updateParamTrans: Update paramTransTable, paramFractionGroup, & WQPParamCASID...

In ut-ir-tools/irTools: R-tools for generating Utah's Integrated Report on water quality

Update paramTransTable, paramFractionGroup, & WQPParamCASID tables in translation workbook

Description

This function identifies parameter/fraction/unit/method combinations in WQP data for which an IR translation has not yet been defined and appends them to the translation table for review.

Usage

updateParamTrans(
  data,
  translation_wb,
  standards_wb,
  paramTransTable_sheetname = "paramTransTable",
  paramTransTable_startRow = 1,
  paramTransTable_startCol = 1,
  CASLookup_sheetname = "CASLookup",
  CASLookup_startRow = 2,
  CASLookup_startCol = 1,
  paramFractionGroup_sheetname = "paramFractionGroup",
  paramFractionGroup_startRow = 2,
  paramFractionGroup_startCol = 2
)

Arguments

data	A WQP results (merged or narrow result) R-object
translation_wb	Full path and filename for IR translation workbook
standards_wb	Full path and filename for IR standards workbook
paramTransTable_sheetname	Name of sheet in workbook holding parameter translation table. Defaults to "paramTransTable".
paramTransTable_startRow	Row to start reading the paramTransTable excel sheet from (in case additional headers have been added). Defaults to 1.
paramTransTable_startCol	Col to start writing the paramTransTable excel sheet to (to the right of all formula based columns). Defaults to 1.
CASLookup_sheetname	Name of sheet in workbook holding CAS lookup table from WQP. Defaults to "CASLookup".
CASLookup_startRow	Row to start reading the CASLookup excel sheet from (in case additional headers have been added). Defaults to 2.
CASLookup_startCol	Col to start writing the CASLookup excel sheet to (to the right of all formula based columns). Defaults to 1.
paramFractionGroup_sheetname	Name of sheet in workbook holding the WQP fraction names. Defaults to "paramFractionGroup".
paramFractionGroup_startRow	Row to start reading the paramFractionGroup excel sheet from (in case additional headers have been added). Defaults to 2.
paramFractionGroup_startCol	Col to start writing the paramFractionGroup excel sheet to (to the right of all formula based columns, note col w/ header 'spacer' in table). Defaults to 2.

Value

Appends any new parameter/fraction/unit combinations in WQP data to translation_wb. This updates the input translation_wb with those new rows with system date in the "DateAdded" column.

ut-ir-tools/irTools documentation built on Jan. 19, 2024, 6:55 p.m.