{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Selected Data","Authorized Rev Req","Incremental Rev Req"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":199,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Selected Data","index":0,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[[32,1,32,14],[39,1,39,14]]}
[{"$f":"'Authorized Rev Req'!A1","v":"SoCalGas Revenue Requirement List"}]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2023"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended December 31"}]
["Summary of Selected Data "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!G109","v":7883056.4020289434}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q8*0.01","v":78830.564020289443}]
[]
[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":5344496.590971522}]
[null,"B",{"$f":"'Incremental Rev Req'!B107","v":"AL 6060"},{"$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":234718.52821600001}]
[null,"C",{"$f":"'Incremental Rev Req'!B123","v":"AL 6216-G"},{"$f":"'Incremental Rev Req'!A123","v":"PPPS Filing"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D123","v":140450.08485147264}]
[null,"D",{"$f":"'Incremental Rev Req'!B124","v":"AL 6210-G"},{"$f":"'Incremental Rev Req'!A124","v":"Regulatory account update"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Incremental Rev Req'!D124:D135)","v":414655.09713250946}]
[]
[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":"Q12","v":5344496.590971522}]
[]
[]
[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":"'Incremental Rev Req'!B105","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'!B110","v":"A.23-11-003"},{"$f":"'Incremental Rev Req'!A110","v":"Catastrophic Event Memorandum Account (CEMA) "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D110","v":52418.848187720003}]
[null,"F",{"$f":"'Incremental Rev Req'!B111","v":"A.23-11-003"},{"$f":"'Incremental Rev Req'!A111","v":"COVID-19 Pandemic Protections Memorandum Account (CPPMA)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D111","v":5830.7102010560002}]
[null,"G",{"$f":"'Incremental Rev Req'!B121","v":"A.22-03-008 "},{"$f":"'Incremental Rev Req'!A121","v":"Energy Efficiency "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D121","v":60415.319735278812}]
[null,"H",{"$f":"'Incremental Rev Req'!B122","v":"A.23.01-004"},{"$f":"'Incremental Rev Req'!A122","v":"Demand Response"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D122","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'!O121","v":7887894.5416296218}]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!P121","v":10215402.36782952}]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!Q121","v":8373713.9264230374}]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!R121","v":8637449.0925541129}]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!S121","v":6114353.593731802}]
[]
[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,215.83287977166515]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,274.66836990152842]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,249.85855098971976]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,258.28733299429803]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,184.07516171448367]
[7,"Bundled residential average monthly bill corresponding to RAR above for typical customer in climate zone 1 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.603859407589695,46.520624947935381]
[null,"B","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103.99134175491132,58.941532083142107]
[null,"C","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94.550961778431073,53.703869304015249]
[null,"D","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97.758196186106048,55.483290505584002]
[null,"E","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.519735508441684,39.816173842936244]

{"sheet":"Authorized Rev Req","index":1,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended December 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01"]
[null,"Advice Letter:","AL 5915","AL 6071","AL 6088","AL 6168-G","AL 6213-G"]
["Filing Description","Authority for Revenue Requirement as of 11/1/2023","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051",2797438.8098034845,2813333.2818626408,2813333.2818626408,2813333.2818626408,2813333.2799938698,"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,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,29982.760000000006,29982.760000000006,"Distribution","N"]
["  Company Use Gas: Other","D.20-02-045 AL 6071, AL 6045, ",1792.6929208784113,2442.7824068004993,2442.7824068004993,2442.7824068004993,2442.7824068005002,"ECPT","N"]
["  Company Use Gas: Storage Load Balancing","D.20-02-045 AL 6071, AL 6045, ",1739.9823775441146,2371.288817256519,2371.288817256519,2371.288817256519,2371.2888172565199,"ECPT","N"]
["  Exchange Revenues & Interutility Transactions","D.20-02-045 AL 6071, AL 6045, ",342.77791000000002,342.77791000000002,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,59771.786676696618,59771.786676696633,"47% Res (LUAF, Other)","N"]
["  Well Incidents & Surface Leaks","D.20-02-045 AL 6071, AL 6045, ",226.38915428249578,308.48434647250184,308.48434647250184,308.48434647250184,308.48434647250201,"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,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,24959.799583904292,24959.799583904292,"Distribution","N"]
["AMI Balancing Account  (AMIBA)","D.20-02-045 AL 6071, AL 6045, ",-77756.901095456211,-323.97185928908709,-323.97185928908709,-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,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,-106.52167417156562,-106.52185926498186,"EPAM","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D.20-02-045 AL 6071, AL 6045, ",10172.083196372587,0,0,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,-12481.017073574887,-15934.575731573012,"CFCA","Y"]
["Core Fixed Cost Account - NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, ",9826.72414135078,-1151.9897406335253,-1401.3020835172681,-1401.3020835172681,-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,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,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,-7124.2567864552111,-7124.2691656544375,"EPAM","Y"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)","D.20-02-045 AL 6071, AL 6045, ",284.26278995019351,441.06566541085317,441.06566541085317,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,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,24824.504625728128,24824.547761103186,"EPAM","Y"]
["Noncore Fixed Cost Account  (NFCA)  Margin","D.20-02-045 AL 6071, AL 6045, ",6370.1809775920838,12427.604012052685,12427.604012052685,12427.604012052685,12427.834050448922,"Non-Residential","Y"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-3275.1851982978651,959.63192651874249,959.63192651874249,959.63192651874249,-11436.667024366332,"Non-Residential","Y"]
["Integrated Transmission Balancing Account  (ITBA) Margin","D.20-02-045, AL 6071, AL 6045, AL 6088,",176.09814139595812,5083.8850590894772,5083.8850590894772,5083.8850590894772,5083.8850590894772,"ECPT","Y"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-1423.0358831880883,3459.772548454087,3459.772548454087,3459.772548454087,3459.772548454087,"ECPT","Y"]
["Compression Services Balancing Account  (CSBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-68.369488844234169,-73.636852931578687,-73.636852931578687,-73.636852931578687,-73.636852931578687,"Non-Residential","Y"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-1168.4484408377084,5918.6872446137231,5918.6872446137231,5918.6872446137231,5918.6872446137231,"ECPT","Y"]
["Noncore Storage Balancing Account  (NSBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",122.05121759349339,93.946777408666094,93.946777408666094,93.946777408666094,93.946777408666094,"ECPT","Y"]
["Pension Balancing Account  (PBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",11312.644088682704,9235.9689255481535,9235.9689255481535,9235.9689255481535,9235.9849740852605,"EPAM","Y"]
["PBOP Balancing Account  (PBOPBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-4328.4227973909083,-4765.7902742977731,-4765.7902742977731,-4765.7902742977731,-4765.7985553955832,"EPAM","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6088, ",22874.176540558052,24483.535529249115,24483.535529249115,24483.535529249115,24483.535529249115,"Local Transmission","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6088, ",72521.186822647796,74787.023820241564,74787.023820241564,74787.023820241564,74787.023820241564,"Distribution","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6088, ",572.09798322721713,-674.07808819608886,-674.07808819608886,-674.07808819608886,-674.07808819608886,"Local Transmission","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6088, ",1611.907471579721,2206.0867435845412,2206.0867435845412,2206.0867435845412,2206.0867435845412,"Distribution","Y"]
["Research Royalty Memorandum Account  (RRMA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-160.82445015363919,-247.95082320763703,-247.95082320763703,-247.95082320763703,-247.9512540501419,"EPAM","Y"]
["Self-Generation Program Memorandum Account  (SGPMA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",16267.798190288335,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,"SGIP","Y"]
["System Operator Gas Account  (SOGA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-57.474724884945573,-54.791024656889135,-54.791024656889135,-54.791024656889135,-54.791024656889135,"ECPT","Y"]
["Rewards & Penalties Balancing Account (RPBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",-266.7671576355873,-288.87206106860225,-288.87206106860225,-288.87206106860225,-288.87256301637063,"EPAM","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 6071, AL 6045, AL 6088, ",14313.748177749801,23349.855935962783,23349.855935962783,23349.855935962783,23349.896508969519,"EPAM","Y"]
["NonCore Backbone Transmission","D.20-02-045, AL 6071, AL 6045, AL 6088, ",205899.09902636753,307036.37711891095,307036.37711891095,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,35607.3666859636,35607.428557776948,"EPAM","Y"]
["On-Bill Financing Balancing Account (OBFBA)","AL 5853-A",0,4574.3633340208544,4574.3633340208544,4574.3633340208544,4574.3712824927779,"EPAM","Y"]
["System Reliability Memorandum Account   (SRMA)","AL 6045, ",0,15184.322292874704,15184.322292874704,15184.322292874704,15184.322292874704,"ECPT","Y"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ","AL 6045,",0,-61.478426684054938,-61.478426684054938,-61.478426684054938,-61.478533509751273,"EPAM","Y"]
[]
[]
["   Subtotal Safety Affordability Reliability",null,3240882.4358018562,3673812.4421397415,3539196.6761642485,3539196.6761642485,3523347.1944171903]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",5107.0718943636321,5106.2014202040336,5106.2014202040336,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,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,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,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,-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,-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,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,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,6090.186376418309,6090.1969588036363,"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,0,0,"EPAM","Y"]
["TLS Adjustment","D.20-02-045, AL 6071, AL 6045, ",-6644.931817014658,10390.216028451658,10421.053586768947,10394.546129042021,10191.858650344628,"Non-Residential","N"]
["  Natural Gas Leak Abatement Program Revenue Requirement","AL 5915G, AL 6071, 6168-G, ",86446.464722770907,86431.165118197561,86431.165118197561,107531.46426397371,107531.65111201403,"EPAM","N"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ","D.20-02-045, AL 6071, AL 6045,",-48.669674355202922,0,0,0,0,"EPAM","Y"]
["Diary Biomethane Project Balancing Account  (DBPBA)","D.20-02-045, AL 6071, AL 6045,",45457.032564324829,34573.344052610402,34573.344052610402,34573.344052610402,34573.404127692869,"EPAM","Y"]
["Diary Biomethane Project Memorandum Account  (DBPMA)","D.20-02-045, AL 6071, AL 6045,",0,8114.6562580048067,8114.6562580048067,8114.6562580048067,8114.6703581347574,"EPAM","Y"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)","D.20-02-045, AL 6071, AL 6045,",1411.3819701407706,1113.8604547746736,1113.8604547746736,1113.8604547746736,1113.8604547746736,"ECPT adjusted","Y"]
[null,"D.20-02-045, AL 6071, AL 6045,"]
[]
[]
[]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) "," D.21-06-015, AL 6052",229388.13208047274,199514.89150131575,199514.89150131575,199514.89150131575,199514.89150131575,"Public Purpose Programs","N"]
["Energy Efficiency "," AL 6052",107144.935,166906.52600000001,166906.52600000001,166906.52600000001,166906.52600000001,"Public Purpose Programs","N"]
["RD&D"," AL 6052",12406.90965,12264.871999999999,12264.871999999999,12264.871999999999,12264.871999999999,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE"," AL 6052",547.65497000000005,520.25400000000002,520.25400000000002,520.25400000000002,520.25400000000002,"Public Purpose Programs","N"]
["Energy Savings Assistance "," D.21-06-015,  AL 6052",0,80174.204849890506,80174.204849890506,80174.204849890506,80174.204849890506,"Public Purpose Programs","N"]
["SJVDGPMA","AL 6052",0,806.16499999999996,806.16499999999996,806.16499999999996,806.16499999999996,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,945015.27645259723,1062529.2292121728,1062560.06677049,1083633.8584585392,1083431.4425854799]
[]
["EOR","D.20-02-045, AL 6045, AL ",-19696.026660334301,-25124.896599589265,-25124.896599589265,-25233.572656235308,-24742.548711656997,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",2584342.1558562312,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,2584342.1558562312,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
[]
["Total Authorized Revenue",null,6750543.8414503504,8012237.0884902552,7877652.1600730792,7898617.2757044816,7883056.4020289434]

{"sheet":"Incremental Rev Req","index":2,"n_rows":147,"n_cols":19,"rows_kept":147,"cut":false,"hidden":false,"merged":[[140,5,140,9],[139,0,139,10],[100,5,100,9],[6,13,6,18],[102,13,102,18],[6,0,6,10],[99,0,99,10]]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2023"]
["Reporting Date: Quarter Ended December 31"]
[]
["Current Revenue Requirement ($000):",7898617.2757044816]
["Current Revenue Requirement Effective:","2023-11-01"]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented",null,null,null,null,null,null,null,null,null,null,null,null,"Authorized"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)",null,null,null,2023,2024,2025,2026,2027]
["Safety Affordability Reliability Proceedings",null,null,"2023-11-01",null,2023,2024,2025,2026,2027,null,null,null,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
["Total Allocated Base Margin",null,"D.19-09-051",2813333.2799938722,"Allocated Base Margin",2813333.2799938722,2813333.2799938722,2813333.2799938722,2813333.2799938722,2813333.2799938722,"Existing",null,null,"Allocated Base Margin",2813333.2799938722,2813333.2799938722,2813333.2799938722,2813333.2799938722,2813333.2799938722]
["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,"Existing",null,null,"Distribution",131935.67014773039,132268.91014773041,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,"Existing",null,null,"ECPT adjusted",11784.454144301089,11784.454144301089,0,0,0]
["  Company Use Gas: Other",null,"D.20-02-045 AL 6071, AL 6045, ",2442.7824068005002,"ECPT",2442.7824068005002,2442.7824068005002,0,0,0,"Existing",null,null,"Local Transmission",45145.452441700174,45378.300841700184,0,0,0]
["  Company Use Gas: Storage Load Balancing",null,"D.20-02-045 AL 6071, AL 6045, ",2371.2888172565199,"ECPT",2371.2888172565199,2371.2888172565199,0,0,0,"Existing",null,null,"SGIP",16265.025427685592,16265.025427685592,0,0,0]
["  Exchange Revenues & Interutility Transactions",null,"D.20-02-045 AL 6071, AL 6045, ",342.77791000000002,"ECPT",342.77791000000002,342.77791000000002,0,0,0,"Existing",null,null,"GHG End User",428956.77859538642,428956.77859538642,0,0,0]
["  Unaccounted For (UAF) Gas",null,"D.20-02-045 AL 6071, AL 6045, ",59771.786676696633,"47% Res (LUAF, Other)",59771.786676696633,59771.786676696633,0,0,0,"Existing",null,null,"Public Purpose Programs",460186.91335120623,421123.55140508618,409108.99744559324,410172.33861179563,0]
["  Well Incidents & Surface Leaks",null,"D.20-02-045 AL 6071, AL 6045, ",308.48434647250201,"ECPT",308.48434647250201,308.48434647250201,0,0,0,"Existing",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,363.84340064715622,0,0,0,"Existing",null,null,"47% Res (LUAF, Other)",74167.878504468536,74167.878504468536,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,24959.799583904292,0,0,0,"Existing",null,null,"ECPT",82775.781034269574,82775.781034269574,0,0,0]
["AMI Balancing Account  (AMIBA)",null,"D.20-02-045 AL 6071, AL 6045, ",-323.97185928908709,"EPAM",-323.97185928908709,-323.97185928908709,0,0,0,"Existing",null,null,"EPAM",216240.73913923561,218258.03082405441,34359.908234099996,39396.959277899994,0]
["Residential Uncollectible Balancing Account  (RUBA) ",null,"D.20-02-045 AL 6071, AL 6045, ",44745.198352024141,"ECPT",44745.198352024141,44745.198352024141,0,0,0,"Existing",null,null,"CFCA",-15934.575731573012,-15934.575731573012,0,0,0]
["Affiliate Transfer Fee Account  (ATFA)",null,"D.20-02-045 AL 6071, AL 6045, ",-106.52185926498186,"EPAM",-106.52185926498186,-106.52185926498186,0,0,0,"Existing",null,null,"Non-Residential",10142.314123821292,10142.314123821292,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,"Existing",null,null,"Total",7883056.4020289434,7748986.043048732,6557822.4994114954,6563922.8916214975,6114353.593731802]
["Core Fixed Cost Account - Non NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-15934.575731573012,"CFCA",-15934.575731573012,-15934.575731573012,0,0,0,"Existing",null,null,"CPUC Fee",3.0000000000000001E-3]
["Core Fixed Cost Account - NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-1401.3020835172681,"Non-Residential",-1401.3020835172681,-1401.3020835172681,0,0,0,"Existing",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,"Existing"]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)",null,"D.20-02-045 AL 6071, AL 6045, ",434.22738384292143,"Non-Residential",434.22738384292143,434.22738384292143,0,0,0,"Existing"]
["Enhanced Oil Recovery Account  (EORA)  ",null,"D.20-02-045 AL 6071, AL 6045, ",-7124.2691656544375,"EPAM",-7124.2691656544375,-7124.2691656544375,0,0,0,"Existing"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)",null,"D.20-02-045 AL 6071, AL 6045, ",441.06566541085317,"ECPT",441.06566541085317,441.06566541085317,0,0,0,"Existing"]
["Intervenor Award Memorandum Account  (IAMA)",null,"D.20-02-045 AL 6071, AL 6045, ",832.93717869704278,"ECPT",832.93717869704278,832.93717869704278,0,0,0,"Existing"]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045 AL 6071, AL 6045, ",24824.547761103186,"EPAM",24824.547761103186,29872.872572999997,34359.908234099996,39396.959277899994,0,"Existing"]
["Noncore Fixed Cost Account  (NFCA)  Margin",null,"D.20-02-045 AL 6071, AL 6045, ",12427.834050448922,"Non-Residential",12427.834050448922,12427.834050448922,0,0,0,"Existing"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-11436.667024366332,"Non-Residential",-11436.667024366332,-11436.667024366332,0,0,0,"Existing"]
["Integrated Transmission Balancing Account  (ITBA) Margin",null,"D.20-02-045, AL 6071, AL 6045, AL 6088,",5083.8850590894772,"ECPT",5083.8850590894772,5083.8850590894772,0,0,0,"Existing"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",3459.772548454087,"ECPT",3459.772548454087,3459.772548454087,0,0,0,"Existing"]
["Compression Services Balancing Account  (CSBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-73.636852931578687,"Non-Residential",-73.636852931578687,-73.636852931578687,0,0,0,"Existing"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",5918.6872446137231,"ECPT",5918.6872446137231,5918.6872446137231,0,0,0,"Existing"]
["Noncore Storage Balancing Account  (NSBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",93.946777408666094,"ECPT",93.946777408666094,93.946777408666094,0,0,0,"Existing"]
["Pension Balancing Account  (PBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",9235.9849740852605,"EPAM",9235.9849740852605,9235.9849740852605,0,0,0,"Existing"]
["PBOP Balancing Account  (PBOPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-4765.7985553955832,"EPAM",-4765.7985553955832,-4765.7985553955832,0,0,0,"Existing"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",24483.535529249115,"Local Transmission",24483.535529249115,24483.535529249115,0,0,0,"Existing"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",74787.023820241564,"Distribution",74787.023820241564,74787.023820241564,0,0,0,"Existing"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-674.07808819608886,"Local Transmission",-674.07808819608886,-674.07808819608886,0,0,0,"Existing"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",2206.0867435845412,"Distribution",2206.0867435845412,2206.0867435845412,0,0,0,"Existing"]
["Research Royalty Memorandum Account  (RRMA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-247.9512540501419,"EPAM",-247.9512540501419,-247.9512540501419,0,0,0,"Existing"]
["Self-Generation Program Memorandum Account  (SGPMA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",16265.025427685592,"SGIP",16265.025427685592,16265.025427685592,0,0,0,"Existing"]
["System Operator Gas Account  (SOGA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-54.791024656889135,"ECPT",-54.791024656889135,-54.791024656889135,0,0,0,"Existing"]
["Rewards & Penalties Balancing Account (RPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",-288.87256301637063,"EPAM",-288.87256301637063,-288.87256301637063,0,0,0,"Existing"]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",23349.896508969519,"EPAM",23349.896508969519,23349.896508969519,0,0,0,"Existing"]
["NonCore Backbone Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, ",307036.37711891095,"Backbone Transmission",307036.37711891095,209446,0,0,0,"Existing"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance",null,"D.22-07-016, AL 6023, ",35607.428557776948,"EPAM",35607.428557776948,35607.428557776948,0,0,0,"Existing"]
["On-Bill Financing Balancing Account (OBFBA)",null,"AL 5853-A",4574.3712824927779,"EPAM",4574.3712824927779,4574.3712824927779,0,0,0,"Existing"]
["System Reliability Memorandum Account   (SRMA)",null,"AL 6045, ",15184.322292874704,"ECPT",15184.322292874704,15184.322292874704,0,0,0,"Existing"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ",null,"AL 6045,",-61.478533509751273,"EPAM",-61.478533509751273,-61.478533509751273,0,0,0,"Existing"]
[]
[]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",5106.2014202040336,"ECPT adjusted",5106.2014202040336,5106.2014202040336,0,0,0,"Existing"]
["  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,2388.5750957260152,0,0,0,"Existing"]
["  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,451660.15168836701,0,0,0,"Existing"]
["  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,11338.595126925329,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 6071, AL 6045,",-783.15163590176303,"ECPT",-783.15163590176303,-783.15163590176303,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 6071, AL 6045,",-22703.373092980601,"GHG End User",-22703.373092980601,-22703.373092980601,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 6071, AL 6045,",3057.4967008465737,"47% Res (LUAF, Other)",3057.4967008465737,3057.4967008465737,0,0,0,"Existing"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.20-02-045, AL 6071, AL 6045,",5564.3922693223831,"ECPT adjusted",5564.3922693223831,5564.3922693223831,0,0,0,"Existing"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ",null,"D.20-02-045, AL 6071, AL 6045,",6090.1969588036363,"EPAM",6090.1969588036363,6090.1969588036363,0,0,0,"Existing"]
["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,"Existing"]
["TLS Adjustment",null,"D.20-02-045, AL 6071, AL 6045, ",10191.858650344628,"Non-Residential",10191.858650344628,10191.858650344628,0,0,0,"Existing"]
["  Natural Gas Leak Abatement Program Revenue Requirement",null,"AL 5915G, AL 6071, 6168-G, ",107531.65111201403,"EPAM",107531.65111201403,104500.61798493601,0,0,0,"Existing"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ",null,"D.20-02-045, AL 6071, AL 6045,",0,"EPAM",0,0,0,0,0,"Existing"]
["Diary Biomethane Project Balancing Account  (DBPBA)",null,"D.20-02-045, AL 6071, AL 6045,",34573.404127692869,"EPAM",34573.404127692869,34573.404127692869,0,0,0,"Existing"]
["Diary Biomethane Project Memorandum Account  (DBPMA)",null,"D.20-02-045, AL 6071, AL 6045,",8114.6703581347574,"EPAM",8114.6703581347574,8114.6703581347574,0,0,0,"Existing"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)",null,"D.20-02-045, AL 6071, AL 6045,",1113.8604547746736,"ECPT adjusted",1113.8604547746736,1113.8604547746736,0,0,0,"Existing"]
[]
[]
[]
["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,"Existing"]
["Energy Efficiency ",null," AL 6052",166906.52600000001,"Public Purpose Programs",166906.52600000001,132220,132220,132220,0,"Existing"]
["RD&D",null," AL 6052",12264.871999999999,"Public Purpose Programs",12264.871999999999,12264.871999999999,0,0,0,"Existing"]
["Bureau Of Equalization BOE",null," AL 6052",520.25400000000002,"Public Purpose Programs",520.25400000000002,520.25400000000002,0,0,0,"Existing"]
["Energy Savings Assistance ",null," D.21-06-015,  AL 6052",80174.204849890506,"Public Purpose Programs",80174.204849890506,122814.84299999999,122849.88400000001,122541.07,0,"Existing"]
["SJVDGPMA",null,null,806.16499999999996,"Public Purpose Programs",806.16499999999996,806.16499999999996,0,0,0,"Existing"]
[]
[]
["EOR",null,"D.20-02-045, AL 6045, AL ",-24742.548711656997,"EPAM",-24742.548711656997,-24742.548711656997,0,0,0,"Existing"]
[]
[]
["Procurement",null,"D.98-07-068",3301020.3137379293,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,7883056.4020289425,null,7883056.4020289425,7748986.043048732,6557822.4994114945,6563922.8916214965,6114353.593731802]
[]
["CPUC Fee",null,null,null,"CPUC Fee",3.0000000000000001E-3]
[]
[]
["Pending Application(s) Not Yet Approved"]
["Filing Description","Proceeding","Basis of Revenue Requirement Forecast:  Application, Amended Application , Amended Testimony,  Proposed Settlement Agreement, Proposed Decision","Proposed Revenue Requirement with FF&U ($000)","Proposed Revenue Recovery Mechanism","Incremental Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2023,2024,2025,2026,2027,null,"Include in Impact"]
["2024 GRC Application","A.22-05-015 ","Application",5344496.590971522,"Allocated Base Margin",null,1504663.9979092209,1789651.8182508256,2050180.7748114755,null,"Existing","Y",null,"Authorized + Pending"]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission ","A.22-05-015 ","Application",-5487.0233199999984,"Local Transmission",null,-5487.0233199999984,null,null,null,"Existing","Y",null,null,2023,2024,2025,2026,2027]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution","A.22-05-015 ","Application",63454.58,"Distribution",null,63454.58,null,null,null,"Existing","Y",null,"Core Procurement",3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293]
["NonCore Backbone Transmission","A.22-05-015 ","Application",22240.277383770008,"Backbone Transmission",null,22240.277383770008,null,null,null,"Existing","Y",null,"Allocated Base Margin",2813333.2799938722,4317997.2797718616,4602985.0982446978,4863514.0548053477,2813333.2799938722]
["TIMPBA","AL 6060","Advice Letter",62283.859715999999,"Local Transmission",null,62283.859715999999,null,null,null,"Existing","Y",null,"Distribution",131935.67014773039,195161.8516524263,0,0,0]
["TIMPBA","AL 6060","Advice Letter",172434.6685,"Backbone Transmission",null,172434.6685,null,null,null,"Existing","Y",null,"ECPT adjusted",11784.454144301089,15383.330929301575,0,0,0]
["Hydrogen Blending ","A.22-09-006","Application",14979.078966298401,"ECPT",3232.2396006774802,8301.0481856490205,971.12149486421004,2474.6696851076899,null,"Existing","Y",null,"Local Transmission",45145.452441700174,103243.72838815609,0,0,0]
["Catastrophic Event Memorandum Account (CEMA) ","A.23-11-003","Application",52418.848187720003,"ECPT",null,52418.848187720003,null,null,null,"New","Y",null,"SGIP",16265.025427685592,16265.025427685592,0,0,0]
["COVID-19 Pandemic Protections Memorandum Account (CPPMA)","A.23-11-003","Application",5830.7102010560002,"ECPT",null,5830.7102010560002,null,null,null,"New","Y",null,"GHG End User",428956.77859538642,745406.27430327912,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Public Purpose Programs",461792.81335120625,586743.81228995183,434377.48471144628,431043.09504782833,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Backbone Transmission",307036.37711891095,387975.29403303459,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"47% Res (LUAF, Other)",74167.878504468536,57020.365417675042,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"ECPT",86008.020634947054,451057.5955002039,971.12149486421004,2474.6696851076899,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"EPAM",216240.73913923561,184111.24150382259,34359.908234099996,39396.959277899994,0]
["Public Policy Proceedings",null,null,0,null,null,null,null,null,null,null,"-",null,"CFCA",-15934.575731573012,-159234.43396321227,0,0,0]
[null,null,null,0,null,null,0,null,null,null,null,"-",null,"Non-Residential",10142.314123821292,13250.68883740779,0,0,0]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,null,"Existing","Y"]
[null,null,null,0,null,null,null,null,null,null,null,"-"]
["Energy Efficiency ","A.22-03-008 ","Application",60415.319735278812,"Public Purpose Programs",null,19467.176033393072,20077.387265853031,20870.756436032709,null,"Existing","Y",null,"Total",7887894.5416296218,10215402.36782952,8373713.9264230374,8637449.0925541129,6114353.593731802]
["Demand Response","A.23.01-004","Application",12500,"Public Purpose Programs",1605.9,5703,5191.1000000000004,null,null,"Existing","Y",null,"Incremental Revenues",4838.1396006783471,2466416.3247807883,1815891.427011542,2073526.2009326154,0]
["PPPS Filing","AL 6216-G","Advice Letter",140450.08485147264,"Public Purpose Programs",null,140450.08485147264,null,null,null,"Existing","Y",null,"CPUC Fee",3.0000000000000001E-3]
["Regulatory account update","AL 6210-G","Advice Letter",1068.5911504559051,"Local Transmission",null,1068.5911504559051,null,null,null,"Existing","Y",null,"Check Figure",0,-3.0267983675003052E-9,2.2561289370059967E-7,1.5273690223693848E-7,0]
["Regulatory account update","AL 6210-G","Advice Letter",-561.63849530410471,"Distribution",null,-561.63849530410471,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",-17147.513086793493,"47% Res (LUAF, Other)",null,-17147.513086793493,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",3108.3747135864978,"Non-Residential",null,3108.3747135864978,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",3598.8767850004865,"ECPT adjusted",null,3598.8767850004865,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",0,"SGIP",null,0,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",-143299.85823163926,"CFCA",null,-143299.85823163926,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",301731.20789150934,"ECPT",null,301731.20789150934,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",-34146.789320231816,"EPAM",null,-34146.789320231816,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",1.8687685951590538E-3,"Allocated Base Margin",null,1.8687685951590538E-3,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",-16145.651850735419,"Backbone Transmission",null,-16145.651850735419,null,null,null,"Existing","Y"]
["Regulatory account update","AL 6210-G","Advice Letter",316449.49570789275,"GHG End User",null,316449.49570789275,null,null,null,"Existing","Y"]
[]
["Total Pending, Filed but not Approved",null,null,6044222.5966177341,null,{"$f":"SUM(F103:F135)","v":4838.1396006774803},{"$f":"SUM(G103:G135)","v":2466416.3247807911},{"$f":"SUM(H103:H135)","v":1815891.427011543},{"$f":"SUM(I103:I135)","v":2073526.2009326159},{"$f":"SUM(J103:J135)","v":0}]
[]
[]
["Applications Projected to be filed. Next 12 Months"]
["Filing Description","Estimated Filing Date","Filing Basis","Proposed Revenue Requirement ($000)","Proposed Revenue Recovery Mechanism","Projected Authorized Revenue Requirement ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2023,2024,2025,2026,2027]
[]
[]
[]
[]
["Public Policy Proceedings"]