{"text_format":"1","workbook":"xlsx","n_sheets":11,"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","Selected Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":252,"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 (2026-2030)"},2026,null,null,"Current Effective Rates",null,{"$f":"CurrentEffectiveRateDate","v":"2026-01-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},"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":29},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A97","v":"2024 GRC Track 3 (PSEP and WMPMA)"},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.833333333333334},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A98","v":"GRC PFM"},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":24.666666666666668},"therms per month"]
[null,{"$f":"'Incremental Rev Req'!A99","v":"GRC Track 2 Proposed Decision - SDG&E 2024"},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'!A100","v":0},null,"Y",2026,null,"Summer season",null,6,"months"]
[null,{"$f":"'Incremental Rev Req'!A101","v":0},null,"Y",2026,null,"Winter Season",null,{"$f":"12-I10","v":6},"months"]
[null,{"$f":"'Incremental Rev Req'!A104","v":"Cost Allocation Proceeding"},null,"N","2027-2029"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% Change over Authorized",null,"Customer Group",null,{"$f":"$D$26","v":"2026-01-01"},{"$f":"$E$26","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"$H$26","v":"% Change over 1/1/2026"},{"$f":"$I$26","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"Residential",null,264.90083490811179,{"$f":"'SAR and RAR'!G28","v":229.73771969948896},{"$f":"'SAR and RAR'!H28","v":264.90083490811179},{"$f":"'SAR and RAR'!I28","v":282.41372983171749},{"$f":"$G27/D27-1","v":6.6111135246819996E-2},0.22928759892425155,6.6111135246819996E-2,null,"Total Residential (RAR)",null,217.42583844438877,{"$f":"'SAR and RAR'!R28","v":229.73771969948896},{"$f":"'SAR and RAR'!S28","v":264.60804510251398},{"$f":"'SAR and RAR'!T28","v":282.12094002611968},{"$f":"$Q27/N27-1","v":0.29755019939029936},{"$f":"$Q27/O27-1","v":0.22801314644870319},6.618428746873839E-2]
[null,"System",null,144.69852958917986,{"$f":"'SAR and RAR'!G29","v":104.86202958917985},{"$f":"'SAR and RAR'!H29","v":144.69852958917986},{"$f":"'SAR and RAR'!I29","v":151.77997821545168},4.8939326794661175E-2,0.44742552485473763,4.8939326794661175E-2,null,"Total System (SAR)",null,89.859930590907737,{"$f":"'SAR and RAR'!R29","v":104.86202958917985},{"$f":"'SAR and RAR'!S29","v":124.97317392647389},{"$f":"'SAR and RAR'!T29","v":132.05462255274574},0.4695607005744491,0.2593178204741875,5.6663749537465558E-2]
[]
[]
[null,"Basic Bundled Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"Non-CARE",null,{"$f":"((D39*$I$10)+(D45*$I$11))/12","v":43.728291251817268},{"$f":"((E39*$I$10)+(E45*$I$11))/12","v":43.728291251817268},50.597991456875214,53.94168727866272,{"$f":"$G33/D33-1","v":0.23356494695916119},0.23356494695916119,6.6083568250675517E-2]
[null,"CARE",null,{"$f":"((D40*$I$10)+(D46*$I$11))/12","v":31.065802981130464},33.972601250001539,36.006940027606483,38.38545870839193,0.23561778627474927,0.12989460023730715,6.6057228938694479E-2]
[null,"Total",null,{"$f":"((D41*$I$10)+(D47*$I$11))/12","v":41.432228248657431},41.959312011353148,47.952226055338599,51.120908287571147,0.23384404963128347,0.21834476870686292,6.6079981950697642E-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":"2025 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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":30.708225348238226},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,4,FALSE)))","v":30.708225348238226},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,6,FALSE)))","v":35.373266045303339},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,8,FALSE)))","v":37.710945778861749},{"$f":"$G39/D39-1","v":0.22804054455153588},{"$f":"$G39/E39-1","v":0.22804054455153588},{"$f":"$G39/F39-1","v":6.6086058623042954E-2},null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q22","v":15},{"$f":"'Res Bill Impact'!R22","v":29},{"$f":"'Res Bill Impact'!S22","v":14.833333333333334},{"$f":"'Res Bill Impact'!T22","v":24.666666666666668}]
[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":23.981145093263553},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$E$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,4,FALSE)))","v":23.981145093263553},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$G$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,6,FALSE)))","v":27.678520492266333},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$I$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,8,FALSE)))","v":29.506967581644766},{"$f":"$G40/D40-1","v":0.23042362935093741},{"$f":"$G40/E40-1","v":0.23042362935093741},6.6060145443443075E-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":29.488417695701965},{"$f":"E39*(1-'SAR and RAR'!$AC$15)+E40*'SAR and RAR'!$AC$15","v":29.488417695701965},{"$f":"F39*(1-'SAR and RAR'!$AC$15)+F40*'SAR and RAR'!$AC$15","v":33.977993630800349},{"$f":"G39*(1-'SAR and RAR'!$AC$15)+G40*'SAR and RAR'!$AC$15","v":36.223335254398997},{"$f":"$G41/D41-1","v":0.22839196148793928},0.22839196148793928,6.6082230987390966E-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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":56.74835715539632},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,5,FALSE)))","v":56.74835715539632},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,7,FALSE)))","v":65.822716868447088},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$47,(VLOOKUP($D$3,'Res Bill Impact'!$B$43:$J$46,9,FALSE)))","v":70.172428778463697},{"$f":"$G45/D45-1","v":0.23655436555295695},{"$f":"$G45/E45-1","v":0.23655436555295695},6.6082229919343982E-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":38.150460868997371},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$F$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,5,FALSE)))","v":43.964057406739521},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$H$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,7,FALSE)))","v":44.335359562946628},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!$J$57,(VLOOKUP($D$3,'Res Bill Impact'!$B$53:$J$56,9,FALSE)))","v":47.263949835139094},0.238882801375218,7.505886906365733E-2,6.6055408167706497E-2]
[null,"Total",null,{"$f":"D45*(1-'SAR and RAR'!$AC$15)+D46*'SAR and RAR'!$AC$15","v":53.376038801612907},{"$f":"E45*(1-'SAR and RAR'!$AC$15)+E46*'SAR and RAR'!$AC$15","v":54.430206327004335},{"$f":"F45*(1-'SAR and RAR'!$AC$15)+F46*'SAR and RAR'!$AC$15","v":61.926458479876842},{"$f":"G45*(1-'SAR and RAR'!$AC$15)+G46*'SAR and RAR'!$AC$15","v":66.018481320743291},0.23685614000168842,0.21290154448651588,6.6078747942547977E-2]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D58*$I$10)+(D64*$I$11))/12","v":39.136798038204354},{"$f":"((E58*$I$10)+(E64*$I$11))/12","v":39.136798038204354},45.394977150653169,48.394778467905986,{"$f":"$G52/D52-1","v":0.23655436555295672},0.23655436555295672,6.608222991934376E-2]
[null,"Essential Use - CARE",null,{"$f":"((D59*$I$10)+(D65*$I$11))/12","v":30.93280610999787},34.350258128805756,35.947588834821588,38.322121487950618,0.238882801375218,0.11562834096475383,6.6055408167706497E-2]
[null,"Total",null,{"$f":"D52*(1-'SAR and RAR'!$AC$15)+D53*'SAR and RAR'!$AC$15","v":37.649185023929462},{"$f":"E52*(1-'SAR and RAR'!$AC$15)+E53*'SAR and RAR'!$AC$15","v":38.268864582774427},{"$f":"F52*(1-'SAR and RAR'!$AC$15)+F53*'SAR and RAR'!$AC$15","v":43.681901621992573},{"$f":"G52*(1-'SAR and RAR'!$AC$15)+G53*'SAR and RAR'!$AC$15","v":46.568324256000857},{"$f":"$G54/D54-1","v":0.2369012563327062},{"$f":"$G54/E54-1","v":0.21687237820382532},6.6078227522838651E-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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":21.525238921012399},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":21.525238921012399},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":24.967237432859239},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,8,FALSE)))","v":26.617128157348297},{"$f":"$G58/D58-1","v":0.23655436555295672},{"$f":"$G58/E58-1","v":0.23655436555295672},{"$f":"$G58/F58-1","v":6.6082229919343982E-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":17.013043360498827},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":17.013043360498827},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":19.771173859151872},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,8,FALSE)))","v":21.077166818372834},{"$f":"$G59/D59-1","v":0.23888280137521778},0.23888280137521778,6.6055408167706275E-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":20.707051763161207},{"$f":"E58*(1-'SAR and RAR'!$AC$15)+E59*'SAR and RAR'!$AC$15","v":20.707051763161207},{"$f":"F58*(1-'SAR and RAR'!$AC$15)+F59*'SAR and RAR'!$AC$15","v":24.02504589209591},{"$f":"G58*(1-'SAR and RAR'!$AC$15)+G59*'SAR and RAR'!$AC$15","v":25.612578340800475},{"$f":"$G60/D60-1","v":0.2369012563327062},{"$f":"$G60/E60-1","v":0.2369012563327062},6.6078227522839095E-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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":56.74835715539632},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":56.74835715539632},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":65.822716868447088},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J67,(VLOOKUP($D$3,'Res Bill Impact'!$B$63:$J$66,9,FALSE)))","v":70.172428778463697},{"$f":"$G64/D64-1","v":0.23655436555295695},{"$f":"$G64/E64-1","v":0.23655436555295695},{"$f":"$G64/F64-1","v":6.6082229919343982E-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":44.852568859496905},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":51.687472897112677},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":52.124003810491303},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J77,(VLOOKUP($D$3,'Res Bill Impact'!$B$73:$J$76,9,FALSE)))","v":55.56707615752839},{"$f":"$G65/D65-1","v":0.238882801375218},7.505886906365733E-2,6.6055408167706497E-2]
[null,"Total",null,{"$f":"D64*(1-'SAR and RAR'!$AC$15)+D65*'SAR and RAR'!$AC$15","v":54.591318284697728},{"$f":"E64*(1-'SAR and RAR'!$AC$15)+E65*'SAR and RAR'!$AC$15","v":55.83067740238765},{"$f":"F64*(1-'SAR and RAR'!$AC$15)+F65*'SAR and RAR'!$AC$15","v":63.338757351889228},{"$f":"G64*(1-'SAR and RAR'!$AC$15)+G65*'SAR and RAR'!$AC$15","v":67.524070171201259},0.2369012563327062,0.20944386335376142,6.6078227522839095E-2]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"BOYEffectiveRateDate","v":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"((D77*$I$10)+(D83*$I$11))/12","v":47.690320182792981},{"$f":"((E77*$I$10)+(E83*$I$11))/12","v":47.690320182792981},55.08770585924308,58.728150453767604,{"$f":"$G71/D71-1","v":0.23144802191865255},0.23144802191865255,6.608451990769737E-2]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D78*$I$10)+(D84*$I$11))/12","v":32.312179424473548},35.420677261117,37.457487764103114,39.931821514373297,{"$f":"$G72/D72-1","v":0.23581331329599386},{"$f":"$G72/E72-1","v":0.12735906261759711},{"$f":"$G72/F72-1","v":6.605711962993488E-2}]
[null,"Total",null,{"$f":"((D79*$I$10)+(D85*$I$11))/12","v":44.901833489044073},45.465491020292653,51.890854605323263,55.319850714381154,0.23201763526825792,0.21674372085171578,6.6080933434966571E-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":"2021-2025 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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":31.552493141837783},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,4,FALSE)))","v":31.552493141837783},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,6,FALSE)))","v":36.329978209302048},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,8,FALSE)))","v":38.730892067592201},{"$f":"$G77/D77-1","v":0.22750655212839743},0.22750655212839743,6.6086300532803843E-2,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.367753039946335},{"$f":"'Res Bill Impact'!R31","v":32.083872604825636},{"$f":"'Res Bill Impact'!S31","v":14.748357547885229},{"$f":"'Res Bill Impact'!T31","v":26.37825981653603}]
[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":23.826679027744252},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!E97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":23.826679027744252},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!G97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":27.503233625059551},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!I97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,8,FALSE)))","v":29.320099162245619},{"$f":"$G78/D78-1","v":0.23055752453393619},{"$f":"$G78/E78-1","v":0.23055752453393619},{"$f":"$G78/F78-1","v":6.6060069952306621E-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":30.151587128939411},{"$f":"E77*(1-'SAR and RAR'!$AC$15)+E78*'SAR and RAR'!$AC$15","v":30.151587128939411},{"$f":"F77*(1-'SAR and RAR'!$AC$15)+F78*'SAR and RAR'!$AC$15","v":34.729442734364042},{"$f":"G77*(1-'SAR and RAR'!$AC$15)+G78*'SAR and RAR'!$AC$15","v":37.024452309587723},0.22794372817780317,0.22794372817780317,6.6082533853986103E-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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"$D$2&\" Authorized\"","v":"2026 Authorized"},{"$f":"$D$2&\" w/Pending\"","v":"2026 w/Pending"},{"$f":"CONCATENATE(\"% Change over \",TEXT(BOYEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},{"$f":"CONCATENATE(\"% Change over \",TEXT(CurrentEffectiveRateDate,\"m/d/yyyy\"))","v":"% Change over 1/1/2026"},"% 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":63.828147223748161},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":63.828147223748161},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":73.845433509184105},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J87,(VLOOKUP($D$3,'Res Bill Impact'!$B$83:$J$86,9,FALSE)))","v":78.725408839943},{"$f":"$G83/D83-1","v":0.23339642875693722},0.23339642875693722,6.6083643887769661E-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":40.797679821202841},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!F97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":47.014675494489737},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!H97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":47.41174190314667},{"$f":"IF($D$3=\"All\",'Res Bill Impact'!J97,(VLOOKUP($D$3,'Res Bill Impact'!$B$93:$J$96,9,FALSE)))","v":50.543543866500976},{"$f":"$G84/D84-1","v":0.238882801375218},{"$f":"$G84/E84-1","v":7.5058869063657108E-2},{"$f":"$G84/F84-1","v":6.6055408167706497E-2}]
[null,"Total",null,{"$f":"D83*(1-'SAR and RAR'!$AC$15)+D84*'SAR and RAR'!$AC$15","v":59.652079849148741},{"$f":"E83*(1-'SAR and RAR'!$AC$15)+E84*'SAR and RAR'!$AC$15","v":60.779394911645902},{"$f":"F83*(1-'SAR and RAR'!$AC$15)+F84*'SAR and RAR'!$AC$15","v":69.052266476282497},{"$f":"G83*(1-'SAR and RAR'!$AC$15)+G84*'SAR and RAR'!$AC$15","v":73.615249119174578},0.23407682188679124,0.21118759451600266,6.6080128513368086E-2]

