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 Copepoda (#/m3)]      ( date set 1 )
    Column # 3    [ABDT= Calanus helgolandicus (#/m3)]      ( date set 1 )
    Column # 4    [ABDT= Euchaeta spp. (#/m3)]      ( date set 1 )
    Column # 5    [ABDT1= Cladocera spp. (#/m3)]      ( date set 1 )
    Column # 6    [ABDT1= Ostracoda (#/m3)]      ( date set 1 )
    Column # 7    [ABDT1= Appendicularia (#/m3)]      ( date set 1 )
    Column # 8    [ABDT1= Tunicata (#/m3)]      ( date set 1 )
    Column # 9    [ABDT1= Medusae (#/m3)]      ( date set 1 )
    Column # 10    [ABDT1= Chaetognatha (#/m3)]      ( date set 1 )
    Column # 11    [ABDT1= Polychaeta (#/m3)]      ( date set 1 )
    Column # 12    [ABDT1= Decapoda Larvae (#/m3)]      ( date set 1 )
    Column # 13    [ABDT= Creseis sp. (#/m3)]      ( date set 1 )
    Column # 14    [ABDT1= Mollusca Larvae (#/m3)]      ( date set 1 )
    Column # 15    [ABDT1= Echinodermata Larvae (#/m3)]      ( date set 1 )
    Column # 16    [ABDT3= Fish Larvae (#/m3)]      ( date set 1 )
    Column # 17    [ABDT3= Sardina pilchardus eggs (#/m3)]      ( date set 1 )
    Column # 18    [ABDT3= Engraulis encrasicolus eggs (#/m3)]      ( date set 1 )
    Column # 19    [ABDT3= Other Fish Eggs (#/m3)]      ( date set 1 )

    Column # 20     [ DATE-YMD ]       Date Set = 2
    Column # 21    [ABND1= Bacteria (cells x 1E6 / ml) at 0 m]      ( date set 2 )
    Column # 22    [ABND1= Bacteria (cells x 1E6 / ml) at 30 m]      ( date set 2 )
    Column # 23    [ABND1= Bacteria (cells x 1E6 / ml) at 100 m]      ( date set 2 )

    Column # 24     [ DATE-YMD ]       Date Set = 3
    Column # 25     [ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 0 m]      ( date set 3 )
    Column # 26     [ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 30 m]      ( date set 3 )
    Column # 27     [ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 100 m]      ( date set 3 )

    Column # 28     [ DATE-YMD ]       Date Set = 4
    Column # 29     [LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 0 m]      ( date set 4 )
    Column # 30     [LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 30 m]      ( date set 4 )
    Column # 31     [LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 100 m]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 21   [ ABND1= Bacteria (cells x 1E6 / ml) at 0 m ]
        Column # 22   [ ABND1= Bacteria (cells x 1E6 / ml) at 30 m ]
        Column # 23   [ ABND1= Bacteria (cells x 1E6 / ml) at 100 m ]
        Column # 25   [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 0 m ]
        Column # 26   [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 30 m ]
        Column # 27   [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 100 m ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepoda (#/m3) ]
        Column # 3   [ ABDT= Calanus helgolandicus (#/m3) ]
        Column # 4   [ ABDT= Euchaeta spp. (#/m3) ]
        Column # 5   [ ABDT1= Cladocera spp. (#/m3) ]
        Column # 6   [ ABDT1= Ostracoda (#/m3) ]
        Column # 7   [ ABDT1= Appendicularia (#/m3) ]
        Column # 8   [ ABDT1= Tunicata (#/m3) ]
        Column # 9   [ ABDT1= Medusae (#/m3) ]
        Column # 10   [ ABDT1= Chaetognatha (#/m3) ]
        Column # 11   [ ABDT1= Polychaeta (#/m3) ]
        Column # 12   [ ABDT1= Decapoda Larvae (#/m3) ]
        Column # 13   [ ABDT= Creseis sp. (#/m3) ]
        Column # 14   [ ABDT1= Mollusca Larvae (#/m3) ]
        Column # 15   [ ABDT1= Echinodermata Larvae (#/m3) ]
        Column # 16   [ ABDT3= Fish Larvae (#/m3) ]
        Column # 17   [ ABDT3= Sardina pilchardus eggs (#/m3) ]
        Column # 18   [ ABDT3= Engraulis encrasicolus eggs (#/m3) ]
        Column # 19   [ ABDT3= Other Fish Eggs (#/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 29   [ LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 0 m ]
        Column # 30   [ LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 30 m ]
        Column # 31   [ LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 100 m ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 21     [ ABND1= Bacteria (cells x 1E6 / ml) at 0 m ]
        column # 22     [ ABND1= Bacteria (cells x 1E6 / ml) at 30 m ]
        column # 23     [ ABND1= Bacteria (cells x 1E6 / ml) at 100 m ]

    Category 2 Group # 2
        column # 25     [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 0 m ]
        column # 26     [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 30 m ]
        column # 27     [ ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 100 m ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepoda (#/m3) ]
        column # 5     [ ABDT1= Cladocera spp. (#/m3) ]
        column # 6     [ ABDT1= Ostracoda (#/m3) ]
        column # 7     [ ABDT1= Appendicularia (#/m3) ]
        column # 8     [ ABDT1= Tunicata (#/m3) ]
        column # 9     [ ABDT1= Medusae (#/m3) ]
        column # 10     [ ABDT1= Chaetognatha (#/m3) ]
        column # 11     [ ABDT1= Polychaeta (#/m3) ]
        column # 12     [ ABDT1= Decapoda Larvae (#/m3) ]
        column # 14     [ ABDT1= Mollusca Larvae (#/m3) ]
        column # 15     [ ABDT1= Echinodermata Larvae (#/m3) ]

    Category 8 Group # 3
        column # 16     [ ABDT3= Fish Larvae (#/m3) ]
        column # 17     [ ABDT3= Sardina pilchardus eggs (#/m3) ]
        column # 18     [ ABDT3= Engraulis encrasicolus eggs (#/m3) ]
        column # 19     [ ABDT3= Other Fish Eggs (#/m3) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1959 2004
DATES in Column 20 no problems detected 1995 2010
DATES in Column 24 no problems detected 1997 2010
DATES in Column 28 no problems detected 1997 2010

 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 1959 2004 01 12 15 15
20 DATE-YMD DATE-YMD yes 1995 2010 01 12 15 15
24 DATE-YMD DATE-YMD yes 1997 2010 01 12 15 15
28 DATE-YMD DATE-YMD yes 1997 2010 01 12 15 15


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepoda (#/m3) ] 		no problems detected 416 13.6000004 815. 416
( 100%)		 416
( 100%)
Column 3 :
[ 05_ABDT= Calanus helgolandicus (#/m3) ] 		no problems detected 416 0.0500000007 42. 362
( 87%)		 136
( 32%)
Column 4 :
[ 06_ABDT= Euchaeta spp. (#/m3) ] 		no problems detected 416 0.100000001 19. 281
( 67%)		 142
( 34%)
Column 5 :
[ 07_ABDT1= Cladocera spp. (#/m3) ] 		no problems detected 416 0.100000001 816.299988 336
( 80%)		 273
( 65%)
Column 6 :
[ 08_ABDT1= Ostracoda (#/m3) ] 		no problems detected 230 0.100000001 15.6000004 184
( 80%)		 60
( 26%)
Column 7 :
[ 09_ABDT1= Appendicularia (#/m3) ] 		no problems detected 416 0.0500000007 214.300003 416
( 100%)		 390
( 93%)
Column 8 :
[ 10_ABDT1= Tunicata (#/m3) ] 		no problems detected 416 0.100000001 1398.59998 364
( 87%)		 261
( 62%)
Column 9 :
[ 11_ABDT1= Medusae (#/m3) ] 		no problems detected 416 0.100000001 162.600006 415
( 99%)		 373
( 89%)
Column 10 :
[ 12_ABDT1= Chaetognatha (#/m3) ] 		no problems detected 416 0.100000001 110.199997 413
( 99%)		 392
( 94%)
Column 11 :
[ 13_ABDT1= Polychaeta (#/m3) ] 		no problems detected 416 0.100000001 6.4000001 326
( 78%)		 42
( 10%)
Column 12 :
[ 14_ABDT1= Decapoda Larvae (#/m3) ] 		no problems detected 416 0.100000001 10.8999996 346
( 83%)		 161
( 38%)
Column 13 :
[ 15_ABDT= Creseis sp. (#/m3) ] 		no problems detected 230 0.100000001 91.1999969 170
( 73%)		 64
( 27%)
Column 14 :
[ 16_ABDT1= Mollusca Larvae (#/m3) ] 		no problems detected 416 0.0500000007 143.5 332
( 79%)		 198
( 47%)
Column 15 :
[ 17_ABDT1= Echinodermata Larvae (#/m3) ] 		no problems detected 230 0.0500000007 83. 120
( 52%)		 41
( 17%)
Column 16 :
[ 18_ABDT3= Fish Larvae (#/m3) ] 		no problems detected 416 0.100000001 6.4000001 298
( 71%)		 36
( 8%)
Column 17 :
[ 19_ABDT3= Sardina pilchardus eggs (#/m3) ] 		no problems detected 416 0.100000001 76.0999985 148
( 35%)		 19
( 4%)
Column 18 :
[ 20_ABDT3= Engraulis encrasicolus eggs (#/m3) ] 		no problems detected 416 0.100000001 7. 147
( 35%)		 20
( 4%)
Column 19 :
[ 21_ABDT3= Other Fish Eggs (#/m3) ] 		no problems detected 416 0.100000001 8.30000019 268
( 64%)		 17
( 4%)
Column 21 :
[ 22_ABND1= Bacteria (cells x 1E6 / ml) at 0 m ] 		no problems detected 156 0.140000001 2.4000001 156
( 100%)		 10
( 6%)
Column 22 :
[ 23_ABND1= Bacteria (cells x 1E6 / ml) at 30 m ] 		no problems detected 156 0.159999996 3.4000001 156
( 100%)		 12
( 7%)
Column 23 :
[ 24_ABND1= Bacteria (cells x 1E6 / ml) at 100 m ] 		no problems detected 156 0.0500000007 2.06999993 156
( 100%)		 10
( 6%)
Column 25 :
[ 25_ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 0 m ] 		no problems detected 136 0.00700000022 4.21999979 135
( 99%)		 30
( 22%)
Column 26 :
[ 26_ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 30 m ] 		no problems detected 136 0.00499999989 3.51999998 135
( 99%)		 23
( 16%)
Column 27 :
[ 27_ABND2= Heterotrophic Nanoplankton (cells x 1E3 / ml) at 100 m ] 		no problems detected 136 0.00700000022 1.98000002 133
( 97%)		 7
( 5%)
Column 29 :
[ 28_LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 0 m ] 		no problems detected 137 0.0199999996 12.25 137
( 100%)		 41
( 29%)
Column 30 :
[ 29_LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 30 m ] 		no problems detected 137 0.0260000005 14.1700001 137
( 100%)		 33
( 24%)
Column 31 :
[ 30_LOTH= Bacterial Production ( cells x 1E4 / ml / hour ) at 100 m ] 		no problems detected 137 0.0199999996 11.8599997 137
( 100%)		 35
( 25%)

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