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

{"sheet":"Authorized Rev Req","index":0,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["SDG&E Gas Revenue Requirement List"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended December 31"]
["Submitted: December 1, 2022"]
[null,"Revenue Requirement Date:","2022-01-01"]
[null,"Advice Letter:","AL 3046-G"]
["Filing Description","Authority for Revenue Requirement as of 1/1/2022","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051, A.22-05-016",412393.92784195661,"Allocated Base Margin","N"]
["SCG Transport excl Core Storge & Load Balance $000","D.20-02-045, AL 3024-G",10101.5487258045,"ECPT","N"]
["SCG Core Seasonal Storage","D.20-02-045, AL 3024-G",14374.700920168953,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.20-02-045, AL 3024-G",9102.0837826634306,"ECPT","N"]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)","D.19-09-051",2576.6109000000001,"Local Transmission","N"]
["LUAF","D.20-02-045, AL 3024-G, AL 3046-G",3180.2303217247427,"46% Res (LUAF, Other)","N"]
["Company Use Gas: Other","D.20-02-045, AL 3024-G, AL 3046-G",234.78660051758473,"ECPT","N"]
["SDG&E NGLAPBA","AL 3046-G",983.22148920005588,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct","AL 3046-G",1620.0351328756483,"EPAM","N"]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045, AL 3024-G, AL 3046-G",52.108015617715203,"Local Transmission","N"]
["CFCA","D.20-02-045, AL 3024-G, AL 3046-G",37541.479619999998,"CFCA","Y"]
["CFCA -NGV only","D.20-02-045, AL 3024-G, AL 3046-G",-210.72329159999998,"Non-Residential","Y"]
["CFCA - C&I shortfall only","D.20-02-045, AL 3024-G, AL 3046-G",5444.0260091999999,"Non-Residential","Y"]
["Hazardous Substance Cleanup Cost Acct HSCCA","D.20-02-045, AL 3024-G, AL 3046-G",290.51172240000005,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045, AL 3024-G, AL 3046-G",10311.120288,"EPAM","Y"]
["PBOPBA","D.20-02-045, AL 3024-G, AL 3046-G",-623.51692177259997,"EPAM","Y"]
["Pension BA","D.20-02-045, AL 3024-G, AL 3046-G",-575.93130622920012,"EPAM","Y"]
["Safety Enhancement Balancing Account - Local Transmission","D.20-02-045, AL 3024-G, AL 3046-G",3036.4630647777644,"Local Transmission","Y"]
["Safety Enhancement Balancing Account - Distribution","D.20-02-045, AL 3024-G, AL 3046-G",38688.933410192403,"Distribution","Y"]
["Rewards & Penalties Bal Acct  RPBA","D.20-02-045, AL 3024-G, AL 3046-G",-127.86607500000001,"EPAM","Y"]
["SGPMA - Rev Req for NEXT Year","D.20-02-045, AL 3024-G, AL 3046-G",1545.2359431600003,"ECPT","Y"]
["Integrated Transmission  Margin ITBA","D.20-02-045, AL 3024-G, AL 3046-G",24.550286399999997,"ECPT","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 3024-G, AL 3046-G",3038.0979420000003,"EPAM","Y"]
["Residential Uncollectible Balancing Account","D.20-02-045, AL 3024-G, AL 3046-G",5629.1760858000007,"EPAM","Y"]
["NFCA -Margin Only","D.20-02-045, AL 3024-G, AL 3046-G",-7128.7894133999998,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.20-02-045, AL 3024-G, AL 3046-G",1705.2219761999997,"Non-Residential","Y"]
["NFCA -Nonmargin SCG","D.20-02-045, AL 3024-G, AL 3046-G",-100.24700279999999,"Non-Residential","Y"]
["Minimum Bil/Customer Charge Revenue ","D.20-02-045, AL 3024-G, AL 3046-G",1816.4409600000001,"All Residential","N"]
["Borrego Revenue","D.20-02-045, AL 3024-G, AL 3046-G",64.571742326140509,"All Residential","N"]
["Employee Discount (Schd GR)","D.20-02-045, AL 3024-G, AL 3046-G",-367.20946999999097,"All Residential","N"]
["SDFFD","D.20-02-045, AL 3024-G, AL 3046-G",1986.9012193223789,"All Residential","N"]
["TSO Balancing Account AL","AL 3040-G",{"$f":"0","v":0},"EPAM","Y"]
["CIS Balancing Account AL","AL 3039-G",{"$f":"0","v":0},"EPAM","Y"]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C9:C42)","v":556607.70051950624}]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.20-02-045, AL 3024-G, AL 3046-G",62728.323235565404,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.20-02-045, AL 3024-G, AL 3046-G",830.72849948880003,"46% Res (LUAF, Other)","N"]
["AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",528.8540862000001,"46% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.20-02-045, AL 3024-G, AL 3046-G",-138.095361,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.20-02-045, AL 3024-G, AL 3046-G",-5290.5867191999996,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.20-02-045, AL 3024-G, AL 3046-G",-11.252214599999999,"46% Res (LUAF, Other)","Y"]
["FERC Settlement Proceeds MA","D.20-02-045, AL 3024-G, AL 3046-G",1.0229286000000002,"Non-Residential","Y"]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees","D.20-02-045, AL 3024-G, AL 3046-G",413.26315440000002,"46% Res (LUAF, Other)","Y"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM","D.20-02-045, AL 3024-G, AL 3046-G",105.36164580000001,"EPAM","Y"]
["TLS Adjustment","D.20-02-045, AL 3024-G, AL 3046-G",6681.9931823319448,"Non-Residential","N"]
["CSI Thermal Program memoradum Account","D.20-02-045, AL 3024-G, AL 3046-G",806.06773680000003,"46% Res (LUAF, Other)","Y"]
[]
[]
[]
[]
[]
[]
["California Alternate Rates for Energy (CARE) - Funding","AL 3027-G-A, D.21-06-015",25613.072,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Admin Expenses","AL 3027-G-A, D.21-06-015",727.2829999999999,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3027-G-A",1000,"Public Purpose Programs","Y"]
["Energy Savings Assistance (ESA/LIEE/DAP)","AL 3027-G-A, D.21-06-015",8041.1949999999997,"Public Purpose Programs","N"]
["Energy Efficiency","AL 3027-G-A, AL 3035-G",15368.681745714286,"Public Purpose Programs","N"]
["RD&D ","AL 3027-G-A",1929.78072,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3027-G-A",56.159990000000001,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,{"$f":"SUM(C46:C74)","v":119391.85263010046}]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procrement",null,{"$f":"SUM(C78:C83)","v":372042.57581360283}]
[]
["Total Authorized Revenue",null,{"$f":"C43+C75+C84","v":1048042.1289632095}]

{"sheet":"Incremental Rev Req","index":1,"n_rows":113,"n_cols":10,"rows_kept":113,"cut":false,"hidden":false,"merged":[[7,0,7,9],[80,0,80,9],[81,5,81,9]]}
["SDG&E Gas Revenue Requirement List"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended December 31"]
["Submitted: December 1, 2022"]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!C86","v":1048042.1289632095}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!C5","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]
["Total Allocated Base Margin",null,"D.19-09-051, A.22-05-016",{"$f":"F11","v":412393.92784195661},"Allocated Base Margin",412393.92784195661,504916,{"$f":"G11","v":504916},{"$f":"H11","v":504916},{"$f":"I11","v":504916}]
["SCG Transport excl Core Storge & Load Balance $000",null,"D.20-02-045, AL 3024-G",{"$f":"F12","v":10101.5487258045},"ECPT",10101.5487258045,{"$f":"F12","v":10101.5487258045},{"$f":"0","v":0},{"$f":"H12","v":0},0]
["SCG Core Seasonal Storage",null,"D.20-02-045, AL 3024-G",14374.700920168953,"Seasonal Storage",14374.700920168953,{"$f":"F13","v":14374.700920168953},{"$f":"0","v":0},0,0]
["SCG Load Balancing Allocated to ALL SDGE $000",null,"D.20-02-045, AL 3024-G",9102.0837826634306,"ECPT",9102.0837826634306,9102.0837826634306,{"$f":"0","v":0},0,0]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)",null,"D.19-09-051",2576.6109000000001,"Local Transmission",2576.6109000000001,2728.4247,{"$f":"G15","v":2728.4247},{"$f":"0","v":0},0]
["LUAF",null,"D.20-02-045, AL 3024-G, AL 3046-G",3180.2303217247427,"46% Res (LUAF, Other)",3180.2303217247427,{"$f":"F16","v":3180.2303217247427},{"$f":"0","v":0},{"$f":"H16","v":0},0]
["Company Use Gas: Other",null,"D.20-02-045, AL 3024-G, AL 3046-G",234.78660051758473,"ECPT",234.78660051758473,{"$f":"F17","v":234.78660051758473},{"$f":"0","v":0},0,0]
["SDG&E NGLAPBA",null,"AL 3046-G",983.22148920005588,"EPAM",983.22148920005588,983.22148920005588,{"$f":"0","v":0},0,0]
["SDG&ENERBA - NGLAP Subacct",null,"AL 3046-G",1620.0351328756483,"EPAM",1620.0351328756483,1620.0351328756483,{"$f":"0","v":0},0,0]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045, AL 3024-G, AL 3046-G",52.108015617715203,"Local Transmission",52.108015617715203,52.108015617715203,{"$f":"0","v":0},0,0]
["CFCA",null,"D.20-02-045, AL 3024-G, AL 3046-G",37541.479619999998,"CFCA",37541.479619999998,37541.479619999998,{"$f":"0","v":0},0,0]
["CFCA -NGV only",null,"D.20-02-045, AL 3024-G, AL 3046-G",-210.72329159999998,"Non-Residential",-210.72329159999998,-210.72329159999998,{"$f":"0","v":0},0,0]
["CFCA - C&I shortfall only",null,"D.20-02-045, AL 3024-G, AL 3046-G",5444.0260091999999,"Non-Residential",5444.0260091999999,5444.0260091999999,{"$f":"0","v":0},0,0]
["Hazardous Substance Cleanup Cost Acct HSCCA",null,"D.20-02-045, AL 3024-G, AL 3046-G",290.51172240000005,"ECPT",290.51172240000005,290.51172240000005,{"$f":"0","v":0},0,0]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045, AL 3024-G, AL 3046-G",10311.120288,"EPAM",10311.120288,15077.545999999998,18705.772299999997,21791.861599999997,24855.447099999998]
["PBOPBA",null,"D.20-02-045, AL 3024-G, AL 3046-G",-623.51692177259997,"EPAM",-623.51692177259997,{"$f":"F26","v":-623.51692177259997},{"$f":"0","v":0},{"$f":"H26","v":0},0]
["Pension BA",null,"D.20-02-045, AL 3024-G, AL 3046-G",-575.93130622920012,"EPAM",-575.93130622920012,{"$f":"F27","v":-575.93130622920012},{"$f":"0","v":0},0,0]
["Safety Enhancement Balancing Account - Local Transmission",null,"D.20-02-045, AL 3024-G, AL 3046-G",3036.4630647777644,"Local Transmission",3036.4630647777644,3036.4630647777644,{"$f":"0","v":0},0,0]
["Safety Enhancement Balancing Account - Distribution",null,"D.20-02-045, AL 3024-G, AL 3046-G",38688.933410192403,"Distribution",38688.933410192403,38688.933410192403,{"$f":"0","v":0},0,0]
["Rewards & Penalties Bal Acct  RPBA",null,"D.20-02-045, AL 3024-G, AL 3046-G",-127.86607500000001,"EPAM",-127.86607500000001,-127.86607500000001,{"$f":"0","v":0},0,0]
["SGPMA - Rev Req for NEXT Year",null,"D.20-02-045, AL 3024-G, AL 3046-G",1545.2359431600003,"ECPT",1545.2359431600003,1545.2359431600003,{"$f":"0","v":0},0,0]
["Integrated Transmission  Margin ITBA",null,"D.20-02-045, AL 3024-G, AL 3046-G",24.550286399999997,"ECPT",24.550286399999997,24.550286399999997,{"$f":"0","v":0},0,0]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 3024-G, AL 3046-G",3038.0979420000003,"EPAM",3038.0979420000003,3038.0979420000003,{"$f":"0","v":0},0,0]
["Residential Uncollectible Balancing Account",null,"D.20-02-045, AL 3024-G, AL 3046-G",5629.1760858000007,"EPAM",5629.1760858000007,5629.1760858000007,{"$f":"0","v":0},0,0]
["NFCA -Margin Only",null,"D.20-02-045, AL 3024-G, AL 3046-G",-7128.7894133999998,"Non-Residential",-7128.7894133999998,-7128.7894133999998,{"$f":"0","v":0},0,0]
["NFCA -Nonmargin Other",null,"D.20-02-045, AL 3024-G, AL 3046-G",1705.2219761999997,"Non-Residential",1705.2219761999997,1705.2219761999997,{"$f":"0","v":0},0,0]
["NFCA -Nonmargin SCG",null,"D.20-02-045, AL 3024-G, AL 3046-G",-100.24700279999999,"Non-Residential",-100.24700279999999,-100.24700279999999,{"$f":"0","v":0},0,0]
["Minimum Bil/Customer Charge Revenue ",null,"D.20-02-045, AL 3024-G, AL 3046-G",1816.4409600000001,"All Residential",1816.4409600000001,1816.4409600000001,{"$f":"0","v":0},0,0]
["Borrego Revenue",null,"D.20-02-045, AL 3024-G, AL 3046-G",64.571742326140509,"All Residential",64.571742326140509,64.571742326140509,{"$f":"0","v":0},0,0]
["Employee Discount (Schd GR)",null,"D.20-02-045, AL 3024-G, AL 3046-G",-367.20946999999097,"All Residential",-367.20946999999097,-367.20946999999097,{"$f":"0","v":0},0,0]
["SDFFD",null,"D.20-02-045, AL 3024-G, AL 3046-G",1986.9012193223789,"All Residential",1986.9012193223789,1986.9012193223789,{"$f":"0","v":0},0,0]
["TSO Balancing Account AL",null,"AL 3040-G",0,"EPAM",0,{"$f":"7058.15","v":7058.15},{"$f":"3529.075","v":3529.0749999999998},{"$f":"0","v":0},{"$f":"I42","v":0}]
["CIS Balancing Account AL",null,"AL 3039-G",0,"EPAM",0,17168,11448.492,{"$f":"0","v":0},0]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.20-02-045, AL 3024-G, AL 3046-G",62728.323235565404,"GHG End User",62728.323235565404,{"$f":"F46","v":62728.323235565404},{"$f":"0","v":0},{"$f":"H46*1.121","v":0},0]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.20-02-045, AL 3024-G, AL 3046-G",830.72849948880003,"46% Res (LUAF, Other)",830.72849948880003,{"$f":"F47","v":830.72849948880003},{"$f":"0","v":0},{"$f":"H47","v":0},0]
["AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",528.8540862000001,"46% Res (LUAF, Other)",528.8540862000001,528.8540862000001,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 3024-G, AL 3046-G",-138.095361,"ECPT",-138.095361,-138.095361,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 3024-G, AL 3046-G",-5290.5867191999996,"GHG End User",-5290.5867191999996,-5290.5867191999996,{"$f":"0","v":0},0,0]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 3024-G, AL 3046-G",-11.252214599999999,"46% Res (LUAF, Other)",-11.252214599999999,-11.252214599999999,{"$f":"0","v":0},0,0]
["FERC Settlement Proceeds MA",null,"D.20-02-045, AL 3024-G, AL 3046-G",1.0229286000000002,"Non-Residential",1.0229286000000002,1.0229286000000002,{"$f":"0","v":0},0,0]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees",null,"D.20-02-045, AL 3024-G, AL 3046-G",413.26315440000002,"46% Res (LUAF, Other)",413.26315440000002,413.26315440000002,{"$f":"0","v":0},0,0]
["New Environmental Regulation Balancing Account (NERBA) - EPAM",null,"D.20-02-045, AL 3024-G, AL 3046-G",105.36164580000001,"EPAM",105.36164580000001,105.36164580000001,{"$f":"0","v":0},0,0]
["TLS Adjustment",null,"D.20-02-045, AL 3024-G, AL 3046-G",6681.9931823319448,"Non-Residential",6681.9931823319448,6681.9931823319448,{"$f":"0","v":0},0,0]
["CSI Thermal Program memoradum Account",null,"D.20-02-045, AL 3024-G, AL 3046-G",806.06773680000003,"46% Res (LUAF, Other)",806.06773680000003,806.06773680000003,{"$f":"0","v":0},0,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["California Alternate Rates for Energy (CARE) - Funding",null,"AL 3027-G-A, D.21-06-015",25613.072,"Public Purpose Programs",25613.072,11537.458000000001,11652.832,11769.36,11887.054]
["California Alternate Rates for Energy (CARE) - Admin Expenses",null,"AL 3027-G-A, D.21-06-015",727.2829999999999,"Public Purpose Programs",727.2829999999999,761.46983,771.47047999999995,813.95269999999994,814.18138999999996]
["California Alternate Rates for Energy (CARE) - Amortization",null,"AL 3027-G-A",1000,"Public Purpose Programs",1000,{"$f":"F64","v":1000},{"$f":"0","v":0},{"$f":"H64","v":0},{"$f":"I64","v":0}]
["Energy Savings Assistance (ESA/LIEE/DAP)",null,"AL 3027-G-A, D.21-06-015",8041.1949999999997,"Public Purpose Programs",8041.1949999999997,12315.641642931652,13505.588216717384,14340.988629792766,15138.709320357639]
["Energy Efficiency",null,"AL 3027-G-A, AL 3035-G",15368.681745714286,"Public Purpose Programs",15368.681745714286,11521.574792218715,{"$f":"G66","v":11521.574792218715},{"$f":"H66","v":11521.574792218715},{"$f":"I66","v":11521.574792218715}]
["RD&D ",null,"AL 3027-G-A",1929.78072,"Public Purpose Programs",1929.78072,{"$f":"F67","v":1929.78072},{"$f":"0","v":0},{"$f":"H67","v":0},0]
["Bureau Of Equalization BOE",null,"AL 3027-G-A",56.159990000000001,"Public Purpose Programs",56.159990000000001,{"$f":"F68","v":56.159990000000001},{"$f":"0","v":0},0,0]
[]
[]
[]
["Procurement",null,"D.97-07-061",{"$f":"F72","v":372042.57581360283},"Core Procurement",372042.57581360283,{"$f":"0","v":0},{"$f":"G72","v":0},{"$f":"H72","v":0},{"$f":"I72","v":0}]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,{"$f":"SUM(D11:D75)","v":1048042.1289632095},null,{"$f":"SUM(F11:F75)","v":1048042.1289632095},{"$f":"SUM(G11:G75)","v":784051.92733908584},{"$f":"SUM(H11:H75)","v":578779.22948893602},{"$f":"SUM(I11:I75)","v":565153.73772201152},{"$f":"SUM(J11:J75)","v":569132.96660257643}]
[]
["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-016","Application",{"$f":"SUM(F84:J84)","v":402240},"Allocated Base Margin",null,null,{"$f":"565242-H11","v":60326},{"$f":"626840-I11","v":121924},{"$f":"724906-J11","v":219990}]
["Pipeline Safety Enhancement Plan (PSEP) -Local T","A.22-05-016","Application",-706.42470000000003,"Local Transmission",null,null,{"$f":"2022-H15","v":-706.42470000000003}]
["TIMPBA","A.22-05-016","Application",7864,"Local Transmission",null,null,7864]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","Application",40844,"Distribution",null,null,40844]
["Catastrophic Event Memorandum Account (CEMA)","A.22-10-021","Application",7122,"EPAM",null,null,7122]
[null,null,null,0,null,null,0]
[null,null,null,0]
["Public Policy Proceedings",null,null,0]
["SDG&E Cost of Capital Application ","A.22-04-012","Application",5480,"EPAM",null,{"$f":"1370","v":1370},{"$f":"1370","v":1370},{"$f":"1370","v":1370},{"$f":"1370","v":1370}]
["Triennial Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",null,0,0,0,0]
["Natural Gas Leak Abatement","AL 3071-G","Advice Letter",58899,"EPAM",null,13170,15243,15243,15243]
["Energy Efficiency","A.22-03-005","Application",47840.294510586667,"Public Purpose Programs",null,null,15145.373038351518,16560.788615612913,16134.132856622236]
["PPPS Filing","AL 3137-G","Advice Letter",9355.1558148496333,"Public Purpose Programs",null,9355.1558148496333]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Regulatory Account Update","AL 3129-G","Advice Letter",4556.661692092066,"Seasonal Storage",null,4556.661692092066]
["Regulatory Account Update","AL 3129-G","Advice Letter",82.421132091550845,"Local Transmission",null,82.421132091550845]
["Regulatory Account Update","AL 3129-G","Advice Letter",2326.9542971582669,"46% Res (LUAF, Other)",null,2326.9542971582669]
["Regulatory Account Update","AL 3129-G","Advice Letter",18091.981244799994,"CFCA",null,18091.981244799994]
["Regulatory Account Update","AL 3129-G","Advice Letter",791.63059783400035,"Distribution",null,791.63059783400035]
["Regulatory Account Update","AL 3129-G","Advice Letter",-9352.9509850077811,"Non-Residential",null,-9352.9509850077811]
["Regulatory Account Update","AL 3129-G","Advice Letter",225.95752049963721,"All Residential",null,225.95752049963721]
["Regulatory Account Update","AL 3129-G","Advice Letter",-1764.542276149692,"GHG End User",null,-1764.542276149692]
["Regulatory Account Update","AL 3129-G","Advice Letter",16573.748866614194,"ECPT",null,16573.748866614194]
["Regulatory Account Update","AL 3129-G","Advice Letter",8327.3102627743428,"EPAM",null,8327.3102627743428]
["Regulatory Account Update","AL 3129-G","Advice Letter",-85487.42412640847,"Allocated Base Margin",null,-85487.42412640847]
[null,null,null,0]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D84:D112)","v":533309.77385173435},null,{"$f":"SUM(F84:F112)","v":0},{"$f":"SUM(G84:G112)","v":-21733.095958852253},{"$f":"SUM(H84:H112)","v":147207.9483383515},155097.78861561292,252737.13285662222]