{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Reservation","Incentive Payment","Inspection Disclaimers","Test Form","Diagnostic Test Form","Lists"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":355,"comments":3,"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":"Reservation","index":0,"n_rows":61,"n_cols":35,"rows_kept":61,"cut":false,"hidden":false,"merged":[[22,33,22,37],[50,15,52,19],[51,13,51,14],[50,7,52,12],[47,1,49,6],[47,7,49,8],[47,9,49,10],[47,14,49,16],[47,22,49,23],[47,24,49,26],[38,1,40,6],[29,1,31,5],[29,22,31,23],[32,22,34,23],[35,22,37,23],[38,22,40,23],[41,22,43,23],[35,31,37,32],[32,24,34,26],[29,34,31,37],[26,34,28,37],[23,34,25,37],[21,1,21,37],[14,1,14,2],[18,1,18,37],[7,1,7,37],[8,1,8,4],[8,34,8,37],[8,31,8,33],[8,23,8,30],[8,20,8,22],[8,5,8,19],[12,1,12,37],[13,20,13,37],[13,1,13,19],[10,10,10,13],[9,32,11,34],[10,29,10,30],[10,35,10,36],[9,25,11,28],[16,3,16,14],[19,24,19,37],[14,16,14,19],[14,11,14,15],[14,3,14,10],[14,35,14,37],[14,22,14,29],[47,27,49,27],[47,28,47,29],[47,30,49,30],[48,11,48,13],[48,17,48,20],[48,28,48,29],[49,28,49,29],[15,36,15,37],[15,20,15,23],[15,24,15,31],[16,20,16,21],[14,20,14,21],[15,32,15,35],[14,30,14,34],[16,36,16,37],[16,34,16,35],[32,31,34,32],[23,24,25,26],[35,24,37,26],[38,24,40,26],[41,24,43,26],[23,22,25,23],[26,22,28,23],[15,1,15,4],[15,18,15,19],[15,14,15,17],[15,5,15,13],[30,14,30,15],[27,11,27,12],[19,1,19,4],[19,5,19,19],[35,1,37,6],[33,19,33,20],[32,17,34,18],[35,17,37,18],[36,19,36,20],[23,1,25,4],[22,1,22,21],[23,13,25,16],[30,16,30,17],[32,1,34,5],[19,20,19,23],[16,1,16,2],[16,18,16,19],[16,15,16,17],[16,22,16,33],[29,31,31,32],[56,3,59,35],[60,10,60,30],[60,33,60,36],[41,31,43,32],[22,27,22,32],[22,22,22,26],[23,27,25,30],[26,27,28,30],[29,27,31,30],[32,27,34,30],[35,27,37,30],[38,27,40,30],[23,31,25,32],[41,27,43,30],[50,1,52,6],[50,22,52,23],[50,24,52,26],[44,1,46,11],[44,12,46,13],[44,14,46,16],[45,17,45,20],[26,24,28,26],[29,24,31,26],[51,28,51,29],[29,18,31,19],[30,8,30,10],[30,11,30,12],[50,31,52,32],[50,33,52,33],[32,34,34,37],[24,17,24,18],[53,20,54,32],[53,3,54,19],[38,17,40,18],[39,19,39,20],[41,17,43,18],[42,19,42,20],[41,1,43,9],[26,1,28,5],[27,8,27,10],[27,16,27,17],[27,14,27,15],[26,6,28,7],[26,18,28,19],[26,31,28,32],[38,31,40,32],[5,1,5,13],[53,33,54,33],[41,33,43,33],[38,33,40,33],[35,33,37,33],[32,33,34,33],[29,33,31,33],[26,33,28,33],[23,33,25,33],[44,22,46,23],[44,24,46,26],[44,31,46,32],[45,28,45,29],[47,31,49,32],[44,27,46,27],[44,28,44,29],[44,30,46,30],[46,28,46,29],[50,27,52,27],[50,30,52,30],[50,28,50,29],[52,28,52,29],[53,1,54,1],[29,6,31,7],[53,34,54,37],[41,34,43,37],[38,34,40,37],[35,34,37,37],[44,33,46,33],[44,34,46,37],[47,33,49,33],[47,34,49,37],[50,34,52,37]]}
[null,"HOME EFFICIENCY INITIATIVE"]
[null,"Program Year 2024 Project Reservation Request"]
[]
[null,"Form Use: This form is to be used to submit project reservation requests prior to beginning work"]
[null,"Please complete all required information as specified below and email, with any required supporting documentation, to:"]
[null,"ResidentialEEApplications@ameren.com"]
[]
[null," SECTION 1: PROJECT INFORMATION"]
[null," Street Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,null," Zip Code:"]
[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,"Conditioned Floor Area (SF):",null,null,null,null,null,null,"Number of \nStories:"]
[null," Ameren Illinois Account Number  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Account",null,null,null,null,"Electric Account"]
[]
[null," Existing Primary Conditioning Equipment (If two or more units exist, please provide and separate model numbers, age, etc. with an *)"]
[null,"Heating Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooling Equipment"]
[null,"System\nType:",null,null,null,null,null,null,null,null,null," Heating Capacity\n Input (Btuh or KwH):",null,null,null,null,null,null,null,null,"System\nType:",null,null,null,null,null,null,null,null,null,"Cooling Capacity\n(Btuh):"]
[null,"Manufacturer:",null,null,null,null,null,null,null,null,null,null,null,null,"Year of\nManufacture:",null,null,null,null,null,"Manufacturer:",null,null,null,null,null,null,null,null,null,null,null,"Year of\nManufacture:"]
[null," Model:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rated\nAFUE:",null,null,null,null,"Model:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rated\nSEER:"]
[]
[null," SECTION 2: PROGRAM ALLY INFORMATION"]
[null,"Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Email:"]
[]
[null," SECTION 3: ENERGY EFFICIENCY MEASURE INFORMATION"]
[null,"MEASURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE RATE",null,null,null,null,"ESTIMATED QUANTITY",null,null,null,null,null,"SUB-TOTAL"]
[null," Air Sealing",null,null,null,null,null,null,null,null,null,null,null,"Initial Blower\nDoor Reading:",null,null,null,null,null,null,null,null,{"$f":"Lists!E3","v":0.7},null,"per CFM",null,null,null,null,null,null,"CFM",null,"$",{"$f":"IF(ISBLANK(AB24),\"\",AB24*W24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CFM"]
[]
[null," Attic Insulation",null,null,null,null,"Exisiting\nType:",null,null,null,null,null,null,null,null,null,null,null,"Current\nR-value:",null,null,null,{"$f":"Lists!E4","v":1.1000000000000001},null,"per SF",null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(AB27),\"\",AB27*W27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Depth:",null,null,"Condition:"]
[]
[null," Attic Insulation",null,null,null,null,"Exisiting\nType:",null,null,null,null,null,null,null,null,null,null,null,"Current\nR-value:",null,null,null,{"$f":"Lists!E4","v":1.1000000000000001},null,"per SF",null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(AB30),\"\",AB30*W30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Depth:",null,null,"Condition:"]
[]
[null," Wall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current\nR-Value:",null,null,null,null,{"$f":"Lists!E5","v":1.1000000000000001},null,"per SF",null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(AB33),\"\",AB33*W33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null," Kneewall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current\nR-Value:",null,null,null,null,{"$f":"Lists!E6","v":1.1000000000000001},null,"per SF",null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(AB36),\"\",AB36*W36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null," Rim Joist Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current\nR-Value:",null,null,null,null,{"$f":"Lists!E7","v":2},null,"per LF",null,null,null,null,null,null,"LF",null,"$",{"$f":"IF(ISBLANK(AB39),\"\",AB39*W39)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null," Crawlspace Wall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current\nR-Value:",null,null,null,null,{"$f":"Lists!E8","v":3},null,"per LF",null,null,null,null,null,null,"LF",null,"$",{"$f":"IF(ISBLANK(AB42),\"\",AB42*W42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null," Continuous Exhaust Ventilation Fan ",null,null,null,null,null,null,null,null,null,null,"Energy Star Certified",null,"New Model\nNumber:",null,null,null,null,null,null,null,{"$f":"Lists!E9","v":25},null,"each",null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(AC46),\"\",AC46*W45)","v":""}]
[]
[]
[null," Smart Thermostat",null,null,null,null,null,"Energy Star Certified",null,"Exisiting\nType:",null,null,null,null,"New Model\nNumber:",null,null,null,null,null,null,null,{"$f":"Lists!E10","v":100},null,"each",null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(AC49),\"\",AC49*W48)","v":""}]
[]
[]
[null,"Duct Sealing",null,null,null,null,null,"% Ductwork in Unconditioned Space:",null,null,null,null,null,null,null,"Distribution Efficiency Before:",null,null,null,null,null,null,{"$f":"Lists!E11","v":200},null,"each",null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(AC52),\"\",AC52*W51)","v":""}]
[]
[]
[null,null,null,"All identified precautionary health & safety concerns related to performed work will be resolved prior to final project paperwork submission. These include (but are not limited to) vapor barriers, ASHRAE ventilation, combustion safety, and attic ventilation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ameren Illinois Energy Efficiency Program\nIncentive Reservation Requested:  ",null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"IF(SUM(AI24:AL53)=0,\" \",SUM(AI24:AL53))","v":" "}]
[]
[]
[null,null,null,"I certify the information I have provided is true and correct and all work performed will meet the requirements and Terms and Conditions of the Program. I hereby request the reservation of incentive funds for the above listed work and understand the incentive cannot exceed 100% of project cost. I agree to allow Ameren Illinois Program staff to perform an on-site Quality Assurance inspection to confirm test results and verify conditions prior to the work being performed. All work will be completed no later than 30 days from receipt of reservation approval from the program."]
[]
[]
[]
[null,null,"Program Ally Signature:",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,"Date:"]

