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 20 13212. 105082. 20
( 100%)
20
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus C6F (#/m2) ]
no problems detected 20 1020.76666 24249.791 20
( 100%)
20
( 100%)
Column 6 :
[ 06_ABDT1= Calanus finmarchicus C6M (#/m2) ]
no problems detected 20 45.2000008 1406.02588 20
( 100%)
20
( 100%)
Column 8 :
[ 07_ABDT1= Calanus finmarchicus C5 (#/m2) ]
no problems detected 20 195.866669 17967. 20
( 100%)
20
( 100%)
Column 10 :
[ 08_ABDT1= Calanus finmarchicus C4 (#/m2) ]
no problems detected 20 60.2666664 4434.12012 20
( 100%)
20
( 100%)
Column 12 :
[ 09_ABDT1= Calanus finmarchicus C3 (#/m2) ]
no problems detected 20 21.8466663 8236.19336 16
( 80%)
16
( 80%)
Column 14 :
[ 10_ABDT1= Calanus finmarchicus C2 (#/m2) ]
no problems detected 20 7.5333333 8515.67969 17
( 85%)
17
( 85%)
Column 16 :
[ 11_ABDT1= Calanus finmarchicus C1 (#/m2) ]
no problems detected 20 15.0666666 11526. 18
( 90%)
18
( 90%)
Column 18 :
[ 12_ABDT2= Calanus glacialis C6F (#/m2) ]
no problems detected 20 4.51999998 633.683167 19
( 95%)
19
( 95%)
Column 20 :
[13_ABDT2= Calanus glacialis 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")

  • 20 22.6353703 33.9530563 2
    ( 10%)
    2
    ( 10%)
    Column 22 :
    [ 14_ABDT2= Calanus glacialis C5 (#/m2) ]
    no problems detected 20 11.38025 183.813339 17
    ( 85%)
    17
    ( 85%)
    Column 24 :
    [ 15_ABDT2= Calanus glacialis C4 (#/m2) ]
    no problems detected 20 15.0666666 306.606659 13
    ( 65%)
    13
    ( 65%)
    Column 26 :
    [ 16_ABDT2= Calanus glacialis C3 (#/m2) ]
    no problems detected 20 15.2890034 728.473328 6
    ( 30%)
    6
    ( 30%)
    Column 28 :
    [ 17_ABDT2= Calanus glacialis C2 (#/m2) ]
    no problems detected 20 4.51999998 254.647903 10
    ( 50%)
    10
    ( 50%)
    Column 30 :
    [ 18_ABDT2= Calanus glacialis C1 (#/m2) ]
    no problems detected 20 7.5333333 602.666687 11
    ( 55%)
    11
    ( 55%)
    Column 32 :
    [ 19_ABDT3= Calanus hyperboreus C6F (#/m2) ]
    no problems detected 20 7.5333333 563.369202 17
    ( 85%)
    17
    ( 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")

  • 20 17.01264 19.1166573 2
    ( 10%)
    2
    ( 10%)
    Column 36 :
    [ 21_ABDT3= Calanus hyperboreus C5 (#/m2) ]
    no problems detected 20 3.76666665 2278.6272 20
    ( 100%)
    20
    ( 100%)
    Column 38 :
    [ 22_ABDT3= Calanus hyperboreus C4 (#/m2) ]
    no problems detected 20 9.73310852 1850.375 20
    ( 100%)
    20
    ( 100%)
    Column 40 :
    [ 23_ABDT3= Calanus hyperboreus C3 (#/m2) ]
    no problems detected 20 7.34531307 1640.00671 14
    ( 70%)
    14
    ( 70%)
    Column 42 :
    [ 24_ABDT3= Calanus hyperboreus C2 (#/m2) ]
    no problems detected 20 5.6500001 2149.26001 13
    ( 65%)
    13
    ( 65%)
    Column 44 :
    [ 25_ABDT3= Calanus hyperboreus C1 (#/m2) ]
    no problems detected 20 7.34531307 2712. 14
    ( 70%)
    14
    ( 70%)
    Column 46 :
    [ 26_ABDT4= Oithona spp. (#/m2) ]
    no problems detected 20 3932.3999 29380. 20
    ( 100%)
    20
    ( 100%)
    Column 48 :
    [ 27_TEMP= Average Temperature (C) from 0-50m ]
    no problems detected 21 0.639999986 5.28000021 21
    ( 100%)
    19
    ( 90%)
    Column 49 :
    [ 28_TEMP= Average Temperature (C) from 0-100m ]
    no problems detected 21 0.239999995 4.57999992 21
    ( 100%)
    20
    ( 95%)
    Column 50 :
    [ 29_PSAL= Average Salinity () from 0-50m ]
    no problems detected 21 26.4500008 34.6399994 21
    ( 100%)
    21
    ( 100%)
    Column 51 :
    [ 30_PSAL= Average Salinity () from 0-100m ]
    no problems detected 21 26.5900002 34.7400017 21
    ( 100%)
    21
    ( 100%)
    Column 52 :
    [ 31_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
    no problems detected 21 13.3999996 277.450012 21
    ( 100%)
    21
    ( 100%)

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