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 22 12346. 210646. 22
( 100%)
22
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus C6F (#/m2) ]
no problems detected 22 1270.12 15270.7412 22
( 100%)
22
( 100%)
Column 6 :
[ 06_ABDT1= Calanus finmarchicus C6M (#/m2) ]
no problems detected 22 54.9933319 762.273621 22
( 100%)
22
( 100%)
Column 8 :
[ 07_ABDT1= Calanus finmarchicus C5 (#/m2) ]
no problems detected 22 303.071655 7525.23486 22
( 100%)
22
( 100%)
Column 10 :
[ 08_ABDT1= Calanus finmarchicus C4 (#/m2) ]
no problems detected 22 174.703903 6847.23486 22
( 100%)
22
( 100%)
Column 12 :
[ 09_ABDT1= Calanus finmarchicus C3 (#/m2) ]
no problems detected 22 5.95509529 8060.52637 22
( 100%)
22
( 100%)
Column 14 :
[ 10_ABDT1= Calanus finmarchicus C2 (#/m2) ]
no problems detected 22 20.0888882 6429.80127 22
( 100%)
22
( 100%)
Column 16 :
[ 11_ABDT1= Calanus finmarchicus C1 (#/m2) ]
no problems detected 22 25.6133327 8121.875 22
( 100%)
22
( 100%)
Column 18 :
[ 12_ABDT2= Calanus glacialis C6F (#/m2) ]
no problems detected 22 4.51999998 209.107697 14
( 63%)
14
( 63%)
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")

  • 22 2.05364871 15.4723082 2
    ( 9%)
    2
    ( 9%)
    Column 22 :
    [ 14_ABDT2= Calanus glacialis C5 (#/m2) ]
    no problems detected 22 3.76666665 54.4925575 16
    ( 72%)
    16
    ( 72%)
    Column 24 :
    [ 15_ABDT2= Calanus glacialis C4 (#/m2) ]
    no problems detected 22 2.25999999 194.017456 14
    ( 63%)
    14
    ( 63%)
    Column 26 :
    [16_ABDT2= Calanus glacialis C3 (#/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")

  • 22 8.28666687 94.3140411 5
    ( 22%)
    5
    ( 22%)
    Column 28 :
    [ 17_ABDT2= Calanus glacialis C2 (#/m2) ]
    no problems detected 22 2.25999999 148.819 9
    ( 40%)
    9
    ( 40%)
    Column 30 :
    [ 18_ABDT2= Calanus glacialis C1 (#/m2) ]
    no problems detected 22 3.76666665 148.819 6
    ( 27%)
    6
    ( 27%)
    Column 32 :
    [ 19_ABDT3= Calanus hyperboreus C6F (#/m2) ]
    no problems detected 22 0.564999998 297.566681 20
    ( 90%)
    19
    ( 86%)
    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")

  • 22 9999999. 0. 0
    ( 0%)
    0
    ( 0%)
    Column 36 :
    [ 21_ABDT3= Calanus hyperboreus C5 (#/m2) ]
    no problems detected 22 6.78000021 902.609253 20
    ( 90%)
    20
    ( 90%)
    Column 38 :
    [ 22_ABDT3= Calanus hyperboreus C4 (#/m2) ]
    no problems detected 22 15.0666666 836.200012 22
    ( 100%)
    22
    ( 100%)
    Column 40 :
    [ 23_ABDT3= Calanus hyperboreus C3 (#/m2) ]
    no problems detected 22 2.25999999 1438.81152 21
    ( 95%)
    21
    ( 95%)
    Column 42 :
    [ 24_ABDT3= Calanus hyperboreus C2 (#/m2) ]
    no problems detected 22 2.76222229 290.700439 18
    ( 81%)
    18
    ( 81%)
    Column 44 :
    [ 25_ABDT3= Calanus hyperboreus C1 (#/m2) ]
    no problems detected 22 2.76222229 528.557495 14
    ( 63%)
    14
    ( 63%)
    Column 46 :
    [ 26_ABDT4= Oithona spp. (#/m2) ]
    no problems detected 22 2849.10669 144337.156 22
    ( 100%)
    22
    ( 100%)
    Column 48 :
    [ 27_TEMP= Average Temperature (C) from 0-50m ]
    no problems detected 22 3.1099999 7.11000013 22
    ( 100%)
    22
    ( 100%)
    Column 49 :
    [ 28_TEMP= Average Temperature (C) from 0-100m ]
    no problems detected 22 0.0900000036 5.82999992 22
    ( 100%)
    21
    ( 95%)
    Column 50 :
    [ 29_PSAL= Average Salinity () from 0-50m ]
    no problems detected 22 19.6499996 34.7799988 22
    ( 100%)
    22
    ( 100%)
    Column 51 :
    [ 30_PSAL= Average Salinity () from 0-100m ]
    no problems detected 22 19.6700001 34.7999992 22
    ( 100%)
    22
    ( 100%)
    Column 52 :
    [ 31_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
    no problems detected 22 51.7900009 314.950012 22
    ( 100%)
    22
    ( 100%)

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