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 11354.4307 380305.812 20
( 100%)
20
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus C6F (#/m2) ]
no problems detected 20 52.7333336 4045.15234 17
( 85%)
17
( 85%)
Column 6 :
[ 06_ABDT1= Calanus finmarchicus C6M (#/m2) ]
no problems detected 20 5.6500001 68.7109528 7
( 35%)
7
( 35%)
Column 8 :
[ 07_ABDT1= Calanus finmarchicus C5 (#/m2) ]
no problems detected 20 22.6000004 10848. 20
( 100%)
20
( 100%)
Column 10 :
[ 08_ABDT1= Calanus finmarchicus C4 (#/m2) ]
no problems detected 20 184.740189 18532. 20
( 100%)
20
( 100%)
Column 12 :
[ 09_ABDT1= Calanus finmarchicus C3 (#/m2) ]
no problems detected 20 63.7738686 27626.6621 20
( 100%)
20
( 100%)
Column 14 :
[ 10_ABDT1= Calanus finmarchicus C2 (#/m2) ]
no problems detected 20 582.714661 66899.6016 20
( 100%)
20
( 100%)
Column 16 :
[ 11_ABDT1= Calanus finmarchicus C1 (#/m2) ]
no problems detected 20 113. 128748.094 20
( 100%)
20
( 100%)
Column 18 :
[ 12_ABDT2= Calanus glacialis C6F (#/m2) ]
no problems detected 20 5.6500001 384.80127 8
( 40%)
8
( 40%)
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 9999999. 0. 0
    ( 0%)
    0
    ( 0%)
    Column 22 :
    [ 14_ABDT2= Calanus glacialis C5 (#/m2) ]
    no problems detected 20 7.5333333 1243. 14
    ( 70%)
    14
    ( 70%)
    Column 24 :
    [ 15_ABDT2= Calanus glacialis C4 (#/m2) ]
    no problems detected 20 18.8628082 1808. 14
    ( 70%)
    14
    ( 70%)
    Column 26 :
    [ 16_ABDT2= Calanus glacialis C3 (#/m2) ]
    no problems detected 20 51.3272476 1808. 16
    ( 80%)
    16
    ( 80%)
    Column 28 :
    [ 17_ABDT2= Calanus glacialis C2 (#/m2) ]
    no problems detected 20 15.670001 3873.63989 16
    ( 80%)
    16
    ( 80%)
    Column 30 :
    [ 18_ABDT2= Calanus glacialis C1 (#/m2) ]
    no problems detected 20 25.1619148 5763. 17
    ( 85%)
    17
    ( 85%)
    Column 32 :
    [19_ABDT3= Calanus hyperboreus C6F (#/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 0.75333333 23.1268139 4
    ( 20%)
    3
    ( 15%)
    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 25.6636829 25.6636829 1
    ( 5%)
    1
    ( 5%)
    Column 36 :
    [ 21_ABDT3= Calanus hyperboreus C5 (#/m2) ]
    no problems detected 20 1.50666666 1012.76825 11
    ( 55%)
    11
    ( 55%)
    Column 38 :
    [ 22_ABDT3= Calanus hyperboreus C4 (#/m2) ]
    no problems detected 20 8.89753056 1378.59998 19
    ( 95%)
    19
    ( 95%)
    Column 40 :
    [ 23_ABDT3= Calanus hyperboreus C3 (#/m2) ]
    no problems detected 20 5.56423712 10976.8203 20
    ( 100%)
    20
    ( 100%)
    Column 42 :
    [ 24_ABDT3= Calanus hyperboreus C2 (#/m2) ]
    no problems detected 20 175.424118 6102. 19
    ( 95%)
    19
    ( 95%)
    Column 44 :
    [ 25_ABDT3= Calanus hyperboreus C1 (#/m2) ]
    no problems detected 20 73.564949 3666.47339 16
    ( 80%)
    16
    ( 80%)
    Column 46 :
    [ 26_ABDT4= Oithona spp. (#/m2) ]
    no problems detected 20 2299.92676 117797.469 20
    ( 100%)
    20
    ( 100%)
    Column 48 :
    [ 27_TEMP= Average Temperature (C) from 0-50m ]
    no problems detected 20 -0.529999971 3.56999993 17
    ( 85%)
    12
    ( 60%)
    Column 49 :
    [ 28_TEMP= Average Temperature (C) from 0-100m ]
    no problems detected 20 0.0299999993 3.75999999 20
    ( 100%)
    14
    ( 70%)
    Column 50 :
    [ 29_PSAL= Average Salinity () from 0-50m ]
    no problems detected 19 32.5 34.1300011 19
    ( 100%)
    19
    ( 100%)
    Column 51 :
    [ 30_PSAL= Average Salinity () from 0-100m ]
    no problems detected 20 33.0200005 34.2099991 20
    ( 100%)
    20
    ( 100%)
    Column 52 :
    [ 31_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
    no problems detected 19 23.4599991 1474.87 19
    ( 100%)
    19
    ( 100%)

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