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    [ABND1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABND1= Total Zooplankton (#/m3)]      ( date set 1 )
    Column # 4    [BIOM= Total Dry Mass (mg/m3)]      ( date set 1 )
    Column # 5     [OTHR1= Relative Copepod Abundance (% of Total Zooplankton)]      ( date set 1 )

    Column # 6     [ DATE-MDY ]       Date Set = 2
    Column # 7    [ABND2= Total Diatoms (#/ml)]      ( date set 2 )
    Column # 8    [ABND2= Total Dinoflagellates (#/ml)]      ( date set 2 )
    Column # 9    [ABND2= Total Coccolithophores (#/ml)]      ( date set 2 )
    Column # 10    [ABND= Total other Flagellates (#/ml)]      ( date set 2 )
    Column # 11    [ABND2= Total Phytoplankton (#/ml)]      ( date set 2 )
    Column # 12    [OTHR1= Relative abundance of Diatoms (%)]      ( date set 2 )
    Column # 13    [OTHR1= Relative abundance of Dinoflagellates (%)]      ( date set 2 )
    Column # 14    [OTHR1= Relative abundance of Coccolithophores (%)]      ( date set 2 )
    Column # 15    [OTHR1= Relative abundance of other Flagellates (%)]      ( date set 2 )

    Column # 16     [ DATE-YMD ]       Date Set = 3
    Column # 17    [CHLA= Chlorophyll a (mg/m3)]      ( date set 3 )

    Column # 18     [ DATE-YMD ]       Date Set = 4
    Column # 19    [TEMP= Temperature (C)]      ( date set 4 )

    Column # 20     [ DATE-YMD ]       Date Set = 5
    Column # 21    [PSAL= Salinity ()]      ( date set 5 )

    Column # 22     [ DATE-YMD ]       Date Set = 6
    Column # 23    [LOTH= Nitrate (mmol/m3)]      ( date set 6 )

    Column # 24     [ DATE-YMD ]       Date Set = 7
    Column # 25    [LOTH= Phosphate (mmol/m3)]      ( date set 7 )

    Column # 26     [ DATE-YMD ]       Date Set = 8
    Column # 27    [LOTH= Silicate (mmol/m3)]      ( date set 8 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 4   [ BIOM= Total Dry Mass (mg/m3) ]

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]
        Column # 3   [ ABND1= Total Zooplankton (#/m3) ]
        Column # 7   [ ABND2= Total Diatoms (#/ml) ]
        Column # 8   [ ABND2= Total Dinoflagellates (#/ml) ]
        Column # 9   [ ABND2= Total Coccolithophores (#/ml) ]
        Column # 10   [ ABND= Total other Flagellates (#/ml) ]
        Column # 11   [ ABND2= Total Phytoplankton (#/ml) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 23   [ LOTH= Nitrate (mmol/m3) ]
        Column # 25   [ LOTH= Phosphate (mmol/m3) ]
        Column # 27   [ LOTH= Silicate (mmol/m3) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 5   [ OTHR1= Relative Copepod Abundance (% of Total Zooplankton) ]
        Column # 12   [ OTHR1= Relative abundance of Diatoms (%) ]
        Column # 13   [ OTHR1= Relative abundance of Dinoflagellates (%) ]
        Column # 14   [ OTHR1= Relative abundance of Coccolithophores (%) ]
        Column # 15   [ OTHR1= Relative abundance of other Flagellates (%) ]

    Temperatures Category
        Column # 19   [ TEMP= Temperature (C) ]

    Salinities Category
        Column # 21   [ PSAL= Salinity () ]

    Chlorophyll/Pigments Category
        Column # 17   [ CHLA= Chlorophyll a (mg/m3) ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]
        column # 3     [ ABND1= Total Zooplankton (#/m3) ]

    Category 2 Group # 2
        column # 7     [ ABND2= Total Diatoms (#/ml) ]
        column # 8     [ ABND2= Total Dinoflagellates (#/ml) ]
        column # 9     [ ABND2= Total Coccolithophores (#/ml) ]
        column # 11     [ ABND2= Total Phytoplankton (#/ml) ]

    Category 6 Group # 1
        column # 5     [ OTHR1= Relative Copepod Abundance (% of Total Zooplankton) ]
        column # 12     [ OTHR1= Relative abundance of Diatoms (%) ]
        column # 13     [ OTHR1= Relative abundance of Dinoflagellates (%) ]
        column # 14     [ OTHR1= Relative abundance of Coccolithophores (%) ]
        column # 15     [ OTHR1= Relative abundance of other Flagellates (%) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1984 2015
DATES in Column 6 no problems detected 1984 2015
DATES in Column 16 no problems detected 1984 2014
DATES in Column 18 no problems detected 1984 2014
DATES in Column 20 no problems detected 1984 2014
DATES in Column 22 no problems detected 1984 2014
DATES in Column 24 no problems detected 1984 2014
DATES in Column 26 no problems detected 1984 2014

 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 1984 2015 01 12 15 15
6 DATE-MDY DATE-MDY yes 1 12 1 31 1984 2015
16 DATE-YMD DATE-YMD yes 1984 2014 1 12 1 31
18 DATE-YMD DATE-YMD yes 1984 2014 1 12 1 31
20 DATE-YMD DATE-YMD yes 1984 2014 1 12 1 31
22 DATE-YMD DATE-YMD yes 1984 2014 1 12 1 31
24 DATE-YMD DATE-YMD yes 1984 2014 1 12 1 31
26 DATE-YMD DATE-YMD yes 1984 2014 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_ABND1= Total Copepods (#/m3) ] 		no problems detected 330 109.900002 4993.97021 330
( 100%)		 330
( 100%)
Column 3 :
[ 05_ABND1= Total Zooplankton (#/m3) ] 		no problems detected 330 167.360001 7544.6001 330
( 100%)		 330
( 100%)
Column 4 :
[ 06_BIOM= Total Dry Mass (mg/m3) ] 		no problems detected 330 1.29999995 23.8400002 330
( 100%)		 330
( 100%)
Column 5 :
[ 07_OTHR1= Relative Copepod Abundance (% of Total Zooplankton) ] 		no problems detected 330 7.19999981 97.0999985 330
( 100%)		 330
( 100%)
Column 7 :
[ 08_ABND2= Total Diatoms (#/ml) ] 		no problems detected 1154 2.97000003 185447.969 1154
( 100%)		 1154
( 100%)
Column 8 :
[ 09_ABND2= Total Dinoflagellates (#/ml) ] 		no problems detected 1154 1.32000005 3400. 1151
( 99%)		 1151
( 99%)
Column 9 :
[ 10_ABND2= Total Coccolithophores (#/ml) ] 		no problems detected 1154 3.28999996 10795. 1127
( 97%)		 1127
( 97%)
Column 10 :
[ 11_ABND= Total other Flagellates (#/ml) ] 		no problems detected 1154 16.7999992 42619.3086 1154
( 100%)		 1154
( 100%)
Column 11 :
[ 12_ABND2= Total Phytoplankton (#/ml) ] 		no problems detected 1154 75.3700027 223384.703 1154
( 100%)		 1154
( 100%)
Column 12 :
[ 13_OTHR1= Relative abundance of Diatoms (%) ] 		no problems detected 1154 0.200000003 98.4000015 1154
( 100%)		 1149
( 99%)
Column 13 :
[ 14_OTHR1= Relative abundance of Dinoflagellates (%) ] 		no problems detected 1154 0.100000001 42.2999992 1151
( 99%)		 910
( 78%)
Column 14 :
[ 15_OTHR1= Relative abundance of Coccolithophores (%) ] 		no problems detected 1154 0.100000001 66.1999969 1126
( 97%)		 773
( 66%)
Column 15 :
[ 16_OTHR1= Relative abundance of other Flagellates (%) ] 		no problems detected 1154 1.20000005 97.0999985 1154
( 100%)		 1154
( 100%)
Column 17 :
[ 17_CHLA= Chlorophyll a (mg/m3) ] 		no problems detected 1009 0.0900000036 12.7200003 1009
( 100%)		 523
( 51%)
Column 19 :
[ 18_TEMP= Temperature (C) ] 		no problems detected 1014 12.3699999 28.9200001 1014
( 100%)		 1014
( 100%)
Column 21 :
[ 19_PSAL= Salinity () ] 		no problems detected 1009 36.2200012 38.3199997 1009
( 100%)		 1009
( 100%)
Column 23 :
[ 20_LOTH= Nitrate (mmol/m3) ] 		no problems detected 1011 0.00999999978 12.0200005 1003
( 99%)		 352
( 34%)
Column 25 :
[ 21_LOTH= Phosphate (mmol/m3) ] 		no problems detected 851 0.00999999978 0.389999986 850
( 99%)		 0
( 0%)
Column 27 :
[ 22_LOTH= Silicate (mmol/m3) ] 		no problems detected 947 0.00999999978 13.5799999 947
( 100%)		 624
( 65%)

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