{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["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":"Authorized Rev Req","index":0,"n_rows":106,"n_cols":5,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended December 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01"]
[null,"Advice Letter:","AL 5915"]
["Filing Description","Authority for Revenue Requirement as of 1/1/2022","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051",2797438.8098034845,"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,"Local Transmission","N"]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)","D.19-09-051",28629.010000000009,"Distribution","N"]
["  Company Use Gas: Other","D.20-02-045, AL 5884, AL 5915G",1792.6929208784113,"ECPT","N"]
["  Company Use Gas: Storage Load Balancing","D.20-02-045, AL 5884, AL 5915G",1739.9823775441146,"ECPT","N"]
["  Exchange Revenues & Interutility Transactions","D.20-02-045, AL 5884, AL 5915G",342.77791000000002,"ECPT","N"]
["  Unaccounted For (UAF) Gas","D.20-02-045, AL 5884, AL 5915G",43865.640785688673,"47% Res (LUAF, Other)","N"]
["  Well Incidents & Surface Leaks","D.20-02-045, AL 5884, AL 5915G",226.38915428249578,"ECPT","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045, AL 5884, AL 5915G",381.0924643613892,"Local Transmission","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution","D.20-02-045, AL 5884, AL 5915G",24839.85662656404,"Distribution","N"]
["AMI Balancing Account  (AMIBA)","D.20-02-045, AL 5884, AL 5915G",-77756.901095456211,"EPAM","Y"]
["Residential Uncollectible Balancing Account  (RUBA) ","D.20-02-045, AL 5884, AL 5915G",16080.829230363346,"ECPT","Y"]
["Affiliate Transfer Fee Account  (ATFA)","D.20-02-045, AL 5884, AL 5915G",-56.852117204809616,"EPAM","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D.20-02-045, AL 5884, AL 5915G",10172.083196372587,"ECPT","Y"]
["Core Fixed Cost Account - Non NGV  (CFCA) ","D.20-02-045, AL 5884, AL 5915G",-28133.81894370247,"CFCA","Y"]
["Core Fixed Cost Account - NGV  (CFCA) ","D.20-02-045, AL 5884, AL 5915G",9826.72414135078,"Non-Residential","Y"]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ","D.20-02-045, AL 5884, AL 5915G",28765.692761009646,"Non-Residential","Y"]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)","D.20-02-045, AL 5884, AL 5915G",395.85348400076731,"Non-Residential","Y"]
["Enhanced Oil Recovery Account  (EORA)  ","D.20-02-045, AL 5884, AL 5915G",2530.5597398430609,"EPAM","Y"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)","D.20-02-045, AL 5884, AL 5915G",284.26278995019351,"ECPT","Y"]
["Intervenor Award Memorandum Account  (IAMA)","D.20-02-045, AL 5884, AL 5915G",731.58066503521957,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045, AL 5884, AL 5915G",17468.470311041361,"EPAM","Y"]
["Noncore Fixed Cost Account  (NFCA)  Margin","D.20-02-045, AL 5884, AL 5915G",6370.1809775920838,"Non-Residential","Y"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin","D.20-02-045, AL 5884, AL 5915G",-3275.1851982978651,"Non-Residential","Y"]
["Integrated Transmission Balancing Account  (ITBA) Margin","D.20-02-045, AL 5884, AL 5915G",176.09814139595812,"ECPT","Y"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)","D.20-02-045, AL 5884, AL 5915G",-1423.0358831880883,"ECPT","Y"]
["Compression Services Balancing Account  (CSBA)","D.20-02-045, AL 5884, AL 5915G",-68.369488844234169,"Non-Residential","Y"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)","D.20-02-045, AL 5884, AL 5915G",-1168.4484408377084,"ECPT","Y"]
["Noncore Storage Balancing Account  (NSBA)","D.20-02-045, AL 5884, AL 5915G",122.05121759349339,"ECPT","Y"]
["Pension Balancing Account  (PBA)","D.20-02-045, AL 5884, AL 5915G",11312.644088682704,"EPAM","Y"]
["PBOP Balancing Account  (PBOPBA)","D.20-02-045, AL 5884, AL 5915G",-4328.4227973909083,"EPAM","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission","D.20-02-045, AL 5884, AL 5915G",22874.176540558052,"Local Transmission","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution","D.20-02-045, AL 5884, AL 5915G",72521.186822647796,"Distribution","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission","D.20-02-045, AL 5884, AL 5915G",572.09798322721713,"Local Transmission","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution","D.20-02-045, AL 5884, AL 5915G",1611.907471579721,"Distribution","Y"]
["Research Royalty Memorandum Account  (RRMA)","D.20-02-045, AL 5884, AL 5915G",-160.82445015363919,"EPAM","Y"]
["Self-Generation Program Memorandum Account  (SGPMA)","D.20-02-045, AL 5884, AL 5915G",16267.798190288335,"SGIP","Y"]
["System Operator Gas Account  (SOGA)","D.20-02-045, AL 5884, AL 5915G",-57.474724884945573,"ECPT","Y"]
["Rewards & Penalties Balancing Account (RPBA)","D.20-02-045, AL 5884, AL 5915G",-266.7671576355873,"EPAM","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 5884, AL 5915G",14313.748177749801,"EPAM","Y"]
["NonCore Backbone Transmission","D.20-02-045, AL 5884, AL 5915G",205899.09902636753,"Backbone Transmission","N"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance","D.22-07-016, AL 6023",0,"EPAM","Y"]
["On-Bill Financing Balancing Account (OBFBA)","AL 5853-A",0,"EPAM","Y"]
[]
[]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C9:C54)","v":3240882.4358018562}]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",5107.0718943636321,"ECPT adjusted","N"]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement","D.20-02-045, AL 5884, AL 5915G",2676.4558822098343,"ECPT","N"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.20-02-045, AL 5884, AL 5915G",421911.65593735001,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.20-02-045, AL 5884, AL 5915G",11523.700831049478,"47% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.20-02-045, AL 5884, AL 5915G",110.10687339904621,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.20-02-045, AL 5884, AL 5915G",24082.112323034682,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.20-02-045, AL 5884, AL 5915G",96.161475841515269,"47% Res (LUAF, Other)","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount","D.20-02-045, AL 5884, AL 5915G",3566.9058998494452,"ECPT adjusted","Y"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ","D.20-02-045, AL 5884, AL 5915G",1979.7078861701277,"EPAM","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ","D.20-02-045, AL 5884, AL 5915G",-2147.5120170099681,"EPAM","Y"]
["TLS Adjustment","D.20-02-045, AL 5884, AL 5915G",-6644.931817014658,"Non-Residential","N"]
["  Natural Gas Leak Abatement Program Revenue Requirement","AL 5915G",86446.464722770907,"EPAM","N"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ","D.20-02-045, AL 5884, AL 5915G",-48.669674355202922,"EPAM","Y"]
["Diary Biomethane Project Balancing Account  (DBPBA)","D.20-02-045, AL 5884, AL 5915G",45457.032564324829,"EPAM","Y"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)","D.20-02-045, AL 5884, AL 5915G",1411.3819701407706,"ECPT adjusted","Y"]
[]
[]
[]
[]
[]
[]
[]
[]
["California Alternate Rates for Energy (CARE) ","AL 5891G, D.21-06-015",229388.13208047274,"Public Purpose Programs","N"]
["Energy Efficiency ","AL 5891G, AL 5898-A",107144.935,"Public Purpose Programs","N"]
["RD&D","AL 5891G",12406.90965,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 5891G",547.65497000000005,"Public Purpose Programs","N"]
["Energy Savings Assistance","AL 5891G, D.21-06-015",{"$f":"0","v":0},"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C58:C92)","v":945015.27645259723}]
[]
["EOR","D.20-02-045, AL 5884",-19696.026660334344,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",2584342.1558562312,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procrement",null,{"$f":"SUM(C98:C103)","v":2584342.1558562312}]
[]
["Total Authorized Revenue",null,{"$f":"C55+C93+C104+C95","v":6750543.8414503504}]

{"sheet":"Incremental Rev Req","index":1,"n_rows":126,"n_cols":10,"rows_kept":126,"cut":false,"hidden":false,"merged":[[6,0,6,9],[94,0,94,9],[95,5,95,9]]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended December 31"]
[]
["Current Revenue Requirement ($000):",6750543.8414503504]
["Current Revenue Requirement Effective:","2022-01-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"]
["Safety Affordability Reliability Proceedings",null,null,{"$f":"B6","v":"2022-01-01"},null,2022,2023,2024,2025,2026]
["Total Allocated Base Margin",null,"D.19-09-051",{"$f":"F10","v":2797438.8098034845},"Allocated Base Margin",2797438.8098034845,3611906,{"$f":"G10","v":3611906},{"$f":"H10","v":3611906},{"$f":"I10","v":3611906}]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)",null,"D.19-09-051",{"$f":"F11","v":20025.239099999992},"Local Transmission",20025.239099999992,21205.1253,{"$f":"G11","v":21205.1253},{"$f":"0","v":0},{"$f":"0","v":0}]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)",null,"D.19-09-051",28629.010000000009,"Distribution",28629.010000000009,30315.83,{"$f":"G12","v":30315.83},{"$f":"0","v":0},{"$f":"0","v":0}]
["  Company Use Gas: Other",null,"D.20-02-045, AL 5884, AL 5915G",1792.6929208784113,"ECPT",1792.6929208784113,{"$f":"F13","v":1792.6929208784113},{"$f":"0","v":0},{"$f":"H13","v":0},0]
["  Company Use Gas: Storage Load Balancing",null,"D.20-02-045, AL 5884, AL 5915G",1739.9823775441146,"ECPT",1739.9823775441146,{"$f":"F14","v":1739.9823775441146},{"$f":"0","v":0},0,0]
["  Exchange Revenues & Interutility Transactions",null,"D.20-02-045, AL 5884, AL 5915G",342.77791000000002,"ECPT",342.77791000000002,342.77791000000002,{"$f":"0","v":0},0,0]
["  Unaccounted For (UAF) Gas",null,"D.20-02-045, AL 5884, AL 5915G",43865.640785688673,"47% Res (LUAF, Other)",43865.640785688673,43865.640785688673,{"$f":"0","v":0},0,0]
["  Well Incidents & Surface Leaks",null,"D.20-02-045, AL 5884, AL 5915G",226.38915428249578,"ECPT",226.38915428249578,226.38915428249578,{"$f":"0","v":0},0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045, AL 5884, AL 5915G",381.0924643613892,"Local Transmission",381.0924643613892,381.0924643613892,{"$f":"0","v":0},0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution",null,"D.20-02-045, AL 5884, AL 5915G",24839.85662656404,"Distribution",24839.85662656404,24839.85662656404,{"$f":"0","v":0},0,0]
["AMI Balancing Account  (AMIBA)",null,"D.20-02-045, AL 5884, AL 5915G",-77756.901095456211,"EPAM",-77756.901095456211,-77756.901095456211,{"$f":"0","v":0},0,0]
["Residential Uncollectible Balancing Account  (RUBA) ",null,"D.20-02-045, AL 5884, AL 5915G",16080.829230363346,"ECPT",16080.829230363346,16080.829230363346,{"$f":"0","v":0},0,0]
["Affiliate Transfer Fee Account  (ATFA)",null,"D.20-02-045, AL 5884, AL 5915G",-56.852117204809616,"EPAM",-56.852117204809616,-56.852117204809616,{"$f":"0","v":0},0,0]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ",null,"D.20-02-045, AL 5884, AL 5915G",10172.083196372587,"ECPT",10172.083196372587,10172.083196372587,{"$f":"0","v":0},0,0]
["Core Fixed Cost Account - Non NGV  (CFCA) ",null,"D.20-02-045, AL 5884, AL 5915G",-28133.81894370247,"CFCA",-28133.81894370247,-28133.81894370247,{"$f":"0","v":0},0,0]
["Core Fixed Cost Account - NGV  (CFCA) ",null,"D.20-02-045, AL 5884, AL 5915G",9826.72414135078,"Non-Residential",9826.72414135078,9826.72414135078,{"$f":"0","v":0},0,0]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ",null,"D.20-02-045, AL 5884, AL 5915G",28765.692761009646,"Non-Residential",28765.692761009646,28765.692761009646,{"$f":"0","v":0},0,0]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)",null,"D.20-02-045, AL 5884, AL 5915G",395.85348400076731,"Non-Residential",395.85348400076731,395.85348400076731,{"$f":"0","v":0},0,0]
["Enhanced Oil Recovery Account  (EORA)  ",null,"D.20-02-045, AL 5884, AL 5915G",2530.5597398430609,"EPAM",2530.5597398430609,2530.5597398430609,{"$f":"0","v":0},0,0]
["Hazardous Substance Cost-Recovery Account  (HSCRA)",null,"D.20-02-045, AL 5884, AL 5915G",284.26278995019351,"ECPT",284.26278995019351,284.26278995019351,{"$f":"0","v":0},0,0]
["Intervenor Award Memorandum Account  (IAMA)",null,"D.20-02-045, AL 5884, AL 5915G",731.58066503521957,"ECPT",731.58066503521957,731.58066503521957,{"$f":"0","v":0},0,0]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045, AL 5884, AL 5915G",17468.470311041361,"EPAM",17468.470311041361,26489.889742499996,29872.872572999997,34359.908234099996,39396.959277899994]
["Noncore Fixed Cost Account  (NFCA)  Margin",null,"D.20-02-045, AL 5884, AL 5915G",6370.1809775920838,"Non-Residential",6370.1809775920838,{"$f":"F32","v":6370.1809775920838},{"$f":"0","v":0},0,0]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin",null,"D.20-02-045, AL 5884, AL 5915G",-3275.1851982978651,"Non-Residential",-3275.1851982978651,{"$f":"F33","v":-3275.1851982978651},{"$f":"0","v":0},0,0]
["Integrated Transmission Balancing Account  (ITBA) Margin",null,"D.20-02-045, AL 5884, AL 5915G",176.09814139595812,"ECPT",176.09814139595812,176.09814139595812,{"$f":"0","v":0},0,0]
["Compressor Station Fuel and Power Balancing Account (CFPBA)",null,"D.20-02-045, AL 5884, AL 5915G",-1423.0358831880883,"ECPT",-1423.0358831880883,-1423.0358831880883,{"$f":"0","v":0},0,0]
["Compression Services Balancing Account  (CSBA)",null,"D.20-02-045, AL 5884, AL 5915G",-68.369488844234169,"Non-Residential",-68.369488844234169,-68.369488844234169,{"$f":"0","v":0},0,0]
["Company-Use Fuel for Load Balancing Account (CUFLBA)",null,"D.20-02-045, AL 5884, AL 5915G",-1168.4484408377084,"ECPT",-1168.4484408377084,-1168.4484408377084,{"$f":"0","v":0},0,0]
["Noncore Storage Balancing Account  (NSBA)",null,"D.20-02-045, AL 5884, AL 5915G",122.05121759349339,"ECPT",122.05121759349339,122.05121759349339,{"$f":"0","v":0},0,0]
["Pension Balancing Account  (PBA)",null,"D.20-02-045, AL 5884, AL 5915G",11312.644088682704,"EPAM",11312.644088682704,11312.644088682704,{"$f":"0","v":0},{"$f":"H39","v":0},0]
["PBOP Balancing Account  (PBOPBA)",null,"D.20-02-045, AL 5884, AL 5915G",-4328.4227973909083,"EPAM",-4328.4227973909083,-4328.4227973909083,{"$f":"0","v":0},0,0]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission",null,"D.20-02-045, AL 5884, AL 5915G",22874.176540558052,"Local Transmission",22874.176540558052,22874.176540558052,{"$f":"0","v":0},0,0]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution",null,"D.20-02-045, AL 5884, AL 5915G",72521.186822647796,"Distribution",72521.186822647796,72521.186822647796,{"$f":"0","v":0},0,0]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission",null,"D.20-02-045, AL 5884, AL 5915G",572.09798322721713,"Local Transmission",572.09798322721713,572.09798322721713,{"$f":"0","v":0},0,0]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution",null,"D.20-02-045, AL 5884, AL 5915G",1611.907471579721,"Distribution",1611.907471579721,1611.907471579721,{"$f":"0","v":0},0,0]
["Research Royalty Memorandum Account  (RRMA)",null,"D.20-02-045, AL 5884, AL 5915G",-160.82445015363919,"EPAM",-160.82445015363919,-160.82445015363919,{"$f":"0","v":0},0,0]
["Self-Generation Program Memorandum Account  (SGPMA)",null,"D.20-02-045, AL 5884, AL 5915G",16267.798190288335,"SGIP",16267.798190288335,16267.798190288335,{"$f":"0","v":0},0,0]
["System Operator Gas Account  (SOGA)",null,"D.20-02-045, AL 5884, AL 5915G",-57.474724884945573,"ECPT",-57.474724884945573,-57.474724884945573,{"$f":"0","v":0},0,0]
["Rewards & Penalties Balancing Account (RPBA)",null,"D.20-02-045, AL 5884, AL 5915G",-266.7671576355873,"EPAM",-266.7671576355873,-266.7671576355873,{"$f":"0","v":0},0,0]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 5884, AL 5915G",14313.748177749801,"EPAM",14313.748177749801,14313.748177749801,{"$f":"0","v":0},0,0]
["NonCore Backbone Transmission",null,"D.20-02-045, AL 5884, AL 5915G",205899.09902636753,"Backbone Transmission",205899.09902636753,209446.25243396754,{"$f":"G50","v":209446.25243396754},{"$f":"0","v":0},0]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance",null,"D.22-07-016, AL 6023",0,"EPAM",0,35607.377042387088,0,0,0]
["On-Bill Financing Balancing Account (OBFBA)",null,"AL 5853-A",{"$f":"F52","v":0},"EPAM",0,4574.3646644771143,{"$f":"0","v":0},0,0]
[]
[]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",{"$f":"F58","v":5107.0718943636321},"ECPT adjusted",5107.0718943636321,{"$f":"F58","v":5107.0718943636321},{"$f":"0","v":0},{"$f":"H58","v":0},0]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement",null,"D.20-02-045, AL 5884, AL 5915G",{"$f":"F59","v":2676.4558822098343},"ECPT",2676.4558822098343,{"$f":"F59","v":2676.4558822098343},{"$f":"0","v":0},0,0]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.20-02-045, AL 5884, AL 5915G",421911.65593735001,"GHG End User",421911.65593735001,421911.65593735001,{"$f":"0","v":0},0,0]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.20-02-045, AL 5884, AL 5915G",11523.700831049478,"47% Res (LUAF, Other)",11523.700831049478,11523.700831049478,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 5884, AL 5915G",110.10687339904621,"ECPT",110.10687339904621,110.10687339904621,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 5884, AL 5915G",24082.112323034682,"GHG End User",24082.112323034682,24082.112323034682,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 5884, AL 5915G",96.161475841515269,"47% Res (LUAF, Other)",96.161475841515269,96.161475841515269,{"$f":"0","v":0},0,0]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.20-02-045, AL 5884, AL 5915G",3566.9058998494452,"ECPT adjusted",3566.9058998494452,3566.9058998494452,{"$f":"0","v":0},0,0]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ",null,"D.20-02-045, AL 5884, AL 5915G",1979.7078861701277,"EPAM",1979.7078861701277,1979.7078861701277,{"$f":"0","v":0},0,0]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ",null,"D.20-02-045, AL 5884, AL 5915G",-2147.5120170099681,"EPAM",-2147.5120170099681,-2147.5120170099681,{"$f":"0","v":0},0,0]
["TLS Adjustment",null,"D.20-02-045, AL 5884, AL 5915G",-6644.931817014658,"Non-Residential",-6644.931817014658,-6644.931817014658,{"$f":"0","v":0},0,0]
["  Natural Gas Leak Abatement Program Revenue Requirement",null,"AL 5915G",86446.464722770907,"EPAM",86446.464722770907,{"$f":"F69","v":86446.464722770907},{"$f":"G69","v":86446.464722770907},{"$f":"0","v":0},{"$f":"0","v":0}]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ",null,"D.20-02-045, AL 5884, AL 5915G",-48.669674355202922,"EPAM",-48.669674355202922,{"$f":"F70","v":-48.669674355202922},{"$f":"0","v":0},{"$f":"H70","v":0},0]
["Diary Biomethane Project Balancing Account  (DBPBA)",null,"D.20-02-045, AL 5884, AL 5915G",45457.032564324829,"EPAM",45457.032564324829,{"$f":"F71","v":45457.032564324829},{"$f":"0","v":0},0,0]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)",null,"D.20-02-045, AL 5884, AL 5915G",1411.3819701407706,"ECPT adjusted",1411.3819701407706,1411.3819701407706,{"$f":"0","v":0},0,0]
[]
[]
["California Alternate Rates for Energy (CARE) ",null,"AL 5891G, D.21-06-015",{"$f":"F75","v":229388.13208047274},"Public Purpose Programs",229388.13208047274,150983.27958214204,152497.41740508622,154039.11344559322,155411.26861179565]
["Energy Efficiency ",null,"AL 5891G, AL 5898-A",{"$f":"F76","v":107144.935},"Public Purpose Programs",107144.935,132220.36343247839,{"$f":"G76","v":132220.36343247839},132220.36343247839,132220.36343247839]
["RD&D",null,"AL 5891G",12406.90965,"Public Purpose Programs",12406.90965,{"$f":"F77","v":12406.90965},{"$f":"0","v":0},0,0]
["Bureau Of Equalization BOE",null,"AL 5891G",547.65497000000005,"Public Purpose Programs",547.65497000000005,{"$f":"F78","v":547.65497000000005},{"$f":"0","v":0},0,0]
["Energy Savings Assistance",null,"AL 5891G, D.21-06-015",0,"Public Purpose Programs",0,122824.705,122814.84299999999,122849.88400000001,122541.07]
[]
[]
[]
["EOR",null,"D.20-02-045, AL 5884",{"$f":"F83","v":-19696.026660334344},"EPAM",-19696.026660334344,{"$f":"F83","v":-19696.026660334344},{"$f":"0","v":0},{"$f":"H83","v":0},0]
[]
[]
["Procurement",null,"D.98-07-068",{"$f":"F86","v":2584342.1558562312},"Core Procurement",2584342.1558562312,{"$f":"0","v":0},{"$f":"G86","v":0},{"$f":"H86","v":0},{"$f":"I86","v":0}]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D10:D89)","v":6750543.8414503494},null,{"$f":"SUM(F10:F89)","v":6750543.8414503494},{"$f":"SUM(G10:G89)","v":5105781.1774707055},{"$f":"SUM(H10:H89)","v":4396725.1688673031},{"$f":"SUM(I10:I89)","v":4055375.2691121711},{"$f":"SUM(J10:J89)","v":4061475.6613221741}]
[]
["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,2022,2023,2024,2025,2026]
["2024 GRC Application","A.22-05-015 ","Application",{"$f":"SUM(F98:J98)","v":971047},"Allocated Base Margin",null,null,{"$f":"3661066-H10","v":49160},{"$f":"3946146-I10","v":334240},{"$f":"4199553-J10","v":587647}]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission ","A.22-05-015 ","Application",-5487.1486199999981,"Local Transmission",null,null,-5487.1486199999981]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution","A.22-05-015 ","Application",63454.75,"Distribution",null,null,63454.75]
["NonCore Backbone Transmission","A.22-05-015 ","Application",22240.277383770008,"Backbone Transmission",null,null,22240.277383770008]
["TIMPBA","A.22-05-015","Application",61269,"Local Transmission",null,null,61269]
["TIMPBA","A.22-05-015","Application",169625,"Backbone Transmission",null,null,169625]
["Public Policy Proceedings",null,null,0]
["Natural Gas Leak Abatement","AL 5950","Advice Letter",41407.627077229088,"EPAM",null,null,41407.627077229088]
["Triennial Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",null,0,0,0,0]
["SoCalGas Cost of Capital Application ","A. 22-04-011","Application",246000,"EPAM",null,61500,61500,61500,61500]
["Energy Efficiency ","A.22-03-008 ","Application",{"$f":"SUM(F108:J108)","v":60415.319735278812},"Public Purpose Programs",null,null,19467.176033393072,20077.387265853031,20870.756436032709]
["PPPS Filing","AL 6052","Advice Letter",{"$f":"SUM(F109:J109)","v":45876.537615757028},"Public Purpose Programs",null,45876.537615757028]
[null,null,null,0]
[null,null,null,0]
["Regulatory Account Update","AL 6045","Advice Letter",621.15203150306888,"Local Transmission",null,621.15203150306888]
["Regulatory Account Update","AL 6045","Advice Letter",4388.8782611806782,"Distribution",null,4388.8782611806782]
["Regulatory Account Update","AL 6045","Advice Letter",18693.950334130343,"47% Res (LUAF, Other)",null,18693.950334130343]
["Regulatory Account Update","AL 6045","Advice Letter",-12795.428847690011,"Non-Residential",null,-12795.428847690011]
["Regulatory Account Update","AL 6045","Advice Letter",1699.0943799472423,"ECPT adjusted",null,1699.0943799472423]
["Regulatory Account Update","AL 6045","Advice Letter",-2.7727626027426595,"SGIP",null,-2.7727626027426595]
["Regulatory Account Update","AL 6045","Advice Letter",150019.25550273666,"CFCA",null,150019.25550273666]
["Regulatory Account Update","AL 6045","Advice Letter",50970.421716961988,"ECPT",null,50970.421716961988]
["Regulatory Account Update","AL 6045","Advice Letter",101166.01276049561,"EPAM",null,101166.01276049561]
["Regulatory Account Update","AL 6045","Advice Letter",-775165.71813735925,"Allocated Base Margin",null,-775165.71813735925]
["Regulatory Account Update","AL 6045","Advice Letter",98455.557243697636,"Backbone Transmission",null,98455.557243697636]
["Regulatory Account Update","AL 6045","Advice Letter",-17036.989664998277,"GHG End User",null,-17036.989664998277]
[null,null,null,0]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D98:D124)","v":1296861.7760100376},null,{"$f":"SUM(F98:F125)","v":0},{"$f":"SUM(G98:G125)","v":-271610.04956623999},{"$f":"SUM(H98:H125)","v":482636.68187439215},{"$f":"SUM(I98:I125)","v":415817.387265853},670017.75643603271]