{"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":92,"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":107,"n_cols":5,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Southern California Gas Company"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended September 30"]
["Submitted October 14, 2022"]
[]
[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"]
["SoCalGas General Rate Case (GRC) Attrition Year 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(C10:C55)","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(C59:C93)","v":945015.27645259723}]
[]
["EOR","D.20-02-045, AL 5884",-19696.026660334344,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",{"$f":"3290999*0.6634475","v":2183405.0590524999},"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procrement",null,{"$f":"SUM(C99:C104)","v":2183405.0590524999}]
[]
["Total Authorized Revenue",null,{"$f":"C56+C94+C105+C96","v":6349606.7446466191}]

{"sheet":"Incremental Rev Req","index":1,"n_rows":127,"n_cols":10,"rows_kept":127,"cut":false,"hidden":false,"merged":[[96,5,96,9],[7,0,7,9],[95,0,95,9]]}
["Southern California Gas Company"]
["Annual Period 2022"]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended September 30"}]
["Submitted October 14, 2022"]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!C107","v":6349606.7446466191}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!C6","v":"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":"B7","v":"2022-01-01"},null,2022,2023,2024,2025,2026]
[{"$f":"'Authorized Rev Req'!A10","v":"SoCalGas General Rate Case (GRC) Attrition Year Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B10","v":"D.19-09-051"},{"$f":"F11","v":2797438.8098034845},{"$f":"'Authorized Rev Req'!D10","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!C10","v":2797438.8098034845},3611906,{"$f":"G11","v":3611906},{"$f":"H11","v":3611906},{"$f":"I11","v":3611906}]
[{"$f":"'Authorized Rev Req'!A11","v":"Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B11","v":"D.19-09-051"},{"$f":"F12","v":20025.239099999992},{"$f":"'Authorized Rev Req'!D11","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C11","v":20025.239099999992},21205.1253,{"$f":"G12","v":21205.1253},{"$f":"0","v":0},{"$f":"0","v":0}]
[{"$f":"'Authorized Rev Req'!A12","v":"Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B12","v":"D.19-09-051"},28629.010000000009,{"$f":"'Authorized Rev Req'!D12","v":"Distribution"},{"$f":"'Authorized Rev Req'!C12","v":28629.010000000009},30315.83,{"$f":"G13","v":30315.83},{"$f":"0","v":0},{"$f":"0","v":0}]
[{"$f":"'Authorized Rev Req'!A13","v":"  Company Use Gas: Other"},null,{"$f":"'Authorized Rev Req'!B13","v":"D.20-02-045, AL 5884, AL 5915G"},1792.6929208784113,{"$f":"'Authorized Rev Req'!D13","v":"ECPT"},{"$f":"'Authorized Rev Req'!C13","v":1792.6929208784113},{"$f":"0","v":0},{"$f":"G14","v":0},{"$f":"H14","v":0},{"$f":"I14","v":0}]
[{"$f":"'Authorized Rev Req'!A14","v":"  Company Use Gas: Storage Load Balancing"},null,{"$f":"'Authorized Rev Req'!B14","v":"D.20-02-045, AL 5884, AL 5915G"},1739.9823775441146,{"$f":"'Authorized Rev Req'!D14","v":"ECPT"},{"$f":"'Authorized Rev Req'!C14","v":1739.9823775441146},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A15","v":"  Exchange Revenues & Interutility Transactions"},null,{"$f":"'Authorized Rev Req'!B15","v":"D.20-02-045, AL 5884, AL 5915G"},342.77791000000002,{"$f":"'Authorized Rev Req'!D15","v":"ECPT"},{"$f":"'Authorized Rev Req'!C15","v":342.77791000000002},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A16","v":"  Unaccounted For (UAF) Gas"},null,{"$f":"'Authorized Rev Req'!B16","v":"D.20-02-045, AL 5884, AL 5915G"},43865.640785688673,{"$f":"'Authorized Rev Req'!D16","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C16","v":43865.640785688673},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A17","v":"  Well Incidents & Surface Leaks"},null,{"$f":"'Authorized Rev Req'!B17","v":"D.20-02-045, AL 5884, AL 5915G"},226.38915428249578,{"$f":"'Authorized Rev Req'!D17","v":"ECPT"},{"$f":"'Authorized Rev Req'!C17","v":226.38915428249578},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A18","v":"SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B18","v":"D.20-02-045, AL 5884, AL 5915G"},381.0924643613892,{"$f":"'Authorized Rev Req'!D18","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C18","v":381.0924643613892},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.20-02-045, AL 5884, AL 5915G"},24839.85662656404,{"$f":"'Authorized Rev Req'!D19","v":"Distribution"},{"$f":"'Authorized Rev Req'!C19","v":24839.85662656404},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A20","v":"AMI Balancing Account  (AMIBA)"},null,{"$f":"'Authorized Rev Req'!B20","v":"D.20-02-045, AL 5884, AL 5915G"},-77756.901095456211,{"$f":"'Authorized Rev Req'!D20","v":"EPAM"},{"$f":"'Authorized Rev Req'!C20","v":-77756.901095456211},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"Residential Uncollectible Balancing Account  (RUBA) "},null,{"$f":"'Authorized Rev Req'!B21","v":"D.20-02-045, AL 5884, AL 5915G"},16080.829230363346,{"$f":"'Authorized Rev Req'!D21","v":"ECPT"},{"$f":"'Authorized Rev Req'!C21","v":16080.829230363346},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A22","v":"Affiliate Transfer Fee Account  (ATFA)"},null,{"$f":"'Authorized Rev Req'!B22","v":"D.20-02-045, AL 5884, AL 5915G"},-56.852117204809616,{"$f":"'Authorized Rev Req'!D22","v":"EPAM"},{"$f":"'Authorized Rev Req'!C22","v":-56.852117204809616},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A23","v":"Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  "},null,{"$f":"'Authorized Rev Req'!B23","v":"D.20-02-045, AL 5884, AL 5915G"},10172.083196372587,{"$f":"'Authorized Rev Req'!D23","v":"ECPT"},{"$f":"'Authorized Rev Req'!C23","v":10172.083196372587},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A24","v":"Core Fixed Cost Account - Non NGV  (CFCA) "},null,{"$f":"'Authorized Rev Req'!B24","v":"D.20-02-045, AL 5884, AL 5915G"},-28133.81894370247,{"$f":"'Authorized Rev Req'!D24","v":"CFCA"},{"$f":"'Authorized Rev Req'!C24","v":-28133.81894370247},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A25","v":"Core Fixed Cost Account - NGV  (CFCA) "},null,{"$f":"'Authorized Rev Req'!B25","v":"D.20-02-045, AL 5884, AL 5915G"},9826.72414135078,{"$f":"'Authorized Rev Req'!D25","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C25","v":9826.72414135078},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A26","v":"Core Fixed Cost Account - C&I   Shortfall (CFCA) "},null,{"$f":"'Authorized Rev Req'!B26","v":"D.20-02-045, AL 5884, AL 5915G"},28765.692761009646,{"$f":"'Authorized Rev Req'!D26","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C26","v":28765.692761009646},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A27","v":"Economic Practicality Shortfall Memorandum Account  (EPSMA)"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.20-02-045, AL 5884, AL 5915G"},395.85348400076731,{"$f":"'Authorized Rev Req'!D27","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C27","v":395.85348400076731},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A28","v":"Enhanced Oil Recovery Account  (EORA)  "},null,{"$f":"'Authorized Rev Req'!B28","v":"D.20-02-045, AL 5884, AL 5915G"},2530.5597398430609,{"$f":"'Authorized Rev Req'!D28","v":"EPAM"},{"$f":"'Authorized Rev Req'!C28","v":2530.5597398430609},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A29","v":"Hazardous Substance Cost-Recovery Account  (HSCRA)"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.20-02-045, AL 5884, AL 5915G"},284.26278995019351,{"$f":"'Authorized Rev Req'!D29","v":"ECPT"},{"$f":"'Authorized Rev Req'!C29","v":284.26278995019351},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A30","v":"Intervenor Award Memorandum Account  (IAMA)"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.20-02-045, AL 5884, AL 5915G"},731.58066503521957,{"$f":"'Authorized Rev Req'!D30","v":"ECPT"},{"$f":"'Authorized Rev Req'!C30","v":731.58066503521957},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A31","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.20-02-045, AL 5884, AL 5915G"},17468.470311041361,{"$f":"'Authorized Rev Req'!D31","v":"EPAM"},{"$f":"'Authorized Rev Req'!C31","v":17468.470311041361},26489.889742499996,29872.872572999997,34359.908234099996,39396.959277899994]
[{"$f":"'Authorized Rev Req'!A32","v":"Noncore Fixed Cost Account  (NFCA)  Margin"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.20-02-045, AL 5884, AL 5915G"},6370.1809775920838,{"$f":"'Authorized Rev Req'!D32","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C32","v":6370.1809775920838},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A33","v":"Noncore Fixed Cost Account  (NFCA)  Nonmargin"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.20-02-045, AL 5884, AL 5915G"},-3275.1851982978651,{"$f":"'Authorized Rev Req'!D33","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C33","v":-3275.1851982978651},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A34","v":"Integrated Transmission Balancing Account  (ITBA) Margin"},null,{"$f":"'Authorized Rev Req'!B34","v":"D.20-02-045, AL 5884, AL 5915G"},176.09814139595812,{"$f":"'Authorized Rev Req'!D34","v":"ECPT"},{"$f":"'Authorized Rev Req'!C34","v":176.09814139595812},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A35","v":"Compressor Station Fuel and Power Balancing Account (CFPBA)"},null,{"$f":"'Authorized Rev Req'!B35","v":"D.20-02-045, AL 5884, AL 5915G"},-1423.0358831880883,{"$f":"'Authorized Rev Req'!D35","v":"ECPT"},{"$f":"'Authorized Rev Req'!C35","v":-1423.0358831880883},{"$f":"0","v":0},{"$f":"G36","v":0},{"$f":"H36","v":0},{"$f":"I36","v":0}]
[{"$f":"'Authorized Rev Req'!A36","v":"Compression Services Balancing Account  (CSBA)"},null,{"$f":"'Authorized Rev Req'!B36","v":"D.20-02-045, AL 5884, AL 5915G"},-68.369488844234169,{"$f":"'Authorized Rev Req'!D36","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C36","v":-68.369488844234169},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A37","v":"Company-Use Fuel for Load Balancing Account (CUFLBA)"},null,{"$f":"'Authorized Rev Req'!B37","v":"D.20-02-045, AL 5884, AL 5915G"},-1168.4484408377084,{"$f":"'Authorized Rev Req'!D37","v":"ECPT"},{"$f":"'Authorized Rev Req'!C37","v":-1168.4484408377084},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A38","v":"Noncore Storage Balancing Account  (NSBA)"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.20-02-045, AL 5884, AL 5915G"},122.05121759349339,{"$f":"'Authorized Rev Req'!D38","v":"ECPT"},{"$f":"'Authorized Rev Req'!C38","v":122.05121759349339},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A39","v":"Pension Balancing Account  (PBA)"},null,{"$f":"'Authorized Rev Req'!B39","v":"D.20-02-045, AL 5884, AL 5915G"},11312.644088682704,{"$f":"'Authorized Rev Req'!D39","v":"EPAM"},{"$f":"'Authorized Rev Req'!C39","v":11312.644088682704},{"$f":"0","v":0},{"$f":"G40","v":0},{"$f":"H40","v":0},{"$f":"I40","v":0}]
[{"$f":"'Authorized Rev Req'!A40","v":"PBOP Balancing Account  (PBOPBA)"},null,{"$f":"'Authorized Rev Req'!B40","v":"D.20-02-045, AL 5884, AL 5915G"},-4328.4227973909083,{"$f":"'Authorized Rev Req'!D40","v":"EPAM"},{"$f":"'Authorized Rev Req'!C40","v":-4328.4227973909083},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A41","v":"Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B41","v":"D.20-02-045, AL 5884, AL 5915G"},22874.176540558052,{"$f":"'Authorized Rev Req'!D41","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C41","v":22874.176540558052},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A42","v":"Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution"},null,{"$f":"'Authorized Rev Req'!B42","v":"D.20-02-045, AL 5884, AL 5915G"},72521.186822647796,{"$f":"'Authorized Rev Req'!D42","v":"Distribution"},{"$f":"'Authorized Rev Req'!C42","v":72521.186822647796},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A43","v":"Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B43","v":"D.20-02-045, AL 5884, AL 5915G"},572.09798322721713,{"$f":"'Authorized Rev Req'!D43","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C43","v":572.09798322721713},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A44","v":"Safety Enhancement Expense Balancing Account (SEEBA) - Distribution"},null,{"$f":"'Authorized Rev Req'!B44","v":"D.20-02-045, AL 5884, AL 5915G"},1611.907471579721,{"$f":"'Authorized Rev Req'!D44","v":"Distribution"},{"$f":"'Authorized Rev Req'!C44","v":1611.907471579721},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A45","v":"Research Royalty Memorandum Account  (RRMA)"},null,{"$f":"'Authorized Rev Req'!B45","v":"D.20-02-045, AL 5884, AL 5915G"},-160.82445015363919,{"$f":"'Authorized Rev Req'!D45","v":"EPAM"},{"$f":"'Authorized Rev Req'!C45","v":-160.82445015363919},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A46","v":"Self-Generation Program Memorandum Account  (SGPMA)"},null,{"$f":"'Authorized Rev Req'!B46","v":"D.20-02-045, AL 5884, AL 5915G"},16267.798190288335,{"$f":"'Authorized Rev Req'!D46","v":"SGIP"},{"$f":"'Authorized Rev Req'!C46","v":16267.798190288335},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A47","v":"System Operator Gas Account  (SOGA)"},null,{"$f":"'Authorized Rev Req'!B47","v":"D.20-02-045, AL 5884, AL 5915G"},-57.474724884945573,{"$f":"'Authorized Rev Req'!D47","v":"ECPT"},{"$f":"'Authorized Rev Req'!C47","v":-57.474724884945573},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A48","v":"Rewards & Penalties Balancing Account (RPBA)"},null,{"$f":"'Authorized Rev Req'!B48","v":"D.20-02-045, AL 5884, AL 5915G"},-266.7671576355873,{"$f":"'Authorized Rev Req'!D48","v":"EPAM"},{"$f":"'Authorized Rev Req'!C48","v":-266.7671576355873},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A49","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B49","v":"D.20-02-045, AL 5884, AL 5915G"},14313.748177749801,{"$f":"'Authorized Rev Req'!D49","v":"EPAM"},{"$f":"'Authorized Rev Req'!C49","v":14313.748177749801},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A50","v":"NonCore Backbone Transmission"},null,{"$f":"'Authorized Rev Req'!B50","v":"D.20-02-045, AL 5884, AL 5915G"},205899.09902636753,{"$f":"'Authorized Rev Req'!D50","v":"Backbone Transmission"},{"$f":"'Authorized Rev Req'!C50","v":205899.09902636753},209446.25243396754,{"$f":"G51","v":209446.25243396754},{"$f":"0","v":0},0]
[{"$f":"'Authorized Rev Req'!A51","v":"Storage Integrity Management Program Balancing Account (SIMPBA) Balance"},null,{"$f":"'Authorized Rev Req'!B51","v":"D.22-07-016, AL 6023"},0,{"$f":"'Authorized Rev Req'!D51","v":"EPAM"},{"$f":"'Authorized Rev Req'!C51","v":0},35028,0,0,0]
[{"$f":"'Authorized Rev Req'!A52","v":"On-Bill Financing Balancing Account (OBFBA)"},null,{"$f":"'Authorized Rev Req'!B52","v":"AL 5853-A"},{"$f":"F53","v":0},{"$f":"'Authorized Rev Req'!D52","v":"EPAM"},{"$f":"'Authorized Rev Req'!C52","v":0},4500,{"$f":"0","v":0},0,0]
[]
[]
[]
[]
[{"$f":"'Authorized Rev Req'!A58","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A59","v":"  AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B59","v":"D.19-09-051"},{"$f":"F59","v":5107.0718943636321},{"$f":"'Authorized Rev Req'!D59","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!C59","v":5107.0718943636321},{"$f":"0","v":0},{"$f":"G59","v":0},{"$f":"H59","v":0},{"$f":"I59","v":0}]
[{"$f":"'Authorized Rev Req'!A60","v":"  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B60","v":"D.20-02-045, AL 5884, AL 5915G"},{"$f":"F60","v":2676.4558822098343},{"$f":"'Authorized Rev Req'!D60","v":"ECPT"},{"$f":"'Authorized Rev Req'!C60","v":2676.4558822098343},{"$f":"0","v":0},{"$f":"G60","v":0},{"$f":"H60","v":0},{"$f":"I60","v":0}]
[{"$f":"'Authorized Rev Req'!A61","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B61","v":"D.20-02-045, AL 5884, AL 5915G"},421911.65593735001,{"$f":"'Authorized Rev Req'!D61","v":"GHG End User"},{"$f":"'Authorized Rev Req'!C61","v":421911.65593735001},{"$f":"0","v":0},{"$f":"G61","v":0},{"$f":"H61","v":0},{"$f":"I61","v":0}]
[{"$f":"'Authorized Rev Req'!A62","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B62","v":"D.20-02-045, AL 5884, AL 5915G"},11523.700831049478,{"$f":"'Authorized Rev Req'!D62","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C62","v":11523.700831049478},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A63","v":"Green House Gas Balancing Account (GHGBA) - Company Gas Compressor"},null,{"$f":"'Authorized Rev Req'!B63","v":"D.20-02-045, AL 5884, AL 5915G"},110.10687339904621,{"$f":"'Authorized Rev Req'!D63","v":"ECPT"},{"$f":"'Authorized Rev Req'!C63","v":110.10687339904621},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A64","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B64","v":"D.20-02-045, AL 5884, AL 5915G"},24082.112323034682,{"$f":"'Authorized Rev Req'!D64","v":"GHG End User"},{"$f":"'Authorized Rev Req'!C64","v":24082.112323034682},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A65","v":"Green House Gas Balancing Account (GHGBA) - LUAF"},null,{"$f":"'Authorized Rev Req'!B65","v":"D.20-02-045, AL 5884, AL 5915G"},96.161475841515269,{"$f":"'Authorized Rev Req'!D65","v":"47% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C65","v":96.161475841515269},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A66","v":"New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount"},null,{"$f":"'Authorized Rev Req'!B66","v":"D.20-02-045, AL 5884, AL 5915G"},3566.9058998494452,{"$f":"'Authorized Rev Req'!D66","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!C66","v":3566.9058998494452},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A67","v":"New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   "},null,{"$f":"'Authorized Rev Req'!B67","v":"D.20-02-045, AL 5884, AL 5915G"},1979.7078861701277,{"$f":"'Authorized Rev Req'!D67","v":"EPAM"},{"$f":"'Authorized Rev Req'!C67","v":1979.7078861701277},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A68","v":"New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program "},null,{"$f":"'Authorized Rev Req'!B68","v":"D.20-02-045, AL 5884, AL 5915G"},-2147.5120170099681,{"$f":"'Authorized Rev Req'!D68","v":"EPAM"},{"$f":"'Authorized Rev Req'!C68","v":-2147.5120170099681},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A69","v":"TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B69","v":"D.20-02-045, AL 5884, AL 5915G"},-6644.931817014658,{"$f":"'Authorized Rev Req'!D69","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C69","v":-6644.931817014658},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A70","v":"  Natural Gas Leak Abatement Program Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B70","v":"AL 5915G"},86446.464722770907,{"$f":"'Authorized Rev Req'!D70","v":"EPAM"},{"$f":"'Authorized Rev Req'!C70","v":86446.464722770907},{"$f":"F70","v":86446.464722770907},{"$f":"G70","v":86446.464722770907},{"$f":"0","v":0},{"$f":"0","v":0}]
[{"$f":"'Authorized Rev Req'!A71","v":"Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) "},null,{"$f":"'Authorized Rev Req'!B71","v":"D.20-02-045, AL 5884, AL 5915G"},{"$f":"F71","v":-48.669674355202922},{"$f":"'Authorized Rev Req'!D71","v":"EPAM"},{"$f":"'Authorized Rev Req'!C71","v":-48.669674355202922},{"$f":"0","v":0},{"$f":"G71","v":0},{"$f":"H71","v":0},{"$f":"I71","v":0}]
[{"$f":"'Authorized Rev Req'!A72","v":"Diary Biomethane Project Balancing Account  (DBPBA)"},null,{"$f":"'Authorized Rev Req'!B72","v":"D.20-02-045, AL 5884, AL 5915G"},45457.032564324829,{"$f":"'Authorized Rev Req'!D72","v":"EPAM"},{"$f":"'Authorized Rev Req'!C72","v":45457.032564324829},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A73","v":"California Solar Iniative Thermal Memorandum Account (CSITPMA)"},null,{"$f":"'Authorized Rev Req'!B73","v":"D.20-02-045, AL 5884, AL 5915G"},1411.3819701407706,{"$f":"'Authorized Rev Req'!D73","v":"ECPT adjusted"},{"$f":"'Authorized Rev Req'!C73","v":1411.3819701407706},{"$f":"0","v":0},0,0,0]
[]
[]
[{"$f":"'Authorized Rev Req'!A82","v":"California Alternate Rates for Energy (CARE) "},null,{"$f":"'Authorized Rev Req'!B82","v":"AL 5891G, D.21-06-015"},{"$f":"F76","v":229388.13208047274},{"$f":"'Authorized Rev Req'!D82","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C82","v":229388.13208047274},150983.27958214204,152497.41740508622,154039.11344559322,155411.26861179565]
[{"$f":"'Authorized Rev Req'!A83","v":"Energy Efficiency "},null,{"$f":"'Authorized Rev Req'!B83","v":"AL 5891G, AL 5898-A"},{"$f":"F77","v":107144.935},{"$f":"'Authorized Rev Req'!D83","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C83","v":107144.935},132220.36343247839,{"$f":"G77","v":132220.36343247839},132220.36343247839,132220.36343247839]
[{"$f":"'Authorized Rev Req'!A84","v":"RD&D"},null,{"$f":"'Authorized Rev Req'!B84","v":"AL 5891G"},12406.90965,{"$f":"'Authorized Rev Req'!D84","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C84","v":12406.90965},{"$f":"0","v":0},{"$f":"G78","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A85","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B85","v":"AL 5891G"},547.65497000000005,{"$f":"'Authorized Rev Req'!D85","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C85","v":547.65497000000005},{"$f":"0","v":0},{"$f":"G79","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A86","v":"Energy Savings Assistance"},null,{"$f":"'Authorized Rev Req'!B86","v":"AL 5891G, D.21-06-015"},{"$f":"F80","v":0},{"$f":"'Authorized Rev Req'!D86","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C86","v":0},122824.705,122814.84299999999,122849.88400000001,122541.07]
[]
[]
[]
[{"$f":"'Authorized Rev Req'!A96","v":"EOR"},null,{"$f":"'Authorized Rev Req'!B96","v":"D.20-02-045, AL 5884"},{"$f":"F84","v":-19696.026660334344},{"$f":"'Authorized Rev Req'!D96","v":"EPAM"},{"$f":"'Authorized Rev Req'!C96","v":-19696.026660334344},{"$f":"0","v":0},{"$f":"G84","v":0},{"$f":"H84","v":0},{"$f":"I84","v":0}]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B99","v":"D.98-07-068"},{"$f":"F87","v":2183405.0590524999},{"$f":"'Authorized Rev Req'!D99","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!C99","v":2183405.0590524999},{"$f":"0","v":0},{"$f":"G87","v":0},{"$f":"H87","v":0},{"$f":"I87","v":0}]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D11:D90)","v":6349606.7446466181},null,{"$f":"SUM(F11:F90)","v":6349606.7446466181},{"$f":"SUM(G11:G90)","v":4431365.9102138588},{"$f":"SUM(H11:H90)","v":4396725.1688673031},{"$f":"SUM(I11:I90)","v":4055375.2691121711},{"$f":"SUM(J11:J90)","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(F99:J99)","v":2827721.6003519185},"Allocated Base Margin",null,null,668170.19260077737,950655.22131242882,1208896.1864387123]
["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]
[null,null,null,0]
[null,null,null,0]
["Public Policy Proceedings",null,null,0]
["Natural Gas Leak Abatement","AL 5950","Advice Letter",65770.278654458176,"EPAM",null,24362.651577229088,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(F109:J109)","v":60415.319735278812},"Public Purpose Programs",null,null,19467.176033393072,20077.387265853031,20870.756436032709]
[null,null,null,{"$f":"SUM(F110:J110)","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D99:D125)","v":3280115.0775054251},null,{"$f":"SUM(F99:F126)","v":0},85862.651577229088,870752.87447516946,1032232.6085782818,1291266.942874745]