COPEPODITE Incoming Data Review
Fatal Format Issues:   none


HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2    [ABND1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABND1= Acartia longiremis (#/m3)]      ( date set 1 )
    Column # 4    [ABND1= Pseudocalanus minutus (#/m3)]      ( date set 1 )
    Column # 5    [ABND1= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 6    [BIOM2= Acartia longiremis biomass (ug/m3)]      ( date set 1 )
    Column # 7    [BIOM2= Pseudocalanus minutus biomass (ug/m3)]      ( date set 1 )
    Column # 8    [BIOM2= Temora longicornis biomass (ug/m3)]      ( date set 1 )
    Column # 9     [OTHR3= Acartia longiremis relative abundance (% of three)]      ( date set 1 )
    Column # 10     [OTHR3= Pseudocalanus minutus relative abundance (% of three)]      ( date set 1 )
    Column # 11     [OTHR3= Temora longicornis relative abundance (% of three)]      ( date set 1 )

    Column # 12     [ DATE-MDY ]       Date Set = 2
    Column # 13    [ABND= Total Abundance (#/m3)]      ( date set 2 )
    Column # 14    [BIOM= Total Wet Mass (mg/m3)]      ( date set 2 )

    Column # 15     [ DATE-YMD ]       Date Set = 3
    Column # 16    [ABND5= Total Diatoms (ug/l)]      ( date set 3 )
    Column # 17    [ABND5= Total Dinoflagellates (ug/L)]      ( date set 3 )
    Column # 18    [ABND= Blue-green Algae (ug/L)]      ( date set 3 )
    Column # 19    [ABND= Green Algae (ug/L)]      ( date set 3 )
    Column # 20    [ABND= Mesodinium rubrum (ug/L)]      ( date set 3 )
    Column # 21    [ABND= Other autotrophic (ug/L)]      ( date set 3 )
    Column # 22    [ABND= Heterotrophic Dinoflagellates (ug/L)]      ( date set 3 )
    Column # 23    [ABND= Ciliata (ug/L)]      ( date set 3 )
    Column # 24    [ABND= Other heterotrophic (ug/L)]      ( date set 3 )

    Column # 25     [ DATE-YMD ]       Date Set = 4
    Column # 26    [TEMP= Average Temperature (C) from 0-10 m]      ( date set 4 )
    Column # 27    [PSAL= Average Salinity (pss) from 0-10 m]      ( date set 4 )
    Column # 28    [LOTH= Average PO4 (uM) from 0-10 m]      ( date set 4 )
    Column # 29    [LOTH= Average Total P (uM) from 0-10 m]      ( date set 4 )
    Column # 30    [LOTH= Average NO3 (uM) from 0-10 m]      ( date set 4 )
    Column # 31    [LOTH= Average NO2 (uM) from 0-10 m]      ( date set 4 )
    Column # 32    [LOTH= Average NH4 (uM) from 0-10 m]      ( date set 4 )
    Column # 33    [LOTH= Average Total N (uM) from 0-10 m]      ( date set 4 )
    Column # 34    [LOTH= Average Si (uM) from 0-10 m]      ( date set 4 )
    Column # 35    [CHLA= Average Chlorophyll-a (ug/L) from 0-10 m]      ( date set 4 )
    Column # 36    [CHLA= Average Phaeopigment (ug/L) from 0-10 m]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 6   [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        Column # 7   [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        Column # 8   [ BIOM2= Temora longicornis biomass (ug/m3) ]
        Column # 14   [ BIOM= Total Wet Mass (mg/m3) ]

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]
        Column # 3   [ ABND1= Acartia longiremis (#/m3) ]
        Column # 4   [ ABND1= Pseudocalanus minutus (#/m3) ]
        Column # 5   [ ABND1= Temora longicornis (#/m3) ]
        Column # 13   [ ABND= Total Abundance (#/m3) ]
        Column # 16   [ ABND5= Total Diatoms (ug/l) ]
        Column # 17   [ ABND5= Total Dinoflagellates (ug/L) ]
        Column # 18   [ ABND= Blue-green Algae (ug/L) ]
        Column # 19   [ ABND= Green Algae (ug/L) ]
        Column # 20   [ ABND= Mesodinium rubrum (ug/L) ]
        Column # 21   [ ABND= Other autotrophic (ug/L) ]
        Column # 22   [ ABND= Heterotrophic Dinoflagellates (ug/L) ]
        Column # 23   [ ABND= Ciliata (ug/L) ]
        Column # 24   [ ABND= Other heterotrophic (ug/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 28   [ LOTH= Average PO4 (uM) from 0-10 m ]
        Column # 29   [ LOTH= Average Total P (uM) from 0-10 m ]
        Column # 30   [ LOTH= Average NO3 (uM) from 0-10 m ]
        Column # 31   [ LOTH= Average NO2 (uM) from 0-10 m ]
        Column # 32   [ LOTH= Average NH4 (uM) from 0-10 m ]
        Column # 33   [ LOTH= Average Total N (uM) from 0-10 m ]
        Column # 34   [ LOTH= Average Si (uM) from 0-10 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 9   [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        Column # 10   [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        Column # 11   [ OTHR3= Temora longicornis relative abundance (% of three) ]

    Temperatures Category
        Column # 26   [ TEMP= Average Temperature (C) from 0-10 m ]

    Salinities Category
        Column # 27   [ PSAL= Average Salinity (pss) from 0-10 m ]

    Chlorophyll/Pigments Category
        Column # 35   [ CHLA= Average Chlorophyll-a (ug/L) from 0-10 m ]
        Column # 36   [ CHLA= Average Phaeopigment (ug/L) from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 2
        column # 6     [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        column # 7     [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        column # 8     [ BIOM2= Temora longicornis biomass (ug/m3) ]

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]
        column # 3     [ ABND1= Acartia longiremis (#/m3) ]
        column # 4     [ ABND1= Pseudocalanus minutus (#/m3) ]
        column # 5     [ ABND1= Temora longicornis (#/m3) ]

    Category 2 Group # 5
        column # 16     [ ABND5= Total Diatoms (ug/l) ]
        column # 17     [ ABND5= Total Dinoflagellates (ug/L) ]

    Category 6 Group # 3
        column # 9     [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        column # 10     [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        column # 11     [ OTHR3= Temora longicornis relative abundance (% of three) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1979 2010
