{"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":114,"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":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[32,1,32,14],[25,1,25,14]]}
["Summary of Selected Data "]
[null,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'!E108","v":7862529.3162068892}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q5*0.01","v":78625.293162068891}]
[]
[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 '!B103","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req '!A103","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D103","v":3366765.1544120777}]
[null,"B",{"$f":"'Incremental Rev Req '!B107","v":"A.22-05-015"},{"$f":"'Incremental Rev Req '!A108","v":"TIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D107+'Incremental Rev Req '!D108","v":230894}]
[]
[]
[3,"List of currently open proceedings for which affordability metrics have been filed:"]
[null,"A",{"$f":"'Incremental Rev Req '!B103","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req '!A103","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q9","v":3366765.1544120777}]
[]
[]
[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 '!B104","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req '!A104","v":"Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D104","v":-5487.0233199999984}]
[null,"B",{"$f":"C18","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req '!A105","v":"Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D105","v":63454.58}]
[null,"C",{"$f":"'Incremental Rev Req '!B106","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req '!A106","v":"NonCore Backbone Transmission"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D106","v":22240.277383770008}]
[null,"D",{"$f":"'Incremental Rev Req '!B109","v":"A.22-09-006"},{"$f":"'Incremental Rev Req '!A109","v":"Hydrogen Blending "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D109","v":14979.078966298401}]
[null,"E",{"$f":"'Incremental Rev Req '!B112","v":"AL 5950"},{"$f":"'Incremental Rev Req '!A112","v":"Natural Gas Leak Abatement"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D112","v":65768.475030524889}]
[null,"F",{"$f":"'Incremental Rev Req '!B115","v":"A.22-03-008 "},{"$f":"'Incremental Rev Req '!A115","v":"Energy Efficiency "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D115","v":60415.319735278812}]
[null,"G",{"$f":"'Incremental Rev Req '!B116","v":"A.23-01-004"},{"$f":"'Incremental Rev Req '!A116","v":"Demand Response"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!D116","v":12500}]
[]
[5,"Total system-level revenue requirement if all pending revenue were granted in full:"]
[null,"A","YE 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!N120","v":7906853.3795564873}]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!O120","v":8132868.0652648201}]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!P120","v":7716874.8281783387}]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!Q120","v":7973488.0377487652}]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req '!R120","v":6114353.5956005696}]
[]
[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,216.0274761278994]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,227.60900000000001]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,228.90700000000001]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,237.108]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,184.07516177409332]
[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,81.430000000000007,48.06]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85.82,50.59]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86.31,50.87]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89.42,52.66]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.330980101584416,41.089731273549155]

