flip to first tab, point 4 suggests there is some export functionality I cannot see (a VBA script?)
cell 11 a NOTE: When submitting updated metadata or re-using templates please highlight fields with modified contents in yellow
and use glitter pen???
personnell tab OK
instrumentation, variable measured is free text. ok but for eg “max temp”, “temperature maxima”, “maximum temperature (c)” “maximum temperature in 24 hours after 9am local time in degrees” etc
too wide, last column was off my wide screen! noticed wasted real estate in column A
tabular data “– Paste or enter your data values into the ‘Values’ section (white cells), starting with the indicated cell”
this is an invitation for clerical error! Too many “copy-and-paste” actions will inevtably introduce errors
I do like the extra metadata Column Name:
– Description:
– Units:
– Data type:
– Variable type:
– Number type:
– Precision:
– Code values:
– Calculations:
– QC: Minimum Valid:
– QC: Minimum Expected:
– QC: Maximum Expected:
– QC: Maximum Valid:
– QC: Custom:
– Fill in missing values in the table with NaN (not a number), including text fields, and do not skip columns
but what about missing values imbued with other meanings (NA = not observed, censored etc)?
ask users to format digit rounding in Excel?? oh no
old excel users may still be restricted to 65,536 rows by 256 columns.