DATES in Column 12 no problems detected 2007 2010
DATES in Column 15 no problems detected 2005 2010
DATES in Column 25 no problems detected 1977 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 3 12 2 31 1979 2010
12 DATE-MDY DATE-MDY yes 4 11 2 29 2007 2010
15 DATE-YMD DATE-YMD yes 2005 2010 04 08 01 30
25 DATE-YMD DATE-YMD yes 1977 2010 02 12 01 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 103 131. 18881. 103
( 100%)		 103
( 100%)
Column 3 :
[ 05_ABND1= Acartia longiremis (#/m3) ] 		no problems detected 103 18. 2958. 103
( 100%)		 103
( 100%)
Column 4 :
[ 06_ABND1= Pseudocalanus minutus (#/m3) ] 		no problems detected 103 24. 11209. 103
( 100%)		 103
( 100%)
Column 5 :
[ 07_ABND1= Temora longicornis (#/m3) ] 		no problems detected 103 10. 12161. 102
( 99%)		 102
( 99%)
Column 6 :
[ 08_BIOM2= Acartia longiremis biomass (ug/m3) ] 		no problems detected 103 1. 183723. 103
( 100%)		 102
( 99%)
Column 7 :
[ 09_BIOM2= Pseudocalanus minutus biomass (ug/m3) ] 		no problems detected 103 3. 300891. 103
( 100%)		 103
( 100%)
Column 8 :
[ 10_BIOM2= Temora longicornis biomass (ug/m3) ] 		no problems detected 103 3. 342235. 102
( 99%)		 102
( 99%)
Column 9 :
[ 11_OTHR3= Acartia longiremis relative abundance (% of three) ] 		no problems detected 103 1.54999995 78.8000031 103
( 100%)		 103
( 100%)
Column 10 :
[ 12_OTHR3= Pseudocalanus minutus relative abundance (% of three) ] 		no problems detected 103 2.5 96.8499985 103
( 100%)		 103
( 100%)
Column 11 :
[ 13_OTHR3= Temora longicornis relative abundance (% of three) ] 		no problems detected 103 0.449999988 80.0800018 102
( 99%)		 101
( 98%)
Column 13 :
[ 14_ABND= Total Abundance (#/m3) ] 		no problems detected 19 1021. 69475. 19
( 100%)		 19
( 100%)
Column 14 :
[ 15_BIOM= Total Wet Mass (mg/m3) ] 		no problems detected 19 15. 575. 19
( 100%)		 19
( 100%)
Column 16 :
[ 16_ABND5= Total Diatoms (ug/l) ] 		no problems detected 69 0.180000007 382.559998 67
( 97%)		 65
( 94%)
Column 17 :
[ 17_ABND5= Total Dinoflagellates (ug/L) ] 		no problems detected 69 4.57999992 767.669983 69
( 100%)		 69
( 100%)
Column 18 :
[ 18_ABND= Blue-green Algae (ug/L) ] 		no problems detected 69 0.430000007 610.97998 68
( 98%)		 64
( 92%)
Column 19 :
[ 19_ABND= Green Algae (ug/L) ] 		no problems detected 69 1. 204.410004 68
( 98%)		 67
( 97%)
Column 20 :
[ 20_ABND= Mesodinium rubrum (ug/L) ] 		no problems detected 69 2.45000005 1666.18005 69
( 100%)		 69
( 100%)
Column 21 :
[ 21_ABND= Other autotrophic (ug/L) ] 		no problems detected 69 24.5200005 1761.26001 69
( 100%)		 69
( 100%)
Column 22 :
[ 22_ABND= Heterotrophic Dinoflagellates (ug/L) ] 		no problems detected 69 3.11999989 255.110001 69
( 100%)		 69
( 100%)
Column 23 :
[ 23_ABND= Ciliata (ug/L) ] 		no problems detected 62 16.0300007 466.679993 62
( 100%)		 62
( 100%)
Column 24 :
[ 24_ABND= Other heterotrophic (ug/L) ] 		no problems detected 69 0.540000021 73.4300003 69
( 100%)		 63
( 91%)
Column 26 :
[ 25_TEMP= Average Temperature (C) from 0-10 m ] 		no problems detected 201 0.409999996 22.2583008 201
( 100%)		 196
( 97%)
Column 27 :
[ 26_PSAL= Average Salinity (pss) from 0-10 m ] 		no problems detected 199 5.6967001 8.96500015 199
( 100%)		 199
( 100%)
Column 28 :
[ 27_LOTH= Average PO4 (uM) from 0-10 m ] 		no problems detected 129 0.00170000002 0.790000021 128
( 99%)		 0
( 0%)
Column 29 :
[ 28_LOTH= Average Total P (uM) from 0-10 m ] 		no problems detected 93 0.193299994 1.51329994 93
( 100%)		 8
( 8%)
Column 30 :
[ 29_LOTH= Average NO3 (uM) from 0-10 m ] 		no problems detected 112 0.0132999998 5.64499998 110
( 98%)		 12
( 10%)
Column 31 :
[ 30_LOTH= Average NO2 (uM) from 0-10 m ] 		no problems detected 112 0.00170000002 0.47330001 77
( 68%)		 0
( 0%)
Column 32 :
[ 31_LOTH= Average NH4 (uM) from 0-10 m ] 		no problems detected 104 0.0132999998 2.3433001 102
( 98%)		 8
( 7%)
Column 33 :
[ 32_LOTH= Average Total N (uM) from 0-10 m ] 		no problems detected 92 0.936699986 38.3833008 92
( 100%)		 91
( 98%)
Column 34 :
[ 33_LOTH= Average Si (uM) from 0-10 m ] 		no problems detected 95 0.136700004 22.9883003 95
( 100%)		 94
( 98%)
Column 35 :
[ 34_CHLA= Average Chlorophyll-a (ug/L) from 0-10 m ] 		no problems detected 196 0.143299997 34.1133003 196
( 100%)		 161
( 82%)
Column 36 :
[ 35_CHLA= Average Phaeopigment (ug/L) from 0-10 m ] 		no problems detected 116 0.136700004 16.4167004 116
( 100%)		 40
( 34%)

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