updateCommentTable: Identify New WQP comment combinations and append them into IR...

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

Identify New WQP comment combinations and append them into IR Parameter Translation Workbook for review (sheet name activityCommentTable)

Description

This function identifies new ResultLaboratoryCommentCode/ResultLaboratoryCommentText/ActivityCommentText/ResultCommentText combinations in WQP data for which an IR_FLAG has not yet been defined and appends them into the translation workbook for review.

Usage

updateCommentTable(
  data,
  translation_wb,
  sheetname = "activityCommentTable",
  startRow = 1,
  startCol = 1
)

Arguments

data	A WQP results (must include activity, merged objects OK) R-object or the full path and filename to a WQP result file (.csv). If input is a path/file name, datatype must be specified as "filepath".
translation_wb	Full path and filename for IR translation workbook (.xlsx).
sheetname	Name of sheet in workbook holding comment table. Defaults to "activityCommentTable".
startRow	Row to start reading the activityCommentTable excel sheet from (in case headers have been added). Defaults to 1.
startCol	Col to start writing the activityCommentTable excel sheet to (to the right of all formula based columns). Defaults to 1.

Value

Appends any new combinations in WQP data to translation_wb for review. 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.