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    [ABDT1= Total Copepods (#/m2)]      ( date set 1 )
    Column # 3    [ABDT1= Total Mesozooplankton (#/m2)]      ( date set 1 )
    Column # 4    [BIOM1= Total Wet Weight (g/m2)]      ( date set 1 )
    Column # 5    [BIOM2= Total Dry Weight (g/m2)]      ( date set 1 )

    Column # 6     [ DATE-YMD ]       Date Set = 2
    Column # 7    [TEMP1= Temperature ( C ) from 0-10m]      ( date set 2 )
    Column # 8    [PSAL1= Salinity () from 0-10m]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10    [TEMP1= Temperature ( C ) from 75-100m]      ( date set 3 )
    Column # 11    [PSAL1= Salinity () from 75-100m]      ( date set 3 )

    Column # 12     [ DATE-YMD ]       Date Set = 4
    Column # 13    [PSAL1= Salinity () from 0-10m]      ( date set 4 )
    Column # 14    [OTHR= Oxygen (ml/l) from 0-10m]      ( date set 4 )
    Column # 15    [CHLA= Chlorophyll-a (mg/m3) from 0-10m]      ( date set 4 )
    Column # 16    [LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 17    [LOTH1= Phosphate (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 18    [LOTH1= Silicate (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 19    [LOTH1= Ammonium (mmol/m3) from 0-10m]      ( date set 4 )

    Column # 20     [ DATE-YMD ]       Date Set = 5
    Column # 21    [PSAL1= Salinity () from 75-100m]      ( date set 5 )
    Column # 22    [OTHR= Oxygen (ml/l) from 75-100m]      ( date set 5 )
    Column # 23    [CHLA= Chlorophyll-a (mg/m3) from 75-100m]      ( date set 5 )
    Column # 24    [LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 25    [LOTH1= Phosphate (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 26    [LOTH1= Silicate (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 27    [LOTH1= Ammonium (mmol/m3) from 75-100m]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 4   [ BIOM1= Total Wet Weight (g/m2) ]
        Column # 5   [ BIOM2= Total Dry Weight (g/m2) ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (#/m2) ]
        Column # 3   [ ABDT1= Total Mesozooplankton (#/m2) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 16   [ LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ]
        Column # 17   [ LOTH1= Phosphate (mmol/m3) from 0-10m ]
        Column # 18   [ LOTH1= Silicate (mmol/m3) from 0-10m ]
        Column # 19   [ LOTH1= Ammonium (mmol/m3) from 0-10m ]
        Column # 24   [ LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]
        Column # 25   [ LOTH1= Phosphate (mmol/m3) from 75-100m ]
        Column # 26   [ LOTH1= Silicate (mmol/m3) from 75-100m ]
        Column # 27   [ LOTH1= Ammonium (mmol/m3) from 75-100m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 14   [ OTHR= Oxygen (ml/l) from 0-10m ]
        Column # 22   [ OTHR= Oxygen (ml/l) from 75-100m ]

    Temperatures Category
        Column # 7   [ TEMP1= Temperature ( C ) from 0-10m ]
        Column # 10   [ TEMP1= Temperature ( C ) from 75-100m ]

    Salinities Category
        Column # 8   [ PSAL1= Salinity () from 0-10m ]
        Column # 11   [ PSAL1= Salinity () from 75-100m ]
        Column # 13   [ PSAL1= Salinity () from 0-10m ]
        Column # 21   [ PSAL1= Salinity () from 75-100m ]

    Chlorophyll/Pigments Category
        Column # 15   [ CHLA= Chlorophyll-a (mg/m3) from 0-10m ]
        Column # 23   [ CHLA= Chlorophyll-a (mg/m3) from 75-100m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 1
        column # 4     [ BIOM1= Total Wet Weight (g/m2) ]

    Category 1 Group # 2
        column # 5     [ BIOM2= Total Dry Weight (g/m2) ]

    Category 4 Group # 1
        column # 7     [ TEMP1= Temperature ( C ) from 0-10m ]
        column # 10     [ TEMP1= Temperature ( C ) from 75-100m ]

    Category 5 Group # 1
        column # 8     [ PSAL1= Salinity () from 0-10m ]
        column # 11     [ PSAL1= Salinity () from 75-100m ]
        column # 13     [ PSAL1= Salinity () from 0-10m ]
        column # 21     [ PSAL1= Salinity () from 75-100m ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (#/m2) ]
        column # 3     [ ABDT1= Total Mesozooplankton (#/m2) ]

    Category 9 Group # 1
        column # 16     [ LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ]
        column # 17     [ LOTH1= Phosphate (mmol/m3) from 0-10m ]
        column # 18     [ LOTH1= Silicate (mmol/m3) from 0-10m ]
        column # 19     [ LOTH1= Ammonium (mmol/m3) from 0-10m ]
        column # 24     [ LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]
        column # 25     [ LOTH1= Phosphate (mmol/m3) from 75-100m ]
        column # 26     [ LOTH1= Silicate (mmol/m3) from 75-100m ]
        column # 27     [ LOTH1= Ammonium (mmol/m3) from 75-100m ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1998 2017
DATES in Column 6 no problems detected 1996 2018
DATES in Column 9 no problems detected 1996 2018
DATES in Column 12 no problems detected 1996 2018
DATES in Column 20 no problems detected 1996 2017

 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 1998 2017 1 12 1 31
6 DATE-YMD DATE-YMD yes 1996 2018 1 12 1 31
9 DATE-YMD DATE-YMD yes 1996 2018 1 12 1 31
12 DATE-YMD DATE-YMD yes 1996 2018 1 12 1 31
20 DATE-YMD DATE-YMD yes 1996 2017 1 12 1 31


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepods (#/m2) ] 		no problems detected 149 26714.4648 713859.75 149
( 100%)		 149
( 100%)
Column 3 :
[ 05_ABDT1= Total Mesozooplankton (#/m2) ] 		no problems detected 149 35247.2461 970462.25 149
( 100%)		 149
( 100%)
Column 4 :
[ 06_BIOM1= Total Wet Weight (g/m2) ] 		no problems detected 147 52.9544754 281.017517 147
( 100%)		 147
( 100%)
Column 5 :
[ 07_BIOM2= Total Dry Weight (g/m2) ] 		no problems detected 107 6.14910984 66.7741928 107
( 100%)		 107
( 100%)
Column 7 :
[ 08_TEMP1= Temperature ( C ) from 0-10m ] 		no problems detected 2636 -1.70700002 17.1690006 2067
( 78%)		 1994
( 75%)
Column 8 :
[ 09_PSAL1= Salinity () from 0-10m ] 		no problems detected 2504 25.816 32.7659988 2504
( 100%)		 2504
( 100%)
Column 10 :
[ 10_TEMP1= Temperature ( C ) from 75-100m ] 		no problems detected 7448 -0.897000015 4.4829998 7386
( 99%)		 6382
( 85%)
Column 11 :
[ 11_PSAL1= Salinity () from 75-100m ] 		no problems detected 7266 31.8630009 34.1160011 7266
( 100%)		 7266
( 100%)
Column 13 :
[ 12_PSAL1= Salinity () from 0-10m ] 		no problems detected 285 25.9099998 32.7099991 285
( 100%)		 285
( 100%)
Column 14 :
[ 13_OTHR= Oxygen (ml/l) from 0-10m ] 		no problems detected 158 5.9000001 9.68999958 158
( 100%)		 158
( 100%)
Column 15 :
[ 14_CHLA= Chlorophyll-a (mg/m3) from 0-10m ] 		no problems detected 389 0.100000001 18.7000008 389
( 100%)		 128
( 32%)
Column 16 :
[ 15_LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ] 		no problems detected 402 0.00499999989 13.2130003 402
( 100%)		 183
( 45%)
Column 17 :
[ 16_LOTH1= Phosphate (mmol/m3) from 0-10m ] 		no problems detected 401 0.0299999993 1.44000006 400
( 99%)		 50
( 12%)
Column 18 :
[ 17_LOTH1= Silicate (mmol/m3) from 0-10m ] 		no problems detected 396 0.0900000036 18.5149994 382
( 96%)		 300
( 75%)
Column 19 :
[ 18_LOTH1= Ammonium (mmol/m3) from 0-10m ] 		no problems detected 11 0.0529999994 0.289999992 11
( 100%)		 0
( 0%)
Column 21 :
[ 19_PSAL1= Salinity () from 75-100m ] 		no problems detected 147 32.3499985 34.1199989 147
( 100%)		 147
( 100%)
Column 22 :
[ 20_OTHR= Oxygen (ml/l) from 75-100m ] 		no problems detected 27 2.56999993 7.05000019 27
( 100%)		 27
( 100%)
Column 23 :
[21_CHLA= Chlorophyll-a (mg/m3) from 75-100m ] 		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")

    		•  252 0.00499999989 0.855000019 252
    ( 100%)    		 0
    ( 0%)
    Column 24 :
    [ 22_LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]     		no problems detected 256 5.54500008 24.0949993 256
    ( 100%)    		 256
    ( 100%)
    Column 25 :
    [ 23_LOTH1= Phosphate (mmol/m3) from 75-100m ]     		no problems detected 255 0.860000014 2.48000002 255
    ( 100%)    		 253
    ( 99%)
    Column 26 :
    [ 24_LOTH1= Silicate (mmol/m3) from 75-100m ]     		no problems detected 253 5.34000015 41.6749992 253
    ( 100%)    		 253
    ( 100%)
    Column 27 :
    [ 25_LOTH1= Ammonium (mmol/m3) from 75-100m ]     		no problems detected 7 0.0149999997 0.209999993 7
    ( 100%)    		 0
    ( 0%)

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