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

DATA SORTED BY GROUPING SETS:

    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 9.99999978E-03 9.48999977 550
( 96 %)		 7
( 1 %)
Column 3 :
[ 05_ABDT1= Gelatinous zooplankton biovolume (ml/m3) ] 		no problems detected 568 1.99999996E-02 34.5000000 63
( 11 %)		 28
( 4 %)
Column 5 :
[ 06_CHLA1= Chlorophyll (mg/l) ] 		no problems detected 818 9.99999978E-03 1.88000000 816
( 99 %)		 9
( 1 %)
Column 6 :
[ 07_CHLA1= Chlorophyll with all years (mg/l) ] 		no problems detected 950 9.99999978E-03 1.88000000 947
( 99 %)		 23
( 2 %)
Column 8 :
[ 08_LOTH= Nitrate (uM) ] 		no problems detected 982 9.99999978E-03 3.89000010 894
( 91 %)		 104
( 10 %)
Column 10 :
[ 09_LOTH= Silicate (uM) ] 		no problems detected 980 9.99999978E-03 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".