COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2     [ABDT= Total Bacillariophyta (#/ml)]      ( date set 1 )
    Column # 3     [BIOM= Total Bacillariophyta biomass (um3/L)]      ( date set 1 )

    Column # 4     [ DATE-DMY ]       Date Set = 2
    Column # 5     [ABDT= Total Chlorophyta (#/ml)]      ( date set 2 )
    Column # 6     [BIOM= Total Chlorophyta biomass (um3/L)]      ( date set 2 )

    Column # 7     [ DATE-DMY ]       Date Set = 3
    Column # 8     [ABDT= Total Chrysophyta (#/ml)]      ( date set 3 )
    Column # 9     [BIOM= Total Chrysophyta biomass (um3/L)]      ( date set 3 )

    Column # 10     [ DATE-DMY ]       Date Set = 4
    Column # 11     [ABDT= Total Ciliophora (#/ml)]      ( date set 4 )
    Column # 12     [BIOM= Total Ciliophora biomass (um3/L)]      ( date set 4 )

    Column # 13     [ DATE-DMY ]       Date Set = 5
    Column # 14     [ABDT= Total Cryptophyta (#/ml)]      ( date set 5 )
    Column # 15     [BIOM= Total Cryptophyta biomass (um3/L)]      ( date set 5 )

    Column # 16     [ DATE-DMY ]       Date Set = 6
    Column # 17     [ABDT= Total Cyanophyta (#/ml)]      ( date set 6 )
    Column # 18     [BIOM= Total Cyanophyta biomass (um3/L)]      ( date set 6 )

    Column # 19     [ DATE-DMY ]       Date Set = 7
    Column # 20     [ABDT= Total Dinophyta (#/ml)]      ( date set 7 )
    Column # 21     [BIOM= Total Dinophyta biomass (um3/L)]      ( date set 7 )

    Column # 22     [ DATE-DMY ]       Date Set = 8
    Column # 23     [ABDT= Total Euglenophyta (#/ml)]      ( date set 8 )
    Column # 24     [BIOM= Total Euglenophyta biomass (um3/L)]      ( date set 8 )

    Column # 25     [ DATE-DMY ]       Date Set = 9
    Column # 26     [ABDT= Total Eustigmatophyta (#/ml)]      ( date set 9 )
    Column # 27     [BIOM= Total Eustigmatophyta biomass (um3/L)]      ( date set 9 )

    Column # 28     [ DATE-DMY ]       Date Set = 10
    Column # 29     [ABDT= Total Haptophyta (#/ml)]      ( date set 10 )
    Column # 30     [BIOM= Total Haptophyta biomass (um3/L)]      ( date set 10 )

    Column # 31     [ DATE-DMY ]       Date Set = 11
    Column # 32     [ABDT= Total Prasinophyta (#/ml)]      ( date set 11 )
    Column # 33     [BIOM= Total Prasinophyta biomass (um3/L)]      ( date set 11 )

    Column # 34     [ DATE-DMY ]       Date Set = 12
    Column # 35     [ABDT= Total Raphidophyta (#/ml)]      ( date set 12 )
    Column # 36     [BIOM= Total Raphidophyta biomass (um3/L)]      ( date set 12 )

    Column # 37     [ DATE-MDY ]       Date Set = 13
    Column # 38     [TEMP= Temperature ( C ) at the surface.]      ( date set 13 )
    Column # 39     [PSAL= Salinity () at the surface.]      ( date set 13 )
    Column # 40     [OTHR= Dissolved Oxygen (mg/L) at the surface.]      ( date set 13 )
    Column # 41     [LOTH= NO3NO2 (uM) at the surface.]      ( date set 13 )
    Column # 42     [LOTH= NH4 (uM) at the surface.]      ( date set 13 )
    Column # 43     [LOTH= PO4 (uM) at the surface.]      ( date set 13 )
    Column # 44     [LOTH= SiO4 (uM) at the surface.]      ( date set 13 )
    Column # 45     [CHLA= Chlorophyll a (ug/L) at the surface.]      ( date set 13 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT= Total Bacillariophyta (#/ml) ]
        Column # 5   [ ABDT= Total Chlorophyta (#/ml) ]
        Column # 8   [ ABDT= Total Chrysophyta (#/ml) ]
        Column # 11   [ ABDT= Total Ciliophora (#/ml) ]
        Column # 14   [ ABDT= Total Cryptophyta (#/ml) ]
        Column # 17   [ ABDT= Total Cyanophyta (#/ml) ]
        Column # 20   [ ABDT= Total Dinophyta (#/ml) ]
        Column # 23   [ ABDT= Total Euglenophyta (#/ml) ]
        Column # 26   [ ABDT= Total Eustigmatophyta (#/ml) ]
        Column # 29   [ ABDT= Total Haptophyta (#/ml) ]
        Column # 32   [ ABDT= Total Prasinophyta (#/ml) ]
        Column # 35   [ ABDT= Total Raphidophyta (#/ml) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 40   [ OTHR= Dissolved Oxygen (mg/L) at the surface. ]

    Temperatures Category
        Column # 38   [ TEMP= Temperature ( C ) at the surface. ]

    Salinities Category
        Column # 39   [ PSAL= Salinity () at the surface. ]




DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1992 2014
DATES in Column 4 no problems detected 1992 2014
DATES in Column 7 no problems detected 1992 2012
DATES in Column 10 no problems detected 1992 2013
DATES in Column 13 no problems detected 1992 2014
DATES in Column 16 no problems detected 1992 2014
DATES in Column 19 no problems detected 1992 2014
DATES in Column 22 no problems detected 1992 2014
DATES in Column 25 no problems detected 1999 2014
DATES in Column 28 no problems detected 1992 2011
DATES in Column 31 no problems detected 1992 2014
DATES in Column 34 no problems detected 2003 2013
DATES in Column 37 no problems detected 1978 2014

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
4 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
7 DATE-DMY DATE-DMY yes 1 30 Apr Sep 1992 2012
10 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2013
13 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
16 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
19 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
22 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
25 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1999 2014
28 DATE-DMY DATE-DMY yes 1 26 Apr Sep 1992 2011
31 DATE-DMY DATE-DMY yes 1 31 Apr Sep 1992 2014
34 DATE-DMY DATE-DMY yes 1 31 Apr Sep 2003 2013
37 DATE-MDY DATE-MDY yes 1 12 1 31 1978 2014



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT= Total Bacillariophyta (#/ml) ]
no problems detected 333 0.600000024 1126206.50 333
( 100 %)
332
( 99 %)
Column 3 :
[ 05_BIOM= Total Bacillariophyta biomass (um3/L) ]
no problems detected 334 2227.69995 449346944. 334
( 100 %)
334
( 100 %)
Column 5 :
[ 06_ABDT= Total Chlorophyta (#/ml) ]
no problems detected 158 0.200000003 172000.000 158
( 100 %)
153
( 96 %)
Column 6 :
[ 07_BIOM= Total Chlorophyta biomass (um3/L) ]
no problems detected 159 6.00000000 1367062.75 159
( 100 %)
159
( 100 %)
Column 8 :
[ 08_ABDT= Total Chrysophyta (#/ml) ]
no problems detected 92 0.200000003 13144.9502 92
( 100 %)
84
( 91 %)
Column 9 :
[ 09_BIOM= Total Chrysophyta biomass (um3/L) ]
no problems detected 92 62.7999992 107789.398 92
( 100 %)
92
( 100 %)
Column 11 :
[ 10_ABDT= Total Ciliophora (#/ml) ]
no problems detected 90 0.200000003 175093.406 90
( 100 %)
71
( 78 %)
Column 12 :
[ 11_BIOM= Total Ciliophora biomass (um3/L) ]
no problems detected 91 837.700012 119318128. 91
( 100 %)
91
( 100 %)
Column 14 :
[ 12_ABDT= Total Cryptophyta (#/ml) ]
no problems detected 324 1.00000000 96262.6016 324
( 100 %)
323
( 99 %)
Column 15 :
[ 13_BIOM= Total Cryptophyta biomass (um3/L) ]
no problems detected 325 162.500000 13549696.0 325
( 100 %)
325
( 100 %)
Column 17 :
[ 14_ABDT= Total Cyanophyta (#/ml) ]
no problems detected 203 1.00000000 136945.500 203
( 100 %)
202
( 99 %)
Column 18 :
[ 15_BIOM= Total Cyanophyta biomass (um3/L) ]
no problems detected 203 10.6000004 360501.188 203
( 100 %)
203
( 100 %)
Column 20 :
[ 16_ABDT= Total Dinophyta (#/ml) ]
no problems detected 285 0.200000003 6278.39990 285
( 100 %)
261
( 91 %)
Column 21 :
[ 17_BIOM= Total Dinophyta biomass (um3/L) ]
no problems detected 286 134.000000 333848000. 286
( 100 %)
286
( 100 %)
Column 23 :
[ 18_ABDT= Total Euglenophyta (#/ml) ]
no problems detected 199 0.100000001 52500.0000 199
( 100 %)
153
( 76 %)
Column 24 :
[ 19_BIOM= Total Euglenophyta biomass (um3/L) ]
no problems detected 199 40.2999992 4468519.50 199
( 100 %)
199
( 100 %)
Column 26 :
[ 20_ABDT= Total Eustigmatophyta (#/ml) ]
no problems detected 228 123.599998 1438750.00 228
( 100 %)
228
( 100 %)
Column 27 :
[ 21_BIOM= Total Eustigmatophyta biomass (um3/L) ]
no problems detected 228 98.9000015 1654562.50 228
( 100 %)
228
( 100 %)
Column 29 :
[22_ABDT= Total Haptophyta (#/ml) ]
There is/are 3 count WARNING(S)!

All/most of your values are EMPTY (missing).
This variable will be ignored!


Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 4 14.3999996 92.0000000 4
    ( 100 %)
    4
    ( 100 %)
    Column 30 :
    [23_BIOM= Total Haptophyta biomass (um3/L) ]
    There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!


    Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 4 1262.90002 2620.00000 4
    ( 100 %)
    4
    ( 100 %)
    Column 32 :
    [ 24_ABDT= Total Prasinophyta (#/ml) ]
    no problems detected 224 0.200000003 31799.4004 224
    ( 100 %)
    212
    ( 94 %)
    Column 33 :
    [ 25_BIOM= Total Prasinophyta biomass (um3/L) ]
    no problems detected 225 64.0999985 3202340.25 225
    ( 100 %)
    225
    ( 100 %)
    Column 35 :
    [ 26_ABDT= Total Raphidophyta (#/ml) ]
    no problems detected 41 0.200000003 9600.00000 41
    ( 100 %)
    31
    ( 75 %)
    Column 36 :
    [ 27_BIOM= Total Raphidophyta biomass (um3/L) ]
    no problems detected 41 361.899994 2573760.00 41
    ( 100 %)
    41
    ( 100 %)
    Column 38 :
    [ 28_TEMP= Temperature ( C ) at the surface. ]
    no problems detected 1974 7.50000000 23.3999996 1974
    ( 100 %)
    1974
    ( 100 %)
    Column 39 :
    [ 29_PSAL= Salinity () at the surface. ]
    no problems detected 2054 8.30000019 33.0999985 2054
    ( 100 %)
    2054
    ( 100 %)
    Column 40 :
    [ 30_OTHR= Dissolved Oxygen (mg/L) at the surface. ]
    no problems detected 1287 5.69999981 13.6999998 1287
    ( 100 %)
    1287
    ( 100 %)
    Column 41 :
    [ 31_LOTH= NO3NO2 (uM) at the surface. ]
    no problems detected 336 0.100000001 95.8000031 330
    ( 98 %)
    322
    ( 95 %)
    Column 42 :
    [ 32_LOTH= NH4 (uM) at the surface. ]
    no problems detected 334 0.100000001 15.1999998 334
    ( 100 %)
    300
    ( 89 %)
    Column 43 :
    [ 33_LOTH= PO4 (uM) at the surface. ]
    no problems detected 336 0.300000012 13.6999998 336
    ( 100 %)
    331
    ( 98 %)
    Column 44 :
    [ 34_LOTH= SiO4 (uM) at the surface. ]
    no problems detected 336 1.39999998 213.000000 335
    ( 99 %)
    335
    ( 99 %)
    Column 45 :
    [ 35_CHLA= Chlorophyll a (ug/L) at the surface. ]
    no problems detected 1965 0.500000000 49.5000000 1965
    ( 100 %)
    1923
    ( 97 %)

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