Additions/Updates:
[ casts.csv>castdb.csv ] will generate an Access-ready cast-table importable csv. The cst_cnt should increment properly - it will use a database you select to set the beginning cst_cnt OR you can key-enter your desired start cst_cnt (for updates). Report Order & Order Occupied are user-selectable.

[ sta.csvs>bottledb.csv ] will generate an Access-ready bottle-table importable csv. The cst_cnt & btl_cnt should increment - it will use a database you select to set the beginning btl_cnt & cst_cnt OR you can key-enter your desired starting btl_cnt and/or cst_cnt (for updates). Please note that each text field is treated independently so you can enter a starting btl_cnt without a cst_cnt or vice-versa BUT the blank cnt will be set by the user-selected database.
Report Order & Order Occupied are user-selectable as well as 'shallow to deep' or 'deep to shallow' depth order.

The CTDatDepth PST & UTC in the casts.csv was incorrect when generated by CESL's csv rebuilding module (regenerates the casts.csv & all the sta.csvs automatically). This module was developed to batch recreate all the csvs so new columns could be added to older cruises. Unfortunately, the ATDepth PST date & time was UTC and AtDepth UTC was UTC+8. CESL was fixed, new casts.csvs generated for 1104, 1108, 1110, 1202, 1203. The AtDepthDate_PST & AtDepthDate_UTC columns were cut & pasted into the working casts.csvs so point-checking data codes & quality codes would remain intact. New IEHs & Data Reports for all published cruises should be updated as well as database dates and times.

CESL1301.exe will generate sta.csvs with columns to accommodate oxygens in umoles/kg from bottles, primary & secondary CTD oxygen sensors. These columns will be updated by DECODR.

CTD asc files contain CTD primary & secondary (when installed) oxygen measurements in umoles/kg. These data were not included in the CTD-bottle data merged csvs. With the mandate to include oxygen in umoles/kg as part of our dataset, these columns are now included in the ctd.csvs. Eight additional columns have been added: Ox1uM, Ox1uM_CruiseCorr, Ox1uM_StaCorr, Ox2uM, Ox2uM_CruiseCorr, Ox2uM_StaCorr, OxuMAve_StaCorr, plus the OxBuM column for the bottle value.

Reporting of bottle oxygens in umoles/kg should begin on CalCOFI 1301SH (Jan 2013). With the addition of bottle oxygens in umoles/kg, bottle-corrected CTD oxygens in umoles/kg will populate the ctd.csvs. These data will be archive with final data.

CalCOFI started running oxygens with the ODF auto-titrator in Oct 2003 so it may be possible to generate umoles/kg values from archived runs as time permits (which it rarely does). Further investigation of this possibility is necessary ie whether older cruise bottle oxygens can be reprocessed to umoles/kg easily.

Tweaked the latest DECODR Database module (Database tab) - users need to run the [db Connection] 1st to get the bottle and cast counts when using casts.csv or sta.csvs to create a database-friendly import file. DECODR was hardwired to a specific database file. Now it prompts users to select the database to use - click [db Connection], select the database (Q:\database is the default path), exit the form, then run the [Sta.csvs > db csv] or [Casts.csv > db] csv modules to generate properly indexed bottle & cast csvs to import.