{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Model Description","Summary","Authorized Rev Req","Incremental Rev Req","SAR and RAR","Res Bill Impact","Hypothetical Summary","Hypothetical SAR and RAR","Hypothetical Res Bill Impact","SetUp"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":146,"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":"Model Description","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tab","Description"]
[null,"Summary","This tab allows the user to input the year, baseline region, and other assumptions. Includes outputs of average bills for current and inputted year."]
[null,null,"Bundled represents customers that we procure gas for. System refers to all customer classes combined. Total System for a customer class includes Bundled + Unbundled. "]
[null,"Authorized Rev Req","This tab shows the authorized revenue requirement for each line item that is in existing rates."]
[null,"Incremental Rev Req","This tab contains several sections: (i) Approved Application(s), (ii) Pending Application(s) Not Yet Approved, and (iii) Applications Projected to be Filed. "]
[null,null,"The Approved Application(s) section shows the authorized revenue requirement for each line item forecasted out by year."]
[null,null,"The Pending Application(s) Not Yet Approved section includes pending advice letters or applications for new proceedings and any pending increases or decreases to current line items."]
[null,"SAR and RAR","This tab shows the total revenue and the allocated revenue used to calculate Residential rates for the inputted year."]
[null,null,"The Residential percent allocations for the Revenue Recovery Mechanisms are estimated using the detailed Cost Allocation and Rate Design Model."]
[null,"Res Bill Impact","This tab shows the calculation for Residential rates and average monthly bills."]
[null,"Hypothetical Tabs","These tabs allow the user to estimate rate impacts from hypothetical revenue requirement changes relative to current rates."]
[]
[null,"*IMPORTANT NOTE:","CRT model uses current year CRT-calculated rates for comparison with future rates. For Hypothetical tabs, CRT uses current rates."]

{"sheet":"Summary","index":1,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,11,79,12],[70,13,70,14],[70,15,70,16],[60,1,60,2],[39,11,39,12],[40,11,40,12],[41,11,41,12],[44,11,44,19],[48,1,48,2],[75,1,75,9],[73,1,73,2],[56,1,56,9],[58,1,58,2],[59,1,59,2],[50,1,50,9],[52,1,52,2],[32,13,32,14],[32,15,32,16],[44,1,44,9],[46,1,46,2],[47,1,47,2],[53,1,53,2],[54,1,54,2],[77,1,77,2],[79,1,79,2],[63,1,63,9],[65,1,65,2],[67,1,67,2],[69,1,69,9],[71,1,71,2],[29,1,29,2],[31,1,31,9],[33,1,33,2],[41,1,41,2],[34,1,34,2],[35,1,35,2],[37,1,37,9],[39,1,39,2],[40,1,40,2],[25,1,25,9],[27,1,27,2],[28,1,28,2],[25,11,25,19],[27,11,27,12],[28,11,28,12],[23,11,23,19],[20,1,20,2],[24,11,24,12],[21,1,21,2],[14,11,14,12],[20,11,20,12],[21,11,21,12],[19,11,19,19],[22,1,22,2],[22,11,22,12],[19,1,19,9]]}
[null,"Inputs:",null,null,null,null,"Assumptions:"]
[null,null,{"$f":"CONCATENATE(\"Rate Impact for Year (\",SetUp!J5,\"-\",SetUp!J9,\")\")","v":"Rate Impact for Year (2024-2028)"},2024,null,null,"Current Effective Rates",null,{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"}]
[null,null,"Baseline Region - (Residential bill)",1,null,null,"Sales Forecast",null,2024]
[null,null,null,null,null,null,"Residential bill calculated using ",null,"Schedule GR, Basic, Bundled, Single Family"]
[null,null,null,null,null,null,"Non-CARE bill impact calculated with average summer usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Res Bill Impact'!Q22:Q25,'Res Bill Impact'!U22:U25),VLOOKUP($D$3,'Res Bill Impact'!$P$22:$T$25,2,FALSE))","v":23.702733811833337},"therms per month"]
[null,"Pending Proceedings",null,"Include in Impact (Y)","Applicable Year(s)",null,"Non-CARE bill impact calculated with average winter usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Res Bill Impact'!R22:R25,'Res Bill Impact'!U22:U25),VLOOKUP(D$3,'Res Bill Impact'!$P$22:$T$25,3,FALSE))","v":50.815830623000004},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A100","v":"2024 GRC Application"},null,"Y","2024-2027",null,"CARE bill impact calculated with average summer usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Res Bill Impact'!S22:S25,'Res Bill Impact'!V22:V25),VLOOKUP($D$3,'Res Bill Impact'!$P$22:$T$25,4,FALSE))","v":17.651984122333332},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A101","v":"Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission "},null,"Y","2024-2027",null,"CARE bill impact calculated with average winter usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Res Bill Impact'!T22:T25,'Res Bill Impact'!V22:V25),VLOOKUP($D$3,'Res Bill Impact'!$P$22:$T$25,5,FALSE))","v":36.094967588500005},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A102","v":"Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution"},null,"Y","2024-2027",null,"Average monthly usage is for all customers (Non-CARE and CARE) based on seasonal usage in",null,null,null,null,2024]
[null,{"$f":"'Incremental Rev Req'!A103","v":"NonCore Backbone Transmission"},null,"Y","2024-2027",null,"Summer season",null,6,"months"]
[null,{"$f":"'Incremental Rev Req'!A105","v":"Catastrophic Event Memorandum Account (CEMA) "},null,"Y",2025,null,"Winter Season",null,{"$f":"12-I10","v":6},"months"]
[null,{"$f":"'Incremental Rev Req'!A114","v":" Cost Allocation Proceeding"},null,"Y","2024-2026"]
[null,{"$f":"'Incremental Rev Req'!A104","v":"TIMPBA"},null,"Y",2025]
[null,{"$f":"'Incremental Rev Req'!A106","v":"COVID-19 Pandemic Protections Memorandum Account (CPPMA)"},null,"Y",2025]
[null,{"$f":"'Incremental Rev Req'!A107","v":"DIMPBA"},null,"Y",2025]
[]
[]
[null,"Outputs:"]
[null,null,null,"(A)","(B)","(C)","(D)","(D)/(A)","(D)/(B)","(D)/(C)",null,null,null,"(A)","(B)","(C)","(D)","(D)/(A)","(D)/(B)","(D)/(C)"]
[null,"Bundled Average Rates - ¢/therm",null,null,null,null,null,null,null,null,null,"Total System (Bundled and Unbundled) Average Rates - ¢/th"]
[null,"Customer Group",null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized",null,"Customer Group",null,{"$f":"$D$21","v":"2024-01-01"},{"$f":"$E$21","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"$H$21","v":"% Change over 1/1/2024"},{"$f":"$I$21","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Residential",null,182.54822985904045,{"$f":"'SAR and RAR'!G28","v":183.54860424771815},{"$f":"'SAR and RAR'!H28","v":183.54860424771815},{"$f":"'SAR and RAR'!I28","v":221.50212126558318},{"$f":"$G22/D22-1","v":0.21338958716073031},{"$f":"$G22/E22-1","v":0.2067763858702123},{"$f":"$G22/F22-1","v":0.2067763858702123},null,"Total Residential (RAR)",null,181.939919315239,{"$f":"'SAR and RAR'!R28","v":182.94781646772972},{"$f":"'SAR and RAR'!S28","v":182.94781646772972},{"$f":"'SAR and RAR'!T28","v":220.90133348559471},{"$f":"$Q22/N22-1","v":0.21414439622152992},{"$f":"$Q22/O22-1","v":0.20745542499852476},0.20745542499852476]
[null,"System",null,103.83913742756327,{"$f":"'SAR and RAR'!G29","v":105.53707065695139},{"$f":"'SAR and RAR'!H29","v":105.53707065695139},{"$f":"'SAR and RAR'!I29","v":118.7530198777354},{"$f":"$G23/D23-1","v":0.14362486842281252},0.12522565898898685,{"$f":"$G23/F23-1","v":0.12522565898898685},null,"Total System (SAR)",null,74.380566627862052,{"$f":"'SAR and RAR'!R29","v":76.078499857250165},{"$f":"'SAR and RAR'!S29","v":76.078499857250165},{"$f":"'SAR and RAR'!T29","v":89.294449078034191},0.2005077821575183,0.17371464008335824,0.17371464008335824]
[]
[]
[null,"Basic Bundled Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Non-CARE",null,{"$f":"((D34*$I$10)+(D40*$I$11))/12","v":71.782130432141358},{"$f":"((E34*$I$10)+(E40*$I$11))/12","v":72.178979528656214},72.17779549396856,87.233712054340629,{"$f":"$G28/D28-1","v":0.21525665968922869},0.20857502591467703,0.20859485188391758]
[null,"CARE",null,{"$f":"((D35*$I$10)+(D41*$I$11))/12","v":39.353319339651527},39.563361967385994,39.560643395889024,47.52890676072419,0.20774835663824476,0.2013363980519296,0.20141895279850774]
[null,"Total",null,{"$f":"((D36*$I$10)+(D42*$I$11))/12","v":63.767436129783967},64.118116505012452,64.116553213638895,77.420775161422782,0.21411146284524563,0.2074711389154793,0.20750057950641376,null,null,{"$f":"'Res Bill Impact'!P18","v":"Basic Bundled"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P19","v":"2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"Basic Bundled Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized",null,null,null,"Non-CARE",null,"CARE"]
[null,"Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$C$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,2,FALSE)))","v":48.794182415691623},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,4,FALSE)))","v":49.054431256037091},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,6,FALSE)))","v":49.058247509290524},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,8,FALSE)))","v":58.932765487857665},{"$f":"$G34/D34-1","v":0.2077826201859998},{"$f":"$G34/E34-1","v":0.20137496203474692},{"$f":"$G34/F34-1","v":0.20128150677818502},null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!Q22","v":23.702733811833337},{"$f":"'Res Bill Impact'!R22","v":50.815830623000004},{"$f":"'Res Bill Impact'!S22","v":17.651984122333332},{"$f":"'Res Bill Impact'!T22","v":36.094967588500005}]
[null,"CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$C$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,2,FALSE)))","v":28.310025131812829},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,4,FALSE)))","v":28.454461792934072},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,6,FALSE)))","v":28.456470376369062},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,8,FALSE)))","v":33.936748481198279},{"$f":"$G35/D35-1","v":0.19875373911493033},{"$f":"$G35/E35-1","v":0.19266878875303806},0.19258460491924434,null,null,2,{"$f":"'Res Bill Impact'!Q23","v":19.992271593666668},{"$f":"'Res Bill Impact'!R23","v":57.296892826166669},{"$f":"'Res Bill Impact'!S23","v":18.340279621499999},{"$f":"'Res Bill Impact'!T23","v":53.477491469500002}]
[null,"Total",null,{"$f":"D34*(1-'SAR and RAR'!$AC$15)+D35*'SAR and RAR'!$AC$15","v":43.731577493067213},{"$f":"E34*(1-'SAR and RAR'!$AC$15)+E35*'SAR and RAR'!$AC$15","v":43.963203661729636},{"$f":"F34*(1-'SAR and RAR'!$AC$15)+F35*'SAR and RAR'!$AC$15","v":43.966573154201335},{"$f":"G34*(1-'SAR and RAR'!$AC$15)+G35*'SAR and RAR'!$AC$15","v":52.755066450001266},{"$f":"$G36/D36-1","v":0.20633806220149609},0.19998230465458611,0.19989034089549285,null,null,3,{"$f":"'Res Bill Impact'!Q24","v":22.172026694500001},{"$f":"'Res Bill Impact'!R24","v":81.479840450333327},{"$f":"'Res Bill Impact'!S24","v":25.090080402166667},{"$f":"'Res Bill Impact'!T24","v":88.999667575999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q25","v":0},{"$f":"'Res Bill Impact'!R25","v":0},{"$f":"'Res Bill Impact'!S25","v":0},{"$f":"'Res Bill Impact'!T25","v":0}]
[null,"Basic Bundled Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$D$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,3,FALSE)))","v":94.770078448591093},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,5,FALSE)))","v":95.303527801275337},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,7,FALSE)))","v":95.297343478646582},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,9,FALSE)))","v":115.53465862082358},{"$f":"$G40/D40-1","v":0.21910481147798588},{"$f":"$G40/E40-1","v":0.21228102764184875},0.21235969863852078]
[null,"CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$D$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,3,FALSE)))","v":50.396613547490226},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,5,FALSE)))","v":50.672262141837912},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,7,FALSE)))","v":50.664816415408986},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,9,FALSE)))","v":61.121065040250095},0.21280103439200126,0.20620360048589692,0.20638086476241502]
[null,"Total",null,{"$f":"D40*(1-'SAR and RAR'!$AC$15)+D41*'SAR and RAR'!$AC$15","v":83.803294766500727},{"$f":"E40*(1-'SAR and RAR'!$AC$15)+E41*'SAR and RAR'!$AC$15","v":84.273029348295267},{"$f":"F40*(1-'SAR and RAR'!$AC$15)+F41*'SAR and RAR'!$AC$15","v":84.266533273076462},{"$f":"G40*(1-'SAR and RAR'!$AC$15)+G41*'SAR and RAR'!$AC$15","v":102.08648387284428},0.21816790327021862,0.21137788284466552,0.21147126750806278]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D53*$I$10)+(D59*$I$11))/12","v":46.552093858440536},{"$f":"((E53*$I$10)+(E59*$I$11))/12","v":46.799003070386966},46.785803334089628,56.150409228653359,{"$f":"$G47/D47-1","v":0.20618439633242236},0.19982062746511131,0.20015913433595744]
[null,"Essential Use - CARE",null,{"$f":"((D54*$I$10)+(D60*$I$11))/12","v":36.349332486555681},36.541524272684157,36.536332853280101,43.826793028371327,0.2057110827160662,0.19936959118952569,0.19954000869128596]
[null,"Total",null,{"$f":"D47*(1-'SAR and RAR'!$AC$15)+D48*'SAR and RAR'!$AC$15","v":44.030508555718939},{"$f":"E47*(1-'SAR and RAR'!$AC$15)+E48*'SAR and RAR'!$AC$15","v":44.263894501589036},{"$f":"F47*(1-'SAR and RAR'!$AC$15)+F48*'SAR and RAR'!$AC$15","v":44.252673999485417},{"$f":"G47*(1-'SAR and RAR'!$AC$15)+G48*'SAR and RAR'!$AC$15","v":53.104660303010093},{"$f":"$G49/D49-1","v":0.2060878251226228},{"$f":"$G49/E49-1","v":0.19972860275780024},0.20003280035976156]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!H19","v":"Essential Usage"}]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,null,null,null,"Monthly Tier 1 Baseline Allowance -BASIC (th)"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized",null,null,"Climate Zone","Summer 2021","Winter 2021"]
[null,"Essential Use  - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!C67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,2,FALSE)))","v":26.463995503035509},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":26.591538009868763},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":26.584719603039677},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,8,FALSE)))","v":31.422065694271271},{"$f":"$G53/D53-1","v":0.18735153543489136},{"$f":"$G53/E53-1","v":0.18165657370437849},{"$f":"$G53/F53-1","v":0.18195964311312496},null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!I22","v":13},{"$f":"'Res Bill Impact'!J22","v":37.333333333333336}]
[null,"Essential Use - CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!C77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,2,FALSE)))","v":20.710251218220815},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":20.809529094499101},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":20.806847434144686},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,8,FALSE)))","v":24.57278050472161},{"$f":"$G54/D54-1","v":0.18650325608327512},0.18084269918521634,0.18099489038387007,null,null,2,{"$f":"'Res Bill Impact'!I23","v":13},{"$f":"'Res Bill Impact'!J23","v":42.166666666666664}]
[null,"Total",null,{"$f":"D53*(1-'SAR and RAR'!$AC$15)+D54*'SAR and RAR'!$AC$15","v":25.041972925482384},{"$f":"E53*(1-'SAR and RAR'!$AC$15)+E54*'SAR and RAR'!$AC$15","v":25.16252990414376},{"$f":"F53*(1-'SAR and RAR'!$AC$15)+F54*'SAR and RAR'!$AC$15","v":25.156733883189577},{"$f":"G53*(1-'SAR and RAR'!$AC$15)+G54*'SAR and RAR'!$AC$15","v":29.729283099579799},{"$f":"$G55/D55-1","v":0.18717815038158081},{"$f":"$G55/E55-1","v":0.18149022426731376},0.18176243536311065,null,null,3,{"$f":"'Res Bill Impact'!I24","v":13},{"$f":"'Res Bill Impact'!J24","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Res Bill Impact'!I25","v":0},{"$f":"'Res Bill Impact'!J25","v":0}]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!D67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,3,FALSE)))","v":66.640192213845566},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":67.006468130905176},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":66.986887065139584},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,9,FALSE)))","v":80.87875276303545},{"$f":"$G59/D59-1","v":0.21366325750530457},{"$f":"$G59/E59-1","v":0.207029037928534},{"$f":"$G59/F59-1","v":0.20738186690757998}]
[null,"Essential Use - CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!D77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,3,FALSE)))","v":51.988413754890544},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":52.273519450869216},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":52.265818272415515},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,9,FALSE)))","v":63.08080555202104},{"$f":"$G60/D60-1","v":0.21336276673929166},0.20674494877486427,0.20692275825926143]
[null,"Total",null,{"$f":"D59*(1-'SAR and RAR'!$AC$15)+D60*'SAR and RAR'!$AC$15","v":63.019044185955494},{"$f":"E59*(1-'SAR and RAR'!$AC$15)+E60*'SAR and RAR'!$AC$15","v":63.365259099034319},{"$f":"F59*(1-'SAR and RAR'!$AC$15)+F60*'SAR and RAR'!$AC$15","v":63.348614115781267},{"$f":"G59*(1-'SAR and RAR'!$AC$15)+G60*'SAR and RAR'!$AC$15","v":76.480037506440368},0.21360199118165624,0.20697111625328968,0.20728825048420174]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"5-Year Average Usage- Non-CARE",null,{"$f":"((D72*$I$10)+(D78*$I$11))/12","v":71.08007821361609},{"$f":"((E72*$I$10)+(E78*$I$11))/12","v":71.472755075647669},71.471236691465606,86.368786565861001,{"$f":"$G66/D66-1","v":0.21509132708461487},0.20841552105340266,0.20844119346509515]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D73*$I$10)+(D79*$I$11))/12","v":39.232804368590521},39.442131106255168,39.43951528896924,47.380641318492472,{"$f":"$G67/D67-1","v":0.20767918788963868},{"$f":"$G67/E67-1","v":0.20126980945454864},{"$f":"$G67/F67-1","v":0.2013494834137648}]
[null,"Total",null,{"$f":"((D74*$I$10)+(D80*$I$11))/12","v":63.20910929331378},63.55647166037641,63.55468204852523,76.732970294880488,0.21395430425717543,0.20731954260951868,0.20735353905623155,null,null,{"$f":"'Res Bill Impact'!P27","v":"Typical Bundled"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P28","v":"2019-2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"Basic Bundled Typical Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized",null,null,null,"Non-CARE",null,"CARE"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!C87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,2,FALSE)))","v":47.768627939641547},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":48.022782000088128},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":48.02610983722164},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,8,FALSE)))","v":57.669286528951517},{"$f":"$G72/D72-1","v":0.20726277928308989},0.20087350476375332,0.2007902935385395,null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!Q31","v":23.211191282000001},{"$f":"'Res Bill Impact'!R31","v":50.634393741933337},{"$f":"'Res Bill Impact'!S31","v":17.783303916800001},{"$f":"'Res Bill Impact'!T31","v":35.740555869799998}]
[null,null,"5-Year Average Usage - CARE",{"$f":"IF($D$3=\"All\",'Res Bill Impact'!C97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,2,FALSE)))","v":28.524557409241474},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":28.670268847358507},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":28.672409830611343},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,8,FALSE)))","v":34.201081788820716},{"$f":"$G73/D73-1","v":0.19900481883516075},{"$f":"$G73/E73-1","v":0.1929110944479957},{"$f":"$G73/F73-1","v":0.19282201917701491},null,null,2,{"$f":"'Res Bill Impact'!Q32","v":19.588177982433333},{"$f":"'Res Bill Impact'!R32","v":56.62928825223333},{"$f":"'Res Bill Impact'!S32","v":18.883067259899999},{"$f":"'Res Bill Impact'!T32","v":53.10374031206667}]
[null,"Total",null,{"$f":"D72*(1-'SAR and RAR'!$AC$15)+D73*'SAR and RAR'!$AC$15","v":43.012507155741439},{"$f":"E72*(1-'SAR and RAR'!$AC$15)+E73*'SAR and RAR'!$AC$15","v":43.23985991086608},{"$f":"F72*(1-'SAR and RAR'!$AC$15)+F73*'SAR and RAR'!$AC$15","v":43.242894420223621},{"$f":"G72*(1-'SAR and RAR'!$AC$15)+G73*'SAR and RAR'!$AC$15","v":51.86918222414576},0.20590929601791674,0.19956869266154009,0.19948451461398564,null,null,3,{"$f":"'Res Bill Impact'!Q33","v":20.927596488166667},{"$f":"'Res Bill Impact'!R33","v":79.119626847833331},{"$f":"'Res Bill Impact'!S33","v":25.945455275366669},{"$f":"'Res Bill Impact'!T33","v":90.095995849833329}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q34","v":0},{"$f":"'Res Bill Impact'!R34","v":0},{"$f":"'Res Bill Impact'!S34","v":0},{"$f":"'Res Bill Impact'!T34","v":0}]
[null,"Basic Bundled Typical Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2024"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Res Bill Impact'!D87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,3,FALSE)))","v":94.39152848759062},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":94.922728151207224},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":94.916363545709586},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,9,FALSE)))","v":115.0682866027705},{"$f":"$G78/D78-1","v":0.21905311256717486},0.21223113625087131,0.21231242226590563]
[null,null,"5-Year Average Usage - CARE",{"$f":"IF($D$3=\"All\",'Res Bill Impact'!D97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,3,FALSE)))","v":49.941051327939576},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":50.213993365151822},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":50.206620747327143},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,9,FALSE)))","v":60.560200848164222},{"$f":"$G79/D79-1","v":0.21263367986576109},{"$f":"$G79/E79-1","v":0.20604231588943089},{"$f":"$G79/F79-1","v":0.20621941781230668}]
[null,"Total",null,{"$f":"D78*(1-'SAR and RAR'!$AC$15)+D79*'SAR and RAR'!$AC$15","v":83.405711430886129},{"$f":"E78*(1-'SAR and RAR'!$AC$15)+E79*'SAR and RAR'!$AC$15","v":83.873083409886732},{"$f":"F78*(1-'SAR and RAR'!$AC$15)+F79*'SAR and RAR'!$AC$15","v":83.866469676826839},{"$f":"G78*(1-'SAR and RAR'!$AC$15)+G79*'SAR and RAR'!$AC$15","v":101.59675836561523},0.2181031325391074,0.21131540936814153,0.2114109340372945]

