Spreadsheet: 188887d1351017303-calculating-value-between-two-points-solar2
Sheet: Sept

 |  | Service Dates: |  | 2011-09-01 00:00:00 |  |  | thru | 2011-10-01 00:00:00 |  |  |  |  |  | PG&E RATES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | PG&E RATES |  |  |  |  |  |  |  |  |  |  |  |  | Baseline |  | 1.01 | 1.3 | 131-200% |  | 201-300% |  | 301%+
 | T1 |  | T2 |  | T3 |  | T4 |  | T5 |  |  |  |  | 1083.078
 | Baseline |  | 1.01 | 1.3 | 131-200% |  | 201-300% |  | 301%+ |  |  |  |  | 0.12845 |  | 0.14602 |  | 0.29561 |  | 0.33561 |  | 0.33561
 | 1083.078 |  | 1083.078 | 1408.0014 | 1408.0014 | 2166.156 | 2166.156 | 3249.234 | 3249.234 |  |  |  | Cost: | 139.1213691 |  | 139.2398
 | 0.12845 |  | 0.14602 |  | 0.29561 |  | 0.33561 |  | 0.33561 |  |  |  | Consumed: | 1084 | --change this number to see it work.
 | 2004.66 |  | 0 | 0 |  | 596.6585999999998 |  | 0
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5 |  | I am attempting to calculate the value between two points. I have an electric usage baseline and I want to setup a spreadsheet
 | 257.498577 |  | 0 |  | 89.25415997399995 |  | 0 |  | 0 |  | to calculate the values for the tier one and tier two rates. I have the values for each tier and I would like to be able to take the baseline,
 | 2004.67107824056 |  |  |  | 592.6004987 |  |  |  |  |  | extrapolate the value that belongs in the tier one range and use the amount that is higher than tier one to extrapolate the value for tier two and so on.
 |  |  |  |  |  |  |  |  |  |  |  | 324.9234000000001
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 2004.66 |  |  | 1462 |  |  |  | 542.66
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings |  |  | If you look on the September page you will find the section that has the "PG&E Rates" and below the "Rate Charges" We are attempting
 |  |  |  | Billed |  | Min |  |  |  |  | to calculate the charges per tier. As you can see T1, T2 etc have percentages attached to them along with usage amounts above the baseline.
 | 346.752736974 |  |  | 202.95 |  | 4.58 |  | 139.222736974
 |  |  |  |  | 207.53
 | Date | Solar | Date | Solar | Date | Solar
 | 2012-09-01 00:00:00 | 19.53 | 2012-09-12 00:00:00 | 17.9 | 2012-09-22 00:00:00 | 12.32 |  | Solar | 542.66
 | 2012-09-02 00:00:00 | 19.11 | 2012-09-13 00:00:00 | 18.52 | 2012-09-23 00:00:00 | 17.75
 | 2012-09-03 00:00:00 | 18.89 | 2012-09-14 00:00:00 | 18.1 | 2012-09-24 00:00:00 | 17.9
 | 2012-09-04 00:00:00 | 19.97 | 2012-09-15 00:00:00 | 18.72 | 2012-09-25 00:00:00 | 18.62 | [NAME] |  | 0.9196118733941944
 | 2012-09-05 00:00:00 | 6.63 | 2012-09-16 00:00:00 | 18.95 | 2012-09-26 00:00:00 | 17.7 | Estimate |  | 590.0967741935484
 | 2012-09-06 00:00:00 | 11 | 2012-09-17 00:00:00 | 18.5 | 2012-09-27 00:00:00 | 17.34 | Actual |  | 542.66
 | 2012-09-07 00:00:00 | 17.84 | 2012-09-18 00:00:00 | 19.17 | 2012-09-28 00:00:00 | 17.61 | Estimate
 | 2012-09-08 00:00:00 | 17.93 | 2012-09-19 00:00:00 | 19 | 2012-09-29 00:00:00 | 18.72 |  |  | Sep | Oct
 | 2012-09-09 00:00:00 | 18.3 | 2012-09-20 00:00:00 | 18.8 | 2012-09-30 00:00:00 | 18.2 | Proposed Prod |  | 573 | 530
 | 2012-09-10 00:00:00 | 17.2 | 2012-09-21 00:00:00 | 16.65 | 2012-10-01 00:00:00 | 18.06 | Days |  | 30 | 31
 | 2012-09-11 00:00:00 | 17.73 |  |  |  |  | Per Day |  | 19.1 | 17.09677419354839
 |  |  |  |  |  |  | Billed Days |  | 30 | 1
 | 921.5819999999999 |  |  |  |  |  | Total |  | 573 | 17.09677419354839
 |  |  |  |  |  |  |  | T2 | 921.5819999999999
 |  |  |  |  |  |  |  |  | 0.01757
 |  |  |  |  |  |  |  | T3 | 596.6585999999998
 |  |  |  |  |  |  |  |  | 0.14959
 |  |  |  |  |  |  |  | T4 | -161.4960000000001
 |  |  |  |  |  |  |  |  | 0.04000000000000004