COPEPODITE Incoming Data Review Fatal Format Issues:   none HEADER REVIEW SECTION [ Jump back to TOP ] SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS Column # 1     [ DATE-YMD ]       Date Set = 1 Column # 2    [ABND1= Total Copepods (#/m3)]      ( date set 1 ) Column # 3    [ABND1= Total Copepods from 1985-present (#/m3)]      ( date set 1 ) Column # 4     [ DATE-MDY ]       Date Set = 2 Column # 5    [ABND5= Total Diatoms (#/L)]      ( date set 2 ) Column # 6    [ABND5= Total Dinoflagellates (#/L)]      ( date set 2 ) Column # 7    [ABND5= Total Coccolithophores (#/L)]      ( date set 2 ) Column # 8    [ABND5= Total Flagellates (#/L)]      ( date set 2 ) Column # 9     [ DATE-DMY ]       Date Set = 3 Column # 10    [LOTH3= Average NH4 (uM) from 0-15 m]      ( date set 3 ) Column # 11    [LOTH3= Average NO2 (uM) from 0-15 m]      ( date set 3 ) Column # 12    [LOTH3= Average NO3 (uM) from 0-15 m]      ( date set 3 ) Column # 13    [LOTH3= Average PO4 (uM) from 0-15 m]      ( date set 3 ) Column # 14    [LOTH3= Average SiO4 (uM) from 0-15 m]      ( date set 3 ) Column # 15    [OTHR= Average Oxygen (uM) from 0-15 m]      ( date set 3 ) Column # 16    [CHLA= Average Chlorophyll (ug/L) from 0-15 m]      ( date set 3 ) Column # 17     [ DATE-DMY ]       Date Set = 4 Column # 18    [TEMP1= Average Temperature ( C ) from 0 - 15 m]      ( date set 4 ) Column # 19    [TEMP1= Temperature ( C ) at the surface]      ( date set 4 ) Column # 20    [PSAL1= Average Salinity () from 0 - 15 m]      ( date set 4 ) Column # 21    [PSAL1= Salinity () at the surface]      ( date set 4 ) DATA SORTED BY CATEGORY TYPES Total/non-zero Abundance Category     Column # 2   [ ABND1= Total Copepods (#/m3) ]     Column # 3   [ ABND1= Total Copepods from 1985-present (#/m3) ]     Column # 5   [ ABND5= Total Diatoms (#/L) ]     Column # 6   [ ABND5= Total Dinoflagellates (#/L) ]     Column # 7   [ ABND5= Total Coccolithophores (#/L) ]     Column # 8   [ ABND5= Total Flagellates (#/L) ] Log10 (logarithmic) Miscellaenous Category     Column # 10   [ LOTH3= Average NH4 (uM) from 0-15 m ]     Column # 11   [ LOTH3= Average NO2 (uM) from 0-15 m ]     Column # 12   [ LOTH3= Average NO3 (uM) from 0-15 m ]     Column # 13   [ LOTH3= Average PO4 (uM) from 0-15 m ]     Column # 14   [ LOTH3= Average SiO4 (uM) from 0-15 m ] non-Log10 (linear) Miscellaenous Category     Column # 15   [ OTHR= Average Oxygen (uM) from 0-15 m ] Temperatures Category     Column # 18   [ TEMP1= Average Temperature ( C ) from 0 - 15 m ]     Column # 19   [ TEMP1= Temperature ( C ) at the surface ] Salinities Category     Column # 20   [ PSAL1= Average Salinity () from 0 - 15 m ]     Column # 21   [ PSAL1= Salinity () at the surface ] Chlorophyll/Pigments Category     Column # 16   [ CHLA= Average Chlorophyll (ug/L) from 0-15 m ] DATA SORTED BY GROUPING SETS: Category 2 Group # 1     column # 2     [ ABND1= Total Copepods (#/m3) ]     column # 3     [ ABND1= Total Copepods from 1985-present (#/m3) ] Category 2 Group # 5     column # 5     [ ABND5= Total Diatoms (#/L) ]     column # 6     [ ABND5= Total Dinoflagellates (#/L) ]     column # 7     [ ABND5= Total Coccolithophores (#/L) ]     column # 8     [ ABND5= Total Flagellates (#/L) ] Category 4 Group # 1     column # 18     [ TEMP1= Average Temperature ( C ) from 0 - 15 m ]     column # 19     [ TEMP1= Temperature ( C ) at the surface ] Category 5 Group # 1     column # 20     [ PSAL1= Average Salinity () from 0 - 15 m ]     column # 21     [ PSAL1= Salinity () at the surface ] Category 9 Group # 3     column # 10     [ LOTH3= Average NH4 (uM) from 0-15 m ]     column # 11     [ LOTH3= Average NO2 (uM) from 0-15 m ]     column # 12     [ LOTH3= Average NO3 (uM) from 0-15 m ]     column # 13     [ LOTH3= Average PO4 (uM) from 0-15 m ]     column # 14     [ LOTH3= Average SiO4 (uM) from 0-15 m ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 1970 2017 DATES in Column 4 no problems detected 1986 2017 DATES in Column 9 no problems detected 1997 2012 DATES in Column 17 no problems detected 1986 2012   Date Column Labeling Date Value-Set1 Date Value-Set2 Date Value-Set3 DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max 1 DATE-YMD DATE-YMD yes 1970 2017 01 12 15 15 4 DATE-MDY DATE-MDY yes 1 12 1 31 1986 2017 9 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1997 2012 17 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1986 2012 DATA REVIEW SECTION [ Jump back to TOP ] DATA COLUMN Comments "n" Minimum (non-zero) Maximum Values > 0 Values > 1 Column 2 : [ 04_ABND1= Total Copepods (#/m3) ] no problems detected 511 12. 24970. 511 ( 100%) 511 ( 100%) Column 3 : [ 05_ABND1= Total Copepods from 1985-present (#/m3) ] no problems detected 382 12. 24970. 382 ( 100%) 382 ( 100%) Column 5 : [ 06_ABND5= Total Diatoms (#/L) ] no problems detected 427 80. 7072533. 427 ( 100%) 427 ( 100%) Column 6 : [ 07_ABND5= Total Dinoflagellates (#/L) ] no problems detected 408 40. 458635. 408 ( 100%) 408 ( 100%) Column 7 : [ 08_ABND5= Total Coccolithophores (#/L) ] no problems detected 96 40. 266450. 87 ( 90%) 87 ( 90%) Column 8 : [ 09_ABND5= Total Flagellates (#/L) ] no problems detected 96 83184. 4594378. 96 ( 100%) 96 ( 100%) Column 10 : [ 10_LOTH3= Average NH4 (uM) from 0-15 m ] no problems detected 1022 0.00200000009 9.31000042 1019 ( 99%) 436 ( 42%) Column 11 : [ 11_LOTH3= Average NO2 (uM) from 0-15 m ] no problems detected 1021 9.99999975E-05 3.3900001 1011 ( 99%) 50 ( 4%) Column 12 : [ 12_LOTH3= Average NO3 (uM) from 0-15 m ] no problems detected 1021 -2.77555988E-17 28.1895008 1018 ( 99%) 402 ( 39%) Column 13 : [ 13_LOTH3= Average PO4 (uM) from 0-15 m ] no problems detected 1006 9.99999975E-05 1.57000005 1004 ( 99%) 3 ( 0%) Column 14 : [ 14_LOTH3= Average SiO4 (uM) from 0-15 m ] no problems detected 1008 9.99999975E-05 31.7021008 1007 ( 99%) 803 ( 79%) Column 15 : [ 15_OTHR= Average Oxygen (uM) from 0-15 m ] no problems detected 962 113.393219 413.394165 962 ( 100%) 962 ( 100%) Column 16 : [ 16_CHLA= Average Chlorophyll (ug/L) from 0-15 m ] no problems detected 1024 0.0798622966 6.52900696 1024 ( 100%) 298 ( 29%) Column 18 : [ 17_TEMP1= Average Temperature ( C ) from 0 - 15 m ] no problems detected 2491 4.78499985 28.2509995 2491 ( 100%) 2491 ( 100%) Column 19 : [ 18_TEMP1= Temperature ( C ) at the surface ] no problems detected 565 5.59100008 28.2509995 565 ( 100%) 565 ( 100%) Column 20 : [ 19_PSAL1= Average Salinity () from 0 - 15 m ] no problems detected 2477 21.6550007 39. 2477 ( 100%) 2477 ( 100%) Column 21 : [ 20_PSAL1= Salinity () at the surface ] no problems detected 565 21.6550007 38.4259987 564 ( 99%) 564 ( 99%) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".