COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2    [ABDT1= Bacillariophyta (mg/m3) from 0-10m]      ( date set 1 )
    Column # 3    [ABDT2= Bacillariophyta (#/L) from 0-10m]      ( date set 1 )
    Column # 4     [OTHR3= Bacillariophyta size (ug/individual) from 0-10m]      ( date set 1 )
    Column # 5    [ABDT1= Dinophyceae (mg/m3) from 0-10m]      ( date set 1 )
    Column # 6    [ABDT2= Dinophyceae (#/L) from 0-10m]      ( date set 1 )
    Column # 7    [OTHR3= Dinophyceae size (ug/individual) from 0-10m]      ( date set 1 )

    Column # 8     [ DATE-YMD ]       Date Set = 2
    Column # 9    [CHLA= Average Chlorophyll (mg/m3) from 0-10m]      ( date set 2 )
    Column # 10    [TEMP= Average Temperature ( C ) from 0-10m]      ( date set 2 )
    Column # 11    [PSAL= Average Salinity () from 0-10m]      ( date set 2 )
    Column # 12    [OTHR= Average Oxygen (ml/l) from 0-10m]      ( date set 2 )
    Column # 13    [LOTH= Average NO3 (mmol/m3) from 0-10m]      ( date set 2 )
    Column # 14    [LOTH= Average NO2 (mmol/m3) from 0-10m]      ( date set 2 )
    Column # 15    [LOTH= Average NH4 (mmol/m3) from 0-10m]      ( date set 2 )
    Column # 16    [LOTH= Average PO4 (mmol/m3) from 0-10m]      ( date set 2 )
    Column # 17    [LOTH= Average Si04 (mmol/m3) from 0-10m]      ( date set 2 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Bacillariophyta (mg/m3) from 0-10m ]
        Column # 3   [ ABDT2= Bacillariophyta (#/L) from 0-10m ]
        Column # 5   [ ABDT1= Dinophyceae (mg/m3) from 0-10m ]
        Column # 6   [ ABDT2= Dinophyceae (#/L) from 0-10m ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 13   [ LOTH= Average NO3 (mmol/m3) from 0-10m ]
        Column # 14   [ LOTH= Average NO2 (mmol/m3) from 0-10m ]
        Column # 15   [ LOTH= Average NH4 (mmol/m3) from 0-10m ]
        Column # 16   [ LOTH= Average PO4 (mmol/m3) from 0-10m ]
        Column # 17   [ LOTH= Average Si04 (mmol/m3) from 0-10m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 4   [ OTHR3= Bacillariophyta size (ug/individual) from 0-10m ]
        Column # 7   [ OTHR3= Dinophyceae size (ug/individual) from 0-10m ]
        Column # 12   [ OTHR= Average Oxygen (ml/l) from 0-10m ]

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

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

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

DATA SORTED BY GROUPING SETS:

    Category 6 Group # 3
        column # 4     [ OTHR3= Bacillariophyta size (ug/individual) from 0-10m ]
        column # 7     [ OTHR3= Dinophyceae size (ug/individual) from 0-10m ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Bacillariophyta (mg/m3) from 0-10m ]
        column # 5     [ ABDT1= Dinophyceae (mg/m3) from 0-10m ]

    Category 8 Group # 2
        column # 3     [ ABDT2= Bacillariophyta (#/L) from 0-10m ]
        column # 6     [ ABDT2= Dinophyceae (#/L) from 0-10m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1994 2016
DATES in Column 8 no problems detected 1994 2016

 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 2016 1 11 1 31
8 DATE-YMD DATE-YMD yes 1994 2016 1 11 1 31



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Bacillariophyta (mg/m3) from 0-10m ]
no problems detected 510 0.00700000022 20133.6035 507
( 99%)
485
( 95%)
Column 3 :
[ 05_ABDT2= Bacillariophyta (#/L) from 0-10m ]
no problems detected 510 40. 25315000. 507
( 99%)
507
( 99%)
Column 4 :
[06_OTHR3= Bacillariophyta size (ug/individual) from 0-10m ]
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")

  • 507 1.99999995E-05 0.525080025 507
    ( 100%)
    0
    ( 0%)
    Column 5 :
    [ 07_ABDT1= Dinophyceae (mg/m3) from 0-10m ]
    no problems detected 510 0.224000007 4822.99316 510
    ( 100%)
    509
    ( 99%)
    Column 6 :
    [ 08_ABDT2= Dinophyceae (#/L) from 0-10m ]
    no problems detected 510 80. 766788. 510
    ( 100%)
    510
    ( 100%)
    Column 7 :
    [09_OTHR3= Dinophyceae size (ug/individual) from 0-10m ]
    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")

  • 510 0.000190000006 0.071419999 510
    ( 100%)
    0
    ( 0%)
    Column 9 :
    [ 10_CHLA= Average Chlorophyll (mg/m3) from 0-10m ]
    no problems detected 481 0.291667014 22.9699993 481
    ( 100%)
    413
    ( 85%)
    Column 10 :
    [ 11_TEMP= Average Temperature ( C ) from 0-10m ]
    no problems detected 507 -0.517414987 23.0435009 504
    ( 99%)
    481
    ( 94%)
    Column 11 :
    [ 12_PSAL= Average Salinity () from 0-10m ]
    no problems detected 509 7.37282991 20.7455006 509
    ( 100%)
    509
    ( 100%)
    Column 12 :
    [ 13_OTHR= Average Oxygen (ml/l) from 0-10m ]
    no problems detected 504 5.26669979 10.4141998 504
    ( 100%)
    504
    ( 100%)
    Column 13 :
    [ 14_LOTH= Average NO3 (mmol/m3) from 0-10m ]
    no problems detected 466 8.90688E-07 11.7792997 466
    ( 100%)
    141
    ( 30%)
    Column 14 :
    [ 15_LOTH= Average NO2 (mmol/m3) from 0-10m ]
    no problems detected 466 0.00100000005 1.57000005 466
    ( 100%)
    18
    ( 3%)
    Column 15 :
    [ 16_LOTH= Average NH4 (mmol/m3) from 0-10m ]
    no problems detected 118 0.00100000005 3.6398201 118
    ( 100%)
    2
    ( 1%)
    Column 16 :
    [ 17_LOTH= Average PO4 (mmol/m3) from 0-10m ]
    no problems detected 467 1.03379998E-05 1.28658998 467
    ( 100%)
    1
    ( 0%)
    Column 17 :
    [ 18_LOTH= Average Si04 (mmol/m3) from 0-10m ]
    no problems detected 466 0.400000006 26.3115997 466
    ( 100%)
    449
    ( 96%)

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