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     [ABND= Total Copepoda (#/m3)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4     [ABND= Total Rotifera (#/m3)]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6     [ABND= Total Cladocera (#/m3)]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8     [ABND= Total Bivalvia (#/m3)]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10     [ABND= Total Appendicularia (#/m3)]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12     [ABND= Total Diatoms (#/L)]      ( date set 6 )

    Column # 13     [ DATE-YMD ]       Date Set = 7
    Column # 14     [ABND= Total Dinoflagellates (#/L)]      ( date set 7 )

    Column # 15     [ DATE-YMD ]       Date Set = 8
    Column # 16     [ABND= Total Ciliophora (#/L)]      ( date set 8 )

    Column # 17     [ DATE-YMD ]       Date Set = 9
    Column # 18     [ABND= Total Coccolithophores (#/L)]      ( date set 9 )

    Column # 19     [ DATE-YMD ]       Date Set = 10
    Column # 20     [ABND= Total Cryptomonads (#/L)]      ( date set 10 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND= Total Copepoda (#/m3) ]
        Column # 4   [ ABND= Total Rotifera (#/m3) ]
        Column # 6   [ ABND= Total Cladocera (#/m3) ]
        Column # 8   [ ABND= Total Bivalvia (#/m3) ]
        Column # 10   [ ABND= Total Appendicularia (#/m3) ]
        Column # 12   [ ABND= Total Diatoms (#/L) ]
        Column # 14   [ ABND= Total Dinoflagellates (#/L) ]
        Column # 16   [ ABND= Total Ciliophora (#/L) ]
        Column # 18   [ ABND= Total Coccolithophores (#/L) ]
        Column # 20   [ ABND= Total Cryptomonads (#/L) ]



DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2009 2023
DATES in Column 3 no problems detected 2013 2018
DATES in Column 5 no problems detected 2009 2023
DATES in Column 7 no problems detected 2012 2018
DATES in Column 9 no problems detected 2012 2018
DATES in Column 11 no problems detected 2000 2023
DATES in Column 13 no problems detected 2000 2023
DATES in Column 15 no problems detected 2000 2023
DATES in Column 17 no problems detected 2001 2023
DATES in Column 19 no problems detected 1999 2023

 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 2009 2023 01 12 01 30
3 DATE-YMD DATE-YMD yes 2013 2018 01 02 02 29
5 DATE-YMD DATE-YMD yes 2009 2023 01 12 01 30
7 DATE-YMD DATE-YMD yes 2012 2018 01 11 02 29
9 DATE-YMD DATE-YMD yes 2012 2018 02 11 02 27
11 DATE-YMD DATE-YMD yes 2000 2023 01 12 01 30
13 DATE-YMD DATE-YMD yes 2000 2023 01 12 01 31
15 DATE-YMD DATE-YMD yes 2000 2023 01 12 01 31
17 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31
19 DATE-YMD DATE-YMD yes 1999 2023 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_ABND= Total Copepoda (#/m3) ] 		no problems detected 127 42.6665993 82268.0156 127
( 100 %)		 127
( 100 %)
Column 4 :
[05_ABND= Total Rotifera (#/m3) ] 		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")

    		•  3 5.11999989 163.839996 3
    ( 100 %)    		 3
    ( 100 %)
    Column 6 :
    [ 06_ABND= Total Cladocera (#/m3) ]     		no problems detected 135 6.53599977 99699.9688 135
    ( 100 %)    		 135
    ( 100 %)
    Column 8 :
    [ 07_ABND= Total Bivalvia (#/m3) ]     		no problems detected 11 15.3599997 10813.4404 11
    ( 100 %)    		 11
    ( 100 %)
    Column 10 :
    [ 08_ABND= Total Appendicularia (#/m3) ]     		no problems detected 7 2.55999994 5079.04004 7
    ( 100 %)    		 7
    ( 100 %)
    Column 12 :
    [ 09_ABND= Total Diatoms (#/L) ]     		no problems detected 201 40.0000000 16335188.0 201
    ( 100 %)    		 201
    ( 100 %)
    Column 14 :
    [ 10_ABND= Total Dinoflagellates (#/L) ]     		no problems detected 227 40.0000000 691483.562 227
    ( 100 %)    		 227
    ( 100 %)
    Column 16 :
    [ 11_ABND= Total Ciliophora (#/L) ]     		no problems detected 214 80.0000000 93108.0938 214
    ( 100 %)    		 214
    ( 100 %)
    Column 18 :
    [ 12_ABND= Total Coccolithophores (#/L) ]     		no problems detected 157 373.000000 9504560.00 157
    ( 100 %)    		 157
    ( 100 %)
    Column 20 :
    [ 13_ABND= Total Cryptomonads (#/L) ]     		no problems detected 228 40.0000000 2781960.00 228
    ( 100 %)    		 228
    ( 100 %)

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