import_cdsr_excel: import_cdsr_excel
In daniel-r-germony/dstCSDR: Tools for Cost and Software Data Reporting (CSDR) Data

Description Usage Arguments Details Value Author(s)

Import a CSDR CDSR (DD Form 1921) from Excel into a Tibble

1	import_cdsr_excel(path)

path

Required. Path to the xls/xlsx file which contains the CSDR 1921. Note the Excel file must have the CSDR 1921 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).

Takes a CSDR CDSR (DD Form 1921) Excel worksheet and imports it to three a tibbles.

Returns a list of three tibbles. The first tibble includes all of the submission's metadata in two columns. The second tibble includes each WBS element as a row and the repoted data as columns. The third tibble includes the summary reporting elements (the rows at the bottom of a CDSR with summary cost data and no WBS number).

Daniel Germony daniel.r.germony.civ@mail.mil

daniel-r-germony/dstCSDR documentation built on Jan. 4, 2020, 12:16 a.m.