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    [ABDT= Total Copepods (#/m2)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [ABDT1= Calanus finmarchicus C6F (#/m2)]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6    [ABDT1= Calanus finmarchicus C6M (#/m2)]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8    [ABDT1= Calanus finmarchicus C5 (#/m2)]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10    [ABDT1= Calanus finmarchicus C4 (#/m2)]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12    [ABDT1= Calanus finmarchicus C3 (#/m2)]      ( date set 6 )

    Column # 13     [ DATE-YMD ]       Date Set = 7
    Column # 14    [ABDT1= Calanus finmarchicus C2 (#/m2)]      ( date set 7 )

    Column # 15     [ DATE-YMD ]       Date Set = 8
    Column # 16    [ABDT1= Calanus finmarchicus C1 (#/m2)]      ( date set 8 )

    Column # 17     [ DATE-YMD ]       Date Set = 9
    Column # 18    [ABDT2= Calanus glacialis C6F (#/m2)]      ( date set 9 )

    Column # 19     [ DATE-YMD ]       Date Set = 10
    Column # 20    [ABDT2= Calanus glacialis C6M (#/m2)]      ( date set 10 )

    Column # 21     [ DATE-YMD ]       Date Set = 11
    Column # 22    [ABDT2= Calanus glacialis C5 (#/m2)]      ( date set 11 )

    Column # 23     [ DATE-YMD ]       Date Set = 12
    Column # 24    [ABDT2= Calanus glacialis C4 (#/m2)]      ( date set 12 )

    Column # 25     [ DATE-YMD ]       Date Set = 13
    Column # 26    [ABDT2= Calanus glacialis C3 (#/m2)]      ( date set 13 )

    Column # 27     [ DATE-YMD ]       Date Set = 14
    Column # 28    [ABDT2= Calanus glacialis C2 (#/m2)]      ( date set 14 )

    Column # 29     [ DATE-YMD ]       Date Set = 15
    Column # 30    [ABDT2= Calanus glacialis C1 (#/m2)]      ( date set 15 )

    Column # 31     [ DATE-YMD ]       Date Set = 16
    Column # 32    [ABDT3= Calanus hyperboreus C6F (#/m2)]      ( date set 16 )

    Column # 33     [ DATE-YMD ]       Date Set = 17
    Column # 34    [ABDT3= Calanus hyperboreus C6M (#/m2)]      ( date set 17 )

    Column # 35     [ DATE-YMD ]       Date Set = 18
    Column # 36    [ABDT3= Calanus hyperboreus C5 (#/m2)]      ( date set 18 )

    Column # 37     [ DATE-YMD ]       Date Set = 19
    Column # 38    [ABDT3= Calanus hyperboreus C4 (#/m2)]      ( date set 19 )

    Column # 39     [ DATE-YMD ]       Date Set = 20
    Column # 40    [ABDT3= Calanus hyperboreus C3 (#/m2)]      ( date set 20 )

    Column # 41     [ DATE-YMD ]       Date Set = 21
    Column # 42    [ABDT3= Calanus hyperboreus C2 (#/m2)]      ( date set 21 )

    Column # 43     [ DATE-YMD ]       Date Set = 22
    Column # 44    [ABDT3= Calanus hyperboreus C1 (#/m2)]      ( date set 22 )

    Column # 45     [ DATE-YMD ]       Date Set = 23
    Column # 46    [ABDT4= Oithona spp. (#/m2)]      ( date set 23 )

    Column # 47     [ DATE-YMD ]       Date Set = 24
    Column # 48    [TEMP= Average Temperature (C) from 0-50m]      ( date set 24 )
    Column # 49    [TEMP= Average Temperature (C) from 0-100m]      ( date set 24 )
    Column # 50    [PSAL= Average Salinity () from 0-50m]      ( date set 24 )
    Column # 51    [PSAL= Average Salinity () from 0-100m]      ( date set 24 )
    Column # 52    [CHLA= Integrated Chlorophyll (mg/m2) from 0-100m]      ( date set 24 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT= Total Copepods (#/m2) ]
        Column # 4   [ ABDT1= Calanus finmarchicus C6F (#/m2) ]
        Column # 6   [ ABDT1= Calanus finmarchicus C6M (#/m2) ]
        Column # 8   [ ABDT1= Calanus finmarchicus C5 (#/m2) ]
        Column # 10   [ ABDT1= Calanus finmarchicus C4 (#/m2) ]
        Column # 12   [ ABDT1= Calanus finmarchicus C3 (#/m2) ]
        Column # 14   [ ABDT1= Calanus finmarchicus C2 (#/m2) ]
        Column # 16   [ ABDT1= Calanus finmarchicus C1 (#/m2) ]
        Column # 18   [ ABDT2= Calanus glacialis C6F (#/m2) ]
        Column # 20   [ ABDT2= Calanus glacialis C6M (#/m2) ]
        Column # 22   [ ABDT2= Calanus glacialis C5 (#/m2) ]
        Column # 24   [ ABDT2= Calanus glacialis C4 (#/m2) ]
        Column # 26   [ ABDT2= Calanus glacialis C3 (#/m2) ]
        Column # 28   [ ABDT2= Calanus glacialis C2 (#/m2) ]
        Column # 30   [ ABDT2= Calanus glacialis C1 (#/m2) ]
        Column # 32   [ ABDT3= Calanus hyperboreus C6F (#/m2) ]
        Column # 34   [ ABDT3= Calanus hyperboreus C6M (#/m2) ]
        Column # 36   [ ABDT3= Calanus hyperboreus C5 (#/m2) ]
        Column # 38   [ ABDT3= Calanus hyperboreus C4 (#/m2) ]
        Column # 40   [ ABDT3= Calanus hyperboreus C3 (#/m2) ]
        Column # 42   [ ABDT3= Calanus hyperboreus C2 (#/m2) ]
        Column # 44   [ ABDT3= Calanus hyperboreus C1 (#/m2) ]
        Column # 46   [ ABDT4= Oithona spp. (#/m2) ]

    Temperatures Category
        Column # 48   [ TEMP= Average Temperature (C) from 0-50m ]
        Column # 49   [ TEMP= Average Temperature (C) from 0-100m ]

    Salinities Category
        Column # 50   [ PSAL= Average Salinity () from 0-50m ]
        Column # 51   [ PSAL= Average Salinity () from 0-100m ]

    Chlorophyll/Pigments Category
        Column # 52   [ CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 4     [ ABDT1= Calanus finmarchicus C6F (#/m2) ]
        column # 6     [ ABDT1= Calanus finmarchicus C6M (#/m2) ]
        column # 8     [ ABDT1= Calanus finmarchicus C5 (#/m2) ]
        column # 10     [ ABDT1= Calanus finmarchicus C4 (#/m2) ]
        column # 12     [ ABDT1= Calanus finmarchicus C3 (#/m2) ]
        column # 14     [ ABDT1= Calanus finmarchicus C2 (#/m2) ]
        column # 16     [ ABDT1= Calanus finmarchicus C1 (#/m2) ]

    Category 8 Group # 2
        column # 18     [ ABDT2= Calanus glacialis C6F (#/m2) ]
        column # 20     [ ABDT2= Calanus glacialis C6M (#/m2) ]
        column # 22     [ ABDT2= Calanus glacialis C5 (#/m2) ]
        column # 24     [ ABDT2= Calanus glacialis C4 (#/m2) ]
        column # 26     [ ABDT2= Calanus glacialis C3 (#/m2) ]
        column # 28     [ ABDT2= Calanus glacialis C2 (#/m2) ]
        column # 30     [ ABDT2= Calanus glacialis C1 (#/m2) ]

    Category 8 Group # 3
        column # 32     [ ABDT3= Calanus hyperboreus C6F (#/m2) ]
        column # 34     [ ABDT3= Calanus hyperboreus C6M (#/m2) ]
        column # 36     [ ABDT3= Calanus hyperboreus C5 (#/m2) ]
        column # 38     [ ABDT3= Calanus hyperboreus C4 (#/m2) ]
        column # 40     [ ABDT3= Calanus hyperboreus C3 (#/m2) ]
        column # 42     [ ABDT3= Calanus hyperboreus C2 (#/m2) ]
        column # 44     [ ABDT3= Calanus hyperboreus C1 (#/m2) ]

    Category 8 Group # 4
        column # 46     [ ABDT4= Oithona spp. (#/m2) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1995 2016
DATES in Column 3 no problems detected 1995 2016
DATES in Column 5 no problems detected 1995 2016
DATES in Column 7 no problems detected 1995 2016
DATES in Column 9 no problems detected 1995 2016
DATES in Column 11 no problems detected 1995 2016
DATES in Column 13 no problems detected 1995 2016
DATES in Column 15 no problems detected 1995 2016
DATES in Column 17 no problems detected 1995 2016
DATES in Column 19 no problems detected 1995 2016
DATES in Column 21 no problems detected 1995 2016
DATES in Column 23 no problems detected 1995 2016
DATES in Column 25 no problems detected 1995 2016
DATES in Column 27 no problems detected 1995 2016
DATES in Column 29 no problems detected 1995 2016
DATES in Column 31 no problems detected 1995 2016
DATES in Column 33 no problems detected 1995 2016
DATES in Column 35 no problems detected 1995 2016
DATES in Column 37 no problems detected 1995 2016
DATES in Column 39 no problems detected 1995 2016
DATES in Column 41 no problems detected 1995 2016
DATES in Column 43 no problems detected 1995 2016
DATES in Column 45 no problems detected 1995 2016
DATES in Column 47 no problems detected 1995 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 1995 2016 5 7 15 15
3 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
5 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
7 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
9 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
11 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
13 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
15 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
17 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
19 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
21 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
23 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
25 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
27 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
29 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
31 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
33 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
35 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
37 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
39 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
41 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
43 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
45 DATE-YMD DATE-YMD yes 1995 2016 5 7 15 15
47 DATE-YMD DATE-YMD yes 1995 2016 05 05 15 15



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT= Total Copepods (#/m2) ]
no problems detected 21 22195.3438 157559. 21
( 100%)
21
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus C6F (#/m2) ]
no problems detected 21 379.357147 12052.5801 21
( 100%)
21
( 100%)
Column 6 :
[ 06_ABDT1= Calanus finmarchicus C6M (#/m2) ]
no problems detected 21 6.45714283 411.704163 19
( 90%)
19
( 90%)
Column 8 :
[ 07_ABDT1= Calanus finmarchicus C5 (#/m2) ]
no problems detected 21 113. 2625.47437 21
( 100%)
21
( 100%)
Column 10 :
[ 08_ABDT1= Calanus finmarchicus C4 (#/m2) ]
no problems detected 21 20.985714 10589.7139 20
( 95%)
20
( 95%)
Column 12 :
[ 09_ABDT1= Calanus finmarchicus C3 (#/m2) ]
no problems detected 21 20.9050007 8523.75098 18
( 85%)
18
( 85%)
Column 14 :
[ 10_ABDT1= Calanus finmarchicus C2 (#/m2) ]
no problems detected 21 161.987839 11138.249 18
( 85%)
18
( 85%)
Column 16 :
[ 11_ABDT1= Calanus finmarchicus C1 (#/m2) ]
no problems detected 21 16.3850002 22564.9863 21
( 100%)
21
( 100%)
Column 18 :
[ 12_ABDT2= Calanus glacialis C6F (#/m2) ]
no problems detected 21 47.4599991 784.306213 21
( 100%)
21
( 100%)
Column 20 :
[ 13_ABDT2= Calanus glacialis C6M (#/m2) ]
no problems detected 21 5.6500001 22.6000004 8
( 38%)
8
( 38%)
Column 22 :
[ 14_ABDT2= Calanus glacialis C5 (#/m2) ]
no problems detected 21 35.569416 715.666687 21
( 100%)
21
( 100%)
Column 24 :
[ 15_ABDT2= Calanus glacialis C4 (#/m2) ]
no problems detected 21 19.3714294 1832.85999 20
( 95%)
20
( 95%)
Column 26 :
[ 16_ABDT2= Calanus glacialis C3 (#/m2) ]
no problems detected 21 5.6500001 3251.38672 17
( 80%)
17
( 80%)
Column 28 :
[ 17_ABDT2= Calanus glacialis C2 (#/m2) ]
no problems detected 21 11.3000002 5586.72021 19
( 90%)
19
( 90%)
Column 30 :
[ 18_ABDT2= Calanus glacialis C1 (#/m2) ]
no problems detected 21 5.6500001 8162.3667 20
( 95%)
20
( 95%)
Column 32 :
[ 19_ABDT3= Calanus hyperboreus C6F (#/m2) ]
no problems detected 21 3.22857141 401.464142 18
( 85%)
18
( 85%)
Column 34 :
[20_ABDT3= Calanus hyperboreus C6M (#/m2) ]
There is/are 2 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")

  • 21 9999999. 0. 0
    ( 0%)
    0
    ( 0%)
    Column 36 :
    [ 21_ABDT3= Calanus hyperboreus C5 (#/m2) ]
    no problems detected 21 62.1500015 1469. 20
    ( 95%)
    20
    ( 95%)
    Column 38 :
    [ 22_ABDT3= Calanus hyperboreus C4 (#/m2) ]
    no problems detected 21 22.6000004 2227.71436 21
    ( 100%)
    21
    ( 100%)
    Column 40 :
    [ 23_ABDT3= Calanus hyperboreus C3 (#/m2) ]
    no problems detected 21 5.6500001 7345.75342 20
    ( 95%)
    20
    ( 95%)
    Column 42 :
    [ 24_ABDT3= Calanus hyperboreus C2 (#/m2) ]
    no problems detected 21 19.751585 8813.64746 20
    ( 95%)
    20
    ( 95%)
    Column 44 :
    [ 25_ABDT3= Calanus hyperboreus C1 (#/m2) ]
    no problems detected 21 68.011673 8291.35449 20
    ( 95%)
    20
    ( 95%)
    Column 46 :
    [ 26_ABDT4= Oithona spp. (#/m2) ]
    no problems detected 21 9375.57422 68516.8594 21
    ( 100%)
    21
    ( 100%)
    Column 48 :
    [27_TEMP= Average Temperature (C) from 0-50m ]
    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")

  • 20 -1.51999998 1.80999994 8
    ( 40%)
    2
    ( 10%)
    Column 49 :
    [28_TEMP= Average Temperature (C) from 0-100m ]
    There is/are 2 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")

  • 20 -1.5 1.296 5
    ( 25%)
    1
    ( 5%)
    Column 50 :
    [ 29_PSAL= Average Salinity () from 0-50m ]
    no problems detected 20 32. 33.1599998 20
    ( 100%)
    20
    ( 100%)
    Column 51 :
    [ 30_PSAL= Average Salinity () from 0-100m ]
    no problems detected 20 32.5600014 33.4780006 20
    ( 100%)
    20
    ( 100%)
    Column 52 :
    [ 31_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
    no problems detected 20 9.88000011 654.450012 20
    ( 100%)
    20
    ( 100%)

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