Spreadsheet: 99721d1298310327-if-then-over-a-column-qaqc-waterpier1
Sheet: Data

Start Date: | 2011-01-01 00:00:00
End Date:
 |  | 85379 | 85383 | 85388 | 85396 | 85398 | 85438 | 85443 | 85448 | 85449
Date | Time | Temp | SpCond | Salinity | Depth | Battery | Chlorophyll | Turbidity+ | ODO% | [NAME]
MM/dd/yyyy | HH:[NAME] | F | mS/cm | ppt | m | V | ug/L | NTU | % | mg/L
2011-01-01 00:00:00 | 00:00:00 | 35.5499992370605 | 24.1399993896484 | 14.2700004577637 | 1.17900002002716 | 13.8000001907349 | 17.7000007629395 | 3.70000004768372 | 107.900001525879 | 13.539999961853
2011-01-01 00:00:00 | 00:15:00 | 35.5299987792969 | 24.1399993896484 | 14.2700004577637 | 1.15900003910065 | 13.8999996185303 | 18.1000003814697 | 2.59999990463257 | 107.900001525879 | 13.539999961853
2011-01-01 00:00:00 | 00:30:00 | 35.4199981689453 | 24.1100006103516 | 14.2399997711182 | 1.14300000667572 | 13.8999996185303 | 20.2999992370605 | 3.59999990463257 | 107.300003051758 | 13.5
2011-01-01 00:00:00 | 00:45:00 | 35.4799995422363 | 24.1399993896484 | 14.2600002288818 | 1.13100004196167 | 13.8000001907349 | 19.3999996185303 | 3.5 | 107.599998474121 | 13.5200004577637
2011-01-01 00:00:00 | 01:00:00 | 35.3499984741211 | 24.1399993896484 | 14.2600002288818 | 1.11300003528595 | 13.8000001907349 | 19 | 4.19999980926514 | 106.599998474121 | 13.4099998474121
2011-01-01 00:00:00 | 01:15:00 | 35.4700012207031 | 24.1200008392334 | 14.25 | 1.0900000333786 | 13.8000001907349 | 19.3999996185303 | 2.59999990463257 | 106.800003051758 | 13.4200000762939
2011-01-01 00:00:00 | 01:30:00 | 35.5299987792969 | 24.1399993896484 | 14.2700004577637 | 1.067999958992 | 13.8000001907349 | 19.6000003814697 | 3.70000004768372 | 108.199996948242 | 13.5900001525879
2011-01-01 00:00:00 | 01:45:00 | 35.5099983215332 | 24.1399993896484 | 14.2700004577637 | 1.04900002479553 | 13.8000001907349 | 19 | 2.90000009536743 | 108.099998474121 | 13.5799999237061
2011-01-01 00:00:00 | 02:00:00 | 35.5099983215332 | 24.1599998474121 | 14.2799997329712 | 1.02499997615814 | 13.8000001907349 | 18.5 | 3.70000004768372 | 108 | 13.5600004196167
2011-01-01 00:00:00 | 02:15:00 | 35.5400009155273 | 24.1599998474121 | 14.2799997329712 | 1.00100004673004 | 13.8000001907349 | 17.7000007629395 | 3.5 | 108.099998474121 | 13.5699996948242
2011-01-01 00:00:00 | 02:30:00 | 35.5099983215332 | 24.1499996185303 | 14.2700004577637 | 0.976000010967255 | 13.8000001907349 | 18.6000003814697 | 3.5 | 108 | 13.5600004196167
2011-01-01 00:00:00 | 02:45:00 | 35.439998626709 | 24.1399993896484 | 14.2600002288818 | 0.953999996185303 | 13.6999998092651 | 19.2999992370605 | 2.70000004768372 | 107.800003051758 | 13.5500001907349
2011-01-01 00:00:00 | 03:00:00 | 35.3400001525879 | 24.1100006103516 | 14.2399997711182 | 0.934000015258789 | 13.6999998092651 | 18.7999992370605 | 2.40000009536743 | 107.5 | 13.539999961853
2011-01-01 00:00:00 | 03:15:00 | 35.5200004577637 | 24.1000003814697 | 14.2399997711182 | 0.915000021457672 | 13.8000001907349 | 17.2999992370605 | 2.59999990463257 | 109.099998474121 | 13.710000038147
2011-01-01 00:00:00 | 03:30:00 | 35.5 | 24.1299991607666 | 14.2600002288818 | 0.893999993801117 | 13.6999998092651 | 16.7000007629395 | 2.5 | 108.199996948242 | 13.5900001525879
2011-01-01 00:00:00 | 03:45:00 | 35.5200004577637 | 24.1599998474121 | 14.2700004577637 | 0.876999974250793 | 13.6999998092651 | 17.7999992370605 | 2.79999995231628 | 107.800003051758 | 13.539999961853
2011-01-01 00:00:00 | 04:00:00 | 35.5499992370605 | 24.2199993133545 | 14.3199996948242 | 0.85699999332428 | 13.6999998092651 | 17.7000007629395 | 3.90000009536743 | 107 | 13.4200000762939
2011-01-01 00:00:00 | 04:15:00 | 35.5499992370605 | 24.2700004577637 | 14.3500003814697 | 0.83899998664856 | 13.6999998092651 | 17.7999992370605 | 2.90000009536743 | 106.300003051758 | 13.3299999237061
2011-01-01 00:00:00 | 04:30:00 | 35.560001373291 | 24.2999992370605 | 14.3699998855591 | 0.824999988079071 | 13.6999998092651 | 17.7999992370605 | 2.79999995231628 | 105.5 | 13.2299995422363
2011-01-01 00:00:00 | 04:45:00 | 35.5299987792969 | 24.3700008392334 | 14.4099998474121 | 0.810999989509583 | 13.6000003814697 | 18.1000003814697 | 3.70000004768372 | 104.300003051758 | 13.0799999237061
2011-01-01 00:00:00 | 05:00:00 | 35.5499992370605 | 24.2600002288818 | 14.3400001525879 | 0.799000024795532 | 13.6000003814697 | 18.2000007629395 | 3.20000004768372 | 104.900001525879 | 13.1599998474121
2011-01-01 00:00:00 | 05:15:00 | 35.5699996948242 | 24.1000003814697 | 14.2399997711182 | 0.792999982833862 | 13.6999998092651 | 17.5 | 2.40000009536743 | 107 | 13.4200000762939
2011-01-01 00:00:00 | 05:30:00 | 35.5299987792969 | 24.2600002288818 | 14.3400001525879 | 0.787999987602234 | 13.6000003814697 | 18.1000003814697 | 2.70000004768372 | 106.599998474121 | 13.3800001144409
2011-01-01 00:00:00 | 05:45:00 | 35.5499992370605 | 24.1499996185303 | 14.2700004577637 | 0.78600001335144 | 13.5 | 17.7000007629395 | 2.70000004768372 | 107 | 13.4399995803833
2011-01-01 00:00:00 | 06:00:00 | 35.6300010681152 | 24.0100002288818 | 14.1800003051758 | 0.78600001335144 | 13.5 | 17.6000003814697 | 2.40000009536743 | 109.699996948242 | 13.75
2011-01-01 00:00:00 | 06:15:00 | 35.5999984741211 | 24.0699996948242 | 14.2200002670288 | 0.794000029563904 | 13.6000003814697 | 17 | 2.59999990463257 | 109.400001525879 | 13.7200002670288
2011-01-01 00:00:00 | 06:30:00 | 35.6300010681152 | 24.0100002288818 | 14.1899995803833 | 0.805999994277954 | 13.5 | 16.1000003814697 | 2.40000009536743 | 109.300003051758 | 13.710000038147
2011-01-01 00:00:00 | 06:45:00 | 35.560001373291 | 24.1800003051758 | 14.289999961853 | 0.824000000953674 | 13.5 | 17.7999992370605 | 2.5 | 108.5 | 13.6099996566772
2011-01-01 00:00:00 | 07:00:00 | 35.560001373291 | 24.1900005340576 | 14.3000001907349 | 0.848999977111816 | 13.5 | 16 | 3.5 | 109.599998474121 | 13.75
2011-01-01 00:00:00 | 07:15:00 | 35.6399993896484 | 24.1200008392334 | 14.2600002288818 | 0.870000004768372 | 13.5 | 17.2000007629395 | 2.70000004768372 | 109 | 13.6599998474121
2011-01-01 00:00:00 | 07:30:00 | 35.4900016784668 | 24.1499996185303 | 14.2700004577637 | 0.89300000667572 | 13.5 | 18.3999996185303 | 2.70000004768372 | 107.900001525879 | 13.5500001907349
2011-01-01 00:00:00 | 07:45:00 | 35.5 | 24.1800003051758 | 14.289999961853 | 0.915000021457672 | 13.8999996185303 | 18.7999992370605 | 2.5 | 107.300003051758 | 13.4799995422363
2011-01-01 00:00:00 | 08:00:00 | 35.439998626709 | 24.2099990844727 | 14.3000001907349 | 0.936999976634979 | 14.1000003814697 | 18.6000003814697 | 3.70000004768372 | 106.5 | 13.3900003433228
2011-01-01 00:00:00 | 08:15:00 | 35.4199981689453 | 24.2199993133545 | 14.3100004196167 | 0.955999970436096 | 14.3000001907349 | 18.1000003814697 | 3.79999995231628 | 106.300003051758 | 13.3599996566772
2011-01-01 00:00:00 | 08:30:00 | 35.5299987792969 | 24.2299995422363 | 14.3199996948242 | 0.980000019073486 | 15 | 15.6999998092651 | 2.59999990463257 | 107 | 13.4200000762939
2011-01-01 00:00:00 | 08:45:00 | 35.4700012207031 | 24.2299995422363 | 14.3199996948242 | 1.00399994850159 | 14.5 | 16.3999996185303 | 2.70000004768372 | 106.800003051758 | 13.4200000762939
2011-01-01 00:00:00 | 09:00:00 | 35.4099998474121 | 24.2199993133545 | 14.3100004196167 | 1.02999997138977 | 15.3000001907349 | 15.3000001907349 | 3 | 106.800003051758 | 13.4300003051758
2011-01-01 00:00:00 | 09:15:00 | 35.439998626709 | 24.2199993133545 | 14.3100004196167 | 1.05499994754791 | 14.3000001907349 | 14 | 3.90000009536743 | 106.900001525879 | 13.4300003051758
2011-01-01 00:00:00 | 09:30:00 | 35.5 | 24.2299995422363 | 14.3199996948242 | 1.07500004768372 | 15.1999998092651 | 14.6999998092651 | 2.90000009536743 | 107.099998474121 | 13.4499998092651
2011-01-01 00:00:00 | 09:45:00 | 35.6199989318848 | 24.2700004577637 | 14.3500003814697 | 1.09599995613098 | 15.3000001907349 | 13.6999998092651 | 3.09999990463257 | 106.699996948242 | 13.3699998855591
2011-01-01 00:00:00 | 10:00:00 | 35.7099990844727 | 24.2700004577637 | 14.3599996566772 | 1.11699998378754 | 14.3999996185303 | 12.3999996185303 | 3.90000009536743 | 106.800003051758 | 13.3699998855591
2011-01-01 00:00:00 | 10:15:00 | 35.6800003051758 | 24.2600002288818 | 14.3500003814697 | 1.13900005817413 | 15.3000001907349 | 13.5 | 3.09999990463257 | 107.5 | 13.460000038147
2011-01-01 00:00:00 | 10:30:00 | 35.7000007629395 | 24.2600002288818 | 14.3500003814697 | 1.14699995517731 | 15.3999996185303 | 15.6999998092651 | 2.90000009536743 | 107.599998474121 | 13.4700002670288
2011-01-01 00:00:00 | 10:45:00 | 35.7000007629395 | 24.2600002288818 | 14.3500003814697 | 1.16299998760223 | 14.3999996185303 | 16.2999992370605 | 3.90000009536743 | 108.099998474121 | 13.5299997329712
2011-01-01 00:00:00 | 11:00:00 | 35.7599983215332 | 24.2199993133545 | 14.3199996948242 | 1.16400003433228 | 14.6000003814697 | 16.1000003814697 | 2.59999990463257 | 108.900001525879 | 13.6199998855591
2011-01-01 00:00:00 | 11:15:00 | 35.7900009155273 | 24.2099990844727 | 14.3199996948242 | 1.1710000038147 | 15.3000001907349 | 18.1000003814697 | 3.59999990463257 | 109.300003051758 | 13.6599998474121
2011-01-01 00:00:00 | 11:30:00 | 35.9099998474121 | 24.2000007629395 | 14.3199996948242 | 1.17299997806549 | 14.8999996185303 | 16 | 2.90000009536743 | 109.599998474121 | 13.6800003051758
2011-01-01 00:00:00 | 11:45:00 | 36.1800003051758 | 24.1700000762939 | 14.3100004196167 | 1.17499995231628 | 14.6000003814697 | 15.1999998092651 | 2.70000004768372 | 110.900001525879 | 13.789999961853
2011-01-01 00:00:00 | 12:00:00 | 36.3699989318848 | 24.1499996185303 | 14.3000001907349 | 1.17999994754791 | 15.1000003814697 | 14.5 | 2.59999990463257 | 112 | 13.8800001144409
2011-01-01 00:00:00 | 12:15:00 | 36.3199996948242 | 24.1200008392334 | 14.289999961853 | 1.17200005054474 | 14.3999996185303 | 15.3000001907349 | 3.70000004768372 | 111.900001525879 | 13.8900003433228
2011-01-01 00:00:00 | 12:30:00 | 36.1300010681152 | 24.1200008392334 | 14.2799997329712 | 1.16799998283386 | 14.5 | 12.3999996185303 | 3.79999995231628 | 110.199996948242 | 13.7200002670288
2011-01-01 00:00:00 | 12:45:00 | 36.0299987792969 | 24.1299991607666 | 14.2799997329712 | 1.1690000295639 | 14.3000001907349 | 13.8999996185303 | 2.90000009536743 | 110.699996948242 | 13.789999961853
2011-01-01 00:00:00 | 13:00:00 | 36.0400009155273 | 24.1200008392334 | 14.2700004577637 | 1.15400004386902 | 14.8999996185303 | 13.3999996185303 | 3.90000009536743 | 110.699996948242 | 13.8000001907349
2011-01-01 00:00:00 | 13:15:00 | 36.0699996948242 | 24.1200008392334 | 14.2700004577637 | 1.13199996948242 | 14.8999996185303 | 15 | 2.79999995231628 | 111.400001525879 | 13.8699998855591
2011-01-01 00:00:00 | 13:30:00 | 35.9900016784668 | 24.0799999237061 | 14.2399997711182 | 1.11600005626678 | 14.3000001907349 | 16.6000003814697 | 4 | 111.099998474121 | 13.8599996566772
2011-01-01 00:00:00 | 13:45:00 | 35.9099998474121 | 24.0300006866455 | 14.210000038147 | 1.09800004959106 | 14.3000001907349 | 17.7999992370605 | 3.70000004768372 | 110.199996948242 | 13.7700004577637
2011-01-01 00:00:00 | 14:00:00 | 35.6699981689453 | 24.1100006103516 | 14.25 | 1.08899998664856 | 14.1999998092651 | 19.1000003814697 | 3 | 109.400001525879 | 13.710000038147
2011-01-01 00:00:00 | 14:15:00 | 35.810001373291 | 24.1499996185303 | 14.2799997329712 | 1.07000005245209 | 14.1999998092651 | 19.1000003814697 | 4 | 110.5 | 13.8199996948242
2011-01-01 00:00:00 | 14:30:00 | 35.8800010681152 | 24.1599998474121 | 14.289999961853 | 1.03199994564056 | 14.3000001907349 | 19.2999992370605 | 3 | 111.199996948242 | 13.8800001144409
2011-01-01 00:00:00 | 14:45:00 | 35.7900009155273 | 24.1700000762939 | 14.3000001907349 | 1.01699995994568 | 14.1999998092651 | 20.6000003814697 | 2.70000004768372 | 111.400001525879 | 13.9300003051758
2011-01-01 00:00:00 | 15:00:00 | 35.7900009155273 | 24.1499996185303 | 14.2799997329712 | 0.99099999666214 | 14.1999998092651 | 19.3999996185303 | 3.90000009536743 | 110.599998474121 | 13.8299999237061
2011-01-01 00:00:00 | 15:15:00 | 35.8400001525879 | 24.1299991607666 | 14.2700004577637 | 0.976000010967255 | 14.1999998092651 | 19 | 3.59999990463257 | 109.900001525879 | 13.7299995422363
2011-01-01 00:00:00 | 15:30:00 | 35.8499984741211 | 24.1399993896484 | 14.2799997329712 | 0.952000021934509 | 14.1000003814697 | 18.6000003814697 | 3 | 110.5 | 13.8000001907349
2011-01-01 00:00:00 | 15:45:00 | 35.8600006103516 | 24.1499996185303 | 14.289999961853 | 0.933000028133392 | 14.1000003814697 | 19.8999996185303 | 3.79999995231628 | 110.699996948242 | 13.8299999237061
2011-01-01 00:00:00 | 16:00:00 | 35.8800010681152 | 24.1599998474121 | 14.289999961853 | 0.91100001335144 | 14.1999998092651 | 18.2000007629395 | 2.70000004768372 | 110.800003051758 | 13.8400001525879
2011-01-01 00:00:00 | 16:15:00 | 35.8699989318848 | 24.1700000762939 | 14.3000001907349 | 0.889999985694885 | 14.1999998092651 | 20.2999992370605 | 2.79999995231628 | 110.800003051758 | 13.8400001525879
2011-01-01 00:00:00 | 16:30:00 | 35.8199996948242 | 24.1700000762939 | 14.3000001907349 | 0.878000020980835 | 13.8999996185303 | 20.2999992370605 | 3.09999990463257 | 110.699996948242 | 13.8299999237061
2011-01-01 00:00:00 | 16:45:00 | 35.810001373291 | 24.1900005340576 | 14.3100004196167 | 0.862999975681305 | 13.8999996185303 | 19 | 3.70000004768372 | 110.300003051758 | 13.789999961853
2011-01-01 00:00:00 | 17:00:00 | 35.7999992370605 | 24.2000007629395 | 14.3100004196167 | 0.848999977111816 | 13.8999996185303 | 20.3999996185303 | 2.79999995231628 | 110 | 13.75
2011-01-01 00:00:00 | 17:15:00 | 35.7299995422363 | 24.2099990844727 | 14.3100004196167 | 0.828000009059906 | 13.8000001907349 | 17.1000003814697 | 3 | 109.5 | 13.6999998092651
2011-01-01 00:00:00 | 17:30:00 | 35.7900009155273 | 24.2000007629395 | 14.3100004196167 | 0.816999971866608 | 14 | 18.2999992370605 | 2.90000009536743 | 109.699996948242 | 13.7200002670288
2011-01-01 00:00:00 | 17:45:00 | 35.7799987792969 | 24.2099990844727 | 14.3199996948242 | 0.818000018596649 | 14 | 20.2999992370605 | 2.79999995231628 | 109.800003051758 | 13.7200002670288
2011-01-01 00:00:00 | 18:00:00 | 36.2299995422363 | 24.0799999237061 | 14.25 | 0.809000015258789 | 13.8999996185303 | 18.2000007629395 | 2.5 | 113.400001525879 | 14.0900001525879
2011-01-01 00:00:00 | 18:15:00 | 36.3899993896484 | 24.0300006866455 | 14.2299995422363 | 0.806999981403351 | 14 | 18.3999996185303 | 3.5 | 114.199996948242 | 14.1599998474121
2011-01-01 00:00:00 | 18:30:00 | 36.3600006103516 | 24.0100002288818 | 14.210000038147 | 0.810000002384186 | 13.8999996185303 | 17.2999992370605 | 3.40000009536743 | 114.5 | 14.210000038147
2011-01-01 00:00:00 | 18:45:00 | 36.3499984741211 | 24 | 14.210000038147 | 0.813000023365021 | 13.8999996185303 | 17.2000007629395 | 2.40000009536743 | 114.699996948242 | 14.2399997711182
2011-01-01 00:00:00 | 19:00:00 | 36.2799987792969 | 24.0300006866455 | 14.2299995422363 | 0.824000000953674 | 14 | 17.7000007629395 | 2.40000009536743 | 114.599998474121 | 14.2299995422363
2011-01-01 00:00:00 | 19:15:00 | 36.3600006103516 | 24.0300006866455 | 14.2299995422363 | 0.832000017166138 | 13.8999996185303 | 18.5 | 3.40000009536743 | 114.300003051758 | 14.1700000762939
2011-01-01 00:00:00 | 19:30:00 | 36.1599998474121 | 24.1000003814697 | 14.2600002288818 | 0.848999977111816 | 14 | 18.1000003814697 | 2.70000004768372 | 113.300003051758 | 14.1000003814697
2011-01-01 00:00:00 | 19:45:00 | 35.9700012207031 | 24.1299991607666 | 14.2799997329712 | 0.870999991893768 | 14.1000003814697 | 17.5 | 3.70000004768372 | 111 | 13.8400001525879
2011-01-01 00:00:00 | 20:00:00 | 35.9300003051758 | 24.1399993896484 | 14.2799997329712 | 0.89300000667572 | 13.8000001907349 | 19 | 2.70000004768372 | 110.800003051758 | 13.8299999237061
2011-01-01 00:00:00 | 20:15:00 | 35.9599990844727 | 24.1399993896484 | 14.2799997329712 | 0.907999992370605 | 13.8999996185303 | 18.7000007629395 | 2.90000009536743 | 110.900001525879 | 13.8400001525879
2011-01-01 00:00:00 | 20:30:00 | 36.1199989318848 | 24.1299991607666 | 14.2799997329712 | 0.929000020027161 | 13.8000001907349 | 18.8999996185303 | 2.70000004768372 | 111.5 | 13.8699998855591
2011-01-01 00:00:00 | 20:45:00 | 36.1300010681152 | 24.1399993896484 | 14.289999961853 | 0.953999996185303 | 13.8999996185303 | 18.8999996185303 | 2.79999995231628 | 111.300003051758 | 13.8500003814697
2011-01-01 00:00:00 | 21:00:00 | 36.1199989318848 | 24.1700000762939 | 14.3100004196167 | 0.970000028610229 | 13.8999996185303 | 19.7000007629395 | 2.90000009536743 | 110.699996948242 | 13.7799997329712
2011-01-01 00:00:00 | 21:15:00 | 36.1300010681152 | 24.1599998474121 | 14.3000001907349 | 0.989000022411346 | 13.8000001907349 | 19.1000003814697 | 3.70000004768372 | 110.400001525879 | 13.7399997711182
2011-01-01 00:00:00 | 21:30:00 | 36.0999984741211 | 24.1800003051758 | 14.3100004196167 | 0.995999991893768 | 13.8999996185303 | 19.3999996185303 | 2.79999995231628 | 110.099998474121 | 13.710000038147
2011-01-01 00:00:00 | 21:45:00 | 36.0999984741211 | 24.1700000762939 | 14.3100004196167 | 1.02600002288818 | 13.8000001907349 | 19 | 2.79999995231628 | 110.300003051758 | 13.7200002670288
2011-01-01 00:00:00 | 22:00:00 | 36.0900001525879 | 24.1900005340576 | 14.3199996948242 | 1.05200004577637 | 13.8999996185303 | 19.1000003814697 | 2.90000009536743 | 110 | 13.6899995803833
2011-01-01 00:00:00 | 22:15:00 | 36.1100006103516 | 24.2000007629395 | 14.3299999237061 | 1.05400002002716 | 13.8999996185303 | 19.8999996185303 | 3.79999995231628 | 109.900001525879 | 13.6800003051758
2011-01-01 00:00:00 | 22:30:00 | 36.1399993896484 | 24.1900005340576 | 14.3199996948242 | 1.08599996566772 | 13.8999996185303 | 19.8999996185303 | 2.79999995231628 | 110.099998474121 | 13.6899995803833
2011-01-01 00:00:00 | 22:45:00 | 36.2599983215332 | 24.2000007629395 | 14.3299999237061 | 1.08299994468689 | 13.8999996185303 | 18.3999996185303 | 3.70000004768372 | 110.699996948242 | 13.7399997711182
2011-01-01 00:00:00 | 23:00:00 | 36.2299995422363 | 24.1900005340576 | 14.3299999237061 | 1.08500003814697 | 13.8000001907349 | 19.3999996185303 | 2.59999990463257 | 110.5 | 13.7200002670288
 | [NAME] | Date @ Max | Time @ Max | Min | Date @ Min | Time @ Min
Temp
SpCond
Salinity
Depth
Battery
Chlorophyll
Turbidity+
ODO%
[NAME]