COPEPODITE Incoming Data Review
Fatal Format Issues:   none

    Mild Data Warnings (non-numeric values):   2    [ 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 Small Copepods (#/m3)]      ( date set 1 )
    Column # 3     [ABDT1= Total Small Calanoid Copepods (#/m3)]      ( date set 1 )
    Column # 4     [ABDT1= Acartia spp (#/m3)]      ( date set 1 )
    Column # 5     [ABDT1= Centropages spp (#/m3)]      ( date set 1 )
    Column # 6     [ABDT1= Pseudo-/Paracalanus spp (#/m3)]      ( date set 1 )
    Column # 7     [ABDT1= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 8     [ABDT1= Oithona spp (#/m3)]      ( date set 1 )

    Column # 9     [ DATE-YMD ]       Date Set = 2
    Column # 10     [ABDT1= Acartia spp. (#/m3)]      ( date set 2 )
    Column # 11     [ABDT1= Paracalanus and Pseudocalanus (#/m3)]      ( date set 2 )
    Column # 12     [ABDT1= Temora longicornis (#/m3)]      ( date set 2 )

    Column # 13     [ DATE-YMD ]       Date Set = 3
    Column # 14     [ABDT1= Oithona spp. (#/m3)]      ( date set 3 )

    Column # 15     [ DATE-MDY ]       Date Set = 4
    Column # 16     [ABDT= Total Bacillariophyceae (#/ml)]      ( date set 4 )
    Column # 17     [ABDT= Total Dinophyceae (#/ml)]      ( date set 4 )

    Column # 18     [ DATE-MDY ]       Date Set = 5
    Column # 19     [TEMP= Temperature (C)]      ( date set 5 )
    Column # 20     [PSAL= Salinity ()]      ( date set 5 )

    Column # 21     [ DATE-MDY ]       Date Set = 6
    Column # 22     [LOTH3= Phosphate (uMol/l)]      ( date set 6 )
    Column # 23     [LOTH3= Silicate (uMol/l)]      ( date set 6 )
    Column # 24     [LOTH3= Nitrate (uMol/l)]      ( date set 6 )
    Column # 25     [LOTH3= Nitrite (uMol/l)]      ( date set 6 )
    Column # 26     [LOTH3= NO3+NO2 (uMol/l)]      ( date set 6 )
    Column # 27     [LOTH3= Ammonium (uMol/l)]      ( date set 6 )
    Column # 28     [LOTH3= Dissolved Inorganic Nitrogen (uMol/l)]      ( date set 6 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Small Copepods (#/m3) ]
        Column # 3   [ ABDT1= Total Small Calanoid Copepods (#/m3) ]
        Column # 4   [ ABDT1= Acartia spp (#/m3) ]
        Column # 5   [ ABDT1= Centropages spp (#/m3) ]
        Column # 6   [ ABDT1= Pseudo-/Paracalanus spp (#/m3) ]
        Column # 7   [ ABDT1= Temora longicornis (#/m3) ]
        Column # 8   [ ABDT1= Oithona spp (#/m3) ]
        Column # 10   [ ABDT1= Acartia spp. (#/m3) ]
        Column # 11   [ ABDT1= Paracalanus and Pseudocalanus (#/m3) ]
        Column # 12   [ ABDT1= Temora longicornis (#/m3) ]
        Column # 14   [ ABDT1= Oithona spp. (#/m3) ]
        Column # 16   [ ABDT= Total Bacillariophyceae (#/ml) ]
        Column # 17   [ ABDT= Total Dinophyceae (#/ml) ]

    Temperatures Category
        Column # 19   [ TEMP= Temperature (C) ]

    Salinities Category
        Column # 20   [ PSAL= Salinity () ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Small Copepods (#/m3) ]
        column # 3     [ ABDT1= Total Small Calanoid Copepods (#/m3) ]
        column # 4     [ ABDT1= Acartia spp (#/m3) ]
        column # 5     [ ABDT1= Centropages spp (#/m3) ]
        column # 6     [ ABDT1= Pseudo-/Paracalanus spp (#/m3) ]
        column # 7     [ ABDT1= Temora longicornis (#/m3) ]
        column # 8     [ ABDT1= Oithona spp (#/m3) ]
        column # 10     [ ABDT1= Acartia spp. (#/m3) ]
        column # 11     [ ABDT1= Paracalanus and Pseudocalanus (#/m3) ]
        column # 12     [ ABDT1= Temora longicornis (#/m3) ]
        column # 14     [ ABDT1= Oithona spp. (#/m3) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1974 2018
DATES in Column 9 no problems detected 1975 2016
DATES in Column 13 no problems detected 1975 2016
DATES in Column 15 no problems detected 1962 2015
DATES in Column 18 no problems detected 1962 2018
DATES in Column 21 no problems detected 1962 2015

 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 1974 2018 01 12 01 31
9 DATE-YMD DATE-YMD yes 1975 2016 01 12 01 31
13 DATE-YMD DATE-YMD yes 1975 2016 01 12 1 31
15 DATE-MDY DATE-MDY yes 1 12 1 31 1962 2015
18 DATE-MDY DATE-MDY yes 1 12 1 31 1962 2018
21 DATE-MDY DATE-MDY yes 1 12 1 31 1962 2015


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Small Copepods (#/m3) ] 		no problems detected 5776 3.16000009 143576.188 5773
( 99 %)		 5773
( 99 %)
Column 3 :
[ 05_ABDT1= Total Small Calanoid Copepods (#/m3) ] 		no problems detected 5776 2.28999996 143576.188 5772
( 99 %)		 5772
( 99 %)
Column 4 :
[ 06_ABDT1= Acartia spp (#/m3) ] 		no problems detected 5776 0.790000021 44156.7305 5718
( 98 %)		 5715
( 98 %)
Column 5 :
[ 07_ABDT1= Centropages spp (#/m3) ] 		no problems detected 5776 0.330000013 13820.9697 4450
( 77 %)		 4418
( 76 %)
Column 6 :
[ 08_ABDT1= Pseudo-/Paracalanus spp (#/m3) ] 		no problems detected 5776 0.479999989 67950.8203 5750
( 99 %)		 5748
( 99 %)
Column 7 :
[ 09_ABDT1= Temora longicornis (#/m3) ] 		no problems detected 5776 0.500000000 104676.859 5588
( 96 %)		 5579
( 96 %)
Column 8 :
[ 10_ABDT1= Oithona spp (#/m3) ] 		no problems detected 5776 0.100000001 11883.4199 4839
( 83 %)		 4824
( 83 %)
Column 10 :
[ 11_ABDT1= Acartia spp. (#/m3) ] 		no problems detected 2260 0.189999998 32749.6660 2248
( 99 %)		 2246
( 99 %)
Column 11 :
[ 12_ABDT1= Paracalanus and Pseudocalanus (#/m3) ] 		no problems detected 2260 0.259999990 35313.0000 2252
( 99 %)		 2251
( 99 %)
Column 12 :
[ 13_ABDT1= Temora longicornis (#/m3) ] 		no problems detected 2260 2.99999993E-02 29013.0000 2188
( 96 %)		 2181
( 96 %)
Column 14 :
[ 14_ABDT1= Oithona spp. (#/m3) ] 		no problems detected 2260 0.200000003 10687.0000 2072
( 91 %)		 2040
( 90 %)
Column 16 :
[ 15_ABDT= Total Bacillariophyceae (#/ml) ] 		no problems detected 11336 3.99999991E-02 14611.2305 11336
( 100 %)		 10322
( 91 %)
Column 17 :
[ 16_ABDT= Total Dinophyceae (#/ml) ] 		no problems detected 10819 3.99999991E-02 4045.84009 10819
( 100 %)		 8159
( 75 %)
Column 19 :
[ 17_TEMP= Temperature (C) ] 		no problems detected 13570 -1.60000002 20.2000008 13541
( 99 %)		 13426
( 98 %)
Column 20 :
[ 18_PSAL= Salinity () ] 		no problems detected 13375 22.7450008 36.1059990 13375
( 100 %)		 13375
( 100 %)
Column 22 :
[ 19_LOTH3= Phosphate (uMol/l) ] 		no problems detected 11509 -0.189999998 8.07999992 11459
( 99 %)		 2368
( 20 %)
Column 23 :
[20_LOTH3= Silicate (uMol/l) ] 		There is/are 2 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")

    		•  10855 4.99999989E-03 44.5499992 10848
    ( 99 %)    		 9830
    ( 90 %)
    Column 24 :
    [ 21_LOTH3= Nitrate (uMol/l) ]     		no problems detected 11543 9.99999978E-03 138.199997 11543
    ( 100 %)    		 11023
    ( 95 %)
    Column 25 :
    [ 22_LOTH3= Nitrite (uMol/l) ]     		no problems detected 11618 -2.99999993E-02 6.30000019 11601
    ( 99 %)    		 3016
    ( 25 %)
    Column 26 :
    [ 23_LOTH3= NO3+NO2 (uMol/l) ]     		no problems detected 11601 4.99999989E-03 139.220001 11601
    ( 100 %)    		 11172
    ( 96 %)
    Column 27 :
    [ 24_LOTH3= Ammonium (uMol/l) ]     		no problems detected 11548 -0.100000001 32.0999985 11520
    ( 99 %)    		 9557
    ( 82 %)
    Column 28 :
    [ 25_LOTH3= Dissolved Inorganic Nitrogen (uMol/l) ]     		no problems detected 11520 9.99999978E-03 143.860001 11520
    ( 100 %)    		 11411
    ( 99 %)

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