{"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":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[53,1,53,2],[55,1,55,9],[57,1,57,2],[58,1,58,2],[59,1,59,2],[37,13,37,14],[37,15,37,16],[49,1,49,9],[51,1,51,2],[52,1,52,2],[61,1,61,9],[63,1,63,2],[64,1,64,2],[75,13,75,14],[75,15,75,16],[65,1,65,2],[82,1,82,2],[84,1,84,2],[68,1,68,9],[70,1,70,2],[72,1,72,2],[74,1,74,9],[76,1,76,2],[80,1,80,9],[78,1,78,2],[34,1,34,2],[36,1,36,9],[38,1,38,2],[46,1,46,2],[39,1,39,2],[40,1,40,2],[42,1,42,9],[44,1,44,2],[45,1,45,2],[30,1,30,9],[32,1,32,2],[33,1,33,2],[28,11,28,19],[25,1,25,2],[29,11,29,12],[26,1,26,2],[16,11,16,12],[25,11,25,12],[26,11,26,12],[24,11,24,19],[27,1,27,2],[27,11,27,12],[24,1,24,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)","SDG&E",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":15.833333333333334},"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":34},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A92","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":15.5},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A93","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T"},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":28.166666666666668},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A94","v":"Pipeline Safety Enhancement Plan (PSEP) - High Pressure 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,2023]
[null,{"$f":"'Incremental Rev Req'!A100","v":" Cost Allocation Proceeding"},null,"Y","2024-2026",null,"Summer season",null,6,"months"]
[null,null,null,null,null,null,"Winter Season",null,{"$f":"12-I10","v":6},"months"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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$26","v":"2024-01-01"},{"$f":"$E$26","v":"2024-12-01"},{"$f":"$D$2&\" Authorized\"","v":"2024 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2024 w/Pending"},{"$f":"$H$26","v":"% Change over 1/1/2024"},{"$f":"$I$26","v":"% Change over 12/1/2024"},"% Change over Authorized"]
[null,"Residential",null,227.49291223993913,{"$f":"'SAR and RAR'!G28","v":229.8418717787402},{"$f":"'SAR and RAR'!H28","v":229.8418717787402},{"$f":"'SAR and RAR'!I28","v":285.57728578106122},{"$f":"$G27/D27-1","v":0.25532388226609837},0.24249460540408108,0.24249460540408108,null,"Total Residential (RAR)",null,227.12984666169348,{"$f":"'SAR and RAR'!R28","v":229.48877215460817},{"$f":"'SAR and RAR'!S28","v":229.48877215460817},{"$f":"'SAR and RAR'!T28","v":285.22418615692914},{"$f":"$Q27/N27-1","v":0.25577589360928998},{"$f":"$Q27/O27-1","v":0.2428677162679298},0.2428677162679298]
[null,"System",null,126.39796640019694,{"$f":"'SAR and RAR'!G29","v":127.70389155959495},{"$f":"'SAR and RAR'!H29","v":127.70389155959495},{"$f":"'SAR and RAR'!I29","v":147.25632041090057},0.16502127846473913,0.15310754130136428,0.15310754130136428,null,"Total System (SAR)",null,94.963090353456352,{"$f":"'SAR and RAR'!R29","v":96.279159712772525},{"$f":"'SAR and RAR'!S29","v":96.279159712772525},{"$f":"'SAR and RAR'!T29","v":115.83158856407812},0.21975378152657421,0.20308059303421344,0.20308059303421344]
[]
[]
[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":"((D39*$I$10)+(D45*$I$11))/12","v":57.877793001533036},{"$f":"((E39*$I$10)+(E45*$I$11))/12","v":58.467865056995358},58.467865056995358,72.661770464518966,{"$f":"$G33/D33-1","v":0.25543436776510009},0.24276421575658991,0.24276421575658991]
[null,"CARE",null,{"$f":"((D40*$I$10)+(D46*$I$11))/12","v":39.247196687565804},39.505008362851221,39.650443439578602,49.274953474954593,0.25550249785268764,0.24730902528527499,0.24273398228300569]
[null,"Total",null,{"$f":"((D41*$I$10)+(D47*$I$11))/12","v":54.962649167876805},55.500732184334794,55.523488523422088,69.002417098311128,0.25544198001722118,0.2432703927064086,0.24276083750038646,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":37.304943983877081},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,4,FALSE)))","v":37.690344282461936},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,6,FALSE)))","v":37.690344282461936},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,8,FALSE)))","v":46.84026671818792},{"$f":"$G39/D39-1","v":0.25560479968638838},{"$f":"$G39/E39-1","v":0.24276568999088766},{"$f":"$G39/F39-1","v":0.24276568999088766},null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q22","v":15.833333333333334},{"$f":"'Res Bill Impact'!R22","v":34},{"$f":"'Res Bill Impact'!S22","v":15.5},{"$f":"'Res Bill Impact'!T22","v":28.166666666666668}]
[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.577775538000783},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,4,FALSE)))","v":28.878232704943571},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,6,FALSE)))","v":28.878232704943571},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,8,FALSE)))","v":35.88805868224491},{"$f":"$G40/D40-1","v":0.25580308497151605},{"$f":"$G40/E40-1","v":0.24273736031295812},0.24273736031295812,null,null,0,{"$f":"'Res Bill Impact'!Q23","v":0},{"$f":"'Res Bill Impact'!R23","v":0},{"$f":"'Res Bill Impact'!S23","v":0},{"$f":"'Res Bill Impact'!T23","v":0}]
[null,"Total",null,{"$f":"D39*(1-'SAR and RAR'!$AC$15)+D40*'SAR and RAR'!$AC$15","v":35.939397178421231},{"$f":"E39*(1-'SAR and RAR'!$AC$15)+E40*'SAR and RAR'!$AC$15","v":36.311506359414096},{"$f":"F39*(1-'SAR and RAR'!$AC$15)+F40*'SAR and RAR'!$AC$15","v":36.311506359414096},{"$f":"G39*(1-'SAR and RAR'!$AC$15)+G40*'SAR and RAR'!$AC$15","v":45.126566244899053},{"$f":"$G41/D41-1","v":0.25562947037948613},0.24276216464921108,0.24276216464921108,null,null,0,{"$f":"'Res Bill Impact'!Q24","v":0},{"$f":"'Res Bill Impact'!R24","v":0},{"$f":"'Res Bill Impact'!S24","v":0},{"$f":"'Res Bill Impact'!T24","v":0}]
[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":78.45064201918899},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,5,FALSE)))","v":79.245385831528779},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,7,FALSE)))","v":79.245385831528779},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,9,FALSE)))","v":98.483274210850013},{"$f":"$G45/D45-1","v":0.25535332377217568},{"$f":"$G45/E45-1","v":0.2427635145877125},0.2427635145877125]
[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":49.916617837130829},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,5,FALSE)))","v":50.131784020758865},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,7,FALSE)))","v":50.422654174213626},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,9,FALSE)))","v":62.661848267664276},0.25533040864505074,0.24994251634286324,0.24273204760628864]
[null,"Total",null,{"$f":"D45*(1-'SAR and RAR'!$AC$15)+D46*'SAR and RAR'!$AC$15","v":73.985901157332378},{"$f":"E45*(1-'SAR and RAR'!$AC$15)+E46*'SAR and RAR'!$AC$15","v":74.689958009255491},{"$f":"F45*(1-'SAR and RAR'!$AC$15)+F46*'SAR and RAR'!$AC$15","v":74.73547068743008},{"$f":"G45*(1-'SAR and RAR'!$AC$15)+G46*'SAR and RAR'!$AC$15","v":92.878267951723203},0.25535090468406763,0.24351747446710093,0.24276019268243654]
[]
[]
[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":"((D58*$I$10)+(D64*$I$11))/12","v":45.241498983959616},{"$f":"((E58*$I$10)+(E64*$I$11))/12","v":45.691031727611602},45.691031727611602,56.783050902896782,{"$f":"$G52/D52-1","v":0.25510984777558376},0.24276140756484921,0.24276140756484921]
[null,"Essential Use - CARE",null,{"$f":"((D59*$I$10)+(D65*$I$11))/12","v":35.443752310388753},35.653330163047755,35.803068052696069,44.493620071714275,0.25533040864505074,0.24795130968800438,0.24273204760628841]
[null,"Total",null,{"$f":"D52*(1-'SAR and RAR'!$AC$15)+D53*'SAR and RAR'!$AC$15","v":43.708437974110282},{"$f":"E52*(1-'SAR and RAR'!$AC$15)+E53*'SAR and RAR'!$AC$15","v":44.120424790136248},{"$f":"F52*(1-'SAR and RAR'!$AC$15)+F53*'SAR and RAR'!$AC$15","v":44.14385439369358},{"$f":"G52*(1-'SAR and RAR'!$AC$15)+G53*'SAR and RAR'!$AC$15","v":54.860114143228586},{"$f":"$G54/D54-1","v":0.25513783347105079},{"$f":"$G54/E54-1","v":0.24341763263107441},0.24275768160076971]
[]
[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":24.882824441177789},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":25.130067450186377},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":25.130067450186377},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,8,FALSE)))","v":31.230677996593233},{"$f":"$G58/D58-1","v":0.25510984777558399},{"$f":"$G58/E58-1","v":0.24276140756484965},{"$f":"$G58/F58-1","v":0.24276140756484965},null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!I22","v":11},{"$f":"'Res Bill Impact'!J22","v":29}]
[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":19.494063770713815},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":19.691687428982835},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":19.691687428982835},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,8,FALSE)))","v":24.471491039442853},{"$f":"$G59/D59-1","v":0.25533040864505074},0.24273204760628864,0.24273204760628864,null,null,0,{"$f":"'Res Bill Impact'!I23","v":0},{"$f":"'Res Bill Impact'!J23","v":0}]
[null,"Total",null,{"$f":"D58*(1-'SAR and RAR'!$AC$15)+D59*'SAR and RAR'!$AC$15","v":24.039640885760651},{"$f":"E58*(1-'SAR and RAR'!$AC$15)+E59*'SAR and RAR'!$AC$15","v":24.279119916531464},{"$f":"F58*(1-'SAR and RAR'!$AC$15)+F59*'SAR and RAR'!$AC$15","v":24.279119916531464},{"$f":"G58*(1-'SAR and RAR'!$AC$15)+G59*'SAR and RAR'!$AC$15","v":30.173062778775723},{"$f":"$G60/D60-1","v":0.25513783347105101},{"$f":"$G60/E60-1","v":0.24275768160076994},0.24275768160076994,null,null,0,{"$f":"'Res Bill Impact'!I24","v":0},{"$f":"'Res Bill Impact'!J24","v":0}]
[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":65.600173526741443},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":66.251996005036816},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":66.251996005036816},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,9,FALSE)))","v":82.335423809200336},{"$f":"$G64/D64-1","v":0.25510984777558376},{"$f":"$G64/E64-1","v":0.24276140756484943},{"$f":"$G64/F64-1","v":0.24276140756484943}]
[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.393440850063698},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":51.614972897112679},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":51.9144486764093},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,9,FALSE)))","v":64.515749103985698},{"$f":"$G65/D65-1","v":0.25533040864505052},0.24994251634286302,0.24273204760628841]
[null,"Total",null,{"$f":"D64*(1-'SAR and RAR'!$AC$15)+D65*'SAR and RAR'!$AC$15","v":63.377235062459903},{"$f":"E64*(1-'SAR and RAR'!$AC$15)+E65*'SAR and RAR'!$AC$15","v":63.961729663741011},{"$f":"F64*(1-'SAR and RAR'!$AC$15)+F65*'SAR and RAR'!$AC$15","v":64.008588870855675},{"$f":"G64*(1-'SAR and RAR'!$AC$15)+G65*'SAR and RAR'!$AC$15","v":79.547165507681456},0.25513783347105101,0.24366814227626499,0.24275768160077016]
[]
[]
[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":"((D77*$I$10)+(D83*$I$11))/12","v":57.746313747696},{"$f":"((E77*$I$10)+(E83*$I$11))/12","v":58.334923507027362},58.334923507027362,72.496554128388595,{"$f":"$G71/D71-1","v":0.25543172236307665},0.24276419287076356,0.24276419287076356]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D78*$I$10)+(D84*$I$11))/12","v":36.99617431684694},37.23691690049781,37.375357954730241,46.447614084672544,{"$f":"$G72/D72-1","v":0.25547073291634126},{"$f":"$G72/E72-1","v":0.24735391516937311},{"$f":"$G72/F72-1","v":0.24273362521185216}]
[null,"Total",null,{"$f":"((D79*$I$10)+(D85*$I$11))/12","v":54.499523361067418},55.033702074015366,55.055364052986384,68.420656306224387,0.25543586597863244,0.24325011270738739,0.24276094587940555,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":36.863931514114078},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":37.244426926114777},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":37.244426926114777},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,8,FALSE)))","v":46.286092106485597},{"$f":"$G77/D77-1","v":0.25559293882596479},0.24276558740741572,0.24276558740741572,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.661739406613},{"$f":"'Res Bill Impact'!R31","v":34.069279171492305},{"$f":"'Res Bill Impact'!S31","v":14.458914681218566},{"$f":"'Res Bill Impact'!T31","v":26.812122049869362}]
[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":26.476237991119756},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":26.752904390027201},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":26.752904390027201},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,8,FALSE)))","v":33.24680957917905},{"$f":"$G78/D78-1","v":0.25572256867951459},{"$f":"$G78/E78-1","v":0.2427364556190994},{"$f":"$G78/F78-1","v":0.2427364556190994},null,null,0,{"$f":"'Res Bill Impact'!Q32","v":0},{"$f":"'Res Bill Impact'!R32","v":0},{"$f":"'Res Bill Impact'!S32","v":0},{"$f":"'Res Bill Impact'!T32","v":0}]
[null,"Total",null,{"$f":"D77*(1-'SAR and RAR'!$AC$15)+D78*'SAR and RAR'!$AC$15","v":35.23856106385287},{"$f":"E77*(1-'SAR and RAR'!$AC$15)+E78*'SAR and RAR'!$AC$15","v":35.602810269764802},{"$f":"F77*(1-'SAR and RAR'!$AC$15)+F78*'SAR and RAR'!$AC$15","v":35.602810269764802},{"$f":"G77*(1-'SAR and RAR'!$AC$15)+G78*'SAR and RAR'!$AC$15","v":44.245825471204455},0.25560817852438045,0.24276216219874125,0.24276216219874125,null,null,0,{"$f":"'Res Bill Impact'!Q33","v":0},{"$f":"'Res Bill Impact'!R33","v":0},{"$f":"'Res Bill Impact'!S33","v":0},{"$f":"'Res Bill Impact'!T33","v":0}]
[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":78.628695981277929},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":79.425420087939955},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":79.425420087939955},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,9,FALSE)))","v":98.707016150291608},{"$f":"$G83/D83-1","v":0.2553561383466727},0.2427635389400904,0.2427635389400904]
[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":47.51611064257412},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":47.720929410968424},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":47.997811519433277},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,9,FALSE)))","v":59.648418590166024},{"$f":"$G84/D84-1","v":0.25533040864505097},{"$f":"$G84/E84-1","v":0.24994251634286324},{"$f":"$G84/F84-1","v":0.24273204760628864}]
[null,"Total",null,{"$f":"D83*(1-'SAR and RAR'!$AC$15)+D84*'SAR and RAR'!$AC$15","v":73.760485658281979},{"$f":"E83*(1-'SAR and RAR'!$AC$15)+E84*'SAR and RAR'!$AC$15","v":74.46459387826593},{"$f":"F83*(1-'SAR and RAR'!$AC$15)+F84*'SAR and RAR'!$AC$15","v":74.507917836207952},{"$f":"G83*(1-'SAR and RAR'!$AC$15)+G84*'SAR and RAR'!$AC$15","v":92.595487141244305},0.25535354485355799,0.24348341028514309,0.24276036467424267]

