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     [ABND7= Total Copepoda (#/m3)]      ( date set 1 )
    Column # 3     [ABND6= Total Copepoda volume (mm3/m3)]      ( date set 1 )

    Column # 4     [ DATE-YMD ]       Date Set = 2
    Column # 5     [ABND7= Total Zooplankton (#/m3)]      ( date set 2 )
    Column # 6     [ABND6= Total Zooplankton volume (mm3/m3)]      ( date set 2 )

    Column # 7     [ DATE-DMY ]       Date Set = 3
    Column # 8     [ABND1= Total Copepods (#/m3) via WP2 net]      ( date set 3 )

    Column # 9     [ DATE-YMD ]       Date Set = 4
    Column # 10     [ABND1= Total Copepods (#/m3) via Juday-Bogorov Net]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND7= Total Copepoda (#/m3) ]
        Column # 3   [ ABND6= Total Copepoda volume (mm3/m3) ]
        Column # 5   [ ABND7= Total Zooplankton (#/m3) ]
        Column # 6   [ ABND6= Total Zooplankton volume (mm3/m3) ]
        Column # 8   [ ABND1= Total Copepods (#/m3) via WP2 net ]
        Column # 10   [ ABND1= Total Copepods (#/m3) via Juday-Bogorov Net ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 8     [ ABND1= Total Copepods (#/m3) via WP2 net ]
        column # 10     [ ABND1= Total Copepods (#/m3) via Juday-Bogorov Net ]

    Category 2 Group # 6
        column # 3     [ ABND6= Total Copepoda volume (mm3/m3) ]
        column # 6     [ ABND6= Total Zooplankton volume (mm3/m3) ]

    Category 2 Group # 7
        column # 2     [ ABND7= Total Copepoda (#/m3) ]
        column # 5     [ ABND7= Total Zooplankton (#/m3) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2001 2017
DATES in Column 4 no problems detected 2001 2017
DATES in Column 7 no problems detected 1995 2012
DATES in Column 9 no problems detected 1974 2003

 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 2001 2017 01 12 01 31
4 DATE-YMD DATE-YMD yes 2001 2017 01 12 01 31
7 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
9 DATE-YMD DATE-YMD yes 1974 2003 01 12 15 15


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABND7= Total Copepoda (#/m3) ] 		no problems detected 788 0.426666677 19328.5332 788
( 100 %)		 787
( 99 %)
Column 3 :
[ 05_ABND6= Total Copepoda volume (mm3/m3) ] 		no problems detected 788 6.48707375E-02 1564.28772 788
( 100 %)		 785
( 99 %)
Column 5 :
[ 06_ABND7= Total Zooplankton (#/m3) ] 		no problems detected 788 3.07555556 19763.1992 788
( 100 %)		 788
( 100 %)
Column 6 :
[ 07_ABND6= Total Zooplankton volume (mm3/m3) ] 		no problems detected 788 0.372929215 36073.0117 788
( 100 %)		 787
( 99 %)
Column 8 :
[ 08_ABND1= Total Copepods (#/m3) via WP2 net ] 		no problems detected 659 27.2666664 16930.1328 659
( 100 %)		 659
( 100 %)
Column 10 :
[ 09_ABND1= Total Copepods (#/m3) via Juday-Bogorov Net ] 		no problems detected 360 23.6252537 2791.31030 360
( 100 %)		 360
( 100 %)

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