Closed cmrn-rhi closed 1 year ago
Excel Template, Reference Guides, Curation SOP
x = 5 = removed a field y = 3 = no picklist items added z = 2 = did not change existing "definitions/formats/examples" but there were numerous functional changes to the spreadsheet
AMR_phenotype
<antibiotic>_phenotype
columnsHad to remove the validation code because we couldn't get it to work while accepting all of the following formats in a single cell yyyy-mm-dd
, yyyy-mm
, and yyyy
. Could not format it as a "number" as it would turn "yyyy-mm-dd" and "yyyy-mm" into a numeric code. Settled on the excel "text" format which will result in users getting a notification that "yyyy" values will have an '
in front of it (though it won't appear in the cell view).
New Wiki sections added to support this release:
Template Updates:
.xslx
to.xslm
to allow for VBA macro coding (e.g., additional validation functionality, multiselect).taxonomic_identification_process
column of theStrain and Isolate Information
tab.Added validation code that forces users to input date into date columns, suggesting "yyyy-mm-dd" and converting to this format from "yyyy/mm/dd" (unable to get succession conversion from other valid excel date formats).Troubleshooting
Reference Guide
Field Reference Guide
.Specification Changes:
environmental_site
weather_type
animal_or_plant_population
environmental_material
anatomical_material
body_product
anatomical_part
food_product
food_product_properties
animal_source_of_food
food_packaging
purpose_of_sequencing
experimental_intervention
AMR_measurement