{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","Data & Calculations","Rates","Changelog"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,2,3,7],[7,2,7,7]]}
[]
[]
[null,null,"Residential Cost Comparison Calculator",null,null,null,null,null,null,null,"Updated 11/2/2016"]
[]
[]
[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","Nov-Apr"]
[null,null,"                   (usage details can typically be found on the third page of your bill)",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,"Date of Enrollment in PCEA","mm/dd/yyyy"]
[]
[]
[null,null,null,null,"PCE EcoPlus","PCE Eco100","PG&E Standard","PG&E Solar Choice (50%)","PG&E Solar Choice (100%)"]
[null,null,null,"PG&E Delivery Costs",{"$f":"G20","v":0},{"$f":"G20","v":0},{"$f":"IFERROR('Data & Calculations'!B83,0)","v":0},{"$f":"G20","v":0},{"$f":"G20","v":0}]
[null,null,null,"Generation Costs",{"$f":"'Data & Calculations'!C84","v":0},{"$f":"E21+IF('Data & Calculations'!I63<0,0,'Data & Calculations'!I63*'Data & Calculations'!B74)","v":0},{"$f":"'Data & Calculations'!B84","v":0},{"$f":"G21+('Data & Calculations'!B79/2)","v":0},{"$f":"G21+('Data & Calculations'!B79)","v":0}]
[null,null,null,"Additional PG&E Fees",{"$f":"'Data & Calculations'!C85","v":0},{"$f":"E22","v":0},0,{"$f":"I22/2","v":0},{"$f":"'Data & Calculations'!B78","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},{"$f":"SUM(H20:H22)","v":0},{"$f":"SUM(I20:I22)","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 PCE?"]
[null,null,"A: CARE is a state-mandated program, and you'll receive the same discount as before. You can 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 (Medical Baseline). Will I still receive this with PCE?"]
[null,null,"A: PCEA customers remain eligible for medical baseline and will still receive this discount in-full. Additionally, they are exempt from additional PG&E fees."]
[]
[null,null,"Q: Does PCE offer special rates for Electric Vehicle owners?"]
[null,null,"A: Yes, select \"Advanced Options\" above and select the Electric Vehicle rate. You will need to enter your time-of-use based usage."]
[]
[null,null,"Q: Are PCE customers exempt from tiered rates, where I pay higher rates as I use more electricity each month?"]
[null,null,"A: No. Tiered rates are part of the utility structure mandated by the California Public Utilities Commission, and are assessed through PG&E delivery charges."]

{"sheet":"Data & Calculations","index":1,"n_rows":86,"n_cols":10,"rows_kept":86,"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:$AJ$16,MATCH(B$2,Rates!$A$2:$J$2,0),FALSE)","v":0.18353},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(C$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(D$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(E$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(F$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(G$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(H$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"_xlfn.IFNA(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(I$2,Rates!$A$2:$J$2,0),FALSE),0)","v":{"$error":"#NAME?"}},{"$f":"_xlfn.IFNA(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(J2,Rates!$A$2:$J$2,0),FALSE),0)","v":{"$error":"#NAME?"}}]
["Tier 2",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(B$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":0.24276},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(C$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(D$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(E$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(F$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(G$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(H$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false}]
["Tier 3",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(B$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":0.24276},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(C$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(D$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(E$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(F$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(G$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(H$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false}]
["Tier 4",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(B$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":0.40306999999999998},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(C$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(D$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(E$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(F$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(G$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AJ$16,MATCH(H$2,Rates!$A$2:$J$2,0)+28,FALSE)","v":false}]
[]
["Determined Bundled Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},{"$f":"B2","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge","Total"]
[{"$f":"A3","v":"Tier 1"},{"$f":"B3*C68","v":{"$error":"#DIV/0!"}},{"$f":"C3*D68","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I3*Calculator!D15","v":{"$error":"#NAME?"}}]
[{"$f":"A4","v":"Tier 2"},{"$f":"B4*C69","v":{"$error":"#DIV/0!"}},{"$f":"C4*D69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Tier 3",{"$f":"B5*C70","v":{"$error":"#DIV/0!"}},{"$f":"C5*D70","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Tier 4",{"$f":"B6*C71","v":{"$error":"#DIV/0!"}},{"$f":"C6*D71","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total",{"$f":"SUM(B10:B13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C10:C13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"_xlfn.IFNA(SUM(I10:I13),0)","v":{"$error":"#NAME?"}},{"$f":"SUM(B14:I14)","v":{"$error":"#DIV/0!"}}]
[]
["Determined Generation Rates (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},{"$f":"B2","v":"All Usage"},{"$f":"C2","v":"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$17,Rates!$A$2:$J$2,0),FALSE)","v":9.6839999999999996E-2},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(C$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(D$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(E$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(F$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(G$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$21:$H$34,MATCH(H$17,Rates!$A$2:$J$2,0),FALSE)","v":false}]
["PCEA",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(B$17,Rates!$A$2:$J$2,0),FALSE)","v":6.8150000000000002E-2},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(C$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(D$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(E$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(F$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(G$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$37:$H$50,MATCH(H$17,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"B74","v":0.01}]
[]
["Determined Generation Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},{"$f":"B2","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","NEM Bonus","Total"]
["PGE",{"$f":"B18*B$63","v":0},{"$f":"C18*C$63","v":0},0,0,0,0,0,null,{"$f":"SUM(B23:H23)","v":0}]
["PCEA",{"$f":"B19*B$63","v":0},0,0,0,0,0,0,{"$f":"SUMIF(B63:H63,\"<0\")*I19","v":0},{"$f":"SUM(B24:I24)","v":0}]
[]
["Determined Delivery Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},{"$f":"B2","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge","Total"]
["PGE",{"$f":"B$14-B23","v":{"$error":"#DIV/0!"}},{"$f":"C$14-C23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I10-I23","v":{"$error":"#NAME?"}},{"$f":"SUM(B28:I28)","v":{"$error":"#DIV/0!"}}]
["PCEA",{"$f":"B$14-B24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I28","v":{"$error":"#NAME?"}},{"$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.1999999999999998E-4,{"$f":"SUM(B37:C37)","v":8.1999999999999998E-4}]
[2009,2.0729999999999998E-2,6.4000000000000005E-4,2.137E-2]
[2010,2.2679999999999999E-2,6.3000000000000003E-4,2.3309999999999997E-2]
[2011,2.342E-2,6.2E-4,2.4039999999999999E-2]
[2012,2.3630000000000002E-2,6.2E-4,2.4250000000000001E-2]
[2013,2.3259999999999999E-2,6.2E-4,2.3879999999999998E-2]
[2014,2.3230000000000001E-2,6.2E-4,2.385E-2]
[2015,2.3230000000000001E-2,6.2E-4,2.385E-2]
[2016,2.3230000000000001E-2,6.2E-4,2.385E-2]
[]
[]
[]
[]
["Extra Fee Calculations (automated - DO NOT TOUCH; Vintage calculation needs to be updated periodically though)"]
["Normalized Vintage:",{"$f":"IF(D51<2009,A37,D51)","v":2016},"Determined Vintage:",{"$f":"MIN(IFERROR(IF(MONTH(Calculator!G16)<7,YEAR(Calculator!G16)-1,YEAR(Calculator!G16)),MAX('Data & Calculations'!A37:A49)),MAX(A37:A49))","v":2016}]
["Determined Fees:",{"$f":"VLOOKUP(B51,A37:D44,4)","v":2.385E-2},"Franchise Only:",{"$f":"VLOOKUP(B51,A37:D44,3)","v":6.2E-4}]
[]
["Delivery Rates (auto updates - DO NOT TOUCH)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},{"$f":"B2","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Meter Charge"]
["Tier 1",{"$f":"B3-B$18","v":8.6690000000000003E-2},{"$f":"C3-C$18","v":0},0,0,0,0,0,{"$error":"#NAME?"}]
["Tier 2",{"$f":"B4-B$18","v":0.14591999999999999},0,0,0,0,0,0,0]
["Tier 3",{"$f":"B5-B$18","v":0.14591999999999999},0,0,0,0,0,0,0]
["Tier 4",{"$f":"B6-B$18","v":0.30623},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(B63:H63)","v":0}]
["Pct of Total",{"$f":"B63/$I$63","v":{"$error":"#DIV/0!"}},{"$f":"C63/$I$63","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\"),B33,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"X\",Calculator!F6=\"May-Oct\"),B34,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"T\",Calculator!F6=\"Nov-Apr\"),C33,IF(AND(Calculator!D16=\"Gas\",Calculator!G15=\"X\",Calculator!F6=\"Nov-Apr\"),C34,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"T\",Calculator!F6=\"May-Oct\"),F33,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"X\",Calculator!F6=\"May-Oct\"),F34,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"T\",Calculator!F6=\"Nov-Apr\"),G33,IF(AND(Calculator!D16=\"Electric\",Calculator!G15=\"X\",Calculator!F6=\"Nov-Apr\"),G34,\"ERROR\"))))))))","v":10.9},{"$f":"B62","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Total Tier Allocation"]
["Tier 1",{"$f":"B67*Calculator!D15","v":337.90000000000003},{"$f":"B$64*$J68","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B68,I63)","v":0}]
["Tier 2",{"$f":"B68*0.3","v":101.37},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B69,I63-J68)","v":0}]
["Tier 3",{"$f":"B68*0.7","v":236.53},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B70,I63-J68-J69)","v":0}]
["Tier 4","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,I63-J68-J69-J70)","v":0}]
[]
["Misc Rates"]
["Eco100 Rate",0.01]
["Minimum Bill",{"$f":"J3*Calculator!D15","v":{"$error":"#NAME?"}},"(automated)"]
["PG&E Solar Premium (kWh)",3.5810000000000002E-2]
["PG&E Solar Premium",{"$f":"B76*I63","v":0},"(automated)"]
["PG&E Solar PCIA",{"$f":"B45*I63","v":0},"(automated)"]
["… without PCIA",{"$f":"B77-B78","v":0},"(automated)"]
[]
["Totals (automated)"]
[null,"PG&E","MCE"]
["Delivery",{"$f":"MAX(B75,J28)","v":{"$error":"#NAME?"}},{"$f":"B83","v":{"$error":"#NAME?"}}]
["Generation",{"$f":"J23","v":0},{"$f":"J24","v":0}]
["PCIA/FF",0,{"$f":"B52*I63","v":0}]
["Total",{"$f":"SUM(B83:B85)","v":{"$error":"#NAME?"}},{"$f":"SUM(C83:C85)","v":{"$error":"#NAME?"}}]

{"sheet":"Rates","index":2,"n_rows":48,"n_cols":36,"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,"Tier 3","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off",null,"Tier 4","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off"]
["Basic Residential (E-1)",0.18353,false,false,false,false,false,false,null,0.32854,{"$f":"A3","v":"Basic Residential (E-1)"},0.24276,false,false,false,false,false,false,null,{"$f":"K3","v":"Basic Residential (E-1)"},{"$f":"L3","v":0.24276},false,false,false,false,false,false,null,{"$f":"T3","v":"Basic Residential (E-1)"},0.40306999999999998,false,false,false,false,false,false]
["Basic CARE Res. (EL-1)",0.12025,false,false,false,false,false,false,null,0.16427,{"$f":"A4","v":"Basic CARE Res. (EL-1)"},0.14838999999999999,false,false,false,false,false,false,null,"Basic CARE Res. (EL-1)",{"$f":"L4","v":0.14838999999999999},false,false,false,false,false,false,null,{"$f":"T4","v":"Basic CARE Res. (EL-1)"},0.21837000000000001,false,false,false,false,false,false]
["E-TOU-A",{"$f":"L5","v":false},{"$f":"M5+D17","v":0.28755999999999998},{"$f":"N5","v":false},{"$f":"O5+D17","v":0.21198},{"$f":"P5+D17","v":0.16960000000000003},false,{"$f":"R5+D17","v":0.15529999999999999},null,{"$f":"J3","v":0.32854},{"$f":"A5","v":"E-TOU-A"},false,0.40555999999999998,false,0.32998,0.28760000000000002,false,0.27329999999999999,null,"E-TOU-A",{"$f":"L5","v":false},0.40555999999999998,false,0.32998,0.28760000000000002,false,0.27329999999999999,null,{"$f":"T5","v":"E-TOU-A"},{"$f":"U5","v":false},{"$f":"V5","v":0.40555999999999998},{"$f":"W5","v":false},{"$f":"X5","v":0.32998},{"$f":"Y5","v":0.28760000000000002},{"$f":"Z5","v":false},{"$f":"AA5","v":0.27329999999999999}]
["E-TOU-B",{"$f":"L6","v":false},{"$f":"M6","v":0.35816999999999999},false,{"$f":"O6","v":0.25511},0.22070999999999999,false,{"$f":"R6","v":0.20191000000000001},null,{"$f":"J3","v":0.32854},"E-TOU-B",false,0.35816999999999999,false,0.25511,0.22070999999999999,false,0.20191000000000001,null,"E-TOU-B",false,0.35816999999999999,false,0.25511,0.22070999999999999,false,0.20191000000000001,null,"E-TOU-B",{"$f":"U6","v":false},0.35816999999999999,false,0.25511,0.22070999999999999,false,0.20191000000000001]
["EL-TOU-A (CARE)",{"$f":"L7","v":false},{"$f":"M7+D18","v":0.18590999999999999},{"$f":"N7","v":false},{"$f":"O7+D18","v":0.13830000000000001},{"$f":"P7+D18","v":0.11158999999999999},{"$f":"Q7","v":false},{"$f":"R7+D18","v":0.10258},null,{"$f":"J4","v":0.16427},"EL-TOU-A (CARE)",false,0.23333999999999999,false,0.18573000000000001,0.15901999999999999,false,0.15001,null,"EL-TOU-A (CARE)",{"$f":"L7","v":false},{"$f":"M7","v":0.23333999999999999},{"$f":"N7","v":false},{"$f":"O7","v":0.18573000000000001},{"$f":"P7","v":0.15901999999999999},{"$f":"Q7","v":false},{"$f":"R7","v":0.15001},null,"EL-TOU-A (CARE)",{"$f":"U7","v":false},{"$f":"V7","v":0.23333999999999999},{"$f":"W7","v":false},{"$f":"X7","v":0.18573000000000001},{"$f":"Y7","v":0.15901999999999999},{"$f":"Z7","v":false},{"$f":"AA7","v":0.15001}]
["EL-TOU-B (CARE)",false,{"$f":"M8","v":0.21822},false,{"$f":"O8","v":0.15329999999999999},{"$f":"P8","v":0.13163},false,{"$f":"R8","v":0.11978},null,{"$f":"J4","v":0.16427},"EL-TOU-B (CARE)",false,0.21822,false,0.15329999999999999,0.13163,false,0.11978,null,"EL-TOU-B (CARE)",{"$f":"L8","v":false},{"$f":"M8","v":0.21822},{"$f":"N8","v":false},{"$f":"O8","v":0.15329999999999999},{"$f":"P8","v":0.13163},{"$f":"Q8","v":false},{"$f":"R8","v":0.11978},null,{"$f":"T8","v":"EL-TOU-B (CARE)"},{"$f":"U8","v":false},{"$f":"V8","v":0.21822},{"$f":"W8","v":false},{"$f":"X8","v":0.15329999999999999},{"$f":"Y8","v":0.13163},{"$f":"Z8","v":false},{"$f":"AA8","v":0.11978}]
["EV-A",false,0.44549,0.24310999999999999,0.11627999999999999,0.31374000000000002,0.19197,0.11904000000000001,null,{"$f":"J3","v":0.32854},"EV-A",{"$f":"B9","v":false},{"$f":"C9","v":0.44549},{"$f":"D9","v":0.24310999999999999},{"$f":"E9","v":0.11627999999999999},{"$f":"F9","v":0.31374000000000002},{"$f":"G9","v":0.19197},{"$f":"H9","v":0.11904000000000001},null,"EV-A",{"$f":"L9","v":false},{"$f":"M9","v":0.44549},{"$f":"N9","v":0.24310999999999999},{"$f":"O9","v":0.11627999999999999},{"$f":"P9","v":0.31374000000000002},{"$f":"Q9","v":0.19197},{"$f":"R9","v":0.11904000000000001},null,"EV-A",false,0.44549,0.24310999999999999,0.11627999999999999,0.31374000000000002,0.19197,0.11904000000000001]
["EV-B",false,0.43901000000000001,0.23988000000000001,0.11581,0.30685000000000001,0.18853,0.11854000000000001,4.9279999999999997E-2,{"$f":"J3","v":0.32854},"EV-B",false,0.43901000000000001,0.23988000000000001,0.11581,0.30685000000000001,0.18853,0.11854000000000001,null,"EV-B",false,0.43901000000000001,0.23988000000000001,0.11581,0.30685000000000001,0.18853,0.11854000000000001,null,"EV-B",false,0.43901000000000001,0.23988000000000001,0.11581,0.30685000000000001,0.18853,0.11854000000000001]
[]
[{"$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 ---"},null,null,null,null,null,null,null,null,"--- Closed Rates ---"]
["E-6 (Time-of-Use)",false,0.34306999999999999,0.2278,0.15101999999999999,false,0.17219000000000001,0.15536,0.25297999999999998,{"$f":"J3","v":0.32854},"E-6 (Time-of-Use)",false,0.40229999999999999,0.28703000000000001,0.21026,false,0.23141999999999999,0.21459,null,{"$f":"K13","v":"E-6 (Time-of-Use)"},false,{"$f":"M13","v":0.40229999999999999},{"$f":"N13","v":0.28703000000000001},{"$f":"O13","v":0.21026},false,{"$f":"Q13","v":0.23141999999999999},{"$f":"R13","v":0.21459},null,"E-6 (Time-of-Use)",false,0.56171000000000004,0.44644,0.36965999999999999,false,0.39083000000000001,0.374]
["EL-6 (CARE, Time-of-Use)",false,0.23705000000000001,0.15254999999999999,9.6269999999999994E-2,false,0.11179,9.9440000000000001E-2,0.20238,{"$f":"J4","v":0.16427},"EL-6 (CARE, Time-of-Use)",false,0.26627000000000001,0.18176999999999999,0.12548999999999999,false,0.14099,0.12864999999999999,null,{"$f":"K14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"M14","v":0.26627000000000001},0.18176999999999999,0.12548999999999999,false,0.14099,0.12864999999999999,null,"EL-6 (CARE, Time-of-Use)",false,0.38846000000000003,0.26540000000000002,0.18343999999999999,false,0.20604,0.18806]
[]
[]
["Baseline Credit (E-TOU only)",null,null,-0.11799999999999999]
["Baseline Credit (EL-TOU only)",null,null,-4.743E-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.6839999999999996E-2,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B21","v":9.6839999999999996E-2},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.18178,false,0.1062,9.4439999999999996E-2,false,8.0140000000000003E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.20402999999999999,false,0.10097,9.7199999999999995E-2,false,7.8399999999999997E-2]
[{"$f":"A7","v":"EL-TOU-A (CARE)"},false,0.18178,false,0.1062,9.4439999999999996E-2,false,8.0140000000000003E-2]
["EL-TOU-B (CARE)",false,0.20402999999999999,false,0.10097,9.7199999999999995E-2,false,7.8399999999999997E-2]
[{"$f":"A9","v":"EV-A"},false,0.22778000000000001,0.10977000000000001,5.5160000000000001E-2,8.5120000000000001E-2,5.3179999999999998E-2,5.713E-2]
[{"$f":"A10","v":"EV-B"},false,{"$f":"C27","v":0.22778000000000001},{"$f":"D27","v":0.10977000000000001},5.5160000000000001E-2,8.5120000000000001E-2,5.3179999999999998E-2,5.713E-2]
[]
[{"$f":"A12","v":"--- Closed Rates ---"}]
[{"$f":"A13","v":"E-6 (Time-of-Use)"},false,0.21337999999999999,0.11209,7.0749999999999993E-2,false,9.3700000000000006E-2,8.233E-2]
[{"$f":"A14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C31","v":0.21337999999999999},{"$f":"D31","v":0.11209},7.0749999999999993E-2,false,9.3700000000000006E-2,8.233E-2]
[]
[]
[]
["PCEA 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.8150000000000002E-2,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B37","v":6.8150000000000002E-2},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.14884,false,7.7039999999999997E-2,6.5869999999999998E-2,false,5.228E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.16997999999999999,false,7.2069999999999995E-2,6.8489999999999995E-2,false,5.0630000000000001E-2]
[{"$f":"A7","v":"EL-TOU-A (CARE)"},false,{"$f":"C39","v":0.14884},false,{"$f":"E39","v":7.7039999999999997E-2},{"$f":"F39","v":6.5869999999999998E-2},false,{"$f":"H39","v":5.228E-2}]
["EL-TOU-B (CARE)",false,{"$f":"C40","v":0.16997999999999999},false,{"$f":"E40","v":7.2069999999999995E-2},{"$f":"F40","v":6.8489999999999995E-2},false,{"$f":"H40","v":5.0630000000000001E-2}]
[{"$f":"A9","v":"EV-A"},false,0.19253999999999999,8.0430000000000001E-2,2.8549999999999999E-2,5.7009999999999998E-2,2.6669999999999999E-2,3.0419999999999999E-2]
[{"$f":"A10","v":"EV-B"},false,{"$f":"C43","v":0.19253999999999999},{"$f":"D43","v":8.0430000000000001E-2},{"$f":"E43","v":2.8549999999999999E-2},{"$f":"F43","v":5.7009999999999998E-2},{"$f":"G43","v":2.6669999999999999E-2},{"$f":"H43","v":3.0419999999999999E-2}]
[]
[{"$f":"A12","v":"--- Closed Rates ---"}]
[{"$f":"A13","v":"E-6 (Time-of-Use)"},false,0.17885999999999999,8.2640000000000005E-2,4.3360000000000003E-2,false,6.5170000000000006E-2,5.4359999999999999E-2]
[{"$f":"A14","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C47","v":0.17885999999999999},{"$f":"D47","v":8.2640000000000005E-2},{"$f":"E47","v":4.3360000000000003E-2},{"$f":"F47","v":false},{"$f":"G47","v":6.5170000000000006E-2},{"$f":"H47","v":5.4359999999999999E-2}]

{"sheet":"Changelog","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"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"]