COPEPODITE Incoming Data Review
Fatal Format Issues:   none

    Mild Data Warnings (non-numeric values):   1    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.



HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2     [ABDT= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3     [BIOM= Total Carbon Mass (ug-C/m3)]      ( date set 1 )
    Column # 4     [ABDT= Foraminifera (#/m3)]      ( date set 1 )
    Column # 5     [ABDT= Tintinnida (#/m3)]      ( date set 1 )
    Column # 6     [ABDT3= Medusae (#/m3)]      ( date set 1 )
    Column # 7     [ABDT3= Siphonophore (#/m3)]      ( date set 1 )
    Column # 8     [ABDT3= Ctenophora (#/m3)]      ( date set 1 )
    Column # 9     [ABDT3= Chaetognaths (#/m3)]      ( date set 1 )
    Column # 10     [ABDT3= Doliolida (#/m3)]      ( date set 1 )
    Column # 11     [ABDT3= Appendicularia (#/m3)]      ( date set 1 )
    Column # 12     [ABDT= Cladocerans (#/m3)]      ( date set 1 )
    Column # 13     [ABDT= Isopoda (#/m3)]      ( date set 1 )
    Column # 14     [ABDT= Amphipoda (#/m3)]      ( date set 1 )
    Column # 15     [ABDT= Euphausiids (#/m3)]      ( date set 1 )
    Column # 16     [ABDT= Decapoda (#/m3)]      ( date set 1 )

    Column # 17     [ DATE-MDY ]       Date Set = 2
    Column # 18     [ABDT5= Total Phytoplankton (cells/ml)]      ( date set 2 )
    Column # 19     [ABDT5= Total Diatoms (cells/ml)]      ( date set 2 )
    Column # 20     [ABDT5= Total Dinoflagellates (cells/ml)]      ( date set 2 )
    Column # 21     [ABDT5= Total Coccolithophorids (cells/ml)]      ( date set 2 )
    Column # 22     [ABDT= Total Flagellates (cells/ml)]      ( date set 2 )
    Column # 23     [ABDT= Total Phaeocystis (cells/ml)]      ( date set 2 )
    Column # 24     [ABDT= Total Ciliates (cells/ml)]      ( date set 2 )

    Column # 25     [ DATE-MDY ]       Date Set = 3
    Column # 26     [ABDT5= Total Phytoplankton (mg/ml)]      ( date set 3 )
    Column # 27     [ABDT5= Total Diatoms (mg/ml)]      ( date set 3 )
    Column # 28     [ABDT5= Total Dinoflagellates (mg/ml)]      ( date set 3 )
    Column # 29     [ABDT5= Total Coccolithophorids (mg/ml)]      ( date set 3 )
    Column # 30     [ABDT= Total Flagellates (mg/ml)]      ( date set 3 )
    Column # 31     [ABDT= Total Phaeocystis (mg/ml)]      ( date set 3 )
    Column # 32     [ABDT= Total Ciliates (mg/ml)]      ( date set 3 )

    Column # 33     [ DATE-DMY ]       Date Set = 4
    Column # 34     [ABDT8= Synechococcus spp. and Cyanobacteria (#/ml) from 0-15m]      ( date set 4 )
    Column # 35     [ABDT7= Picoeukaryotes (#/ml) from 0-15m]      ( date set 4 )
    Column # 36     [ABDT7= Nanoeukaryotes (#/ml) from 0-15m]      ( date set 4 )
    Column # 37     [ABDT7= Coccolithophores 5-8 um (#/ml) from 0-15m]      ( date set 4 )
    Column # 38     [ABDT7= Cryptophytes (#/ml) from 0-15m]      ( date set 4 )
    Column # 39     [ABDT7= Phaeocystis sp. cells (#/ml) from 0-15m]      ( date set 4 )
    Column # 40     [ABDT7= Dinoflagellates (#/ml) from 0-15m]      ( date set 4 )
    Column # 41     [ABDT7= Total Nanoeukaryotic Phytoplankton (#/ml) from 0-15m]      ( date set 4 )
    Column # 42     [ABDT7= Heterotrophic Nanoeukaryotes aka heterotrophic flagellates (#/ml) from 0-15m]      ( date set 4 )
    Column # 43     [ABDT8= Heterotrophic Bacteria with high DNA content (#/ml) from 0-15m]      ( date set 4 )
    Column # 44     [ABDT8= Heterotrophic Bacteria with low DNA content (#/ml) from 0-15m]      ( date set 4 )
    Column # 45     [ABDT8= Total Bacteria (#/ml) from 0-15m]      ( date set 4 )

    Column # 46     [ DATE-MDY ]       Date Set = 5
    Column # 47     [CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface]      ( date set 5 )

    Column # 48     [ DATE-MDY ]       Date Set = 6
    Column # 49     [TEMP= Temperature ( C ) at the surface]      ( date set 6 )
    Column # 50     [PSAL= Salinity () at the surface]      ( date set 6 )

    Column # 51     [ DATE-DMY ]       Date Set = 7
    Column # 52     [LOTH4= NO3+NO2 (uM) at the surface]      ( date set 7 )
    Column # 53     [LOTH4= Nitrite (uM) at the surface]      ( date set 7 )
    Column # 54     [LOTH4= Ammonia (uM) at the surface]      ( date set 7 )
    Column # 55     [LOTH4= Silicate (uM) at the surface]      ( date set 7 )
    Column # 56     [LOTH4= Phosphate (uM) at the surface]      ( date set 7 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT= Total Copepods (#/m3) ]
        Column # 4   [ ABDT= Foraminifera (#/m3) ]
        Column # 5   [ ABDT= Tintinnida (#/m3) ]
        Column # 6   [ ABDT3= Medusae (#/m3) ]
        Column # 7   [ ABDT3= Siphonophore (#/m3) ]
        Column # 8   [ ABDT3= Ctenophora (#/m3) ]
        Column # 9   [ ABDT3= Chaetognaths (#/m3) ]
        Column # 10   [ ABDT3= Doliolida (#/m3) ]
        Column # 11   [ ABDT3= Appendicularia (#/m3) ]
        Column # 12   [ ABDT= Cladocerans (#/m3) ]
        Column # 13   [ ABDT= Isopoda (#/m3) ]
        Column # 14   [ ABDT= Amphipoda (#/m3) ]
        Column # 15   [ ABDT= Euphausiids (#/m3) ]
        Column # 16   [ ABDT= Decapoda (#/m3) ]
        Column # 18   [ ABDT5= Total Phytoplankton (cells/ml) ]
        Column # 19   [ ABDT5= Total Diatoms (cells/ml) ]
        Column # 20   [ ABDT5= Total Dinoflagellates (cells/ml) ]
        Column # 21   [ ABDT5= Total Coccolithophorids (cells/ml) ]
        Column # 22   [ ABDT= Total Flagellates (cells/ml) ]
        Column # 23   [ ABDT= Total Phaeocystis (cells/ml) ]
        Column # 24   [ ABDT= Total Ciliates (cells/ml) ]
        Column # 26   [ ABDT5= Total Phytoplankton (mg/ml) ]
        Column # 27   [ ABDT5= Total Diatoms (mg/ml) ]
        Column # 28   [ ABDT5= Total Dinoflagellates (mg/ml) ]
        Column # 29   [ ABDT5= Total Coccolithophorids (mg/ml) ]
        Column # 30   [ ABDT= Total Flagellates (mg/ml) ]
        Column # 31   [ ABDT= Total Phaeocystis (mg/ml) ]
        Column # 32   [ ABDT= Total Ciliates (mg/ml) ]
        Column # 34   [ ABDT8= Synechococcus spp. and Cyanobacteria (#/ml) from 0-15m ]
        Column # 35   [ ABDT7= Picoeukaryotes (#/ml) from 0-15m ]
        Column # 36   [ ABDT7= Nanoeukaryotes (#/ml) from 0-15m ]
        Column # 37   [ ABDT7= Coccolithophores 5-8 um (#/ml) from 0-15m ]
        Column # 38   [ ABDT7= Cryptophytes (#/ml) from 0-15m ]
        Column # 39   [ ABDT7= Phaeocystis sp. cells (#/ml) from 0-15m ]
        Column # 40   [ ABDT7= Dinoflagellates (#/ml) from 0-15m ]
        Column # 41   [ ABDT7= Total Nanoeukaryotic Phytoplankton (#/ml) from 0-15m ]
        Column # 42   [ ABDT7= Heterotrophic Nanoeukaryotes aka heterotrophic flagellates (#/ml) from 0-15m ]
        Column # 43   [ ABDT8= Heterotrophic Bacteria with high DNA content (#/ml) from 0-15m ]
        Column # 44   [ ABDT8= Heterotrophic Bacteria with low DNA content (#/ml) from 0-15m ]
        Column # 45   [ ABDT8= Total Bacteria (#/ml) from 0-15m ]

    Temperatures Category
        Column # 49   [ TEMP= Temperature ( C ) at the surface ]

    Salinities Category
        Column # 50   [ PSAL= Salinity () at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 3
        column # 6     [ ABDT3= Medusae (#/m3) ]
        column # 7     [ ABDT3= Siphonophore (#/m3) ]
        column # 8     [ ABDT3= Ctenophora (#/m3) ]
        column # 9     [ ABDT3= Chaetognaths (#/m3) ]
        column # 10     [ ABDT3= Doliolida (#/m3) ]
        column # 11     [ ABDT3= Appendicularia (#/m3) ]

    Category 8 Group # 5
        column # 18     [ ABDT5= Total Phytoplankton (cells/ml) ]
        column # 19     [ ABDT5= Total Diatoms (cells/ml) ]
        column # 20     [ ABDT5= Total Dinoflagellates (cells/ml) ]
        column # 21     [ ABDT5= Total Coccolithophorids (cells/ml) ]
        column # 26     [ ABDT5= Total Phytoplankton (mg/ml) ]
        column # 27     [ ABDT5= Total Diatoms (mg/ml) ]
        column # 28     [ ABDT5= Total Dinoflagellates (mg/ml) ]
        column # 29     [ ABDT5= Total Coccolithophorids (mg/ml) ]

    Category 8 Group # 7
        column # 35     [ ABDT7= Picoeukaryotes (#/ml) from 0-15m ]
        column # 36     [ ABDT7= Nanoeukaryotes (#/ml) from 0-15m ]
        column # 37     [ ABDT7= Coccolithophores 5-8 um (#/ml) from 0-15m ]
        column # 38     [ ABDT7= Cryptophytes (#/ml) from 0-15m ]
        column # 39     [ ABDT7= Phaeocystis sp. cells (#/ml) from 0-15m ]
        column # 40     [ ABDT7= Dinoflagellates (#/ml) from 0-15m ]
        column # 41     [ ABDT7= Total Nanoeukaryotic Phytoplankton (#/ml) from 0-15m ]
        column # 42     [ ABDT7= Heterotrophic Nanoeukaryotes aka heterotrophic flagellates (#/ml) from 0-15m ]

    Category 8 Group # 8
        column # 34     [ ABDT8= Synechococcus spp. and Cyanobacteria (#/ml) from 0-15m ]
        column # 43     [ ABDT8= Heterotrophic Bacteria with high DNA content (#/ml) from 0-15m ]
        column # 44     [ ABDT8= Heterotrophic Bacteria with low DNA content (#/ml) from 0-15m ]
        column # 45     [ ABDT8= Total Bacteria (#/ml) from 0-15m ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1988 2017
DATES in Column 17 no problems detected 1992 2015
DATES in Column 25 no problems detected 1992 2015
DATES in Column 33 no problems detected 2007 2015
DATES in Column 46 no problems detected 1992 2018
DATES in Column 48 no problems detected 1988 2017
DATES in Column 51 no problems detected 2000 2018

 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 1988 2017 1 12 1 31
17 DATE-MDY DATE-MDY yes 1 12 1 31 1992 2015
25 DATE-MDY DATE-MDY yes 1 12 1 31 1992 2015
33 DATE-DMY DATE-DMY yes 1 31 01 12 2007 2015
46 DATE-MDY DATE-MDY yes 1 12 1 31 1992 2018
48 DATE-MDY DATE-MDY yes Apr 12 01 31 1988 2017
51 DATE-DMY DATE-DMY yes 1 31 01 12 2000 2018


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT= Total Copepods (#/m3) ] 		no problems detected 1317 3.63000011 15489.7305 1317
( 100 %)		 1317
( 100 %)
Column 3 :
[ 05_BIOM= Total Carbon Mass (ug-C/m3) ] 		no problems detected 1317 198.000000 233824.000 1317
( 100 %)		 1317
( 100 %)
Column 4 :
[ 06_ABDT= Foraminifera (#/m3) ] 		no problems detected 1317 0.109999999 8094.00977 22
( 1 %)		 14
( 1 %)
Column 5 :
[ 07_ABDT= Tintinnida (#/m3) ] 		no problems detected 1317 0.168421060 307.750000 21
( 1 %)		 19
( 1 %)
Column 6 :
[ 08_ABDT3= Medusae (#/m3) ] 		no problems detected 1317 3.99999991E-02 2283.91577 1010
( 76 %)		 902
( 68 %)
Column 7 :
[ 09_ABDT3= Siphonophore (#/m3) ] 		no problems detected 1317 3.82775106E-02 2254.73682 995
( 75 %)		 910
( 69 %)
Column 8 :
[ 10_ABDT3= Ctenophora (#/m3) ] 		no problems detected 1317 4.21052612E-02 70.7368393 259
( 19 %)		 130
( 9 %)
Column 9 :
[ 11_ABDT3= Chaetognaths (#/m3) ] 		no problems detected 1317 3.99999991E-02 568.340027 1185
( 89 %)		 1124
( 85 %)
Column 10 :
[ 12_ABDT3= Doliolida (#/m3) ] 		no problems detected 1317 7.99999982E-02 611.368408 154
( 11 %)		 102
( 7 %)
Column 11 :
[ 13_ABDT3= Appendicularia (#/m3) ] 		no problems detected 1317 3.99999991E-02 3159.96997 1076
( 81 %)		 1035
( 78 %)
Column 12 :
[ 14_ABDT= Cladocerans (#/m3) ] 		no problems detected 1317 3.99999991E-02 7634.04980 908
( 68 %)		 820
( 62 %)
Column 13 :
[ 15_ABDT= Isopoda (#/m3) ] 		no problems detected 1317 3.82775106E-02 12.6315794 206
( 15 %)		 52
( 3 %)
Column 14 :
[ 16_ABDT= Amphipoda (#/m3) ] 		no problems detected 1317 3.99999991E-02 103.230003 630
( 47 %)		 394
( 29 %)
Column 15 :
[ 17_ABDT= Euphausiids (#/m3) ] 		no problems detected 1317 3.86286825E-02 40.1599998 453
( 34 %)		 235
( 17 %)
Column 16 :
[ 18_ABDT= Decapoda (#/m3) ] 		no problems detected 1317 3.99999991E-02 160.000000 1200
( 91 %)		 1142
( 86 %)
Column 18 :
[ 19_ABDT5= Total Phytoplankton (cells/ml) ] 		no problems detected 961 9.65999985 12069.0596 961
( 100 %)		 961
( 100 %)
Column 19 :
[ 20_ABDT5= Total Diatoms (cells/ml) ] 		no problems detected 961 7.99999982E-02 5055.85986 961
( 100 %)		 949
( 98 %)
Column 20 :
[ 21_ABDT5= Total Dinoflagellates (cells/ml) ] 		no problems detected 961 1.99999996E-02 4814.71045 960
( 99 %)		 708
( 73 %)
Column 21 :
[ 22_ABDT5= Total Coccolithophorids (cells/ml) ] 		no problems detected 957 9.99999978E-03 2878.29468 777
( 81 %)		 753
( 78 %)
Column 22 :
[ 23_ABDT= Total Flagellates (cells/ml) ] 		no problems detected 958 273.271637 10787.7305 958
( 100 %)		 958
( 100 %)
Column 23 :
[ 24_ABDT= Total Phaeocystis (cells/ml) ] 		no problems detected 961 0.100000001 8235.65723 167
( 17 %)		 147
( 15 %)
Column 24 :
[ 25_ABDT= Total Ciliates (cells/ml) ] 		no problems detected 961 7.99999982E-02 97.8587723 960
( 99 %)		 814
( 84 %)
Column 26 :
[ 26_ABDT5= Total Phytoplankton (mg/ml) ] 		no problems detected 961 2.58947039 626.851074 961
( 100 %)		 961
( 100 %)
Column 27 :
[ 27_ABDT5= Total Diatoms (mg/ml) ] 		no problems detected 961 1.33794895E-03 227.052582 961
( 100 %)		 764
( 79 %)
Column 28 :
[ 28_ABDT5= Total Dinoflagellates (mg/ml) ] 		no problems detected 961 1.11276489E-02 609.599060 960
( 99 %)		 669
( 69 %)
Column 29 :
[ 29_ABDT5= Total Coccolithophorids (mg/ml) ] 		no problems detected 957 1.79733004E-04 32.0412178 777
( 81 %)		 154
( 16 %)
Column 30 :
[ 30_ABDT= Total Flagellates (mg/ml) ] 		no problems detected 958 0.592750192 210.726242 958
( 100 %)		 956
( 99 %)
Column 31 :
[ 31_ABDT= Total Phaeocystis (mg/ml) ] 		no problems detected 961 1.83081999E-03 150.780029 167
( 17 %)		 67
( 6 %)
Column 32 :
[ 32_ABDT= Total Ciliates (mg/ml) ] 		no problems detected 961 5.94341615E-03 164.630814 960
( 99 %)		 594
( 61 %)
Column 34 :
[ 33_ABDT8= Synechococcus spp. and Cyanobacteria (#/ml) from 0-15m ] 		no problems detected 694 69.0000000 257399.000 694
( 100 %)		 694
( 100 %)
Column 35 :
[ 34_ABDT7= Picoeukaryotes (#/ml) from 0-15m ] 		no problems detected 695 165.000000 82693.0000 695
( 100 %)		 695
( 100 %)
Column 36 :
[ 35_ABDT7= Nanoeukaryotes (#/ml) from 0-15m ] 		no problems detected 693 84.0000000 15979.0000 693
( 100 %)		 693
( 100 %)
Column 37 :
[ 36_ABDT7= Coccolithophores 5-8 um (#/ml) from 0-15m ] 		no problems detected 695 2.00000000 2230.00000 695
( 100 %)		 695
( 100 %)
Column 38 :
[ 37_ABDT7= Cryptophytes (#/ml) from 0-15m ] 		no problems detected 695 9.00000000 2369.00000 695
( 100 %)		 695
( 100 %)
Column 39 :
[ 38_ABDT7= Phaeocystis sp. cells (#/ml) from 0-15m ] 		no problems detected 694 9.00000000 12566.0000 165
( 23 %)		 165
( 23 %)
Column 40 :
[ 39_ABDT7= Dinoflagellates (#/ml) from 0-15m ] 		no problems detected 695 4.00000000 862.000000 72
( 10 %)		 72
( 10 %)
Column 41 :
[ 40_ABDT7= Total Nanoeukaryotic Phytoplankton (#/ml) from 0-15m ] 		no problems detected 695 665.000000 91147.0000 695
( 100 %)		 695
( 100 %)
Column 42 :
[ 41_ABDT7= Heterotrophic Nanoeukaryotes aka heterotrophic flagellates (#/ml) from 0-15m ] 		no problems detected 661 84.0000000 8268.00000 661
( 100 %)		 661
( 100 %)
Column 43 :
[ 42_ABDT8= Heterotrophic Bacteria with high DNA content (#/ml) from 0-15m ] 		no problems detected 677 100108.000 3758336.00 677
( 100 %)		 677
( 100 %)
Column 44 :
[ 43_ABDT8= Heterotrophic Bacteria with low DNA content (#/ml) from 0-15m ] 		no problems detected 675 22578.0000 1444039.00 675
( 100 %)		 675
( 100 %)
Column 45 :
[ 44_ABDT8= Total Bacteria (#/ml) from 0-15m ] 		no problems detected 674 162562.000 4324921.00 674
( 100 %)		 674
( 100 %)
Column 47 :
[ 45_CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface ] 		no problems detected 1022 0.100000001 11.7200003 1022
( 100 %)		 485
( 47 %)
Column 49 :
[ 46_TEMP= Temperature ( C ) at the surface ] 		no problems detected 1886 6.76000023 19.9200001 1886
( 100 %)		 1886
( 100 %)
Column 50 :
[47_PSAL= Salinity () at the surface ] 		There is/are 1 count WARNING(S)!
Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  1311 33.4599991 35.8600006 1311
    ( 100 %)    		 1311
    ( 100 %)
    Column 52 :
    [ 48_LOTH4= NO3+NO2 (uM) at the surface ]     		no problems detected 2223 9.99999978E-03 16.2500000 1973
    ( 88 %)    		 1254
    ( 56 %)
    Column 53 :
    [ 49_LOTH4= Nitrite (uM) at the surface ]     		no problems detected 2269 9.99999978E-03 1.38999999 1810
    ( 79 %)    		 39
    ( 1 %)
    Column 54 :
    [ 50_LOTH4= Ammonia (uM) at the surface ]     		no problems detected 1905 9.99999978E-03 4.13999987 1697
    ( 89 %)    		 62
    ( 3 %)
    Column 55 :
    [ 51_LOTH4= Silicate (uM) at the surface ]     		no problems detected 2126 9.99999978E-03 13.6599998 2126
    ( 100 %)    		 1504
    ( 70 %)
    Column 56 :
    [ 52_LOTH4= Phosphate (uM) at the surface ]     		no problems detected 2232 9.99999978E-03 1.11000001 2145
    ( 96 %)    		 3
    ( 0 %)

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