COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   15    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.




HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2     [ABDT1= Total Copepods (#/m2)]      ( date set 1 )
    Column # 3     [ABDT1= Total Calanus spp. (#/m2)]      ( date set 1 )
    Column # 4     [ABDT1= Total other Calanoid copepods (#/m2)]      ( date set 1 )
    Column # 5     [ABDT1= Total Cyclopoid copepods (#/m2)]      ( date set 1 )

    Column # 6     [ DATE-YMD ]       Date Set = 2
    Column # 7     [BIOM1= Total Dry Mass (g/m2)]      ( date set 2 )
    Column # 8     [BIOM1= Dry Mass 180-1000 um (g/m2)]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10     [ABDT5= Total Diatoms (#/l)]      ( date set 3 )

    Column # 11     [ DATE-YMD ]       Date Set = 4
    Column # 12     [ABDT5= Total Dinoflagellates (#/l)]      ( date set 4 )

    Column # 13     [ DATE-MDY ]       Date Set = 5
    Column # 14     [TEMP= Temperature ( C ) at 5m]      ( date set 5 )
    Column # 15     [PSAL= Salinity () at 5m]      ( date set 5 )
    Column # 16     [OTHR3= Oxygen (ml/l) at 5m]      ( date set 5 )
    Column # 17     [LOTH4= PO4 (uM) at 5m]      ( date set 5 )
    Column # 18     [LOTH5= NO2 (uM) at 5m]      ( date set 5 )
    Column # 19     [LOTH6= NO3 (um) at 5m]      ( date set 5 )
    Column # 20     [LOTH9= NO2NO3 (uM) at 5m]      ( date set 5 )
    Column # 21     [LOTH7= NH4 (uM) at 5m]      ( date set 5 )
    Column # 22     [LOTH8= SiO4 (uM) at 5m]      ( date set 5 )
    Column # 23     [CHLA1= Chlorophyll-a (mg/m3) at 5m]      ( date set 5 )
    Column # 24     [LOTH= Total-P (uM) at 5m]      ( date set 5 )
    Column # 25     [LOTH= Total-N (uM) at 5m]      ( date set 5 )
    Column # 26     [LOTH= Particulate P () at 5M]      ( date set 5 )
    Column # 27     [LOTH= Particulate N () at 5M]      ( date set 5 )
    Column # 28     [LOTH= Particulate C () at 5M]      ( date set 5 )

    Column # 29     [ DATE-MDY ]       Date Set = 6
    Column # 30     [TEMP= Temperature ( C ) at 10m]      ( date set 6 )
    Column # 31     [PSAL= Salinity () at 10m]      ( date set 6 )
    Column # 32     [OTHR3= Oxygen (ml/l) at 10m]      ( date set 6 )
    Column # 33     [LOTH4= PO4 (uM) at 10m]      ( date set 6 )
    Column # 34     [LOTH5= NO2 (uM) at 10m]      ( date set 6 )
    Column # 35     [LOTH6= NO3 (um) at 10m]      ( date set 6 )
    Column # 36     [LOTH9= NO2NO3 (uM) at 10m]      ( date set 6 )
    Column # 37     [LOTH7= NH4 (uM) at 10m]      ( date set 6 )
    Column # 38     [LOTH8= SiO4 (uM) at 10m]      ( date set 6 )
    Column # 39     [CHLA1= Chlorophyll-a (mg/m3) at 10m]      ( date set 6 )

    Column # 40     [ DATE-MDY ]       Date Set = 7
    Column # 41     [TEMP= Temperature ( C ) at 50m]      ( date set 7 )
    Column # 42     [PSAL= Salinity () at 50m]      ( date set 7 )
    Column # 43     [OTHR3= Oxygen (ml/l) at 50m]      ( date set 7 )
    Column # 44     [LOTH4= PO4 (uM) at 50m]      ( date set 7 )
    Column # 45     [LOTH5= NO2 (uM) at 50m]      ( date set 7 )
    Column # 46     [LOTH6= NO3 (um) at 50m]      ( date set 7 )
    Column # 47     [LOTH9= NO2NO3 (uM) at 50m]      ( date set 7 )
    Column # 48     [LOTH7= NH4 (uM) at 50m]      ( date set 7 )
    Column # 49     [LOTH8= SiO4 (uM) at 50m]      ( date set 7 )
    Column # 50     [CHLA1= Chlorophyll-a (mg/m3) at 50m]      ( date set 7 )

    Column # 51     [ DATE-MDY ]       Date Set = 8
    Column # 52     [TEMP= Average Temperature ( C ) from 0-75m]      ( date set 8 )
    Column # 53     [PSAL= Average Salinity () from 0-75m]      ( date set 8 )
    Column # 54     [OTHR3= Average Oxygen (ml/l) from 0-75m]      ( date set 8 )
    Column # 55     [LOTH4= Average PO4 (uM) from 0-75m]      ( date set 8 )
    Column # 56     [LOTH5= Average NO2 (uM) from 0-75m]      ( date set 8 )
    Column # 57     [LOTH6= Average NO3 (um) from 0-75m]      ( date set 8 )
    Column # 58     [LOTH9= Average NO2NO3 (uM) from 0-75m]      ( date set 8 )
    Column # 59     [LOTH7= Average NH4 (uM) from 0-75m]      ( date set 8 )
    Column # 60     [LOTH8= Average SiO4 (uM) from 0-75m]      ( date set 8 )
    Column # 61     [CHLA1= Average Chlorophyll-a (mg/m3) from 0-75m]      ( date set 8 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (#/m2) ]
        Column # 3   [ ABDT1= Total Calanus spp. (#/m2) ]
        Column # 4   [ ABDT1= Total other Calanoid copepods (#/m2) ]
        Column # 5   [ ABDT1= Total Cyclopoid copepods (#/m2) ]
        Column # 10   [ ABDT5= Total Diatoms (#/l) ]
        Column # 12   [ ABDT5= Total Dinoflagellates (#/l) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 16   [ OTHR3= Oxygen (ml/l) at 5m ]
        Column # 32   [ OTHR3= Oxygen (ml/l) at 10m ]
        Column # 43   [ OTHR3= Oxygen (ml/l) at 50m ]
        Column # 54   [ OTHR3= Average Oxygen (ml/l) from 0-75m ]

    Temperatures Category
        Column # 14   [ TEMP= Temperature ( C ) at 5m ]
        Column # 30   [ TEMP= Temperature ( C ) at 10m ]
        Column # 41   [ TEMP= Temperature ( C ) at 50m ]
        Column # 52   [ TEMP= Average Temperature ( C ) from 0-75m ]

    Salinities Category
        Column # 15   [ PSAL= Salinity () at 5m ]
        Column # 31   [ PSAL= Salinity () at 10m ]
        Column # 42   [ PSAL= Salinity () at 50m ]
        Column # 53   [ PSAL= Average Salinity () from 0-75m ]

DATA SORTED BY GROUPING SETS:

    Category 6 Group # 3
        column # 16     [ OTHR3= Oxygen (ml/l) at 5m ]
        column # 32     [ OTHR3= Oxygen (ml/l) at 10m ]
        column # 43     [ OTHR3= Oxygen (ml/l) at 50m ]
        column # 54     [ OTHR3= Average Oxygen (ml/l) from 0-75m ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (#/m2) ]
        column # 3     [ ABDT1= Total Calanus spp. (#/m2) ]
        column # 4     [ ABDT1= Total other Calanoid copepods (#/m2) ]
        column # 5     [ ABDT1= Total Cyclopoid copepods (#/m2) ]

    Category 8 Group # 5
        column # 10     [ ABDT5= Total Diatoms (#/l) ]
        column # 12     [ ABDT5= Total Dinoflagellates (#/l) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1994 2019
DATES in Column 6 no problems detected 1994 2019
DATES in Column 9 no problems detected 2000 2015
DATES in Column 11 no problems detected 2000 2015
DATES in Column 13 no problems detected 1994 2017
DATES in Column 29 no problems detected 1994 2017
DATES in Column 40 no problems detected 1994 2017
DATES in Column 51 no problems detected 1994 2017

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1994 2019 01 12 01 31
6 DATE-YMD DATE-YMD yes 1994 2019 01 12 01 31
9 DATE-YMD DATE-YMD yes 2000 2015 01 12 15 15
11 DATE-YMD DATE-YMD yes 2000 2015 01 12 15 15
13 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2017
29 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2017
40 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2017
51 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2017



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepods (#/m2) ]
no problems detected 535 600.000000 741888.000 535
( 100 %)
535
( 100 %)
Column 3 :
[ 05_ABDT1= Total Calanus spp. (#/m2) ]
no problems detected 535 16.0000000 171520.000 534
( 99 %)
534
( 99 %)
Column 4 :
[ 06_ABDT1= Total other Calanoid copepods (#/m2) ]
no problems detected 535 488.000000 485888.000 535
( 100 %)
535
( 100 %)
Column 5 :
[ 07_ABDT1= Total Cyclopoid copepods (#/m2) ]
no problems detected 535 16.0000000 284672.000 532
( 99 %)
532
( 99 %)
Column 7 :
[ 08_BIOM1= Total Dry Mass (g/m2) ]
no problems detected 530 8.00000038E-03 20.8959999 529
( 99 %)
218
( 41 %)
Column 8 :
[ 09_BIOM1= Dry Mass 180-1000 um (g/m2) ]
no problems detected 530 8.00000038E-03 20.1679993 529
( 99 %)
138
( 26 %)
Column 10 :
[ 10_ABDT5= Total Diatoms (#/l) ]
no problems detected 177 20.0000000 6960000.00 113
( 63 %)
113
( 63 %)
Column 12 :
[ 11_ABDT5= Total Dinoflagellates (#/l) ]
no problems detected 177 40.0000000 270000.000 142
( 80 %)
142
( 80 %)
Column 14 :
[ 12_TEMP= Temperature ( C ) at 5m ]
no problems detected 474 -0.342999995 21.7220001 472
( 99 %)
464
( 97 %)
Column 15 :
[ 13_PSAL= Salinity () at 5m ]
no problems detected 475 17.4969997 34.2039986 475
( 100 %)
475
( 100 %)
Column 16 :
[ 14_OTHR3= Oxygen (ml/l) at 5m ]
no problems detected 452 4.40999985 9.51000023 452
( 100 %)
452
( 100 %)
Column 17 :
[ 15_LOTH4= PO4 (uM) at 5m ]
no problems detected 454 9.99999978E-03 0.699999988 454
( 100 %)
0
( 0 %)
Column 18 :
[ 16_LOTH5= NO2 (uM) at 5m ]
no problems detected 454 9.99999978E-03 1.53999996 453
( 99 %)
6
( 1 %)
Column 19 :
[ 17_LOTH6= NO3 (um) at 5m ]
no problems detected 454 9.99999978E-03 15.1700001 454
( 100 %)
193
( 42 %)
Column 20 :
[ 18_LOTH9= NO2NO3 (uM) at 5m ]
no problems detected 454 2.99999993E-02 15.5400000 454
( 100 %)
200
( 44 %)
Column 21 :
[ 19_LOTH7= NH4 (uM) at 5m ]
no problems detected 304 3.99999991E-02 3.90000010 304
( 100 %)
48
( 15 %)
Column 22 :
[ 20_LOTH8= SiO4 (uM) at 5m ]
no problems detected 454 2.99999993E-02 13.8500004 454
( 100 %)
302
( 66 %)
Column 23 :
[ 21_CHLA1= Chlorophyll-a (mg/m3) at 5m ]
no problems detected 453 0.170000002 19.7000008 453
( 100 %)
275
( 60 %)
Column 24 :
[22_LOTH= Total-P (uM) at 5m ]
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")

  • 311 0.270000011 0.959999979 311
    ( 100 %)
    0
    ( 0 %)
    Column 25 :
    [23_LOTH= Total-N (uM) at 5m ]
    There is/are 1 count WARNING(S)!
    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")

  • 311 9.94999981 39.9199982 311
    ( 100 %)
    311
    ( 100 %)
    Column 26 :
    [24_LOTH= Particulate P () at 5M ]
    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")

  • 304 1.99999996E-02 0.500000000 304
    ( 100 %)
    0
    ( 0 %)
    Column 27 :
    [25_LOTH= Particulate N () at 5M ]
    There is/are 1 count WARNING(S)!
    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")

  • 299 0.360000014 7.32999992 299
    ( 100 %)
    265
    ( 88 %)
    Column 28 :
    [26_LOTH= Particulate C () at 5M ]
    There is/are 1 count WARNING(S)!
    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")

  • 297 4.13999987 57.2999992 297
    ( 100 %)
    297
    ( 100 %)
    Column 30 :
    [ 27_TEMP= Temperature ( C ) at 10m ]
    no problems detected 474 -7.00000022E-03 20.9260006 473
    ( 99 %)
    471
    ( 99 %)
    Column 31 :
    [ 28_PSAL= Salinity () at 10m ]
    no problems detected 475 18.0599995 34.2389984 475
    ( 100 %)
    475
    ( 100 %)
    Column 32 :
    [ 29_OTHR3= Oxygen (ml/l) at 10m ]
    no problems detected 452 4.71999979 9.02999973 452
    ( 100 %)
    452
    ( 100 %)
    Column 33 :
    [ 30_LOTH4= PO4 (uM) at 10m ]
    no problems detected 455 9.99999978E-03 0.730000019 455
    ( 100 %)
    0
    ( 0 %)
    Column 34 :
    [ 31_LOTH5= NO2 (uM) at 10m ]
    no problems detected 455 9.99999978E-03 1.58000004 454
    ( 99 %)
    8
    ( 1 %)
    Column 35 :
    [ 32_LOTH6= NO3 (um) at 10m ]
    no problems detected 455 9.99999978E-03 19.8199997 454
    ( 99 %)
    223
    ( 49 %)
    Column 36 :
    [ 33_LOTH9= NO2NO3 (uM) at 10m ]
    no problems detected 455 2.99999993E-02 20.3400002 455
    ( 100 %)
    239
    ( 52 %)
    Column 37 :
    [ 34_LOTH7= NH4 (uM) at 10m ]
    no problems detected 304 9.00000036E-02 2.55999994 304
    ( 100 %)
    62
    ( 20 %)
    Column 38 :
    [ 35_LOTH8= SiO4 (uM) at 10m ]
    no problems detected 455 3.99999991E-02 13.3000002 455
    ( 100 %)
    328
    ( 72 %)
    Column 39 :
    [ 36_CHLA1= Chlorophyll-a (mg/m3) at 10m ]
    no problems detected 453 0.159999996 17.0699997 453
    ( 100 %)
    258
    ( 56 %)
    Column 41 :
    [ 37_TEMP= Temperature ( C ) at 50m ]
    no problems detected 474 2.80699992 16.4410000 474
    ( 100 %)
    474
    ( 100 %)
    Column 42 :
    [ 38_PSAL= Salinity () at 50m ]
    no problems detected 475 31.2880001 35.0900002 475
    ( 100 %)
    475
    ( 100 %)
    Column 43 :
    [ 39_OTHR3= Oxygen (ml/l) at 50m ]
    no problems detected 452 4.25000000 8.18999958 452
    ( 100 %)
    452
    ( 100 %)
    Column 44 :
    [ 40_LOTH4= PO4 (uM) at 50m ]
    no problems detected 455 5.99999987E-02 0.829999983 455
    ( 100 %)
    0
    ( 0 %)
    Column 45 :
    [ 41_LOTH5= NO2 (uM) at 50m ]
    no problems detected 455 9.99999978E-03 2.10999990 455
    ( 100 %)
    8
    ( 1 %)
    Column 46 :
    [ 42_LOTH6= NO3 (um) at 50m ]
    no problems detected 455 0.100000001 16.6100006 455
    ( 100 %)
    372
    ( 81 %)
    Column 47 :
    [ 43_LOTH9= NO2NO3 (uM) at 50m ]
    no problems detected 455 0.170000002 16.8600006 455
    ( 100 %)
    408
    ( 89 %)
    Column 48 :
    [44_LOTH7= NH4 (uM) at 50m ]
    There is/are 1 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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 49 :
    [ 45_LOTH8= SiO4 (uM) at 50m ]
    no problems detected 455 0.620000005 9.21000004 455
    ( 100 %)
    447
    ( 98 %)
    Column 50 :
    [ 46_CHLA1= Chlorophyll-a (mg/m3) at 50m ]
    no problems detected 439 3.99999991E-02 4.80000019 439
    ( 100 %)
    30
    ( 6 %)
    Column 52 :
    [47_TEMP= Average Temperature ( C ) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3324 -0.568000019 21.8190002 3320
    ( 99 %)
    3297
    ( 99 %)
    Column 53 :
    [48_PSAL= Average Salinity () from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3331 16.7469997 35.1959991 3331
    ( 100 %)
    3331
    ( 100 %)
    Column 54 :
    [49_OTHR3= Average Oxygen (ml/l) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3170 4.25000000 10.0500002 3170
    ( 100 %)
    3170
    ( 100 %)
    Column 55 :
    [50_LOTH4= Average PO4 (uM) from 0-75m ]
    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")

  • 3192 9.99999978E-03 0.899999976 3192
    ( 100 %)
    0
    ( 0 %)
    Column 56 :
    [51_LOTH5= Average NO2 (uM) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3193 9.99999978E-03 2.77999997 3190
    ( 99 %)
    61
    ( 1 %)
    Column 57 :
    [52_LOTH6= Average NO3 (um) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3193 9.99999978E-03 22.7000008 3191
    ( 99 %)
    2005
    ( 62 %)
    Column 58 :
    [53_LOTH9= Average NO2NO3 (uM) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3193 2.99999993E-02 23.2600002 3193
    ( 100 %)
    2136
    ( 66 %)
    Column 59 :
    [54_LOTH7= Average NH4 (uM) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 1939 3.99999991E-02 4.80000019 1939
    ( 100 %)
    631
    ( 32 %)
    Column 60 :
    [55_LOTH8= Average SiO4 (uM) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 3193 2.99999993E-02 15.6300001 3193
    ( 100 %)
    2664
    ( 83 %)
    Column 61 :
    [56_CHLA1= Average Chlorophyll-a (mg/m3) from 0-75m ]
    There is/are 1 count WARNING(S)!
    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")

  • 2718 3.99999991E-02 19.7000008 2718
    ( 100 %)
    1047
    ( 38 %)

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