{"sheet":"Incentive Payment","index":1,"n_rows":70,"n_cols":34,"rows_kept":70,"cut":false,"hidden":false,"merged":[[20,33,20,37],[32,33,32,37],[28,24,28,29],[42,32,44,32],[42,33,44,37],[42,30,44,31],[45,1,46,17],[9,1,9,37],[42,24,42,29],[44,24,44,29],[42,1,44,5],[42,6,44,10],[42,12,44,16],[42,18,42,23],[44,18,44,23],[28,30,28,31],[25,1,27,3],[25,6,27,8],[25,11,27,13],[25,18,27,19],[26,4,26,5],[26,9,26,10],[26,14,26,17],[30,20,30,21],[41,30,41,31],[41,33,41,37],[21,18,23,19],[22,4,22,5],[22,9,22,10],[22,14,22,17],[24,33,24,37],[26,20,26,21],[28,1,28,17],[24,21,24,23],[32,1,32,17],[32,24,32,29],[32,30,32,31],[40,21,40,23],[40,24,40,29],[40,30,40,31],[40,33,40,37],[36,33,36,37],[70,1,70,37],[61,1,61,37],[62,1,62,37],[63,1,63,37],[64,1,64,37],[65,1,65,37],[66,1,66,37],[67,1,67,37],[68,1,68,37],[69,1,69,37],[58,1,58,37],[59,1,59,37],[60,1,60,37],[52,2,52,37],[54,2,54,37],[20,1,20,17],[20,24,20,29],[20,30,20,31],[16,24,16,29],[17,1,19,3],[17,6,19,8],[17,11,19,13],[17,18,19,19],[18,4,18,5],[18,9,18,10],[18,14,18,17],[28,33,28,37],[22,20,22,21],[24,1,24,17],[24,24,24,29],[24,30,24,31],[21,1,23,3],[21,6,23,8],[21,11,23,13],[7,1,7,37],[8,1,8,5],[16,33,16,37],[13,2,15,5],[13,10,15,13],[14,6,14,8],[14,14,14,16],[16,1,16,17],[10,1,10,37],[11,1,11,17],[11,18,11,23],[11,24,11,29],[11,32,11,37],[12,1,12,17],[12,24,12,29],[12,30,12,31],[12,33,12,37],[16,30,16,31],[8,6,8,11],[8,12,8,15],[8,16,8,25],[8,26,8,29],[8,30,8,37],[5,1,5,11],[56,1,56,8],[45,18,46,31],[48,1,48,37],[45,33,46,37],[45,32,46,32],[38,9,38,10],[38,14,38,17],[36,1,36,17],[36,24,36,29],[36,30,36,31],[37,1,39,3],[37,6,39,8],[37,11,39,13],[37,18,39,19],[38,4,38,5],[34,14,34,17],[29,1,31,3],[29,6,31,8],[29,11,31,13],[29,18,31,19],[30,4,30,5],[30,9,30,10],[30,14,30,17],[20,21,20,23],[16,21,16,23],[12,21,12,23],[36,18,36,20],[32,18,32,20],[28,18,28,20],[24,18,24,20],[20,18,20,20],[16,18,16,20],[12,18,12,20],[18,20,18,21],[36,21,36,23],[32,21,32,23],[28,21,28,23],[43,18,43,20],[43,21,43,23],[43,24,43,29],[33,1,35,3],[33,6,35,8],[33,11,35,13],[33,18,35,19],[34,4,34,5],[34,9,34,10],[40,1,40,12],[40,13,40,14],[40,15,40,17],[40,18,40,20],[41,1,41,12],[41,13,41,14],[41,15,41,17],[41,18,41,20],[41,21,41,23],[41,24,41,29],[55,33,55,37],[55,31,55,32],[55,1,55,5],[55,6,55,15],[55,16,55,20],[55,21,55,30],[56,31,56,32],[56,33,56,37],[56,9,56,30]]}
[null,"HOME EFFICIENCY INITIATIVE"]
[null,"Program Year 2024 Project Incentive Payment Request"]
[]
[null,"Form Use: This form is to be used to submit project incentive payment requests once reserved work has been completed"]
[null,"Please complete all required information as specified below and email, with any required supporting documentation, to:"]
[null,"ResidentialEEApplications@ameren.com"]
[]
[null," SECTION 1: PROJECT and PROGRAM ALLY INFORMATION"]
[null,"Project Reservation \nNumber: ",null,null,null,null,null,null,null,null,null,null,"Program Ally Company Name:",null,null,null,{"$f":"IF(ISBLANK(Reservation!F20),\"\",Reservation!F20)","v":""},null,null,null,null,null,null,null,null,null,"Program Ally\nContact Email:",null,null,null,{"$f":"IF(ISBLANK(Reservation!Y20),\"\",Reservation!Y20)","v":""}]
[]
[null," SECTION 2: ENERGY EFFICIENCY MEASURE INFORMATION"]
[null,"MEASURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCENTIVE RATE",null,null,null,null,null,"FINAL QUANTITY",null,null,null,null,null,null,null,"SUBTOTAL"]
[null," Air Sealing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E3","v":0.7},null,null,"per CFM",null,null,{"$f":"IF(ISBLANK(Reservation!R25),\"\",G15-O15)","v":""},null,null,null,null,null,"CFM",null,"$",{"$f":"IF(ISBLANK(Reservation!R25),\"\",IF(ISBLANK(O15),\"\",Y13*S13))","v":""}]
[null,null,"Initial Blower\nDoor Reading:",null,null,null,null,null,null,null,"Final Blower\nDoor Reading:"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reservation!R25),\"\",Reservation!R25)","v":""}]
[]
[null," Attic Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E4","v":1.1000000000000001},null,null,"per SF",null,null,null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(Y17),\"\",Y17*S17)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:",null,null,null,null,null,null,"Bag\nCount:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!U28),\"\",Reservation!U28)","v":""}]
[]
[null," Attic Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E4","v":1.1000000000000001},null,null,"per SF",null,null,null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(Y21),\"\",Y21*S21)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:",null,null,null,null,null,null,"Bag\nCount:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!U31),\"\",Reservation!U31)","v":""}]
[]
[null," Wall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E5","v":1.1000000000000001},null,null,"per SF",null,null,null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(Y25),\"\",Y25*S25)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:",null,null,null,null,null,null,"Bag\nCount:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!T34),\"\",Reservation!T34)","v":0}]
[]
[null," Kneewall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E6","v":1.1000000000000001},null,null,"per SF",null,null,null,null,null,null,null,null,"SF",null,"$",{"$f":"IF(ISBLANK(Y29),\"\",Y29*S29)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:",null,null,null,null,null,null,"Bag\nCount:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!T37),\"\",Reservation!T37)","v":0}]
[]
[null," Rim Joist Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E7","v":2},null,null,"per LF",null,null,null,null,null,null,null,null,"LF",null,"$",{"$f":"IF(ISBLANK(Y33),\"\",Y33*S33)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!T40),\"\",Reservation!T40)","v":0}]
[]
[null," Crawlspace Wall Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E8","v":3},null,null,"per LF",null,null,null,null,null,null,null,null,"LF",null,"$",{"$f":"IF(ISBLANK(Y37),\"\",Y37*S37)","v":""}]
[null,"Pre-Install\nR-value:",null,null,null,null,"Final\nR-value:",null,null,null,null,"Installed\nType:"]
[null,null,null,null,{"$f":"IF(ISBLANK(Reservation!T43),\"\",Reservation!T43)","v":0}]
[]
[null," Continuous Exhaust Ventilation Fan",null,null,null,null,null,null,null,null,null,null,null,"Model Number:",null,null,null,null,{"$f":"Lists!E9","v":25},null,null,"each",null,null,null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(Y41),\"\",Y41*S41)","v":""}]
[null," Smart Thermostat",null,null,null,null,null,null,null,null,null,null,null,"Model Number:",null,null,null,null,{"$f":"Lists!E10","v":100},null,null,"each",null,null,null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(Y42),\"\",Y42*S42)","v":""}]
[null,"Duct Sealing",null,null,null,null,"Distribution Efficiency Before:",null,null,null,null,null,"Distribution Efficiency After:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA",null,"$",{"$f":"IF(ISBLANK(Y44),\"\",Y44*S44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Lists!E11","v":200},null,null,"each"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ameren Illinois Energy Efficiency Program\nIncentive Payment Requested:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"IF(SUM(AH13,AH17,AH21,AH25,AH29,AH33,AH37,AH41,AH42,AH43)=0,\" \",SUM(AH13,AH17,AH21,AH25,AH29,AH33,AH37,AH41,AH42,AH43))","v":" "}]
[]
[]
[null," SECTION 3: SUPPORTING DOCUMENTATION"]
[null,null,"Customer invoice displaying applied \"Ameren Illinois Energy Efficiency Program Incentive\" reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Audit Disclaimer Form [if applicable]"]
[null,null,"Energy Audit Diagnostic Test Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting project photos, diagrams, or notes"]
[]
[null,null,"I certify the information I have provided is true and correct and all work performed meets the requirements and Terms and Conditions of the Program. I hereby request an incentive payment for the above listed work."]
[]
[null,null,"I, the homeowner, verify that I have been provided the Guide to Home Ventilation. My Program Ally and I have discussed, and I understand, ventilation strategies as they relate to my home. I have elected not to pursue ASHRAE 62.2-2016 as a part of my project's ventilation strategy at this time."]
[null,"Print Customer Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer  Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"Program Ally Signature:",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,"Date:"]
[]
[null,"     AMEREN ILLINOIS RESIDENTIAL ENERGY EFFICIENCY PROGRAM TERMS AND CONDITIONS"]
[null,"1. Definitions – In addition to terms defined elsewhere herein, when any one of the following terms is used in these Terms and Conditions, wherein the first letter is written with a capital letter, then that term shall have the following definition. Words importing persons include corporation, and words importing only the singular include the plural and vice versa when the context requires. a) “Ameren Illinois” shall mean Ameren Illinois Company d/b/a Ameren Illinois. b) “Program Ally” shall mean contractors/allies who have met the minimum qualifications established by Ameren Illinois and are allowed to offer program incentives. c) “Application” shall mean the Customer or Program Ally completed document used to apply for cash incentives or used for any other appropriate application-specific documentation. d) “Customer” shall mean an Eligible Customer who has submitted an Application for incentive money using their Ameren Illinois account number. The Customer abides by these Terms and Conditions upon acceptance of Customer’s Application by Ameren Illinois. e) “Eligible Customer” shall mean a residential customer of Ameren Illinois, with an active Ameren Illinois-delivered electric or gas account residing in an existing home or new construction. Individually metered residential multifamily units must have prior program approval to participate. Installations performed between January 1, 2022 to December 31, 2022 are eligible for incentives or until incentive funds are exhausted. Equipment and/or materials must be installed by a participating Program Ally at the Customer’s address listed on the Application. The Application must be filled out completely and accurately, signed and accompanied by dated copies of the invoices. See the project/measure eligibility for requirements specific to individual incentives. f) “Program” shall mean the energy efficiency plan or measure that is the subject of the Application. g) “Program Manager” shall mean the Ameren Illinois designee in charge of the Application. h) “Reservation of Funds”, when required, shall mean written notification to Program Ally of a pre-approved incentive amount, which Ameren Illinois issues after review Program Ally’s request for funds."]
[null,"2. General – Customer and Program Ally shall abide by these Terms and Conditions; abide by all Local, State and Federal guidelines, applicable laws, building codes, regulations and licensing requirements; and perform work in accordance with customary installation standards, and/or according to manufacturer specifications."]
[null,"3. Procedures & Reporting – Program Ally shall follow Program procedures of; a) verifying eligibility of Customer and work to be performed; b) reserving funds from Program in advance of the project commencing; and, c) submitting a reservation form and/or Application supplied by the Program for work performed with all required documentation. Program Ally agrees to provide all documentation associated with specified projects for quality assurance. Program Ally must provide necessary supporting documentation of services rendered including invoices and site assessment reports as requested."]
[null,"4. Independent Contractor – Listing in the Program Ally database does not constitute any endorsement of the Program Ally by Ameren Illinois. Program Ally is an independent contractor participating in the Program and not an employee of, or under contract to, Ameren Illinois or Program staff and authorized Ameren Representatives. Program Ally is not authorized to assume or create any obligation or liabilities, express or implied, on behalf of or in the name of Ameren Illinois or Program staff and authorized Ameren Representatives. Program Ally shall properly represent this to the Customers."]
[null,"5. Warranty of Work – Program Ally shall provide the Customer a written warranty covering both labor and materials for a minimum of one year from the date the service is performed. All materials installed shall carry the manufacturer’s warranty, which will be provided to the Customer. Offers of, and documentation referring to, any applicable extended warranty coverage shall be supplied to the Customer."]
[null,"6. Quality Assurance – Program Ally will maintain effective procedures for quality assurance as for resolution of Customer complaints or disputes and for response to Customer emergencies. Program Ally agrees to make its quality assurance procedures available to the Program for review and upon request. Only trained and skilled personnel of Program Ally shall supervise any project performed under the Program. All work is subject to quality assurance and verification inspections by Program before incentive payments are paid. Ameren Illinois is the sole authority in determining that the work is complete and eligible for payment. If the applicable Program Manager determines Program Ally’s work is not up to Program standards, upon request from the Program Representative, Program Ally shall make reasonable repairs or corrections to bring such work up to Program standards at no additional cost to the Customer. Program Manager shall have sole authority in determining the necessary remedies to correct faulty work."]
[null,"7. Pre and Post Installation Verification – Ameren Illinois is not obligated to make any incentive payment until it has performed a satisfactory post-installation verification. This provision may be waived at the sole discretion of Ameren Illinois. Inspections conducted are solely for the purpose of determining Program compliance and are not safety or building code inspections."]
[null,"8. Incentive Payments/Limits – For all Applications, Ameren Illinois is not obligated to award any incentive payment unless a reservation form and/or Application is submitted and granted. Customer and Program Ally are responsible for ensuring the Application is accurate and equipment meets eligibility requirements in order to receive the Pre-approval incentive payment. Incentive payments will be issued to Program Ally. The Program Ally shall inform Customer of Program financial incentives, and shall include a discount to the Customer in the amount of the incentive, labeled on Customer’s invoice as “Ameren Illinois Energy Efficiency Program Incentive.”"]
[null,"9. Indemnification – Customer agrees to protect, indemnify, defend and hold harmless Ameren Illinois, the Prime Implementer (Leidos, Inc.), and their\nrespective affiliates, subsidiaries, parent companies, officers, directors, agents, subcontractors, and employees (collectively the “Indemnities”), against\nall losses, damages, expenses, fees, costs and liability arising from any program, design, consulting, measures, product, system, equipment, or\nappliance. Customer agrees that such obligations under this section shall survive any expiration or termination of this Agreement and shall not be limited\nto any remunerations herein of required insurance coverage. To the maximum extent permitted by law, the Customer agrees to limit Indemnities’ liability\nto the Customer for any reason to the total amount of payments identified in this Agreement. This limitation shall apply regardless of the cause of action\nor legal theory pled or asserted. Customer hereby expressly waives the right to specifically enforce this Agreement."]
[null,"10. Changes In/Cancellation of the Program – a) Ameren Illinois may change the program requirements, incentives, or these Terms & Conditions at any time without notice, including suspending acceptance of Applications, denial of Applications already received, or terminating the Program. b) In the event of a program change, Applications that have been granted Pre-approval will be processed to completion under the Terms & Conditions in effect at the time of Pre-approval by Ameren Illinois. c) Cash incentives under the Ameren Illinois Program are offered on a first-come, first-served basis and are subject to project and Customer eligibility, and the availability of funds."]
[null,"11. Miscellaneous – Ameren Illinois reserves the right to make changes to; its Program, program incentives, rules, guidelines, and these Terms and Conditions upon written notice to the Program Ally. These Terms and Conditions shall be governed by Illinois law."]

{"sheet":"Inspection Disclaimers","index":2,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[2,1,2,23],[1,1,1,23],[7,21,7,23],[3,1,5,23],[6,1,6,23],[7,1,7,3],[7,4,7,12],[7,14,7,17],[8,1,8,3],[8,4,8,15],[8,16,8,20],[8,21,8,23],[9,1,9,23],[14,2,14,6],[14,7,14,8],[14,9,14,23],[15,2,15,6],[15,7,15,8],[15,9,15,23],[10,1,10,23],[11,1,11,14],[11,16,11,18],[11,20,11,23],[12,1,12,23],[13,2,13,6],[13,7,13,8],[13,9,13,23],[18,1,18,23],[21,15,21,23],[22,2,22,23],[23,2,23,23],[16,3,16,6],[16,7,16,8],[16,9,16,23],[17,1,17,14],[17,16,17,18],[17,20,17,23],[20,15,20,23],[19,15,19,23],[21,2,21,13],[20,2,20,13],[19,2,19,13],[24,2,24,5],[24,6,24,7],[24,8,24,14],[24,15,24,16],[24,17,24,23],[25,1,26,1],[25,2,26,5],[25,6,25,7],[25,8,25,14],[25,16,25,17],[27,2,27,23],[28,2,28,23],[29,2,29,23],[30,1,31,23],[33,1,33,23],[34,1,34,14],[34,16,34,18],[34,20,34,23],[25,18,25,21],[25,22,25,23],[26,6,26,7],[26,8,26,14],[26,16,26,17],[26,18,26,21],[26,22,26,23],[32,1,32,23],[44,1,44,14],[44,16,44,18],[44,20,44,23],[45,2,45,23],[46,1,46,2],[46,3,46,23],[35,2,35,23],[36,1,36,14],[36,16,36,18],[36,20,36,23],[38,1,42,23],[43,1,43,23],[37,20,37,23],[51,1,51,23],[52,1,52,14],[52,16,52,18],[52,20,52,23],[53,2,53,23],[54,1,58,23],[47,2,47,23],[48,1,48,2],[48,3,48,23],[49,2,49,23],[50,1,50,2],[50,3,50,23],[62,1,63,23],[64,2,64,23],[65,2,65,23],[66,2,66,23],[67,2,67,23],[71,1,71,23],[59,2,59,14],[59,16,59,23],[60,1,60,23],[61,1,61,14],[61,16,61,18],[61,20,61,23],[70,1,70,23],[80,1,80,5],[80,6,80,18],[80,19,80,20],[80,21,80,23],[82,1,82,23],[84,1,84,23],[72,1,72,14],[72,16,72,18],[72,20,72,23],[73,1,76,23],[78,2,78,23],[79,19,79,20],[79,21,79,23],[81,1,81,23],[77,1,77,23],[79,1,79,3],[79,13,79,18],[79,10,79,12],[79,4,79,9],[88,4,88,5],[88,6,88,8],[88,9,88,10],[88,11,88,13],[88,14,88,16],[88,17,88,19],[85,1,85,23],[86,1,86,5],[86,6,86,15],[86,16,86,17],[86,18,86,23],[87,1,87,23],[88,1,88,3],[88,20,88,23],[90,1,90,5],[90,6,90,19],[90,21,90,23],[91,1,91,23],[92,1,92,6],[92,7,92,15],[92,16,92,17],[92,18,92,23],[89,1,89,2],[89,3,89,11],[89,12,89,13],[89,14,89,16],[89,18,89,20],[89,21,89,23],[97,1,97,23],[96,1,96,5],[96,6,96,19],[96,21,96,23],[93,1,93,6],[93,7,93,23],[94,1,94,23],[95,1,95,2],[95,3,95,11],[95,12,95,13],[95,14,95,16],[95,18,95,20],[95,21,95,23]]}
[]
[null,"AMEREN ILLINOIS ENERGY EFFICIENCY PROGRAM"]
[null,"Energy Audit Inspection Disclaimers"]
[null,"Please complete the application, provide a copy to the customer, attach required documentation and send it to the following email address: ResidentialEEApplications@ameren.com. All projects will receive a reservation number via email. The reservation number is required \nprior to project start date. All program paperwork must be submitted within 30 days of the project completion or by December 31st, whichever comes first."]
[]
[]
[null,"    SECTION 1: PROJECT INFORMATION"]
[null,"Address:",null,null,{"$f":"IF(Reservation!F9=\"\",\"\",Reservation!F9)","v":""},null,null,null,null,null,null,null,null,"City:",{"$f":"IF(Reservation!X9=\"\",\"\",Reservation!X9)","v":""},null,null,null,"IL",null,"Zip Code:",{"$f":"IF(Reservation!AI9=\"\",\"\",Reservation!AI9)","v":""}]
[null,"Project Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment Date:"]
[]
[null,"     SECTION 2.1: INSPECTION INFORMATION (Check all applicable areas)"]
[null,"     ASBESTOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,"The following suspected Asbestos Containing Materials (ACMs) were identified in your home. It is important to understand that it is not possible to determine if a material has asbestos without professional testing and for this reason all possible ACMs must be treated as if it contains asbestos. This may disqualify your home from participation in the Ameren Illinois Energy Efficiency Program; however, proper precautions must be taken to ensure the suspect ACMs will not be disturbed. As a result, any measure that would result in work taking place in an area with suspect ACMs or that could disturb the asbestos is not allowed. For more information regarding asbestos, please visit www.epa.gov/asbestos and refer to “Suspect ACM White Paper”."]
[null,null,"Vermiculite",null,null,null,null,"Location:"]
[null,null,"Suspect Asbestos Siding",null,null,null,null,"Location:"]
[null,null,"Suspect Asbestos Duct Wrap and/or Flue Pipe",null,null,null,null,"Location:"]
[null,null,"Other:",null,null,null,null,"Location:"]
[null,"     COMBUSTION SAFETY INSPECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,"A combustion safety inspection was performed on your home to identify potential health and safety concerns. The testing was conducted in accordance with the Building Performance Institute ANSI/BPI-1200-S standard. The following combustion safety conditions were identified:"]
[null,null,"Ambient Combustible Fuel Gas is greater than 10% Lower Explosive Limit (LEL)",null,null,null,null,null,null,null,null,null,null,null,null,"Carbon Monoxide detector is missing or inoperable"]
[null,null,"Combustible Fuel Lines register a potential gas leak",null,null,null,null,null,null,null,null,null,null,null,null,"Ameren Illinois Gas Leak procedure was enacted     "]
[null,null,"Ambient Carbon Monoxide (CO) is between 36-69 PPM",null,null,null,null,null,null,null,null,null,null,null,null,"Ambient Carbon Monoxide (CO) is greater than 69 PPM     "]
[null,null,"Visual Inspection of the Combustion Appliance Zone (CAZ) has revealed the following:"]
[]
[null,null,"Appliance Spillage (Back drafting)",null,null,null,"Location 1:",null,null,null,null,null,null,null,null,"Location 2:"]
[null,null,"High Undiluted Carbon Monoxide (CO) at Appliance(s)",null,null,null,"Location 1:",null,null,null,null,null,null,null,null,"Limit:",null,null,"Measurement (PPM):"]
[null,null,null,null,null,null,"Location 2:",null,null,null,null,null,null,null,null,"Limit:",null,null,"Measurement (PPM):"]
[null,null,"Gas Oven has a Carbon Monoxide (CO) reading of greater than 225 parts per million (PPM); service required prior to building envelope work"]
[null,null,"Unvented gas heater that does not comply with ANSI Z21.11.2. This appliance needs to be removed prior to building envelope work."]
[null,"Notes:"]
[null,"These issues can cause potentially life threatening or hazardous situations. You are not eligible for Home Efficiency Program incentives for building envelope measures until these combustion safety issues are resolved by a qualified service technician. The service technician must leave a written certification that all combustion safety issues in your home are resolved. This must include (in writing) undiluted CO and draft test results indicating that the issue has been resolved per Building Performance Institute standards. This documentation must be emailed to the email address at the top of this form."]
[]
[]
[null,"     SECTION 2.2: INSPECTION INFORMATION (Check all applicable areas)"]
[null,"     ATTIC ELECTRICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,null,"Attic has exposed wiring junctions, open junction boxes, or fixtures that need to be properly sealed for building envelope work to proceed."]
[null,"     KNOB & TUBE WIRING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,"     Evidence of Knob & Tube wiring has been observed in the following locations:",null,null,null,null,null,null,null,null,null,null,null,null,"Attic",null,"Walls",null,"Basement"]
[null,"Indications of “knob and tube” wiring were discovered. This old style of wiring involves individual wires that are run through walls and ceilings in a house, with ceramic “knobs” and “tubes” to prevent contact with wood framing. The knob and tube wiring that has been noted may or may not appear to be active. Even if the observed wiring appears to be inactive, there may still be active knob and tube circuits hidden inside walls or other inaccessible areas of the house. Program guidelines require that you must have the home checked by a licensed electrician and certified as being free of any and all active knob and tube wiring, before insulation and/or air sealing work can be done. Your licensed electrician will need to certify in writing the absence of any knob and tube wiring by filling out and submitting a signed copy of this document to the Home Efficiency Program in order to verify the absence or inactivity of the knob and tube wiring in the areas of your home where we are proposing insulation to be installed. Due to the liability involved in signing such a form, we suggest you show or describe this form to your electrician before hiring him to inspect your home to be sure he / she is willing to sign it. (Any additions, deletions or other alterations will render this form invalid)."]
[]
[]
[]
[]
[null,"IMPORTANT: The completed certification form at the end of this document MUST be received by the Home Efficiency Program at the address listed below before a Contract is issued for energy-saving insulation and/or air sealing work."]
[null,"     MOISTURE RELATED ISSUES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,null,"There are exterior bulk moisture concerns related to the following items (examples: gutter, grading, roofing, siding)"]
[null,"Describe:"]
[null,null,"There is standing water observed in the following areas (examples: crawl space, basement)"]
[null,"Describe:"]
[null,null,"There are other moisture concerns in the following areas (examples: open sump pit, leaking plumbing, dryer venting)"]
[null,"Describe:"]
[null,"All water related issues; leaking roofs, standing water in the crawl space, water leaks in the basement, for example (there are additional issues that are to numerous to include in this document) must be corrected before any work can be started on the home.   "]
[null,"     MOLD-LIKE SUBSTANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,null,"A mold-like substance has been found in one or more areas of your home. Mold is an organic substance that has been shown to cause adverse health effects in some individuals."]
[null,"When a mold-like substance is found to be present in an area of your home and it exceeds an area greater than 10 square feet, your home is not eligible for financial incentives from the Ameren Illinois Energy Efficiency programs until one of the following conditions has been met: 1. An experienced professional contractor has remediated the mold and has attested to its remediation in writing. 2. An experienced professional contractor has determined that the substance is not mold and does not need to be remediated and has attested to this determination in writing.  Your experienced professional contractor must fill out and sign the statement below.  Due to the liability involved in signing such a statement, it is suggested you show or describe this form to your experienced professional contractor before hiring them to be sure that they are willing to sign it.  Any additions, deletions, or other alterations will render this form invalid.  For a mold-like substance less than 10 square feet, your home is not eligible for financial incentives.  For more information please visit http://www.epa.gov/mold "]
[]
[]
[]
[]
[null,null,"The mold-like substance is greater than 10 square feet (professional remediation required)",null,null,null,null,null,null,null,null,null,null,null,null,null,"The mold-like substance is 10 square feet or less"]
[null,"IMPORTANT: The completed certification form at the end of this document MUST be received by the Home Efficiency Program at the address listed below before a Contract is issued for energy-saving insulation and/or air sealing work."]
[null,"     STORAGE REMOVAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,"It has been determined your attic space would benefit from adding blown-in fiber insulation to your attic floor. The process of blowing in fibrous insulation in your attic will create dust which may accumulate on storage located in that area. Please take the necessary actions listed below before the insulation work commences:"]
[]
[null,null,"Storage Removal: You must remove your storage and relocate it to a new permanent location, so that the entire attic area can be insulated and air sealed. You will not be left with a storage area after insulation work has been completed."]
[null,null,"Knee Wall Storage: You must temporarily relocate your storage so that the Program Ally has total access to this area to complete the recommended insulation upgrades. Your storage can later be put back into this area after the Program Ally has completed the work."]
[null,null,"Condense Storage: You must condense your storage to an area in the attic that has been determined by you and your Program Ally. This will allow for the entire attic to be insulated and/or air sealed, except for the area that you want to leave for your condensed storage. If you plan on leaving your condensed storage in the attic during the installation of the blown cellulose insulation, you will need to cover this storage if you don’t want dust to accumulate on your storage items."]
[null,null,"Platform Build Up: If you are interested in having your entire attic insulated and you still want to leave your storage in the attic, you can build a raised platform in your attic that will be higher than the insulation that will be blown. This will allow you put your storage back on top of the platform without compressing the insulation that would result in compromising the R-value of the new blown-in insulation."]
[]
[]
[]
[null,"     SECTION 2.3: INSPECTION INFORMATION (Check all applicable areas)"]
[null,"     INTERIOR DENSE PACK \"DRILL AND BLOW\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable",null,null,null,"Not Applicable"]
[null,"It has been determined your home would benefit from having fiber insulation blown into your walls or “interior drill and blow.\" Interior drill and blow requires holes to be drilled from the inside of the living space and can be a very intrusive and dusty process. To ensure that this job goes smoothly, you (the homeowner) must ensure that all furniture and any clothing located in adjacent areas to the exterior walls (that are being treated) must be moved away from those walls and covered with plastic prior to commencement of the job for that day. Once the insulation is blown in, the contractor’s responsibility will be to plug the access holes and treat the surface with an initial application of spackle/filler. The homeowner is responsible for any additional work to the treated areas, including cleaning, dusting and painting to achieve the desired finished conditions unless other wise specified. Please sign below in recognition of having been fully informed of the work and possible inconvenience caused by the interior drill and blow process."]
[]
[]
[]
[null," "]
[null,null,"By checking the box and signing below you acknowledge the disclaimers, as described above, exist in your home, you have been informed of the situation, and you agree to hold Ameren Illinois, and its subcontractors  harmless. Ameren Illinois expressly disclaims any and all warranties or representations of any kind, whether oral, statutory, expressed or implied, including without limitation warranties of suitability or fitness. This notice does not constitute an endorsement or warranty regarding the presence or absence of other real or potential health and safety hazards that may exist at this address or on the premises."]
[null,"Print Customer Name:",null,null,null,null,null,null,null,null,"Customer Signature:",null,null,null,null,null,null,null,null,"Date:"]
[null,"Program Ally Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Special Note: Form must be submitted completely and accurately and must be approved prior to work beginning. If approval is not received prior to work beginning, the incentive will not be paid. The form should be emailed to: ResidentialEEApplications@ameren.com. The subject line and file name must read: Program Ally Name_Homeowner Last Name_Homeowner First Name_ Program Name (Ex: Insulators Inc_Jones_Mary). The reservation number will be emailed to you at the address listed above. The reservation number is not transferable and must be provided on all incentive forms. If the customer decides not to participate in the program, please email us immediately."]
[]
[null,"     SECTION 3: PROOF OF REMEDIATION"]
[null,"     KNOB AND TUBE REMEDIATION"]
[null,"     Electrician's Printed Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"License #:"]
[null,"I have performed an inspection of the home located at the below address and upon completion of my inspection, I have found that there is no active knob and tube wiring in the initialed area(s):"]
[null,null,null,null,"Attic:",null,null,null,null,"Walls:",null,null,null,null,"Basement:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,"IL","Zip Code:"]
[null,"     Signature of the Electrician:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,"     MOLD REMEDIATION"]
[null,"     Certified Remediation Company:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"License #:"]
[null,"     Inspecting Agent Printed Name:"]
[null,"I have performed an inspection of the home located at the below address and upon completion of my inspection, I have found that all mold has been remediated."]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,"IL","Zip Code:"]
[null,"     Signature of Inspecting Agent:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]

{"sheet":"Test Form","index":3,"n_rows":105,"n_cols":37,"rows_kept":105,"cut":false,"hidden":false,"merged":[[101,1,103,5],[101,6,101,20],[102,6,102,20],[103,6,103,20],[104,1,104,5],[104,6,104,20],[97,1,97,5],[97,6,97,20],[98,1,99,5],[98,6,98,20],[99,6,99,20],[100,1,100,5],[100,6,100,20],[93,1,93,5],[93,6,93,20],[94,1,96,5],[94,6,94,20],[95,6,95,20],[96,6,96,20],[90,1,90,19],[90,20,90,23],[90,24,90,27],[90,28,90,37],[91,1,91,20],[92,1,92,5],[92,6,92,20],[87,1,87,9],[87,10,87,17],[87,25,87,37],[88,1,88,9],[88,10,88,17],[88,25,89,37],[89,1,89,9],[85,1,85,9],[85,10,85,17],[85,25,85,26],[86,1,86,9],[86,10,86,17],[86,25,86,26],[83,1,83,9],[83,10,83,17],[83,25,83,26],[84,1,84,9],[84,10,84,17],[84,25,84,26],[81,1,81,9],[81,10,81,17],[81,25,81,26],[81,33,81,35],[81,36,81,37],[82,1,82,9],[82,10,82,17],[82,25,82,26],[82,33,82,35],[82,36,82,37],[79,1,79,9],[79,10,79,17],[79,25,79,26],[79,33,79,35],[79,36,79,37],[80,1,80,9],[80,10,80,17],[80,25,80,26],[80,33,80,35],[80,36,80,37],[77,25,77,26],[78,1,78,9],[78,10,78,17],[78,25,78,26],[78,33,78,35],[78,36,78,37],[75,1,75,9],[75,25,75,32],[75,33,75,37],[76,1,76,9],[76,10,76,17],[76,25,76,26],[76,33,77,35],[76,36,77,37],[77,1,77,9],[77,10,77,17],[72,1,72,37],[73,1,73,37],[74,1,74,9],[74,10,74,24],[74,25,74,32],[74,33,74,37],[66,1,66,37],[67,1,67,37],[68,1,68,37],[69,1,69,37],[70,1,70,37],[71,1,71,37],[62,1,62,22],[62,23,62,24],[62,26,62,29],[62,30,62,31],[62,32,62,35],[65,1,65,37],[58,1,58,22],[58,23,58,24],[58,26,58,36],[60,1,60,22],[60,23,60,24],[60,26,60,29],[60,30,60,31],[60,32,60,35],[64,1,64,37],[53,26,56,36],[54,1,54,22],[54,23,54,24],[56,1,56,22],[56,23,56,24],[57,26,57,36],[50,17,50,21],[50,22,50,24],[50,25,50,34],[50,35,50,36],[52,1,52,9],[52,10,52,11],[52,12,52,16],[52,17,52,18],[52,26,52,36],[47,27,47,34],[47,35,47,36],[48,2,48,9],[48,10,48,12],[48,13,48,15],[48,16,48,18],[48,19,48,21],[48,22,48,24],[48,27,48,34],[48,35,48,36],[47,2,47,9],[47,10,47,12],[47,13,47,15],[47,16,47,18],[47,19,47,21],[47,22,47,24],[45,26,45,36],[46,2,46,9],[46,10,46,12],[46,13,46,15],[46,16,46,18],[46,19,46,21],[46,22,46,24],[46,27,46,34],[46,35,46,36],[45,2,45,9],[45,10,45,12],[45,13,45,15],[45,16,45,18],[45,19,45,21],[45,22,45,24],[43,26,43,36],[44,2,44,9],[44,10,44,12],[44,13,44,15],[44,16,44,18],[44,19,44,21],[44,22,44,24],[44,26,44,36],[43,2,43,9],[43,10,43,12],[43,13,43,15],[43,16,43,18],[43,19,43,21],[43,22,43,24],[42,2,42,9],[42,10,42,12],[42,13,42,15],[42,16,42,18],[42,19,42,21],[42,22,42,24],[40,1,40,37],[41,1,41,9],[41,10,41,12],[41,13,41,15],[41,16,41,18],[41,19,41,21],[41,22,41,24],[41,26,41,34],[41,35,41,36],[31,35,31,36],[33,1,33,19],[33,20,33,37],[34,1,34,19],[34,20,34,37],[35,1,39,19],[35,20,35,37],[36,20,39,37],[27,35,27,36],[29,1,31,15],[29,20,29,25],[29,26,29,27],[29,28,29,34],[29,35,29,36],[31,17,31,18],[31,20,31,27],[31,28,31,31],[31,32,31,34],[25,1,25,6],[25,7,25,8],[25,9,25,16],[25,17,25,18],[25,20,25,37],[27,1,27,15],[27,17,27,18],[27,20,27,25],[27,26,27,27],[27,28,27,34],[21,35,21,36],[23,1,23,15],[23,17,23,18],[23,20,23,24],[23,25,23,26],[23,27,23,34],[23,35,23,36],[18,1,18,19],[18,20,18,37],[19,1,19,15],[19,17,19,18],[19,20,19,37],[21,1,21,6],[21,7,21,8],[21,9,21,16],[21,17,21,18],[21,20,21,34],[14,1,14,37],[15,1,15,27],[15,28,15,32],[15,33,15,36],[17,1,17,37],[12,1,12,37],[13,1,13,37],[9,1,9,37],[10,1,10,37],[11,1,11,10],[11,11,11,13],[11,14,11,15],[11,16,11,17],[11,18,11,23],[11,24,11,25],[11,26,11,34],[11,35,11,36],[6,1,6,37],[7,1,7,37],[8,1,8,7],[8,8,8,16],[8,17,8,21],[8,22,8,36],[0,1,0,37],[1,1,1,37],[2,1,2,37],[3,1,3,37],[4,1,4,37],[5,1,5,4],[5,5,5,11],[5,12,5,15],[5,17,5,36]]}
[null," AMEREN ILLINOIS ENERGY EFFICIENCY PROGRAM"]
[null," Residential Single-Family Project Test Form"]
[]
[null," SECTION 1: PROJECT INFORMATION"]
[]
[null,"Project Number",null,null,null,{"$f":"IF('Incentive Payment'!G9=\"\",\"\",'Incentive Payment'!G9)","v":""},null,null,null,null,null,null,"Street Address",null,null,null,null,{"$f":"IF(Reservation!F9=\"\",\"\",Reservation!F9)","v":""}]
[]
[]
[null,"BPI-Certified Tester Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Ally Name"]
[]
[]
[null,"Floor Area in Square Feet (including basements)",null,null,null,null,null,null,null,null,null,null,null,null,"Stories",null,{"$f":"IF(Reservation!AJ11=\"\",\"\",Reservation!AJ11)","v":""},null,"Number of Bedrooms ",null,null,null,null,null,null,null,"Combustion Safety Testing Required "]
[]
[]
[]
[null," SECTION 2: POST-WORK PROJECT TESTING",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,"Post-work Test Date "]
[]
[null," Combustion Safety Testing"]
[]
[null," Conditions for Entry (as per BPI-1200 7.3):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAZ Greatest Possible Depressurization (as per BPI-1200 7.9.1)"]
[]
[null," Ambient CFG (%LEL):",null,null,null,null,null,null,null,"House Ambient CO Level (PPM):",null,null,null,null,null,null,null,null,null,null,"Combustion Appliance Zone (CAZ) ambient CO (PPM):"]
[]
[null," Fuel Distribution System Inspection (as per BPI-1200 7.5):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline Pressure:",null,null,null,null,null,null,"Greatest Possible Depressurization:"]
[]
[null,"Suspect Gas Leak Found:",null,null,null,null,null,null,null,"Resolved per Program requirements",null,null,null,null,null,null,null,null,null,null,"Spillage and CO Testing (as per BPI-1200 7.9.2 through 7.9.4)"]
[]
[null," Visual Inspection of CAZ (as per BPI-1200 7.7):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Heater Spillage:",null,null,null,null,null,null,null,"Water Heater Air-Free CO:"]
[]
[null,"Visual Inspection of combustion appliances and venting systems (as per BPI-1200 7.8):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heating Spillage:",null,null,null,null,null,null,null,"Heating Air-Free CO:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ameren Illinois Gas Operations",null,null,null,null,null,null,null,"800-755-5000",null,null,null,"Oven CO:"]
[]
[null,"If any portion of the combustion appliance and fuel distribution system inspection did not",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If any appliance failed spillage or tested unacceptable for CO, or if ambient CO level in "]
[null,"meet BPI-1200 standards, describe actions taken:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAZ became elevated, state actions taken here; any additional appliances tested or "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"additonal Combution Appliance Zone data can be placed here also:"]
[]
[]
[]
[]
[null,"Ventilation Requirements (ASHRAE 62.2-2016)"]
[null,"Local demand-controlled ventilation",null,null,null,null,null,null,null,null,"Required",null,null,"Measured",null,null,"Shortfall",null,null,"Window Credit (Y/N)",null,null,"Deficit",null,null,null,"Final blower door measurement Q50:",null,null,null,null,null,null,null,null,{"$f":"IF('Incentive Payment'!O15=\"\",\"\",'Incentive Payment'!O15)","v":""}]
[null,null,"Bathroom #1 flow rate (CFM)",null,null,null,null,null,null,null,50,null,null,null,null,null,{"$f":"IF(N43=\"\",\"\",(IF(N43>K43,0,K43-N43)))","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(T43=\"\",Q43,(IF(T43=\"Y\",IF((Q43-20)>0, (Q43-20),0),Q43))),\"\")","v":""}]
[null,null,"Bathroom #2 flow rate (CFM)",null,null,null,null,null,null,null,50,null,null,null,null,null,{"$f":"IF(N44=\"\",\"\",(IF(N44>K44,0,K44-N44)))","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(T44=\"\",Q44,(IF(T44=\"Y\",IF((Q44-20)>0, (Q44-20),0),Q44))),\"\")","v":""},null,null,null,"Utilized Ventilation Strategy"]
[null,null,"Bathroom #3 flow rate (CFM)",null,null,null,null,null,null,null,50,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,"Bathroom #4 flow rate (CFM)",null,null,null,null,null,null,null,50,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"Select one rate below"]
[null,null,"Half-Bath #5 flow rate (CFM)",null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,"Not Applicable",null,null,0,null,null,null,null,"Continuous Ventilation Rate (CFM)"]
[null,null,"Kitchen # 1 flow rate (CFM)",null,null,null,null,null,null,null,100,null,null,0,null,null,{"$f":"IF(N48=\"\",\"\",(IF(N48>K48,0,K48-N48)))","v":100},null,null,null,null,null,{"$f":"IFERROR(IF(T48=\"\",Q48,(IF(T48=\"Y\",IF((Q48-20)>0, (Q48-20),0),Q48))),\"\")","v":100}]
[null,null,"Kitchen # 2 flow rate (CFM)",null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,"Intermittent Ventilation Rate (CFM)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Local Deficit:",null,null,null,null,{"$f":"IF(COUNT(W43:Y46)+COUNT(W48:Y49)=0,\"\",SUM(W43:Y49))","v":100},null,null,"Timer Set Point (min/hour)"]
[]
[null,"Weather and shielding factor (wsf):",null,null,null,null,null,null,null,null,null,null,"Story Factor (s):",null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q12,Lists!J5:K9,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,"Additional Ventilation Notes:"]
[]
[null,"Required whole-house ventilation rate   Qtot = (.03 x floor area) + (7.5 x (# of bedrooms +1)):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($L$12=\"\",\"\",IF($Y$12=\"\",\"\",(0.03*$L$12+(7.5*($Y$12+1)))))","v":""}]
[]
[null,"Alternative compliance supplement (total local deficit / 4):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W51=\"\",\"\",IF(W51>0,W51/4,\"\"))","v":25}]
[]
[null,"Adjusted Qtot for alternative compliance supplement:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X55=\"\",\"\",IF(X57=\"\",X55,X55+X57))","v":""},null,null,"Infiltration Testing Data"]
[]
[null,"Infiltration credit for blower door measurement   Qinf = Q50 x S x wsf x .052:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ42=\"\",\"\",IF(R53=\"\",\"\",IF(K53=\"\",\"\",0.052*AJ42*K53*R53)))","v":""},null,null,"Outside Temp:",null,null,null,null,null,"Test door facing:"]
[]
[null,"Required whole-house mechanical ventilation rate   Qfan = Adjusted Qtot - Qinf:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X59=\"\",\"\",IF(X61=\"\",\"\",X59-X61))","v":""},null,null,"Wind Speed:",null,null,null,null,null,"Wind direction:"]
[null,null,"Note:  if Qfan ≤ 15 CFM then no additional whole-building mechanical ventilation is required"]
[]
[]
[null," SECTION 3: REFERENCE CHARTS AND ACTION LEVEL DATA"]
[]
[null,"Spillage and carbon monoxide in combustion appliances BPI-1200 Annex D"]
[null,"For single DHW or warm vent appliance, spillage assessed at 2 minutes of main burner operation and CO air free at 5 minutes"]
[null,"For single cold vent appliance (except DHW), spillage and CO air free are both assessed at 5 minutes of main burner operation"]
[null,"For commonly vented appliances, smallest BTU first, spillage at 2 mins, CO air free at 5 mins, do not allow to cool, fire second appliance, re-assess first appliance for spillage at 2 mins, immediately assess second appliance for spillage, assess second appliance for CO air free at 5 mins"]
[null,"CO above threshold limit is unacceptable, advise homeowner the appliance should be serviced immediately by a qualified professional  "]
[null,"If CO level is unacceptable and spillage is not present, testing may continue at discretion of tester"]
[null,"If ambient CO is 70 PPM or greater",null,null,null,null,null,null,null,null,"Carbon monoxide threshold limits BPI-1200 7.9.5 Table 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Illinois Weather & Shielding Factors          ",null,null,null,null,null,null,null,"Story Factors (S)"]
[null," - Terminate the inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appliance","CO Threshold Limit",null,null,null,null,null,null,"(wsf) ASHRAE 62.2-2016 App B",null,null,null,null,null,null,null,"BPI-1200 Annex I.1.4"]
[null," - Notify occupants to evacuate",null,null,null,null,null,null,null,null,"Central Furnace (all categories)  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.44,null,"Mount Vernon",null,null,null,null,null,"Stories Above Grade",null,null,"Factor"]
[null," - Notify emergency services from outside",null,null,null,null,null,null,null,null,"Boiler  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.47,null,"Marion"]
[null,"If ambient CO is 36-69 PPM",null,null,null,null,null,null,null,null,"Floor Furnace  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.48,null,"Belleville Scott AFB",null,null,null,null,null,1,null,null,1]
[null," - Advise the homeowner of elevated level",null,null,null,null,null,null,null,null,"Gravity Furnace  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.51,null,"Quincy",null,null,null,null,null,1.5,null,null,1.18]
[null," - Open doors and windows",null,null,null,null,null,null,null,null,"Wall Furnace (BIV)  ",null,null,null,null,null,null,null,"200 ppm air free",null,null,null,null,null,null,0.51,null,"Sterling / Rock Falls",null,null,null,null,null,2,null,null,1.32]
[null," - Recommend CO sources be turned off",null,null,null,null,null,null,null,null,"Wall Furnace (Direct Vent)  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.55000000000000004,null,"Peoria",null,null,null,null,null,2.5,null,null,1.44]
[null," - Advise homeowner contact qual. pro",null,null,null,null,null,null,null,null,"Vented Room Heater  ",null,null,null,null,null,null,null,"200 ppm air free",null,null,null,null,null,null,0.56000000000000005,null,"Decatur",null,null,null,null,null,3,null,null,1.55]
[null,"If ambient CO is 9-35 PPM",null,null,null,null,null,null,null,null,"Unvented Room Heater  ",null,null,null,null,null,null,null,"200 ppm air free",null,null,null,null,null,null,0.56999999999999995,null,"Springfield "]
[null," - Advise the homeowner of elevated level",null,null,null,null,null,null,null,null,"Water Heater  ",null,null,null,null,null,null,null,"200 ppm air free",null,null,null,null,null,null,0.56999999999999995,null,"Urbana Champaign"]
[null," - Recommend open doors and windows",null,null,null,null,null,null,null,null,"Oven/Broiler  ",null,null,null,null,null,null,null,"225 ppm as measured",null,null,null,null,null,null,0.57999999999999996,null,"Moline / Quad Cities"]
[null," - Recommend CO sources be checked",null,null,null,null,null,null,null,null,"Clothes Dryer  ",null,null,null,null,null,null,null,"400 ppm air free",null,null,null,null,null,null,0.6,null,"Bloomington / Normal"]
[null," - Advise homeowner contact qual. pro",null,null,null,null,null,null,null,null,"Refrigerator  ",null,null,null,null,null,null,null,"25 ppm as measured",null,null,null,null,null,null,"Action if house ambient combustible fuel gas is > 10% LEL:"]
[null,"If ambient CO < 9 PPM",null,null,null,null,null,null,null,null,"Gas Log (gas fireplace) ",null,null,null,null,null,null,null,"25 ppm as measured in vent",null,null,null,null,null,null,"Terminate inspection, notify to evacuate, notify emergency services from outside"]
[null," - no action is required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Log (in wood burning fireplace) ","400 ppm air free in fire box"]
[null,"Minimum clearance of vent connectors from combustibles BPI-1200 Table E2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Vent - 6 in",null,null,null,"L Vent - 6 in",null,null,null,"Single wall metal pipe - 9 in"]
[null,"Process Checklist"]
[null,"Conditions for entry",null,null,null,null,"House ambient combustible fuel gas < 10% LEL"]
[null,"BPI-1200 7.3",null,null,null,null,"House ambient CO level (PPM)"]
[null,"Natural gas and LP gas piping system inspection and leak testing",null,null,null,null,"Gas leak testing completed"]
[null,null,null,null,null,null,"Follow Program process if gas leak detected"]
[null,null,null,null,null,null,"Gas lines or connectors unsafe or uncoated brass"]
[null,"BPI-1200 7.5",null,null,null,null,"Visibly worn flex gas line or pre-1973"]
[null,"Visual inspection of CAZ",null,null,null,null,"CAZ clear of flammable products"]
[null,null,null,null,null,null,"Vent connectors clearance from combustibles"]
[null,"BPI-1200 7.7",null,null,null,null,"Garage DHW FVIR or 18” off floor"]
[null,"Visual combustion appliance and venting system inspection                                  ",null,null,null,null,"Venting system 1/4\" rise per foot"]
[null,null,null,null,null,null,"Masonry chimney lined"]
[null,null,null,null,null,null,"Lower BTU appliance enters main flue after higher BTU appliance"]
[null,"BPI-1200 7.8",null,null,null,null,"Unvented heater ANSI Z21.11.2  label"]

{"sheet":"Diagnostic Test Form","index":4,"n_rows":141,"n_cols":19,"rows_kept":141,"cut":false,"hidden":true,"merged":[[135,1,135,18],[136,1,136,18],[137,1,137,18],[138,1,138,16],[138,17,138,18],[140,1,140,3],[131,1,131,18],[132,1,134,11],[132,12,132,18],[133,12,133,16],[133,17,133,18],[134,12,134,16],[134,17,134,18],[126,1,126,17],[127,1,127,17],[128,1,128,17],[129,1,130,7],[129,8,129,17],[130,8,130,17],[124,1,124,12],[124,13,124,15],[124,16,124,17],[125,1,125,9],[125,10,125,14],[125,16,125,17],[123,1,123,7],[123,8,123,9],[123,10,123,11],[123,12,123,13],[123,14,123,15],[123,16,123,17],[122,1,122,7],[122,8,122,9],[122,10,122,11],[122,12,122,13],[122,14,122,15],[122,16,122,17],[121,1,121,7],[121,8,121,9],[121,10,121,11],[121,12,121,13],[121,14,121,15],[121,16,121,17],[120,1,120,7],[120,8,120,9],[120,10,120,11],[120,12,120,13],[120,14,120,15],[120,16,120,17],[119,1,119,7],[119,8,119,9],[119,10,119,11],[119,12,119,13],[119,14,119,15],[119,16,119,17],[118,1,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[118,14,118,15],[118,16,118,17],[117,1,117,7],[117,8,117,9],[117,10,117,11],[117,12,117,13],[117,14,117,15],[117,16,117,17],[115,1,115,18],[116,1,116,7],[116,8,116,9],[116,10,116,11],[116,12,116,13],[116,14,116,15],[116,16,116,17],[110,1,110,17],[111,1,111,17],[112,1,112,17],[113,1,114,7],[113,8,113,17],[114,8,114,17],[108,1,108,12],[108,13,108,15],[108,16,108,17],[109,1,109,9],[109,10,109,14],[109,16,109,17],[107,1,107,7],[107,8,107,9],[107,10,107,11],[107,12,107,13],[107,14,107,15],[107,16,107,17],[106,1,106,7],[106,8,106,9],[106,10,106,11],[106,12,106,13],[106,14,106,15],[106,16,106,17],[105,1,105,7],[105,8,105,9],[105,10,105,11],[105,12,105,13],[105,14,105,15],[105,16,105,17],[104,1,104,7],[104,8,104,9],[104,10,104,11],[104,12,104,13],[104,14,104,15],[104,16,104,17],[103,1,103,7],[103,8,103,9],[103,10,103,11],[103,12,103,13],[103,14,103,15],[103,16,103,17],[102,1,102,7],[102,8,102,9],[102,10,102,11],[102,12,102,13],[102,14,102,15],[102,16,102,17],[101,1,101,7],[101,8,101,9],[101,10,101,11],[101,12,101,13],[101,14,101,15],[101,16,101,17],[99,1,99,18],[100,1,100,7],[100,8,100,9],[100,10,100,11],[100,12,100,13],[100,14,100,15],[100,16,100,17],[98,1,98,7],[98,8,98,9],[98,10,98,11],[98,12,98,13],[98,14,98,16],[98,17,98,18],[95,1,95,5],[95,6,95,7],[95,10,95,14],[95,15,95,16],[96,1,96,18],[97,1,97,18],[92,1,92,18],[93,1,93,2],[93,3,93,6],[93,7,93,9],[93,10,93,18],[94,1,94,18],[87,1,87,18],[88,1,88,18],[89,1,89,18],[90,1,90,16],[90,17,90,18],[91,1,91,18],[76,13,76,15],[83,1,83,7],[83,8,83,11],[83,13,83,15],[84,1,86,11],[84,13,84,15],[85,13,85,15],[86,13,86,15],[81,1,81,7],[81,8,81,11],[81,13,81,15],[82,1,82,7],[82,8,82,11],[82,13,82,15],[76,16,76,17],[77,1,77,7],[77,8,77,11],[77,13,77,15],[77,16,86,18],[78,1,78,7],[78,8,78,11],[74,1,74,7],[74,8,74,11],[74,13,74,15],[74,16,74,17],[75,1,75,7],[75,8,75,11],[75,13,75,15],[75,16,75,17],[78,13,78,15],[79,1,79,7],[79,8,79,11],[79,13,79,15],[80,1,80,7],[80,8,80,11],[80,13,80,15],[76,1,76,7],[76,8,76,11],[72,1,72,7],[72,8,72,11],[72,13,72,15],[72,16,72,17],[73,1,73,7],[73,8,73,11],[73,13,73,15],[73,16,73,17],[69,12,69,15],[70,1,70,7],[70,8,70,11],[70,13,70,15],[70,16,71,17],[70,18,71,18],[71,1,71,7],[71,8,71,11],[71,13,71,15],[63,1,63,18],[64,1,64,18],[65,1,65,18],[66,1,66,18],[67,1,67,18],[68,1,68,11],[68,12,68,15],[68,16,69,18],[69,1,69,7],[69,8,69,11],[56,8,56,10],[56,14,56,16],[57,1,57,18],[58,1,58,18],[59,1,61,18],[62,1,62,18],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[56,3,56,6],[50,1,51,1],[50,2,51,3],[50,4,51,4],[50,5,50,6],[50,9,50,10],[50,15,50,16],[47,1,47,18],[48,1,48,18],[49,1,49,4],[49,5,49,6],[49,7,49,12],[49,13,49,18],[43,1,43,16],[43,17,43,18],[44,1,44,18],[45,1,45,18],[46,3,46,6],[46,10,46,18],[37,1,37,10],[38,1,38,10],[39,1,39,10],[40,1,40,18],[41,1,41,18],[42,1,42,18],[32,1,32,18],[33,1,33,8],[33,9,33,10],[34,1,34,10],[35,1,35,10],[36,1,36,10],[27,1,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,18],[28,1,28,18],[29,1,31,18],[23,12,24,12],[23,13,23,18],[24,13,24,18],[25,5,25,10],[25,13,25,18],[26,1,26,8],[26,9,26,18],[20,1,20,4],[20,5,20,10],[20,13,20,18],[21,1,25,4],[21,5,21,10],[21,13,21,18],[22,5,22,10],[22,13,22,18],[23,5,24,10],[23,11,24,11],[16,1,16,4],[16,5,16,10],[16,13,16,18],[17,13,17,18],[18,1,19,4],[18,5,18,10],[18,13,18,18],[19,5,19,10],[19,13,19,18],[12,1,12,4],[12,5,12,10],[12,13,12,18],[13,1,15,4],[13,5,13,10],[13,13,13,18],[14,5,14,10],[14,13,14,18],[15,5,15,10],[15,13,15,18],[9,1,9,18],[10,1,10,4],[10,5,10,10],[10,13,10,18],[11,1,11,4],[11,5,11,10],[11,13,11,18],[7,1,7,4],[7,5,7,9],[7,10,7,13],[7,14,7,18],[8,1,8,9],[8,11,8,18],[0,1,0,18],[1,1,1,18],[2,1,2,18],[3,1,3,18],[4,1,4,2],[4,3,4,8],[4,9,4,10],[4,11,4,18],[6,1,6,2],[6,3,6,7],[6,8,6,9],[6,10,6,13],[6,14,6,15],[6,16,6,18],[5,1,5,2],[5,3,5,8],[5,9,5,10],[5,11,5,13],[5,15,5,16],[5,17,5,18]]}
[null,"Energy Efficiency Program"]
[null,"Energy Audit Diagnostic Test Form"]
[null,"Please complete all required information and submit this form as an attachment to the Incentive Application"]
[null,"Section 1:  Project Identification"]
[null,"Name:",null,{"$f":"IF(ISBLANK(Reservation!#REF!),\"\",Reservation!#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,"Primary Phone:",null,{"$f":"IF(ISBLANK(Reservation!#REF!),\"\",Reservation!#REF!)","v":{"$error":"#REF!"}}]
[null,"Address:",null,{"$f":"IF(ISBLANK(Reservation!F9),\"\",Reservation!F9)","v":""},null,null,null,null,null,"City:",null,{"$f":"IF(ISBLANK(Reservation!X9),\"\",Reservation!X9)","v":""},null,null,"IL","Zip Code:",null,{"$f":"IF(ISBLANK(Reservation!AI9),\"\",Reservation!AI9)","v":""}]
[null,"Project ID           (if required):",null,null,null,null,null,null,"Pre-Test Date:",null,null,null,null,null,"Post-Test Date:"]
[null,"Program Ally Company Name:",null,null,null,{"$f":"IF(ISBLANK(Reservation!F20),\"\",Reservation!F20)","v":""},null,null,null,null,"BPI-Certified Tester Name:"]
[null,"Was combustion safety testing required for this home?  Y / N:",null,null,null,null,null,null,null,null,null,"    If not, sections 3, 4, and 5 of this form may be left blank"]
[null,"Section 2:  Fuel Distribution System Inspection (always required when fuel lines exist in the residence)"]
[null,"Reference",null,null,null,"Selected Inspection Item",null,null,null,null,null,"Pre-Test Y/N","Post-Test Y/N","Actions levels for house ambient CO                                             BPI-1200 7.3.3.3"]
[null,"Conditions for entry",null,null,null,"House ambient combustible fuel gas > 10% LEL",null,null,null,null,null,null,null,"If ambient CO is 70 PPM or greater"]
[null,"BPI-1200 7.3",null,null,null,"House ambient CO level (PPM)",null,null,null,null,null,null,null," - Terminate the inspection"]
[null,"Natural gas and LP gas piping system inspection and leak testing",null,null,null,"Gas leak testing completed",null,null,null,null,null,null,null," - Notify occupants to evacuate"]
[null,null,null,null,null,"Gas leak(s) found",null,null,null,null,null,null,null," - Notify emergency services from outside"]
[null,null,null,null,null,"Gas lines or connectors unsafe or uncoated brass",null,null,null,null,null,null,null,"If ambient CO is 36-69 PPM"]
[null,"BPI-1200 7.5",null,null,null,"Visibly worn flex gas line or pre-1973",null,null,null,null,null,null,null," - Advise the homeowner of elevated level"]
[null,"Section 3:  Combustion Appliance Inspection",null,null,null,null,null,null,null,null,null,null,null," - Open doors and windows"]
[null,"Visual inspection of CAZ",null,null,null,"CAZ clear of flammable products",null,null,null,null,null,null,null," - Recommend CO sources be turned off"]
[null,null,null,null,null,"Vent connectors clearance from combustibles",null,null,null,null,null,null,null," - Advise homeowner contact qual. professional"]
[null,"BPI-1200 7.7",null,null,null,"Garage DHW FVIR or 18” off floor (Y/N/NA)",null,null,null,null,null,null,null,"If ambient CO is 9-35 PPM"]
[null,"Visual inspection of combustion appliances and venting systems                                  BPI-1200 7.8",null,null,null,"Venting system 1/4\" rise per foot",null,null,null,null,null,null,null," - Advise the homeowner of elevated level"]
[null,null,null,null,null,"Masonry chimney lined (Y/N/NA)",null,null,null,null,null,null,null," - Recommend open doors and windows"]
[null,null,null,null,null,"Lower BTU appliance enters main flue after higher BTU appliance (Y/N/NA)",null,null,null,null,null,null,null," - Recommend CO sources be checked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," - Advise homeowner contact qual. professional"]
[null,null,null,null,null,"Unvented heater ANSI Z21.11.2  label (Y/N/NA)",null,null,null,null,null,null,null,"If ambient CO < 9 PPM then no action is required"]
[null,"Action if house ambient combustible fuel gas is > 10% LEL:",null,null,null,null,null,null,null,"Terminate inspection, notify to evacuate, notify emergency services from outside"]
[null,"Minimum clearance of vent connectors from combustibles BPI-1200 Table E2:",null,null,null,null,null,null,null,null,null,"B Vent - 6 in",null,"L Vent - 6 in",null,"Single wall metal pipe - 9 in"]
[null,"If any portion of the combustion appliance and fuel distribution system inspection did not meet BPI-1200 standards, describe actions taken:"]
[]
[]
[]
[null,"Section 4:  Establishment of Greatest Possible Depressurization CAZ Conditions BPI-1200 7.9.1"]
[null,"Number of Combustion Appliance Zones for this test:",null,null,null,null,null,null,null,null,null,"CAZ #1 Pre","> 70?        Y / N","CAZ #1 Post","> 70?        Y / N","CAZ #2 Pre","> 70?        Y / N","CAZ #2 Post","> 70?        Y / N"]
[null,"Combustion Appliance Zone ambient CO level"]
[null,"Baseline pressure (interior doors closed except rooms with exhaust fans or returns to central air)"]
[null,"Pressure with exhaust equipment on"]
[null,"Pressure with air handler on"]
[null,"Pressure with air handler turned either on or off and CAZ doors open "]
[null,"Greatest Possible Depressurization"]
[]
[]
[null,"General Inquiries: Ameren Illinois Residential Energy Efficiency Programs • PO Box 5098, Peoria, IL 61601-9998"]
[null,"For more information contact your Field Energy Specialist • Fax: 309.677.3370 • AmerenIllinoisSavings.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEP-1004-1119"]
[null,{"$f":"B1","v":"Energy Efficiency Program"}]
[null,{"$f":"B2","v":"Energy Audit Diagnostic Test Form"}]
[null,null,"Project ID:",{"$f":"IF($D$5=\"\",\"\",$D$5)","v":{"$error":"#REF!"}},null,null,null,null,null,"Homeowner Name:",""]
[null,"Section 5:  Combustion Appliance Zone (CAZ) Spillage and CO Testing BPI-1200 7.9.2 thru 4"]
[null,"Under BPI Greatest Possible Depressurization Conditions"]
[null,null,null,null,null,"Spillage test",null,"CO pre-test (PPM)",null,null,null,null,null,"CO post-test (PPM)"]
[null,null,"Common     Vent",null,"CAZ #","(P / F)",null,"CO","O2","CO Air-Free",null,"Thresh",null,"CO","O2","CO Air-Free",null,"Thresh"]
[null,null,null,null,null,"Pre","Post","Meas","Meas","Calc","Meas","-hold","A / U","Meas","Meas","Calc","Meas","-hold","A / U"]
[null,"DHW",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I53>20.9,9999,IF(OR(H53=\"\",I53=\"\"),\"\",(20.9/(20.9-I53)*H53))),9999)","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(O53>20.9,9999,IF(OR(N53=\"\",O53=\"\"),\"\",(20.9/(20.9-O53)*N53))),9999)","v":""}]
[null,"Heat",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I54>20.9,9999,IF(OR(H54=\"\",I54=\"\"),\"\",(20.9/(20.9-I54)*H54))),9999)","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(O54>20.9,9999,IF(OR(N54=\"\",O54=\"\"),\"\",(20.9/(20.9-O54)*N54))),9999)","v":""}]
[null,"Other",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I55>20.9,9999,IF(OR(H55=\"\",I55=\"\"),\"\",(20.9/(20.9-I55)*H55))),9999)","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(O55>20.9,9999,IF(OR(N55=\"\",O55=\"\"),\"\",(20.9/(20.9-O55)*N55))),9999)","v":""}]
[null,"Other",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I56>20.9,9999,IF(OR(H56=\"\",I56=\"\"),\"\",(20.9/(20.9-I56)*H56))),9999)","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(O56>20.9,9999,IF(OR(N56=\"\",O56=\"\"),\"\",(20.9/(20.9-O56)*N56))),9999)","v":""}]
[null,"Oven"]
[null,"Actions For Failed CAZ Tests"]
[null,"If any appliance failed spillage or tested unacceptable for CO, or if ambient CO level in CAZ became elevated, state actions taken:"]
[]
[]
[]
[null,"Spillage and carbon monoxide in combustion appliances BPI-1200 Annex D"]
[null,"For single DHW or warm vent appliance, spillage assessed at 2 minutes of main burner operation and CO air free at 5 minutes"]
[null,"For single cold vent appliance (except DHW), spillage and CO air free are both assessed at 5 minutes of main burner operation"]
[null,"For commonly vented appliances, smallest BTU first, spillage at 2 mins, CO air free at 5 mins, do not allow to cool, fire second appliance, re-assess first appliance for spillage at 2 mins, immediately assess second appliance for spillage, assess second appliance for CO air free at 5 mins"]
[null,"CO above threshold limit is unacceptable, advise homeowner the appliance should be serviced immediately by a qualified professional  "]
[null,"If CO level is unacceptable and spillage is not present, testing may continue at discretion of tester"]
[null,"Carbon monoxide threshold limits BPI-1200 7.9.5 Table 1",null,null,null,null,null,null,null,null,null,null,"Illinois Weather & Shielding Factors          ",null,null,null,"Story Factors (S)             BPI-1200 Annex I.1.4"]
[null,"Appliance",null,null,null,null,null,null,"CO Threshold Limit",null,null,null,"(wsf) ASHRAE 62.2-2016 App B"]
[null,"Central Furnace (all categories)",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.44,"Mount Vernon",null,null,"Stories Above Grade",null,"Factor"]
[null,"Boiler",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.47,"Marion"]
[null,"Floor Furnace",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.48,"Belleville Scott AFB",null,null,1,null,1]
[null,"Gravity Furnace",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.51,"Quincy",null,null,1.5,null,1.18]
[null,"Wall Furnace (BIV)",null,null,null,null,null,null,"200 ppm air free",null,null,null,0.51,"Sterling / Rock Falls",null,null,2,null,1.32]
[null,"Wall Furnace (Direct Vent)",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.55000000000000004,"Peoria",null,null,2.5,null,1.44]
[null,"Vented Room Heater",null,null,null,null,null,null,"200 ppm air free",null,null,null,0.56000000000000005,"Decatur",null,null,3,null,1.55]
[null,"Unvented Room Heater",null,null,null,null,null,null,"200 ppm air free",null,null,null,0.56000000000000005,"Chicago Midway"]
[null,"Water Heater",null,null,null,null,null,null,"200 ppm air free",null,null,null,0.56999999999999995,"Springfield "]
[null,"Oven/Broiler",null,null,null,null,null,null,"225 ppm as measured",null,null,null,0.56999999999999995,"Urbana Champaign"]
[null,"Clothes Dryer",null,null,null,null,null,null,"400 ppm air free",null,null,null,0.56999999999999995,"Aurora"]
[null,"Refrigerator",null,null,null,null,null,null,"25 ppm as measured",null,null,null,0.57999999999999996,"Rockford"]
[null,"Gas Log (gas fireplace)",null,null,null,null,null,null,"25 ppm as measured in vent",null,null,null,0.57999999999999996,"Moline / Quad Cities"]
[null,"Gas Log (installed in wood burning fireplace)",null,null,null,null,null,null,"400 ppm air free in fire box",null,null,null,0.57999999999999996,"W Chicago / Du Page"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.59,"Chicago / Waukegan"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.6,"Chicago O'Hare"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.6,"Bloomington / Normal"]
[]
[]
[null,"General Inquiries: Ameren Illinois Residential Energy Efficiency Programs • PO Box 5098, Peoria, IL 61601-9998"]
[null,"For more information contact your Field Energy Specialist • Fax: 309.677.3370 • AmerenIllinoisSavings.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEP-1004-1119"]
[null,{"$f":"B1","v":"Energy Efficiency Program"}]
[null,{"$f":"B2","v":"Energy Audit Diagnostic Test Form"}]
[null,"Project ID:",null,{"$f":"IF(ISBLANK(D7),\"\",D7)","v":""},null,null,null,"Homeowner Name:",null,null,{"$f":"D5","v":{"$error":"#REF!"}}]
[null,"Section 6:  Blower Door Test"]
[null,"Initial blower door measurement Q50:",null,null,null,null,{"$f":"Reservation!R25","v":0},null,"Tout:",null,"Final blower door measurement Q50:",null,null,null,null,{"$f":"'Incentive Payment'!O15","v":0},null,"Tout:"]
[null,"Section 7:  Floor Area"]
[null,"ASHRAE 62.2-2016 defines floor area:  all above and below grade finished areas as defined in ANSI Standard Z765.  ANSI Z765 defines finished area:  an enclosed area in a house that is suitable for year-round use, embodying walls, floors, and ceilings that are similar to the rest of the house."]
[null,"Floor area in square feet:",null,null,null,null,null,null,null,null,"Stories:",null,null,null,"Number of bedrooms:"]
[null,"Section 8:  Ventilation Requirements Pre-Test (ASHRAE 62.2-2016)"]
[null,"Local demand-controlled ventilation",null,null,null,null,null,null,"Required",null,"Measured or Assume Zero",null,"Shortfall",null,"Window Credit           20 CFM   (Y / N)",null,"Deficit"]
[null,"Bathroom #1 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K102=\"\",\"\",(IF(K102>I102,0,I102-K102)))","v":""},null,null,null,{"$f":"IFERROR(IF(O102=\"\",M102,(IF(O102=\"Y\",IF((M102-20)>0, (M102-20),0),M102))),\"\")","v":""}]
[null,"Bathroom #2 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K103=\"\",\"\",(IF(K103>I103,0,I103-K103)))","v":""},null,null,null,{"$f":"IFERROR(IF(O103=\"\",M103,(IF(O103=\"Y\",IF((M103-20)>0, (M103-20),0),M103))),\"\")","v":""}]
[null,"Bathroom #3 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K104=\"\",\"\",(IF(K104>I104,0,I104-K104)))","v":""},null,null,null,{"$f":"IFERROR(IF(O104=\"\",M104,(IF(O104=\"Y\",IF((M104-20)>0, (M104-20),0),M104))),\"\")","v":""}]
[null,"Bathroom #4 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K105=\"\",\"\",(IF(K105>I105,0,I105-K105)))","v":""},null,null,null,{"$f":"IFERROR(IF(O105=\"\",M105,(IF(O105=\"Y\",IF((M105-20)>0, (M105-20),0),M105))),\"\")","v":""}]
[null,"Half-Bathroom #5 demand-controlled flow rate (CFM):",null,null,null,null,null,null,0,null,null,null,0,null,"N/A",null,0]
[null,"Kitchen #1 demand-controlled flow rate (CFM):",null,null,null,null,null,null,100,null,0,null,{"$f":"IF(K107=\"\",\"\",(IF(K107>I107,0,I107-K107)))","v":100},null,null,null,{"$f":"IFERROR(IF(O107=\"\",M107,(IF(O107=\"Y\",IF((M107-20)>0, (M107-20),0),M107))),\"\")","v":100}]
[null,"Kitchen #2 demand-controlled flow rate (CFM):",null,null,null,null,null,null,100,null,null,null,{"$f":"IF(K108=\"\",\"\",(IF(K108>I108,0,I108-K108)))","v":""},null,null,null,{"$f":"IFERROR(IF(O108=\"\",M108,(IF(O108=\"Y\",IF((M108-20)>0, (M108-20),0),M108))),\"\")","v":""}]
[null,"Note:  If the flow through an operating, vented, kitchen exhaust fan or bathroom exhaust fan cannot be measured, then assume zero CFM.  ASHRAE 62.2-2016 Appendix A3.1",null,null,null,null,null,null,null,null,null,null,null,"Total local deficit:",null,null,{"$f":"IF(COUNT(Q102:R105)+COUNT(Q107:R108)=0,\"\",SUM(Q102:R108))","v":100}]
[null,"Is whole-building mechanical ventilation required?",null,null,null,null,null,null,null,null,"Weather and shielding factor (wsf):",null,null,null,null,null,"Story factor (S):",null,{"$f":"IF(M99=\"\",\"\",VLOOKUP(M99,Q73:S77,3))","v":""}]
[null,"Required whole-house ventilation rate   Qtot = (.03 x floor area) + (7.5 x (# of bedrooms +1)): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$99=\"\",\"\",IF($R$99=\"\",\"\",(0.03*$I$99+(7.5*($R$99+1)))))","v":""}]
[null,"Alternative compliance supplement (total local deficit / 4):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q109=\"\",\"\",IF(Q109>0,Q109/4,\"\"))","v":25}]
[null,"Adjusted Qtot for alternative compliance supplement:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S111=\"\",\"\",IF(S112=\"\",S111,S111+S112))","v":""}]
[null,"Note:  if Qfan ≤ 15 CFM then no additional whole-building mechanical ventilation is required",null,null,null,null,null,null,"Infiltration credit for blower door measurement   Qinf = Q50 x S x wsf x .052:",null,null,null,null,null,null,null,null,null,{"$f":"IF($G$96=\"\",\"\",IF(S110=\"\",\"\",IF(P110=\"\",\"\",0.052*$G$96*P110*S110)))","v":""}]
[null,null,null,null,null,null,null,null,"Required whole-house mechanical ventilation rate   Qfan = Adjusted Qtot - Qinf:",null,null,null,null,null,null,null,null,null,{"$f":"IF(S113=\"\",\"\",IF(S114=\"\",\"\",S113-S114))","v":""}]
[null,"Section 9:  Ventilation Requirements Post-Test (ASHRAE 62.2-2016)"]
[null,"Local demand-controlled ventilation",null,null,null,null,null,null,"Required",null,"Measured or Assume Zero",null,"Shortfall",null,"Window Credit           20 CFM   (Y / N)",null,"Deficit",null,"Alt Comp (Y)"]
[null,"Bathroom #1 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K118=\"\",\"\",(IF(K118>I118,0,I118-K118)))","v":""},null,null,null,{"$f":"IFERROR(IF(O118=\"\",M118,(IF(O118=\"Y\",IF((M118-20)>0, (M118-20),0),M118))),\"\")","v":""}]
[null,"Bathroom #2 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K119=\"\",\"\",(IF(K119>I119,0,I119-K119)))","v":""},null,null,null,{"$f":"IFERROR(IF(O119=\"\",M119,(IF(O119=\"Y\",IF((M119-20)>0, (M119-20),0),M119))),\"\")","v":""}]
[null,"Bathroom #3 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K120=\"\",\"\",(IF(K120>I120,0,I120-K120)))","v":""},null,null,null,{"$f":"IFERROR(IF(O120=\"\",M120,(IF(O120=\"Y\",IF((M120-20)>0, (M120-20),0),M120))),\"\")","v":""}]
[null,"Bathroom #4 demand-controlled flow rate (CFM):",null,null,null,null,null,null,50,null,null,null,{"$f":"IF(K121=\"\",\"\",(IF(K121>I121,0,I121-K121)))","v":""},null,null,null,{"$f":"IFERROR(IF(O121=\"\",M121,(IF(O121=\"Y\",IF((M121-20)>0, (M121-20),0),M121))),\"\")","v":""}]
[null,"Half-Bathroom #5 demand-controlled flow rate (CFM):",null,null,null,null,null,null,0,null,null,null,0,null,"N/A",null,0]
[null,"Kitchen #1 demand-controlled flow rate (CFM):",null,null,null,null,null,null,100,null,0,null,{"$f":"IF(K123=\"\",\"\",(IF(K123>I123,0,I123-K123)))","v":100},null,null,null,{"$f":"IFERROR(IF(O123=\"\",M123,(IF(O123=\"Y\",IF((M123-20)>0, (M123-20),0),M123))),\"\")","v":100}]
[null,"Kitchen #2 demand-controlled flow rate (CFM):",null,null,null,null,null,null,100,null,null,null,{"$f":"IF(K124=\"\",\"\",(IF(K124>I124,0,I124-K124)))","v":""},null,null,null,{"$f":"IFERROR(IF(O124=\"\",M124,(IF(O124=\"Y\",IF((M124-20)>0, (M124-20),0),M124))),\"\")","v":""}]
[null,"Note:  If the flow through an operating, vented, kitchen exhaust fan or bathroom exhaust fan cannot be measured, then assume zero CFM.  ASHRAE 62.2-2016 Appendix A3.1",null,null,null,null,null,null,null,null,null,null,null,"Total local deficit:",null,null,{"$f":"IF(COUNT(Q118:R121)+COUNT(Q123:R124)=0,\"\",SUM(Q118:R124))","v":100}]
[null,"Is whole-building mechanical ventilation required?",null,null,null,null,null,null,null,null,"Weather and shielding factor (wsf):",null,null,null,null,{"$f":"IF(P110=\"\",\"\",P110)","v":""},"Story factor (S):",null,{"$f":"IF(S110=\"\",\"\",S110)","v":""}]
[null,"Required whole-house ventilation rate   Qtot = (.03 x floor area) + (7.5 x (# of bedrooms +1)): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$99=\"\",\"\",IF($R$99=\"\",\"\",(0.03*$I$99+(7.5*($R$99+1)))))","v":""}]
[null,"Alternative compliance supplement (total local deficit / 4):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q125=\"\",\"\",IF(Q125>0,Q125/4,\"\"))","v":25}]
[null,"Adjusted Qtot for alternative compliance supplement:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S127=\"\",\"\",IF(S128=\"\",S127,S127+S128))","v":""}]
[null,"Note:  if Qfan ≤ 15 CFM then no additional whole-building mechanical ventilation is required",null,null,null,null,null,null,"Infiltration credit for blower door measurement   Qinf = Q50 x S x wsf x .052:",null,null,null,null,null,null,null,null,null,{"$f":"IF($P$96=\"\",\"\",IF(S126=\"\",\"\",IF(P126=\"\",\"\",0.052*$P$96*P126*S126)))","v":""}]
[null,null,null,null,null,null,null,null,"Required whole-house mechanical ventilation rate   Qfan = Adjusted Qtot - Qinf:",null,null,null,null,null,null,null,null,null,{"$f":"IF(S129=\"\",\"\",IF(S130=\"\",\"\",S129-S130))","v":""}]
[null,"Describe the strategy used to make any corrections to local exhaust deficits and/or required whole-building mechanical ventilation:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Installed Whole-Building Mechanical Ventilation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Measured Continuous Ventilation Rate:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Timer Set point (minutes/hour):"]
[]
[]
[null,"General Inquiries: Ameren Illinois Residential Energy Efficiency Programs • PO Box 5098, Peoria, IL 61601-9998"]
[null,"For more information contact your Field Energy Specialist • Fax: 309.677.3370 • AmerenIllinoisSavings.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEP-1004-1119"]
[]
[null,"edited 11-3-21"]

{"sheet":"Lists","index":5,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
["Central Air Conditioner",null,null,"Measure","Incentive",null,null,null,null,"TEST FORM"]
["Air Source Heat Pump",null,null,"Air Sealing",0.7,null,"X",null,null,"Stories","Story Factor","Wsf"]
["Mini-Split Heat Pump",null,null,"Attic ",1.1000000000000001]
["Window Unit",null,null,"Wall",1.1000000000000001,null,0,null,null,1,1,0.44]
["None",null,null,"Kneewall",1.1000000000000001,null,1,null,null,1.5,1.18,0.47,"Yes",null,"Pass",null,"Y"]
[null,null,null,"Rim Joist",2,null,null,null,null,2,1.32,0.48,"No",null,"Fail"]
[null,null,null,"Crawl Space",3,null,"Manual",null,null,2.5,1.44,0.51]
[null,null,null,"Exhaust Fan",25,null,"Programmable",null,null,3,1.55,0.55000000000000004]
["Natural Gas Furnace",null,null,"Smart Thermostat",100,null,null,null,null,null,null,0.56000000000000005]
["Natural Gas Boiler",null,null,"Duct Sealing",200,null,"0%",null,null,null,null,0.56999999999999995]
["Air Source Heat Pump",null,null,null,null,null,"< 25%",null,null,null,null,0.57999999999999996]
["Electric Resistance",null,null,null,null,null,"< 50%",null,null,null,null,0.6]
["Propane Furnace",null,null,null,null,null,"> 50%"]
["Propane Boiler",null,null,null,null,null,"> 75%"]
[null,null,null,null,null,null,1]
[]
["Blown cellulose",null,null,null,null,null,null,null,null,"Variable flow fan adjusted on site",null,null,null,"N"]
["Blown fiberglass",null,null,null,null,null,null,null,null,"One speed fan with timer (existing or new)",null,null,null,"W"]
["Fiberglass batt",null,null,null,null,null,null,null,null,"Air cycler-style",null,null,null,"S"]
["Foam Board",null,null,null,null,null,null,null,null,"Recovery Ventilator",null,null,null,"E"]
["Spray Foam",null,null,null,null,null,null,null,null,"Natural",null,null,null,"NW"]
["Mixed types",null,null,null,null,null,null,null,null,"Other (detail below)",null,null,null,"NE"]
["Mineral Wool",null,null,null,null,null,null,null,null,null,null,null,null,"SW"]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,"SE"]
[]
[]
["Good"]
["Fair"]
["Poor"]
["Very Poor"]