{"sheet":"Authorized Rev Req","index":2,"n_rows":92,"n_cols":12,"rows_kept":92,"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 3046-G","AL 3149-G","AL 3163-G","AL 3213-G","AL 3244-G","AL 3261-G","AL 3312-G","AL-3345"]
["Filing Description","Authority for Revenue Requirement as of 10/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, A.22-05-016",412393.92784195661,412992.27437904326,412992.27437904326,412992.27437904326,412992.27437904326,417772.13947090023,417344.74138154538,417344.74138154538,"Allocated Base Margin","N"]
["SCG Transport excl Core Storge & Load Balance $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",10101.5487258045,18927.301506775031,18927.301506775031,19163.89443334132,16390.059073287463,59110.52142599332,59221.346535796984,59221.22817428541,"ECPT","N"]
["SCG Core Seasonal Storage","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",14374.700920168953,18907.657128629489,18907.657128629489,18907.657128629489,17001.410111315246,17001.410111315254,17001.410111315254,17001.410111315254,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",9102.0837826634306,11569.318977706102,11569.318977706102,11569.318977706102,11389.102717475975,11389.102717475971,11389.102717475971,11389.102717475971,"ECPT","N"]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)","D.19-09-051",2576.6109000000001,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,"Local Transmission","N"]
["LUAF","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3180.2303217247427,4359.515855476232,4359.515855476232,4359.515855476232,4359.515855476232,3607.5249270959521,3722.5793902382834,3722.5793902382834,"46% Res (LUAF, Other)","N"]
["Company Use Gas: Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",234.78660051758473,321.84961592802711,321.84961592802711,321.84961592802711,321.84961592802711,266.3324439520315,274.82656027154178,274.82656027154178,"ECPT","N"]
["SDG&E NGLAPBA","AL 3149-G, AL 3071-G-B, 3247-G-B",983.22148920005588,734.78317488009657,734.78317488009657,143.91573455627505,143.91573455627505,666.38432929558826,666.38432929558815,666.38432929558815,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct","AL 3149-G,  AL 3071-G-B,3247-G-B",1620.0351328756483,5725.6373585236443,5725.6373585236443,6792.859113609511,6792.859113609511,4950.4356988439195,4967.0727197205524,4967.0727197205524,"EPAM","N"]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",52.108015617715203,47.131684850968078,47.131684850968078,47.131684850968078,47.131684850968078,48.348788764696145,48.348788764696145,48.348788764696145,"Local Transmission","N"]
["CFCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",37541.479619999998,55563.797728400001,55563.797728400001,55563.797728400001,55563.797728400001,25794.189268400005,25794.189268400005,32720.484075331624,"CFCA","Y"]
["CFCA -NGV only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-210.72329159999998,3011.7432064000004,3011.7432064000004,3011.7432064000004,3011.7432064000004,2805.0950652000001,2805.0950652000001,2805.0950652000001,"Non-Residential","Y"]
["CFCA - C&I shortfall only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",5444.0260091999999,40.920424000000004,40.920424000000004,40.920424000000004,40.920424000000004,37.851392200000006,37.851392200000006,37.851392200000006,"Non-Residential","Y"]
["Hazardous Substance Cleanup Cost Acct HSCCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",290.51172240000005,122.76127200000001,122.76127200000001,122.76127200000001,122.76127200000001,72.633752600000008,72.633752600000008,72.633752600000008,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",10311.120288,11907.843384,11907.843384,11907.843384,11907.843384,15931.344073800004,15931.344073800003,15931.344073800003,"EPAM","Y"]
["PBOPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-623.51692177259997,-531.23917447400004,-531.23917447400004,-531.23917447400004,-531.23917447400004,-354.98467820000002,-354.98467820000008,-354.98467820000008,"EPAM","Y"]
["Pension BA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-575.93130622920012,-298.79172895260001,-298.79172895260001,-298.79172895260001,-298.79172895260001,51.15053000000001,51.15053000000001,51.15053000000001,"EPAM","Y"]
["Safety Enhancement Balancing Account - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3036.4630647777644,3084.2385558959263,3084.2385558959263,3084.2385558959263,3084.2385558959263,3321.4404759571516,3321.4404759571516,3321.4404759571516,"Local Transmission","Y"]
["Safety Enhancement Balancing Account - Distribution","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",38688.933410192403,39079.214628479465,39079.214628479465,39079.214628479465,39079.214628479465,48957.417309766293,49368.178378244505,49368.178378244505,"Distribution","Y"]
["Rewards & Penalties Bal Acct  RPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-127.86607500000001,310.99522240000005,310.99522240000005,310.99522240000005,310.99522240000005,-119.69224020000003,-119.69224020000001,-119.69224020000001,"EPAM","Y"]
["SGPMA - Rev Req for NEXT Year","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1545.2359431600003,1545.3598123600002,1545.3598123600002,1545.3598123600002,1545.3598123600002,1696.1515748000002,1696.1515748000002,1696.1515748000002,"ECPT","Y"]
["Integrated Transmission  Margin ITBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",24.550286399999997,704.35051671497718,704.35051671497718,704.35051671497718,704.35051671497718,-289.51199980000001,-289.51199980000001,-289.51199980000001,"ECPT","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3038.0979420000003,4285.3914033999999,4285.3914033999999,4285.3914033999999,4285.3914033999999,4093.0654106000011,4093.0654106000002,4093.0654106000002,"EPAM","Y"]
["Residential Uncollectible Balancing Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",5629.1760858000007,10487.904671200002,10487.904671200002,10487.904671200002,10487.904671200002,26260.682102000006,26260.682102000006,26260.682102000006,"EPAM","Y"]
["NFCA -Margin Only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-7128.7894133999998,3046.5255668000004,3046.5255668000004,3046.5255668000004,3046.5255668000004,4377.4623573999997,4377.4623573999997,4377.4623573999997,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1705.2219761999997,794.87923620000004,794.87923620000004,794.87923620000004,794.87923620000004,6588.1882640000003,6588.1882640000003,6784.0932542683813,"Non-Residential","Y"]
["NFCA -Nonmargin SCG","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-100.24700279999999,132.991378,132.991378,132.991378,132.991378,-1020.9645788,-1020.9645788,-1020.9645788,"Non-Residential","Y"]
["Minimum Bil/Customer Charge Revenue ","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,"All Residential","N"]
["Borrego Revenue","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,"All Residential","N"]
["Employee Discount (Schd GR)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,"All Residential","N"]
["SDFFD","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1986.9012193223789,2243.52579553028,2243.52579553028,2243.52579553028,2235.2764847903877,2098.3340670427324,2112.1396483676353,2130.6707838359775,"All Residential","N"]
["Customer Information System  Account - CISBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",{"$f":"0","v":0},28619.672934858001,28619.672934858001,28619.672934858001,28619.672934858001,0,0,0,"EPAM","Y"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ","AL 3039-G, 3247-G-B",{"$f":"0","v":0},10830.843399584999,10830.843399584999,10830.843399584999,10830.843399584999,0,0,0,"EPAM","Y"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)","D. 21-10-012, 3247-G-B",0,0,0,0,0,113.55417660000001,113.55417660000001,113.55417660000001,"ECPT","Y"]
["GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct","D.24-02-010",0,0,0,0,0,0,0,0,"ECPT","Y"]
["Gain/Loss on Sale Memo Acct GLOSMA","D.20-02-045, 3247-G-B",0,0,0,0,0,-1.0230106000000003,-1.0230106000000001,-1.0230106000000001,"EPAM","Y"]
["Transmission Integrity Management Program Memorandum Account  (TIMPBA)","AL 3312-G",0,0,0,0,0,0,7280.4081272496533,7280.4081272496533,"Local Transmission","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C8:C45)","v":556607.70051950624},652780.64954693615,652780.64954693615,653493.59678826446,648625.04883992637,659436.83485872927,{"$f":"SUM(I8:I45)","v":666965.42225656938},{"$f":"SUM(J8:J45)","v":674106.03482772619}]
[]
[]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",62728.323235565404,62672.954086711361,62672.954086711361,62672.954086711361,62672.954086711361,86283.785928646161,86283.785928646161,86283.785928646161,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",830.72849948880003,809.23321752201855,809.23321752201855,809.23321752201855,809.23321752201855,1046.1279719769354,1046.1279719769354,1046.1279719769354,"46% Res (LUAF, Other)","N"]
["AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",528.8540862000001,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,"46% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-138.095361,1354.208041356786,1354.208041356786,1354.208041356786,1354.208041356786,-27046.354242800004,-27046.354242800004,-27046.354242800004,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-5290.5867191999996,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,17577.156816130475,17577.156816130475,17577.156816130475,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-11.252214599999999,-248.04164622186403,-248.04164622186403,-248.04164622186403,-248.04164622186403,-899.22631739999997,-899.22631739999997,-899.22631739999997,"46% Res (LUAF, Other)","Y"]
["FERC Settlement Proceeds MA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",1.0229286000000002,0,0,0,0,0,0,0,"Non-Residential","Y"]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3071-G-B, 3247-G-B",413.26315440000002,2305.8658924000006,2305.8658924000006,2305.8658924000006,2305.8658924000006,-801.01729980000027,-801.01729980000027,-801.01729980000027,"46% Res (LUAF, Other)","Y"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B",105.36164580000001,864.44395699999995,864.44395699999995,864.44395699999995,864.44395699999995,2678.2417508000008,2678.2417508000003,2678.2417508000003,"EPAM","Y"]
["  TLS Adjustment","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",6681.9931823319448,-10406.77744459657,-10437.810558367659,-10411.005461001434,-10207.828179601249,-9118.6142854368882,-8863.9711464073116,-9300.9861081117924,"Non-Residential","N"]
["CSI Thermal Program memoradum Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",806.06773680000003,333.50145560000004,333.50145560000004,333.50145560000004,333.50145560000004,95.139985800000005,95.139985800000005,95.139985800000005,"46% Res (LUAF, Other)","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B",{"$f":"0","v":0},2813.2791500000003,2813.2791500000003,2813.2791500000003,2813.2791500000003,37.851392200000006,37.851392200000006,37.851392200000006,"ECPT","Y"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)","D.22-02-025, 3247-G-B",0,0,0,0,0,29.667307400000009,29.667307399999999,29.667307399999999,"EPAM","y"]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding","AL 3137-G, D.21-06-015, 3245-G",25613.072,22795.559000000001,22795.559000000001,22795.559000000001,22795.559000000001,21383.37754112266,21383.37754112266,21383.37754112266,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Admin Expenses","AL 3137-G, D.21-06-015, 3245-G",727.2829999999999,761.47,761.47,761.47,761.47,771.47047999999995,771.47047999999995,771.47047999999995,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3137-G, AL 3245-G, AL 3247-G-B",1000,-1000,-1000,-1000,-1000,7000,7000,7000,"Public Purpose Programs","Y"]
["Energy Savings Assistance (ESA/LIEE/DAP)","AL 3137-G, D.21-06-015, AL 3247-G-B",8041.1949999999997,10315.642,10315.642,10315.642,10315.642,7005.5879999999997,7005.5879999999997,7005.5879999999997,"Public Purpose Programs","N"]
["Energy Efficiency","D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G",15368.681745714286,12089.109,12089.109,12089.109,12089.109,25981.63,25981.63,25981.63,"Public Purpose Programs","N"]
["RD&D ","AL 3137-G, AL 3245-G",1929.78072,2278.9604600000002,2278.9604600000002,2278.9604600000002,2278.9604600000002,2183.7319900000002,2183.7319900000002,2183.7319900000002,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3137-G, AL 3245-G",56.159990000000001,55.36833,55.36833,55.36833,55.36833,47.053350000000002,47.053350000000002,47.053350000000002,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C51:C79)","v":119391.85263010046},{"$f":"SUM(D51:D79)","v":101254.1992437171},{"$f":"SUM(E51:E79)","v":101223.16612994601},{"$f":"SUM(F51:F79)","v":101249.97122731223},{"$f":"SUM(G51:G79)","v":101453.14850871242},{"$f":"SUM(H51:H74)","v":134784.50684883934},{"$f":"SUM(I51:I74)","v":135039.14998786891},{"$f":"SUM(J51:J74)","v":134602.13502616444}]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,{"$f":"TotalCoreVolume*SetUp!K5","v":259331.31984714375},"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,{"$f":"SUM(C84:C89)","v":372042.57581360283},{"$f":"SUM(D84:D89)","v":475248.57632622559},475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,259331.31984714375]
[]
["Total Authorized Revenue",null,{"$f":"C46+C80+C90","v":1048042.1289632095},1229283.4251168789,1229252.3920031078,1229992.1443418022,1225326.7736748643,1053552.6615547123,1061335.8920915821,1068039.4897010345]

{"sheet":"Incremental Rev Req","index":3,"n_rows":129,"n_cols":19,"rows_kept":129,"cut":false,"hidden":false,"merged":[[121,0,121,10],[5,13,5,18],[5,0,5,10],[88,0,88,10]]}
[{"$f":"'Authorized Rev Req'!A1","v":"Annual Period 2024"}]
[{"$f":"'Authorized Rev Req'!A2","v":"Reporting Date: Quarter Ended December 31"}]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!J92","v":1068039.4897010345}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!J4","v":"2024-10-01"}]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented",null,null,null,null,null,null,null,null,null,null,null,null,"Authorized"]
["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":"B5","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$9:$E$83,N8,$F$9:$F$83)","v":259331.31984714375},{"$f":"SUMIF($E$9:$E$83,N8,$G$9:$G$83)","v":259331.31984714375},{"$f":"SUMIF($E$9:$E$83,N8,$H$9:$H$83)","v":259331.31984714375},{"$f":"SUMIF($E$9:$E$83,N8,$I$9:$I$83)","v":259331.31984714375},{"$f":"SUMIF($E$9:$E$83,N8,$J$9:$J$83)","v":259331.31984714375}]
[{"$f":"'Authorized Rev Req'!A8","v":"Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B8","v":"D.19-09-051, A.22-05-016"},{"$f":"F9","v":417344.74138154538},{"$f":"'Authorized Rev Req'!K8","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!J8","v":417344.74138154538},{"$f":"F9","v":417344.74138154538},{"$f":"F9","v":417344.74138154538},{"$f":"F9","v":417344.74138154538},0,"Existing",null,null,"Allocated Base Margin",417344.74138154538,417344.74138154538,417344.74138154538,417344.74138154538,0]
[{"$f":"'Authorized Rev Req'!A9","v":"SCG Transport excl Core Storge & Load Balance $000"},null,{"$f":"'Authorized Rev Req'!B9","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},59221.22817428541,{"$f":"'Authorized Rev Req'!K9","v":"ECPT"},{"$f":"'Authorized Rev Req'!J9","v":59221.22817428541},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Distribution",49368.178378244505,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A10","v":"SCG Core Seasonal Storage"},null,{"$f":"'Authorized Rev Req'!B10","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},17001.410111315254,{"$f":"'Authorized Rev Req'!K10","v":"Seasonal Storage"},{"$f":"'Authorized Rev Req'!J10","v":17001.410111315254},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"All Residential",3644.4740161621276,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A11","v":"SCG Load Balancing Allocated to ALL SDGE $000"},null,{"$f":"'Authorized Rev Req'!B11","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},11389.102717475971,{"$f":"'Authorized Rev Req'!K11","v":"ECPT"},{"$f":"'Authorized Rev Req'!J11","v":11389.102717475971},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Local Transmission",13348.645791971499,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A12","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B12","v":"D.19-09-051"},2698.4483999999993,{"$f":"'Authorized Rev Req'!K12","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J12","v":2698.4483999999993},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Seasonal Storage",17001.410111315254,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A13","v":"LUAF"},null,{"$f":"'Authorized Rev Req'!B13","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},3722.5793902382834,{"$f":"'Authorized Rev Req'!K13","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J13","v":3722.5793902382834},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"GHG End User",103860.94274477664,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A14","v":"Company Use Gas: Other"},null,{"$f":"'Authorized Rev Req'!B14","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},274.82656027154178,{"$f":"'Authorized Rev Req'!K14","v":"ECPT"},{"$f":"'Authorized Rev Req'!J14","v":274.82656027154178},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Public Purpose Programs",64372.851361122666,52461.612999999998,53377.255000000005,37424.365000000005,26310.181]
[{"$f":"'Authorized Rev Req'!A15","v":"SDG&E NGLAPBA"},null,{"$f":"'Authorized Rev Req'!B15","v":"AL 3149-G, AL 3071-G-B, 3247-G-B"},666.38432929558815,{"$f":"'Authorized Rev Req'!K15","v":"EPAM"},{"$f":"'Authorized Rev Req'!J15","v":666.38432929558815},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"-",0,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A16","v":"SDG&ENERBA - NGLAP Subacct"},null,{"$f":"'Authorized Rev Req'!B16","v":"AL 3149-G,  AL 3071-G-B,3247-G-B"},4967.0727197205524,{"$f":"'Authorized Rev Req'!K16","v":"EPAM"},{"$f":"'Authorized Rev Req'!J16","v":4967.0727197205524},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"46% Res (LUAF, Other)",3692.5002110152182,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A17","v":"SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B17","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},48.348788764696145,{"$f":"'Authorized Rev Req'!K17","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J17","v":48.348788764696145},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"ECPT",45469.482105632895,12271.016944999999,3233.7377709999996,1786.1772059999998,0]
[{"$f":"'Authorized Rev Req'!A18","v":"CFCA"},null,{"$f":"'Authorized Rev Req'!B18","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},32720.484075331624,{"$f":"'Authorized Rev Req'!K18","v":"CFCA"},{"$f":"'Authorized Rev Req'!J18","v":32720.484075331624},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"EPAM",54201.908294616143,21791.861599999997,24855.447099999998,0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"CFCA -NGV only"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},2805.0950652000001,{"$f":"'Authorized Rev Req'!K19","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J19","v":2805.0950652000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"CFCA",32720.484075331624,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A20","v":"CFCA - C&I shortfall only"},null,{"$f":"'Authorized Rev Req'!B20","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},37.851392200000006,{"$f":"'Authorized Rev Req'!K20","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J20","v":37.851392200000006},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Non-Residential",3682.5513821565892,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"Hazardous Substance Cleanup Cost Acct HSCCA"},null,{"$f":"'Authorized Rev Req'!B21","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},72.633752600000008,{"$f":"'Authorized Rev Req'!K21","v":"ECPT"},{"$f":"'Authorized Rev Req'!J21","v":72.633752600000008},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Total",{"$f":"SUM(O8:O21)","v":1068039.4897010343},{"$f":"SUM(P8:P21)","v":763200.55277368915},{"$f":"SUM(Q8:Q21)","v":758142.50109968917},{"$f":"SUM(R8:R21)","v":715886.60343468911},{"$f":"SUM(S8:S21)","v":285641.50084714376}]
[{"$f":"'Authorized Rev Req'!A22","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B22","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},15931.344073800003,{"$f":"'Authorized Rev Req'!K22","v":"EPAM"},{"$f":"'Authorized Rev Req'!J22","v":15931.344073800003},21791.861599999997,24855.447099999998,{"$f":"0","v":0},0,"Existing",null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3}]
[{"$f":"'Authorized Rev Req'!A23","v":"PBOPBA"},null,{"$f":"'Authorized Rev Req'!B23","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},-354.98467820000008,{"$f":"'Authorized Rev Req'!K23","v":"EPAM"},{"$f":"'Authorized Rev Req'!J23","v":-354.98467820000008},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Check",{"$f":"O22-F84","v":0},{"$f":"P22-G84","v":0},{"$f":"Q22-H84","v":0},{"$f":"R22-I84","v":0},{"$f":"S22-J84","v":0}]
[{"$f":"'Authorized Rev Req'!A24","v":"Pension BA"},null,{"$f":"'Authorized Rev Req'!B24","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},51.15053000000001,{"$f":"'Authorized Rev Req'!K24","v":"EPAM"},{"$f":"'Authorized Rev Req'!J24","v":51.15053000000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A25","v":"Safety Enhancement Balancing Account - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B25","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},3321.4404759571516,{"$f":"'Authorized Rev Req'!K25","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!J25","v":3321.4404759571516},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A26","v":"Safety Enhancement Balancing Account - Distribution"},null,{"$f":"'Authorized Rev Req'!B26","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},49368.178378244505,{"$f":"'Authorized Rev Req'!K26","v":"Distribution"},{"$f":"'Authorized Rev Req'!J26","v":49368.178378244505},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A27","v":"Rewards & Penalties Bal Acct  RPBA"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},-119.69224020000001,{"$f":"'Authorized Rev Req'!K27","v":"EPAM"},{"$f":"'Authorized Rev Req'!J27","v":-119.69224020000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A28","v":"SGPMA - Rev Req for NEXT Year"},null,{"$f":"'Authorized Rev Req'!B28","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},1696.1515748000002,{"$f":"'Authorized Rev Req'!K28","v":"ECPT"},{"$f":"'Authorized Rev Req'!J28","v":1696.1515748000002},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A29","v":"Integrated Transmission  Margin ITBA"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},-289.51199980000001,{"$f":"'Authorized Rev Req'!K29","v":"ECPT"},{"$f":"'Authorized Rev Req'!J29","v":-289.51199980000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A30","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},4093.0654106000002,{"$f":"'Authorized Rev Req'!K30","v":"EPAM"},{"$f":"'Authorized Rev Req'!J30","v":4093.0654106000002},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A31","v":"Residential Uncollectible Balancing Account"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},26260.682102000006,{"$f":"'Authorized Rev Req'!K31","v":"EPAM"},{"$f":"'Authorized Rev Req'!J31","v":26260.682102000006},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A32","v":"NFCA -Margin Only"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},4377.4623573999997,{"$f":"'Authorized Rev Req'!K32","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J32","v":4377.4623573999997},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A33","v":"NFCA -Nonmargin Other"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},6784.0932542683813,{"$f":"'Authorized Rev Req'!K33","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J33","v":6784.0932542683813},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A34","v":"NFCA -Nonmargin SCG"},null,{"$f":"'Authorized Rev Req'!B34","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},-1020.9645788,{"$f":"'Authorized Rev Req'!K34","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J34","v":-1020.9645788},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A35","v":"Minimum Bil/Customer Charge Revenue "},null,{"$f":"'Authorized Rev Req'!B35","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},1816.4409600000001,{"$f":"'Authorized Rev Req'!K35","v":"All Residential"},{"$f":"'Authorized Rev Req'!J35","v":1816.4409600000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A36","v":"Borrego Revenue"},null,{"$f":"'Authorized Rev Req'!B36","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},64.571742326140509,{"$f":"'Authorized Rev Req'!K36","v":"All Residential"},{"$f":"'Authorized Rev Req'!J36","v":64.571742326140509},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A37","v":"Employee Discount (Schd GR)"},null,{"$f":"'Authorized Rev Req'!B37","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},-367.20946999999097,{"$f":"'Authorized Rev Req'!K37","v":"All Residential"},{"$f":"'Authorized Rev Req'!J37","v":-367.20946999999097},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A38","v":"SDFFD"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},2130.6707838359775,{"$f":"'Authorized Rev Req'!K38","v":"All Residential"},{"$f":"'Authorized Rev Req'!J38","v":2130.6707838359775},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A39","v":"Customer Information System  Account - CISBA"},null,{"$f":"'Authorized Rev Req'!B39","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B"},0,{"$f":"'Authorized Rev Req'!K39","v":"EPAM"},{"$f":"'Authorized Rev Req'!J39","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A40","v":"Transition, Stabilization and OCM Balancing Account - TSOBA-G "},null,{"$f":"'Authorized Rev Req'!B40","v":"AL 3039-G, 3247-G-B"},0,{"$f":"'Authorized Rev Req'!K40","v":"EPAM"},{"$f":"'Authorized Rev Req'!J40","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A42","v":"GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct"},null,{"$f":"'Authorized Rev Req'!B42","v":"D.24-02-010"},113.55417660000001,"ECPT",{"$f":"'Authorized Rev Req'!J41","v":113.55417660000001},{"$f":"11995*1.023011","v":12271.016944999999},{"$f":"3161*1.023011","v":3233.7377709999996},{"$f":"1746*1.023011","v":1786.1772059999998},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A41","v":"Percentage of Income Payment Plan Balancing Account (PIPPBA)"},null,{"$f":"'Authorized Rev Req'!B41","v":"D. 21-10-012, 3247-G-B"},0,"ECPT",{"$f":"'Authorized Rev Req'!J42","v":0},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A43","v":"Gain/Loss on Sale Memo Acct GLOSMA"},null,{"$f":"'Authorized Rev Req'!B43","v":"D.20-02-045, 3247-G-B"},-1.0230106000000001,"EPAM",{"$f":"'Authorized Rev Req'!J43","v":-1.0230106000000001},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A44","v":"Transmission Integrity Management Program Memorandum Account  (TIMPBA)"},null,{"$f":"'Authorized Rev Req'!B44","v":"AL 3312-G"},{"$f":"F45","v":7280.4081272496533},"Local Transmission",{"$f":"'Authorized Rev Req'!J44","v":7280.4081272496533},0,0,0,0,"Existing"]
[]
[{"$f":"'Authorized Rev Req'!A50","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A51","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B51","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},{"$f":"F48","v":86283.785928646161},{"$f":"'Authorized Rev Req'!K51","v":"GHG End User"},{"$f":"'Authorized Rev Req'!J51","v":86283.785928646161},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A52","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B52","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},1046.1279719769354,{"$f":"'Authorized Rev Req'!K52","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J52","v":1046.1279719769354},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A53","v":"AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B53","v":"D.19-09-051"},528.89648020000016,{"$f":"'Authorized Rev Req'!K53","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J53","v":528.89648020000016},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A54","v":"Green House Gas Balancing Account (GHGBA) - Company Gas Compressor"},null,{"$f":"'Authorized Rev Req'!B54","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-27046.354242800004,{"$f":"'Authorized Rev Req'!K54","v":"ECPT"},{"$f":"'Authorized Rev Req'!J54","v":-27046.354242800004},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A55","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B55","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},17577.156816130475,{"$f":"'Authorized Rev Req'!K55","v":"GHG End User"},{"$f":"'Authorized Rev Req'!J55","v":17577.156816130475},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A56","v":"Green House Gas Balancing Account (GHGBA) - LUAF"},null,{"$f":"'Authorized Rev Req'!B56","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-899.22631739999997,{"$f":"'Authorized Rev Req'!K56","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J56","v":-899.22631739999997},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A57","v":"FERC Settlement Proceeds MA"},null,{"$f":"'Authorized Rev Req'!B57","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},0,{"$f":"'Authorized Rev Req'!K57","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J57","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A58","v":"New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount"},null,{"$f":"'Authorized Rev Req'!B58","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3071-G-B, 3247-G-B"},-801.01729980000027,{"$f":"'Authorized Rev Req'!K58","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J58","v":-801.01729980000027},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A59","v":"New Environmental Regulation Balancing Account (NERBA) - EPAM"},null,{"$f":"'Authorized Rev Req'!B59","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B"},2678.2417508000003,{"$f":"'Authorized Rev Req'!K59","v":"EPAM"},{"$f":"'Authorized Rev Req'!J59","v":2678.2417508000003},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A60","v":"  TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B60","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-9300.9861081117924,{"$f":"'Authorized Rev Req'!K60","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!J60","v":-9300.9861081117924},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A61","v":"CSI Thermal Program memoradum Account"},null,{"$f":"'Authorized Rev Req'!B61","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},95.139985800000005,{"$f":"'Authorized Rev Req'!K61","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!J61","v":95.139985800000005},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A62","v":"Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  "},null,{"$f":"'Authorized Rev Req'!B62","v":"D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B"},37.851392200000006,"ECPT",{"$f":"'Authorized Rev Req'!J62","v":37.851392200000006},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A63","v":"Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)"},null,{"$f":"'Authorized Rev Req'!B63","v":"D.22-02-025, 3247-G-B"},29.667307399999999,"EPAM",{"$f":"'Authorized Rev Req'!J63","v":29.667307399999999},0,0,0,{"$f":"0","v":0},"Existing"]
[]
[]
["PPPS Programs"]
[{"$f":"'Authorized Rev Req'!A68","v":"California Alternate Rates for Energy (CARE) - Funding"},null,{"$f":"'Authorized Rev Req'!B68","v":"AL 3137-G, D.21-06-015, 3245-G"},{"$f":"F64","v":21383.37754112266},{"$f":"'Authorized Rev Req'!K68","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J68","v":21383.37754112266},11769.36,11887.054,11887.054,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A69","v":"California Alternate Rates for Energy (CARE) - Admin Expenses"},null,{"$f":"'Authorized Rev Req'!B69","v":"AL 3137-G, D.21-06-015, 3245-G"},771.47047999999995,{"$f":"'Authorized Rev Req'!K69","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J69","v":771.47047999999995},{"$f":"813953/1000","v":813.95299999999997},{"$f":"814181/1000","v":814.18100000000004},0,0,"Existing","approved admin budget 2021-2026 provided by Edith Nieves"]
[{"$f":"'Authorized Rev Req'!A70","v":"California Alternate Rates for Energy (CARE) - Amortization"},null,{"$f":"'Authorized Rev Req'!B70","v":"AL 3137-G, AL 3245-G, AL 3247-G-B"},7000,{"$f":"'Authorized Rev Req'!K70","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J70","v":7000},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A71","v":"Energy Savings Assistance (ESA/LIEE/DAP)"},null,{"$f":"'Authorized Rev Req'!B71","v":"AL 3137-G, D.21-06-015, AL 3247-G-B"},7005.5879999999997,{"$f":"'Authorized Rev Req'!K71","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J71","v":7005.5879999999997},{"$f":"14340989/1000","v":14340.989},{"$f":"15138709/1000","v":15138.709000000001},0,0,"Existing","approved budgets for ESA 2021-2026 provided by Edith Nieves"]
[{"$f":"'Authorized Rev Req'!A72","v":"Energy Efficiency"},null,{"$f":"'Authorized Rev Req'!B72","v":"D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G"},25981.63,{"$f":"'Authorized Rev Req'!K72","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J72","v":25981.63},{"$f":"25537311/1000","v":25537.311000000002},{"$f":"G68","v":25537.311000000002},{"$f":"H68","v":25537.311000000002},{"$f":"26310181/1000","v":26310.181},"Existing","approved budget for EE 2024-2028 provided by Edith Nieves"]
[{"$f":"'Authorized Rev Req'!A73","v":"RD&D "},null,{"$f":"'Authorized Rev Req'!B73","v":"AL 3137-G, AL 3245-G"},2183.7319900000002,{"$f":"'Authorized Rev Req'!K73","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J73","v":2183.7319900000002},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A74","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B74","v":"AL 3137-G, AL 3245-G"},47.053350000000002,{"$f":"'Authorized Rev Req'!K74","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!J74","v":47.053350000000002},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B84","v":"D.97-07-061"},{"$f":"F80","v":259331.31984714375},{"$f":"'Authorized Rev Req'!K84","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!J84","v":259331.31984714375},{"$f":"F80","v":259331.31984714375},259331.31984714375,259331.31984714375,259331.31984714375,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D9:D83)","v":1068039.4897010343},null,{"$f":"SUM(F9:F83)","v":1068039.4897010343},{"$f":"SUM(G9:G83)","v":763200.55277368904},{"$f":"SUM(H9:H83)","v":758142.50109968905},{"$f":"SUM(I9:I83)","v":715886.60343468911},{"$f":"SUM(J9:J83)","v":285641.50084714376}]
[]
["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",null,"Authorized + Pending"]
["2024 GRC Application","A.22-05-016","PD",{"$f":"SUM(F92:J92)","v":859950.78748851898},"Allocated Base Margin",178307.60219244525,202105.99203744164,226884.02137420111,252653.17188443098,null,"Existing",{"$f":"IFERROR(VLOOKUP(A92,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2024},2025,2026,2027,2028]
["Pipeline Safety Enhancement Plan (PSEP) -Local T","A.22-05-016","PD",5907.6946401090827,"Local Transmission",-624.51023999999916,2156.9783601090817,2158.3665600000004,2216.8599600000002,null,"Existing",{"$f":"IFERROR(VLOOKUP(A93,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUM(O8,SUMIFS(F$92:F$119,$E$92:$E$119,$N93,$L$92:$L$119,\"y\"))","v":259331.31984714375},{"$f":"SUM(P8,SUMIFS(G$92:G$119,$E$92:$E$119,$N93,$L$92:$L$119,\"y\"))","v":259331.31984714375},{"$f":"SUM(Q8,SUMIFS(H$92:H$119,$E$92:$E$119,$N93,$L$92:$L$119,\"y\"))","v":259331.31984714375},{"$f":"SUM(R8,SUMIFS(I$92:I$119,$E$92:$E$119,$N93,$L$92:$L$119,\"y\"))","v":259331.31984714375},{"$f":"SUM(S8,SUMIFS(J$92:J$119,$E$92:$E$119,$N93,$L$92:$L$119,\"y\"))","v":259331.31984714375}]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","PD",166778.7894531764,"Distribution",39215.000999999997,40781.471521777996,42540.351436960002,44241.965494438402,null,"Existing",{"$f":"IFERROR(VLOOKUP(A94,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Allocated Base Margin",595652.34357399063,619450.73341898702,644228.76275574649,669997.91326597636,0]
["Natural Gas Leak Abatement","3285-G-A","Advice Letter",16435.801876581922,"EPAM",null,8124.5255081343203,8311.2763684475995,null,null,"New","Y",null,"Distribution",88583.179378244502,40781.471521777996,42540.351436960002,44241.965494438402,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A96,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"All Residential",3644.4740161621276,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A97,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Local Transmission",12724.1355519715,2156.9783601090817,2158.3665600000004,2216.8599600000002,0]
["Public Policy Proceedings",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A98,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Seasonal Storage",17001.410111315254,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A99,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"GHG End User",103860.94274477664,0,0,0,0]
[" Cost Allocation Proceeding","A. 22-09-015","Settlment Agreement",0,"EPAM",0,0,null,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A100,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Public Purpose Programs",64372.851361122666,52461.612999999998,53377.255000000005,37424.365000000005,26310.181]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A101,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"-",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A102,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"46% Res (LUAF, Other)",3692.5002110152182,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A103,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"ECPT",45469.482105632895,12271.016944999999,3233.7377709999996,1786.1772059999998,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A104,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"EPAM",54201.908294616143,29916.387108134317,33166.723468447599,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A105,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"CFCA",32720.484075331624,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A106,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Non-Residential",3682.5513821565892,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A107,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Total",{"$f":"SUM(O93:O106)","v":1284937.582653479},{"$f":"SUM(P93:P106)","v":1016369.5202011522},{"$f":"SUM(Q93:Q106)","v":1038036.5168392978},{"$f":"SUM(R93:R106)","v":1014998.6007735585},{"$f":"SUM(S93:S106)","v":285641.50084714376}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A108,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Incremental Revenues",{"$f":"O107-O22","v":216898.09295244468},{"$f":"P107-P22","v":253168.96742746304},{"$f":"Q107-Q22","v":279894.01573960867},{"$f":"R107-R22","v":299111.99733886938},{"$f":"S107-S22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A109,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"CPUC Fee",{"$f":"RegulatoryFee","v":1E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A110,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Check Figure",{"$f":"ROUND(O108,6)-ROUND(F120,6)","v":0},{"$f":"ROUND(P108,6)-SUM(G92:G119)","v":-4.6304194256663322E-7},{"$f":"ROUND(Q108,6)-SUM(H92:H119)","v":3.9133010432124138E-7},{"$f":"ROUND(R108,6)-SUM(I92:I119)","v":1.3061799108982086E-7},{"$f":"ROUND(S108,6)-SUM(J92:J119)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A111,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A112,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A113,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A114,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A115,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A116,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A117,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A118,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,{"$f":"SUM(F119:J119)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A119,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D92:D119)","v":1049073.0734583864},null,{"$f":"SUM(F92:F119)","v":216898.09295244524},{"$f":"SUM(G92:G119)","v":253168.96742746304},{"$f":"SUM(H92:H119)","v":279894.01573960867},{"$f":"SUM(I92:I119)","v":299111.99733886938},{"$f":"SUM(J92:J119)","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,25,16,25],[31,5,31,7],[36,20,36,21],[15,22,15,23],[16,22,16,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],[15,24,16,24],[46,20,46,21],[52,20,52,21],[0,2,0,3],[25,5,25,10],[71,20,71,21],[15,20,15,21],[16,20,16,21],[25,15,25,21],[64,20,64,21]]}
[null,null,"Revenue Change ($000)"]
[null,null,"Authorized","w/ Pending"]
[null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B3,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":259331.31984714375},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B3,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":259331.31984714375},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$8:$S$21,MATCH(B4,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":417344.74138154538},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B4,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":595652.34357399063},null,null,{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential","CPUC Fee"]
[null,"Distribution",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B5,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":49368.178378244505},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B5,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":88583.179378244502},null,"Residential",0.588631244029723,0.8281360554566396,0.6930742196352998,1,0.41531057983403791,0.74289826710724882,0.52375194016439541,0.47439185603624595,null,0.46,0.28236732831753186,0.8281360554566396,0.61658896708606825,0,{"$f":"RegulatoryFee","v":1E-3}]
[null,"All Residential",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B6,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":3644.4740161621276},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B6,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":3644.4740161621276}]
[null,"Local Transmission",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B7,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":13348.645791971499},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B7,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":12724.1355519715},null,null,"Revenue Change ($000) - System"]
[null,"Seasonal Storage",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B8,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":17001.410111315254},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B8,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":17001.410111315254},null,"Authorized",{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% Res (LUAF, Other)","ECPT","EPAM","CFCA","Non-Residential"]
[null,"GHG End User",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B9,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":103860.94274477664},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B9,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":103860.94274477664},null,"Residential",{"$f":"G5*G10","v":152650.51741749421},{"$f":"H5*H10","v":345618.22789328435},{"$f":"I5*I10","v":34215.81170431809},3644.4740161621276,5543.8338238628739,12630.318110075761,54397.370269879953,30537.956435548364,{"$f":"O5*O10","v":0},1698.5500970670005,{"$f":"Q5*Q10","v":12839.096182149384},{"$f":"R5*R10","v":44886.554533325929},{"$f":"S5*S10","v":20175.089478564871},{"$f":"T5*T10","v":0},{"$f":"SUM(G9:T9)","v":718837.79996173293},"Check","CPUC Fee"]
[null,"Public Purpose Programs",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B10,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":64372.851361122666},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B10,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":64372.851361122666},null,"Total System",{"$f":"C3","v":259331.31984714375},{"$f":"C4","v":417344.74138154538},{"$f":"C5","v":49368.178378244505},{"$f":"C6","v":3644.4740161621276},{"$f":"C7","v":13348.645791971499},{"$f":"C8","v":17001.410111315254},{"$f":"C9","v":103860.94274477664},{"$f":"C10","v":64372.851361122666},{"$f":"C11","v":0},{"$f":"C12","v":3692.5002110152182},{"$f":"C13","v":45469.482105632895},{"$f":"C14","v":54201.908294616143},{"$f":"C15","v":32720.484075331624},{"$f":"C16","v":3682.5513821565892},{"$f":"SUM(G10:T10)","v":1068039.4897010343},{"$f":"U10-C17","v":0},{"$f":"RegulatoryFee","v":1E-3}]
[null,"-",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B11,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":0},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B11,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":0},null,"w/Pending"]
[null,"46% Res (LUAF, Other)",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B12,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":3692.5002110152182},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B12,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":3692.5002110152182},null,"Residential",{"$f":"G5*G13","v":152650.51741749421},{"$f":"H5*H13","v":493281.18223086762},61394.717920390591,3644.4740161621276,5284.4681139761797,12630.318110075761,54397.370269879953,30537.956435548364,{"$f":"O5*O13","v":0},1698.5500970670005,{"$f":"Q5*Q13","v":12839.096182149384},{"$f":"R5*R13","v":44886.554533325929},{"$f":"S5*S13","v":20175.089478564871},{"$f":"T5*T13","v":0},{"$f":"SUM(G12:T12)","v":893420.29480550205},"Check","CPUC Fee"]
[null,"ECPT",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B13,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":45469.482105632895},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B13,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":45469.482105632895},null,"Total System",{"$f":"D3","v":259331.31984714375},{"$f":"D4","v":595652.34357399063},{"$f":"D5","v":88583.179378244502},{"$f":"D6","v":3644.4740161621276},{"$f":"D7","v":12724.1355519715},{"$f":"D8","v":17001.410111315254},{"$f":"D9","v":103860.94274477664},{"$f":"D10","v":64372.851361122666},{"$f":"D11","v":0},{"$f":"D12","v":3692.5002110152182},{"$f":"D13","v":45469.482105632895},{"$f":"D14","v":54201.908294616143},{"$f":"D15","v":32720.484075331624},{"$f":"D16","v":3682.5513821565892},{"$f":"SUM(G13:T13)","v":1284937.582653479},{"$f":"U13-D17","v":0},{"$f":"RegulatoryFee","v":1E-3}]
[null,"EPAM",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B14,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":54201.908294616143},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B14,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":54201.908294616143},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$8:$S$21,MATCH(B15,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":32720.484075331624},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B15,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":32720.484075331624},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.15647077444701882,{"$f":"AC15","v":0.15647077444701882}]
[null,"Non-Residential",{"$f":"INDEX('Incremental Rev Req'!$N$8:$S$21,MATCH(B16,'Incremental Rev Req'!$N$8:$N$21,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$7:$S$7,0))","v":3682.5513821565892},{"$f":"INDEX('Incremental Rev Req'!$N$93:$S$106,MATCH(B16,'Incremental Rev Req'!$N$93:$N$106,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$92:$S$92,0))","v":3682.5513821565892},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":1068039.4897010343},{"$f":"SUM(D3:D16)","v":1284937.582653479},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","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% 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":566187.28254423873},null,{"$f":"SUMPRODUCT(H12:T12,H19:T19)","v":740769.77738800785},null,{"$f":"SUMPRODUCT(G9,G19)","v":152650.51741749421},{"$f":"SUMPRODUCT(G12,G19)","v":152650.51741749421}]
[null,null,null,null,null,"Total System",1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUMPRODUCT(H10:T10,H20:T20)","v":808708.16985389043},null,{"$f":"SUMPRODUCT(H13:T13,H20:T20)","v":1025606.2628063356},null,{"$f":"SUMPRODUCT(G10,G20)","v":259331.31984714375},{"$f":"SUMPRODUCT(G13,G20)","v":259331.31984714375}]
[]
[null,null,"TCAP D.20-02-045  SALES DETERMINANTS SYSTEM NET","TCAP D.20-02-045  SALES DETERMINANTS BUNDLED"]
[null,"Residential",313234.40934070927,310981.19469103281]
[null,"Total System",1109315.3418530996,473212.18655010499]
[]
[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,14643.436251083585,null,"Residential",{"$f":"D23","v":310981.19469103281},229.8418717787402,{"$f":"(U19/C23*100)+(Y19/D23*100)","v":229.8418717787402},{"$f":"(W19/C23*100)+(Z19/D23*100)","v":285.57728578106122},{"$f":"H28/G28-1","v":0},{"$f":"I28/G28-1","v":0.24249460540408108},null,null,null,null,"Residential",{"$f":"C23","v":313234.40934070927},229.48877215460817,{"$f":"U9/Q28*100","v":229.48877215460817},{"$f":"U12/Q28*100","v":285.22418615692914},{"$f":"S28/R28-1","v":0},{"$f":"T28/R28-1","v":0.2428677162679298}]
[null,2021,23945.842837510012,null,"Total System",{"$f":"D24","v":473212.18655010499},127.70389155959495,{"$f":"(U20/C24*100)+(Y20/D24*100)","v":127.70389155959495},{"$f":"(W20/C24*100)+(Z20/D24*100)","v":147.25632041090057},{"$f":"H29/G29-1","v":0},{"$f":"I29/G29-1","v":0.15310754130136428},null,null,null,null,"Total System",{"$f":"C24","v":1109315.3418530996},96.279159712772525,{"$f":"U10/Q29*100","v":96.279159712772525},{"$f":"U13/Q29*100","v":115.83158856407812},{"$f":"S29/R29-1","v":0},{"$f":"T29/R29-1","v":0.20308059303421344}]
[null,2022,25613.07213654686,null,null,null,null,"cents/therm"]
[null,2023,22795.559340745884]
[null,2024,21383.37754112266]

{"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",187959.32956315737,2.2183702129715859,{"$f":"F7*E7","v":416963.37795301789},{"$f":"((Y10-I12-T12)/SUM(E7,F9/F7*E9,P7*((Q7/F7)),P9*((Q9/F7))))","v":2.2835515863805798},{"$f":"E7*H7","v":429214.82519897824},{"$f":"((Y13-K12-V12)/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*((Q7/F7)),SUM(P9)*(Q9/F7)))","v":2.8381525451448395},{"$f":"E7*J7","v":533457.24958339275},null,null,null,{"$f":"D7","v":"Baseline"},34568.659520669324,1.7380840610361086,{"$f":"Q7*P7","v":60083.236124259478},{"$f":"H7*(1+(Q7/F7-1))","v":1.7891534026348033},{"$f":"P7*S7","v":61848.634805929505},{"$f":"J7*(1+(Q7/F7-1))","v":2.223681003585714},{"$f":"P7*U7","v":76869.671495534814},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":698319.39549946727}]
[null,null,null,"non-Baseline",76615.611405786854,2.5235302129715862,{"$f":"F9*E9","v":193341.81016779359},{"$f":"F9/F$7*H$7","v":2.5976779652983915},{"$f":"E9*H9","v":199022.68554667663},{"$f":"F9/F$7*J$7","v":3.2285700803299346},247358.87067090833,null,null,null,{"$f":"D9","v":"non-Baseline"},14090.808851095719,1.9822120610361087,{"$f":"Q9*P9","v":27930.971254396289},{"$f":"H9*(1+(Q9/F9-1))","v":2.0404545057690524},{"$f":"P9*S9","v":28751.654410148705},{"$f":"J9*(1+(Q9/F9-1))","v":2.5360150317337897},{"$f":"P9*U9","v":35734.503055666275},null,"Change (Authorized)",{"$f":"Y10-Y8","v":20518.404462265666}]
[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":718837.79996173293}]
[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":664014.40923910646},0,{"$f":"F12*12*E12/1000","v":0},{"$f":"SetUp!D7","v":0},{"$f":"(H12*12*E12)/1000","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0},null,null,null,"Fixed Charge",210053,{"$f":"F12*(1-CAREDiscountPercent)","v":0},{"$f":"Q12*12*P12/1000","v":0},{"$f":"SetUp!D7*(1-CAREDiscountPercent)","v":0},{"$f":"(S12*12*P12)/1000","v":0},{"$f":"S12","v":0},{"$f":"T12","v":0},null,"Change (w/Pending)",{"$f":"Y13-Y8","v":195100.89930603479}]
[null,null,null,"Total Customers",874067.40923910646,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":893420.29480550205}]
[]
[]
[]
[]
[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",2.2610749491979809,2.2835515863805798,{"$f":"H7","v":2.2835515863805798},{"$f":"J7","v":2.8381525451448395},null,{"$f":"Zones","v":"SDG&E"},11,29,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15.833333333333334,34,15.5,28.166666666666668,{"$f":"SUM(Q22:R22)/SUM($Q$22:$R$25)","v":1},{"$f":"SUM(S22:T22)/SUM($S$22:$T$25)","v":1}]
[null,"Tier 2",2.5690936984895085,2.5976779652983915,{"$f":"H9","v":2.5976779652983915},{"$f":"J9","v":3.2285700803299346},null,0,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q23:R23)/SUM($Q$22:$R$25)","v":0},{"$f":"SUM(S23:T23)/SUM($S$22:$T$25)","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q24:R24)/SUM($Q$22:$R$25)","v":0},{"$f":"SUM(S24:T24)/SUM($S$22:$T$25)","v":0}]
["Winter","Tier 1",{"$f":"C22","v":2.2610749491979809},{"$f":"D22","v":2.2835515863805798},{"$f":"E22","v":2.2835515863805798},2.8381525451448395,null,0,null,null,null,null,null,null,null,0,null,null,null,null,{"$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",{"$f":"C23","v":2.5690936984895085},{"$f":"D23","v":2.5976779652983915},{"$f":"E23","v":2.5976779652983915},3.2285700803299346]
[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":"BOYEffectiveRateDate","v":"2024-01-01"},{"$f":"CurrentEffectiveRateDate","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.7711876155194377,1.7891534026348033,{"$f":"S7","v":1.7891534026348033},{"$f":"U7","v":2.223681003585714},null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15.661739406613,34.069279171492305,14.458914681218566,26.812122049869362,{"$f":"SUM(Q31:R31)/SUM($Q$31:$R$34)","v":1},{"$f":"SUM(S31:T31)/SUM($S$31:$T$34)","v":1}]
[null,"Tier 2",2.0176026149526596,2.0404545057690524,{"$f":"S9","v":2.0404545057690524},{"$f":"U9","v":2.5360150317337897},null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q32:R32)/SUM($Q$31:$R$34)","v":0},{"$f":"SUM(S32:T32)/SUM($S$31:$T$34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q33:R33)/SUM($Q$31:$R$34)","v":0},{"$f":"SUM(S33:T33)/SUM($S$31:$T$34)","v":0}]
["Winter","Tier 1",{"$f":"C31","v":1.7711876155194377},1.778826651624575,{"$f":"E31","v":1.7891534026348033},2.223681003585714,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q34:R34)/SUM($Q$31:$R$34)","v":0},{"$f":"SUM(S34:T34)/SUM($S$31:$T$34)","v":0}]
[null,"Tier 2",{"$f":"C32","v":2.0176026149526596},2.0263044255832194,{"$f":"E32","v":2.0404545057690524},2.5360150317337897]
[]
[]
[]
[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":"SDG&E"},{"$f":"IF($Q22>$I22,C$22*$I22+C$23*($Q22-$I22),$Q22*C$22)+('Incremental Rev Req'!$F$86*$Q22)+IF(Q22>0,$F$12,0)","v":37.304943983877081},{"$f":"IF($R22>$J22,C$25*$J22+C$26*($R22-$J22),$R22*C$25)+('Incremental Rev Req'!$F$86*$R22)+IF(R22>0,$F$12,0)","v":78.45064201918899},{"$f":"IF($Q22>$I22,D$22*$I22+D$23*($Q22-$I22),$Q22*D$22)+('Incremental Rev Req'!$F$86*$Q22)+IF(Q22>0,$F$12,0)","v":37.690344282461936},{"$f":"IF($R22>$J22,D$25*$J22+D$26*($R22-$J22),$R22*D$25)+('Incremental Rev Req'!$F$86*$R22)+IF(R22>0,$F$12,0)","v":79.245385831528779},{"$f":"IF($Q22>$I22,E$22*$I22+E$23*($Q22-$I22),$Q22*E$22)+('Incremental Rev Req'!$F$86*$Q22)+IF(Q22>0,$H$12,0)","v":37.690344282461936},{"$f":"IF($R22>$J22,E$25*$J22+E$26*($R22-$J22),$R22*E$25)+('Incremental Rev Req'!$F$86*$R22)+IF(R22>0,$H$12,0)","v":79.245385831528779},{"$f":"IF($Q22>$I22,F$22*$I22+F$23*($Q22-$I22),$Q22*F$22)+('Incremental Rev Req'!$F$86*$Q22)+IF(Q22>0,$J$12,0)","v":46.84026671818792},{"$f":"IF($R22>$J22,F$25*$J22+F$26*($R22-$J22),$R22*F$25)+('Incremental Rev Req'!$F$86*$R22)+IF(R22>0,$J$12,0)","v":98.483274210850013}]
[null,0,{"$f":"IF($Q23>$I23,C$22*$I23+C$23*($Q23-$I23),$Q23*C$22)+('Incremental Rev Req'!$F$86*$Q23)+IF(Q23>0,$F$12,0)","v":0},{"$f":"IF($R23>$J23,C$25*$J23+C$26*($R23-$J23),$R23*C$25)+('Incremental Rev Req'!$F$86*$R23)+IF(R23>0,$F$12,0)","v":0},{"$f":"IF($Q23>$I23,D$22*$I23+D$23*($Q23-$I23),$Q23*D$22)+('Incremental Rev Req'!$F$86*$Q23)+IF(Q23>0,$F$12,0)","v":0},{"$f":"IF($R23>$J23,D$25*$J23+D$26*($R23-$J23),$R23*D$25)+('Incremental Rev Req'!$F$86*$R23)+IF(R23>0,$F$12,0)","v":0},{"$f":"IF($Q23>$I23,E$22*$I23+E$23*($Q23-$I23),$Q23*E$22)+('Incremental Rev Req'!$F$86*$Q23)+IF(Q23>0,$H$12,0)","v":0},{"$f":"IF($R23>$J23,E$25*$J23+E$26*($R23-$J23),$R23*E$25)+('Incremental Rev Req'!$F$86*$R23)+IF(R23>0,$H$12,0)","v":0},{"$f":"IF($Q23>$I23,F$22*$I23+F$23*($Q23-$I23),$Q23*F$22)+('Incremental Rev Req'!$F$86*$Q23)+IF(Q23>0,$J$12,0)","v":0},{"$f":"IF($R23>$J23,F$25*$J23+F$26*($R23-$J23),$R23*F$25)+('Incremental Rev Req'!$F$86*$R23)+IF(R23>0,$J$12,0)","v":0}]
[null,0,{"$f":"IF($Q24>$I24,C$22*$I24+C$23*($Q24-$I24),$Q24*C$22)+('Incremental Rev Req'!$F$86*$Q24)+IF(Q24>0,$F$12,0)","v":0},{"$f":"IF($R24>$J24,C$25*$J24+C$26*($R24-$J24),$R24*C$25)+('Incremental Rev Req'!$F$86*$R24)+IF(R24>0,$F$12,0)","v":0},{"$f":"IF($Q24>$I24,D$22*$I24+D$23*($Q24-$I24),$Q24*D$22)+('Incremental Rev Req'!$F$86*$Q24)+IF(Q24>0,$F$12,0)","v":0},{"$f":"IF($R24>$J24,D$25*$J24+D$26*($R24-$J24),$R24*D$25)+('Incremental Rev Req'!$F$86*$R24)+IF(R24>0,$F$12,0)","v":0},{"$f":"IF($Q24>$I24,E$22*$I24+E$23*($Q24-$I24),$Q24*E$22)+('Incremental Rev Req'!$F$86*$Q24)+IF(Q24>0,$H$12,0)","v":0},{"$f":"IF($R24>$J24,E$25*$J24+E$26*($R24-$J24),$R24*E$25)+('Incremental Rev Req'!$F$86*$R24)+IF(R24>0,$H$12,0)","v":0},{"$f":"IF($Q24>$I24,F$22*$I24+F$23*($Q24-$I24),$Q24*F$22)+('Incremental Rev Req'!$F$86*$Q24)+IF(Q24>0,$J$12,0)","v":0},{"$f":"IF($R24>$J24,F$25*$J24+F$26*($R24-$J24),$R24*F$25)+('Incremental Rev Req'!$F$86*$R24)+IF(R24>0,$J$12,0)","v":0}]
[null,0,{"$f":"IF($Q25>$I25,C$22*$I25+C$23*($Q25-$I25),$Q25*C$22)+('Incremental Rev Req'!$F$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$R25)+IF(R25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C43:C46,$U$22:$U$25)","v":37.304943983877081},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":78.45064201918899},37.690344282461936,79.245385831528779,37.690344282461936,79.245385831528779,46.84026671818792,98.483274210850013]
[]
[]
[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":"SDG&E"},{"$f":"IF($S22>$I22,C$31*$I22+C$32*($S22-$I22),$S22*C$31)+('Incremental Rev Req'!$F$86*$S22)+IF(S22>0,$Q$12,0)","v":28.577775538000783},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Incremental Rev Req'!$F$86*$T22)+IF(T22>0,$Q$12,0)","v":49.916617837130829},{"$f":"IF($S22>$I22,D$31*$I22+D$32*($S22-$I22),$S22*D$31)+('Incremental Rev Req'!$F$86*$S22)+IF(S22>0,$Q$12,0)","v":28.878232704943571},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Incremental Rev Req'!$F$86*$T22)+IF(T22>0,$Q$12,0)","v":50.131784020758865},{"$f":"IF($S22>$I22,E$31*$I22+E$32*($S22-$I22),$S22*E$31)+('Incremental Rev Req'!$F$86*$S22)+IF(S22>0,$S$12,0)","v":28.878232704943571},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Incremental Rev Req'!$F$86*$T22)+IF(T22>0,$S$12,0)","v":50.422654174213626},{"$f":"IF($S22>$I22,F$31*$I22+F$32*($S22-$I22),$S22*F$31)+('Incremental Rev Req'!$F$86*$S22)+IF(S22>0,$U$12,0)","v":35.88805868224491},{"$f":"IF($T22>$J22,F$34*$J22+F$35*($T22-$J22),$T22*F$34)+('Incremental Rev Req'!$F$86*$T22)+IF(T22>0,$U$12,0)","v":62.661848267664276}]
[null,0,{"$f":"IF($S23>$I23,C$31*$I23+C$32*($S23-$I23),$S23*C$31)+('Incremental Rev Req'!$F$86*$S23)+IF(S23>0,$Q$12,0)","v":0},{"$f":"IF($T23>$J23,C$34*$J23+C$35*($T23-$J23),$T23*C$34)+('Incremental Rev Req'!$F$86*$T23)+IF(T23>0,$Q$12,0)","v":0},{"$f":"IF($S23>$I23,D$31*$I23+D$32*($S23-$I23),$S23*D$31)+('Incremental Rev Req'!$F$86*$S23)+IF(S23>0,$Q$12,0)","v":0},{"$f":"IF($T23>$J23,D$34*$J23+D$35*($T23-$J23),$T23*D$34)+('Incremental Rev Req'!$F$86*$T23)+IF(T23>0,$Q$12,0)","v":0},{"$f":"IF($S23>$I23,E$31*$I23+E$32*($S23-$I23),$S23*E$31)+('Incremental Rev Req'!$F$86*$S23)+IF(S23>0,$S$12,0)","v":0},{"$f":"IF($T23>$J23,E$34*$J23+E$35*($T23-$J23),$T23*E$34)+('Incremental Rev Req'!$F$86*$T23)+IF(T23>0,$S$12,0)","v":0},{"$f":"IF($S23>$I23,F$31*$I23+F$32*($S23-$I23),$S23*F$31)+('Incremental Rev Req'!$F$86*$S23)+IF(S23>0,$U$12,0)","v":0},{"$f":"IF($T23>$J23,F$34*$J23+F$35*($T23-$J23),$T23*F$34)+('Incremental Rev Req'!$F$86*$T23)+IF(T23>0,$U$12,0)","v":0}]
[null,0,{"$f":"IF($S24>$I24,C$31*$I24+C$32*($S24-$I24),$S24*C$31)+('Incremental Rev Req'!$F$86*$S24)+IF(S24>0,$Q$12,0)","v":0},{"$f":"IF($T24>$J24,C$34*$J24+C$35*($T24-$J24),$T24*C$34)+('Incremental Rev Req'!$F$86*$T24)+IF(T24>0,$Q$12,0)","v":0},{"$f":"IF($S24>$I24,D$31*$I24+D$32*($S24-$I24),$S24*D$31)+('Incremental Rev Req'!$F$86*$S24)+IF(S24>0,$Q$12,0)","v":0},{"$f":"IF($T24>$J24,D$34*$J24+D$35*($T24-$J24),$T24*D$34)+('Incremental Rev Req'!$F$86*$T24)+IF(T24>0,$Q$12,0)","v":0},{"$f":"IF($S24>$I24,E$31*$I24+E$32*($S24-$I24),$S24*E$31)+('Incremental Rev Req'!$F$86*$S24)+IF(S24>0,$S$12,0)","v":0},{"$f":"IF($T24>$J24,E$34*$J24+E$35*($T24-$J24),$T24*E$34)+('Incremental Rev Req'!$F$86*$T24)+IF(T24>0,$S$12,0)","v":0},{"$f":"IF($S24>$I24,F$31*$I24+F$32*($S24-$I24),$S24*F$31)+('Incremental Rev Req'!$F$86*$S24)+IF(S24>0,$U$12,0)","v":0},{"$f":"IF($T24>$J24,F$34*$J24+F$35*($T24-$J24),$T24*F$34)+('Incremental Rev Req'!$F$86*$T24)+IF(T24>0,$U$12,0)","v":0}]
[null,0,{"$f":"IF($S25>$I25,C$31*$I25+C$32*($S25-$I25),$S25*C$31)+('Incremental Rev Req'!$F$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$T25)+IF(T25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C53:C56,$V$22:$V$25)","v":28.577775538000783},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":49.916617837130829},28.878232704943571,50.131784020758865,28.878232704943571,50.422654174213626,35.88805868224491,62.661848267664276]
[]
[]
[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":"SDG&E"},{"$f":"($C$22*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$F$12,0)","v":24.882824441177789},{"$f":"($C$25*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$F$12,0)","v":65.600173526741443},{"$f":"($D$22*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$F$12,0)","v":25.130067450186377},{"$f":"($D$25*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$F$12,0)","v":66.251996005036816},{"$f":"($E$22*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$H$12,0)","v":25.130067450186377},{"$f":"($E$25*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$H$12,0)","v":66.251996005036816},{"$f":"($F$22*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$J$12,0)","v":31.230677996593233},{"$f":"($F$25*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$J$12,0)","v":82.335423809200336}]
[null,0,{"$f":"($C$22*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($C$25*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($D$22*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($D$25*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($E$22*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$H$12,0)","v":0},{"$f":"($E$25*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$H$12,0)","v":0},{"$f":"($F$22*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$J$12,0)","v":0},{"$f":"($F$25*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($C$25*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($D$22*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($D$25*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($E$22*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$H$12,0)","v":0},{"$f":"($E$25*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$H$12,0)","v":0},{"$f":"($F$22*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$J$12,0)","v":0},{"$f":"($F$25*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($C$25*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($D$22*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($D$25*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($E$22*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$H$12,0)","v":0},{"$f":"($E$25*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$H$12,0)","v":0},{"$f":"($F$22*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$J$12,0)","v":0},{"$f":"($F$25*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C63:C66,$U$22:$U$25)","v":24.882824441177789},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":65.600173526741443},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":25.130067450186377},{"$f":"SUMPRODUCT(F63:F66,$U$22:$U$25)","v":66.251996005036816},25.130067450186377,66.251996005036816,31.230677996593233,82.335423809200336]
[]
[]
[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":"SDG&E"},{"$f":"($C$31*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$Q$12,0)","v":19.494063770713815},{"$f":"($C$34*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$Q$12,0)","v":51.393440850063698},{"$f":"($D$31*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$Q$12,0)","v":19.691687428982835},{"$f":"($D$34*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$Q$12,0)","v":51.614972897112679},{"$f":"($E$31*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$S$12,0)","v":19.691687428982835},{"$f":"($E$34*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$S$12,0)","v":51.9144486764093},{"$f":"($F$31*$I22)+('Incremental Rev Req'!$F$86*$I22)+IF(I22>0,$U$12,0)","v":24.471491039442853},{"$f":"($F$34*$J22)+('Incremental Rev Req'!$F$86*$J22)+IF(J22>0,$U$12,0)","v":64.515749103985698}]
[null,0,{"$f":"($C$31*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($C$34*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($D$31*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($D$34*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($E$31*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$S$12,0)","v":0},{"$f":"($E$34*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$S$12,0)","v":0},{"$f":"($F$31*$I23)+('Incremental Rev Req'!$F$86*$I23)+IF(I23>0,$U$12,0)","v":0},{"$f":"($F$34*$J23)+('Incremental Rev Req'!$F$86*$J23)+IF(J23>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($C$34*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($D$31*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($D$34*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($E$31*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$S$12,0)","v":0},{"$f":"($E$34*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$S$12,0)","v":0},{"$f":"($F$31*$I24)+('Incremental Rev Req'!$F$86*$I24)+IF(I24>0,$U$12,0)","v":0},{"$f":"($F$34*$J24)+('Incremental Rev Req'!$F$86*$J24)+IF(J24>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($C$34*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($D$31*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($D$34*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($E$31*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$S$12,0)","v":0},{"$f":"($E$34*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$S$12,0)","v":0},{"$f":"($F$31*$I25)+('Incremental Rev Req'!$F$86*$I25)+IF(I25>0,$U$12,0)","v":0},{"$f":"($F$34*$J25)+('Incremental Rev Req'!$F$86*$J25)+IF(J25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C73:C76,$V$22:$V$25)","v":19.494063770713815},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":51.393440850063698},19.691687428982835,51.614972897112679,19.691687428982835,51.9144486764093,24.471491039442853,64.515749103985698]
[]
[]
[null,null,"Typical 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":"SDG&E"},{"$f":"IF($Q31>$I22,C$22*$I22+C$23*($Q31-$I22),$Q31*C$22)+('Incremental Rev Req'!$F$86*$Q31)+IF(Q31>0,$F$12,0)","v":36.863931514114078},{"$f":"IF($R31>$J22,C$25*$J22+C$26*($R31-$J22),$R31*C$25)+('Incremental Rev Req'!$F$86*$R31)+IF(R31>0,$F$12,0)","v":78.628695981277929},{"$f":"IF($Q31>$I22,D$22*$I22+D$23*($Q31-$I22),$Q31*D$22)+('Incremental Rev Req'!$F$86*$Q31)+IF(Q31>0,$F$12,0)","v":37.244426926114777},{"$f":"IF($R31>$J22,D$25*$J22+D$26*($R31-$J22),$R31*D$25)+('Incremental Rev Req'!$F$86*$R31)+IF(R31>0,$F$12,0)","v":79.425420087939955},{"$f":"IF($Q31>$I22,E$22*$I22+E$23*($Q31-$I22),$Q31*E$22)+('Incremental Rev Req'!$F$86*$Q31)+IF(Q31>0,$H$12,0)","v":37.244426926114777},{"$f":"IF($R31>$J22,E$25*$J22+E$26*($R31-$J22),$R31*E$25)+('Incremental Rev Req'!$F$86*$R31)+IF(R31>0,$H$12,0)","v":79.425420087939955},{"$f":"IF($Q31>$I22,F$22*$I22+F$23*($Q31-$I22),$Q31*F$22)+('Incremental Rev Req'!$F$86*$Q31)+IF(Q31>0,$J$12,0)","v":46.286092106485597},{"$f":"IF($R31>$J22,F$25*$J22+F$26*($R31-$J22),$R31*F$25)+('Incremental Rev Req'!$F$86*$R31)+IF(R31>0,$J$12,0)","v":98.707016150291608}]
[null,0,{"$f":"IF($Q32>$I23,C$22*$I23+C$23*($Q32-$I23),$Q32*C$22)+('Incremental Rev Req'!$F$86*$Q32)+IF(Q32>0,$F$12,0)","v":0},{"$f":"IF($R32>$J23,C$25*$J23+C$26*($R32-$J23),$R32*C$25)+('Incremental Rev Req'!$F$86*$R32)+IF(R32>0,$F$12,0)","v":0},{"$f":"IF($Q32>$I23,D$22*$I23+D$23*($Q32-$I23),$Q32*D$22)+('Incremental Rev Req'!$F$86*$Q32)+IF(Q32>0,$F$12,0)","v":0},{"$f":"IF($R32>$J23,D$25*$J23+D$26*($R32-$J23),$R32*D$25)+('Incremental Rev Req'!$F$86*$R32)+IF(R32>0,$F$12,0)","v":0},{"$f":"IF($Q32>$I23,E$22*$I23+E$23*($Q32-$I23),$Q32*E$22)+('Incremental Rev Req'!$F$86*$Q32)+IF(Q32>0,$H$12,0)","v":0},{"$f":"IF($R32>$J23,E$25*$J23+E$26*($R32-$J23),$R32*E$25)+('Incremental Rev Req'!$F$86*$R32)+IF(R32>0,$H$12,0)","v":0},{"$f":"IF($Q32>$I23,F$22*$I23+F$23*($Q32-$I23),$Q32*F$22)+('Incremental Rev Req'!$F$86*$Q32)+IF(Q32>0,$J$12,0)","v":0},{"$f":"IF($R32>$J23,F$25*$J23+F$26*($R32-$J23),$R32*F$25)+('Incremental Rev Req'!$F$86*$R32)+IF(R32>0,$J$12,0)","v":0}]
[null,0,{"$f":"IF($Q33>$I24,C$22*$I24+C$23*($Q33-$I24),$Q33*C$22)+('Incremental Rev Req'!$F$86*$Q33)+IF(Q33>0,$F$12,0)","v":0},{"$f":"IF($R33>$J24,C$25*$J24+C$26*($R33-$J24),$R33*C$25)+('Incremental Rev Req'!$F$86*$R33)+IF(R33>0,$F$12,0)","v":0},{"$f":"IF($Q33>$I24,D$22*$I24+D$23*($Q33-$I24),$Q33*D$22)+('Incremental Rev Req'!$F$86*$Q33)+IF(Q33>0,$F$12,0)","v":0},{"$f":"IF($R33>$J24,D$25*$J24+D$26*($R33-$J24),$R33*D$25)+('Incremental Rev Req'!$F$86*$R33)+IF(R33>0,$F$12,0)","v":0},{"$f":"IF($Q33>$I24,E$22*$I24+E$23*($Q33-$I24),$Q33*E$22)+('Incremental Rev Req'!$F$86*$Q33)+IF(Q33>0,$H$12,0)","v":0},{"$f":"IF($R33>$J24,E$25*$J24+E$26*($R33-$J24),$R33*E$25)+('Incremental Rev Req'!$F$86*$R33)+IF(R33>0,$H$12,0)","v":0},{"$f":"IF($Q33>$I24,F$22*$I24+F$23*($Q33-$I24),$Q33*F$22)+('Incremental Rev Req'!$F$86*$Q33)+IF(Q33>0,$J$12,0)","v":0},{"$f":"IF($R33>$J24,F$25*$J24+F$26*($R33-$J24),$R33*F$25)+('Incremental Rev Req'!$F$86*$R33)+IF(R33>0,$J$12,0)","v":0}]
[null,0,{"$f":"IF($Q34>$I25,C$22*$I25+C$23*($Q34-$I25),$Q34*C$22)+('Incremental Rev Req'!$F$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$R34)+IF(R34>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C83:C86,$U$22:$U$25)","v":36.863931514114078},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":78.628695981277929},{"$f":"SUMPRODUCT(E83:E86,$U$22:$U$25)","v":37.244426926114777},79.425420087939955,37.244426926114777,79.425420087939955,46.286092106485597,98.707016150291608]
[]
[]
[null,null,"Typical 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":"SDG&E"},{"$f":"IF($S31>$I22,C$31*$I22+C$32*($S31-$I22),$S31*C$31)+('Incremental Rev Req'!$F$86*$S31)+IF(S31>0,$Q$12,0)","v":26.476237991119756},{"$f":"IF($T31>$J22,C$34*$J22+C$35*($T31-$J22),$T31*C$34)+('Incremental Rev Req'!$F$86*$T31)+IF(T31>0,$Q$12,0)","v":47.51611064257412},{"$f":"IF($S31>$I22,D$31*$I22+D$32*($S31-$I22),$S31*D$31)+('Incremental Rev Req'!$F$86*$S31)+IF(S31>0,$Q$12,0)","v":26.752904390027201},{"$f":"IF($T31>$J22,D$34*$J22+D$35*($T31-$J22),$T31*D$34)+('Incremental Rev Req'!$F$86*$T31)+IF(T31>0,$Q$12,0)","v":47.720929410968424},{"$f":"IF($S31>$I22,E$31*$I22+E$32*($S31-$I22),$S31*E$31)+('Incremental Rev Req'!$F$86*$S31)+IF(S31>0,$S$12,0)","v":26.752904390027201},{"$f":"IF($T31>$J22,E$34*$J22+E$35*($T31-$J22),$T31*E$34)+('Incremental Rev Req'!$F$86*$T31)+IF(T31>0,$S$12,0)","v":47.997811519433277},{"$f":"IF($S31>$I22,F$31*$I22+F$32*($S31-$I22),$S31*F$31)+('Incremental Rev Req'!$F$86*$S31)+IF(S31>0,$U$12,0)","v":33.24680957917905},{"$f":"IF($T31>$J22,F$34*$J22+F$35*($T31-$J22),$T31*F$34)+('Incremental Rev Req'!$F$86*$T31)+IF(T31>0,$U$12,0)","v":59.648418590166024}]
[null,0,{"$f":"IF($S32>$I23,C$31*$I23+C$32*($S32-$I23),$S32*C$31)+('Incremental Rev Req'!$F$86*$S32)+IF(S32>0,$Q$12,0)","v":0},{"$f":"IF($T32>$J23,C$34*$J23+C$35*($T32-$J23),$T32*C$34)+('Incremental Rev Req'!$F$86*$T32)+IF(T32>0,$Q$12,0)","v":0},{"$f":"IF($S32>$I23,D$31*$I23+D$32*($S32-$I23),$S32*D$31)+('Incremental Rev Req'!$F$86*$S32)+IF(S32>0,$Q$12,0)","v":0},{"$f":"IF($T32>$J23,D$34*$J23+D$35*($T32-$J23),$T32*D$34)+('Incremental Rev Req'!$F$86*$T32)+IF(T32>0,$Q$12,0)","v":0},{"$f":"IF($S32>$I23,E$31*$I23+E$32*($S32-$I23),$S32*E$31)+('Incremental Rev Req'!$F$86*$S32)+IF(S32>0,$S$12,0)","v":0},{"$f":"IF($T32>$J23,E$34*$J23+E$35*($T32-$J23),$T32*E$34)+('Incremental Rev Req'!$F$86*$T32)+IF(T32>0,$S$12,0)","v":0},{"$f":"IF($S32>$I23,F$31*$I23+F$32*($S32-$I23),$S32*F$31)+('Incremental Rev Req'!$F$86*$S32)+IF(S32>0,$U$12,0)","v":0},{"$f":"IF($T32>$J23,F$34*$J23+F$35*($T32-$J23),$T32*F$34)+('Incremental Rev Req'!$F$86*$T32)+IF(T32>0,$U$12,0)","v":0}]
[null,0,{"$f":"IF($S33>$I24,C$31*$I24+C$32*($S33-$I24),$S33*C$31)+('Incremental Rev Req'!$F$86*$S33)+IF(S33>0,$Q$12,0)","v":0},{"$f":"IF($T33>$J24,C$34*$J24+C$35*($T33-$J24),$T33*C$34)+('Incremental Rev Req'!$F$86*$T33)+IF(T33>0,$Q$12,0)","v":0},{"$f":"IF($S33>$I24,D$31*$I24+D$32*($S33-$I24),$S33*D$31)+('Incremental Rev Req'!$F$86*$S33)+IF(S33>0,$Q$12,0)","v":0},{"$f":"IF($T33>$J24,D$34*$J24+D$35*($T33-$J24),$T33*D$34)+('Incremental Rev Req'!$F$86*$T33)+IF(T33>0,$Q$12,0)","v":0},{"$f":"IF($S33>$I24,E$31*$I24+E$32*($S33-$I24),$S33*E$31)+('Incremental Rev Req'!$F$86*$S33)+IF(S33>0,$S$12,0)","v":0},{"$f":"IF($T33>$J24,E$34*$J24+E$35*($T33-$J24),$T33*E$34)+('Incremental Rev Req'!$F$86*$T33)+IF(T33>0,$S$12,0)","v":0},{"$f":"IF($S33>$I24,F$31*$I24+F$32*($S33-$I24),$S33*F$31)+('Incremental Rev Req'!$F$86*$S33)+IF(S33>0,$U$12,0)","v":0},{"$f":"IF($T33>$J24,F$34*$J24+F$35*($T33-$J24),$T33*F$34)+('Incremental Rev Req'!$F$86*$T33)+IF(T33>0,$U$12,0)","v":0}]
[null,0,{"$f":"IF($S34>$I25,C$31*$I25+C$32*($S34-$I25),$S34*C$31)+('Incremental Rev Req'!$F$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$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$86*$T34)+IF(T34>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C93:C96,$V$22:$V$25)","v":26.476237991119756},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":47.51611064257412},26.752904390027201,47.720929410968424,26.752904390027201,47.997811519433277,33.24680957917905,59.648418590166024]

{"sheet":"Hypothetical Summary","index":6,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[[39,12,39,13],[77,10,77,11],[77,12,77,13],[54,1,54,2],[55,1,55,2],[48,1,48,2],[46,1,46,2],[47,1,47,2],[63,1,63,7],[65,1,65,2],[66,1,66,2],[67,1,67,2],[39,10,39,11],[57,1,57,7],[59,1,59,2],[60,1,60,2],[61,1,61,2],[51,1,51,7],[53,1,53,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],[36,1,36,2],[26,9,26,15],[27,9,27,10],[28,9,28,10],[29,9,29,10],[26,1,26,7],[27,1,27,2],[28,1,28,2],[29,1,29,2],[32,1,32,7],[34,1,34,2],[35,1,35,2],[38,1,38,7],[40,1,40,2],[41,1,41,2],[42,1,42,2],[44,1,44,7]]}
[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)","SDG&E",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":15.833333333333334},"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":34},"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":15.5},"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":28.166666666666668},"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":2023}]
[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!D26","v":"2024-01-01"},{"$f":"Summary!E26","v":"2024-12-01"},"Proposed",{"$f":"Summary!H26","v":"% Change over 1/1/2024"},{"$f":"Summary!I26","v":"% Change over 12/1/2024"},null,"Customer Group",null,{"$f":"D28","v":"2024-01-01"},{"$f":"E28","v":"2024-12-01"},"Proposed",{"$f":"Summary!P26","v":"2024 Authorized"},{"$f":"Summary!Q26","v":"2024 w/Pending"}]
[null,"Residential",null,221.15169083443971,{"$f":"'Hypothetical SAR and RAR'!G28","v":223.42294193660797},{"$f":"'Hypothetical SAR and RAR'!H28","v":223.42294193660797},{"$f":"$F29/D29-1","v":1.0270105074026148E-2},{"$f":"$F29/E29-1","v":0},null,"Residential",null,220.79859121030765,{"$f":"'Hypothetical SAR and RAR'!R28","v":223.06984231247591},{"$f":"'Hypothetical SAR and RAR'!S28","v":223.06984231247591},{"$f":"$N29/L29-1","v":1.0286528957084373E-2},{"$f":"$N29/M29-1","v":0}]
[null,"System",null,126.07234778093807,{"$f":"'Hypothetical SAR and RAR'!G29","v":127.37535792459865},{"$f":"'Hypothetical SAR and RAR'!H29","v":127.37535792459865},{"$f":"$F30/D30-1","v":1.0335415867123166E-2},{"$f":"$F30/E30-1","v":0},null,"System",null,94.647615934115635,{"$f":"'Hypothetical SAR and RAR'!R29","v":95.950626077776192},{"$f":"'Hypothetical SAR and RAR'!S29","v":95.950626077776192},{"$f":"$N30/L30-1","v":1.3766962123669124E-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":56.249606139875347},{"$f":"((E41*$H$10)+(E47*$H$11))/12","v":56.799677806542029},56.799677806542029,{"$f":"$F35/D35-1","v":9.7791203248396297E-3},0]
[null,"CARE",null,{"$f":"((D42*$H$10)+(D48*$H$11))/12","v":38.143254665955041},38.519289999288368,38.519289999288368,9.8585014998460174E-3,0]
[null,"Total",null,{"$f":"((D43*$H$10)+(D49*$H$11))/12","v":53.416491302341136},53.939331369149208,53.939331369149208,9.7879897024453211E-3,0,null,{"$f":"'Res Bill Impact'!P18","v":"Basic Bundled"}]
[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,"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":36.255495038716774},{"$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":36.614968372050114},{"$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":36.614968372050114},{"$f":"$F41/D41-1","v":9.9150027588772449E-3},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q22","v":15.833333333333334},{"$f":"'Hypothetical Res Bill Impact'!R22","v":34},{"$f":"'Hypothetical Res Bill Impact'!S22","v":15.5},{"$f":"'Hypothetical Res Bill Impact'!T22","v":28.166666666666668}]
[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":27.773930946059686},{"$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":28.054378946059682},{"$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":28.054378946059686},1.0097526365449028E-2,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q23","v":0},{"$f":"'Hypothetical Res Bill Impact'!R23","v":0},{"$f":"'Hypothetical Res Bill Impact'!S23","v":0},{"$f":"'Hypothetical Res Bill Impact'!T23","v":0}]
[null,"Total",null,{"$f":"D41*(1-'Hypothetical SAR and RAR'!$AA$16)+D42*'Hypothetical SAR and RAR'!$AA$16","v":34.928378136616693},{"$f":"E41*(1-'Hypothetical SAR and RAR'!$AA$16)+E42*'Hypothetical SAR and RAR'!$AA$16","v":35.275486314842432},{"$f":"F41*(1-'Hypothetical SAR and RAR'!$AA$16)+F42*'Hypothetical SAR and RAR'!$AA$16","v":35.275486314842432},9.9377124488311264E-3,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q24","v":0},{"$f":"'Hypothetical Res Bill Impact'!R24","v":0},{"$f":"'Hypothetical Res Bill Impact'!S24","v":0},{"$f":"'Hypothetical Res Bill Impact'!T24","v":0}]
[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":76.243717241033934},{"$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":76.984387241033929},{"$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":76.984387241033929},{"$f":"$F47/D47-1","v":9.7145053625660172E-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":48.512578385850397},{"$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":48.984201052517058},{"$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":48.984201052517058},9.7216574001810496E-3,0]
[null,"Total",null,{"$f":"D47*(1-'Hypothetical SAR and RAR'!$AA$16)+D48*'Hypothetical SAR and RAR'!$AA$16","v":71.904604468065557},{"$f":"E47*(1-'Hypothetical SAR and RAR'!$AA$16)+E48*'Hypothetical SAR and RAR'!$AA$16","v":72.603176423455977},{"$f":"F47*(1-'Hypothetical SAR and RAR'!$AA$16)+F48*'Hypothetical SAR and RAR'!$AA$16","v":72.603176423455977},9.7152603864287812E-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":43.968804259431721},{"$f":"((E60*$H$10)+(E66*$H$11))/12","v":44.387404259431712},44.387404259431712,{"$f":"$F54/D54-1","v":9.5203862613615353E-3},0]
[null,"Essential Use - CARE",null,{"$f":"((D61*$H$10)+(D67*$H$11))/12","v":34.446801220722172},34.78168122072217,34.78168122072217,9.7216574001810496E-3,0]
[null,"Total",null,{"$f":"((D62*$H$10)+(D68*$H$11))/12","v":42.478889069677969},42.884389336441266,42.884389336441266,9.545924473169709E-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":24.182842342687444},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":24.413072342687443},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":24.413072342687443},{"$f":"$F60/D60-1","v":9.5203862613617574E-3},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!I22","v":11},{"$f":"'Hypothetical Res Bill Impact'!J22","v":29}]
[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":18.945740671397196},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":19.129924671397195},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":19.129924671397195},9.7216574001810496E-3,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!I23","v":0},{"$f":"'Hypothetical Res Bill Impact'!J23","v":0}]
[null,"Total",null,{"$f":"D60*(1-'Hypothetical SAR and RAR'!$AA$16)+D61*'Hypothetical SAR and RAR'!$AA$16","v":23.363388988322882},{"$f":"E60*(1-'Hypothetical SAR and RAR'!$AA$16)+E61*'Hypothetical SAR and RAR'!$AA$16","v":23.586414135042691},{"$f":"F60*(1-'Hypothetical SAR and RAR'!$AA$16)+F61*'Hypothetical SAR and RAR'!$AA$16","v":23.586414135042691},9.545924473169487E-3,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!I24","v":0},{"$f":"'Hypothetical Res Bill Impact'!J24","v":0}]
[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":63.754766176175998},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":64.361736176175981},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":64.361736176175981},{"$f":"$F66/D66-1","v":9.5203862613615353E-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":49.947861770047155},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":50.433437770047149},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":50.433437770047149},9.7216574001810496E-3,0]
[null,"Total",null,{"$f":"D66*(1-'Hypothetical SAR and RAR'!$AA$16)+D67*'Hypothetical SAR and RAR'!$AA$16","v":61.594389151033056},{"$f":"E66*(1-'Hypothetical SAR and RAR'!$AA$16)+E67*'Hypothetical SAR and RAR'!$AA$16","v":62.182364537839824},{"$f":"F66*(1-'Hypothetical SAR and RAR'!$AA$16)+F67*'Hypothetical SAR and RAR'!$AA$16","v":62.182364537839824},9.545924473169487E-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":56.12182574274977},{"$f":"((E79*$H$10)+(E85*$H$11))/12","v":56.670529461139033},56.67052946113904,{"$f":"$F73/D73-1","v":9.7770111917672153E-3},0]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D80*$H$10)+(D86*$H$11))/12","v":35.955550405151847},36.309110042383658,36.309110042383658,9.8332422462694691E-3,0]
[null,"Total",null,{"$f":"((D81*$H$10)+(D87*$H$11))/12","v":52.966393022964006},53.484562395845806,53.484562395845813,9.7829839509204763E-3,0,null,{"$f":"'Res Bill Impact'!P27","v":"Typical Bundled"}]
[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,"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":35.826889407949366},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":36.181774319682191},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":36.181774319682198},{"$f":"$F79/D79-1","v":9.9055462976946895E-3},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q31","v":15.661739406613},{"$f":"'Hypothetical Res Bill Impact'!R31","v":34.069279171492305},{"$f":"'Hypothetical Res Bill Impact'!S31","v":14.458914681218566},{"$f":"'Hypothetical Res Bill Impact'!T31","v":26.812122049869362}]
[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":25.731508882424095},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":25.989685985284719},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":25.989685985284723},1.0033500329900136E-2,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q32","v":0},{"$f":"'Hypothetical Res Bill Impact'!R32","v":0},{"$f":"'Hypothetical Res Bill Impact'!S32","v":0},{"$f":"'Hypothetical Res Bill Impact'!T32","v":0}]
[null,"Total",null,{"$f":"D79*(1-'Hypothetical SAR and RAR'!$AA$16)+D80*'Hypothetical SAR and RAR'!$AA$16","v":34.247257398783077},{"$f":"E79*(1-'Hypothetical SAR and RAR'!$AA$16)+E80*'Hypothetical SAR and RAR'!$AA$16","v":34.587010364766591},{"$f":"F79*(1-'Hypothetical SAR and RAR'!$AA$16)+F80*'Hypothetical SAR and RAR'!$AA$16","v":34.587010364766599},9.9205890278266651E-3,0,null,0,{"$f":"'Hypothetical Res Bill Impact'!Q33","v":0},{"$f":"'Hypothetical Res Bill Impact'!R33","v":0},{"$f":"'Hypothetical Res Bill Impact'!S33","v":0},{"$f":"'Hypothetical Res Bill Impact'!T33","v":0}]
[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":76.416762077550175},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":77.159284602595875},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":77.159284602595875},{"$f":"$F85/D85-1","v":9.7167493735492716E-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":46.179591927879592},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":46.6285340994826},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":46.6285340994826},9.7216574001810496E-3,0]
[null,"Total",null,{"$f":"D85*(1-'Hypothetical SAR and RAR'!$AA$16)+D86*'Hypothetical SAR and RAR'!$AA$16","v":71.685528647144935},{"$f":"E85*(1-'Hypothetical SAR and RAR'!$AA$16)+E86*'Hypothetical SAR and RAR'!$AA$16","v":72.382114426925028},{"$f":"F85*(1-'Hypothetical SAR and RAR'!$AA$16)+F86*'Hypothetical SAR and RAR'!$AA$16","v":72.382114426925028},9.7172440927215664E-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],[17,22,17,23],[18,22,18,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","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% 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.588631244029723},{"$f":"'SAR and RAR'!H5","v":0.8281360554566396},{"$f":"'SAR and RAR'!I5","v":0.6930742196352998},{"$f":"'SAR and RAR'!J5","v":1},{"$f":"'SAR and RAR'!K5","v":0.41531057983403791},{"$f":"'SAR and RAR'!L5","v":0.74289826710724882},{"$f":"'SAR and RAR'!M5","v":0.52375194016439541},{"$f":"'SAR and RAR'!N5","v":0.47439185603624595},{"$f":"'SAR and RAR'!O5","v":0},{"$f":"'SAR and RAR'!P5","v":0.46},{"$f":"'SAR and RAR'!Q5","v":0.28236732831753186},{"$f":"'SAR and RAR'!R5","v":0.8281360554566396},{"$f":"'SAR and RAR'!S5","v":0.61658896708606825},{"$f":"'SAR and RAR'!T5","v":0}]
[null,"All Residential",{"$f":"'Hypothetical Summary'!D9","v":0}]
[null,"Local Transmission",{"$f":"'Hypothetical Summary'!D10","v":0},null,null,null,"Revenue Change ($000) - System"]
[null,"Seasonal Storage",{"$f":"'Hypothetical Summary'!D11","v":0},null,null,"w/Proposed",{"$f":"TRANSPOSE(RevRecoveryMechanisms)","v":"Core Procurement"},"Allocated Base Margin","Distribution","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% 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,null,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},null,{"$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,"-"]
[null,"46% 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.15647077444701882}]
[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","All Residential","Local Transmission","Seasonal Storage","GHG End User","Public Purpose Programs","-","46% 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"},{"$f":"'SAR and RAR'!D22","v":"TCAP D.20-02-045  SALES DETERMINANTS BUNDLED"}]
[null,"Residential",{"$f":"'SAR and RAR'!C23","v":313234.40934070927},{"$f":"'SAR and RAR'!D23","v":310981.19469103281}]
[null,"Total System",{"$f":"'SAR and RAR'!C24","v":1109315.3418530996},{"$f":"'SAR and RAR'!D24","v":473212.18655010499}]
[]
[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":310981.19469103281},223.42294193660797,{"$f":"(U19/C23*100)+(W19/D23*100)+G28","v":223.42294193660797},{"$f":"H28/G28-1","v":0},null,null,null,null,null,null,"Residential",{"$f":"'SAR and RAR'!Q28","v":313234.40934070927},223.06984231247591,{"$f":"U9/Q28*100+R28","v":223.06984231247591},{"$f":"S28/R28-1","v":0}]
[null,null,null,null,"Total System",{"$f":"'SAR and RAR'!F29","v":473212.18655010499},127.37535792459865,{"$f":"(U20/C24*100)+(W20/D24*100)+G29","v":127.37535792459865},{"$f":"H29/G29-1","v":0},null,null,null,null,null,null,"Total System",{"$f":"'SAR and RAR'!Q29","v":1109315.3418530996},95.950626077776192,{"$f":"U10/Q29*100+R29","v":95.950626077776192},{"$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],[70,2,70,3],[70,4,70,5],[70,6,70,7],[49,11,49,16],[59,11,59,16],[69,11,69,16],[39,1,39,8],[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":"SalesForecastYear","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":187959.32956315737},{"$f":"'Res Bill Impact'!F7","v":2.2183702129715859},{"$f":"F7*E7","v":416963.37795301789},{"$f":"(Y10/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*(Q7/F7),SUM(P9)*(Q9/F7)))","v":2.2183702129715859},{"$f":"E7*H7","v":416963.37795301789},null,null,null,null,null,"Baseline ",{"$f":"'Res Bill Impact'!P7","v":34568.659520669324},{"$f":"'Res Bill Impact'!Q7","v":1.7380840610361086},{"$f":"'Res Bill Impact'!R7","v":60083.236124259478},{"$f":"H7*(1+(Q7/F7-1))","v":1.7380840610361086},{"$f":"P7*S7","v":60083.236124259478},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:G12)+SUM(R7:R12))","v":698319.39549946727}]
[null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!E9","v":76615.611405786854},{"$f":"'Res Bill Impact'!F9","v":2.5235302129715862},{"$f":"F9*E9","v":193341.81016779359},{"$f":"F9/F$7*H$7","v":2.5235302129715866},{"$f":"E9*H9","v":193341.81016779362},null,null,null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!P9","v":14090.808851095719},{"$f":"'Res Bill Impact'!Q9","v":1.9822120610361087},{"$f":"'Res Bill Impact'!R9","v":27930.971254396289},{"$f":"H9*(1+(Q9/F9-1))","v":1.9822120610361089},{"$f":"P9*S9","v":27930.971254396289},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":698319.39549946727}]
[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":664014.40923910646},0,{"$f":"F12*12*E12/1000","v":0},0,{"$f":"(H12*12*E12)/1000","v":0},null,null,null,null,null,"Fixed Charge",210053,{"$f":"F12*(1-CAREDiscountPercent)","v":0},{"$f":"Q12*12*P12/1000","v":0},{"$f":"H12*(1-CAREDiscountPercent)","v":0},{"$f":"(S12*12*P12)/1000","v":0}]
[null,null,null,"Total Customers",874067.40923910646]
[]
[]
[]
[]
[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",2.197440212971586,2.2183702129715859,{"$f":"H7","v":2.2183702129715859},null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!I22","v":11},{"$f":"'Res Bill Impact'!J22","v":29},null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q22","v":15.833333333333334},{"$f":"'Res Bill Impact'!R22","v":34},{"$f":"'Res Bill Impact'!S22","v":15.5},{"$f":"'Res Bill Impact'!T22","v":28.166666666666668},{"$f":"SUM(Q22:R22)/SUM($Q$22:$R$25)","v":1},{"$f":"SUM(S22:T22)/SUM($S$22:$T$25)","v":1}]
[null,"Tier 2",2.496790212971586,2.5235302129715862,{"$f":"H9","v":2.5235302129715866},null,null,0,{"$f":"'Res Bill Impact'!I23","v":0},{"$f":"'Res Bill Impact'!J23","v":0},null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q23","v":0},{"$f":"'Res Bill Impact'!R23","v":0},{"$f":"'Res Bill Impact'!S23","v":0},{"$f":"'Res Bill Impact'!T23","v":0},{"$f":"SUM(Q23:R23)/SUM($Q$22:$R$25)","v":0},{"$f":"SUM(S23:T23)/SUM($S$22:$T$25)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"'Res Bill Impact'!I24","v":0},{"$f":"'Res Bill Impact'!J24","v":0},null,null,null,null,null,0,{"$f":"'Res Bill Impact'!Q24","v":0},{"$f":"'Res Bill Impact'!R24","v":0},{"$f":"'Res Bill Impact'!S24","v":0},{"$f":"'Res Bill Impact'!T24","v":0},{"$f":"SUM(Q24:R24)/SUM($Q$22:$R$25)","v":0},{"$f":"SUM(S24:T24)/SUM($S$22:$T$25)","v":0}]
["Winter","Tier 1",{"$f":"C22","v":2.197440212971586},2.2183702129715859,2.2183702129715859,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.496790212971586,2.5235302129715862,2.5235302129715866]
[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.7213400610361087,1.7380840610361086,{"$f":"S7","v":1.7380840610361086},null,null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.661739406613},{"$f":"'Res Bill Impact'!R31","v":34.069279171492305},{"$f":"'Res Bill Impact'!S31","v":14.458914681218566},{"$f":"'Res Bill Impact'!T31","v":26.812122049869362},{"$f":"SUM(Q31:R31)/SUM($Q$31:$R$34)","v":1},{"$f":"SUM(S31:T31)/SUM($S$31:$T$34)","v":1}]
[null,"Tier 2",1.9608200610361086,1.9822120610361087,{"$f":"S9","v":1.9822120610361089},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(Q32:R32)/SUM($Q$31:$R$34)","v":0},{"$f":"SUM(S32:T32)/SUM($S$31:$T$34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
["Winter","Tier 1",{"$f":"C31","v":1.7213400610361087},1.7380840610361086,1.7380840610361086,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"Tier 2",1.9608200610361086,1.9822120610361087,1.9822120610361089]
[]
[]
[]
[null,"Note: Bill inserts include CPUC fee in the calculations"]
[null,{"$f":"'Res Bill Impact'!C40","v":"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":"E30","v":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":"SDG&E"},{"$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":36.255495038716774},{"$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":76.243717241033934},{"$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":36.614968372050114},{"$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":76.984387241033929},{"$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":36.614968372050114},{"$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":76.984387241033929}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[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":36.255495038716774},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":76.243717241033934},36.614968372050114,76.984387241033929,36.614968372050114,76.984387241033929]
[]
[]
[null,null,{"$f":"'Res Bill Impact'!C50","v":"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":"Proposed"}]
[null,null,"Summer","Winter","Summer","Winter","Summer","Winter"]
[null,{"$f":"Zones","v":"SDG&E"},{"$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.773930946059686},{"$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":48.512578385850397},{"$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":28.054378946059682},{"$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":48.984201052517058},{"$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":28.054378946059686},{"$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":48.984201052517058}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[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":27.773930946059686},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":48.512578385850397},28.054378946059682,48.984201052517058,28.054378946059686,48.984201052517058]
[]
[]
[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":"SDG&E"},{"$f":"($C$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":24.182842342687444},{"$f":"($C$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":63.754766176175998},{"$f":"($D$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":24.413072342687443},{"$f":"($D$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":64.361736176175981},{"$f":"($E$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$H$12,0)","v":24.413072342687443},{"$f":"($E$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$H$12,0)","v":64.361736176175981}]
[null,0,{"$f":"($C$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($C$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($D$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($D$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($E$22*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$H$12,0)","v":0},{"$f":"($E$25*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$H$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($C$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($D$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($D$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($E$22*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$H$12,0)","v":0},{"$f":"($E$25*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$H$12,0)","v":0}]
[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":24.182842342687444},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":63.754766176175998},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":24.413072342687443},64.361736176175981,24.413072342687443,64.361736176175981]
[]
[]
[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":"SDG&E"},{"$f":"($C$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":18.945740671397196},{"$f":"($C$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":49.947861770047155},{"$f":"($D$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":19.129924671397195},{"$f":"($D$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":50.433437770047149},{"$f":"($E$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$S$12,0)","v":19.129924671397195},{"$f":"($E$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$S$12,0)","v":50.433437770047149}]
[null,0,{"$f":"($C$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($C$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($D$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($D$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($E$31*$I23)+('Hypothetical SAR and RAR'!$C$18*$I23)+IF(I23>0,$S$12,0)","v":0},{"$f":"($E$34*$J23)+('Hypothetical SAR and RAR'!$C$18*$J23)+IF(J23>0,$S$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($C$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($D$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($D$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($E$31*$I24)+('Hypothetical SAR and RAR'!$C$18*$I24)+IF(I24>0,$S$12,0)","v":0},{"$f":"($E$34*$J24)+('Hypothetical SAR and RAR'!$C$18*$J24)+IF(J24>0,$S$12,0)","v":0}]
[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":18.945740671397196},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":49.947861770047155},19.129924671397195,50.433437770047149,19.129924671397195,50.433437770047149]
[]
[]
[null,null,"Typical 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":"SDG&E"},{"$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":35.826889407949366},{"$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":76.416762077550175},{"$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":36.181774319682191},{"$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":77.159284602595875},{"$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":36.181774319682198},{"$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":77.159284602595875}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[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":35.826889407949366},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":76.416762077550175},36.181774319682191,77.159284602595875,36.181774319682198,77.159284602595875]
[]
[]
[null,null,"Typical 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":"SDG&E"},{"$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":25.731508882424095},{"$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":46.179591927879592},{"$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":25.989685985284719},{"$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":46.6285340994826},{"$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":25.989685985284723},{"$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":46.6285340994826}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[null,0,{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0},{"$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":0}]
[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":25.731508882424095},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":46.179591927879592},25.989685985284719,46.6285340994826,25.989685985284723,46.6285340994826]

{"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,"SDG&E",null,"Core Procurement",null,2024,0.54802333333333342]
[null,null,"Care Discount %",0.2,null,null,null,"Allocated Base Margin",null,{"$f":"J5+1","v":2025},{"$f":"K5*(1+L6)","v":0.60282566666666682},0.1]
[null,null,"Proposed Residential Fixed Charge",0,null,null,null,"Distribution",null,{"$f":"J6+1","v":2026},0.66310823333333357,0.1]
[null,null,null,null,null,null,null,"All Residential",null,2027,0.72941905666666695,0.1]
[null,null,null,null,null,"All",null,"Local Transmission",null,2028,0.80236096233333376,0.1]
[null,null,null,null,null,null,null,"Seasonal Storage"]
[null,null,null,null,null,null,null,"GHG End User",null,{"$f":"J5-1","v":2023},0.79470166666666675]
[null,null,"Regulatory Fee",1E-3,null,null,null,"Public Purpose Programs"]
[null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,"Other Revenues",null,"46% 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"]