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= Acartia (#/m3)]      ( date set 1 )
    Column # 4    [ABND1= Pseudocalanus (#/m3)]      ( date set 1 )
    Column # 5    [ABND1= Cladocera (#/m3)]      ( date set 1 )
    Column # 6    [LOTH2= Ratio of Pseudocalanus to Acartia (ratio)]      ( date set 1 )
    Column # 7    [LOTH2= Ratio of Cladocerans to Copepods (ratio)]      ( date set 1 )

    Column # 8     [ DATE-YMD ]       Date Set = 2
    Column # 9    [ABDT1= Total Phytoplankton (ug/l)]      ( date set 2 )
    Column # 10    [ABDT2= Total Cyanobacteria (ug/l)]      ( date set 2 )
    Column # 11    [ABDT2= Total Chlorophyceae (ug/l)]      ( date set 2 )
    Column # 12    [ABDT2= Total Chrysophyceae (ug/l)]      ( date set 2 )
    Column # 13    [ABDT1= Total Diatomophyceae (ug/l)]      ( date set 2 )
    Column # 14    [ABDT2= Total Cryptophyceae (ug/l)]      ( date set 2 )
    Column # 15    [ABDT2= Total Euglenophyceae (ug/l)]      ( date set 2 )
    Column # 16    [ABDT2= Total Prymnesiophyceae (ug/l)]      ( date set 2 )
    Column # 17    [ABDT2= Total Prasinophyceae (ug/l)]      ( date set 2 )
    Column # 18    [ABDT1= Total Dinophyceae (ug/l)]      ( date set 2 )
    Column # 19    [ABDT2= Total Craspedophyceae (ug/l)]      ( date set 2 )
    Column # 20    [ABDT2= Total Ciliophora (ug/l)]      ( date set 2 )
    Column # 21    [ABDT2= Remaining unidentified Phytoplankton (ug/l)]      ( date set 2 )

    Column # 22     [ DATE-YMD ]       Date Set = 3
    Column # 23    [CHLA= Average Chlorophyll (mg/m3) from 0-10m]      ( date set 3 )
    Column # 24    [TEMP= Average Temperature ( C ) from 0-10m]      ( date set 3 )
    Column # 25    [PSAL= Average Salinity () from 0-10m]      ( date set 3 )
    Column # 26    [OTHR= Average Oxygen (ml/l) from 0-10m]      ( date set 3 )
    Column # 27    [LOTH= Average NO3 (mmol/m3) from 0-10m]      ( date set 3 )
    Column # 28    [LOTH= Average NO2 (mmol/m3) from 0-10m]      ( date set 3 )
    Column # 29    [LOTH= Average NH4 (mmol/m3) from 0-10m]      ( date set 3 )
    Column # 30    [LOTH= Average PO4 (mmol/m3) from 0-10m]      ( date set 3 )
    Column # 31    [LOTH= Average Si04 (mmol/m3) from 0-10m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]
        Column # 3   [ ABND1= Acartia (#/m3) ]
        Column # 4   [ ABND1= Pseudocalanus (#/m3) ]
        Column # 5   [ ABND1= Cladocera (#/m3) ]

    Abundance (with zeros) Category
        Column # 9   [ ABDT1= Total Phytoplankton (ug/l) ]
        Column # 10   [ ABDT2= Total Cyanobacteria (ug/l) ]
        Column # 11   [ ABDT2= Total Chlorophyceae (ug/l) ]
        Column # 12   [ ABDT2= Total Chrysophyceae (ug/l) ]
        Column # 13   [ ABDT1= Total Diatomophyceae (ug/l) ]
        Column # 14   [ ABDT2= Total Cryptophyceae (ug/l) ]
        Column # 15   [ ABDT2= Total Euglenophyceae (ug/l) ]
        Column # 16   [ ABDT2= Total Prymnesiophyceae (ug/l) ]
        Column # 17   [ ABDT2= Total Prasinophyceae (ug/l) ]
        Column # 18   [ ABDT1= Total Dinophyceae (ug/l) ]
        Column # 19   [ ABDT2= Total Craspedophyceae (ug/l) ]
        Column # 20   [ ABDT2= Total Ciliophora (ug/l) ]
        Column # 21   [ ABDT2= Remaining unidentified Phytoplankton (ug/l) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 6   [ LOTH2= Ratio of Pseudocalanus to Acartia (ratio) ]
        Column # 7   [ LOTH2= Ratio of Cladocerans to Copepods (ratio) ]
        Column # 27   [ LOTH= Average NO3 (mmol/m3) from 0-10m ]
        Column # 28   [ LOTH= Average NO2 (mmol/m3) from 0-10m ]
        Column # 29   [ LOTH= Average NH4 (mmol/m3) from 0-10m ]
        Column # 30   [ LOTH= Average PO4 (mmol/m3) from 0-10m ]
        Column # 31   [ LOTH= Average Si04 (mmol/m3) from 0-10m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 26   [ OTHR= Average Oxygen (ml/l) from 0-10m ]

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

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

    Chlorophyll/Pigments Category
        Column # 23   [ CHLA= Average Chlorophyll (mg/m3) from 0-10m ]

DATA SORTED BY GROUPING SETS:

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

    Category 8 Group # 1
        column # 9     [ ABDT1= Total Phytoplankton (ug/l) ]
        column # 13     [ ABDT1= Total Diatomophyceae (ug/l) ]
        column # 18     [ ABDT1= Total Dinophyceae (ug/l) ]

    Category 8 Group # 2
        column # 10     [ ABDT2= Total Cyanobacteria (ug/l) ]
        column # 11     [ ABDT2= Total Chlorophyceae (ug/l) ]
        column # 12     [ ABDT2= Total Chrysophyceae (ug/l) ]
        column # 14     [ ABDT2= Total Cryptophyceae (ug/l) ]
        column # 15     [ ABDT2= Total Euglenophyceae (ug/l) ]
        column # 16     [ ABDT2= Total Prymnesiophyceae (ug/l) ]
        column # 17     [ ABDT2= Total Prasinophyceae (ug/l) ]
        column # 19     [ ABDT2= Total Craspedophyceae (ug/l) ]
        column # 20     [ ABDT2= Total Ciliophora (ug/l) ]
        column # 21     [ ABDT2= Remaining unidentified Phytoplankton (ug/l) ]

    Category 9 Group # 2
        column # 6     [ LOTH2= Ratio of Pseudocalanus to Acartia (ratio) ]
        column # 7     [ LOTH2= Ratio of Cladocerans to Copepods (ratio) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1981 2015
DATES in Column 8 no problems detected 1979 2013
DATES in Column 22 no problems detected 1994 2016

 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 1981 2015 1 11 1 31
8 DATE-YMD DATE-YMD yes 1979 2013 01 12 01 31
22 DATE-YMD DATE-YMD yes 1994 2016 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 240 510. 48587. 240
( 100%)		 240
( 100%)
Column 3 :
[ 05_ABND1= Acartia (#/m3) ] 		no problems detected 240 46. 18652. 240
( 100%)		 240
( 100%)
Column 4 :
[ 06_ABND1= Pseudocalanus (#/m3) ] 		no problems detected 240 3. 11606. 240
( 100%)		 240
( 100%)
Column 5 :
[ 07_ABND1= Cladocera (#/m3) ] 		no problems detected 240 1. 111820. 100
( 41%)		 98
( 40%)
Column 6 :
[ 08_LOTH2= Ratio of Pseudocalanus to Acartia (ratio) ] 		no problems detected 240 0.000300000014 26.4122009 240
( 100%)		 72
( 30%)
Column 7 :
[ 09_LOTH2= Ratio of Cladocerans to Copepods (ratio) ] 		no problems detected 240 9.99999975E-05 11.0458002 104
( 43%)		 28
( 11%)
Column 9 :
[ 10_ABDT1= Total Phytoplankton (ug/l) ] 		no problems detected 928 9.17000008 32971.4688 928
( 100%)		 928
( 100%)
Column 10 :
[ 11_ABDT2= Total Cyanobacteria (ug/l) ] 		no problems detected 928 0.0199999996 10095.79 752
( 81%)		 604
( 65%)
Column 11 :
[ 12_ABDT2= Total Chlorophyceae (ug/l) ] 		no problems detected 928 0.00999999978 256. 546
( 58%)		 212
( 22%)
Column 12 :
[ 13_ABDT2= Total Chrysophyceae (ug/l) ] 		no problems detected 928 0.00999999978 829.150024 542
( 58%)		 361
( 38%)
Column 13 :
[ 14_ABDT1= Total Diatomophyceae (ug/l) ] 		no problems detected 928 0.0500000007 32172.8809 858
( 92%)		 823
( 88%)
Column 14 :
[ 15_ABDT2= Total Cryptophyceae (ug/l) ] 		no problems detected 928 0.0900000036 341.75 858
( 92%)		 850
( 91%)
Column 15 :
[ 16_ABDT2= Total Euglenophyceae (ug/l) ] 		no problems detected 928 0.0299999993 798.48999 641
( 69%)		 541
( 58%)
Column 16 :
[ 17_ABDT2= Total Prymnesiophyceae (ug/l) ] 		no problems detected 928 0.00999999978 676.950012 333
( 35%)		 216
( 23%)
Column 17 :
[ 18_ABDT2= Total Prasinophyceae (ug/l) ] 		no problems detected 928 0.0199999996 717.809998 690
( 74%)		 539
( 58%)
Column 18 :
[ 19_ABDT1= Total Dinophyceae (ug/l) ] 		no problems detected 928 0.0799999982 4449.75 870
( 93%)		 860
( 92%)
Column 19 :
[ 20_ABDT2= Total Craspedophyceae (ug/l) ] 		no problems detected 928 0.00999999978 786. 445
( 47%)		 117
( 12%)
Column 20 :
[ 21_ABDT2= Total Ciliophora (ug/l) ] 		no problems detected 928 0.0799999982 3653.22998 631
( 67%)		 613
( 66%)
Column 21 :
[ 22_ABDT2= Remaining unidentified Phytoplankton (ug/l) ] 		no problems detected 928 0.00999999978 2319.6499 818
( 88%)		 785
( 84%)
Column 23 :
[ 23_CHLA= Average Chlorophyll (mg/m3) from 0-10m ] 		no problems detected 502 0.133332998 14.8289003 502
( 100%)		 436
( 86%)
Column 24 :
[ 24_TEMP= Average Temperature ( C ) from 0-10m ] 		no problems detected 528 0.127553999 22.7371998 528
( 100%)		 516
( 97%)
Column 25 :
[ 25_PSAL= Average Salinity () from 0-10m ] 		no problems detected 533 6.81952 16.2140999 533
( 100%)		 533
( 100%)
Column 26 :
[ 26_OTHR= Average Oxygen (ml/l) from 0-10m ] 		no problems detected 528 5.75258017 10.9315004 528
( 100%)		 528
( 100%)
Column 27 :
[ 27_LOTH= Average NO3 (mmol/m3) from 0-10m ] 		no problems detected 513 1.6E-05 5.6719799 513
( 100%)		 134
( 26%)
Column 28 :
[ 28_LOTH= Average NO2 (mmol/m3) from 0-10m ] 		no problems detected 513 0.00100000005 1.17332995 513
( 100%)		 2
( 0%)
Column 29 :
[ 29_LOTH= Average NH4 (mmol/m3) from 0-10m ] 		no problems detected 197 0.00100000005 1.54489994 197
( 100%)		 2
( 1%)
Column 30 :
[ 30_LOTH= Average PO4 (mmol/m3) from 0-10m ] 		no problems detected 516 0.00100000005 0.898325026 516
( 100%)		 0
( 0%)
Column 31 :
[ 31_LOTH= Average Si04 (mmol/m3) from 0-10m ] 		no problems detected 512 0.00100000005 19.1082001 512
( 100%)		 508
( 99%)

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