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) ] 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 ] 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 ] 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.0000000 24970.0000 511 ( 100 %) 511 ( 100 %) Column 3 : [ 05_ABND1= Total Copepods from 1985-present (#/m3) ] no problems detected 382 12.0000000 24970.0000 382 ( 100 %) 382 ( 100 %) Column 5 : [ 06_ABND5= Total Diatoms (#/L) ] no problems detected 427 80.0000000 7072533.00 427 ( 100 %) 427 ( 100 %) Column 6 : [ 07_ABND5= Total Dinoflagellates (#/L) ] no problems detected 408 40.0000000 458635.000 408 ( 100 %) 408 ( 100 %) Column 7 : [ 08_ABND5= Total Coccolithophores (#/L) ] no problems detected 96 40.0000000 266450.000 87 ( 90 %) 87 ( 90 %) Column 8 : [ 09_ABND5= Total Flagellates (#/L) ] no problems detected 96 83184.0000 4594378.00 96 ( 100 %) 96 ( 100 %) Column 10 : [ 10_LOTH3= Average NH4 (uM) from 0-15 m ] no problems detected 1022 2.00000009E-03 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.39000010 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 7.98622966E-02 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.0000000 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".