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 (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 3     [ABDT1= Total Cladocera (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 4     [ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 5     [ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m]      ( date set 1 )

    Column # 6     [ DATE-MDY ]       Date Set = 2
    Column # 7     [ABDT5= Bacillariophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 8     [ABDT5= Dinophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 9     [ABDT5= Charophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 10     [ABDT5= Chlorophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 11     [ABDT5= Chrysophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 12     [ABDT5= Litostomatea (mg-WW/m3)]      ( date set 2 )
    Column # 13     [ABDT5= Cryptophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 14     [ABDT5= Ebriidea (mg-WW/m3)]      ( date set 2 )
    Column # 15     [ABDT5= Euglenophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 16     [ABDT5= Cyanophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 17     [ABDT5= Prasinophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 18     [ABDT5= Prymnesiophyceae (mg-WW/m3)]      ( date set 2 )

    Column # 19     [ DATE-MDY ]       Date Set = 3
    Column # 20     [CHLA= Chlorophyll-a (mg/m3) averaged from 0-10 m]      ( date set 3 )
    Column # 21     [LOTH= NO3NO2 (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 22     [LOTH= Nitrite (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 23     [LOTH= Nitrate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 24     [OTHR= Oxygen (ml/l) averaged from 0-10 m]      ( date set 3 )
    Column # 25     [OTHR= Oxygen (mg/l) averaged from 0-10 m]      ( date set 3 )
    Column # 26     [LOTH= Phosphate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 27     [PSAL= Salinity () averaged from 0-10 m]      ( date set 3 )
    Column # 28     [LOTH= Silicate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 29     [TEMP= Temperature ( C ) averaged from 0-10 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (mg-WW/m3) from 0-10m ]
        Column # 3   [ ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ]
        Column # 4   [ ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ]
        Column # 5   [ ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ]
        Column # 7   [ ABDT5= Bacillariophyceae (mg-WW/m3) ]
        Column # 8   [ ABDT5= Dinophyceae (mg-WW/m3) ]
        Column # 9   [ ABDT5= Charophyceae (mg-WW/m3) ]
        Column # 10   [ ABDT5= Chlorophyceae (mg-WW/m3) ]
        Column # 11   [ ABDT5= Chrysophyceae (mg-WW/m3) ]
        Column # 12   [ ABDT5= Litostomatea (mg-WW/m3) ]
        Column # 13   [ ABDT5= Cryptophyceae (mg-WW/m3) ]
        Column # 14   [ ABDT5= Ebriidea (mg-WW/m3) ]
        Column # 15   [ ABDT5= Euglenophyceae (mg-WW/m3) ]
        Column # 16   [ ABDT5= Cyanophyceae (mg-WW/m3) ]
        Column # 17   [ ABDT5= Prasinophyceae (mg-WW/m3) ]
        Column # 18   [ ABDT5= Prymnesiophyceae (mg-WW/m3) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 24   [ OTHR= Oxygen (ml/l) averaged from 0-10 m ]
        Column # 25   [ OTHR= Oxygen (mg/l) averaged from 0-10 m ]

    Temperatures Category
        Column # 29   [ TEMP= Temperature ( C ) averaged from 0-10 m ]

    Salinities Category
        Column # 27   [ PSAL= Salinity () averaged from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (mg-WW/m3) from 0-10m ]
        column # 3     [ ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ]
        column # 4     [ ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ]
        column # 5     [ ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ]

    Category 8 Group # 5
        column # 7     [ ABDT5= Bacillariophyceae (mg-WW/m3) ]
        column # 8     [ ABDT5= Dinophyceae (mg-WW/m3) ]
        column # 9     [ ABDT5= Charophyceae (mg-WW/m3) ]
        column # 10     [ ABDT5= Chlorophyceae (mg-WW/m3) ]
        column # 11     [ ABDT5= Chrysophyceae (mg-WW/m3) ]
        column # 12     [ ABDT5= Litostomatea (mg-WW/m3) ]
        column # 13     [ ABDT5= Cryptophyceae (mg-WW/m3) ]
        column # 14     [ ABDT5= Ebriidea (mg-WW/m3) ]
        column # 15     [ ABDT5= Euglenophyceae (mg-WW/m3) ]
        column # 16     [ ABDT5= Cyanophyceae (mg-WW/m3) ]
        column # 17     [ ABDT5= Prasinophyceae (mg-WW/m3) ]
        column # 18     [ ABDT5= Prymnesiophyceae (mg-WW/m3) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1957 2015
DATES in Column 6 no problems detected 1993 2017
DATES in Column 19 no problems detected 1993 2017

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1957 2015 01 12 1 31
6 DATE-MDY DATE-MDY yes 3 12 1 31 1993 2017
19 DATE-MDY DATE-MDY yes 1 12 1 31 1993 2017


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 (mg-WW/m3) from 0-10m ] 		no problems detected 423 1.00000000 10069.0000 420
( 99 %)		 417
( 98 %)
Column 3 :
[ 05_ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ] 		no problems detected 423 1.00000000 2014.00000 330
( 78 %)		 312
( 73 %)
Column 4 :
[ 06_ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ] 		no problems detected 423 1.00000000 998.000000 382
( 90 %)		 369
( 87 %)
Column 5 :
[ 07_ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ] 		no problems detected 85 1.00000000 1372.00000 78
( 91 %)		 73
( 85 %)
Column 7 :
[ 08_ABDT5= Bacillariophyceae (mg-WW/m3) ] 		no problems detected 247 0.300000012 10225.5996 229
( 92 %)		 216
( 87 %)
Column 8 :
[ 09_ABDT5= Dinophyceae (mg-WW/m3) ] 		no problems detected 243 0.300000012 4379.00000 235
( 96 %)		 222
( 91 %)
Column 9 :
[10_ABDT5= Charophyceae (mg-WW/m3) ] 		There is/are 1 count WARNING(S)!

Some of your values are zero or "one".

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")

    		•  11 3.99999991E-02 2.79999995 10
    ( 90 %)    		 1
    ( 9 %)
    Column 10 :
    [ 11_ABDT5= Chlorophyceae (mg-WW/m3) ]     		no problems detected 149 0.300000012 676.099976 149
    ( 100 %)    		 146
    ( 97 %)
    Column 11 :
    [ 12_ABDT5= Chrysophyceae (mg-WW/m3) ]     		no problems detected 244 0.200000003 62.2000008 203
    ( 83 %)    		 182
    ( 74 %)
    Column 12 :
    [ 13_ABDT5= Litostomatea (mg-WW/m3) ]     		no problems detected 118 2.00000000 2843.89990 118
    ( 100 %)    		 118
    ( 100 %)
    Column 13 :
    [ 14_ABDT5= Cryptophyceae (mg-WW/m3) ]     		no problems detected 253 1.00000000 229.000000 252
    ( 99 %)    		 251
    ( 99 %)
    Column 14 :
    [ 15_ABDT5= Ebriidea (mg-WW/m3) ]     		no problems detected 60 0.800000012 167.399994 60
    ( 100 %)    		 57
    ( 95 %)
    Column 15 :
    [ 16_ABDT5= Euglenophyceae (mg-WW/m3) ]     		no problems detected 213 0.300000012 315.700012 156
    ( 73 %)    		 130
    ( 61 %)
    Column 16 :
    [ 17_ABDT5= Cyanophyceae (mg-WW/m3) ]     		no problems detected 248 0.100000001 2039.00000 243
    ( 97 %)    		 223
    ( 89 %)
    Column 17 :
    [ 18_ABDT5= Prasinophyceae (mg-WW/m3) ]     		no problems detected 145 0.100000001 310.882263 145
    ( 100 %)    		 136
    ( 93 %)
    Column 18 :
    [ 19_ABDT5= Prymnesiophyceae (mg-WW/m3) ]     		no problems detected 239 9.99999978E-03 114.699997 198
    ( 82 %)    		 152
    ( 63 %)
    Column 20 :
    [ 20_CHLA= Chlorophyll-a (mg/m3) averaged from 0-10 m ]     		no problems detected 303 0.590361416 50.9959831 303
    ( 100 %)    		 301
    ( 99 %)
    Column 21 :
    [ 21_LOTH= NO3NO2 (uM) averaged from 0-10 m ]     		no problems detected 153 3.33333295E-03 39.9199982 149
    ( 97 %)    		 93
    ( 60 %)
    Column 22 :
    [ 22_LOTH= Nitrite (uM) averaged from 0-10 m ]     		no problems detected 148 3.33333295E-03 1.33000004 147
    ( 99 %)    		 1
    ( 0 %)
    Column 23 :
    [ 23_LOTH= Nitrate (uM) averaged from 0-10 m ]     		no problems detected 147 1.66666675E-02 27.2933331 147
    ( 100 %)    		 77
    ( 52 %)
    Column 24 :
    [ 24_OTHR= Oxygen (ml/l) averaged from 0-10 m ]     		no problems detected 182 4.12876129 14.5249996 177
    ( 97 %)    		 177
    ( 97 %)
    Column 25 :
    [ 25_OTHR= Oxygen (mg/l) averaged from 0-10 m ]     		no problems detected 125 6.56181812 13.1733332 125
    ( 100 %)    		 125
    ( 100 %)
    Column 26 :
    [ 26_LOTH= Phosphate (uM) averaged from 0-10 m ]     		no problems detected 289 6.88171992E-03 2.54333329 288
    ( 99 %)    		 10
    ( 3 %)
    Column 27 :
    [ 27_PSAL= Salinity () averaged from 0-10 m ]     		no problems detected 246 1.76190473E-02 5.79333353 246
    ( 100 %)    		 244
    ( 99 %)
    Column 28 :
    [ 28_LOTH= Silicate (uM) averaged from 0-10 m ]     		no problems detected 280 8.45238101E-03 42.0858345 280
    ( 100 %)    		 257
    ( 91 %)
    Column 29 :
    [ 29_TEMP= Temperature ( C ) averaged from 0-10 m ]     		no problems detected 239 1.99999996E-02 23.9666672 239
    ( 100 %)    		 237
    ( 99 %)

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