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= Bacteria (cells/ml) at 5 m]      ( date set 1 )
    Column # 3    [ABDT= Synechococcus (cells/ml) at 5 m]      ( date set 1 )
    Column # 4    [ABDT= Picoeukaryotes (cells/ml) at 5 m]      ( date set 1 )
    Column # 5    [ABDT= Picophytoplankton (cells/ml) at 5 m]      ( date set 1 )
    Column # 6    [ABDT= Nanophytoplankton (cells/ml) at 5 m]      ( date set 1 )

    Column # 7     [ DATE-DMY ]       Date Set = 2
    Column # 8    [TEMP= Temperature (C) at 5 m]      ( date set 2 )
    Column # 9    [PSAL= Salinity (psu) at 5 m]      ( date set 2 )
    Column # 10    [OTHR= Light attenuation (m-1) at 5 m]      ( date set 2 )
    Column # 11    [LOTH= Nitrate (mmol/m3) at 5 m]      ( date set 2 )
    Column # 12    [LOTH= Silicate (mmol/m3) at 5 m]      ( date set 2 )
    Column # 13    [LOTH= Phosphate (mmol/m3) at 5 m]      ( date set 2 )
    Column # 14    [LOTH= Nitrite (mmol/m3) at 5 m]      ( date set 2 )
    Column # 15    [LOTH= Ammonium (mmol/m3) at 5 m]      ( date set 2 )
    Column # 16    [LOTH= POC (ug/L) at 5 m]      ( date set 2 )
    Column # 17    [LOTH= PON (ug/L) at 5 m]      ( date set 2 )
    Column # 18    [CHLA= Chlorophyll (ug/L) at 5 m]      ( date set 2 )

    Column # 19     [ DATE-DMY ]       Date Set = 3
    Column # 20    [CHLA9= HPLC Alloxanthin (ug/L) at 5 m]      ( date set 3 )
    Column # 21    [CHLA9= HPLC 19-Butanoyloxyfucoxanthin (ug/L) at 5 m]      ( date set 3 )
    Column # 22    [CHLA9= HPLC Chlorophyll a (ug/L) at 5 m]      ( date set 3 )
    Column # 23    [CHLA9= HPLC Chlorophyll b (ug/L) at 5 m]      ( date set 3 )
    Column # 24    [CHLA9= HPLC Chlorophyll c1 + c2 (ug/L) at 5 m]      ( date set 3 )
    Column # 25    [CHLA9= HPLC Chlorophyll c3 (ug/L) at 5 m]      ( date set 3 )
    Column # 26    [CHLA9= HPLC Diadinoxanthin (ug/L) at 5 m]      ( date set 3 )
    Column # 27    [CHLA9= HPLC Fucoxanthin (ug/L) at 5 m]      ( date set 3 )
    Column # 28    [CHLA9= HPLC 19-Hexanoyloxyfucoxanthin (ug/L) at 5 m]      ( date set 3 )
    Column # 29    [CHLA9= HPLC Peridinin (ug/L) at 5 m]      ( date set 3 )
    Column # 30    [CHLA9= HPLC Prasinoxanthin (ug/L) at 5 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT= Bacteria (cells/ml) at 5 m ]
        Column # 3   [ ABDT= Synechococcus (cells/ml) at 5 m ]
        Column # 4   [ ABDT= Picoeukaryotes (cells/ml) at 5 m ]
        Column # 5   [ ABDT= Picophytoplankton (cells/ml) at 5 m ]
        Column # 6   [ ABDT= Nanophytoplankton (cells/ml) at 5 m ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 11   [ LOTH= Nitrate (mmol/m3) at 5 m ]
        Column # 12   [ LOTH= Silicate (mmol/m3) at 5 m ]
        Column # 13   [ LOTH= Phosphate (mmol/m3) at 5 m ]
        Column # 14   [ LOTH= Nitrite (mmol/m3) at 5 m ]
        Column # 15   [ LOTH= Ammonium (mmol/m3) at 5 m ]
        Column # 16   [ LOTH= POC (ug/L) at 5 m ]
        Column # 17   [ LOTH= PON (ug/L) at 5 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 10   [ OTHR= Light attenuation (m-1) at 5 m ]

    Temperatures Category
        Column # 8   [ TEMP= Temperature (C) at 5 m ]

    Salinities Category
        Column # 9   [ PSAL= Salinity (psu) at 5 m ]

    Chlorophyll/Pigments Category
        Column # 18   [ CHLA= Chlorophyll (ug/L) at 5 m ]
        Column # 20   [ CHLA9= HPLC Alloxanthin (ug/L) at 5 m ]
        Column # 21   [ CHLA9= HPLC 19-Butanoyloxyfucoxanthin (ug/L) at 5 m ]
        Column # 22   [ CHLA9= HPLC Chlorophyll a (ug/L) at 5 m ]
        Column # 23   [ CHLA9= HPLC Chlorophyll b (ug/L) at 5 m ]
        Column # 24   [ CHLA9= HPLC Chlorophyll c1 + c2 (ug/L) at 5 m ]
        Column # 25   [ CHLA9= HPLC Chlorophyll c3 (ug/L) at 5 m ]
        Column # 26   [ CHLA9= HPLC Diadinoxanthin (ug/L) at 5 m ]
        Column # 27   [ CHLA9= HPLC Fucoxanthin (ug/L) at 5 m ]
        Column # 28   [ CHLA9= HPLC 19-Hexanoyloxyfucoxanthin (ug/L) at 5 m ]
        Column # 29   [ CHLA9= HPLC Peridinin (ug/L) at 5 m ]
        Column # 30   [ CHLA9= HPLC Prasinoxanthin (ug/L) at 5 m ]