{"sheet":"Authorized Rev Req","index":2,"n_rows":109,"n_cols":12,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Period 2024"]
["Reporting Date: Quarter Ended December 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01","2024-01-01","2024-07-01","2024-10-01"]
[null,"Advice Letter:","AL 5915-G","AL 6071-G","AL 6088-G","AL 6168-G","AL 6213-G","AL 6237-G","AL 6325-G","AL 6369-G"]
["Filing Description","Authority for Revenue Requirement as of 7/1/2024","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051",2797438.8098034845,2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2799938722,2828192.7647602689,2827790.6008280008,2827790.6008280008,"Allocated Base Margin","N"]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)","D.19-09-051",20025.239099999992,20972.15159999999,20972.15159999999,20972.15159999999,20972.15159999999,20972.15159999999,20972.15159999999,20972.15159999999,"Local Transmission","N"]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)","D.19-09-051",28629.010000000009,29982.760000000006,29982.760000000006,29982.760000000006,29982.760000000006,29982.760000000006,29982.760000000006,29982.760000000006,"Distribution","N"]
["  Company Use Gas: Other","D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325",1792.6929208784113,2442.7824068004993,2442.7824068004993,2442.7824068004993,2442.7824068005002,2021.5178140390128,2086.3596441268455,2086.3596441268455,"ECPT","N"]
["  Company Use Gas: Storage Load Balancing","D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325",1739.9823775441146,2371.288817256519,2371.288817256519,2371.288817256519,2371.2888172565199,1962.3534920550317,2025.2975783353625,2025.2975783353625,"ECPT","N"]
["  Exchange Revenues & Interutility Transactions","D.20-02-045 AL 6071, AL 6045, AL 6210",342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,"ECPT","N"]
["  Unaccounted For (UAF) Gas","D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325",43865.640785688673,59771.786676696618,59771.786676696618,59771.786676696618,59771.786676696633,49463.976491521389,51050.573817974575,51050.573817974575,"47% Res (LUAF, Other)","N"]
["  Well Incidents & Surface Leaks","D.20-02-045 AL 6071, AL 6045, AL 6210",226.38915428249578,308.48434647250184,308.48434647250184,308.48434647250184,308.48434647250201,255.28536639623627,263.47385241244478,263.47385241244478,"ECPT","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045 AL 6071, AL 6045, AL 6210",381.0924643613892,363.84340064715622,363.84340064715622,363.84340064715622,363.84340064715622,373.23910182592897,373.23910182592897,373.23910182592891,"Local Transmission","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution","D.20-02-045 AL 6071, AL 6045, AL 6210",24839.85662656404,24959.799583904292,24959.799583904292,24959.799583904292,24959.799583904292,25796.911065795495,25796.911065795503,25796.911065795503,"Distribution","N"]
["AMI Balancing Account  (AMIBA)","D.20-02-045 AL 6071, AL 6045, AL 6210",-77756.901095456211,-323.97185928908709,-323.97185928908709,-323.97185928908709,-323.97185928908709,0,0,0,"EPAM","Y"]
["Residential Uncollectible Balancing Account  (RUBA) ","D.20-02-045 AL 6071, AL 6045, AL 6210",16080.829230363346,44745.198352024141,44745.198352024141,44745.198352024141,44745.198352024141,361045.45629300445,361045.45629300445,361045.45629300445,"ECPT","Y"]
["Affiliate Transfer Fee Account  (ATFA)","D.20-02-045 AL 6071, AL 6045, AL 6210",-56.852117204809616,-106.52167417156562,-106.52167417156562,-106.52167417156562,-106.52185926498186,-332.51517351882774,-332.51517193329846,-332.51517193329846,"EPAM","Y"]
["Core Fixed Cost Account - Non NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",-28133.81894370247,121885.43655903419,-12481.017073574887,-12481.017073574887,-15934.575731573012,-159234.4339632123,-159234.4339632123,-159234.4339632123,"CFCA","Y"]
["Core Fixed Cost Account - NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",9826.72414135078,-1151.9897406335253,-1401.3020835172681,-1401.3020835172681,-1401.3020835172681,-6384.867245124733,-6384.867245124733,-6384.867245124733,"Non-Residential","Y"]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",28765.692761009646,0,0,0,0,0,0,0,"Non-Residential","Y"]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)","D.20-02-045 AL 6071, AL 6045, AL 6210",395.85348400076731,434.22738384292143,434.22738384292143,434.22738384292143,434.22738384292143,623.91417663694745,623.91417663694745,623.91417663694745,"Non-Residential","Y"]
["Enhanced Oil Recovery Account  (EORA)  ","D.20-02-045 AL 6071, AL 6045, AL 6210",2530.5597398430609,-7124.2567864552111,-7124.2567864552111,-7124.2567864552111,-7124.2691656544375,9594.3896797095258,9594.3896339606781,9594.3896339606781,"EPAM","Y"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)","D.20-02-045 AL 6071, AL 6045, AL 6210",284.26278995019351,441.06566541085317,441.06566541085317,441.06566541085317,441.06566541085317,2438.2408158617095,2438.2408158617095,2438.2408158617095,"ECPT","Y"]
["Intervenor Award Memorandum Account  (IAMA)","D.20-02-045 AL 6071, AL 6045, AL 6210",731.58066503521957,832.93717869704278,832.93717869704278,832.93717869704278,832.93717869704278,435.57870822027792,435.57870822027792,435.57870822027792,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045 AL 6071, AL 6045, AL 6210",17468.470311041361,24824.504625728128,24824.504625728128,24824.504625728128,24824.547761103186,27664.398592009951,27664.398460098037,27664.398460098037,"EPAM","Y"]
["Noncore Fixed Cost Account  (NFCA)  Margin","D.20-02-045 AL 6071, AL 6045, AL 6210",6370.1809775920838,12427.604012052685,12427.604012052685,12427.604012052685,12427.834050448922,6309.9682501879579,6309.9680673442781,6309.9680673442781,"Non-Residential","Y"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin","D.20-02-045 AL 6071, AL 6045, AL 6210",-3275.1851982978651,959.63192651874249,959.63192651874249,959.63192651874249,-11436.667024366332,913.70340598259429,913.70340598259429,913.70340598259429,"Non-Residential","Y"]
["Integrated Transmission Balancing Account  (ITBA) Margin","D.20-02-045, AL 6071, AL 6045, AL 6210",176.09814139595812,5083.8850590894772,5083.8850590894772,5083.8850590894772,5083.8850590894772,-2088.9106059958776,-2088.9106059958776,-2088.9106059958776,"ECPT","Y"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-1423.0358831880883,3459.772548454087,3459.772548454087,3459.772548454087,3459.772548454087,5089.7942028112566,5089.7942028112566,5089.7942028112566,"ECPT","Y"]
["Compression Services Balancing Account  (CSBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-68.369488844234169,-73.636852931578687,-73.636852931578687,-73.636852931578687,-73.636852931578687,0,0,0,"Non-Residential","Y"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-1168.4484408377084,5918.6872446137231,5918.6872446137231,5918.6872446137231,5918.6872446137231,12182.449387643102,12182.449387643102,12182.449387643102,"ECPT","Y"]
["Noncore Storage Balancing Account  (NSBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",122.05121759349339,93.946777408666094,93.946777408666094,93.946777408666094,93.946777408666094,0,0,0,"ECPT","Y"]
["Pension Balancing Account  (PBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",11312.644088682704,9235.9689255481535,9235.9689255481535,9235.9689255481535,9235.9849740852605,23408.247268413917,23408.247156796577,23408.247156796577,"EPAM","Y"]
["PBOP Balancing Account  (PBOPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-4328.4227973909083,-4765.7902742977731,-4765.7902742977731,-4765.7902742977731,-4765.7985553955832,-1010.3988927540598,-1010.3988879361832,-1010.3988879361832,"EPAM","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210",22874.176540558052,24483.535529249115,24483.535529249115,24483.535529249115,24483.535529249115,25945.72456347875,25945.72456347875,25945.72456347875,"Local Transmission","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6210",72521.186822647796,74787.023820241564,74787.023820241564,74787.023820241564,74787.023820241564,78908.462504203519,78908.462504203519,78908.462504203519,"Distribution","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210",572.09798322721713,-674.07808819608886,-674.07808819608886,-674.07808819608886,-674.07808819608886,-305.13476405558407,-305.13476405558407,-305.13476405558407,"Local Transmission","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6210",1611.907471579721,2206.0867435845412,2206.0867435845412,2206.0867435845412,2206.0867435845412,402.79583157444125,402.79583157444125,402.79583157444125,"Distribution","Y"]
["Research Royalty Memorandum Account  (RRMA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-160.82445015363919,-247.95082320763703,-247.95082320763703,-247.95082320763703,-247.9512540501419,-157.27504476026635,-157.27504401033312,-157.27504401033312,"EPAM","Y"]
["Self-Generation Program Memorandum Account  (SGPMA)","D.20-02-045, AL 6071, AL 6045, AL 6210",16267.798190288335,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,"SGIP","Y"]
["System Operator Gas Account  (SOGA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-57.474724884945573,-54.791024656889135,-54.791024656889135,-54.791024656889135,-54.791024656889135,0,0,0,"ECPT","Y"]
["Rewards & Penalties Balancing Account (RPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-266.7671576355873,-288.87206106860225,-288.87206106860225,-288.87206106860225,-288.87256301637063,7370.2338338696845,7370.2337987262608,7370.2337987262608,"EPAM","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",14313.748177749801,23349.855935962783,23349.855935962783,23349.855935962783,23349.896508969519,24061.231562666457,24061.231447935483,24061.231447935483,"EPAM","Y"]
["NonCore Backbone Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210, AL6325, AL 6325-G",205899.09902636753,307036.37711891095,307036.37711891095,307036.37711891095,307036.37711891095,302321.96641038521,403718.61343722232,403718.61343722232,"Backbone Transmission","N"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance","D.22-07-016, AL 6023, AL 6045, AL 6210",0,35607.3666859636,35607.3666859636,35607.3666859636,35607.428557776948,0,0,0,"EPAM","Y"]
["On-Bill Financing Balancing Account (OBFBA)","D.19-03-001, AL 5853-A",0,4574.3633340208544,4574.3633340208544,4574.3633340208544,4574.3712824927779,0,0,0,"EPAM","Y"]
["System Reliability Memorandum Account   (SRMA)","D.20-02-045, AL 6045, AL 6210",0,15184.322292874704,15184.322292874704,15184.322292874704,15184.322292874704,32096.064218294516,32096.064218294516,32096.064218294516,"ECPT","Y"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ","D.20-02-045, AL 6045, AL 6210",0,-61.478426684054938,-61.478426684054938,-61.478426684054938,-61.478533509751273,0,0,0,"EPAM","Y"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)","D.20-02-045, AL 6210",0,0,0,0,0,573.80824116959502,573.80824116959502,573.80824116959502,"ECPT","Y"]
["Transmission Integrity Management Program Memorandum Account  (TIMPBA)  Local Transmission","AL 6325-G",0,0,0,0,0,0,56339.323056636218,56339.323056636218,"Local Transmission","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C9:C52)","v":3230710.3526054835},{"$f":"SUM(D9:D55)","v":3673812.4421397415},3539196.6761642485,3539196.6761642485,3523347.1944171903,3727501.6552862898,{"$f":"SUM(I9:I55)","v":3886558.0325514893},{"$f":"SUM(J9:J55)","v":3886558.0325514893}]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",5107.0718943636321,5106.2014202040336,5106.2014202040336,5106.2014202040336,5106.2014202040336,5106.2014202040336,5106.2014202040336,5106.2014202040336,"ECPT adjusted","N"]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",2676.4558822098343,2388.5750957260152,2388.5750957260152,2388.5750957260152,2388.5750957260152,2684.1598286442622,2684.1598286442622,2684.1598286442622,"ECPT","N"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",421911.65593735001,451660.15168836701,451660.15168836701,451660.15168836701,451660.15168836701,659841.41913136793,659841.41913136793,659841.41913136793,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",11523.700831049478,11338.595126925329,11338.595126925329,11338.595126925329,11338.595126925329,14890.288905538293,14890.288905538293,14890.288905538293,"47% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.22-07-016, AL 6023, AL 6045, AL 6210",110.10687339904621,-783.15163590176303,-783.15163590176303,-783.15163590176303,-783.15163590176303,-2420.193064735909,-2420.193064735909,-2420.193064735909,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.22-07-016, AL 6023, AL 6045, AL 6210",24082.112323034682,-22703.373092980601,-22703.373092980601,-22703.373092980601,-22703.373092980601,85564.855171911244,85564.855171911244,85564.855171911244,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.22-07-016, AL 6023, AL 6045, AL 6210",96.161475841515269,3057.4967008465737,3057.4967008465737,3057.4967008465737,3057.4967008465737,-7155.0303898461352,-7155.0303898461352,-7155.0303898461352,"47% Res (LUAF, Other)","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount","D.22-07-016, AL 6023, AL 6045, AL 6210",3566.9058998494452,5564.3922693223831,5564.3922693223831,5564.3922693223831,5564.3922693223831,8886.0215302670767,8886.0215302670767,8886.0215302670767,"ECPT adjusted","Y"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ","D.22-07-016, AL 6023, AL 6045, AL 6210",1979.7078861701277,6090.186376418309,6090.186376418309,6090.186376418309,6090.1969588036363,8805.7593683541018,8805.7593263656763,8805.7593263656763,"EPAM","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ","D.22-07-016, AL 6023, AL 6045, AL 6210",-2147.5120170099681,0,0,0,0,0,0,0,"EPAM","Y"]
["TLS Adjustment","D.22-07-016, AL 6023, AL 6045, AL 6210",-6644.931817014658,10390.216028451658,10421.053586768947,10394.546129042021,10191.858650344628,8841,8840.8383313910454,9275.9915557850618,"Non-Residential","N"]
["  Natural Gas Leak Abatement Program Revenue Requirement","AL 5915G, AL 6071, AL 6168-G, AL 5950-G-B",86446.464722770907,86431.165118197561,86431.165118197561,107531.46426397371,107531.65111201403,104496.82835282681,104898.97716773154,104898.97716773154,"EPAM","N"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ","D. 13-12-040, AL 6071, AL 6045, AL 6210",-48.669674355202922,0,0,0,0,0,0,0,"EPAM","Y"]
["Diary Biomethane Project Balancing Account  (DBPBA)","D. 17-12-004, AL 6071, AL 6045, AL 6210",45457.032564324829,34573.344052610402,34573.344052610402,34573.344052610402,34573.404127692869,1209.1955164650758,1209.1955106992791,1209.1955106992791,"EPAM","Y"]
["Diary Biomethane Project Memorandum Account  (DBPMA)","D. 17-12-004, AL 6071, AL 6045, AL 6210",{"$f":"0","v":0},8114.6562580048067,8114.6562580048067,8114.6562580048067,8114.6703581347574,5125.9905405987492,5125.990516156533,5125.990516156533,"EPAM","Y"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)","D. 10-01-022, AL 6071, AL 6045, AL 6210",1411.3819701407706,1113.8604547746736,1113.8604547746736,1113.8604547746736,1113.8604547746736,1391.1079788304662,1391.1079788304662,1391.1079788304662,"ECPT adjusted","Y"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Administrative Costs Subaccount ","D. 22-02-025, AL 6210",0,0,0,0,0,237.04701141936164,237.04701028905242,237.04701028905242,"EPAM","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D.16-12-043/D.19-12-009, AL 6071, AL 6045, AL 6210",10172.083196372587,0,0,0,0,0,0,0,"ECPT","Y"]
[]
[]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) "," D.21-06-015, AL 6052, AL 6216",229388.13208047274,199514.89150131575,199514.89150131575,199514.89150131575,199514.89150131575,272251.15142222279,272251.15142222279,272251.15142222279,"Public Purpose Programs","N"]
["Energy Efficiency "," AL 6052, AL 6216, AL 6209",107144.935,166906.52600000001,166906.52600000001,166906.52600000001,166906.52600000001,165866.63928,165866.63928,165866.63928,"Public Purpose Programs","N"]
["RD&D"," AL 6052, AL 6216",12406.90965,12264.871999999999,12264.871999999999,12264.871999999999,12264.871999999999,11380.117797799039,11380.117797799039,11380.117797799039,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE"," AL 6052, AL 6216",547.65497000000005,520.25400000000002,520.25400000000002,520.25400000000002,520.25400000000002,476.44983000000002,476.44983000000002,476.44983000000002,"Public Purpose Programs","N"]
["Energy Savings Assistance "," D.21-06-015,  AL 6052, AL 6216",{"$f":"0","v":0},80174.204849890506,80174.204849890506,80174.204849890506,80174.204849890506,111508.29992653689,111508.29992653689,111508.29992653689,"Public Purpose Programs","N"]
["SJVDGPMA","AL 6052, AL 6216",{"$f":"0","v":0},806.16499999999996,806.16499999999996,806.16499999999996,806.16499999999996,90.978000000000208,90.978000000000208,90.978000000000208,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C60:C95)","v":955187.35964896996},{"$f":"SUM(D60:D95)","v":1062529.2292121728},1062560.06677049,1083633.8584585392,1083431.4425854799,1459078.2875584038,1459480.2746313729,1459915.4278557668]
[]
["EOR","D.20-02-045, AL 6045, AL ",-19696.026660334344,-25124.896599589265,-25124.896599589265,-25233.572656235308,-24742.548711656997,-32255.657450315099,-33347.396110484115,-33358.598503645662,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",{"$f":"TotalCoreVolume*SetUp!K11","v":2611619.0544005278},3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,1800955.4437626412,1800955.4437626412,{"$f":"TotalCoreVolume*SetUp!K5","v":1800955.4437626412},"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,{"$f":"SUM(C101:C106)","v":2611619.0544005278},3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,1800955.4437626412,1800955.4437626412,1800955.4437626412]
[]
["Total Authorized Revenue",null,{"$f":"C56+C96+C107+C98","v":6777820.739994647},8012237.0884902552,7877652.1600730792,7898617.2757044816,7883056.4020289434,6955279.7291570194,7113646.3548350194,7114070.305666252]

{"sheet":"Incremental Rev Req","index":3,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[6,0,6,10],[96,0,96,10],[133,0,134,10]]}
[]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2024"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended December 31"}]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!J109","v":7114070.305666252}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!J5","v":"2024-10-01"}]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)",null,null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028]
["Safety Affordability Reliability Proceedings",null,null,{"$f":"B6","v":"2024-10-01"},null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028,null,null,null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUMIF($E$10:$E$91,N9,$F$10:$F$91)","v":1800955.4437626412},{"$f":"SUMIF($E$10:$E$91,N9,$G$10:$G$91)","v":1800955.4437626412},{"$f":"SUMIF($E$10:$E$91,N9,$H$10:$H$91)","v":1800955.4437626412},{"$f":"SUMIF($E$10:$E$91,N9,$I$10:$I$91)","v":1800955.4437626412},{"$f":"SUMIF($E$10:$E$91,N9,$J$10:$J$91)","v":1800955.4437626412}]
[{"$f":"'Authorized Rev Req'!A9","v":"Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B9","v":"D.19-09-051"},{"$f":"F10","v":2827790.6008280008},{"$f":"'Authorized Rev Req'!K9","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!J9","v":2827790.6008280008},{"$f":"F10","v":2827790.6008280008},{"$f":"G10","v":2827790.6008280008},{"$f":"H10","v":2827790.6008280008},{"$f":"I10","v":2827790.6008280008},"Existing",null,null,"Allocated Base Margin",2827790.6008280008,2827790.6008280008,2827790.6008280008,2827790.6008280008,2827790.6008280008]
[{"$f":"'Authorized Rev Req'!A10","v":"Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B10","v":"D.19-09-051"},20972.15159999999,{"$f":"'Authorized Rev Req'!K10","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J10","v":20972.15159999999},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Distribution",135090.92940157346,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A11","v":"Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B11","v":"D.19-09-051"},29982.760000000006,{"$f":"'Authorized Rev Req'!K11","v":"Distribution"},{"$f":"'Authorized Rev Req'!J11","v":29982.760000000006},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"ECPT adjusted",15383.330929301577,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A12","v":"  Company Use Gas: Other"},null,{"$f":"'Authorized Rev Req'!B12","v":"D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325"},2086.3596441268455,{"$f":"'Authorized Rev Req'!K12","v":"ECPT"},{"$f":"'Authorized Rev Req'!J12","v":2086.3596441268455},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Local Transmission",103325.30355788532,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A13","v":"  Company Use Gas: Storage Load Balancing"},null,{"$f":"'Authorized Rev Req'!B13","v":"D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325"},2025.2975783353625,{"$f":"'Authorized Rev Req'!K13","v":"ECPT"},{"$f":"'Authorized Rev Req'!J13","v":2025.2975783353625},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"SGIP",16265.025427685592,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A14","v":"  Exchange Revenues & Interutility Transactions"},null,{"$f":"'Authorized Rev Req'!B14","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},342.77791000000002,{"$f":"'Authorized Rev Req'!K14","v":"ECPT"},{"$f":"'Authorized Rev Req'!J14","v":342.77791000000002},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"GHG End User",745406.27430327912,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A15","v":"  Unaccounted For (UAF) Gas"},null,{"$f":"'Authorized Rev Req'!B15","v":"D.20-02-045 AL 6071, AL 6045, AL 6210, AL 6325"},51050.573817974575,{"$f":"'Authorized Rev Req'!K15","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J15","v":51050.573817974575},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Public Purpose Programs",561573.6362565587,276818.17,276509.35600000003,153968.28599999999,0]
[{"$f":"'Authorized Rev Req'!A16","v":"  Well Incidents & Surface Leaks"},null,{"$f":"'Authorized Rev Req'!B16","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},263.47385241244478,{"$f":"'Authorized Rev Req'!K16","v":"ECPT"},{"$f":"'Authorized Rev Req'!J16","v":263.47385241244478},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Backbone Transmission",403718.61343722232,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A17","v":"SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B17","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},373.23910182592891,{"$f":"'Authorized Rev Req'!K17","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J17","v":373.23910182592891},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"47% Res (LUAF, Other)",58785.832333666731,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A18","v":"SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution"},null,{"$f":"'Authorized Rev Req'!B18","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},25796.911065795503,{"$f":"'Authorized Rev Req'!K18","v":"Distribution"},{"$f":"'Authorized Rev Req'!J18","v":25796.911065795503},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"ECPT",416754.35700979206,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"AMI Balancing Account  (AMIBA)"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K19","v":"EPAM"},{"$f":"'Authorized Rev Req'!J19","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"EPAM",177516.68242123362,49701.612944246554,49024.749769454305,52180.971312539885,51764.669645427013]
[{"$f":"'Authorized Rev Req'!A20","v":"Residential Uncollectible Balancing Account  (RUBA) "},null,{"$f":"'Authorized Rev Req'!B20","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},361045.45629300445,{"$f":"'Authorized Rev Req'!K20","v":"ECPT"},{"$f":"'Authorized Rev Req'!J20","v":361045.45629300445},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"CFCA",-159234.4339632123,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"Affiliate Transfer Fee Account  (ATFA)"},null,{"$f":"'Authorized Rev Req'!B21","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},-332.51517193329846,{"$f":"'Authorized Rev Req'!K21","v":"EPAM"},{"$f":"'Authorized Rev Req'!J21","v":-332.51517193329846},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Non-Residential",10738.709960624148,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A22","v":"Core Fixed Cost Account - Non NGV  (CFCA) "},null,{"$f":"'Authorized Rev Req'!B22","v":"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210"},-159234.4339632123,{"$f":"'Authorized Rev Req'!K22","v":"CFCA"},{"$f":"'Authorized Rev Req'!J22","v":-159234.4339632123},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Total",{"$f":"SUM(O9:O22)","v":7114070.305666252},{"$f":"SUM(P9:P22)","v":4955265.8275348879},4954280.1503600953,4834895.3019031817,4680510.7142360685]
[{"$f":"'Authorized Rev Req'!A23","v":"Core Fixed Cost Account - NGV  (CFCA) "},null,{"$f":"'Authorized Rev Req'!B23","v":"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210"},-6384.867245124733,{"$f":"'Authorized Rev Req'!K23","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J23","v":-6384.867245124733},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3}]
[{"$f":"'Authorized Rev Req'!A24","v":"Core Fixed Cost Account - C&I   Shortfall (CFCA) "},null,{"$f":"'Authorized Rev Req'!B24","v":"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210"},0,{"$f":"'Authorized Rev Req'!K24","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J24","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing",null,null,"Check",{"$f":"O23-F92","v":0},{"$f":"P23-G92","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A25","v":"Economic Practicality Shortfall Memorandum Account  (EPSMA)"},null,{"$f":"'Authorized Rev Req'!B25","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},623.91417663694745,{"$f":"'Authorized Rev Req'!K25","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J25","v":623.91417663694745},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A26","v":"Enhanced Oil Recovery Account  (EORA)  "},null,{"$f":"'Authorized Rev Req'!B26","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},9594.3896339606781,{"$f":"'Authorized Rev Req'!K26","v":"EPAM"},{"$f":"'Authorized Rev Req'!J26","v":9594.3896339606781},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A27","v":"Hazardous Substance Cost-Recovery Account  (HSCRA)"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},2438.2408158617095,{"$f":"'Authorized Rev Req'!K27","v":"ECPT"},{"$f":"'Authorized Rev Req'!J27","v":2438.2408158617095},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A28","v":"Intervenor Award Memorandum Account  (IAMA)"},null,{"$f":"'Authorized Rev Req'!B28","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},435.57870822027792,{"$f":"'Authorized Rev Req'!K28","v":"ECPT"},{"$f":"'Authorized Rev Req'!J28","v":435.57870822027792},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A29","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},27664.398460098037,{"$f":"'Authorized Rev Req'!K29","v":"EPAM"},{"$f":"'Authorized Rev Req'!J29","v":27664.398460098037},33619.643028128216,33231.789826917317,36899.477637248048,36899.477637248048,"Existing"]
[{"$f":"'Authorized Rev Req'!A30","v":"Noncore Fixed Cost Account  (NFCA)  Margin"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},6309.9680673442781,{"$f":"'Authorized Rev Req'!K30","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J30","v":6309.9680673442781},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A31","v":"Noncore Fixed Cost Account  (NFCA)  Nonmargin"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.20-02-045 AL 6071, AL 6045, AL 6210"},913.70340598259429,{"$f":"'Authorized Rev Req'!K31","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J31","v":913.70340598259429},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A32","v":"Integrated Transmission Balancing Account  (ITBA) Margin"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},-2088.9106059958776,{"$f":"'Authorized Rev Req'!K32","v":"ECPT"},{"$f":"'Authorized Rev Req'!J32","v":-2088.9106059958776},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A33","v":"Compressor Station Fuel and Power Balancing Account (CFPBA)"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},5089.7942028112566,{"$f":"'Authorized Rev Req'!K33","v":"ECPT"},{"$f":"'Authorized Rev Req'!J33","v":5089.7942028112566},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A34","v":"Compression Services Balancing Account  (CSBA)"},null,{"$f":"'Authorized Rev Req'!B34","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K34","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J34","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A35","v":"Company-Use Fuel for Load Balancing Account (CUFLBA)"},null,{"$f":"'Authorized Rev Req'!B35","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},12182.449387643102,{"$f":"'Authorized Rev Req'!K35","v":"ECPT"},{"$f":"'Authorized Rev Req'!J35","v":12182.449387643102},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A36","v":"Noncore Storage Balancing Account  (NSBA)"},null,{"$f":"'Authorized Rev Req'!B36","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K36","v":"ECPT"},{"$f":"'Authorized Rev Req'!J36","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A37","v":"Pension Balancing Account  (PBA)"},null,{"$f":"'Authorized Rev Req'!B37","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},23408.247156796577,{"$f":"'Authorized Rev Req'!K37","v":"EPAM"},{"$f":"'Authorized Rev Req'!J37","v":23408.247156796577},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A38","v":"PBOP Balancing Account  (PBOPBA)"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},-1010.3988879361832,{"$f":"'Authorized Rev Req'!K38","v":"EPAM"},{"$f":"'Authorized Rev Req'!J38","v":-1010.3988879361832},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A39","v":"Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B39","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},25945.72456347875,{"$f":"'Authorized Rev Req'!K39","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J39","v":25945.72456347875},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A40","v":"Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution"},null,{"$f":"'Authorized Rev Req'!B40","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},78908.462504203519,{"$f":"'Authorized Rev Req'!K40","v":"Distribution"},{"$f":"'Authorized Rev Req'!J40","v":78908.462504203519},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A41","v":"Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B41","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},-305.13476405558407,{"$f":"'Authorized Rev Req'!K41","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J41","v":-305.13476405558407},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A42","v":"Safety Enhancement Expense Balancing Account (SEEBA) - Distribution"},null,{"$f":"'Authorized Rev Req'!B42","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},402.79583157444125,{"$f":"'Authorized Rev Req'!K42","v":"Distribution"},{"$f":"'Authorized Rev Req'!J42","v":402.79583157444125},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A43","v":"Research Royalty Memorandum Account  (RRMA)"},null,{"$f":"'Authorized Rev Req'!B43","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},-157.27504401033312,{"$f":"'Authorized Rev Req'!K43","v":"EPAM"},{"$f":"'Authorized Rev Req'!J43","v":-157.27504401033312},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A44","v":"Self-Generation Program Memorandum Account  (SGPMA)"},null,{"$f":"'Authorized Rev Req'!B44","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},16265.025427685592,{"$f":"'Authorized Rev Req'!K44","v":"SGIP"},{"$f":"'Authorized Rev Req'!J44","v":16265.025427685592},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A45","v":"System Operator Gas Account  (SOGA)"},null,{"$f":"'Authorized Rev Req'!B45","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K45","v":"ECPT"},{"$f":"'Authorized Rev Req'!J45","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A46","v":"Rewards & Penalties Balancing Account (RPBA)"},null,{"$f":"'Authorized Rev Req'!B46","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},7370.2337987262608,{"$f":"'Authorized Rev Req'!K46","v":"EPAM"},{"$f":"'Authorized Rev Req'!J46","v":7370.2337987262608},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A47","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B47","v":"D.20-02-045, AL 6071, AL 6045, AL 6210"},24061.231447935483,{"$f":"'Authorized Rev Req'!K47","v":"EPAM"},{"$f":"'Authorized Rev Req'!J47","v":24061.231447935483},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A48","v":"NonCore Backbone Transmission"},null,{"$f":"'Authorized Rev Req'!B48","v":"D.20-02-045, AL 6071, AL 6045, AL 6210, AL6325, AL 6325-G"},403718.61343722232,{"$f":"'Authorized Rev Req'!K48","v":"Backbone Transmission"},{"$f":"'Authorized Rev Req'!J48","v":403718.61343722232},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A49","v":"Storage Integrity Management Program Balancing Account (SIMPBA) Balance"},null,{"$f":"'Authorized Rev Req'!B49","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K49","v":"EPAM"},{"$f":"'Authorized Rev Req'!J49","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A50","v":"On-Bill Financing Balancing Account (OBFBA)"},null,{"$f":"'Authorized Rev Req'!B50","v":"D.19-03-001, AL 5853-A"},0,{"$f":"'Authorized Rev Req'!K50","v":"EPAM"},{"$f":"'Authorized Rev Req'!J50","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A51","v":"System Reliability Memorandum Account   (SRMA)"},null,{"$f":"'Authorized Rev Req'!B51","v":"D.20-02-045, AL 6045, AL 6210"},32096.064218294516,{"$f":"'Authorized Rev Req'!K51","v":"ECPT"},{"$f":"'Authorized Rev Req'!J51","v":32096.064218294516},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A52","v":"Distributed Energy Resources Svcs Bal Account  (DERSBA) "},null,{"$f":"'Authorized Rev Req'!B52","v":"D.20-02-045, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K52","v":"EPAM"},{"$f":"'Authorized Rev Req'!J52","v":0},0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A53","v":"Percentage of Income Payment Plan Balancing Account (PIPPBA)"},null,{"$f":"'Authorized Rev Req'!B53","v":"D.20-02-045, AL 6210"},{"$f":"F54","v":573.80824116959502},{"$f":"'Authorized Rev Req'!K53","v":"ECPT"},{"$f":"'Authorized Rev Req'!J53","v":573.80824116959502},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A54","v":"Transmission Integrity Management Program Memorandum Account  (TIMPBA)  Local Transmission"},null,{"$f":"'Authorized Rev Req'!B54","v":"AL 6325-G"},{"$f":"F55","v":56339.323056636218},{"$f":"'Authorized Rev Req'!K54","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J54","v":56339.323056636218},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[]
[{"$f":"'Authorized Rev Req'!A59","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A60","v":"  AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B60","v":"D.19-09-051"},{"$f":"F58","v":5106.2014202040336},{"$f":"'Authorized Rev Req'!K60","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!J60","v":5106.2014202040336},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"H58","v":0},{"$f":"I58","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A61","v":"  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B61","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},2684.1598286442622,{"$f":"'Authorized Rev Req'!K61","v":"ECPT"},{"$f":"'Authorized Rev Req'!J61","v":2684.1598286442622},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"H59","v":0},{"$f":"I59","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A62","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B62","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},659841.41913136793,{"$f":"'Authorized Rev Req'!K62","v":"GHG End User"},{"$f":"'Authorized Rev Req'!J62","v":659841.41913136793},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A63","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B63","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},14890.288905538293,{"$f":"'Authorized Rev Req'!K63","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J63","v":14890.288905538293},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A64","v":"Green House Gas Balancing Account (GHGBA) - Company Gas Compressor"},null,{"$f":"'Authorized Rev Req'!B64","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},-2420.193064735909,{"$f":"'Authorized Rev Req'!K64","v":"ECPT"},{"$f":"'Authorized Rev Req'!J64","v":-2420.193064735909},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A65","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B65","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},85564.855171911244,{"$f":"'Authorized Rev Req'!K65","v":"GHG End User"},{"$f":"'Authorized Rev Req'!J65","v":85564.855171911244},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A66","v":"Green House Gas Balancing Account (GHGBA) - LUAF"},null,{"$f":"'Authorized Rev Req'!B66","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},-7155.0303898461352,{"$f":"'Authorized Rev Req'!K66","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J66","v":-7155.0303898461352},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A67","v":"New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount"},null,{"$f":"'Authorized Rev Req'!B67","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},8886.0215302670767,{"$f":"'Authorized Rev Req'!K67","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!J67","v":8886.0215302670767},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A68","v":"New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   "},null,{"$f":"'Authorized Rev Req'!B68","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},8805.7593263656763,{"$f":"'Authorized Rev Req'!K68","v":"EPAM"},{"$f":"'Authorized Rev Req'!J68","v":8805.7593263656763},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A69","v":"New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program "},null,{"$f":"'Authorized Rev Req'!B69","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K69","v":"EPAM"},{"$f":"'Authorized Rev Req'!J69","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A70","v":"TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B70","v":"D.22-07-016, AL 6023, AL 6045, AL 6210"},9275.9915557850618,{"$f":"'Authorized Rev Req'!K70","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J70","v":9275.9915557850618},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A71","v":"  Natural Gas Leak Abatement Program Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B71","v":"AL 5915G, AL 6071, AL 6168-G, AL 5950-G-B"},104898.97716773154,{"$f":"'Authorized Rev Req'!K71","v":"EPAM"},{"$f":"'Authorized Rev Req'!J71","v":104898.97716773154},16081.969916118336,15792.959942536991,15281.493675291833,14865.192008178965,"Existing"]
[{"$f":"'Authorized Rev Req'!A72","v":"Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) "},null,{"$f":"'Authorized Rev Req'!B72","v":"D. 13-12-040, AL 6071, AL 6045, AL 6210"},0,{"$f":"'Authorized Rev Req'!K72","v":"EPAM"},{"$f":"'Authorized Rev Req'!J72","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"H70","v":0},{"$f":"I70","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A73","v":"Diary Biomethane Project Balancing Account  (DBPBA)"},null,{"$f":"'Authorized Rev Req'!B73","v":"D. 17-12-004, AL 6071, AL 6045, AL 6210"},1209.1955106992791,{"$f":"'Authorized Rev Req'!K73","v":"EPAM"},{"$f":"'Authorized Rev Req'!J73","v":1209.1955106992791},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A74","v":"Diary Biomethane Project Memorandum Account  (DBPMA)"},null,{"$f":"'Authorized Rev Req'!B74","v":"D. 17-12-004, AL 6071, AL 6045, AL 6210"},5125.990516156533,{"$f":"'Authorized Rev Req'!K74","v":"EPAM"},{"$f":"'Authorized Rev Req'!J74","v":5125.990516156533},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A75","v":"California Solar Iniative Thermal Memorandum Account (CSITPMA)"},null,{"$f":"'Authorized Rev Req'!B75","v":"D. 10-01-022, AL 6071, AL 6045, AL 6210"},1391.1079788304662,{"$f":"'Authorized Rev Req'!K75","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!J75","v":1391.1079788304662},{"$f":"0","v":0},{"$f":"0","v":0},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A76","v":"Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Administrative Costs Subaccount "},null,{"$f":"'Authorized Rev Req'!B76","v":"D. 22-02-025, AL 6210"},237.04701028905242,"EPAM",{"$f":"'Authorized Rev Req'!J76","v":237.04701028905242},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"H74","v":0},{"$f":"I74","v":0},"Existing"]
[]
["PPPS Programs"]
[{"$f":"'Authorized Rev Req'!A84","v":"California Alternate Rates for Energy (CARE) "},null,{"$f":"'Authorized Rev Req'!B84","v":" D.21-06-015, AL 6052, AL 6216"},{"$f":"F77","v":272251.15142222279},{"$f":"'Authorized Rev Req'!K84","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J84","v":272251.15142222279},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A85","v":"Energy Efficiency "},null,{"$f":"'Authorized Rev Req'!B85","v":" AL 6052, AL 6216, AL 6209"},165866.63928,{"$f":"'Authorized Rev Req'!K85","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J85","v":165866.63928},153968.28599999999,{"$f":"G78","v":153968.28599999999},{"$f":"H78","v":153968.28599999999},{"$f":"0","v":0},"Existing","Provided by Reg Accounting Tony Tjioe "]
[{"$f":"'Authorized Rev Req'!A86","v":"RD&D"},null,{"$f":"'Authorized Rev Req'!B86","v":" AL 6052, AL 6216"},11380.117797799039,{"$f":"'Authorized Rev Req'!K86","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J86","v":11380.117797799039},null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A87","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B87","v":" AL 6052, AL 6216"},476.44983000000002,{"$f":"'Authorized Rev Req'!K87","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J87","v":476.44983000000002},null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A88","v":"Energy Savings Assistance "},null,{"$f":"'Authorized Rev Req'!B88","v":" D.21-06-015,  AL 6052, AL 6216"},111508.29992653689,{"$f":"'Authorized Rev Req'!K88","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J88","v":111508.29992653689},122849.88400000001,122541.07,{"$f":"0","v":0},{"$f":"0","v":0},"Existing","Provided by Reg Accounting Tony Tjioe "]
[{"$f":"'Authorized Rev Req'!A89","v":"SJVDGPMA"},null,null,90.978000000000208,{"$f":"'Authorized Rev Req'!K89","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J89","v":90.978000000000208},null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},"Existing"]
[]
[]
[{"$f":"'Authorized Rev Req'!A98","v":"EOR"},null,{"$f":"'Authorized Rev Req'!B98","v":"D.20-02-045, AL 6045, AL "},{"$f":"F85","v":-33358.598503645662},{"$f":"'Authorized Rev Req'!K98","v":"EPAM"},{"$f":"'Authorized Rev Req'!J98","v":-33358.598503645662},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"H85","v":0},{"$f":"I85","v":0},"Existing"]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B101","v":"D.98-07-068"},{"$f":"F88","v":1800955.4437626412},{"$f":"'Authorized Rev Req'!K101","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!J101","v":1800955.4437626412},{"$f":"F88","v":1800955.4437626412},{"$f":"G88","v":1800955.4437626412},{"$f":"H88","v":1800955.4437626412},{"$f":"I88","v":1800955.4437626412},"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(F10:F91)","v":7114070.305666253},null,{"$f":"SUM(F10:F91)","v":7114070.305666253},{"$f":"SUM(G10:G91)","v":4955265.8275348889},{"$f":"SUM(H10:H91)","v":4954280.1503600962},{"$f":"SUM(I10:I91)","v":4834895.3019031817},{"$f":"SUM(J10:J91)","v":4680510.7142360695}]
[]
["CPUC Fee",null,null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3}]
[]
[]
["Pending Application(s) Not Yet Approved"]
["Filing Description","Proceeding","Basis of Revenue Requirement Forecast:  Application, Amended Application , Amended Testimony,  Proposed Settlement Agreement, Proposed Decision","Proposed Revenue Requirement with FF&U ($000)","Proposed Revenue Recovery Mechanism","Incremental Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028,null,"Include in Impact"]
["2024 GRC Application","`","PD",{"$f":"SUM(F100:J100)","v":5451566.4542879974},"Allocated Base Margin",1119721.3991719992,1277545.3991719992,1441758.8391719996,1612540.8167719995,null,"Existing",{"$f":"IFERROR(VLOOKUP(A100,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"}]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission ","A.22-05-015 ","PD",{"$f":"SUM(F101:J101)","v":47476.491932456396},"Local Transmission",-4853.6497599999875,16763.884447865319,17434.439825779933,18131.81741881113,null,"Existing",{"$f":"IFERROR(VLOOKUP(A101,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"}]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution","A.22-05-015 ","PD",408352.11394725664,"Distribution",96160.04,100010.27484215039,104010.68583583641,108171.11326926987,null,"Existing",{"$f":"IFERROR(VLOOKUP(A102,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,"Authorized + Pending"]
["NonCore Backbone Transmission","A.22-05-015 ","PD",1020161.3018628103,"Backbone Transmission",24790.373264518043,329328.83377125376,331779.92297755583,334262.17184948269,null,"Existing",{"$f":"IFERROR(VLOOKUP(A103,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028]
["TIMPBA","SDG&E AL 3257-G-A","Advice Letter",22035.043198157015,"ECPT",null,22035.043198157015,null,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A104,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUM(O9,SUMIFS(F$100:F$131,$E$100:$E$131,$N104,$L$101:$L$132,\"y\"))","v":1800955.4437626412},{"$f":"SUM(P9,SUMIFS(G$100:G$131,$E$100:$E$131,$N104,$L$101:$L$132,\"y\"))","v":1800955.4437626412},{"$f":"SUM(Q9,SUMIFS(H$100:H$131,$E$100:$E$131,$N104,$L$101:$L$132,\"y\"))","v":1800955.4437626412},{"$f":"SUM(R9,SUMIFS(I$100:I$131,$E$100:$E$131,$N104,$L$101:$L$132,\"y\"))","v":1800955.4437626412},{"$f":"SUM(S9,SUMIFS(J$100:J$131,$E$100:$E$131,$N104,$L$101:$L$132,\"y\"))","v":1800955.4437626412}]
["Catastrophic Event Memorandum Account (CEMA) ","A.23-11-003","Application",52396.735833086008,"ECPT",null,52396.735833086008,null,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A105,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,"Allocated Base Margin",3947512,4105336,4269549.4400000004,4440331.4176000003,2827790.6008280008]
["COVID-19 Pandemic Protections Memorandum Account (CPPMA)","A.23-11-003","Application",5828.2505756313421,"ECPT",null,5828.2505756313421,null,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A106,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,"Distribution",231250.96940157347,100010.27484215039,104010.68583583641,108171.11326926987,0]
["DIMPBA","AL 6224","Advice Letter",82765.636602892759,"EPAM",null,82765.636602892759,null,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A107,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,"ECPT adjusted",15383.330929301577,0,0,0,0]
["Natural Gas Leak Abatement","AL 6277-G-B","Advice Letter",285272.17219082499,"EPAM",null,155713.46384350699,129558.708347318,null,null,"New","Y",null,"Local Transmission",98471.65379788533,16763.884447865319,17434.439825779933,18131.81741881113,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A109,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"SGIP",16265.025427685592,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A110,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"GHG End User",745406.27430327912,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A111,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"Public Purpose Programs",561573.6362565587,276818.17,276509.35600000003,153968.28599999999,0]
["Public Policy Proceedings",null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A112,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"Backbone Transmission",428508.98670174036,329328.83377125376,331779.92297755583,334262.17184948269,0]
[null,null,null,{"$f":"SUM(F113:J113)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A113,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"47% Res (LUAF, Other)",58785.832333666731,0,0,0,0]
[" Cost Allocation Proceeding","A. 22-09-015","Settlement Agreement",{"$f":"SUM(F114:J114)","v":0},"EPAM",null,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(A114,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"Y"},null,"ECPT",416754.35700979206,80260.029606874377,0,0,0]
[null,null,null,{"$f":"SUM(F115:J115)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A115,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"EPAM",{"$f":"SUM(O20,SUMIFS(F$100:F$131,$E$100:$E$131,$N115,$L$101:$L$132,\"y\"))","v":177516.68242123362},{"$f":"SUM(P20,SUMIFS(G$100:G$132,$E$100:$E$132,$N115,$L$100:$L$132,\"y\"))","v":288180.71339064633},178583.45811677229,{"$f":"SUM(R20,SUMIFS(I$100:I$131,$E$100:$E$131,$N115,$L$101:$L$132,\"y\"))","v":52180.971312539885},51764.669645427013]
[null,null,null,{"$f":"SUM(F116:J116)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A116,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"CFCA",{"$f":"SUM(O21,SUMIFS(F$100:F$131,$E$100:$E$131,$N116,$L$101:$L$132,\"y\"))","v":-159234.4339632123},{"$f":"SUM(P21,SUMIFS(G$100:G$131,$E$100:$E$131,$N116,$L$101:$L$132,\"y\"))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A117,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"Non-Residential",{"$f":"SUM(O22,SUMIFS(F$100:F$131,$E$100:$E$131,$N117,$L$101:$L$132,\"y\"))","v":10738.709960624148},{"$f":"SUM(P22,SUMIFS(G$100:G$131,$E$100:$E$131,$N117,$L$101:$L$132,\"y\"))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A118,Summary!$B$7:$D$17,3,FALSE),\"-\")","v":"-"},null,"Total",{"$f":"SUM(O104:O117)","v":8349888.4683427708},{"$f":"SUM(P104:P117)","v":6997653.3498214316},{"$f":"SUM(Q104:Q117)","v":6978822.7465185858},{"$f":"SUM(R104:R117)","v":6908001.2212127447},{"$f":"SUM(S104:S117)","v":4680510.7142360685}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Revenues",{"$f":"O118-O23","v":1235818.1626765188},{"$f":"P118-P23","v":2042387.5222865436},{"$f":"Q118-Q23","v":2024542.5961584905},{"$f":"R118-R23","v":2073105.919309563},{"$f":"S118-S23","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Check Figure",{"$f":"ROUND(O119,6)-ROUND(F133,6)","v":0},{"$f":"ROUND(P119,6)-SUM(G100:G131)","v":4.5704655349254608E-7},{"$f":"ROUND(Q119,6)-SUM(H100:H131)","v":-4.898756742477417E-7},{"$f":"ROUND(R119,6)-SUM(I100:I131)","v":4.3679028749465942E-7},{"$f":"ROUND(S119,6)-SUM(J100:J130)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D100:D130)","v":7375854.2004311122},null,{"$f":"SUM(F100:F132)","v":1235818.1626765174},{"$f":"SUM(G100:G131)","v":2042387.5222865429},{"$f":"SUM(H100:H131)","v":2024542.5961584898},{"$f":"SUM(I100:I131)","v":2073105.9193095632},{"$f":"SUM(J100:J132)","v":0}]
["Applications Projected to be Filed, Next 12 Months"]
[]
["Filing Description","Estimated Filing Date","Filing Basis","Proposed Revenue Requirement ($000)","Proposed Revenue Recovery Mechanism","Projected Authorized Revenue Requirement ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028]
[]
[]
[]
[]
["Public Policy Proceedings"]

{"sheet":"SAR and RAR","index":4,"n_rows":32,"n_cols":30,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,24,16,24],[15,25,16,25],[16,20,16,21],[16,22,16,23],[31,5,31,7],[15,22,15,23],[17,20,17,21],[18,20,18,21],[19,20,19,21],[17,22,17,23],[18,22,18,23],[19,22,19,23],[46,20,46,21],[52,20,52,21],[0,2,0,3],[25,5,25,10],[71,20,71,21],[15,20,15,21],[25,15,25,21],[64,20,64,21],[36,20,36,21]]}
[null,null,"Revenue Change ($000)"]
[null,null,"Authorized","w/ Pending"]
[null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B3,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":1800955.4437626412},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B3,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":1800955.4437626412},null,null,"Allocation",null,null,null,null,null,null,null,null,"Other Revenues and Balancing Accounts"]
[null,"Allocated Base Margin",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B4,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":2827790.6008280008},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B4,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":3947512},null,null,{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential","CPUC Fee"]
[null,"Distribution",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B5,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":135090.92940157346},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B5,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":231250.96940157347},null,"Residential",0.66270937539797536,0.74462262420775072,0.61126244041598166,0.38772943906757024,0.41732655419472187,8.3272591170996182E-2,0.55036291215658573,0.52865356398173613,0,0.47118636590796048,0.25092103633912455,0.74462262420775072,0.6979502783828444,0,{"$f":"RegulatoryFee","v":1E-3}]
[null,"ECPT adjusted",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B6,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":15383.330929301577},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B6,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":15383.330929301577}]
[null,"Local Transmission",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B7,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":103325.30355788532},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B7,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":98471.65379788533},null,null,"Revenue Change ($000) - System"]
[null,"SGIP",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B8,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":16265.025427685592},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B8,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":16265.025427685592},null,"Authorized",{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential"]
[null,"GHG End User",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B9,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":745406.27430327912},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B9,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":745406.27430327912},null,"Residential",{"$f":"G5*G10","v":1193510.0572555235},{"$f":"H5*H10","v":2105636.857898558},{"$f":"I5*I10","v":82576.011184068877},{"$f":"J5*J10","v":5964.5702722089045},43120.392894935918,1354.4308128255198,410243.96786534344,296877.90424521285,{"$f":"O5*O10","v":0},27699.082704175107,{"$f":"Q5*Q10","v":104572.43515974251},{"$f":"R5*R10","v":132182.93790515288},{"$f":"S5*S10","v":-111137.71751275868},{"$f":"T5*T10","v":0},{"$f":"SUM(G9:T9)","v":4292600.9306849902},"Check","CPUC Fee"]
[null,"Public Purpose Programs",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B10,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":561573.6362565587},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B10,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":561573.6362565587},null,"Total System",{"$f":"C3","v":1800955.4437626412},{"$f":"C4","v":2827790.6008280008},{"$f":"C5","v":135090.92940157346},{"$f":"C6","v":15383.330929301577},{"$f":"C7","v":103325.30355788532},{"$f":"C8","v":16265.025427685592},{"$f":"C9","v":745406.27430327912},{"$f":"C10","v":561573.6362565587},{"$f":"C11","v":403718.61343722232},{"$f":"C12","v":58785.832333666731},{"$f":"C13","v":416754.35700979206},{"$f":"C14","v":177516.68242123362},{"$f":"C15","v":-159234.4339632123},{"$f":"C16","v":10738.709960624148},{"$f":"SUM(G10:T10)","v":7114070.305666252},{"$f":"U10-C17","v":0},{"$f":"RegulatoryFee","v":1E-3}]
[null,"Backbone Transmission",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B11,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":403718.61343722232},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B11,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":428508.98670174036},null,"w/Pending"]
[null,"47% Res (LUAF, Other)",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B12,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":58785.832333666731},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B12,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":58785.832333666731},null,"Residential",{"$f":"G5*G13","v":1193510.0572555235},{"$f":"H5*H13","v":2939406.7445315863},141355.0319049673,5964.5702722089045,41094.835965327082,1354.4308128255198,410243.96786534344,296877.90424521285,{"$f":"O5*O13","v":0},27699.082704175107,{"$f":"Q5*Q13","v":104572.43515974251},{"$f":"R5*R13","v":132182.93790515288},{"$f":"S5*S13","v":-111137.71751275868},{"$f":"T5*T13","v":0},{"$f":"SUM(G12:T12)","v":5183124.2811093079},"Check","CPUC Fee"]
[null,"ECPT",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B13,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":416754.35700979206},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B13,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":416754.35700979206},null,"Total System",{"$f":"D3","v":1800955.4437626412},{"$f":"D4","v":3947512},{"$f":"D5","v":231250.96940157347},{"$f":"D6","v":15383.330929301577},{"$f":"D7","v":98471.65379788533},{"$f":"D8","v":16265.025427685592},{"$f":"D9","v":745406.27430327912},{"$f":"D10","v":561573.6362565587},{"$f":"D11","v":428508.98670174036},{"$f":"D12","v":58785.832333666731},{"$f":"D13","v":416754.35700979206},{"$f":"D14","v":177516.68242123362},{"$f":"D15","v":-159234.4339632123},{"$f":"D16","v":10738.709960624148},{"$f":"SUM(G13:T13)","v":8349888.4683427708},{"$f":"U13-D17","v":0},{"$f":"RegulatoryFee","v":1E-3}]
[null,"EPAM",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B14,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":177516.68242123362},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B14,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":177516.68242123362},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized","w/Pending"]
[null,"CFCA",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B15,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":-159234.4339632123},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B15,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":-159234.4339632123},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of CARE Sales (Bundled)",0.24714733696214691,{"$f":"AC15","v":0.24714733696214691}]
[null,"Non-Residential",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B16,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":10738.709960624148},{"$f":"INDEX('Incremental Rev Req'!$N$104:$S$117,MATCH(B16,'Incremental Rev Req'!$N$104:$N$117,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$103:$S$103,0))","v":10738.709960624148},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized ",null,"w/Pending Total UDC",null,"Commodity","w/Pending Commodity"]
[null,"Total Revenue Requirement",{"$f":"SUM(C3:C16)","v":7114070.305666252},{"$f":"SUM(D3:D16)","v":8349888.4683427708},null,null,"Revenue Split - Bundled Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bundled Revenue Change",null,"Bundled Revenue Change"]
[null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3},{"$f":"C18","v":1E-3},null,null,{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential","Total",null,"Total",null,"Core Procurement","Core Procurement"]
[null,null,null,null,null,"Residential",1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUMPRODUCT(H9:T9,H19:T19)","v":3099090.8734294651},null,{"$f":"SUMPRODUCT(H12:T12,H19:T19)","v":3989614.2238537837},null,{"$f":"SUMPRODUCT(G9,G19)","v":1193510.0572555235},{"$f":"SUMPRODUCT(G12,G19)","v":1193510.0572555235}]
[null,null,null,null,null,"Total System",1,1,1,1,1,1,1,0,1,1,1,1,1,1,{"$f":"SUMPRODUCT(H10:T10,H20:T20)","v":4751541.2256470518},null,{"$f":"SUMPRODUCT(H13:T13,H20:T20)","v":5987359.3883235687},null,{"$f":"SUMPRODUCT(G10,G20)","v":1800955.4437626412},{"$f":"SUMPRODUCT(G13,G20)","v":1800955.4437626412}]
[]
[null,null,"TCAP D.20-02-045 SALES DETERMINANTS SYSTEM NET (MTH) Average year Throughput","TCAP D.20-02-045 SALES DETERMINANTS BUNDLED (MTH)Average year throughput"]
[null,"Residential",2346352.6450134837,2318963.2675040946]
[null,"Total System",9350960.2831479758,3290999.2211096496]
[]
[null,null,null,null,null,"Bundled",null,null,null,null,null,null,null,null,null,"System (Bundled and Unbundled)"]
[null,"CARE Discount",null,null,null,"TCAP D.20-02-045 SALES DETERMINANTS BUNDLED",{"$f":"CONCATENATE(TEXT(CurrentEffectiveRateDate,\"mm/dd/yyyy\"),\" Avg Rates\"&\"(sales adj.)\")","v":"12/01/2024 Avg Rates(sales adj.)"},"Proposed Avg Rates (Authorized)","Proposed Avg Rates (w/Pending)","% Change (Authorized)","% Change (w/Pending)",null,null,null,null,null,{"$f":"F27","v":"TCAP D.20-02-045 SALES DETERMINANTS BUNDLED"},{"$f":"G27","v":"12/01/2024 Avg Rates(sales adj.)"},"Proposed Avg Rates (Authorized)","Proposed Avg Rates (w/Pending)","% Change (Authorized)","% Change (w/Pending)"]
[null,2020,132417.97639184489,null,"Residential",{"$f":"D23","v":2318963.2675040946},183.54860424771815,{"$f":"(U19/C23*100)+(Y19/D23*100)","v":183.54860424771815},{"$f":"(W19/C23*100)+(Z19/D23*100)","v":221.50212126558318},{"$f":"H28/G28-1","v":0},{"$f":"I28/G28-1","v":0.2067763858702123},null,null,null,null,"Residential",{"$f":"C23","v":2346352.6450134837},182.94781646772972,{"$f":"U9/Q28*100","v":182.94781646772972},{"$f":"U12/Q28*100","v":220.90133348559471},{"$f":"S28/R28-1","v":0},{"$f":"T28/R28-1","v":0.20745542499852476}]
[null,2021,187534.66465327851,null,"Total System",{"$f":"D24","v":3290999.2211096496},105.53707065695139,{"$f":"(U20/C24*100)+(Y20/D24*100)","v":105.53707065695139},{"$f":"(W20/C24*100)+(Z20/D24*100)","v":118.7530198777354},{"$f":"H29/G29-1","v":0},{"$f":"I29/G29-1","v":0.12522565898898685},null,null,null,null,"Total System",{"$f":"C24","v":9350960.2831479758},76.078499857250165,{"$f":"U10/Q29*100","v":76.078499857250165},{"$f":"U13/Q29*100","v":89.294449078034191},{"$f":"S29/R29-1","v":0},{"$f":"T29/R29-1","v":0.17371464008335824}]
[null,2022,210430.21408047274,null,null,null,null,"cents/therm"]
[null,2023,213115.43917425306]
[null,2024,214904.499407189]

{"sheet":"Res Bill Impact","index":5,"n_rows":97,"n_cols":25,"rows_kept":97,"cut":false,"hidden":false,"merged":[[49,2,49,9],[39,2,39,9],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[1,1,1,3],[2,4,2,10],[2,15,2,21],[38,2,38,9],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[19,20,19,21],[20,16,20,17],[20,18,20,19],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[59,2,59,9],[69,2,69,9],[70,2,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[79,2,79,9],[80,2,80,3],[80,4,80,5],[80,6,80,7],[80,8,80,9],[89,2,89,9],[90,2,90,3],[90,4,90,5],[90,6,90,7],[90,8,90,9],[38,13,38,20],[39,13,39,20],[40,13,40,14],[40,15,40,16],[40,17,40,18],[40,19,40,20],[49,13,49,20],[50,13,50,14],[50,15,50,16],[50,17,50,18],[50,19,50,20],[70,17,70,18],[70,19,70,20],[59,13,59,20],[60,13,60,14],[60,15,60,16],[60,17,60,18],[60,19,60,20],[28,20,28,21],[29,16,29,17],[29,18,29,19],[89,13,89,20],[90,13,90,14],[90,15,90,16],[90,17,90,18],[90,19,90,20],[79,13,79,20],[80,13,80,14],[80,15,80,16],[80,17,80,18],[80,19,80,20],[69,13,69,20],[70,13,70,14],[70,15,70,16]]}
[]
[]
[null,null,null,null,"Schedule GR",null,null,null,null,null,null,null,null,null,null,"Schedule GR [CARE]"]
[null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},"Proposed","Proposed","Proposed","Proposed",null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},"Proposed","Proposed","Proposed","Proposed"]
[null,null,null,null,"System Sales Forecast","Rates","Revenue","Authorized Rates","Authorized Revenue","w/Pending Rates","w/Pending Revenue",null,null,null,null,"Sales Forecast","Rates","Revenue","Authorized Rates","Authorized Revenue","w/Pending Rates","w/Pending Revenue"]
[]
[null,null,null,"Baseline",1205788.2452481429,1.6262076136533858,{"$f":"F7*E7","v":1960862.024876286},{"$f":"((Y10-I12-T12)/SUM(E7,F9/F7*E9,P7*((Q7/F7)),P9*((Q9/F7))))","v":1.6593630463876672},{"$f":"E7*H7","v":2000840.4559333979},{"$f":"((Y13-K12-V12)/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*((Q7/F7)),SUM(P9)*(Q9/F7)))","v":2.0314665918670207},{"$f":"E7*J7","v":2449518.5370875602},null,null,null,{"$f":"D7","v":"Baseline"},419691.96036134037,1.2660225082886378,{"$f":"Q7*P7","v":531339.46836523968},{"$f":"H7*(1+(Q7/F7-1))","v":1.2918344180111296},{"$f":"P7*S7","v":542172.51935734227},{"$f":"J7*(1+(Q7/F7-1))","v":1.5815215772862776},{"$f":"P7*U7","v":663751.89112503699},null,"Bundled Residential Rev Req "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current",{"$f":"(SUM(G7:G9)+SUM(R7:R9))","v":3891862.5479114167}]
[null,null,null,"non-Baseline",534746.29266911256,2.0568576136533858,{"$f":"F9*E9","v":1099896.983449386},{"$f":"F9/F$7*H$7","v":2.0987932211864684},{"$f":"E9*H9","v":1122321.8941085287},{"$f":"F9/F$7*J$7","v":2.5694367012444577},1373996.7502384279,null,null,null,{"$f":"D9","v":"non-Baseline"},186126.14673488794,1.6105425082886375,{"$f":"Q9*P9","v":299764.0712205054},{"$f":"H9*(1+(Q9/F9-1))","v":1.6433785578501705},{"$f":"P9*S9","v":305875.71859938937},{"$f":"J9*(1+(Q9/F9-1))","v":2.011897664788227},{"$f":"P9*U9","v":374466.75997195189},null,"Change (Authorized)",{"$f":"Y10-Y8","v":400738.38277357351}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed (Authorized)",{"$f":"'SAR and RAR'!U9","v":4292600.9306849902}]
[null,null,null,null,"Non-CARE customers",null,null,null,null,null,null,null,null,null,null,"CARE Customers"]
[null,null,null,"Fixed Charge",{"$f":"E13-P12","v":3924404.1114388667},5,{"$f":"F12*12*E12/1000","v":235464.24668633199},{"$f":"SetUp!D7","v":5},{"$f":"(H12*12*E12)/1000","v":235464.24668633199},{"$f":"H12","v":5},{"$f":"I12","v":235464.24668633199},null,null,null,"Fixed Charge",1790127,{"$f":"F12*(1-CAREDiscountPercent)","v":4},{"$f":"Q12*12*P12/1000","v":85926.096000000005},{"$f":"SetUp!D7*(1-CAREDiscountPercent)","v":4},{"$f":"(S12*12*P12)/1000","v":85926.096000000005},{"$f":"S12","v":4},{"$f":"T12","v":85926.096000000005},null,"Change (w/Pending)",{"$f":"Y13-Y8","v":1291261.7331978912}]
[null,null,null,"Total Customers",5714531.1114388667,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed (w/Pending)",{"$f":"'SAR and RAR'!U12","v":5183124.2811093079}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic Bundled"]
[null,null,null,null,{"$f":"Summary!D2","v":2024},{"$f":"Summary!D2","v":2024},null,"Essential Usage",null,null,null,null,null,null,null,"2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"]
[null,"SCHEDULE GR RATES ($/therm)",null,null,"Proposed","Proposed",null,"Monthly Tier 1 Baseline Allowance -BASIC (th)",null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter","Population Weight"]
[null,"Rates",{"$f":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2024-12-01"},"Authorized","w/Pending",null,"Climate Zone","Summer 2023","Winter 2023",null,null,null,null,null,null,"Non-CARE",null,"CARE",null,"Non-CARE","CARE"]
["Summer","Tier 1",1.6500765771565775,1.659887539220674,{"$f":"H7","v":1.6593630463876672},{"$f":"J7","v":2.0314665918670207},null,{"$f":"Zones","v":1},13,37.333333333333336,null,null,null,null,null,{"$f":"Zones","v":1},23.702733811833337,50.815830623000004,17.651984122333332,36.094967588500005,0.95334948874186987,0.95334948874186987]
[null,"Tier 2",2.0854002884914355,2.0977995815921848,{"$f":"H9","v":2.0987932211864684},{"$f":"J9","v":2.5694367012444577},null,2,13,42.166666666666664,null,null,null,null,null,2,19.992271593666668,57.296892826166669,18.340279621499999,53.477491469500002,4.4671949626213771E-2,4.4671949626213771E-2]
[null,null,null,null,null,null,null,3,13,65,null,null,null,null,null,3,22.172026694500001,81.479840450333327,25.090080402166667,88.999667575999993,1.9785616319163667E-3,1.9785616319163667E-3]
["Winter","Tier 1",{"$f":"C22","v":1.6500765771565775},{"$f":"D22","v":1.659887539220674},{"$f":"E22","v":1.6593630463876672},2.0314665918670207,null,0,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"Tier 2",{"$f":"C23","v":2.0854002884914355},{"$f":"D23","v":2.0977995815921848},{"$f":"E23","v":2.0987932211864684},2.5694367012444577]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typical Bundled"]
[null,null,null,null,{"$f":"Summary!D2","v":2024},{"$f":"Summary!D2","v":2024},null,null,null,null,null,null,null,null,null,"2019-2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"]
[null,"SCHEDULE GR-LI [CARE] ($/therm)",null,null,"Proposed","Proposed",null,null,null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter","Population Weight"]
[null,"Rates",{"$f":"C21","v":"2024-01-01"},{"$f":"D21","v":"2024-12-01"},"Authorized","w/Pending",null,null,null,null,null,null,null,null,null,null,"Non-CARE",null,"CARE",null,"Non-CARE","CARE"]
["Summer","Tier 1",1.2844039398631395,1.2920406995768539,{"$f":"S7","v":1.2918344180111296},{"$f":"U7","v":1.5815215772862776},null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":1},23.211191282000001,50.634393741933337,17.783303916800001,35.740555869799998,0.95334948874186987,0.95334948874186987]
[null,"Tier 2",1.6326629089310256,1.6423703334740625,{"$f":"S9","v":1.6433785578501705},{"$f":"U9","v":2.011897664788227},null,null,null,null,null,null,null,null,null,2,19.588177982433333,56.62928825223333,18.883067259899999,53.10374031206667,4.4671949626213771E-2,4.4671949626213771E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,20.927596488166667,79.119626847833331,25.945455275366669,90.095995849833329,1.9785616319163667E-3,1.9785616319163667E-3]
["Winter","Tier 1",{"$f":"C31","v":1.2844039398631395},{"$f":"D31","v":1.2920406995768539},1.2918344180111296,1.5815215772862776,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"Tier 2",{"$f":"C32","v":1.6326629089310256},{"$f":"D32","v":1.6423703334740625},1.6433785578501705,2.011897664788227]
[]
[]
[]
[null,null,"Note: Bill inserts include CPUC fee in the calculations"]
[null,null,"2023 Recorded Average Basic Bundled Non-CARE Customer Bill"]
[null,null,{"$f":"C30","v":"2024-01-01"},null,{"$f":"D30","v":"2024-12-01"},null,{"$f":"E21","v":"Authorized"},null,{"$f":"F21","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($Q22>$I22,C$22*$I22+C$23*($Q22-$I22),$Q22*C$22)+('Incremental Rev Req'!$F$94*$Q22)+IF(Q22>0,$F$12,0)","v":48.794182415691623},{"$f":"IF($R22>$J22,C$25*$J22+C$26*($R22-$J22),$R22*C$25)+('Incremental Rev Req'!$F$94*$R22)+IF(R22>0,$F$12,0)","v":94.770078448591093},{"$f":"IF($Q22>$I22,D$22*$I22+D$23*($Q22-$I22),$Q22*D$22)+('Incremental Rev Req'!$F$94*$Q22)+IF(Q22>0,$F$12,0)","v":49.054431256037091},{"$f":"IF($R22>$J22,D$25*$J22+D$26*($R22-$J22),$R22*D$25)+('Incremental Rev Req'!$F$94*$R22)+IF(R22>0,$F$12,0)","v":95.303527801275337},{"$f":"IF($Q22>$I22,E$22*$I22+E$23*($Q22-$I22),$Q22*E$22)+('Incremental Rev Req'!$F$94*$Q22)+IF(Q22>0,$H$12,0)","v":49.058247509290524},{"$f":"IF($R22>$J22,E$25*$J22+E$26*($R22-$J22),$R22*E$25)+('Incremental Rev Req'!$F$94*$R22)+IF(R22>0,$H$12,0)","v":95.297343478646582},{"$f":"IF($Q22>$I22,F$22*$I22+F$23*($Q22-$I22),$Q22*F$22)+('Incremental Rev Req'!$F$94*$Q22)+IF(Q22>0,$J$12,0)","v":58.932765487857665},{"$f":"IF($R22>$J22,F$25*$J22+F$26*($R22-$J22),$R22*F$25)+('Incremental Rev Req'!$F$94*$R22)+IF(R22>0,$J$12,0)","v":115.53465862082358}]
[null,2,{"$f":"IF($Q23>$I23,C$22*$I23+C$23*($Q23-$I23),$Q23*C$22)+('Incremental Rev Req'!$F$94*$Q23)+IF(Q23>0,$F$12,0)","v":41.052672973272109},{"$f":"IF($R23>$J23,C$25*$J23+C$26*($R23-$J23),$R23*C$25)+('Incremental Rev Req'!$F$94*$R23)+IF(R23>0,$F$12,0)","v":106.18810389422383},{"$f":"IF($Q23>$I23,D$22*$I23+D$23*($Q23-$I23),$Q23*D$22)+('Incremental Rev Req'!$F$94*$Q23)+IF(Q23>0,$F$12,0)","v":41.266914705035283},{"$f":"IF($R23>$J23,D$25*$J23+D$26*($R23-$J23),$R23*D$25)+('Incremental Rev Req'!$F$94*$R23)+IF(R23>0,$F$12,0)","v":106.78940357009216},{"$f":"IF($Q23>$I23,E$22*$I23+E$23*($Q23-$I23),$Q23*E$22)+('Incremental Rev Req'!$F$94*$Q23)+IF(Q23>0,$H$12,0)","v":41.267044096115647},{"$f":"IF($R23>$J23,E$25*$J23+E$26*($R23-$J23),$R23*E$25)+('Incremental Rev Req'!$F$94*$R23)+IF(R23>0,$H$12,0)","v":106.78232144741625},{"$f":"IF($Q23>$I23,F$22*$I23+F$23*($Q23-$I23),$Q23*F$22)+('Incremental Rev Req'!$F$94*$Q23)+IF(Q23>0,$J$12,0)","v":49.395257223701151},{"$f":"IF($R23>$J23,F$25*$J23+F$26*($R23-$J23),$R23*F$25)+('Incremental Rev Req'!$F$94*$R23)+IF(R23>0,$J$12,0)","v":129.59362990890051}]
[null,3,{"$f":"IF($Q24>$I24,C$22*$I24+C$23*($Q24-$I24),$Q24*C$22)+('Incremental Rev Req'!$F$94*$Q24)+IF(Q24>0,$F$12,0)","v":45.600514644491462},{"$f":"IF($R24>$J24,C$25*$J24+C$26*($R24-$J24),$R24*C$25)+('Incremental Rev Req'!$F$94*$R24)+IF(R24>0,$F$12,0)","v":146.70352138504583},{"$f":"IF($Q24>$I24,D$22*$I24+D$23*($Q24-$I24),$Q24*D$22)+('Incremental Rev Req'!$F$94*$Q24)+IF(Q24>0,$F$12,0)","v":45.841783798637714},{"$f":"IF($R24>$J24,D$25*$J24+D$26*($R24-$J24),$R24*D$25)+('Incremental Rev Req'!$F$94*$R24)+IF(R24>0,$F$12,0)","v":147.54557229120937},{"$f":"IF($Q24>$I24,E$22*$I24+E$23*($Q24-$I24),$Q24*E$22)+('Incremental Rev Req'!$F$94*$Q24)+IF(Q24>0,$H$12,0)","v":45.844079080692104},{"$f":"IF($R24>$J24,E$25*$J24+E$26*($R24-$J24),$R24*E$25)+('Incremental Rev Req'!$F$94*$R24)+IF(R24>0,$H$12,0)","v":147.52785527904283},{"$f":"IF($Q24>$I24,F$22*$I24+F$23*($Q24-$I24),$Q24*F$22)+('Incremental Rev Req'!$F$94*$Q24)+IF(Q24>0,$J$12,0)","v":54.998179734607959},{"$f":"IF($R24>$J24,F$25*$J24+F$26*($R24-$J24),$R24*F$25)+('Incremental Rev Req'!$F$94*$R24)+IF(R24>0,$J$12,0)","v":179.47071519554612}]
[null,0,{"$f":"IF($Q25>$I25,C$22*$I25+C$23*($Q25-$I25),$Q25*C$22)+('Incremental Rev Req'!$F$94*$Q25)+IF(Q25>0,$F$12,0)","v":0},{"$f":"IF($R25>$J25,C$25*$J25+C$26*($R25-$J25),$R25*C$25)+('Incremental Rev Req'!$F$94*$R25)+IF(R25>0,$F$12,0)","v":0},{"$f":"IF($Q25>$I25,D$22*$I25+D$23*($Q25-$I25),$Q25*D$22)+('Incremental Rev Req'!$F$94*$Q25)+IF(Q25>0,$F$12,0)","v":0},{"$f":"IF($R25>$J25,D$25*$J25+D$26*($R25-$J25),$R25*D$25)+('Incremental Rev Req'!$F$94*$R25)+IF(R25>0,$F$12,0)","v":0},{"$f":"IF($Q25>$I25,E$22*$I25+E$23*($Q25-$I25),$Q25*E$22)+('Incremental Rev Req'!$F$94*$Q25)+IF(Q25>0,$H$12,0)","v":0},{"$f":"IF($R25>$J25,E$25*$J25+E$26*($R25-$J25),$R25*E$25)+('Incremental Rev Req'!$F$94*$R25)+IF(R25>0,$H$12,0)","v":0},{"$f":"IF($Q25>$I25,F$22*$I25+F$23*($Q25-$I25),$Q25*F$22)+('Incremental Rev Req'!$F$94*$Q25)+IF(Q25>0,$J$12,0)","v":0},{"$f":"IF($R25>$J25,F$25*$J25+F$26*($R25-$J25),$R25*F$25)+('Incremental Rev Req'!$F$94*$R25)+IF(R25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C43:C46,$U$22:$U$25)","v":48.442035227331814},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":95.382897423736622},48.700191287961346,95.919988369833533,48.703839832558252,95.913741122589244,58.498921578712803,116.28920170643572]
[]
[]
[null,null,"2023 Recorded Average Basic Bundled CARE Customer Bill"]
[null,null,{"$f":"C30","v":"2024-01-01"},null,{"$f":"D30","v":"2024-12-01"},null,{"$f":"E30","v":"Authorized"},null,{"$f":"F30","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($S22>$I22,C$31*$I22+C$32*($S22-$I22),$S22*C$31)+('Incremental Rev Req'!$F$94*$S22)+IF(S22>0,$Q$12,0)","v":28.310025131812829},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Incremental Rev Req'!$F$94*$T22)+IF(T22>0,$Q$12,0)","v":50.396613547490226},{"$f":"IF($S22>$I22,D$31*$I22+D$32*($S22-$I22),$S22*D$31)+('Incremental Rev Req'!$F$94*$S22)+IF(S22>0,$Q$12,0)","v":28.454461792934072},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Incremental Rev Req'!$F$94*$T22)+IF(T22>0,$Q$12,0)","v":50.672262141837912},{"$f":"IF($S22>$I22,E$31*$I22+E$32*($S22-$I22),$S22*E$31)+('Incremental Rev Req'!$F$94*$S22)+IF(S22>0,$S$12,0)","v":28.456470376369062},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Incremental Rev Req'!$F$94*$T22)+IF(T22>0,$S$12,0)","v":50.664816415408986},{"$f":"IF($S22>$I22,F$31*$I22+F$32*($S22-$I22),$S22*F$31)+('Incremental Rev Req'!$F$94*$S22)+IF(S22>0,$U$12,0)","v":33.936748481198279},{"$f":"IF($T22>$J22,F$34*$J22+F$35*($T22-$J22),$T22*F$34)+('Incremental Rev Req'!$F$94*$T22)+IF(T22>0,$U$12,0)","v":61.121065040250095}]
[null,2,{"$f":"IF($S23>$I23,C$31*$I23+C$32*($S23-$I23),$S23*C$31)+('Incremental Rev Req'!$F$94*$S23)+IF(S23>0,$Q$12,0)","v":29.434467959185579},{"$f":"IF($T23>$J23,C$34*$J23+C$35*($T23-$J23),$T23*C$34)+('Incremental Rev Req'!$F$94*$T23)+IF(T23>0,$Q$12,0)","v":76.67927441403495},{"$f":"IF($S23>$I23,D$31*$I23+D$32*($S23-$I23),$S23*D$31)+('Incremental Rev Req'!$F$94*$S23)+IF(S23>0,$Q$12,0)","v":29.585586196928293},{"$f":"IF($T23>$J23,D$34*$J23+D$35*($T23-$J23),$T23*D$34)+('Incremental Rev Req'!$F$94*$T23)+IF(T23>0,$Q$12,0)","v":77.111090093589581},{"$f":"IF($S23>$I23,E$31*$I23+E$32*($S23-$I23),$S23*E$31)+('Incremental Rev Req'!$F$94*$S23)+IF(S23>0,$S$12,0)","v":29.588288736663507},{"$f":"IF($T23>$J23,E$34*$J23+E$35*($T23-$J23),$T23*E$34)+('Incremental Rev Req'!$F$94*$T23)+IF(T23>0,$S$12,0)","v":77.113795736848317},{"$f":"IF($S23>$I23,F$31*$I23+F$32*($S23-$I23),$S23*F$31)+('Incremental Rev Req'!$F$94*$S23)+IF(S23>0,$U$12,0)","v":35.322216884155111},{"$f":"IF($T23>$J23,F$34*$J23+F$35*($T23-$J23),$T23*F$34)+('Incremental Rev Req'!$F$94*$T23)+IF(T23>0,$U$12,0)","v":93.497192674690012}]
[null,3,{"$f":"IF($S24>$I24,C$31*$I24+C$32*($S24-$I24),$S24*C$31)+('Incremental Rev Req'!$F$94*$S24)+IF(S24>0,$Q$12,0)","v":40.46136713723439},{"$f":"IF($T24>$J24,C$34*$J24+C$35*($T24-$J24),$T24*C$34)+('Incremental Rev Req'!$F$94*$T24)+IF(T24>0,$Q$12,0)","v":126.75862283668984},{"$f":"IF($S24>$I24,D$31*$I24+D$32*($S24-$I24),$S24*D$31)+('Incremental Rev Req'!$F$94*$S24)+IF(S24>0,$Q$12,0)","v":40.678008556735961},{"$f":"IF($T24>$J24,D$34*$J24+D$35*($T24-$J24),$T24*D$34)+('Incremental Rev Req'!$F$94*$T24)+IF(T24>0,$Q$12,0)","v":127.48798718013326},{"$f":"IF($S24>$I24,E$31*$I24+E$32*($S24-$I24),$S24*E$31)+('Incremental Rev Req'!$F$94*$S24)+IF(S24>0,$S$12,0)","v":40.687516410152114},{"$f":"IF($T24>$J24,E$34*$J24+E$35*($T24-$J24),$T24*E$34)+('Incremental Rev Req'!$F$94*$T24)+IF(T24>0,$S$12,0)","v":127.4987759282298},{"$f":"IF($S24>$I24,F$31*$I24+F$32*($S24-$I24),$S24*F$31)+('Incremental Rev Req'!$F$94*$S24)+IF(S24>0,$U$12,0)","v":48.908875113344799},{"$f":"IF($T24>$J24,F$34*$J24+F$35*($T24-$J24),$T24*F$34)+('Incremental Rev Req'!$F$94*$T24)+IF(T24>0,$U$12,0)","v":155.17277734303215}]
[null,0,{"$f":"IF($S25>$I25,C$31*$I25+C$32*($S25-$I25),$S25*C$31)+('Incremental Rev Req'!$F$94*$S25)+IF(S25>0,$Q$12,0)","v":0},{"$f":"IF($T25>$J25,C$34*$J25+C$35*($T25-$J25),$T25*C$34)+('Incremental Rev Req'!$F$94*$T25)+IF(T25>0,$Q$12,0)","v":0},{"$f":"IF($S25>$I25,D$31*$I25+D$32*($S25-$I25),$S25*D$31)+('Incremental Rev Req'!$F$94*$S25)+IF(S25>0,$Q$12,0)","v":0},{"$f":"IF($T25>$J25,D$34*$J25+D$35*($T25-$J25),$T25*D$34)+('Incremental Rev Req'!$F$94*$T25)+IF(T25>0,$Q$12,0)","v":0},{"$f":"IF($S25>$I25,E$31*$I25+E$32*($S25-$I25),$S25*E$31)+('Incremental Rev Req'!$F$94*$S25)+IF(S25>0,$S$12,0)","v":0},{"$f":"IF($T25>$J25,E$34*$J25+E$35*($T25-$J25),$T25*E$34)+('Incremental Rev Req'!$F$94*$T25)+IF(T25>0,$S$12,0)","v":0},{"$f":"IF($S25>$I25,F$31*$I25+F$32*($S25-$I25),$S25*F$31)+('Incremental Rev Req'!$F$94*$S25)+IF(S25>0,$U$12,0)","v":0},{"$f":"IF($T25>$J25,F$34*$J25+F$35*($T25-$J25),$T25*F$34)+('Incremental Rev Req'!$F$94*$T25)+IF(T25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C53:C56,$V$22:$V$25)","v":28.384298364223},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":51.721798191479024},28.529176365963078,52.005320778563309,28.531230787546804,51.998364611641378,34.028263331206432,62.753456892405985]
[]
[]
[null,null,"Essential Usage Basic Bundled Non-CARE Customer Bill"]
[null,null,{"$f":"C51","v":"2024-01-01"},null,{"$f":"E51","v":"2024-12-01"},null,{"$f":"G51","v":"Authorized"},null,{"$f":"I51","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"($C$22*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$F$12,0)","v":26.463995503035509},{"$f":"($C$25*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$F$12,0)","v":66.640192213845566},{"$f":"($D$22*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$F$12,0)","v":26.591538009868763},{"$f":"($D$25*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$F$12,0)","v":67.006468130905176},{"$f":"($E$22*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$H$12,0)","v":26.584719603039677},{"$f":"($E$25*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$H$12,0)","v":66.986887065139584},{"$f":"($F$22*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$J$12,0)","v":31.422065694271271},{"$f":"($F$25*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$J$12,0)","v":80.87875276303545}]
[null,2,{"$f":"($C$22*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$F$12,0)","v":26.463995503035509},{"$f":"($C$25*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$F$12,0)","v":74.62039567010234},{"$f":"($D$22*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$F$12,0)","v":26.591538009868763},{"$f":"($D$25*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$F$12,0)","v":75.034091237138412},{"$f":"($E$22*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$H$12,0)","v":26.584719603039677},{"$f":"($E$25*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$H$12,0)","v":75.011975122679956},{"$f":"($F$22*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$J$12,0)","v":31.422065694271271},{"$f":"($F$25*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$J$12,0)","v":90.702341290392695}]
[null,3,{"$f":"($C$22*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$F$12,0)","v":26.463995503035509},{"$f":"($C$25*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$F$12,0)","v":112.31997751517754},{"$f":"($D$22*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$F$12,0)","v":26.591538009868763},{"$f":"($D$25*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$F$12,0)","v":112.95769004934381},{"$f":"($E$22*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$H$12,0)","v":26.584719603039677},{"$f":"($E$25*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$H$12,0)","v":112.92359801519837},{"$f":"($F$22*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$J$12,0)","v":31.422065694271271},{"$f":"($F$25*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$J$12,0)","v":137.11032847135635}]
[null,0,{"$f":"($C$22*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($C$25*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($D$22*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($D$25*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($E$22*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$H$12,0)","v":0},{"$f":"($E$25*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$H$12,0)","v":0},{"$f":"($F$22*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$J$12,0)","v":0},{"$f":"($F$25*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C63:C66,$U$22:$U$25)","v":26.463995503035509},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":67.087063731201795},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":26.591538009868763},{"$f":"SUMPRODUCT(F63:F66,$U$22:$U$25)","v":67.455995030552558},26.584719603039677,67.436272008374175,31.422065694271271,81.428849253076891]
[]
[]
[null,null,"Essential Usage Basic Bundled CARE Customer Bill"]
[null,null,{"$f":"C61","v":"2024-01-01"},null,{"$f":"E61","v":"2024-12-01"},null,{"$f":"G61","v":"Authorized"},null,{"$f":"I61","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"($C$31*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$Q$12,0)","v":20.710251218220815},{"$f":"($C$34*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$Q$12,0)","v":51.988413754890544},{"$f":"($D$31*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$Q$12,0)","v":20.809529094499101},{"$f":"($D$34*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$Q$12,0)","v":52.273519450869216},{"$f":"($E$31*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$S$12,0)","v":20.806847434144686},{"$f":"($E$34*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$S$12,0)","v":52.265818272415515},{"$f":"($F$31*$I22)+('Incremental Rev Req'!$F$94*$I22)+IF(I22>0,$U$12,0)","v":24.57278050472161},{"$f":"($F$34*$J22)+('Incremental Rev Req'!$F$94*$J22)+IF(J22>0,$U$12,0)","v":63.08080555202104}]
[null,2,{"$f":"($C$31*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$Q$12,0)","v":20.710251218220815},{"$f":"($C$34*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$Q$12,0)","v":58.201199464229049},{"$f":"($D$31*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$Q$12,0)","v":20.809529094499101},{"$f":"($D$34*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$Q$12,0)","v":58.523216165490666},{"$f":"($E$31*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$S$12,0)","v":20.806847434144686},{"$f":"($E$34*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$S$12,0)","v":58.514517959469295},{"$f":"($F$31*$I23)+('Incremental Rev Req'!$F$94*$I23)+IF(I23>0,$U$12,0)","v":24.57278050472161},{"$f":"($F$34*$J23)+('Incremental Rev Req'!$F$94*$J23)+IF(J23>0,$U$12,0)","v":70.729659842238036}]
[null,3,{"$f":"($C$31*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$Q$12,0)","v":20.710251218220815},{"$f":"($C$34*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$Q$12,0)","v":87.551256091104065},{"$f":"($D$31*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$Q$12,0)","v":20.809529094499101},{"$f":"($D$34*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$Q$12,0)","v":88.047645472495503},{"$f":"($E$31*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$S$12,0)","v":20.806847434144686},{"$f":"($E$34*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$S$12,0)","v":88.034237170723429},{"$f":"($F$31*$I24)+('Incremental Rev Req'!$F$94*$I24)+IF(I24>0,$U$12,0)","v":24.57278050472161},{"$f":"($F$34*$J24)+('Incremental Rev Req'!$F$94*$J24)+IF(J24>0,$U$12,0)","v":106.86390252360805}]
[null,0,{"$f":"($C$31*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($C$34*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($D$31*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($D$34*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($E$31*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$S$12,0)","v":0},{"$f":"($E$34*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$S$12,0)","v":0},{"$f":"($F$31*$I25)+('Incremental Rev Req'!$F$94*$I25)+IF(I25>0,$U$12,0)","v":0},{"$f":"($F$34*$J25)+('Incremental Rev Req'!$F$94*$J25)+IF(J25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C73:C76,$V$22:$V$25)","v":20.710251218220815},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":52.336314280504901},20.809529094499105,52.623486900845634,20.806847434144682,52.615729891331419,24.57278050472161,63.509122341366322]
[]
[]
[null,null,"5-Year Average Monthly Basic Bundled Non-CARE Customer"]
[null,null,{"$f":"C71","v":"2024-01-01"},null,{"$f":"E71","v":"2024-12-01"},null,{"$f":"G71","v":"Authorized"},null,{"$f":"I71","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($Q31>$I22,C$22*$I22+C$23*($Q31-$I22),$Q31*C$22)+('Incremental Rev Req'!$F$94*$Q31)+IF(Q31>0,$F$12,0)","v":47.768627939641547},{"$f":"IF($R31>$J22,C$25*$J22+C$26*($R31-$J22),$R31*C$25)+('Incremental Rev Req'!$F$94*$R31)+IF(R31>0,$F$12,0)","v":94.39152848759062},{"$f":"IF($Q31>$I22,D$22*$I22+D$23*($Q31-$I22),$Q31*D$22)+('Incremental Rev Req'!$F$94*$Q31)+IF(Q31>0,$F$12,0)","v":48.022782000088128},{"$f":"IF($R31>$J22,D$25*$J22+D$26*($R31-$J22),$R31*D$25)+('Incremental Rev Req'!$F$94*$R31)+IF(R31>0,$F$12,0)","v":94.922728151207224},{"$f":"IF($Q31>$I22,E$22*$I22+E$23*($Q31-$I22),$Q31*E$22)+('Incremental Rev Req'!$F$94*$Q31)+IF(Q31>0,$H$12,0)","v":48.02610983722164},{"$f":"IF($R31>$J22,E$25*$J22+E$26*($R31-$J22),$R31*E$25)+('Incremental Rev Req'!$F$94*$R31)+IF(R31>0,$H$12,0)","v":94.916363545709586},{"$f":"IF($Q31>$I22,F$22*$I22+F$23*($Q31-$I22),$Q31*F$22)+('Incremental Rev Req'!$F$94*$Q31)+IF(Q31>0,$J$12,0)","v":57.669286528951517},{"$f":"IF($R31>$J22,F$25*$J22+F$26*($R31-$J22),$R31*F$25)+('Incremental Rev Req'!$F$94*$R31)+IF(R31>0,$J$12,0)","v":115.0682866027705}]
[null,2,{"$f":"IF($Q32>$I23,C$22*$I23+C$23*($Q32-$I23),$Q32*C$22)+('Incremental Rev Req'!$F$94*$Q32)+IF(Q32>0,$F$12,0)","v":40.209571946217338},{"$f":"IF($R32>$J23,C$25*$J23+C$26*($R32-$J23),$R32*C$25)+('Incremental Rev Req'!$F$94*$R32)+IF(R32>0,$F$12,0)","v":104.7952135185711},{"$f":"IF($Q32>$I23,D$22*$I23+D$23*($Q32-$I23),$Q32*D$22)+('Incremental Rev Req'!$F$94*$Q32)+IF(Q32>0,$F$12,0)","v":40.418803202854683},{"$f":"IF($R32>$J23,D$25*$J23+D$26*($R32-$J23),$R32*D$25)+('Incremental Rev Req'!$F$94*$R32)+IF(R32>0,$F$12,0)","v":105.38823536965184},{"$f":"IF($Q32>$I23,E$22*$I23+E$23*($Q32-$I23),$Q32*E$22)+('Incremental Rev Req'!$F$94*$Q32)+IF(Q32>0,$H$12,0)","v":40.41853107052313},{"$f":"IF($R32>$J23,E$25*$J23+E$26*($R32-$J23),$R32*E$25)+('Incremental Rev Req'!$F$94*$R32)+IF(R32>0,$H$12,0)","v":105.38048988863794},{"$f":"IF($Q32>$I23,F$22*$I23+F$23*($Q32-$I23),$Q32*F$22)+('Incremental Rev Req'!$F$94*$Q32)+IF(Q32>0,$J$12,0)","v":48.356560174648571},{"$f":"IF($R32>$J23,F$25*$J23+F$26*($R32-$J23),$R32*F$25)+('Incremental Rev Req'!$F$94*$R32)+IF(R32>0,$J$12,0)","v":127.87759461014357}]
[null,3,{"$f":"IF($Q33>$I24,C$22*$I24+C$23*($Q33-$I24),$Q33*C$22)+('Incremental Rev Req'!$F$94*$Q33)+IF(Q33>0,$F$12,0)","v":43.004135102990134},{"$f":"IF($R33>$J24,C$25*$J24+C$26*($R33-$J24),$R33*C$25)+('Incremental Rev Req'!$F$94*$R33)+IF(R33>0,$F$12,0)","v":141.77917104388843},{"$f":"IF($Q33>$I24,D$22*$I24+D$23*($Q33-$I24),$Q33*D$22)+('Incremental Rev Req'!$F$94*$Q33)+IF(Q33>0,$F$12,0)","v":43.229974202264636},{"$f":"IF($R33>$J24,D$25*$J24+D$26*($R33-$J24),$R33*D$25)+('Incremental Rev Req'!$F$94*$R33)+IF(R33>0,$F$12,0)","v":142.59195696981419},{"$f":"IF($Q33>$I24,E$22*$I24+E$23*($Q33-$I24),$Q33*E$22)+('Incremental Rev Req'!$F$94*$Q33)+IF(Q33>0,$H$12,0)","v":43.231032969193691},{"$f":"IF($R33>$J24,E$25*$J24+E$26*($R33-$J24),$R33*E$25)+('Incremental Rev Req'!$F$94*$R33)+IF(R33>0,$H$12,0)","v":142.57189475596127},{"$f":"IF($Q33>$I24,F$22*$I24+F$23*($Q33-$I24),$Q33*F$22)+('Incremental Rev Req'!$F$94*$Q33)+IF(Q33>0,$J$12,0)","v":51.799450660111546},{"$f":"IF($R33>$J24,F$25*$J24+F$26*($R33-$J24),$R33*F$25)+('Incremental Rev Req'!$F$94*$R33)+IF(R33>0,$J$12,0)","v":173.40393552890376}]
[null,0,{"$f":"IF($Q34>$I25,C$22*$I25+C$23*($Q34-$I25),$Q34*C$22)+('Incremental Rev Req'!$F$94*$Q34)+IF(Q34>0,$F$12,0)","v":0},{"$f":"IF($R34>$J25,C$25*$J25+C$26*($R34-$J25),$R34*C$25)+('Incremental Rev Req'!$F$94*$R34)+IF(R34>0,$F$12,0)","v":0},{"$f":"IF($Q34>$I25,D$22*$I25+D$23*($Q34-$I25),$Q34*D$22)+('Incremental Rev Req'!$F$94*$Q34)+IF(Q34>0,$F$12,0)","v":0},{"$f":"IF($R34>$J25,D$25*$J25+D$26*($R34-$J25),$R34*D$25)+('Incremental Rev Req'!$F$94*$R34)+IF(R34>0,$F$12,0)","v":0},{"$f":"IF($Q34>$I25,E$22*$I25+E$23*($Q34-$I25),$Q34*E$22)+('Incremental Rev Req'!$F$94*$Q34)+IF(Q34>0,$H$12,0)","v":0},{"$f":"IF($R34>$J25,E$25*$J25+E$26*($R34-$J25),$R34*E$25)+('Incremental Rev Req'!$F$94*$R34)+IF(R34>0,$H$12,0)","v":0},{"$f":"IF($Q34>$I25,F$22*$I25+F$23*($Q34-$I25),$Q34*F$22)+('Incremental Rev Req'!$F$94*$Q34)+IF(Q34>0,$J$12,0)","v":0},{"$f":"IF($R34>$J25,F$25*$J25+F$26*($R34-$J25),$R34*F$25)+('Incremental Rev Req'!$F$94*$R34)+IF(R34>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C83:C86,$U$22:$U$25)","v":47.421523328359434},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":94.950040752610434},{"$f":"SUMPRODUCT(E83:E86,$U$22:$U$25)","v":47.673614576681388},95.484559269645899,47.676777106665064,95.478105876184401,57.241655054333641,115.7559240415607]
[]
[]
[null,null,"5-Year Average Monthly Basic Bundled CARE Customer"]
[null,null,{"$f":"C81","v":"2024-01-01"},null,{"$f":"E81","v":"2024-12-01"},null,{"$f":"G81","v":"Authorized"},null,{"$f":"I81","v":"w/Pending"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($S31>$I22,C$31*$I22+C$32*($S31-$I22),$S31*C$31)+('Incremental Rev Req'!$F$94*$S31)+IF(S31>0,$Q$12,0)","v":28.524557409241474},{"$f":"IF($T31>$J22,C$34*$J22+C$35*($T31-$J22),$T31*C$34)+('Incremental Rev Req'!$F$94*$T31)+IF(T31>0,$Q$12,0)","v":49.941051327939576},{"$f":"IF($S31>$I22,D$31*$I22+D$32*($S31-$I22),$S31*D$31)+('Incremental Rev Req'!$F$94*$S31)+IF(S31>0,$Q$12,0)","v":28.670268847358507},{"$f":"IF($T31>$J22,D$34*$J22+D$35*($T31-$J22),$T31*D$34)+('Incremental Rev Req'!$F$94*$T31)+IF(T31>0,$Q$12,0)","v":50.213993365151822},{"$f":"IF($S31>$I22,E$31*$I22+E$32*($S31-$I22),$S31*E$31)+('Incremental Rev Req'!$F$94*$S31)+IF(S31>0,$S$12,0)","v":28.672409830611343},{"$f":"IF($T31>$J22,E$34*$J22+E$35*($T31-$J22),$T31*E$34)+('Incremental Rev Req'!$F$94*$T31)+IF(T31>0,$S$12,0)","v":50.206620747327143},{"$f":"IF($S31>$I22,F$31*$I22+F$32*($S31-$I22),$S31*F$31)+('Incremental Rev Req'!$F$94*$S31)+IF(S31>0,$U$12,0)","v":34.201081788820716},{"$f":"IF($T31>$J22,F$34*$J22+F$35*($T31-$J22),$T31*F$34)+('Incremental Rev Req'!$F$94*$T31)+IF(T31>0,$U$12,0)","v":60.560200848164222}]
[null,2,{"$f":"IF($S32>$I23,C$31*$I23+C$32*($S32-$I23),$S32*C$31)+('Incremental Rev Req'!$F$94*$S32)+IF(S32>0,$Q$12,0)","v":30.321199991465924},{"$f":"IF($T32>$J23,C$34*$J23+C$35*($T32-$J23),$T32*C$34)+('Incremental Rev Req'!$F$94*$T32)+IF(T32>0,$Q$12,0)","v":76.068691010966077},{"$f":"IF($S32>$I23,D$31*$I23+D$32*($S32-$I23),$S32*D$31)+('Incremental Rev Req'!$F$94*$S32)+IF(S32>0,$Q$12,0)","v":30.477587299251297},{"$f":"IF($T32>$J23,D$34*$J23+D$35*($T32-$J23),$T32*D$34)+('Incremental Rev Req'!$F$94*$T32)+IF(T32>0,$Q$12,0)","v":76.49687852936205},{"$f":"IF($S32>$I23,E$31*$I23+E$32*($S32-$I23),$S32*E$31)+('Incremental Rev Req'!$F$94*$S32)+IF(S32>0,$S$12,0)","v":30.480837090714598},{"$f":"IF($T32>$J23,E$34*$J23+E$35*($T32-$J23),$T32*E$34)+('Incremental Rev Req'!$F$94*$T32)+IF(T32>0,$S$12,0)","v":76.49920734759327},{"$f":"IF($S32>$I23,F$31*$I23+F$32*($S32-$I23),$S32*F$31)+('Incremental Rev Req'!$F$94*$S32)+IF(S32>0,$U$12,0)","v":36.414792853966389},{"$f":"IF($T32>$J23,F$34*$J23+F$35*($T32-$J23),$T32*F$34)+('Incremental Rev Req'!$F$94*$T32)+IF(T32>0,$U$12,0)","v":92.744869842680572}]
[null,3,{"$f":"IF($S33>$I24,C$31*$I24+C$32*($S33-$I24),$S33*C$31)+('Incremental Rev Req'!$F$94*$S33)+IF(S33>0,$Q$12,0)","v":41.858761340812819},{"$f":"IF($T33>$J24,C$34*$J24+C$35*($T33-$J24),$T33*C$34)+('Incremental Rev Req'!$F$94*$T33)+IF(T33>0,$Q$12,0)","v":128.54965367366373},{"$f":"IF($S33>$I24,D$31*$I24+D$32*($S33-$I24),$S33*D$31)+('Incremental Rev Req'!$F$94*$S33)+IF(S33>0,$Q$12,0)","v":42.083706247351991},{"$f":"IF($T33>$J24,D$34*$J24+D$35*($T33-$J24),$T33*D$34)+('Incremental Rev Req'!$F$94*$T33)+IF(T33>0,$Q$12,0)","v":129.28966054109981},{"$f":"IF($S33>$I24,E$31*$I24+E$32*($S33-$I24),$S33*E$31)+('Incremental Rev Req'!$F$94*$S33)+IF(S33>0,$S$12,0)","v":42.094076510566012},{"$f":"IF($T33>$J24,E$34*$J24+E$35*($T33-$J24),$T33*E$34)+('Incremental Rev Req'!$F$94*$T33)+IF(T33>0,$S$12,0)","v":129.30155463408624},{"$f":"IF($S33>$I24,F$31*$I24+F$32*($S33-$I24),$S33*F$31)+('Incremental Rev Req'!$F$94*$S33)+IF(S33>0,$U$12,0)","v":50.630657198127615},{"$f":"IF($T33>$J24,F$34*$J24+F$35*($T33-$J24),$T33*F$34)+('Incremental Rev Req'!$F$94*$T33)+IF(T33>0,$U$12,0)","v":157.37957396527258}]
[null,0,{"$f":"IF($S34>$I25,C$31*$I25+C$32*($S34-$I25),$S34*C$31)+('Incremental Rev Req'!$F$94*$S34)+IF(S34>0,$Q$12,0)","v":0},{"$f":"IF($T34>$J25,C$34*$J25+C$35*($T34-$J25),$T34*C$34)+('Incremental Rev Req'!$F$94*$T34)+IF(T34>0,$Q$12,0)","v":0},{"$f":"IF($S34>$I25,D$31*$I25+D$32*($S34-$I25),$S34*D$31)+('Incremental Rev Req'!$F$94*$S34)+IF(S34>0,$Q$12,0)","v":0},{"$f":"IF($T34>$J25,D$34*$J25+D$35*($T34-$J25),$T34*D$34)+('Incremental Rev Req'!$F$94*$T34)+IF(T34>0,$Q$12,0)","v":0},{"$f":"IF($S34>$I25,E$31*$I25+E$32*($S34-$I25),$S34*E$31)+('Incremental Rev Req'!$F$94*$S34)+IF(S34>0,$S$12,0)","v":0},{"$f":"IF($T34>$J25,E$34*$J25+E$35*($T34-$J25),$T34*E$34)+('Incremental Rev Req'!$F$94*$T34)+IF(T34>0,$S$12,0)","v":0},{"$f":"IF($S34>$I25,F$31*$I25+F$32*($S34-$I25),$S34*F$31)+('Incremental Rev Req'!$F$94*$S34)+IF(S34>0,$U$12,0)","v":0},{"$f":"IF($T34>$J25,F$34*$J25+F$35*($T34-$J25),$T34*F$34)+('Incremental Rev Req'!$F$94*$T34)+IF(T34>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C93:C96,$V$22:$V$25)","v":28.631199480462072},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":51.263755896251418},28.777544598791728,51.544557168331501,28.779751396806677,51.537656052944399,34.332479505543432,62.18951585709933]

{"sheet":"Hypothetical Summary","index":6,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[[77,10,77,11],[77,12,77,13],[29,9,29,10],[27,9,27,10],[28,9,28,10],[26,9,26,15],[39,10,39,11],[39,12,39,13],[51,1,51,7],[53,1,53,2],[26,1,26,7],[27,1,27,2],[28,1,28,2],[29,1,29,2],[32,1,32,7],[47,1,47,2],[48,1,48,2],[38,1,38,7],[40,1,40,2],[41,1,41,2],[42,1,42,2],[54,1,54,2],[55,1,55,2],[63,1,63,7],[65,1,65,2],[66,1,66,2],[67,1,67,2],[57,1,57,7],[59,1,59,2],[60,1,60,2],[61,1,61,2],[82,1,82,7],[84,1,84,2],[86,1,86,2],[70,1,70,7],[72,1,72,2],[74,1,74,2],[76,1,76,7],[78,1,78,2],[80,1,80,2],[44,1,44,7],[46,1,46,2],[36,1,36,2],[34,1,34,2],[35,1,35,2]]}
[null,"Inputs:",null,null,null,"Assumptions:"]
[null,null,null,null,null,"Current Effective Rates",null,{"$f":"SetUp!D4","v":"2024-12-01"}]
[null,null,"Baseline Region - (Residential bill)","All",null,"Sales Forecast",null,{"$f":"Summary!I3","v":2024}]
[null,null,null,null,null,"Residential bill calculated using ",null,{"$f":"Summary!I4","v":"Schedule GR, Basic, Bundled, Single Family"}]
[null,null,null,"Revenue Change ($000)",null,"Non-CARE bill impact calculated with average summer usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Hypothetical Res Bill Impact'!Q22:Q25,'Hypothetical Res Bill Impact'!U22:U25),VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$P$22:$T$25,2,FALSE))","v":21.959056211960281},"therms per month"]
[null,null,"Procurement",null,null,"Non-CARE bill impact calculated with average winter usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Hypothetical Res Bill Impact'!R22:R25,'Hypothetical Res Bill Impact'!U22:U25),VLOOKUP(D$3,'Hypothetical Res Bill Impact'!$P$22:$T$25,3,FALSE))","v":65.218490818992549},"therms per month"]
[null,null,"Customer Costs",null,null,"CARE bill impact calculated with average summer usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Hypothetical Res Bill Impact'!S22:S25,'Hypothetical Res Bill Impact'!V22:V25),VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$P$22:$T$25,4,FALSE))","v":21.399222284353826},"therms per month"]
[null,null,"Medium Pressure Distribution",null,null,"CARE bill impact calculated with average winter usage of ",null,null,null,{"$f":"IF($D$3=\"ALL\",SUMPRODUCT('Hypothetical Res Bill Impact'!T22:T25,'Hypothetical Res Bill Impact'!V22:V25),VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$P$22:$T$25,5,FALSE))","v":66.489802226034271},"therms per month"]
[null,null,"High Pressure Distribution",null,null,"Average monthly usage is for all customers (Non-CARE and CARE) based on seasonal usage in",null,null,null,null,{"$f":"Summary!L9","v":2024}]
[null,null,"Local Transmission",null,null,"Summer season",null,{"$f":"Summary!I10","v":6},"months"]
[null,null,"Storage",null,null,"Winter Season",null,{"$f":"Summary!I11","v":6},"months"]
[null,null,"GHG Revenue"]
[null,null,"Other Balancing Acounts"]
[null,null,"NGV Costs"]
[null,null,"Backbone Transmisson"]
[null,null,"Public Purpose Programs"]
[]
[]
[]
[null,null,"Total",{"$f":"SUM(D6:D18)","v":0}]
[]
[]
[]
[]
[null,"Outputs:"]
[null,null,null,"(A)","(B)","(C)","(C)/(A)","(C)/(B)",null,null,null,"(A)","(B)","(C)","(C)/(A)","(C)/(B)"]
[null,"Bundled Average Rates - ¢/therm",null,null,null,null,null,null,null,"Total System (Bundled and Unbundled) Average Rates - ¢/therm"]
[null,"Customer Group",null,{"$f":"Summary!D21","v":"2024-01-01"},{"$f":"Summary!E21","v":"2024-12-01"},"Proposed",{"$f":"Summary!H21","v":"% Change over 1/1/2024"},{"$f":"Summary!I21","v":"% Change over 12/1/2024"},null,"Customer Group",null,{"$f":"D28","v":"2024-01-01"},{"$f":"E28","v":"2024-12-01"},"Proposed",{"$f":"G28","v":"% Change over 1/1/2024"},{"$f":"H28","v":"% Change over 12/1/2024"}]
[null,"Residential",null,183.60041857364715,{"$f":"'Hypothetical SAR and RAR'!G28","v":184.63662234247678},{"$f":"'Hypothetical SAR and RAR'!H28","v":184.63662234247678},{"$f":"$F29/D29-1","v":5.6437985102630872E-3},{"$f":"$F29/E29-1","v":0},null,"Residential",null,182.9996307936587,{"$f":"'Hypothetical SAR and RAR'!R28","v":184.0358345624883},{"$f":"'Hypothetical SAR and RAR'!S28","v":184.0358345624883},{"$f":"$N29/L29-1","v":5.6623271005282749E-3},{"$f":"$N29/M29-1","v":0}]
[null,"System",null,113.1255173900588,{"$f":"'Hypothetical SAR and RAR'!G29","v":115.58268109137062},{"$f":"'Hypothetical SAR and RAR'!H29","v":115.58268109137062},{"$f":"$F30/D30-1","v":2.1720684757970732E-2},{"$f":"$F30/E30-1","v":0},null,"System",null,77.661428234466243,{"$f":"'Hypothetical SAR and RAR'!R29","v":80.118591935778056},{"$f":"'Hypothetical SAR and RAR'!S29","v":80.118591935778056},{"$f":"$N30/L30-1","v":3.1639434879995099E-2},{"$f":"$N30/M30-1","v":0}]
[]
[]
[null,"Basic Bundled Residential Monthly Average Bills"]
[null,null,null,{"$f":"$D$28","v":"2024-01-01"},{"$f":"$E$28","v":"2024-12-01"},{"$f":"$F$28","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},{"$f":"$H$28","v":"% Change over 12/1/2024"}]
[null,"Non-CARE",null,{"$f":"((D41*$H$10)+(D47*$H$11))/12","v":80.681356641881862},{"$f":"((E41*$H$10)+(E47*$H$11))/12","v":81.129425401665557},81.129425401665557,{"$f":"$F35/D35-1","v":5.5535600593892287E-3},0]
[null,"CARE",null,{"$f":"((D42*$H$10)+(D48*$H$11))/12","v":63.317995229103701},63.67753448300035,63.67753448300035,5.6783107645106412E-3,0]
[null,"Total",null,{"$f":"((D43*$H$10)+(D49*$H$11))/12","v":76.39004810800246},76.816237036163585,76.816237036163585,5.5791158497318083E-3,0,null,{"$f":"'Hypothetical Res Bill Impact'!P18","v":"Basic Bundled"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Hypothetical Res Bill Impact'!P19","v":"2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"Basic Bundled Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter"]
[null,null,null,{"$f":"D34","v":"2024-01-01"},{"$f":"E28","v":"2024-12-01"},{"$f":"F28","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2024"},{"$f":"$H$28","v":"% Change over 12/1/2024"},null,null,"Non-CARE",null,"CARE"]
[null,"Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$C$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,2,FALSE)))","v":44.352821472427266},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$E$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,4,FALSE)))","v":44.590161014425135},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$G$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,6,FALSE)))","v":44.590161014425135},{"$f":"$F41/D41-1","v":5.3511712247080734E-3},0,null,{"$f":"Zones","v":1},{"$f":"'Hypothetical Res Bill Impact'!Q22","v":23.702733811833337},{"$f":"'Hypothetical Res Bill Impact'!R22","v":50.815830623000004},{"$f":"'Hypothetical Res Bill Impact'!S22","v":17.651984122333332},{"$f":"'Hypothetical Res Bill Impact'!T22","v":36.094967588500005}]
[null,"CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$C$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,2,FALSE)))","v":33.823036568230897},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$E$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,4,FALSE)))","v":34.006996355553675},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$G$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,6,FALSE)))","v":34.006996355553675},5.4388903536699562E-3,0,null,2,{"$f":"'Hypothetical Res Bill Impact'!Q23","v":19.992271593666668},{"$f":"'Hypothetical Res Bill Impact'!R23","v":57.296892826166669},{"$f":"'Hypothetical Res Bill Impact'!S23","v":18.340279621499999},{"$f":"'Hypothetical Res Bill Impact'!T23","v":53.477491469500002}]
[null,"Total",null,{"$f":"D41*(1-'Hypothetical SAR and RAR'!$AA$16)+D42*'Hypothetical SAR and RAR'!$AA$16","v":41.750413174570923},{"$f":"E41*(1-'Hypothetical SAR and RAR'!$AA$16)+E42*'Hypothetical SAR and RAR'!$AA$16","v":41.974560052353148},{"$f":"F41*(1-'Hypothetical SAR and RAR'!$AA$16)+F42*'Hypothetical SAR and RAR'!$AA$16","v":41.974560052353148},5.3687343606636517E-3,0,null,3,{"$f":"'Hypothetical Res Bill Impact'!Q24","v":22.172026694500001},{"$f":"'Hypothetical Res Bill Impact'!R24","v":81.479840450333327},{"$f":"'Hypothetical Res Bill Impact'!S24","v":25.090080402166667},{"$f":"'Hypothetical Res Bill Impact'!T24","v":88.999667575999993}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q25","v":0},{"$f":"'Hypothetical Res Bill Impact'!R25","v":0},{"$f":"'Hypothetical Res Bill Impact'!S25","v":0},{"$f":"'Hypothetical Res Bill Impact'!T25","v":0}]
[null,"Basic Bundled Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"$D$28","v":"2024-01-01"},{"$f":"$E$28","v":"2024-12-01"},{"$f":"F40","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2024"},{"$f":"$H$28","v":"% Change over 12/1/2024"}]
[null,"Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$D$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,3,FALSE)))","v":117.00989181133647},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$F$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,5,FALSE)))","v":117.66868978890597},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$H$47,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$43:$J$46,7,FALSE)))","v":117.66868978890597},{"$f":"$F47/D47-1","v":5.6302759311299688E-3},0]
[null,"CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$D$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,3,FALSE)))","v":92.812953889976498},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$F$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,5,FALSE)))","v":93.348072610447034},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!$H$57,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$53:$J$56,7,FALSE)))","v":93.348072610447034},5.7655607115454366E-3,0]
[null,"Total",null,{"$f":"D47*(1-'Hypothetical SAR and RAR'!$AA$16)+D48*'Hypothetical SAR and RAR'!$AA$16","v":111.02968304143397},{"$f":"E47*(1-'Hypothetical SAR and RAR'!$AA$16)+E48*'Hypothetical SAR and RAR'!$AA$16","v":111.65791401997402},{"$f":"F47*(1-'Hypothetical SAR and RAR'!$AA$16)+F48*'Hypothetical SAR and RAR'!$AA$16","v":111.65791401997402},5.6582254522477005E-3,0]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"D46","v":"2024-01-01"},{"$f":"E46","v":"2024-12-01"},{"$f":"F46","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D60*$H$10)+(D66*$H$11))/12","v":55.985741897885674},{"$f":"((E60*$H$10)+(E66*$H$11))/12","v":56.274379507708623},56.274379507708623,{"$f":"$F54/D54-1","v":5.1555556832560967E-3},0]
[null,"Essential Use - CARE",null,{"$f":"((D61*$H$10)+(D67*$H$11))/12","v":44.910294652943115},45.148281432471151,45.148281432471151,5.2991587200026391E-3,0]
[null,"Total",null,{"$f":"((D62*$H$10)+(D68*$H$11))/12","v":53.248474605633362},53.524593997634014,53.524593997634014,5.1854892378726536E-3,0]
[null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!H19","v":"Essential Usage"}]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,"Monthly Tier 1 Baseline Allowance -BASIC (th)"]
[null,null,null,{"$f":"D53","v":"2024-01-01"},{"$f":"E53","v":"2024-12-01"},{"$f":"F53","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized",null,"Climate Zone","Summer","Winter"]
[null,"Essential Use  - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!C67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,2,FALSE)))","v":26.03461897749402},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":26.15369897749402},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":26.15369897749402},{"$f":"$F60/D60-1","v":4.5739098430033209E-3},0,null,{"$f":"Zones","v":1},{"$f":"'Hypothetical Res Bill Impact'!I22","v":13},{"$f":"'Hypothetical Res Bill Impact'!J22","v":37.333333333333336}]
[null,"Essential Use - CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!C77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,2,FALSE)))","v":20.376028607752289},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":20.471292607752293},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":20.471292607752293},4.6752977154616016E-3,0,null,2,{"$f":"'Hypothetical Res Bill Impact'!I23","v":13},{"$f":"'Hypothetical Res Bill Impact'!J23","v":42.166666666666664}]
[null,"Total",null,{"$f":"D60*(1-'Hypothetical SAR and RAR'!$AA$16)+D61*'Hypothetical SAR and RAR'!$AA$16","v":24.636113436652703},{"$f":"E60*(1-'Hypothetical SAR and RAR'!$AA$16)+E61*'Hypothetical SAR and RAR'!$AA$16","v":24.749307375675613},{"$f":"F60*(1-'Hypothetical SAR and RAR'!$AA$16)+F61*'Hypothetical SAR and RAR'!$AA$16","v":24.749307375675613},4.5946345925858001E-3,0,null,3,{"$f":"'Hypothetical Res Bill Impact'!I24","v":13},{"$f":"'Hypothetical Res Bill Impact'!J24","v":65}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"'Hypothetical Res Bill Impact'!I25","v":0},{"$f":"'Hypothetical Res Bill Impact'!J25","v":0}]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"D59","v":"2024-01-01"},{"$f":"E59","v":"2024-12-01"},{"$f":"F59","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!D67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,3,FALSE)))","v":85.936864818277314},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":86.395060037923216},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":86.395060037923216},{"$f":"$F66/D66-1","v":5.33176560041837E-3},0]
[null,"Essential Use - CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!D77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,3,FALSE)))","v":69.444560698133927},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":69.825270257190013},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":69.825270257190013},5.4822084728993747E-3,0]
[null,"Total",null,{"$f":"D66*(1-'Hypothetical SAR and RAR'!$AA$16)+D67*'Hypothetical SAR and RAR'!$AA$16","v":81.860835774614031},{"$f":"E66*(1-'Hypothetical SAR and RAR'!$AA$16)+E67*'Hypothetical SAR and RAR'!$AA$16","v":82.299880619592415},{"$f":"F66*(1-'Hypothetical SAR and RAR'!$AA$16)+F67*'Hypothetical SAR and RAR'!$AA$16","v":82.299880619592415},5.3633076284145265E-3,0]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"D65","v":"2024-01-01"},{"$f":"E65","v":"2024-12-01"},{"$f":"F65","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"((D79*$H$10)+(D85*$H$11))/12","v":78.653951360310074},{"$f":"((E79*$H$10)+(E85*$H$11))/12","v":79.088931498537718},79.088931498537718,{"$f":"$F73/D73-1","v":5.5303024286093017E-3},0]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D80*$H$10)+(D86*$H$11))/12","v":64.075814963257173},64.440391739851364,64.440391739851364,5.6897719803212787E-3,0]
[null,"Total",null,{"$f":"((D81*$H$10)+(D87*$H$11))/12","v":75.051003771907503},75.468583906794251,75.468583906794251,5.5639513650722616E-3,0,null,{"$f":"'Hypothetical Res Bill Impact'!P27","v":"Typical Bundled"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Hypothetical Res Bill Impact'!P28","v":"2019-2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"Basic Bundled Typical Residential Monthly Average Bills - Summer",null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter"]
[null,null,null,{"$f":"D72","v":"2024-01-01"},{"$f":"E72","v":"2024-12-01"},{"$f":"F72","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized",null,null,"Non-CARE",null,"CARE"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!C87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,2,FALSE)))","v":42.777276740313177},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":43.004444804052277},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":43.004444804052277},{"$f":"$F79/D79-1","v":5.310484468615595E-3},0,null,{"$f":"Zones","v":1},{"$f":"'Hypothetical Res Bill Impact'!Q31","v":23.211191282000001},{"$f":"'Hypothetical Res Bill Impact'!R31","v":50.634393741933337},{"$f":"'Hypothetical Res Bill Impact'!S31","v":17.783303916800001},{"$f":"'Hypothetical Res Bill Impact'!T31","v":35.740555869799998}]
[null,null,"5-Year Average Usage - CARE",{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!C97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,2,FALSE)))","v":34.782534888599216},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":34.972823478523296},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":34.972823478523296},5.470808569114638E-3,0,null,2,{"$f":"'Hypothetical Res Bill Impact'!Q32","v":19.588177982433333},{"$f":"'Hypothetical Res Bill Impact'!R32","v":56.62928825223333},{"$f":"'Hypothetical Res Bill Impact'!S32","v":18.883067259899999},{"$f":"'Hypothetical Res Bill Impact'!T32","v":53.10374031206667}]
[null,"Total",null,{"$f":"D79*(1-'Hypothetical SAR and RAR'!$AA$16)+D80*'Hypothetical SAR and RAR'!$AA$16","v":40.801397581962249},{"$f":"E79*(1-'Hypothetical SAR and RAR'!$AA$16)+E80*'Hypothetical SAR and RAR'!$AA$16","v":41.019450981959402},{"$f":"F79*(1-'Hypothetical SAR and RAR'!$AA$16)+F80*'Hypothetical SAR and RAR'!$AA$16","v":41.019450981959402},5.3442630135187574E-3,0,null,3,{"$f":"'Hypothetical Res Bill Impact'!Q33","v":20.927596488166667},{"$f":"'Hypothetical Res Bill Impact'!R33","v":79.119626847833331},{"$f":"'Hypothetical Res Bill Impact'!S33","v":25.945455275366669},{"$f":"'Hypothetical Res Bill Impact'!T33","v":90.095995849833329}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q34","v":0},{"$f":"'Hypothetical Res Bill Impact'!R34","v":0},{"$f":"'Hypothetical Res Bill Impact'!S34","v":0},{"$f":"'Hypothetical Res Bill Impact'!T34","v":0}]
[null,"Basic Bundled Typical Residential Monthly Average Bills - Winter"]
[null,null,null,{"$f":"D78","v":"2024-01-01"},{"$f":"E78","v":"2024-12-01"},{"$f":"F78","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2024"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!D87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,3,FALSE)))","v":114.53062598030695},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":115.17341819302317},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":115.17341819302317},{"$f":"$F85/D85-1","v":5.6124046054435439E-3},0]
[null,null,"5-Year Average Usage - CARE",{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!D97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,3,FALSE)))","v":93.369095037915145},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":93.907960001179433},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":93.907960001179433},5.7713418240314951E-3,0]
[null,"Total",null,{"$f":"D85*(1-'Hypothetical SAR and RAR'!$AA$16)+D86*'Hypothetical SAR and RAR'!$AA$16","v":109.30060996185276},{"$f":"E85*(1-'Hypothetical SAR and RAR'!$AA$16)+E86*'Hypothetical SAR and RAR'!$AA$16","v":109.91771683162912},{"$f":"F85*(1-'Hypothetical SAR and RAR'!$AA$16)+F86*'Hypothetical SAR and RAR'!$AA$16","v":109.91771683162912},5.6459599813005745E-3,0]

