{"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 (2025-2029)"},2025,null,null,"Current Effective Rates",null,{"$f":"CurrentEffectiveRateDate","v":"2025-06-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.166666666666666},"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":30.333333333333332},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A99","v":"Natural Gas Leak Abatement"},null,"Y","2026-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":14.624743281218564},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A100","v":"GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct"},null,"Y","2025-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":26.166666666666668},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A101","v":"2026 Cost of Capital"},null,"Y",2026,null,"Average monthly usage is for all customers (Non-CARE and CARE) based on seasonal usage in",null,null,null,null,2024]
[null,{"$f":"'Incremental Rev Req'!A102","v":"2024 GRC Track 3 (PSEP and WMPMA)"},null,"Y",2026,null,"Summer season",null,6,"months"]
[null,{"$f":"'Incremental Rev Req'!A103","v":"TIMPBA"},null,"Y",2026,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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% Change over Authorized",null,"Customer Group",null,{"$f":"$D$26","v":"2025-01-01"},{"$f":"$E$26","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"$H$26","v":"% Change over 1/1/2025"},{"$f":"$I$26","v":"% Change over 6/1/2025"},"% Change over Authorized"]
[null,"Residential",null,217.6490613572463,{"$f":"'SAR and RAR'!G28","v":262.2217111825251},{"$f":"'SAR and RAR'!H28","v":262.2217111825251},{"$f":"'SAR and RAR'!I28","v":265.92438318077535},{"$f":"$G27/D27-1","v":0.22180349192634741},1.4120386834303389E-2,1.4120386834303389E-2,null,"Total Residential (RAR)",null,217.42583844438877,{"$f":"'SAR and RAR'!R28","v":261.97983849907013},{"$f":"'SAR and RAR'!S28","v":261.97983849907013},{"$f":"'SAR and RAR'!T28","v":265.68251049732032},{"$f":"$Q27/N27-1","v":0.22194543389227506},{"$f":"$Q27/O27-1","v":1.413342347053681E-2},1.413342347053681E-2]
[null,"System",null,109.72605249873097,{"$f":"'SAR and RAR'!G29","v":142.59080380037514},{"$f":"'SAR and RAR'!H29","v":142.59080380037514},{"$f":"'SAR and RAR'!I29","v":144.08800238746892},0.31316126941808431,1.0499965966878522E-2,1.0499965966878522E-2,null,"Total System (SAR)",null,89.859930590907737,{"$f":"'SAR and RAR'!R29","v":126.29575317010247},{"$f":"'SAR and RAR'!S29","v":126.29575317010247},{"$f":"'SAR and RAR'!T29","v":127.79295175719625},0.42213499294786549,1.1854702549477292E-2,1.1854702549477292E-2]
[]
[]
[null,"Basic Bundled Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% Change over Authorized"]
[null,"Non-CARE",null,{"$f":"((D39*$I$10)+(D45*$I$11))/12","v":49.966698835653894},{"$f":"((E39*$I$10)+(E45*$I$11))/12","v":52.001517269355723},52.001517269355723,52.735672895574076,{"$f":"$G33/D33-1","v":5.5416389804490596E-2},1.4117965489652828E-2,1.4117965489652828E-2]
[null,"CARE",null,{"$f":"((D40*$I$10)+(D46*$I$11))/12","v":35.417229628250048},36.821331347384948,36.856043368258774,37.376224783792402,5.5311925187389255E-2,1.5069890634110905E-2,1.4113870290852315E-2]
[null,"Total",null,{"$f":"((D41*$I$10)+(D47*$I$11))/12","v":47.328473453043422},49.24892531969823,49.255219579182587,49.950575701047519,5.5402214707085173E-2,1.4247019133809324E-2,1.4117409846221118E-2,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":"2024 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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":34.033727569200749},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,4,FALSE)))","v":35.424886713802316},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,6,FALSE)))","v":35.424886713802316},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,8,FALSE)))","v":35.925025746817688},{"$f":"$G39/D39-1","v":5.5571290972208809E-2},{"$f":"$G39/E39-1","v":1.4118295904684164E-2},{"$f":"$G39/F39-1","v":1.4118295904684164E-2},null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q22","v":15.166666666666666},{"$f":"'Res Bill Impact'!R22","v":30.333333333333332},{"$f":"'Res Bill Impact'!S22","v":14.624743281218564},{"$f":"'Res Bill Impact'!T22","v":26.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":25.971986290312149},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,4,FALSE)))","v":27.031281977260189},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,6,FALSE)))","v":27.031281977260189},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,8,FALSE)))","v":27.412809788171447},{"$f":"$G40/D40-1","v":5.5476061081887407E-2},{"$f":"$G40/E40-1","v":1.4114306943792565E-2},1.4114306943792565E-2,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":32.571908573138721},{"$f":"E39*(1-'SAR and RAR'!$AC$15)+E40*'SAR and RAR'!$AC$15","v":33.902891598250179},{"$f":"F39*(1-'SAR and RAR'!$AC$15)+F40*'SAR and RAR'!$AC$15","v":33.902891598250179},{"$f":"G39*(1-'SAR and RAR'!$AC$15)+G40*'SAR and RAR'!$AC$15","v":34.381523101859713},{"$f":"$G41/D41-1","v":5.5557522048718333E-2},1.4117719198743384E-2,1.4117719198743384E-2,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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":65.899670102107038},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,5,FALSE)))","v":68.578147824909124},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,7,FALSE)))","v":68.578147824909124},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,9,FALSE)))","v":69.546320044330457},{"$f":"$G45/D45-1","v":5.5336391465589774E-2},{"$f":"$G45/E45-1","v":1.4117794809699991E-2},1.4117794809699991E-2]
[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":44.862472966187951},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,5,FALSE)))","v":46.611380717509711},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,7,FALSE)))","v":46.680804759257356},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,9,FALSE)))","v":47.339639779413361},5.5216902891028985E-2,1.5624061134710709E-2,1.4113617439839743E-2]
[null,"Total",null,{"$f":"D45*(1-'SAR and RAR'!$AC$15)+D46*'SAR and RAR'!$AC$15","v":62.08503833294813},{"$f":"E45*(1-'SAR and RAR'!$AC$15)+E46*'SAR and RAR'!$AC$15","v":64.594959041146282},{"$f":"F45*(1-'SAR and RAR'!$AC$15)+F46*'SAR and RAR'!$AC$15","v":64.607547560114995},{"$f":"G45*(1-'SAR and RAR'!$AC$15)+G46*'SAR and RAR'!$AC$15","v":65.51962830023534},5.5320735228804541E-2,1.4314882659807182E-2,1.4117247513097286E-2]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D58*$I$10)+(D64*$I$11))/12","v":43.178082637333439},{"$f":"((E58*$I$10)+(E64*$I$11))/12","v":44.93107070368319},44.93107070368319,45.565393881749451,{"$f":"$G52/D52-1","v":5.528988548351732E-2},1.4117695575286193E-2,1.4117695575286193E-2]
[null,"Essential Use - CARE",null,{"$f":"((D59*$I$10)+(D65*$I$11))/12","v":34.289788254411178},35.641125346998962,35.679595994336829,36.183164162608939,5.5216902891028763E-2,1.5208240770534953E-2,1.4113617439839743E-2]
[null,"Total",null,{"$f":"D52*(1-'SAR and RAR'!$AC$15)+D53*'SAR and RAR'!$AC$15","v":41.566386463757098},{"$f":"E52*(1-'SAR and RAR'!$AC$15)+E53*'SAR and RAR'!$AC$15","v":43.246543983588374},{"$f":"F52*(1-'SAR and RAR'!$AC$15)+F53*'SAR and RAR'!$AC$15","v":43.253519787093325},{"$f":"G52*(1-'SAR and RAR'!$AC$15)+G53*'SAR and RAR'!$AC$15","v":43.864133427662033},{"$f":"$G54/D54-1","v":5.5278968401749395E-2},{"$f":"$G54/E54-1","v":1.4280665856398311E-2},1.4117085582267652E-2]
[]
[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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":23.747945450533393},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":24.712088887025754},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":24.712088887025754},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,8,FALSE)))","v":25.060966634962195},{"$f":"$G58/D58-1","v":5.5289885483517098E-2},{"$f":"$G58/E58-1","v":1.4117695575286193E-2},{"$f":"$G58/F58-1","v":1.4117695575286193E-2},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":18.859383539926146},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":19.623777796885257},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":19.623777796885257},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,8,FALSE)))","v":19.900740289434918},{"$f":"$G59/D59-1","v":5.5216902891028985E-2},1.4113617439839743E-2,1.4113617439839743E-2,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":22.861512555066408},{"$f":"E58*(1-'SAR and RAR'!$AC$15)+E59*'SAR and RAR'!$AC$15","v":23.789435882901326},{"$f":"F58*(1-'SAR and RAR'!$AC$15)+F59*'SAR and RAR'!$AC$15","v":23.789435882901326},{"$f":"G58*(1-'SAR and RAR'!$AC$15)+G59*'SAR and RAR'!$AC$15","v":24.125273385214118},{"$f":"$G60/D60-1","v":5.5278968401749173E-2},{"$f":"$G60/E60-1","v":1.4117085582267874E-2},1.4117085582267874E-2,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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":62.608219824133485},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":65.150052520340623},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":65.150052520340623},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,9,FALSE)))","v":66.069821128536702},{"$f":"$G64/D64-1","v":5.528988548351732E-2},{"$f":"$G64/E64-1","v":1.4117695575286193E-2},{"$f":"$G64/F64-1","v":1.4117695575286193E-2}]
[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":49.7201929688962},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":51.658472897112674},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":51.735414191788408},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,9,FALSE)))","v":52.465588035782957},{"$f":"$G65/D65-1","v":5.5216902891028763E-2},1.5624061134710709E-2,1.4113617439839521E-2]
[null,"Total",null,{"$f":"D64*(1-'SAR and RAR'!$AC$15)+D65*'SAR and RAR'!$AC$15","v":60.271260372447792},{"$f":"E64*(1-'SAR and RAR'!$AC$15)+E65*'SAR and RAR'!$AC$15","v":62.703652084275411},{"$f":"F64*(1-'SAR and RAR'!$AC$15)+F65*'SAR and RAR'!$AC$15","v":62.717603691285319},{"$f":"G64*(1-'SAR and RAR'!$AC$15)+G65*'SAR and RAR'!$AC$15","v":63.602993470109951},5.5278968401749617E-2,1.4342727352240958E-2,1.4117085582267874E-2]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"((D77*$I$10)+(D83*$I$11))/12","v":53.944769148457745},{"$f":"((E77*$I$10)+(E83*$I$11))/12","v":56.144737737192237},56.144737737192237,56.937394313625838,{"$f":"$G71/D71-1","v":5.5475724753447198E-2},1.4118092066685684E-2,1.4118092066685684E-2]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D78*$I$10)+(D84*$I$11))/12","v":35.875014717570586},37.296962619455051,37.332383056273237,37.859287347934917,{"$f":"$G72/D72-1","v":5.531071265017462E-2},{"$f":"$G72/E72-1","v":1.5076957719515338E-2},{"$f":"$G72/F72-1","v":1.4113867064619035E-2}]
[null,"Total",null,{"$f":"((D79*$I$10)+(D85*$I$11))/12","v":50.66821767310595},52.727109367901299,52.733532082994522,53.478000343196271,5.5454539337027375E-2,1.4241079859995009E-2,1.4117549703100973E-2,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":"2020-2024 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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":34.995817185197083},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":36.426917617092073},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":36.426917617092073},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,8,FALSE)))","v":36.941205006547207},{"$f":"$G77/D77-1","v":5.5589152585155288E-2},1.4118333998532462E-2,1.4118333998532462E-2,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.556399473279669},{"$f":"'Res Bill Impact'!R31","v":33.166552904825643},{"$f":"'Res Bill Impact'!S31","v":14.624743281218564},{"$f":"'Res Bill Impact'!T31","v":26.700685816536037}]
[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":25.971986290312149},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":27.031281977260189},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":27.031281977260189},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,8,FALSE)))","v":27.412809788171447},{"$f":"$G78/D78-1","v":5.5476061081887407E-2},{"$f":"$G78/E78-1","v":1.4114306943792565E-2},{"$f":"$G78/F78-1","v":1.4114306943792565E-2},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":33.359544454150978},{"$f":"E77*(1-'SAR and RAR'!$AC$15)+E78*'SAR and RAR'!$AC$15","v":34.723226294926853},{"$f":"F77*(1-'SAR and RAR'!$AC$15)+F78*'SAR and RAR'!$AC$15","v":34.723226294926853},{"$f":"G77*(1-'SAR and RAR'!$AC$15)+G78*'SAR and RAR'!$AC$15","v":35.213440662548251},5.5573187186211515E-2,1.4117765539920946E-2,1.4117765539920946E-2,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":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"$D$2&\" Authorized\"","v":"2025 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2025 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2025"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 6/1/2025"},"% 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":72.893721111718406},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":75.862557857292401},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":75.862557857292401},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,9,FALSE)))","v":76.933583620704454},{"$f":"$G83/D83-1","v":5.5421268764623388E-2},1.4117975898292112E-2,1.4117975898292112E-2]
[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":45.77804314482902},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":47.562643261649917},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":47.633484135286274},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,9,FALSE)))","v":48.305764907698375},{"$f":"$G84/D84-1","v":5.5216902891028985E-2},{"$f":"$G84/E84-1","v":1.5624061134710709E-2},{"$f":"$G84/F84-1","v":1.4113617439839743E-2}]
[null,"Total",null,{"$f":"D83*(1-'SAR and RAR'!$AC$15)+D84*'SAR and RAR'!$AC$15","v":67.976890892060936},{"$f":"E83*(1-'SAR and RAR'!$AC$15)+E84*'SAR and RAR'!$AC$15","v":70.730992440875752},{"$f":"F83*(1-'SAR and RAR'!$AC$15)+F84*'SAR and RAR'!$AC$15","v":70.743837871062212},{"$f":"G83*(1-'SAR and RAR'!$AC$15)+G84*'SAR and RAR'!$AC$15","v":71.742560023844291},5.5396313105328332E-2,1.4301617269319555E-2,1.4117443763827842E-2]

