Create Field Sheet
create_field_sheet.Rd
create_field_sheet()
is called within create_season_field_sheets()
and appends a worksheet to an existing excel workbook
containing a formatted field sheet to be used by crew collecting genetic samples.
Usage
create_field_sheet(
wb,
field_sheet_sample_plan,
sample_event_number,
first_sample_date,
sample_location,
sample_location_code,
fl_summary
)
Arguments
- wb
A Workbook object from
createWorkbook
- field_sheet_sample_plan
A dataframe containing the content of the field sheet, use the
field_sheet_sample_plan
output fromget_field_sheet_event_plan
. Noteget_field_sheet_event_plan
also returns the other arguments required by this function.The following columns must contain data:
Bin The sampling bin identifier A-E
Bin FL Range (mm) The min to max fork length range of the sampling bin
Sample # A number denoting the order the sample was taken, 1 to the total number of planned samples with in the sampling bin
Sample ID
{sample_location_code}{YY}_{sample_event_number}_{sample_bin}_{sample_number}
(e.g., "BTC22_3_A_1")
The remaining columns ("Date", "Time", "FL (mm)", "Field Run ID", "Fin Clip (Y/N)", "Comments") will be left empty and filled out by hand in the field
- sample_event_number
The non-unique sampling event number, enumerated from 1 at the start of each monitoring season for each sampling location
- first_sample_date
A date object YYYY-MM-DD representing the first day of sampling of a 2 day sampling event
- sample_location
The sampling location name (e.g., "Battle Creek")
- sample_location_code
The sampling location short code (e.g., "BTC")
- fl_summary
a summary of the fork length bins used for the sampling location with min and max fork lengths.
Value
A Workbook object from createWorkbook
with the new worksheet
See also
Other field sheet helpers:
create_season_field_sheets()
,
get_field_sheet_event_plan()
,
process_field_sheet_samples()
,
update_field_sheet_samples()