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 29200. 454157. 21
( 100%)
21
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus C6F (#/m2) ]
no problems detected 21 428.78363 11402.5674 21
( 100%)
21
( 100%)
Column 6 :
[ 06_ABDT1= Calanus finmarchicus C6M (#/m2) ]
no problems detected 21 18.0799999 1414.56042 20
( 95%)
20
( 95%)
Column 8 :
[ 07_ABDT1= Calanus finmarchicus C5 (#/m2) ]
no problems detected 21 163.850006 39365.0898 21
( 100%)
21
( 100%)
Column 10 :
[ 08_ABDT1= Calanus finmarchicus C4 (#/m2) ]
no problems detected 21 186.449997 95805.1641 21
( 100%)
21
( 100%)
Column 12 :
[ 09_ABDT1= Calanus finmarchicus C3 (#/m2) ]
no problems detected 21 312.060638 92830.6328 21
( 100%)
21
( 100%)
Column 14 :
[ 10_ABDT1= Calanus finmarchicus C2 (#/m2) ]
no problems detected 21 254.647903 148313.625 21
( 100%)
21
( 100%)
Column 16 :
[ 11_ABDT1= Calanus finmarchicus C1 (#/m2) ]
no problems detected 21 594.178467 73161.8516 21
( 100%)
21
( 100%)
Column 18 :
[ 12_ABDT2= Calanus glacialis C6F (#/m2) ]
no problems detected 21 5.83534861 611.154968 9
( 42%)
9
( 42%)
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")

  • 21 5.6500001 11.3000002 2
    ( 9%)
    2
    ( 9%)
    Column 22 :
    [ 14_ABDT2= Calanus glacialis C5 (#/m2) ]
    no problems detected 21 3.22857141 105.631721 12
    ( 57%)
    12
    ( 57%)
    Column 24 :
    [ 15_ABDT2= Calanus glacialis C4 (#/m2) ]
    no problems detected 21 2.82500005 367.824768 11
    ( 52%)
    11
    ( 52%)
    Column 26 :
    [ 16_ABDT2= Calanus glacialis C3 (#/m2) ]
    no problems detected 21 20.545454 203.399994 10
    ( 47%)
    10
    ( 47%)
    Column 28 :
    [ 17_ABDT2= Calanus glacialis C2 (#/m2) ]
    no problems detected 21 17.4636364 294.259796 10
    ( 47%)
    10
    ( 47%)
    Column 30 :
    [ 18_ABDT2= Calanus glacialis C1 (#/m2) ]
    no problems detected 21 28.2942123 542.400024 10
    ( 47%)
    10
    ( 47%)
    Column 32 :
    [ 19_ABDT3= Calanus hyperboreus C6F (#/m2) ]
    no problems detected 21 2.82500005 192.400635 16
    ( 76%)
    16
    ( 76%)
    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 19.3714294 603.111084 17
    ( 80%)
    17
    ( 80%)
    Column 38 :
    [ 22_ABDT3= Calanus hyperboreus C4 (#/m2) ]
    no problems detected 21 16.1428566 1301.76001 21
    ( 100%)
    21
    ( 100%)
    Column 40 :
    [ 23_ABDT3= Calanus hyperboreus C3 (#/m2) ]
    no problems detected 21 4.10909081 3051. 18
    ( 85%)
    18
    ( 85%)
    Column 42 :
    [ 24_ABDT3= Calanus hyperboreus C2 (#/m2) ]
    no problems detected 21 67.8000031 1969.29211 15
    ( 71%)
    15
    ( 71%)
    Column 44 :
    [ 25_ABDT3= Calanus hyperboreus C1 (#/m2) ]
    no problems detected 21 23.8555565 1715.62256 16
    ( 76%)
    16
    ( 76%)
    Column 46 :
    [ 26_ABDT4= Oithona spp. (#/m2) ]
    no problems detected 21 1140.54663 168189.203 21
    ( 100%)
    21
    ( 100%)
    Column 48 :
    [ 27_TEMP= Average Temperature (C) from 0-50m ]
    no problems detected 22 1.87 7.51999998 22
    ( 100%)
    22
    ( 100%)
    Column 49 :
    [ 28_TEMP= Average Temperature (C) from 0-100m ]
    no problems detected 22 0.449999988 6.76000023 22
    ( 100%)
    21
    ( 95%)
    Column 50 :
    [ 29_PSAL= Average Salinity () from 0-50m ]
    no problems detected 21 33.8800011 34.8499985 21
    ( 100%)
    21
    ( 100%)
    Column 51 :
    [ 30_PSAL= Average Salinity () from 0-100m ]
    no problems detected 22 34.2159996 34.8699989 22
    ( 100%)
    22
    ( 100%)
    Column 52 :
    [ 31_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
    no problems detected 21 39.6399994 604.380005 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".