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    [ABND1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABND1= Acartia longiremis (#/m3)]      ( date set 1 )
    Column # 4    [ABND1= Pseudocalanus minutus (#/m3)]      ( date set 1 )
    Column # 5    [ABND1= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 6    [BIOM2= Acartia longiremis biomass (ug/m3)]      ( date set 1 )
    Column # 7    [BIOM2= Pseudocalanus minutus biomass (ug/m3)]      ( date set 1 )
    Column # 8    [BIOM2= Temora longicornis biomass (ug/m3)]      ( date set 1 )
    Column # 9     [OTHR3= Acartia longiremis relative abundance (% of three)]      ( date set 1 )
    Column # 10     [OTHR3= Pseudocalanus minutus relative abundance (% of three)]      ( date set 1 )
    Column # 11     [OTHR3= Temora longicornis relative abundance (% of three)]      ( date set 1 )

    Column # 12     [ DATE-MDY ]       Date Set = 2
    Column # 13    [ABND= Total Abundance (#/m3)]      ( date set 2 )
    Column # 14    [BIOM= Total Wet Mass (mg/m3)]      ( date set 2 )

    Column # 15     [ DATE-YMD ]       Date Set = 3
    Column # 16    [ABND1= Total Diatoms (ug/l)]      ( date set 3 )
    Column # 17    [ABND1= Total Dinoflagellates (ug/L)]      ( date set 3 )
    Column # 18    [ABND= Cyanobacteria (ug/L)]      ( date set 3 )
    Column # 19    [ABND= Green Algae (ug/L)]      ( date set 3 )
    Column # 20    [ABND= Mesodinium rubrum (ug/L)]      ( date set 3 )
    Column # 21    [ABND= Other autotrophic (ug/L)]      ( date set 3 )
    Column # 22    [ABND= Heterotrophic Dinoflagellates (ug/L)]      ( date set 3 )
    Column # 23    [ABND= Ciliata (ug/L)]      ( date set 3 )
    Column # 24    [ABND= Other heterotrophic (ug/L)]      ( date set 3 )

    Column # 25     [ DATE-YMD ]       Date Set = 4
    Column # 26    [TEMP= Average Temperature (C) from 0-10 m]      ( date set 4 )
    Column # 27    [PSAL= Average Salinity (pss) from 0-10 m]      ( date set 4 )
    Column # 28    [LOTH= Average PO4 (uM) from 0-10 m]      ( date set 4 )
    Column # 29    [LOTH= Average Total P (uM) from 0-10 m]      ( date set 4 )
    Column # 30    [LOTH= Average NO3 (uM) from 0-10 m]      ( date set 4 )
    Column # 31    [LOTH= Average NO2 (uM) from 0-10 m]      ( date set 4 )
    Column # 32    [LOTH= Average NH4 (uM) from 0-10 m]      ( date set 4 )
    Column # 33    [LOTH= Average Total N (uM) from 0-10 m]      ( date set 4 )
    Column # 34    [LOTH= Average Si (uM) from 0-10 m]      ( date set 4 )
    Column # 35    [CHLA= Average Chlorophyll-a (ug/L) from 0-10 m]      ( date set 4 )
    Column # 36    [CHLA= Average Phaeopigment (ug/L) from 0-10 m]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 6   [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        Column # 7   [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        Column # 8   [ BIOM2= Temora longicornis biomass (ug/m3) ]
        Column # 14   [ BIOM= Total Wet Mass (mg/m3) ]

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]
        Column # 3   [ ABND1= Acartia longiremis (#/m3) ]
        Column # 4   [ ABND1= Pseudocalanus minutus (#/m3) ]
        Column # 5   [ ABND1= Temora longicornis (#/m3) ]
        Column # 13   [ ABND= Total Abundance (#/m3) ]
        Column # 16   [ ABND1= Total Diatoms (ug/l) ]
        Column # 17   [ ABND1= Total Dinoflagellates (ug/L) ]
        Column # 18   [ ABND= Cyanobacteria (ug/L) ]
        Column # 19   [ ABND= Green Algae (ug/L) ]
        Column # 20   [ ABND= Mesodinium rubrum (ug/L) ]
        Column # 21   [ ABND= Other autotrophic (ug/L) ]
        Column # 22   [ ABND= Heterotrophic Dinoflagellates (ug/L) ]
        Column # 23   [ ABND= Ciliata (ug/L) ]
        Column # 24   [ ABND= Other heterotrophic (ug/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 28   [ LOTH= Average PO4 (uM) from 0-10 m ]
        Column # 29   [ LOTH= Average Total P (uM) from 0-10 m ]
        Column # 30   [ LOTH= Average NO3 (uM) from 0-10 m ]
        Column # 31   [ LOTH= Average NO2 (uM) from 0-10 m ]
        Column # 32   [ LOTH= Average NH4 (uM) from 0-10 m ]
        Column # 33   [ LOTH= Average Total N (uM) from 0-10 m ]
        Column # 34   [ LOTH= Average Si (uM) from 0-10 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 9   [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        Column # 10   [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        Column # 11   [ OTHR3= Temora longicornis relative abundance (% of three) ]

    Temperatures Category
        Column # 26   [ TEMP= Average Temperature (C) from 0-10 m ]

    Salinities Category
        Column # 27   [ PSAL= Average Salinity (pss) from 0-10 m ]

    Chlorophyll/Pigments Category
        Column # 35   [ CHLA= Average Chlorophyll-a (ug/L) from 0-10 m ]
        Column # 36   [ CHLA= Average Phaeopigment (ug/L) from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 2
        column # 6     [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        column # 7     [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        column # 8     [ BIOM2= Temora longicornis biomass (ug/m3) ]

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]
        column # 3     [ ABND1= Acartia longiremis (#/m3) ]
        column # 4     [ ABND1= Pseudocalanus minutus (#/m3) ]
        column # 5     [ ABND1= Temora longicornis (#/m3) ]
        column # 16     [ ABND1= Total Diatoms (ug/l) ]
        column # 17     [ ABND1= Total Dinoflagellates (ug/L) ]

    Category 6 Group # 3
        column # 9     [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        column # 10     [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        column # 11     [ OTHR3= Temora longicornis relative abundance (% of three) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1986 2010
