{"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":115,"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":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,1,29,3],[36,1,36,3]]}
["SDG&E Gas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended June 30"]
["Submitted: June 1, 2023"]
[]
["Summary of Selected Data "]
[null,null,null,null,"Revenue"]
[null,null,null,null," Requirement"]
[null,null,null,null,"$000"]
[1,"Current total system-level revenue requirement that is used for defining the reporting threshold:",null,null,{"$f":"'Authorized Rev Req'!E86","v":1229252.3920031078}]
[null,"A","One-percent reporting threshold",null,{"$f":"E10*0.01","v":12292.523920031079}]
[]
[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 '!B84","v":"A.22-05-016"},{"$f":"'Incremental Rev Req '!A84","v":"2024 GRC Application"},{"$f":"'Incremental Rev Req '!D84","v":402240}]
[null,"B",{"$f":"'Incremental Rev Req '!B87","v":"A.22-05-016"},{"$f":"'Incremental Rev Req '!A87","v":"Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution"},{"$f":"'Incremental Rev Req '!D87","v":40844}]
[null,"C",{"$f":"'Incremental Rev Req '!B89","v":"A.22-09-006"},{"$f":"'Incremental Rev Req '!A89","v":"Hydrogen Blending "},{"$f":"'Incremental Rev Req '!D89","v":13783.905265000001}]
[null,"D",{"$f":"'Incremental Rev Req '!B94","v":"AL 3071-G"},{"$f":"'Incremental Rev Req '!A94","v":"Natural Gas Leak Abatement"},{"$f":"'Incremental Rev Req '!D94","v":22686.504516652552}]
[null,"E",{"$f":"'Incremental Rev Req '!B95","v":"A.22-03-005"},{"$f":"'Incremental Rev Req '!A95","v":"Energy Efficiency"},{"$f":"'Incremental Rev Req '!D95","v":47840.294510586667}]
[]
[]
[3,"List of currently open proceedings for which affordability metrics have been filed:"]
[null,"A",{"$f":"'Incremental Rev Req '!B84","v":"A.22-05-016"},{"$f":"'Incremental Rev Req '!A84","v":"2024 GRC Application"},{"$f":"E14","v":402240}]
[]
[]
[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 '!B85","v":"A.22-05-016"},{"$f":"'Incremental Rev Req '!A85","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T"},{"$f":"'Incremental Rev Req '!D85","v":-706.42470000000003}]
[null,"B",{"$f":"'Incremental Rev Req '!B88","v":"A.22-10-021"},{"$f":"'Incremental Rev Req '!A88","v":"Catastrophic Event Memorandum Account (CEMA)"},{"$f":"'Incremental Rev Req '!D88","v":7122.202581999999}]
[null,"C",{"$f":"'Incremental Rev Req '!B86","v":"A.22-05-016"},{"$f":"'Incremental Rev Req '!A86","v":"TIMPBA"},{"$f":"'Incremental Rev Req '!D86","v":7864}]
[]
[5,"Total system-level revenue requirement if all pending revenue were granted in full:\nrequests were granted in full"]
[null,"A","YE 2023",null,{"$f":"'Incremental Rev Req '!N99","v":1240858.233065278}]
[null,"B","YE 2024",null,{"$f":"'Incremental Rev Req '!O99","v":1209129.5915220713}]
[null,"C","YE 2025",null,{"$f":"'Incremental Rev Req '!P99","v":1179541.31771885}]
[null,"D","YE 2026",null,{"$f":"'Incremental Rev Req '!Q99","v":1282812.6512854241}]
[null,"E","YE 2027",null,{"$f":"'Incremental Rev Req '!R99","v":980164.57632622565}]
[]
[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,"cents/Therm"]
[null,"A","YE 2023",null,null,268.93700000000001]
[null,"B","YE 2024",null,null,274.70400000000001]
[null,"C","YE 2025",null,null,270.92700000000002]
[null,"D","YE 2026",null,null,297.89100000000002]
[null,"E","YE 2027",null,null,223.417]
[]
[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,"Non-CARE","CARE"]
[null,"A","YE 2023",null,null,null,66.508010447784315,42.700391552956717]
[null,"B","YE 2024",null,null,null,67.936231249168927,43.617076104685509]
[null,"C","YE 2025",null,null,null,67.000835564738153,43.016704808566452]
[null,"D","YE 2026",null,null,null,73.677793686455672,47.302221695580556]
[null,"E","YE 2027",null,null,null,55.236117045503988,35.465676486079921]

{"sheet":"Authorized Rev Req","index":1,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["SDG&E Gas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended June 30"]
["Submitted: June 1, 2023"]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01"]
[null,"Advice Letter:","AL 3046-G","AL 3149-G","AL 3163-G"]
["Filing Description","Authority for Revenue Requirement as of 3/1/2023","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,"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,"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,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",9102.0837826634306,11569.318977706102,11569.318977706102,"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,"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,"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,"ECPT","N"]
["SDG&E NGLAPBA","AL 3149-G",983.22148920005588,734.78317488009657,734.78317488009657,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct","AL 3149-G",1620.0351328756483,5725.6373585236443,5725.6373585236443,"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,"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,"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,"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,"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,"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,"EPAM","Y"]
["PBOPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-623.51692177259997,-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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"All Residential","N"]
["Customer Information System  Account - CISBA","AL 3040-G",0,28619.672934858001,28619.672934858001,"EPAM","Y"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ","AL 3039-G",0,10830.843399584999,10830.843399584999,"EPAM","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,556607.700519506,652780.64954693615,652780.64954693615]
[]
[]
[]
["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,"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,"46% Res (LUAF, Other)","N"]
["AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",528.8540862000001,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,"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,"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,"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,"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,"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,"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,"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,"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,"ECPT","Y"]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding","AL 3137-G, D.21-06-015",25613.072,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,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3137-G",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,"Public Purpose Programs","N"]
["Energy Efficiency","AL 3137-G, AL 3035-G",15368.681745714286,12089.109,12089.109,"Public Purpose Programs","N"]
["RD&D ","AL 3137-G",1929.78072,2278.9604600000002,2278.9604600000002,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3137-G",56.159990000000001,55.36833,55.36833,"Public Purpose Programs","N"]
[]
[]
[]
["   Subtotal Public Policy ",null,119391.85263010046,101254.1992437171,101223.16612994601]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,372042.57581360283,475248.57632622559,475248.57632622559]
[]
["Total Authorized Revenue",null,1048042.1289632095,1229283.4251168789,1229252.3920031078]

{"sheet":"Incremental Rev Req ","index":2,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[82,12,82,17],[107,5,107,9],[7,0,7,9],[80,0,80,9],[81,5,81,9],[106,0,106,9],[8,12,8,17]]}
["SDG&E Gas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended June 30"]
["Submitted: June 1, 2023"]
[]
["Current Revenue Requirement ($000):",1229252.3920031078]
["Current Revenue Requirement Effective:","2023-03-01"]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,null,null,"Authorized"]
["Safety Affordability Reliability Proceedings",null,null,"2023-03-01",null,2023,2024,2025,2026,2027,null,null,null,2023,2024,2025,2026,2027]
["Total Allocated Base Margin",null,"D.19-09-051, A.22-05-016",412992.27437904326,"Allocated Base Margin",412992.27437904326,504916,504916,504916,504916,null,null,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
["SCG Transport excl Core Storge & Load Balance $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",18927.301506775031,"ECPT",18927.301506775031,0,0,0,0,null,null,"Allocated Base Margin",412992.27437904326,504916,504916,504916,504916]
["SCG Core Seasonal Storage",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",18907.657128629489,"Seasonal Storage",18907.657128629489,0,0,0,0,null,null,"Distribution",39079.214628479465,0,0,0,0]
["SCG Load Balancing Allocated to ALL SDGE $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",11569.318977706102,"ECPT",11569.318977706102,0,0,0,0,null,null,"All Residential",3757.32902785643,0,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,null,null,"Local Transmission",5829.8186407468938,2728.4247,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,0,0,0,0,null,null,"Seasonal Storage",18907.657128629489,0,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,0,0,0,0,null,null,"GHG End User",55603.481350456714,0,0,0,0]
["SDG&E NGLAPBA",null,"AL 3149-G",734.78317488009657,"EPAM",734.78317488009657,983.22148920005588,0,0,0,null,null,"Public Purpose Programs",47296.108789999998,37451.465488936083,38445.876122011468,39361.519502576339,0]
["SDG&ENERBA - NGLAP Subacct",null,"AL 3149-G",5725.6373585236443,"EPAM",5725.6373585236443,1620.0351328756483,0,0,0,null,null,"-",0,0,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,0,0,0,0,null,null,"46% Res (LUAF, Other)",8088.9712549763872,0,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,0,0,0,0,null,null,"ECPT",37358.428892840922,0,0,0,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,0,0,0,0,null,null,"EPAM",72937.48460242014,36286.595922075699,21791.861599999997,24855.447099999998,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,0,0,0,0,null,null,"CFCA",55563.797728400001,0,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,0,0,0,0,null,null,"Non-Residential",-3410.7507469676575,0,0,0,0]
["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,null,null,"Total",1229252.3920031076,1056631.0624372375,1040402.3140482371,1044381.542928802,{"$f":"SUM(R11:R12)","v":980164.57632622565}]
["PBOPBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-531.23917447400004,"EPAM",-531.23917447400004,0,0,0,0,null,null,"CPUC Fee",3.0000000000000001E-3]
["Pension BA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-298.79172895260001,"EPAM",-298.79172895260001,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["Borrego Revenue",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",64.571742326140509,"All Residential",64.571742326140509,0,0,0,0]
["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,0,0,0,0]
["SDFFD",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",2243.52579553028,"All Residential",2243.52579553028,0,0,0,0]
["Customer Information System  Account - CISBA",null,"AL 3040-G",28619.672934858001,"EPAM",28619.672934858001,3529.0749999999998,0,0,0]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ",null,"AL 3039-G",10830.843399584999,"EPAM",10830.843399584999,11448.492,0,0,0]
[]
["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,0,0,0,0]
["  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,0,0,0,0]
["AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",528.89648020000016,"46% Res (LUAF, Other)",528.89648020000016,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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,0,0,0,0]
["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]
["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,0,0,0,0]
["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,0,0,0,0]
["  TLS Adjustment",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ",-10437.810558367659,"Non-Residential",-10437.810558367659,0,0,0,0]
["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,0,0,0,0]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ",null,null,2813.2791500000003,"ECPT",2813.2791500000003,0,0,0,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["PPPS Programs",null,null,0]
["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]
["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]
["California Alternate Rates for Energy (CARE) - Amortization",null,"AL 3137-G",-1000,"Public Purpose Programs",-1000,0,0,0,0]
["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]
["Energy Efficiency",null,"AL 3137-G, AL 3035-G",12089.109,"Public Purpose Programs",12089.109,11521.5747922187,11521.5747922187,11521.5747922187,0]
["RD&D ",null,"AL 3137-G",2278.9604600000002,"Public Purpose Programs",2278.9604600000002,0,0,0,0]
["Bureau Of Equalization BOE",null,"AL 3137-G",55.36833,"Public Purpose Programs",55.36833,0,0,0,0]
[]
[]
[]
["Procurement",null,"D.97-07-061",475248.57632622559,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,1229252.3920031078,null,1229252.3920031078,1056631.0624372375,1040402.3140482372,1044381.5429288021,{"$f":"J11+J72","v":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"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2023,2024,2025,2026,2027,"Include in Impact",null,"Authorized + Pending"]
["2024 GRC Application","A.22-05-016","Application",402240,"Allocated Base Margin",null,60326,121924,219990,null,"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,"Y",null,"Core Procurement",475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559]
["TIMPBA","A.22-05-016","Application",7864,"Local Transmission",null,7864,null,null,null,"Y",null,"Allocated Base Margin",412992.27437904326,565242,626840,724906,504916]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","Application",40844,"Distribution",null,40844,null,null,null,"Y",null,"Distribution",39079.214628479465,40844,0,0,0]
["Catastrophic Event Memorandum Account (CEMA)","A.22-10-021","Application",7122.202581999999,"EPAM",null,7122.202581999999,null,null,null,"Y",null,"All Residential",3757.32902785643,0,0,0,0]
["Hydrogen Blending ","A.22-09-006","Application",13783.905265000001,"ECPT",3251.7999199999999,7570.9147899999998,654.21505500000001,2306.9755,null,"Y",null,"Local Transmission",5829.8186407468938,9886,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"Seasonal Storage",18907.657128629489,0,0,0,0]
["Public Policy Proceedings",null,null,0,null,null,null,null,null,null,null,null,"GHG End User",55603.481350456714,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Public Purpose Programs",47296.108789999998,52596.838527287604,55006.664737624378,55495.652359198575,0]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,null,null,null,"-",0,0,0,0,0]
["Natural Gas Leak Abatement","AL 3071-G","Advice Letter",22686.504516652552,"EPAM",8354.0411421702593,14332.463374482293,null,null,null,"Y",null,"46% Res (LUAF, Other)",8088.9712549763872,0,0,0,0]
["Energy Efficiency","A.22-03-005","Application",47840.294510586667,"Public Purpose Programs",null,15145.373038351518,16560.788615612913,16134.132856622236,null,"Y",null,"ECPT",40610.22881284092,7570.9147899999998,654.21505500000001,2306.9755,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"EPAM",81291.525744590399,57741.261878557991,21791.861599999997,24855.447099999998,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"CFCA",55563.797728400001,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"Non-Residential",-3410.7507469676575,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"Total",1240858.233065278,1209129.5915220713,1179541.31771885,1282812.6512854241,{"$f":"SUM(R85:R86)","v":980164.57632622565}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Revenues",11605.841062170453,152498.5290848338,139139.00367061293,238431.10835662216,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"CPUC Fee",3.0000000000000001E-3]
[]
[]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,541674.48217423924,null,11605.841062170259,152498.52908483378,139139.0036706129,238431.10835662222,0]