COPEPODITE Incoming Data Review
Fatal Format Issues:   none


HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2    [ABDT1= Total Mesozooplankton Biovolume (ml/m3)]      ( date set 1 )
    Column # 3    [ABDT1= Gelatinous zooplankton biovolume (ml/m3)]      ( date set 1 )

    Column # 4     [ DATE-DMY ]       Date Set = 2
    Column # 5    [CHLA1= Chlorophyll (mg/l)]      ( date set 2 )
    Column # 6    [CHLA1= Chlorophyll with all years (mg/l)]      ( date set 2 )

    Column # 7     [ DATE-DMY ]       Date Set = 3
    Column # 8    [LOTH= Nitrate (uM)]      ( date set 3 )

    Column # 9     [ DATE-DMY ]       Date Set = 4
    Column # 10    [LOTH= Silicate (uM)]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Mesozooplankton Biovolume (ml/m3) ]
        Column # 3   [ ABDT1= Gelatinous zooplankton biovolume (ml/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 8   [ LOTH= Nitrate (uM) ]
        Column # 10   [ LOTH= Silicate (uM) ]

    Chlorophyll/Pigments Category
        Column # 5   [ CHLA1= Chlorophyll (mg/l) ]
        Column # 6   [ CHLA1= Chlorophyll with all years (mg/l) ]

DATA SORTED BY GROUPING SETS:

    Category 3 Group # 1
        column # 5     [ CHLA1= Chlorophyll (mg/l) ]
        column # 6     [ CHLA1= Chlorophyll with all years (mg/l) ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Mesozooplankton Biovolume (ml/m3) ]
        column # 3     [ ABDT1= Gelatinous zooplankton biovolume (ml/m3) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2003 2013
DATES in Column 4 no problems detected 1979 2011
DATES in Column 7 no problems detected 1988 2011
DATES in Column 9 no problems detected 1988 2011

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 1 12 01 31 2003 2013
4 DATE-DMY DATE-DMY yes 1 31 01 12 1979 2011
7 DATE-DMY DATE-DMY yes 01 31 01 12 1988 2011
9 DATE-DMY DATE-DMY yes 01 31 01 12 1988 2011


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Mesozooplankton Biovolume (ml/m3) ] 		no problems detected 568 0.00999999978 9.48999977 550
( 96%)		 7
( 1%)
Column 3 :
[ 05_ABDT1= Gelatinous zooplankton biovolume (ml/m3) ] 		no problems detected 568 0.0199999996 34.5 63
( 11%)		 28
( 4%)
Column 5 :
[ 06_CHLA1= Chlorophyll (mg/l) ] 		no problems detected 818 0.00999999978 1.88 816
( 99%)		 9
( 1%)
Column 6 :
[ 07_CHLA1= Chlorophyll with all years (mg/l) ] 		no problems detected 950 0.00999999978 1.88 947
( 99%)		 23
( 2%)
Column 8 :
[ 08_LOTH= Nitrate (uM) ] 		no problems detected 982 0.00999999978 3.8900001 894
( 91%)		 104
( 10%)
Column 10 :
[ 09_LOTH= Silicate (uM) ] 		no problems detected 980 0.00999999978 4.23999977 958
( 97%)		 395
( 40%)

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