updateLabActMediaTables: Update labNameActivityTable & activityMediaNameTable

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

Update labNameActivityTable & activityMediaNameTable

Description

This function identifies new LaboratoryName/ActivityTypeCode combinations & ActivityMediaName/ActivityMediaSubdivisionName combinations in WQP data for which an IR_FLAG has not yet been defined and appends them into the translation workbook for review.

Usage

updateLabActMediaTables(
  data,
  translation_wb,
  labNameActivityTable_sheetname = "labNameActivityTable",
  labNameActivityTable_startCol = 1,
  labNameActivityTable_startRow = 1,
  activityMediaNameTable_sheetname = "activityMediaNameTable",
  activityMediaNameTable_startCol = 1,
  activityMediaNameTable_startRow = 1
)

Arguments

data	A WQP results (must include activity, merged objects OK) R-object
translation_wb	Full path and filename for IR translation workbook (.xlsx).
labNameActivityTable_sheetname	Name of sheet in workbook holding lab name / activity table. Defaults to "labNameActivityTable".
labNameActivityTable_startCol	Col to start writing the labNameActivityTable excel sheet to (to the right of all formula based columns). Defaults to 3.
labNameActivityTable_startRow	Row to start reading the labNameActivityTable excel sheet from (in case headers have been added). Defaults to 1.
activityMediaNameTable_sheetname	Name of sheet in workbook holding activity / media/submedia name table. Defaults to "activityMediaNameTable".
activityMediaNameTable_startCol	Col to start writing the activityMediaNameTable excel sheet to (to the right of all formula based columns). Defaults to 3.
activityMediaNameTable_startRow	Row to start reading the activityMediaNameTable excel sheet from (in case headers have been added). 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.