{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calculator","Data & Calculations","Rates","Rebundled Rates","Changelog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,2,52,8],[3,2,3,7],[7,2,7,7],[30,2,31,8],[34,2,35,8],[41,2,42,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[37,2,38,8]]}
[]
[]
[null,null,"SVCE Residential Cost Comparison Calculator",null,null,null,null,null,"Updated 7/3/2017"]
[]
[]
[null,null,{"$f":"IF(ISNUMBER(SEARCH(\"-1\",D9)),\"Enter Your Total Monthly Usage (kWh)\",\"\")","v":"Enter Your Total Monthly Usage (kWh)"},null,"Select Your Billing Month","May-Oct"]
[null,null,"                   Enter usage for one summer (May-Oct) or one winter (Nov-Apr) month",null,"           Select which range of months your bill falls in"]
[null,null,"Additional Rate Options"]
[null,null,"Non-Basic Rate Schedule","Basic Residential (E-1)"]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,3,FALSE)=FALSE,\"\",\"Summer Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,6,FALSE)=FALSE,\"\",\"Winter Peak Usage (kWh)\")","v":""}]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,4,FALSE)=FALSE,\"\",\"Summer Partial Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,7,FALSE)=FALSE,\"\",\"Winter Partial Peak Usage (kWh)\")","v":""}]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,5,FALSE)=FALSE,\"\",\"Summer Off Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$14,8,FALSE)=FALSE,\"\",\"Winter Off Peak Usage (kWh)\")","v":""}]
[]
[null,null,null,null,"Optional Information (Default Values Represent a Typical Customer)"]
[null,null,"Days in Billing Cycle",31,null,"Baseline Territory (click for map)","X"]
[null,null,"Primary Heating Source","Gas",null,"PCIA Vintage (from PG&E Delivery page of your bill)",2017]
[]
[null,null,"                   (usage details can typically be found on the third page of your bill)"]
[null,null,null,null,"SVCE GreenStart","PG&E Service","SVCE GreenPrime"]
[null,null,null,"PG&E Delivery Costs",{"$f":"F20","v":0},{"$f":"IFERROR('Data & Calculations'!B74,0)","v":0},{"$f":"F20","v":0}]
[null,null,null,"Generation Costs",{"$f":"'Data & Calculations'!C75","v":0},{"$f":"'Data & Calculations'!B75","v":0},{"$f":"E21+'Data & Calculations'!I59*'Data & Calculations'!B69","v":0}]
[null,null,null,"Additional PG&E Fees",{"$f":"'Data & Calculations'!C76","v":0},null,{"$f":"E22","v":0}]
[null,null,null,"Total Electric Charges",{"$f":"SUM(E20:E22)","v":0},{"$f":"SUM(F20:F22)","v":0},{"$f":"SUM(G20:G22)","v":0}]
[]
[]
[null,null,"Frequently Asked Questions:"]
[null,null,"Q: I have a CARE (California Affordable Rates for Energy) discount. Will I still receive this with SVCE?"]
[null,null,"A: CARE is a state-mandated program, and you'll receive the same discount as before. To determine applicable CARE discounts, select CARE rates under Advanced Options (above)."]
[]
[null,null,"Q: I have medical equipment at home and am granted a special rate by PG&E (also known as a \"Medical Baseline\" rate). Will I remain eligible for the Medical Baseline rate with SVCE?"]
[null,null,"A: Yes. SVCE customers remain eligible for Medical Baseline rates and will continue to receive applicable discounts after enrollment in SVCE service. Additionally, they are exempt from additional PG&E fees."]
[]
[]
[null,null,"Q: Does SVCE offer special rates for Electric Vehicle owners?"]
[null,null,"A: Silicon Valley Clean Energy's rates mirror those of PG&E, so your rate plan remains the same, but will cost 1% less than PG&E's equivalent generation rate for GreenStart."]
[]
[null,null,"Q: Are SVCE customers exempt from tiered rates - rates that progressively increase as customers use more energy throughout each billing period?"]
[null,null,"A: No. Tiered rates are an important element of utility rate design and are mandated by the California Public Utilities Commission. Tiered rates are intended to promote energy conservation and are assessed through PG&E's delivery charges for all utility customers."]
[]
[]
[null,null,"For more commonly asked questions, please visit our full FAQ.  https://www.svcleanenergy.org/faqs"]
[]
[]
[]
[]
[null,null,"Service Options","Renewable Content\n(% of Total Power Supply)","Emissions Factor \n(lbs. CO2/MWh)*","Estimated Emissions\n(lbs. CO2)","Service Description"]
[null,null,"SVCE GreenStart (50%)",0.5,"<25",{"$f":"CONCATENATE(ROUND(SUM(D$10:G$12,D$6)*25/1000,0),\" lbs.\")","v":"0 lbs."},"Basic SVCE service (default)"]
[null,null,"PG&E Standard (30%)",0.3,405,{"$f":"CONCATENATE(ROUND(SUM(D$10:G$12,D$6)*E48/1000,0),\" lbs.\")","v":"0 lbs."},"Basic PG&E service (opt out)"]
[null,null,"SVCE GreenPrime (100%)",1,0,{"$f":"CONCATENATE(ROUND(SUM(D$10:G$12,D$6)*E49/1000,1),\" lbs.\")","v":"0 lbs."},"Optional 100% renewable SVCE service"]
[null,null,"PG&E Solar Choice (50%)",0.65,202.5,"0 lbs.","Optional 50% solar PG&E service"]
[null,null,"PG&E Solar Choice (100%)",1,0,"0 lbs.","Optional 100% solar PG&E service"]
[null,null,"* As reported to the California Energy Commission’s Power Source Disclosure Program, reflecting PG&E's most currently available emission factor (for CY 2015), as verified by The Climate Registry. PG&E CY 2016 data is subject to an independent audit and verification that will not be completed until October 1, 2017. Silicon Valley Clean Energy’s generation data is forecast for 2017 and may be subject to change. Actual generation data will be reported to the California Energy Commission in 2018."]

