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 Diatoms (#/L)]      ( date set 1 ) Column # 3    [ABDT1= Total Dinoflagellates (#/L)]      ( date set 1 ) Column # 4    [ABDT1= Other Phytoplankton (#/L)]      ( date set 1 ) Column # 5    [ABDT1= Total Phytoplankton (#/L)]      ( date set 1 ) Column # 6     [ DATE-MDY ]       Date Set = 2 Column # 7    [ABND= Faecal Coliforms (cfu/100ml)]      ( date set 2 ) Column # 8    [ABND= Escherichia coli (cfu/100ml)]      ( date set 2 ) Column # 9     [ DATE-MDY ]       Date Set = 3 Column # 10    [TEMP= Temperature (C) at the surface]      ( date set 3 ) Column # 11    [PSAL= Salinity () at the surface]      ( date set 3 ) Column # 12    [CHLA= Chlorophyll (ug/l) at the surface]      ( date set 3 ) Column # 13    [OTHR= Secchi Depth (m)]      ( date set 3 ) Column # 14    [OTHR= Oxygen (mg/l) at the surface]      ( date set 3 ) Column # 15    [OTHR= pH () at the surface]      ( date set 3 ) Column # 16    [LOTH= Turbidity (NTU) at the surface]      ( date set 3 ) Column # 17     [ DATE-MDY ]       Date Set = 4 Column # 18    [LOTH= NO3-N (mg/l) at the surface]      ( date set 4 ) Column # 19    [LOTH= NO2-N (mg/l) at the surface]      ( date set 4 ) Column # 20    [LOTH= Ammonium-N (mg/l) at the surface]      ( date set 4 ) Column # 21    [LOTH= Phosphate-P (mg/l) at the surface]      ( date set 4 ) Column # 22    [LOTH= Silicate-Si (mg/l) at the surface]      ( date set 4 ) DATA SORTED BY CATEGORY TYPES Total/non-zero Abundance Category     Column # 7   [ ABND= Faecal Coliforms (cfu/100ml) ]     Column # 8   [ ABND= Escherichia coli (cfu/100ml) ] Abundance (with zeros) Category     Column # 2   [ ABDT1= Total Diatoms (#/L) ]     Column # 3   [ ABDT1= Total Dinoflagellates (#/L) ]     Column # 4   [ ABDT1= Other Phytoplankton (#/L) ]     Column # 5   [ ABDT1= Total Phytoplankton (#/L) ] Log10 (logarithmic) Miscellaenous Category     Column # 16   [ LOTH= Turbidity (NTU) at the surface ]     Column # 18   [ LOTH= NO3-N (mg/l) at the surface ]     Column # 19   [ LOTH= NO2-N (mg/l) at the surface ]     Column # 20   [ LOTH= Ammonium-N (mg/l) at the surface ]     Column # 21   [ LOTH= Phosphate-P (mg/l) at the surface ]     Column # 22   [ LOTH= Silicate-Si (mg/l) at the surface ] non-Log10 (linear) Miscellaenous Category     Column # 13   [ OTHR= Secchi Depth (m) ]     Column # 14   [ OTHR= Oxygen (mg/l) at the surface ]     Column # 15   [ OTHR= pH () at the surface ] Temperatures Category     Column # 10   [ TEMP= Temperature (C) at the surface ] Salinities Category     Column # 11   [ PSAL= Salinity () at the surface ] Chlorophyll/Pigments Category     Column # 12   [ CHLA= Chlorophyll (ug/l) at the surface ] DATA SORTED BY GROUPING SETS: Category 8 Group # 1     column # 2     [ ABDT1= Total Diatoms (#/L) ]     column # 3     [ ABDT1= Total Dinoflagellates (#/L) ]     column # 4     [ ABDT1= Other Phytoplankton (#/L) ]     column # 5     [ ABDT1= Total Phytoplankton (#/L) ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 1991 2004 DATES in Column 6 no problems detected 1986 2010 DATES in Column 9 no problems detected 1986 2010 DATES in Column 17 no problems detected 1986 2010   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-DMY DATE-DMY yes 1 31 Apr Sep 00 99 6 DATE-MDY DATE-MDY yes 1 12 1 31 1986 2010 9 DATE-MDY DATE-MDY yes 1 12 1 31 1986 2010 17 DATE-MDY DATE-MDY yes 1 12 1 31 1986 2010 DATA REVIEW SECTION [ Jump back to TOP ] DATA COLUMN Comments "n" Minimum (non-zero) Maximum Values > 0 Values > 1 Column 2 : [ 04_ABDT1= Total Diatoms (#/L) ] no problems detected 113 4. 84650. 112 ( 99%) 112 ( 99%) Column 3 : [ 05_ABDT1= Total Dinoflagellates (#/L) ] no problems detected 113 4. 355. 105 ( 92%) 105 ( 92%) Column 4 : [ 06_ABDT1= Other Phytoplankton (#/L) ] no problems detected 113 10. 3965. 112 ( 99%) 112 ( 99%) Column 5 : [ 07_ABDT1= Total Phytoplankton (#/L) ] no problems detected 113 20. 84890. 113 ( 100%) 113 ( 100%) Column 7 : [ 08_ABND= Faecal Coliforms (cfu/100ml) ] no problems detected 220 1. 2100. 220 ( 100%) 209 ( 95%) Column 8 : [ 09_ABND= Escherichia coli (cfu/100ml) ] no problems detected 220 1. 910. 220 ( 100%) 197 ( 89%) Column 10 : [ 10_TEMP= Temperature (C) at the surface ] no problems detected 220 14.3000002 29.5 220 ( 100%) 220 ( 100%) Column 11 : [ 11_PSAL= Salinity () at the surface ] no problems detected 220 16.5 34.5 220 ( 100%) 220 ( 100%) Column 12 : [ 12_CHLA= Chlorophyll (ug/l) at the surface ] no problems detected 217 0.200000003 29. 217 ( 100%) 168 ( 77%) Column 13 : [ 13_OTHR= Secchi Depth (m) ] no problems detected 217 1. 15. 217 ( 100%) 211 ( 97%) Column 14 : [ 14_OTHR= Oxygen (mg/l) at the surface ] no problems detected 218 4.19999981 13.8000002 218 ( 100%) 218 ( 100%) Column 15 : [ 15_OTHR= pH () at the surface ] no problems detected 217 6.0999999 8.89999962 217 ( 100%) 217 ( 100%) Column 16 : [ 16_LOTH= Turbidity (NTU) at the surface ] no problems detected 220 0.5 21.8999996 220 ( 100%) 214 ( 97%) Column 18 : [ 17_LOTH= NO3-N (mg/l) at the surface ] no problems detected 217 0.00200000009 0.790000021 217 ( 100%) 0 ( 0%) Column 19 : [ 18_LOTH= NO2-N (mg/l) at the surface ] no problems detected 217 0.00200000009 0.180000007 217 ( 100%) 0 ( 0%) Column 20 : [ 19_LOTH= Ammonium-N (mg/l) at the surface ] no problems detected 217 0.00499999989 0.550000012 217 ( 100%) 0 ( 0%) Column 21 : [ 20_LOTH= Phosphate-P (mg/l) at the surface ] no problems detected 217 0.00200000009 0.0410000011 217 ( 100%) 0 ( 0%) Column 22 : [ 21_LOTH= Silicate-Si (mg/l) at the surface ] no problems detected 217 0.0500000007 4.69999981 217 ( 100%) 56 ( 25%) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".