DATES in Column 12 no problems detected 2002 2010
DATES in Column 15 no problems detected 1987 2010
DATES in Column 25 no problems detected 1977 2010

 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 2 12 1 31 1986 2010
12 DATE-MDY DATE-MDY yes 3 11 1 31 2002 2010
15 DATE-YMD DATE-YMD yes 1987 2010 01 12 01 31
25 DATE-YMD DATE-YMD yes 1977 2010 01 12 01 31


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABND1= Total Copepods (#/m3) ] 		no problems detected 100 81. 23627. 100
( 100%)		 100
( 100%)
Column 3 :
[ 05_ABND1= Acartia longiremis (#/m3) ] 		no problems detected 100 11. 3089. 99
( 99%)		 99
( 99%)
Column 4 :
[ 06_ABND1= Pseudocalanus minutus (#/m3) ] 		no problems detected 100 10. 8168. 100
( 100%)		 100
( 100%)
Column 5 :
[ 07_ABND1= Temora longicornis (#/m3) ] 		no problems detected 100 9. 19361. 100
( 100%)		 100
( 100%)
Column 6 :
[ 08_BIOM2= Acartia longiremis biomass (ug/m3) ] 		no problems detected 99 1. 51908. 99
( 100%)		 98
( 98%)
Column 7 :
[ 09_BIOM2= Pseudocalanus minutus biomass (ug/m3) ] 		no problems detected 99 2. 189806. 99
( 100%)		 99
( 100%)
Column 8 :
[ 10_BIOM2= Temora longicornis biomass (ug/m3) ] 		no problems detected 99 1. 245262. 99
( 100%)		 97
( 97%)
Column 9 :
[ 11_OTHR3= Acartia longiremis relative abundance (% of three) ] 		no problems detected 100 0.733423114 72.4867706 99
( 99%)		 98
( 98%)
Column 10 :
[ 12_OTHR3= Pseudocalanus minutus relative abundance (% of three) ] 		no problems detected 100 3.37837839 95.2851334 100
( 100%)		 100
( 100%)
Column 11 :
[ 13_OTHR3= Temora longicornis relative abundance (% of three) ] 		no problems detected 100 1.85334408 96.6216202 100
( 100%)		 100
( 100%)
Column 13 :
[ 14_ABND= Total Abundance (#/m3) ] 		no problems detected 38 818. 65695. 38
( 100%)		 38
( 100%)
Column 14 :
[ 15_BIOM= Total Wet Mass (mg/m3) ] 		no problems detected 37 3. 1010. 37
( 100%)		 37
( 100%)
Column 16 :
[ 16_ABND1= Total Diatoms (ug/l) ] 		no problems detected 196 0.109999999 12295.1104 195
( 99%)		 192
( 97%)
Column 17 :
[ 17_ABND1= Total Dinoflagellates (ug/L) ] 		no problems detected 196 0.360000014 18942.8691 196
( 100%)		 195
( 99%)
Column 18 :
[ 18_ABND= Cyanobacteria (ug/L) ] 		no problems detected 197 0.0799999982 4451.20996 196
( 99%)		 176
( 89%)
Column 19 :
[ 19_ABND= Green Algae (ug/L) ] 		no problems detected 197 0.0500000007 10215.8604 191
( 96%)		 176
( 89%)
Column 20 :
[ 20_ABND= Mesodinium rubrum (ug/L) ] 		no problems detected 197 0.150000006 3860.94995 188
( 95%)		 181
( 91%)
Column 21 :
[ 21_ABND= Other autotrophic (ug/L) ] 		no problems detected 197 3.88000011 8055.81982 197
( 100%)		 197
( 100%)
Column 22 :
[ 22_ABND= Heterotrophic Dinoflagellates (ug/L) ] 		no problems detected 196 0.529999971 1541.06995 186
( 94%)		 182
( 92%)
Column 23 :
[ 23_ABND= Ciliata (ug/L) ] 		no problems detected 72 2.25999999 466.23999 72
( 100%)		 72
( 100%)
Column 24 :
[ 24_ABND= Other heterotrophic (ug/L) ] 		no problems detected 197 0.0599999987 922.01001 176
( 89%)		 157
( 79%)
Column 26 :
[ 25_TEMP= Average Temperature (C) from 0-10 m ] 		no problems detected 532 -0.28670001 22.6000004 526
( 98%)		 501
( 94%)
Column 27 :
[ 26_PSAL= Average Salinity (pss) from 0-10 m ] 		no problems detected 526 4.40999985 8.85000038 526
( 100%)		 526
( 100%)
Column 28 :
[ 27_LOTH= Average PO4 (uM) from 0-10 m ] 		no problems detected 382 0.00329999998 1.48670006 375
( 98%)		 3
( 0%)
Column 29 :
[ 28_LOTH= Average Total P (uM) from 0-10 m ] 		no problems detected 207 0.159999996 3.47670007 207
( 100%)		 30
( 14%)
Column 30 :
[ 29_LOTH= Average NO3 (uM) from 0-10 m ] 		no problems detected 275 0.00600000005 24.9517002 269
( 97%)		 95
( 34%)
Column 31 :
[ 30_LOTH= Average NO2 (uM) from 0-10 m ] 		no problems detected 275 0.0013 0.745299995 234
( 85%)		 0
( 0%)
Column 32 :
[ 31_LOTH= Average NH4 (uM) from 0-10 m ] 		no problems detected 245 0.00329999998 5.71000004 237
( 96%)		 57
( 23%)
Column 33 :
[ 32_LOTH= Average Total N (uM) from 0-10 m ] 		no problems detected 205 1.38999999 46.2332993 205
( 100%)		 205
( 100%)
Column 34 :
[ 33_LOTH= Average Si (uM) from 0-10 m ] 		no problems detected 224 0.284999996 34.071701 224
( 100%)		 221
( 98%)
Column 35 :
[ 34_CHLA= Average Chlorophyll-a (ug/L) from 0-10 m ] 		no problems detected 515 0.0925000012 23.9333 515
( 100%)		 436
( 84%)
Column 36 :
[ 35_CHLA= Average Phaeopigment (ug/L) from 0-10 m ] 		no problems detected 248 0.0350000001 14.8866997 248
( 100%)		 139
( 56%)

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