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    [ABDT1= Total Copepods (#/m2)]      ( date set 1 ) Column # 3    [ABDT1= Total Mesozooplankton (#/m2)]      ( date set 1 ) Column # 4    [BIOM1= Total Wet Weight (g/m2)]      ( date set 1 ) Column # 5    [BIOM2= Total Dry Weight (g/m2)]      ( date set 1 ) Column # 6     [ DATE-YMD ]       Date Set = 2 Column # 7    [ABDT7= Total Diatoms (#/L)]      ( date set 2 ) Column # 8     [ DATE-YMD ]       Date Set = 3 Column # 9    [ABDT7= Total Dinoflagellates (#/L)]      ( date set 3 ) Column # 10     [ DATE-YMD ]       Date Set = 4 Column # 11    [ABDT7= Total Ciliates (#/L)]      ( date set 4 ) Column # 12     [ DATE-YMD ]       Date Set = 5 Column # 13    [ABDT7= Total Coccolithophores (#/L)]      ( date set 5 ) Column # 14     [ DATE-YMD ]       Date Set = 6 Column # 15    [ABDT7= Total Cryptophyceae (#/L)]      ( date set 6 ) Column # 16     [ DATE-YMD ]       Date Set = 7 Column # 17    [ABDT7= Total Chlorophyceae (#/L)]      ( date set 7 ) Column # 18     [ DATE-YMD ]       Date Set = 8 Column # 19    [ABDT7= Total Chrysophyceae (#/L)]      ( date set 8 ) Column # 20     [ DATE-YMD ]       Date Set = 9 Column # 21    [ABDT7= Total Euglenozoa (#/L)]      ( date set 9 ) Column # 22     [ DATE-YMD ]       Date Set = 10 Column # 23    [TEMP1= Temperature ( C ) from 0-10m]      ( date set 10 ) Column # 24    [PSAL1= Salinity () from 0-10m]      ( date set 10 ) Column # 25     [ DATE-YMD ]       Date Set = 11 Column # 26    [TEMP1= Temperature ( C ) from 75-100m]      ( date set 11 ) Column # 27    [PSAL1= Salinity () from 75-100m]      ( date set 11 ) Column # 28     [ DATE-YMD ]       Date Set = 12 Column # 29    [PSAL1= Salinity () from 0-10m]      ( date set 12 ) Column # 30    [OTHR= Oxygen (ml/l) from 0-10m]      ( date set 12 ) Column # 31    [CHLA= Chlorophyll-a (mg/m3) from 0-10m]      ( date set 12 ) Column # 32    [LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m]      ( date set 12 ) Column # 33    [LOTH1= Phosphate (mmol/m3) from 0-10m]      ( date set 12 ) Column # 34    [LOTH1= Silicate (mmol/m3) from 0-10m]      ( date set 12 ) Column # 35    [LOTH1= Ammonium (mmol/m3) from 0-10m]      ( date set 12 ) Column # 36     [ DATE-YMD ]       Date Set = 13 Column # 37    [PSAL1= Salinity () from 75-100m]      ( date set 13 ) Column # 38    [OTHR= Oxygen (ml/l) from 75-100m]      ( date set 13 ) Column # 39    [CHLA= Chlorophyll-a (mg/m3) from 75-100m]      ( date set 13 ) Column # 40    [LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m]      ( date set 13 ) Column # 41    [LOTH1= Phosphate (mmol/m3) from 75-100m]      ( date set 13 ) Column # 42    [LOTH1= Silicate (mmol/m3) from 75-100m]      ( date set 13 ) Column # 43    [LOTH1= Ammonium (mmol/m3) from 75-100m]      ( date set 13 ) DATA SORTED BY CATEGORY TYPES Total Biomass Category     Column # 4   [ BIOM1= Total Wet Weight (g/m2) ]     Column # 5   [ BIOM2= Total Dry Weight (g/m2) ] Abundance (with zeros) Category     Column # 2   [ ABDT1= Total Copepods (#/m2) ]     Column # 3   [ ABDT1= Total Mesozooplankton (#/m2) ]     Column # 7   [ ABDT7= Total Diatoms (#/L) ]     Column # 9   [ ABDT7= Total Dinoflagellates (#/L) ]     Column # 11   [ ABDT7= Total Ciliates (#/L) ]     Column # 13   [ ABDT7= Total Coccolithophores (#/L) ]     Column # 15   [ ABDT7= Total Cryptophyceae (#/L) ]     Column # 17   [ ABDT7= Total Chlorophyceae (#/L) ]     Column # 19   [ ABDT7= Total Chrysophyceae (#/L) ]     Column # 21   [ ABDT7= Total Euglenozoa (#/L) ] Log10 (logarithmic) Miscellaenous Category     Column # 32   [ LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ]     Column # 33   [ LOTH1= Phosphate (mmol/m3) from 0-10m ]     Column # 34   [ LOTH1= Silicate (mmol/m3) from 0-10m ]     Column # 35   [ LOTH1= Ammonium (mmol/m3) from 0-10m ]     Column # 40   [ LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]     Column # 41   [ LOTH1= Phosphate (mmol/m3) from 75-100m ]     Column # 42   [ LOTH1= Silicate (mmol/m3) from 75-100m ]     Column # 43   [ LOTH1= Ammonium (mmol/m3) from 75-100m ] non-Log10 (linear) Miscellaenous Category     Column # 30   [ OTHR= Oxygen (ml/l) from 0-10m ]     Column # 38   [ OTHR= Oxygen (ml/l) from 75-100m ] Temperatures Category     Column # 23   [ TEMP1= Temperature ( C ) from 0-10m ]     Column # 26   [ TEMP1= Temperature ( C ) from 75-100m ] Salinities Category     Column # 24   [ PSAL1= Salinity () from 0-10m ]     Column # 27   [ PSAL1= Salinity () from 75-100m ]     Column # 29   [ PSAL1= Salinity () from 0-10m ]     Column # 37   [ PSAL1= Salinity () from 75-100m ] Chlorophyll/Pigments Category     Column # 31   [ CHLA= Chlorophyll-a (mg/m3) from 0-10m ]     Column # 39   [ CHLA= Chlorophyll-a (mg/m3) from 75-100m ] DATA SORTED BY GROUPING SETS: Category 1 Group # 1     column # 4     [ BIOM1= Total Wet Weight (g/m2) ] Category 1 Group # 2     column # 5     [ BIOM2= Total Dry Weight (g/m2) ] Category 4 Group # 1     column # 23     [ TEMP1= Temperature ( C ) from 0-10m ]     column # 26     [ TEMP1= Temperature ( C ) from 75-100m ] Category 5 Group # 1     column # 24     [ PSAL1= Salinity () from 0-10m ]     column # 27     [ PSAL1= Salinity () from 75-100m ]     column # 29     [ PSAL1= Salinity () from 0-10m ]     column # 37     [ PSAL1= Salinity () from 75-100m ] Category 8 Group # 1     column # 2     [ ABDT1= Total Copepods (#/m2) ]     column # 3     [ ABDT1= Total Mesozooplankton (#/m2) ] Category 8 Group # 7     column # 7     [ ABDT7= Total Diatoms (#/L) ]     column # 9     [ ABDT7= Total Dinoflagellates (#/L) ]     column # 11     [ ABDT7= Total Ciliates (#/L) ]     column # 13     [ ABDT7= Total Coccolithophores (#/L) ]     column # 15     [ ABDT7= Total Cryptophyceae (#/L) ]     column # 17     [ ABDT7= Total Chlorophyceae (#/L) ]     column # 19     [ ABDT7= Total Chrysophyceae (#/L) ]     column # 21     [ ABDT7= Total Euglenozoa (#/L) ] Category 9 Group # 1     column # 32     [ LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ]     column # 33     [ LOTH1= Phosphate (mmol/m3) from 0-10m ]     column # 34     [ LOTH1= Silicate (mmol/m3) from 0-10m ]     column # 35     [ LOTH1= Ammonium (mmol/m3) from 0-10m ]     column # 40     [ LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]     column # 41     [ LOTH1= Phosphate (mmol/m3) from 75-100m ]     column # 42     [ LOTH1= Silicate (mmol/m3) from 75-100m ]     column # 43     [ LOTH1= Ammonium (mmol/m3) from 75-100m ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 2005 2017 DATES in Column 6 no problems detected 1997 2017 DATES in Column 8 no problems detected 1997 2017 DATES in Column 10 no problems detected 1997 2017 DATES in Column 12 no problems detected 1997 2017 DATES in Column 14 no problems detected 1997 2017 DATES in Column 16 no problems detected 1997 2017 DATES in Column 18 no problems detected 1997 2017 DATES in Column 20 no problems detected 1997 2017 DATES in Column 22 no problems detected 1994 2018 DATES in Column 25 no problems detected 1994 2018 DATES in Column 28 no problems detected 1991 2018 DATES in Column 36 no problems detected 1999 2017   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 2005 2017 1 12 1 31 6 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 8 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 10 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 12 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 14 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 16 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 18 DATE-YMD DATE-YMD yes 1997 2017 01 12 01 31 20 DATE-YMD DATE-YMD yes 1997 2017 02 12 01 31 22 DATE-YMD DATE-YMD yes 1994 2018 1 12 1 31 25 DATE-YMD DATE-YMD yes 1994 2018 1 12 1 31 28 DATE-YMD DATE-YMD yes 1991 2018 1 12 1 31 36 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31 DATA REVIEW SECTION [ Jump back to TOP ] DATA COLUMN Comments "n" Minimum (non-zero) Maximum Values > 0 Values > 1 Column 2 : [ 04_ABDT1= Total Copepods (#/m2) ] no problems detected 344 12155.1064 484070.844 344 ( 100%) 344 ( 100%) Column 3 : [ 05_ABDT1= Total Mesozooplankton (#/m2) ] no problems detected 344 12564.8037 560182.75 344 ( 100%) 344 ( 100%) Column 4 : [ 06_BIOM1= Total Wet Weight (g/m2) ] no problems detected 344 3.34776163 253.648773 344 ( 100%) 344 ( 100%) Column 5 : [ 07_BIOM2= Total Dry Weight (g/m2) ] no problems detected 191 1.88951135 31.4947796 191 ( 100%) 191 ( 100%) Column 7 : [ 08_ABDT7= Total Diatoms (#/L) ] no problems detected 450 1240. 25007544. 450 ( 100%) 450 ( 100%) Column 9 : [ 09_ABDT7= Total Dinoflagellates (#/L) ] no problems detected 450 1840. 503922. 450 ( 100%) 450 ( 100%) Column 11 : [ 10_ABDT7= Total Ciliates (#/L) ] no problems detected 449 160. 60720. 449 ( 100%) 449 ( 100%) Column 13 : [ 11_ABDT7= Total Coccolithophores (#/L) ] no problems detected 446 2212. 1039460. 446 ( 100%) 446 ( 100%) Column 15 : [ 12_ABDT7= Total Cryptophyceae (#/L) ] no problems detected 450 240. 2109729. 450 ( 100%) 450 ( 100%) Column 17 : [ 13_ABDT7= Total Chlorophyceae (#/L) ] no problems detected 433 40. 209688. 433 ( 100%) 433 ( 100%) Column 19 : [ 14_ABDT7= Total Chrysophyceae (#/L) ] no problems detected 434 40. 189355. 434 ( 100%) 434 ( 100%) Column 21 : [ 15_ABDT7= Total Euglenozoa (#/L) ] no problems detected 411 20. 52896. 411 ( 100%) 411 ( 100%) Column 23 : [ 16_TEMP1= Temperature ( C ) from 0-10m ] no problems detected 18624 -1.60000002 16.2000008 18563 ( 99%) 18537 ( 99%) Column 24 : [ 17_PSAL1= Salinity () from 0-10m ] no problems detected 18467 14.3999996 30.6000004 18467 ( 100%) 18467 ( 100%) Column 26 : [ 18_TEMP1= Temperature ( C ) from 75-100m ] no problems detected 17021 -1.5 4.5 15233 ( 89%) 8560 ( 50%) Column 27 : [ 19_PSAL1= Salinity () from 75-100m ] no problems detected 17212 29.7999992 33.7000008 17212 ( 100%) 17212 ( 100%) Column 29 : [ 20_PSAL1= Salinity () from 0-10m ] no problems detected 807 19.2299995 30.9200001 807 ( 100%) 807 ( 100%) Column 30 : [ 21_OTHR= Oxygen (ml/l) from 0-10m ] no problems detected 329 5.73000002 9.94999981 329 ( 100%) 329 ( 100%) Column 31 : [ 22_CHLA= Chlorophyll-a (mg/m3) from 0-10m ] no problems detected 2171 0.0450000018 79.2350006 2171 ( 100%) 1572 ( 72%) Column 32 : [ 23_LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ] no problems detected 1697 0.00499999989 23.6800003 1690 ( 99%) 1396 ( 82%) Column 33 : [ 24_LOTH1= Phosphate (mmol/m3) from 0-10m ] no problems detected 1688 0.00300000003 1.61000001 1641 ( 97%) 368 ( 21%) Column 34 : [ 25_LOTH1= Silicate (mmol/m3) from 0-10m ] no problems detected 1697 0.00300000003 35.4570007 1681 ( 99%) 1591 ( 93%) Column 35 : [ 26_LOTH1= Ammonium (mmol/m3) from 0-10m ] no problems detected 262 0.00999999978 1.69299996 262 ( 100%) 15 ( 5%) Column 37 : [ 27_PSAL1= Salinity () from 75-100m ] no problems detected 424 31.2999992 33.7299995 424 ( 100%) 424 ( 100%) Column 38 : [ 28_OTHR= Oxygen (ml/l) from 75-100m ] no problems detected 106 3.4000001 7.38000011 106 ( 100%) 106 ( 100%) Column 39 : [ 29_CHLA= Chlorophyll-a (mg/m3) from 75-100m ] no problems detected 447 0.00999999978 2.1400001 445 ( 99%) 11 ( 2%) Column 40 : [ 30_LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ] no problems detected 449 7.72300005 24.2000008 449 ( 100%) 449 ( 100%) Column 41 : [ 31_LOTH1= Phosphate (mmol/m3) from 75-100m ] no problems detected 449 0.88499999 2.76699996 449 ( 100%) 442 ( 98%) Column 42 : [ 32_LOTH1= Silicate (mmol/m3) from 75-100m ] no problems detected 449 5.78000021 45.7299995 449 ( 100%) 449 ( 100%) Column 43 : [ 33_LOTH1= Ammonium (mmol/m3) from 75-100m ] no problems detected 98 0.00499999989 2.15499997 92 ( 93%) 3 ( 3%) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".