Spreadsheet: 215981d1361553104-conditional-if-formula-question-test_ms-worked
Sheet: Sheet1

Current Inh. Oil Factor: |  | 0.0119 | Current Chemical Mixture Ratio:
Desired Inh. Oil Factor: |  | 0.019
Desired ppm: |  | 100 | Current ppm: |  | 100 | Total Gals/day Saved:
Chemical Mixture Ratio:
WMTS1
Well | DATE | SYS. | Oil | Water | T.F. | Inh. Oil | Inh. Oil Actual | Gal Chemical | T.F. Factor | [NAME] | New Inh. Oil Rate | New Actual Inh. Oil Rate | New Gals Chemical | Gals Chemical Saved | New ppm |  | Worked on
WM 7-5 | 2013-02-08 00:00:00 | ELPS | 3 | 767
WM 7-13 | 2013-02-17 00:00:00 | HP | 90 | 116 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For example, if
WM 7-14 | 2013-02-17 00:00:00 | HP | 116 | 62
WM 12-9 | 2013-02-13 00:00:00 | HP | 82 | 62 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inh. Oil |  | Inh. Oil Actual
WM 12-10 | 2013-02-15 00:00:00 | HP | 97 | 355 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.2 | =
WM 13-1 | 2013-02-16 00:00:00 | HP | 31 | 72 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.7 | = | 2
WM 13-2 | 2013-02-14 00:00:00 | HP | 37 | 141 |  |  | 2
WM 18-1 | 2013-02-16 00:00:00 | HP | 99 | 102
WM 7-13#2 | 2013-02-12 00:00:00 | HP | 82 | 693
WM 18-5 | 2013-02-11 00:00:00 | HP | 136 | 70
WM 18-10 | 2013-02-15 00:00:00 | HP | 131 | 64
WM 18-10A | 2013-02-12 00:00:00 | HP | 72 | 46 |  |  | 2
WM 18-14 | 2013-02-16 00:00:00 | HP | 83 | 75 |  |  | 2
WM 19-4 | 2013-02-16 00:00:00 | HP | 14 | 35 |  |  | 2 |  |  |  |  | 2
WM 19-6 | 2013-02-17 00:00:00 | HP | 38 | 72 |  |  | 2
WM 13-7 | 2013-02-17 00:00:00 | HP | 48 | 55 |  |  | 2
WM 18-14#2 | 2013-02-14 00:00:00 | HP | 83 | 509
WM 7-10 | 2013-02-13 00:00:00 | HP | 108 | 129
 |  |  |  |  |  |  |  |  |  |  |  |  | Test Site Saved:
WMTS2
Well | DATE | SYS. | Oil | Water | T.F. | Inh. Oil | Inh. Oil Actual | Gal Chemical | T.F. Factor | [NAME] | New Inh. Oil Rate | New Actual Inh. Oil Rate | New Gals Chemical | Gals Chemical Saved | New ppm
WM 17-5 | 2013-02-04 00:00:00 | HP | 45 | 36 |  |  | 2 |  |  |  |  | 2
WM 17-10 | 2013-02-08 00:00:00 | HP | 44 | 76 |  |  | 2
WM 17-13 | 2013-02-17 00:00:00 | HP | 93 | 55 |  |  | 2
WM 17-14 | 2013-02-06 00:00:00 | HP | 55 | 58 |  |  | 2
WM 18-9 | 2013-02-15 00:00:00 | HP | 47 | 48 |  |  | 2 |  |  |  |  | 2
WM 20-1 | 2013-02-16 00:00:00 | HP | 93 | 87
WM 20-2 | 2013-02-10 00:00:00 | HP | 92 | 72 |  |  | 2
WM 19-1 | 2013-02-10 00:00:00 | HP | 25 | 85 |  |  | 2
WM 19-8 | 2013-02-12 00:00:00 | HP | 41 | 29 |  |  | 2 |  |  |  |  | 2
WM 19-10 | 2013-02-09 00:00:00 | HP | 58 | 50 |  |  | 2
WM 20-5 | 2013-02-14 00:00:00 | HP | 40 | 38 |  |  | 2 |  |  |  |  | 2
WM17-13#2 | 2013-02-07 00:00:00 | HP | 119 | 1093
 |  |  |  |  |  |  |  |  |  |  |  |  | Test Site Saved:
Old TS
Well | DATE | SYS. | Oil | Water | T.F. | Inh. Oil | Inh. Oil Actual | Gal Chemical | T.F. Factor | [NAME] | New Inh. Oil Rate | New Actual Inh. Oil Rate | New Gals Chemical | Gals Chemical Saved | New ppm
7-1 | 2013-02-08 00:00:00 | HP | 64 | 196 |  |  | 3.1
8-13 | 02/0813 | HP | 30 | 50 |  |  | 2 |  |  |  |  | 2
17-2B | 2013-02-07 00:00:00 | HP | 43 | 74 |  |  | 2
17-6 | 2013-02-12 00:00:00 | HP | 6 | 53 |  |  | 2 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Test Site Saved:
EMTS1
Well | DATE | SYS. | Oil | Water | T.F. | Inh. Oil | Inh. Oil Actual | Gal Chemical | T.F. Factor | [NAME] | New Inh. Oil Rate | New Actual Inh. Oil Rate | New Gals Chemical | Gals Chemical Saved | New ppm
EM 9-16 | 2013-02-17 00:00:00 | ELPS | 51 | 81 |  |  | 2
EM 15-14 | 2013-02-11 00:00:00 | HP | 43 | 301
EM 22-2 | 2013-02-09 00:00:00 | HP | 28 | 124 |  |  | 2
EM 22-8 | 2013-02-14 00:00:00 | HP | 32 | 48 |  |  | 2 |  |  |  |  | 2
EM 21-7 | 2013-02-12 00:00:00 | HP | 81 | 275
EM 16-10 | 2012-02-06 00:00:00 | HP | 49 | 287
EM 23-4 | 2012-02-13 00:00:00 | HP | 39 | 201
EM 21-1 | 2013-02-10 00:00:00 | HP | 69 | 105 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Test Site Saved:
EMTS2
Well | DATE | SYS. | Oil | Water | T.F. | Inh. Oil | Inh. Oil Actual | Gal Chemical | T.F. Factor | [NAME] | New Inh. Oil Rate | New Actual Inh. Oil Rate | New Gals Chemical | Gals Chemical Saved | New ppm
EM 10-9 | 2013-02-07 00:00:00 | HP | 27 | 68 |  |  | 2 |  |  |  |  | 2
EM 14-4 | 2013-02-06 00:00:00 | LP | 47 | 158
 |  |  |  |  |  |  |  |  |  |  |  |  | Test Site Saved: