COPEPODITE Incoming Data Review
Fatal Format Issues:   none


HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2     [ABDT1= Total Phytoplankton (#/L)]      ( date set 1 )
    Column # 3     [ABDT1= Total Diatoms (#/L)]      ( date set 1 )
    Column # 4     [ABDT1= Total Dinoflagellates (#/L)]      ( date set 1 )
    Column # 5     [ABDT1= Other Phytoplankton (#/L)]      ( date set 1 )
    Column # 6     [ABDT2= Diatoms as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 7     [ABDT2= Dinoflagellates as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 8     [ABDT2= Other Phytoplankton as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 9     [OTHR3= Number of Phytoplankton Species]      ( date set 1 )
    Column # 10     [OTHR3= Number of Diatom Species]      ( date set 1 )
    Column # 11     [OTHR3= Number of Dinoflagellate Species]      ( date set 1 )
    Column # 12     [OTHR3= Number of Other Phytoplankton Species]      ( date set 1 )

    Column # 13     [ DATE-DMY ]       Date Set = 2
    Column # 14     [CHLA= Chlorophyll via Fluorescence proxy ()]      ( date set 2 )

    Column # 15     [ DATE-DMY ]       Date Set = 3
    Column # 16     [TEMP= Temperature ( C ) at the surface]      ( date set 3 )
    Column # 17     [PSAL= Salinity (pss) at the surface]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Phytoplankton (#/L) ]
        Column # 3   [ ABDT1= Total Diatoms (#/L) ]
        Column # 4   [ ABDT1= Total Dinoflagellates (#/L) ]
        Column # 5   [ ABDT1= Other Phytoplankton (#/L) ]
        Column # 6   [ ABDT2= Diatoms as % of Total Phytoplankton (ratio) ]
        Column # 7   [ ABDT2= Dinoflagellates as % of Total Phytoplankton (ratio) ]
        Column # 8   [ ABDT2= Other Phytoplankton as % of Total Phytoplankton (ratio) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 9   [ OTHR3= Number of Phytoplankton Species ]
        Column # 10   [ OTHR3= Number of Diatom Species ]
        Column # 11   [ OTHR3= Number of Dinoflagellate Species ]
        Column # 12   [ OTHR3= Number of Other Phytoplankton Species ]

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

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

DATA SORTED BY GROUPING SETS:

    Category 6 Group # 3
        column # 9     [ OTHR3= Number of Phytoplankton Species ]
        column # 10     [ OTHR3= Number of Diatom Species ]
        column # 11     [ OTHR3= Number of Dinoflagellate Species ]
        column # 12     [ OTHR3= Number of Other Phytoplankton Species ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Phytoplankton (#/L) ]
        column # 3     [ ABDT1= Total Diatoms (#/L) ]
        column # 4     [ ABDT1= Total Dinoflagellates (#/L) ]
        column # 5     [ ABDT1= Other Phytoplankton (#/L) ]

    Category 8 Group # 2
        column # 6     [ ABDT2= Diatoms as % of Total Phytoplankton (ratio) ]
        column # 7     [ ABDT2= Dinoflagellates as % of Total Phytoplankton (ratio) ]
        column # 8     [ ABDT2= Other Phytoplankton as % of Total Phytoplankton (ratio) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1988 2009
DATES in Column 13 no problems detected 2004 2010
DATES in Column 15 no problems detected 1989 2009

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
13 DATE-DMY DATE-DMY yes 1 31 Apr Sep 04 10
15 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_ABDT1= Total Phytoplankton (#/L) ] 		no problems detected 589 60.0000000 2465306.00 589
( 100 %)		 589
( 100 %)
Column 3 :
[ 05_ABDT1= Total Diatoms (#/L) ] 		no problems detected 589 40.0000000 2251438.00 588
( 99 %)		 588
( 99 %)
Column 4 :
[ 06_ABDT1= Total Dinoflagellates (#/L) ] 		no problems detected 589 20.0000000 726240.000 567
( 96 %)		 567
( 96 %)
Column 5 :
[ 07_ABDT1= Other Phytoplankton (#/L) ] 		no problems detected 589 20.0000000 160814.000 582
( 98 %)		 582
( 98 %)
Column 6 :
[ 08_ABDT2= Diatoms as % of Total Phytoplankton (ratio) ] 		no problems detected 589 0.292780519 100.000000 588
( 99 %)		 586
( 99 %)
Column 7 :
[ 09_ABDT2= Dinoflagellates as % of Total Phytoplankton (ratio) ] 		no problems detected 589 4.40377742E-02 89.6892624 567
( 96 %)		 540
( 91 %)
Column 8 :
[ 10_ABDT2= Other Phytoplankton as % of Total Phytoplankton (ratio) ] 		no problems detected 589 9.78617184E-03 86.3636398 582
( 98 %)		 563
( 95 %)
Column 9 :
[ 11_OTHR3= Number of Phytoplankton Species ] 		no problems detected 589 2.00000000 62.0000000 589
( 100 %)		 589
( 100 %)
Column 10 :
[ 12_OTHR3= Number of Diatom Species ] 		no problems detected 588 2.00000000 35.0000000 588
( 100 %)		 588
( 100 %)
Column 11 :
[ 13_OTHR3= Number of Dinoflagellate Species ] 		no problems detected 567 1.00000000 25.0000000 567
( 100 %)		 531
( 93 %)
Column 12 :
[ 14_OTHR3= Number of Other Phytoplankton Species ] 		no problems detected 582 1.00000000 14.0000000 582
( 100 %)		 561
( 96 %)
Column 14 :
[ 15_CHLA= Chlorophyll via Fluorescence proxy () ] 		no problems detected 199 -0.680000007 18.6200008 197
( 98 %)		 138
( 69 %)
Column 16 :
[ 16_TEMP= Temperature ( C ) at the surface ] 		no problems detected 565 0.200000003 15.3000002 565
( 100 %)		 561
( 99 %)
Column 17 :
[ 17_PSAL= Salinity (pss) at the surface ] 		no problems detected 528 26.4599991 33.0999985 528
( 100 %)		 528
( 100 %)

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