contin_volmon_import: Import continuous information from volmon data template.

In DEQrmichie/odeqcdr: ODEQ Continuous Data Review

Import continuous information from volmon data template.

Description

This functions uses the volmon data template as an input and returns a list with each element that matches the output of contin_import. This function does the same thing as contin_import but uses the different template.

Usage

contin_volmon_import(
  file,
  project = "ODEQVolMonWQProgram",
  timezone = "PDT",
  append_ordeq = TRUE
)

Arguments

file	The path and file name to template xlsx file.
project	Optional variable identifying project. ODEQ volmon's program (ODEQVolMonWQProgram) is the default
timezone	Optional variable setting time zone. Defaults to "PDT"
append_ordeq	Optional boolean to append "-ORDEQ" to monitoring locations. Default is TRUE.

Details

This function will read the template and return a list with each list element holding a dataframe of the information for each spreadsheet. Any rows with all NAs are removed.

The function returns a named list holding each worksheet from the xlsx. The name of each list element is the same as the xlsx:

Organization_Details Projects Monitoring_Locations Deployment Results PrePost Audit_Data

Column names are made into syntactically valid names acceptable by R.

This function relies heavily upon the readxl package.

Value

list of each continuous template data

See Also

read_excel, contin_import

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