COPEPODITE Incoming Data Review
Fatal Format Issues:   none

    Mild Data Warnings (non-numeric values):   4    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.



HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2    [ABND1= Total Diatoms (cells/liter)]      ( date set 1 )
    Column # 3    [ABND1= Total Dinoflagellates (cells/liter)]      ( date set 1 )

    Column # 4     [ DATE-DMY ]       Date Set = 2
    Column # 5    [ABND1= Total Microflagellates (cells/liter)]      ( date set 2 )

    Column # 6     [ DATE-DMY ]       Date Set = 3
    Column # 7    [ABND1= Total Microzooplankton (cells/liter)]      ( date set 3 )

    Column # 8     [ DATE-MDY ]       Date Set = 4
    Column # 9    [TEMP= Temperature ( C ) at the surface.]      ( date set 4 )
    Column # 10    [PSAL= Salinity (pss) at the surface.]      ( date set 4 )
    Column # 11    [OTHR= Dissolved Oxygen (ml/l) at the surface.]      ( date set 4 )
    Column # 12    [LOTH= Silicate (ug-at/L) at the surface.]      ( date set 4 )
    Column # 13    [LOTH= Nitrite (ug-at/L) at the surface.]      ( date set 4 )
    Column # 14    [LOTH= Nitrate (ug-at/L) at the surface.]      ( date set 4 )
    Column # 15    [LOTH= Phosphate (ug-at/L) at the surface.]      ( date set 4 )
    Column # 16    [CHLA= Chlorophyll-a (ug/L) at the surface.]      ( date set 4 )

    Column # 17     [ DATE-MDY ]       Date Set = 5
    Column # 18    [TEMP= Temperature ( C ) at Port Erin]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Diatoms (cells/liter) ]
        Column # 3   [ ABND1= Total Dinoflagellates (cells/liter) ]
        Column # 5   [ ABND1= Total Microflagellates (cells/liter) ]
        Column # 7   [ ABND1= Total Microzooplankton (cells/liter) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 12   [ LOTH= Silicate (ug-at/L) at the surface. ]
        Column # 13   [ LOTH= Nitrite (ug-at/L) at the surface. ]
        Column # 14   [ LOTH= Nitrate (ug-at/L) at the surface. ]
        Column # 15   [ LOTH= Phosphate (ug-at/L) at the surface. ]

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Dissolved Oxygen (ml/l) at the surface. ]

    Temperatures Category
        Column # 9   [ TEMP= Temperature ( C ) at the surface. ]
        Column # 18   [ TEMP= Temperature ( C ) at Port Erin ]

    Salinities Category
        Column # 10   [ PSAL= Salinity (pss) at the surface. ]

    Chlorophyll/Pigments Category
        Column # 16   [ CHLA= Chlorophyll-a (ug/L) at the surface. ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Diatoms (cells/liter) ]
        column # 3     [ ABND1= Total Dinoflagellates (cells/liter) ]
        column # 5     [ ABND1= Total Microflagellates (cells/liter) ]
        column # 7     [ ABND1= Total Microzooplankton (cells/liter) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1995 2009
DATES in Column 4 no problems detected 1995 2009
DATES in Column 6 no problems detected 1995 2009
DATES in Column 8 no problems detected 1954 2011
DATES in Column 17 no problems detected 1900 1999

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
4 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
6 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
8 DATE-MDY DATE-MDY yes 1 12 1 31 1954 2011
17 DATE-MDY DATE-MDY yes 1 12 1 31 1900 1999


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABND1= Total Diatoms (cells/liter) ] 		no problems detected 402 160. 20038920. 400
( 99%)		 400
( 99%)
Column 3 :
[ 05_ABND1= Total Dinoflagellates (cells/liter) ] 		no problems detected 402 20. 104400. 376
( 93%)		 376
( 93%)
Column 5 :
[ 06_ABND1= Total Microflagellates (cells/liter) ] 		no problems detected 398 20. 884800. 374
( 93%)		 374
( 93%)
Column 7 :
[07_ABND1= Total Microzooplankton (cells/liter) ] 		There is/are 4 count WARNING(S)!
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")

    		•  367 14. 55440. 322
    ( 87%)    		 322
    ( 87%)
    Column 9 :
    [ 08_TEMP= Temperature ( C ) at the surface. ]     		no problems detected 1471 5.19999981 16.5 1471
    ( 100%)    		 1471
    ( 100%)
    Column 10 :
    [ 09_PSAL= Salinity (pss) at the surface. ]     		no problems detected 1447 33.3499985 35.0639992 1447
    ( 100%)    		 1447
    ( 100%)
    Column 11 :
    [ 10_OTHR= Dissolved Oxygen (ml/l) at the surface. ]     		no problems detected 1015 5.5 8.64999962 1015
    ( 100%)    		 1015
    ( 100%)
    Column 12 :
    [ 11_LOTH= Silicate (ug-at/L) at the surface. ]     		no problems detected 1196 0.00999999978 12.5699997 1190
    ( 99%)    		 1053
    ( 88%)
    Column 13 :
    [ 12_LOTH= Nitrite (ug-at/L) at the surface. ]     		no problems detected 1187 0.00999999978 1.77999997 1161
    ( 97%)    		 2
    ( 0%)
    Column 14 :
    [ 13_LOTH= Nitrate (ug-at/L) at the surface. ]     		no problems detected 1075 0.00999999978 16.8899994 1063
    ( 98%)    		 707
    ( 65%)
    Column 15 :
    [ 14_LOTH= Phosphate (ug-at/L) at the surface. ]     		no problems detected 1343 0.00999999978 5.34000015 1339
    ( 99%)    		 15
    ( 1%)
    Column 16 :
    [ 15_CHLA= Chlorophyll-a (ug/L) at the surface. ]     		no problems detected 977 0.0399999991 16.2999992 976
    ( 99%)    		 326
    ( 33%)
    Column 18 :
    [ 16_TEMP= Temperature ( C ) at Port Erin ]     		no problems detected 39079 3.5 16.1000004 38954
    ( 99%)    		 38954
    ( 99%)

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