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     [CHLA= Chlorophyll (ug/L) at the surface]      ( date set 6 )


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 ]

    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 ]

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 1987 2015
DATES in Column 3 no problems detected 1987 2015
DATES in Column 5 no problems detected 1987 2018
DATES in Column 7 no problems detected 1987 2018
DATES in Column 9 no problems detected 1988 2017
DATES in Column 11 no problems detected 1999 2015

 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 1987 2015 01 12 01 31
3 DATE-YMD DATE-YMD yes 1987 2015 01 12 01 31
5 DATE-YMD DATE-YMD yes 1987 2018 01 12 01 31
7 DATE-YMD DATE-YMD yes 1987 2018 01 12 01 31
9 DATE-YMD DATE-YMD yes 1988 2017 01 12 01 31
11 DATE-YMD DATE-YMD yes 1999 2015 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 706 100.000000 4969900.00 706
( 100 %)		 706
( 100 %)
Column 4 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ] 		no problems detected 702 100.000000 227200.000 692
( 98 %)		 692
( 98 %)
Column 6 :
[ 06_TEMP= Temperature (C) at the surface ] 		no problems detected 999 8.69999981 29.2000008 999
( 100 %)		 999
( 100 %)
Column 8 :
[ 07_PSAL= Salinity () at the surface ] 		no problems detected 966 21.6000004 42.2000008 966
( 100 %)		 966
( 100 %)
Column 10 :
[ 08_OTHR= Oxygen (ml/l) at the surface ] 		no problems detected 142 0.660000026 150.000000 142
( 100 %)		 141
( 99 %)
Column 12 :
[ 09_CHLA= Chlorophyll (ug/L) at the surface ] 		no problems detected 406 5.00000007E-02 4.75000000 402
( 99 %)		 66
( 16 %)

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