{"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":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[31,1,31,14],[38,1,38,14]]}
[{"$f":"'Authorized Rev Req'!A1","v":"SoCalGas Revenue Requirement List"}]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2024"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended March 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'!H109","v":6955534.2907632161}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q8*0.01","v":69555.342907632163}]
[]
[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'!B100","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req'!A100","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D100","v":5074818.8489186997}]
[null,"B",{"$f":"'Incremental Rev Req'!B102","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req'!A102","v":"Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D102","v":371485}]
[null,"C",{"$f":"'Incremental Rev Req'!B105","v":"AL 6060"},{"$f":"'Incremental Rev Req'!A105","v":"TIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D105+'Incremental Rev Req'!D104","v":234731.71063045785}]
[null,"D",{"$f":"'Incremental Rev Req'!B103","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req'!A103","v":"NonCore Backbone Transmission"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D103","v":1029598.3097628092}]
[null,"E",{"$f":"'Incremental Rev Req'!B109","v":"AL 6224"},{"$f":"'Incremental Rev Req'!A109","v":"DIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D109","v":82765.636602892759}]
[]
[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'!A100","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q12","v":5074818.8489186997}]
[]
[]
[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'!B101","v":"A.22-05-015 "},{"$f":"'Incremental Rev Req'!A101","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'!D101","v":46322.525360000014}]
[null,"B",{"$f":"'Incremental Rev Req'!B106","v":"SDG&E AL 3257-G"},{"$f":"'Incremental Rev Req'!A106","v":"TIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D106","v":23730.672098993233}]
[null,"C",{"$f":"'Incremental Rev Req'!B107","v":"A.23-11-003"},{"$f":"'Incremental Rev Req'!A107","v":"Catastrophic Event Memorandum Account (CEMA) "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D107","v":52396.735833086008}]
[null,"D",{"$f":"'Incremental Rev Req'!B108","v":"A.23-11-003"},{"$f":"'Incremental Rev Req'!A108","v":"COVID-19 Pandemic Protections Memorandum Account (CPPMA)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D108","v":5828.2505756313421}]
[]
[]
[]
[]
[]
[5,"Total system-level revenue requirement if all pending revenue were granted in full:"]
[null,"A","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!O118","v":7899323.041395844}]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!P118","v":6916125.2768648351}]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!Q118","v":6774671.4117632816}]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!R118","v":7032740.0221167961}]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!S118","v":4680912.878168337}]
[]
[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 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,211.05699999999999]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,191.952]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,195.43299999999999]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,204.65]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,142.864]
[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 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82.27,45.2]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.77,41.2]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76.14,41.928887706098507]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79.760000000000005,43.857589637516298]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55.5,30.93]