{"sheet":"Authorized Rev Req","index":1,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended March 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01"]
[null,"Advice Letter:","AL 5915","AL 6071","AL 6088"]
["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",2797438.8098034845,2813333.2818626408,2813333.2818626408,"Allocated Base Margin","N"]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)","D.19-09-051",20025.239099999992,20972.15159999999,20972.15159999999,"Local Transmission","N"]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)","D.19-09-051",28629.010000000009,29982.760000000006,29982.760000000006,"Distribution","N"]
["  Company Use Gas: Other","D.20-02-045 AL 6071, AL 6045",1792.6929208784113,2442.7824068004993,2442.7824068004993,"ECPT","N"]
["  Company Use Gas: Storage Load Balancing","D.20-02-045 AL 6071, AL 6045",1739.9823775441146,2371.288817256519,2371.288817256519,"ECPT","N"]
["  Exchange Revenues & Interutility Transactions","D.20-02-045 AL 6071, AL 6045",342.77791000000002,342.77791000000002,342.77791000000002,"ECPT","N"]
["  Unaccounted For (UAF) Gas","D.20-02-045 AL 6071, AL 6045",43865.640785688673,59771.786676696618,59771.786676696618,"47% Res (LUAF, Other)","N"]
["  Well Incidents & Surface Leaks","D.20-02-045 AL 6071, AL 6045",226.38915428249578,308.48434647250184,308.48434647250184,"ECPT","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045 AL 6071, AL 6045",381.0924643613892,363.84340064715622,363.84340064715622,"Local Transmission","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution","D.20-02-045 AL 6071, AL 6045",24839.85662656404,24959.799583904292,24959.799583904292,"Distribution","N"]
["AMI Balancing Account  (AMIBA)","D.20-02-045 AL 6071, AL 6045",-77756.901095456211,-323.97185928908709,-323.97185928908709,"EPAM","Y"]
["Residential Uncollectible Balancing Account  (RUBA) ","D.20-02-045 AL 6071, AL 6045",16080.829230363346,44745.198352024141,44745.198352024141,"ECPT","Y"]
["Affiliate Transfer Fee Account  (ATFA)","D.20-02-045 AL 6071, AL 6045",-56.852117204809616,-106.52167417156562,-106.52167417156562,"EPAM","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D.20-02-045 AL 6071, AL 6045",10172.083196372587,0,0,"ECPT","Y"]
["Core Fixed Cost Account - Non NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088",-28133.81894370247,121885.43655903419,-12481.017073574887,"CFCA","Y"]
["Core Fixed Cost Account - NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088",9826.72414135078,-1151.9897406335253,-1401.3020835172681,"Non-Residential","Y"]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088",28765.692761009646,0,0,"Non-Residential","Y"]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)","D.20-02-045 AL 6071, AL 6045",395.85348400076731,434.22738384292143,434.22738384292143,"Non-Residential","Y"]
["Enhanced Oil Recovery Account  (EORA)  ","D.20-02-045 AL 6071, AL 6045",2530.5597398430609,-7124.2567864552111,-7124.2567864552111,"EPAM","Y"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)","D.20-02-045 AL 6071, AL 6045",284.26278995019351,441.06566541085317,441.06566541085317,"ECPT","Y"]
["Intervenor Award Memorandum Account  (IAMA)","D.20-02-045 AL 6071, AL 6045",731.58066503521957,832.93717869704278,832.93717869704278,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045 AL 6071, AL 6045",17468.470311041361,24824.504625728128,24824.504625728128,"EPAM","Y"]
["Noncore Fixed Cost Account  (NFCA)  Margin","D.20-02-045 AL 6071, AL 6045",6370.1809775920838,12427.604012052685,12427.604012052685,"Non-Residential","Y"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin","D.20-02-045 AL 6071, AL 6045",-3275.1851982978651,959.63192651874249,959.63192651874249,"Non-Residential","Y"]
["Integrated Transmission Balancing Account  (ITBA) Margin","D.20-02-045 AL 6071, AL 6045",176.09814139595812,5083.8850590894772,5083.8850590894772,"ECPT","Y"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)","D.20-02-045 AL 6071, AL 6045",-1423.0358831880883,3459.772548454087,3459.772548454087,"ECPT","Y"]
["Compression Services Balancing Account  (CSBA)","D.20-02-045 AL 6071, AL 6045",-68.369488844234169,-73.636852931578687,-73.636852931578687,"Non-Residential","Y"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)","D.20-02-045 AL 6071, AL 6045",-1168.4484408377084,5918.6872446137231,5918.6872446137231,"ECPT","Y"]
["Noncore Storage Balancing Account  (NSBA)","D.20-02-045 AL 6071, AL 6045",122.05121759349339,93.946777408666094,93.946777408666094,"ECPT","Y"]
["Pension Balancing Account  (PBA)","D.20-02-045 AL 6071, AL 6045",11312.644088682704,9235.9689255481535,9235.9689255481535,"EPAM","Y"]
["PBOP Balancing Account  (PBOPBA)","D.20-02-045 AL 6071, AL 6045",-4328.4227973909083,-4765.7902742977731,-4765.7902742977731,"EPAM","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission","D.20-02-045 AL 6071, AL 6045",22874.176540558052,24483.535529249115,24483.535529249115,"Local Transmission","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution","D.20-02-045 AL 6071, AL 6045",72521.186822647796,74787.023820241564,74787.023820241564,"Distribution","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission","D.20-02-045 AL 6071, AL 6045",572.09798322721713,-674.07808819608886,-674.07808819608886,"Local Transmission","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution","D.20-02-045 AL 6071, AL 6045",1611.907471579721,2206.0867435845412,2206.0867435845412,"Distribution","Y"]
["Research Royalty Memorandum Account  (RRMA)","D.20-02-045 AL 6071, AL 6045",-160.82445015363919,-247.95082320763703,-247.95082320763703,"EPAM","Y"]
["Self-Generation Program Memorandum Account  (SGPMA)","D.20-02-045 AL 6071, AL 6045",16267.798190288335,16265.025427685592,16265.025427685592,"SGIP","Y"]
["System Operator Gas Account  (SOGA)","D.20-02-045 AL 6071, AL 6045",-57.474724884945573,-54.791024656889135,-54.791024656889135,"ECPT","Y"]
["Rewards & Penalties Balancing Account (RPBA)","D.20-02-045 AL 6071, AL 6045",-266.7671576355873,-288.87206106860225,-288.87206106860225,"EPAM","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045 AL 6071, AL 6045",14313.748177749801,23349.855935962783,23349.855935962783,"EPAM","Y"]
["NonCore Backbone Transmission","D.20-02-045 AL 6071, AL 6045",205899.09902636753,307036.37711891095,307036.37711891095,"Backbone Transmission","N"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance","D.22-07-016, AL 6023",0,35607.3666859636,35607.3666859636,"EPAM","Y"]
["On-Bill Financing Balancing Account (OBFBA)","AL 5853-A",0,4574.3633340208544,4574.3633340208544,"EPAM","Y"]
["System Reliability Memorandum Account   (SRMA)","AL 6045",0,15184.322292874704,15184.322292874704,"ECPT","Y"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ","AL 6045",0,-61.478426684054938,-61.478426684054938,"EPAM","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,3240882.4358018562,3658689.5982735511,3524073.8322980581]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",5107.0718943636321,5106.2014202040336,5106.2014202040336,"ECPT adjusted","N"]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement","D.20-02-045, AL 6071, AL 6045",2676.4558822098343,2388.5750957260152,2388.5750957260152,"ECPT","N"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.20-02-045, AL 6071, AL 6045",421911.65593735001,451660.15168836701,451660.15168836701,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.20-02-045, AL 6071, AL 6045",11523.700831049478,11338.595126925329,11338.595126925329,"47% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.20-02-045, AL 6071, AL 6045",110.10687339904621,-783.15163590176303,-783.15163590176303,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.20-02-045, AL 6071, AL 6045",24082.112323034682,-22703.373092980601,-22703.373092980601,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.20-02-045, AL 6071, AL 6045",96.161475841515269,3057.4967008465737,3057.4967008465737,"47% Res (LUAF, Other)","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount","D.20-02-045, AL 6071, AL 6045",3566.9058998494452,5564.3922693223831,5564.3922693223831,"ECPT adjusted","Y"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ","D.20-02-045, AL 6071, AL 6045",1979.7078861701277,6090.186376418309,6090.186376418309,"EPAM","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ","D.20-02-045, AL 6071, AL 6045",-2147.5120170099681,0,0,"EPAM","Y"]
["TLS Adjustment","D.20-02-045, AL 6071, AL 6045",-6644.931817014658,10390.216028451658,10421.053586768947,"Non-Residential","N"]
["  Natural Gas Leak Abatement Program Revenue Requirement","AL 5915G, AL 6071",86446.464722770907,86431.165118197561,86431.165118197561,"EPAM","N"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ","D.20-02-045, AL 6071, AL 6045",-48.669674355202922,0,0,"EPAM","Y"]
["Diary Biomethane Project Balancing Account  (DBPBA)","D.20-02-045, AL 6071, AL 6045",45457.032564324829,34573.344052610402,34573.344052610402,"EPAM","Y"]
["Diary Biomethane Project Memorandum Account  (DBPMA)","D.20-02-045, AL 6071, AL 6045",0,8114.6562580048067,8114.6562580048067,"EPAM","Y"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)","D.20-02-045, AL 6071, AL 6045",1411.3819701407706,1113.8604547746736,1113.8604547746736,"ECPT adjusted","Y"]
[]
[]
[]
[]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) "," D.21-06-015, AL 6052",229388.13208047274,199514.89150131575,199514.89150131575,"Public Purpose Programs","N"]
["Energy Efficiency "," AL 6052",107144.935,166906.52600000001,166906.52600000001,"Public Purpose Programs","N"]
["RD&D"," AL 6052",12406.90965,12264.871999999999,12264.871999999999,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE"," AL 6052",547.65497000000005,520.25400000000002,520.25400000000002,"Public Purpose Programs","N"]
["Energy Savings Assistance "," D.21-06-015,  AL 6052",0,80174.204849890506,80174.204849890506,"Public Purpose Programs","N"]
["SJVDGPMA","AL 6052",0,806.16499999999996,806.16499999999996,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,945015.27645259723,1062529.2292121728,1062560.06677049]
[]
["EOR","D.20-02-045, AL 6045",-19696.026660334344,-25124.896599589265,-25124.896599589265,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",2584342.1558562312,3301020.3137379293,3301020.3137379293,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,2584342.1558562312,3301020.3137379293,3301020.3137379293]
[]
["Total Authorized Revenue",null,6750543.8414503504,7997114.2446240634,7862529.3162068892]

{"sheet":"Incremental Rev Req ","index":2,"n_rows":133,"n_cols":18,"rows_kept":133,"cut":false,"hidden":false,"merged":[[6,12,6,17],[101,12,101,17],[6,0,6,9],[99,0,99,9],[100,5,100,9]]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended March 31"]
[]
["Current Revenue Requirement ($000):",7862529.3162068892]
["Current Revenue Requirement Effective:","2023-03-01"]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented",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,null,null,null,2023,2024,2025,2026,2027]
["Safety Affordability Reliability Proceedings",null,null,"2023-03-01",null,2023,2024,2025,2026,2027,null,null,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
["Total Allocated Base Margin",null,"D.19-09-051",2813333.2818626408,"Allocated Base Margin",2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2818626408,null,null,"Allocated Base Margin",2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2818626408]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)",null,"D.19-09-051",20972.15159999999,"Local Transmission",20972.15159999999,21205,0,0,0,null,null,"Distribution",131935.67014773039,30316,0,0,0]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)",null,"D.19-09-051",29982.760000000006,"Distribution",29982.760000000006,30316,0,0,0,null,null,"ECPT adjusted",11784.454144301089,0,0,0,0]
["  Company Use Gas: Other",null,"D.20-02-045 AL 6071, AL 6045",2442.7824068004993,"ECPT",2442.7824068004993,0,0,0,0,null,null,"Local Transmission",45145.452441700174,21205,0,0,0]
["  Company Use Gas: Storage Load Balancing",null,"D.20-02-045 AL 6071, AL 6045",2371.288817256519,"ECPT",2371.288817256519,0,0,0,0,null,null,"SGIP",16265.025427685592,0,0,0,0]
["  Exchange Revenues & Interutility Transactions",null,"D.20-02-045 AL 6071, AL 6045",342.77791000000002,"ECPT",342.77791000000002,0,0,0,0,null,null,"GHG End User",428956.77859538642,0,0,0,0]
["  Unaccounted For (UAF) Gas",null,"D.20-02-045 AL 6071, AL 6045",59771.786676696618,"47% Res (LUAF, Other)",59771.786676696618,0,0,0,0,null,null,"Public Purpose Programs",460186.91335120623,407532.26040508621,409108.99744559324,410172.33861179563,0]
["  Well Incidents & Surface Leaks",null,"D.20-02-045 AL 6071, AL 6045",308.48434647250184,"ECPT",308.48434647250184,0,0,0,0,null,null,"Backbone Transmission",307036.37711891095,209446,0,0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045 AL 6071, AL 6045",363.84340064715622,"Local Transmission",363.84340064715622,0,0,0,0,null,null,"47% Res (LUAF, Other)",74167.878504468521,0,0,0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution",null,"D.20-02-045 AL 6071, AL 6045",24959.799583904292,"Distribution",24959.799583904292,0,0,0,0,null,null,"ECPT",82775.781034269574,0,0,0,0]
["AMI Balancing Account  (AMIBA)",null,"D.20-02-045 AL 6071, AL 6045",-323.97185928908709,"EPAM",-323.97185928908709,0,0,0,0,null,null,"EPAM",194757.67280769142,116304.03769119756,34359.908234099996,39396.959277899994,0]
["Residential Uncollectible Balancing Account  (RUBA) ",null,"D.20-02-045 AL 6071, AL 6045",44745.198352024141,"ECPT",44745.198352024141,0,0,0,0,null,null,"CFCA",-12481.017073574887,0,0,0,0]
["Affiliate Transfer Fee Account  (ATFA)",null,"D.20-02-045 AL 6071, AL 6045",-106.52167417156562,"EPAM",-106.52167417156562,0,0,0,0,null,null,"Non-Residential",22767.577972734449,0,0,0,0]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ",null,"D.20-02-045 AL 6071, AL 6045",0,"ECPT",0,0,0,0,0,null,null,"Total",7877652.1600730782,6899156.893696853,6557822.5012802631,6563922.8934902651,6114353.5956005696]
["Core Fixed Cost Account - Non NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088",-12481.017073574887,"CFCA",-12481.017073574887,0,0,0,0,null,null,"CPUC Fee",5.77E-3]
["Core Fixed Cost Account - NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088",-1401.3020835172681,"Non-Residential",-1401.3020835172681,0,0,0,0,null,null,"Check",0,0,0,0,0]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088",0,"Non-Residential",0,0,0,0,0]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)",null,"D.20-02-045 AL 6071, AL 6045",434.22738384292143,"Non-Residential",434.22738384292143,0,0,0,0]
["Enhanced Oil Recovery Account  (EORA)  ",null,"D.20-02-045 AL 6071, AL 6045",-7124.2567864552111,"EPAM",-7124.2567864552111,0,0,0,0]
["Hazardous Substance Cost-Recovery Account  (HSCRA)",null,"D.20-02-045 AL 6071, AL 6045",441.06566541085317,"ECPT",441.06566541085317,0,0,0,0]
["Intervenor Award Memorandum Account  (IAMA)",null,"D.20-02-045 AL 6071, AL 6045",832.93717869704278,"ECPT",832.93717869704278,0,0,0,0]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045 AL 6071, AL 6045",24824.504625728128,"EPAM",24824.504625728128,29872.872572999997,34359.908234099996,39396.959277899994,0]
["Noncore Fixed Cost Account  (NFCA)  Margin",null,"D.20-02-045 AL 6071, AL 6045",12427.604012052685,"Non-Residential",12427.604012052685,0,0,0,0]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin",null,"D.20-02-045 AL 6071, AL 6045",959.63192651874249,"Non-Residential",959.63192651874249,0,0,0,0]
["Integrated Transmission Balancing Account  (ITBA) Margin",null,"D.20-02-045 AL 6071, AL 6045",5083.8850590894772,"ECPT",5083.8850590894772,0,0,0,0]
["Compressor Station Fuel and Power Balancing Account (CFPBA)",null,"D.20-02-045 AL 6071, AL 6045",3459.772548454087,"ECPT",3459.772548454087,0,0,0,0]
["Compression Services Balancing Account  (CSBA)",null,"D.20-02-045 AL 6071, AL 6045",-73.636852931578687,"Non-Residential",-73.636852931578687,0,0,0,0]
["Company-Use Fuel for Load Balancing Account (CUFLBA)",null,"D.20-02-045 AL 6071, AL 6045",5918.6872446137231,"ECPT",5918.6872446137231,0,0,0,0]
["Noncore Storage Balancing Account  (NSBA)",null,"D.20-02-045 AL 6071, AL 6045",93.946777408666094,"ECPT",93.946777408666094,0,0,0,0]
["Pension Balancing Account  (PBA)",null,"D.20-02-045 AL 6071, AL 6045",9235.9689255481535,"EPAM",9235.9689255481535,0,0,0,0]
["PBOP Balancing Account  (PBOPBA)",null,"D.20-02-045 AL 6071, AL 6045",-4765.7902742977731,"EPAM",-4765.7902742977731,0,0,0,0]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission",null,"D.20-02-045 AL 6071, AL 6045",24483.535529249115,"Local Transmission",24483.535529249115,0,0,0,0]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution",null,"D.20-02-045 AL 6071, AL 6045",74787.023820241564,"Distribution",74787.023820241564,0,0,0,0]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission",null,"D.20-02-045 AL 6071, AL 6045",-674.07808819608886,"Local Transmission",-674.07808819608886,0,0,0,0]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution",null,"D.20-02-045 AL 6071, AL 6045",2206.0867435845412,"Distribution",2206.0867435845412,0,0,0,0]
["Research Royalty Memorandum Account  (RRMA)",null,"D.20-02-045 AL 6071, AL 6045",-247.95082320763703,"EPAM",-247.95082320763703,0,0,0,0]
["Self-Generation Program Memorandum Account  (SGPMA)",null,"D.20-02-045 AL 6071, AL 6045",16265.025427685592,"SGIP",16265.025427685592,0,0,0,0]
["System Operator Gas Account  (SOGA)",null,"D.20-02-045 AL 6071, AL 6045",-54.791024656889135,"ECPT",-54.791024656889135,0,0,0,0]
["Rewards & Penalties Balancing Account (RPBA)",null,"D.20-02-045 AL 6071, AL 6045",-288.87206106860225,"EPAM",-288.87206106860225,0,0,0,0]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045 AL 6071, AL 6045",23349.855935962783,"EPAM",23349.855935962783,0,0,0,0]
["NonCore Backbone Transmission",null,"D.20-02-045 AL 6071, AL 6045",307036.37711891095,"Backbone Transmission",307036.37711891095,209446,0,0,0]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance",null,"D.22-07-016, AL 6023",35607.3666859636,"EPAM",35607.3666859636,0,0,0,0]
["On-Bill Financing Balancing Account (OBFBA)",null,"AL 5853-A",4574.3633340208544,"EPAM",4574.3633340208544,0,0,0,0]
["System Reliability Memorandum Account   (SRMA)",null,"AL 6045",15184.322292874704,"ECPT",15184.322292874704,0,0,0,0]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ",null,"AL 6045",-61.478426684054938,"EPAM",-61.478426684054938,0,0,0,0]
[]
[]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",5106.2014202040336,"ECPT adjusted",5106.2014202040336,0,0,0,0]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement",null,"D.20-02-045, AL 6071, AL 6045",2388.5750957260152,"ECPT",2388.5750957260152,0,0,0,0]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.20-02-045, AL 6071, AL 6045",451660.15168836701,"GHG End User",451660.15168836701,0,0,0,0]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.20-02-045, AL 6071, AL 6045",11338.595126925329,"47% Res (LUAF, Other)",11338.595126925329,0,0,0,0]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 6071, AL 6045",-783.15163590176303,"ECPT",-783.15163590176303,0,0,0,0]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 6071, AL 6045",-22703.373092980601,"GHG End User",-22703.373092980601,0,0,0,0]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 6071, AL 6045",3057.4967008465737,"47% Res (LUAF, Other)",3057.4967008465737,0,0,0,0]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.20-02-045, AL 6071, AL 6045",5564.3922693223831,"ECPT adjusted",5564.3922693223831,0,0,0,0]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ",null,"D.20-02-045, AL 6071, AL 6045",6090.186376418309,"EPAM",6090.186376418309,0,0,0,0]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ",null,"D.20-02-045, AL 6071, AL 6045",0,"EPAM",0,0,0,0,0]
["TLS Adjustment",null,"D.20-02-045, AL 6071, AL 6045",10421.053586768947,"Non-Residential",10421.053586768947,0,0,0,0]
["  Natural Gas Leak Abatement Program Revenue Requirement",null,"AL 5915G, AL 6071",86431.165118197561,"EPAM",86431.165118197561,86431.165118197561,0,0,0]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ",null,"D.20-02-045, AL 6071, AL 6045",0,"EPAM",0,0,0,0,0]
["Diary Biomethane Project Balancing Account  (DBPBA)",null,"D.20-02-045, AL 6071, AL 6045",34573.344052610402,"EPAM",34573.344052610402,0,0,0,0]
["Diary Biomethane Project Memorandum Account  (DBPMA)",null,"D.20-02-045, AL 6071, AL 6045",8114.6562580048067,"EPAM",8114.6562580048067,0,0,0,0]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)",null,"D.20-02-045, AL 6071, AL 6045",1113.8604547746736,"ECPT adjusted",1113.8604547746736,0,0,0,0]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) ",null," D.21-06-015, AL 6052",199514.89150131575,"Public Purpose Programs",199514.89150131575,152497.41740508622,154039.11344559322,155411.26861179565,0]
["Energy Efficiency ",null," AL 6052",166906.52600000001,"Public Purpose Programs",166906.52600000001,132220,132220,132220,0]
["RD&D",null," AL 6052",12264.871999999999,"Public Purpose Programs",12264.871999999999,0,0,0,0]
["Bureau Of Equalization BOE",null," AL 6052",520.25400000000002,"Public Purpose Programs",520.25400000000002,0,0,0,0]
["Energy Savings Assistance ",null," D.21-06-015,  AL 6052",80174.204849890506,"Public Purpose Programs",80174.204849890506,122814.84299999999,122849.88400000001,122541.07,0]
["SJVDGPMA",null,null,806.16499999999996,"Public Purpose Programs",806.16499999999996,0,0,0,0]
[]
[]
["EOR",null,"D.20-02-045, AL 6045",-25124.896599589265,"EPAM",-25124.896599589265,0,0,0,0]
[]
[]
["Procurement",null,"D.98-07-068",3301020.3137379293,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,7877652.1600730792,null,7877652.1600730792,6899156.8936968539,6557822.5012802631,6563922.8934902661,6114353.5956005696]
[]
["CPUC Fee",null,null,null,"CPUC Fee",5.77E-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,"Included in Impact",null,"Authorized + Pending"]
["2024 GRC Application","A.22-05-015 ","Application",3366765.1544120777,"Allocated Base Margin",null,847732.71813735925,1132812.7181373592,1386219.7181373592,null,"Y",null,null,2022,2023,2024,2025,2026]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission ","A.22-05-015 ","Application",-5487.0233199999984,"Local Transmission",null,-5487.0233199999984,null,null,null,"Y",null,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution","A.22-05-015 ","Application",63454.58,"Distribution",null,63454.58,null,null,null,"Y",null,"Allocated Base Margin",2813333.2818626408,3661066,3946146,4199553,2813333.2818626408]
["NonCore Backbone Transmission","A.22-05-015 ","Application",22240.277383770008,"Backbone Transmission",null,22240.277383770008,null,null,null,"Y",null,"Distribution",131935.67014773039,93770.58,0,0,0]
["TIMPBA","A.22-05-015","Application",61269,"Local Transmission",null,61269,null,null,null,"Y",null,"ECPT adjusted",11784.454144301089,0,0,0,0]
["TIMPBA","A.22-05-015","Application",169625,"Backbone Transmission",null,169625,null,null,null,"Y",null,"Local Transmission",45145.452441700174,76986.976679999992,0,0,0]
["Hydrogen Blending ","A.22-09-006","Application",14979.078966298401,"ECPT",3232.2396006774802,8301.0481856490205,971.12149486421004,2474.6696851076899,null,"Y",null,"SGIP",16265.025427685592,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"GHG End User",428956.77859538642,0,0,0,0]
["Public Policy Proceedings",null,null,0,null,null,null,null,null,null,"Y",null,"Public Purpose Programs",461792.81335120625,432702.43643847929,434377.48471144628,431043.09504782833,0]
["Natural Gas Leak Abatement","AL 5950","Advice Letter",65768.475030524889,"EPAM",24363.079882730453,41405.395147794436,null,null,null,null,null,"Backbone Transmission",307036.37711891095,401311.27738376998,0,0,0]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,null,null,null,"47% Res (LUAF, Other)",74167.878504468521,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"ECPT",86008.020634947054,8301.0481856490205,971.12149486421004,2474.6696851076899,0]
["Energy Efficiency ","A.22-03-008 ","Application",60415.319735278812,"Public Purpose Programs",null,19467.176033393072,20077.387265853031,20870.756436032709,null,"Y",null,"EPAM",219120.75269042188,157709.43283899198,34359.908234099996,39396.959277899994,0]
["Demand Response","A.23-01-004","Application",12500,"Public Purpose Programs",1605.9,5703,5191.1000000000004,null,null,"Y",null,"CFCA",-12481.017073574887,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,null,"Non-Residential",22767.577972734449,0,0,0,0]
[null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",7906853.3795564873,8132868.0652648201,7716874.8281783387,7973488.0377487652,6114353.5956005696]
[null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Revenues",29201.219483409077,1233711.1715679672,1159052.3268980756,1409565.1442585001,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"CPUC Fee",5.77E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Check Figure",0,3.4458935260772705E-8,-7.6601281762123108E-8,5.0035305321216583E-7,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,0]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,3831529.8622079496,null,29201.219483407935,1233711.1715679655,1159052.3268980766,1409565.1442584996,0]