{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ComEd NTGR PY1-PY7"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ComEd NTGR PY1-PY7","index":0,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,7,0,9],[12,18,16,18],[9,16,11,16],[9,17,11,17],[0,12,0,15],[59,18,60,18],[19,16,19,17],[9,18,11,18],[20,16,20,17],[21,16,21,17],[22,16,22,17],[23,16,23,17],[24,16,24,17],[42,2,42,6],[43,18,58,18],[9,13,11,14],[19,18,20,18],[25,18,33,18]]}
[null,"ComEd NTGRs PY1-PY7",null,null,null,null,null,"PY5 Research",null,null,null,null,"EPY7 EM&V Recommendations"]
["Sector","Program","PY1","PY2","PY3","PY4","PY5 SAG Consensus","Free ridership ","Spillover","NTG","PY5 Report Status","PY6 SAG Consensus","Free Ridership","Participant Spillover","Nonparticipant Spillover","PY7 EM&V NTGR Recommended Value","PY7 FR Source","PY7 SO Source","PY7 Notes","Priority","Reason"]
["C&I","Business Standard",0.67,0.74,0.72,0.7,null,null,null,null,null,null,null,null,null,null,null,null,"No program-level PY5 estimates"]
["C&I","Business Standard - Lighting",null,null,0.74,0.7,0.74,0.26,0.05,0.79,"draft",0.7,{"$f":"H4","v":0.26},7.0000000000000007E-2,null,{"$f":"1-M4+N4+O4","v":0.81},"self-report participant survey","Participant and TA researched - TA used"]
["C&I","Business Standard - Non-Lighting",null,null,0.62,0.63,0.62,0.31,0.06,0.75,null,0.63,{"$f":"H5","v":0.31},0.08,null,{"$f":"1-M5+N5+O5","v":0.76999999999999991},"self-report participant survey ","Participant and TA researched - TA used"]
["C&I","Business Custom",0.72,0.76,0.56000000000000005,0.61,0.56000000000000005,{"$f":"1-J6","v":0.36},0,0.64,"draft",0.61,{"$f":"H6","v":0.36},{"$f":"I6","v":0},0,{"$f":"1-M6+N6+O6","v":0.64},"PY5 self-report participant survey","PY5 self-report participant survey","Participants spillover researched and small, but not negligble"]
["C&I","Data Centers ","NA","NA","NA",0.43,0.56000000000000005,{"$f":"1-J7","v":0.52},0,0.48,"draft",null,0.52,0,0,0.48,"PY5 self-report participant survey","PY5 self-report participant survey","Participants spillover researched and small, but not negligble","Discuss","ComEd comment"]
["C&I","Industrial Systems (FKA Compressed Air)","NA","NA","NA",0.67,0.67,0.33,0.01,0.68,null,0.67,{"$f":"H8","v":0.33},{"$f":"I8","v":0.01},0,{"$f":"1-M8+N8+O8","v":0.67999999999999994},"PY5 self-report participant survey","PY5 self-report participant survey"]
["C&I","Business Retrocommissioning",0.8,0.92,0.71,1.038,0.71,"No research","No research","No research","draft",1.04,0.1,0.13600000000000001,0,{"$f":"1-M9+N9+O9","v":1.036},"EPY4 research","EPY4 research","No new research in PY5. Spillover is a mixture of participant and nonparticipant (from trade allies)."]
["C&I","Business New Construction - Program","NA",0.59,0.65,0.56999999999999995,0.65,"No research","No research","No research","draft",0.52,{"$f":"1-0.54","v":0.45999999999999996},0.05,null,"0.54+0.05=0.59","PY4 participant surveys","EM&V Estimate","PY7 recommendation is the NTG for comprehensive projects; program expects to have mostly comprehensive projects in PY7","Discuss","ComEd comment"]
["C&I","Business New Construction - Comprehensive Projects","NA","NA","NA",0.54,"NA","No research","No research","No research",null,null,{"$f":"1-0.54","v":0.45999999999999996},null,null,"0.54+0.05=0.59",null,null,null,"Discuss","ComEd comment"]
["C&I ","Business New Construction - Systems Projects","NA","NA","NA",0.59,"NA","No research","No research","No research",null,null,{"$f":"1-0.59","v":0.41000000000000003},null,null,"0.59+0.05=0.64",null,null,null,"Discuss","ComEd comment"]
["C&I","BILD - Mid Stream Incentives","NA","NA",0.74,0.63,0.74,0.42,0.05,0.63,"draft",0.63,null,null,null,null,null,null,"EPY5 CFL NTG=0.66. 2-year average = 0.64 and recommended in PY5 final report."]
["C&I","BILD - CFLs",null,null,null,null,null,0.41,7.0000000000000007E-2,0.66,null,null,{"$f":"H14","v":0.41},{"$f":"I14","v":7.0000000000000007E-2},0,0.64,"Participant surveys","Participant surveys"]
["C&I","BILD - LEDs",null,null,null,null,null,0.38,0.08,0.7,null,null,{"$f":"H15","v":0.38},0.08,0,{"$f":"1-M15+N15+O15","v":0.7},"Participant surveys","Participant surveys"]
["C&I","BILD - Linear Flourescents",null,null,null,null,null,0.47,0.03,0.56000000000000005,null,null,0.47,0.03,0,{"$f":"1-M16+N16+O16","v":0.56000000000000005},"Participant surveys","Participant surveys"]
["C&I","BILD - other",null,null,null,null,null,0.4,7.0000000000000007E-2,0.67,null,null,0.4,7.0000000000000007E-2,0,{"$f":"1-M17+N17+O17","v":0.66999999999999993},"Participant surveys","Participant surveys"]
["C&I","Small Business ","NA","NA","NA",0.95,0.9,"No research","No research","No research","draft",0.95,0.05,0,0,{"$f":"1-M18+N18+O18","v":0.95},"EPY4 Participant and trade ally surveys","EPY4 Participant and trade ally surveys","PY4 SO rounded to 0 (negligible)"]
["Residential","Residential Lighting Program",0.68,0.57999999999999996,0.71,0.54,null,0.48,0.02,0.54,"draft",null,null,null,null,null,null,null,null,"Discuss","ICC Comment"]
["Residential","Residential Lighting Program -Standard CFL",null,null,null,0.55000000000000004,0.72,0.47,0.02,0.55000000000000004,null,0.54,null,0.01,3.0000000000000001E-3,0.6,"PY5 in-store intercept surveys",null,"Standard and specialty CFL recommendation = 3-year weighted average. Total spillover = 0.02","Discuss","ICC Comment"]
["Residential","Residential Lighting Program - Specialty CFL",null,null,null,0.44,0.8,0.53,0.02,0.48,null,0.8,null,0.01,3.0000000000000001E-3,0.55000000000000004,"PY5 in-store intercept surveys",null,null,"Discuss","ICC Comment"]
["Residential","Residential Lighting Program - CFL Fixtures",null,null,null,0.54,0.79,0.48,0.02,0.54,null,0.54,null,null,null,0.75,"New bulb type to the program. EM&V Estimate",null,null,"Discuss","ICC Comment"]
["Residential","Residential Lighting Program - LED Bulbs",null,null,null,0.54,"NA",0.53,0.02,0.48,null,null,null,null,null,0.75,"New bulb type to the program. EM&V Estimate",null,null,"Discuss","ICC Comment"]
["Residential","Residential Lighting Program - LED Fixtures",null,null,null,0.54,"NA",0.48,0.02,0.54,null,null,null,null,null,0.75,"New bulb type to the program. EM&V Estimate",null,null,"Discuss","ICC Comment"]
["Residential","Residential Lighting Program - Coupon",null,null,null,0.55000000000000004,"NA",0.47,0.02,0.55000000000000004,null,null,null,null,null,"As above",null,null,null,"Discuss","ICC Comment"]
["Residential","Fridge Freezer Recycling Rebate (Appliance Recycling)",0.73,0.75,0.68,"NA",null,null,null,null,"draft",null,null,null,null,null,null,null,"Based upon secondary research and field knowledge, the indication is SO is negligible. Deeming NTG at the retailer/non-retailer level gives the program the opportunity to improve final net savings by adjusting program operations.","Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Refrigerators",null,null,null,0.77,0.67,0.44,0,0.56000000000000005,null,0.73,null,null,null,null,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Freezers",null,null,null,0.77,0.75,0.48,0,0.52,null,0.82,null,null,null,null,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Room AC units",null,null,null,0.57999999999999996,0.7,0.5,0,0.5,null,0.72,null,null,null,null,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate -  Refrigerator - Retailers",null,null,null,null,null,{"$f":"1-J30","v":0.83},0,0.17,null,null,{"$f":"H30","v":0.83},0,0,{"$f":"1-M30+N30+O30","v":0.17000000000000004},"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate -  Refrigerator - Non-Retailers",null,null,null,null,null,{"$f":"1-J31","v":0.20999999999999996},0,0.79,null,null,{"$f":"H31","v":0.20999999999999996},0,0,0.79,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Freezer - Retailers",null,null,null,null,null,0.79,0,0.21,null,null,0.79,0,0,0.20999999999999996,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Freezer - Non-Retailers",null,null,null,null,null,0.41000000000000003,0,0.59,null,null,0.41000000000000003,0,0,0.59,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Fridge Freezer Recycling Rebate - Room AC - Non-Retailers",null,null,null,null,null,0.5,0,0.5,null,null,0.5,0,0,0.5,"PY5 participant and retailer surveys","None",null,"Discuss","ComEd comment"]
["Residential","Multi-Family All Electric",0.8,0.8,0.9,0.98,0.81,"No research","No research","No research","draft",null,null,null,null,null,"EPY4 participant survey","PY4 building manager survey","PY4 research; all CFL measures"]
["Residential","Multi-Family with Gas","NA","NA",null,0.94,0.93,"No research","No research","No research","draft",null,null,null,null,null,"EPY4 participant survey","PY4 building manager survey","PY4 research; all water efficiency measures"]
["Residential","Multi-Family - CFLs",null,null,null,0.98,0.81,"No research","No research","No research",null,0.98,{"$f":"1-P37","v":2.0000000000000018E-2},0,0,0.98,"EPY4 participant survey","None",null,"Discuss","Phil Mosenthal comment"]
["Residential","Multi-Family - Showerhead",null,null,null,0.92,0.93,"No research","No research","No research",null,0.92,{"$f":"1-P38","v":7.999999999999996E-2},0,0,0.92,"EPY4 participant survey","None"]
["Residential","Multi-Family - Bath Aerator",null,null,null,0.94,0.93,"No research","No research","No research",null,null,6.0000000000000053E-2,0,0,0.94,"EPY4 participant survey","None"]
["Residential ","Multi-Family - Kitchen Aerator",null,null,null,1,0.93,"No research","No research","No research",null,null,0,0,0,1,"EPY4 participant survey","None"]
["Residential ","Multi-Family - Other Measures, Direct Installed in Units",null,null,null,null,null,"No research","No research","No research",null,null,null,0,0,0.95,"EM&V Estimate","None","Not enough responses to calculate measure-level NTG. (Programmable thermostats, pipe wrap, which are direct install.)","Discuss"]
["Residential ","Multi-Family - Other Measures, Direct Installed in Common Areas",null,null,null,null,null,"No research","No research","No research",null,null,null,0,0,0.95,"EM&V Estimate","None","Not enough responses to calculate measure-level NTG. (Programmable thermostats, pipe wrap, which are direct install.)","Discuss"]
["Residential","Multi-Family Comprehensive projects","Not offered until PY6",null,null,null,null,"No research","No research","No research","draft",0.8,null,"In the NTG","In the NTG",0.95,"EM&V Estimate","EM&V Estimate","New program NTGR element in EPY6","Discuss","ComEd comment"]
["Residential","Single Family with Gas - Direct Install Measures","NA","NA",0.79,null,0.94,0.23,0.03,0.8,"draft",null,0.23,0.03,null,0.8,"EPY4 and EPY5 participants surveys",null,"For Weatherization free ridership, Navigant assigned a 75% weighting to TA FR survey results and 25% to participants. "]
["Residential","Single Family All Electric","NA",0.88,0.92,"NA",0.89,0.2,0.09,0.89,"draft"]
["Residential","Single Family with Gas - Lighting",null,null,null,0.79,0.89,0.24,0.04,0.8,null,0.79,null,null,null,"Use DI #"]
["Residential","Single Family with Gas _ Showerhead",null,null,null,0.75,0.94,7.0000000000000007E-2,0.02,0.95,null,0.75,null,null,null,"Use DI #"]
["Residential","Single Family with Gas_ Kitchen Aerator",null,null,null,"NA",0.94,0.01,7.0000000000000007E-2,1.06,null,null,null,null,null,"Use DI #"]
["Residential","Single Family with Gas _ Bath Aerator",null,null,null,"NA",0.94,0.01,0,0.99,null,null,null,null,null,"Use DI #"]
["Residential","Single Family with Gas _ Water Heater Temp Setback",null,null,null,"NA",0.94,0.12,0,0.88,null,null,null,null,null,"Use DI #"]
["Residential","Single Family with Gas _ Pipe Insulation",null,null,null,"NA",0.94,0.12,0,0.88,null,null,null,null,null,"Use DI #"]
["Residential","Single Family with Gas _ Programmable Thermostat",null,null,null,"NA","NA","NA","NA","NA",null,null,null,null,null,"Use DI #"]
["Residential ","Single Family with Gas _ Programmable Thermostat Education",null,null,null,"NA","NA","NA","NA","NA",null,null,null,null,null,"Use DI #"]
["Residential","Single Family with Gas - Weatherization Measures ",null,null,null,0.8,0.8,0.1,0.11,1.02,"draft",0.8,0.1,0.11,null,1.02,"EPY4 and EPY5 participants surveys, EPY5 Trade ally surveys"]
["Residential ","Single Family with Gas - Attic Insulation",null,null,null,"NA",0.8,0.21,0,0.79,null,null,null,null,null,"Use Weatherization #"]
["Residential ","Single Family with Gas - Wall Insulation",null,null,null,"NA",0.8,0.22,0,0.78,null,null,null,null,null,"Use Weatherization #"]
["Residential ","Single Family with Gas - Floor Insulation (other)",null,null,null,"NA",0.8,0.16,0,0.84,null,null,null,null,null,"Use Weatherization #"]
["Residential","Single Family with Gas - Duct Sealing ",null,null,null,"NA",0.8,"NA","NA","NA",null,null,null,null,null,"Use Weatherization #"]
["Residential","Single Family with Gas - Air Sealing",null,null,null,"NA",0.8,0.14000000000000001,0,0.86,null,null,null,null,null,"Use Weatherization #"]
["Residential","Complete System Replacement with Gas _ Participant","NA","NA","NA",0.59,"R","No research","No research","No research","Draft",null,0.41,null,null,0.99,null,null,"PY5 NTG = (0.41 (PY4 participant survey) + 0.25 (EPY5 trade allies))/2 + 0.12 (participating trade ally spillover) + 0.20 (non-participating trade ally spillover) ","Discuss","Phil Mosenthal comment"]
["Residential","Complete System Replacement with Gas _ Trade Ally","NA","NA","NA","NA","R",0.25,"0 + 0.12 + 0.20",0.99,null,0.59,0.25,0.12,0.2,{"$f":"1-AVERAGE(M61,M60)+N61+O61","v":0.99},"EPY4 participant survey; EPY5 participating trade ally survey","EPY5 participating trade ally survey; EPY5 Nonparticipant trade ally survey",null,"Discuss","Phil Mosenthal comment"]
["Residential","Residential New Construction","NA","NA","NA","NA","R","No research","No research","No research","draft",0.8,null,null,null,0.8,"Planning value","None","No evaluation research has been done; 0.8 is NTG planning value"]
["Residential","Elementary Energy Education","NA","NA","NA",0.76,0.76,"No research","No research","No research","final",0.76,"varies","varies",0,0.76,"PY4 participant surveys","PY4 participant surveys","PY4 total NTG was weighted based upon all measures (e.g., aerators, CFLs, etc.)"]