DATA SORTED BY GROUPING SETS:

    Category 3 Group # 9
        column # 20     [ CHLA9= HPLC Alloxanthin (ug/L) at 5 m ]
        column # 21     [ CHLA9= HPLC 19-Butanoyloxyfucoxanthin (ug/L) at 5 m ]
        column # 22     [ CHLA9= HPLC Chlorophyll a (ug/L) at 5 m ]
        column # 23     [ CHLA9= HPLC Chlorophyll b (ug/L) at 5 m ]
        column # 24     [ CHLA9= HPLC Chlorophyll c1 + c2 (ug/L) at 5 m ]
        column # 25     [ CHLA9= HPLC Chlorophyll c3 (ug/L) at 5 m ]
        column # 26     [ CHLA9= HPLC Diadinoxanthin (ug/L) at 5 m ]
        column # 27     [ CHLA9= HPLC Fucoxanthin (ug/L) at 5 m ]
        column # 28     [ CHLA9= HPLC 19-Hexanoyloxyfucoxanthin (ug/L) at 5 m ]
        column # 29     [ CHLA9= HPLC Peridinin (ug/L) at 5 m ]
        column # 30     [ CHLA9= HPLC Prasinoxanthin (ug/L) at 5 m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1967 2010
DATES in Column 7 no problems detected 1967 2010
DATES in Column 19 no problems detected 1967 2010

 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 00 99
7 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
19 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT= Bacteria (cells/ml) at 5 m ]
no problems detected 885 329799. 8296585. 885
( 100%)
885
( 100%)
Column 3 :
[ 05_ABDT= Synechococcus (cells/ml) at 5 m ]
no problems detected 842 2. 494868. 842
( 100%)
842
( 100%)
Column 4 :
[ 06_ABDT= Picoeukaryotes (cells/ml) at 5 m ]
no problems detected 848 83. 184350. 848
( 100%)
848
( 100%)
Column 5 :
[ 07_ABDT= Picophytoplankton (cells/ml) at 5 m ]
no problems detected 848 185. 575824. 848
( 100%)
848
( 100%)
Column 6 :
[ 08_ABDT= Nanophytoplankton (cells/ml) at 5 m ]
no problems detected 848 297. 91743. 848
( 100%)
848
( 100%)
Column 8 :
[ 09_TEMP= Temperature (C) at 5 m ]
no problems detected 1394 -0.620000005 19.7199993 1372
( 98%)
1270
( 91%)
Column 9 :
[ 10_PSAL= Salinity (psu) at 5 m ]
no problems detected 1065 21.1000004 31.3299999 1065
( 100%)
1065
( 100%)
Column 10 :
[11_OTHR= Light attenuation (m-1) at 5 m ]
There is/are 1 count WARNING(S)!

