{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Selected Data","Authorized Rev Req","Incremental Rev Req"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":199,"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":"Selected Data","index":0,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,1,30,15],[37,1,37,14]]}
["SDGE Revenue Requirement List"]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2023"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended December 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'!G89","v":1225326.7736748643}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q7*0.01","v":12253.267736748643}]
[]
[2,"List of currently open proceedings that exceed the threshold for use of the affordability metrics (proceedings shaded gray filed prior to D.22-08-023):"]
[null,"A",{"$f":"'Incremental Rev Req'!B82","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A82","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D82","v":659590.78756474587}]
[null,"B",{"$f":"'Incremental Rev Req'!B85","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A85","v":"Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D85","v":40844}]
[null,"C",{"$f":"'Incremental Rev Req'!B87","v":"A.22-09-006"},{"$f":"'Incremental Rev Req'!A87","v":"Hydrogen Blending "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D87","v":13783.905265000001}]
[null,"E",{"$f":"'Incremental Rev Req'!B93","v":"A.22-03-005"},{"$f":"'Incremental Rev Req'!A93","v":"Energy Efficiency"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D93","v":47840.294510586667}]
[null,"F",{"$f":"'Incremental Rev Req'!B88","v":"A.22-05-015"},{"$f":"'Incremental Rev Req'!A88","v":"GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D88","v":17290.931922}]
[null,"G",{"$f":"'Incremental Rev Req'!B94","v":"AL 3245-G"},{"$f":"'Incremental Rev Req'!A94","v":"PPPS filing "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D94","v":21201.328822186581}]
[null,"H",{"$f":"'Incremental Rev Req'!B108","v":"AL 3247-G"},{"$f":"'Incremental Rev Req'!A98","v":"Regulatory Account Update"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Incremental Rev Req'!G99:G103,'Incremental Rev Req'!G105:G107)","v":24988.106130165579}]
[]
[3,"List of currently open proceedings for which affordability metrics have been filed:"]
[null,"A",{"$f":"'Incremental Rev Req'!B82","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A82","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q11","v":659590.78756474587}]
[]
[]
[4,"List of currently open proceedings that do not exceed the threshold for use of the affordability metrics (proceedings shaded gray filed prior to D.22-08-023):"]
[null,"A",{"$f":"'Incremental Rev Req'!B83","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A83","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D83","v":-706.42470000000003}]
[null,"B",{"$f":"'Incremental Rev Req'!B86","v":"A.22-10-021"},{"$f":"'Incremental Rev Req'!A86","v":"Catastrophic Event Memorandum Account (CEMA)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D86","v":7122.202581999999}]
[null,"C",{"$f":"'Incremental Rev Req'!B84","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A84","v":"TIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D84","v":8044.9585039999993}]
[null,"D",{"$f":"'Incremental Rev Req'!B92","v":"AL 3071-G"},{"$f":"'Incremental Rev Req'!A92","v":"Natural Gas Leak Abatement"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D92","v":3013.5658362152949}]
[]
[]
[]
[5,"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,{"$f":"'Incremental Rev Req'!N97","v":"Total"}]
[null,"A","YE 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!O97","v":1228578.5735948642}]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!P97","v":1470647.4133745758}]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!Q97","v":1277004.6955699732}]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!R97","v":1371090.8507155154}]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!S97","v":981950.75353222562}]
[]
[6,"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 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,266.15375892563179]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,317.90817265422692]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,296.68851014195451]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,321.22460162802844]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,223.88874310998602]
[]
[7,"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 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65.819503645542611,42.257583676874454]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78.635327520039411,50.483074785171993]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73.380752347771747,47.110567345882153]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79.456567034864307,51.010165231570625]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55.35351708086705,35.540272306934881]

{"sheet":"Authorized Rev Req","index":1,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["SDGE Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended December 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01"]
[null,"Advice Letter:","AL 3046-G","AL 3149-G","AL 3163-G","AL 3213-G","AL 3244-G"]
["Filing Description","Authority for Revenue Requirement as of 11/1/2023","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051, A.22-05-016",412393.92784195661,412992.27437904326,412992.27437904326,412992.27437904326,412992.27437904326,"Allocated Base Margin","N"]
["SCG Transport excl Core Storge & Load Balance $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",10101.5487258045,18927.301506775031,18927.301506775031,19163.89443334132,16390.059073287463,"ECPT","N"]
["SCG Core Seasonal Storage","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",14374.700920168953,18907.657128629489,18907.657128629489,18907.657128629489,17001.410111315246,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.20-02-045, AL 3149-G, AL 3129-G-A, AL 3129-G, 3244-G ",9102.0837826634306,11569.318977706102,11569.318977706102,11569.318977706102,11389.102717475975,"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,"Local Transmission","N"]
["LUAF","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",3180.2303217247427,4359.515855476232,4359.515855476232,4359.515855476232,4359.515855476232,"46% Res (LUAF, Other)","N"]
["Company Use Gas: Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",234.78660051758473,321.84961592802711,321.84961592802711,321.84961592802711,321.84961592802711,"ECPT","N"]
["SDG&E NGLAPBA","AL 3149-G",983.22148920005588,734.78317488009657,734.78317488009657,143.91573455627505,143.91573455627505,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct","AL 3149-G",1620.0351328756483,5725.6373585236443,5725.6373585236443,6792.859113609511,6792.859113609511,"EPAM","N"]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",52.108015617715203,47.131684850968078,47.131684850968078,47.131684850968078,47.131684850968078,"Local Transmission","N"]
["CFCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, AL 3163-G",37541.479619999998,55563.797728400001,55563.797728400001,55563.797728400001,55563.797728400001,"CFCA","Y"]
["CFCA -NGV only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, AL 3163-G",-210.72329159999998,3011.7432064000004,3011.7432064000004,3011.7432064000004,3011.7432064000004,"Non-Residential","Y"]
["CFCA - C&I shortfall only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",5444.0260091999999,40.920424000000004,40.920424000000004,40.920424000000004,40.920424000000004,"Non-Residential","Y"]
["Hazardous Substance Cleanup Cost Acct HSCCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",290.51172240000005,122.76127200000001,122.76127200000001,122.76127200000001,122.76127200000001,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",10311.120288,11907.843384,11907.843384,11907.843384,11907.843384,"EPAM","Y"]
["PBOPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-623.51692177259997,-531.23917447400004,-531.23917447400004,-531.23917447400004,-531.23917447400004,"EPAM","Y"]
["Pension BA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-575.93130622920012,-298.79172895260001,-298.79172895260001,-298.79172895260001,-298.79172895260001,"EPAM","Y"]
["Safety Enhancement Balancing Account - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",3036.4630647777644,3084.2385558959263,3084.2385558959263,3084.2385558959263,3084.2385558959263,"Local Transmission","Y"]
["Safety Enhancement Balancing Account - Distribution","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",38688.933410192403,39079.214628479465,39079.214628479465,39079.214628479465,39079.214628479465,"Distribution","Y"]
["Rewards & Penalties Bal Acct  RPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-127.86607500000001,310.99522240000005,310.99522240000005,310.99522240000005,310.99522240000005,"EPAM","Y"]
["SGPMA - Rev Req for NEXT Year","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1545.2359431600003,1545.3598123600002,1545.3598123600002,1545.3598123600002,1545.3598123600002,"ECPT","Y"]
["Integrated Transmission  Margin ITBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",24.550286399999997,704.35051671497718,704.35051671497718,704.35051671497718,704.35051671497718,"ECPT","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",3038.0979420000003,4285.3914033999999,4285.3914033999999,4285.3914033999999,4285.3914033999999,"EPAM","Y"]
["Residential Uncollectible Balancing Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",5629.1760858000007,10487.904671200002,10487.904671200002,10487.904671200002,10487.904671200002,"EPAM","Y"]
["NFCA -Margin Only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-7128.7894133999998,3046.5255668000004,3046.5255668000004,3046.5255668000004,3046.5255668000004,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1705.2219761999997,794.87923620000004,794.87923620000004,794.87923620000004,794.87923620000004,"Non-Residential","Y"]
["NFCA -Nonmargin SCG","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-100.24700279999999,132.991378,132.991378,132.991378,132.991378,"Non-Residential","Y"]
["Minimum Bil/Customer Charge Revenue ","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,"All Residential","N"]
["Borrego Revenue","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,"All Residential","N"]
["Employee Discount (Schd GR)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,"All Residential","N"]
["SDFFD","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1986.9012193223789,2243.52579553028,2243.52579553028,2243.52579553028,2235.2764847903877,"All Residential","N"]
["Customer Information System  Account - CISBA","AL 3040-G",0,28619.672934858001,28619.672934858001,28619.672934858001,28619.672934858001,"EPAM","Y"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ","AL 3039-G",0,10830.843399584999,10830.843399584999,10830.843399584999,10830.843399584999,"EPAM","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,556607.70051950624,652780.64954693615,652780.64954693615,653493.59678826446,648625.04883992637]
[]
[]
[]
["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 ",62728.323235565404,62672.954086711361,62672.954086711361,62672.954086711361,62672.954086711361,"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 ",830.72849948880003,809.23321752201855,809.23321752201855,809.23321752201855,809.23321752201855,"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,"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 ",-138.095361,1354.208041356786,1354.208041356786,1354.208041356786,1354.208041356786,"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 ",-5290.5867191999996,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,"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 ",-11.252214599999999,-248.04164622186403,-248.04164622186403,-248.04164622186403,-248.04164622186403,"46% Res (LUAF, Other)","Y"]
["FERC Settlement Proceeds MA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1.0229286000000002,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 ",413.26315440000002,2305.8658924000006,2305.8658924000006,2305.8658924000006,2305.8658924000006,"46% Res (LUAF, Other)","Y"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",105.36164580000001,864.44395699999995,864.44395699999995,864.44395699999995,864.44395699999995,"EPAM","Y"]
["  TLS Adjustment","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",6681.9931823319448,-10406.77744459657,-10437.810558367659,-10411.005461001434,-10207.828179601249,"Non-Residential","N"]
["CSI Thermal Program memoradum Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",806.06773680000003,333.50145560000004,333.50145560000004,333.50145560000004,333.50145560000004,"46% Res (LUAF, Other)","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","AL 3129-G-A and AL 3129-G ",0,2813.2791500000003,2813.2791500000003,2813.2791500000003,2813.2791500000003,"ECPT","Y"]
[]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding","AL 3137-G, D.21-06-015",25613.072,22795.559000000001,22795.559000000001,22795.559000000001,22795.559000000001,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Admin Expenses","AL 3137-G, D.21-06-015",727.2829999999999,761.47,761.47,761.47,761.47,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3137-G",1000,-1000,-1000,-1000,-1000,"Public Purpose Programs","Y"]
["Energy Savings Assistance (ESA/LIEE/DAP)","AL 3137-G, D.21-06-015",8041.1949999999997,10315.642,10315.642,10315.642,10315.642,"Public Purpose Programs","N"]
["Energy Efficiency","AL 3137-G, AL 3035-G",15368.681745714286,12089.109,12089.109,12089.109,12089.109,"Public Purpose Programs","N"]
["RD&D ","AL 3137-G",1929.78072,2278.9604600000002,2278.9604600000002,2278.9604600000002,2278.9604600000002,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3137-G",56.159990000000001,55.36833,55.36833,55.36833,55.36833,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,119391.85263010046,101254.1992437171,101223.16612994601,101249.97122731223,101453.14850871242]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
[]
["Total Authorized Revenue",null,1048042.1289632095,1229283.4251168789,1229252.3920031078,1229992.1443418022,1225326.7736748643]

{"sheet":"Incremental Rev Req","index":2,"n_rows":120,"n_cols":19,"rows_kept":120,"cut":false,"hidden":false,"merged":[[112,0,112,10],[113,5,113,9],[79,5,79,9],[5,13,5,18],[80,13,80,18],[5,0,5,10],[78,0,78,10]]}
["Annual Period 2023"]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended December 31"}]
[]
["Current Revenue Requirement ($000):",1229992.1443418022]
["Current Revenue Requirement Effective:","2023-11-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,2023,2024,2025,2026,2027]
["Safety Affordability Reliability Proceedings",null,null,"2023-11-01",null,2023,2024,2025,2026,2027,null,null,null,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
["Total Allocated Base Margin",null,"D.19-09-051, A.22-05-016",412992.27437904326,"Allocated Base Margin",412992.27437904326,504916,504916,504916,504916,"Existing",null,null,"Allocated Base Margin",412992.27437904326,504916,504916,504916,504916]
["SCG Transport excl Core Storge & Load Balance $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",16390.059073287463,"ECPT",16390.059073287463,16390.059073287463,0,0,0,"Existing",null,null,"Distribution",39079.214628479465,39079.214628479465,0,0,0]
["SCG Core Seasonal Storage",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",17001.410111315246,"Seasonal Storage",17001.410111315246,17001.410111315246,0,0,0,"Existing",null,null,"All Residential",3749.0797171165377,3749.0797171165377,0,0,0]
["SCG Load Balancing Allocated to ALL SDGE $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A, AL 3129-G, 3244-G ",11389.102717475975,"ECPT",11389.102717475975,11389.102717475975,0,0,0,"Existing",null,null,"Local Transmission",5829.8186407468938,5859.794940746895,0,0,0]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)",null,"D.19-09-051",2698.4483999999993,"Local Transmission",2698.4483999999993,2728.4247,0,0,0,"Existing",null,null,"Seasonal Storage",17001.410111315246,17001.410111315246,0,0,0]
["LUAF",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",4359.515855476232,"46% Res (LUAF, Other)",4359.515855476232,4359.515855476232,0,0,0,"Existing",null,null,"GHG End User",55603.481350456714,55603.481350456714,0,0,0]
["Company Use Gas: Other",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",321.84961592802711,"ECPT",321.84961592802711,321.84961592802711,0,0,0,"Existing",null,null,"Public Purpose Programs",47296.108789999998,39785.794278936082,38445.876122011468,39361.519502576339,0]
["SDG&E NGLAPBA",null,"AL 3149-G",143.91573455627505,"EPAM",143.91573455627505,983.22148920005588,0,0,0,"Existing",null,null,"-",0,0,0,0,0]
["SDG&ENERBA - NGLAP Subacct",null,"AL 3149-G",6792.859113609511,"EPAM",6792.859113609511,1620.0351328756483,0,0,0,"Existing",null,null,"46% Res (LUAF, Other)",8088.9712549763872,8088.9712549763872,0,0,0]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",47.131684850968078,"Local Transmission",47.131684850968078,47.131684850968078,0,0,0,"Existing",null,null,"ECPT",34640.970199123221,34640.970199123221,0,0,0]
["CFCA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, AL 3163-G",55563.797728400001,"CFCA",55563.797728400001,55563.797728400001,0,0,0,"Existing",null,null,"EPAM",73413.838917182191,51405.300272649103,21791.861599999997,24855.447099999998,0]
["CFCA -NGV only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, AL 3163-G",3011.7432064000004,"Non-Residential",3011.7432064000004,3011.7432064000004,0,0,0,"Existing",null,null,"CFCA",55563.797728400001,55563.797728400001,0,0,0]
["CFCA - C&I shortfall only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",40.920424000000004,"Non-Residential",40.920424000000004,40.920424000000004,0,0,0,"Existing",null,null,"Non-Residential",-3180.7683682012475,-3180.7683682012475,0,0,0]
["Hazardous Substance Cleanup Cost Acct HSCCA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",122.76127200000001,"ECPT",122.76127200000001,122.76127200000001,0,0,0,"Existing",null,null,"Total",1225326.7736748643,1287761.622440224,1040402.3140482371,1044381.542928802,980164.57632622565]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",11907.843384,"EPAM",11907.843384,18705.772299999997,21791.861599999997,24855.447099999998,0,"Existing",null,null,"CPUC Fee",3.0000000000000001E-3]
["PBOPBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-531.23917447400004,"EPAM",-531.23917447400004,-531.23917447400004,0,0,0,"Existing",null,null,"Check",0,0,0,0,0]
["Pension BA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-298.79172895260001,"EPAM",-298.79172895260001,-298.79172895260001,0,0,0,"Existing"]
["Safety Enhancement Balancing Account - Local Transmission",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",3084.2385558959263,"Local Transmission",3084.2385558959263,3084.2385558959263,0,0,0,"Existing"]
["Safety Enhancement Balancing Account - Distribution",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",39079.214628479465,"Distribution",39079.214628479465,39079.214628479465,0,0,0,"Existing"]
["Rewards & Penalties Bal Acct  RPBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",310.99522240000005,"EPAM",310.99522240000005,310.99522240000005,0,0,0,"Existing"]
["SGPMA - Rev Req for NEXT Year",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1545.3598123600002,"ECPT",1545.3598123600002,1545.3598123600002,0,0,0,"Existing"]
["Integrated Transmission  Margin ITBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",704.35051671497718,"ECPT",704.35051671497718,704.35051671497718,0,0,0,"Existing"]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",4285.3914033999999,"EPAM",4285.3914033999999,4285.3914033999999,0,0,0,"Existing"]
["Residential Uncollectible Balancing Account",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",10487.904671200002,"EPAM",10487.904671200002,10487.904671200002,0,0,0,"Existing"]
["NFCA -Margin Only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",3046.5255668000004,"Non-Residential",3046.5255668000004,3046.5255668000004,0,0,0,"Existing"]
["NFCA -Nonmargin Other",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",794.87923620000004,"Non-Residential",794.87923620000004,794.87923620000004,0,0,0,"Existing"]
["NFCA -Nonmargin SCG",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",132.991378,"Non-Residential",132.991378,132.991378,0,0,0,"Existing"]
["Minimum Bil/Customer Charge Revenue ",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1816.4409600000001,"All Residential",1816.4409600000001,1816.4409600000001,0,0,0,"Existing"]
["Borrego Revenue",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",64.571742326140509,"All Residential",64.571742326140509,64.571742326140509,0,0,0,"Existing"]
["Employee Discount (Schd GR)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-367.20946999999097,"All Residential",-367.20946999999097,-367.20946999999097,0,0,0,"Existing"]
["SDFFD",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",2235.2764847903877,"All Residential",2235.2764847903877,2235.2764847903877,0,0,0,"Existing"]
["Customer Information System  Account - CISBA",null,"AL 3040-G",28619.672934858001,"EPAM",28619.672934858001,3529.0749999999998,0,0,0,"New"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ",null,"AL 3039-G",10830.843399584999,"EPAM",10830.843399584999,11448.492,0,0,0,"New"]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",62672.954086711361,"GHG End User",62672.954086711361,62672.954086711361,0,0,0,"Existing"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",809.23321752201855,"46% Res (LUAF, Other)",809.23321752201855,809.23321752201855,0,0,0,"Existing"]
["AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",528.89648020000016,"46% Res (LUAF, Other)",528.89648020000016,528.89648020000016,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",1354.208041356786,"ECPT",1354.208041356786,1354.208041356786,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-7069.4727362546482,"GHG End User",-7069.4727362546482,-7069.4727362546482,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-248.04164622186403,"46% Res (LUAF, Other)",-248.04164622186403,-248.04164622186403,0,0,0,"Existing"]
["FERC Settlement Proceeds MA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",0,"Non-Residential",0,0,0,0,0,"Existing"]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",2305.8658924000006,"46% Res (LUAF, Other)",2305.8658924000006,2305.8658924000006,0,0,0,"Existing"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",864.44395699999995,"EPAM",864.44395699999995,864.44395699999995,0,0,0,"Existing"]
["  TLS Adjustment",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-10207.828179601249,"Non-Residential",-10207.828179601249,-10207.828179601249,0,0,0,"Existing"]
["CSI Thermal Program memoradum Account",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",333.50145560000004,"46% Res (LUAF, Other)",333.50145560000004,333.50145560000004,0,0,0,"Existing"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ",null,null,2813.2791500000003,"ECPT",2813.2791500000003,2813.2791500000003,0,0,0,"Existing"]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding",null,"AL 3137-G, D.21-06-015",22795.559000000001,"Public Purpose Programs",22795.559000000001,11652.832,11769.36,11887.054,null,"Existing"]
["California Alternate Rates for Energy (CARE) - Admin Expenses",null,"AL 3137-G, D.21-06-015",761.47,"Public Purpose Programs",761.47,771.47047999999995,813.95269999999994,814.18138999999996,null,"Existing"]
["California Alternate Rates for Energy (CARE) - Amortization",null,"AL 3137-G",-1000,"Public Purpose Programs",-1000,0,0,0,0,"Existing"]
["Energy Savings Assistance (ESA/LIEE/DAP)",null,"AL 3137-G, D.21-06-015",10315.642,"Public Purpose Programs",10315.642,13505.588216717384,14340.988629792766,15138.709320357639,0,"Existing"]
["Energy Efficiency",null,"AL 3137-G, AL 3035-G",12089.109,"Public Purpose Programs",12089.109,11521.5747922187,11521.5747922187,11521.5747922187,0,"Existing"]
["RD&D ",null,"AL 3137-G",2278.9604600000002,"Public Purpose Programs",2278.9604600000002,2278.9604600000002,0,0,0,"Existing"]
["Bureau Of Equalization BOE",null,"AL 3137-G",55.36833,"Public Purpose Programs",55.36833,55.36833,0,0,0,"Existing"]
[]
[]
[]
["Procurement",null,"D.97-07-061",475248.57632622559,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,1225326.7736748643,null,1225326.7736748643,1287761.622440224,1040402.3140482372,1044381.5429288021,980164.57632622565]
[]
["CPUC Fee",null,null,null,"CPUC Fee",3.0000000000000001E-3]
[]
[]
["Pending Application(s) Not Yet Approved"]
["Filing Description","Proceeding","Basis of Revenue Requirement Forecast:  Application, Amended Application , Amended Testimony,  Proposed Settlement Agreement, Proposed Decision","Proposed Revenue Requirement with FF&U ($000)","Proposed Revenue Recovery Mechanism","Incremental Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2023,2024,2025,2026,2027,null,"Include in Impact",null,"Authorized + Pending"]
["2024 GRC Application","A.22-05-016","Application",659590.78756474587,"Allocated Base Margin",null,147439.96499953128,207116.3609061233,305034.46165909129,null,"Existing","Y",null,null,2023,2024,2025,2026,2027]
["Pipeline Safety Enhancement Plan (PSEP) -Local T","A.22-05-016","Application",-706.42470000000003,"Local Transmission",null,-706.42470000000003,null,null,null,"Existing","Y",null,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
["TIMPBA","A.22-05-016","Application",8044.9585039999993,"Local Transmission",null,8044.9585039999993,null,null,null,"New","Y",null,"Allocated Base Margin",412992.27437904326,560432.23937857454,712032.3609061233,809950.46165909129,504916]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","Application",40844,"Distribution",null,40844,null,null,null,"Existing","Y",null,"Distribution",39079.214628479465,89747.920352589907,0,0,0]
["Catastrophic Event Memorandum Account (CEMA)","A.22-10-021","Application",7122.202581999999,"EPAM",null,7122.202581999999,null,null,null,"New","Y",null,"All Residential",3749.0797171165377,3894.6062699750655,0,0,0]
["Hydrogen Blending ","A.22-09-006","Application",13783.905265000001,"ECPT",3251.7999199999999,7570.9147899999998,654.21505500000001,2306.9755,null,"New","Y",null,"Local Transmission",5829.8186407468938,13336.752311721695,0,0,0]
["GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct","A.22-05-015","Application",17290.931922,"EPAM",null,null,12271.016944999999,3233.7377709999996,1786.1772059999998,"New","Y",null,"Seasonal Storage",17001.410111315246,17001.410111315246,0,0,0]
["Public Policy Proceedings",null,null,null,null,null,null,null,null,null,null,"-",null,"GHG End User",55603.481350456714,109274.92615304617,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"Public Purpose Programs",47296.108789999998,76132.496139474184,55006.664737624378,55495.652359198575,0]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,null,"Existing","Y",null,"-",0,0,0,0,0]
["Natural Gas Leak Abatement","AL 3071-G","Advice Letter",3013.5658362152949,"EPAM",null,3013.5658362152949,null,null,null,"Existing","Y",null,"46% Res (LUAF, Other)",8088.9712549763872,3576.8955147766328,0,0,0]
["Energy Efficiency","A.22-03-005","Application",47840.294510586667,"Public Purpose Programs",null,15145.373038351518,16560.788615612913,16134.132856622236,null,"Existing","Y",null,"ECPT",37892.770119123219,48887.475460100868,654.21505500000001,2306.9755,0]
["PPPS filing ","AL 3245-G","Advice Letter",21201.328822186581,"Public Purpose Programs",null,21201.328822186581,null,null,null,"Existing","Y",null,"EPAM",73413.838917182191,43632.455867447999,34062.878545,28089.184870999998,1786.1772059999998]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"CFCA",55563.797728400001,25794.189268400001,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Non-Residential",-3180.7683682012475,3687.4702209281413,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Total",1228578.5735948642,1470647.4133745758,1277004.6955699732,1371090.8507155154,981950.75353222562]
["Regulatory Account Update","AL 3247-G","Advice Letter",0,"Seasonal Storage",null,0,null,null,null,null,"Y",null,"Incremental Revenues",3251.7999199999031,182885.79093435174,236602.38152173616,326709.30778671347,1786.1772059999639]
["Regulatory Account Update","AL 3247-G","Advice Letter",138.42356697480145,"Local Transmission",null,138.42356697480145,null,null,null,null,"Y",null,"CPUC Fee",3.0000000000000001E-3]
["Regulatory Account Update","AL 3247-G","Advice Letter",-4512.0757401997544,"46% Res (LUAF, Other)",null,-4512.0757401997544,null,null,null,null,"Y",null,"Check Figure",0,-3.5209814086556435E-7,2.6376801542937756E-7,2.8649810701608658E-7,0]
["Regulatory Account Update","AL 3247-G","Advice Letter",-29769.608459999999,"CFCA",null,-29769.608459999999,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",9824.7057241104412,"Distribution",null,9824.7057241104412,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",6868.2385891293889,"Non-Residential",null,6868.2385891293889,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",145.52655285852779,"All Residential",null,145.52655285852779,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",53671.444802589453,"GHG End User",null,53671.444802589453,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",6675.5904709776487,"ECPT",null,6675.5904709776487,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",-17908.612823416399,"EPAM",null,-17908.612823416399,null,null,null,null,"Y"]
["Regulatory Account Update","AL 3247-G","Advice Letter",-91923.725620956684,"Allocated Base Margin",null,-91923.725620956684,null,null,null,null,"Y"]
[null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,0,null,null,null,null,null,null,null,"-"]
["Total Pending, Filed but not Approved",null,null,751235.45736880181,null,3251.7999199999999,182885.79093435209,236602.38152173624,326709.30778671353,1786.1772059999998]
[]
["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,2023,2024,2025,2026,2027]
[]
[]
[]
[]
["Public Policy Proceedings"]