{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Table E-1","Table E-2","Table E-3","Table E-4","Table E-5_AB 841","Table G-1","Table G-2","Table G-3","Table G-4","Table G-5_AB 841"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":55,"defined_names":797,"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":"Table E-1","index":0,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table E-1"]
["SDG&E Electric EE Funds Monthly Collections for Energy Efficiency by Rate Schedule "]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Customer Class","January","February","March ","April","May","June ","July","August","September","October","November","December","TOTAL"]
["Residential",2920880.7919828068,2095190.0924959276,1414940.8648793544,1390510.8150336249,1265989.0867158365,null,null,null,null,null,null,null,9087511.6511075515]
["CARE",null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Sm Comm",903811.95413307473,723749.88181677833,556981.44382146536,298892.10800063895,305089.39438937954,null,null,null,null,null,null,null,2788524.7821613373]
["Other C&I",1885840.9975915789,1322217.4612219515,1312850.4955407088,1130137.8213577825,1468804.1229045356,null,null,null,null,null,null,null,7119850.8986165579]
["Agriculture",35969.249398675369,30426.888920385172,21930.025850020538,30948.432182825807,38568.147045736776,null,null,null,null,null,null,null,157842.74339764367]
["Lighting",3511.6323980275038,4523.5288682874034,5063.0640012849817,1247.7904279098902,3152.4684561746744,null,null,null,null,null,null,null,17498.484151684454]
[]
["Total",5750014.625504164,4176107.8533233302,3311765.8940928341,2851736.9670027816,3081603.2195116631,"","","","","","","",19171228.559434775]
[]
["All revenues collected in rates to fund EE flow through the Electric Procurement Balancing Account which is transferred monthly to the Electric PGC Balancing Account."]

{"sheet":"Table E-2","index":1,"n_rows":236,"n_cols":29,"rows_kept":236,"cut":false,"hidden":false,"merged":[]}
["Table E-2"]
["SDG&E Electric EE Funds Monthly Payments for Energy Efficiency by Program Implementer "]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Program Implementer (PY 2017)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL",null,"Program Implementer (PY 2013-2015)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["SDG&E",-28690.14,-53983.07,-123226.58,-248613.44,-127751,0,0,0,0,0,0,0,-582264.23,null,"SDG&E",-3037.19,-3154.03,-3023.99,-2759.14,-2815.34,0,0,0,0,0,0,0,-14789.689999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["IOU Program Admin--Non-IOU Programs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Local-CALS - Middle Income Direct Install (MIDI)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-CALS – Residential HVAC-QI/QM",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Calculated Incentives-RCx",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Deemed Incentives-HVAC Commercial",-4.82,-6.12,null,null,null,null,null,null,null,null,null,null,-10.940000000000001,null,"SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM Direct Install",-4.34,-5.51,null,null,null,null,null,null,null,null,null,null,-9.85,null,"SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-IND-Customer Services-Audits CIEEP",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-AG-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-WE&T-Connections K-12",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",-4.34,-5.51,null,null,null,null,null,null,null,null,null,null,-9.85,null,"SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res Splash",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Zelda",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Sustainable Labs Program",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - Energy Advantage Program EAP",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - STREAMLINED AG EFFICIENCY (SAE) PRGM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - MID-MKT DYNAMIC EE PROGRAM ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["   Subtotal",-13.5,-17.14,0,0,0,0,0,0,0,0,0,0,-30.64,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Prg Implementation Costs--Non-IOU Prgs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Local-CALS - Middle Income Direct Install (MIDI)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-CALS – Residential HVAC-QI/QM",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Calculated Incentives-RCx",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Deemed Incentives-HVAC Commercial",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM Direct Install",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-IND-Customer Services-Audits CIEEP",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-AG-Customer Services-Pump Test Services",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res Splash",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P-Zelda",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Sustainable Labs Program",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - Energy Advantage Program EAP",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - STREAMLINED AG EFFICIENCY (SAE) PRGM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - MID-MKT DYNAMIC EE PROGRAM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-WE&T-Connections K-12",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Total",-3037.19,-3154.03,-3023.99,-2759.14,-2815.34,0,0,0,0,0,0,0,-14789.689999999999]
[]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Implementer (PY 2018-2019)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG&E",-60706.8,-298874.87,-293457.55,73352.179999999993,218337.94,0,0,0,0,0,0,0,-361349.10000000003]
["Total",-28703.64,-54000.21,-123226.58,-248613.44,-127751,0,0,0,0,0,0,0,-582294.87,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",3.22,-28.56,null,null,null,null,null,null,null,null,null,null,-25.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Program Implementer (PY 2016)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL",null,"SW-COM DIRECT INSTALL ",-112.95,-24.1,-24.1,-24.13,null,null,null,null,null,null,null,null,-185.28]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SDG&E",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-AG CUST SVC PUMPTEST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",-24.1,-24.1,-24.1,-24.13,-24.13,null,null,null,null,null,null,null,-120.56]
["IOU Program Admin--Non-IOU Programs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM CUST SVC PMPTST SERV ",7.03,null,null,null,null,null,null,null,null,null,null,null,7.03]
["SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS BLDG RETRO-COMMISSION",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-47.06,null,null,null,null,null,null,null,null,null,null,null,-47.06]
["SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"FACILITY ASSESSMENT SERVICES",-20.92,null,null,null,null,null,null,null,null,null,null,null,-20.92]
["SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"   Subtotal",-194.78000000000003,-76.759999999999991,-48.2,-48.26,-24.13,0,0,0,0,0,0,0,-392.13]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Prg Implementation Costs--Non-IOU Prgs"]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-CALS RES HVAC QI/QM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DIRECT INSTALL ",-24.1,null,null,23.62,null,null,null,null,null,null,null,null,-0.48000000000000043]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",null,-693.16,null,null,null,null,null,null,null,null,null,null,-693.16]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-RES COMPRE MOBILE HOME ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Prg Implementation Costs--Non-IOU Prgs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS BLDG RETRO-COMMISSION",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"FACILITY ASSESSMENT SERVICES",-3544.0699999999997,null,null,null,null,null,null,null,null,null,null,null,-3544.0699999999997]
["SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"   Subtotal",-3568.1699999999996,-693.16,0,23.62,0,0,0,0,0,0,0,0,-4237.71]
["SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Total",-64469.75,-299644.78999999998,-293505.75,73327.539999999994,218313.81,0,0,0,0,0,0,0,-365978.94000000006]
["SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Program Implementer (PY 2020)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null," "]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SDG&E",-10688.321000000113,-236982.83400000003,-318475.05000000005,-1464201.71,117675.83,0,0,0,0,0,0,0,-1912672.085]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"IOU Program Admin--Non-IOU Programs"]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-3961.8180000001198,-31832.49,-6292.55,3012.3,null,null,null,null,null,null,null,null,-39074.558000000121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-RES COMPRE MOBILE HOME ",-615.43799999999999,-211.83,-4218.1000000000004,1766.5899999999997,-430.22,null,null,null,null,null,null,null,-3708.9980000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",4849.32599999999,50538.17,null,null,null,null,null,null,null,null,null,null,55387.495999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",756.50399999999399,295.61,null,-31.08,null,null,null,null,null,null,null,null,1021.0339999999941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-744.93499999999995,-29.94,-5224.5,5224.5,null,null,null,null,null,null,null,null,-774.875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",11890.197,-44.91,-8869.5,null,null,null,null,null,null,null,null,null,2975.7870000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",2809.1970000000001,-44.91,-12271.5,-5224.5,null,null,null,null,null,null,null,null,-14731.713]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",140.292,null,null,null,null,null,null,null,null,null,null,null,140.292]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",160.33500000000001,null,null,null,null,null,null,null,null,null,null,null,160.33500000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",240.52500000000001,null,null,null,null,null,null,null,null,null,null,null,240.52500000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",-436.47,-16.62,-2126.25,2126.25,null,null,null,null,null,null,null,null,-453.09000000000015]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",15087.714999999864,18653.079999999998,-39002.400000000001,6874.0599999999995,-430.22,0,0,0,0,0,0,0,1182.234999999858]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-51645.4559999997,-47996.28,null,100.35,null,null,null,null,null,null,null,null,-99541.385999999693]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",1498.22999999996,10440.219999999999,-132.12,428.54,null,null,null,null,null,null,null,null,12234.869999999959]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",-460.74599999999998,-460.74599999999998,-921.49,null,-3096.45,null,null,null,null,null,null,null,-4939.4319999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-827.89200000000005,null,null,null,null,null,null,null,null,null,null,null,-827.89200000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-45000,null,null,null,null,null,null,null,null,null,null,null,-45000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",null,null,-432474.3,-77923.8,null,null,null,null,null,null,null,null,-510398.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",null,null,-466677.9,237080.7,null,null,null,null,null,null,null,null,-229597.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",null,null,-753642,-159156.9,null,null,null,null,null,null,null,null,-912798.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",3599.8299999999899,null,null,null,null,null,null,null,null,null,null,null,3599.8299999999899]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-92836.033999999752,-38016.805999999997,-1653847.81,528.89000000001397,-3096.45,0,0,0,0,0,0,0,-1787268.2099999997]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",-88436.64,-256346.56000000003,-2011325.26,-1456798.76,114149.16,0,0,0,0,0,0,0,-3698758.0599999996]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Implementer (PY 2021)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG&E",-566395.94899999991,-1473432.787,-1503335.4840000002,-698054.98099999991,-1560099.304,0,0,0,0,0,0,0,-5801318.5050000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-40365.053999999996,16761.825000000001,-13848.075000000001,-25753.544999999998,-7325.1630000000005,null,null,null,null,null,null,null,-70530.011999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",-74474.900999999998,-82634.444999999978,-129883.095,-106012.701,-112309.677,null,null,null,null,null,null,null,-505314.81900000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-4909.527,-18461.537999999997,-21571.002,-3437.28,-5749.317,null,null,null,null,null,null,null,-54128.663999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-13121.856,-12678.597,-19410.317999999901,-23726.394,-14557.932000000001,null,null,null,null,null,null,null,-83495.096999999907]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",-8960.7780000000002,-8717.0220000000008,-12664.323,-15088.175999999999,-9737.4419999999991,null,null,null,null,null,null,null,-55167.740999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",-14379.57,-14052.447,-27988.821,-32318.001,-26356.563000000002,null,null,null,null,null,null,null,-115095.402]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW National C&S Advoc (Utility)",-2257.056,-2715.93,-2947.2930000000001,-3192.3989999999999,-2524.6710000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWC&S Adv Stat Apli Stnrd (Util",-2321.0729999999999,-2809.7009999999996,-3028.4369999999999,-3300.498,-2584.6200000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWC&S Adv State Bldg Code (Util",-3179.1509999999998,-3933.3779999999997,-4141.9530000000004,-4601.3310000000001,-3465.4409999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW Upstream HVAC Prog (Utility)",-8162.91,-10364.67,-11053.323,-16594.532999999999,-16134.326999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW UPSTREAM HVAC PROGRAM",null,null,-6298.65,-19780.424999999999,-14497.722]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-172131.87600000002,-139605.90299999996,-252835.28999999995,-253805.28299999997,-215242.87499999997,0,0,0,0,0,0,0,-1033621.2269999998]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-1337.85,null,-492916.5,-706.08600000001002,-706.08600000000229,null,null,null,null,null,null,null,-495666.522]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",null,null,-460.74599999999998,null,-460.74599999999998,null,null,null,null,null,null,null,-921.49199999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",null,-3928.5,-4008.8249999999998,null,-8873.7569999999996,null,null,null,null,null,null,null,-16811.081999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-106808.13,-207000,-252316.26,-167770.95300000001,-338770.95,null,null,null,null,null,null,null,-1072666.2930000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",-2541.915,null,-5083.83,-1412.172,-1412.1719999999991,null,null,null,null,null,null,null,-10450.088999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",-2408.13,null,-84479.444999999992,-956.20500000000902,-4910.1099999999997,null,null,null,null,null,null,null,-92753.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOCACY NATNL C&S ADVOC",null,null,-112142.088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOC STATE APPLI STNDRD",null,null,-124372.764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOCACY STATE BLDG CODE",null,null,-176683.698]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW UPSTREAM HVAC PROGRAM",null,null,null,-687706.2,-353509.20000000007]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-113096.02500000001,-210928.5,-1252464.156,-858551.61599999992,-708643.02100000007,0,0,0,0,0,0,0,-3143683.318]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",-851623.84999999986,-1823967.19,-3008634.93,-1810411.88,-2483985.2000000002,0,0,0,0,0,0,0,-9978623.0500000007]

