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     [ABND= Total Copepods (#/m3)]      ( date set 1 ) Column # 3     [ DATE-DMY ]       Date Set = 2 Column # 4     [ABDT2= Total Diatoms (#/L)]      ( date set 2 ) Column # 5     [ABDT2= Total Dinoflagellates (#/ml)]      ( date set 2 ) Column # 6     [ABDT3= Total Diatoms (#/L)]      ( date set 2 ) Column # 7     [ABDT3= Total Dinoflagellates (#/ml)]      ( date set 2 ) Column # 8     [ DATE-YMD ]       Date Set = 3 Column # 9     [TEMP= Temperature ( C ) at 0m]      ( date set 3 ) Column # 10     [PSAL= Salinity () at 0m]      ( date set 3 ) Column # 11     [LOTH= Phosphate (uM) at 0m]      ( date set 3 ) Column # 12     [LOTH= NO3NO2 (uM) at 0m]      ( date set 3 ) Column # 13     [LOTH= NO2 (uM) at 0m]      ( date set 3 ) Column # 14     [LOTH= Silicate (uM) at 0m]      ( date set 3 ) Column # 15     [LOTH= NH4 (uM) at 0m]      ( date set 3 ) Column # 16     [CHLA= Chlorophyll (ug/L) at 0m]      ( date set 3 ) Column # 17     [ DATE-YMD ]       Date Set = 4 Column # 18     [TEMP= Temperature ( C ) at 45m]      ( date set 4 ) Column # 19     [PSAL= Salinity () at 45m]      ( date set 4 ) Column # 20     [LOTH= Phosphate (uM) at 45m]      ( date set 4 ) Column # 21     [LOTH= NO3NO2 (uM) at 45m]      ( date set 4 ) Column # 22     [LOTH= NO2 (uM) at 45m]      ( date set 4 ) Column # 23     [LOTH= Silicate (uM) at 45m]      ( date set 4 ) Column # 24     [LOTH= NH4 (uM) at 45m]      ( date set 4 ) Column # 25     [CHLA= Chlorophyll (ug/L) at 45m]      ( date set 4 ) Column # 26     [ DATE-MDY ]       Date Set = 5 Column # 27     [ABDT7= Total Cnidaria (#/m3)]      ( date set 5 ) Column # 28     [ABDT7= Total Ctenophora (#/m3)]      ( date set 5 ) Column # 29     [ABDT7= Total Chaetognatha (#/m3)]      ( date set 5 ) Column # 30     [ DATE-YMD ]       Date Set = 6 Column # 31     [OTHR= Secchi Depth (m)]      ( date set 6 ) DATA SORTED BY CATEGORY TYPES Total/non-zero Abundance Category     Column # 2   [ ABND= Total Copepods (#/m3) ] Abundance (with zeros) Category     Column # 4   [ ABDT2= Total Diatoms (#/L) ]     Column # 5   [ ABDT2= Total Dinoflagellates (#/ml) ]     Column # 6   [ ABDT3= Total Diatoms (#/L) ]     Column # 7   [ ABDT3= Total Dinoflagellates (#/ml) ]     Column # 27   [ ABDT7= Total Cnidaria (#/m3) ]     Column # 28   [ ABDT7= Total Ctenophora (#/m3) ]     Column # 29   [ ABDT7= Total Chaetognatha (#/m3) ] non-Log10 (linear) Miscellaenous Category     Column # 31   [ OTHR= Secchi Depth (m) ] Temperatures Category     Column # 9   [ TEMP= Temperature ( C ) at 0m ]     Column # 18   [ TEMP= Temperature ( C ) at 45m ] Salinities Category     Column # 10   [ PSAL= Salinity () at 0m ]     Column # 19   [ PSAL= Salinity () at 45m ] DATA SORTED BY GROUPING SETS: Category 8 Group # 2     column # 4     [ ABDT2= Total Diatoms (#/L) ]     column # 5     [ ABDT2= Total Dinoflagellates (#/ml) ] Category 8 Group # 3     column # 6     [ ABDT3= Total Diatoms (#/L) ]     column # 7     [ ABDT3= Total Dinoflagellates (#/ml) ] Category 8 Group # 7     column # 27     [ ABDT7= Total Cnidaria (#/m3) ]     column # 28     [ ABDT7= Total Ctenophora (#/m3) ]     column # 29     [ ABDT7= Total Chaetognatha (#/m3) ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 1999 2017 DATES in Column 3 no problems detected 1997 2017 DATES in Column 8 no problems detected 1998 2016 DATES in Column 17 no problems detected 1997 2017 DATES in Column 26 no problems detected 1999 2017 DATES in Column 30 no problems detected 2001 2016   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 1999 2017 3 DATE-DMY DATE-DMY yes 1 31 01 12 1997 2017 8 DATE-YMD DATE-YMD yes 1998 2016 1 12 1 31 17 DATE-YMD DATE-YMD yes 1997 2017 1 12 1 31 26 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2017 30 DATE-YMD DATE-YMD yes 2001 2016 1 12 1 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 Copepods (#/m3) ] no problems detected 867 33.6800003 22395.3691 866 ( 99 %) 866 ( 99 %) Column 4 : [ 05_ABDT2= Total Diatoms (#/L) ] no problems detected 949 570.000000 3282377.75 890 ( 93 %) 890 ( 93 %) Column 5 : [ 06_ABDT2= Total Dinoflagellates (#/ml) ] no problems detected 949 100.000000 317467.156 633 ( 66 %) 633 ( 66 %) Column 6 : [ 07_ABDT3= Total Diatoms (#/L) ] no problems detected 949 0.569999993 3282.37769 890 ( 93 %) 888 ( 93 %) Column 7 : [ 08_ABDT3= Total Dinoflagellates (#/ml) ] no problems detected 949 0.100000001 317.467163 633 ( 66 %) 627 ( 66 %) Column 9 : [ 09_TEMP= Temperature ( C ) at 0m ] no problems detected 2856 4.36999989 16.2299995 803 ( 28 %) 803 ( 28 %) Column 10 : [ 10_PSAL= Salinity () at 0m ] no problems detected 2856 32.9169998 34.9930000 799 ( 27 %) 799 ( 27 %) Column 11 : [ 11_LOTH= Phosphate (uM) at 0m ] no problems detected 2856 9.99999978E-03 0.720000029 680 ( 23 %) 0 ( 0 %) Column 12 : [ 12_LOTH= NO3NO2 (uM) at 0m ] no problems detected 2856 9.99999978E-03 14.6000004 978 ( 34 %) 583 ( 20 %) Column 13 : [ 13_LOTH= NO2 (uM) at 0m ] no problems detected 2856 9.99999978E-03 1.99000001 149 ( 5 %) 8 ( 0 %) Column 14 : [ 14_LOTH= Silicate (uM) at 0m ] no problems detected 2856 9.99999978E-03 11.6499996 885 ( 30 %) 709 ( 24 %) Column 15 : [ 15_LOTH= NH4 (uM) at 0m ] no problems detected 2856 9.99999978E-03 3.79999995 673 ( 23 %) 123 ( 4 %) Column 16 : [ 16_CHLA= Chlorophyll (ug/L) at 0m ] no problems detected 2856 5.99999987E-02 9.80000019 1453 ( 50 %) 645 ( 22 %) Column 18 : [ 17_TEMP= Temperature ( C ) at 45m ] no problems detected 1211 4.65999985 14.2399998 935 ( 77 %) 935 ( 77 %) Column 19 : [ 18_PSAL= Salinity () at 45m ] no problems detected 1211 33.9920006 34.9930000 925 ( 76 %) 925 ( 76 %) Column 20 : [ 19_LOTH= Phosphate (uM) at 45m ] no problems detected 1211 9.99999978E-03 0.860000014 780 ( 64 %) 0 ( 0 %) Column 21 : [ 20_LOTH= NO3NO2 (uM) at 45m ] no problems detected 1211 9.99999978E-03 11.6999998 1069 ( 88 %) 664 ( 54 %) Column 22 : [ 21_LOTH= NO2 (uM) at 45m ] no problems detected 1211 1.99999996E-02 2.45000005 204 ( 16 %) 15 ( 1 %) Column 23 : [ 22_LOTH= Silicate (uM) at 45m ] no problems detected 1211 9.99999978E-03 8.38000011 974 ( 80 %) 844 ( 69 %) Column 24 : [ 23_LOTH= NH4 (uM) at 45m ] no problems detected 1211 9.99999978E-03 4.40000010 762 ( 62 %) 219 ( 18 %) Column 25 : [24_CHLA= Chlorophyll (ug/L) at 45m ] There is/are 1 count WARNING(S)! Some of your values are zero or "one". Possible warning triggers: a non-numeric value was encountered! text comments like "null" or "n/a" will be ignored. Engineering units ("1.25E5", "1.25 x 10^5") 1211 0.170000002 2.03999996 6 ( 0 %) 2 ( 0 %) Column 27 : [ 25_ABDT7= Total Cnidaria (#/m3) ] no problems detected 867 0.252626896 505.253784 665 ( 76 %) 454 ( 52 %) Column 28 : [ 26_ABDT7= Total Ctenophora (#/m3) ] no problems detected 867 0.252626896 67.1987534 298 ( 34 %) 123 ( 14 %) Column 29 : [ 27_ABDT7= Total Chaetognatha (#/m3) ] no problems detected 867 0.252626896 294.562958 841 ( 97 %) 774 ( 89 %) Column 31 : [ 28_OTHR= Secchi Depth (m) ] no problems detected 706 2.00000000 15.0000000 689 ( 97 %) 689 ( 97 %) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".