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     [BIOM1= Total Dry Weight (mg/m3) 200um]      ( date set 1 )
    Column # 3     [BIOM1= Total Dry Weight (mg/m3) 500um]      ( date set 1 )
    Column # 4     [BIOM1= Total Ashfree Dry Weight (mg/m3) 500um]      ( date set 1 )
    Column # 5     [ABND= Total Zooplankton (#/m3) 500um]      ( date set 1 )
    Column # 6     [CHLA= Integrated Chlorophyll (mg/m2)]      ( date set 1 )

    Column # 7     [ DATE-YMD ]       Date Set = 2
    Column # 8     [ABND2= Total Phytoplankton (#/ml)]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10     [ABND2= Total Diatoms (#/ml)]      ( date set 3 )

    Column # 11     [ DATE-YMD ]       Date Set = 4
    Column # 12     [ABND2= Total Dinoflagellates (#/ml)]      ( date set 4 )

    Column # 13     [ DATE-YMD ]       Date Set = 5
    Column # 14     [ABND2= Total Coccolithophorids (#/ml)]      ( date set 5 )

    Column # 15     [ DATE-YMD ]       Date Set = 6
    Column # 16     [ABND2= Total Cyanobacteria (#/ml)]      ( date set 6 )

    Column # 17     [ DATE-YMD ]       Date Set = 7
    Column # 18     [ABND2= Total Nanoflagellates (#/ml)]      ( date set 7 )

    Column # 19     [ DATE-YMD ]       Date Set = 8
    Column # 20     [TEMP= Temperature (C)]      ( date set 8 )
    Column # 21     [PSAL= Salinity ()]      ( date set 8 )
    Column # 22     [OTHR= Oxygen (mg/l)]      ( date set 8 )

    Column # 23     [ DATE-YMD ]       Date Set = 9
    Column # 24     [LOTH4= Silicate (uM)]      ( date set 9 )
    Column # 25     [LOTH4=Phosphate (uM)]      ( date set 9 )
    Column # 26     [LOTH4=Nitrate (uM)]      ( date set 9 )
    Column # 27     [OTHR= pH ()]      ( date set 9 )
    Column # 28     [OTHR= Alkalinity (umol/kg)]      ( date set 9 )
    Column # 29     [CHLA= Chlorophyll (mg/m3)]      ( date set 9 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 5   [ ABND= Total Zooplankton (#/m3) 500um ]
        Column # 8   [ ABND2= Total Phytoplankton (#/ml) ]
        Column # 10   [ ABND2= Total Diatoms (#/ml) ]
        Column # 12   [ ABND2= Total Dinoflagellates (#/ml) ]
        Column # 14   [ ABND2= Total Coccolithophorids (#/ml) ]
        Column # 16   [ ABND2= Total Cyanobacteria (#/ml) ]
        Column # 18   [ ABND2= Total Nanoflagellates (#/ml) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 22   [ OTHR= Oxygen (mg/l) ]
        Column # 27   [ OTHR= pH () ]
        Column # 28   [ OTHR= Alkalinity (umol/kg) ]

    Temperatures Category
        Column # 20   [ TEMP= Temperature (C) ]

    Salinities Category
        Column # 21   [ PSAL= Salinity () ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 2
        column # 8     [ ABND2= Total Phytoplankton (#/ml) ]
        column # 10     [ ABND2= Total Diatoms (#/ml) ]
        column # 12     [ ABND2= Total Dinoflagellates (#/ml) ]
        column # 14     [ ABND2= Total Coccolithophorids (#/ml) ]
        column # 16     [ ABND2= Total Cyanobacteria (#/ml) ]
        column # 18     [ ABND2= Total Nanoflagellates (#/ml) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2001 2013
DATES in Column 7 no problems detected 1995 2012
DATES in Column 9 no problems detected 1995 2012
DATES in Column 11 no problems detected 1995 2012
DATES in Column 13 no problems detected 1995 2012
DATES in Column 15 no problems detected 1995 2012
DATES in Column 17 no problems detected 1995 2012
DATES in Column 19 no problems detected 1995 2012
DATES in Column 23 no problems detected 1995 2012

 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 15 15 2001 2013
