COPEPODITE Incoming Data Review Fatal Format Issues:   none HEADER REVIEW SECTION [ Jump back to TOP ] SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS Column # 1     [ DATE-MDY ]       Date Set = 1 Column # 2    [ABDT1= Total Phytoplankton < 20 um (cells/ml) at 1 m]      ( date set 1 ) Column # 3    [ABDT1= Synechococcus (cells/ml) at 1 m]      ( date set 1 ) Column # 4    [ABDT1= Cryptophytes (cells/ml) at 1 m]      ( date set 1 ) Column # 5     [ABDT1= Eukaryotic phytoplankton - including cryptophytes (cells/ml) at 1 m]      ( date set 1 ) Column # 6     [ DATE-MDY ]       Date Set = 2 Column # 7     [ABDT2= Heterotrophic + Mixotrophic Protists (cells/ml) at 1 m]      ( date set 2 ) Column # 8    [ABDT2= Heterotrophic Protists (cells/ml) at 1 m]      ( date set 2 ) Column # 9    [ABDT2= Mixotrophic Protists (cells/ml) at 1 m]      ( date set 2 ) Column # 10     [ DATE-MDY ]       Date Set = 3 Column # 11    [ABDT3= Bacteria (#/ml) at 1 m]      ( date set 3 ) Column # 12     [ DATE-MDY ]       Date Set = 4 Column # 13    [CHLA4= Total Chlorophyll (ug/L) at 1 m]      ( date set 4 ) Column # 14     [CHLA4= Total Chlorophyll of the < 3 um size fraction (ug/L) at 1 m]      ( date set 4 ) Column # 15     [CHLA4= Total Chlorophyll of the < 20 um size fraction (ug/L) at 1 m]      ( date set 4 ) Column # 16     [CHLA4= Total Chlorophyll of the 3 to 20 um size fraction (ug/L) at 1 m]      ( date set 4 ) Column # 17     [CHLA4= Total Chlorophyll of the > 20 um size fraction (ug/L) at 1 m]      ( date set 4 ) Column # 18     [ DATE-MDY ]       Date Set = 5 Column # 19    [TEMP= Temperature ( C ) at 1 m]      ( date set 5 ) Column # 20    [PSAL= Salinity (psu) at 1 m]      ( date set 5 ) DATA SORTED BY CATEGORY TYPES Abundance (with zeros) Category     Column # 2   [ ABDT1= Total Phytoplankton < 20 um (cells/ml) at 1 m ]     Column # 3   [ ABDT1= Synechococcus (cells/ml) at 1 m ]     Column # 4   [ ABDT1= Cryptophytes (cells/ml) at 1 m ]     Column # 5   [ ABDT1= Eukaryotic phytoplankton - including cryptophytes (cells/ml) at 1 m ]     Column # 7   [ ABDT2= Heterotrophic + Mixotrophic Protists (cells/ml) at 1 m ]     Column # 8   [ ABDT2= Heterotrophic Protists (cells/ml) at 1 m ]     Column # 9   [ ABDT2= Mixotrophic Protists (cells/ml) at 1 m ]     Column # 11   [ ABDT3= Bacteria (#/ml) at 1 m ] Temperatures Category     Column # 19   [ TEMP= Temperature ( C ) at 1 m ] Salinities Category     Column # 20   [ PSAL= Salinity (psu) at 1 m ] Chlorophyll/Pigments Category     Column # 13   [ CHLA4= Total Chlorophyll (ug/L) at 1 m ]     Column # 14   [ CHLA4= Total Chlorophyll of the < 3 um size fraction (ug/L) at 1 m ]     Column # 15   [ CHLA4= Total Chlorophyll of the < 20 um size fraction (ug/L) at 1 m ]     Column # 16   [ CHLA4= Total Chlorophyll of the 3 to 20 um size fraction (ug/L) at 1 m ]     Column # 17   [ CHLA4= Total Chlorophyll of the > 20 um size fraction (ug/L) at 1 m ] DATA SORTED BY GROUPING SETS: Category 3 Group # 4     column # 13     [ CHLA4= Total Chlorophyll (ug/L) at 1 m ]     column # 14     [ CHLA4= Total Chlorophyll of the < 3 um size fraction (ug/L) at 1 m ]     column # 15     [ CHLA4= Total Chlorophyll of the < 20 um size fraction (ug/L) at 1 m ]     column # 16     [ CHLA4= Total Chlorophyll of the 3 to 20 um size fraction (ug/L) at 1 m ]     column # 17     [ CHLA4= Total Chlorophyll of the > 20 um size fraction (ug/L) at 1 m ] Category 8 Group # 1     column # 2     [ ABDT1= Total Phytoplankton < 20 um (cells/ml) at 1 m ]     column # 3     [ ABDT1= Synechococcus (cells/ml) at 1 m ]     column # 4     [ ABDT1= Cryptophytes (cells/ml) at 1 m ]     column # 5     [ ABDT1= Eukaryotic phytoplankton - including cryptophytes (cells/ml) at 1 m ] Category 8 Group # 2     column # 7     [ ABDT2= Heterotrophic + Mixotrophic Protists (cells/ml) at 1 m ]     column # 8     [ ABDT2= Heterotrophic Protists (cells/ml) at 1 m ]     column # 9     [ ABDT2= Mixotrophic Protists (cells/ml) at 1 m ] Category 8 Group # 3     column # 11     [ ABDT3= Bacteria (#/ml) at 1 m ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 2001 2011 DATES in Column 6 no problems detected 2003 2011 DATES in Column 10 no problems detected 2001 2011 DATES in Column 12 no problems detected 2000 2012 DATES in Column 18 no problems detected 2000 2012   Date Column Labeling Date Value-Set1 Date Value-Set2 Date Value-Set3 DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max 1 DATE-MDY DATE-MDY yes 1 12 1 31 2001 2011 6 DATE-MDY DATE-MDY yes 1 12 1 31 2003 2011 10 DATE-MDY DATE-MDY yes 1 12 1 31 2001 2011 12 DATE-MDY DATE-MDY yes 1 12 1 31 2000 2012 18 DATE-MDY DATE-MDY yes 1 12 1 31 2000 2012 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 < 20 um (cells/ml) at 1 m ] no problems detected 567 1051.948 277794.25 567 ( 100%) 567 ( 100%) Column 3 : [ 05_ABDT1= Synechococcus (cells/ml) at 1 m ] no problems detected 567 70.5128174 210672.844 567 ( 100%) 567 ( 100%) Column 4 : [ 06_ABDT1= Cryptophytes (cells/ml) at 1 m ] no problems detected 567 5.39083576 3987.9519 567 ( 100%) 567 ( 100%) Column 5 : [ 07_ABDT1= Eukaryotic phytoplankton - including cryptophytes (cells/ml) at 1 m ] no problems detected 567 571.428589 206222.922 567 ( 100%) 567 ( 100%) Column 7 : [ 08_ABDT2= Heterotrophic + Mixotrophic Protists (cells/ml) at 1 m ] no problems detected 435 194.881897 11468.9512 435 ( 100%) 435 ( 100%) Column 8 : [ 09_ABDT2= Heterotrophic Protists (cells/ml) at 1 m ] no problems detected 435 175.675674 9777.30176 435 ( 100%) 435 ( 100%) Column 9 : [ 10_ABDT2= Mixotrophic Protists (cells/ml) at 1 m ] no problems detected 435 3.79506636 4738.00732 435 ( 100%) 435 ( 100%) Column 11 : [ 11_ABDT3= Bacteria (#/ml) at 1 m ] no problems detected 548 192946.953 8326580. 548 ( 100%) 548 ( 100%) Column 13 : [ 12_CHLA4= Total Chlorophyll (ug/L) at 1 m ] no problems detected 577 0.0607770234 17.7385273 577 ( 100%) 493 ( 85%) Column 14 : [ 13_CHLA4= Total Chlorophyll of the < 3 um size fraction (ug/L) at 1 m ] no problems detected 577 -3.88008881 53.2036018 575 ( 99%) 103 ( 17%) Column 15 : [ 14_CHLA4= Total Chlorophyll of the < 20 um size fraction (ug/L) at 1 m ] no problems detected 576 -0.430660874 7.50878429 573 ( 99%) 320 ( 55%) Column 16 : [ 15_CHLA4= Total Chlorophyll of the 3 to 20 um size fraction (ug/L) at 1 m ] no problems detected 576 0.00120202499 5.12182474 536 ( 93%) 187 ( 32%) Column 17 : [ 16_CHLA4= Total Chlorophyll of the > 20 um size fraction (ug/L) at 1 m ] no problems detected 575 0.00367555302 16.8910999 557 ( 96%) 232 ( 40%) Column 19 : [ 17_TEMP= Temperature ( C ) at 1 m ] no problems detected 580 -2. 22.7999992 567 ( 97%) 557 ( 96%) Column 20 : [ 18_PSAL= Salinity (psu) at 1 m ] no problems detected 519 27. 36. 519 ( 100%) 519 ( 100%) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".