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-YMD ]       Date Set = 2
    Column # 8     [TEMP= Temperature ( C ) at 10m]      ( date set 2 )
    Column # 9     [PSAL= Salinity () at 10m]      ( date set 2 )
    Column # 10     [CHLA= Chlorophyll (mg/m3) at 10m]      ( date set 2 )

    Column # 11     [ DATE-DMY ]       Date Set = 3
    Column # 12     [OTHR= Light attenuation (m-1) at 5 m]      ( date set 3 )
    Column # 13     [LOTH= Nitrate (mmol/m3) at 5 m]      ( date set 3 )
    Column # 14     [LOTH= Silicate (mmol/m3) at 5 m]      ( date set 3 )
    Column # 15     [LOTH= Phosphate (mmol/m3) at 5 m]      ( date set 3 )
    Column # 16     [LOTH= Nitrite (mmol/m3) at 5 m]      ( date set 3 )
    Column # 17     [LOTH= Ammonium (mmol/m3) at 5 m]      ( date set 3 )
    Column # 18     [LOTH= POC (ug/L) at 5 m]      ( date set 3 )
    Column # 19     [LOTH= PON (ug/L) at 5 m]      ( date set 3 )

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


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 ]

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

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

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




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 1999 2022
DATES in Column 11 no problems detected 1967 2010
DATES in Column 20 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-YMD DATE-YMD yes 1999 2022 4 10 15 15
11 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
20 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.000 8296585.00 885
( 100 %)
885
( 100 %)
Column 3 :
[ 05_ABDT= Synechococcus (cells/ml) at 5 m ]
no problems detected 842 2.00000000 494868.000 842
( 100 %)
842
( 100 %)
Column 4 :
[ 06_ABDT= Picoeukaryotes (cells/ml) at 5 m ]
no problems detected 848 83.0000000 184350.000 848
( 100 %)
848
( 100 %)
Column 5 :
[ 07_ABDT= Picophytoplankton (cells/ml) at 5 m ]
no problems detected 848 185.000000 575824.000 848
( 100 %)
848
( 100 %)
Column 6 :
[ 08_ABDT= Nanophytoplankton (cells/ml) at 5 m ]
no problems detected 848 297.000000 91743.0000 848
( 100 %)
848
( 100 %)
Column 8 :
[ 09_TEMP= Temperature ( C ) at 10m ]
no problems detected 37 -0.520799994 17.3814430 35
( 94 %)
32
( 86 %)
Column 9 :
[ 10_PSAL= Salinity () at 10m ]
no problems detected 39 29.8333721 31.9114742 39
( 100 %)
39
( 100 %)
Column 10 :
[ 11_CHLA= Chlorophyll (mg/m3) at 10m ]
no problems detected 39 0.369050711 13.5832262 39
( 100 %)
25
( 64 %)
Column 12 :
[12_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 4.06999998E-02 0.942200005 839
    ( 100 %)
    0
    ( 0 %)
    Column 13 :
    [ 13_LOTH= Nitrate (mmol/m3) at 5 m ]
    no problems detected 1311 9.99999978E-03 12.4799995 1216
    ( 92 %)
    673
    ( 51 %)
    Column 14 :
    [ 14_LOTH= Silicate (mmol/m3) at 5 m ]
    no problems detected 1312 9.99999978E-03 20.0200005 1296
    ( 98 %)
    981
    ( 74 %)
    Column 15 :
    [ 15_LOTH= Phosphate (mmol/m3) at 5 m ]
    no problems detected 1312 2.99999993E-02 2.39000010 1312
    ( 100 %)
    286
    ( 21 %)
    Column 16 :
    [ 16_LOTH= Nitrite (mmol/m3) at 5 m ]
    no problems detected 745 9.99999978E-03 4.82000017 741
    ( 99 %)
    13
    ( 1 %)
    Column 17 :
    [ 17_LOTH= Ammonium (mmol/m3) at 5 m ]
    no problems detected 840 9.99999978E-03 11.3000002 835
    ( 99 %)
    377
    ( 44 %)
    Column 18 :
    [ 18_LOTH= POC (ug/L) at 5 m ]
    no problems detected 713 50.0000000 2485.00000 713
    ( 100 %)
    713
    ( 100 %)
    Column 19 :
    [ 19_LOTH= PON (ug/L) at 5 m ]
    no problems detected 713 9.00000000 311.000000 713
    ( 100 %)
    713
    ( 100 %)
    Column 21 :
    [ 20_CHLA9= HPLC Alloxanthin (ug/L) at 5 m ]
    no problems detected 734 8.00000038E-03 3.40520000 684
    ( 93 %)
    22
    ( 2 %)
    Column 22 :
    [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 9.20000020E-03 1.07299995 103
    ( 14 %)
    1
    ( 0 %)
    Column 23 :
    [ 22_CHLA9= HPLC Chlorophyll a (ug/L) at 5 m ]
    no problems detected 734 1.66999996E-02 34.7784004 729
    ( 99 %)
    626
    ( 85 %)
    Column 24 :
    [ 23_CHLA9= HPLC Chlorophyll b (ug/L) at 5 m ]
    no problems detected 734 3.10000009E-03 23.8101997 528
    ( 71 %)
    44
    ( 5 %)
    Column 25 :
    [ 24_CHLA9= HPLC Chlorophyll c1 + c2 (ug/L) at 5 m ]
    no problems detected 734 4.60000010E-03 4.95879984 699
    ( 95 %)
    143
    ( 19 %)
    Column 26 :
    [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 1.30000000E-03 0.758400023 213
    ( 29 %)
    0
    ( 0 %)
    Column 27 :
    [ 26_CHLA9= HPLC Diadinoxanthin (ug/L) at 5 m ]
    no problems detected 734 5.20000001E-03 5.76100016 664
    ( 90 %)
    29
    ( 3 %)
    Column 28 :
    [ 27_CHLA9= HPLC Fucoxanthin (ug/L) at 5 m ]
    no problems detected 734 2.32999995E-02 11.0697002 719
    ( 97 %)
    287
    ( 39 %)
    Column 29 :
    [ 28_CHLA9= HPLC 19-Hexanoyloxyfucoxanthin (ug/L) at 5 m ]
    no problems detected 734 3.00000003E-03 3.89820004 255
    ( 34 %)
    8
    ( 1 %)
    Column 30 :
    [ 29_CHLA9= HPLC Peridinin (ug/L) at 5 m ]
    no problems detected 734 8.39999970E-03 18.2465992 337
    ( 45 %)
    36
    ( 4 %)
    Column 31 :
    [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 1.71000008E-02 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".