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     [ABND= Total Copepoda (#/m3)]      ( date set 1 ) Column # 3     [ DATE-YMD ]       Date Set = 2 Column # 4     [ABND= Total Rotifera (#/m3)]      ( date set 2 ) Column # 5     [ DATE-YMD ]       Date Set = 3 Column # 6     [ABND= Total Cladocera (#/m3)]      ( date set 3 ) Column # 7     [ DATE-YMD ]       Date Set = 4 Column # 8     [ABND= Total Bivalvia (#/m3)]      ( date set 4 ) Column # 9     [ DATE-YMD ]       Date Set = 5 Column # 10     [ABND= Total Appendicularia (#/m3)]      ( date set 5 ) Column # 11     [ DATE-YMD ]       Date Set = 6 Column # 12     [ABND= Total Diatoms (#/L)]      ( date set 6 ) Column # 13     [ DATE-YMD ]       Date Set = 7 Column # 14     [ABND= Total Dinoflagellates (#/L)]      ( date set 7 ) Column # 15     [ DATE-YMD ]       Date Set = 8 Column # 16     [ABND= Total Ciliophora (#/L)]      ( date set 8 ) Column # 17     [ DATE-YMD ]       Date Set = 9 Column # 18     [ABND= Total Coccolithophores (#/L)]      ( date set 9 ) Column # 19     [ DATE-YMD ]       Date Set = 10 Column # 20     [ABND= Total Cryptomonads (#/L)]      ( date set 10 ) Column # 21     [ DATE-YMD ]       Date Set = 11 Column # 22     [TEMP= Temperature (C)]      ( date set 11 ) Column # 23     [PSAL= Salinity (pss)]      ( date set 11 ) Column # 24     [OTHR= pH ()]      ( date set 11 ) Column # 25     [OTHR= Oxygen (ml/l)]      ( date set 11 ) Column # 26     [OTHR= OxygenSat (%)]      ( date set 11 ) Column # 27     [LOTH= Po4-P (uM)]      ( date set 11 ) Column # 28     [LOTH= Tot-P (uM)]      ( date set 11 ) Column # 29     [LOTH= NO2-N (uM)]      ( date set 11 ) Column # 30     [LOTH= NO3-N (uM)]      ( date set 11 ) Column # 31     [LOTH= NH4-N (uM)]      ( date set 11 ) Column # 32     [LOTH= Tot-N (uM)]      ( date set 11 ) Column # 33     [LOTH= SiO3-Si (uM)]      ( date set 11 ) Column # 34     [CHLA= Chlorophyll (ug/l)]      ( date set 11 ) Column # 35     [ DATE-YMD ]       Date Set = 12 Column # 36     [ABDT1= Total Copepoda (#/m3)]      ( date set 12 ) Column # 37     [ABDT1= Total Rotifera (#/m3)]      ( date set 12 ) Column # 38     [ABDT1= Total Cirripedia (#/m3)]      ( date set 12 ) Column # 39     [ABDT1= Total Euphausiacea (#/m3)]      ( date set 12 ) Column # 40     [ABDT1= Total Polychaeta (#/m3)]      ( date set 12 ) Column # 41     [ABDT1= Total Gastropoda (#/m3)]      ( date set 12 ) Column # 42     [ABDT1= Total Bivalvia (#/m3)]      ( date set 12 ) Column # 43     [ABDT1= Total Chaetognatha (#/m3)]      ( date set 12 ) Column # 44     [ABDT1= Total Echinodermata (#/m3)]      ( date set 12 ) Column # 45     [ABDT1= Total Appendicularia (#/m3)]      ( date set 12 ) Column # 46     [ABDT2= Total Copepoda (#/m3)]      ( date set 12 ) Column # 47     [ABDT2= Acartia spp. (#/m3)]      ( date set 12 ) Column # 48     [ABDT2= Calanus spp. (#/m3)]      ( date set 12 ) Column # 49     [ABDT2= Centropages spp. (#/m3)]      ( date set 12 ) Column # 50     [ABDT2= Microsetella spp. (#/m3)]      ( date set 12 ) Column # 51     [ABDT2= Oithona spp. (#/m3)]      ( date set 12 ) Column # 52     [ABDT2= Paracalanus spp. (#/m3)]      ( date set 12 ) Column # 53     [ABDT2= Temora spp. (#/m3)]      ( date set 12 ) Column # 54     [ABDT2= Other copepoda (#/m3)]      ( date set 12 ) Column # 55     [ DATE-YMD ]       Date Set = 13 Column # 56     [ABDT1= Total Diatoms (#/L)]      ( date set 13 ) Column # 57     [ABDT1= Total Dinoflagellates (#/L)]      ( date set 13 ) Column # 58     [ABDT1= Total Cyanobacteria (#/L)]      ( date set 13 ) Column # 59     [ABDT1= Total Coccolithophorids (#/L)]      ( date set 13 ) Column # 60     [ABDT1= Total Ciliphora (#/L)]      ( date set 13 ) Column # 61     [ABDT1= Total Cryptomonads (#/L)]      ( date set 13 ) Column # 62     [ABDT1= Total Chrysomonads (#/L)]      ( date set 13 ) Column # 63     [ABDT1= Total Euglenophyta (#/L)]      ( date set 13 ) DATA SORTED BY CATEGORY TYPES Total/non-zero Abundance Category     Column # 2   [ ABND= Total Copepoda (#/m3) ]     Column # 4   [ ABND= Total Rotifera (#/m3) ]     Column # 6   [ ABND= Total Cladocera (#/m3) ]     Column # 8   [ ABND= Total Bivalvia (#/m3) ]     Column # 10   [ ABND= Total Appendicularia (#/m3) ]     Column # 12   [ ABND= Total Diatoms (#/L) ]     Column # 14   [ ABND= Total Dinoflagellates (#/L) ]     Column # 16   [ ABND= Total Ciliophora (#/L) ]     Column # 18   [ ABND= Total Coccolithophores (#/L) ]     Column # 20   [ ABND= Total Cryptomonads (#/L) ] Abundance (with zeros) Category     Column # 36   [ ABDT1= Total Copepoda (#/m3) ]     Column # 37   [ ABDT1= Total Rotifera (#/m3) ]     Column # 38   [ ABDT1= Total Cirripedia (#/m3) ]     Column # 39   [ ABDT1= Total Euphausiacea (#/m3) ]     Column # 40   [ ABDT1= Total Polychaeta (#/m3) ]     Column # 41   [ ABDT1= Total Gastropoda (#/m3) ]     Column # 42   [ ABDT1= Total Bivalvia (#/m3) ]     Column # 43   [ ABDT1= Total Chaetognatha (#/m3) ]     Column # 44   [ ABDT1= Total Echinodermata (#/m3) ]     Column # 45   [ ABDT1= Total Appendicularia (#/m3) ]     Column # 46   [ ABDT2= Total Copepoda (#/m3) ]     Column # 47   [ ABDT2= Acartia spp. (#/m3) ]     Column # 48   [ ABDT2= Calanus spp. (#/m3) ]     Column # 49   [ ABDT2= Centropages spp. (#/m3) ]     Column # 50   [ ABDT2= Microsetella spp. (#/m3) ]     Column # 51   [ ABDT2= Oithona spp. (#/m3) ]     Column # 52   [ ABDT2= Paracalanus spp. (#/m3) ]     Column # 53   [ ABDT2= Temora spp. (#/m3) ]     Column # 54   [ ABDT2= Other copepoda (#/m3) ]     Column # 56   [ ABDT1= Total Diatoms (#/L) ]     Column # 57   [ ABDT1= Total Dinoflagellates (#/L) ]     Column # 58   [ ABDT1= Total Cyanobacteria (#/L) ]     Column # 59   [ ABDT1= Total Coccolithophorids (#/L) ]     Column # 60   [ ABDT1= Total Ciliphora (#/L) ]     Column # 61   [ ABDT1= Total Cryptomonads (#/L) ]     Column # 62   [ ABDT1= Total Chrysomonads (#/L) ]     Column # 63   [ ABDT1= Total Euglenophyta (#/L) ] non-Log10 (linear) Miscellaenous Category     Column # 24   [ OTHR= pH () ]     Column # 25   [ OTHR= Oxygen (ml/l) ]     Column # 26   [ OTHR= OxygenSat (%) ] Temperatures Category     Column # 22   [ TEMP= Temperature (C) ] Salinities Category     Column # 23   [ PSAL= Salinity (pss) ] DATA SORTED BY GROUPING SETS: Category 8 Group # 1     column # 36     [ ABDT1= Total Copepoda (#/m3) ]     column # 37     [ ABDT1= Total Rotifera (#/m3) ]     column # 38     [ ABDT1= Total Cirripedia (#/m3) ]     column # 39     [ ABDT1= Total Euphausiacea (#/m3) ]     column # 40     [ ABDT1= Total Polychaeta (#/m3) ]     column # 41     [ ABDT1= Total Gastropoda (#/m3) ]     column # 42     [ ABDT1= Total Bivalvia (#/m3) ]     column # 43     [ ABDT1= Total Chaetognatha (#/m3) ]     column # 44     [ ABDT1= Total Echinodermata (#/m3) ]     column # 45     [ ABDT1= Total Appendicularia (#/m3) ]     column # 56     [ ABDT1= Total Diatoms (#/L) ]     column # 57     [ ABDT1= Total Dinoflagellates (#/L) ]     column # 58     [ ABDT1= Total Cyanobacteria (#/L) ]     column # 59     [ ABDT1= Total Coccolithophorids (#/L) ]     column # 60     [ ABDT1= Total Ciliphora (#/L) ]     column # 61     [ ABDT1= Total Cryptomonads (#/L) ]     column # 62     [ ABDT1= Total Chrysomonads (#/L) ]     column # 63     [ ABDT1= Total Euglenophyta (#/L) ] Category 8 Group # 2     column # 46     [ ABDT2= Total Copepoda (#/m3) ]     column # 47     [ ABDT2= Acartia spp. (#/m3) ]     column # 48     [ ABDT2= Calanus spp. (#/m3) ]     column # 49     [ ABDT2= Centropages spp. (#/m3) ]     column # 50     [ ABDT2= Microsetella spp. (#/m3) ]     column # 51     [ ABDT2= Oithona spp. (#/m3) ]     column # 52     [ ABDT2= Paracalanus spp. (#/m3) ]     column # 53     [ ABDT2= Temora spp. (#/m3) ]     column # 54     [ ABDT2= Other copepoda (#/m3) ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 2007 2023 DATES in Column 3 no problems detected 2007 2018 DATES in Column 5 no problems detected 2007 2022 DATES in Column 7 no problems detected 2008 2018 DATES in Column 9 no problems detected 2007 2018 DATES in Column 11 no problems detected 2001 2023 DATES in Column 13 no problems detected 2001 2023 DATES in Column 15 no problems detected 2001 2023 DATES in Column 17 no problems detected 2001 2023 DATES in Column 19 no problems detected 2001 2023 DATES in Column 21 no problems detected 2001 2012 DATES in Column 35 no problems detected 2007 2011 DATES in Column 55 no problems detected 2002 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-YMD DATE-YMD yes 2007 2023 01 12 01 31 3 DATE-YMD DATE-YMD yes 2007 2018 01 12 01 30 5 DATE-YMD DATE-YMD yes 2007 2022 01 12 01 31 7 DATE-YMD DATE-YMD yes 2008 2018 01 12 01 31 9 DATE-YMD DATE-YMD yes 2007 2018 01 12 05 31 11 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31 13 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31 15 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31 17 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31 19 DATE-YMD DATE-YMD yes 2001 2023 01 12 01 31 21 DATE-YMD DATE-YMD yes 2001 2012 1 12 1 31 35 DATE-YMD DATE-YMD yes 2007 2011 01 12 06 31 55 DATE-YMD DATE-YMD yes 2002 2010 01 12 03 31 DATA REVIEW SECTION [ Jump back to TOP ] DATA COLUMN Comments "n" Minimum (non-zero) Maximum Values > 0 Values > 1 Column 2 : [ 04_ABND= Total Copepoda (#/m3) ] no problems detected 127 134.080002 26091.5195 127 ( 100 %) 127 ( 100 %) Column 4 : [ 05_ABND= Total Rotifera (#/m3) ] no problems detected 33 20.4799995 114032.602 33 ( 100 %) 33 ( 100 %) Column 6 : [ 06_ABND= Total Cladocera (#/m3) ] no problems detected 68 13.3332996 20316.1602 68 ( 100 %) 68 ( 100 %) Column 8 : [ 07_ABND= Total Bivalvia (#/m3) ] no problems detected 71 10.2399998 45875.2422 71 ( 100 %) 71 ( 100 %) Column 10 : [ 08_ABND= Total Appendicularia (#/m3) ] no problems detected 68 10.2399998 27525.0996 68 ( 100 %) 68 ( 100 %) Column 12 : [ 09_ABND= Total Diatoms (#/L) ] no problems detected 248 100.000000 5000000.00 248 ( 100 %) 248 ( 100 %) Column 14 : [ 10_ABND= Total Dinoflagellates (#/L) ] no problems detected 252 91.0000000 493574.000 252 ( 100 %) 252 ( 100 %) Column 16 : [ 11_ABND= Total Ciliophora (#/L) ] no problems detected 230 40.0000000 71470.0000 230 ( 100 %) 230 ( 100 %) Column 18 : [ 12_ABND= Total Coccolithophores (#/L) ] no problems detected 172 817.000000 2857269.00 172 ( 100 %) 172 ( 100 %) Column 20 : [ 13_ABND= Total Cryptomonads (#/L) ] no problems detected 236 372.000000 2063860.25 236 ( 100 %) 236 ( 100 %) Column 22 : [ 14_TEMP= Temperature (C) ] no problems detected 138 -1.05999994 20.7800007 136 ( 98 %) 136 ( 98 %) Column 23 : [ 15_PSAL= Salinity (pss) ] no problems detected 134 15.9219999 34.2820015 134 ( 100 %) 134 ( 100 %) Column 24 : [ 16_OTHR= pH () ] no problems detected 62 8.10999966 8.46000004 62 ( 100 %) 62 ( 100 %) Column 25 : [ 17_OTHR= Oxygen (ml/l) ] no problems detected 137 5.46999979 9.53999996 137 ( 100 %) 137 ( 100 %) Column 26 : [ 18_OTHR= OxygenSat (%) ] no problems detected 131 96.0000000 114.000000 131 ( 100 %) 131 ( 100 %) Column 27 : [ 19_LOTH= Po4-P (uM) ] no problems detected 139 1.99999996E-02 0.579999983 139 ( 100 %) 0 ( 0 %) Column 28 : [ 20_LOTH= Tot-P (uM) ] no problems detected 135 0.129999995 1.08000004 135 ( 100 %) 1 ( 0 %) Column 29 : [ 21_LOTH= NO2-N (uM) ] no problems detected 139 1.99999996E-02 1.35000002 139 ( 100 %) 1 ( 0 %) Column 30 : [ 22_LOTH= NO3-N (uM) ] no problems detected 139 0.100000001 9.15999985 139 ( 100 %) 45 ( 32 %) Column 31 : [ 23_LOTH= NH4-N (uM) ] no problems detected 135 5.00000007E-02 1.37000000 135 ( 100 %) 2 ( 1 %) Column 32 : [ 24_LOTH= Tot-N (uM) ] no problems detected 135 6.90000010 22.2999992 135 ( 100 %) 135 ( 100 %) Column 33 : [ 25_LOTH= SiO3-Si (uM) ] no problems detected 139 0.100000001 8.39999962 139 ( 100 %) 66 ( 47 %) Column 34 : [ 26_CHLA= Chlorophyll (ug/l) ] no problems detected 139 0.100000001 19.8999996 139 ( 100 %) 52 ( 37 %) Column 36 : [ 27_ABDT1= Total Copepoda (#/m3) ] no problems detected 36 59.6800003 106055.672 36 ( 100 %) 36 ( 100 %) Column 37 : [ 28_ABDT1= Total Rotifera (#/m3) ] no problems detected 36 0.639999986 5570.56006 9 ( 25 %) 8 ( 22 %) Column 38 : [ 29_ABDT1= Total Cirripedia (#/m3) ] no problems detected 36 0.639999986 163.839996 7 ( 19 %) 6 ( 16 %) Column 39 : [ 30_ABDT1= Total Euphausiacea (#/m3) ] no problems detected 36 0.479999989 163.839996 13 ( 36 %) 11 ( 30 %) Column 40 : [ 31_ABDT1= Total Polychaeta (#/m3) ] no problems detected 36 0.639999986 2785.28003 20 ( 55 %) 19 ( 52 %) Column 41 : [ 32_ABDT1= Total Gastropoda (#/m3) ] no problems detected 36 5.11999989 23592.9609 31 ( 86 %) 31 ( 86 %) Column 42 : [ 33_ABDT1= Total Bivalvia (#/m3) ] no problems detected 36 5.11999989 23592.9609 31 ( 86 %) 31 ( 86 %) Column 43 : [ 34_ABDT1= Total Chaetognatha (#/m3) ] no problems detected 36 0.159999996 43.5200005 15 ( 41 %) 12 ( 33 %) Column 44 : [ 35_ABDT1= Total Echinodermata (#/m3) ] no problems detected 36 2.55999994 5898.24023 24 ( 66 %) 24 ( 66 %) Column 45 : [ 36_ABDT1= Total Appendicularia (#/m3) ] no problems detected 36 0.639999986 983.039978 26 ( 72 %) 25 ( 69 %) Column 46 : [ 37_ABDT2= Total Copepoda (#/m3) ] no problems detected 36 59.6800003 106055.672 36 ( 100 %) 36 ( 100 %) Column 47 : [ 38_ABDT2= Acartia spp. (#/m3) ] no problems detected 36 0.959999979 3932.15991 32 ( 88 %) 31 ( 86 %) Column 48 : [ 39_ABDT2= Calanus spp. (#/m3) ] no problems detected 36 5.11999989 6225.91992 35 ( 97 %) 35 ( 97 %) Column 49 : [ 40_ABDT2= Centropages spp. (#/m3) ] no problems detected 36 0.479999989 3461.11987 32 ( 88 %) 31 ( 86 %) Column 50 : [ 41_ABDT2= Microsetella spp. (#/m3) ] no problems detected 36 0.639999986 1310.71997 24 ( 66 %) 23 ( 63 %) Column 51 : [ 42_ABDT2= Oithona spp. (#/m3) ] no problems detected 36 18.0799999 93716.4766 35 ( 97 %) 35 ( 97 %) Column 52 : [ 43_ABDT2= Paracalanus spp. (#/m3) ] no problems detected 36 3.83999991 21135.3594 34 ( 94 %) 34 ( 94 %) Column 53 : [ 44_ABDT2= Temora spp. (#/m3) ] no problems detected 36 0.159999996 1310.71997 25 ( 69 %) 24 ( 66 %) Column 54 : [ 45_ABDT2= Other copepoda (#/m3) ] no problems detected 36 12.9600000 2621.43994 35 ( 97 %) 35 ( 97 %) Column 56 : [ 46_ABDT1= Total Diatoms (#/L) ] no problems detected 85 50.0000000 5147470.00 83 ( 97 %) 83 ( 97 %) Column 57 : [ 47_ABDT1= Total Dinoflagellates (#/L) ] no problems detected 85 102.000000 286320.000 85 ( 100 %) 85 ( 100 %) Column 58 : [ 48_ABDT1= Total Cyanobacteria (#/L) ] no problems detected 85 250.000000 6809400.00 9 ( 10 %) 9 ( 10 %) Column 59 : [ 49_ABDT1= Total Coccolithophorids (#/L) ] no problems detected 85 1778.00000 372827.000 39 ( 45 %) 39 ( 45 %) Column 60 : [ 50_ABDT1= Total Ciliphora (#/L) ] no problems detected 85 50.0000000 15299.0000 83 ( 97 %) 83 ( 97 %) Column 61 : [ 51_ABDT1= Total Cryptomonads (#/L) ] no problems detected 85 1805.00000 1178620.00 81 ( 95 %) 81 ( 95 %) Column 62 : [ 52_ABDT1= Total Chrysomonads (#/L) ] no problems detected 85 50.0000000 176171.000 44 ( 51 %) 44 ( 51 %) Column 63 : [ 53_ABDT1= Total Euglenophyta (#/L) ] no problems detected 85 50.0000000 12291.0000 9 ( 10 %) 9 ( 10 %) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".