{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cost Comparison","Calculation","Rates","PCIA  FF","CARE","Rebundled Rates","Changelog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Cost Comparison","index":0,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":false,"merged":[[34,13,36,19],[45,1,46,15]]}
[]
[null,"SVCE Business Cost Comparison Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 7/3/17"]
[]
[null,"Required Information",null,null,null,null,null,null,null,null,null,null,null,"Optional Information"]
[null,"Your Rate"]
[null,"A1 (COM-1)"]
[]
[null,"Your Usage"]
[null,null,null,null,null,null,null,"SUMMER",null,null,null,"WINTER"]
[null,{"$f":"IF(VLOOKUP(B6,Rates!A:AA,2,0)=FALSE,\"\",\"One Month of Usage:\")","v":""},null,null,null,"Summer Billing Period (days):",null,null,null," Winter Billing Period (days):"]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,3,0)=FALSE,\" \",\"Summer Month Usage:\")","v":"Summer Month Usage:"},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,4,0)=FALSE,\" \",\"Winter Month Usage:\")","v":"Winter Month Usage:"},null,null,null,null,null,"PCIA Vintage:",null,2017]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,11,0)=FALSE,\" \",\"Max Peak (kW):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,14,0)=FALSE,\" \",\"Max Peak (kW):\")","v":" "},null,null,null,null,null,"Franchise Fee Exemption:",null,"No"]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,12,0)=FALSE,\" \",\"Max Part Peak (kW):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,15,0)=FALSE,\" \",\"Part Peak (kW):\")","v":" "},null,null,null,null,null,"Phase:",null,"Single-phase"]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,13,0)=FALSE,\" \",\"Max Demand (kW):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,16,0)=FALSE,\" \",\"Max Demand (kW):\")","v":" "},null,null,null,null,null,"CARE Discount:",null,"No"]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,5,0)=FALSE,\" \",\"Peak (kWh):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,8,0)=FALSE,\" \",\"Peak (kWh):\")","v":" "}]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,6,0)=FALSE,\" \",\"Part Peak (kWh):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,9,0)=FALSE,\" \",\"Part Peak (kWh):\")","v":" "},null,null,null,null,null,"(E19 Only) Voluntary or Mandatory Service:",null,"Voluntary"]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,7,0)=FALSE,\" \",\"Off Peak (kWh):\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,10,0)=FALSE,\" \",\"Off Peak (kWh):\")","v":" "}]
[null,null,null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,17,0)=FALSE,\" \",\"Summer Connected Load:\")","v":" "},null,null,null,{"$f":"IF(VLOOKUP($B$6,Rates!A:AA,18,0)=FALSE,\" \",\"Winter Connected Load:\")","v":" "}]
[]
[null,"Total Cost Summary",null,null,null,null,null,null,null,"Compare Options (select two from the orange menus below)"]
[null,"Service Options",null,null,null,"Total Charges",null,null,null,null,null,"SVCE GreenStart (50%)",null,"PG&E Standard",null,"Difference"]
[null,"SVCE GreenStart (50%)",null,null,null,{"$f":"SUM(F32:L32)","v":0},null,null,null,"Total Cost",null,{"$f":"VLOOKUP(L21,$B$21:$F$26,5,FALSE)","v":0},null,{"$f":"VLOOKUP(N21,$B$21:$F$26,5,FALSE)","v":0},null,{"$f":"ABS(L22-N22)","v":0}]
[null,"PG&E Standard",null,null,null,{"$f":"SUM(F33:L33)","v":0},null,null,null,"Renewable %",null,{"$f":"VLOOKUP(L21,$B$40:$J$45,5,FALSE)","v":0.5},null,{"$f":"VLOOKUP(N21,$B$40:$J$45,5,FALSE)","v":0.3},null,{"$f":"ABS(L23-N23)","v":0.2}]
[null,"SVCE GreenPrime (100%)",null,null,null,{"$f":"SUM(F34:L34)","v":0},null,null,null,{"$f":"IF(J$39=\"lbs. (pounds)\",\"Estimated Emissions (lbs.)\",\"Estimated Emissions (MT)\")","v":"Estimated Emissions (lbs.)"},null,{"$f":"VLOOKUP(L21,$B$40:$J$45,9,FALSE)","v":0},null,{"$f":"VLOOKUP(N21,$B$40:$J$45,9,FALSE)","v":0},null,{"$f":"ABS(L24-N24)","v":0}]
[null,"PG&E Solar Choice (50%)",null,null,null,{"$f":"SUM(F35:L35)","v":0}]
[null,"PG&E Solar Choice (100%)",null,null,null,{"$f":"SUM(F36:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Calculation!B31<>0,\"CARE Program Adjustment:\",\"\")","v":""},null,{"$f":"IF(R14=\"Yes\",SUM(CARE!D3:D7),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=Rates!A56,\"Comparisons of streetlight rates (LS-1, LS-2, LS-3) are for electricity only, and do not include lamp fees imposed by PG&E.\",\"\")","v":""}]
[null,"Additional Billing Details"]
[null,"Breakdown of Charges by Service"]
[null,"Service Options",null,null,null,"PG&E Delivery Cost",null,"Generation Cost",null,"PCIA (PG&E Fee)",null,"Franchise Fee"]
[null,"SVCE GreenStart (50%)",null,null,null,{"$f":"F33","v":0},null,{"$f":"Calculation!B37","v":0},null,{"$f":"Calculation!B38","v":0},null,{"$f":"Calculation!B39","v":0}]
[null,"PG&E Standard",null,null,null,{"$f":"Calculation!B34","v":0},null,{"$f":"Calculation!B33","v":0},null,0,null,0]
[null,"SVCE GreenPrime (100%)",null,null,null,{"$f":"F33","v":0},null,{"$f":"H32+Calculation!B43","v":0},null,{"$f":"J32","v":0},null,{"$f":"L32","v":0}]
[null,"PG&E Solar Choice (50%)",null,null,null,{"$f":"F33","v":0},null,{"$f":"H33+Calculation!B42/2","v":0},null,{"$f":"J36/2","v":0},null,0]
[null,"PG&E Solar Choice (100%)",null,null,null,{"$f":"F33","v":0},null,{"$f":"H33+Calculation!B42","v":0},null,{"$f":"IF(L26=\"Pre-2009\",0,Calculation!B41)","v":0},null,0]
[]
[]
[null,"Breakdown of Energy Content",null,null,null,null,null,"Show emissions using (select):",null,"lbs. (pounds)"]
[null,"Service Options",null,null,null,"Renewable Content\n(% of Total Power Supply)",null,"Emissions Factor \n(lbs. CO2/MWh)*",null,"Estimated Emissions\n(lbs. CO2)",null,"Service Description"]
[null,"SVCE GreenStart (50%)",null,null,null,0.5,null,"<25",null,{"$f":"IF(J$39=\"lbs. (pounds)\",25*Calculation!E$3/1000,25*Calculation!E$3/1000/2204.6)","v":0},null,"Basic SVCE service (default)"]
[null,"PG&E Standard",null,null,null,0.3,null,405,null,{"$f":"IF(J$39=\"lbs. (pounds)\",H42*Calculation!E$3/1000,H42*Calculation!E$3/1000/2204.6)","v":0},null,"Basic PG&E service (opt out)"]
[null,"SVCE GreenPrime (100%)",null,null,null,1,null,0,null,{"$f":"IF(J$39=\"lbs. (pounds)\",H43*Calculation!E$3/1000,H43*Calculation!E$3/1000/2204.6)","v":0},null,"Optional 100% renewable SVCE service"]
[null,"PG&E Solar Choice (50%)",null,null,null,0.65,null,{"$f":"AVERAGE(H42,H45)","v":202.5},null,{"$f":"IF(J$39=\"lbs. (pounds)\",H44*Calculation!E$3/1000,H44*Calculation!E$3/1000/2204.6)","v":0},null,"Optional 50% solar PG&E service"]
[null,"PG&E Solar Choice (100%)",null,null,null,1,null,0,null,{"$f":"IF(J$39=\"lbs. (pounds)\",H45*Calculation!E$3/1000,H45*Calculation!E$3/1000/2204.6)","v":0},null,"Optional 100% solar PG&E service"]
[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."]
[]
[]
[null,"Glossary of Terms"]
[]
[null,"Required Account Data Terms"]
[null,"Your Rate:",null,null,null,"The PG&E rate selected for billing your account. Different rates utilize different usage data to determine your charges due. Selecting a rate will highlight required usage."]
[null,"Non Time-of-Use Usage Data:",null,null,null,"Basic and older electric rates may charge you based on total usage, regardless of what time of day it is used. This usage may still be divided seasonally as defined by PG&E."]
[null,"Time-of-Use Usage Data:",null,null,null,"Usage data which is specific to certain times of the day. This is divided into peak, partial peak, and off peak periods and is also divided seasonally."]
[null,"Demand-Based Usage Data:",null,null,null,"Large business customers are also assessed demand charges, which are based on their maximum use of electricity during certain points of a billing cycle."]
[]
[null,"Optional Account Data Terms"]
[null,"Billing Period Length:",null,null,null,"Certain PG&E delivery charges are affected by the length of your billing period. If the data reviewed is for a longer or shorter period than indicated, it can be adjusted."]
[null,"PCIA Vintage:",null,null,null,"PG&E assesses fees to customers which choose a provider other than PG&E. This fee is based on when your address began taking SVCE service and your rate class."]
[null,"Franchise Fee Exemption:",null,null,null,"Customers which are a subdivision of the State of California (such as state facilities, city facilities, school districts) are exempt from the Franchise Fee Surcharge."]
[null,"Phase:",null,null,null,"Some small business customers may be either single-phase or poly-phase, impacting monthly PG&E meter charges."]
[null,"CARE Discount:",null,null,null,"CARE is a low-income discount available to qualifying residential households; certain businesses may (rarely) also qualify. Available to PG&E and SVCE customers equally."]
[null,"Medical Baseline Exemption:",null,null,null,"Customers with needed medical equipment may receive an adjustment to their tiered delivery rates. Available to PG&E and SVCE customers equally."]
[null,"E19 Voluntary/Mandatory:",null,null,null,"Customers may participate in the E19 on a voluntary or required basis due to their high usage. Voluntary assignment is denoted by the letter \"V\" (e.g. E19SV)"]

{"sheet":"Calculation","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Normalized PCIA",{"$f":"'Cost Comparison'!R11","v":2017},null,null,null,null,"PCIA Charge",{"$f":"IFERROR(B2*E3,0)","v":0}]
["PCIA Rate",{"$f":"VLOOKUP(E2,'PCIA  FF'!A2:T12,MATCH(B1,'PCIA  FF'!1:1,0),FALSE)","v":2.1989999999999999E-2},null,"PCIA Class",{"$f":"VLOOKUP('Cost Comparison'!B6,Rates!$A$74:$S$104,19,0)","v":"A1"}]
["FF Rate",{"$f":"IF('Cost Comparison'!$R$12=\"No\",VLOOKUP(E2,'PCIA  FF'!A14:T24,MATCH(B1,'PCIA  FF'!14:14,0),FALSE),0)","v":6.4999999999999997E-4},null,"Usage Eligible",{"$f":"SUMIF(C7:C15,\"<>FALSE\",B7:B15)","v":0},null,"FF Charge",{"$f":"E3*B3","v":0}]
[]
["Bundled Rate Components"]
[null,"kWh/KW","Bundled Rate","Bundled Charge","PG&E Gen Rate","PG&E Gen Charge","SVCEA Gen Rate","SVCEA Gen Charge"]
["Non-sea/non-tou",{"$f":"'Cost Comparison'!D10","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,2,0)","v":false},{"$f":"B7*C7","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,2,0)","v":false},{"$f":"B7*E7","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,2,0)","v":false},{"$f":"G7*B7","v":0}]
["Summer seasonal",{"$f":"'Cost Comparison'!H11","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,3,0)","v":0.24729999999999999},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,3,0)","v":0.11518},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,3,0)","v":9.1389999999999999E-2},0]
["Winter Seasonal",{"$f":"'Cost Comparison'!L11","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,4,0)","v":0.19270000000000001},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,4,0)","v":7.9240000000000005E-2},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,4,0)","v":5.5809999999999998E-2},0]
["Summer Peak",{"$f":"'Cost Comparison'!H15","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,5,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,5,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,5,0)","v":false},0]
["Summer Part",{"$f":"'Cost Comparison'!H16","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,6,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,6,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,6,0)","v":false},0]
["Summer Off",{"$f":"'Cost Comparison'!H17","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,7,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,7,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,7,0)","v":false},0]
["Winter Peak",{"$f":"'Cost Comparison'!L15","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,8,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,8,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,8,0)","v":false},0]
["Winter Part",{"$f":"'Cost Comparison'!L16","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,9,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,9,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,9,0)","v":false},0]
["Winter Off",{"$f":"'Cost Comparison'!L17","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,10,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,10,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,10,0)","v":false},0]
["Demand Summer Peak",{"$f":"'Cost Comparison'!H12","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,11,0)","v":false},{"$f":"IF(B16=0,0,B16*C16*'Cost Comparison'!$H$10/SUM('Cost Comparison'!H10+'Cost Comparison'!L10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,11,0)","v":false},{"$f":"IF(E16=FALSE,0,B16*E16*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,11,0)","v":false},{"$f":"IF(G16=FALSE,0,B16*G16*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Demand Summer Part",{"$f":"'Cost Comparison'!H13","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,12,0)","v":false},{"$f":"IF(B17=0,0,B17*C17*'Cost Comparison'!H10/SUM('Cost Comparison'!H10+'Cost Comparison'!L10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,12,0)","v":false},{"$f":"IF(E17=FALSE,0,B17*E17*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,12,0)","v":false},{"$f":"IF(G17=FALSE,0,B17*G17*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Demand Summer Max",{"$f":"'Cost Comparison'!H14","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,13,0)","v":false},{"$f":"IF(B18=0,0,B18*C18*'Cost Comparison'!H10/SUM('Cost Comparison'!H10+'Cost Comparison'!L10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,13,0)","v":false},{"$f":"IF(E18=FALSE,0,B18*E18*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,13,0)","v":false},{"$f":"IF(G18=FALSE,0,B18*G18*'Cost Comparison'!$H$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Demand Winter Peak",{"$f":"'Cost Comparison'!L12","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,14,0)","v":false},{"$f":"IF(B19=0,0,B19*C19*'Cost Comparison'!L10/SUM('Cost Comparison'!L10+'Cost Comparison'!H10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,14,0)","v":false},{"$f":"IF(E19=FALSE,0,B19*E19*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,14,0)","v":false},{"$f":"IF(G19=FALSE,0,B19*G19*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Demand Winter Part",{"$f":"'Cost Comparison'!L13","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,15,0)","v":false},{"$f":"IF(B20=0,0,B20*C20*'Cost Comparison'!L10/SUM('Cost Comparison'!L10+'Cost Comparison'!H10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,15,0)","v":false},{"$f":"IF(E20=FALSE,0,B20*E20*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,15,0)","v":false},{"$f":"IF(G20=FALSE,0,B20*G20*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Demand Winter Max",{"$f":"'Cost Comparison'!L14","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,16,0)","v":false},{"$f":"IF(B21=0,0,B21*C21*'Cost Comparison'!L10/SUM('Cost Comparison'!L10+'Cost Comparison'!H10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,16,0)","v":false},{"$f":"IF(E21=FALSE,0,B21*E21*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,16,0)","v":false},{"$f":"IF(G21=FALSE,0,B21*G21*'Cost Comparison'!$L$10/SUM('Cost Comparison'!$H$10+'Cost Comparison'!$L$10))","v":0}]
["Conn. Load Summer",{"$f":"'Cost Comparison'!D14","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,17,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,17,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,17,0)","v":false},0]
["Conn. Load Winter",{"$f":"'Cost Comparison'!D15","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,18,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$38:$W$71,18,0)","v":false},0,{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$73:$W$106,18,0)","v":false},0]
[{"$f":"Rates!S2","v":"Single-phase"},{"$f":"IF(A24='Cost Comparison'!$R$13,SUM('Cost Comparison'!$L$10+'Cost Comparison'!$H$10,0))","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,19,0)","v":0.32854},0]
[{"$f":"Rates!T2","v":"Poly-phase"},{"$f":"IF(A25='Cost Comparison'!$R$13,'Cost Comparison'!$R$10,0)","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,20,0)","v":0.65708},0]
["Voluntary",{"$f":"IF(E2=\"E19\",IF('Cost Comparison'!R16=\"Voluntary\",'Cost Comparison'!H10+'Cost Comparison'!L10,0),0)","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,21,0)","v":false},0]
["Mandatory",{"$f":"IF(E2=\"E19\",IF('Cost Comparison'!R16=\"Mandatory\",'Cost Comparison'!R10,0),0)","v":0},{"$f":"VLOOKUP('Cost Comparison'!$B$6,Rates!$A$2:$W$33,22,0)","v":false},0]
["Total",null,null,{"$f":"SUM(D7:D27)","v":0},null,{"$f":"SUM(F7:F25)","v":0},null,{"$f":"SUM(H7:H25)","v":0}]
[]
["Raw Total",{"$f":"D28","v":0}]
["CARE Discount",{"$f":"SUM(CARE!D3:D7)","v":0}]
["PG&E Bundled Total",{"$f":"B30-B31","v":0},null,null,"GreenPrime Rate",8.0000000000000002E-3]
["PG&E Gen",{"$f":"F28","v":0}]
["PG&E T&D",{"$f":"B32-B33","v":0}]
["SVCEA Gen Only",{"$f":"H28","v":0}]
["SVCEA NEM Bonus",{"$f":"F37*F32","v":0}]
["SVCEA Gen",{"$f":"SUM(B35:B36)","v":0},null,null,"Eligible NEM Bonus Usage",{"$f":"SUMIFS(B8:B15,B8:B15,\"<0\",C8:C15,\"<>FALSE\")","v":0}]
["PCIA",{"$f":"H1","v":0}]
["FF",{"$f":"H3","v":0}]
["Solar Choice Premium",{"$f":"E3*VLOOKUP(E2,'PCIA  FF'!A27:B36,2,FALSE)","v":0}]
["Solar Choice PCIA",{"$f":"VLOOKUP(Calculation!E2,'PCIA  FF'!A1:T11,MATCH('Cost Comparison'!R11,'PCIA  FF'!1:1,0),FALSE)*E3","v":0}]
["… without PCIA",{"$f":"B40-B41","v":0}]
["Deep Green Premium",{"$f":"E3*F32","v":0}]
["Local Sol Gen Rate",{"$f":"SUM(E3*F33,H16:H23)","v":0}]

{"sheet":"Rates","index":2,"n_rows":104,"n_cols":22,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["Bundled Charges",null,"Flat Rate Options",null,"TOU Rate Options",null,null,null,null,null,"Demand Charges",null,null,null,null,null,null,null,"Per Meter/Day"]
["Rate Schedules","All Usage","Summer","Winter","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Summer Peak","Summer Partial Peak","Summer Maximum","Winter Off Peak","Winter Partial","Winter Maximum","Conn. Load Sum.","Conn. Load Win.","Single-phase","Poly-phase","Voluntary","Mandatory"]
["A1 (COM-1)",false,0.24729999999999999,0.19270000000000001,false,false,false,false,false,false,false,false,false,false,false,false,false,false,0.32854,0.65708,false,false]
["A1X (COM-1 TOU)",false,false,false,0.26297999999999999,0.23932999999999999,0.21196999999999999,false,0.22047,0.19955999999999999,false,false,false,false,false,false,false,false,{"$f":"S3","v":0.32854},{"$f":"T3","v":0.65708},false,false]
["A6 (COM-6)",false,false,false,0.55478000000000005,0.25796000000000002,0.18637999999999999,false,0.20441999999999999,0.18618000000000001,false,false,false,false,false,false,false,false,{"$f":"S3","v":0.32854},{"$f":"T3","v":0.65708},false,false]
["A10A (COM-10)",false,0.16286,0.12626000000000001,false,false,false,false,false,false,false,false,18.260000000000002,false,false,10.93,false,false,4.5995900000000001,{"$f":"S6","v":4.5995900000000001},false,false]
["A10B (COM-10-TOU)",false,false,false,0.21765999999999999,0.16253000000000001,0.13446,false,0.13435,0.11729000000000001,false,false,{"$f":"M6","v":18.260000000000002},false,false,{"$f":"P6","v":10.93},false,false,{"$f":"S6","v":4.5995900000000001},{"$f":"T6","v":4.5995900000000001},false,false]
["E19S (COM-19S)",false,false,false,0.15178,0.11126999999999999,8.4449999999999997E-2,false,0.10573,9.1109999999999997E-2,18.64,5.18,17.559999999999999,false,0.12,17.559999999999999,false,false,false,false,{"$f":"S6","v":4.5995900000000001},19.712530000000001]
["E19P (COM-19P)",false,false,false,0.14165,0.10327,7.8600000000000003E-2,false,9.8089999999999997E-2,8.4690000000000001E-2,16.600000000000001,4.53,14.4,false,0.15,14.4,false,false,false,false,{"$f":"U8","v":4.5995900000000001},{"$f":"V8","v":19.712530000000001}]
["E19T (COM-19T)",false,false,false,0.10559,9.2979999999999993E-2,7.6310000000000003E-2,false,9.4969999999999999E-2,8.2159999999999997E-2,12.42,3.11,9.1300000000000008,false,0,9.1300000000000008,false,false,false,false,{"$f":"U7","v":false},{"$f":"V7","v":false}]
["E19SR (COM-19SR)",false,false,false,0.33953,0.1593,8.4449999999999997E-2,false,0.10621999999999999,9.1109999999999997E-2,1.5,0.51,17.559999999999999,false,0.03,17.559999999999999,false,false,false,false,{"$f":"U8","v":4.5995900000000001},{"$f":"V8","v":19.712530000000001}]
["E19PR (COM-19PR)",false,false,false,0.32229999999999998,0.1482,7.8600000000000003E-2,false,9.8739999999999994E-2,8.4690000000000001E-2,1.33,0.44,14.4,false,0.04,14.4,false,false,false,false,{"$f":"U9","v":4.5995900000000001},32.854210000000002]
["E19TR (COM-19TR)",false,false,false,0.27428999999999998,0.13020999999999999,7.6310000000000003E-2,false,9.4969999999999999E-2,8.2159999999999997E-2,0,0,9.1300000000000008,false,0,9.1300000000000008,false,false,false,false,{"$f":"U12","v":4.5995900000000001},59.13758]
["E20S (COM-20S)",false,false,false,0.14244000000000001,0.10559,8.029E-2,false,0.10024,8.6529999999999996E-2,18.05,5.01,17.440000000000001,false,0.05,17.440000000000001,false,false,39.425049999999999,{"$f":"S14","v":39.425049999999999},false,false]
["E20P (COM-20P)",false,false,false,0.14393,0.10331,7.8329999999999997E-2,false,9.7960000000000005E-2,8.4470000000000003E-2,19.260000000000002,5.13,15.09,false,0.12,15.09,false,false,49.281309999999998,{"$f":"S15","v":49.281309999999998},false,false]
["E20T (COM-20T)",false,false,false,0.1008,8.8569999999999996E-2,7.238E-2,false,9.0490000000000001E-2,7.8060000000000004E-2,15.89,3.79,8.31,false,0,8.31,false,false,65.708420000000004,65.708420000000004,false,false]
["E20SR (COM-20SR)",false,false,false,0.31035000000000001,0.15060999999999999,8.029E-2,false,0.10043000000000001,8.6529999999999996E-2,1.45,0.5,17.440000000000001,false,0.01,17.440000000000001,false,false,{"$f":"S14","v":39.425049999999999},39.425049999999999,false,false]
["E20PR (COM-20PR)",false,false,false,0.32678000000000001,0.1467,7.8329999999999997E-2,false,9.8430000000000004E-2,8.4470000000000003E-2,1.46,0.49,15.09,false,0.03,15.09,false,false,{"$f":"S15","v":49.281309999999998},49.281309999999998,false,false]
["E20TR (COM-20TR)",false,false,false,0.27137,0.12456,7.238E-2,false,9.0490000000000001E-2,7.8060000000000004E-2,0,0,8.31,false,false,8.31,false,false,65.708420000000004,65.708420000000004,false,false]
["LS-1, LS-2, LS-3 (SL-1)",0.15873999999999999,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
["TC-1",0.18432000000000001,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,0.32854,0.32854,false,false]
["AG-1A",false,0.27939000000000003,0.21526999999999999,false,false,false,false,false,false,false,false,false,false,false,false,7.96,1.52,0.57399999999999995,{"$f":"S22","v":0.57399999999999995},false,false]
["AG-1B",false,0.23904,0.18603,false,false,false,false,false,false,false,false,11.63,false,false,2.34,false,false,0.76312999999999998,{"$f":"S23","v":0.76312999999999998},false,false]
["AG-4A",false,false,false,0.44480999999999998,false,0.19503000000000001,false,0.20179,0.16356000000000001,false,false,false,false,false,false,8.1199999999999992,1.23,{"$f":"0.574+0.22341","v":0.79740999999999995},{"$f":"S24","v":0.79740999999999995},false,false]
["AG-4B",false,false,false,0.29149999999999998,false,0.15745999999999999,false,0.15783,0.13306000000000001,5.17,false,9.7899999999999991,false,false,2.2599999999999998,false,false,{"$f":"0.76313+0.19713","v":0.96026},0.96026,false,false]
["AG-4C",false,false,false,0.26604,0.15676000000000001,0.11856999999999999,false,0.13113,0.11411,12.1,2.31,4.96,false,5.3999999999999999E-2,2.4,false,false,{"$f":"2.15003+0.19713","v":2.3471600000000001},2.3471600000000001,false,false]
["AG-5A, AG-5D",false,false,false,0.30743999999999999,false,0.15756000000000001,false,0.16586999999999999,0.14047999999999999,false,false,false,false,false,false,11.77,2.19,{"$f":"S24","v":0.79740999999999995},0.79740999999999995,false,false]
["AG-5B, AG-5E",false,false,false,0.2099,false,9.1889999999999999E-2,false,0.11199000000000001,8.3580000000000002E-2,9.85,false,15.37,false,false,5.95,false,false,{"$f":"1.19446+0.19713","v":1.3915900000000001},1.3915900000000001,false,false]
["AG-5C, AG-5F",false,false,false,0.16234000000000001,0.11173,9.289E-2,false,9.8580000000000001E-2,8.9969999999999994E-2,16.62,3.44,5.95,false,0.89,3.71,false,false,{"$f":"5.30871+0.19713","v":5.5058399999999992},5.5058399999999992,false,false]
["AG-RA",false,false,false,0.52724000000000004,false,0.18507999999999999,false,0.18867999999999999,0.15508,false,false,false,false,false,false,7.08,1.1599999999999999,{"$f":"S24","v":0.79740999999999995},0.79740999999999995,false,false]
["AG-RB",false,false,false,0.47500999999999999,false,0.17491999999999999,false,0.16422,0.13589999999999999,3.69,false,9.59,false,false,1.93,false,false,{"$f":"S25","v":0.96026},0.96026,false,false]
["AG-VA",false,false,false,0.49260999999999999,false,0.18195,false,0.18995000000000001,0.15562999999999999,false,false,false,false,false,false,7.1,1.2,{"$f":"S30","v":0.79740999999999995},0.79740999999999995,false,false]
["AG-VB",false,false,false,0.44031999999999999,false,0.17005999999999999,false,0.16158,0.13421,3.66,false,9.65,false,false,1.91,false,false,{"$f":"S31","v":0.96026},{"$f":"T31","v":0.96026},false,false]
[]
[]
[]
["PG&E Generation",null,"Flat Rate Options",null,"TOU Rate Options",null,null,null,null,null,"Demand Charges"]
["Rate Schedules",{"$f":"B2","v":"All Usage"},{"$f":"C2","v":"Summer"},"Winter","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Summer Peak","Summer Partial Peak","Summer Maximum","Winter Off Peak","Winter Partial","Winter Maximum","Conn. Load Sum.","Conn. Load Win."]
[{"$f":"A3","v":"A1 (COM-1)"},false,0.11518,7.9240000000000005E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
["A1X (COM-1 TOU)",false,false,false,0.13086,0.10721,7.9850000000000004E-2,false,0.10700999999999999,8.6099999999999996E-2,false,false,false,false,false,false,false,false]
["A6 (COM-6)",false,false,false,0.36486000000000002,0.12528,6.6989999999999994E-2,false,9.2450000000000004E-2,7.4959999999999999E-2,false,false,false,false,false,false,false,false]
["A10A (COM-10)",false,0.10492,8.0549999999999997E-2,false,false,false,false,false,false,false,false,4.8899999999999997,false,false,false,false,false]
["A10B (COM-10-TOU)",false,false,false,0.15972,0.10459,7.6520000000000005E-2,false,8.8639999999999997E-2,7.1580000000000005E-2,false,false,{"$f":"M42","v":4.8899999999999997},false,false,false,false,false]
["E19S (COM-19S)",false,false,false,0.12551999999999999,8.5010000000000002E-2,5.8189999999999999E-2,false,7.9469999999999999E-2,6.4850000000000005E-2,12.63,3.12,false,false,false,false,false,false]
["E19P (COM-19P)",false,false,false,0.11638,7.8E-2,5.3330000000000002E-2,false,7.2819999999999996E-2,5.9420000000000001E-2,11.29,2.75,false,false,false,false,false,false]
["E19T (COM-19T)",false,false,false,8.0320000000000003E-2,6.7710000000000006E-2,5.1040000000000002E-2,false,6.9699999999999998E-2,5.6890000000000003E-2,12.42,3.11,false,false,false,false,false,false]
[{"$f":"A11","v":"E19SR (COM-19SR)"},false,false,false,0.26473999999999998,0.1157,5.8189999999999999E-2,false,7.9469999999999999E-2,6.4850000000000005E-2,false,false,false,false,false,false,false,false]
["E19PR (COM-19PR)",false,false,false,0.24990000000000001,0.10836,5.3330000000000002E-2,false,7.2819999999999996E-2,5.9420000000000001E-2,false,false,false,false,false,false,false,false]
["E19TR (COM-19TR)",false,false,false,0.24901999999999999,0.10494000000000001,5.1040000000000002E-2,false,6.9699999999999998E-2,5.6890000000000003E-2,false,false,false,false,false,false,false,false]
[{"$f":"A14","v":"E20S (COM-20S)"},false,false,false,0.1167,7.9850000000000004E-2,5.4550000000000001E-2,false,7.4499999999999997E-2,6.0789999999999997E-2,12.24,3.02,false,false,false,false,false,false]
["E20P (COM-20P)",false,false,false,0.11932,7.8700000000000006E-2,5.3719999999999997E-2,false,7.3349999999999999E-2,5.9859999999999997E-2,13.44,3.18,false,false,false,false,false,false]
["E20T (COM-20T)",false,false,false,7.7979999999999994E-2,6.5750000000000003E-2,4.956E-2,false,6.7669999999999994E-2,5.5239999999999997E-2,15.89,3.79,false,false,false,false,false,false]
["E20SR (COM-20SR)",false,false,false,0.24074999999999999,0.11029,5.4550000000000001E-2,false,7.4499999999999997E-2,6.0789999999999997E-2,false,false,false,false,false,false,false,false]
["E20PR (COM-20PR)",false,false,false,0.25758999999999999,0.10856,5.3719999999999997E-2,false,7.3349999999999999E-2,5.9859999999999997E-2,false,false,false,false,false,false,false,false]
["E20TR (COM-20TR)",false,false,false,0.24854999999999999,0.10174,4.956E-2,false,6.7669999999999994E-2,5.5239999999999997E-2,false,false,false,false,false,false,false,false]
["LS-1, LS-2, LS-3 (SL-1)",7.9969999999999999E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
["TC-1",8.6779999999999996E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
["AG-1A",false,9.9320000000000006E-2,7.9659999999999995E-2,false,false,false,false,false,false,false,false,false,false,false,false,1.36,false]
["AG-1B",false,0.10228,7.9729999999999995E-2,false,false,false,false,false,false,false,false,2.04,false,false,false,false,false]
["AG-4A",false,false,false,0.15892000000000001,false,6.8610000000000004E-2,false,7.2709999999999997E-2,6.1949999999999998E-2,false,false,false,false,false,false,1.35,false]
["AG-4B",false,false,false,0.12171,false,7.0639999999999994E-2,false,6.8879999999999997E-2,5.8610000000000002E-2,2.54,false,2.39,false,false,false,false,false]
["AG-4C",false,false,false,0.13933000000000001,7.8880000000000006E-2,5.6910000000000002E-2,false,6.3149999999999998E-2,5.3710000000000001E-2,5.85,1,false,false,false,false,false,false]
["AG-5A, AG-5D",false,false,false,0.14873,false,7.3529999999999998E-2,false,7.7009999999999995E-2,6.5680000000000002E-2,false,false,false,false,false,false,3.7,false]
["AG-5B, AG-5E",false,false,false,0.14527000000000001,false,4.8840000000000001E-2,false,6.8940000000000001E-2,4.0529999999999997E-2,5.57,false,4.45,false,false,false,false,false]
["AG-5C, AG-5F",false,false,false,0.11976000000000001,6.9150000000000003E-2,5.0310000000000001E-2,false,5.5960000000000003E-2,4.7390000000000002E-2,10.28,1.93,false,false,false,false,false,false]
["AG-RA",false,false,false,0.26734999999999998,false,6.7330000000000001E-2,false,7.4459999999999998E-2,6.3380000000000006E-2,false,false,false,false,false,false,1.31,false]
["AG-RB",false,false,false,0.24143000000000001,false,6.6839999999999997E-2,false,6.1310000000000003E-2,5.2220000000000003E-2,2.1800000000000002,false,1.94,false,false,false,false,false]
["AG-VA",false,false,false,0.23391999999999999,false,6.4619999999999997E-2,false,7.2940000000000005E-2,6.2089999999999999E-2,false,false,false,false,false,false,1.37,false]
["AG-VB",false,false,false,0.21601000000000001,false,6.5019999999999994E-2,false,6.1539999999999997E-2,5.2400000000000002E-2,2.29,false,1.78,false,false,false,false,false]
[]
[]
["SVCEA Generation",null,"Flat Rate Options",null,"TOU Rate Options",null,null,null,null,null,"Demand Charges"]
["Rate Schedules",{"$f":"B2","v":"All Usage"},{"$f":"C2","v":"Summer"},"Winter","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Summer Peak","Summer Partial Peak","Summer Maximum","Winter Off Peak","Winter Partial","Winter Maximum","Conn. Load Sum.","Conn. Load Win.","PCIA Mapping"]
[{"$f":"A39","v":"A1 (COM-1)"},false,9.1389999999999999E-2,5.5809999999999998E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"'PCIA  FF'!$A$3","v":"A1"}]
["A1X (COM-1 TOU)",false,false,false,0.10691000000000001,8.3500000000000005E-2,5.6410000000000002E-2,false,8.3299999999999999E-2,6.2600000000000003E-2,false,false,false,false,false,false,false,false,{"$f":"'PCIA  FF'!$A$3","v":"A1"}]
["A6 (COM-6)",false,false,false,0.33856999999999998,0.10138999999999999,4.3679999999999997E-2,false,6.8890000000000007E-2,5.1569999999999998E-2,false,false,false,false,false,false,false,false,{"$f":"'PCIA  FF'!$A$3","v":"A1"}]
["A10A (COM-10)",false,8.0659999999999996E-2,5.6529999999999997E-2,false,false,false,false,false,false,false,false,4.84,false,false,false,false,false,{"$f":"'PCIA  FF'!$A$4","v":"A10"}]
["A10B (COM-10-TOU)",false,false,false,0.13491,8.0329999999999999E-2,5.2540000000000003E-2,false,6.454E-2,4.7649999999999998E-2,false,false,4.84,false,false,false,false,false,{"$f":"'PCIA  FF'!$A$4","v":"A10"}]
["E19S (COM-19S)",false,false,false,0.10473,6.4630000000000007E-2,3.8080000000000003E-2,false,5.9150000000000001E-2,4.4670000000000001E-2,12.5,3.09,false,false,false,false,false,false,"E19"]
["E19P (COM-19P)",false,false,false,9.5689999999999997E-2,5.7689999999999998E-2,3.3270000000000001E-2,false,5.2560000000000003E-2,3.9300000000000002E-2,11.18,2.72,false,false,false,false,false,false,"E19"]
["E19T (COM-19T)",false,false,false,5.9990000000000002E-2,4.7500000000000001E-2,3.1E-2,false,4.947E-2,3.6790000000000003E-2,12.3,3.08,false,false,false,false,false,false,"E19"]
[{"$f":"A47","v":"E19SR (COM-19SR)"},false,false,false,0.24256,9.5009999999999997E-2,3.8080000000000003E-2,false,5.9150000000000001E-2,4.4670000000000001E-2,false,false,false,false,false,false,false,false,"E19"]
["E19PR (COM-19PR)",false,false,false,0.22786999999999999,8.7749999999999995E-2,3.3270000000000001E-2,false,5.2560000000000003E-2,3.9300000000000002E-2,false,false,false,false,false,false,false,false,"E19"]
["E19TR (COM-19TR)",false,false,false,0.22700000000000001,8.4360000000000004E-2,3.1E-2,false,4.947E-2,3.6790000000000003E-2,false,false,false,false,false,false,false,false,"E19"]
[{"$f":"A50","v":"E20S (COM-20S)"},false,false,false,9.6799999999999997E-2,6.0319999999999999E-2,3.5270000000000003E-2,false,5.5030000000000003E-2,4.1450000000000001E-2,12.12,2.99,false,false,false,false,false,false,{"$f":"'PCIA  FF'!A11","v":"E20S"}]
["E20P (COM-20P)",false,false,false,0.10074,6.0519999999999997E-2,3.5790000000000002E-2,false,5.5230000000000001E-2,4.1869999999999997E-2,13.31,3.15,false,false,false,false,false,false,{"$f":"'PCIA  FF'!A10","v":"E20P"}]
["E20T (COM-20T)",false,false,false,6.1339999999999999E-2,4.9230000000000003E-2,3.32E-2,false,5.1130000000000002E-2,3.8830000000000003E-2,15.73,3.75,false,false,false,false,false,false,{"$f":"'PCIA  FF'!A9","v":"E20T"}]
["E20SR (COM-20SR)",false,false,false,0.21961,9.0459999999999999E-2,3.5270000000000003E-2,false,5.5030000000000003E-2,4.1450000000000001E-2,false,false,false,false,false,false,false,false,{"$f":"S85","v":"E20S"}]
["E20PR (COM-20PR)",false,false,false,0.23762,9.0079999999999993E-2,3.5790000000000002E-2,false,5.5230000000000001E-2,4.1869999999999997E-2,false,false,false,false,false,false,false,false,{"$f":"S86","v":"E20P"}]
["E20TR (COM-20TR)",false,false,false,0.23019999999999999,8.4860000000000005E-2,3.32E-2,false,5.1130000000000002E-2,3.8830000000000003E-2,false,false,false,false,false,false,false,false,{"$f":"S87","v":"E20T"}]
["LS-1, LS-2, LS-3 (SL-1)",7.4289999999999995E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"'PCIA  FF'!A6","v":"Streelights"}]
["TC-1",6.3270000000000007E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"S74","v":"A1"}]
["AG-1A",false,7.6469999999999996E-2,5.7000000000000002E-2,false,false,false,false,false,false,false,false,false,false,false,false,1.35,false,"Agriculture"]
["AG-1B",false,7.9399999999999998E-2,5.7070000000000003E-2,false,false,false,false,false,false,false,false,2.02,false,false,false,false,false,{"$f":"S93","v":"Agriculture"}]
["AG-4A",false,false,false,0.13547000000000001,false,4.6059999999999997E-2,false,5.0119999999999998E-2,3.9469999999999998E-2,false,false,false,false,false,false,1.34,false,{"$f":"S94","v":"Agriculture"}]
["AG-4B",false,false,false,9.8629999999999995E-2,false,4.8070000000000002E-2,false,4.6330000000000003E-2,3.6159999999999998E-2,2.5099999999999998,false,2.37,false,false,false,false,false,"Agriculture"]
["AG-4C",false,false,false,0.11608,5.6230000000000002E-2,3.4479999999999997E-2,false,4.0660000000000002E-2,3.1309999999999998E-2,5.79,0.99,false,false,false,false,false,false,"Agriculture"]
["AG-5A, AG-5D",false,false,false,0.12537999999999999,false,5.0930000000000003E-2,false,5.4379999999999998E-2,4.3159999999999997E-2,false,false,false,false,false,false,3.66,false,"Agriculture"]
["AG-5B, AG-5E",false,false,false,0.12196,false,2.649E-2,false,4.6390000000000001E-2,1.8259999999999998E-2,5.51,false,4.41,false,false,false,false,false,"Agriculture"]
[{"$f":"A65","v":"AG-5C, AG-5F"},false,false,false,9.6699999999999994E-2,4.6600000000000003E-2,2.7949999999999999E-2,false,3.354E-2,2.5059999999999999E-2,10.18,1.91,false,false,false,false,false,false,"Agriculture"]
["AG-RA",false,false,false,0.24282000000000001,false,4.48E-2,false,5.1860000000000003E-2,4.0890000000000003E-2,false,false,false,false,false,false,1.3,false,"Agriculture"]
["AG-RB",false,false,false,0.21715999999999999,false,4.4310000000000002E-2,false,3.884E-2,2.9839999999999998E-2,2.16,false,1.92,false,false,false,false,false,"Agriculture"]
["AG-VA",false,false,false,0.20971999999999999,false,4.2110000000000002E-2,false,5.0349999999999999E-2,3.9609999999999999E-2,false,false,false,false,false,false,1.36,false,"Agriculture"]
["AG-VB",false,false,false,0.19198999999999999,false,4.2509999999999999E-2,false,3.9059999999999997E-2,3.0020000000000002E-2,2.27,false,1.76,false,false,false,false,false,"Agriculture"]

{"sheet":"PCIA  FF","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["PCIA",null,2009,2010,2011,2012,2013,2014,2015,2016,2017,null,null,"Error-checking and debugging:"]
["Residential",null,null,null,null,null,null,null,null,null,null,null,null,"Min","Max"]
["A1",null,1.8610000000000002E-2,2.112E-2,2.2009999999999998E-2,2.2710000000000001E-2,2.2599999999999999E-2,2.2210000000000001E-2,2.1909999999999999E-2,2.1989999999999999E-2,2.1989999999999999E-2,null,null,{"$f":"MIN(C3:K3)","v":1.8610000000000002E-2},{"$f":"MAX(C3:K3)","v":2.2710000000000001E-2}]
["A10",null,1.9060000000000001E-2,2.163E-2,2.2550000000000001E-2,2.3259999999999999E-2,2.315E-2,2.2759999999999999E-2,2.2450000000000001E-2,2.2530000000000001E-2,2.2530000000000001E-2,null,null,{"$f":"MIN(C4:K4)","v":1.9060000000000001E-2},{"$f":"MAX(C4:K4)","v":2.3259999999999999E-2}]
["E19",null,1.5980000000000001E-2,1.814E-2,1.89E-2,1.95E-2,1.941E-2,1.908E-2,1.882E-2,1.8890000000000001E-2,1.8890000000000001E-2,null,null,1.5980000000000001E-2,1.95E-2]
["Streelights",null,3.5899999999999999E-3,4.0699999999999998E-3,4.2399999999999998E-3,4.3699999999999998E-3,4.3499999999999997E-3,4.28E-3,4.2199999999999998E-3,4.2399999999999998E-3,4.2399999999999998E-3,null,null,3.5899999999999999E-3,4.3699999999999998E-3]
["Standby",null,8.6499999999999997E-3,9.8099999999999993E-3,1.023E-2,1.055E-2,1.0500000000000001E-2,1.0319999999999999E-2,1.018E-2,1.022E-2,1.022E-2,null,null,8.6499999999999997E-3,1.055E-2]
["Agriculture",null,1.806E-2,2.0490000000000001E-2,2.1360000000000001E-2,2.2030000000000001E-2,2.1930000000000002E-2,2.1559999999999999E-2,2.1260000000000001E-2,2.1340000000000001E-2,2.1340000000000001E-2,null,null,1.806E-2,2.2030000000000001E-2]
["E20T",null,1.2970000000000001E-2,1.472E-2,1.5339999999999999E-2,1.5820000000000001E-2,1.575E-2,1.5480000000000001E-2,1.5270000000000001E-2,1.532E-2,1.532E-2,null,null,1.2970000000000001E-2,1.5820000000000001E-2]
["E20P",null,1.422E-2,1.6140000000000002E-2,1.6820000000000002E-2,1.7350000000000001E-2,1.7270000000000001E-2,1.6969999999999999E-2,1.6740000000000001E-2,1.6799999999999999E-2,1.6799999999999999E-2,null,null,1.422E-2,1.7350000000000001E-2]
["E20S",null,1.5339999999999999E-2,1.7409999999999998E-2,1.814E-2,1.8720000000000001E-2,1.8630000000000001E-2,1.831E-2,1.806E-2,1.813E-2,1.813E-2,null,null,1.5339999999999999E-2,1.8720000000000001E-2]
[]
[]
["FFS","Pre-2009",{"$f":"C1","v":2009},{"$f":"D1","v":2010},2011,2012,2013,2014,2015,2016,{"$f":"K1","v":2017}]
["Residential"]
["A1",8.3000000000000001E-4,6.8000000000000005E-4,6.6E-4,6.4999999999999997E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4999999999999997E-4,6.4999999999999997E-4,6.4999999999999997E-4,6.4999999999999997E-4,null,null,6.4000000000000005E-4,6.8000000000000005E-4]
["A10",8.7000000000000001E-4,7.1000000000000002E-4,6.8999999999999997E-4,6.8000000000000005E-4,6.7000000000000002E-4,6.7000000000000002E-4,6.8000000000000005E-4,6.8000000000000005E-4,6.8000000000000005E-4,6.8000000000000005E-4,null,null,6.7000000000000002E-4,7.1000000000000002E-4]
["E19",8.0000000000000004E-4,6.6E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.3000000000000003E-4,6.3000000000000003E-4,6.3000000000000003E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,null,null,6.3000000000000003E-4,6.6E-4]
["Streelights",6.8000000000000005E-4,6.4999999999999997E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,6.4000000000000005E-4,null,null,6.4000000000000005E-4,6.4999999999999997E-4]
["Standby",5.9999999999999995E-4,5.2999999999999998E-4,5.1999999999999995E-4,5.1999999999999995E-4,5.1000000000000004E-4,5.1000000000000004E-4,5.1999999999999995E-4,5.1999999999999995E-4,5.1999999999999995E-4,5.1999999999999995E-4,null,null,5.1000000000000004E-4,5.2999999999999998E-4]
["Agriculture",6.9999999999999999E-4,5.4000000000000001E-4,5.1999999999999995E-4,5.1999999999999995E-4,5.1000000000000004E-4,5.1000000000000004E-4,5.1000000000000004E-4,5.1999999999999995E-4,5.1999999999999995E-4,5.1999999999999995E-4,null,null,5.1000000000000004E-4,5.4000000000000001E-4]
["E20T",6.7000000000000002E-4,5.5999999999999995E-4,5.5000000000000003E-4,5.4000000000000001E-4,5.4000000000000001E-4,5.4000000000000001E-4,5.4000000000000001E-4,5.4000000000000001E-4,5.4000000000000001E-4,5.4000000000000001E-4,null,null,5.4000000000000001E-4,5.5999999999999995E-4]
["E20P",7.2999999999999996E-4,6.0999999999999997E-4,5.9999999999999995E-4,5.9000000000000003E-4,5.9000000000000003E-4,5.9000000000000003E-4,5.9000000000000003E-4,5.9000000000000003E-4,5.9000000000000003E-4,5.9000000000000003E-4,null,null,5.9000000000000003E-4,6.0999999999999997E-4]
["E20S",7.5000000000000002E-4,6.2E-4,6.0999999999999997E-4,5.9999999999999995E-4,5.9000000000000003E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,null,null,5.9000000000000003E-4,6.2E-4]
[]
[]
["Solar Prem. (Solar Choice Premium)","All Usage"]
["Residential",2.6100000000000002E-2]
["A1",1.6709999999999999E-2]
["A10",1.49E-2]
["E19",1.6990000000000002E-2]
["Streelights",1.5869999999999999E-2]
["Agriculture",3.3410000000000002E-2]
["E20T",2.9149999999999999E-2]
["E20P",2.3879999999999998E-2]
["E20S",2.1329999999999998E-2]

{"sheet":"CARE","index":4,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Commercial Care Discounts",null,null,null,null,"CARE Ind?",{"$f":"'Cost Comparison'!R14","v":"No"}]
[null,null,"Usage","Discount",null,"Eligible Usage",{"$f":"Calculation!E3","v":0}]
["A1",7.8939999999999996E-2,{"$f":"IF(AND($G$1=\"Yes\",Calculation!$E$2=CARE!$A3,'Cost Comparison'!B6<>\"TC-1\"),Calculation!$E$3,0)","v":0},{"$f":"B3*C3","v":0}]
["A6",7.6280000000000001E-2,{"$f":"IF(AND($G$1=\"Yes\",Calculation!$E$2=CARE!$A4),Calculation!$E$3,0)","v":0},{"$f":"B4*C4","v":0}]
["A10",7.0660000000000001E-2,{"$f":"IF(AND($G$1=\"Yes\",Calculation!$E$2=CARE!$A5),Calculation!$E$3,0)","v":0},{"$f":"B5*C5","v":0}]
["E19",6.2619999999999995E-2,{"$f":"IF(AND($G$1=\"Yes\",Calculation!$E$2=CARE!$A6),Calculation!$E$3,0)","v":0},{"$f":"B6*C6","v":0}]
["E20",5.1450000000000003E-2,{"$f":"IF(AND($G$1=\"Yes\",Calculation!$E$2=CARE!$A7),Calculation!$E$3,0)","v":0},0]

{"sheet":"Rebundled Rates","index":5,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,2,1,5]]}
[]
[null,"A1X (COM-1 TOU)","MCE",null,null,null,"PG&E","Overall"]
[null,"Season","MCE Gen.","PG&E Delivery","PG&E Fees","Effective Rate","PG&E Rate","% Diff."]
["Non-Seasonal","All Usage",{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0)))","v":""},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0))=FALSE,\"\",G4-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0)))","v":""},{"$f":"IF(C4=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":""},{"$f":"IF(SUM(C4:E4)=0,\"\",SUM(C4:E4))","v":""},{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B4,Rates!$2:$2,0)))","v":""},{"$f":"IFERROR((F4/G4)-1,\"\")","v":""}]
["Non-TOU",{"$f":"Rates!C2","v":"Summer"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0)))","v":""},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0))=FALSE,\"\",G5-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0)))","v":""},{"$f":"IF(C5=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":""},{"$f":"IF(SUM(C5:E5)=0,\"\",SUM(C5:E5))","v":""},{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B5,Rates!$2:$2,0)))","v":""},{"$f":"IFERROR((F5/G5)-1,\"\")","v":""}]
["Non-TOU",{"$f":"Rates!D2","v":"Winter"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0)))","v":""},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0))=FALSE,\"\",G6-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0)))","v":""},{"$f":"IF(C6=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":""},"",{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B6,Rates!$2:$2,0)))","v":""},""]
["TOU Usage",{"$f":"Rates!E2","v":"Summer Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0)))","v":0.10691000000000001},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0))=FALSE,\"\",G7-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0)))","v":0.13211999999999999},{"$f":"IF(C7=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":2.264E-2},{"$f":"IF(SUM(C7:E7)=0,\"\",SUM(C7:E7))","v":0.26167000000000001},{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B7,Rates!$2:$2,0)))","v":0.26297999999999999},{"$f":"IFERROR((F7/G7)-1,\"\")","v":-4.9813674043652778E-3}]
["TOU Usage",{"$f":"Rates!F2","v":"Summer Partial Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0)))","v":8.3500000000000005E-2},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0))=FALSE,\"\",G8-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0)))","v":0.13211999999999999},{"$f":"IF(C8=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":2.264E-2},{"$f":"IF(SUM(C8:E8)=0,\"\",SUM(C8:E8))","v":0.23825999999999997},{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B8,Rates!$2:$2,0)))","v":0.23932999999999999},{"$f":"IFERROR((F8/G8)-1,\"\")","v":-4.4708143567460112E-3}]
["TOU Usage",{"$f":"Rates!G2","v":"Summer Off Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0)))","v":5.6410000000000002E-2},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0))=FALSE,\"\",G9-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0)))","v":0.13211999999999999},{"$f":"IF(C9=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":2.264E-2},0.21116999999999997,{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B9,Rates!$2:$2,0)))","v":0.21196999999999999},-3.7741189791009599E-3]
["TOU Usage",{"$f":"Rates!H2","v":"Winter Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0)))","v":""},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0))=FALSE,\"\",G10-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0)))","v":""},{"$f":"IF(C10=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":""},"",{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B10,Rates!$2:$2,0)))","v":""},""]
["TOU Usage",{"$f":"Rates!I2","v":"Winter Partial Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0)))","v":8.3299999999999999E-2},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0))=FALSE,\"\",G11-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0)))","v":0.11346000000000001},{"$f":"IF(C11=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":2.264E-2},0.21939999999999998,{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B11,Rates!$2:$2,0)))","v":0.22047},-4.8532680183245303E-3]
["TOU Usage",{"$f":"Rates!J2","v":"Winter Off Peak"},{"$f":"IF(INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$73:$J$106,MATCH($B$2,Rates!$A$73:$A$106,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0)))","v":6.2600000000000003E-2},{"$f":"IF(INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0))=FALSE,\"\",G12-INDEX(Rates!$A$38:$J$69,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0)))","v":0.11345999999999999},{"$f":"IF(C12=\"\",\"\",VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$A:$O,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0)+VLOOKUP(VLOOKUP($B$2,Rates!$A$72:$S$106,19,0),'PCIA  FF'!$14:$24,MATCH(MAX('PCIA  FF'!$1:$1),'PCIA  FF'!$1:$1,0),0))","v":2.264E-2},0.19869999999999999,{"$f":"IF(INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0))=FALSE,\"\",INDEX(Rates!$A$2:$J$35,MATCH('Rebundled Rates'!$B$2,Rates!$A$2:$A$35,0),MATCH('Rebundled Rates'!B12,Rates!$2:$2,0)))","v":0.19955999999999999},-4.3094808578874044E-3]
["Demand",{"$f":"Rates!K2","v":"Summer Peak"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B13,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B13,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G13-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B13,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B13,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B13,Rates!$K$2:$V$2,0),0))","v":""},""]
["Demand",{"$f":"Rates!L2","v":"Summer Partial Peak"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B14,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B14,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G14-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B14,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B14,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B14,Rates!$K$2:$V$2,0),0))","v":""},""]
["Demand",{"$f":"Rates!M2","v":"Summer Maximum"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B15,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B15,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G15-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B15,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B15,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B15,Rates!$K$2:$V$2,0),0))","v":""},""]
["Demand",{"$f":"Rates!N2","v":"Winter Off Peak"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B16,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B16,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G16-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B16,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B16,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B16,Rates!$K$2:$V$2,0),0))","v":""}]
["Demand",{"$f":"Rates!O2","v":"Winter Partial"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B17,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B17,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G17-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B17,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B17,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B17,Rates!$K$2:$V$2,0),0))","v":""},""]
["Demand",{"$f":"Rates!P2","v":"Winter Maximum"},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B18,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B18,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G18-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B18,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,{"$f":"IF(SUM(C18:E18)=0,\"\",SUM(C18:E18))","v":""},{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B18,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B18,Rates!$K$2:$V$2,0),0))","v":""},{"$f":"IFERROR((F18/G18)-1,\"\")","v":""}]
["Ag. HP Load",{"$f":"Rates!Q2","v":"Conn. Load Sum."},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B19,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B19,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G19-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B19,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,{"$f":"IF(SUM(C19:E19)=0,\"\",SUM(C19:E19))","v":""},{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B19,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B19,Rates!$K$2:$V$2,0),0))","v":""},""]
["Ag. HP Load",{"$f":"Rates!R2","v":"Conn. Load Win."},{"$f":"IF(VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B20,Rates!$K$73:$S$73,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$73:$S$104,10+MATCH('Rebundled Rates'!B20,Rates!$K$73:$S$73,0),0))","v":""},{"$f":"IFERROR(G20-VLOOKUP($B$2,Rates!$A$38:$V$71,10+MATCH('Rebundled Rates'!B20,Rates!$K$2:$V$2,0),0),\"\")","v":""},null,"",{"$f":"IF(VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B20,Rates!$K$2:$V$2,0),0)=FALSE,\"\",VLOOKUP($B$2,Rates!$A$2:$V$35,10+MATCH('Rebundled Rates'!B20,Rates!$K$2:$V$2,0),0))","v":""},""]

{"sheet":"Changelog","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["2016-11-15","Added Changelog"]
[null,"Added lbs or metric tons for CO2 switch"]
[null,"Changed CO2e description to CO2 (due to recently discovered information that PG&E emissions only includes CO2 and omits other equivalent gasses which would increase their emissions factor)"]
["2017-01-03","Updated for PG&E AET"]
[null,"Fixed AG-1 A/B maximum demand defect"]
[null,"Fixed AG-4 C demand component defect"]
["2017-03-01","Updated PCIA methodology"]
[null,"Addressed PG&E Solar Choice Calculation issues"]
[null,"Updated PG&E Solar Choice Rates"]
[null,"Updated rates to PG&E 3/1 rate change"]
[null,"Updated description of PCIA Vintages"]
[null,"Added MCE 4/1 Rates"]
[]
["2017-06-07","split Billing days into billing days Summer and Billing Days Winter"]
[null,"Changed Demand charges to be responsive to # of billing days in the month"]