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    [ABDT3= Total Copepods (#/m2)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [BIOM3= Total Wet Weight (g/m2)]      ( date set 2 )
    Column # 5    [BIOM2= Total Dry Weight (g/m2)]      ( date set 2 )
    Column # 6    [BIOM2= Total Dry Weight of <10 mm (g/m2)]      ( date set 2 )
    Column # 7    [BIOM3= Total Wet Weight of <10 mm (g/m2)]      ( date set 2 )
    Column # 8    [BIOM3= Total Wet Weight of >10 mm (g/m2)]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10    [ABDT8= Total Diatoms (#/L)]      ( date set 3 )
    Column # 11    [ABDT8= Total Dinoflagellates (#/L)]      ( date set 3 )
    Column # 12    [ABDT8= Total Ciliates (#/L)]      ( date set 3 )
    Column # 13    [ABDT8= Total Flagellates (#/L)]      ( date set 3 )

    Column # 14     [ DATE-YMD ]       Date Set = 4
    Column # 15    [CHLA= Integrated Chlorophyll (mg/m2) from 0-100m]      ( date set 4 )

    Column # 16     [ DATE-YMD ]       Date Set = 5
    Column # 17    [LOTH3= Nitrate (mmol/m3) at the surface]      ( date set 5 )
    Column # 18    [LOTH3= Phosphate (mmol/m3) at the surface]      ( date set 5 )
    Column # 19    [LOTH3= Silicate (mmol/m3) at the surface]      ( date set 5 )

    Column # 20     [ DATE-YMD ]       Date Set = 6
    Column # 21    [LOTH3= Nitrate (mmol/m3) at the bottom]      ( date set 6 )
    Column # 22    [LOTH3= Phosphate (mmol/m3) at the bottom]      ( date set 6 )
    Column # 23    [LOTH3= Silicate (mmol/m3) at the bottom]      ( date set 6 )

    Column # 24     [ DATE-YMD ]       Date Set = 7
    Column # 25    [TEMP1= Temperature ( C ) at the surface]      ( date set 7 )
    Column # 26    [PSAL1= Salinity () at the surface]      ( date set 7 )
    Column # 27    [TEMP1= Temperature ( C ) at the bottom]      ( date set 7 )
    Column # 28    [PSAL1= Salinity () at the bottom]      ( date set 7 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 4   [ BIOM3= Total Wet Weight (g/m2) ]
        Column # 5   [ BIOM2= Total Dry Weight (g/m2) ]
        Column # 6   [ BIOM2= Total Dry Weight of <10 mm (g/m2) ]
        Column # 7   [ BIOM3= Total Wet Weight of <10 mm (g/m2) ]
        Column # 8   [ BIOM3= Total Wet Weight of >10 mm (g/m2) ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT3= Total Copepods (#/m2) ]
        Column # 10   [ ABDT8= Total Diatoms (#/L) ]
        Column # 11   [ ABDT8= Total Dinoflagellates (#/L) ]
        Column # 12   [ ABDT8= Total Ciliates (#/L) ]
        Column # 13   [ ABDT8= Total Flagellates (#/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 17   [ LOTH3= Nitrate (mmol/m3) at the surface ]
        Column # 18   [ LOTH3= Phosphate (mmol/m3) at the surface ]
        Column # 19   [ LOTH3= Silicate (mmol/m3) at the surface ]
        Column # 21   [ LOTH3= Nitrate (mmol/m3) at the bottom ]
        Column # 22   [ LOTH3= Phosphate (mmol/m3) at the bottom ]
        Column # 23   [ LOTH3= Silicate (mmol/m3) at the bottom ]

    Temperatures Category
        Column # 25   [ TEMP1= Temperature ( C ) at the surface ]
        Column # 27   [ TEMP1= Temperature ( C ) at the bottom ]

    Salinities Category
        Column # 26   [ PSAL1= Salinity () at the surface ]
        Column # 28   [ PSAL1= Salinity () at the bottom ]

    Chlorophyll/Pigments Category
        Column # 15   [ CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 2
        column # 5     [ BIOM2= Total Dry Weight (g/m2) ]
        column # 6     [ BIOM2= Total Dry Weight of <10 mm (g/m2) ]

    Category 1 Group # 3
        column # 4     [ BIOM3= Total Wet Weight (g/m2) ]
        column # 7     [ BIOM3= Total Wet Weight of <10 mm (g/m2) ]
        column # 8     [ BIOM3= Total Wet Weight of >10 mm (g/m2) ]

    Category 4 Group # 1
        column # 25     [ TEMP1= Temperature ( C ) at the surface ]
        column # 27     [ TEMP1= Temperature ( C ) at the bottom ]

    Category 5 Group # 1
        column # 26     [ PSAL1= Salinity () at the surface ]
        column # 28     [ PSAL1= Salinity () at the bottom ]

    Category 8 Group # 3
        column # 2     [ ABDT3= Total Copepods (#/m2) ]

    Category 8 Group # 8
        column # 10     [ ABDT8= Total Diatoms (#/L) ]
        column # 11     [ ABDT8= Total Dinoflagellates (#/L) ]
        column # 12     [ ABDT8= Total Ciliates (#/L) ]
        column # 13     [ ABDT8= Total Flagellates (#/L) ]

    Category 9 Group # 3
        column # 17     [ LOTH3= Nitrate (mmol/m3) at the surface ]
        column # 18     [ LOTH3= Phosphate (mmol/m3) at the surface ]
        column # 19     [ LOTH3= Silicate (mmol/m3) at the surface ]
        column # 21     [ LOTH3= Nitrate (mmol/m3) at the bottom ]
        column # 22     [ LOTH3= Phosphate (mmol/m3) at the bottom ]
        column # 23     [ LOTH3= Silicate (mmol/m3) at the bottom ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1999 2017
DATES in Column 3 no problems detected 1999 2017
DATES in Column 9 no problems detected 1999 2017
DATES in Column 14 no problems detected 1999 2017
DATES in Column 16 no problems detected 1999 2017
DATES in Column 20 no problems detected 1999 2017
DATES in Column 24 no problems detected 1999 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 1999 2017 1 12 1 31
3 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
9 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
14 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
16 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
20 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
24 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_ABDT3= Total Copepods (#/m2) ] 		no problems detected 246 1074.70166 729773.312 246
( 100%)		 246
( 100%)
Column 4 :
[ 05_BIOM3= Total Wet Weight (g/m2) ] 		no problems detected 224 0.111256279 91.3872452 224
( 100%)		 187
( 83%)
Column 5 :
[ 06_BIOM2= Total Dry Weight (g/m2) ] 		no problems detected 243 0.0118181817 14.5660353 238
( 97%)		 97
( 39%)
Column 6 :
[ 07_BIOM2= Total Dry Weight of <10 mm (g/m2) ] 		no problems detected 238 0.0118181817 14.5660353 238
( 100%)		 95
( 39%)
Column 7 :
[ 08_BIOM3= Total Wet Weight of <10 mm (g/m2) ] 		no problems detected 218 0.111256279 58.1649933 218
( 100%)		 176
( 80%)
Column 8 :
[ 09_BIOM3= Total Wet Weight of >10 mm (g/m2) ] 		no problems detected 137 0.0079227034 94.533226 133
( 97%)		 26
( 18%)
Column 10 :
[ 10_ABDT8= Total Diatoms (#/L) ] 		no problems detected 254 2900. 1007000. 254
( 100%)		 254
( 100%)
Column 11 :
[ 11_ABDT8= Total Dinoflagellates (#/L) ] 		no problems detected 254 100. 19200. 196
( 77%)		 196
( 77%)
Column 12 :
[ 12_ABDT8= Total Ciliates (#/L) ] 		no problems detected 254 100. 2500. 148
( 58%)		 148
( 58%)
Column 13 :
[ 13_ABDT8= Total Flagellates (#/L) ] 		no problems detected 254 100. 30200. 142
( 55%)		 142
( 55%)
Column 15 :
[ 14_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ] 		no problems detected 259 6.12478685 789.332703 259
( 100%)		 259
( 100%)
Column 17 :
[ 15_LOTH3= Nitrate (mmol/m3) at the surface ] 		no problems detected 269 0.294999987 21.4790001 269
( 100%)		 263
( 97%)
Column 18 :
[ 16_LOTH3= Phosphate (mmol/m3) at the surface ] 		no problems detected 255 0.310000002 4.44999981 253
( 99%)		 43
( 16%)
Column 19 :
[ 17_LOTH3= Silicate (mmol/m3) at the surface ] 		no problems detected 269 0.970000029 13.9549999 269
( 100%)		 268
( 99%)
Column 21 :
[ 18_LOTH3= Nitrate (mmol/m3) at the bottom ] 		no problems detected 264 3.27999997 11.9809999 264
( 100%)		 264
( 100%)
Column 22 :
[ 19_LOTH3= Phosphate (mmol/m3) at the bottom ] 		no problems detected 250 0.561500013 4.80900002 248
( 99%)		 36
( 14%)
Column 23 :
[ 20_LOTH3= Silicate (mmol/m3) at the bottom ] 		no problems detected 264 2.77800012 11.3140001 264
( 100%)		 264
( 100%)
Column 25 :
[ 21_TEMP1= Temperature ( C ) at the surface ] 		no problems detected 281 0.569700003 13.8216 281
( 100%)		 280
( 99%)
Column 26 :
[ 22_PSAL1= Salinity () at the surface ] 		no problems detected 281 26.0872002 33.0214005 281
( 100%)		 281
( 100%)
Column 27 :
[ 23_TEMP1= Temperature ( C ) at the bottom ] 		no problems detected 255 1.19309998 31.7600002 255
( 100%)		 255
( 100%)
Column 28 :
[ 24_PSAL1= Salinity () at the bottom ] 		no problems detected 254 31.4232998 33.4177017 254
( 100%)		 254
( 100%)

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