{"sheet":"Data & Calculations","index":1,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["Determined Bundled Rate (automated)"]
[{"$f":"Calculator!D9","v":"Basic Residential (E-1)"},{"$f":"Rates!B2","v":"All Usage"},{"$f":"Rates!C2","v":"S Pk"},{"$f":"Rates!D2","v":"S Pt"},{"$f":"Rates!E2","v":"S Off"},{"$f":"Rates!F2","v":"W Pk"},{"$f":"Rates!G2","v":"W Pt"},{"$f":"Rates!H2","v":"W Off"},{"$f":"Rates!I2","v":"Meter Charge"},{"$f":"Rates!J2","v":"Minimum Bill"}]
["Tier 1",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(B$2,Rates!$A$2:$J$2,0),FALSE)","v":0.19979},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(C$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(D$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(E$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(F$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(G$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(H$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"IFERROR(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(I$2,Rates!$A$2:$J$2,0),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(J2,Rates!$A$2:$J$2,0),FALSE),0)","v":0.32854}]
["Tier 2",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(B$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":0.27611999999999998},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(C$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(D$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(E$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(F$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(G$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(H$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false}]
["Tier 3",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(B$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":0.40139000000000002},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(C$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(D$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(E$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(F$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(G$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$16,MATCH(H$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false}]
[]
["Determined Bundled Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge","Total"]
[{"$f":"A3","v":"Tier 1"},{"$f":"B3*C64","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I3*Calculator!D15","v":0}]
[{"$f":"A4","v":"Tier 2"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"A5","v":"Tier 3"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total",{"$f":"SUM(B9:B11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IFERROR(SUM(I9:I11),0)","v":0},{"$f":"SUM(B12:I12)","v":{"$error":"#DIV/0!"}}]
[]
["Determined Generation Rates (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","NEM Bonus"]
["PGE",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(B$15,Rates!$A$2:$J$2,0),FALSE)","v":9.8379999999999995E-2},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(C$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(D$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(E$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(F$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(G$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(H$15,Rates!$A$2:$J$2,0),FALSE)","v":false}]
["SVCE",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(B$15,Rates!$A$2:$J$2,0),FALSE)","v":6.7629999999999996E-2},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(C$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(D$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(E$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(F$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(G$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(H$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"B69","v":8.0000000000000002E-3}]
[]
["Determined Generation Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","NEM Bonus","Total"]
["PGE",{"$f":"B16*B$59","v":0},0,0,0,0,0,0,null,{"$f":"SUM(B21:H21)","v":0}]
["SVCE",0,0,0,0,0,0,0,{"$f":"SUMIF(B59:H59,\"<0\")*I17","v":0},{"$f":"SUM(B22:I22)","v":0}]
[]
["Determined Delivery Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge","Total"]
["PGE",{"$f":"B$12-B21","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I9-I21","v":0},{"$f":"SUM(B26:I26)","v":{"$error":"#DIV/0!"}}]
["SVCE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I26","v":0},{"$error":"#DIV/0!"}]
[]
["Baseline Quantities  (annual update)"]
["Basic (Gas)","Summer","Winter",null,"Electric","Summer","Winter"]
["T",7,8.5,null,"T",8.3000000000000007,14.9]
["X",10.1,10.9,null,"X",9.3000000000000007,16.7]
[]
["Fees (annual update)","PCIA","FF","Total"]
["Pre-2009",0,8.3000000000000001E-4,{"$f":"SUM(B35:C35)","v":8.3000000000000001E-4}]
[2009,2.47E-2,6.2E-4,2.5319999999999999E-2]
[2010,2.8029999999999999E-2,5.9000000000000003E-4,2.862E-2]
[2011,2.9219999999999999E-2,5.8E-4,2.98E-2]
[2012,3.014E-2,5.6999999999999998E-4,3.0710000000000001E-2]
[2013,3.0009999999999998E-2,5.8E-4,3.0589999999999999E-2]
[2014,2.9489999999999999E-2,5.8E-4,3.007E-2]
[2015,2.9090000000000001E-2,5.8E-4,2.9670000000000002E-2]
[2016,2.9190000000000001E-2,5.8E-4,2.9770000000000001E-2]
[2017,2.9190000000000001E-2,5.8E-4,2.9770000000000001E-2]
[]
[]
[]
["Extra Fee Calculations (automated - DO NOT TOUCH; Vintage calculation needs to be updated periodically though)"]
["Vintage:",{"$f":"Calculator!G16","v":2017}]
["Determined Fees:",{"$f":"VLOOKUP(B49,A35:D46,4)","v":2.9770000000000001E-2},"Franchise Only:",{"$f":"VLOOKUP(B49,A35:D42,3)","v":5.8E-4}]
[]
["Delivery Rates (auto updates - DO NOT TOUCH)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge"]
["Tier 1",{"$f":"B3-B$16","v":0.10141},0,0,0,0,0,0,0]
["Tier 2",0.17773999999999998,0,0,0,0,0,0,0]
["High Usage",0.30301,0,0,0,0,0,0,0]
[]
["Total kWh (automated)","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Total"]
["All Usage",{"$f":"IF(B3=FALSE,0,Calculator!D6)","v":0},{"$f":"IF(C3=FALSE,0,Calculator!D10)","v":0},{"$f":"IF(D3=FALSE,0,Calculator!D11)","v":0},{"$f":"IF(E3=FALSE,0,Calculator!D12)","v":0},{"$f":"IF(F3=FALSE,0,Calculator!G10)","v":0},{"$f":"IF(G3=FALSE,0,Calculator!G11)","v":0},{"$f":"IF(H3=FALSE,0,Calculator!G12)","v":0},{"$f":"SUM(B59:H59)","v":0}]
["Pct of Total",{"$f":"B59/$I$59","v":{"$error":"#DIV/0!"}},{"$f":"C59/$I$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Tiering Calculations (auto updates - DO NOT TOUCH)"]
["Calculated Baseline:",{"$f":"IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"T\",Calculator!F6=\"May-Oct\"),B31,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"X\",Calculator!F6=\"May-Oct\"),B32,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"T\",Calculator!F6=\"Nov-Apr\"),C31,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"X\",Calculator!F6=\"Nov-Apr\"),C32,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"T\",Calculator!F6=\"May-Oct\"),F31,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"X\",Calculator!F6=\"May-Oct\"),F32,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"T\",Calculator!F6=\"Nov-Apr\"),G31,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"X\",Calculator!F6=\"Nov-Apr\"),G32,\"ERROR\"))))))))","v":10.1},{"$f":"B58","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Total Tier Allocation"]
["Tier 1",{"$f":"B63*Calculator!D15","v":313.09999999999997},{"$f":"B$60*$J64","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B64,I59)","v":0}]
["Tier 2",{"$f":"B64*3","v":939.3},{"$f":"B$60*$J65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B65,I59-J64)","v":0}]
["High Usage Rate","all above",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX(0,I59-J64-J65)","v":0}]
[]
["Misc Rates"]
["GreenPrime Rate",8.0000000000000002E-3]
["Minimum Bill",{"$f":"J3*Calculator!D15","v":10.18474},"(automated)"]
[]
["Totals (automated)"]
[null,"PG&E","SVCE"]
["Delivery",{"$f":"MAX(B70,J26)","v":{"$error":"#DIV/0!"}},{"$f":"B74","v":{"$error":"#DIV/0!"}}]
["Generation",{"$f":"J21","v":0},{"$f":"J22","v":0}]
["PCIA/FF",0,{"$f":"B50*I59","v":0}]
["Total",{"$f":"SUM(B74:B76)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C74:C76)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Rates","index":2,"n_rows":48,"n_cols":27,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Bundled Rate"]
["Tier 1","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge","Minimum Bill","Tier 2","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off",null,"High Usage","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off"]
["Basic Residential (E-1)",0.19979,false,false,false,false,false,false,null,0.32854,{"$f":"A3","v":"Basic Residential (E-1)"},0.27611999999999998,false,false,false,false,false,false,null,{"$f":"K3","v":"Basic Residential (E-1)"},0.40139000000000002,false,false,false,false,false,false]
["Basic CARE Res. (EL-1)",0.12642999999999999,false,false,false,false,false,false,null,0.16427,{"$f":"A4","v":"Basic CARE Res. (EL-1)"},0.17261000000000001,false,false,false,false,false,false,null,"Basic CARE Res. (EL-1)",0.2397,false,false,false,false,false,false]
["E-TOU-A",{"$f":"L5","v":false},{"$f":"M5+D17","v":0.30506},{"$f":"N5","v":false},{"$f":"O5+D17","v":0.22948000000000002},{"$f":"P5+D17","v":0.18709000000000003},false,{"$f":"R5+D17","v":0.17279},null,{"$f":"J3","v":0.32854},{"$f":"A5","v":"E-TOU-A"},false,0.39335999999999999,false,0.31778000000000001,0.27539000000000002,false,0.26108999999999999,null,"E-TOU-A",false,0.39335999999999999,false,0.31778000000000001,0.27539000000000002,false,0.26108999999999999]
["E-TOU-B",{"$f":"L6","v":false},{"$f":"M6","v":0.36335000000000001},false,0.26029000000000002,0.22588,false,0.20707999999999999,null,{"$f":"J3","v":0.32854},"E-TOU-B",false,0.36335000000000001,false,0.26029000000000002,0.22588,false,0.20707999999999999,null,"E-TOU-B",false,0.36335000000000001,false,0.26029000000000002,0.22588,false,0.20707999999999999]
["EL-TOU-A (CARE)",{"$f":"L7","v":false},{"$f":"M7+D18","v":0.18906000000000001},false,{"$f":"O7+D18","v":0.14144000000000001},{"$f":"P7+D18","v":0.11474000000000001},false,{"$f":"R7+D18","v":0.10572999999999999},null,{"$f":"J4","v":0.16427},"EL-TOU-A (CARE)",false,0.23685,false,0.18923000000000001,0.16253000000000001,false,0.15351999999999999,null,"EL-TOU-A (CARE)",false,0.23685,false,0.18923000000000001,0.16253000000000001,false,0.15351999999999999]
["EL-TOU-B (CARE)",false,0.22162999999999999,false,0.15670000000000001,0.13502,false,0.12317,null,{"$f":"J4","v":0.16427},"EL-TOU-B (CARE)",false,0.22162999999999999,false,0.15670000000000001,0.13502,false,0.12317,null,"EL-TOU-B (CARE)",false,0.22162999999999999,false,0.15670000000000001,0.13502,false,0.12317]
["EV-A",false,0.45389000000000002,0.24986,0.12225,0.32018000000000002,0.19794,0.12503,null,{"$f":"J3","v":0.32854},"EV-A",false,0.45389000000000002,0.24986,0.12225,0.32018000000000002,0.19794,0.12503,null,"EV-A",false,0.45389000000000002,0.24986,0.12225,0.32018000000000002,0.19794,0.12503]
["EV-B",false,0.44738,0.24660000000000001,0.12179,0.31324999999999997,0.19447,0.12453,4.9279999999999997E-2,{"$f":"J3","v":0.32854},"EV-B",false,0.44738,0.24660000000000001,0.12179,0.31324999999999997,0.19447,0.12453,null,"EV-B",false,0.44738,0.24660000000000001,0.12179,0.31324999999999997,0.19447,0.12453]
[]
[{"$f":"\"--- Closed Rates ---\"","v":"--- Closed Rates ---"},null,null,null,null,null,null,null,null,null,{"$f":"A12","v":"--- Closed Rates ---"},null,null,null,null,null,null,null,null,{"$f":"K12","v":"--- Closed Rates ---"}]
["E-6 (Time-of-Use)",false,0.35932999999999998,0.24406,0.16728000000000001,false,0.18845000000000001,0.17161999999999999,0.25297999999999998,{"$f":"J3","v":0.32854},"E-6 (Time-of-Use)",false,0.43565999999999999,0.32039000000000001,0.24362,false,0.26478000000000002,0.24795,null,{"$f":"K13","v":"E-6 (Time-of-Use)"},false,{"$f":"M13","v":0.43565999999999999},{"$f":"N13","v":0.32039000000000001},0.24362,false,0.26478000000000002,0.24795]
["EL-6 (CARE, Time-of-Use)",false,0.24323,0.15873000000000001,0.10245,false,0.11797000000000001,0.10562000000000001,0.20238,{"$f":"J4","v":0.16427},"EL-6 (CARE, Time-of-Use)",false,0.29049000000000003,0.20599000000000001,0.14971000000000001,false,0.16521,0.15287000000000001,null,{"$f":"K14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"M14","v":0.29049000000000003},{"$f":"N14","v":0.20599000000000001},{"$f":"O14","v":0.14971000000000001},false,{"$f":"Q14","v":0.16521},{"$f":"R14","v":0.15287000000000001}]
[]
[]
["Baseline Credit (E-TOU only)",null,null,-8.8300000000000003E-2]
["Baseline Credit (EL-TOU only)",null,null,-4.7789999999999999E-2]
[]
["PG&E Generation Rate","All Usage",{"$f":"C2","v":"S Pk"},"S Pt","S Off","W Pk","W Pt","W Off"]
[{"$f":"A3","v":"Basic Residential (E-1)"},9.8379999999999995E-2,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B21","v":9.8379999999999995E-2},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.18232000000000001,false,0.10674,9.4979999999999995E-2,false,8.0680000000000002E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.20441999999999999,false,0.10136000000000001,9.758E-2,false,7.8780000000000003E-2]
[{"$f":"A7","v":"EL-TOU-A (CARE)"},false,{"$f":"C23","v":0.18232000000000001},false,{"$f":"E23","v":0.10674},{"$f":"F23","v":9.4979999999999995E-2},false,{"$f":"H23","v":8.0680000000000002E-2}]
["EL-TOU-B (CARE)",false,{"$f":"C24","v":0.20441999999999999},false,{"$f":"E24","v":0.10136000000000001},{"$f":"F24","v":9.758E-2},false,{"$f":"H24","v":7.8780000000000003E-2}]
[{"$f":"A9","v":"EV-A"},false,0.23091999999999999,0.11128,5.5930000000000001E-2,8.6290000000000006E-2,5.391E-2,5.7919999999999999E-2]
[{"$f":"A10","v":"EV-B"},false,{"$f":"C27","v":0.23091999999999999},{"$f":"D27","v":0.11128},5.5930000000000001E-2,8.6290000000000006E-2,5.391E-2,5.7919999999999999E-2]
[]
[{"$f":"A12","v":"--- Closed Rates ---"}]
[{"$f":"A13","v":"E-6 (Time-of-Use)"},false,0.21671000000000001,0.11384,7.1849999999999997E-2,false,9.5159999999999995E-2,8.362E-2]
[{"$f":"A14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C31","v":0.21671000000000001},{"$f":"D31","v":0.11384},7.1849999999999997E-2,false,9.5159999999999995E-2,8.362E-2]
[]
[]
[]
["SVCEA Generation Rate","All Usage",{"$f":"C2","v":"S Pk"},{"$f":"D2","v":"S Pt"},"S Off","W Pk","W Pt","W Off"]
[{"$f":"A3","v":"Basic Residential (E-1)"},6.7629999999999996E-2,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B37","v":6.7629999999999996E-2},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.15171999999999999,false,7.689E-2,6.5250000000000002E-2,false,5.1090000000000003E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.17374000000000001,false,7.1709999999999996E-2,6.7979999999999999E-2,false,4.9369999999999997E-2]
[{"$f":"A7","v":"EL-TOU-A (CARE)"},false,{"$f":"C39","v":0.15171999999999999},false,{"$f":"E39","v":7.689E-2},{"$f":"F39","v":6.5250000000000002E-2},false,{"$f":"H39","v":5.1090000000000003E-2}]
["EL-TOU-B (CARE)",false,{"$f":"C40","v":0.17374000000000001},false,{"$f":"E40","v":7.1709999999999996E-2},{"$f":"F40","v":6.7979999999999999E-2},false,{"$f":"H40","v":4.9369999999999997E-2}]
[{"$f":"A9","v":"EV-A"},false,0.19883999999999999,8.0399999999999999E-2,2.5600000000000001E-2,5.5660000000000001E-2,2.3599999999999999E-2,2.7570000000000001E-2]
[{"$f":"A10","v":"EV-B"},false,{"$f":"C43","v":0.19883999999999999},{"$f":"D43","v":8.0399999999999999E-2},{"$f":"E43","v":2.5600000000000001E-2},{"$f":"F43","v":5.5660000000000001E-2},{"$f":"G43","v":2.3599999999999999E-2},{"$f":"H43","v":2.7570000000000001E-2}]
[]
[{"$f":"A12","v":"--- Closed Rates ---"}]
[{"$f":"A13","v":"E-6 (Time-of-Use)"},false,0.18476999999999999,8.2930000000000004E-2,4.1360000000000001E-2,false,6.4439999999999997E-2,5.3010000000000002E-2]
[{"$f":"A14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C47","v":0.18476999999999999},{"$f":"D47","v":8.2930000000000004E-2},{"$f":"E47","v":4.1360000000000001E-2},false,{"$f":"G47","v":6.4439999999999997E-2},{"$f":"H47","v":5.3010000000000002E-2}]

{"sheet":"Rebundled Rates","index":3,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[[42,0,42,13],[43,3,43,6],[43,10,43,13],[20,10,20,13],[20,3,20,6],[26,3,26,6],[26,10,26,13],[34,3,34,6],[34,10,34,13],[1,3,1,6],[0,1,0,6],[0,8,0,13],[1,10,1,13],[6,3,6,6],[6,10,6,13]]}
[null,"Rates for Usage",null,null,null,null,null,null,"Rates for Surplus Generation (Excess NEM Credits at billing date)"]
[{"$f":"Rates!A3","v":"Basic Residential (E-1)"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Up to Baseline",{"$f":"C3-VLOOKUP($A$2,Rates!$A$20:$H$33,2,0)+VLOOKUP($A$2,Rates!$A$36:$H$49,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.19880999999999999},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$18,2,0)","v":0.19979},"MCE's rate is",{"$f":"IF(B3<C3,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C3-B3)","v":9.8000000000000864E-4},"per kWh",null,{"$f":"B3+0.01","v":0.20881},{"$f":"C3","v":0.19979},"MCE's rate is",{"$f":"IF(I3<J3,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J3-I3)","v":9.0200000000000002E-3},"per kWh"]
["100%-200% of Baseline",{"$f":"C4-VLOOKUP($A$2,Rates!$A$20:$H$33,2,0)+VLOOKUP($A$2,Rates!$A$36:$H$49,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.27514},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$18,12,0)","v":0.27611999999999998},"MCE's rate is",{"$f":"IF(B4<C4,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C4-B4)","v":9.7999999999998089E-4},"per kWh",null,{"$f":"B4+0.01","v":0.28514},{"$f":"C4","v":0.27611999999999998},"MCE's rate is",{"$f":"IF(I4<J4,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J4-I4)","v":9.020000000000028E-3},"per kWh"]
["Over 200% of Baseline",{"$f":"C5-VLOOKUP($A$2,Rates!$A$20:$H$33,2,0)+VLOOKUP($A$2,Rates!$A$36:$H$49,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.40040999999999999},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$18,21,0)","v":0.40139000000000002},"MCE's rate is","lower by",9.800000000000364E-4,"per kWh",null,0.41041,0.40139000000000002,"MCE's rate is","higher by",9.0199999999999725E-3,"per kWh"]
[]
[{"$f":"Rates!A5","v":"E-TOU-A"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Summer Peak"]
["… up to Baseline",{"$f":"C9-VLOOKUP($A$7,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.30423},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,3,0)","v":0.30506},"MCE's rate is",{"$f":"IF(B9<C9,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C9-B9)","v":8.2999999999999741E-4},"per kWh",null,{"$f":"B9+0.01","v":0.31423000000000001},{"$f":"C9","v":0.30506},"MCE's rate is",{"$f":"IF(I9<J9,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J9-I9)","v":9.1700000000000115E-3},"per kWh"]
["… above Baseline",{"$f":"C10-VLOOKUP($A$7,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.39252999999999999},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,13,0)","v":0.39335999999999999},"MCE's rate is","lower by",8.2999999999999741E-4,"per kWh",null,{"$f":"B10+0.01","v":0.40253},{"$f":"C10","v":0.39335999999999999},"MCE's rate is","higher by",9.1700000000000115E-3,"per kWh"]
["Summer Off Peak"]
["… up to Baseline",{"$f":"C12-VLOOKUP($A$7,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.22940000000000002},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,5,0)","v":0.22948000000000002},"MCE's rate is",{"$f":"IF(B12<C12,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C12-B12)","v":7.999999999999674E-5},"per kWh",null,{"$f":"B12+0.01","v":0.23940000000000003},{"$f":"C12","v":0.22948000000000002},"MCE's rate is","higher by",9.9200000000000121E-3,"per kWh"]
["… above Baseline",{"$f":"C13-VLOOKUP($A$7,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.31770000000000004},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,15,0)","v":0.31778000000000001},"MCE's rate is","lower by",7.9999999999968985E-5,"per kWh",null,{"$f":"B13+0.01","v":0.32770000000000005},{"$f":"C13","v":0.31778000000000001},"MCE's rate is","higher by",9.9200000000000399E-3,"per kWh"]
["Winter Peak"]
["… up to Baseline",{"$f":"C15-VLOOKUP($A$7,Rates!$A$20:$H$33,6,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.18713000000000005},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,6,0)","v":0.18709000000000003},"MCE's rate is","higher by",4.0000000000012248E-5,"per kWh",null,{"$f":"B15+0.01","v":0.19713000000000006},{"$f":"C15","v":0.18709000000000003},"MCE's rate is","higher by",1.0040000000000021E-2,"per kWh"]
["… above Baseline",{"$f":"C16-VLOOKUP($A$7,Rates!$A$20:$H$33,6,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.27543000000000001},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,16,0)","v":0.27539000000000002},"MCE's rate is","higher by",3.9999999999984492E-5,"per kWh",null,{"$f":"B16+0.01","v":0.28543000000000002},{"$f":"C16","v":0.27539000000000002},"MCE's rate is","higher by",1.0039999999999993E-2,"per kWh"]
["Winter Off Peak"]
["… up to Baseline",{"$f":"C18-VLOOKUP($A$7,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.17296999999999998},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,8,0)","v":0.17279},"MCE's rate is","higher by",1.7999999999998573E-4,"per kWh",null,{"$f":"B18+0.01","v":0.18296999999999999},{"$f":"C18","v":0.17279},"MCE's rate is","higher by",1.0179999999999995E-2,"per kWh"]
["… above Baseline",{"$f":"C19-VLOOKUP($A$7,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$7,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.26127},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$18,18,0)","v":0.26108999999999999},"MCE's rate is","higher by",1.8000000000001348E-4,"per kWh",null,{"$f":"B19+0.01","v":0.27127000000000001},{"$f":"C19","v":0.26108999999999999},"MCE's rate is","higher by",1.0180000000000022E-2,"per kWh"]
[]
[{"$f":"Rates!A6","v":"E-TOU-B"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C22-VLOOKUP($A$21,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$21,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.36244000000000004},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$18,3,0)","v":0.36335000000000001},"MCE's rate is",{"$f":"IF(B22<C22,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C22-B22)","v":9.0999999999996639E-4},"per kWh",null,{"$f":"B22+0.01","v":0.37244000000000005},{"$f":"C22","v":0.36335000000000001},"MCE's rate is",{"$f":"IF(I22<J22,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J22-I22)","v":9.0900000000000425E-3},"per kWh"]
["Summer Off Peak",{"$f":"C23-VLOOKUP($A$21,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$21,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.26041000000000003},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$18,5,0)","v":0.26029000000000002},"MCE's rate is",{"$f":"IF(B23<C23,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(C23-B23)","v":1.2000000000000899E-4},"per kWh",null,{"$f":"B23+0.01","v":0.27041000000000004},{"$f":"C23","v":0.26029000000000002},"MCE's rate is",{"$f":"IF(I23<J23,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J23-I23)","v":1.0120000000000018E-2},"per kWh"]
["Winter Peak",{"$f":"C24-VLOOKUP($A$21,Rates!$A$20:$H$33,6,0)+VLOOKUP($A$21,Rates!$A$36:$H$49,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.22605},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$18,6,0)","v":0.22588},"MCE's rate is","higher by",1.7000000000000348E-4,"per kWh",null,{"$f":"B24+0.01","v":0.23605000000000001},{"$f":"C24","v":0.22588},"MCE's rate is","higher by",1.0170000000000012E-2,"per kWh"]
["Winter Off Peak",{"$f":"C25-VLOOKUP($A$21,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$21,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.20743999999999996},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$18,8,0)","v":0.20707999999999999},"MCE's rate is","higher by",3.5999999999997145E-4,"per kWh",null,{"$f":"B25+0.01","v":0.21743999999999997},{"$f":"C25","v":0.20707999999999999},"MCE's rate is","higher by",1.035999999999998E-2,"per kWh"]
[]
[{"$f":"Rates!A9","v":"EV-A"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C28-VLOOKUP($A$27,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.45158000000000004},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,3,0)","v":0.45389000000000002},"MCE's rate is",{"$f":"IF(B28<C28,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C28-B28)","v":2.3099999999999787E-3},"per kWh",null,{"$f":"B28+0.01","v":0.46158000000000005},{"$f":"C28","v":0.45389000000000002},"MCE's rate is",{"$f":"IF(I28<J28,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J28-I28)","v":7.6900000000000301E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C29-VLOOKUP($A$27,Rates!$A$20:$H$33,4,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.24874999999999997},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,4,0)","v":0.24986},"MCE's rate is",{"$f":"IF(B29<C29,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C29-B29)","v":1.1100000000000276E-3},"per kWh",null,{"$f":"B29+0.01","v":0.25874999999999998},{"$f":"C29","v":0.24986},"MCE's rate is",{"$f":"IF(I29<J29,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J29-I29)","v":8.8899999999999813E-3},"per kWh"]
["Summer Off Peak",{"$f":"C30-VLOOKUP($A$27,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.12168999999999999},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,5,0)","v":0.12225},"MCE's rate is","lower by",5.6000000000000494E-4,"per kWh",null,{"$f":"B30+0.01","v":0.13169},{"$f":"C30","v":0.12225},"MCE's rate is","higher by",9.4400000000000039E-3,"per kWh"]
["Winter Peak",{"$f":"C31-VLOOKUP($A$27,Rates!$A$20:$H$33,6,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.31932000000000005},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,6,0)","v":0.32018000000000002},"MCE's rate is","lower by",8.599999999999719E-4,"per kWh",null,{"$f":"B31+0.01","v":0.32932000000000006},{"$f":"C31","v":0.32018000000000002},"MCE's rate is","higher by",9.140000000000037E-3,"per kWh"]
["Winter Partial Peak",{"$f":"C32-VLOOKUP($A$27,Rates!$A$20:$H$33,7,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.19739999999999999},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,7,0)","v":0.19794},"MCE's rate is",{"$f":"IF(B32<C32,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C32-B32)","v":5.4000000000001269E-4},"per kWh",null,{"$f":"B32+0.01","v":0.2074},{"$f":"C32","v":0.19794},"MCE's rate is",{"$f":"IF(I32<J32,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J32-I32)","v":9.4599999999999962E-3},"per kWh"]
["Winter Off Peak",{"$f":"C33-VLOOKUP($A$27,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$27,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.12445000000000001},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$18,8,0)","v":0.12503},"MCE's rate is","lower by",5.7999999999999718E-4,"per kWh",null,0.13445000000000001,0.12503,"MCE's rate is","higher by",9.4200000000000117E-3,"per kWh"]
[]
[{"$f":"Rates!A10","v":"EV-B"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C36-VLOOKUP($A$35,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.44507000000000002},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,3,0)","v":0.44738},"MCE's rate is",{"$f":"IF(B36<C36,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C36-B36)","v":2.3099999999999787E-3},"per kWh",null,{"$f":"B36+0.01","v":0.45507000000000003},{"$f":"C36","v":0.44738},"MCE's rate is",{"$f":"IF(I36<J36,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J36-I36)","v":7.6900000000000301E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C37-VLOOKUP($A$35,Rates!$A$20:$H$33,4,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.24548999999999999},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,4,0)","v":0.24660000000000001},"MCE's rate is",{"$f":"IF(B37<C37,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C37-B37)","v":1.1100000000000276E-3},"per kWh",null,{"$f":"B37+0.01","v":0.25548999999999999},{"$f":"C37","v":0.24660000000000001},"MCE's rate is",{"$f":"IF(I37<J37,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J37-I37)","v":8.8899999999999813E-3},"per kWh"]
["Summer Off Peak",{"$f":"C38-VLOOKUP($A$35,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.12123},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,5,0)","v":0.12179},"MCE's rate is","lower by",5.5999999999999106E-4,"per kWh",null,{"$f":"B38+0.01","v":0.13123000000000001},{"$f":"C38","v":0.12179},"MCE's rate is","higher by",9.4400000000000178E-3,"per kWh"]
["Winter Peak",{"$f":"C39-VLOOKUP($A$35,Rates!$A$20:$H$33,6,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.31239},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,6,0)","v":0.31324999999999997},"MCE's rate is","lower by",8.599999999999719E-4,"per kWh",null,{"$f":"B39+0.01","v":0.32239000000000001},{"$f":"C39","v":0.31324999999999997},"MCE's rate is","higher by",9.140000000000037E-3,"per kWh"]
["Winter Partial Peak",{"$f":"C40-VLOOKUP($A$35,Rates!$A$20:$H$33,7,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.19393000000000002},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,7,0)","v":0.19447},"MCE's rate is","lower by",5.3999999999998494E-4,"per kWh",null,{"$f":"B40+0.01","v":0.20393000000000003},{"$f":"C40","v":0.19447},"MCE's rate is","higher by",9.4600000000000239E-3,"per kWh"]
["Winter Off Peak",{"$f":"C41-VLOOKUP($A$35,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$35,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.12395},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$18,8,0)","v":0.12453},"MCE's rate is","lower by",5.7999999999999718E-4,"per kWh",null,0.13395000000000001,0.12453,"MCE's rate is","higher by",9.4200000000000117E-3,"per kWh"]
[]
[" -----  Closed to New Customers (ignores tiering, which is competitively irrelevant) -----"]
[{"$f":"Rates!A13","v":"E-6 (Time-of-Use)"},"MCE Rebundled","PG&E Bundled","Result",null,null,null,null,"MCE Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C45-VLOOKUP($A$44,Rates!$A$20:$H$33,3,0)+VLOOKUP($A$44,Rates!$A$36:$H$49,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.35715999999999998},{"$f":"VLOOKUP(A$44,Rates!$A$2:$AB$18,3,0)","v":0.35932999999999998},"MCE's rate is",{"$f":"IF(B45<C45,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C45-B45)","v":2.1700000000000053E-3},"per kWh",null,{"$f":"B45+0.01","v":0.36715999999999999},{"$f":"C45","v":0.35932999999999998},"MCE's rate is",{"$f":"IF(I45<J45,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J45-I45)","v":7.8300000000000036E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C46-VLOOKUP($A$44,Rates!$A$20:$H$33,4,0)+VLOOKUP($A$44,Rates!$A$36:$H$49,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.24292},{"$f":"VLOOKUP(A$44,Rates!$A$2:$AB$18,4,0)","v":0.24406},"MCE's rate is",{"$f":"IF(B46<C46,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C46-B46)","v":1.1400000000000021E-3},"per kWh",null,{"$f":"B46+0.01","v":0.25291999999999998},{"$f":"C46","v":0.24406},"MCE's rate is",{"$f":"IF(I46<J46,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J46-I46)","v":8.859999999999979E-3},"per kWh"]
["Summer Off Peak",{"$f":"C47-VLOOKUP($A$44,Rates!$A$20:$H$33,5,0)+VLOOKUP($A$44,Rates!$A$36:$H$49,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.16656000000000001},{"$f":"VLOOKUP(A$44,Rates!$A$2:$AB$18,5,0)","v":0.16728000000000001},"MCE's rate is","lower by",7.1999999999999842E-4,"per kWh",null,{"$f":"B47+0.01","v":0.17656000000000002},{"$f":"C47","v":0.16728000000000001},"MCE's rate is","higher by",9.2800000000000105E-3,"per kWh"]
["Winter Partial Peak",{"$f":"C48-VLOOKUP($A$44,Rates!$A$20:$H$33,7,0)+VLOOKUP($A$44,Rates!$A$36:$H$49,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.1875},{"$f":"VLOOKUP(A$44,Rates!$A$2:$AB$18,7,0)","v":0.18845000000000001},"MCE's rate is","lower by",9.5000000000000639E-4,"per kWh",null,{"$f":"B48+0.01","v":0.19750000000000001},{"$f":"C48","v":0.18845000000000001},"MCE's rate is","higher by",9.0500000000000025E-3,"per kWh"]
["Winter Off Peak",{"$f":"C49-VLOOKUP($A$44,Rates!$A$20:$H$33,8,0)+VLOOKUP($A$44,Rates!$A$36:$H$49,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$35:$A$46),'Data & Calculations'!$A$35:$D$46,4,0)","v":0.17077999999999999},{"$f":"VLOOKUP(A$44,Rates!$A$2:$AB$18,8,0)","v":0.17161999999999999},"MCE's rate is","lower by",8.4000000000000741E-4,"per kWh",null,0.18078,0.17161999999999999,"MCE's rate is","higher by",9.1600000000000015E-3,"per kWh"]
[]
["Note: Rebundled rates assume the most current PCIA vintage. Other vintages may result in small adjustments to the above rates."]

{"sheet":"Changelog","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Date","Change"]
["2016-04-29","Beta version completed, to staff for review."]
["2016-05-04","Cosmetic Changes"]
[null,"Corrected EV rate description"]
[null,"Hid and locked cell editing for public use to restrict potentially breaking calculations"]
["2016-05-23","Replaced IFNA command with IFERROR; IFNA is not well supported in Excel. May need to replace with IF(ISERROR()) later."]
["2016-11-15","Rebundled Rates Added"]
["2017-01-03","Updated for PG&E AET"]
["2017-03-01","Changes for PG&E 3/1 change (tiers, etc)"]
[null,"Updated Local Sol implementation date"]
[null,"Added MCE 4/1 Rates"]