{"sheet":"Authorized Rev Req","index":2,"n_rows":99,"n_cols":15,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Period 2025"]
["Reporting Date: Quarter Ended June 30"]
[]
[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","2025-01-01","2025-02-01","2025-02-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-G","AL-3383-G","AL-3392-G-A","AL-3392-G-A"]
["Filing Description","Authority for Revenue Requirement as of 2/1/2025","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) ","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.24-12-074",412393.92784195661,412992.27437904326,412992.27437904326,412992.27437904326,412992.27437904326,417772.13947090023,417344.74138154538,417344.74138154538,413132.58535711508,475212.73630577826,475212.73630577826,"Allocated Base Margin","N"]
["SCG Transport excl Core Storge & Load Balance $000","D.24-12-074",10101.5487258045,18927.301506775031,18927.301506775031,19163.89443334132,16390.059073287463,59110.52142599332,59221.346535796984,59221.22817428541,21557.266166845875,24405.134866023502,24405.134866023502,"ECPT","N"]
["SCG Core Seasonal Storage","D.24-12-074",14374.700920168953,18907.657128629489,18907.657128629489,18907.657128629489,17001.410111315246,17001.410111315254,17001.410111315254,17001.410111315254,17001.410111315254,22813.158346716304,22813.158346716304,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.24-07-009,",9102.0837826634306,11569.318977706102,11569.318977706102,11569.318977706102,11389.102717475975,11389.102717475971,11389.102717475971,11389.102717475971,11389.102717475971,13289.971130037364,13289.971130037364,"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,2698.4483999999993,1416.8473200000001,1416.8473200000001,"Local Transmission","N"]
["LUAF","D.24-07-009, AL 3383, AL 3392-G-A",3180.2303217247427,4359.515855476232,4359.515855476232,4359.515855476232,4359.515855476232,3607.5249270959521,3722.5793902382834,3722.5793902382834,3027.4870088540747,9159.2938555307755,9159.2938555307755,"46% Res (LUAF, Other)","N"]
["Company Use Gas: Other","D.24-07-009, AL 3383, AL 3392-G-A",234.78660051758473,321.84961592802711,321.84961592802711,321.84961592802711,321.84961592802711,266.3324439520315,274.82656027154178,274.82656027154178,223.51003261125493,298.36010016290237,298.36010016290237,"ECPT","N"]
["SDG&E NGLAPBA"," AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A",983.22148920005588,734.78317488009657,734.78317488009657,143.91573455627505,143.91573455627505,666.38432929558826,666.38432929558815,666.38432929558815,666.38432929558826,666.99386717611071,666.99386717611071,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct"," AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A",1620.0351328756483,5725.6373585236443,5725.6373585236443,6792.859113609511,6792.859113609511,4950.4356988439195,4967.0727197205524,4967.0727197205524,4958.6529346372954,4963.1885857130337,4963.1885857130337,"EPAM","N"]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.24-07-009, AL 3383, AL 3392-G-A",52.108015617715203,47.131684850968078,47.131684850968078,47.131684850968078,47.131684850968078,48.348788764696145,48.348788764696145,48.348788764696145,43.89855417499308,39.313580777554797,39.313580777554797,"Local Transmission","N"]
["CFCA","D.24-07-009, AL 3383, AL 3392-G-A",37541.479619999998,55563.797728400001,55563.797728400001,55563.797728400001,55563.797728400001,25794.189268400005,25794.189268400005,32720.484075331624,75579.000117400021,75648.131790397572,75648.131790397572,"CFCA","Y"]
["CFCA -NGV only","D.24-07-009, AL 3383, AL 3392-G-A",-210.72329159999998,3011.7432064000004,3011.7432064000004,3011.7432064000004,3011.7432064000004,2805.0950652000001,2805.0950652000001,2805.0950652000001,25.575265000000002,25.598658546541497,25.598658546541497,"Non-Residential","Y"]
["CFCA - C&I shortfall only","D.24-07-009, AL 3383, AL 3392-G-A",5444.0260091999999,40.920424000000004,40.920424000000004,40.920424000000004,40.920424000000004,37.851392200000006,37.851392200000006,37.851392200000006,39.897413400000005,39.933907332604733,39.933907332604733,"Non-Residential","Y"]
["Hazardous Substance Cleanup Cost Acct HSCCA","D.24-07-009, AL 3383, AL 3392-G-A",290.51172240000005,122.76127200000001,122.76127200000001,122.76127200000001,122.76127200000001,72.633752600000008,72.633752600000008,72.633752600000008,420.45735660000003,420.84194650514223,420.84194650514223,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.24-07-009, AL 3383, AL 3392-G-A",10311.120288,11907.843384,11907.843384,11907.843384,11907.843384,15931.344073800004,15931.344073800003,15931.344073800003,23565.049171000006,23586.603984783338,23586.603984783338,"EPAM","Y"]
["PBOPBA","D.24-07-009, AL 3383, AL 3392-G-A",-623.51692177259997,-531.23917447400004,-531.23917447400004,-531.23917447400004,-531.23917447400004,-354.98467820000002,-354.98467820000008,-354.98467820000008,-417.38832480000008,-225.64053933387851,-225.64053933387851,"EPAM","Y"]
["Pension BA","D.24-07-009, AL 3383, AL 3392-G-A",-575.93130622920012,-298.79172895260001,-298.79172895260001,-298.79172895260001,-298.79172895260001,51.15053000000001,51.15053000000001,51.15053000000001,-5049.5803216000013,-625.53812884639603,-625.53812884639603,"EPAM","Y"]
["Safety Enhancement Balancing Account - Local Transmission","D.24-07-009, AL 3383, AL 3392-G-A",3036.4630647777644,3084.2385558959263,3084.2385558959263,3084.2385558959263,3084.2385558959263,3321.4404759571516,3321.4404759571516,3321.4404759571516,3360.9883347663554,-884.13753996041953,-884.13753996041953,"Local Transmission","Y"]
["Safety Enhancement Balancing Account - Distribution","D.24-07-009, AL 3383, AL 3392-G-A",38688.933410192403,39079.214628479465,39079.214628479465,39079.214628479465,39079.214628479465,48957.417309766293,49368.178378244505,49368.178378244505,48598.556032131484,23688.773971364353,23688.773971364353,"Distribution","Y"]
["Rewards & Penalties Bal Acct  RPBA","D.24-07-009, AL 3383, AL 3392-G-A",-127.86607500000001,310.99522240000005,310.99522240000005,310.99522240000005,310.99522240000005,-119.69224020000003,-119.69224020000001,-119.69224020000001,-51.15053000000001,-51.197317093082994,-51.197317093082994,"EPAM","Y"]
["SGPMA - Rev Req for NEXT Year","D.24-07-009, AL 3383, AL 3392-G-A",1545.2359431600003,1545.3598123600002,1545.3598123600002,1545.3598123600002,1545.3598123600002,1696.1515748000002,1696.1515748000002,1696.1515748000002,0,0,0,"ECPT","Y"]
["Integrated Transmission  Margin ITBA","D.24-07-009, AL 3383, AL 3392-G-A",24.550286399999997,704.35051671497718,704.35051671497718,704.35051671497718,704.35051671497718,-289.51199980000001,-289.51199980000001,-289.51199980000001,1889.5005782000003,1891.228893418486,1891.228893418486,"ECPT","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.24-07-009, AL 3383, AL 3392-G-A",3038.0979420000003,4285.3914033999999,4285.3914033999999,4285.3914033999999,4285.3914033999999,4093.0654106000011,4093.0654106000002,4093.0654106000002,4609.6857636000004,-348.51410035727741,-348.51410035727741,"EPAM","Y"]
["Residential Uncollectible Balancing Account","D.24-07-009, AL 3383, AL 3392-G-A",5629.1760858000007,10487.904671200002,10487.904671200002,10487.904671200002,10487.904671200002,26260.682102000006,26260.682102000006,26260.682102000006,13910.898138800001,13923.622356634853,13923.622356634853,"EPAM","Y"]
["NFCA -Margin Only","D.24-07-009, AL 3383, AL 3392-G-A",-7128.7894133999998,3046.5255668000004,3046.5255668000004,3046.5255668000004,3046.5255668000004,4377.4623573999997,4377.4623573999997,4377.4623573999997,57.288593600000013,57.340995144252958,57.340995144252958,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.24-07-009, AL 3383, AL 3392-G-A",1705.2219761999997,794.87923620000004,794.87923620000004,794.87923620000004,794.87923620000004,6588.1882640000003,6588.1882640000003,6784.0932542683813,4107.3875589999998,4111.1445625745646,4111.1445625745646,"Non-Residential","Y"]
["NFCA -Nonmargin SCG","D.24-07-009, AL 3383, AL 3392-G-A",-100.24700279999999,132.991378,132.991378,132.991378,132.991378,-1020.9645788,-1020.9645788,-1020.9645788,446.03262160000003,446.44060505168369,446.44060505168369,"Non-Residential","Y"]
["Minimum Bil/Customer Charge Revenue ","D.24-07-009, AL 3383, AL 3392-G-A",1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1428.2529999999999,1428.2529999999999,"All Residential","N"]
["Borrego Revenue","D.24-07-009, AL 3383, AL 3392-G-A",64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,59.438824546069831,59.438824546069831,"All Residential","N"]
["Employee Discount (Schd GR)","D.24-07-009, AL 3383, AL 3392-G-A",-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-606.06691000001092,-606.06691000001092,"All Residential","N"]
["SDFFD","D.24-07-009, AL 3383, AL 3392-G-A",1986.9012193223789,2243.52579553028,2243.52579553028,2243.52579553028,2235.2764847903877,2098.3340670427324,2112.1396483676353,2130.6707838359775,2213.6270380394139,2406.2721718929802,2406.2721718929802,"All Residential","N"]
["Customer Information System  Account - CISBA","D.24-07-009, AL 3383, AL 3392-G-A",{"$f":"0","v":0},28619.672934858001,28619.672934858001,28619.672934858001,28619.672934858001,0,0,0,0,0,0,"EPAM","Y"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ","AL 3039-G, D.24-07-009, AL 3383, AL 3392-G-A",{"$f":"0","v":0},10830.843399584999,10830.843399584999,10830.843399584999,10830.843399584999,0,0,0,0,0,0,"EPAM","Y"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)","D. 21-10-012,  D.24-07-009, AL 3383, AL 3392-G-A",0,0,0,0,0,113.55417660000001,113.55417660000001,113.55417660000001,211.76319420000004,211.95689276536362,211.95689276536362,"ECPT","Y"]
["Gain/Loss on Sale Memo Acct GLOSMA"," D.24-07-009, AL 3383, AL 3392-G-A",0,0,0,0,0,-1.0230106000000003,-1.0230106000000001,-1.0230106000000001,0,0,0,"EPAM","Y"]
["Transmission Integrity Management Program Memorandum Account  (TIMPBA)","AL 3312-G,D.24-07-009, AL 3383, AL 3392-G-A",0,0,0,0,0,0,7280.4081272496533,7280.4081272496533,7280.4081272496533,7567.7042719846359,7567.7042719846359,"Local Transmission","Y"]
["Cost of Capital Adjustment (Subtracted from Base Margin)","D.24-12-074,AL 3392-G-A",0,0,0,0,0,0,0,0,0,-5707.0000000000009,-5707.0000000000009,"EPAM","N"]
["General Rate Case Revenue Requirement Memorandum Account  (GRCMA)",null,null,0,0,0,0,0,0,0,0,18532.625999999997,18532.625999999997,"EPAM","Y"]
["  GRCRRMA Sub allocation for AB32 Admin Fees","D.24-12-074,AL 3392-G-A",0,0,0,0,0,0,0,0,0,341.24933333333342,341.24933333333342,"ECPT","Y"]
["  GRCRRMA PSEP Local Transmission","D.24-12-074,AL 3392-G-A",0,0,0,0,0,0,0,0,0,-679.73003999999969,-679.73003999999969,"Local Transmission","Y"]
["  GRCRRMA PSEP Distribution","D.24-12-074,AL 3392-G-A",0,0,0,0,0,0,0,0,0,10178.705333333333,10178.705333333333,"Distribution","Y"]
["Pipeline Safety Enhancement Plan (PSEP) -Distribution (subtracted from Base Margin and allocated here)","D.19-09-051",0,0,0,0,0,0,0,0,0,15437.625766000001,15437.625766000001,"Distribution"]
["Distribution Integrity Management Program Memorandum Account  (DIMPBA)",null,0,0,0,0,0,0,0,0,0,-14786.157520606683,-14786.157520606683,"Distribution"]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C9:C51)","v":556607.70051950624},{"$f":"SUM(D9:D51)","v":652780.64954693615},{"$f":"SUM(E9:E52)","v":652780.64954693615},653493.59678826446,648625.04883992637,659436.83485872927,666965.42225656938,674106.03482772619,{"$f":"SUM(K9:K44)","v":657010.5449728386},{"$f":"SUM(L9:L52)","v":728354.50912732701},{"$f":"SUM(M9:M52)","v":728354.50912732701}]
[]
[]
[]
["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,87782.323173211742,87862.617155020853,87862.617155020853,"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,1040.4561679269118,1041.4078671483583,1041.4078671483583,"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,528.89648020000004,1085.1171215926709,1085.1171215926709,"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,-6342.6657200000009,-6348.4673195422911,-6348.4673195422911,"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,8589.1969976,8597.0534862704972,8597.0534862704972,"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,-1088.4832784000002,-1089.4789077408063,-1089.4789077408063,"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,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,759.0738652,0,0,"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,3926.3146828000008,1117.0323729399925,1117.0323729399925,"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,-5765.0642823541202,-8113.3052522579455,-8113.3052522579455,"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,150.38255820000001,150.520112253664,150.520112253664,"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,-27.621286200000007,-27.646551230264819,-27.646551230264819,"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,56.265583000000021,56.317048802391298,56.317048802391298,"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,19135.75612917971,19135.75612917971,19135.75612917971,"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,698.36900000000003,698.36900000000003,698.36900000000003,"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,0,0,0,"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,14340.989,14340.989,14340.989,"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,50762.256999999998,50762.256999999998,50762.256999999998,"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,1276.3142700000001,1276.3142700000001,1276.3142700000001,"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,52.328879999999998,52.328879999999998,52.328879999999998,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C58:C86)","v":119391.85263010046},{"$f":"SUM(D58:D86)","v":101254.1992437171},{"$f":"SUM(E58:E86)","v":101223.16612994601},{"$f":"SUM(F58:F86)","v":101249.97122731223},{"$f":"SUM(G58:G86)","v":101453.14850871242},{"$f":"SUM(H58:H81)","v":134784.50684883934},135039.14998786891,134602.13502616444,175875.0892203642,170597.18141243685,170597.18141243685]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,259331.31984714375,{"$f":"TotalCoreVolume*SetUp!K5","v":136165.98498056631},{"$f":"K91","v":136165.98498056631},{"$f":"K91","v":136165.98498056631},"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,{"$f":"SUM(C91:C96)","v":372042.57581360283},{"$f":"SUM(D91:D96)","v":475248.57632622559},475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,259331.31984714375,136165.98498056631,136165.98498056631,136165.98498056631]
[]
["Total Authorized Revenue",null,{"$f":"C53+C87+C97","v":1048042.1289632095},1229283.4251168789,1229252.3920031078,1229992.1443418022,1225326.7736748643,1053552.6615547123,1061335.8920915821,1068039.4897010345,969051.61917376914,1035117.6755203302,1035117.6755203302]

{"sheet":"Incremental Rev Req","index":3,"n_rows":136,"n_cols":19,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2025"}]
["Reporting Date: Quarter Ended June 30"]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!M99","v":1035117.6755203302}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!M5","v":"2025-02-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":2025},2026,2027,2028,2029]
["Safety Affordability Reliability Proceedings",null,null,{"$f":"B6","v":"2025-02-01"},null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2025},2026,2027,2028,2029,null,null,null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUMIF($E$10:$E$90,N9,$F$10:$F$90)","v":136165.98498056631},{"$f":"SUMIF($E$10:$E$90,N9,$G$10:$G$90)","v":136165.98498056631},{"$f":"SUMIF($E$10:$E$90,N9,$H$10:$H$90)","v":136165.98498056631},{"$f":"SUMIF($E$10:$E$90,N9,$I$10:$I$90)","v":136165.98498056631},{"$f":"SUMIF($E$10:$E$90,N9,$J$10:$J$90)","v":136165.98498056631}]
[{"$f":"'Authorized Rev Req'!A9","v":"Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B9","v":"D.24-12-074"},{"$f":"F10","v":475212.73630577826},{"$f":"'Authorized Rev Req'!N9","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!M9","v":475212.73630577826},489469.11839495163,504153.19194680016,{"$f":"H10","v":504153.19194680016},{"$f":"I10","v":504153.19194680016},"Existing",null,null,"Allocated Base Margin",475212.73630577826,489469.11839495163,504153.19194680016,504153.19194680016,504153.19194680016]
[{"$f":"'Authorized Rev Req'!A10","v":"SCG Transport excl Core Storge & Load Balance $000"},null,{"$f":"'Authorized Rev Req'!B10","v":"D.24-12-074"},24405.134866023502,{"$f":"'Authorized Rev Req'!N10","v":"ECPT"},{"$f":"'Authorized Rev Req'!M10","v":24405.134866023502},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Distribution",34518.947550090998,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A11","v":"SCG Core Seasonal Storage"},null,{"$f":"'Authorized Rev Req'!B11","v":"D.24-12-074"},22813.158346716304,{"$f":"'Authorized Rev Req'!N11","v":"Seasonal Storage"},{"$f":"'Authorized Rev Req'!M11","v":22813.158346716304},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"All Residential",3287.897086439039,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A12","v":"SCG Load Balancing Allocated to ALL SDGE $000"},null,{"$f":"'Authorized Rev Req'!B12","v":"D.24-07-009,"},13289.971130037364,{"$f":"'Authorized Rev Req'!N12","v":"ECPT"},{"$f":"'Authorized Rev Req'!M12","v":13289.971130037364},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Local Transmission",7459.997592801772,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A13","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B13","v":"D.19-09-051"},1416.8473200000001,{"$f":"'Authorized Rev Req'!N13","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!M13","v":1416.8473200000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Seasonal Storage",22813.158346716304,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A14","v":"LUAF"},null,{"$f":"'Authorized Rev Req'!B14","v":"D.24-07-009, AL 3383, AL 3392-G-A"},9159.2938555307755,{"$f":"'Authorized Rev Req'!N14","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M14","v":9159.2938555307755},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"GHG End User",96459.670641291348,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A15","v":"Company Use Gas: Other"},null,{"$f":"'Authorized Rev Req'!B15","v":"D.24-07-009, AL 3383, AL 3392-G-A"},298.36010016290237,{"$f":"'Authorized Rev Req'!N15","v":"ECPT"},{"$f":"'Authorized Rev Req'!M15","v":298.36010016290237},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Public Purpose Programs",86266.014279179712,59828.009129179714,60625.957129179711,0,26310.181]
[{"$f":"'Authorized Rev Req'!A16","v":"SDG&E NGLAPBA"},null,{"$f":"'Authorized Rev Req'!B16","v":" AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A"},666.99386717611071,{"$f":"'Authorized Rev Req'!N16","v":"EPAM"},{"$f":"'Authorized Rev Req'!M16","v":666.99386717611071},{"$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'!A17","v":"SDG&ENERBA - NGLAP Subacct"},null,{"$f":"'Authorized Rev Req'!B17","v":" AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A"},4963.1885857130337,{"$f":"'Authorized Rev Req'!N17","v":"EPAM"},{"$f":"'Authorized Rev Req'!M17","v":4963.1885857130337},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"46% Res (LUAF, Other)",10346.860048784663,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A18","v":"SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B18","v":"D.24-07-009, AL 3383, AL 3392-G-A"},39.313580777554797,{"$f":"'Authorized Rev Req'!N18","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!M18","v":39.313580777554797},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"ECPT",34482.629291473539,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"CFCA"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.24-07-009, AL 3383, AL 3392-G-A"},75648.131790397572,{"$f":"'Authorized Rev Req'!N19","v":"CFCA"},{"$f":"'Authorized Rev Req'!M19","v":75648.131790397572},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"EPAM",55888.494130419072,18646.06288530086,33104.185232387521,36790.392063089501,40179.654454651602]
[{"$f":"'Authorized Rev Req'!A20","v":"CFCA -NGV only"},null,{"$f":"'Authorized Rev Req'!B20","v":"D.24-07-009, AL 3383, AL 3392-G-A"},25.598658546541497,{"$f":"'Authorized Rev Req'!N20","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M20","v":25.598658546541497},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"CFCA",75648.131790397572,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"CFCA - C&I shortfall only"},null,{"$f":"'Authorized Rev Req'!B21","v":"D.24-07-009, AL 3383, AL 3392-G-A"},39.933907332604733,{"$f":"'Authorized Rev Req'!N21","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M21","v":39.933907332604733},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Non-Residential",-3432.8465236082984,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A22","v":"Hazardous Substance Cleanup Cost Acct HSCCA"},null,{"$f":"'Authorized Rev Req'!B22","v":"D.24-07-009, AL 3383, AL 3392-G-A"},420.84194650514223,{"$f":"'Authorized Rev Req'!N22","v":"ECPT"},{"$f":"'Authorized Rev Req'!M22","v":420.84194650514223},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Total",{"$f":"SUM(O9:O22)","v":1035117.6755203303},{"$f":"SUM(P9:P22)","v":704109.17538999859},{"$f":"SUM(Q9:Q22)","v":734049.31928893377},{"$f":"SUM(R9:R22)","v":677109.56899045606},{"$f":"SUM(S9:S22)","v":706809.01238201815}]
[{"$f":"'Authorized Rev Req'!A23","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B23","v":"D.24-07-009, AL 3383, AL 3392-G-A"},23586.603984783338,{"$f":"'Authorized Rev Req'!N23","v":"EPAM"},{"$f":"'Authorized Rev Req'!M23","v":23586.603984783338},18646.06288530086,33104.185232387521,36790.392063089501,40179.654454651602,"Existing",null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":2.5000000000000001E-3}]
[{"$f":"'Authorized Rev Req'!A24","v":"PBOPBA"},null,{"$f":"'Authorized Rev Req'!B24","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-225.64053933387851,{"$f":"'Authorized Rev Req'!N24","v":"EPAM"},{"$f":"'Authorized Rev Req'!M24","v":-225.64053933387851},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Check",{"$f":"O23-F91","v":0},{"$f":"P23-G91","v":0},{"$f":"Q23-H91","v":0},{"$f":"R23-I91","v":0},{"$f":"S23-J91","v":0}]
[{"$f":"'Authorized Rev Req'!A25","v":"Pension BA"},null,{"$f":"'Authorized Rev Req'!B25","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-625.53812884639603,{"$f":"'Authorized Rev Req'!N25","v":"EPAM"},{"$f":"'Authorized Rev Req'!M25","v":-625.53812884639603},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A26","v":"Safety Enhancement Balancing Account - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B26","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-884.13753996041953,{"$f":"'Authorized Rev Req'!N26","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!M26","v":-884.13753996041953},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A27","v":"Safety Enhancement Balancing Account - Distribution"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.24-07-009, AL 3383, AL 3392-G-A"},23688.773971364353,{"$f":"'Authorized Rev Req'!N27","v":"Distribution"},{"$f":"'Authorized Rev Req'!M27","v":23688.773971364353},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A28","v":"Rewards & Penalties Bal Acct  RPBA"},null,{"$f":"'Authorized Rev Req'!B28","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-51.197317093082994,{"$f":"'Authorized Rev Req'!N28","v":"EPAM"},{"$f":"'Authorized Rev Req'!M28","v":-51.197317093082994},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A29","v":"SGPMA - Rev Req for NEXT Year"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!N29","v":"ECPT"},{"$f":"'Authorized Rev Req'!M29","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A30","v":"Integrated Transmission  Margin ITBA"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1891.228893418486,{"$f":"'Authorized Rev Req'!N30","v":"ECPT"},{"$f":"'Authorized Rev Req'!M30","v":1891.228893418486},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A31","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-348.51410035727741,{"$f":"'Authorized Rev Req'!N31","v":"EPAM"},{"$f":"'Authorized Rev Req'!M31","v":-348.51410035727741},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A32","v":"Residential Uncollectible Balancing Account"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.24-07-009, AL 3383, AL 3392-G-A"},13923.622356634853,{"$f":"'Authorized Rev Req'!N32","v":"EPAM"},{"$f":"'Authorized Rev Req'!M32","v":13923.622356634853},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A33","v":"NFCA -Margin Only"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.24-07-009, AL 3383, AL 3392-G-A"},57.340995144252958,{"$f":"'Authorized Rev Req'!N33","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M33","v":57.340995144252958},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A34","v":"NFCA -Nonmargin Other"},null,{"$f":"'Authorized Rev Req'!B34","v":"D.24-07-009, AL 3383, AL 3392-G-A"},4111.1445625745646,{"$f":"'Authorized Rev Req'!N34","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M34","v":4111.1445625745646},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A35","v":"NFCA -Nonmargin SCG"},null,{"$f":"'Authorized Rev Req'!B35","v":"D.24-07-009, AL 3383, AL 3392-G-A"},446.44060505168369,{"$f":"'Authorized Rev Req'!N35","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M35","v":446.44060505168369},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A36","v":"Minimum Bil/Customer Charge Revenue "},null,{"$f":"'Authorized Rev Req'!B36","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1428.2529999999999,{"$f":"'Authorized Rev Req'!N36","v":"All Residential"},{"$f":"'Authorized Rev Req'!M36","v":1428.2529999999999},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A37","v":"Borrego Revenue"},null,{"$f":"'Authorized Rev Req'!B37","v":"D.24-07-009, AL 3383, AL 3392-G-A"},59.438824546069831,{"$f":"'Authorized Rev Req'!N37","v":"All Residential"},{"$f":"'Authorized Rev Req'!M37","v":59.438824546069831},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A38","v":"Employee Discount (Schd GR)"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-606.06691000001092,{"$f":"'Authorized Rev Req'!N38","v":"All Residential"},{"$f":"'Authorized Rev Req'!M38","v":-606.06691000001092},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A39","v":"SDFFD"},null,{"$f":"'Authorized Rev Req'!B39","v":"D.24-07-009, AL 3383, AL 3392-G-A"},2406.2721718929802,{"$f":"'Authorized Rev Req'!N39","v":"All Residential"},{"$f":"'Authorized Rev Req'!M39","v":2406.2721718929802},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A40","v":"Customer Information System  Account - CISBA"},null,{"$f":"'Authorized Rev Req'!B40","v":"D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!N40","v":"EPAM"},{"$f":"'Authorized Rev Req'!M40","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A41","v":"Transition, Stabilization and OCM Balancing Account - TSOBA-G "},null,{"$f":"'Authorized Rev Req'!B41","v":"AL 3039-G, D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!N41","v":"EPAM"},{"$f":"'Authorized Rev Req'!M41","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A42","v":"Percentage of Income Payment Plan Balancing Account (PIPPBA)"},null,{"$f":"'Authorized Rev Req'!B42","v":"D. 21-10-012,  D.24-07-009, AL 3383, AL 3392-G-A"},211.95689276536362,"ECPT",{"$f":"'Authorized Rev Req'!M42","v":211.95689276536362},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.24-07-009, AL 3383, AL 3392-G-A"},0,"EPAM",{"$f":"'Authorized Rev Req'!M43","v":0},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,D.24-07-009, AL 3383, AL 3392-G-A"},{"$f":"F45","v":7567.7042719846359},"Local Transmission",{"$f":"'Authorized Rev Req'!M44","v":7567.7042719846359},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A45","v":"Cost of Capital Adjustment (Subtracted from Base Margin)"},null,{"$f":"'Authorized Rev Req'!B45","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F46","v":-5707.0000000000009},"EPAM",{"$f":"'Authorized Rev Req'!M45","v":-5707.0000000000009},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A46","v":"General Rate Case Revenue Requirement Memorandum Account  (GRCMA)"},null,"D.24-12-074,AL 3392-G-A",{"$f":"F47","v":18532.625999999997},"EPAM",{"$f":"'Authorized Rev Req'!M46","v":18532.625999999997}]
[{"$f":"'Authorized Rev Req'!A47","v":"  GRCRRMA Sub allocation for AB32 Admin Fees"},null,{"$f":"'Authorized Rev Req'!B47","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F48","v":341.24933333333342},"ECPT",{"$f":"'Authorized Rev Req'!M47","v":341.24933333333342},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A48","v":"  GRCRRMA PSEP Local Transmission"},null,{"$f":"'Authorized Rev Req'!B48","v":"D.24-12-074,AL 3392-G-A"},-679.73003999999969,"Local Transmission",{"$f":"'Authorized Rev Req'!M48","v":-679.73003999999969},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A49","v":"  GRCRRMA PSEP Distribution"},null,{"$f":"'Authorized Rev Req'!B49","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F50","v":10178.705333333333},"Distribution",{"$f":"'Authorized Rev Req'!M49","v":10178.705333333333},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A50","v":"Pipeline Safety Enhancement Plan (PSEP) -Distribution (subtracted from Base Margin and allocated here)"},null,"D.24-12-074,AL 3392-G-A",{"$f":"F51","v":15437.625766000001},"Distribution",{"$f":"'Authorized Rev Req'!M50","v":15437.625766000001},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A51","v":"Distribution Integrity Management Program Memorandum Account  (DIMPBA)"},null,"D.24-12-074,AL 3392-G-A",-14786.157520606683,"Distribution",{"$f":"'Authorized Rev Req'!M51","v":-14786.157520606683},null,null,null,null,"New"]
[]
[{"$f":"'Authorized Rev Req'!A57","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A58","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B58","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},{"$f":"F55","v":87862.617155020853},{"$f":"'Authorized Rev Req'!N58","v":"GHG End User"},{"$f":"'Authorized Rev Req'!M58","v":87862.617155020853},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A59","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B59","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},1041.4078671483583,{"$f":"'Authorized Rev Req'!N59","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M59","v":1041.4078671483583},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A60","v":"AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B60","v":"D.19-09-051"},1085.1171215926709,{"$f":"'Authorized Rev Req'!N60","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M60","v":1085.1171215926709},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A61","v":"Green House Gas Balancing Account (GHGBA) - Company Gas Compressor"},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"},-6348.4673195422911,{"$f":"'Authorized Rev Req'!N61","v":"ECPT"},{"$f":"'Authorized Rev Req'!M61","v":-6348.4673195422911},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A62","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B62","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},8597.0534862704972,{"$f":"'Authorized Rev Req'!N62","v":"GHG End User"},{"$f":"'Authorized Rev Req'!M62","v":8597.0534862704972},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A63","v":"Green House Gas Balancing Account (GHGBA) - LUAF"},null,{"$f":"'Authorized Rev Req'!B63","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-1089.4789077408063,{"$f":"'Authorized Rev Req'!N63","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M63","v":-1089.4789077408063},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A64","v":"FERC Settlement Proceeds MA"},null,{"$f":"'Authorized Rev Req'!B64","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},0,{"$f":"'Authorized Rev Req'!N64","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M64","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A65","v":"New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount"},null,{"$f":"'Authorized Rev Req'!B65","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3071-G-B, 3247-G-B"},0,{"$f":"'Authorized Rev Req'!N65","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M65","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A66","v":"New Environmental Regulation Balancing Account (NERBA) - EPAM"},null,{"$f":"'Authorized Rev Req'!B66","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B"},1117.0323729399925,{"$f":"'Authorized Rev Req'!N66","v":"EPAM"},{"$f":"'Authorized Rev Req'!M66","v":1117.0323729399925},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A67","v":"  TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B67","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-8113.3052522579455,{"$f":"'Authorized Rev Req'!N67","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!M67","v":-8113.3052522579455},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A68","v":"CSI Thermal Program memoradum Account"},null,{"$f":"'Authorized Rev Req'!B68","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},150.520112253664,{"$f":"'Authorized Rev Req'!N68","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!M68","v":150.520112253664},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A69","v":"Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  "},null,{"$f":"'Authorized Rev Req'!B69","v":"D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B"},-27.646551230264819,"ECPT",{"$f":"'Authorized Rev Req'!M69","v":-27.646551230264819},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A70","v":"Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)"},null,{"$f":"'Authorized Rev Req'!B70","v":"D.22-02-025, 3247-G-B"},56.317048802391298,"EPAM",{"$f":"'Authorized Rev Req'!M70","v":56.317048802391298},0,0,0,{"$f":"0","v":0},"Existing"]
[]
[]
["PPPS Programs"]
[{"$f":"'Authorized Rev Req'!A75","v":"California Alternate Rates for Energy (CARE) - Funding"},null,{"$f":"'Authorized Rev Req'!B75","v":"AL 3137-G, D.21-06-015, 3245-G"},{"$f":"F71","v":19135.75612917971},{"$f":"'Authorized Rev Req'!N75","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M75","v":19135.75612917971},{"$f":"F71","v":19135.75612917971},{"$f":"G71","v":19135.75612917971},null,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A76","v":"California Alternate Rates for Energy (CARE) - Admin Expenses"},null,{"$f":"'Authorized Rev Req'!B76","v":"AL 3137-G, D.21-06-015, 3245-G"},698.36900000000003,{"$f":"'Authorized Rev Req'!N76","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M76","v":698.36900000000003},{"$f":"813953/1000","v":813.95299999999997},{"$f":"814181/1000","v":814.18100000000004},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A77","v":"California Alternate Rates for Energy (CARE) - Amortization"},null,{"$f":"'Authorized Rev Req'!B77","v":"AL 3137-G, AL 3245-G, AL 3247-G-B"},0,{"$f":"'Authorized Rev Req'!N77","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M77","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A78","v":"Energy Savings Assistance (ESA/LIEE/DAP)"},null,{"$f":"'Authorized Rev Req'!B78","v":"AL 3137-G, D.21-06-015, AL 3247-G-B"},14340.989,{"$f":"'Authorized Rev Req'!N78","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M78","v":14340.989},{"$f":"14340989/1000","v":14340.989},{"$f":"15138709/1000","v":15138.709000000001},0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A79","v":"Energy Efficiency"},null,{"$f":"'Authorized Rev Req'!B79","v":"D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G"},50762.256999999998,{"$f":"'Authorized Rev Req'!N79","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M79","v":50762.256999999998},{"$f":"25537311/1000","v":25537.311000000002},{"$f":"G75","v":25537.311000000002},null,{"$f":"26310181/1000","v":26310.181},"Existing"]
[{"$f":"'Authorized Rev Req'!A80","v":"RD&D "},null,{"$f":"'Authorized Rev Req'!B80","v":"AL 3137-G, AL 3245-G"},1276.3142700000001,{"$f":"'Authorized Rev Req'!N80","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M80","v":1276.3142700000001},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A81","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B81","v":"AL 3137-G, AL 3245-G"},52.328879999999998,{"$f":"'Authorized Rev Req'!N81","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!M81","v":52.328879999999998},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B91","v":"D.97-07-061"},{"$f":"F87","v":136165.98498056631},{"$f":"'Authorized Rev Req'!N91","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!M91","v":136165.98498056631},{"$f":"F87","v":136165.98498056631},136165.98498056631,136165.98498056631,136165.98498056631,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D10:D90)","v":1035117.67552033},null,{"$f":"SUM(F10:F90)","v":1035117.67552033},{"$f":"SUM(G10:G90)","v":704109.17538999836},{"$f":"SUM(H10:H90)","v":734049.31928893377},{"$f":"SUM(I10:I90)","v":677109.56899045594},{"$f":"SUM(J10:J90)","v":706809.01238201803}]
[]
["CPUC Fee",null,null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":2.5000000000000001E-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":2025},2026,2027,2028,2029,null,"Include in Impact",null,"Authorized + Pending"]
["Natural Gas Leak Abatement","3285-G-A","Advice Letter",{"$f":"SUM(F99:J99)","v":16829.379207089063},"EPAM",null,8319.0781734158809,8510.3010336731804,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A99,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2025},2026,2027,2028,2029]
["GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct","A-22-05-015","Application",{"$f":"SUM(F100:J100)","v":17295.516846515166},"EPAM",12271.012147000001,3236.694386624707,1787.8103128904581,null,null,"Existing",{"$f":"IFERROR(VLOOKUP(A100,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUM(O9,SUMIFS(F$99:F$126,$E$99:$E$126,$N100,$L$99:$L$126,\"y\"))","v":136165.98498056631},{"$f":"SUM(P9,SUMIFS(G$99:G$126,$E$99:$E$126,$N100,$L$99:$L$126,\"y\"))","v":136165.98498056631},{"$f":"SUM(Q9,SUMIFS(H$99:H$126,$E$99:$E$126,$N100,$L$99:$L$126,\"y\"))","v":136165.98498056631},{"$f":"SUM(R9,SUMIFS(I$99:I$126,$E$99:$E$126,$N100,$L$99:$L$126,\"y\"))","v":136165.98498056631},{"$f":"SUM(S9,SUMIFS(J$99:J$126,$E$99:$E$126,$N100,$L$99:$L$126,\"y\"))","v":136165.98498056631}]
["2026 Cost of Capital","A-25-03-013","Application",{"$f":"SUM(F101:J101)","v":23293},"EPAM",null,23293,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A101,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Allocated Base Margin",475212.73630577826,489469.11839495163,504153.19194680016,504153.19194680016,504153.19194680016]
["2024 GRC Track 3 (PSEP and WMPMA)","A.25-05-015/016","Application",{"$f":"SUM(F102:J102)","v":50051},"EPAM",null,50051,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A102,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Distribution",34518.947550090998,0,0,0,0]
["TIMPBA","A.25-02-012","Application",{"$f":"SUM(F103:J103)","v":7400},"Local Transmission",null,7400,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A103,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"All Residential",3287.897086439039,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Transmission",7459.997592801772,7400,0,0,0]
["Public Policy Proceedings",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A105,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Seasonal Storage",22813.158346716304,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A106,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"GHG End User",96459.670641291348,0,0,0,0]
[null,null,null,0,null,0,0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A107,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Public Purpose Programs",86266.014279179712,59828.009129179714,60625.957129179711,0,26310.181]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A108,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(A109,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"46% Res (LUAF, Other)",10346.860048784663,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A110,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"ECPT",34482.629291473539,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A111,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"EPAM",68159.506277419074,103545.83544534145,43402.296578951158,36790.392063089501,40179.654454651602]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A112,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"CFCA",75648.131790397572,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A113,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Non-Residential",-3432.8465236082984,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A114,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Total",{"$f":"SUM(O100:O113)","v":1047388.6876673303},{"$f":"SUM(P100:P113)","v":796408.94795003918},{"$f":"SUM(Q100:Q113)","v":744347.43063549744},{"$f":"SUM(R100:R113)","v":677109.56899045606},{"$f":"SUM(S100:S113)","v":706809.01238201815}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A115,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Incremental Revenues",{"$f":"O114-O23","v":12271.012146999943},{"$f":"P114-P23","v":92299.772560040583},{"$f":"Q114-Q23","v":10298.111346563674},{"$f":"R114-R23","v":0},{"$f":"S114-S23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A116,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"CPUC Fee",{"$f":"RegulatoryFee","v":2.5000000000000001E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A117,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"Check Figure",{"$f":"ROUND(O115,6)-ROUND(F127,6)","v":0},{"$f":"ROUND(P115,6)-SUM(G99:G126)","v":-4.058529157191515E-8},{"$f":"ROUND(Q115,6)-SUM(H99:H126)","v":4.363610059954226E-7},{"$f":"ROUND(R115,6)-SUM(I99:I126)","v":0},{"$f":"ROUND(S115,6)-SUM(J99:J126)","v":0}]
[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,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A119,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A120,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A121,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A122,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A123,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A124,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A125,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
[null,null,null,{"$f":"SUM(F126:J126)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A126,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"}]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D99:D126)","v":114868.89605360423},null,{"$f":"SUM(F99:F126)","v":12271.012147000001},{"$f":"SUM(G99:G126)","v":92299.772560040583},{"$f":"SUM(H99:H126)","v":10298.111346563639},{"$f":"SUM(I99:I126)","v":0},{"$f":"SUM(J99:J126)","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":2025},2026,2027,2028,2029]
[]
[]
[]
[]
["Public Policy Proceedings"]

{"sheet":"SAR and RAR","index":4,"n_rows":33,"n_cols":30,"rows_kept":33,"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$9:$S$22,MATCH(B3,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":136165.98498056631},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B3,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":136165.98498056631},null,null,"Allocation",null,null,null,null,null,null,null,null,"Other Revenues and Balancing Accounts"]
[null,"Allocated Base Margin",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B4,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":475212.73630577826},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B4,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":475212.73630577826},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$9:$S$22,MATCH(B5,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":34518.947550090998},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B5,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":34518.947550090998},null,"Residential",0.57246929564900972,0.81652373633254627,0.71351095116714947,1,0.51543343712031298,0.7405203174456334,0.49735087986604948,0.45465574087968463,null,0.43914119669235535,0.33016648110968039,0.81652373633254627,0.60198759162917603,0,{"$f":"RegulatoryFee","v":2.5000000000000001E-3}]
[null,"All Residential",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B6,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":3287.897086439039},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B6,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":3287.897086439039}]
[null,"Local Transmission",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B7,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":7459.997592801772},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B7,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":7459.997592801772},null,null,"Revenue Change ($000) - System"]
[null,"Seasonal Storage",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B8,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":22813.158346716304},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B8,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":22813.158346716304},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$9:$S$22,MATCH(B9,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":96459.670641291348},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B9,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":96459.670641291348},null,"Residential",{"$f":"G5*G10","v":77950.845513178429},{"$f":"H5*H10","v":388022.4790012071},{"$f":"I5*I10","v":24629.647099754373},3287.897086439039,3845.1322001670783,16893.607260847857,47974.30206503559,39221.338634837906,{"$f":"O5*O10","v":0},4543.7325038316194,{"$f":"Q5*Q10","v":11385.00837257541},{"$f":"R5*R10","v":45634.282045369364},{"$f":"S5*S10","v":45539.236667747944},{"$f":"T5*T10","v":0},{"$f":"SUM(G9:T9)","v":708927.50845099171},"Check","CPUC Fee"]
[null,"Public Purpose Programs",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B10,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":86266.014279179712},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B10,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":86266.014279179712},null,"Total System",{"$f":"C3","v":136165.98498056631},{"$f":"C4","v":475212.73630577826},{"$f":"C5","v":34518.947550090998},{"$f":"C6","v":3287.897086439039},{"$f":"C7","v":7459.997592801772},{"$f":"C8","v":22813.158346716304},{"$f":"C9","v":96459.670641291348},{"$f":"C10","v":86266.014279179712},{"$f":"C11","v":0},{"$f":"C12","v":10346.860048784663},{"$f":"C13","v":34482.629291473539},{"$f":"C14","v":55888.494130419072},{"$f":"C15","v":75648.131790397572},{"$f":"C16","v":-3432.8465236082984},{"$f":"SUM(G10:T10)","v":1035117.6755203303},{"$f":"U10-C17","v":0},{"$f":"RegulatoryFee","v":2.5000000000000001E-3}]
[null,"-",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B11,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":0},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B11,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":0},null,"w/Pending"]
[null,"46% Res (LUAF, Other)",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B12,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":10346.860048784663},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B12,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":10346.860048784663},null,"Residential",{"$f":"G5*G13","v":77950.845513178429},{"$f":"H5*H13","v":388022.4790012071},24629.647099754373,3287.897086439039,3845.1322001670783,16893.607260847857,47974.30206503559,39221.338634837906,{"$f":"O5*O13","v":0},4543.7325038316194,{"$f":"Q5*Q13","v":11385.00837257541},{"$f":"R5*R13","v":55653.854732219865},{"$f":"S5*S13","v":45539.236667747944},{"$f":"T5*T13","v":0},{"$f":"SUM(G12:T12)","v":718947.08113784215},"Check","CPUC Fee"]
[null,"ECPT",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B13,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":34482.629291473539},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B13,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":34482.629291473539},null,"Total System",{"$f":"D3","v":136165.98498056631},{"$f":"D4","v":475212.73630577826},{"$f":"D5","v":34518.947550090998},{"$f":"D6","v":3287.897086439039},{"$f":"D7","v":7459.997592801772},{"$f":"D8","v":22813.158346716304},{"$f":"D9","v":96459.670641291348},{"$f":"D10","v":86266.014279179712},{"$f":"D11","v":0},{"$f":"D12","v":10346.860048784663},{"$f":"D13","v":34482.629291473539},{"$f":"D14","v":68159.506277419074},{"$f":"D15","v":75648.131790397572},{"$f":"D16","v":-3432.8465236082984},{"$f":"SUM(G13:T13)","v":1047388.6876673303},{"$f":"U13-D17","v":0},{"$f":"RegulatoryFee","v":2.5000000000000001E-3}]
[null,"EPAM",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B14,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":55888.494130419072},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B14,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":68159.506277419074},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorized","w/Pending"]
[null,"CFCA",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B15,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":75648.131790397572},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B15,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":75648.131790397572},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.18132794708881522,{"$f":"AC15","v":0.18132794708881522}]
[null,"Non-Residential",{"$f":"INDEX('Incremental Rev Req'!$N$9:$S$22,MATCH(B16,'Incremental Rev Req'!$N$9:$N$22,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$8:$S$8,0))","v":-3432.8465236082984},{"$f":"INDEX('Incremental Rev Req'!$N$100:$S$113,MATCH(B16,'Incremental Rev Req'!$N$100:$N$113,0),MATCH(Summary!$D$2,'Incremental Rev Req'!$N$99:$S$99,0))","v":-3432.8465236082984},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":1035117.6755203303},{"$f":"SUM(D3:D16)","v":1047388.6876673303},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":2.5000000000000001E-3},{"$f":"C18","v":2.5000000000000001E-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":630976.66293781332},null,{"$f":"SUMPRODUCT(H12:T12,H19:T19)","v":640996.23562466376},null,{"$f":"SUMPRODUCT(G9,G19)","v":77950.845513178429},{"$f":"SUMPRODUCT(G12,G19)","v":77950.845513178429}]
[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":898951.69053976389},null,{"$f":"SUMPRODUCT(H13:T13,H20:T20)","v":911222.70268676383},null,{"$f":"SUMPRODUCT(G10,G20)","v":136165.98498056631},{"$f":"SUMPRODUCT(G13,G20)","v":136165.98498056631}]
[]
[null,null,"CAP D.24-07-009  SALES DETERMINANTS SYSTEM NET","CAP D.24-07-009  SALES DETERMINANTS BUNDLED"]
[null,"Residential",270603.84207905678,268350.62742938031]
[null,"Total System",819598.16505165747,413767.70037365775]
[]
[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,"CAP D.24-07-009  SALES DETERMINANTS BUNDLED",{"$f":"CONCATENATE(TEXT(CurrentEffectiveRateDate,\"mm/dd/yyyy\"),\" Avg Rates\"&\"(sales adj.)\")","v":"06/01/2025 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":"CAP D.24-07-009  SALES DETERMINANTS BUNDLED"},{"$f":"G27","v":"06/01/2025 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":268350.62742938031},262.2217111825251,{"$f":"(U19/C23*100)+(Y19/D23*100)","v":262.2217111825251},{"$f":"(W19/C23*100)+(Z19/D23*100)","v":265.92438318077535},{"$f":"H28/G28-1","v":0},{"$f":"I28/G28-1","v":1.4120386834303389E-2},null,null,null,null,"Residential",{"$f":"C23","v":270603.84207905678},261.97983849907013,{"$f":"U9/Q28*100","v":261.97983849907013},{"$f":"U12/Q28*100","v":265.68251049732032},{"$f":"S28/R28-1","v":0},{"$f":"T28/R28-1","v":1.413342347053681E-2}]
[null,2021,23945.842837510012,null,"Total System",{"$f":"D24","v":413767.70037365775},142.59080380037514,{"$f":"(U20/C24*100)+(Y20/D24*100)","v":142.59080380037514},{"$f":"(W20/C24*100)+(Z20/D24*100)","v":144.08800238746892},{"$f":"H29/G29-1","v":0},{"$f":"I29/G29-1","v":1.0499965966878522E-2},null,null,null,null,"Total System",{"$f":"C24","v":819598.16505165747},126.29575317010247,{"$f":"U10/Q29*100","v":126.29575317010247},{"$f":"U13/Q29*100","v":127.79295175719625},{"$f":"S29/R29-1","v":0},{"$f":"T29/R29-1","v":1.1854702549477292E-2}]
[null,2022,25613.07213654686,null,null,null,null,"cents/therm"]
[null,2023,22795.559340745884]
[null,2024,21383.37754112266]
[null,2025,19135.75612917971]

{"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":"2025-06-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},"Proposed","Proposed","Proposed","Proposed",null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-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.4901739191413812,{"$f":"F7*E7","v":468051.42033747409},{"$f":"((Y10-I12-T12)/SUM(E7,F9/F7*E9,P7*((Q7/F7)),P9*((Q9/F7))))","v":2.2440535351841593},{"$f":"E7*H7","v":421790.79797704774},{"$f":"((Y13-K12-V12)/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*((Q7/F7)),SUM(P9)*(Q9/F7)))","v":2.2757696940874723},{"$f":"E7*J7","v":427752.14594083303},null,null,null,{"$f":"D7","v":"Baseline"},34568.659520669324,1.9768666233571082,{"$f":"Q7*P7","v":68337.629220607108},{"$f":"H7*(1+(Q7/F7-1))","v":1.7814797997168417},{"$f":"P7*S7","v":61583.368639361681},{"$f":"J7*(1+(Q7/F7-1))","v":1.806658208130447},{"$f":"P7*U7","v":62453.752467083956},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":786680.33735731093}]
[null,null,null,"non-Baseline",76615.611405786854,2.8502839191413814,{"$f":"F9*E9","v":218376.24514509927},{"$f":"F9/F$7*H$7","v":2.5685714784263749},{"$f":"E9*H9","v":196792.67425910258},{"$f":"F9/F$7*J$7","v":2.6048741868453176},199574.02846030588,null,null,null,{"$f":"D9","v":"non-Baseline"},14090.808851095719,2.2649546233571081,{"$f":"Q9*P9","v":31915.04265413051},{"$f":"H9*(1+(Q9/F9-1))","v":2.0410941543106138},{"$f":"P9*S9","v":28760.667575479729},{"$f":"J9*(1+(Q9/F9-1))","v":2.0699418023367229},{"$f":"P9*U9","v":29167.154269619317},null,"Change (Authorized)",{"$f":"Y10-Y8","v":-77752.828906319221}]
[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":708927.50845099171}]
[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":688839.64874337753},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",185227.76049572896,{"$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":-67733.256219468778}]
[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":718947.08113784215}]
[]
[]
[]
[]
[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":2025},{"$f":"Summary!D2","v":2025},null,"Essential Usage",null,null,null,null,null,null,null,"2024 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"]
[null,"Rates",{"$f":"BOYEffectiveRateDate","v":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},"Authorized","w/Pending",null,"Climate Zone","Summer 2024","Winter 2024",null,null,null,null,null,null,"Non-CARE",null,"CARE"]
["Summer","Tier 1",2.156404131866672,2.2440535351841593,{"$f":"H7","v":2.2440535351841593},{"$f":"J7","v":2.2757696940874723},null,{"$f":"Zones","v":"SDG&E"},11,29,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15.166666666666666,30.333333333333332,14.624743281218564,26.166666666666668]
[null,"Tier 2",2.4660877084801656,2.5685714784263749,{"$f":"H9","v":2.5685714784263749},{"$f":"J9","v":2.6048741868453176},null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
["Winter","Tier 1",{"$f":"C22","v":2.156404131866672},{"$f":"D22","v":2.2440535351841593},{"$f":"E22","v":2.2440535351841593},2.2757696940874723,null,0,null,null,null,null,null,null,null,0]
[null,"Tier 2",{"$f":"C23","v":2.4660877084801656},{"$f":"D23","v":2.5685714784263749},{"$f":"E23","v":2.5685714784263749},2.6048741868453176]
[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":2025},{"$f":"Summary!D2","v":2025},null,null,null,null,null,null,null,null,null,"2020-2024 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"]
[null,"Rates",{"$f":"BOYEffectiveRateDate","v":"2025-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2025-06-01"},"Authorized","w/Pending",null,null,null,null,null,null,null,null,null,null,"Non-CARE",null,"CARE"]
["Summer","Tier 1",1.7119894127205586,1.7814797997168417,{"$f":"S7","v":1.7814797997168417},{"$f":"U7","v":1.806658208130447},null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15.556399473279669,33.166552904825643,14.624743281218564,26.700685816536037]
[null,"Tier 2",1.9597362740113535,2.0410941543106138,{"$f":"S9","v":2.0410941543106138},{"$f":"U9","v":2.0699418023367229},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Winter","Tier 1",{"$f":"C31","v":1.7119894127205586},1.778826651624575,{"$f":"E31","v":1.7814797997168417},1.806658208130447,null,null,null,null,null,null,null,null,null,0]
[null,"Tier 2",{"$f":"C32","v":1.9597362740113535},2.0263044255832194,{"$f":"E32","v":2.0410941543106138},2.0699418023367229]
[]
[]
[]
[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":"2025-01-01"},null,{"$f":"D30","v":"2025-06-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$93*$Q22)+IF(Q22>0,$F$12,0)","v":34.033727569200749},{"$f":"IF($R22>$J22,C$25*$J22+C$26*($R22-$J22),$R22*C$25)+('Incremental Rev Req'!$F$93*$R22)+IF(R22>0,$F$12,0)","v":65.899670102107038},{"$f":"IF($Q22>$I22,D$22*$I22+D$23*($Q22-$I22),$Q22*D$22)+('Incremental Rev Req'!$F$93*$Q22)+IF(Q22>0,$F$12,0)","v":35.424886713802316},{"$f":"IF($R22>$J22,D$25*$J22+D$26*($R22-$J22),$R22*D$25)+('Incremental Rev Req'!$F$93*$R22)+IF(R22>0,$F$12,0)","v":68.578147824909124},{"$f":"IF($Q22>$I22,E$22*$I22+E$23*($Q22-$I22),$Q22*E$22)+('Incremental Rev Req'!$F$93*$Q22)+IF(Q22>0,$H$12,0)","v":35.424886713802316},{"$f":"IF($R22>$J22,E$25*$J22+E$26*($R22-$J22),$R22*E$25)+('Incremental Rev Req'!$F$93*$R22)+IF(R22>0,$H$12,0)","v":68.578147824909124},{"$f":"IF($Q22>$I22,F$22*$I22+F$23*($Q22-$I22),$Q22*F$22)+('Incremental Rev Req'!$F$93*$Q22)+IF(Q22>0,$J$12,0)","v":35.925025746817688},{"$f":"IF($R22>$J22,F$25*$J22+F$26*($R22-$J22),$R22*F$25)+('Incremental Rev Req'!$F$93*$R22)+IF(R22>0,$J$12,0)","v":69.546320044330457}]
[null,0,{"$f":"IF($Q23>$I23,C$22*$I23+C$23*($Q23-$I23),$Q23*C$22)+('Incremental Rev Req'!$F$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$R25)+IF(R25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C43:C46,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,"2023 Recorded Average Basic Bundled CARE Customer Bill"]
[null,null,{"$f":"C30","v":"2025-01-01"},null,{"$f":"D30","v":"2025-06-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$93*$S22)+IF(S22>0,$Q$12,0)","v":25.971986290312149},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Incremental Rev Req'!$F$93*$T22)+IF(T22>0,$Q$12,0)","v":44.862472966187951},{"$f":"IF($S22>$I22,D$31*$I22+D$32*($S22-$I22),$S22*D$31)+('Incremental Rev Req'!$F$93*$S22)+IF(S22>0,$Q$12,0)","v":27.031281977260189},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Incremental Rev Req'!$F$93*$T22)+IF(T22>0,$Q$12,0)","v":46.611380717509711},{"$f":"IF($S22>$I22,E$31*$I22+E$32*($S22-$I22),$S22*E$31)+('Incremental Rev Req'!$F$93*$S22)+IF(S22>0,$S$12,0)","v":27.031281977260189},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Incremental Rev Req'!$F$93*$T22)+IF(T22>0,$S$12,0)","v":46.680804759257356},{"$f":"IF($S22>$I22,F$31*$I22+F$32*($S22-$I22),$S22*F$31)+('Incremental Rev Req'!$F$93*$S22)+IF(S22>0,$U$12,0)","v":27.412809788171447},{"$f":"IF($T22>$J22,F$34*$J22+F$35*($T22-$J22),$T22*F$34)+('Incremental Rev Req'!$F$93*$T22)+IF(T22>0,$U$12,0)","v":47.339639779413361}]
[null,0,{"$f":"IF($S23>$I23,C$31*$I23+C$32*($S23-$I23),$S23*C$31)+('Incremental Rev Req'!$F$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$T25)+IF(T25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C53:C56,$V$22:$V$25)","v":0},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,"Essential Usage Basic Bundled Non-CARE Customer Bill"]
[null,null,{"$f":"C51","v":"2025-01-01"},null,{"$f":"E51","v":"2025-06-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$93*$I22)+IF(I22>0,$F$12,0)","v":23.747945450533393},{"$f":"($C$25*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$F$12,0)","v":62.608219824133485},{"$f":"($D$22*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$F$12,0)","v":24.712088887025754},{"$f":"($D$25*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$F$12,0)","v":65.150052520340623},{"$f":"($E$22*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$H$12,0)","v":24.712088887025754},{"$f":"($E$25*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$H$12,0)","v":65.150052520340623},{"$f":"($F$22*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$J$12,0)","v":25.060966634962195},{"$f":"($F$25*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$J$12,0)","v":66.069821128536702}]
[null,0,{"$f":"($C$22*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($C$25*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($D$22*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($D$25*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($E$22*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$H$12,0)","v":0},{"$f":"($E$25*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$H$12,0)","v":0},{"$f":"($F$22*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$J$12,0)","v":0},{"$f":"($F$25*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($C$25*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($D$22*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($D$25*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($E$22*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$H$12,0)","v":0},{"$f":"($E$25*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$H$12,0)","v":0},{"$f":"($F$22*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$J$12,0)","v":0},{"$f":"($F$25*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($C$25*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($D$22*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($D$25*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($E$22*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$H$12,0)","v":0},{"$f":"($E$25*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$H$12,0)","v":0},{"$f":"($F$22*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$J$12,0)","v":0},{"$f":"($F$25*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C63:C66,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(F63:F66,$U$22:$U$25)","v":0},0,0,0,0]
[]
[]
[null,null,"Essential Usage Basic Bundled CARE Customer Bill"]
[null,null,{"$f":"C61","v":"2025-01-01"},null,{"$f":"E61","v":"2025-06-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$93*$I22)+IF(I22>0,$Q$12,0)","v":18.859383539926146},{"$f":"($C$34*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$Q$12,0)","v":49.7201929688962},{"$f":"($D$31*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$Q$12,0)","v":19.623777796885257},{"$f":"($D$34*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$Q$12,0)","v":51.658472897112674},{"$f":"($E$31*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$S$12,0)","v":19.623777796885257},{"$f":"($E$34*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$S$12,0)","v":51.735414191788408},{"$f":"($F$31*$I22)+('Incremental Rev Req'!$F$93*$I22)+IF(I22>0,$U$12,0)","v":19.900740289434918},{"$f":"($F$34*$J22)+('Incremental Rev Req'!$F$93*$J22)+IF(J22>0,$U$12,0)","v":52.465588035782957}]
[null,0,{"$f":"($C$31*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($C$34*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($D$31*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($D$34*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($E$31*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$S$12,0)","v":0},{"$f":"($E$34*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$S$12,0)","v":0},{"$f":"($F$31*$I23)+('Incremental Rev Req'!$F$93*$I23)+IF(I23>0,$U$12,0)","v":0},{"$f":"($F$34*$J23)+('Incremental Rev Req'!$F$93*$J23)+IF(J23>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($C$34*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($D$31*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($D$34*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($E$31*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$S$12,0)","v":0},{"$f":"($E$34*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$S$12,0)","v":0},{"$f":"($F$31*$I24)+('Incremental Rev Req'!$F$93*$I24)+IF(I24>0,$U$12,0)","v":0},{"$f":"($F$34*$J24)+('Incremental Rev Req'!$F$93*$J24)+IF(J24>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($C$34*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($D$31*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($D$34*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($E$31*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$S$12,0)","v":0},{"$f":"($E$34*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$S$12,0)","v":0},{"$f":"($F$31*$I25)+('Incremental Rev Req'!$F$93*$I25)+IF(I25>0,$U$12,0)","v":0},{"$f":"($F$34*$J25)+('Incremental Rev Req'!$F$93*$J25)+IF(J25>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C73:C76,$V$22:$V$25)","v":0},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":0},0,0,0,0,0,0]
[]
[]
[null,null,"Typical Monthly Basic Bundled Non-CARE Customer"]
[null,null,{"$f":"C71","v":"2025-01-01"},null,{"$f":"E71","v":"2025-06-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$93*$Q31)+IF(Q31>0,$F$12,0)","v":34.995817185197083},{"$f":"IF($R31>$J22,C$25*$J22+C$26*($R31-$J22),$R31*C$25)+('Incremental Rev Req'!$F$93*$R31)+IF(R31>0,$F$12,0)","v":72.893721111718406},{"$f":"IF($Q31>$I22,D$22*$I22+D$23*($Q31-$I22),$Q31*D$22)+('Incremental Rev Req'!$F$93*$Q31)+IF(Q31>0,$F$12,0)","v":36.426917617092073},{"$f":"IF($R31>$J22,D$25*$J22+D$26*($R31-$J22),$R31*D$25)+('Incremental Rev Req'!$F$93*$R31)+IF(R31>0,$F$12,0)","v":75.862557857292401},{"$f":"IF($Q31>$I22,E$22*$I22+E$23*($Q31-$I22),$Q31*E$22)+('Incremental Rev Req'!$F$93*$Q31)+IF(Q31>0,$H$12,0)","v":36.426917617092073},{"$f":"IF($R31>$J22,E$25*$J22+E$26*($R31-$J22),$R31*E$25)+('Incremental Rev Req'!$F$93*$R31)+IF(R31>0,$H$12,0)","v":75.862557857292401},{"$f":"IF($Q31>$I22,F$22*$I22+F$23*($Q31-$I22),$Q31*F$22)+('Incremental Rev Req'!$F$93*$Q31)+IF(Q31>0,$J$12,0)","v":36.941205006547207},{"$f":"IF($R31>$J22,F$25*$J22+F$26*($R31-$J22),$R31*F$25)+('Incremental Rev Req'!$F$93*$R31)+IF(R31>0,$J$12,0)","v":76.933583620704454}]
[null,0,{"$f":"IF($Q32>$I23,C$22*$I23+C$23*($Q32-$I23),$Q32*C$22)+('Incremental Rev Req'!$F$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$R34)+IF(R34>0,$J$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C83:C86,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":0},{"$f":"SUMPRODUCT(E83:E86,$U$22:$U$25)","v":0},0,0,0,0,0]
[]
[]
[null,null,"Typical Average Monthly Basic Bundled CARE Customer"]
[null,null,{"$f":"C81","v":"2025-01-01"},null,{"$f":"E81","v":"2025-06-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$93*$S31)+IF(S31>0,$Q$12,0)","v":25.971986290312149},{"$f":"IF($T31>$J22,C$34*$J22+C$35*($T31-$J22),$T31*C$34)+('Incremental Rev Req'!$F$93*$T31)+IF(T31>0,$Q$12,0)","v":45.77804314482902},{"$f":"IF($S31>$I22,D$31*$I22+D$32*($S31-$I22),$S31*D$31)+('Incremental Rev Req'!$F$93*$S31)+IF(S31>0,$Q$12,0)","v":27.031281977260189},{"$f":"IF($T31>$J22,D$34*$J22+D$35*($T31-$J22),$T31*D$34)+('Incremental Rev Req'!$F$93*$T31)+IF(T31>0,$Q$12,0)","v":47.562643261649917},{"$f":"IF($S31>$I22,E$31*$I22+E$32*($S31-$I22),$S31*E$31)+('Incremental Rev Req'!$F$93*$S31)+IF(S31>0,$S$12,0)","v":27.031281977260189},{"$f":"IF($T31>$J22,E$34*$J22+E$35*($T31-$J22),$T31*E$34)+('Incremental Rev Req'!$F$93*$T31)+IF(T31>0,$S$12,0)","v":47.633484135286274},{"$f":"IF($S31>$I22,F$31*$I22+F$32*($S31-$I22),$S31*F$31)+('Incremental Rev Req'!$F$93*$S31)+IF(S31>0,$U$12,0)","v":27.412809788171447},{"$f":"IF($T31>$J22,F$34*$J22+F$35*($T31-$J22),$T31*F$34)+('Incremental Rev Req'!$F$93*$T31)+IF(T31>0,$U$12,0)","v":48.305764907698375}]
[null,0,{"$f":"IF($S32>$I23,C$31*$I23+C$32*($S32-$I23),$S32*C$31)+('Incremental Rev Req'!$F$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$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$93*$T34)+IF(T34>0,$U$12,0)","v":0}]
[null,"Total",{"$f":"SUMPRODUCT(C93:C96,$V$22:$V$25)","v":0},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":0},0,0,0,0,0,0]

{"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":"2025-06-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.166666666666666},"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":30.333333333333332},"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":14.624743281218564},"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":26.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":2024}]
[null,null,"Local Transmission",null,null,"Summer season",null,{"$f":"Summary!I10","v":6},"months"]
[null,null,"Storage",null,null,"Winter Season",null,{"$f":"Summary!I11","v":6},"months"]
[null,null,"GHG Revenue"]
[null,null,"Other Balancing Acounts"]
[null,null,"NGV Costs"]
[null,null,"Backbone Transmisson"]
[null,null,"Public Purpose Programs"]
[]
[]
[]
[null,null,"Total",{"$f":"SUM(D6:D18)","v":0}]
[]
[]
[]
[]
[null,"Outputs:"]
[null,null,null,"(A)","(B)","(C)","(C)/(A)","(C)/(B)",null,null,null,"(A)","(B)","(C)","(C)/(A)","(C)/(B)"]
[null,"Bundled Average Rates - ¢/therm",null,null,null,null,null,null,null,"Total System (Bundled and Unbundled) Average Rates - ¢/therm"]
[null,"Customer Group",null,{"$f":"Summary!D26","v":"2025-01-01"},{"$f":"Summary!E26","v":"2025-06-01"},"Proposed",{"$f":"Summary!H26","v":"% Change over 1/1/2025"},{"$f":"Summary!I26","v":"% Change over 6/1/2025"},null,"Customer Group",null,{"$f":"D28","v":"2025-01-01"},{"$f":"E28","v":"2025-06-01"},"Proposed",{"$f":"Summary!P26","v":"2025 Authorized"},{"$f":"Summary!Q26","v":"2025 w/Pending"}]
[null,"Residential",null,213.02606781542525,{"$f":"'Hypothetical SAR and RAR'!G28","v":257.2661389501049},{"$f":"'Hypothetical SAR and RAR'!H28","v":257.2661389501049},{"$f":"$F29/D29-1","v":0.20767444842952787},{"$f":"$F29/E29-1","v":0},null,"Residential",null,212.78419513197028,{"$f":"'Hypothetical SAR and RAR'!R28","v":257.02426626664987},{"$f":"'Hypothetical SAR and RAR'!S28","v":257.02426626664987},{"$f":"$N29/L29-1","v":0.20791051284256135},{"$f":"$N29/M29-1","v":0}]
[null,"System",null,43.434203540129033,{"$f":"'Hypothetical SAR and RAR'!G29","v":43.434203540129033},{"$f":"'Hypothetical SAR and RAR'!H29","v":43.434203540129033},{"$f":"$F30/D30-1","v":0},{"$f":"$F30/E30-1","v":0},null,"System",null,27.139152909856335,{"$f":"'Hypothetical SAR and RAR'!R29","v":27.139152909856335},{"$f":"'Hypothetical SAR and RAR'!S29","v":27.139152909856335},{"$f":"$N30/L30-1","v":0},{"$f":"$N30/M30-1","v":0}]
[]
[]
[null,"Basic Bundled Residential Monthly Average Bills"]
[null,null,null,{"$f":"$D$28","v":"2025-01-01"},{"$f":"$E$28","v":"2025-06-01"},{"$f":"$F$28","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},{"$f":"$H$28","v":"% Change over 6/1/2025"}]
[null,"Non-CARE",null,{"$f":"((D41*$H$10)+(D47*$H$11))/12","v":47.839108854921335},{"$f":"((E41*$H$10)+(E47*$H$11))/12","v":57.698634160466419},57.698634160466419,{"$f":"$F35/D35-1","v":0.20609759549337436},0]
[null,"CARE",null,{"$f":"((D42*$H$10)+(D48*$H$11))/12","v":33.853766992312451},40.892700206460418,40.892700206460418,0.20792171269289983,0]
[null,"Total",null,{"$f":"((D43*$H$10)+(D49*$H$11))/12","v":45.303175525639205},54.651248657676298,54.651248657676298,0.20634476553959402,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":"2024 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":"2025-01-01"},{"$f":"E28","v":"2025-06-01"},{"$f":"F28","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2025"},{"$f":"$H$28","v":"% Change over 6/1/2025"},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":32.588142569947557},{"$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":39.306012773644284},{"$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":39.306012773644284},{"$f":"$F41/D41-1","v":0.20614461807012829},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q22","v":15.166666666666666},{"$f":"'Hypothetical Res Bill Impact'!R22","v":30.333333333333332},{"$f":"'Hypothetical Res Bill Impact'!S22","v":14.624743281218564},{"$f":"'Hypothetical Res Bill Impact'!T22","v":26.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":24.829227826388355},{"$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":29.991973768409839},{"$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":29.991973768409839},0.20793018526877227,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":31.181234487860827},{"$f":"E41*(1-'Hypothetical SAR and RAR'!$AA$16)+E42*'Hypothetical SAR and RAR'!$AA$16","v":37.617117201719971},{"$f":"F41*(1-'Hypothetical SAR and RAR'!$AA$16)+F42*'Hypothetical SAR and RAR'!$AA$16","v":37.617117201719971},0.20640243465552,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":"2025-01-01"},{"$f":"$E$28","v":"2025-06-01"},{"$f":"F40","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2025"},{"$f":"$H$28","v":"% Change over 6/1/2025"}]
[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":63.09007513989512},{"$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.091255547288569},{"$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.091255547288569},{"$f":"$F47/D47-1","v":0.20607330675331736},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":42.878306158236548},{"$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":51.793426644510994},{"$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":51.793426644510994},0.20791680654022127,0]
[null,"Total",null,{"$f":"D47*(1-'Hypothetical SAR and RAR'!$AA$16)+D48*'Hypothetical SAR and RAR'!$AA$16","v":59.425116563417582},{"$f":"E47*(1-'Hypothetical SAR and RAR'!$AA$16)+E48*'Hypothetical SAR and RAR'!$AA$16","v":71.685380113632633},{"$f":"F47*(1-'Hypothetical SAR and RAR'!$AA$16)+F48*'Hypothetical SAR and RAR'!$AA$16","v":71.685380113632633},0.20631450570452103,0]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"D46","v":"2025-01-01"},{"$f":"E46","v":"2025-06-01"},{"$f":"F46","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D60*$H$10)+(D66*$H$11))/12","v":41.335847344985787},{"$f":"((E60*$H$10)+(E66*$H$11))/12","v":49.853478382827632},49.853478382827632,{"$f":"$F54/D54-1","v":0.20605918554794234},0]
[null,"Essential Use - CARE",null,{"$f":"((D61*$H$10)+(D67*$H$11))/12","v":32.773227636868697},39.587332467142161,39.587332467142161,0.20791680654022127,0]
[null,"Total",null,{"$f":"((D62*$H$10)+(D68*$H$11))/12","v":39.783205091610689},47.991939219422164,47.991939219422164,0.20633667169120318,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":"2025-01-01"},{"$f":"E53","v":"2025-06-01"},{"$f":"F53","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% 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":22.734716039742185},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":27.419413110555194},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":27.419413110555194},{"$f":"$F60/D60-1","v":0.20605918554794211},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.025275200277783},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":21.773032856928189},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":21.773032856928189},0.20791680654022149,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":21.880762800385881},{"$f":"E60*(1-'Hypothetical SAR and RAR'!$AA$16)+E61*'Hypothetical SAR and RAR'!$AA$16","v":26.395566570682185},{"$f":"F60*(1-'Hypothetical SAR and RAR'!$AA$16)+F61*'Hypothetical SAR and RAR'!$AA$16","v":26.395566570682185},0.20633667169120273,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":"2025-01-01"},{"$f":"E59","v":"2025-06-01"},{"$f":"F59","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% 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":59.936978650229399},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":72.287543655100066},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":72.287543655100066},{"$f":"$F66/D66-1","v":0.20605918554794211},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":47.521180073459611},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":57.401632077356133},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":57.401632077356133},0.20791680654022127,0]
[null,"Total",null,{"$f":"D66*(1-'Hypothetical SAR and RAR'!$AA$16)+D67*'Hypothetical SAR and RAR'!$AA$16","v":57.685647382835498},{"$f":"E66*(1-'Hypothetical SAR and RAR'!$AA$16)+E67*'Hypothetical SAR and RAR'!$AA$16","v":69.588311868162137},{"$f":"F66*(1-'Hypothetical SAR and RAR'!$AA$16)+F67*'Hypothetical SAR and RAR'!$AA$16","v":69.588311868162137},0.20633667169120318,0]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"D65","v":"2025-01-01"},{"$f":"E65","v":"2025-06-01"},{"$f":"F65","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"((D79*$H$10)+(D85*$H$11))/12","v":51.649963791082712},{"$f":"((E79*$H$10)+(E85*$H$11))/12","v":62.295827518675083},62.295827518675083,{"$f":"$F73/D73-1","v":0.20611560872827495},0]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D80*$H$10)+(D86*$H$11))/12","v":34.291305271340349},41.421210047202905,41.421210047202905,0.20792165009307828,0]
[null,"Total",null,{"$f":"((D81*$H$10)+(D87*$H$11))/12","v":48.502353877482051},58.510675986308733,58.510675986308733,0.20634714212237837,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":"2020-2024 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":"2025-01-01"},{"$f":"E72","v":"2025-06-01"},{"$f":"F72","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% 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":33.509791428276827},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":40.417836257111695},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":40.417836257111695},{"$f":"$F79/D79-1","v":0.20615003956740829},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q31","v":15.556399473279669},{"$f":"'Hypothetical Res Bill Impact'!R31","v":33.166552904825643},{"$f":"'Hypothetical Res Bill Impact'!S31","v":14.624743281218564},{"$f":"'Hypothetical Res Bill Impact'!T31","v":26.700685816536037}]
[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":24.829227826388355},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":29.991973768409839},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":29.991973768409839},0.20793018526877227,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":31.935762650772499},{"$f":"E79*(1-'Hypothetical SAR and RAR'!$AA$16)+E80*'Hypothetical SAR and RAR'!$AA$16","v":38.527336015405105},{"$f":"F79*(1-'Hypothetical SAR and RAR'!$AA$16)+F80*'Hypothetical SAR and RAR'!$AA$16","v":38.527336015405105},0.20640100055581923,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":"2025-01-01"},{"$f":"E78","v":"2025-06-01"},{"$f":"F78","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2025"},"% 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":69.790136153888582},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":84.173818780238477},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":84.173818780238477},{"$f":"$F85/D85-1","v":0.2060990767324713},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":43.753382716292343},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":52.850446325995968},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":52.850446325995968},0.20791680654022149,0]
[null,"Total",null,{"$f":"D85*(1-'Hypothetical SAR and RAR'!$AA$16)+D86*'Hypothetical SAR and RAR'!$AA$16","v":65.068945104191613},{"$f":"E85*(1-'Hypothetical SAR and RAR'!$AA$16)+E86*'Hypothetical SAR and RAR'!$AA$16","v":78.494015957212355},{"$f":"F85*(1-'Hypothetical SAR and RAR'!$AA$16)+F86*'Hypothetical SAR and RAR'!$AA$16","v":78.494015957212355},0.20632070846582584,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.57246929564900972},{"$f":"'SAR and RAR'!H5","v":0.81652373633254627},{"$f":"'SAR and RAR'!I5","v":0.71351095116714947},{"$f":"'SAR and RAR'!J5","v":1},{"$f":"'SAR and RAR'!K5","v":0.51543343712031298},{"$f":"'SAR and RAR'!L5","v":0.7405203174456334},{"$f":"'SAR and RAR'!M5","v":0.49735087986604948},{"$f":"'SAR and RAR'!N5","v":0.45465574087968463},{"$f":"'SAR and RAR'!O5","v":0},{"$f":"'SAR and RAR'!P5","v":0.43914119669235535},{"$f":"'SAR and RAR'!Q5","v":0.33016648110968039},{"$f":"'SAR and RAR'!R5","v":0.81652373633254627},{"$f":"'SAR and RAR'!S5","v":0.60198759162917603},{"$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.18132794708881522}]
[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":2.5000000000000001E-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":"CAP D.24-07-009  SALES DETERMINANTS SYSTEM NET"},{"$f":"'SAR and RAR'!D22","v":"CAP D.24-07-009  SALES DETERMINANTS BUNDLED"}]
[null,"Residential",{"$f":"'SAR and RAR'!C23","v":270603.84207905678},{"$f":"'SAR and RAR'!D23","v":268350.62742938031}]
[null,"Total System",{"$f":"'SAR and RAR'!C24","v":819598.16505165747},{"$f":"'SAR and RAR'!D24","v":413767.70037365775}]
[]
[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":"06/01/2025 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":"06/01/2025 Avg Rates(sales adj.)"},"Proposed Avg Rates","% Change"]
[null,null,null,null,"Residential",{"$f":"'SAR and RAR'!F28","v":268350.62742938031},257.2661389501049,{"$f":"(U19/C23*100)+(W19/D23*100)+G28","v":257.2661389501049},{"$f":"H28/G28-1","v":0},null,null,null,null,null,null,"Residential",{"$f":"'SAR and RAR'!Q28","v":270603.84207905678},257.02426626664987,{"$f":"U9/Q28*100+R28","v":257.02426626664987},{"$f":"S28/R28-1","v":0}]
[null,null,null,null,"Total System",{"$f":"'SAR and RAR'!F29","v":413767.70037365775},43.434203540129033,{"$f":"(U20/C24*100)+(W20/D24*100)+G29","v":43.434203540129033},{"$f":"H29/G29-1","v":0},null,null,null,null,null,null,"Total System",{"$f":"'SAR and RAR'!Q29","v":819598.16505165747},27.139152909856335,{"$f":"U10/Q29*100+R29","v":27.139152909856335},{"$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":"2025-06-01"},{"$f":"'Res Bill Impact'!G4","v":"2025-06-01"},"Proposed","Proposed",null,null,null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"'Res Bill Impact'!Q4","v":"2025-06-01"},{"$f":"'Res Bill Impact'!R4","v":"2025-06-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.4901739191413812},{"$f":"F7*E7","v":468051.42033747409},{"$f":"(Y10/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*(Q7/F7),SUM(P9)*(Q9/F7)))","v":2.4901739191413812},{"$f":"E7*H7","v":468051.42033747409},null,null,null,null,null,"Baseline ",{"$f":"'Res Bill Impact'!P7","v":34568.659520669324},{"$f":"'Res Bill Impact'!Q7","v":1.9768666233571082},{"$f":"'Res Bill Impact'!R7","v":68337.629220607108},{"$f":"H7*(1+(Q7/F7-1))","v":1.9768666233571082},{"$f":"P7*S7","v":68337.629220607108},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":786680.33735731093}]
[null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!E9","v":76615.611405786854},{"$f":"'Res Bill Impact'!F9","v":2.8502839191413814},{"$f":"F9*E9","v":218376.24514509927},{"$f":"F9/F$7*H$7","v":2.8502839191413814},{"$f":"E9*H9","v":218376.24514509927},null,null,null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!P9","v":14090.808851095719},{"$f":"'Res Bill Impact'!Q9","v":2.2649546233571081},{"$f":"'Res Bill Impact'!R9","v":31915.04265413051},{"$f":"H9*(1+(Q9/F9-1))","v":2.2649546233571081},{"$f":"P9*S9","v":31915.04265413051},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":786680.33735731093}]
[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":"2024 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":"2025-01-01"},{"$f":"'Res Bill Impact'!D21","v":"2025-06-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.0642923672492897,2.4901739191413812,{"$f":"H7","v":2.4901739191413812},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.166666666666666},{"$f":"'Res Bill Impact'!R22","v":30.333333333333332},{"$f":"'Res Bill Impact'!S22","v":14.624743281218564},{"$f":"'Res Bill Impact'!T22","v":26.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.3623223672492895,2.8502839191413814,{"$f":"H9","v":2.8502839191413814},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.0642923672492897},2.4901739191413812,2.4901739191413812,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.3623223672492895,2.8502839191413814,2.8502839191413814]
[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":"2020-2024 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":"2025-01-01"},{"$f":"D21","v":"2025-06-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.6361613818434348,1.9768666233571082,{"$f":"S7","v":1.9768666233571082},null,null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.556399473279669},{"$f":"'Res Bill Impact'!R31","v":33.166552904825643},{"$f":"'Res Bill Impact'!S31","v":14.624743281218564},{"$f":"'Res Bill Impact'!T31","v":26.700685816536037},{"$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.8745853818434348,2.2649546233571081,{"$f":"S9","v":2.2649546233571081},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.6361613818434348},1.9768666233571082,1.9768666233571082,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"Tier 2",1.8745853818434348,2.2649546233571081,2.2649546233571081]
[]
[]
[]
[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":"2025-01-01"},null,{"$f":"D30","v":"2025-06-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":32.588142569947557},{"$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":63.09007513989512},{"$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":39.306012773644284},{"$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.091255547288569},{"$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":39.306012773644284},{"$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.091255547288569}]
[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":32.588142569947557},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":63.09007513989512},39.306012773644284,76.091255547288569,39.306012773644284,76.091255547288569]
[]
[]
[null,null,{"$f":"'Res Bill Impact'!C50","v":"2023 Recorded Average Basic Bundled CARE Customer Bill"}]
[null,null,{"$f":"C30","v":"2025-01-01"},null,{"$f":"D30","v":"2025-06-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":24.829227826388355},{"$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":42.878306158236548},{"$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":29.991973768409839},{"$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":51.793426644510994},{"$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":29.991973768409839},{"$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":51.793426644510994}]
[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":24.829227826388355},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":42.878306158236548},29.991973768409839,51.793426644510994,29.991973768409839,51.793426644510994]
[]
[]
[null,null,"Essential Usage Basic Bundled Non-CARE Customer"]
[null,null,{"$f":"C51","v":"2025-01-01"},null,{"$f":"D30","v":"2025-06-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":22.734716039742185},{"$f":"($C$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":59.936978650229399},{"$f":"($D$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":27.419413110555194},{"$f":"($D$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":72.287543655100066},{"$f":"($E$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$H$12,0)","v":27.419413110555194},{"$f":"($E$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$H$12,0)","v":72.287543655100066}]
[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":22.734716039742185},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":59.936978650229399},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":27.419413110555194},72.287543655100066,27.419413110555194,72.287543655100066]
[]
[]
[null,null,"Essential Usage Basic Bundled CARE Customer"]
[null,null,{"$f":"C51","v":"2025-01-01"},null,{"$f":"E61","v":"2025-06-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.025275200277783},{"$f":"($C$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":47.521180073459611},{"$f":"($D$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":21.773032856928189},{"$f":"($D$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":57.401632077356133},{"$f":"($E$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$S$12,0)","v":21.773032856928189},{"$f":"($E$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$S$12,0)","v":57.401632077356133}]
[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.025275200277783},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":47.521180073459611},21.773032856928189,57.401632077356133,21.773032856928189,57.401632077356133]
[]
[]
[null,null,"Typical Monthly Usage Basic Bundled Non-CARE Customer "]
[null,null,{"$f":"C71","v":"2025-01-01"},null,{"$f":"E71","v":"2025-06-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":33.509791428276827},{"$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":69.790136153888582},{"$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":40.417836257111695},{"$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":84.173818780238477},{"$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":40.417836257111695},{"$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":84.173818780238477}]
[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":33.509791428276827},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":69.790136153888582},40.417836257111695,84.173818780238477,40.417836257111695,84.173818780238477]
[]
[]
[null,null,"Typical Monthly Usage Basic Bundled CARE Customer "]
[null,null,{"$f":"C81","v":"2025-01-01"},null,{"$f":"E81","v":"2025-06-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":24.829227826388355},{"$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":43.753382716292343},{"$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":29.991973768409839},{"$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":52.850446325995968},{"$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":29.991973768409839},{"$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":52.850446325995968}]
[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":24.829227826388355},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":43.753382716292343},29.991973768409839,52.850446325995968,29.991973768409839,52.850446325995968]

{"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","2025-06-01",null,"Zones",null,"Revenue Recovery Mechanisms",null,"Years Available for Rate Impact","Procurement Rate Assumption"]
[null,null,"Beginning of Year Effecive Rate Date","2025-01-01",null,"SDG&E",null,"Core Procurement",null,2025,0.32908800000000005]
[null,null,"Care Discount %",0.2,null,null,null,"Allocated Base Margin",null,{"$f":"J5+1","v":2026},{"$f":"K5*(1+L6)","v":0.36199680000000006},0.1]
[null,null,"Proposed Residential Fixed Charge",0,null,null,null,"Distribution",null,{"$f":"J6+1","v":2027},0.39819648000000007,0.1]
[null,null,null,null,null,null,null,"All Residential",null,2028,0.43801612800000012,0.1]
[null,null,null,null,null,"All",null,"Local Transmission",null,2029,0.48181774080000017,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":2024},0.34405272727272734]
[null,null,"Regulatory Fee",2.5000000000000001E-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"]