COPEPODITE Incoming Data Review
Fatal Format Issues:   none


HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2    [ABDT1= Total Diatoms (#/L) at the surface]      ( date set 1 )
    Column # 3    [ABDT1= Total Dinoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 4    [ABDT1= Total Coccolithophores (#/L) at the surface]      ( date set 1 )
    Column # 5    [ABDT1= Total Silicoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 6    [ABDT1= Other nanoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 7    [ABDT1= Total Phytoplankton (#/L) at the surface]      ( date set 1 )

    Column # 8     [ DATE-DMY ]       Date Set = 2
    Column # 9    [TEMP= Temperature ( C ) at the surface]      ( date set 2 )
    Column # 10    [PSAL= Salinity () at the surface]      ( date set 2 )
    Column # 11    [OTHR= Density (kg/m3) at the surface]      ( date set 2 )
    Column # 12    [OTHR= Oxygen (ml/l) at the surface]      ( date set 2 )
    Column # 13    [LOTH= NO3 (uM) at the surface]      ( date set 2 )
    Column # 14    [LOTH= NO2 (uM) at the surface]      ( date set 2 )
    Column # 15    [LOTH= NH4 (uM) at the surface]      ( date set 2 )
    Column # 16    [LOTH= PO4 (uM) at the surface]      ( date set 2 )
    Column # 17    [LOTH= SiO4 (uM) at the surface]      ( date set 2 )
    Column # 18    [CHLA= Chlorophyll (ug/l) at the surface]      ( date set 2 )

    Column # 19     [ DATE-DMY ]       Date Set = 3
    Column # 20    [ABDT1= Total Diatoms (#/L) at 20 m]      ( date set 3 )
    Column # 21    [ABDT1= Total Dinoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 22    [ABDT1= Total Coccolithophores (#/L) at 20 m]      ( date set 3 )
    Column # 23    [ABDT1= Total Silicoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 24    [ABDT1= Other nanoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 25    [ABDT1= Total Phytoplankton (#/L) at 20 m]      ( date set 3 )

    Column # 26     [ DATE-DMY ]       Date Set = 4
    Column # 27    [TEMP= Temperature ( C ) at 20 m]      ( date set 4 )
    Column # 28    [PSAL= Salinity () at 20 m]      ( date set 4 )
    Column # 29    [OTHR= Density (kg/m3) at 20 m]      ( date set 4 )
    Column # 30    [OTHR= Oxygen (ml/l) at 20 m]      ( date set 4 )
    Column # 31    [LOTH= NO3 (uM) at 20 m]      ( date set 4 )
    Column # 32    [LOTH= NO2 (uM) at 20 m]      ( date set 4 )
    Column # 33    [LOTH= NH4 (uM) at 20 m]      ( date set 4 )
    Column # 34    [LOTH= PO4 (uM) at 20 m]      ( date set 4 )
    Column # 35    [LOTH= SiO4 (uM) at 20 m]      ( date set 4 )
    Column # 36    [CHLA= Chlorophyll (ug/l) at 20 m]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) at the surface ]
        Column # 3   [ ABDT1= Total Dinoflagellates (#/L) at the surface ]
        Column # 4   [ ABDT1= Total Coccolithophores (#/L) at the surface ]
        Column # 5   [ ABDT1= Total Silicoflagellates (#/L) at the surface ]
        Column # 6   [ ABDT1= Other nanoflagellates (#/L) at the surface ]
        Column # 7   [ ABDT1= Total Phytoplankton (#/L) at the surface ]
        Column # 20   [ ABDT1= Total Diatoms (#/L) at 20 m ]
        Column # 21   [ ABDT1= Total Dinoflagellates (#/L) at 20 m ]
        Column # 22   [ ABDT1= Total Coccolithophores (#/L) at 20 m ]
        Column # 23   [ ABDT1= Total Silicoflagellates (#/L) at 20 m ]
        Column # 24   [ ABDT1= Other nanoflagellates (#/L) at 20 m ]
        Column # 25   [ ABDT1= Total Phytoplankton (#/L) at 20 m ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 13   [ LOTH= NO3 (uM) at the surface ]
        Column # 14   [ LOTH= NO2 (uM) at the surface ]
        Column # 15   [ LOTH= NH4 (uM) at the surface ]
        Column # 16   [ LOTH= PO4 (uM) at the surface ]
        Column # 17   [ LOTH= SiO4 (uM) at the surface ]
        Column # 31   [ LOTH= NO3 (uM) at 20 m ]
        Column # 32   [ LOTH= NO2 (uM) at 20 m ]
        Column # 33   [ LOTH= NH4 (uM) at 20 m ]
        Column # 34   [ LOTH= PO4 (uM) at 20 m ]
        Column # 35   [ LOTH= SiO4 (uM) at 20 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Density (kg/m3) at the surface ]
        Column # 12   [ OTHR= Oxygen (ml/l) at the surface ]
        Column # 29   [ OTHR= Density (kg/m3) at 20 m ]
        Column # 30   [ OTHR= Oxygen (ml/l) at 20 m ]

    Temperatures Category
        Column # 9   [ TEMP= Temperature ( C ) at the surface ]
        Column # 27   [ TEMP= Temperature ( C ) at 20 m ]

    Salinities Category
        Column # 10   [ PSAL= Salinity () at the surface ]
        Column # 28   [ PSAL= Salinity () at 20 m ]

    Chlorophyll/Pigments Category
        Column # 18   [ CHLA= Chlorophyll (ug/l) at the surface ]
        Column # 36   [ CHLA= Chlorophyll (ug/l) at 20 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) at the surface ]
        column # 3     [ ABDT1= Total Dinoflagellates (#/L) at the surface ]
        column # 4     [ ABDT1= Total Coccolithophores (#/L) at the surface ]
        column # 5     [ ABDT1= Total Silicoflagellates (#/L) at the surface ]
        column # 6     [ ABDT1= Other nanoflagellates (#/L) at the surface ]
        column # 7     [ ABDT1= Total Phytoplankton (#/L) at the surface ]
        column # 20     [ ABDT1= Total Diatoms (#/L) at 20 m ]
        column # 21     [ ABDT1= Total Dinoflagellates (#/L) at 20 m ]
        column # 22     [ ABDT1= Total Coccolithophores (#/L) at 20 m ]
        column # 23     [ ABDT1= Total Silicoflagellates (#/L) at 20 m ]
        column # 24     [ ABDT1= Other nanoflagellates (#/L) at 20 m ]
        column # 25     [ ABDT1= Total Phytoplankton (#/L) at 20 m ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1990 2014
DATES in Column 8 no problems detected 1990 2014
DATES in Column 19 no problems detected 1990 2014
DATES in Column 26 no problems detected 1990 2014

 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 3 31 Apr Sep 1990 2014
8 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014
19 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014
26 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Diatoms (#/L) at the surface ] 		no problems detected 290 270. 4536000. 288
( 99%)		 288
( 99%)
Column 3 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ] 		no problems detected 290 540. 297920. 289
( 99%)		 289
( 99%)
Column 4 :
[ 06_ABDT1= Total Coccolithophores (#/L) at the surface ] 		no problems detected 290 370. 712800. 286
( 98%)		 286
( 98%)
Column 5 :
[ 07_ABDT1= Total Silicoflagellates (#/L) at the surface ] 		no problems detected 290 270. 6480. 63
( 21%)		 63
( 21%)
Column 6 :
[ 08_ABDT1= Other nanoflagellates (#/L) at the surface ] 		no problems detected 290 26728. 4393400. 290
( 100%)		 290
( 100%)
Column 7 :
[ 09_ABDT1= Total Phytoplankton (#/L) at the surface ] 		no problems detected 290 66306. 5134000. 290
( 100%)		 290
( 100%)
Column 9 :
[ 10_TEMP= Temperature ( C ) at the surface ] 		no problems detected 306 6.23000002 28.0900002 306
( 100%)		 306
( 100%)
Column 10 :
[ 11_PSAL= Salinity () at the surface ] 		no problems detected 306 28.1200008 38.6599998 306
( 100%)		 306
( 100%)
Column 11 :
[ 12_OTHR= Density (kg/m3) at the surface ] 		no problems detected 306 19.0400009 30.0200005 306
( 100%)		 306
( 100%)
Column 12 :
[ 13_OTHR= Oxygen (ml/l) at the surface ] 		no problems detected 296 3.75 7.88999987 296
( 100%)		 296
( 100%)
Column 13 :
[ 14_LOTH= NO3 (uM) at the surface ] 		no problems detected 294 0.00999999978 23.2299995 294
( 100%)		 194
( 65%)
Column 14 :
[ 15_LOTH= NO2 (uM) at the surface ] 		no problems detected 294 0.00999999978 1.88999999 294
( 100%)		 17
( 5%)
Column 15 :
[ 16_LOTH= NH4 (uM) at the surface ] 		no problems detected 294 0.00999999978 7.32999992 294
( 100%)		 114
( 38%)
Column 16 :
[ 17_LOTH= PO4 (uM) at the surface ] 		no problems detected 294 0.00999999978 0.639999986 294
( 100%)		 0
( 0%)
Column 17 :
[ 18_LOTH= SiO4 (uM) at the surface ] 		no problems detected 294 0.00999999978 34.8600006 294
( 100%)		 267
( 90%)
Column 18 :
[ 19_CHLA= Chlorophyll (ug/l) at the surface ] 		no problems detected 298 0.0599999987 12.0600004 298
( 100%)		 108
( 36%)
Column 20 :
[ 20_ABDT1= Total Diatoms (#/L) at 20 m ] 		no problems detected 248 270. 3000240. 248
( 100%)		 248
( 100%)
Column 21 :
[ 21_ABDT1= Total Dinoflagellates (#/L) at 20 m ] 		no problems detected 248 495. 83750. 240
( 96%)		 240
( 96%)
Column 22 :
[ 22_ABDT1= Total Coccolithophores (#/L) at 20 m ] 		no problems detected 248 540. 627480. 240
( 96%)		 240
( 96%)
Column 23 :
[ 23_ABDT1= Total Silicoflagellates (#/L) at 20 m ] 		no problems detected 248 270. 18125. 71
( 28%)		 71
( 28%)
Column 24 :
[ 24_ABDT1= Other nanoflagellates (#/L) at 20 m ] 		no problems detected 248 11122. 930000. 248
( 100%)		 248
( 100%)
Column 25 :
[ 25_ABDT1= Total Phytoplankton (#/L) at 20 m ] 		no problems detected 248 38678. 3134160. 248
( 100%)		 248
( 100%)
Column 27 :
[ 26_TEMP= Temperature ( C ) at 20 m ] 		no problems detected 304 5.26000023 23.3600006 304
( 100%)		 304
( 100%)
Column 28 :
[ 27_PSAL= Salinity () at 20 m ] 		no problems detected 304 35.6399994 38.6800003 304
( 100%)		 304
( 100%)
Column 29 :
[ 28_OTHR= Density (kg/m3) at 20 m ] 		no problems detected 304 25.3500004 30.4699993 304
( 100%)		 304
( 100%)
Column 30 :
[ 29_OTHR= Oxygen (ml/l) at 20 m ] 		no problems detected 296 3.28999996 7.48000002 296
( 100%)		 296
( 100%)
Column 31 :
[ 30_LOTH= NO3 (uM) at 20 m ] 		no problems detected 291 0.00999999978 17.5900002 291
( 100%)		 183
( 62%)
Column 32 :
[ 31_LOTH= NO2 (uM) at 20 m ] 		no problems detected 292 0.00999999978 1.88 292
( 100%)		 26
( 8%)
Column 33 :
[ 32_LOTH= NH4 (uM) at 20 m ] 		no problems detected 292 0.00999999978 5.51000023 292
( 100%)		 184
( 63%)
Column 34 :
[ 33_LOTH= PO4 (uM) at 20 m ] 		no problems detected 291 0.00999999978 1.07000005 291
( 100%)		 1
( 0%)
Column 35 :
[ 34_LOTH= SiO4 (uM) at 20 m ] 		no problems detected 291 0.00999999978 41.3300018 291
( 100%)		 280
( 96%)
Column 36 :
[ 35_CHLA= Chlorophyll (ug/l) at 20 m ] 		no problems detected 295 0.170000002 7.44000006 295
( 100%)		 135
( 45%)

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