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 (cells/liter)]      ( date set 1 ) Column # 3    [ABDT2= Total Dinoflagellates (cells/litre)]      ( date set 1 ) Column # 4     [ DATE-YMD ]       Date Set = 2 Column # 5    [ABDT1= Skeletonema spp. (cells/liter)]      ( date set 2 ) Column # 6    [ABDT1= Chaetoceros spp. (cells/liter)]      ( date set 2 ) Column # 7    [ABDT1= Pseudo-nitzschia spp. (cells/liter)]      ( date set 2 ) Column # 8    [ABDT1= Rhizosolenia spp. (cells/liter)]      ( date set 2 ) Column # 9    [ABDT1= Thalassionema nitzschioides (cells/liter)]      ( date set 2 ) Column # 10    [ABDT2= Gyrodinium spirale (cells/liter)]      ( date set 2 ) Column # 11     [ DATE-YMD ]       Date Set = 3 Column # 12     [ABDT2= Alexandrium catenella/tamarense (cells/liter)]      ( date set 3 ) Column # 13    [ABDT1= Rhizosolenia pungens/setigera (cells/liter)]      ( date set 3 ) Column # 14    [ABDT1= Leptocylindrus danicus (cells/liter)]      ( date set 3 ) Column # 15    [ABDT1= Leptocylindrus minimus (cells/liter)]      ( date set 3 ) Column # 16    [ABDT2= Heterocapsa triquetra (cells/liter)]      ( date set 3 ) Column # 17    [ABDT1= Guinardia striata (cells/liter)]      ( date set 3 ) Column # 18     [ DATE-YMD ]       Date Set = 4 Column # 19    [ABDT2= Dinophysis sacculus (cells/liter)]      ( date set 4 ) Column # 20    [ABDT2= Protoperidinium bipes (cells/liter)]      ( date set 4 ) Column # 21     [ DATE-YMD ]       Date Set = 5 Column # 22    [ABDT= Euglenophyceae (cells/l)]      ( date set 5 ) Column # 23     [ DATE-YMD ]       Date Set = 6 Column # 24    [ABDT= Picoeukaryotes (cells/liter)]      ( date set 6 ) Column # 25     [ DATE-YMD ]       Date Set = 7 Column # 26    [ABDT= Picocyanobacteria (cells/ml)]      ( date set 7 ) Column # 27     [ DATE-YMD ]       Date Set = 8 Column # 28    [ABDT2= Dinophysis acuminata (cells/liter)]      ( date set 8 ) Column # 29     [ DATE-YMD ]       Date Set = 9 Column # 30    [ABDT1= Dactyliosolen fragilissimus (cells/liter)]      ( date set 9 ) Column # 31     [ DATE-YMD ]       Date Set = 10 Column # 32    [ABDT1= Ceratoneis closterium (cells/liter)]      ( date set 10 ) Column # 33     [ DATE-DMY ]       Date Set = 11 Column # 34    [TEMP= Temperature ( C )]      ( date set 11 ) Column # 35    [PSAL= Salinity ()]      ( date set 11 ) Column # 36    [LOTH= Soluble Reactive Phosphorus (umol-P/liter)]      ( date set 11 ) Column # 37     [ DATE-YMD ]       Date Set = 12 Column # 38    [LOTH= Nitrate (umol-N/liter)]      ( date set 12 ) Column # 39     [ DATE-YMD ]       Date Set = 13 Column # 40    [LOTH= Ammonium (umol-N/liter)]      ( date set 13 ) Column # 41     [ DATE-YMD ]       Date Set = 14 Column # 42    [CHLA= Chlorophyll-a (ug/l)]      ( date set 14 ) Column # 43     [ DATE-YMD ]       Date Set = 15 Column # 44    [LOTH1= Rainfall (mm)]      ( date set 15 ) Column # 45     [ DATE-YMD ]       Date Set = 16 Column # 46    [LOTH= Crassostrea gigas Standing Stock (tons)]      ( date set 16 ) DATA SORTED BY CATEGORY TYPES Abundance (with zeros) Category     Column # 2   [ ABDT1= Total Diatoms (cells/liter) ]     Column # 3   [ ABDT2= Total Dinoflagellates (cells/litre) ]     Column # 5   [ ABDT1= Skeletonema spp. (cells/liter) ]     Column # 6   [ ABDT1= Chaetoceros spp. (cells/liter) ]     Column # 7   [ ABDT1= Pseudo-nitzschia spp. (cells/liter) ]     Column # 8   [ ABDT1= Rhizosolenia spp. (cells/liter) ]     Column # 9   [ ABDT1= Thalassionema nitzschioides (cells/liter) ]     Column # 10   [ ABDT2= Gyrodinium spirale (cells/liter) ]     Column # 12   [ ABDT2= Alexandrium catenella/tamarense (cells/liter) ]     Column # 13   [ ABDT1= Rhizosolenia pungens/setigera (cells/liter) ]     Column # 14   [ ABDT1= Leptocylindrus danicus (cells/liter) ]     Column # 15   [ ABDT1= Leptocylindrus minimus (cells/liter) ]     Column # 16   [ ABDT2= Heterocapsa triquetra (cells/liter) ]     Column # 17   [ ABDT1= Guinardia striata (cells/liter) ]     Column # 19   [ ABDT2= Dinophysis sacculus (cells/liter) ]     Column # 20   [ ABDT2= Protoperidinium bipes (cells/liter) ]     Column # 22   [ ABDT= Euglenophyceae (cells/l) ]     Column # 24   [ ABDT= Picoeukaryotes (cells/liter) ]     Column # 26   [ ABDT= Picocyanobacteria (cells/ml) ]     Column # 28   [ ABDT2= Dinophysis acuminata (cells/liter) ]     Column # 30   [ ABDT1= Dactyliosolen fragilissimus (cells/liter) ]     Column # 32   [ ABDT1= Ceratoneis closterium (cells/liter) ] Log10 (logarithmic) Miscellaenous Category     Column # 36   [ LOTH= Soluble Reactive Phosphorus (umol-P/liter) ]     Column # 38   [ LOTH= Nitrate (umol-N/liter) ]     Column # 40   [ LOTH= Ammonium (umol-N/liter) ]     Column # 44   [ LOTH1= Rainfall (mm) ]     Column # 46   [ LOTH= Crassostrea gigas Standing Stock (tons) ] Temperatures Category     Column # 34   [ TEMP= Temperature ( C ) ] Salinities Category     Column # 35   [ PSAL= Salinity () ] Chlorophyll/Pigments Category     Column # 42   [ CHLA= Chlorophyll-a (ug/l) ] DATA SORTED BY GROUPING SETS: Category 8 Group # 1     column # 2     [ ABDT1= Total Diatoms (cells/liter) ]     column # 5     [ ABDT1= Skeletonema spp. (cells/liter) ]     column # 6     [ ABDT1= Chaetoceros spp. (cells/liter) ]     column # 7     [ ABDT1= Pseudo-nitzschia spp. (cells/liter) ]     column # 8     [ ABDT1= Rhizosolenia spp. (cells/liter) ]     column # 9     [ ABDT1= Thalassionema nitzschioides (cells/liter) ]     column # 13     [ ABDT1= Rhizosolenia pungens/setigera (cells/liter) ]     column # 14     [ ABDT1= Leptocylindrus danicus (cells/liter) ]     column # 15     [ ABDT1= Leptocylindrus minimus (cells/liter) ]     column # 17     [ ABDT1= Guinardia striata (cells/liter) ]     column # 30     [ ABDT1= Dactyliosolen fragilissimus (cells/liter) ]     column # 32     [ ABDT1= Ceratoneis closterium (cells/liter) ] Category 8 Group # 2     column # 3     [ ABDT2= Total Dinoflagellates (cells/litre) ]     column # 10     [ ABDT2= Gyrodinium spirale (cells/liter) ]     column # 12     [ ABDT2= Alexandrium catenella/tamarense (cells/liter) ]     column # 16     [ ABDT2= Heterocapsa triquetra (cells/liter) ]     column # 19     [ ABDT2= Dinophysis sacculus (cells/liter) ]     column # 20     [ ABDT2= Protoperidinium bipes (cells/liter) ]     column # 28     [ ABDT2= Dinophysis acuminata (cells/liter) ] Category 9 Group # 1     column # 44     [ LOTH1= Rainfall (mm) ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 1975 2010 DATES in Column 4 no problems detected 1975 2013 DATES in Column 11 no problems detected 1987 2010 DATES in Column 18 no problems detected 1987 2010 DATES in Column 21 no problems detected 1987 2013 DATES in Column 23 no problems detected 1991 2013 DATES in Column 25 no problems detected 1991 2013 DATES in Column 27 no problems detected 1987 2013 DATES in Column 29 no problems detected 1987 2013 DATES in Column 31 no problems detected 1987 2013 DATES in Column 33 no problems detected 1972 2010 DATES in Column 37 no problems detected 1972 2004 DATES in Column 39 no problems detected 1986 2004 DATES in Column 41 no problems detected 1975 2010 DATES in Column 43 no problems detected 1971 2009 DATES in Column 45 no problems detected 1965 2001   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 2010 4 DATE-YMD DATE-YMD yes 1975 2013 Apr Sep 15 15 11 DATE-YMD DATE-YMD yes 1987 2010 Apr Sep 15 15 18 DATE-YMD DATE-YMD yes 1987 2010 Apr Sep 15 15 21 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15 23 DATE-YMD DATE-YMD yes 1991 2013 Apr Sep 15 15 25 DATE-YMD DATE-YMD yes 1991 2013 Apr Sep 15 15 27 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15 29 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15 31 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15 33 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99 37 DATE-YMD DATE-YMD yes 1972 2004 01 12 15 15 39 DATE-YMD DATE-YMD yes 1986 2004 01 12 15 15 41 DATE-YMD DATE-YMD yes 1975 2010 Apr Sep 15 15 43 DATE-YMD DATE-YMD yes 1971 2009 01 12 15 15 45 DATE-YMD DATE-YMD yes 1965 2001 12 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_ABDT1= Total Diatoms (cells/liter) ] no problems detected 845 300. 50017800. 755 ( 89%) 755 ( 89%) Column 3 : [ 05_ABDT2= Total Dinoflagellates (cells/litre) ] no problems detected 958 50. 2635000. 683 ( 71%) 683 ( 71%) Column 5 : [ 06_ABDT1= Skeletonema spp. (cells/liter) ] no problems detected 276 150. 33500000. 173 ( 62%) 173 ( 62%) Column 6 : [ 07_ABDT1= Chaetoceros spp. (cells/liter) ] no problems detected 276 100. 2250000. 247 ( 89%) 247 ( 89%) Column 7 : [ 08_ABDT1= Pseudo-nitzschia spp. (cells/liter) ] no problems detected 276 500. 3064000. 188 ( 68%) 188 ( 68%) Column 8 : [ 09_ABDT1= Rhizosolenia spp. (cells/liter) ] no problems detected 286 50. 651000. 147 ( 51%) 147 ( 51%) Column 9 : [ 10_ABDT1= Thalassionema nitzschioides (cells/liter) ] no problems detected 285 150. 450000. 60 ( 21%) 60 ( 21%) Column 10 : [ 11_ABDT2= Gyrodinium spirale (cells/liter) ] no problems detected 289 50. 6650. 168 ( 58%) 168 ( 58%) Column 12 : [ 12_ABDT2= Alexandrium catenella/tamarense (cells/liter) ] no problems detected 288 25. 53400. 55 ( 19%) 55 ( 19%) Column 13 : [ 13_ABDT1= Rhizosolenia pungens/setigera (cells/liter) ] no problems detected 276 50. 420100. 99 ( 35%) 99 ( 35%) Column 14 : [ 14_ABDT1= Leptocylindrus danicus (cells/liter) ] no problems detected 267 100. 401600. 122 ( 45%) 122 ( 45%) Column 15 : [ 15_ABDT1= Leptocylindrus minimus (cells/liter) ] no problems detected 267 300. 1168000. 145 ( 54%) 145 ( 54%) Column 16 : [ 16_ABDT2= Heterocapsa triquetra (cells/liter) ] no problems detected 276 50. 248000. 76 ( 27%) 76 ( 27%) Column 17 : [ 17_ABDT1= Guinardia striata (cells/liter) ] no problems detected 275 100. 143000. 60 ( 21%) 60 ( 21%) Column 19 : [ 18_ABDT2= Dinophysis sacculus (cells/liter) ] no problems detected 284 20. 540. 32 ( 11%) 32 ( 11%) Column 20 : [ 19_ABDT2= Protoperidinium bipes (cells/liter) ] no problems detected 275 50. 1000000. 52 ( 18%) 52 ( 18%) Column 22 : [ 20_ABDT= Euglenophyceae (cells/l) ] no problems detected 317 50. 107400. 188 ( 59%) 188 ( 59%) Column 24 : [ 21_ABDT= Picoeukaryotes (cells/liter) ] no problems detected 107 3100000. 239254544. 107 ( 100%) 107 ( 100%) Column 26 : [ 22_ABDT= Picocyanobacteria (cells/ml) ] no problems detected 97 4. 1097100. 84 ( 86%) 84 ( 86%) Column 28 : [ 23_ABDT2= Dinophysis acuminata (cells/liter) ] no problems detected 317 15. 550. 59 ( 18%) 59 ( 18%) Column 30 : [ 24_ABDT1= Dactyliosolen fragilissimus (cells/liter) ] no problems detected 311 100. 404500. 120 ( 38%) 120 ( 38%) Column 32 : [ 25_ABDT1= Ceratoneis closterium (cells/liter) ] no problems detected 311 50. 3320000. 32 ( 10%) 32 ( 10%) Column 34 : [ 26_TEMP= Temperature ( C ) ] no problems detected 427 2.70000005 27.7999992 427 ( 100%) 427 ( 100%) Column 35 : [ 27_PSAL= Salinity () ] no problems detected 1067 22.2999992 40.5999985 1067 ( 100%) 1067 ( 100%) Column 36 : [ 28_LOTH= Soluble Reactive Phosphorus (umol-P/liter) ] no problems detected 230 0.0399999991 10. 230 ( 100%) 151 ( 65%) Column 38 : [ 29_LOTH= Nitrate (umol-N/liter) ] no problems detected 233 0.00999999978 21.3999996 225 ( 96%) 90 ( 38%) Column 40 : [ 30_LOTH= Ammonium (umol-N/liter) ] no problems detected 82 0.0599999987 15.6000004 82 ( 100%) 37 ( 45%) Column 42 : [ 31_CHLA= Chlorophyll-a (ug/l) ] no problems detected 244 0.200000003 13. 244 ( 100%) 190 ( 77%) Column 44 : [ 32_LOTH1= Rainfall (mm) ] no problems detected 420 0.200000003 642. 415 ( 98%) 407 ( 96%) Column 46 : [ 33_LOTH= Crassostrea gigas Standing Stock (tons) ] no problems detected 28 2100. 19000. 28 ( 100%) 28 ( 100%) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".