Some of your values are zero or "one".

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")

  • 839 0.0406999998 0.942200005 839
    ( 100%)
    0
    ( 0%)
    Column 11 :
    [ 12_LOTH= Nitrate (mmol/m3) at 5 m ]
    no problems detected 1311 0.00999999978 12.4799995 1216
    ( 92%)
    673
    ( 51%)
    Column 12 :
    [ 13_LOTH= Silicate (mmol/m3) at 5 m ]
    no problems detected 1312 0.00999999978 20.0200005 1296
    ( 98%)
    981
    ( 74%)
    Column 13 :
    [ 14_LOTH= Phosphate (mmol/m3) at 5 m ]
    no problems detected 1312 0.0299999993 2.3900001 1312
    ( 100%)
    286
    ( 21%)
    Column 14 :
    [ 15_LOTH= Nitrite (mmol/m3) at 5 m ]
    no problems detected 745 0.00999999978 4.82000017 741
    ( 99%)
    13
    ( 1%)
    Column 15 :
    [ 16_LOTH= Ammonium (mmol/m3) at 5 m ]
    no problems detected 840 0.00999999978 11.3000002 835
    ( 99%)
    377
    ( 44%)
    Column 16 :
    [ 17_LOTH= POC (ug/L) at 5 m ]
    no problems detected 713 50. 2485. 713
    ( 100%)
    713
    ( 100%)
    Column 17 :
    [ 18_LOTH= PON (ug/L) at 5 m ]
    no problems detected 713 9. 311. 713
    ( 100%)
    713
    ( 100%)
    Column 18 :
    [ 19_CHLA= Chlorophyll (ug/L) at 5 m ]
    no problems detected 1438 0.140000001 109.32 1438
    ( 100%)
    1278
    ( 88%)
    Column 20 :
    [ 20_CHLA9= HPLC Alloxanthin (ug/L) at 5 m ]
    no problems detected 734 0.00800000038 3.4052 684
    ( 93%)
    22
    ( 2%)
    Column 21 :
    [21_CHLA9= HPLC 19-Butanoyloxyfucoxanthin (ug/L) at 5 m ]
    There is/are 1 count WARNING(S)!

    Some of your values are zero or "one".

    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")

  • 734 0.0092000002 1.07299995 103
    ( 14%)
    1
    ( 0%)
    Column 22 :
    [ 22_CHLA9= HPLC Chlorophyll a (ug/L) at 5 m ]
    no problems detected 734 0.0166999996 34.7784004 729
    ( 99%)
    626
    ( 85%)
    Column 23 :
    [ 23_CHLA9= HPLC Chlorophyll b (ug/L) at 5 m ]
    no problems detected 734 0.00310000009 23.8101997 528
    ( 71%)
    44
    ( 5%)
    Column 24 :
    [ 24_CHLA9= HPLC Chlorophyll c1 + c2 (ug/L) at 5 m ]
    no problems detected 734 0.0046000001 4.95879984 699
    ( 95%)
    143
    ( 19%)
    Column 25 :
    [25_CHLA9= HPLC Chlorophyll c3 (ug/L) at 5 m ]
    There is/are 1 count WARNING(S)!

    Some of your values are zero or "one".

    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")

  • 734 0.0013 0.758400023 213
    ( 29%)
    0
    ( 0%)
    Column 26 :
    [ 26_CHLA9= HPLC Diadinoxanthin (ug/L) at 5 m ]
    no problems detected 734 0.00520000001 5.76100016 664
    ( 90%)
    29
    ( 3%)
    Column 27 :
    [ 27_CHLA9= HPLC Fucoxanthin (ug/L) at 5 m ]
    no problems detected 734 0.0232999995 11.0697002 719
    ( 97%)
    287
    ( 39%)
    Column 28 :
    [ 28_CHLA9= HPLC 19-Hexanoyloxyfucoxanthin (ug/L) at 5 m ]
    no problems detected 734 0.00300000003 3.89820004 255
    ( 34%)
    8
    ( 1%)
    Column 29 :
    [ 29_CHLA9= HPLC Peridinin (ug/L) at 5 m ]
    no problems detected 734 0.0083999997 18.2465992 337
    ( 45%)
    36
    ( 4%)
    Column 30 :
    [30_CHLA9= HPLC Prasinoxanthin (ug/L) at 5 m ]
    There is/are 1 count WARNING(S)!

    Some of your values are zero or "one".

    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")

  • 734 0.0171000008 0.465499997 96
    ( 13%)
    0
    ( 0%)

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