contin_export: Export continuous result information from to template xlsx...

In DEQrmichie/odeqcdr: ODEQ Continuous Data Review

Export continuous result information from to template xlsx file.

Description

Export monitoring results into the most recent version of Oregon DEQ's continuous data submission template xlsx file format. This function will export a list with each element holding a data frame of the information for each spreadsheet in the template. The cell colors and quality control elements from the actual template are not included in the output xlsx.

Usage

contin_export(
  file,
  org,
  projects,
  mloc,
  deployment,
  results,
  prepost,
  audits,
  sumstats = NULL,
  equipment = NULL,
  ver = 2
)

Arguments

file	The path and file name to the output xlsx file.
org	data frame holding Organization Details
projects	data frame with Projects
mloc	data frame holding Monitoring_Locations
deployment	data frame holding Deployment
results	data frame holding Results
prepost	data frame holding PrePost
audits	data frame holding Audit_Data
sumstats	Optional data frame holding the AWQMS summary statistics generated using sumstats. Default is NULL.
equipment	Optional data frame holding equipment Info. Only used for version 3 template. Default is NULL.
ver	numeric version of the template. Valid values are ver=2 (the default) or ver=3.

Details

This function relies upon the openxlsx package.

See Also

openxlsx, contin_export_v2, contin_export_v3

DEQrmichie/odeqcdr documentation built on Feb. 15, 2025, 10:01 a.m.