{"sheet":"Authorized Rev Req","index":2,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
["Annual Period 2025"]
["Reporting Date: Quarter Ended March 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01","2024-01-01","2024-07-01","2024-10-01","2025-01-01","2025-02-01","2025-07-01","2025-09-01","2025-10-01","2026-01-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-3431-G","AL-3447-G","AL-3457-G","AL-3438-G"]
["Filing Description","Authority for Revenue Requirement as of 10/01/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) ","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,475212.73608376429,475212.73608376429,491182.11962129368,"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,27312.888395031419,26976.484013950241,28089.390822925208,"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.158346716307,22813.158346716307,22279.642412940473,22279.642412940473,23067.973570493206,"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,12979.167546880011,12979.167546880011,13438.415589853987,"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,1416.8473200000003,1416.8473200000003,1464.6924600000004,"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,8658.3185670046078,8658.3185670046078,9677.4329804631216,"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,282.04104329875889,282.04104329875889,315.2382616949493,"ECPT","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,39.313580777554826,39.313580777554826,37.268490301980989,"Local Transmission","N"]
["CFCA","D.24-07-009, AL 3383, AL 3392-G-A, AL 6538",37541.479619999998,55563.797728400001,55563.797728400001,55563.797728400001,55563.797728400001,25794.189268400005,25794.189268400005,32720.484075331624,75579.000117400021,75648.131790397572,75648.131790397572,75648.131790397703,68715.501536664349,21078.929369858219,"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,25.598658546541539,25.598658546541539,-1668.0723758234942,"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,39.933907332604804,39.933907332604804,0,"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,420.84194650514291,420.84194650514291,87.306743808495682,"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,23586.603984783382,23586.603984783382,16316.089710564167,"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,-225.64053933387851,-225.64053933387851,5199.3733783365324,"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,-625.53812884639717,-625.53812884639717,7663.477830061016,"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,-884.13753996041987,-884.13753996041987,1684.4906119844525,"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,23688.773971364426,23688.773971364426,50453.415825049553,"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,-51.197317093083079,-51.197317093083079,-53.411184447550312,"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,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,1891.228893418489,1891.228893418489,2620.229452417324,"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,-348.51410035727804,-348.51410035727804,-3149.205606080563,"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,13923.622356634874,13923.622356634874,23136.287109251356,"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,57.340995144253043,57.340995144253043,1428.7491839719685,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.24-07-009, AL 3383, AL 3392-G-A, AL 3447-G, AL 6538",1705.2219761999997,794.87923620000004,794.87923620000004,794.87923620000004,794.87923620000004,6588.1882640000003,6588.1882640000003,6784.0932542683813,4107.3875589999998,4111.1445625745646,4111.1445625745646,4111.1445625745719,3915.0603842670384,-287.5986854868093,"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,446.44060505168443,446.44060505168443,1526.3273094049953,"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,1428.2529999999999,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,59.438824546069831,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,-606.06691000001092,-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,2392.8234176377423,2374.5392468044802,2469.8040647015428,"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,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,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,211.95689276536396,211.95689276536396,1832.4144818159566,"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,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, AL 3431",0,0,0,0,0,0,7280.4081272496533,7280.4081272496533,7280.4081272496533,7567.7042719846359,0,0,0,0,"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,-5707,-5707,-7916.0000000000018,"EPAM","N"]
["General Rate Case Revenue Requirement Memorandum Account  (GRCMA)",null,null,0,0,0,0,0,0,0,0,18532.625999999997,18532.625999999997,18532.626,18532.626,18415.516233662707,"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,341.24933333333291,341.24933333333291,341.24933333333291,"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,-679.73003999999992,-679.73003999999992,-728.46863419783074,"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,10178.705333333301,10178.705333333301,10114.384939493688,"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,15437.625766000001,15437.625766000001,15844.324000000001,"Distribution","N"]
["Distribution Integrity Management Program Memorandum Account  (DIMPBA)",null,0,0,0,0,0,0,0,0,0,-14786.157520606683,-14786.157520606683,-14786.15752060667,-14786.15752060667,0,"Distribution","Y"]
["Concurrent Application System Balancing Account (CASBA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4210.6979531983252]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C9:C49)","v":554004.44389743055},{"$f":"SUM(D9:D49)","v":646320.2290135324},{"$f":"SUM(E9:E50)","v":646320.2290135324},646556.82194009866,641688.27399176045,653820.01483058976,661331.96520755324,668472.57777871005,{"$f":"SUM(K9:K42)","v":651385.50770890573},{"$f":"SUM(L9:L50)","v":722724.32667443785},{"$f":"SUM(M9:M50)","v":715156.62240245321},{"$f":"SUM(N9:N50)","v":716689.31309286878},{"$f":"SUM(O9:O50)","v":709205.91010891332},{"$f":"SUM(P9:P50)","v":738774.46775644948}]
[]
[]
[]
["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,87862.617155020998,87862.617155020998,80558.905121358897,"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,1041.4078671483596,1041.4078671483596,3600.4283616059961,"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,1085.1171215926722,1085.1171215926722,1120.6077352361037,"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,-6348.467319542302,-6348.467319542302,4356.092946962709,"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,8597.0534862705099,8597.0534862705099,-33618.205587732642,"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,-1089.4789077408082,-1089.4789077408082,-1076.4407942506293,"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,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,0,0,0,"46% Res (LUAF, Other)","Y"]
["New Environmental Regulation Balancing Account (NERBA) - LDAR 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,1117.0323729399938,1117.0323729399938,0,"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,-7484.7396281400552,-7080.5114566566808,-13441.430545418532,"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,150.52011225366422,150.52011225366422,71.89967137170234,"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,-27.646551230264865,-27.646551230264865,0,"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,56.31704880239139,56.31704880239139,71.899671371702354,"EPAM","y"]
["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,666.99386717611173,666.99386717611173,-553.3470608437583,"EPAM","Y"]
["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,4963.1885857130419,4963.1885857130419,-2114.0763087237883,"EPAM","Y"]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding","AL 3137-G, D.21-06-015, 3245-G, 3462-G",25613.072,22795.559000000001,22795.559000000001,22795.559000000001,22795.559000000001,21383.37754112266,21383.37754112266,21383.37754112266,19135.75612917971,19135.75612917971,19135.75612917971,{"$f":"M73","v":19135.75612917971},{"$f":"M73","v":19135.75612917971},22811.164566316405,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Admin Expenses","AL 3137-G, D.21-06-015, 3245-G, 3462-G",727.2829999999999,761.47,761.47,761.47,761.47,771.47047999999995,771.47047999999995,771.47047999999995,698.36900000000003,698.36900000000003,698.36900000000003,698.36900000000003,{"$f":"M74","v":698.36900000000003},743.89099999999996,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3137-G, AL 3245-G, AL 3247-G-B, 3462-G",1000,-1000,-1000,-1000,-1000,7000,7000,7000,0,0,0,0,{"$f":"M75","v":0},0,"Public Purpose Programs","Y"]
["Energy Savings Assistance (ESA/LIEE/DAP)","AL 3137-G, D.21-06-015, AL 3247-G-B, 3462-G",8041.1949999999997,10315.642,10315.642,10315.642,10315.642,7005.5879999999997,7005.5879999999997,7005.5879999999997,14340.989,14340.989,14340.989,14340.989,{"$f":"M76","v":14340.989},15138.709320357639,"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,40192.256999999998,{"$f":"K77","v":40192.256999999998},{"$f":"L77","v":40192.256999999998},40192.256999999998,{"$f":"N77","v":40192.256999999998},45917.596267981098,"Public Purpose Programs","N"]
["RD&D ","AL 3137-G, AL 3245-G, 3462-G",1929.78072,2278.9604600000002,2278.9604600000002,2278.9604600000002,2278.9604600000002,2183.7319900000002,2183.7319900000002,2183.7319900000002,1276.3142700000001,1276.3142700000001,1276.3142700000001,1276.3142700000001,1276.3142700000001,1245.4186200000001,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3137-G, AL 3245-G, 3462-G",56.159990000000001,55.36833,55.36833,55.36833,55.36833,47.053350000000002,47.053350000000002,47.053350000000002,52.328879999999998,52.328879999999998,52.328879999999998,52.328879999999998,52.328879999999998,50.387560000000001,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C56:C84)","v":121995.10925217617},{"$f":"SUM(D56:D84)","v":107714.61977712082},{"$f":"SUM(E56:E84)","v":107683.58666334974},{"$f":"SUM(F56:F84)","v":108186.746075478},{"$f":"SUM(G56:G84)","v":108389.92335687819},{"$f":"SUM(H56:H79)","v":140401.32687697886},140672.60703688505,140235.59207518058,170930.12648429713,165657.36386532595,165657.36386532595,{"$f":"SUM(N56:N79)","v":166285.92948944398},166690.15766092736,124883.50054559291]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,259331.31984714375,136165.98498056631,136165.98498056631,136165.98498056631,136165.98498056631,136165.98498056631,{"$f":"TotalCoreVolume*SetUp!K5","v":164830.56995935214},"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,{"$f":"SUM(C89:C94)","v":372042.57581360283},{"$f":"SUM(D89:D94)","v":475248.57632622559},475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,259331.31984714375,259331.31984714375,136165.98498056631,136165.98498056631,136165.98498056631,{"$f":"SUM(N89:N94)","v":136165.98498056631},136165.98498056631,164830.56995935214]
[]
["Total Authorized Revenue",null,{"$f":"C51+C85+C95","v":1048042.1289632095},1229283.4251168789,1229252.3920031078,1229992.1443418022,1225326.7736748643,1053552.6615547123,1061335.8920915821,1068039.4897010345,958481.61917376914,1024547.6755203301,1016979.9712483454,{"$f":"N51+N85+N95","v":1019141.2275628791},{"$f":"O51+O85+O95","v":1012062.052750407},{"$f":"P51+P85+P95","v":1028488.5382613945}]

{"sheet":"Incremental Rev Req","index":3,"n_rows":129,"n_cols":19,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2025"}]
["Reporting Date: Quarter Ended December 31"]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!O97","v":1012062.052750407}]
["Current Revenue Requirement Effective:","2025-10-01"]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented",null,null,null,null,null,null,null,null,null,null,null,null,"Authorized"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)",null,null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2026},2027,2028,2029,2030]
["Safety Affordability Reliability Proceedings",null,null,{"$f":"B6","v":"2025-10-01"},null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2026},2027,2028,2029,2030,null,null,null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUMIF($E$10:$E$88,N9,$F$10:$F$88)","v":164830.56995935214},{"$f":"SUMIF($E$10:$E$88,N9,$G$10:$G$88)","v":164830.56995935214},{"$f":"SUMIF($E$10:$E$88,N9,$H$10:$H$88)","v":164830.56995935214},{"$f":"SUMIF($E$10:$E$88,N9,$I$10:$I$88)","v":164830.56995935214},{"$f":"SUMIF($E$10:$E$88,N9,$J$10:$J$88)","v":164830.56995935214}]
[{"$f":"'Authorized Rev Req'!A9","v":"Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B9","v":"D.24-12-074"},{"$f":"F10","v":491182.11962129368},{"$f":"'Authorized Rev Req'!Q9","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!P9","v":491182.11962129368},{"$f":"F10*1.03","v":505917.58320993249},{"$f":"G10","v":505917.58320993249},{"$f":"H10","v":505917.58320993249},505917.58320993249,"Existing",null,null,"Allocated Base Margin",491182.11962129368,505917.58320993249,505917.58320993249,505917.58320993249,505917.58320993249]
[{"$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"},28089.390822925208,{"$f":"'Authorized Rev Req'!Q10","v":"ECPT"},{"$f":"'Authorized Rev Req'!P10","v":28089.390822925208},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Distribution",76412.12476454323,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"},23067.973570493206,{"$f":"'Authorized Rev Req'!Q11","v":"Seasonal Storage"},{"$f":"'Authorized Rev Req'!P11","v":23067.973570493206},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"All Residential",3351.4289792476015,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,"},13438.415589853987,{"$f":"'Authorized Rev Req'!Q12","v":"ECPT"},{"$f":"'Authorized Rev Req'!P12","v":13438.415589853987},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Local Transmission",2457.9829280886029,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"},1464.6924600000004,{"$f":"'Authorized Rev Req'!Q13","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!P13","v":1464.6924600000004},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Seasonal Storage",23067.973570493206,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"},9677.4329804631216,{"$f":"'Authorized Rev Req'!Q14","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P14","v":9677.4329804631216},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"GHG End User",46940.699533626255,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"},315.2382616949493,{"$f":"'Authorized Rev Req'!Q15","v":"ECPT"},{"$f":"'Authorized Rev Req'!P15","v":315.2382616949493},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Public Purpose Programs",85907.16733465514,85907.168000000005,85907.168000000005,85907.168000000005,85907.168000000005]
[{"$f":"'Authorized Rev Req'!A16","v":"SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B16","v":"D.24-07-009, AL 3383, AL 3392-G-A"},37.268490301980989,{"$f":"'Authorized Rev Req'!Q16","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!P16","v":37.268490301980989},{"$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":"CFCA"},null,{"$f":"'Authorized Rev Req'!B17","v":"D.24-07-009, AL 3383, AL 3392-G-A, AL 6538"},21078.929369858219,{"$f":"'Authorized Rev Req'!Q17","v":"CFCA"},{"$f":"'Authorized Rev Req'!P17","v":21078.929369858219},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"46% Res (LUAF, Other)",13393.927954426295,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A18","v":"CFCA -NGV only"},null,{"$f":"'Authorized Rev Req'!B18","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-1668.0723758234942,{"$f":"'Authorized Rev Req'!Q18","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P18","v":-1668.0723758234942},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"ECPT",51080.337632811963,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"CFCA - C&I shortfall only"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!Q19","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P19","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"EPAM",57016.603773151815,18646.06288530086,33104.185232387521,36790.392063089501,40179.654454651602]
[{"$f":"'Authorized Rev Req'!A20","v":"Hazardous Substance Cleanup Cost Acct HSCCA"},null,{"$f":"'Authorized Rev Req'!B20","v":"D.24-07-009, AL 3383, AL 3392-G-A"},87.306743808495682,{"$f":"'Authorized Rev Req'!Q20","v":"ECPT"},{"$f":"'Authorized Rev Req'!P20","v":87.306743808495682},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"CFCA",21078.929369858219,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B21","v":"D.24-07-009, AL 3383, AL 3392-G-A"},16316.089710564167,{"$f":"'Authorized Rev Req'!Q21","v":"EPAM"},{"$f":"'Authorized Rev Req'!P21","v":16316.089710564167},18646.06288530086,33104.185232387521,36790.392063089501,40179.654454651602,"Existing","FFU",null,"Non-Residential",-12442.025113351872,0,0,0,0]
[{"$f":"'Authorized Rev Req'!A22","v":"PBOPBA"},null,{"$f":"'Authorized Rev Req'!B22","v":"D.24-07-009, AL 3383, AL 3392-G-A"},5199.3733783365324,{"$f":"'Authorized Rev Req'!Q22","v":"EPAM"},{"$f":"'Authorized Rev Req'!P22","v":5199.3733783365324},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",1.0239463418616617,null,"Total",{"$f":"SUM(O9:O22)","v":1024277.8403081964},{"$f":"SUM(P9:P22)","v":775301.38405458548},{"$f":"SUM(Q9:Q22)","v":789759.50640167214},{"$f":"SUM(R9:R22)","v":793445.71323237417},{"$f":"SUM(S9:S22)","v":796834.97562393628}]
[{"$f":"'Authorized Rev Req'!A23","v":"Pension BA"},null,{"$f":"'Authorized Rev Req'!B23","v":"D.24-07-009, AL 3383, AL 3392-G-A"},7663.477830061016,{"$f":"'Authorized Rev Req'!Q23","v":"EPAM"},{"$f":"'Authorized Rev Req'!P23","v":7663.477830061016},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":3.5000000000000001E-3}]
[{"$f":"'Authorized Rev Req'!A24","v":"Safety Enhancement Balancing Account - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B24","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1684.4906119844525,{"$f":"'Authorized Rev Req'!Q24","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!P24","v":1684.4906119844525},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing",null,null,"Check",{"$f":"O23-F89","v":0},{"$f":"P23-G89","v":0},{"$f":"Q23-H89","v":0},{"$f":"R23-I89","v":0},{"$f":"S23-J89","v":0}]
[{"$f":"'Authorized Rev Req'!A25","v":"Safety Enhancement Balancing Account - Distribution"},null,{"$f":"'Authorized Rev Req'!B25","v":"D.24-07-009, AL 3383, AL 3392-G-A"},50453.415825049553,{"$f":"'Authorized Rev Req'!Q25","v":"Distribution"},{"$f":"'Authorized Rev Req'!P25","v":50453.415825049553},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A26","v":"Rewards & Penalties Bal Acct  RPBA"},null,{"$f":"'Authorized Rev Req'!B26","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-53.411184447550312,{"$f":"'Authorized Rev Req'!Q26","v":"EPAM"},{"$f":"'Authorized Rev Req'!P26","v":-53.411184447550312},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A27","v":"SGPMA - Rev Req for NEXT Year"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!Q27","v":"ECPT"},{"$f":"'Authorized Rev Req'!P27","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A28","v":"Integrated Transmission  Margin ITBA"},null,{"$f":"'Authorized Rev Req'!B28","v":"D.24-07-009, AL 3383, AL 3392-G-A"},2620.229452417324,{"$f":"'Authorized Rev Req'!Q28","v":"ECPT"},{"$f":"'Authorized Rev Req'!P28","v":2620.229452417324},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A29","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-3149.205606080563,{"$f":"'Authorized Rev Req'!Q29","v":"EPAM"},{"$f":"'Authorized Rev Req'!P29","v":-3149.205606080563},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A30","v":"Residential Uncollectible Balancing Account"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.24-07-009, AL 3383, AL 3392-G-A"},23136.287109251356,{"$f":"'Authorized Rev Req'!Q30","v":"EPAM"},{"$f":"'Authorized Rev Req'!P30","v":23136.287109251356},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A31","v":"NFCA -Margin Only"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1428.7491839719685,{"$f":"'Authorized Rev Req'!Q31","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P31","v":1428.7491839719685},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A32","v":"NFCA -Nonmargin Other"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.24-07-009, AL 3383, AL 3392-G-A, AL 3447-G, AL 6538"},-287.5986854868093,{"$f":"'Authorized Rev Req'!Q32","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P32","v":-287.5986854868093},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A33","v":"NFCA -Nonmargin SCG"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1526.3273094049953,{"$f":"'Authorized Rev Req'!Q33","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P33","v":1526.3273094049953},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A34","v":"Minimum Bil/Customer Charge Revenue "},null,{"$f":"'Authorized Rev Req'!B34","v":"D.24-07-009, AL 3383, AL 3392-G-A"},1428.2529999999999,{"$f":"'Authorized Rev Req'!Q34","v":"All Residential"},{"$f":"'Authorized Rev Req'!P34","v":1428.2529999999999},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A35","v":"Borrego Revenue"},null,{"$f":"'Authorized Rev Req'!B35","v":"D.24-07-009, AL 3383, AL 3392-G-A"},59.438824546069831,{"$f":"'Authorized Rev Req'!Q35","v":"All Residential"},{"$f":"'Authorized Rev Req'!P35","v":59.438824546069831},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A36","v":"Employee Discount (Schd GR)"},null,{"$f":"'Authorized Rev Req'!B36","v":"D.24-07-009, AL 3383, AL 3392-G-A"},-606.06691000001092,{"$f":"'Authorized Rev Req'!Q36","v":"All Residential"},{"$f":"'Authorized Rev Req'!P36","v":-606.06691000001092},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A37","v":"SDFFD"},null,{"$f":"'Authorized Rev Req'!B37","v":"D.24-07-009, AL 3383, AL 3392-G-A"},2469.8040647015428,{"$f":"'Authorized Rev Req'!Q37","v":"All Residential"},{"$f":"'Authorized Rev Req'!P37","v":2469.8040647015428},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A38","v":"Customer Information System  Account - CISBA"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!Q38","v":"EPAM"},{"$f":"'Authorized Rev Req'!P38","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A39","v":"Transition, Stabilization and OCM Balancing Account - TSOBA-G "},null,{"$f":"'Authorized Rev Req'!B39","v":"AL 3039-G, D.24-07-009, AL 3383, AL 3392-G-A"},0,{"$f":"'Authorized Rev Req'!Q39","v":"EPAM"},{"$f":"'Authorized Rev Req'!P39","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A40","v":"Percentage of Income Payment Plan Balancing Account (PIPPBA)"},null,{"$f":"'Authorized Rev Req'!B40","v":"D. 21-10-012,  D.24-07-009, AL 3383, AL 3392-G-A"},1832.4144818159566,"ECPT",{"$f":"'Authorized Rev Req'!P40","v":1832.4144818159566},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A41","v":"Gain/Loss on Sale Memo Acct GLOSMA"},null,{"$f":"'Authorized Rev Req'!B41","v":" D.24-07-009, AL 3383, AL 3392-G-A"},0,"EPAM",{"$f":"'Authorized Rev Req'!P41","v":0},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A42","v":"Transmission Integrity Management Program Memorandum Account  (TIMPBA)"},null,{"$f":"'Authorized Rev Req'!B42","v":"AL 3312-G,D.24-07-009, AL 3383, AL 3392-G-A, AL 3431"},{"$f":"F43","v":0},"Local Transmission",{"$f":"'Authorized Rev Req'!P42","v":0},0,0,0,0,"Existing"]
[{"$f":"'Authorized Rev Req'!A43","v":"Cost of Capital Adjustment (Subtracted from Base Margin)"},null,{"$f":"'Authorized Rev Req'!B43","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F44","v":-7916.0000000000018},"EPAM",{"$f":"'Authorized Rev Req'!P43","v":-7916.0000000000018},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A44","v":"General Rate Case Revenue Requirement Memorandum Account  (GRCMA)"},null,"D.24-12-074,AL 3392-G-A",{"$f":"F45","v":18415.516233662707},"EPAM",{"$f":"'Authorized Rev Req'!P44","v":18415.516233662707}]
[{"$f":"'Authorized Rev Req'!A45","v":"  GRCRRMA Sub allocation for AB32 Admin Fees"},null,{"$f":"'Authorized Rev Req'!B45","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F46","v":341.24933333333291},"ECPT",{"$f":"'Authorized Rev Req'!P45","v":341.24933333333291},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A46","v":"  GRCRRMA PSEP Local Transmission"},null,{"$f":"'Authorized Rev Req'!B46","v":"D.24-12-074,AL 3392-G-A"},-728.46863419783074,"Local Transmission",{"$f":"'Authorized Rev Req'!P46","v":-728.46863419783074},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A47","v":"  GRCRRMA PSEP Distribution"},null,{"$f":"'Authorized Rev Req'!B47","v":"D.24-12-074,AL 3392-G-A"},{"$f":"F48","v":10114.384939493688},"Distribution",{"$f":"'Authorized Rev Req'!P47","v":10114.384939493688},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A48","v":"Pipeline Safety Enhancement Plan (PSEP) -Distribution (subtracted from Base Margin and allocated here)"},null,"D.24-12-074,AL 3392-G-A",{"$f":"F49","v":15844.324000000001},"Distribution",{"$f":"'Authorized Rev Req'!P48","v":15844.324000000001},null,null,null,null,"New"]
[{"$f":"'Authorized Rev Req'!A49","v":"Distribution Integrity Management Program Memorandum Account  (DIMPBA)"},null,"D.24-12-074,AL 3392-G-A",0,"Distribution",{"$f":"'Authorized Rev Req'!P49","v":0},null,null,null,null,"New"]
[]
[{"$f":"'Authorized Rev Req'!A55","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A56","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B56","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},{"$f":"F53","v":80558.905121358897},{"$f":"'Authorized Rev Req'!Q56","v":"GHG End User"},{"$f":"'Authorized Rev Req'!P56","v":80558.905121358897},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A57","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B57","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},3600.4283616059961,{"$f":"'Authorized Rev Req'!Q57","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P57","v":3600.4283616059961},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A58","v":"AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B58","v":"D.19-09-051"},1120.6077352361037,{"$f":"'Authorized Rev Req'!Q58","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P58","v":1120.6077352361037},{"$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) - Company Gas Compressor"},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"},4356.092946962709,{"$f":"'Authorized Rev Req'!Q59","v":"ECPT"},{"$f":"'Authorized Rev Req'!P59","v":4356.092946962709},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A60","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B60","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-33618.205587732642,{"$f":"'Authorized Rev Req'!Q60","v":"GHG End User"},{"$f":"'Authorized Rev Req'!P60","v":-33618.205587732642},{"$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) - LUAF"},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"},-1076.4407942506293,{"$f":"'Authorized Rev Req'!Q61","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P61","v":-1076.4407942506293},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A62","v":"FERC Settlement Proceeds MA"},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"},0,{"$f":"'Authorized Rev Req'!Q62","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P62","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A63","v":"New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount"},null,{"$f":"'Authorized Rev Req'!B63","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'!Q63","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P63","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A64","v":"New Environmental Regulation Balancing Account (NERBA) - LDAR EPAM"},null,{"$f":"'Authorized Rev Req'!B64","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B"},0,{"$f":"'Authorized Rev Req'!Q64","v":"EPAM"},{"$f":"'Authorized Rev Req'!P64","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A65","v":"  TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B65","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},-13441.430545418532,{"$f":"'Authorized Rev Req'!Q65","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!P65","v":-13441.430545418532},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A66","v":"CSI Thermal Program memoradum Account"},null,{"$f":"'Authorized Rev Req'!B66","v":"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B"},71.89967137170234,{"$f":"'Authorized Rev Req'!Q66","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!P66","v":71.89967137170234},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A67","v":"Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  "},null,{"$f":"'Authorized Rev Req'!B67","v":"D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B"},0,"ECPT",{"$f":"'Authorized Rev Req'!P67","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A68","v":"Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)"},null,{"$f":"'Authorized Rev Req'!B68","v":"D.22-02-025, 3247-G-B"},71.899671371702354,"EPAM",{"$f":"'Authorized Rev Req'!P68","v":71.899671371702354},0,0,0,{"$f":"0","v":0},"Existing"]
[{"$f":"'Authorized Rev Req'!A69","v":"SDG&E NGLAPBA"},null,{"$f":"'Authorized Rev Req'!B69","v":" AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A"},{"$f":"F66","v":-553.3470608437583},"EPAM",{"$f":"'Authorized Rev Req'!P69","v":-553.3470608437583}]
[{"$f":"'Authorized Rev Req'!A70","v":"SDG&ENERBA - NGLAP Subacct"},null,{"$f":"'Authorized Rev Req'!B70","v":" AL 3071-G, D.24-07-009, AL 3383, AL 3392-G-A"},-2114.0763087237883,"EPAM",{"$f":"'Authorized Rev Req'!P70","v":-2114.0763087237883}]
["PPPS Programs"]
[{"$f":"'Authorized Rev Req'!A73","v":"California Alternate Rates for Energy (CARE) - Funding"},null,{"$f":"'Authorized Rev Req'!B73","v":"AL 3137-G, D.21-06-015, 3245-G, 3462-G"},{"$f":"F69","v":22811.164566316405},{"$f":"'Authorized Rev Req'!Q73","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P73","v":22811.164566316405},22811.165000000001,{"$f":"G69","v":22811.165000000001},{"$f":"H69","v":22811.165000000001},{"$f":"I69","v":22811.165000000001},"Existing"]
[{"$f":"'Authorized Rev Req'!A74","v":"California Alternate Rates for Energy (CARE) - Admin Expenses"},null,{"$f":"'Authorized Rev Req'!B74","v":"AL 3137-G, D.21-06-015, 3245-G, 3462-G"},743.89099999999996,{"$f":"'Authorized Rev Req'!Q74","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P74","v":743.89099999999996},743.89099999999996,{"$f":"G70","v":743.89099999999996},{"$f":"H70","v":743.89099999999996},743.89099999999996,"Existing"]
[{"$f":"'Authorized Rev Req'!A75","v":"California Alternate Rates for Energy (CARE) - Amortization"},null,{"$f":"'Authorized Rev Req'!B75","v":"AL 3137-G, AL 3245-G, AL 3247-G-B, 3462-G"},0,{"$f":"'Authorized Rev Req'!Q75","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P75","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},0,"Existing"]
[{"$f":"'Authorized Rev Req'!A76","v":"Energy Savings Assistance (ESA/LIEE/DAP)"},null,{"$f":"'Authorized Rev Req'!B76","v":"AL 3137-G, D.21-06-015, AL 3247-G-B, 3462-G"},15138.709320357639,{"$f":"'Authorized Rev Req'!Q76","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P76","v":15138.709320357639},15138.709000000001,{"$f":"G72","v":15138.709000000001},{"$f":"H72","v":15138.709000000001},{"$f":"I72","v":15138.709000000001},"Existing"]
[{"$f":"'Authorized Rev Req'!A77","v":"Energy Efficiency"},null,{"$f":"'Authorized Rev Req'!B77","v":"D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G, "},45917.596267981098,{"$f":"'Authorized Rev Req'!Q77","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P77","v":45917.596267981098},45917.595999999998,{"$f":"G73","v":45917.595999999998},{"$f":"H73","v":45917.595999999998},45917.595999999998,"Existing"]
[{"$f":"'Authorized Rev Req'!A78","v":"RD&D "},null,{"$f":"'Authorized Rev Req'!B78","v":"AL 3137-G, AL 3245-G, 3462-G"},1245.4186200000001,{"$f":"'Authorized Rev Req'!Q78","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P78","v":1245.4186200000001},1245.4190000000001,{"$f":"G74","v":1245.4190000000001},{"$f":"H74","v":1245.4190000000001},{"$f":"I74","v":1245.4190000000001},"Existing"]
[{"$f":"'Authorized Rev Req'!A79","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B79","v":"AL 3137-G, AL 3245-G, 3462-G"},50.387560000000001,{"$f":"'Authorized Rev Req'!Q79","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!P79","v":50.387560000000001},50.387999999999998,{"$f":"G75","v":50.387999999999998},{"$f":"H75","v":50.387999999999998},{"$f":"I75","v":50.387999999999998},"Existing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B89","v":"D.97-07-061"},{"$f":"F85","v":164830.56995935214},{"$f":"'Authorized Rev Req'!Q89","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!P89","v":164830.56995935214},{"$f":"F85","v":164830.56995935214},164830.56995935214,164830.56995935214,164830.56995935214,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D10:D88)","v":1024277.8403081961},null,{"$f":"SUM(F10:F88)","v":1024277.8403081961},{"$f":"SUM(G10:G88)","v":775301.38405458559},{"$f":"SUM(H10:H88)","v":789759.50640167226},{"$f":"SUM(I10:I88)","v":793445.71323237417},{"$f":"SUM(J10:J88)","v":796834.97562393628}]
[]
["CPUC Fee",null,null,null,"CPUC Fee",{"$f":"RegulatoryFee","v":3.5000000000000001E-3},null,null,null,null,null,null,"FFU"]
[null,null,null,null,null,null,null,null,null,null,null,"Jan",1.0230106000000001]
[null,null,null,null,null,null,null,null,null,null,null,"Feb",1.0239463418616599]
["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":2026},2027,2028,2029,2030,null,"Include in Impact"]
["2024 GRC Track 3 (PSEP and WMPMA)","A.25-05-015/016","Application",{"$f":"SUM(F97:J97)","v":50051},"EPAM",50051,null,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A97,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
["GRC PFM","A.25-05-015/016","Application",23678.528629484725,"EPAM",{"$f":"11803423/1000","v":11803.423000000001},11875.105629484722,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A98,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Authorized + Pending"]
["GRC Track 2 Proposed Decision - SDG&E 2024","A.22-05-015 ","Application",-3815,"EPAM",-3815,null,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A99,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,null,{"$f":"TRANSPOSE(YearsForRateImpact)","v":2026},2027,2028,2029,2030]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A100,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,{"$f":"RevRecoveryMechanisms","v":"Core Procurement"},{"$f":"SUM(O9,SUMIFS(F$97:F$124,$E$97:$E$124,$N100,$L$97:$L$124,\"y\"))","v":164830.56995935214},{"$f":"SUM(P9,SUMIFS(G$97:G$124,$E$97:$E$124,$N100,$L$97:$L$124,\"y\"))","v":164830.56995935214},{"$f":"SUM(Q9,SUMIFS(H$97:H$124,$E$97:$E$124,$N100,$L$97:$L$124,\"y\"))","v":164830.56995935214},{"$f":"SUM(R9,SUMIFS(I$97:I$124,$E$97:$E$124,$N100,$L$97:$L$124,\"y\"))","v":164830.56995935214},{"$f":"SUM(S9,SUMIFS(J$97:J$124,$E$97:$E$124,$N100,$L$97:$L$124,\"y\"))","v":164830.56995935214}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A101,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Allocated Base Margin",{"$f":"SUM(O10,SUMIFS(F$97:F$124,$E$97:$E$124,$N101,$L$97:$L$124,\"y\"))","v":491182.11962129368},505917.58320993249,505917.58320993249,{"$f":"SUM(R10,SUMIFS(I$97:I$124,$E$97:$E$124,$N101,$L$97:$L$124,\"y\"))","v":505917.58320993249},505917.58320993249]
[null,null,null,null,null,null,null,null,null,null,null,"N",null,"Distribution",{"$f":"SUM(O11,SUMIFS(F$97:F$124,$E$97:$E$124,$N102,$L$97:$L$124,\"y\"))","v":76412.12476454323},{"$f":"SUM(P11,SUMIFS(G$97:G$124,$E$97:$E$124,$N102,$L$97:$L$124,\"y\"))","v":0},0,0,{"$f":"SUM(S11,SUMIFS(J$97:J$124,$E$97:$E$124,$N102,$L$97:$L$124,\"y\"))","v":0}]
["Public Policy Proceedings",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A103,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"-"},null,"All Residential",{"$f":"SUM(O12,SUMIFS(F$97:F$124,$E$97:$E$124,$N103,$L$97:$L$124,\"y\"))","v":3351.4289792476015},0,0,0,0]
["Cost Allocation Proceeding","A.25-09-014","Application",null,null,null,null,null,null,null,"New",{"$f":"IFERROR(VLOOKUP(A104,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"N"},null,"Local Transmission",{"$f":"SUM(O13,SUMIFS(F$97:F$124,$E$97:$E$124,$N104,$L$97:$L$124,\"y\"))","v":2457.9829280886029},0,0,0,0]
[null,null,null,{"$f":"SUM(F105:J105)","v":0},null,0,0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A105,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Seasonal Storage",{"$f":"SUM(O14,SUMIFS(F$97:F$124,$E$97:$E$124,$N105,$L$97:$L$124,\"y\"))","v":23067.973570493206},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":"Y"},null,"GHG End User",{"$f":"SUM(O15,SUMIFS(F$97:F$124,$E$97:$E$124,$N106,$L$97:$L$124,\"y\"))","v":46940.699533626255},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A107,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Public Purpose Programs",{"$f":"SUM(O16,SUMIFS(F$97:F$124,$E$97:$E$124,$N107,$L$97:$L$124,\"y\"))","v":85907.16733465514},85907.168000000005,85907.168000000005,85907.168000000005,85907.168000000005]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A108,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"-",{"$f":"SUM(O17,SUMIFS(F$97:F$124,$E$97:$E$124,$N108,$L$97:$L$124,\"y\"))","v":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":"Y"},null,"46% Res (LUAF, Other)",{"$f":"SUM(O18,SUMIFS(F$97:F$124,$E$97:$E$124,$N109,$L$97:$L$124,\"y\"))","v":13393.927954426295},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":"Y"},null,"ECPT",{"$f":"SUM(O19,SUMIFS(F$97:F$124,$E$97:$E$124,$N110,$L$97:$L$124,\"y\"))","v":51080.337632811963},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A111,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"EPAM",{"$f":"SUM(O20,SUMIFS(F$97:F$124,$E$97:$E$124,$N111,$L$97:$L$124,\"y\"))","v":115056.02677315183},30521.168514785582,33104.185232387521,36790.392063089501,40179.654454651602]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A112,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"CFCA",{"$f":"SUM(O21,SUMIFS(F$97:F$124,$E$97:$E$124,$N112,$L$97:$L$124,\"y\"))","v":21078.929369858219},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A113,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Non-Residential",{"$f":"SUM(O22,SUMIFS(F$97:F$124,$E$97:$E$124,$N113,$L$97:$L$124,\"y\"))","v":-12442.025113351872},{"$f":"SUM(P22,SUMIFS(G$97:G$124,$E$97:$E$124,$N113,$L$97:$L$124,\"y\"))","v":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":"Y"},null,"Total",{"$f":"SUM(O100:O113)","v":1082317.2633081963},{"$f":"SUM(P100:P113)","v":787176.48968407023},{"$f":"SUM(Q100:Q113)","v":789759.50640167214},{"$f":"SUM(R100:R113)","v":793445.71323237417},{"$f":"SUM(S100:S113)","v":796834.97562393628}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A115,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"Incremental Revenues",{"$f":"O114-O23","v":58039.422999999952},{"$f":"P114-P23","v":11875.105629484751},{"$f":"Q114-Q23","v":0},{"$f":"R114-R23","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A116,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"},null,"CPUC Fee",{"$f":"RegulatoryFee","v":3.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":"Y"},null,"Check Figure",{"$f":"ROUND(O115,6)-ROUND(F125,6)","v":0},{"$f":"ROUND(P115,6)-SUM(G97:G124)","v":-4.8472247726749629E-7},{"$f":"ROUND(Q115,6)-SUM(H97:H124)","v":0},{"$f":"ROUND(R115,6)-SUM(I97:I124)","v":0},{"$f":"ROUND(S115,6)-SUM(J97:J124)","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":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A119,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A120,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A121,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A122,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A123,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
[null,null,null,{"$f":"SUM(F124:J124)","v":0}]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D97:D124)","v":69914.528629484732},null,{"$f":"SUM(F97:F124)","v":58039.423000000003},{"$f":"SUM(G97:G124)","v":11875.105629484722},{"$f":"SUM(H97:H124)","v":0},{"$f":"SUM(I97:I124)","v":0},{"$f":"SUM(J97:J124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A124,Summary!$B$7:$D$18,3,FALSE),\"-\")","v":"Y"}]
["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":2026},2027,2028,2029,2030]

{"sheet":"SAR and RAR","index":4,"n_rows":34,"n_cols":30,"rows_kept":34,"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":164830.56995935214},{"$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":164830.56995935214},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":491182.11962129368},{"$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":491182.11962129368},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":76412.12476454323},{"$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":76412.12476454323},null,"Residential",0.57246929564900972,0.81652373633254627,0.71351095116714947,1,0.51543343712031298,0.74052031744563351,0.49735087986604948,0.45465574087968463,null,0.43914119669235535,0.33016648110968039,0.81652373633254627,0.60198759162917603,0,{"$f":"RegulatoryFee","v":3.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":3351.4289792476015},{"$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":3351.4289792476015}]
[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":2457.9829280886029},{"$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":2457.9829280886029},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":23067.973570493206},{"$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":23067.973570493206},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":46940.699533626255},{"$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":46940.699533626255},null,"Residential",{"$f":"G5*G10","v":94360.440286055149},{"$f":"H5*H10","v":401061.85953291837},{"$f":"I5*I10","v":54520.887821452139},3351.4289792476015,1266.9265890077597,17082.303111249112,23345.998214576877,39058.186811412677,{"$f":"O5*O10","v":0},5881.8255503179544,{"$f":"Q5*Q10","v":16865.015330119906},{"$f":"R5*R10","v":46555.410345846278},{"$f":"S5*S10","v":12689.253925482455},{"$f":"T5*T10","v":0},{"$f":"SUM(G9:T9)","v":716039.53649768629},"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":85907.16733465514},{"$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":85907.16733465514},null,"Total System",{"$f":"C3","v":164830.56995935214},{"$f":"C4","v":491182.11962129368},{"$f":"C5","v":76412.12476454323},{"$f":"C6","v":3351.4289792476015},{"$f":"C7","v":2457.9829280886029},{"$f":"C8","v":23067.973570493206},{"$f":"C9","v":46940.699533626255},{"$f":"C10","v":85907.16733465514},{"$f":"C11","v":0},{"$f":"C12","v":13393.927954426295},{"$f":"C13","v":51080.337632811963},{"$f":"C14","v":57016.603773151815},{"$f":"C15","v":21078.929369858219},{"$f":"C16","v":-12442.025113351872},{"$f":"SUM(G10:T10)","v":1024277.8403081964},{"$f":"U10-C17","v":0},{"$f":"RegulatoryFee","v":3.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":13393.927954426295},{"$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":13393.927954426295},null,"Residential",{"$f":"G5*G13","v":94360.440286055149},{"$f":"H5*H13","v":401061.85953291837},54520.887821452139,3351.4289792476015,1266.9265890077597,17082.303111249112,23345.998214576877,39058.186811412677,{"$f":"O5*O13","v":0},5881.8255503179544,{"$f":"Q5*Q13","v":16865.015330119906},{"$f":"R5*R13","v":93945.976868391401},{"$f":"S5*S13","v":12689.253925482455},{"$f":"T5*T13","v":0},{"$f":"SUM(G12:T12)","v":763430.10302023136},"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":51080.337632811963},{"$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":51080.337632811963},null,"Total System",{"$f":"D3","v":164830.56995935214},{"$f":"D4","v":491182.11962129368},{"$f":"D5","v":76412.12476454323},{"$f":"D6","v":3351.4289792476015},{"$f":"D7","v":2457.9829280886029},{"$f":"D8","v":23067.973570493206},{"$f":"D9","v":46940.699533626255},{"$f":"D10","v":85907.16733465514},{"$f":"D11","v":0},{"$f":"D12","v":13393.927954426295},{"$f":"D13","v":51080.337632811963},{"$f":"D14","v":115056.02677315183},{"$f":"D15","v":21078.929369858219},{"$f":"D16","v":-12442.025113351872},{"$f":"SUM(G13:T13)","v":1082317.2633081963},{"$f":"U13-D17","v":0},{"$f":"RegulatoryFee","v":3.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":57016.603773151815},{"$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":115056.02677315183},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":21078.929369858219},{"$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":21078.929369858219},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":-12442.025113351872},{"$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":-12442.025113351872},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":1024277.8403081964},{"$f":"SUM(D3:D16)","v":1082317.2633081963},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":3.5000000000000001E-3},{"$f":"C18","v":3.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":621679.0962116312},null,{"$f":"SUMPRODUCT(H12:T12,H19:T19)","v":669069.66273417627},null,{"$f":"SUMPRODUCT(G9,G19)","v":94360.440286055149},{"$f":"SUMPRODUCT(G12,G19)","v":94360.440286055149}]
[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":859447.27034884412},null,{"$f":"SUMPRODUCT(H13:T13,H20:T20)","v":917486.69334884407},null,{"$f":"SUMPRODUCT(G10,G20)","v":164830.56995935214},{"$f":"SUMPRODUCT(G13,G20)","v":164830.56995935214}]
[]
[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":"01/01/2026 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":"01/01/2026 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},229.73771969948896,{"$f":"(U19/C23*100)+(Y19/D23*100)","v":264.90083490811179},{"$f":"(W19/C23*100)+(Z19/D23*100)","v":282.41372983171749},{"$f":"H28/G28-1","v":0.1530576487597175},{"$f":"I28/G28-1","v":0.22928759892425155},null,null,null,null,"Residential",{"$f":"C23","v":270603.84207905678},229.73771969948896,{"$f":"U9/Q28*100","v":264.60804510251398},{"$f":"U12/Q28*100","v":282.12094002611968},{"$f":"S28/R28-1","v":0.15178319628416936},{"$f":"T28/R28-1","v":0.22801314644870319}]
[null,2021,23945.842837510012,null,"Total System",{"$f":"D24","v":413767.70037365775},104.86202958917985,{"$f":"(U20/C24*100)+(Y20/D24*100)","v":144.69852958917986},{"$f":"(W20/C24*100)+(Z20/D24*100)","v":151.77997821545168},{"$f":"H29/G29-1","v":0.37989442085060032},{"$f":"I29/G29-1","v":0.44742552485473763},null,null,null,null,"Total System",{"$f":"C24","v":819598.16505165747},104.86202958917985,{"$f":"U10/Q29*100","v":124.97317392647389},{"$f":"U13/Q29*100","v":132.05462255274574},{"$f":"S29/R29-1","v":0.19178671647004997},{"$f":"T29/R29-1","v":0.2593178204741875}]
[null,2022,25613.07213654686,null,null,null,null,"cents/therm"]
[null,2023,22795.559340745884]
[null,2024,21383.37754112266]
[null,2025,19135.75612917971]
[null,2026,23555.056]

{"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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},"Proposed","Proposed","Proposed","Proposed",null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-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.5494747527979991,{"$f":"F7*E7","v":479197.56527410826},{"$f":"((Y10-I12-T12)/SUM(E7,F9/F7*E9,P7*((Q7/F7)),P9*((Q9/F7))))","v":2.2662488575326583},{"$f":"E7*H7","v":425962.61588510982},{"$f":"((Y13-K12-V12)/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*((Q7/F7)),SUM(P9)*(Q9/F7)))","v":2.4162389233952997},{"$f":"E7*J7","v":454154.64810578566},null,null,null,{"$f":"D7","v":"Baseline"},34568.659520669324,2.0180706682237539,{"$f":"Q7*P7","v":69761.997818476579},{"$f":"H7*(1+(Q7/F7-1))","v":1.7938794417410793},{"$f":"P7*S7","v":62012.00764267573},{"$f":"J7*(1+(Q7/F7-1))","v":1.9126060743975306},{"$f":"P7*U7","v":66116.228183012179},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":805527.03390815726}]
[null,null,null,"non-Baseline",76615.611405786854,2.9226947527979994,{"$f":"F9*E9","v":223924.04543810379},{"$f":"F9/F$7*H$7","v":2.5980071531110238},{"$f":"E9*H9","v":199047.90647220879},{"$f":"F9/F$7*J$7","v":2.7699544053783627},212221.75033421602,null,null,null,{"$f":"D9","v":"non-Baseline"},14090.808851095719,2.3166466682237541,{"$f":"Q9*P9","v":32643.42537746868},{"$f":"H9*(1+(Q9/F9-1))","v":2.0592860782037716},{"$f":"P9*S9","v":29017.006497691895},{"$f":"J9*(1+(Q9/F9-1))","v":2.1955784599839814},{"$f":"P9*U9","v":30937.476397217393},null,"Change (Authorized)",{"$f":"Y10-Y8","v":-89487.497410470969}]
[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":716039.53649768629}]
[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":-42096.930887925904}]
[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":763430.10302023136}]
[]
[]
[]
[]
[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":2026},{"$f":"Summary!D2","v":2026},null,"Essential Usage",null,null,null,null,null,null,null,"2025 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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},"Authorized","w/Pending",null,"Climate Zone","Summer 2024","Winter 2024",null,null,null,null,null,null,"Non-CARE",null,"CARE"]
["Summer","Tier 1",1.953339901910218,1.953339901910218,{"$f":"H7","v":2.2662488575326583},{"$f":"J7","v":2.4162389233952997},null,{"$f":"Zones","v":"SDG&E"},11,29,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15,29,14.833333333333334,24.666666666666668]
[null,"Tier 2",2.2922466068064566,2.2922466068064566,{"$f":"H9","v":2.5980071531110238},{"$f":"J9","v":2.7699544053783627},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":1.953339901910218},{"$f":"D22","v":1.953339901910218},{"$f":"E22","v":2.2662488575326583},{"$f":"F22","v":2.4162389233952997},null,0,null,null,null,null,null,null,null,0]
[null,"Tier 2",{"$f":"C23","v":2.2922466068064566},{"$f":"D23","v":2.2922466068064566},{"$f":"E23","v":2.5980071531110238},2.7699544053783627]
[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":2026},{"$f":"Summary!D2","v":2026},null,null,null,null,null,null,null,null,null,"2021-2025 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":"2026-01-01"},{"$f":"CurrentEffectiveRateDate","v":"2026-01-01"},"Authorized","w/Pending",null,null,null,null,null,null,null,null,null,null,"Non-CARE",null,"CARE"]
["Summer","Tier 1",1.5431403054998933,1.5431403054998933,{"$f":"S7","v":1.7938794417410793},{"$f":"U7","v":1.9126060743975306},null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},15.367753039946335,32.083872604825636,14.748357547885229,26.37825981653603]
[null,"Tier 2",1.8142656694168842,1.8142656694168842,{"$f":"S9","v":2.0592860782037716},{"$f":"U9","v":2.1955784599839814},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.5431403054998933},1.778826651624575,{"$f":"E31","v":1.7938794417410793},1.9126060743975306,null,null,null,null,null,null,null,null,null,0]
[null,"Tier 2",{"$f":"C32","v":1.8142656694168842},2.0263044255832194,{"$f":"E32","v":2.0592860782037716},2.1955784599839814]
[]
[]
[]
[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":"2026-01-01"},null,{"$f":"D30","v":"2026-01-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$91*$Q22)+IF(Q22>0,$F$12,0)","v":30.708225348238226},{"$f":"IF($R22>$J22,C$25*$J22+C$26*($R22-$J22),$R22*C$25)+('Incremental Rev Req'!$F$91*$R22)+IF(R22>0,$F$12,0)","v":56.74835715539632},{"$f":"IF($Q22>$I22,D$22*$I22+D$23*($Q22-$I22),$Q22*D$22)+('Incremental Rev Req'!$F$91*$Q22)+IF(Q22>0,$F$12,0)","v":30.708225348238226},{"$f":"IF($R22>$J22,D$25*$J22+D$26*($R22-$J22),$R22*D$25)+('Incremental Rev Req'!$F$91*$R22)+IF(R22>0,$F$12,0)","v":56.74835715539632},{"$f":"IF($Q22>$I22,E$22*$I22+E$23*($Q22-$I22),$Q22*E$22)+('Incremental Rev Req'!$F$91*$Q22)+IF(Q22>0,$H$12,0)","v":35.373266045303339},{"$f":"IF($R22>$J22,E$25*$J22+E$26*($R22-$J22),$R22*E$25)+('Incremental Rev Req'!$F$91*$R22)+IF(R22>0,$H$12,0)","v":65.822716868447088},{"$f":"IF($Q22>$I22,F$22*$I22+F$23*($Q22-$I22),$Q22*F$22)+('Incremental Rev Req'!$F$91*$Q22)+IF(Q22>0,$J$12,0)","v":37.710945778861749},{"$f":"IF($R22>$J22,F$25*$J22+F$26*($R22-$J22),$R22*F$25)+('Incremental Rev Req'!$F$91*$R22)+IF(R22>0,$J$12,0)","v":70.172428778463697}]
[null,0,{"$f":"IF($Q23>$I23,C$22*$I23+C$23*($Q23-$I23),$Q23*C$22)+('Incremental Rev Req'!$F$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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":"2026-01-01"},null,{"$f":"D30","v":"2026-01-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$91*$S22)+IF(S22>0,$Q$12,0)","v":23.981145093263553},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Incremental Rev Req'!$F$91*$T22)+IF(T22>0,$Q$12,0)","v":38.150460868997371},{"$f":"IF($S22>$I22,D$31*$I22+D$32*($S22-$I22),$S22*D$31)+('Incremental Rev Req'!$F$91*$S22)+IF(S22>0,$Q$12,0)","v":23.981145093263553},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Incremental Rev Req'!$F$91*$T22)+IF(T22>0,$Q$12,0)","v":43.964057406739521},{"$f":"IF($S22>$I22,E$31*$I22+E$32*($S22-$I22),$S22*E$31)+('Incremental Rev Req'!$F$91*$S22)+IF(S22>0,$S$12,0)","v":27.678520492266333},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Incremental Rev Req'!$F$91*$T22)+IF(T22>0,$S$12,0)","v":44.335359562946628},{"$f":"IF($S22>$I22,F$31*$I22+F$32*($S22-$I22),$S22*F$31)+('Incremental Rev Req'!$F$91*$S22)+IF(S22>0,$U$12,0)","v":29.506967581644766},{"$f":"IF($T22>$J22,F$34*$J22+F$35*($T22-$J22),$T22*F$34)+('Incremental Rev Req'!$F$91*$T22)+IF(T22>0,$U$12,0)","v":47.263949835139094}]
[null,0,{"$f":"IF($S23>$I23,C$31*$I23+C$32*($S23-$I23),$S23*C$31)+('Incremental Rev Req'!$F$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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":"2026-01-01"},null,{"$f":"E51","v":"2026-01-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$91*$I22)+IF(I22>0,$F$12,0)","v":21.525238921012399},{"$f":"($C$25*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$F$12,0)","v":56.74835715539632},{"$f":"($D$22*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$F$12,0)","v":21.525238921012399},{"$f":"($D$25*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$F$12,0)","v":56.74835715539632},{"$f":"($E$22*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$H$12,0)","v":24.967237432859239},{"$f":"($E$25*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$H$12,0)","v":65.822716868447088},{"$f":"($F$22*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$J$12,0)","v":26.617128157348297},{"$f":"($F$25*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$J$12,0)","v":70.172428778463697}]
[null,0,{"$f":"($C$22*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($C$25*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($D$22*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$F$12,0)","v":0},{"$f":"($D$25*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$F$12,0)","v":0},{"$f":"($E$22*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$H$12,0)","v":0},{"$f":"($E$25*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$H$12,0)","v":0},{"$f":"($F$22*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$J$12,0)","v":0},{"$f":"($F$25*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($C$25*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($D$22*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$F$12,0)","v":0},{"$f":"($D$25*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$F$12,0)","v":0},{"$f":"($E$22*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$H$12,0)","v":0},{"$f":"($E$25*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$H$12,0)","v":0},{"$f":"($F$22*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$J$12,0)","v":0},{"$f":"($F$25*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$J$12,0)","v":0}]
[null,0,{"$f":"($C$22*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($C$25*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($D$22*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$F$12,0)","v":0},{"$f":"($D$25*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$F$12,0)","v":0},{"$f":"($E$22*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$H$12,0)","v":0},{"$f":"($E$25*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$H$12,0)","v":0},{"$f":"($F$22*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$J$12,0)","v":0},{"$f":"($F$25*$J25)+('Incremental Rev Req'!$F$91*$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":"2026-01-01"},null,{"$f":"E61","v":"2026-01-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$91*$I22)+IF(I22>0,$Q$12,0)","v":17.013043360498827},{"$f":"($C$34*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$Q$12,0)","v":44.852568859496905},{"$f":"($D$31*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$Q$12,0)","v":17.013043360498827},{"$f":"($D$34*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$Q$12,0)","v":51.687472897112677},{"$f":"($E$31*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$S$12,0)","v":19.771173859151872},{"$f":"($E$34*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$S$12,0)","v":52.124003810491303},{"$f":"($F$31*$I22)+('Incremental Rev Req'!$F$91*$I22)+IF(I22>0,$U$12,0)","v":21.077166818372834},{"$f":"($F$34*$J22)+('Incremental Rev Req'!$F$91*$J22)+IF(J22>0,$U$12,0)","v":55.56707615752839}]
[null,0,{"$f":"($C$31*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($C$34*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($D$31*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$Q$12,0)","v":0},{"$f":"($D$34*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$Q$12,0)","v":0},{"$f":"($E$31*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$S$12,0)","v":0},{"$f":"($E$34*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$S$12,0)","v":0},{"$f":"($F$31*$I23)+('Incremental Rev Req'!$F$91*$I23)+IF(I23>0,$U$12,0)","v":0},{"$f":"($F$34*$J23)+('Incremental Rev Req'!$F$91*$J23)+IF(J23>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($C$34*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($D$31*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$Q$12,0)","v":0},{"$f":"($D$34*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$Q$12,0)","v":0},{"$f":"($E$31*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$S$12,0)","v":0},{"$f":"($E$34*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$S$12,0)","v":0},{"$f":"($F$31*$I24)+('Incremental Rev Req'!$F$91*$I24)+IF(I24>0,$U$12,0)","v":0},{"$f":"($F$34*$J24)+('Incremental Rev Req'!$F$91*$J24)+IF(J24>0,$U$12,0)","v":0}]
[null,0,{"$f":"($C$31*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($C$34*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($D$31*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$Q$12,0)","v":0},{"$f":"($D$34*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$Q$12,0)","v":0},{"$f":"($E$31*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$S$12,0)","v":0},{"$f":"($E$34*$J25)+('Incremental Rev Req'!$F$91*$J25)+IF(J25>0,$S$12,0)","v":0},{"$f":"($F$31*$I25)+('Incremental Rev Req'!$F$91*$I25)+IF(I25>0,$U$12,0)","v":0},{"$f":"($F$34*$J25)+('Incremental Rev Req'!$F$91*$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":"2026-01-01"},null,{"$f":"E71","v":"2026-01-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$91*$Q31)+IF(Q31>0,$F$12,0)","v":31.552493141837783},{"$f":"IF($R31>$J22,C$25*$J22+C$26*($R31-$J22),$R31*C$25)+('Incremental Rev Req'!$F$91*$R31)+IF(R31>0,$F$12,0)","v":63.828147223748161},{"$f":"IF($Q31>$I22,D$22*$I22+D$23*($Q31-$I22),$Q31*D$22)+('Incremental Rev Req'!$F$91*$Q31)+IF(Q31>0,$F$12,0)","v":31.552493141837783},{"$f":"IF($R31>$J22,D$25*$J22+D$26*($R31-$J22),$R31*D$25)+('Incremental Rev Req'!$F$91*$R31)+IF(R31>0,$F$12,0)","v":63.828147223748161},{"$f":"IF($Q31>$I22,E$22*$I22+E$23*($Q31-$I22),$Q31*E$22)+('Incremental Rev Req'!$F$91*$Q31)+IF(Q31>0,$H$12,0)","v":36.329978209302048},{"$f":"IF($R31>$J22,E$25*$J22+E$26*($R31-$J22),$R31*E$25)+('Incremental Rev Req'!$F$91*$R31)+IF(R31>0,$H$12,0)","v":73.845433509184105},{"$f":"IF($Q31>$I22,F$22*$I22+F$23*($Q31-$I22),$Q31*F$22)+('Incremental Rev Req'!$F$91*$Q31)+IF(Q31>0,$J$12,0)","v":38.730892067592201},{"$f":"IF($R31>$J22,F$25*$J22+F$26*($R31-$J22),$R31*F$25)+('Incremental Rev Req'!$F$91*$R31)+IF(R31>0,$J$12,0)","v":78.725408839943}]
[null,0,{"$f":"IF($Q32>$I23,C$22*$I23+C$23*($Q32-$I23),$Q32*C$22)+('Incremental Rev Req'!$F$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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":"2026-01-01"},null,{"$f":"E81","v":"2026-01-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$91*$S31)+IF(S31>0,$Q$12,0)","v":23.826679027744252},{"$f":"IF($T31>$J22,C$34*$J22+C$35*($T31-$J22),$T31*C$34)+('Incremental Rev Req'!$F$91*$T31)+IF(T31>0,$Q$12,0)","v":40.797679821202841},{"$f":"IF($S31>$I22,D$31*$I22+D$32*($S31-$I22),$S31*D$31)+('Incremental Rev Req'!$F$91*$S31)+IF(S31>0,$Q$12,0)","v":23.826679027744252},{"$f":"IF($T31>$J22,D$34*$J22+D$35*($T31-$J22),$T31*D$34)+('Incremental Rev Req'!$F$91*$T31)+IF(T31>0,$Q$12,0)","v":47.014675494489737},{"$f":"IF($S31>$I22,E$31*$I22+E$32*($S31-$I22),$S31*E$31)+('Incremental Rev Req'!$F$91*$S31)+IF(S31>0,$S$12,0)","v":27.503233625059551},{"$f":"IF($T31>$J22,E$34*$J22+E$35*($T31-$J22),$T31*E$34)+('Incremental Rev Req'!$F$91*$T31)+IF(T31>0,$S$12,0)","v":47.41174190314667},{"$f":"IF($S31>$I22,F$31*$I22+F$32*($S31-$I22),$S31*F$31)+('Incremental Rev Req'!$F$91*$S31)+IF(S31>0,$U$12,0)","v":29.320099162245619},{"$f":"IF($T31>$J22,F$34*$J22+F$35*($T31-$J22),$T31*F$34)+('Incremental Rev Req'!$F$91*$T31)+IF(T31>0,$U$12,0)","v":50.543543866500976}]
[null,0,{"$f":"IF($S32>$I23,C$31*$I23+C$32*($S32-$I23),$S32*C$31)+('Incremental Rev Req'!$F$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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$91*$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":"2026-01-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},"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":29},"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.833333333333334},"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":24.666666666666668},"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":"2026-01-01"},{"$f":"Summary!E26","v":"2026-01-01"},"Proposed",{"$f":"Summary!H26","v":"% Change over 1/1/2026"},{"$f":"Summary!I26","v":"% Change over 1/1/2026"},null,"Customer Group",null,{"$f":"D28","v":"2026-01-01"},{"$f":"E28","v":"2026-01-01"},"Proposed",{"$f":"Summary!P26","v":"2026 Authorized"},{"$f":"Summary!Q26","v":"2026 w/Pending"}]
[null,"Residential",null,259.51483001153451,{"$f":"'Hypothetical SAR and RAR'!G28","v":259.51483001153451},{"$f":"'Hypothetical SAR and RAR'!H28","v":259.51483001153451},{"$f":"$F29/D29-1","v":0},{"$f":"$F29/E29-1","v":0},null,"Residential",null,259.22204020593676,{"$f":"'Hypothetical SAR and RAR'!R28","v":259.22204020593676},{"$f":"'Hypothetical SAR and RAR'!S28","v":259.22204020593676},{"$f":"$N29/L29-1","v":0},{"$f":"$N29/M29-1","v":0}]
[null,"System",null,144.80312026195367,{"$f":"'Hypothetical SAR and RAR'!G29","v":144.80312026195367},{"$f":"'Hypothetical SAR and RAR'!H29","v":144.80312026195367},{"$f":"$F30/D30-1","v":0},{"$f":"$F30/E30-1","v":0},null,"System",null,125.07776459924771,{"$f":"'Hypothetical SAR and RAR'!R29","v":125.07776459924771},{"$f":"'Hypothetical SAR and RAR'!S29","v":125.07776459924771},{"$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":"2026-01-01"},{"$f":"$E$28","v":"2026-01-01"},{"$f":"$F$28","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},{"$f":"$H$28","v":"% Change over 1/1/2026"}]
[null,"Non-CARE",null,{"$f":"((D41*$H$10)+(D47*$H$11))/12","v":56.911884561555979},{"$f":"((E41*$H$10)+(E47*$H$11))/12","v":56.911884561555979},56.911884561555972,{"$f":"$F35/D35-1","v":0},0]
[null,"CARE",null,{"$f":"((D42*$H$10)+(D48*$H$11))/12","v":40.498291364085809},40.498291364085809,40.498291364085809,0,0]
[null,"Total",null,{"$f":"((D43*$H$10)+(D49*$H$11))/12","v":53.935641402707773},53.935641402707773,53.935641402707766,0,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":"2025 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":"2026-01-01"},{"$f":"E28","v":"2026-01-01"},{"$f":"F28","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2026"},{"$f":"$H$28","v":"% Change over 1/1/2026"},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":39.787501291969988},{"$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.787501291969988},{"$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.787501291969981},{"$f":"$F41/D41-1","v":0},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q22","v":15},{"$f":"'Hypothetical Res Bill Impact'!R22","v":29},{"$f":"'Hypothetical Res Bill Impact'!S22","v":14.833333333333334},{"$f":"'Hypothetical Res Bill Impact'!T22","v":24.666666666666668}]
[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":31.131172911985683},{"$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":31.131172911985683},{"$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":31.131172911985683},0,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":38.217867037500781},{"$f":"E41*(1-'Hypothetical SAR and RAR'!$AA$16)+E42*'Hypothetical SAR and RAR'!$AA$16","v":38.217867037500781},{"$f":"F41*(1-'Hypothetical SAR and RAR'!$AA$16)+F42*'Hypothetical SAR and RAR'!$AA$16","v":38.217867037500781},0,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":"2026-01-01"},{"$f":"$E$28","v":"2026-01-01"},{"$f":"F40","v":"Proposed"},{"$f":"G28","v":"% Change over 1/1/2026"},{"$f":"$H$28","v":"% Change over 1/1/2026"}]
[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":74.03626783114197},{"$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":74.03626783114197},{"$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":74.036267831141956},{"$f":"$F47/D47-1","v":0},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":49.865409816185938},{"$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":49.865409816185938},{"$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":49.865409816185924},0,0]
[null,"Total",null,{"$f":"D47*(1-'Hypothetical SAR and RAR'!$AA$16)+D48*'Hypothetical SAR and RAR'!$AA$16","v":69.653415767914765},{"$f":"E47*(1-'Hypothetical SAR and RAR'!$AA$16)+E48*'Hypothetical SAR and RAR'!$AA$16","v":69.653415767914765},{"$f":"F47*(1-'Hypothetical SAR and RAR'!$AA$16)+F48*'Hypothetical SAR and RAR'!$AA$16","v":69.653415767914751},0,0]
[]
[]
[null,"Basic Bundled Essential Use Residential Monthly Average Bills"]
[null,null,null,{"$f":"D46","v":"2026-01-01"},{"$f":"E46","v":"2026-01-01"},{"$f":"F46","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"Essential Use  - Non-CARE",null,{"$f":"((D60*$H$10)+(D66*$H$11))/12","v":51.059495055959985},{"$f":"((E60*$H$10)+(E66*$H$11))/12","v":51.059495055959985},51.059495055959964,{"$f":"$F54/D54-1","v":0},0]
[null,"Essential Use - CARE",null,{"$f":"((D61*$H$10)+(D67*$H$11))/12","v":40.431413364475077},40.431413364475077,40.43141336447507,0,0]
[null,"Total",null,{"$f":"((D62*$H$10)+(D68*$H$11))/12","v":49.132326821350802},49.132326821350802,49.132326821350794,0,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":"2026-01-01"},{"$f":"E53","v":"2026-01-01"},{"$f":"F53","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% 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":28.08272228077799},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,4,FALSE)))","v":28.08272228077799},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,6,FALSE)))","v":28.082722280777983},{"$f":"$F60/D60-1","v":0},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":22.237277350461291},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,4,FALSE)))","v":22.237277350461291},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,6,FALSE)))","v":22.237277350461287},0,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":27.022779751742942},{"$f":"E60*(1-'Hypothetical SAR and RAR'!$AA$16)+E61*'Hypothetical SAR and RAR'!$AA$16","v":27.022779751742942},{"$f":"F60*(1-'Hypothetical SAR and RAR'!$AA$16)+F61*'Hypothetical SAR and RAR'!$AA$16","v":27.022779751742938},0,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":"2026-01-01"},{"$f":"E59","v":"2026-01-01"},{"$f":"F59","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% 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":74.03626783114197},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,5,FALSE)))","v":74.03626783114197},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H67,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$63:$J$66,7,FALSE)))","v":74.036267831141956},{"$f":"$F66/D66-1","v":0},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":58.625549378488863},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,5,FALSE)))","v":58.625549378488863},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H77,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$73:$J$76,7,FALSE)))","v":58.625549378488856},0,0]
[null,"Total",null,{"$f":"D66*(1-'Hypothetical SAR and RAR'!$AA$16)+D67*'Hypothetical SAR and RAR'!$AA$16","v":71.241873890958658},{"$f":"E66*(1-'Hypothetical SAR and RAR'!$AA$16)+E67*'Hypothetical SAR and RAR'!$AA$16","v":71.241873890958658},{"$f":"F66*(1-'Hypothetical SAR and RAR'!$AA$16)+F67*'Hypothetical SAR and RAR'!$AA$16","v":71.241873890958658},0,0]
[]
[]
[null,"Basic Bundled Typical Residential Monthly Average Bills"]
[null,null,null,{"$f":"D65","v":"2026-01-01"},{"$f":"E65","v":"2026-01-01"},{"$f":"F65","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% Change over Authorized"]
[null,"5-Year Average Usage - Non-CARE",null,{"$f":"((D79*$H$10)+(D85*$H$11))/12","v":61.961948986733354},{"$f":"((E79*$H$10)+(E85*$H$11))/12","v":61.961948986733354},61.96194898673334,{"$f":"$F73/D73-1","v":0},0]
[null,null,"5-Year Average Usage - CARE",{"$f":"((D80*$H$10)+(D86*$H$11))/12","v":42.129766475196554},42.129766475196554,42.12976647519654,0,0]
[null,"Total",null,{"$f":"((D81*$H$10)+(D87*$H$11))/12","v":58.365820045625675},58.365820045625675,58.365820045625675,0,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":"2021-2025 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":"2026-01-01"},{"$f":"E72","v":"2026-01-01"},{"$f":"F72","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% 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":40.863618307786467},{"$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.863618307786467},{"$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.86361830778646},{"$f":"$F79/D79-1","v":0},0,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Hypothetical Res Bill Impact'!Q31","v":15.367753039946335},{"$f":"'Hypothetical Res Bill Impact'!R31","v":32.083872604825636},{"$f":"'Hypothetical Res Bill Impact'!S31","v":14.748357547885229},{"$f":"'Hypothetical Res Bill Impact'!T31","v":26.37825981653603}]
[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":30.934016626498568},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!E97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,4,FALSE)))","v":30.934016626498568},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!G97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,6,FALSE)))","v":30.934016626498561},0,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":39.063104019508884},{"$f":"E79*(1-'Hypothetical SAR and RAR'!$AA$16)+E80*'Hypothetical SAR and RAR'!$AA$16","v":39.063104019508884},{"$f":"F79*(1-'Hypothetical SAR and RAR'!$AA$16)+F80*'Hypothetical SAR and RAR'!$AA$16","v":39.063104019508884},0,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":"2026-01-01"},{"$f":"E78","v":"2026-01-01"},{"$f":"F78","v":"Proposed"},{"$f":"$G$28","v":"% Change over 1/1/2026"},"% 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":83.060279665680241},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,5,FALSE)))","v":83.060279665680241},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H87,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$83:$J$86,7,FALSE)))","v":83.060279665680227},{"$f":"$F85/D85-1","v":0},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":53.325516323894533},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!F97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,5,FALSE)))","v":53.325516323894533},{"$f":"IF($D$3=\"All\",'Hypothetical Res Bill Impact'!H97,(VLOOKUP($D$3,'Hypothetical Res Bill Impact'!$B$93:$J$96,7,FALSE)))","v":53.325516323894526},0,0]
[null,"Total",null,{"$f":"D85*(1-'Hypothetical SAR and RAR'!$AA$16)+D86*'Hypothetical SAR and RAR'!$AA$16","v":77.66853607174248},{"$f":"E85*(1-'Hypothetical SAR and RAR'!$AA$16)+E86*'Hypothetical SAR and RAR'!$AA$16","v":77.66853607174248},{"$f":"F85*(1-'Hypothetical SAR and RAR'!$AA$16)+F86*'Hypothetical SAR and RAR'!$AA$16","v":77.668536071742466},0,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.74052031744563351},{"$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":3.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":"01/01/2026 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":"01/01/2026 Avg Rates(sales adj.)"},"Proposed Avg Rates","% Change"]
[null,null,null,null,"Residential",{"$f":"'SAR and RAR'!F28","v":268350.62742938031},259.51483001153451,{"$f":"(U19/C23*100)+(W19/D23*100)+G28","v":259.51483001153451},{"$f":"H28/G28-1","v":0},null,null,null,null,null,null,"Residential",{"$f":"'SAR and RAR'!Q28","v":270603.84207905678},259.22204020593676,{"$f":"U9/Q28*100+R28","v":259.22204020593676},{"$f":"S28/R28-1","v":0}]
[null,null,null,null,"Total System",{"$f":"'SAR and RAR'!F29","v":413767.70037365775},144.80312026195367,{"$f":"(U20/C24*100)+(W20/D24*100)+G29","v":144.80312026195367},{"$f":"H29/G29-1","v":0},null,null,null,null,null,null,"Total System",{"$f":"'SAR and RAR'!Q29","v":819598.16505165747},125.07776459924771,{"$f":"U10/Q29*100+R29","v":125.07776459924771},{"$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":"2026-01-01"},{"$f":"'Res Bill Impact'!G4","v":"2026-01-01"},"Proposed","Proposed",null,null,null,null,null,null,{"$f":"SalesForecastYear","v":2024},{"$f":"'Res Bill Impact'!Q4","v":"2026-01-01"},{"$f":"'Res Bill Impact'!R4","v":"2026-01-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.5494747527979991},{"$f":"F7*E7","v":479197.56527410826},{"$f":"(Y10/SUM(SUM(E7),F9/F7*SUM(E9),SUM(P7)*(Q7/F7),SUM(P9)*(Q9/F7)))","v":2.5494747527979986},{"$f":"E7*H7","v":479197.5652741082},null,null,null,null,null,"Baseline ",{"$f":"'Res Bill Impact'!P7","v":34568.659520669324},{"$f":"'Res Bill Impact'!Q7","v":2.0180706682237539},{"$f":"'Res Bill Impact'!R7","v":69761.997818476579},{"$f":"H7*(1+(Q7/F7-1))","v":2.0180706682237535},{"$f":"P7*S7","v":69761.997818476564},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":805527.03390815726}]
[null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!E9","v":76615.611405786854},{"$f":"'Res Bill Impact'!F9","v":2.9226947527979994},{"$f":"F9*E9","v":223924.04543810379},{"$f":"F9/F$7*H$7","v":2.922694752797999},{"$f":"E9*H9","v":223924.04543810376},null,null,null,null,null,"Non-Baseline",{"$f":"'Res Bill Impact'!P9","v":14090.808851095719},{"$f":"'Res Bill Impact'!Q9","v":2.3166466682237541},{"$f":"'Res Bill Impact'!R9","v":32643.42537746868},{"$f":"H9*(1+(Q9/F9-1))","v":2.3166466682237541},{"$f":"P9*S9","v":32643.42537746868},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":805527.03390815726}]
[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":"2025 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":"2026-01-01"},{"$f":"'Res Bill Impact'!D21","v":"2026-01-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.5494747527979991,2.5494747527979991,{"$f":"H7","v":2.5494747527979986},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},{"$f":"'Res Bill Impact'!R22","v":29},{"$f":"'Res Bill Impact'!S22","v":14.833333333333334},{"$f":"'Res Bill Impact'!T22","v":24.666666666666668},{"$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.9226947527979994,2.9226947527979994,{"$f":"H9","v":2.922694752797999},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.5494747527979991},2.5494747527979991,2.5494747527979986,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.9226947527979994,2.9226947527979994,2.922694752797999]
[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":"2021-2025 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":"2026-01-01"},{"$f":"D21","v":"2026-01-01"},"Proposed",null,null,null,null,null,null,null,null,null,null,null,"Non-CARE",null,"CARE",null,"Non-CARE","CARE"]
["Summer","Tier 1",2.0180706682237539,2.0180706682237539,{"$f":"S7","v":2.0180706682237535},null,null,null,null,null,null,null,null,null,null,{"$f":"Zones","v":"SDG&E"},{"$f":"'Res Bill Impact'!Q31","v":15.367753039946335},{"$f":"'Res Bill Impact'!R31","v":32.083872604825636},{"$f":"'Res Bill Impact'!S31","v":14.748357547885229},{"$f":"'Res Bill Impact'!T31","v":26.37825981653603},{"$f":"SUM(Q31:R31)/SUM($Q$31:$R$34)","v":1},{"$f":"SUM(S31:T31)/SUM($S$31:$T$34)","v":1}]
[null,"Tier 2",2.3166466682237541,2.3166466682237541,{"$f":"S9","v":2.3166466682237541},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":2.0180706682237539},2.0180706682237539,2.0180706682237535,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"Tier 2",2.3166466682237541,2.3166466682237541,2.3166466682237541]
[]
[]
[]
[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":"2026-01-01"},null,{"$f":"D30","v":"2026-01-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":39.787501291969988},{"$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":74.03626783114197},{"$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.787501291969988},{"$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":74.03626783114197},{"$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.787501291969981},{"$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":74.036267831141956}]
[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":39.787501291969988},{"$f":"SUMPRODUCT(D43:D46,$U$22:$U$25)","v":74.03626783114197},39.787501291969988,74.03626783114197,39.787501291969981,74.036267831141956]
[]
[]
[null,null,{"$f":"'Res Bill Impact'!C50","v":"2023 Recorded Average Basic Bundled CARE Customer Bill"}]
[null,null,{"$f":"C30","v":"2026-01-01"},null,{"$f":"D30","v":"2026-01-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":31.131172911985683},{"$f":"IF($T22>$J22,C$34*$J22+C$35*($T22-$J22),$T22*C$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$Q$12,0)","v":49.865409816185938},{"$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":31.131172911985683},{"$f":"IF($T22>$J22,D$34*$J22+D$35*($T22-$J22),$T22*D$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$Q$12,0)","v":49.865409816185938},{"$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":31.131172911985683},{"$f":"IF($T22>$J22,E$34*$J22+E$35*($T22-$J22),$T22*E$34)+('Hypothetical SAR and RAR'!$C$18*$T22)+IF(T22>0,$S$12,0)","v":49.865409816185924}]
[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":31.131172911985683},{"$f":"SUMPRODUCT(D53:D56,$V$22:$V$25)","v":49.865409816185938},31.131172911985683,49.865409816185938,31.131172911985683,49.865409816185924]
[]
[]
[null,null,"Essential Usage Basic Bundled Non-CARE Customer"]
[null,null,{"$f":"C51","v":"2026-01-01"},null,{"$f":"D30","v":"2026-01-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":28.08272228077799},{"$f":"($C$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":74.03626783114197},{"$f":"($D$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$F$12,0)","v":28.08272228077799},{"$f":"($D$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$F$12,0)","v":74.03626783114197},{"$f":"($E$22*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$H$12,0)","v":28.082722280777983},{"$f":"($E$25*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$H$12,0)","v":74.036267831141956}]
[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":28.08272228077799},{"$f":"SUMPRODUCT(D63:D66,$U$22:$U$25)","v":74.03626783114197},{"$f":"SUMPRODUCT(E63:E66,$U$22:$U$25)","v":28.08272228077799},74.03626783114197,28.082722280777983,74.036267831141956]
[]
[]
[null,null,"Essential Usage Basic Bundled CARE Customer"]
[null,null,{"$f":"C51","v":"2026-01-01"},null,{"$f":"E61","v":"2026-01-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":22.237277350461291},{"$f":"($C$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":58.625549378488863},{"$f":"($D$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$Q$12,0)","v":22.237277350461291},{"$f":"($D$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$Q$12,0)","v":58.625549378488863},{"$f":"($E$31*$I22)+('Hypothetical SAR and RAR'!$C$18*$I22)+IF(I22>0,$S$12,0)","v":22.237277350461287},{"$f":"($E$34*$J22)+('Hypothetical SAR and RAR'!$C$18*$J22)+IF(J22>0,$S$12,0)","v":58.625549378488856}]
[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":22.237277350461291},{"$f":"SUMPRODUCT(D73:D76,$V$22:$V$25)","v":58.625549378488863},22.237277350461291,58.625549378488863,22.237277350461287,58.625549378488856]
[]
[]
[null,null,"Typical Monthly Usage Basic Bundled Non-CARE Customer "]
[null,null,{"$f":"C71","v":"2026-01-01"},null,{"$f":"E71","v":"2026-01-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":40.863618307786467},{"$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":83.060279665680241},{"$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.863618307786467},{"$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":83.060279665680241},{"$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.86361830778646},{"$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":83.060279665680227}]
[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":40.863618307786467},{"$f":"SUMPRODUCT(D83:D86,$U$22:$U$25)","v":83.060279665680241},40.863618307786467,83.060279665680241,40.86361830778646,83.060279665680227]
[]
[]
[null,null,"Typical Monthly Usage Basic Bundled CARE Customer "]
[null,null,{"$f":"C81","v":"2026-01-01"},null,{"$f":"E81","v":"2026-01-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":30.934016626498568},{"$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":53.325516323894533},{"$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":30.934016626498568},{"$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":53.325516323894533},{"$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":30.934016626498561},{"$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":53.325516323894526}]
[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":30.934016626498568},{"$f":"SUMPRODUCT(D93:D96,$V$22:$V$25)","v":53.325516323894533},30.934016626498568,53.325516323894533,30.934016626498561,53.325516323894526]

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

{"sheet":"Selected Data","index":10,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["SDGE Revenue Requirement List"]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2025"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended March 31"}]
["Summary of Selected Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Requirement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$000"]
[1,"Current total system-level revenue requirement that is used for defining the reporting threshold:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Authorized Rev Req'!O97","v":1012062.052750407}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q7*0.01","v":10120.62052750407}]
[]
["2*","List of currently open proceedings for which affordability metrics have been filed:"]
[null,"A",{"$f":"'Incremental Rev Req'!B97","v":"A.25-05-015/016"},{"$f":"'Incremental Rev Req'!A97","v":"2024 GRC Track 3 (PSEP and WMPMA)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D97","v":50051}]
[]
[]
[3,"Total system-level revenue requirement if all pending revenue were granted in full:\nrequests were granted in full",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"A","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!O114","v":1082317.2633081963}]
[null,"B","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!P114","v":787176.48968407023}]
[null,"C","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!Q114","v":789759.50640167214}]
[null,"D","YE 2029",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!R114","v":793445.71323237417}]
[null,"E","YE 2030",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!S114","v":796834.97562393628}]
[]
[4,"Bundled residential average rate (RAR) if all pending revenue were granted in full (from Cost and Rate Tracker (CRT) as submitted by utility):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cents/Therm"]
[null,"A","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,247.25061462309466]
[null,"B","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,176.29947798242006]
[null,"C","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,177.07888098167592]
[null,"D","YE 2029",null,null,null,null,null,null,null,null,null,null,null,null,null,null,178.19116207538633]
[null,"E","YE 2030",null,null,null,null,null,null,null,null,null,null,null,null,null,null,179.21384274765896]
[]
[5,"Bundled residential average monthly bill corresponding to RAR above for typical customer using a Typical 5-year average usage (from CRT as submitted by utility):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-CARE","CARE"]
[null,"A","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.319420752306222,34.769848861722416]
[null,"B","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.616608252517018,24.812931925915606]
[null,"C","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.778119634890892,24.922309326906539]
[null,"D","YE 2029",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37.008611507779499,25.078401124497191]
[null,"E","YE 2030",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37.220535979796523,25.221918860615261]
[]
[]
[null,"*Per D.25-12-044 affordability metrics are only required for >1% increase requests in a GRC filing"]