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

    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 ]

DATA SORTED BY GROUPING SETS:

    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.0000000 23627.0000 100
( 100 %)
100
( 100 %)
Column 3 :
[ 05_ABND1= Acartia longiremis (#/m3) ]
no problems detected 100 11.0000000 3089.00000 99
( 99 %)
99
( 99 %)
Column 4 :
[ 06_ABND1= Pseudocalanus minutus (#/m3) ]
no problems detected 100 10.0000000 8168.00000 100
( 100 %)
100
( 100 %)
Column 5 :
[ 07_ABND1= Temora longicornis (#/m3) ]
no problems detected 100 9.00000000 19361.0000 100
( 100 %)
100
( 100 %)
Column 6 :
[ 08_BIOM2= Acartia longiremis biomass (ug/m3) ]
no problems detected 99 1.00000000 51908.0000 99
( 100 %)
98
( 98 %)
Column 7 :
[ 09_BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
no problems detected 99 2.00000000 189806.000 99
( 100 %)
99
( 100 %)
Column 8 :
[ 10_BIOM2= Temora longicornis biomass (ug/m3) ]
no problems detected 99 1.00000000 245262.000 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.000000 65695.0000 38
( 100 %)
38
( 100 %)
Column 14 :
[ 15_BIOM= Total Wet Mass (mg/m3) ]
no problems detected 37 3.00000000 1010.00000 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 7.99999982E-02 4451.20996 196
( 99 %)
176
( 89 %)
Column 19 :
[ 19_ABND= Green Algae (ug/L) ]
no problems detected 197 5.00000007E-02 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.239990 72
( 100 %)
72
( 100 %)
Column 24 :
[ 24_ABND= Other heterotrophic (ug/L) ]
no problems detected 197 5.99999987E-02 922.010010 176
( 89 %)
157
( 79 %)
Column 26 :
[ 25_TEMP= Average Temperature (C) from 0-10 m ]
no problems detected 532 -0.286700010 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 3.29999998E-03 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 6.00000005E-03 24.9517002 269
( 97 %)
95
( 34 %)
Column 31 :
[ 30_LOTH= Average NO2 (uM) from 0-10 m ]
no problems detected 275 1.30000000E-03 0.745299995 234
( 85 %)
0
( 0 %)
Column 32 :
[ 31_LOTH= Average NH4 (uM) from 0-10 m ]
no problems detected 245 3.29999998E-03 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.0717010 224
( 100 %)
221
( 98 %)
Column 35 :
[ 34_CHLA= Average Chlorophyll-a (ug/L) from 0-10 m ]
no problems detected 515 9.25000012E-02 23.9333000 515
( 100 %)
436
( 84 %)
Column 36 :
[ 35_CHLA= Average Phaeopigment (ug/L) from 0-10 m ]
no problems detected 248 3.50000001E-02 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".