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 Copepoda (mg-WW/m2)]      ( date set 1 )
    Column # 3    [ABDT1= Total Cladocera (mg-WW/m2)]      ( date set 1 )
    Column # 4    [ABDT1= Total Gelatinous (mg-WW/m2)]      ( date set 1 )
    Column # 5    [ABDT1= Total Meroplanktonic Larvae (mg-WW/m2)]      ( date set 1 )
    Column # 6    [ABDT1= Total Rotatoria (mg-WW/m2)]      ( date set 1 )

    Column # 7     [ DATE-MDY ]       Date Set = 2
    Column # 8    [ABDT2= Total Diatoms (mg-WW/m3)]      ( date set 2 )
    Column # 9    [ABDT2= Total Dinoflagellates (mg-WW/m3)]      ( date set 2 )

    Column # 10     [ DATE-MDY ]       Date Set = 3
    Column # 11    [CHLA= Average Chlorophyll (mg/m3) from 0-10m]      ( date set 3 )
    Column # 12    [LOTH= Average NO2 (umol-N/L) from 0-10m]      ( date set 3 )
    Column # 13    [LOTH= Average NO3NO2 (umol-N/L) from 0-10m]      ( date set 3 )
    Column # 14    [LOTH= Average NO3 (umol-N/L) from 0-10m]      ( date set 3 )
    Column # 15    [OTHR= Average Oxygen (ml) from 0-10m]      ( date set 3 )
    Column # 16    [LOTH= Average PO4 (umol-P/L) from 0-10m]      ( date set 3 )
    Column # 17    [PSAL= Average Salinity () from 0-10m]      ( date set 3 )
    Column # 18    [LOTH= Average SiO4 (umol-Si/L) from 0-10m]      ( date set 3 )
    Column # 19    [TEMP= Average Temperature ( C ) from 0-10m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepoda (mg-WW/m2) ]
        Column # 3   [ ABDT1= Total Cladocera (mg-WW/m2) ]
        Column # 4   [ ABDT1= Total Gelatinous (mg-WW/m2) ]
        Column # 5   [ ABDT1= Total Meroplanktonic Larvae (mg-WW/m2) ]
        Column # 6   [ ABDT1= Total Rotatoria (mg-WW/m2) ]
        Column # 8   [ ABDT2= Total Diatoms (mg-WW/m3) ]
        Column # 9   [ ABDT2= Total Dinoflagellates (mg-WW/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 12   [ LOTH= Average NO2 (umol-N/L) from 0-10m ]
        Column # 13   [ LOTH= Average NO3NO2 (umol-N/L) from 0-10m ]
        Column # 14   [ LOTH= Average NO3 (umol-N/L) from 0-10m ]
        Column # 16   [ LOTH= Average PO4 (umol-P/L) from 0-10m ]
        Column # 18   [ LOTH= Average SiO4 (umol-Si/L) from 0-10m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 15   [ OTHR= Average Oxygen (ml) from 0-10m ]

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

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

    Chlorophyll/Pigments Category
        Column # 11   [ CHLA= Average Chlorophyll (mg/m3) from 0-10m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepoda (mg-WW/m2) ]
        column # 3     [ ABDT1= Total Cladocera (mg-WW/m2) ]
        column # 4     [ ABDT1= Total Gelatinous (mg-WW/m2) ]
        column # 5     [ ABDT1= Total Meroplanktonic Larvae (mg-WW/m2) ]
        column # 6     [ ABDT1= Total Rotatoria (mg-WW/m2) ]

    Category 8 Group # 2
        column # 8     [ ABDT2= Total Diatoms (mg-WW/m3) ]
        column # 9     [ ABDT2= Total Dinoflagellates (mg-WW/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1993 2015
DATES in Column 7 no problems detected 1993 2015
DATES in Column 10 no problems detected 1993 2015

 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 1993 2015
7 DATE-MDY DATE-MDY yes 1 11 1 31 1993 2015
10 DATE-MDY DATE-MDY yes 1 12 1 31 1993 2015



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepoda (mg-WW/m2) ]
no problems detected 242 13. 35740. 242
( 100%)
242
( 100%)
Column 3 :
[ 05_ABDT1= Total Cladocera (mg-WW/m2) ]
no problems detected 242 1. 18587. 203
( 83%)
199
( 82%)
Column 4 :
[ 06_ABDT1= Total Gelatinous (mg-WW/m2) ]
no problems detected 242 1. 1271. 183
( 75%)
182
( 75%)
Column 5 :
[ 07_ABDT1= Total Meroplanktonic Larvae (mg-WW/m2) ]
no problems detected 242 2. 4509. 232
( 95%)
232
( 95%)
Column 6 :
[ 08_ABDT1= Total Rotatoria (mg-WW/m2) ]
no problems detected 242 1. 56089. 242
( 100%)
241
( 99%)
Column 8 :
[ 09_ABDT2= Total Diatoms (mg-WW/m3) ]
no problems detected 225 0.400000006 68252. 222
( 98%)
219
( 97%)
Column 9 :
[ 10_ABDT2= Total Dinoflagellates (mg-WW/m3) ]
no problems detected 239 18. 67723.1016 237
( 99%)
237
( 99%)
Column 11 :
[ 11_CHLA= Average Chlorophyll (mg/m3) from 0-10m ]
no problems detected 238 0.25999999 28.9382534 238
( 100%)
221
( 92%)
Column 12 :
[ 12_LOTH= Average NO2 (umol-N/L) from 0-10m ]
no problems detected 101 0.00333333295 0.263333321 89
( 88%)
0
( 0%)
Column 13 :
[ 13_LOTH= Average NO3NO2 (umol-N/L) from 0-10m ]
no problems detected 148 0.001190476 9.71809483 138
( 93%)
31
( 20%)
Column 14 :
[ 14_LOTH= Average NO3 (umol-N/L) from 0-10m ]
no problems detected 101 0.00333333295 9.46333313 98
( 97%)
23
( 22%)
Column 15 :
[ 15_OTHR= Average Oxygen (ml) from 0-10m ]
no problems detected 225 3.53200006 12.333333 224
( 99%)
224
( 99%)
Column 16 :
[ 16_LOTH= Average PO4 (umol-P/L) from 0-10m ]
no problems detected 246 0.00999999978 1.10419357 245
( 99%)
3
( 1%)
Column 17 :
[ 17_PSAL= Average Salinity () from 0-10m ]
no problems detected 245 4.47293663 6.76333332 245
( 100%)
245
( 100%)
Column 18 :
[ 18_LOTH= Average SiO4 (umol-Si/L) from 0-10m ]
no problems detected 248 0.272023797 19.5298805 248
( 100%)
243
( 97%)
Column 19 :
[ 19_TEMP= Average Temperature ( C ) from 0-10m ]
no problems detected 245 -0.00737500004 20.3633327 244
( 99%)
238
( 97%)

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