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

{"sheet":"Authorized Rev Req","index":0,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["San Diego Gas & Electric Company"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended September 30"]
["Submitted October 14, 2022"]
[]
[null,"Revenue Requirement Date:","2022-01-01"]
[null,"Advice Letter:","AL 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"]
[]
[]
["   Subtotal Safety Affordability Reliability",null,{"$f":"SUM(C10:C43)","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) - EPCT","D.20-02-045, AL 3024-G, AL 3046-G",413.26315440000002,"ECPT","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(C47:C75)","v":119391.85263010046}]
[]
["Procurement"]
["Procurement","D.97-07-061",313349.629312,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procrement",null,{"$f":"SUM(C79:C84)","v":313349.629312}]
[]
["Total Authorized Revenue",null,{"$f":"C44+C76+C85","v":989349.18246160669}]

{"sheet":"Incremental Rev Req","index":1,"n_rows":113,"n_cols":10,"rows_kept":113,"cut":false,"hidden":false,"merged":[[81,5,81,9],[7,0,7,9],[80,0,80,9]]}
["San Diego Gas & Electric Company"]
["Annual Period 2022"]
["Reporting Date: Quarter Ended September 30"]
["Submitted October 14, 2022"]
[]
["Current Revenue Requirement ($000):",{"$f":"'Authorized Rev Req'!C87","v":989349.18246160669}]
["Current Revenue Requirement Effective:",{"$f":"'Authorized Rev Req'!C6","v":"2022-01-01"}]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year"]
["Safety Affordability Reliability Proceedings",null,null,{"$f":"B7","v":"2022-01-01"},null,2022,2023,2024,2025,2026]
[{"$f":"'Authorized Rev Req'!A10","v":"Total Allocated Base Margin"},null,{"$f":"'Authorized Rev Req'!B10","v":"D.19-09-051, A.22-05-016"},{"$f":"F11","v":412393.92784195661},{"$f":"'Authorized Rev Req'!D10","v":"Allocated Base Margin"},{"$f":"'Authorized Rev Req'!C10","v":412393.92784195661},504916,{"$f":"G11","v":504916},{"$f":"H11","v":504916},{"$f":"I11","v":504916}]
[{"$f":"'Authorized Rev Req'!A11","v":"SCG Transport excl Core Storge & Load Balance $000"},null,{"$f":"'Authorized Rev Req'!B11","v":"D.20-02-045, AL 3024-G"},{"$f":"F12","v":10101.5487258045},{"$f":"'Authorized Rev Req'!D11","v":"ECPT"},{"$f":"'Authorized Rev Req'!C11","v":10101.5487258045},{"$f":"0","v":0},{"$f":"G12","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A12","v":"SCG Core Seasonal Storage"},null,{"$f":"'Authorized Rev Req'!B12","v":"D.20-02-045, AL 3024-G"},14374.700920168953,{"$f":"'Authorized Rev Req'!D12","v":"Seasonal Storage"},{"$f":"'Authorized Rev Req'!C12","v":14374.700920168953},{"$f":"0","v":0},{"$f":"G13","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A13","v":"SCG Load Balancing Allocated to ALL SDGE $000"},null,{"$f":"'Authorized Rev Req'!B13","v":"D.20-02-045, AL 3024-G"},9102.0837826634306,{"$f":"'Authorized Rev Req'!D13","v":"ECPT"},{"$f":"'Authorized Rev Req'!C13","v":9102.0837826634306},{"$f":"0","v":0},{"$f":"G14","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A14","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B14","v":"D.19-09-051"},2576.6109000000001,{"$f":"'Authorized Rev Req'!D14","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C14","v":2576.6109000000001},2728.4247,{"$f":"G15","v":2728.4247},{"$f":"0","v":0},{"$f":"I15","v":0}]
[{"$f":"'Authorized Rev Req'!A15","v":"LUAF"},null,{"$f":"'Authorized Rev Req'!B15","v":"D.20-02-045, AL 3024-G, AL 3046-G"},{"$f":"F16","v":3180.2303217247427},{"$f":"'Authorized Rev Req'!D15","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C15","v":3180.2303217247427},{"$f":"0","v":0},{"$f":"G16","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A16","v":"Company Use Gas: Other"},null,{"$f":"'Authorized Rev Req'!B16","v":"D.20-02-045, AL 3024-G, AL 3046-G"},234.78660051758473,{"$f":"'Authorized Rev Req'!D16","v":"ECPT"},{"$f":"'Authorized Rev Req'!C16","v":234.78660051758473},{"$f":"0","v":0},{"$f":"G17","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A17","v":"SDG&E NGLAPBA"},null,{"$f":"'Authorized Rev Req'!B17","v":"AL 3046-G"},983.22148920005588,{"$f":"'Authorized Rev Req'!D17","v":"EPAM"},{"$f":"'Authorized Rev Req'!C17","v":983.22148920005588},{"$f":"0","v":0},{"$f":"G18","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A18","v":"SDG&ENERBA - NGLAP Subacct"},null,{"$f":"'Authorized Rev Req'!B18","v":"AL 3046-G"},1620.0351328756483,{"$f":"'Authorized Rev Req'!D18","v":"EPAM"},{"$f":"'Authorized Rev Req'!C18","v":1620.0351328756483},{"$f":"0","v":0},{"$f":"G19","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A19","v":"SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B19","v":"D.20-02-045, AL 3024-G, AL 3046-G"},52.108015617715203,{"$f":"'Authorized Rev Req'!D19","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C19","v":52.108015617715203},{"$f":"0","v":0},{"$f":"G20","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A20","v":"CFCA"},null,{"$f":"'Authorized Rev Req'!B20","v":"D.20-02-045, AL 3024-G, AL 3046-G"},37541.479619999998,{"$f":"'Authorized Rev Req'!D20","v":"CFCA"},{"$f":"'Authorized Rev Req'!C20","v":37541.479619999998},{"$f":"0","v":0},{"$f":"G21","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A21","v":"CFCA -NGV only"},null,{"$f":"'Authorized Rev Req'!B21","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-210.72329159999998,{"$f":"'Authorized Rev Req'!D21","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C21","v":-210.72329159999998},{"$f":"0","v":0},{"$f":"G22","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A22","v":"CFCA - C&I shortfall only"},null,{"$f":"'Authorized Rev Req'!B22","v":"D.20-02-045, AL 3024-G, AL 3046-G"},5444.0260091999999,{"$f":"'Authorized Rev Req'!D22","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C22","v":5444.0260091999999},{"$f":"0","v":0},{"$f":"G23","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A23","v":"Hazardous Substance Cleanup Cost Acct HSCCA"},null,{"$f":"'Authorized Rev Req'!B23","v":"D.20-02-045, AL 3024-G, AL 3046-G"},290.51172240000005,{"$f":"'Authorized Rev Req'!D23","v":"ECPT"},{"$f":"'Authorized Rev Req'!C23","v":290.51172240000005},{"$f":"0","v":0},{"$f":"G24","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A24","v":"Master Meter Balancing Account  (MMBA)"},null,{"$f":"'Authorized Rev Req'!B24","v":"D.20-02-045, AL 3024-G, AL 3046-G"},10311.120288,{"$f":"'Authorized Rev Req'!D24","v":"EPAM"},{"$f":"'Authorized Rev Req'!C24","v":10311.120288},15077.545999999998,18705.772299999997,21791.861599999997,24855.447099999998]
[{"$f":"'Authorized Rev Req'!A25","v":"PBOPBA"},null,{"$f":"'Authorized Rev Req'!B25","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-623.51692177259997,{"$f":"'Authorized Rev Req'!D25","v":"EPAM"},{"$f":"'Authorized Rev Req'!C25","v":-623.51692177259997},{"$f":"0","v":0},{"$f":"G26","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A26","v":"Pension BA"},null,{"$f":"'Authorized Rev Req'!B26","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-575.93130622920012,{"$f":"'Authorized Rev Req'!D26","v":"EPAM"},{"$f":"'Authorized Rev Req'!C26","v":-575.93130622920012},{"$f":"0","v":0},{"$f":"G27","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A27","v":"Safety Enhancement Balancing Account - Local Transmission"},null,{"$f":"'Authorized Rev Req'!B27","v":"D.20-02-045, AL 3024-G, AL 3046-G"},3036.4630647777644,{"$f":"'Authorized Rev Req'!D27","v":"Local Transmission"},{"$f":"'Authorized Rev Req'!C27","v":3036.4630647777644},{"$f":"0","v":0},{"$f":"G28","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A28","v":"Safety Enhancement Balancing Account - Distribution"},null,{"$f":"'Authorized Rev Req'!B28","v":"D.20-02-045, AL 3024-G, AL 3046-G"},38688.933410192403,{"$f":"'Authorized Rev Req'!D28","v":"Distribution"},{"$f":"'Authorized Rev Req'!C28","v":38688.933410192403},{"$f":"0","v":0},{"$f":"G29","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A29","v":"Rewards & Penalties Bal Acct  RPBA"},null,{"$f":"'Authorized Rev Req'!B29","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-127.86607500000001,{"$f":"'Authorized Rev Req'!D29","v":"EPAM"},{"$f":"'Authorized Rev Req'!C29","v":-127.86607500000001},{"$f":"0","v":0},{"$f":"G30","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A30","v":"SGPMA - Rev Req for NEXT Year"},null,{"$f":"'Authorized Rev Req'!B30","v":"D.20-02-045, AL 3024-G, AL 3046-G"},1545.2359431600003,{"$f":"'Authorized Rev Req'!D30","v":"ECPT"},{"$f":"'Authorized Rev Req'!C30","v":1545.2359431600003},{"$f":"0","v":0},{"$f":"G31","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A31","v":"Integrated Transmission  Margin ITBA"},null,{"$f":"'Authorized Rev Req'!B31","v":"D.20-02-045, AL 3024-G, AL 3046-G"},24.550286399999997,{"$f":"'Authorized Rev Req'!D31","v":"ECPT"},{"$f":"'Authorized Rev Req'!C31","v":24.550286399999997},{"$f":"0","v":0},{"$f":"G32","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A32","v":"Liability Insurance Premium Balancing Account (LIPBA)"},null,{"$f":"'Authorized Rev Req'!B32","v":"D.20-02-045, AL 3024-G, AL 3046-G"},3038.0979420000003,{"$f":"'Authorized Rev Req'!D32","v":"EPAM"},{"$f":"'Authorized Rev Req'!C32","v":3038.0979420000003},{"$f":"0","v":0},{"$f":"G33","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A33","v":"Residential Uncollectible Balancing Account"},null,{"$f":"'Authorized Rev Req'!B33","v":"D.20-02-045, AL 3024-G, AL 3046-G"},5629.1760858000007,{"$f":"'Authorized Rev Req'!D33","v":"EPAM"},{"$f":"'Authorized Rev Req'!C33","v":5629.1760858000007},{"$f":"0","v":0},{"$f":"G34","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A34","v":"NFCA -Margin Only"},null,{"$f":"'Authorized Rev Req'!B34","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-7128.7894133999998,{"$f":"'Authorized Rev Req'!D34","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C34","v":-7128.7894133999998},{"$f":"0","v":0},{"$f":"G35","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A35","v":"NFCA -Nonmargin Other"},null,{"$f":"'Authorized Rev Req'!B35","v":"D.20-02-045, AL 3024-G, AL 3046-G"},1705.2219761999997,{"$f":"'Authorized Rev Req'!D35","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C35","v":1705.2219761999997},{"$f":"0","v":0},{"$f":"G36","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A36","v":"NFCA -Nonmargin SCG"},null,{"$f":"'Authorized Rev Req'!B36","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-100.24700279999999,{"$f":"'Authorized Rev Req'!D36","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C36","v":-100.24700279999999},{"$f":"0","v":0},{"$f":"G37","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A37","v":"Minimum Bil/Customer Charge Revenue "},null,{"$f":"'Authorized Rev Req'!B37","v":"D.20-02-045, AL 3024-G, AL 3046-G"},{"$f":"F38","v":1816.4409600000001},{"$f":"'Authorized Rev Req'!D37","v":"All Residential"},{"$f":"'Authorized Rev Req'!C37","v":1816.4409600000001},{"$f":"0","v":0},{"$f":"G38","v":0},{"$f":"H38","v":0},{"$f":"I38","v":0}]
[{"$f":"'Authorized Rev Req'!A38","v":"Borrego Revenue"},null,{"$f":"'Authorized Rev Req'!B38","v":"D.20-02-045, AL 3024-G, AL 3046-G"},64.571742326140509,{"$f":"'Authorized Rev Req'!D38","v":"All Residential"},{"$f":"'Authorized Rev Req'!C38","v":64.571742326140509},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A39","v":"Employee Discount (Schd GR)"},null,{"$f":"'Authorized Rev Req'!B39","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-367.20946999999097,{"$f":"'Authorized Rev Req'!D39","v":"All Residential"},{"$f":"'Authorized Rev Req'!C39","v":-367.20946999999097},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A40","v":"SDFFD"},null,{"$f":"'Authorized Rev Req'!B40","v":"D.20-02-045, AL 3024-G, AL 3046-G"},1986.9012193223789,{"$f":"'Authorized Rev Req'!D40","v":"All Residential"},{"$f":"'Authorized Rev Req'!C40","v":1986.9012193223789},{"$f":"0","v":0},0,0,0]
[{"$f":"'Authorized Rev Req'!A41","v":"TSO Balancing Account AL"},null,{"$f":"'Authorized Rev Req'!B41","v":"AL 3040-G"},{"$f":"F42","v":0},{"$f":"'Authorized Rev Req'!D41","v":"EPAM"},{"$f":"'Authorized Rev Req'!C41","v":0},{"$f":"7058.15","v":7058.15},{"$f":"3529.075","v":3529.0749999999998},{"$f":"0","v":0},0]
[]
[]
[{"$f":"'Authorized Rev Req'!A46","v":"Public Policy Proceedings"}]
[{"$f":"'Authorized Rev Req'!A47","v":"  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B47","v":"D.20-02-045, AL 3024-G, AL 3046-G"},62728.323235565404,{"$f":"'Authorized Rev Req'!D47","v":"GHG End User"},{"$f":"'Authorized Rev Req'!C47","v":62728.323235565404},{"$f":"0","v":0},{"$f":"G46*1.121","v":0},{"$f":"H46*1.121","v":0},0]
[{"$f":"'Authorized Rev Req'!A48","v":"  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement"},null,{"$f":"'Authorized Rev Req'!B48","v":"D.20-02-045, AL 3024-G, AL 3046-G"},830.72849948880003,{"$f":"'Authorized Rev Req'!D48","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C48","v":830.72849948880003},{"$f":"0","v":0},{"$f":"G47","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A49","v":"AB32 Fees (subtracted from base margin and allocated here)"},null,{"$f":"'Authorized Rev Req'!B49","v":"D.19-09-051"},528.8540862000001,{"$f":"'Authorized Rev Req'!D49","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C49","v":528.8540862000001},{"$f":"0","v":0},{"$f":"G48","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A50","v":"Green House Gas Balancing Account (GHGBA) - Company Gas Compressor"},null,{"$f":"'Authorized Rev Req'!B50","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-138.095361,{"$f":"'Authorized Rev Req'!D50","v":"ECPT"},{"$f":"'Authorized Rev Req'!C50","v":-138.095361},{"$f":"0","v":0},{"$f":"G49","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A51","v":"Green House Gas Balancing Account (GHGBA) - End User"},null,{"$f":"'Authorized Rev Req'!B51","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-5290.5867191999996,{"$f":"'Authorized Rev Req'!D51","v":"GHG End User"},{"$f":"'Authorized Rev Req'!C51","v":-5290.5867191999996},{"$f":"0","v":0},{"$f":"G50","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A52","v":"Green House Gas Balancing Account (GHGBA) - LUAF"},null,{"$f":"'Authorized Rev Req'!B52","v":"D.20-02-045, AL 3024-G, AL 3046-G"},-11.252214599999999,{"$f":"'Authorized Rev Req'!D52","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C52","v":-11.252214599999999},{"$f":"0","v":0},{"$f":"G51","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A53","v":"FERC Settlement Proceeds MA"},null,{"$f":"'Authorized Rev Req'!B53","v":"D.20-02-045, AL 3024-G, AL 3046-G"},1.0229286000000002,{"$f":"'Authorized Rev Req'!D53","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C53","v":1.0229286000000002},{"$f":"0","v":0},{"$f":"G52","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A54","v":"New Environmental Regulation Balancing Account (NERBA) - EPCT"},null,{"$f":"'Authorized Rev Req'!B54","v":"D.20-02-045, AL 3024-G, AL 3046-G"},413.26315440000002,{"$f":"'Authorized Rev Req'!D54","v":"ECPT"},{"$f":"'Authorized Rev Req'!C54","v":413.26315440000002},{"$f":"0","v":0},{"$f":"G53","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A55","v":"New Environmental Regulation Balancing Account (NERBA) - EPAM"},null,{"$f":"'Authorized Rev Req'!B55","v":"D.20-02-045, AL 3024-G, AL 3046-G"},105.36164580000001,{"$f":"'Authorized Rev Req'!D55","v":"EPAM"},{"$f":"'Authorized Rev Req'!C55","v":105.36164580000001},{"$f":"0","v":0},{"$f":"G54","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A56","v":"TLS Adjustment"},null,{"$f":"'Authorized Rev Req'!B56","v":"D.20-02-045, AL 3024-G, AL 3046-G"},6681.9931823319448,{"$f":"'Authorized Rev Req'!D56","v":"Non-Residential"},{"$f":"'Authorized Rev Req'!C56","v":6681.9931823319448},{"$f":"0","v":0},{"$f":"G55","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A57","v":"CSI Thermal Program memoradum Account"},null,{"$f":"'Authorized Rev Req'!B57","v":"D.20-02-045, AL 3024-G, AL 3046-G"},{"$f":"F56","v":806.06773680000003},{"$f":"'Authorized Rev Req'!D57","v":"46% Res (LUAF, Other)"},{"$f":"'Authorized Rev Req'!C57","v":806.06773680000003},{"$f":"0","v":0},{"$f":"G56","v":0},{"$f":"H56","v":0},{"$f":"I56","v":0}]
[]
[]
[]
[]
[]
[{"$f":"'Authorized Rev Req'!A64","v":"California Alternate Rates for Energy (CARE) - Funding"},null,{"$f":"'Authorized Rev Req'!B64","v":"AL 3027-G-A, D.21-06-015"},25613.072,{"$f":"'Authorized Rev Req'!D64","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C64","v":25613.072},11537.458000000001,11652.832,11769.36,11887.054]
[{"$f":"'Authorized Rev Req'!A65","v":"California Alternate Rates for Energy (CARE) - Admin Expenses"},null,{"$f":"'Authorized Rev Req'!B65","v":"AL 3027-G-A, D.21-06-015"},{"$f":"F63","v":727.2829999999999},{"$f":"'Authorized Rev Req'!D65","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C65","v":727.2829999999999},761.46983,771.47047999999995,813.95269999999994,814.18138999999996]
[{"$f":"'Authorized Rev Req'!A66","v":"California Alternate Rates for Energy (CARE) - Amortization"},null,{"$f":"'Authorized Rev Req'!B66","v":"AL 3027-G-A"},1000,{"$f":"'Authorized Rev Req'!D66","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C66","v":1000},{"$f":"0","v":0},{"$f":"G64","v":0},{"$f":"H64","v":0},{"$f":"I64","v":0}]
[{"$f":"'Authorized Rev Req'!A67","v":"Energy Savings Assistance (ESA/LIEE/DAP)"},null,{"$f":"'Authorized Rev Req'!B67","v":"AL 3027-G-A, D.21-06-015"},8041.1949999999997,{"$f":"'Authorized Rev Req'!D67","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C67","v":8041.1949999999997},12315.641642931652,13505.588216717384,14340.988629792766,15138.709320357639]
[{"$f":"'Authorized Rev Req'!A68","v":"Energy Efficiency"},null,{"$f":"'Authorized Rev Req'!B68","v":"AL 3027-G-A, AL 3035-G"},15368.681745714286,{"$f":"'Authorized Rev Req'!D68","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C68","v":15368.681745714286},11521.574792218715,{"$f":"G66","v":11521.574792218715},{"$f":"H66","v":11521.574792218715},{"$f":"I66","v":11521.574792218715}]
[{"$f":"'Authorized Rev Req'!A69","v":"RD&D "},null,{"$f":"'Authorized Rev Req'!B69","v":"AL 3027-G-A"},{"$f":"F67","v":1929.78072},{"$f":"'Authorized Rev Req'!D69","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C69","v":1929.78072},{"$f":"0","v":0},{"$f":"G67","v":0},0,0]
[{"$f":"'Authorized Rev Req'!A70","v":"Bureau Of Equalization BOE"},null,{"$f":"'Authorized Rev Req'!B70","v":"AL 3027-G-A"},56.159990000000001,{"$f":"'Authorized Rev Req'!D70","v":"Public Purpose Programs"},{"$f":"'Authorized Rev Req'!C70","v":56.159990000000001},{"$f":"0","v":0},0,0,0]
[]
[]
[]
["Procurement",null,{"$f":"'Authorized Rev Req'!B79","v":"D.97-07-061"},{"$f":"F72","v":313349.629312},{"$f":"'Authorized Rev Req'!D79","v":"Core Procurement"},{"$f":"'Authorized Rev Req'!C79","v":313349.629312},{"$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":989349.18246160657},null,{"$f":"SUM(F11:F75)","v":989349.18246160657},{"$f":"SUM(G11:G75)","v":565916.26496515027},{"$f":"SUM(H11:H75)","v":567330.73748893605},{"$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":674184.61621408374},"Allocated Base Margin",null,null,152304.57454931061,211980.97045590263,309899.0712088705]
["Pipeline Safety Enhancement Plan (PSEP) -Local T","A.22-05-016","Application",-706.02137999999991,"Local Transmission",null,null,-706.02137999999991]
["CIS Balancing Account AL","AL 3039-G","Advice Letter",28209.216,"EPAM",null,16760.723999999998,11448.492]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","Application",40844,"Distribution",null,null,40844]
[null,null,null,0]
[null,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,1370,1370,1370,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]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"SUM(F99:J99)","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total Pending, Filed but not Approved",null,null,{"$f":"SUM(D85:D111)","v":180566.48913058668},null,{"$f":"SUM(F84:F112)","v":0},{"$f":"SUM(G84:G112)","v":31300.723999999998},235649.41820766212,245154.75907151555,342646.20406549273]