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 Diatoms (#/ml)]      ( date set 1 )
    Column # 3     [ABDT2= Total Diatoms cell volume (ml/m3)]      ( date set 1 )
    Column # 4     [ABDT3= Total Diatoms cell carbon (ugC/l)]      ( date set 1 )
    Column # 5     [ABDT1= Total dinoflagellates (#/ml)]      ( date set 1 )
    Column # 6     [ABDT2= Total dinoflagellates cell volume (um3/l)]      ( date set 1 )
    Column # 7     [ABDT3= Total dinoflagellates cell carbon (ugC/l)]      ( date set 1 )
    Column # 8     [ABDT1= Other phytoplankton (#/l)]      ( date set 1 )
    Column # 9     [ABDT2= Other phytoplanktons cell volume (um3/l)]      ( date set 1 )
    Column # 10     [ABDT3= Other phytoplanktons cell carbon (ugC/l)]      ( date set 1 )

    Column # 11     [ DATE-MDY ]       Date Set = 2
    Column # 12     [TEMP= Temperature ( C )]      ( date set 2 )
    Column # 13     [PSAL= Salinity ()]      ( date set 2 )
    Column # 14     [OTHR= pH ()]      ( date set 2 )
    Column # 15     [LOTH= NH4 (uM)]      ( date set 2 )
    Column # 16     [LOTH= NO2 (uM)]      ( date set 2 )
    Column # 17     [LOTH= NO3 (uM)]      ( date set 2 )
    Column # 18     [LOTH= DON (uM)]      ( date set 2 )
    Column # 19     [LOTH= DOP (uM)]      ( date set 2 )
    Column # 20     [LOTH= PO4 (uM)]      ( date set 2 )
    Column # 21     [LOTH= Si04 (uM)]      ( date set 2 )
    Column # 22     [CHLA= Chlorophyll (ug/l)]      ( date set 2 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/ml) ]
        Column # 3   [ ABDT2= Total Diatoms cell volume (ml/m3) ]
        Column # 4   [ ABDT3= Total Diatoms cell carbon (ugC/l) ]
        Column # 5   [ ABDT1= Total dinoflagellates (#/ml) ]
        Column # 6   [ ABDT2= Total dinoflagellates cell volume (um3/l) ]
        Column # 7   [ ABDT3= Total dinoflagellates cell carbon (ugC/l) ]
        Column # 8   [ ABDT1= Other phytoplankton (#/l) ]
        Column # 9   [ ABDT2= Other phytoplanktons cell volume (um3/l) ]
        Column # 10   [ ABDT3= Other phytoplanktons cell carbon (ugC/l) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 14   [ OTHR= pH () ]

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

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

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/ml) ]
        column # 5     [ ABDT1= Total dinoflagellates (#/ml) ]
        column # 8     [ ABDT1= Other phytoplankton (#/l) ]

    Category 8 Group # 2
        column # 3     [ ABDT2= Total Diatoms cell volume (ml/m3) ]
        column # 6     [ ABDT2= Total dinoflagellates cell volume (um3/l) ]
        column # 9     [ ABDT2= Other phytoplanktons cell volume (um3/l) ]

    Category 8 Group # 3
        column # 4     [ ABDT3= Total Diatoms cell carbon (ugC/l) ]
        column # 7     [ ABDT3= Total dinoflagellates cell carbon (ugC/l) ]
        column # 10     [ ABDT3= Other phytoplanktons cell carbon (ugC/l) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1992 2013
DATES in Column 11 no problems detected 1973 2018

 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 1 31 1992 2013
11 DATE-MDY DATE-MDY yes 1 12 1 31 1973 2018


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 (#/ml) ] 		no problems detected 1301 0.600000024 11009.6709 1296
( 99 %)		 1292
( 99 %)
Column 3 :
[ 05_ABDT2= Total Diatoms cell volume (ml/m3) ] 		no problems detected 1301 6.99999975E-04 29.2085991 1288
( 99 %)		 473
( 36 %)
Column 4 :
[ 06_ABDT3= Total Diatoms cell carbon (ugC/l) ] 		no problems detected 1301 9.00000036E-02 1416.50000 1286
( 98 %)		 1277
( 98 %)
Column 5 :
[ 07_ABDT1= Total dinoflagellates (#/ml) ] 		no problems detected 1301 0.100000001 638.708008 889
( 68 %)		 587
( 45 %)
Column 6 :
[ 08_ABDT2= Total dinoflagellates cell volume (um3/l) ] 		no problems detected 1301 1.20000004E-05 185.266113 871
( 66 %)		 104
( 7 %)
Column 7 :
[ 09_ABDT3= Total dinoflagellates cell carbon (ugC/l) ] 		no problems detected 1301 9.99999978E-03 627.450012 870
( 66 %)		 580
( 44 %)
Column 8 :
[ 10_ABDT1= Other phytoplankton (#/l) ] 		no problems detected 1301 30.0000000 127749248. 945
( 72 %)		 945
( 72 %)
Column 9 :
[ 11_ABDT2= Other phytoplanktons cell volume (um3/l) ] 		no problems detected 1301 3.00000011E-06 14.5094442 900
( 69 %)		 72
( 5 %)
Column 10 :
[ 12_ABDT3= Other phytoplanktons cell carbon (ugC/l) ] 		no problems detected 1301 1.99999996E-02 2735.30005 899
( 69 %)		 832
( 63 %)
Column 12 :
[ 13_TEMP= Temperature ( C ) ] 		no problems detected 3065 -3.00000000 23.2999992 2988
( 97 %)		 2915
( 95 %)
Column 13 :
[ 14_PSAL= Salinity () ] 		no problems detected 3027 23.6000004 33.3800011 3027
( 100 %)		 3027
( 100 %)
Column 14 :
[ 15_OTHR= pH () ] 		no problems detected 2691 7.42999983 9.69999981 2691
( 100 %)		 2691
( 100 %)
Column 15 :
[ 16_LOTH= NH4 (uM) ] 		no problems detected 2858 9.99999978E-03 61.2000008 2858
( 100 %)		 1952
( 68 %)
Column 16 :
[ 17_LOTH= NO2 (uM) ] 		no problems detected 3012 9.99999978E-03 6.01999998 3009
( 99 %)		 736
( 24 %)
Column 17 :
[ 18_LOTH= NO3 (uM) ] 		no problems detected 2938 9.99999978E-03 203.690002 2812
( 95 %)		 2017
( 68 %)
Column 18 :
[ 19_LOTH= DON (uM) ] 		no problems detected 1476 2.99999993E-02 72.0000000 1476
( 100 %)		 1462
( 99 %)
Column 19 :
[ 20_LOTH= DOP (uM) ] 		no problems detected 1397 9.99999978E-03 1.08000004 1397
( 100 %)		 1
( 0 %)
Column 20 :
[ 21_LOTH= PO4 (uM) ] 		no problems detected 3017 9.99999978E-03 28.6499996 3004
( 99 %)		 910
( 30 %)
Column 21 :
[ 22_LOTH= Si04 (uM) ] 		no problems detected 2992 9.99999978E-03 51.4300003 2957
( 98 %)		 2313
( 77 %)
Column 22 :
[ 23_CHLA= Chlorophyll (ug/l) ] 		no problems detected 2594 0.439999998 84.1100006 2594
( 100 %)		 2563
( 98 %)

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