{"sheet":"Authorized Rev Req","index":1,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2024"]
["Reporting Date: Quarter Ended March 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01","2024-01-01"]
[null,"Advice Letter:","AL 5915-G","AL 6071-G","AL 6088-G","AL 6168-G","AL 6213-G","AL 6237-G"]
["Filing Description","Authority for Revenue Requirement as of 1/1/2024","Authorized Revenue Requirement       ($000) ","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.2799938722,2828192.7647602689,"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,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,29982.760000000006,"Distribution","N"]
["  Company Use Gas: Other","D.20-02-045 AL 6071, AL 6045, AL 6210",1792.6929208784113,2442.7824068004993,2442.7824068004993,2442.7824068004993,2442.7824068005002,2021.5178140390128,"ECPT","N"]
["  Company Use Gas: Storage Load Balancing","D.20-02-045 AL 6071, AL 6045, AL 6210",1739.9823775441146,2371.288817256519,2371.288817256519,2371.288817256519,2371.2888172565199,1962.3534920550317,"ECPT","N"]
["  Exchange Revenues & Interutility Transactions","D.20-02-045 AL 6071, AL 6045, AL 6210",342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,342.77791000000002,"ECPT","N"]
["  Unaccounted For (UAF) Gas","D.20-02-045 AL 6071, AL 6045, AL 6210",43865.640785688673,59771.786676696618,59771.786676696618,59771.786676696618,59771.786676696633,49463.976491521389,"47% Res (LUAF, Other)","N"]
["  Well Incidents & Surface Leaks","D.20-02-045 AL 6071, AL 6045, AL 6210",226.38915428249578,308.48434647250184,308.48434647250184,308.48434647250184,308.48434647250201,255.28536639623627,"ECPT","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045 AL 6071, AL 6045, AL 6210",381.0924643613892,363.84340064715622,363.84340064715622,363.84340064715622,363.84340064715622,373.23910182592897,"Local Transmission","N"]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution","D.20-02-045 AL 6071, AL 6045, AL 6210",24839.85662656404,24959.799583904292,24959.799583904292,24959.799583904292,24959.799583904292,25796.911065795495,"Distribution","N"]
["AMI Balancing Account  (AMIBA)","D.20-02-045 AL 6071, AL 6045, AL 6210",-77756.901095456211,-323.97185928908709,-323.97185928908709,-323.97185928908709,-323.97185928908709,0,"EPAM","Y"]
["Residential Uncollectible Balancing Account  (RUBA) ","D.20-02-045 AL 6071, AL 6045, AL 6210",16080.829230363346,44745.198352024141,44745.198352024141,44745.198352024141,44745.198352024141,361045.45629300445,"ECPT","Y"]
["Affiliate Transfer Fee Account  (ATFA)","D.20-02-045 AL 6071, AL 6045, AL 6210",-56.852117204809616,-106.52167417156562,-106.52167417156562,-106.52167417156562,-106.52185926498186,-332.51517351882774,"EPAM","Y"]
["Core Fixed Cost Account - Non NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",-28133.81894370247,121885.43655903419,-12481.017073574887,-12481.017073574887,-15934.575731573012,-159234.4339632123,"CFCA","Y"]
["Core Fixed Cost Account - NGV  (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",9826.72414135078,-1151.9897406335253,-1401.3020835172681,-1401.3020835172681,-1401.3020835172681,-6384.867245124733,"Non-Residential","Y"]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ","D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",28765.692761009646,0,0,0,0,0,"Non-Residential","Y"]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)","D.20-02-045 AL 6071, AL 6045, AL 6210",395.85348400076731,434.22738384292143,434.22738384292143,434.22738384292143,434.22738384292143,623.91417663694745,"Non-Residential","Y"]
["Enhanced Oil Recovery Account  (EORA)  ","D.20-02-045 AL 6071, AL 6045, AL 6210",2530.5597398430609,-7124.2567864552111,-7124.2567864552111,-7124.2567864552111,-7124.2691656544375,9594.3896797095258,"EPAM","Y"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)","D.20-02-045 AL 6071, AL 6045, AL 6210",284.26278995019351,441.06566541085317,441.06566541085317,441.06566541085317,441.06566541085317,2438.2408158617095,"ECPT","Y"]
["Intervenor Award Memorandum Account  (IAMA)","D.20-02-045 AL 6071, AL 6045, AL 6210",731.58066503521957,832.93717869704278,832.93717869704278,832.93717869704278,832.93717869704278,435.57870822027792,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045 AL 6071, AL 6045, AL 6210",17468.470311041361,24824.504625728128,24824.504625728128,24824.504625728128,24824.547761103186,27664.398592009951,"EPAM","Y"]
["Noncore Fixed Cost Account  (NFCA)  Margin","D.20-02-045 AL 6071, AL 6045, AL 6210",6370.1809775920838,12427.604012052685,12427.604012052685,12427.604012052685,12427.834050448922,6309.9682501879579,"Non-Residential","Y"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin","D.20-02-045 AL 6071, AL 6045, AL 6210",-3275.1851982978651,959.63192651874249,959.63192651874249,959.63192651874249,-11436.667024366332,913.70340598259429,"Non-Residential","Y"]
["Integrated Transmission Balancing Account  (ITBA) Margin","D.20-02-045, AL 6071, AL 6045, AL 6210",176.09814139595812,5083.8850590894772,5083.8850590894772,5083.8850590894772,5083.8850590894772,-2088.9106059958776,"ECPT","Y"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-1423.0358831880883,3459.772548454087,3459.772548454087,3459.772548454087,3459.772548454087,5089.7942028112566,"ECPT","Y"]
["Compression Services Balancing Account  (CSBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-68.369488844234169,-73.636852931578687,-73.636852931578687,-73.636852931578687,-73.636852931578687,0,"Non-Residential","Y"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-1168.4484408377084,5918.6872446137231,5918.6872446137231,5918.6872446137231,5918.6872446137231,12182.449387643102,"ECPT","Y"]
["Noncore Storage Balancing Account  (NSBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",122.05121759349339,93.946777408666094,93.946777408666094,93.946777408666094,93.946777408666094,0,"ECPT","Y"]
["Pension Balancing Account  (PBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",11312.644088682704,9235.9689255481535,9235.9689255481535,9235.9689255481535,9235.9849740852605,23408.247268413917,"EPAM","Y"]
["PBOP Balancing Account  (PBOPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-4328.4227973909083,-4765.7902742977731,-4765.7902742977731,-4765.7902742977731,-4765.7985553955832,-1010.3988927540598,"EPAM","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210",22874.176540558052,24483.535529249115,24483.535529249115,24483.535529249115,24483.535529249115,25945.72456347875,"Local Transmission","Y"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6210",72521.186822647796,74787.023820241564,74787.023820241564,74787.023820241564,74787.023820241564,78908.462504203519,"Distribution","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210",572.09798322721713,-674.07808819608886,-674.07808819608886,-674.07808819608886,-674.07808819608886,-305.13476405558407,"Local Transmission","Y"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution","D.20-02-045, AL 6071, AL 6045, AL 6210",1611.907471579721,2206.0867435845412,2206.0867435845412,2206.0867435845412,2206.0867435845412,402.79583157444125,"Distribution","Y"]
["Research Royalty Memorandum Account  (RRMA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-160.82445015363919,-247.95082320763703,-247.95082320763703,-247.95082320763703,-247.9512540501419,-157.27504476026635,"EPAM","Y"]
["Self-Generation Program Memorandum Account  (SGPMA)","D.20-02-045, AL 6071, AL 6045, AL 6210",16267.798190288335,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,16265.025427685592,"SGIP","Y"]
["System Operator Gas Account  (SOGA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-57.474724884945573,-54.791024656889135,-54.791024656889135,-54.791024656889135,-54.791024656889135,0,"ECPT","Y"]
["Rewards & Penalties Balancing Account (RPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",-266.7671576355873,-288.87206106860225,-288.87206106860225,-288.87206106860225,-288.87256301637063,7370.2338338696845,"EPAM","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 6071, AL 6045, AL 6210",14313.748177749801,23349.855935962783,23349.855935962783,23349.855935962783,23349.896508969519,24061.231562666457,"EPAM","Y"]
["NonCore Backbone Transmission","D.20-02-045, AL 6071, AL 6045, AL 6210",205899.09902636753,307036.37711891095,307036.37711891095,307036.37711891095,307036.37711891095,302321.96641038521,"Backbone Transmission","N"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance","D.22-07-016, AL 6023, AL 6045, AL 6210",0,35607.3666859636,35607.3666859636,35607.3666859636,35607.428557776948,0,"EPAM","Y"]
["On-Bill Financing Balancing Account (OBFBA)","D.19-03-001, AL 5853-A",0,4574.3633340208544,4574.3633340208544,4574.3633340208544,4574.3712824927779,0,"EPAM","Y"]
["System Reliability Memorandum Account   (SRMA)","D.20-02-045, AL 6045, AL 6210",0,15184.322292874704,15184.322292874704,15184.322292874704,15184.322292874704,32096.064218294516,"ECPT","Y"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ","D.20-02-045, AL 6045, AL 6210",0,-61.478426684054938,-61.478426684054938,-61.478426684054938,-61.478533509751273,0,"EPAM","Y"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)","D.20-02-045, AL 6210",0,0,0,0,0,573.80824116959502,"ECPT","Y"]
[]
[]
["   Subtotal Safety Affordability Reliability",null,3230710.3526054835,3673812.4421397415,3539196.6761642485,3539196.6761642485,3523347.1944171903,3727501.6552862898]
[]
[]
["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,5106.2014202040336,"ECPT adjusted","N"]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",2676.4558822098343,2388.5750957260152,2388.5750957260152,2388.5750957260152,2388.5750957260152,2684.1598286442622,"ECPT","N"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",421911.65593735001,451660.15168836701,451660.15168836701,451660.15168836701,451660.15168836701,659841.41913136793,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.22-07-016, AL 6023, AL 6045, AL 6210",11523.700831049478,11338.595126925329,11338.595126925329,11338.595126925329,11338.595126925329,14890.288905538293,"47% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.22-07-016, AL 6023, AL 6045, AL 6210",110.10687339904621,-783.15163590176303,-783.15163590176303,-783.15163590176303,-783.15163590176303,-2420.193064735909,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.22-07-016, AL 6023, AL 6045, AL 6210",24082.112323034682,-22703.373092980601,-22703.373092980601,-22703.373092980601,-22703.373092980601,85564.855171911244,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.22-07-016, AL 6023, AL 6045, AL 6210",96.161475841515269,3057.4967008465737,3057.4967008465737,3057.4967008465737,3057.4967008465737,-7155.0303898461352,"47% Res (LUAF, Other)","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount","D.22-07-016, AL 6023, AL 6045, AL 6210",3566.9058998494452,5564.3922693223831,5564.3922693223831,5564.3922693223831,5564.3922693223831,8886.0215302670767,"ECPT adjusted","Y"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ","D.22-07-016, AL 6023, AL 6045, AL 6210",1979.7078861701277,6090.186376418309,6090.186376418309,6090.186376418309,6090.1969588036363,8805.7593683541018,"EPAM","Y"]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ","D.22-07-016, AL 6023, AL 6045, AL 6210",-2147.5120170099681,0,0,0,0,0,"EPAM","Y"]
["TLS Adjustment","D.22-07-016, AL 6023, AL 6045, AL 6210",-6644.931817014658,10390.216028451658,10421.053586768947,10394.546129042021,10191.858650344628,9095.5616061965702,"Non-Residential","N"]
["  Natural Gas Leak Abatement Program Revenue Requirement","AL 5915G, AL 6071, AL 6168-G, AL 5950-G-B",86446.464722770907,86431.165118197561,86431.165118197561,107531.46426397371,107531.65111201403,104496.82835282681,"EPAM","N"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ","D. 13-12-040, AL 6071, AL 6045, AL 6210",-48.669674355202922,0,0,0,0,0,"EPAM","Y"]
["Diary Biomethane Project Balancing Account  (DBPBA)","D. 17-12-004, AL 6071, AL 6045, AL 6210",45457.032564324829,34573.344052610402,34573.344052610402,34573.344052610402,34573.404127692869,1209.1955164650758,"EPAM","Y"]
["Diary Biomethane Project Memorandum Account  (DBPMA)","D. 17-12-004, AL 6071, AL 6045, AL 6210",0,8114.6562580048067,8114.6562580048067,8114.6562580048067,8114.6703581347574,5125.9905405987492,"EPAM","Y"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)","D. 10-01-022, AL 6071, AL 6045, AL 6210",1411.3819701407706,1113.8604547746736,1113.8604547746736,1113.8604547746736,1113.8604547746736,1391.1079788304662,"ECPT adjusted","Y"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Administrative Costs Subaccount ","D. 22-02-025, AL 6210",0,0,0,0,0,237.04701141936164,"EPAM","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D.16-12-043/D.19-12-009, AL 6071, AL 6045, AL 6210",10172.083196372587,0,0,0,0,0,"ECPT","Y"]
[null,null,null,null,null,null,null,null,"EPAM","N"]
[]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) "," D.21-06-015, AL 6052, AL 6216",229388.13208047274,199514.89150131575,199514.89150131575,199514.89150131575,199514.89150131575,272251.15142222279,"Public Purpose Programs","N"]
["Energy Efficiency "," AL 6052, AL 6216, AL 6209",107144.935,166906.52600000001,166906.52600000001,166906.52600000001,166906.52600000001,165866.63928,"Public Purpose Programs","N"]
["RD&D"," AL 6052, AL 6216",12406.90965,12264.871999999999,12264.871999999999,12264.871999999999,12264.871999999999,11380.117797799039,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE"," AL 6052, AL 6216",547.65497000000005,520.25400000000002,520.25400000000002,520.25400000000002,520.25400000000002,476.44983000000002,"Public Purpose Programs","N"]
["Energy Savings Assistance "," D.21-06-015,  AL 6052, AL 6216",0,80174.204849890506,80174.204849890506,80174.204849890506,80174.204849890506,111508.29992653689,"Public Purpose Programs","N"]
["SJVDGPMA","AL 6052, AL 6216",0,806.16499999999996,806.16499999999996,806.16499999999996,806.16499999999996,90.978000000000208,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,955187.35964896996,1062529.2292121728,1062560.06677049,1083633.8584585392,1083431.4425854799,1459332.8491646003]
[]
["EOR","D.20-02-045, AL 6045, AL ",-19696.026660334344,-25124.896599589265,-25124.896599589265,-25233.572656235308,-24742.548711656997,-32255.657450315099,"EPAM"]
[]
["Procurement"]
["Procurement","D.98-07-068",2611619.0544005278,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,1800955.4437626412,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,2611619.0544005278,3301020.3137379293,3301020.3137379293,3301020.3137379293,3301020.3137379293,1800955.4437626412]
[]
["Total Authorized Revenue",null,6777820.739994647,8012237.0884902552,7877652.1600730792,7898617.2757044816,7883056.4020289434,6955534.2907632161]

{"sheet":"Incremental Rev Req","index":2,"n_rows":144,"n_cols":19,"rows_kept":144,"cut":false,"hidden":false,"merged":[[6,0,6,10],[96,0,96,10],[97,5,97,9],[137,5,137,9],[136,0,136,11]]}
["SoCalGas Revenue Requirement List"]
["Annual Period 2024"]
["Reporting Date: Quarter Ended March 31"]
[]
["Current Revenue Requirement ($000):",6955534.2907632161]
["Current Revenue Requirement Effective:","2024-01-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,2024,2025,2026,2027,2028]
["Safety Affordability Reliability Proceedings",null,null,"2024-01-01",null,2024,2025,2026,2027,2028,null,null,null,"Core Procurement",1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412]
["Total Allocated Base Margin",null,"D.19-09-051",2828192.7647602689,"Allocated Base Margin",2828192.7647602689,2828192.7647602689,2828192.7647602689,2828192.7647602689,2828192.7647602689,"Existing",null,null,"Allocated Base Margin",2828192.7647602689,2828192.7647602689,2828192.7647602689,2828192.7647602689,2828192.7647602689]
["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,0,0,0,0,"Existing",null,null,"Distribution",135090.92940157346,0,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,0,0,0,0,"Existing",null,null,"ECPT adjusted",15383.330929301577,0,0,0,0]
["  Company Use Gas: Other",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",2021.5178140390128,"ECPT",2021.5178140390128,0,0,0,0,"Existing",null,null,"Local Transmission",46985.980501249091,0,0,0,0]
["  Company Use Gas: Storage Load Balancing",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",1962.3534920550317,"ECPT",1962.3534920550317,0,0,0,0,"Existing",null,null,"SGIP",16265.025427685592,0,0,0,0]
["  Exchange Revenues & Interutility Transactions",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",342.77791000000002,"ECPT",342.77791000000002,0,0,0,0,"Existing",null,null,"GHG End User",745406.27430327912,0,0,0,0]
["  Unaccounted For (UAF) Gas",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",49463.976491521389,"47% Res (LUAF, Other)",49463.976491521389,0,0,0,0,"Existing",null,null,"Public Purpose Programs",561573.6362565587,276818.17,276509.35600000003,153968.28599999999,0]
["  Well Incidents & Surface Leaks",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",255.28536639623627,"ECPT",255.28536639623627,0,0,0,0,"Existing",null,null,"Backbone Transmission",302321.96641038521,0,0,0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",373.23910182592897,"Local Transmission",373.23910182592897,0,0,0,0,"Existing",null,null,"47% Res (LUAF, Other)",57199.235007213545,0,0,0,0]
["SCG PSEP - 2017 Forecast Application RevReq Capital Cost - Distribution",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",25796.911065795495,"Distribution",25796.911065795495,0,0,0,0,"Existing",null,null,"ECPT",416618.38260740769,0,0,0,0]
["AMI Balancing Account  (AMIBA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",0,"EPAM",0,0,0,0,0,"Existing",null,null,"EPAM",178217.4751649854,49701.612944246554,49024.749769454305,52180.971312539885,51764.669645427013]
["Residential Uncollectible Balancing Account  (RUBA) ",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",361045.45629300445,"ECPT",361045.45629300445,0,0,0,0,"Existing",null,null,"CFCA",-159234.4339632123,0,0,0,0]
["Affiliate Transfer Fee Account  (ATFA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",-332.51517351882774,"EPAM",-332.51517351882774,0,0,0,0,"Existing",null,null,"Non-Residential",10558.280193879336,0,0,0,0]
["Core Fixed Cost Account - Non NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",-159234.4339632123,"CFCA",-159234.4339632123,0,0,0,0,"Existing",null,null,"Total",6955534.290763218,4955667.9914671564,4954682.3142923638,4835297.4658354502,4680912.878168337]
["Core Fixed Cost Account - NGV  (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",-6384.867245124733,"Non-Residential",-6384.867245124733,0,0,0,0,"Existing",null,null,"CPUC Fee",1E-3]
["Core Fixed Cost Account - C&I   Shortfall (CFCA) ",null,"D.20-02-045, AL 6071, AL 6045, AL 6088, AL 6210",0,"Non-Residential",0,0,0,0,0,"Existing",null,null,"Check",0,0,0,0,0]
["Economic Practicality Shortfall Memorandum Account  (EPSMA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",623.91417663694745,"Non-Residential",623.91417663694745,0,0,0,0,"Existing"]
["Enhanced Oil Recovery Account  (EORA)  ",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",9594.3896797095258,"EPAM",9594.3896797095258,0,0,0,0,"Existing"]
["Hazardous Substance Cost-Recovery Account  (HSCRA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",2438.2408158617095,"ECPT",2438.2408158617095,0,0,0,0,"Existing"]
["Intervenor Award Memorandum Account  (IAMA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",435.57870822027792,"ECPT",435.57870822027792,0,0,0,0,"Existing"]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",27664.398592009951,"EPAM",27664.398592009951,33619.643028128216,33231.789826917317,36899.477637248048,36899.477637248048,"Existing"]
["Noncore Fixed Cost Account  (NFCA)  Margin",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",6309.9682501879579,"Non-Residential",6309.9682501879579,0,0,0,0,"Existing"]
["Noncore Fixed Cost Account  (NFCA)  Nonmargin",null,"D.20-02-045 AL 6071, AL 6045, AL 6210",913.70340598259429,"Non-Residential",913.70340598259429,0,0,0,0,"Existing"]
["Integrated Transmission Balancing Account  (ITBA) Margin",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",-2088.9106059958776,"ECPT",-2088.9106059958776,0,0,0,0,"Existing"]
["Compressor Station Fuel and Power Balancing Account (CFPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",5089.7942028112566,"ECPT",5089.7942028112566,0,0,0,0,"Existing"]
["Compression Services Balancing Account  (CSBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",0,"Non-Residential",0,0,0,0,0,"Existing"]
["Company-Use Fuel for Load Balancing Account (CUFLBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",12182.449387643102,"ECPT",12182.449387643102,0,0,0,0,"Existing"]
["Noncore Storage Balancing Account  (NSBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",0,"ECPT",0,0,0,0,0,"Existing"]
["Pension Balancing Account  (PBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",23408.247268413917,"EPAM",23408.247268413917,0,0,0,0,"Existing"]
["PBOP Balancing Account  (PBOPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",-1010.3988927540598,"EPAM",-1010.3988927540598,0,0,0,0,"Existing"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Local Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",25945.72456347875,"Local Transmission",25945.72456347875,0,0,0,0,"Existing"]
["Safety Enhancement Capital Cost Balancing Account (SECCBA) - Distribution",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",78908.462504203519,"Distribution",78908.462504203519,0,0,0,0,"Existing"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Local Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",-305.13476405558407,"Local Transmission",-305.13476405558407,0,0,0,0,"Existing"]
["Safety Enhancement Expense Balancing Account (SEEBA) - Distribution",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",402.79583157444125,"Distribution",402.79583157444125,0,0,0,0,"Existing"]
["Research Royalty Memorandum Account  (RRMA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",-157.27504476026635,"EPAM",-157.27504476026635,0,0,0,0,"Existing"]
["Self-Generation Program Memorandum Account  (SGPMA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",16265.025427685592,"SGIP",16265.025427685592,0,0,0,0,"Existing"]
["System Operator Gas Account  (SOGA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",0,"ECPT",0,0,0,0,0,"Existing"]
["Rewards & Penalties Balancing Account (RPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",7370.2338338696845,"EPAM",7370.2338338696845,0,0,0,0,"Existing"]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",24061.231562666457,"EPAM",24061.231562666457,0,0,0,0,"Existing"]
["NonCore Backbone Transmission",null,"D.20-02-045, AL 6071, AL 6045, AL 6210",302321.96641038521,"Backbone Transmission",302321.96641038521,0,0,0,0,"Existing"]
["Storage Integrity Management Program Balancing Account (SIMPBA) Balance",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",0,"EPAM",0,0,0,0,0,"Existing"]
["On-Bill Financing Balancing Account (OBFBA)",null,"D.19-03-001, AL 5853-A",0,"EPAM",0,0,0,0,0,"Existing"]
["System Reliability Memorandum Account   (SRMA)",null,"D.20-02-045, AL 6045, AL 6210",32096.064218294516,"ECPT",32096.064218294516,0,0,0,0,"Existing"]
["Distributed Energy Resources Svcs Bal Account  (DERSBA) ",null,"D.20-02-045, AL 6045, AL 6210",0,"EPAM",0,0,0,0,0,"Existing"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)",null,"D.20-02-045, AL 6210",573.80824116959502,"ECPT",573.80824116959502,0,0,0,0,"New"]
[]
[]
["Public Policy Proceedings"]
["  AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",5106.2014202040336,"ECPT adjusted",5106.2014202040336,0,0,0,0,"Existing"]
["  Green House Gas Balancing Account (GHGBA) - Company Gas Compressor Revenue Requirement",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",2684.1598286442622,"ECPT",2684.1598286442622,0,0,0,0,"Existing"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",659841.41913136793,"GHG End User",659841.41913136793,0,0,0,0,"Existing"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",14890.288905538293,"47% Res (LUAF, Other)",14890.288905538293,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",-2420.193064735909,"ECPT",-2420.193064735909,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",85564.855171911244,"GHG End User",85564.855171911244,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",-7155.0303898461352,"47% Res (LUAF, Other)",-7155.0303898461352,0,0,0,0,"Existing"]
["New Envirnomental Regulatory Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",8886.0215302670767,"ECPT adjusted",8886.0215302670767,0,0,0,0,"Existing"]
["New Environmental Regulatory Balancing Account (NERBA)  -  Leak Detection & Repair (LDAR) sub-account   ",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",8805.7593683541018,"EPAM",8805.7593683541018,0,0,0,0,"Existing"]
["New Envirnomental Regulatory Balancing Account (NERBA) -Natural Gas Leak Abatement Program ",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",0,"EPAM",0,0,0,0,0,"Existing"]
["TLS Adjustment",null,"D.22-07-016, AL 6023, AL 6045, AL 6210",9095.5616061965702,"Non-Residential",9095.5616061965702,0,0,0,0,"Existing"]
["  Natural Gas Leak Abatement Program Revenue Requirement",null,"AL 5915G, AL 6071, AL 6168-G, AL 5950-G-B",104496.82835282681,"EPAM",104496.82835282681,16081.969916118336,15792.959942536991,15281.493675291833,14865.192008178965,"Existing"]
["Biogas Conditioning/Upgrading Svcs Bal Acct  (BCSBA) ",null,"D. 13-12-040, AL 6071, AL 6045, AL 6210",0,"EPAM",0,0,0,0,0,"Existing"]
["Diary Biomethane Project Balancing Account  (DBPBA)",null,"D. 17-12-004, AL 6071, AL 6045, AL 6210",1209.1955164650758,"EPAM",1209.1955164650758,0,0,0,0,"Existing"]
["Diary Biomethane Project Memorandum Account  (DBPMA)",null,"D. 17-12-004, AL 6071, AL 6045, AL 6210",5125.9905405987492,"EPAM",5125.9905405987492,0,0,0,0,"Existing"]
["California Solar Iniative Thermal Memorandum Account (CSITPMA)",null,"D. 10-01-022, AL 6071, AL 6045, AL 6210",1391.1079788304662,"ECPT adjusted",1391.1079788304662,0,0,0,0,"Existing"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Administrative Costs Subaccount ",null,"D. 22-02-025, AL 6210",237.04701141936164,"EPAM",237.04701141936164,0,0,0,0,"Existing"]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) ",null," D.21-06-015, AL 6052, AL 6216",272251.15142222279,"Public Purpose Programs",272251.15142222279,0,0,0,0,"Existing"]
["Energy Efficiency ",null," AL 6052, AL 6216, AL 6209",165866.63928,"Public Purpose Programs",165866.63928,153968.28599999999,153968.28599999999,153968.28599999999,0,"Existing"]
["RD&D",null," AL 6052, AL 6216",11380.117797799039,"Public Purpose Programs",11380.117797799039,0,0,0,0,"Existing"]
["Bureau Of Equalization BOE",null," AL 6052, AL 6216",476.44983000000002,"Public Purpose Programs",476.44983000000002,0,0,0,0,"Existing"]
["Energy Savings Assistance ",null," D.21-06-015,  AL 6052, AL 6216",111508.29992653689,"Public Purpose Programs",111508.29992653689,122849.88400000001,122541.07,0,0,"Existing"]
["SJVDGPMA",null,null,90.978000000000208,"Public Purpose Programs",90.978000000000208,0,0,0,0,"Existing"]
[]
[]
["EOR",null,"D.20-02-045, AL 6045, AL ",-32255.657450315099,"EPAM",-32255.657450315099,0,0,0,0,"Existing"]
[]
[]
["Procurement",null,"D.98-07-068",1800955.4437626412,"Core Procurement",1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,6955534.290763217,null,6955297.2437517978,4955667.9914671564,4954682.3142923638,4835297.4658354502,4680912.878168337]
[]
["CPUC Fee",null,null,null,"CPUC Fee",1E-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,2024,2025,2026,2027,2028,null,"Include in Impact"]
["2024 GRC Application","A.22-05-015 ","Application",5074818.8489186997,"Allocated Base Margin",842341.5302681108,1117953.093205363,1371359.8610533625,1743164.3643918633,null,"Existing","Y"]
["Pipeline Safety Enhancement Plan (PSEP) GRC - Local Transmission ","A.22-05-015 ","Application",46322.525360000014,"Local Transmission",172464.1797392508,172464.1797392508,172464.1797392508,172464.1797392508,null,"Existing","Y"]
["Pipeline Safety Enhancement Plan (PSEP) GRC -Distribution","A.22-05-015 ","Application",371485,"Distribution",71227.039999999994,97396.58,100074.64,102786.74,null,"Existing","Y",null,"Authorized + Pending"]
["NonCore Backbone Transmission","A.22-05-015 ","Application",1029598.3097628092,"Backbone Transmission",34227.381164516846,329328.83377125376,331779.92297755583,334262.17184948269,null,"Existing","Y",null,null,2024,2025,2026,2027,2028]
["TIMPBA","AL 6060","Advice Letter",62267.530891207047,"Local Transmission",null,62267.530891207047,null,null,null,"New","Y",null,"Core Procurement",1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412,1800955.4437626412]
["TIMPBA","AL 6060","Advice Letter",172464.1797392508,"Backbone Transmission",null,172464.1797392508,null,null,null,"New","Y",null,"Allocated Base Margin",3670534.2950283797,3946145.8579656319,4199552.6258136313,4571357.1291521322,2828192.7647602689]
["TIMPBA","SDG&E AL 3257-G","Advice Letter",23730.672098993233,"ECPT",null,23730.672098993233,null,null,null,"New","Y",null,"Distribution",206317.96940157347,97396.58,100074.64,102786.74,0]
["Catastrophic Event Memorandum Account (CEMA) ","A.23-11-003","Application",52396.735833086008,"ECPT",null,52396.735833086008,null,null,null,"New","Y",null,"ECPT adjusted",15383.330929301577,0,0,0,0]
["COVID-19 Pandemic Protections Memorandum Account (CPPMA)","A.23-11-003","Application",5828.2505756313421,"ECPT",null,5828.2505756313421,null,null,null,"New","Y",null,"Local Transmission",42978.779701249106,78593.303571207041,16774.673440000002,17229.280040000001,0]
["DIMPBA","AL 6224","Advice Letter",82765.636602892759,"EPAM",null,82765.636602892759,null,null,null,"New","Y",null,"SGIP",16265.025427685592,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"GHG End User",745406.27430327912,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Public Purpose Programs",561573.6362565587,276818.17,276509.35600000003,153968.28599999999,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Backbone Transmission",336549.34757490206,501793.01351050456,331779.92297755583,334262.17184948269,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"47% Res (LUAF, Other)",57199.235007213545,0,0,0,0]
["Public Policy Proceedings",null,null,0,null,null,null,null,null,null,null,"-",null,"ECPT",416618.38260740769,81955.658507710585,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"EPAM",178217.4751649854,132467.2495471393,49024.749769454305,52180.971312539885,51764.669645427013]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,0,null,"Y",null,"CFCA",-159234.4339632123,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Non-Residential",10558.280193879336,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Total",7899323.041395844,6916125.2768648351,6774671.4117632816,7032740.0221167961,4680912.878168337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Revenues",943788.750632626,1960457.2853976786,1819989.0974709177,2197442.5562813459,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CPUC Fee",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Check Figure",0,3.2177194952964783E-7,8.172355592250824E-8,-3.4598633646965027E-7,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Pending, Filed but not Approved",null,null,6921677.6897825701,null,943788.75063262763,1960457.2853976781,1819989.0974709182,2197442.5562813459,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,2024,2025,2026,2027,2028]
[]
[]
[]
[]
["Public Policy Proceedings"]