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     [ABDT1= Calanidae (#/m3)]      ( date set 1 )
    Column # 4     [ABDT1= Paracalanidae (#/m3)]      ( date set 1 )
    Column # 5     [ABDT1= Acartiidae (#/m3)]      ( date set 1 )
    Column # 6     [ABDT1= Oithonidae (#/m3)]      ( date set 1 )
    Column # 7     [ABDT2= Salpidae (#/m3)]      ( date set 1 )
    Column # 8     [ABDT2= Doliolidae (#/m3)]      ( date set 1 )

    Column # 9     [ DATE-MDY ]       Date Set = 2
    Column # 10     [CHLA= Chlorophyll (mg/m3)]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12     [BIOM= Total Dry Mass (mg/m3)]      ( date set 3 )

    Column # 13     [ DATE-YMD ]       Date Set = 4
    Column # 14     [ABDT3= Total Diatoms (#/L)]      ( date set 4 )
    Column # 15     [ABDT3= Total Centric Diatoms (#/L)]      ( date set 4 )
    Column # 16     [ABDT3= Total Pennate Diatoms (#/L)]      ( date set 4 )
    Column # 17     [ABDT4= Total Dinoflagellates (#/L)]      ( date set 4 )
    Column # 18     [ABDT= Total Flagellates (#/L)]      ( date set 4 )
    Column # 19     [ABDT= Total Naked Flagellates (#/L)]      ( date set 4 )
    Column # 20     [ABDT= Total Ciliates (#/L)]      ( date set 4 )
    Column # 21     [ABDT= Total Coccolithophore (#/L)]      ( date set 4 )
    Column # 22     [ABDT= Total Cyanobacteria (#/L)]      ( date set 4 )

    Column # 23     [ DATE-YMD ]       Date Set = 5
    Column # 24     [PSAL= Salinity () at the surface]      ( date set 5 )
    Column # 25     [OTHR= Oxygen (uM) at the surface]      ( date set 5 )
    Column # 26     [LOTH= Silicate (uM) at the surface]      ( date set 5 )
    Column # 27     [LOTH= Nitrate (uM) at the surface]      ( date set 5 )
    Column # 28     [LOTH= Phosphate (uM) at the surface]      ( date set 5 )
    Column # 29     [OTHR= TCO2 (umol/kg) at the surface]      ( date set 5 )
    Column # 30     [OTHR= Total Alkalinity (umol/kg) at the surface]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]

    Abundance (with zeros) Category
        Column # 3   [ ABDT1= Calanidae (#/m3) ]
        Column # 4   [ ABDT1= Paracalanidae (#/m3) ]
        Column # 5   [ ABDT1= Acartiidae (#/m3) ]
        Column # 6   [ ABDT1= Oithonidae (#/m3) ]
        Column # 7   [ ABDT2= Salpidae (#/m3) ]
        Column # 8   [ ABDT2= Doliolidae (#/m3) ]
        Column # 14   [ ABDT3= Total Diatoms (#/L) ]
        Column # 15   [ ABDT3= Total Centric Diatoms (#/L) ]
        Column # 16   [ ABDT3= Total Pennate Diatoms (#/L) ]
        Column # 17   [ ABDT4= Total Dinoflagellates (#/L) ]
        Column # 18   [ ABDT= Total Flagellates (#/L) ]
        Column # 19   [ ABDT= Total Naked Flagellates (#/L) ]
        Column # 20   [ ABDT= Total Ciliates (#/L) ]
        Column # 21   [ ABDT= Total Coccolithophore (#/L) ]
        Column # 22   [ ABDT= Total Cyanobacteria (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 25   [ OTHR= Oxygen (uM) at the surface ]
        Column # 29   [ OTHR= TCO2 (umol/kg) at the surface ]
        Column # 30   [ OTHR= Total Alkalinity (umol/kg) at the surface ]

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

DATA SORTED BY GROUPING SETS:

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

    Category 8 Group # 1
        column # 3     [ ABDT1= Calanidae (#/m3) ]
        column # 4     [ ABDT1= Paracalanidae (#/m3) ]
        column # 5     [ ABDT1= Acartiidae (#/m3) ]
        column # 6     [ ABDT1= Oithonidae (#/m3) ]

    Category 8 Group # 2
        column # 7     [ ABDT2= Salpidae (#/m3) ]
        column # 8     [ ABDT2= Doliolidae (#/m3) ]

    Category 8 Group # 3
        column # 14     [ ABDT3= Total Diatoms (#/L) ]
        column # 15     [ ABDT3= Total Centric Diatoms (#/L) ]
        column # 16     [ ABDT3= Total Pennate Diatoms (#/L) ]

    Category 8 Group # 4
        column # 17     [ ABDT4= Total Dinoflagellates (#/L) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2008 2015
DATES in Column 9 no problems detected 2009 2014
DATES in Column 11 no problems detected 2008 2015
DATES in Column 13 no problems detected 2009 2015
DATES in Column 23 no problems detected 2009 2015

 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 2008 2015 01 12 01 31
9 DATE-MDY DATE-MDY yes 1 12 1 28 2009 2014
11 DATE-YMD DATE-YMD yes 2008 2015 01 12 01 31
13 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 28
23 DATE-YMD DATE-YMD yes 2009 2015 01 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 86 27.2311001 5863.85938 83
( 96 %)		 83
( 96 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ] 		no problems detected 86 8.82499981 1639.56567 83
( 96 %)		 83
( 96 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ] 		no problems detected 86 1.13450003 315.053802 83
( 96 %)		 83
( 96 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ] 		no problems detected 86 0.126000002 106.089500 72
( 83 %)		 71
( 82 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ] 		no problems detected 86 7.37519979 868.005371 83
( 96 %)		 83
( 96 %)
Column 7 :
[ 09_ABDT2= Salpidae (#/m3) ] 		no problems detected 86 0.315200001 57.8670006 38
( 44 %)		 37
( 43 %)
Column 8 :
[ 10_ABDT2= Doliolidae (#/m3) ] 		no problems detected 86 3.21479988 816.567993 79
( 91 %)		 79
( 91 %)
Column 10 :
[11_CHLA= Chlorophyll (mg/m3) ] 		There is/are 1 count WARNING(S)!

Some of your values are zero or "one".

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")

    		•  58 7.10000023E-02 1.29700005 58
    ( 100 %)    		 2
    ( 3 %)
    Column 12 :
    [ 12_BIOM= Total Dry Mass (mg/m3) ]     		no problems detected 83 5.21449995 52.6847000 83
    ( 100 %)    		 83
    ( 100 %)
    Column 14 :
    [ 13_ABDT3= Total Diatoms (#/L) ]     		no problems detected 66 178.000000 115254.000 66
    ( 100 %)    		 66
    ( 100 %)
    Column 15 :
    [ 14_ABDT3= Total Centric Diatoms (#/L) ]     		no problems detected 66 89.0000000 106163.000 66
    ( 100 %)    		 66
    ( 100 %)
    Column 16 :
    [ 15_ABDT3= Total Pennate Diatoms (#/L) ]     		no problems detected 66 13.0000000 60606.0000 62
    ( 93 %)    		 62
    ( 93 %)
    Column 17 :
    [ 16_ABDT4= Total Dinoflagellates (#/L) ]     		no problems detected 66 8.00000000 2522.00000 65
    ( 98 %)    		 65
    ( 98 %)
    Column 18 :
    [17_ABDT= Total Flagellates (#/L) ]     		There is/are 2 count WARNING(S)!

    Some of your values are zero or "one".

    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")

    		•  66 9999999.00 0.00000000 0
    ( 0 %)    		 0
    ( 0 %)
    Column 19 :
    [ 18_ABDT= Total Naked Flagellates (#/L) ]     		no problems detected 66 375.000000 133531.000 61
    ( 92 %)    		 61
    ( 92 %)
    Column 20 :
    [ 19_ABDT= Total Ciliates (#/L) ]     		no problems detected 66 18.0000000 720.000000 27
    ( 40 %)    		 27
    ( 40 %)
    Column 21 :
    [20_ABDT= Total Coccolithophore (#/L) ]     		There is/are 2 count WARNING(S)!

    Some of your values are zero or "one".

    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")

    		•  66 191.000000 1229.00000 3
    ( 4 %)    		 3
    ( 4 %)
    Column 22 :
    [21_ABDT= Total Cyanobacteria (#/L) ]     		There is/are 2 count WARNING(S)!

    Some of your values are zero or "one".

    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")

    		•  66 9999999.00 0.00000000 0
    ( 0 %)    		 0
    ( 0 %)
    Column 24 :
    [ 22_PSAL= Salinity () at the surface ]     		no problems detected 67 33.7900009 99.0000000 67
    ( 100 %)    		 67
    ( 100 %)
    Column 25 :
    [23_OTHR= Oxygen (uM) at the surface ]     		There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!

    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")

    		•  0 9999999.00 -9999999.00 0
    ( -2147483648 %)    		 0
    ( -2147483648 %)
    Column 26 :
    [ 24_LOTH= Silicate (uM) at the surface ]     		no problems detected 72 0.100000001 2.40000010 67
    ( 93 %)    		 10
    ( 13 %)
    Column 27 :
    [ 25_LOTH= Nitrate (uM) at the surface ]     		no problems detected 72 0.100000001 0.699999988 26
    ( 36 %)    		 0
    ( 0 %)
    Column 28 :
    [ 26_LOTH= Phosphate (uM) at the surface ]     		no problems detected 72 9.99999978E-03 0.230000004 70
    ( 97 %)    		 0
    ( 0 %)
    Column 29 :
    [27_OTHR= TCO2 (umol/kg) at the surface ]     		There is/are 1 count WARNING(S)!

    Some of your values are zero or "one".

    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")

    		•  67 9.99999978E-03 1.40999997 65
    ( 97 %)    		 2
    ( 2 %)
    Column 30 :
    [ 28_OTHR= Total Alkalinity (umol/kg) at the surface ]     		no problems detected 54 1911.30005 2038.12000 54
    ( 100 %)    		 54
    ( 100 %)

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