Skip to contents

create_season_field_sheets() creates an excel workbook and appends multiple formatted field worksheets for sample event IDs in a given sample plan.

Usage

create_season_field_sheets(con, season, field_sheet_filepath)

Arguments

con

A valid connection to the database

season

format YYYY

field_sheet_filepath

The filepath and name desired for the workbook containing field sheets.

Value

A Workbook object from createWorkbook with a worksheet for each sampling event in the sample plan.

Details

create_season_field_sheets() creates field sheets for all unique sample event IDs in a given season. For a given season, the function will gather all sampling events for that year up to September 30th and all sampling events from the previous year after October 1st.

Examples