{"sheet":"Table E-3","index":2,"n_rows":95,"n_cols":14,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Table E-3"]
["SDG&E Status of Electric EE Funds"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","TOTAL"]
[]
["2021 Electric Funds"]
["     Beginning Balance",0,4507800.7155041648,6414787.6788274944,6279260.6029203273,6942936.8999231094,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",5750014.625504164,4176107.8533233302,3311765.8940928341,2851736.9670027816,3081603.2195116631,0,0,0,0,0,0,0,19171228.559434772]
["     Interest Accrued",244.16,455.09,423.12,440.73,352,0,0,0,0,0,0,0,1915.1]
["     Period Adjustment1",-390834.22,-445608.79,-439081.16,-378089.52,-408565.69,0,0,0,0,0,0,0,-2062179.38]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",-851623.84999999986,-1823967.19,-3008634.93,-1810411.88,-2483985.2000000002,0,0,0,0,0,0,0,-9978623.0500000007]
["     Commitments",null,null,null,null,null,null,null,null,null,null,null,null,0]
["     Month Ending Balance",4507800.7155041648,6414787.6788274944,6279260.6029203273,6942936.8999231094,7132341.2294347724,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2020 Electric Funds"]
["     Beginning Balance",25276546.989999998,19475821.106999997,19229892.213225283,-5024299.4867747165,-6263859.8479500012,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",null,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",2733.5,2088.56,1595.39,-20.100000000000001,-48,0,0,0,0,0,0,0,6349.3499999999995]
["     Period Adjustment",null,0,0,0,0,0,0,0,0,0,0,0,0]
["     PEEEBA Transfer SEESPBA",null,null,-22500000,0,0,null,null,null,null,null,null,null,-22500000]
["     On Bill Financing Return","",0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",-88436.64,-256346.56000000003,-2011325.26,-1456798.76,114149.16,0,0,0,0,0,0,0,-3698758.0599999996]
["     Commitments",-5715022.7429999998,8329.1062252847478,255538.16999999993,217258.49882471468,146676.42000000086,0,0,0,0,0,0,0,-5087220.5479499996]
["     Month Ending Balance",19475821.106999997,19229892.213225283,-5024299.4867747165,-6263859.8479500012,-6003082.2679500002,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2018-2019 Electric Funds"]
["     Beginning Balance",52650428.170000002,41382656.213,41618168.506999999,41758922.281999998,42288063.096000001,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",5700.3,4370.1499999999996,3476.64,3469.53,2610,0,0,0,0,0,0,0,19626.62]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",-64469.75,-299644.78999999998,-293505.75,73327.539999999994,218313.81,0,0,0,0,0,0,0,-365978.94]
["     Commitments",-11209002.506999999,530786.93400000036,430782.88499999791,452343.74400000088,239701.68899999931,0,0,0,0,0,0,0,-9555387.2550000008]
["     Month Ending Balance",41382656.213,41618168.506999999,41758922.281999998,42288063.096000001,42748688.594999999,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2017 Electric Funds"]
["     Beginning Balance",8131156.5,4484918.6210000003,4530596.2650000006,4430636.631000001,4216888.2370000016,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",879.32,673.03,533,520.20000000000005,381,0,0,0,0,0,0,0,2986.55]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",-28703.64,-54000.21,-123226.58,-248613.44,-127751,0,0,0,0,0,0,0,-582294.87]
["     Commitments",-3618413.5590000004,99004.824000000488,22733.945999999996,34344.845999999903,0,0,0,0,0,0,0,0,-3462329.943]
["     Month Ending Balance",4484918.6210000003,4530596.2650000006,4430636.631000001,4216888.2370000016,4089518.2370000016,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2016 Electric Funds"]
["     Beginning Balance",-16522249.609999999,-19975053.313333001,-19976430.313333001,-19977532.313333001,-19978634.083333001,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",-1789.91,-1377,-1102,-1101.77,-826,0,0,0,0,0,0,0,-6196.68]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Commitments",-3451013.793333,0,0,0,0,0,0,0,0,0,0,0,-3451013.793333]
["     Month Ending Balance",-19975053.313333001,-19976430.313333001,-19977532.313333001,-19978634.083333001,-19979460.083333001,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2013-2015 Electric Funds"]
["     Beginning Balance",519534.08000000002,-3722499.5972279757,-3709949.1062279758,-3565399.1532279751,-3318399.0222279755,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",56.12,42.91,34,33.94,25,0,0,0,0,0,0,0,191.97]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",-3037.19,-3154.03,-3023.99,-2759.14,-2815.34,0,0,0,0,0,0,0,-14789.689999999999]
["     Commitments2",-4239052.6072279755,15661.610999999568,147539.9430000009,249725.33099999977,20051.900999999605,0,0,0,0,0,0,0,-3806073.8212279757]
["     Month Ending Balance",-3722499.5972279757,-3709949.1062279758,-3565399.1532279751,-3318399.0222279755,-3301137.4612279758,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2010-2012 Electric Funds"]
["     Beginning Balance",2291101.4700000002,1356797.3900000001,1356988.34,1357141.11,1357293.8900000001,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",248.2,190.95,152.77000000000001,152.78,115,0,0,0,0,0,0,0,859.69999999999993]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     On Bill Financing Return",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Commitments",-934552.28000000014,0,0,0,0,0,0,0,0,0,0,0,-934552.28000000014]
["     Month Ending Balance",1356797.3900000001,1356988.34,1357141.11,1357293.8900000001,1357408.8900000001,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2006-2008 Electric Funds"]
["     Beginning Balance",0,0,0,0,0,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Period Adjustment",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Commitments",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Month Ending Balance",0,0,0,0,0,0,0,0,0,0,0,0,"Not Applicable"]
[]
[]
[]
[]
["Notes:"]
[" (1) The adjustment reflects the revenue required for the Willdan Contract and is reflected as a Willdan Revenue line item in EPEEBA. The net transfer from EPEEBA to PEEEBA is the difference between"]
["    the collections and Willdan Revenue line item reflected in the electric EPEEBA account. "]
["(2) Financing Pilots commitments, authorized in AL.3147-E/2625-G, noted herein for the first time in August 2018"]

{"sheet":"Table E-4","index":3,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Table E-4"]
["SDG&E Status of Electric Procurement Funds"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","TOTAL"]
[]
["Electric Procurement Funds"]
["     Beginning Balance",-824364.03000000026,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection",5750014.625504164,4176107.8533233302,3311765.8940928341,2851736.9670027816,3081603.2195116631,null,null,null,null,null,null,null,19171228.559434772]
["     Interest Accrued",-90,-68,-52,-52,-39,null,null,null,null,null,null,null,-301]
["     Period Adjustment1",-6406282.71,-5392484.96,-5313491.51,-4575408,-4944211.96,null,null,null,null,null,null,null,-26631879.140000001]
["     Payments (Willdan Contract)2",-404726.04,-404687.5,-404687.5,-404687.5,-404687.5,null,null,null,null,null,null,null,-2023476.04]
["     Commitments",0,0,0,null,0,0,0,0,0,0,0,0,0]
["     Month Ending Balance",-1885448.1544958362,-1621132.6066766698,-2406465.1159071657,-2128410.5329972184,-2267335.2404883369,"","","","","","","",-10308791.650565227]
[]
[]
["(1) Adjustment due to transfer the over collected EE Procurement balance to the Post-1997 electric PEEEBA account. Balance at the end of each month transferred to Post-1997 electric PEEEBA account Per Preliminary Statement 30675-E"]
["(2) This reflects the 6-year contract between SDG&E and Willdan Energy Solutions with payments beginning January 1,2018. The recovery of the costs of the contract was approved in D.16-12-041."]

{"sheet":"Table E-5_AB 841","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,13]]}
["Table E-5_AB841"]
["Status of School Energy Efficiency Stimulus Program Balancing Account"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","January","February","March ","April","May","June ","July","August","September","October","November","December","TOTAL"]
[]
["SEESP Balancing Account [1]"]
["     Beginning Balance",0,0,0,10579891.4,10580596.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,0]
["     Collections ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Transfers from EE Balancing Acct (PEEEBA)",0,0,22500000,0,0,0,0,0,0,0,0,0,22500000]
["     Disbursements to CEC",0,0,-11919711.6,0,0,0,0,0,0,0,0,0,-11919711.6]
["     Interest Accrued ",0,0,-397,705,529,0,0,0,0,0,0,0,837]
["     Month Ending Balance",0,0,10579891.4,10580596.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4,10581125.4]
[]
[]
["[1] The School Energy Efficiency Stimulus Program (SEESP) Balancing Account is authorized in Advice 3679-E/2949-G, Joint Tier 1 Advice Letter to Fund the School Energy Efficiency Stimulus Program in Compliance with Decision 21-01-004, effective February 1, 2021; as well as in SDG&E's Advice Letter 3680-E/2950-G Establishment of the School Energy Efficiency Stimulus Program Balancing Account in Compliance with Decision 21-01-004, effective January 14, 2021."]

{"sheet":"Table G-1","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Table G-1"]
["SDG&E Gas EE Funds Monthly Collections for Energy Efficiency by Rate Schedule "]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Rate Schedule","January","February","March ","April","May","June ","July","August","September","October","November","December","TOTAL"]
["Residential Non Care",37838.550000000003,47541.5,40895.4,33437.78,36590.35,null,null,null,null,null,null,null,196303.58000000002]
["Residential Care",7485.23,9882.2099999999991,8752.99,7039.96,6910.08,null,null,null,null,null,null,null,40070.47]
["Commercial Non Care",63337.59,85642.63,82720.350000000006,65362.97,54424.3,null,null,null,null,null,null,null,351487.84]
["Commercial Care",329.18,390.03,382.9,303.69,217.59,null,null,null,null,null,null,null,1623.39]
["NGV Non Care",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Industrial Non Care",10267.879999999999,20821.060000000001,20055.46,36620.06,40919.89,null,null,null,null,null,null,null,128684.34999999999]
["Less:  Uncoll  @ .1690%",-201.55,-277.63,-258.24,-241.27,-235.02,null,null,null,null,null,null,null,-1213.71]
[]
["Total",119056.87999999999,163999.79999999999,152548.85999999999,142523.19,138827.19000000003,0,0,0,0,0,0,0,716955.92]

{"sheet":"Table G-2","index":6,"n_rows":237,"n_cols":29,"rows_kept":237,"cut":false,"hidden":false,"merged":[]}
["Table G-2"]
["SDG&E Gas EE Funds Monthly Payments for Energy Efficiency by Program Implementer "]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Program Implementer (PY 2017)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL",null,"Program Implementer (PY 2013-2015)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["SDG&E",-3187.7755555555555,-5998.0955555555556,-13691.86,-27623.69,-14194.55,0,0,0,0,0,0,0,-64695.97111111111,null,"SDG&E",-337.46,-350.45,-335.99,-306.57,-312.82,0,0,0,0,0,0,0,-1643.29]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["IOU Program Admin--Non-IOU Programs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,null,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-CALS – Residential HVAC-QI/QM",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Calculated Incentives-RCx",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Deemed Incentives-HVAC Commercial",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM Direct Install",-0.48222222222222222,-0.61222222222222222,0,0,0,0,0,0,0,0,0,0,-1.0944444444444446,null,"SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-AG-Customer Services-Pump Test Services",null,-0.61222222222222222,0,0,0,0,0,0,0,0,0,0,-0.61222222222222222,null,"SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",-0.48222222222222222,0,0,0,0,0,0,0,0,0,0,0,-0.48222222222222222,null,"3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - STREAMLINED AG EFFICIENCY (SAE) PRGM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - MID-MKT DYNAMIC EE PROGRAM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["   Subtotal",-0.96444444444444444,-1.2244444444444444,0,0,0,0,0,0,0,0,0,0,-2.1888888888888891,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["Prg Implementation Costs--Non-IOU Prgs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-CALS – Residential HVAC-QI/QM",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM-Deemed Incentives-HVAC Commercial",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,null,0]
["SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,null,0]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - STREAMLINED AG EFFICIENCY (SAE) PRGM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - MID-MKT DYNAMIC EE PROGRAM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Total",-337.46,-350.45,-335.99,-306.57,-312.82,0,0,0,0,0,0,0,-1643.29]
[]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Implementer (PY 2018-2019)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG&E",-6745.5844444444447,-33207.821111111109,-32609.062222222223,8150.1711111111108,24259.741111111114,0,0,0,0,0,0,0,-40152.555555555562]
["Total",-3188.74,-5999.32,-13691.86,-27623.69,-14194.55,0,0,0,0,0,0,0,-64698.159999999996,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",0.35777777777777786,-3.1733333333333329,0,0,0,0,0,0,0,0,0,0,-2.8155555555555551]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Program Implementer (PY 2016)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL",null,"SW-COM DIRECT INSTALL ",-12.55,0,0,0,0,0,0,0,0,0,0,0,-12.55]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SDG&E",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-AG CUST SVC PUMPTEST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",-2.677777777777778,-2.677777777777778,-2.677777777777778,-2.6811111111111114,-2.6811111111111114,0,0,0,0,0,0,0,-13.395555555555557]
["IOU Program Admin--Non-IOU Programs",0,0,0,0,0,0,0,0,0,0,0,0,null,null,"3P-IDEA ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM CUST SVC PMPTST SERV ",0.7811111111111112,0,0,0,0,0,0,0,0,0,0,0,0.7811111111111112]
["SW-CALS – Residential HVAC-QI/QM",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS BLDG RETRO-COMMISSION",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-5.2288888888888891,0,0,0,0,0,0,0,0,0,0,0,-5.2288888888888891]
["SW-COM-Deemed Incentives-HVAC Commercial",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"FACILITY ASSESSMENT SERVICES",null,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"   Subtotal",-19.317777777777778,-5.8511111111111109,-2.677777777777778,-2.6811111111111114,-2.6811111111111114,0,0,0,0,0,0,0,-33.208888888888886]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Prg Implementation Costs--Non-IOU Prgs"]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-CALS RES HVAC QI/QM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DIRECT INSTALL ",-2.677777777777778,0,0,0,0,0,0,0,0,0,0,0,-2.677777777777778]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",0,-77.017777777777781,0,0,0,0,0,0,0,0,0,0,-77.017777777777781]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-RES COMPRE MOBILE HOME ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Prg Implementation Costs--Non-IOU Prgs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-CALS-Plug Load and Appliances-ARP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Local-CALS - Middle Income Direct Install (MIDI)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"HOPPS BLDG RETRO-COMMISSION",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-CALS – Residential HVAC-QI/QM",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Healthcare Energy Efficiency (HEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Customer Services-Audits Lodging Energy Efficiency (LEEP)",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"FACILITY ASSESSMENT SERVICES",null,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Calculated Incentives-RCx",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-COM-Deemed Incentives-HVAC Commercial",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"   Subtotal",-2.677777777777778,-77.017777777777781,0,0,0,0,0,0,0,0,0,0,-79.695555555555558]
["SW-COM Direct Install",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Com-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-IND-Customer Services-Audits CIEEP",0,0,0,0,0,0,0,0,0,0,0,0,0]
["SW-Ind-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Total",-6767.58,-33290.689999999995,-32611.74,8147.49,24257.06,0,0,0,0,0,0,0,-40265.460000000006]
["SW-AG-Customer Services-Pump Test Services",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-Res-Comprehensive Manufactured-Mobile Home",0,0,0,0,0,0,0,0,0,0,0,0,0]
["3P-IDEA",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["3P-Res Splash",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Program Implementer (PY 2020)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
["3P-Zelda",0,0,0,0,0,0,0,0,0,0,0,0,0,null," "]
["3P-Sustainable Labs Program",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SDG&E",-1187.4734444444566,-26331.321555555558,-35386.162222222221,-162689.04999999999,13075.082222222221,0,0,0,0,0,0,0,-212518.92499999999]
["3P - Energy Advantage Program EAP",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"IOU Program Admin--Non-IOU Programs"]
["SW-WE&T-Connections K-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["   Subtotal",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-440.2020000000133,-3536.9433333333336,-699.17222222222233,334.7,0,0,0,0,0,0,0,0,-4341.6175555555692]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"3P-RES COMPRE MOBILE HOME ",-68.382000000000005,-23.536666666666669,-468.67777777777781,196.28777777777776,-47.802222222222227,0,0,0,0,0,0,0,-412.11088888888895]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",538.81399999999894,5615.3522222222218,0,0,0,0,0,0,0,0,0,0,6154.1662222222203]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",84.055999999999344,32.845555555555556,0,-3.4533333333333331,0,0,0,0,0,0,0,0,113.44822222222156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-82.770555555555546,-3.3266666666666667,-580.5,580.5,0,0,0,0,0,0,0,0,-86.097222222222172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",1321.133,-4.9899999999999993,-985.5,0,0,0,0,0,0,0,0,0,330.64300000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",312.13300000000004,-4.9899999999999993,-1363.5,-580.5,0,0,0,0,0,0,0,0,-1636.857]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",15.588000000000001,0,0,0,0,0,0,0,0,0,0,0,15.588000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",17.815000000000001,0,0,0,0,0,0,0,0,0,0,0,17.815000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",26.725000000000001,0,0,0,0,0,0,0,0,0,0,0,26.725000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",1724.9094444444295,2074.4111111111106,-4097.3500000000004,527.53444444444449,-47.802222222222227,0,0,0,0,0,0,0,181.70277777776198]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-5738.3839999999673,-5332.9199999999992,0,11.15,0,0,0,0,0,0,0,0,-11060.153999999968]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",166.46999999999557,1160.0244444444443,-14.680000000000001,47.615555555555559,0,0,0,0,0,0,0,0,1359.4299999999953]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",-51.194000000000003,-51.194000000000003,-102.38777777777777,0,-344.04999999999995,0,0,0,0,0,0,0,-548.82577777777772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-91.988000000000014,0,0,0,0,0,0,0,0,0,0,0,-91.988000000000014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-5000,0,0,0,0,0,0,0,0,0,0,0,-5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",0,0,-48052.7,-8658.2000000000007,0,0,0,0,0,0,0,0,-56710.899999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",0,0,-51853.100000000006,26342.300000000003,0,0,0,0,0,0,0,0,-25510.800000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",0,0,-83738,-17684.099999999999,0,0,0,0,0,0,0,0,-101422.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-10715.095999999972,-4224.0895555555553,-183760.86777777778,58.76555555556115,-344.04999999999995,0,0,0,0,0,0,0,-198985.33777777775]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",-10177.66,-28481.000000000004,-223244.38,-162102.74999999997,12683.23,0,0,0,0,0,0,0,-411322.55999999994]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Implementer (PY 2021)","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG&E",-62932.770999999986,-163528.56299999999,-167222.93599999999,-77561.479000000007,-173344.20155555557,0,0,0,0,0,0,0,-644589.95055555552]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOU Program Admin--Non-IOU Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-4485.0060000000003,1862.4250000000002,-1538.6750000000002,-2861.5049999999997,-813.90700000000015,0,0,0,0,0,0,0,-7836.6680000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",-8274.9889999999996,-9181.6049999999977,-14431.455000000002,-11779.189000000002,-12478.853000000001,0,0,0,0,0,0,0,-56146.091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",-545.50300000000004,-2051.2819999999997,-2396.7780000000002,-381.92000000000007,-638.81299999999999,0,0,0,0,0,0,0,-6014.2960000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-1457.9839999999999,-1408.7329999999999,-2156.7019999999889,-2636.2660000000001,-1617.548,0,0,0,0,0,0,0,-9277.2329999999893]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",-995.64200000000005,-968.55800000000022,-1407.1470000000002,-1676.4639999999999,-1081.9379999999999,0,0,0,0,0,0,0,-6129.7490000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",-1597.73,-1561.3830000000003,-3109.8690000000001,-3590.8890000000001,-2928.5070000000005,0,0,0,0,0,0,0,-12788.378000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW National C&S Advoc (Utility)",-250.78399999999999,-301.77000000000004,-327.47700000000003,-354.71100000000001,-280.51900000000006,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWC&S Adv Stat Apli Stnrd (Util",-257.89699999999999,-312.18899999999991,-336.49299999999999,-366.72199999999998,-287.18000000000006,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWC&S Adv State Bldg Code (Util",-353.23899999999998,-437.04200000000003,-460.2170000000001,-511.25900000000001,-385.04899999999998,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW Upstream HVAC Prog (Utility)",-906.99,-1151.6300000000001,-1228.1469999999999,-1843.837,-1792.7029999999997,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW UPSTREAM HVAC PROGRAM",null,null,-699.85,-2197.8249999999998,-1610.8580000000002,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-19125.764000000003,-15511.767,-28092.80999999999,-28200.587000000003,-23915.875000000004,0,0,0,0,0,0,0,-114846.803]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prg Implementation Costs--Non-IOU Prgs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCAL-CALS MIDI ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-CALS RES HVAC QI/QM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DEEM INC HVAC COMM ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM DIRECT INSTALL ",-148.65,0,-54768.5,-78.454000000001116,-78.454000000000264,0,0,0,0,0,0,0,-55074.057999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC AUDITS CIEEP ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-AG CUST SVC PUMPTEST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-RES COMPRE MOBILE HOME ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-IDEA ",0,0,-51.194000000000003,0,-51.194000000000003,0,0,0,0,0,0,0,-102.38800000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-IND CUST SVC PMPTST SERV",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW-COM CUST SVC PMPTST SERV ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3P-ENERGY ADV PROGRAM",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPS MULTI FAMILY ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREAMLINED AG EFFICIENCY (SAE) PRGM ",0,-436.5,-445.42499999999995,0,-985.97300000000007,0,0,0,0,0,0,0,-1867.8980000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MULTI FAMILY PROGRAM",-11867.570000000002,-23000,-28035.140000000003,-18641.217000000001,-37641.216666666667,0,0,0,0,0,0,0,-119185.14366666667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.SMALL CUSTOMER SERVICE(<20KW)",-282.435,0,-564.87,-156.90800000000002,-156.9079999999999,0,0,0,0,0,0,0,-1161.1210000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMM.LARGE CUSTOMER SERVICES(>20KW)",-267.57,0,-9386.6049999999996,-106.245000000001,-545.56777777777768,0,0,0,0,0,0,0,-10305.987777777778]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARD ADVOCACY-NAT.CODES DI",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CODES&STANDARDS ADVOCACY-ST.AP",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW CODES&STANDARD ADV-ST.BLDGCODES-DI",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY ASSESSMENT SERVICES",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOCACY NATNL C&S ADVOC",null,null,-12460.232,0,0,0,0,0,0,0,0,0,-12460.232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOC STATE APPLI STNDRD",null,null,-13819.196,0,0,0,0,0,0,0,0,0,-13819.196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW C&S ADVOCACY STATE BLDG CODE",null,null,-19631.522000000001,0,0,0,0,0,0,0,0,0,-19631.522000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW UPSTREAM HVAC PROGRAM",null,null,null,-76411.799999999988,-39278.800000000003,0,0,0,0,0,0,0,-115690.59999999999]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Subtotal",-12566.225,-23436.5,-139162.68400000001,-95394.623999999996,-78738.113444444447,0,0,0,0,0,0,0,-349298.14644444443]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",-94624.75999999998,-202476.83,-334478.43,-201156.69,-275998.19,0,0,0,0,0,0,0,-1108734.8999999999]

{"sheet":"Table G-3","index":7,"n_rows":109,"n_cols":14,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["Table G-3"]
["SDG&E Status of Gas PGC Funds"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","TOTAL"]
[]
["2021 Gas PGC Funds"]
["     Beginning Balance",0,-16663.469999999972,-55143.489999999962,-237082.8,-559484.28,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",119056.87999999999,163999.79999999999,152548.85999999999,142523.19,138827.19000000003,null,null,null,null,null,null,null,716955.92]
["     Collection(BOE Reimbursement)",130769.52,0,0,171864.11,0,null,null,null,null,null,null,null,302633.63]
["     Interest Accrued",-1,-2.99,-9.74,-26.55,-31.4,null,null,null,null,null,null,null,-71.680000000000007]
["     Period Adjustment",0,null,null,null,null,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",-94624.75999999998,-202476.83,-334478.43,-201156.69,-275998.19,null,null,null,null,null,null,null,-1108734.8999999999]
["     Payments(BOE)",-171864.11,0,0,-435605.54,0,null,null,null,null,null,null,null,-607469.64999999991]
["     Commitments",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Ending Balance",-16663.469999999972,-55143.489999999962,-237082.8,-559484.28,-696686.67999999993,"","","","","","","","Not Applicable"]
[]
[]
["2020 Gas PGC Funds"]
["     Beginning Balance",-1561960.99,-2207311.1770000001,-2234998.9307527463,-4929964.3507527467,-5068220.9575500013,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",-170,-132.21,-114.17,-293.69,-224.02,null,null,null,null,null,null,null,-934.09]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     PGEEBA Transfer SEESPBA",0,0,-2500000,0,0,null,null,null,null,null,null,null,-2500000]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",-10177.66,-28481.000000000004,-223244.38,-162102.74999999997,12683.23,null,null,null,null,null,null,null,-411322.56]
["     Payments(BOE)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["     Commitments",-635002.527,925.45624725392554,28393.130000000005,24139.833202745998,16297.380000000121,0,0,0,0,0,0,0,-565246.72754999995]
["     Ending Balance",-2207311.1770000001,-2234998.9307527463,-4929964.3507527467,-5068220.9575500013,-5039464.3675500005,"","","","","","","","Not Applicable"]
[]
["2018-2019 Gas PGC Funds"]
["     Beginning Balance",11482621.359999999,10231653.057,10258293.693,10274308.618000001,10333477.654000001,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",1244,955,761.9,761.13,571.70000000000005,null,null,null,null,null,null,null,4293.7300000000005]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",-6767.58,-33290.689999999995,-32611.74,8147.49,24257.06,null,null,null,null,null,null,null,-40265.459999999992]
["     Payments(BOE)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Commitments",-1245444.723,58976.325999999885,47864.76500000013,50260.415999999968,26633.520999999717,0,0,0,0,0,0,0,-1061709.6950000003]
["     Ending Balance",10231653.057,10258293.693,10274308.618000001,10333477.654000001,10384939.935000001,"","","","","","","","Not Applicable"]
[]
["2017 Gas PGC Funds"]
["     Beginning Balance",2160287.5099999998,1755286.6789999993,1766809.5129999993,1753260.6329999992,1725778.5529999994,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",233.86,179.53,142.97999999999999,141.61000000000001,105.17,null,null,null,null,null,null,null,803.15]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",-3188.74,-5999.32,-13691.86,-27623.69,-14194.55,null,null,null,null,null,null,null,-64698.16]
["     Payments(BOE)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Commitments ",-402045.95100000006,17342.624000000011,0,0,0,0,0,0,0,0,0,0,-384703.32700000005]
["     Ending Balance",1755286.6789999993,1766809.5129999993,1753260.6329999992,1725778.5529999994,1711689.1729999993,"","","","","","","","Not Applicable"]
[]
["2016 Gas PGC Funds "]
["     Beginning Balance",-9573136.8699999992,-9957619.9370369986,-9958417.7870369982,-9959056.1170369983,-9959694.4870369975,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",-1037.0899999999999,-797.85,-638.33000000000004,-638.37,-478.81,null,null,null,null,null,null,null,-3590.45]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(BOE)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Commitments ",-383445.977037,0,0,0,0,0,0,0,0,0,0,0,-383445.977037]
["     Ending Balance",-9957619.9370369986,-9958417.7870369982,-9959056.1170369983,-9959694.4870369975,-9960173.297036998,"","","","","","","","Not Applicable"]
[]
["2013-2015 Gas PGC Funds"]
["     Beginning Balance",7590966.0099999998,7120445.0447524469,7122467.3837524466,7139030.8207524456,7166977.629752445,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",822.34,632.61,506.1,506.12,379.6,null,null,null,null,null,null,null,2846.77]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",-337.46,-350.45,-335.99,-306.57,-312.82,null,null,null,null,null,null,null,-1643.29]
["     Payments(BOE)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Commitments1",-471005.84524755285,1740.1790000000037,16393.327000000048,27747.258999999962,2227.9890000000014,0,0,0,0,0,0,0,-422897.09124755283]
["     Ending Balance",7120445.0447524469,7122467.3837524466,7139030.8207524456,7166977.629752445,7169272.3987524444,0,0,0,0,0,0,0,"Not Applicable"]
[]
["2010-2012 Gas PGC Funds"]
["     Beginning Balance",574394.41,340818.56999999995,340866.56999999995,340904.86999999994,340943.16999999993,null,null,null,null,null,null,null,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Interest Accrued",62.23,48,38.299999999999997,38.299999999999997,28.73,null,null,null,null,null,null,null,215.55999999999997]
["     Period Adjustment",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     On Bill Financing Return",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(Customers)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Payments(BOE)",0,0,0,0,0,null,null,null,null,null,null,null,0]
["     Commitments ",-233638.07000000004,0,0,0,0,0,0,0,0,0,0,0,-233638.07000000004]
["     Ending Balance",340818.56999999995,340866.56999999995,340904.86999999994,340943.16999999993,340971.89999999991,"","","","","","","","Not Applicable"]
[]
["2006 - 2008 and Bridge Gas PGC Funds"]
["     Beginning Balance",0,0,0,0,0,0,0,0,0,0,0,0,"Not Applicable"]
["     Collection(Rates)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Collection(BOE Reimbursement)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Interest Accrued",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments(Cust) & Transfers",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Payments(BOE)",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Commitments ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Ending Balance",0,0,0,0,0,0,0,0,0,0,0,0,"Not Applicable"]
[]
[]
[]
[]
["Notes:"]
["(1) Financing Pilots commitments, authorized in AL.3147-E/2625-G, noted herein for the first time in August 2018"]

{"sheet":"Table G-4","index":8,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table G-4"]
["SDG&E Gas PGC Funds Monthly Payments to and Receipts from State Board of Equalization (BOE) for Energy Efficiency"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","TOTAL"]
[" "]
["Payments to BOE",-171864.11,0,0,-435605.54,0,0,0,0,0,0,0,0,-607469.64999999991,"From PGEEBA, 'PPP Surcharge Remittance to BOE' line (reverse sign)"]
[" "]
["Payments received from BOE",130769.52,0,0,171864.11,0,0,0,0,0,0,0,0,302633.63,"From PGEEBA, 'PPP Surcharge Refund from BOE' line (reverse sign)"]
[]
["Net Receipts from BOE",-41094.589999999982,0,0,-263741.43,0,0,0,0,0,0,0,0,-304836.0199999999]

{"sheet":"Table G-5_AB 841","index":9,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,13]]}
["Table G-5_AB 841"]
["Status of School Energy Efficiency Stimulus Program Balancing Account"]
["Calendar Year 2021"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[" ","January","February","March ","April","May","June ","July","August","September","October","November","December","TOTAL"]
[]
["SEESP Balancing Account [1]"]
["     Beginning Balance",0,0,0,1175543.6000000001,1175621.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,0]
["     Collections ",0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Transfers from EE Balancing Acct (PEEEBA)",0,0,2500000,0,0,0,0,0,0,0,0,0,2500000]
["     Disbursements to CEC",0,0,-1324412.3999999999,0,0,0,0,0,0,0,0,0,-1324412.3999999999]
["     Interest Accrued ",0,0,-44,78,59,0,0,0,0,0,0,0,93]
["     Month Ending Balance",0,0,1175543.6000000001,1175621.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001,1175680.6000000001]
[]
[]
["[1] The School Energy Efficiency Stimulus Program (SEESP) Balancing Account is authorized in Advice 3679-E/2949-G, Joint Tier 1 Advice Letter to Fund the School Energy Efficiency Stimulus Program in Compliance with Decision 21-01-004, effective February 1, 2021; as well as in SDG&E's Advice Letter 3680-E/2950-G Establishment of the School Energy Efficiency Stimulus Program Balancing Account in Compliance with Decision 21-01-004, effective January 14, 2021."]