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    [ABDT6= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABDT6= Total Calanoids (#/m3)]      ( date set 1 )
    Column # 4    [ABDT1= Calanus finmarchicus C5-6 (#/m3)]      ( date set 1 )
    Column # 5    [ABDT1= Calanus helgolandicus C5-6 (#/m3)]      ( date set 1 )
    Column # 6    [ABDT2= Euphausiids (#/m3)]      ( date set 1 )
    Column # 7    [ABDT2= Cnidaria (#/m3)]      ( date set 1 )
    Column # 8    [ABDT2= Chaetognatha (#/m3)]      ( date set 1 )
    Column # 9    [ABDT2= Echinodermata larvae (#/m3)]      ( date set 1 )
    Column # 10    [ABDT2= Bryozoa larvae (#/m3)]      ( date set 1 )
    Column # 11    [ABDT2= Decapoda larvae (#/m3)]      ( date set 1 )
    Column # 12    [ABDT2= Polychaeta (#/m3)]      ( date set 1 )
    Column # 13    [ABDT2= Bivalvia larvae (#/m3)]      ( date set 1 )
    Column # 14    [ABDT4= Pseudocalanus elongatus (#/m3)]      ( date set 1 )
    Column # 15    [ABDT4= Acartia clausii (#/m3)]      ( date set 1 )
    Column # 16    [ABDT4= Cladocerans (#/m3)]      ( date set 1 )
    Column # 17    [ABDT4= Oithonidae spp (#/m3)]      ( date set 1 )
    Column # 18    [ABDT4= Cirripedia larvae (#/m3)]      ( date set 1 )
    Column # 19    [ABDT4= Larvacea (#/m3)]      ( date set 1 )
    Column # 20    [ABDT4= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 21    [ABDT4= Gastropoda (#/m3)]      ( date set 1 )
    Column # 22    [ABDT4= Calanus spp. C1-4 (#/m3)]      ( date set 1 )
    Column # 23    [ABDT4= Paracalanus parvus (#/m3)]      ( date set 1 )

    Column # 24     [ DATE-MDY ]       Date Set = 2
    Column # 25    [ABDT1= Total diatoms (cells/L)]      ( date set 2 )
    Column # 26    [ABDT1= Total dinoflagellates (cells/L)]      ( date set 2 )
    Column # 27    [CHLA= Chlorophyll (ug/l) averaged from 0-10 m]      ( date set 2 )

    Column # 28     [ DATE-MDY ]       Date Set = 3
    Column # 29    [TEMP= Temperature (C) at 1 m]      ( date set 3 )
    Column # 30    [TEMP= Temperature (C) at 45 m]      ( date set 3 )
    Column # 31    [PSAL= Salinity () 1 m]      ( date set 3 )
    Column # 32    [PSAL= Salinity () 45 m]      ( date set 3 )
    Column # 33    [LOTH1= Nitrate (uM) at 1 m]      ( date set 3 )
    Column # 34    [LOTH1= Ammonia (uM) at 1 m]      ( date set 3 )
    Column # 35    [LOTH1= Phosphate (uM) at 1 m]      ( date set 3 )
    Column # 36    [LOTH1= Silicate (uM) at 1 m]      ( date set 3 )
    Column # 37    [LOTH1= Nitrate (uM) at 45 m]      ( date set 3 )
    Column # 38    [LOTH1= Ammonia (uM) at 45 m]      ( date set 3 )
    Column # 39    [LOTH1= Phosphate (uM) at 45 m]      ( date set 3 )
    Column # 40    [LOTH1= Silicate (uM) at 45 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT6= Total Copepods (#/m3) ]
        Column # 3   [ ABDT6= Total Calanoids (#/m3) ]
        Column # 4   [ ABDT1= Calanus finmarchicus C5-6 (#/m3) ]
        Column # 5   [ ABDT1= Calanus helgolandicus C5-6 (#/m3) ]
        Column # 6   [ ABDT2= Euphausiids (#/m3) ]
        Column # 7   [ ABDT2= Cnidaria (#/m3) ]
        Column # 8   [ ABDT2= Chaetognatha (#/m3) ]
        Column # 9   [ ABDT2= Echinodermata larvae (#/m3) ]
        Column # 10   [ ABDT2= Bryozoa larvae (#/m3) ]
        Column # 11   [ ABDT2= Decapoda larvae (#/m3) ]
        Column # 12   [ ABDT2= Polychaeta (#/m3) ]
        Column # 13   [ ABDT2= Bivalvia larvae (#/m3) ]
        Column # 14   [ ABDT4= Pseudocalanus elongatus (#/m3) ]
        Column # 15   [ ABDT4= Acartia clausii (#/m3) ]
        Column # 16   [ ABDT4= Cladocerans (#/m3) ]
        Column # 17   [ ABDT4= Oithonidae spp (#/m3) ]
        Column # 18   [ ABDT4= Cirripedia larvae (#/m3) ]
        Column # 19   [ ABDT4= Larvacea (#/m3) ]
        Column # 20   [ ABDT4= Temora longicornis (#/m3) ]
        Column # 21   [ ABDT4= Gastropoda (#/m3) ]
        Column # 22   [ ABDT4= Calanus spp. C1-4 (#/m3) ]
        Column # 23   [ ABDT4= Paracalanus parvus (#/m3) ]
        Column # 25   [ ABDT1= Total diatoms (cells/L) ]
        Column # 26   [ ABDT1= Total dinoflagellates (cells/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 33   [ LOTH1= Nitrate (uM) at 1 m ]
        Column # 34   [ LOTH1= Ammonia (uM) at 1 m ]
        Column # 35   [ LOTH1= Phosphate (uM) at 1 m ]
        Column # 36   [ LOTH1= Silicate (uM) at 1 m ]
        Column # 37   [ LOTH1= Nitrate (uM) at 45 m ]
        Column # 38   [ LOTH1= Ammonia (uM) at 45 m ]
        Column # 39   [ LOTH1= Phosphate (uM) at 45 m ]
        Column # 40   [ LOTH1= Silicate (uM) at 45 m ]

    Temperatures Category
        Column # 29   [ TEMP= Temperature (C) at 1 m ]
        Column # 30   [ TEMP= Temperature (C) at 45 m ]

    Salinities Category
        Column # 31   [ PSAL= Salinity () 1 m ]
        Column # 32   [ PSAL= Salinity () 45 m ]

    Chlorophyll/Pigments Category
        Column # 27   [ CHLA= Chlorophyll (ug/l) averaged from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 4     [ ABDT1= Calanus finmarchicus C5-6 (#/m3) ]
        column # 5     [ ABDT1= Calanus helgolandicus C5-6 (#/m3) ]
        column # 25     [ ABDT1= Total diatoms (cells/L) ]
        column # 26     [ ABDT1= Total dinoflagellates (cells/L) ]

    Category 8 Group # 2
        column # 6     [ ABDT2= Euphausiids (#/m3) ]
        column # 7     [ ABDT2= Cnidaria (#/m3) ]
        column # 8     [ ABDT2= Chaetognatha (#/m3) ]
        column # 9     [ ABDT2= Echinodermata larvae (#/m3) ]
        column # 10     [ ABDT2= Bryozoa larvae (#/m3) ]
        column # 11     [ ABDT2= Decapoda larvae (#/m3) ]
        column # 12     [ ABDT2= Polychaeta (#/m3) ]
        column # 13     [ ABDT2= Bivalvia larvae (#/m3) ]

    Category 8 Group # 4
        column # 14     [ ABDT4= Pseudocalanus elongatus (#/m3) ]
        column # 15     [ ABDT4= Acartia clausii (#/m3) ]
        column # 16     [ ABDT4= Cladocerans (#/m3) ]
        column # 17     [ ABDT4= Oithonidae spp (#/m3) ]
        column # 18     [ ABDT4= Cirripedia larvae (#/m3) ]
        column # 19     [ ABDT4= Larvacea (#/m3) ]
        column # 20     [ ABDT4= Temora longicornis (#/m3) ]
        column # 21     [ ABDT4= Gastropoda (#/m3) ]
        column # 22     [ ABDT4= Calanus spp. C1-4 (#/m3) ]
        column # 23     [ ABDT4= Paracalanus parvus (#/m3) ]

    Category 8 Group # 6
        column # 2     [ ABDT6= Total Copepods (#/m3) ]
        column # 3     [ ABDT6= Total Calanoids (#/m3) ]

    Category 9 Group # 1
        column # 33     [ LOTH1= Nitrate (uM) at 1 m ]
        column # 34     [ LOTH1= Ammonia (uM) at 1 m ]
        column # 35     [ LOTH1= Phosphate (uM) at 1 m ]
        column # 36     [ LOTH1= Silicate (uM) at 1 m ]
        column # 37     [ LOTH1= Nitrate (uM) at 45 m ]
        column # 38     [ LOTH1= Ammonia (uM) at 45 m ]
        column # 39     [ LOTH1= Phosphate (uM) at 45 m ]
        column # 40     [ LOTH1= Silicate (uM) at 45 m ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2002 2010
DATES in Column 24 no problems detected 2002 2010
DATES in Column 28 no problems detected 2002 2010

 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 02 10
24 DATE-MDY DATE-MDY yes 1 12 1 31 2002 2010
28 DATE-MDY DATE-MDY yes 1 12 1 31 2002 2010


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT6= Total Copepods (#/m3) ] 		no problems detected 454 14.9410763 21892.8984 454
( 100%)		 454
( 100%)
Column 3 :
[ 05_ABDT6= Total Calanoids (#/m3) ] 		no problems detected 454 6.82092619 19931.0703 454
( 100%)		 454
( 100%)
Column 4 :
[ 06_ABDT1= Calanus finmarchicus C5-6 (#/m3) ] 		no problems detected 454 0.324806005 237.757996 249
( 54%)		 121
( 26%)
Column 5 :
[ 07_ABDT1= Calanus helgolandicus C5-6 (#/m3) ] 		no problems detected 454 0.324806005 311.488953 414
( 91%)		 338
( 74%)
Column 6 :
[ 08_ABDT2= Euphausiids (#/m3) ] 		no problems detected 454 0.324806005 166.625488 291
( 64%)		 206
( 45%)
Column 7 :
[ 09_ABDT2= Cnidaria (#/m3) ] 		no problems detected 454 0.324806005 3472.82593 400
( 88%)		 340
( 74%)
Column 8 :
[ 10_ABDT2= Chaetognatha (#/m3) ] 		no problems detected 454 0.324806005 474.216766 423
( 93%)		 342
( 75%)
Column 9 :
[ 11_ABDT2= Echinodermata larvae (#/m3) ] 		no problems detected 454 0.324806005 155.906876 153
( 33%)		 137
( 30%)
Column 10 :
[ 12_ABDT2= Bryozoa larvae (#/m3) ] 		no problems detected 454 0.324806005 1442.13867 409
( 90%)		 386
( 85%)
Column 11 :
[ 13_ABDT2= Decapoda larvae (#/m3) ] 		no problems detected 454 0.324806005 595.369385 419
( 92%)		 351
( 77%)
Column 12 :
[ 14_ABDT2= Polychaeta (#/m3) ] 		no problems detected 454 0.324806005 389.767212 413
( 90%)		 404
( 88%)
Column 13 :
[ 15_ABDT2= Bivalvia larvae (#/m3) ] 		no problems detected 454 0.324806005 1792.9292 421
( 92%)		 412
( 90%)
Column 14 :
[ 16_ABDT4= Pseudocalanus elongatus (#/m3) ] 		no problems detected 454 0.974418044 9926.07129 454
( 100%)		 453
( 99%)
Column 15 :
[ 17_ABDT4= Acartia clausii (#/m3) ] 		no problems detected 454 0.324806005 6418.1665 454
( 100%)		 451
( 99%)
Column 16 :
[ 18_ABDT4= Cladocerans (#/m3) ] 		no problems detected 454 0.324806005 19956.0801 351
( 77%)		 304
( 66%)
Column 17 :
[ 19_ABDT4= Oithonidae spp (#/m3) ] 		no problems detected 454 0.64961201 13018.2246 452
( 99%)		 450
( 99%)
Column 18 :
[ 20_ABDT4= Cirripedia larvae (#/m3) ] 		no problems detected 454 0.324806005 21567.1191 401
( 88%)		 361
( 79%)
Column 19 :
[ 21_ABDT4= Larvacea (#/m3) ] 		no problems detected 454 0.324806005 2871.28516 438
( 96%)		 428
( 94%)
Column 20 :
[ 22_ABDT4= Temora longicornis (#/m3) ] 		no problems detected 454 0.324806005 3845.70312 396
( 87%)		 360
( 79%)
Column 21 :
[ 23_ABDT4= Gastropoda (#/m3) ] 		no problems detected 454 0.324806005 4066.896 442
( 97%)		 435
( 95%)
Column 22 :
[ 24_ABDT4= Calanus spp. C1-4 (#/m3) ] 		no problems detected 454 0.324806005 3429.95142 391
( 86%)		 347
( 76%)
Column 23 :
[ 25_ABDT4= Paracalanus parvus (#/m3) ] 		no problems detected 454 0.324806005 2234.66528 441
( 97%)		 434
( 95%)
Column 25 :
[ 26_ABDT1= Total diatoms (cells/L) ] 		no problems detected 445 952. 3840977. 395
( 88%)		 395
( 88%)
Column 26 :
[ 27_ABDT1= Total dinoflagellates (cells/L) ] 		no problems detected 445 952. 755332. 282
( 63%)		 282
( 63%)
Column 27 :
[ 28_CHLA= Chlorophyll (ug/l) averaged from 0-10 m ] 		no problems detected 440 -0.0500000007 8.39999962 429
( 97%)		 218
( 49%)
Column 29 :
[ 29_TEMP= Temperature (C) at 1 m ] 		no problems detected 456 6.15409994 14.776 456
( 100%)		 456
( 100%)
Column 30 :
[ 30_TEMP= Temperature (C) at 45 m ] 		no problems detected 444 6.99690008 13.8179998 444
( 100%)		 444
( 100%)
Column 31 :
[ 31_PSAL= Salinity () 1 m ] 		no problems detected 453 29.3812008 34.9846001 453
( 100%)		 453
( 100%)
Column 32 :
[ 32_PSAL= Salinity () 45 m ] 		no problems detected 441 31.9698009 35.0727005 441
( 100%)		 441
( 100%)
Column 33 :
[ 33_LOTH1= Nitrate (uM) at 1 m ] 		no problems detected 440 0.00999999978 8.69999981 395
( 89%)		 254
( 57%)
Column 34 :
[ 34_LOTH1= Ammonia (uM) at 1 m ] 		no problems detected 415 0.0599999987 6.5 374
( 90%)		 115
( 27%)
Column 35 :
[ 35_LOTH1= Phosphate (uM) at 1 m ] 		no problems detected 443 0.00700000022 1.45000005 414
( 93%)		 4
( 0%)
Column 36 :
[ 36_LOTH1= Silicate (uM) at 1 m ] 		no problems detected 424 0.0299999993 10.8100004 422
( 99%)		 347
( 81%)
Column 37 :
[ 37_LOTH1= Nitrate (uM) at 45 m ] 		no problems detected 430 0.00999999978 9.68000031 409
( 95%)		 330
( 76%)
Column 38 :
[ 38_LOTH1= Ammonia (uM) at 45 m ] 		no problems detected 404 0.0879999995 6.4000001 380
( 94%)		 173
( 42%)
Column 39 :
[ 39_LOTH1= Phosphate (uM) at 45 m ] 		no problems detected 431 0.00999999978 1.36000001 417
( 96%)		 3
( 0%)
Column 40 :
[ 40_LOTH1= Silicate (uM) at 45 m ] 		no problems detected 411 0.0939999968 11.7200003 410
( 99%)		 387
( 94%)

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