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 Diatoms (#/L) at the surface]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [ABDT1= Total Dinoflagellates (#/L) at the surface]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6    [TEMP= Temperature (C) at the surface]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8    [PSAL= Salinity () at the surface]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10    [OTHR= Oxygen (ml/l) at the surface]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12    [LOTH= NO3+NO2 (uM) at the surface]      ( date set 6 )

    Column # 13     [ DATE-YMD ]       Date Set = 7
    Column # 14    [LOTH= NO3 (uM) at the surface]      ( date set 7 )

    Column # 15     [ DATE-YMD ]       Date Set = 8
    Column # 16    [LOTH= NO2 (uM) at the surface]      ( date set 8 )

    Column # 17     [ DATE-YMD ]       Date Set = 9
    Column # 18    [LOTH= NH4 (uM) at the surface]      ( date set 9 )

    Column # 19     [ DATE-YMD ]       Date Set = 10
    Column # 20    [LOTH= PO4 (uM) at the surface]      ( date set 10 )

    Column # 21     [ DATE-YMD ]       Date Set = 11
    Column # 22    [LOTH= SiO4 (uM) at the surface]      ( date set 11 )

    Column # 23     [ DATE-YMD ]       Date Set = 12
    Column # 24    [CHLA= Chlorophyll (ug/L) at the surface]      ( date set 12 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) at the surface ]
        Column # 4   [ ABDT1= Total Dinoflagellates (#/L) at the surface ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 12   [ LOTH= NO3+NO2 (uM) at the surface ]
        Column # 14   [ LOTH= NO3 (uM) at the surface ]
        Column # 16   [ LOTH= NO2 (uM) at the surface ]
        Column # 18   [ LOTH= NH4 (uM) at the surface ]
        Column # 20   [ LOTH= PO4 (uM) at the surface ]
        Column # 22   [ LOTH= SiO4 (uM) at the surface ]

    non-Log10 (linear) Miscellaenous Category
        Column # 10   [ OTHR= Oxygen (ml/l) at the surface ]

    Temperatures Category
        Column # 6   [ TEMP= Temperature (C) at the surface ]

    Salinities Category
        Column # 8   [ PSAL= Salinity () at the surface ]

    Chlorophyll/Pigments Category
        Column # 24   [ CHLA= Chlorophyll (ug/L) at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) at the surface ]
        column # 4     [ ABDT1= Total Dinoflagellates (#/L) at the surface ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1992 2018
DATES in Column 3 no problems detected 1992 2018
DATES in Column 5 no problems detected 1992 2018
DATES in Column 7 no problems detected 1992 2018
DATES in Column 9 no problems detected 2007 2018
DATES in Column 11 no problems detected 2009 2018
DATES in Column 13 no problems detected 1992 2009
DATES in Column 15 no problems detected 1992 2018
DATES in Column 17 no problems detected 1992 2018
DATES in Column 19 no problems detected 1992 2018
DATES in Column 21 no problems detected 1992 2018
DATES in Column 23 no problems detected 1992 2018

 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 1992 2018 01 12 01 31
3 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
5 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
7 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
9 DATE-YMD DATE-YMD yes 2007 2018 01 12 01 31
11 DATE-YMD DATE-YMD yes 2009 2018 01 12 01 31
13 DATE-YMD DATE-YMD yes 1992 2009 01 12 01 31
15 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
17 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
19 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
21 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 31
23 DATE-YMD DATE-YMD yes 1992 2018 01 12 01 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 Diatoms (#/L) at the surface ] 		no problems detected 421 2400. 7470372. 421
( 100%)		 421
( 100%)
Column 4 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ] 		no problems detected 397 100. 237508. 390
( 98%)		 390
( 98%)
Column 6 :
[ 06_TEMP= Temperature (C) at the surface ] 		no problems detected 428 2.0999999 22.1000004 428
( 100%)		 428
( 100%)
Column 8 :
[ 07_PSAL= Salinity () at the surface ] 		no problems detected 431 29.1399994 35.2999992 431
( 100%)		 431
( 100%)
Column 10 :
[ 08_OTHR= Oxygen (ml/l) at the surface ] 		no problems detected 195 6.26000023 12.5 195
( 100%)		 195
( 100%)
Column 12 :
[ 09_LOTH= NO3+NO2 (uM) at the surface ] 		no problems detected 167 0.150000006 31.1000004 167
( 100%)		 92
( 55%)
Column 14 :
[ 10_LOTH= NO3 (uM) at the surface ] 		no problems detected 250 0.0199999996 43.3100014 250
( 100%)		 152
( 60%)
Column 16 :
[ 11_LOTH= NO2 (uM) at the surface ] 		no problems detected 417 0.0399999991 1.91999996 417
( 100%)		 8
( 1%)
Column 18 :
[ 12_LOTH= NH4 (uM) at the surface ] 		no problems detected 421 0.0599999987 10.1999998 421
( 100%)		 217
( 51%)
Column 20 :
[ 13_LOTH= PO4 (uM) at the surface ] 		no problems detected 420 0.0500000007 3.0999999 420
( 100%)		 33
( 7%)
Column 22 :
[ 14_LOTH= SiO4 (uM) at the surface ] 		no problems detected 418 0.100000001 19.0100002 418
( 100%)		 262
( 62%)
Column 24 :
[ 15_CHLA= Chlorophyll (ug/L) at the surface ] 		no problems detected 502 0.00999999978 29.6000004 502
( 100%)		 447
( 89%)

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