Spreadsheet: 102505d1300435176-match-previous-occurrence-of-text-in-column-use-offset-to-get-input-variable-trackingtest
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Omega Distillation Summary
 |  |  |  |  |  |  |  |  |  | Specific Gravity 0.8 |  |  | Specific Gravity 1.0 |  |  | Specific Gravity 1.0
Batch | Days to fill @ 7d/wk | Drums of Waste |  |  |  |  |  | Total |  | Pounds Processed |  |  |  |  |  |  |  |  | Total | Out | Total |  | Total Discharge Cycles
 |  | Date | # |  | Date | # |  | # |  | Water Drum |  |  | Solvent Drum |  |  | Sludge Drum |  |  |  |  | Run |  | Output 1 | Output 2
 |  | Filled |  |  | M/T'd |  |  |  |  | # | Gal / % |  | # | Gal / % |  | # | Gal / % |  | # / Diff | Gal | Hrs |  | # / cycle | # / cycle
1 | 12 | 2011-01-04 00:00:00 | 397 |  | 01.05 | 37 |  | 360 | 1 | 22.5 | 2.8125 |  | 327.5 | 51.171875 |  | 9.98 | 1.2475 |  | 359.98 | 55.231875 | 7.5 |  | 76 | 928
 |  | --- | 0 |  | --- | 0 |  |  | 2 |  | 0.05092168245238823 |  |  | 0.9264917223976191 |  |  | 0.02258659514999265 |  | -0.01999999999998181 |  |  |  | 0.2960526315789473 | 0.3529094827586207
2 | 80 | 2011-01-21 00:00:00 | 480.5 |  | 01.27 | 101.5 |  | 379 | 3 | 0 | 0 |  | 370 | 57.8125 |  | 13.5 | 1.6875 |  | 383.5 | 59.5 | 9 |  | 0 | 1052
 | Mits | --- | 0 |  | --- | 0 |  |  | 4 |  | 0 |  |  | 0.9716386554621849 |  |  | 0.02836134453781513 |  | 4.5 |  |  |  |  | 0.3517110266159696
3 | 20 | 2011-01-24 00:00:00 | 407.5 |  | 02.01 | 36 |  | 371.5 | 5 | 17.5 | 2.1875 |  | 343 | 53.59375 |  | 10.43 | 1.30375 |  | 370.93 | 57.085 | 12 |  | 46 | 970
 |  | --- | 0 |  | --- | 0 |  |  | 6 |  | 0.03832004904966278 |  |  | 0.9388412017167381 |  |  | 0.02283874923359902 |  | -0.5699999999999932 |  |  |  | 0.3804347826086957 | 0.3536082474226804
4 | 11 | 2011-02-04 00:00:00 | 433.5 |  | 02.04 | 42 |  | 391.5 | 7 | 54 | 6.75 |  | 328.5 | 51.328125 |  | 11.7 | 1.4625 |  | 394.2 | 59.540625 | 6.5 |  | 123 | 910
 |  | --- | 0 |  | --- | 0 |  |  | 8 |  | 0.1133679735474729 |  |  | 0.8620689655172414 |  |  | 0.02456306093528578 |  | 2.699999999999989 |  |  |  | 0.4390243902439024 | 0.360989010989011
5 | 10 | 2011-02-14 00:00:00 | 417 |  | 02.15 | 37 |  | 380 | 9 | 69.5 | 8.6875 |  | 297 | 46.40625 |  | 12.24 | 1.53 |  | 378.74 | 56.62375 | 7 |  | 155 | 838
 | Mits | --- | 0 |  | --- | 0 |  |  | 10 |  | 0.1534250204198768 |  |  | 0.8195545155522197 |  |  | 0.02702046402790349 |  | -1.259999999999991 |  |  |  | 0.4483870967741935 | 0.3544152744630071
6 | 24 | 2011-02-28 00:00:00 | 425 |  | 03.02 | 36.5 |  | 388.5 | 11 | 61 | 7.625 |  | 313.5 | 48.984375 |  | 13.63 | 1.70375 |  | 388.13 | 58.313125 | 9 |  | 150 | 952
 |  | --- | 0 |  | --- | 0 |  |  | 12 |  | 0.130759584570369 |  |  | 0.8400231508772681 |  |  | 0.02921726455236278 |  | -0.3700000000000045 |  |  |  | 0.4066666666666667 | 0.3293067226890756
7 | 8 | 2011-03-08 00:00:00 | 433.5 |  | 03.14 | 37 |  | 396.5 | 13 | 82 | 10.25 |  | 306.5 | 47.890625 |  | 9.98 | 1.2475 |  | 398.48 | 59.388125 | 11.5 |  | 186 | 1124
 |  | --- | 0 |  | --- | 0 |  |  | 14 |  | 0.1725934267161996 |  |  | 0.8064006903737069 |  |  | 0.02100588291009356 |  | 1.980000000000018 |  |  |  | 0.4408602150537634 | 0.2726868327402135
8 | 9 | 2011-03-17 00:00:00 | 424 |  | 03.20 | 37.5 |  | 763.5 | 15
 | ? | 2011-03-19 00:00:00 | 414 |  | 03.20 | 37 |  |  | 16
9 |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 18
10 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 20
11 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 22
12 |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | 24
13 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  | 26
14 |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  | 28
15 |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  | 30
16 |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  | 32
17 |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  | 34
18 |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  | 36
19 |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  | 38
20 |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  | 40
21 |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  | 42
22 |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  | 44
23 |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  | 46
24 |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Averages as
 |  |  |  |  |  |  |  |  | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03.03.11
 |  |  |  |  |  |  |  | 3430.5 | 49 | 306.5 | 38.3125 |  | 2286 | 357.1875 |  | 81.46000000000001 | 10.1825 |  | 2673.96 | 405.6825 | 62.5 |  | 6.430468754469785 | 5.43000365183675 | Oz. / cycle | 6.3058 | 5.6078
 |  | Totals |  | as of |  |  |  | # | 50 | # | Gal |  | # | Gal |  | # | Gal |  | # | Gal | Hrs |  | 0.4019042971543615 | 0.3393752282397969 | #   / cycle | 0.394113 | 0.35049
 | 2011-03-18 00:00:00 |  |  |  |  | Total Waste In |  |  | 51 | Total Water Out |  |  | Total Solvent Out |  |  | Total Sludge Out |  |  | Output Total |  |  |  | Average