import_fchr_excel: import_fchr_excel
In daniel-r-germony/dstCSDR: Tools for Cost and Software Data Reporting (CSDR) Data
Description
Usage
Arguments
Details
Value
Author(s)
View source: R/import_fchr_excel.R
Description
Import a CSDR FCHR (DD Form 1921-1) from Excel into a Tibble
Usage
1
import_fchr_excel(path)
Arguments
path
Required. Path to the xls/xlsx file which contains the CSDR
FCHR 1921-1. Note the Excel file must have FCHR data on the first
worksheet (remove any coversheets prior to using this script) and cannot
have columns or rows moved/changed from the standard from (i.e., the
script assumes a cPet produced/compliant file is provided).
Details
Takes a CSDR Functional Cost-Hour Report (FCHR) (DD Form 1921-1) Excel
worksheet and imports it to a set of tibbles.
Value
Returns a list of two tibbles. The first tibble includes all of the
submission's metadata in two columns. The second tibble includes each
worksheet from the FCHR combined into one long table where each row
is a Functional Data Element and the columns include the cost & hours
data. Remarks by WBS and a few other columns are included so that the
FCHR data is a proper rectangular table.
Author(s)
Daniel Germony daniel.r.germony.civ@mail.mil
daniel-r-germony/dstCSDR documentation built on Jan. 4, 2020, 12:16 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value Author(s)
View source: R/import_fchr_excel.R
Description
Import a CSDR FCHR (DD Form 1921-1) from Excel into a Tibble
Usage
1 | import_fchr_excel(path)
|
Arguments
path |
Required. Path to the xls/xlsx file which contains the CSDR FCHR 1921-1. Note the Excel file must have FCHR data on the first worksheet (remove any coversheets prior to using this script) and cannot have columns or rows moved/changed from the standard from (i.e., the script assumes a cPet produced/compliant file is provided). |
Details
Takes a CSDR Functional Cost-Hour Report (FCHR) (DD Form 1921-1) Excel worksheet and imports it to a set of tibbles.
Value
Returns a list of two tibbles. The first tibble includes all of the submission's metadata in two columns. The second tibble includes each worksheet from the FCHR combined into one long table where each row is a Functional Data Element and the columns include the cost & hours data. Remarks by WBS and a few other columns are included so that the FCHR data is a proper rectangular table.
Author(s)
Daniel Germony daniel.r.germony.civ@mail.mil
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.