updateDetCondLimTables: Update detection condition and limit type tables

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

Update detection condition and limit type tables

Description

This function identifies new ResultDetectionConditionText & DetectionQuantitationLimitTypeName values in WQP data for which are not in IR translation tables and appends them into the translation workbook for review. New ResultDetectionConditionText & DetectionQuantitationLimitTypeName values generated by this function are derived from those in detquantlim that match (via merge) records in results input (this allows subsetting of these lists by other previously generated data screens if desired).

Usage

updateDetCondLimTables(
  results,
  detquantlim,
  translation_wb,
  detConditionTable_sheetname = "detConditionTable",
  detConditionTable_startRow = 2,
  detConditionTable_startCol = 1,
  detLimitTypeTable_sheetname = "detLimitTypeTable",
  detLimitTypeTable_startRow = 2,
  detLimitTypeTable_startCol = 1
)

Arguments

results	A WQP results (must include narrow result, merged, wide objects OK) R-object name.
detquantlim	A WQP detection/quantitation limit file R-object. Should be matching complement to WQP results input. New values derived from those that successfully merge to results input.
translation_wb	Full path and filename for IR translation workbook (.xlsx).
detConditionTable_sheetname	Name of sheet in workbook holding result detection condition names table. Defaults to "detConditionTable".
detConditionTable_startRow	Row to start reading the detConditionTable excel sheet from (in case headers have been added). Defaults to 2.
detConditionTable_startCol	Col to start writing the detConditionTable excel sheet to (to the right of all formula based columns). Defaults to 1.
detLimitTypeTable_sheetname	Name of sheet in workbook holding detection limit type names and ranked prioritizations table. Defaults to "detLimitTypeTable".
detLimitTypeTable_startRow	Row to start reading the detLimitTypeTable excel sheet from (in case headers have been added). Defaults to 2.
detLimitTypeTable_startCol	Col to start writing the detLimitTypeTable excel sheet to (to the right of all formula based columns). Defaults to 1.

Value

Appends any new values in WQP data to translation_wb for review. This updates the input translation_wb with those new rows.

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