COPEPODITE Incoming Data Review
Fatal Format Issues:   none

    Mild Data Warnings (non-numeric values):   4    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.



HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2    [ABND1= Total Phytoplankton (#/l)]      ( date set 1 )
    Column # 3    [ABND1= Total Diatoms (#/l)]      ( date set 1 )
    Column # 4    [ABND1= Total Dinoflagellates (#/l)]      ( date set 1 )
    Column # 5    [OTHR5= Relative Diatoms (% of total)]      ( date set 1 )
    Column # 6    [OTHR5= Relative Dinoflagellates (% of total)]      ( date set 1 )

    Column # 7     [ DATE-DMY ]       Date Set = 2
    Column # 8    [ABDT4= Mnemiopsis large >1 cm (#/m3)]      ( date set 2 )
    Column # 9    [ABDT4= Mnemiopsis small <1 cm (#/m3)]      ( date set 2 )

    Column # 10     [ DATE-DMY ]       Date Set = 3
    Column # 11    [CHLA1= Surface Chlorophyll (ug/l)]      ( date set 3 )
    Column # 12    [CHLA1= Surface Phaeophytin (ug/l)]      ( date set 3 )
    Column # 13    [CHLA1= Bottom Chlorophyll (ug/l)]      ( date set 3 )
    Column # 14    [CHLA1= Bottom Phaeophytin (ug/l)]      ( date set 3 )
    Column # 15    [CHLA1= Surface Chlorophyll <20 um (ug/l)]      ( date set 3 )
    Column # 16    [CHLA1= Surface Phaeophytin <20 um (ug/l)]      ( date set 3 )
    Column # 17    [CHLA1= Bottom Chlorophyll <20um (ug/l)]      ( date set 3 )
    Column # 18    [CHLA1= Bottom Phaeophytin <20um (ug/l)]      ( date set 3 )

    Column # 19     [ DATE-DMY ]       Date Set = 4
    Column # 20    [TEMP1= Surface Temperature ( C )]      ( date set 4 )
    Column # 21    [TEMP1= Bottom Temperature ( C )]      ( date set 4 )

    Column # 22     [ DATE-DMY ]       Date Set = 5
    Column # 23    [PSAL= Surface Salinity ()]      ( date set 5 )
    Column # 24    [PSAL= Bottom Salinity ()]      ( date set 5 )

    Column # 25     [ DATE-DMY ]       Date Set = 6
    Column # 26    [LOTH1= Surface NH4 (uM)]      ( date set 6 )
    Column # 27    [LOTH1= Surface DIP (uM)]      ( date set 6 )
    Column # 28    [LOTH1= Surface NO3NO2 (uM)]      ( date set 6 )
    Column # 29    [LOTH1= Surface NO3 (uM)]      ( date set 6 )
    Column # 30    [LOTH1= Surface NO2 (uM)]      ( date set 6 )
    Column # 31    [LOTH1= Surface DIN (uM)]      ( date set 6 )

    Column # 32     [ DATE-DMY ]       Date Set = 7
    Column # 33    [LOTH1= Surface Silicate (uM)]      ( date set 7 )

    Column # 34     [ DATE-DMY ]       Date Set = 8
    Column # 35    [LOTH1= Bottom NH4 (uM)]      ( date set 8 )
    Column # 36    [LOTH1= Bottom DIP (uM)]      ( date set 8 )
    Column # 37    [LOTH1= Bottom NO3NO2 (uM)]      ( date set 8 )
    Column # 38    [LOTH1= Bottom NO3 (uM)]      ( date set 8 )
    Column # 39    [LOTH1= Bottom NO2 (uM)]      ( date set 8 )
    Column # 40    [LOTH1= Bottom DIN (uM)]      ( date set 8 )

    Column # 41     [ DATE-DMY ]       Date Set = 9
    Column # 42    [LOTH1= Bottom Silicate (uM)]      ( date set 9 )

    Column # 43     [ DATE-DMY ]       Date Set = 10
    Column # 44    [OTHR= Secchi Depth (M)]      ( date set 10 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Phytoplankton (#/l) ]
        Column # 3   [ ABND1= Total Diatoms (#/l) ]
        Column # 4   [ ABND1= Total Dinoflagellates (#/l) ]

    Abundance (with zeros) Category
        Column # 8   [ ABDT4= Mnemiopsis large >1 cm (#/m3) ]
        Column # 9   [ ABDT4= Mnemiopsis small <1 cm (#/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 26   [ LOTH1= Surface NH4 (uM) ]
        Column # 27   [ LOTH1= Surface DIP (uM) ]
        Column # 28   [ LOTH1= Surface NO3NO2 (uM) ]
        Column # 29   [ LOTH1= Surface NO3 (uM) ]
        Column # 30   [ LOTH1= Surface NO2 (uM) ]
        Column # 31   [ LOTH1= Surface DIN (uM) ]
        Column # 33   [ LOTH1= Surface Silicate (uM) ]
        Column # 35   [ LOTH1= Bottom NH4 (uM) ]
        Column # 36   [ LOTH1= Bottom DIP (uM) ]
        Column # 37   [ LOTH1= Bottom NO3NO2 (uM) ]
        Column # 38   [ LOTH1= Bottom NO3 (uM) ]
        Column # 39   [ LOTH1= Bottom NO2 (uM) ]
        Column # 40   [ LOTH1= Bottom DIN (uM) ]
        Column # 42   [ LOTH1= Bottom Silicate (uM) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 5   [ OTHR5= Relative Diatoms (% of total) ]
        Column # 6   [ OTHR5= Relative Dinoflagellates (% of total) ]
        Column # 44   [ OTHR= Secchi Depth (M) ]

    Temperatures Category
        Column # 20   [ TEMP1= Surface Temperature ( C ) ]
        Column # 21   [ TEMP1= Bottom Temperature ( C ) ]

    Salinities Category
        Column # 23   [ PSAL= Surface Salinity () ]
        Column # 24   [ PSAL= Bottom Salinity () ]

    Chlorophyll/Pigments Category
        Column # 11   [ CHLA1= Surface Chlorophyll (ug/l) ]
        Column # 12   [ CHLA1= Surface Phaeophytin (ug/l) ]
        Column # 13   [ CHLA1= Bottom Chlorophyll (ug/l) ]
        Column # 14   [ CHLA1= Bottom Phaeophytin (ug/l) ]
        Column # 15   [ CHLA1= Surface Chlorophyll <20 um (ug/l) ]
        Column # 16   [ CHLA1= Surface Phaeophytin <20 um (ug/l) ]
        Column # 17   [ CHLA1= Bottom Chlorophyll <20um (ug/l) ]
        Column # 18   [ CHLA1= Bottom Phaeophytin <20um (ug/l) ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Phytoplankton (#/l) ]
        column # 3     [ ABND1= Total Diatoms (#/l) ]
        column # 4     [ ABND1= Total Dinoflagellates (#/l) ]

    Category 3 Group # 1
        column # 11     [ CHLA1= Surface Chlorophyll (ug/l) ]
        column # 12     [ CHLA1= Surface Phaeophytin (ug/l) ]
        column # 13     [ CHLA1= Bottom Chlorophyll (ug/l) ]
        column # 14     [ CHLA1= Bottom Phaeophytin (ug/l) ]
        column # 15     [ CHLA1= Surface Chlorophyll <20 um (ug/l) ]
        column # 16     [ CHLA1= Surface Phaeophytin <20 um (ug/l) ]
        column # 17     [ CHLA1= Bottom Chlorophyll <20um (ug/l) ]
        column # 18     [ CHLA1= Bottom Phaeophytin <20um (ug/l) ]

    Category 4 Group # 1
        column # 20     [ TEMP1= Surface Temperature ( C ) ]
        column # 21     [ TEMP1= Bottom Temperature ( C ) ]

    Category 6 Group # 5
        column # 5     [ OTHR5= Relative Diatoms (% of total) ]
        column # 6     [ OTHR5= Relative Dinoflagellates (% of total) ]

    Category 8 Group # 4
        column # 8     [ ABDT4= Mnemiopsis large >1 cm (#/m3) ]
        column # 9     [ ABDT4= Mnemiopsis small <1 cm (#/m3) ]

    Category 9 Group # 1
        column # 26     [ LOTH1= Surface NH4 (uM) ]
        column # 27     [ LOTH1= Surface DIP (uM) ]
        column # 28     [ LOTH1= Surface NO3NO2 (uM) ]
        column # 29     [ LOTH1= Surface NO3 (uM) ]
        column # 30     [ LOTH1= Surface NO2 (uM) ]
        column # 31     [ LOTH1= Surface DIN (uM) ]
        column # 33     [ LOTH1= Surface Silicate (uM) ]
        column # 35     [ LOTH1= Bottom NH4 (uM) ]
        column # 36     [ LOTH1= Bottom DIP (uM) ]
        column # 37     [ LOTH1= Bottom NO3NO2 (uM) ]
        column # 38     [ LOTH1= Bottom NO3 (uM) ]
        column # 39     [ LOTH1= Bottom NO2 (uM) ]
        column # 40     [ LOTH1= Bottom DIN (uM) ]
        column # 42     [ LOTH1= Bottom Silicate (uM) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1999 2016
DATES in Column 7 no problems detected 2005 2016
DATES in Column 10 no problems detected 1999 2016
DATES in Column 19 no problems detected 1959 2016
DATES in Column 22 no problems detected 1959 2016
DATES in Column 25 no problems detected 2003 2014
DATES in Column 32 no problems detected 2003 2014
DATES in Column 34 no problems detected 2003 2014
DATES in Column 41 no problems detected 2003 2014
DATES in Column 43 no problems detected 1959 2016

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
7 DATE-DMY DATE-DMY yes 1 31 Apr Sep 05 16
10 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1999 2016
19 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1959 2016
22 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 1997
25 DATE-DMY DATE-DMY yes 1 31 Apr Sep 2003 2014
32 DATE-DMY DATE-DMY yes 1 31 Apr Sep 2003 2014
34 DATE-DMY DATE-DMY yes 1 31 Apr Sep 2003 2014
41 DATE-DMY DATE-DMY yes 1 31 Apr Sep 2003 2014
43 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1959 2016


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABND1= Total Phytoplankton (#/l) ] 		no problems detected 1251 7000. 130163000. 1251
( 100%)		 1251
( 100%)
Column 3 :
[ 05_ABND1= Total Diatoms (#/l) ] 		no problems detected 1251 500. 128788000. 1251
( 100%)		 1251
( 100%)
Column 4 :
[ 06_ABND1= Total Dinoflagellates (#/l) ] 		no problems detected 1251 100. 8283800. 1110
( 88%)		 1110
( 88%)
Column 5 :
[ 07_OTHR5= Relative Diatoms (% of total) ] 		no problems detected 1251 0.100000001 979. 1251
( 100%)		 1247
( 99%)
Column 6 :
[ 08_OTHR5= Relative Dinoflagellates (% of total) ] 		no problems detected 1251 0.100000001 87.6999969 1079
( 86%)		 763
( 60%)
Column 8 :
[ 09_ABDT4= Mnemiopsis large >1 cm (#/m3) ] 		no problems detected 520 0.360000014 210.910004 133
( 25%)		 90
( 17%)
Column 9 :
[ 10_ABDT4= Mnemiopsis small <1 cm (#/m3) ] 		no problems detected 520 0.360000014 877.369995 263
( 50%)		 206
( 39%)
Column 11 :
[ 11_CHLA1= Surface Chlorophyll (ug/l) ] 		no problems detected 836 0.0500000007 48.0299988 836
( 100%)		 810
( 96%)
Column 12 :
[ 12_CHLA1= Surface Phaeophytin (ug/l) ] 		no problems detected 833 -7.13999987 50.2000008 809
( 97%)		 512
( 61%)
Column 13 :
[13_CHLA1= Bottom Chlorophyll (ug/l) ] 		There is/are 1 count WARNING(S)!
Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  824 0.0299999993 50.8400002 824
    ( 100%)    		 798
    ( 96%)
    Column 14 :
    [14_CHLA1= Bottom Phaeophytin (ug/l) ]     		There is/are 1 count WARNING(S)!
    Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  823 -4.23999977 12.3299999 802
    ( 97%)    		 556
    ( 67%)
    Column 15 :
    [ 15_CHLA1= Surface Chlorophyll <20 um (ug/l) ]     		no problems detected 813 -1.16999996 32.7700005 811
    ( 99%)    		 736
    ( 90%)
    Column 16 :
    [ 16_CHLA1= Surface Phaeophytin <20 um (ug/l) ]     		no problems detected 813 -0.980000019 58.6100006 797
    ( 98%)    		 488
    ( 60%)
    Column 17 :
    [17_CHLA1= Bottom Chlorophyll <20um (ug/l) ]     		There is/are 1 count WARNING(S)!
    Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  803 0.0199999996 23.3700008 803
    ( 100%)    		 669
    ( 83%)
    Column 18 :
    [18_CHLA1= Bottom Phaeophytin <20um (ug/l) ]     		There is/are 1 count WARNING(S)!
    Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  803 -1.53999996 31.5799999 783
    ( 97%)    		 484
    ( 60%)
    Column 20 :
    [ 19_TEMP1= Surface Temperature ( C ) ]     		no problems detected 2531 -2. 26.4699993 2455
    ( 96%)    		 2349
    ( 92%)
    Column 21 :
    [ 20_TEMP1= Bottom Temperature ( C ) ]     		no problems detected 2093 -1.75 33.0999985 2053
    ( 98%)    		 1989
    ( 95%)
    Column 23 :
    [ 21_PSAL= Surface Salinity () ]     		no problems detected 2077 3.79999995 34. 2077
    ( 100%)    		 2077
    ( 100%)
    Column 24 :
    [ 22_PSAL= Bottom Salinity () ]     		no problems detected 1969 3.5999999 34.5 1956
    ( 99%)    		 1956
    ( 99%)
    Column 26 :
    [ 23_LOTH1= Surface NH4 (uM) ]     		no problems detected 353 0.0199999996 13.0150003 353
    ( 100%)    		 136
    ( 38%)
    Column 27 :
    [ 24_LOTH1= Surface DIP (uM) ]     		no problems detected 354 0.00499999989 1.94000006 354
    ( 100%)    		 96
    ( 27%)
    Column 28 :
    [ 25_LOTH1= Surface NO3NO2 (uM) ]     		no problems detected 355 -0.0700000003 19.3789997 344
    ( 96%)    		 134
    ( 37%)
    Column 29 :
    [ 26_LOTH1= Surface NO3 (uM) ]     		no problems detected 346 -0.0700000003 18.2520008 334
    ( 96%)    		 110
    ( 31%)
    Column 30 :
    [ 27_LOTH1= Surface NO2 (uM) ]     		no problems detected 348 -0.0399999991 13.8299999 327
    ( 93%)    		 44
    ( 12%)
    Column 31 :
    [ 28_LOTH1= Surface DIN (uM) ]     		no problems detected 299 0.0359999985 28.3239994 298
    ( 99%)    		 161
    ( 53%)
    Column 33 :
    [ 29_LOTH1= Surface Silicate (uM) ]     		no problems detected 300 0.0299999993 77.6200027 300
    ( 100%)    		 260
    ( 86%)
    Column 35 :
    [ 30_LOTH1= Bottom NH4 (uM) ]     		no problems detected 343 -0.0299999993 13.0480003 341
    ( 99%)    		 181
    ( 52%)
    Column 36 :
    [ 31_LOTH1= Bottom DIP (uM) ]     		no problems detected 344 0.0199999996 2.04200006 344
    ( 100%)    		 116
    ( 33%)
    Column 37 :
    [ 32_LOTH1= Bottom NO3NO2 (uM) ]     		no problems detected 343 -0.00999999978 14.7489996 339
    ( 98%)    		 131
    ( 38%)
    Column 38 :
    [ 33_LOTH1= Bottom NO3 (uM) ]     		no problems detected 339 -0.0399999991 14.0340004 328
    ( 96%)    		 103
    ( 30%)
    Column 39 :
    [ 34_LOTH1= Bottom NO2 (uM) ]     		no problems detected 339 -0.00999999978 11.5679998 328
    ( 96%)    		 38
    ( 11%)
    Column 40 :
    [ 35_LOTH1= Bottom DIN (uM) ]     		no problems detected 292 0.0260000005 20.7649994 290
    ( 99%)    		 203
    ( 69%)
    Column 42 :
    [ 36_LOTH1= Bottom Silicate (uM) ]     		no problems detected 298 0.0399999991 55.0600014 298
    ( 100%)    		 268
    ( 89%)
    Column 44 :
    [ 37_OTHR= Secchi Depth (M) ]     		no problems detected 1655 0.5 35. 1654
    ( 99%)    		 1645
    ( 99%)

    The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".