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     [CHLA= Chlorophyll (mg/m3)]      ( date set 1 )
    Column # 3     [CHLA= Phaeopigment (mg/m3)]      ( date set 1 )

    Column # 4     [ DATE-YMD ]       Date Set = 2
    Column # 5     [TEMP= Temperature (C)]      ( date set 2 )
    Column # 6     [PSAL= Salinity ()]      ( date set 2 )
    Column # 7     [OTHR= Oxygen (ml/l)]      ( date set 2 )

    Column # 8     [ DATE-MDY ]       Date Set = 3
    Column # 9     [OTHR= Oxygen (ml/l)]      ( date set 3 )
    Column # 10     [OTHR= Oxygen (uM)]      ( date set 3 )

    Column # 11     [ DATE-YMD ]       Date Set = 4
    Column # 12     [BIOM= Total Displacement Volume (ml/1000m3)]      ( date set 4 )
    Column # 13     [ABDT= Total Copepods (#/1000m3)]      ( date set 4 )
    Column # 14     [ABND= Total Zooplankton (#/1000m3)]      ( date set 4 )

    Column # 15     [ DATE-MDY ]       Date Set = 5
    Column # 16     [LOTH= PO4 (uM)]      ( date set 5 )
    Column # 17     [LOTH= SiO4 (uM)]      ( date set 5 )
    Column # 18     [LOTH= NO3NO2 (uM)]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 14   [ ABND= Total Zooplankton (#/1000m3) ]

    Abundance (with zeros) Category
        Column # 13   [ ABDT= Total Copepods (#/1000m3) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 7   [ OTHR= Oxygen (ml/l) ]
        Column # 9   [ OTHR= Oxygen (ml/l) ]
        Column # 10   [ OTHR= Oxygen (uM) ]

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

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



DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1989 2015
DATES in Column 4 no problems detected 1997 2014
DATES in Column 8 no problems detected 1993 2012
DATES in Column 11 no problems detected 1993 2013
DATES in Column 15 no problems detected 1991 2014

 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 11 1 31 1989 2015
4 DATE-YMD DATE-YMD yes 1997 2014 Feb Sep 01 31
8 DATE-MDY DATE-MDY yes 1 4 1 31 1993 2012
11 DATE-YMD DATE-YMD yes 1993 2013 01 02 01 31
15 DATE-MDY DATE-MDY yes 1 11 1 31 1991 2014


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_CHLA= Chlorophyll (mg/m3) ] 		no problems detected 8406 -6.86896229 13292.5000 8398
( 99 %)		 3853
( 45 %)
Column 3 :
[ 05_CHLA= Phaeopigment (mg/m3) ] 		no problems detected 8406 -5.53000021 10447.2998 7389
( 87 %)		 607
( 7 %)
Column 5 :
[ 06_TEMP= Temperature (C) ] 		no problems detected 5134 -1.85249996 4.42290020 4188
( 81 %)		 2469
( 48 %)
Column 6 :
[ 07_PSAL= Salinity () ] 		no problems detected 5046 25.8719997 34.9822998 5046
( 100 %)		 5046
( 100 %)
Column 7 :
[ 08_OTHR= Oxygen (ml/l) ] 		no problems detected 4444 2.02370000 12.3921003 4444
( 100 %)		 4444
( 100 %)
Column 9 :
[ 09_OTHR= Oxygen (ml/l) ] 		no problems detected 1425 4.15700006 19.0380001 1425
( 100 %)		 1425
( 100 %)
Column 10 :
[ 10_OTHR= Oxygen (uM) ] 		no problems detected 1909 4.03999996 1416.80005 1909
( 100 %)		 1909
( 100 %)
Column 12 :
[ 11_BIOM= Total Displacement Volume (ml/1000m3) ] 		no problems detected 1156 7.00000003E-02 6592.52588 1142
( 98 %)		 1129
( 97 %)
Column 13 :
[ 12_ABDT= Total Copepods (#/1000m3) ] 		no problems detected 1156 0.245000005 999.999023 181
( 15 %)		 180
( 15 %)
Column 14 :
[ 13_ABND= Total Zooplankton (#/1000m3) ] 		no problems detected 1156 8.00000038E-03 25.6259995 188
( 16 %)		 93
( 8 %)
Column 16 :
[ 14_LOTH= PO4 (uM) ] 		no problems detected 3313 -3.99999991E-02 13.1630001 3281
( 99 %)		 2667
( 80 %)
Column 17 :
[ 15_LOTH= SiO4 (uM) ] 		no problems detected 3637 0.699999988 191.740005 3636
( 99 %)		 3635
( 99 %)
Column 18 :
[ 16_LOTH= NO3NO2 (uM) ] 		no problems detected 2449 9.99999978E-03 35.6500015 2429
( 99 %)		 2383
( 97 %)

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