{"sheet":"Hypothetical SAR and RAR","index":7,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[18,20,18,21],[19,20,19,21],[18,22,18,23],[17,22,17,23],[19,22,19,23],[16,20,16,21],[16,22,16,23],[15,20,15,21],[15,22,15,23],[17,20,17,21],[64,20,64,21],[71,20,71,21],[25,5,25,8],[25,15,25,19],[31,5,31,7],[36,20,36,21],[46,20,46,21],[52,20,52,21]]}
[]
[null,null,"Revenue Change ($000)"]
[null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"'Hypothetical Summary'!D6","v":0},null,null,null,"Allocation"]
[null,"Allocated Base Margin",{"$f":"'Hypothetical Summary'!D7","v":0},null,null,null,{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential"]
[null,"Distribution",{"$f":"'Hypothetical Summary'!D8","v":0},null,null,"Residential",{"$f":"'SAR and RAR'!G5","v":0.66270937539797536},{"$f":"'SAR and RAR'!H5","v":0.74462262420775072},{"$f":"'SAR and RAR'!I5","v":0.61126244041598166},{"$f":"'SAR and RAR'!J5","v":0.38772943906757024},{"$f":"'SAR and RAR'!K5","v":0.41732655419472187},{"$f":"'SAR and RAR'!L5","v":8.3272591170996182E-2},{"$f":"'SAR and RAR'!M5","v":0.55036291215658573},{"$f":"'SAR and RAR'!N5","v":0.52865356398173613},{"$f":"'SAR and RAR'!O5","v":0},{"$f":"'SAR and RAR'!P5","v":0.47118636590796048},{"$f":"'SAR and RAR'!Q5","v":0.25092103633912455},{"$f":"'SAR and RAR'!R5","v":0.74462262420775072},{"$f":"'SAR and RAR'!S5","v":0.6979502783828444},{"$f":"'SAR and RAR'!T5","v":0}]
[null,"ECPT adjusted",{"$f":"'Hypothetical Summary'!D9","v":0}]
[null,"Local Transmission",{"$f":"'Hypothetical Summary'!D10","v":0},null,null,null,"Revenue Change ($000) - System"]
[null,"SGIP",{"$f":"'Hypothetical Summary'!D11","v":0},null,null,"w/Proposed",{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential"]
[null,"GHG End User",{"$f":"'Hypothetical Summary'!D12","v":0},null,null,"Residential",{"$f":"G5*G10","v":0},{"$f":"H5*H10","v":0},{"$f":"I5*I10","v":0},0,0,0,0,0,{"$f":"O5*O10","v":0},0,{"$f":"Q5*Q10","v":0},{"$f":"R5*R10","v":0},{"$f":"S5*S10","v":0},0,{"$f":"SUM(G9:T9)","v":0},"Check"]
[null,"Public Purpose Programs",{"$f":"'Hypothetical Summary'!D13","v":0},null,null,"Total System",{"$f":"C3","v":0},{"$f":"C4","v":0},{"$f":"C5","v":0},{"$f":"C6","v":0},{"$f":"C7","v":0},{"$f":"C8","v":0},{"$f":"C9","v":0},{"$f":"C10","v":0},{"$f":"C11","v":0},{"$f":"C12","v":0},{"$f":"C13","v":0},{"$f":"C14","v":0},{"$f":"C15","v":0},{"$f":"C16","v":0},{"$f":"SUM(G10:T10)","v":0},{"$f":"U10-C17","v":0}]
[null,"Backbone Transmission",{"$f":"'Hypothetical Summary'!D14","v":0}]
[null,"47% Res (LUAF, Other)",{"$f":"'Hypothetical Summary'!D15","v":0}]
[null,"ECPT",{"$f":"'Hypothetical Summary'!D16","v":0}]
[null,"EPAM",{"$f":"'Hypothetical Summary'!D17","v":0}]
[null,"CFCA",{"$f":"'Hypothetical Summary'!D18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"w/Proposed"]
[null,"Non-Residential",{"$f":"'Hypothetical Summary'!D14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total UDC w/Proposed",null,"Commodity w/Proposed",null,null,"% of CARE Sales (Bundled)",{"$f":"'SAR and RAR'!AC15","v":0.24714733696214691}]
[null,"Total",{"$f":"SUM(C3:C16)","v":0},null,null,null,"Revenue Split - Bundled",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bundled Revenue Change",null,"Bundled Revenue Change"]
[null,"CPUC Fee",{"$f":"'SAR and RAR'!D18","v":1E-3},null,null,null,{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","ECPT adjusted","Local Transmission","SGIP","GHG End User","Public Purpose Programs","Backbone Transmission","47% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential","Total",null,"Total"]
[null,null,null,null,null,"Residential",1,1,1,1,1,1,1,1,1,1,1,1,1,0,{"$f":"SUMPRODUCT(H9:S9,H19:S19)","v":0},null,{"$f":"SUMPRODUCT(G9,G19)","v":0}]
[null,null,null,null,null,"Total System",1,1,1,1,1,1,1,1,1,1,1,1,1,0,{"$f":"SUMPRODUCT(H10:S10,H20:S20)","v":0},null,{"$f":"SUMPRODUCT(G10,G20)","v":0}]
[]
[null,null,{"$f":"'SAR and RAR'!C22","v":"TCAP D.20-02-045 SALES DETERMINANTS SYSTEM NET (MTH) Average year Throughput"},{"$f":"'SAR and RAR'!D22","v":"TCAP D.20-02-045 SALES DETERMINANTS BUNDLED (MTH)Average year throughput"}]
[null,"Residential",{"$f":"'SAR and RAR'!C23","v":2346352.6450134837},{"$f":"'SAR and RAR'!D23","v":2318963.2675040946}]
[null,"Total System",{"$f":"'SAR and RAR'!C24","v":9350960.2831479758},{"$f":"'SAR and RAR'!D24","v":3290999.2211096496}]
[]
[null,null,null,null,null,"Bundled",null,null,null,null,null,null,null,null,null,"System (Bundled and Unbundled)"]
[null,null,null,null,null,{"$f":"Summary!I3&\" Authorized Sales Forecast\"","v":"2024 Authorized Sales Forecast"},{"$f":"'SAR and RAR'!G27","v":"12/01/2024 Avg Rates(sales adj.)"},"Proposed Avg Rates","% Change",null,null,null,null,null,null,null,{"$f":"F27","v":"2024 Authorized Sales Forecast"},{"$f":"G27","v":"12/01/2024 Avg Rates(sales adj.)"},"Proposed Avg Rates","% Change"]
[null,null,null,null,"Residential",{"$f":"'SAR and RAR'!F28","v":2318963.2675040946},184.63662234247678,{"$f":"(U19/C23*100)+(W19/D23*100)+G28","v":184.63662234247678},{"$f":"H28/G28-1","v":0},null,null,null,null,null,null,"Residential",{"$f":"'SAR and RAR'!Q28","v":2346352.6450134837},184.0358345624883,{"$f":"U9/Q28*100+R28","v":184.0358345624883},{"$f":"S28/R28-1","v":0}]
[null,null,null,null,"Total System",{"$f":"'SAR and RAR'!F29","v":3290999.2211096496},115.58268109137062,{"$f":"(U20/C24*100)+(W20/D24*100)+G29","v":115.58268109137062},{"$f":"H29/G29-1","v":0},null,null,null,null,null,null,"Total System",{"$f":"'SAR and RAR'!Q29","v":9350960.2831479758},80.118591935778056,{"$f":"U10/Q29*100+R29","v":80.118591935778056},{"$f":"S29/R29-1","v":0}]

{"sheet":"Hypothetical Res Bill Impact","index":8,"n_rows":97,"n_cols":25,"rows_kept":97,"cut":false,"hidden":false,"merged":[[28,20,28,21],[29,16,29,17],[29,18,29,19],[39,11,39,16],[79,11,79,16],[89,11,89,16],[90,2,90,3],[90,4,90,5],[90,6,90,7],[90,8,90,9],[89,2,89,7],[80,2,80,3],[80,4,80,5],[80,6,80,7],[80,8,80,9],[79,2,79,7],[70,8,70,9],[69,2,69,7],[20,16,20,17],[20,18,20,19],[1,1,1,3],[50,4,50,5],[50,6,50,7],[39,2,39,7],[70,2,70,3],[70,4,70,5],[70,6,70,7],[49,11,49,16],[59,11,59,16],[69,11,69,16],[19,20,19,21],[2,4,2,8],[2,15,2,19],[50,8,50,9],[60,8,60,9],[49,2,49,7],[59,2,59,7],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[38,1,38,7],[60,2,60,3],[60,4,60,5],[60,6,60,7],[50,2,50,3]]}
[]
[]
[null,null,null,null,"Schedule GR",null,null,null,null,null,null,null,null,null,null,"Schedule GR [CARE]"]
[null,null,null,null,{"$f":"'Res Bill Impact'!E4","v":2024},{"$f":"'Res Bill Impact'!F4","v":"2024-12-01"},{"$f":"'Res Bill Impact'!G4","v":"2024-12-01"},"Proposed","Proposed",null,null,null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"'Res Bill Impact'!Q4","v":"2024-12-01"},{"$f":"'Res Bill Impact'!R4","v":"2024-12-01"},"Proposed","Proposed"]
[null,null,null,null,"Sales Forecast","Rates","Revenue","Rates","Revenue",null,null,null,null,null,null,"Sales Forecast","Rates","Revenue","Rates","Revenue"]
[]
[null,null,null,"Baseline",{"$f":"'Res Bill Impact'!E7","v":1205788.2452481429},{"$f":"'Res Bill Impact'!F7","v":1.6262076136533858},{"$f":"F7*E7","v":1960862.024876286},{"$f":"(Y10/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*(1+(Q7/F7-1)),SUM(P9)*(1+(Q9/F9-1))*F9/F7))","v":1.6262076136533858},{"$f":"E7*H7","v":1960862.024876286},null,null,null,null,null,"Baseline ",{"$f":"'Res Bill Impact'!P7","v":419691.96036134037},{"$f":"'Res Bill Impact'!Q7","v":1.2660225082886378},{"$f":"'Res Bill Impact'!R7","v":531339.46836523968},{"$f":"H7*(1+(Q7/F7-1))","v":1.2660225082886378},{"$f":"P7*S7","v":531339.46836523968},null,null,null,"Bundled Residential Rev Req "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current",{"$f":"(SUM(G7:G9)+SUM(R7:R9))","v":3891862.5479114167}]
[null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!E9","v":534746.29266911256},{"$f":"'Res Bill Impact'!F9","v":2.0568576136533858},{"$f":"F9*E9","v":1099896.983449386},{"$f":"F9/F$7*H$7","v":2.0568576136533858},{"$f":"E9*H9","v":1099896.983449386},null,null,null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!P9","v":186126.14673488794},{"$f":"'Res Bill Impact'!Q9","v":1.6105425082886375},{"$f":"'Res Bill Impact'!R9","v":299764.0712205054},{"$f":"H9*(1+(Q9/F9-1))","v":1.6105425082886375},{"$f":"P9*S9","v":299764.0712205054},null,null,null,"Change (Proposed)",{"$f":"'Hypothetical SAR and RAR'!U9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed (w/ Current Revenues)",{"$f":"Y8+Y9","v":3891862.5479114167}]
[null,null,null,null,"Non-CARE customers",null,null,null,null,null,null,null,null,null,null,"CARE Customers"]
[null,null,null,"Fixed Charge",{"$f":"E13-P12","v":3924404.1114388667},5,{"$f":"F12*12*E12/1000","v":235464.24668633199},5,{"$f":"(H12*12*E12)/1000","v":235464.24668633199},null,null,null,null,null,"Fixed Charge",{"$f":"'Res Bill Impact'!P12","v":1790127},{"$f":"F12*(1-CAREDiscountPercent)","v":4},{"$f":"Q12*12*P12/1000","v":85926.096000000005},{"$f":"H12*(1-CAREDiscountPercent)","v":4},{"$f":"(S12*12*P12)/1000","v":85926.096000000005}]
[null,null,null,"Total Customers",{"$f":"'Res Bill Impact'!E13","v":5714531.1114388667}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P18","v":"Basic Bundled"}]
[null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!H19","v":"Essential Usage"},null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P19","v":"2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"SCHEDULE DR RATES ($/th)",null,null,null,null,null,"Monthly Tier 1 Baseline Allowance -BASIC (th)",null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter","Population Weight"]
[null,"Rates",{"$f":"'Res Bill Impact'!C21","v":"2024-01-01"},{"$f":"'Res Bill Impact'!D21","v":"2024-12-01"},"Proposed",null,null,"Climate Zone","Summer","Winter",null,null,null,null,null,null,"Non-CARE",null,"CARE",null,"Non-CARE","CARE"]
["Summer","Tier 1",1.6170476136533858,1.6262076136533858,{"$f":"H7","v":1.6262076136533858},null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!I22","v":13},{"$f":"'Res Bill Impact'!J22","v":37.333333333333336},null,null,null,null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!Q22","v":23.702733811833337},{"$f":"'Res Bill Impact'!R22","v":50.815830623000004},{"$f":"'Res Bill Impact'!S22","v":17.651984122333332},{"$f":"'Res Bill Impact'!T22","v":36.094967588500005},{"$f":"SUM(Q22:R22)/SUM($Q$22:$R$25)","v":0.29170391561638259},{"$f":"SUM(S22:T22)/SUM($S$22:$T$25)","v":0.22426851264616052}]
[null,"Tier 2",2.0436576136533859,2.0568576136533858,{"$f":"H9","v":2.0568576136533858},null,null,2,{"$f":"'Res Bill Impact'!I23","v":13},{"$f":"'Res Bill Impact'!J23","v":42.166666666666664},null,null,null,null,null,2,{"$f":"'Res Bill Impact'!Q23","v":19.992271593666668},{"$f":"'Res Bill Impact'!R23","v":57.296892826166669},{"$f":"'Res Bill Impact'!S23","v":18.340279621499999},{"$f":"'Res Bill Impact'!T23","v":53.477491469500002},{"$f":"SUM(Q23:R23)/SUM($Q$22:$R$25)","v":0.30254946625682688},{"$f":"SUM(S23:T23)/SUM($S$22:$T$25)","v":0.29967215240031081}]
[null,null,null,null,null,null,null,3,{"$f":"'Res Bill Impact'!I24","v":13},{"$f":"'Res Bill Impact'!J24","v":65},null,null,null,null,null,3,{"$f":"'Res Bill Impact'!Q24","v":22.172026694500001},{"$f":"'Res Bill Impact'!R24","v":81.479840450333327},{"$f":"'Res Bill Impact'!S24","v":25.090080402166667},{"$f":"'Res Bill Impact'!T24","v":88.999667575999993},{"$f":"SUM(Q24:R24)/SUM($Q$22:$R$25)","v":0.40574661812679064},{"$f":"SUM(S24:T24)/SUM($S$22:$T$25)","v":0.47605933495352865}]
["Winter","Tier 1",{"$f":"C22","v":1.6170476136533858},1.6262076136533858,1.6262076136533858,null,null,0,{"$f":"'Res Bill Impact'!I25","v":0},{"$f":"'Res Bill Impact'!J25","v":0},null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q25","v":0},{"$f":"'Res Bill Impact'!R25","v":0},{"$f":"'Res Bill Impact'!S25","v":0},{"$f":"'Res Bill Impact'!T25","v":0},{"$f":"SUM(Q25:R25)/SUM($Q$22:$R$25)","v":0},{"$f":"SUM(S25:T25)/SUM($S$22:$T$25)","v":0}]
[null,"Tier 2",2.0436576136533859,2.0568576136533858,2.0568576136533858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P27","v":"Typical Bundled"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Res Bill Impact'!P28","v":"2019-2023 Recorded Data - Average Monthly Usage - ALL-BASIC th"}]
[null,"SCHEDULE DR [CARE] ($/th)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Climate Zone","Summer","Winter","Summer","Winter","Population Weight"]
[null,"Rates",{"$f":"C21","v":"2024-01-01"},{"$f":"D21","v":"2024-12-01"},"Proposed",null,null,null,null,null,null,null,null,null,null,null,"Non-CARE",null,"CARE",null,"Non-CARE","CARE"]
["Summer","Tier 1",1.2586945082886376,1.2660225082886378,{"$f":"S7","v":1.2660225082886378},null,null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":1},{"$f":"'Res Bill Impact'!Q31","v":23.211191282000001},{"$f":"'Res Bill Impact'!R31","v":50.634393741933337},{"$f":"'Res Bill Impact'!S31","v":17.783303916800001},{"$f":"'Res Bill Impact'!T31","v":35.740555869799998},{"$f":"SUM(Q31:R31)/SUM($Q$31:$R$34)","v":0.29525210487105552},{"$f":"SUM(S31:T31)/SUM($S$31:$T$34)","v":0.2215830692049883}]
[null,"Tier 2",1.5999825082886376,1.6105425082886375,{"$f":"S9","v":1.6105425082886375},null,null,null,null,null,null,null,null,null,null,2,{"$f":"'Res Bill Impact'!Q32","v":19.588177982433333},{"$f":"'Res Bill Impact'!R32","v":56.62928825223333},{"$f":"'Res Bill Impact'!S32","v":18.883067259899999},{"$f":"'Res Bill Impact'!T32","v":53.10374031206667},{"$f":"SUM(Q32:R32)/SUM($Q$31:$R$34)","v":0.30473544662731833},{"$f":"SUM(S32:T32)/SUM($S$31:$T$34)","v":0.29801770327592669}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"'Res Bill Impact'!Q33","v":20.927596488166667},{"$f":"'Res Bill Impact'!R33","v":79.119626847833331},{"$f":"'Res Bill Impact'!S33","v":25.945455275366669},{"$f":"'Res Bill Impact'!T33","v":90.095995849833329},0.40001244850162609,0.48039922751908498]
["Winter","Tier 1",{"$f":"C31","v":1.2586945082886376},1.2660225082886378,1.2660225082886378,null,null,null,null,null,null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q34","v":0},{"$f":"'Res Bill Impact'!R34","v":0},{"$f":"'Res Bill Impact'!S34","v":0},{"$f":"'Res Bill Impact'!T34","v":0},0,0]
[null,"Tier 2",1.5999825082886376,1.6105425082886375,1.6105425082886375]
[]
[]
[]
[null,"Note: Bill inserts include CPUC fee in the calculations"]
[null,null,"2023 Recorded Average Basic Bundled Non-CARE Customer "]
[null,null,{"$f":"C30","v":"2024-01-01"},null,{"$f":"D30","v":"2024-12-01"},null,{"$f":"E30","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($Q22>$I22,C$22*$I22+C$23*($Q22-$I22),$Q22*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q22)+IF(Q22>0,$F$12,0)","v":47.91804515276457},{"$f":"IF($R22>$J22,C$25*$J22+C$26*($R22-$J22),$R22*C$25)+('Hypothetical SAR and RAR'!$C$18*$R22)+IF(R22>0,$F$12,0)","v":92.974201644104497},{"$f":"IF($Q22>$I22,D$22*$I22+D$23*($Q22-$I22),$Q22*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q22)+IF(Q22>0,$F$12,0)","v":48.17840123908077},{"$f":"IF($R22>$J22,D$25*$J22+D$26*($R22-$J22),$R22*D$25)+('Hypothetical SAR and RAR'!$C$18*$R22)+IF(R22>0,$F$12,0)","v":93.494143941661434},{"$f":"IF($Q22>$I22,E$22*$I22+E$23*($Q22-$I22),$Q22*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q22)+IF(Q22>0,$H$12,0)","v":48.17840123908077},{"$f":"IF($R22>$J22,E$25*$J22+E$26*($R22-$J22),$R22*E$25)+('Hypothetical SAR and RAR'!$C$18*$R22)+IF(R22>0,$H$12,0)","v":93.494143941661434}]
[null,2,{"$f":"IF($Q23>$I23,C$22*$I23+C$23*($Q23-$I23),$Q23*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q23)+IF(Q23>0,$F$12,0)","v":40.331420328216865},{"$f":"IF($R23>$J23,C$25*$J23+C$26*($R23-$J23),$R23*C$25)+('Hypothetical SAR and RAR'!$C$18*$R23)+IF(R23>0,$F$12,0)","v":104.16380648903709},{"$f":"IF($Q23>$I23,D$22*$I23+D$23*($Q23-$I23),$Q23*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q23)+IF(Q23>0,$F$12,0)","v":40.542798313253257},{"$f":"IF($R23>$J23,D$25*$J23+D$26*($R23-$J23),$R23*D$25)+('Hypothetical SAR and RAR'!$C$18*$R23)+IF(R23>0,$F$12,0)","v":104.74977214100915},{"$f":"IF($Q23>$I23,E$22*$I23+E$23*($Q23-$I23),$Q23*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q23)+IF(Q23>0,$H$12,0)","v":40.542798313253257},{"$f":"IF($R23>$J23,E$25*$J23+E$26*($R23-$J23),$R23*E$25)+('Hypothetical SAR and RAR'!$C$18*$R23)+IF(R23>0,$H$12,0)","v":104.74977214100915}]
[null,3,{"$f":"IF($Q24>$I24,C$22*$I24+C$23*($Q24-$I24),$Q24*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q24)+IF(Q24>0,$F$12,0)","v":44.788273191035536},{"$f":"IF($R24>$J24,C$25*$J24+C$26*($R24-$J24),$R24*C$25)+('Hypothetical SAR and RAR'!$C$18*$R24)+IF(R24>0,$F$12,0)","v":143.86872613603717},{"$f":"IF($Q24>$I24,D$22*$I24+D$23*($Q24-$I24),$Q24*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q24)+IF(Q24>0,$F$12,0)","v":45.028423943402935},{"$f":"IF($R24>$J24,D$25*$J24+D$26*($R24-$J24),$R24*D$25)+('Hypothetical SAR and RAR'!$C$18*$R24)+IF(R24>0,$F$12,0)","v":144.68166002998154},{"$f":"IF($Q24>$I24,E$22*$I24+E$23*($Q24-$I24),$Q24*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q24)+IF(Q24>0,$H$12,0)","v":45.028423943402935},{"$f":"IF($R24>$J24,E$25*$J24+E$26*($R24-$J24),$R24*E$25)+('Hypothetical SAR and RAR'!$C$18*$R24)+IF(R24>0,$H$12,0)","v":144.68166002998154}]
[null,0,{"$f":"IF($Q25>$I25,C$22*$I25+C$23*($Q25-$I25),$Q25*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q25)+IF(Q25>0,$F$12,0)","v":0},{"$f":"IF($R25>$J25,C$25*$J25+C$26*($R25-$J25),$R25*C$25)+('Hypothetical SAR and RAR'!$C$18*$R25)+IF(R25>0,$F$12,0)","v":0},{"$f":"IF($Q25>$I25,D$22*$I25+D$23*($Q25-$I25),$Q25*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q25)+IF(Q25>0,$F$12,0)","v":0},{"$f":"IF($R25>$J25,D$25*$J25+D$26*($R25-$J25),$R25*D$25)+('Hypothetical SAR and RAR'!$C$18*$R25)+IF(R25>0,$F$12,0)","v":0},{"$f":"IF($Q25>$I25,E$22*$I25+E$23*($Q25-$I25),$Q25*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q25)+IF(Q25>0,$H$12,0)","v":0},{"$f":"IF($R25>$J25,E$25*$J25+E$26*($R25-$J25),$R25*E$25)+('Hypothetical SAR and RAR'!$C$18*$R25)+IF(R25>0,$H$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C43:C46,$U$22:$U$25)","v":44.352821472427266},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":117.00989181133647},44.590161014425135,117.66868978890597,44.590161014425135,117.66868978890597]
[]
[]
[null,null,"2023 Recorded Average Basic Bundled CARE Customer "]
[null,null,{"$f":"C30","v":"2024-01-01"},null,{"$f":"D30","v":"2024-12-01"},null,{"$f":"E30","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($S22>$I22,C$31*$I22+C$32*($S22-$I22),$S22*C$31)+('Hypothetical SAR and RAR'!$C$18*$S22)+IF(S22>0,$Q$12,0)","v":27.823773816444422},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$Q$12,0)","v":49.468632448089821},{"$f":"IF($S22>$I22,D$31*$I22+D$32*($S22-$I22),$S22*D$31)+('Hypothetical SAR and RAR'!$C$18*$S22)+IF(S22>0,$Q$12,0)","v":27.968162768776267},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$Q$12,0)","v":49.733136370578357},{"$f":"IF($S22>$I22,E$31*$I22+E$32*($S22-$I22),$S22*E$31)+('Hypothetical SAR and RAR'!$C$18*$S22)+IF(S22>0,$S$12,0)","v":27.968162768776267},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$S$12,0)","v":49.733136370578357}]
[null,2,{"$f":"IF($S23>$I23,C$31*$I23+C$32*($S23-$I23),$S23*C$31)+('Hypothetical SAR and RAR'!$C$18*$S23)+IF(S23>0,$Q$12,0)","v":28.925722871144053},{"$f":"IF($T23>$J23,C$34*$J23+C$35*($T23-$J23),$T23*C$34)+('Hypothetical SAR and RAR'!$C$18*$T23)+IF(T23>0,$Q$12,0)","v":75.225551096490989},{"$f":"IF($S23>$I23,D$31*$I23+D$32*($S23-$I23),$S23*D$31)+('Hypothetical SAR and RAR'!$C$18*$S23)+IF(S23>0,$Q$12,0)","v":29.077380223947099},{"$f":"IF($T23>$J23,D$34*$J23+D$35*($T23-$J23),$T23*D$34)+('Hypothetical SAR and RAR'!$C$18*$T23)+IF(T23>0,$Q$12,0)","v":75.653990739742255},{"$f":"IF($S23>$I23,E$31*$I23+E$32*($S23-$I23),$S23*E$31)+('Hypothetical SAR and RAR'!$C$18*$S23)+IF(S23>0,$S$12,0)","v":29.077380223947099},{"$f":"IF($T23>$J23,E$34*$J23+E$35*($T23-$J23),$T23*E$34)+('Hypothetical SAR and RAR'!$C$18*$T23)+IF(T23>0,$S$12,0)","v":75.653990739742255}]
[null,3,{"$f":"IF($S24>$I24,C$31*$I24+C$32*($S24-$I24),$S24*C$31)+('Hypothetical SAR and RAR'!$C$18*$S24)+IF(S24>0,$Q$12,0)","v":39.732035855424378},{"$f":"IF($T24>$J24,C$34*$J24+C$35*($T24-$J24),$T24*C$34)+('Hypothetical SAR and RAR'!$C$18*$T24)+IF(T24>0,$Q$12,0)","v":124.30319103267941},{"$f":"IF($S24>$I24,D$31*$I24+D$32*($S24-$I24),$S24*D$31)+('Hypothetical SAR and RAR'!$C$18*$S24)+IF(S24>0,$Q$12,0)","v":39.954971104471255},{"$f":"IF($T24>$J24,D$34*$J24+D$35*($T24-$J24),$T24*D$34)+('Hypothetical SAR and RAR'!$C$18*$T24)+IF(T24>0,$Q$12,0)","v":125.03294752228199},{"$f":"IF($S24>$I24,E$31*$I24+E$32*($S24-$I24),$S24*E$31)+('Hypothetical SAR and RAR'!$C$18*$S24)+IF(S24>0,$S$12,0)","v":39.954971104471255},{"$f":"IF($T24>$J24,E$34*$J24+E$35*($T24-$J24),$T24*E$34)+('Hypothetical SAR and RAR'!$C$18*$T24)+IF(T24>0,$S$12,0)","v":125.03294752228199}]
[null,0,{"$f":"IF($S25>$I25,C$31*$I25+C$32*($S25-$I25),$S25*C$31)+('Hypothetical SAR and RAR'!$C$18*$S25)+IF(S25>0,$Q$12,0)","v":0},{"$f":"IF($T25>$J25,C$34*$J25+C$35*($T25-$J25),$T25*C$34)+('Hypothetical SAR and RAR'!$C$18*$T25)+IF(T25>0,$Q$12,0)","v":0},{"$f":"IF($S25>$I25,D$31*$I25+D$32*($S25-$I25),$S25*D$31)+('Hypothetical SAR and RAR'!$C$18*$S25)+IF(S25>0,$Q$12,0)","v":0},{"$f":"IF($T25>$J25,D$34*$J25+D$35*($T25-$J25),$T25*D$34)+('Hypothetical SAR and RAR'!$C$18*$T25)+IF(T25>0,$Q$12,0)","v":0},{"$f":"IF($S25>$I25,E$31*$I25+E$32*($S25-$I25),$S25*E$31)+('Hypothetical SAR and RAR'!$C$18*$S25)+IF(S25>0,$S$12,0)","v":0},{"$f":"IF($T25>$J25,E$34*$J25+E$35*($T25-$J25),$T25*E$34)+('Hypothetical SAR and RAR'!$C$18*$T25)+IF(T25>0,$S$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C53:C56,$V$22:$V$25)","v":33.823036568230897},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":92.812953889976498},34.006996355553675,93.348072610447034,34.006996355553675,93.348072610447034]
[]
[]
[null,null,"Essential Usage Basic Bundled Non-CARE Customer"]
[null,null,{"$f":"C51","v":"2024-01-01"},null,{"$f":"D30","v":"2024-12-01"},null,{"$f":"G51","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"($C$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":26.034618977494016},{"$f":"($C$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":65.407110909726413},{"$f":"($D$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":26.153698977494017},{"$f":"($D$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":65.749084243059741},{"$f":"($E$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$H$12,0)","v":26.153698977494017},{"$f":"($E$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$H$12,0)","v":65.749084243059741}]
[null,2,{"$f":"($C$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$F$12,0)","v":26.034618977494016},{"$f":"($C$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$F$12,0)","v":73.227674375717754},{"$f":"($D$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$F$12,0)","v":26.153698977494017},{"$f":"($D$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$F$12,0)","v":73.613921042384419},{"$f":"($E$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$H$12,0)","v":26.153698977494017},{"$f":"($E$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$H$12,0)","v":73.613921042384419}]
[null,3,{"$f":"($C$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$F$12,0)","v":26.034618977494016},{"$f":"($C$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$F$12,0)","v":110.17309488747007},{"$f":"($D$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$F$12,0)","v":26.153698977494017},{"$f":"($D$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$F$12,0)","v":110.76849488747008},{"$f":"($E$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$H$12,0)","v":26.153698977494017},{"$f":"($E$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$H$12,0)","v":110.76849488747008}]
[null,0,{"$f":"($C$22*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($C$25*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($D$22*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($D$25*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($E$22*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$H$12,0)","v":0},{"$f":"($E$25*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$H$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C63:C66,$U$22:$U$25)","v":26.03461897749402},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":85.936864818277314},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":26.15369897749402},86.395060037923216,26.15369897749402,86.395060037923216]
[]
[]
[null,null,"Essential Usage Basic Bundled CARE Customer"]
[null,null,{"$f":"C51","v":"2024-01-01"},null,{"$f":"E61","v":"2024-12-01"},null,{"$f":"G61","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"($C$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":20.376028607752289},{"$f":"($C$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":51.02859497610914},{"$f":"($D$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":20.471292607752293},{"$f":"($D$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":51.30217364277582},{"$f":"($E$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$S$12,0)","v":20.471292607752293},{"$f":"($E$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$S$12,0)","v":51.30217364277582}]
[null,2,{"$f":"($C$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$Q$12,0)","v":20.376028607752289},{"$f":"($C$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$Q$12,0)","v":57.11711843283755},{"$f":"($D$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$Q$12,0)","v":20.471292607752293},{"$f":"($D$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$Q$12,0)","v":57.426115766170895},{"$f":"($E$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$S$12,0)","v":20.471292607752293},{"$f":"($E$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$S$12,0)","v":57.426115766170895}]
[null,3,{"$f":"($C$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$Q$12,0)","v":20.376028607752289},{"$f":"($C$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$Q$12,0)","v":85.880143038761446},{"$f":"($D$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$Q$12,0)","v":20.471292607752293},{"$f":"($D$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$Q$12,0)","v":86.356463038761461},{"$f":"($E$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$S$12,0)","v":20.471292607752293},{"$f":"($E$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$S$12,0)","v":86.356463038761461}]
[null,0,{"$f":"($C$31*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($C$34*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($D$31*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($D$34*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($E$31*$I25)+('Hypothetical SAR and RAR'!$C$18*$I25)+IF(I25>0,$S$12,0)","v":0},{"$f":"($E$34*$J25)+('Hypothetical SAR and RAR'!$C$18*$J25)+IF(J25>0,$S$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C73:C76,$V$22:$V$25)","v":20.376028607752289},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":69.444560698133927},20.471292607752293,69.825270257190013,20.471292607752293,69.825270257190013]
[]
[]
[null,null,"5-Year Average Monthly Usage Basic Bundled Non-CARE Customer "]
[null,null,{"$f":"C71","v":"2024-01-01"},null,{"$f":"E71","v":"2024-12-01"},null,{"$f":"G71","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($Q31>$I22,C$22*$I22+C$23*($Q31-$I22),$Q31*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q31)+IF(Q31>0,$F$12,0)","v":46.913008976706394},{"$f":"IF($R31>$J22,C$25*$J22+C$26*($R31-$J22),$R31*C$25)+('Hypothetical SAR and RAR'!$C$18*$R31)+IF(R31>0,$F$12,0)","v":92.603225343834012},{"$f":"IF($Q31>$I22,D$22*$I22+D$23*($Q31-$I22),$Q31*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q31)+IF(Q31>0,$F$12,0)","v":47.166876701628794},{"$f":"IF($R31>$J22,D$25*$J22+D$26*($R31-$J22),$R31*D$25)+('Hypothetical SAR and RAR'!$C$18*$R31)+IF(R31>0,$F$12,0)","v":93.120772674560868},{"$f":"IF($Q31>$I22,E$22*$I22+E$23*($Q31-$I22),$Q31*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q31)+IF(Q31>0,$H$12,0)","v":47.166876701628794},{"$f":"IF($R31>$J22,E$25*$J22+E$26*($R31-$J22),$R31*E$25)+('Hypothetical SAR and RAR'!$C$18*$R31)+IF(R31>0,$H$12,0)","v":93.120772674560868}]
[null,2,{"$f":"IF($Q32>$I23,C$22*$I23+C$23*($Q32-$I23),$Q32*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q32)+IF(Q32>0,$F$12,0)","v":39.505187249379937},{"$f":"IF($R32>$J23,C$25*$J23+C$26*($R32-$J23),$R32*C$25)+('Hypothetical SAR and RAR'!$C$18*$R32)+IF(R32>0,$F$12,0)","v":102.79878371403446},{"$f":"IF($Q32>$I23,D$22*$I23+D$23*($Q32-$I23),$Q32*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q32)+IF(Q32>0,$F$12,0)","v":39.711231198748052},{"$f":"IF($R32>$J23,D$25*$J23+D$26*($R32-$J23),$R32*D$25)+('Hypothetical SAR and RAR'!$C$18*$R32)+IF(R32>0,$F$12,0)","v":103.3759369856306},{"$f":"IF($Q32>$I23,E$22*$I23+E$23*($Q32-$I23),$Q32*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q32)+IF(Q32>0,$H$12,0)","v":39.711231198748052},{"$f":"IF($R32>$J23,E$25*$J23+E$26*($R32-$J23),$R32*E$25)+('Hypothetical SAR and RAR'!$C$18*$R32)+IF(R32>0,$H$12,0)","v":103.3759369856306}]
[null,3,{"$f":"IF($Q33>$I24,C$22*$I24+C$23*($Q33-$I24),$Q33*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q33)+IF(Q33>0,$F$12,0)","v":42.243839494995832},{"$f":"IF($R33>$J24,C$25*$J24+C$26*($R33-$J24),$R33*C$25)+('Hypothetical SAR and RAR'!$C$18*$R33)+IF(R33>0,$F$12,0)","v":139.04289742383725},{"$f":"IF($Q33>$I24,D$22*$I24+D$23*($Q33-$I24),$Q33*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q33)+IF(Q33>0,$F$12,0)","v":42.467563768639636},{"$f":"IF($R33>$J24,D$25*$J24+D$26*($R33-$J24),$R33*D$25)+('Hypothetical SAR and RAR'!$C$18*$R33)+IF(R33>0,$F$12,0)","v":139.82467649822865},{"$f":"IF($Q33>$I24,E$22*$I24+E$23*($Q33-$I24),$Q33*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q33)+IF(Q33>0,$H$12,0)","v":42.467563768639636},{"$f":"IF($R33>$J24,E$25*$J24+E$26*($R33-$J24),$R33*E$25)+('Hypothetical SAR and RAR'!$C$18*$R33)+IF(R33>0,$H$12,0)","v":139.82467649822865}]
[null,0,{"$f":"IF($Q34>$I25,C$22*$I25+C$23*($Q34-$I25),$Q34*C$22)+('Hypothetical SAR and RAR'!$C$18*$Q34)+IF(Q34>0,$F$12,0)","v":0},{"$f":"IF($R34>$J25,C$25*$J25+C$26*($R34-$J25),$R34*C$25)+('Hypothetical SAR and RAR'!$C$18*$R34)+IF(R34>0,$F$12,0)","v":0},{"$f":"IF($Q34>$I25,D$22*$I25+D$23*($Q34-$I25),$Q34*D$22)+('Hypothetical SAR and RAR'!$C$18*$Q34)+IF(Q34>0,$F$12,0)","v":0},{"$f":"IF($R34>$J25,D$25*$J25+D$26*($R34-$J25),$R34*D$25)+('Hypothetical SAR and RAR'!$C$18*$R34)+IF(R34>0,$F$12,0)","v":0},{"$f":"IF($Q34>$I25,E$22*$I25+E$23*($Q34-$I25),$Q34*E$22)+('Hypothetical SAR and RAR'!$C$18*$Q34)+IF(Q34>0,$H$12,0)","v":0},{"$f":"IF($R34>$J25,E$25*$J25+E$26*($R34-$J25),$R34*E$25)+('Hypothetical SAR and RAR'!$C$18*$R34)+IF(R34>0,$H$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C83:C86,$U$22:$U$25)","v":42.777276740313177},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":114.53062598030695},43.004444804052277,115.17341819302317,43.004444804052277,115.17341819302317]
[]
[]
[null,null,"5-Year Average Monthly Usage Basic Bundled CARE Customer "]
[null,null,{"$f":"C81","v":"2024-01-01"},null,{"$f":"E81","v":"2024-12-01"},null,{"$f":"G81","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":1},{"$f":"IF($S31>$I22,C$31*$I22+C$32*($S31-$I22),$S31*C$31)+('Hypothetical SAR and RAR'!$C$18*$S31)+IF(S31>0,$Q$12,0)","v":28.03401451037762},{"$f":"IF($T31>$J22,C$34*$J22+C$35*($T31-$J22),$T31*C$34)+('Hypothetical SAR and RAR'!$C$18*$T31)+IF(T31>0,$Q$12,0)","v":49.022181952370289},{"$f":"IF($S31>$I22,D$31*$I22+D$32*($S31-$I22),$S31*D$31)+('Hypothetical SAR and RAR'!$C$18*$S31)+IF(S31>0,$Q$12,0)","v":28.179790199739031},{"$f":"IF($T31>$J22,D$34*$J22+D$35*($T31-$J22),$T31*D$34)+('Hypothetical SAR and RAR'!$C$18*$T31)+IF(T31>0,$Q$12,0)","v":49.284088745784189},{"$f":"IF($S31>$I22,E$31*$I22+E$32*($S31-$I22),$S31*E$31)+('Hypothetical SAR and RAR'!$C$18*$S31)+IF(S31>0,$S$12,0)","v":28.179790199739031},{"$f":"IF($T31>$J22,E$34*$J22+E$35*($T31-$J22),$T31*E$34)+('Hypothetical SAR and RAR'!$C$18*$T31)+IF(T31>0,$S$12,0)","v":49.284088745784189}]
[null,2,{"$f":"IF($S32>$I23,C$31*$I23+C$32*($S32-$I23),$S32*C$31)+('Hypothetical SAR and RAR'!$C$18*$S32)+IF(S32>0,$Q$12,0)","v":29.79471638593775},{"$f":"IF($T32>$J23,C$34*$J23+C$35*($T32-$J23),$T32*C$34)+('Hypothetical SAR and RAR'!$C$18*$T32)+IF(T32>0,$Q$12,0)","v":74.627182030987612},{"$f":"IF($S32>$I23,D$31*$I23+D$32*($S32-$I23),$S32*D$31)+('Hypothetical SAR and RAR'!$C$18*$S32)+IF(S32>0,$Q$12,0)","v":29.9521055762023},{"$f":"IF($T32>$J23,D$34*$J23+D$35*($T32-$J23),$T32*D$34)+('Hypothetical SAR and RAR'!$C$18*$T32)+IF(T32>0,$Q$12,0)","v":75.05167486201637},{"$f":"IF($S32>$I23,E$31*$I23+E$32*($S32-$I23),$S32*E$31)+('Hypothetical SAR and RAR'!$C$18*$S32)+IF(S32>0,$S$12,0)","v":29.9521055762023},{"$f":"IF($T32>$J23,E$34*$J23+E$35*($T32-$J23),$T32*E$34)+('Hypothetical SAR and RAR'!$C$18*$T32)+IF(T32>0,$S$12,0)","v":75.05167486201637}]
[null,3,{"$f":"IF($S33>$I24,C$31*$I24+C$32*($S33-$I24),$S33*C$31)+('Hypothetical SAR and RAR'!$C$18*$S33)+IF(S33>0,$Q$12,0)","v":41.101476065447194},{"$f":"IF($T33>$J24,C$34*$J24+C$35*($T33-$J24),$T33*C$34)+('Hypothetical SAR and RAR'!$C$18*$T33)+IF(T33>0,$Q$12,0)","v":126.05839342242886},{"$f":"IF($S33>$I24,D$31*$I24+D$32*($S33-$I24),$S33*D$31)+('Hypothetical SAR and RAR'!$C$18*$S33)+IF(S33>0,$Q$12,0)","v":41.333444073155071},{"$f":"IF($T33>$J24,D$34*$J24+D$35*($T33-$J24),$T33*D$34)+('Hypothetical SAR and RAR'!$C$18*$T33)+IF(T33>0,$Q$12,0)","v":126.7997271386031},{"$f":"IF($S33>$I24,E$31*$I24+E$32*($S33-$I24),$S33*E$31)+('Hypothetical SAR and RAR'!$C$18*$S33)+IF(S33>0,$S$12,0)","v":41.333444073155071},{"$f":"IF($T33>$J24,E$34*$J24+E$35*($T33-$J24),$T33*E$34)+('Hypothetical SAR and RAR'!$C$18*$T33)+IF(T33>0,$S$12,0)","v":126.7997271386031}]
[null,0,{"$f":"IF($S34>$I25,C$31*$I25+C$32*($S34-$I25),$S34*C$31)+('Hypothetical SAR and RAR'!$C$18*$S34)+IF(S34>0,$Q$12,0)","v":0},{"$f":"IF($T34>$J25,C$34*$J25+C$35*($T34-$J25),$T34*C$34)+('Hypothetical SAR and RAR'!$C$18*$T34)+IF(T34>0,$Q$12,0)","v":0},{"$f":"IF($S34>$I25,D$31*$I25+D$32*($S34-$I25),$S34*D$31)+('Hypothetical SAR and RAR'!$C$18*$S34)+IF(S34>0,$Q$12,0)","v":0},{"$f":"IF($T34>$J25,D$34*$J25+D$35*($T34-$J25),$T34*D$34)+('Hypothetical SAR and RAR'!$C$18*$T34)+IF(T34>0,$Q$12,0)","v":0},{"$f":"IF($S34>$I25,E$31*$I25+E$32*($S34-$I25),$S34*E$31)+('Hypothetical SAR and RAR'!$C$18*$S34)+IF(S34>0,$S$12,0)","v":0},{"$f":"IF($T34>$J25,E$34*$J25+E$35*($T34-$J25),$T34*E$34)+('Hypothetical SAR and RAR'!$C$18*$T34)+IF(T34>0,$S$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C93:C96,$V$22:$V$25)","v":34.782534888599216},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":93.369095037915145},34.972823478523296,93.907960001179433,34.972823478523296,93.907960001179433]

{"sheet":"SetUp","index":9,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Current Quarter Effective Rate Date","2024-12-01",null,"Zones",null,"Revenue Recovery Mechanisms",null,"Years Available for Rate Impact","Procurement Rate Assumption"]
[null,null,"Beginning of Year Effecive Rate Date","2024-01-01",null,1,null,"Core Procurement",null,2024,0.5472366666666667]
[null,null,"Care Discount %",0.2,null,2,null,"Allocated Base Margin",null,{"$f":"J5+1","v":2025},{"$f":"K5*(1+L6)","v":0.60196033333333343},0.1]
[null,null,"Proposed Residential Fixed Charge",5,null,3,null,"Distribution",null,{"$f":"J6+1","v":2026},0.66215636666666677,0.1]
[null,null,null,null,null,null,null,"ECPT adjusted",null,2027,0.72837200333333352,0.1]
[null,null,null,null,null,"All",null,"Local Transmission",null,2028,0.80120920366666692,0.1]
[null,null,null,null,null,null,null,"SGIP"]
[null,null,null,null,null,null,null,"GHG End User",null,{"$f":"J5-1","v":2023},0.79356416666666663]
[null,null,"Regulatory Fee",1E-3,null,null,null,"Public Purpose Programs"]
[null,null,null,null,null,null,null,"Backbone Transmission"]
[null,null,null,null,null,"Other Revenues",null,"47% Res (LUAF, Other)"]
[null,null,null,null,null,"and Balancing",null,"ECPT"]
[null,null,null,null,null,"Accouns",null,"EPAM"]
[null,null,null,null,null,null,null,"CFCA"]
[null,null,null,null,null,null,null,"Non-Residential"]
[]
[]
[null,null,null,null,null,null,null,"Procurement"]
[null,null,null,null,null,null,null,"Customer Costs"]
[null,null,null,null,null,null,null,"Medium Pressure Distribution"]
[null,null,null,null,null,null,null,"High Pressure Distribution"]
[null,null,null,null,null,null,null,"Local Transmission"]
[null,null,null,null,null,null,null,"Storage"]
[null,null,null,null,null,null,null,"GHG Revenue"]
[null,null,null,null,null,null,null,"Other Balancing Acounts"]
[null,null,null,null,null,null,null,"NGV Costs"]
[null,null,null,null,null,null,null,"Backbone Transmisson"]
[null,null,null,null,null,null,null,"Public Purpose Programs"]