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     [ABND1= Total Copepods (#/m3)]      ( date set 1 ) Column # 3     [ABND1= Acartia (#/m3)]      ( date set 1 ) Column # 4     [ABND1= Pseudocalanus (#/m3)]      ( date set 1 ) Column # 5     [ABND1= Cladocera (#/m3)]      ( date set 1 ) Column # 6     [LOTH2= Ratio of Pseudocalanus to Acartia (ratio)]      ( date set 1 ) Column # 7     [LOTH2= Ratio of Cladocerans to Copepods (ratio)]      ( date set 1 ) Column # 8     [ DATE-YMD ]       Date Set = 2 Column # 9     [ABDT1= Total Phytoplankton (ug/l)]      ( date set 2 ) Column # 10     [ABDT2= Total Cyanobacteria (ug/l)]      ( date set 2 ) Column # 11     [ABDT2= Total Chlorophyceae (ug/l)]      ( date set 2 ) Column # 12     [ABDT2= Total Chrysophyceae (ug/l)]      ( date set 2 ) Column # 13     [ABDT1= Total Diatomophyceae (ug/l)]      ( date set 2 ) Column # 14     [ABDT2= Total Cryptophyceae (ug/l)]      ( date set 2 ) Column # 15     [ABDT2= Total Euglenophyceae (ug/l)]      ( date set 2 ) Column # 16     [ABDT2= Total Prymnesiophyceae (ug/l)]      ( date set 2 ) Column # 17     [ABDT2= Total Prasinophyceae (ug/l)]      ( date set 2 ) Column # 18     [ABDT1= Total Dinophyceae (ug/l)]      ( date set 2 ) Column # 19     [ABDT2= Total Craspedophyceae (ug/l)]      ( date set 2 ) Column # 20     [ABDT2= Total Ciliophora (ug/l)]      ( date set 2 ) Column # 21     [ABDT2= Remaining unidentified Phytoplankton (ug/l)]      ( date set 2 ) Column # 22     [ DATE-YMD ]       Date Set = 3 Column # 23     [CHLA= Average Chlorophyll (mg/m3) from 0-10m]      ( date set 3 ) Column # 24     [TEMP= Average Temperature ( C ) from 0-10m]      ( date set 3 ) Column # 25     [PSAL= Average Salinity () from 0-10m]      ( date set 3 ) Column # 26     [OTHR= Average Oxygen (ml/l) from 0-10m]      ( date set 3 ) Column # 27     [LOTH= Average NO3 (mmol/m3) from 0-10m]      ( date set 3 ) Column # 28     [LOTH= Average NO2 (mmol/m3) from 0-10m]      ( date set 3 ) Column # 29     [LOTH= Average NH4 (mmol/m3) from 0-10m]      ( date set 3 ) Column # 30     [LOTH= Average PO4 (mmol/m3) from 0-10m]      ( date set 3 ) Column # 31     [LOTH= Average Si04 (mmol/m3) from 0-10m]      ( date set 3 ) DATA SORTED BY CATEGORY TYPES Total/non-zero Abundance Category     Column # 2   [ ABND1= Total Copepods (#/m3) ]     Column # 3   [ ABND1= Acartia (#/m3) ]     Column # 4   [ ABND1= Pseudocalanus (#/m3) ]     Column # 5   [ ABND1= Cladocera (#/m3) ] Abundance (with zeros) Category     Column # 9   [ ABDT1= Total Phytoplankton (ug/l) ]     Column # 10   [ ABDT2= Total Cyanobacteria (ug/l) ]     Column # 11   [ ABDT2= Total Chlorophyceae (ug/l) ]     Column # 12   [ ABDT2= Total Chrysophyceae (ug/l) ]     Column # 13   [ ABDT1= Total Diatomophyceae (ug/l) ]     Column # 14   [ ABDT2= Total Cryptophyceae (ug/l) ]     Column # 15   [ ABDT2= Total Euglenophyceae (ug/l) ]     Column # 16   [ ABDT2= Total Prymnesiophyceae (ug/l) ]     Column # 17   [ ABDT2= Total Prasinophyceae (ug/l) ]     Column # 18   [ ABDT1= Total Dinophyceae (ug/l) ]     Column # 19   [ ABDT2= Total Craspedophyceae (ug/l) ]     Column # 20   [ ABDT2= Total Ciliophora (ug/l) ]     Column # 21   [ ABDT2= Remaining unidentified Phytoplankton (ug/l) ] non-Log10 (linear) Miscellaenous Category     Column # 26   [ OTHR= Average Oxygen (ml/l) from 0-10m ] Temperatures Category     Column # 24   [ TEMP= Average Temperature ( C ) from 0-10m ] Salinities Category     Column # 25   [ PSAL= Average Salinity () from 0-10m ] DATA SORTED BY GROUPING SETS: Category 2 Group # 1     column # 2     [ ABND1= Total Copepods (#/m3) ]     column # 3     [ ABND1= Acartia (#/m3) ]     column # 4     [ ABND1= Pseudocalanus (#/m3) ]     column # 5     [ ABND1= Cladocera (#/m3) ] Category 8 Group # 1     column # 9     [ ABDT1= Total Phytoplankton (ug/l) ]     column # 13     [ ABDT1= Total Diatomophyceae (ug/l) ]     column # 18     [ ABDT1= Total Dinophyceae (ug/l) ] Category 8 Group # 2     column # 10     [ ABDT2= Total Cyanobacteria (ug/l) ]     column # 11     [ ABDT2= Total Chlorophyceae (ug/l) ]     column # 12     [ ABDT2= Total Chrysophyceae (ug/l) ]     column # 14     [ ABDT2= Total Cryptophyceae (ug/l) ]     column # 15     [ ABDT2= Total Euglenophyceae (ug/l) ]     column # 16     [ ABDT2= Total Prymnesiophyceae (ug/l) ]     column # 17     [ ABDT2= Total Prasinophyceae (ug/l) ]     column # 19     [ ABDT2= Total Craspedophyceae (ug/l) ]     column # 20     [ ABDT2= Total Ciliophora (ug/l) ]     column # 21     [ ABDT2= Remaining unidentified Phytoplankton (ug/l) ] DATE REVIEW SECTION [ Jump back to TOP ] DATE COLUMN Comments Minimum Year Maximum Year DATES in Column 1 no problems detected 1981 2015 DATES in Column 8 no problems detected 1979 2013 DATES in Column 22 no problems detected 1994 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-YMD DATE-YMD yes 1981 2015 1 11 1 31 8 DATE-YMD DATE-YMD yes 1979 2013 01 12 01 31 22 DATE-YMD DATE-YMD yes 1994 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_ABND1= Total Copepods (#/m3) ] no problems detected 240 510.000000 48587.0000 240 ( 100 %) 240 ( 100 %) Column 3 : [ 05_ABND1= Acartia (#/m3) ] no problems detected 240 46.0000000 18652.0000 240 ( 100 %) 240 ( 100 %) Column 4 : [ 06_ABND1= Pseudocalanus (#/m3) ] no problems detected 240 3.00000000 11606.0000 240 ( 100 %) 240 ( 100 %) Column 5 : [ 07_ABND1= Cladocera (#/m3) ] no problems detected 240 1.00000000 111820.000 100 ( 41 %) 98 ( 40 %) Column 6 : [ 08_LOTH2= Ratio of Pseudocalanus to Acartia (ratio) ] no problems detected 240 3.00000014E-04 26.4122009 240 ( 100 %) 72 ( 30 %) Column 7 : [ 09_LOTH2= Ratio of Cladocerans to Copepods (ratio) ] no problems detected 240 9.99999975E-05 11.0458002 104 ( 43 %) 28 ( 11 %) Column 9 : [ 10_ABDT1= Total Phytoplankton (ug/l) ] no problems detected 928 9.17000008 32971.4688 928 ( 100 %) 928 ( 100 %) Column 10 : [ 11_ABDT2= Total Cyanobacteria (ug/l) ] no problems detected 928 1.99999996E-02 10095.7900 752 ( 81 %) 604 ( 65 %) Column 11 : [ 12_ABDT2= Total Chlorophyceae (ug/l) ] no problems detected 928 9.99999978E-03 256.000000 546 ( 58 %) 212 ( 22 %) Column 12 : [ 13_ABDT2= Total Chrysophyceae (ug/l) ] no problems detected 928 9.99999978E-03 829.150024 542 ( 58 %) 361 ( 38 %) Column 13 : [ 14_ABDT1= Total Diatomophyceae (ug/l) ] no problems detected 928 5.00000007E-02 32172.8809 858 ( 92 %) 823 ( 88 %) Column 14 : [ 15_ABDT2= Total Cryptophyceae (ug/l) ] no problems detected 928 9.00000036E-02 341.750000 858 ( 92 %) 850 ( 91 %) Column 15 : [ 16_ABDT2= Total Euglenophyceae (ug/l) ] no problems detected 928 2.99999993E-02 798.489990 641 ( 69 %) 541 ( 58 %) Column 16 : [ 17_ABDT2= Total Prymnesiophyceae (ug/l) ] no problems detected 928 9.99999978E-03 676.950012 333 ( 35 %) 216 ( 23 %) Column 17 : [ 18_ABDT2= Total Prasinophyceae (ug/l) ] no problems detected 928 1.99999996E-02 717.809998 690 ( 74 %) 539 ( 58 %) Column 18 : [ 19_ABDT1= Total Dinophyceae (ug/l) ] no problems detected 928 7.99999982E-02 4449.75000 870 ( 93 %) 860 ( 92 %) Column 19 : [ 20_ABDT2= Total Craspedophyceae (ug/l) ] no problems detected 928 9.99999978E-03 786.000000 445 ( 47 %) 117 ( 12 %) Column 20 : [ 21_ABDT2= Total Ciliophora (ug/l) ] no problems detected 928 7.99999982E-02 3653.22998 631 ( 67 %) 613 ( 66 %) Column 21 : [ 22_ABDT2= Remaining unidentified Phytoplankton (ug/l) ] no problems detected 928 9.99999978E-03 2319.64990 818 ( 88 %) 785 ( 84 %) Column 23 : [ 23_CHLA= Average Chlorophyll (mg/m3) from 0-10m ] no problems detected 502 0.133332998 14.8289003 502 ( 100 %) 436 ( 86 %) Column 24 : [ 24_TEMP= Average Temperature ( C ) from 0-10m ] no problems detected 528 0.127553999 22.7371998 528 ( 100 %) 516 ( 97 %) Column 25 : [ 25_PSAL= Average Salinity () from 0-10m ] no problems detected 533 6.81952000 16.2140999 533 ( 100 %) 533 ( 100 %) Column 26 : [ 26_OTHR= Average Oxygen (ml/l) from 0-10m ] no problems detected 528 5.75258017 10.9315004 528 ( 100 %) 528 ( 100 %) Column 27 : [ 27_LOTH= Average NO3 (mmol/m3) from 0-10m ] no problems detected 513 1.60000000E-05 5.67197990 513 ( 100 %) 134 ( 26 %) Column 28 : [ 28_LOTH= Average NO2 (mmol/m3) from 0-10m ] no problems detected 513 1.00000005E-03 1.17332995 513 ( 100 %) 2 ( 0 %) Column 29 : [ 29_LOTH= Average NH4 (mmol/m3) from 0-10m ] no problems detected 197 1.00000005E-03 1.54489994 197 ( 100 %) 2 ( 1 %) Column 30 : [ 30_LOTH= Average PO4 (mmol/m3) from 0-10m ] no problems detected 516 1.00000005E-03 0.898325026 516 ( 100 %) 0 ( 0 %) Column 31 : [ 31_LOTH= Average Si04 (mmol/m3) from 0-10m ] no problems detected 512 1.00000005E-03 19.1082001 512 ( 100 %) 508 ( 99 %) The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".