7 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
9 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
11 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
13 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
15 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
17 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 18
19 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 26
23 DATE-YMD DATE-YMD yes 1995 2012 01 12 01 26


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_BIOM1= Total Dry Weight (mg/m3) 200um ] 		no problems detected 121 1.39999998 33.4500008 121
( 100 %)		 121
( 100 %)
Column 3 :
[ 05_BIOM1= Total Dry Weight (mg/m3) 500um ] 		no problems detected 70 0.709999979 16.8099995 70
( 100 %)		 68
( 97 %)
Column 4 :
[ 06_BIOM1= Total Ashfree Dry Weight (mg/m3) 500um ] 		no problems detected 49 7.00000003E-02 5.38000011 49
( 100 %)		 32
( 65 %)
Column 5 :
[ 07_ABND= Total Zooplankton (#/m3) 500um ] 		no problems detected 53 6.61999989 214.809998 53
( 100 %)		 53
( 100 %)
Column 6 :
[ 08_CHLA= Integrated Chlorophyll (mg/m2) ] 		no problems detected 122 13.0000000 202.339996 122
( 100 %)		 122
( 100 %)
Column 8 :
[ 09_ABND2= Total Phytoplankton (#/ml) ] 		no problems detected 170 5.00000000 5274.57422 166
( 97 %)		 166
( 97 %)
Column 10 :
[ 10_ABND2= Total Diatoms (#/ml) ] 		no problems detected 170 9.99999978E-03 12682.5596 150
( 88 %)		 87
( 51 %)
Column 12 :
[ 11_ABND2= Total Dinoflagellates (#/ml) ] 		no problems detected 170 9.99999978E-03 103.000000 160
( 94 %)		 124
( 72 %)
Column 14 :
[ 12_ABND2= Total Coccolithophorids (#/ml) ] 		no problems detected 170 1.99999996E-02 208.059998 142
( 83 %)		 94
( 55 %)
Column 16 :
[ 13_ABND2= Total Cyanobacteria (#/ml) ] 		no problems detected 170 9.99999978E-03 85.0000000 79
( 46 %)		 34
( 20 %)
Column 18 :
[ 14_ABND2= Total Nanoflagellates (#/ml) ] 		no problems detected 170 10.3999996 1831.28003 159
( 93 %)		 159
( 93 %)
Column 20 :
[ 15_TEMP= Temperature (C) ] 		no problems detected 188 21.8190002 30.0620003 188
( 100 %)		 188
( 100 %)
Column 21 :
[ 16_PSAL= Salinity () ] 		no problems detected 188 35.8629990 37.0169983 188
( 100 %)		 188
( 100 %)
Column 22 :
[ 17_OTHR= Oxygen (mg/l) ] 		no problems detected 190 4.07000017 6.19000006 190
( 100 %)		 190
( 100 %)
Column 24 :
[ 18_LOTH4= Silicate (uM) ] 		no problems detected 496 9.99999978E-03 11.6199999 422
( 85 %)		 217
( 43 %)
Column 25 :
[ 19_LOTH4=Phosphate (uM) ] 		no problems detected 498 9.99999978E-03 1.07000005 467
( 93 %)		 1
( 0 %)
Column 26 :
[ 20_LOTH4=Nitrate (uM) ] 		no problems detected 498 9.99999978E-03 13.9099998 340
( 68 %)		 29
( 5 %)
Column 27 :
[ 21_OTHR= pH () ] 		no problems detected 517 7.92399979 8.13300037 517
( 100 %)		 517
( 100 %)
Column 28 :
[ 22_OTHR= Alkalinity (umol/kg) ] 		no problems detected 511 13.8000002 18.5580006 511
( 100 %)		 511
( 100 %)
Column 29 :
[ 23_CHLA= Chlorophyll (mg/m3) ] 		no problems detected 579 5.00000007E-02 8.02000046 579
( 100 %)		 119
( 20 %)

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