{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["HOME","Checklist","Applicant Info","Terms & Conditions","Inspection Report","Gen Info","Pictures"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":4,"defined_names":167,"comments":2,"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":"HOME","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,16,4],[1,2,1,8],[0,2,0,8],[2,0,2,8],[6,1,7,4],[9,1,9,4],[3,4,3,5],[3,7,3,8],[3,1,3,2],[14,6,14,8],[7,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[6,6,6,8],[13,9,13,12],[0,0,1,1],[5,0,5,3],[13,6,13,8],[11,1,13,4]]}
[null,null,"2024 New Construction Quality Application Bonus v1"]
[null,null,"PNM Business Energy Efficiency Programs"]
["Why improve energy efficiency?"]
[null,"Improves profitability by cutting operating costs",null,null,"Distinguishes your business as an energy efficiency advocate within our community",null,null,"Qualifies your project for rebates that can help cover upgrade costs"]
[]
["         Application Process",null,null,null,null,null,"Contact Our Team"]
["1.","Submit a Pre-Notification Application to reserve funding (if required).",null,null,null,null,"Address:"]
[null,null,null,null,null,null,"320 Gold Avenue SW, Suite 500\nAlbuquerque, NM 87102\n"]
[]
["2.","Install the qualified technology.",null,null,null,null,"Main Phone:"]
[null,null,null,null,null,null,"(505) 938-9400"]
["3.","Complete, sign, and submit a Final \nApplication with all required documentation \nwithin 6 months of project completion.",null,null,null,null,"Email:"]
[null,null,null,null,null,null,"energyefficiency@pnm.com"]
[null,null,null,null,null,null,"Website:"]
[null,null,null,null,null,null,"www.pnmenergyefficiency.com"]
["4.","The incentive check will be sent 4 to 6 \nweeks after approval of the Final Application."]

{"sheet":"Checklist","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
[null,null,null,"Checklist"]
[]
[]
[null,"1. Accurate W-9 for all payees"]
[]
[null,"2. All signatures"]
[]
[null,"3. App submitted by Trade Ally"]
[]
[null,"4. Complete set of construction drawings, in elec. format"]
[]
[null,"5. Interior ComCheck"]
[]
[null,"6. Exterior ComCheck"]
[]
[null,"7. Product Submittals (if applied for):"]
[null,null,"a. Interior Lighting"]
[null,null,"b. Exterior Lighting"]
[null,null,"c. HVAC (AHRI or manufacturer IPLV sheets)"]
[null,null,"d. Food Service Equipment"]
[null,null,"e. Pool Pumps"]
[null,null,"f. Industrial"]
[]
[null,"10. Incentive over $1,000"]
[]
[null,"11. Product spec sheets for every measure"]
[]
[null,"12. Invoices or GC Pay Application"]
[]
[null,"13. Quantity equals installed measures"]

{"sheet":"Applicant Info","index":2,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[36,0,36,3],[25,0,25,10],[30,0,30,10],[23,5,23,10],[24,5,24,10],[23,0,23,4],[24,0,24,4],[26,0,26,10],[29,0,29,10],[27,0,27,10],[28,0,28,10],[34,0,34,10],[11,6,11,10],[0,0,0,1],[16,0,16,3],[0,9,0,10],[5,7,5,8],[9,0,9,10],[14,0,14,5],[14,6,14,10],[11,0,11,5],[21,0,21,3],[0,3,0,8],[3,0,3,5],[3,6,3,8],[21,8,21,10],[18,6,18,7],[20,0,20,3],[20,4,20,5],[20,6,20,7],[12,0,12,10],[5,2,5,4],[13,6,13,10],[13,0,13,5],[15,3,15,5],[15,6,15,7],[15,8,15,10],[22,0,22,10],[16,4,16,10],[33,7,33,10],[35,7,35,10],[18,4,18,5],[21,4,21,5],[31,0,31,4],[33,0,33,4],[35,0,35,4],[31,7,31,10],[19,4,19,10],[17,4,17,10],[17,0,17,3],[18,0,18,3],[19,0,19,3],[32,0,32,10]]}
[null,null,null,"APPLICANT INFORMATION",null,null,null,null,null,"For office use only:"]
[null,null,null,null,null,null,null,null,null,"Application #","Revision #"]
[]
["Application Type:",null,null,null,null,null,"Check ONE box below:*"]
[]
[null,null,"NC Quality Application Bonus",null,null,null,null,"Final Application",null,"Date",null,null,null,null,null,{"$f":"IF(G6>0,\"Yes\",)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New pre notification checkbox flag:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifacility checkbox flag:"]
[]
["Name of Company*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"College/University",null,"Corporation (Inc, PC, etc.)",null,"AL"]
["Name of Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,"Grocery",null,"Government Agency",null,"AK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Health Care",null,"Individual",null,"AZ"]
["Telephone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,"Heavy Industry",null,"Partnership",null,"AR"]
["Email Address*",null,null,null,null,null,null,null,null,null,null,null,"Hotel/Motel",null,"Exempt",null,"CA"]
["Address Where Measures Installed*",null,null,null,null,null,null,null,null,null,null,null,"Light Industry",null,null,null,"CO"]
["City Where Measures Installed*",null,null,null,null,null,"State*",null,{"$f":"IF(E19=\"\",\"\",\"NM\")","v":""},"Zip*",null,null,"Miscellaneous",null,null,null,"CT"]
["Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,"Office",null,null,null,"DE"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,"Restaurant",null,null,null,"FL"]
["Taxpayer ID Number (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,"Retail",null,null,null,"GA"]
["FOR OFFICE USE ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HI"]
["Annual kWh Savings",null,null,null,null,"Total Incentive Requested",null,null,null,null,null,null,null,null,null,null,"ID"]
[null,null,null,null,null,{"$f":"IF(A25<10000,0,1000+(0.005*A25))","v":0},null,null,null,null,null,null,null,null,null,null,"IL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
["AGREEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
["Inspections\nPNM reserves the right to inspect all Participating PNM Trade Allies’ projects to verify sales transactions, compliance with program rules, and accuracy of project documentation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
["Tax Liability\nBonuses paid under this program are taxable and will be reported to the IRS unless the recipient is tax exempt. PNM is not responsible for any taxes that may be imposed on a Participating PNM Trade Ally as a result of its receipt of a bonus payment.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
["Disclaimer\nPNM reserves the right to modify or terminate this bonus program without prior notice. The PNM New Construction Quality Application Bonus has limited funds and may end at any time.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
["Acceptace of Terms and Conditions\n          I have read and understand the Eligibility Requirements, Bonus Requirements, and other terms and conditions set forth in this PNM New Construction Quality Application Bonus section, and agree to abide by all requirements. Furthermore, I concur that I must meet all eligibility criteria in order to be paid a bonus.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
["Applicant Signature (Please sign by hand)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
["Print Applicant Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]

{"sheet":"Terms & Conditions","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,3,0,6],[43,2,43,7]]}
[null,null,null,"TERMS & CONDITIONS"]

{"sheet":"Inspection Report","index":4,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":true,"merged":[[39,17,39,23],[40,17,40,23],[41,17,41,23],[42,17,42,23],[18,0,18,23],[33,0,33,13],[33,14,33,16],[33,17,33,23],[34,0,34,13],[34,14,34,16],[34,17,34,23],[35,0,35,13],[35,14,35,16],[27,0,27,23],[22,0,22,23],[23,0,23,23],[0,0,3,18],[0,19,0,23],[1,19,3,23],[4,4,4,7],[4,20,4,23],[5,4,5,7],[5,19,5,23],[7,5,7,21],[8,5,8,21],[9,5,9,21],[24,0,24,23],[25,0,25,23],[26,0,26,23],[10,5,10,11],[13,0,15,23],[19,0,19,23],[20,0,20,23],[21,0,21,23],[35,17,35,23],[36,0,36,13],[36,14,36,16],[36,17,36,23],[37,0,37,13],[37,14,37,16],[37,17,37,23],[45,14,45,20],[46,14,46,20],[38,0,38,13],[38,14,38,16],[38,17,38,23],[43,0,43,13],[43,14,43,16],[43,17,43,23],[39,0,39,13],[40,0,40,13],[41,0,41,13],[42,0,42,13],[39,14,39,16],[40,14,40,16],[41,14,41,16],[42,14,42,16]]}
["     AC Tune-up Post Inspection Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Applicant Info'!J3","v":0}]
[]
[]
["Date Assigned:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Date:"]
["Date Due:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector:"]
[]
["Name of Company:",null,null,null,null,{"$f":"+'Applicant Info'!A13","v":0}]
["Site Address:",null,null,null,null,{"$f":"+'Applicant Info'!E18","v":0}]
["Contact Name:",null,null,null,null,{"$f":"+'Applicant Info'!A15","v":0}]
["Phone Number:",null,null,null,null,{"$f":"+'Applicant Info'!D16","v":0}]
[]
["Project Description:"]
[{"$f":"\"The facility had a total of \"&TEXT('Gen Info'!C8,0)& \" rooftop units. There were \"&IF('Gen Info'!C9>0,\"(\"&TEXT('Gen Info'!C9,0)& \") 3-ton units\",) &IF('Gen Info'!C10>0,\"(\"&TEXT('Gen Info'!C10,0)& \") 4-ton units\",) &IF('Gen Info'!C11>0,\", (\"&TEXT('Gen Info'!C11,0)& \") 5-ton units\",)&IF('Gen Info'!C12>0,\", (\"&TEXT('Gen Info'!C12,0)& \") 6-ton units\",)&IF('Gen Info'!C13>0,\", (\"&TEXT('Gen Info'!C13,0)& \") 7.5-ton units\",)&IF('Gen Info'!C14>0,\", (\"&TEXT('Gen Info'!C14,0)& \") 8-ton units\",)&IF('Gen Info'!C15>0,\", (\"&TEXT('Gen Info'!C15,0)& \") 9-ton units\",) &IF('Gen Info'!C16>0,\"(\"&TEXT('Gen Info'!C16,0)& \") 10-ton units\",) &IF('Gen Info'!C17>0,\"(\"&TEXT('Gen Info'!C17,0)& \") 11-ton units\",) &IF('Gen Info'!F9>0,\", (\"&TEXT('Gen Info'!F9,0)& \") 12.5-ton units\",) &IF('Gen Info'!F10>0,\", (\"&TEXT('Gen Info'!F10,0)& \") 15-ton units\",)&IF('Gen Info'!F11>0,\", (\"&TEXT('Gen Info'!F11,0)& \") 17.5-ton units\",)&IF('Gen Info'!F12>0,\", (\"&TEXT('Gen Info'!F12,0)& \") 20-ton units\",)&IF('Gen Info'!F13>0,\", (\"&TEXT('Gen Info'!F13,0)& \") 25-ton units\",)&IF('Gen Info'!F14>0,\", (\"&TEXT('Gen Info'!F14,0)& \") 30-ton units\",) &IF('Gen Info'!F15>0,\", (\"&TEXT('Gen Info'!F15,0)& \") 35-ton units\",)&IF('Gen Info'!F16>0,\", (\"&TEXT('Gen Info'!F16,0)& \") 40-ton units\",) &\".\"","v":{"$error":"#REF!"}}]
[]
[]
[]
["Inspection Results:"]
[{"$f":"TEXT('Gen Info'!B24,0)&\" Model: \"&TEXT('Gen Info'!C24,0)&\",  Serial Number: \"&TEXT('Gen Info'!D24,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E24,0)&\" because \"&TEXT('Gen Info'!F24,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G24,0)&\" due to \"&TEXT('Gen Info'!H24,0)&IF('Gen Info'!I24=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I24=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J24=\"Yes\",\" Unit passed.\",IF('Gen Info'!I24=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B25,0)&\" Model: \"&TEXT('Gen Info'!C25,0)&\",  Serial Number: \"&TEXT('Gen Info'!D25,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E25,0)&\" because \"&TEXT('Gen Info'!F25,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G25,0)&\" due to \"&TEXT('Gen Info'!H25,0)&IF('Gen Info'!I25=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I25=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J25=\"Yes\",\" Unit passed.\",IF('Gen Info'!I25=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B26,0)&\" Model: \"&TEXT('Gen Info'!C26,0)&\",  Serial Number: \"&TEXT('Gen Info'!D26,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E26,0)&\" because \"&TEXT('Gen Info'!F26,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G26,0)&\" due to \"&TEXT('Gen Info'!H26,0)&IF('Gen Info'!I26=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I26=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J26=\"Yes\",\" Unit passed.\",IF('Gen Info'!I26=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B27,0)&\" Model: \"&TEXT('Gen Info'!C27,0)&\",  Serial Number: \"&TEXT('Gen Info'!D27,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E27,0)&\" because \"&TEXT('Gen Info'!F27,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G27,0)&\" due to \"&TEXT('Gen Info'!H27,0)&IF('Gen Info'!I27=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I27=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J27=\"Yes\",\" Unit passed.\",IF('Gen Info'!I27=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B28,0)&\" Model: \"&TEXT('Gen Info'!C28,0)&\",  Serial Number: \"&TEXT('Gen Info'!D28,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E28,0)&\" because \"&TEXT('Gen Info'!F28,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G28,0)&\" due to \"&TEXT('Gen Info'!H28,0)&IF('Gen Info'!I28=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I28=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J28=\"Yes\",\" Unit passed.\",IF('Gen Info'!I28=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B29,0)&\" Model: \"&TEXT('Gen Info'!C29,0)&\",  Serial Number: \"&TEXT('Gen Info'!D29,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E29,0)&\" because \"&TEXT('Gen Info'!F29,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G29,0)&\" due to \"&TEXT('Gen Info'!H29,0)&IF('Gen Info'!I29=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I29=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J29=\"Yes\",\" Unit passed.\",IF('Gen Info'!I29=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B30,0)&\" Model: \"&TEXT('Gen Info'!C30,0)&\",  Serial Number: \"&TEXT('Gen Info'!D30,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E30,0)&\" because \"&TEXT('Gen Info'!F30,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G30,0)&\" due to \"&TEXT('Gen Info'!H30,0)&IF('Gen Info'!I30=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I30=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J30=\"Yes\",\" Unit passed.\",IF('Gen Info'!I30=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B31,0)&\" Model: \"&TEXT('Gen Info'!C31,0)&\",  Serial Number: \"&TEXT('Gen Info'!D31,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E31,0)&\" because \"&TEXT('Gen Info'!F31,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G31,0)&\" due to \"&TEXT('Gen Info'!H31,0)&IF('Gen Info'!I31=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I31=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J31=\"Yes\",\" Unit passed.\",IF('Gen Info'!I31=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B32,0)&\" Model: \"&TEXT('Gen Info'!C32,0)&\",  Serial Number: \"&TEXT('Gen Info'!D32,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E32,0)&\" because \"&TEXT('Gen Info'!F32,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G32,0)&\" due to \"&TEXT('Gen Info'!H32,0)&IF('Gen Info'!I32=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I32=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J32=\"Yes\",\" Unit passed.\",IF('Gen Info'!I32=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
[{"$f":"TEXT('Gen Info'!B33,0)&\" Model: \"&TEXT('Gen Info'!C33,0)&\",  Serial Number: \"&TEXT('Gen Info'!D33,0)&\".\"&\" Pre-test diagnosis was to \"&TEXT('Gen Info'!E33,0)&\" because \"&TEXT('Gen Info'!F33,0)&\" Post-test diagnosis was \"&TEXT('Gen Info'!G33,0)&\" due to \"&TEXT('Gen Info'!H33,0)&IF('Gen Info'!I33=\"Yes\",\" A refrigerant charge was added.\",IF('Gen Info'!I33=\"No\",\" Charge addition not necessary.\",\" Unit was rejected due to not meeting minimum requirements.\"))&IF('Gen Info'!J33=\"Yes\",\" Unit passed.\",IF('Gen Info'!I33=\"No\",\" Unit was rejected due to not meeting minimum requirements.(See notes)\"))","v":{"$error":"#REF!"}}]
["Comments"]
[]
[]
[]
["Recommended Incentive:"]
["Measure",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantity",null,null," Incentive"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Requested Incentive Amount Based on Application:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Applicant Info'!F25","v":0}]
["Recommended Incentive Amount Based on Inspection:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Gen Info","index":5,"n_rows":38,"n_cols":32,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,5,7,6],[7,2,7,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[8,2,8,3],[15,2,15,3],[16,2,16,3],[15,5,15,6],[12,5,12,6],[11,5,11,6],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,5,13,6],[14,2,14,3],[14,5,14,6],[10,5,10,6],[47,30,48,30],[48,1,49,1],[48,2,49,2],[48,3,49,3],[48,4,49,4],[48,6,49,6],[48,7,49,7],[39,0,39,10],[13,2,13,3],[53,0,53,10],[42,10,43,10],[44,6,45,6],[47,1,47,7],[41,1,41,7],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,6,43,6],[42,7,43,7],[19,2,19,3],[19,4,19,5],[19,6,19,7]]}
[]
["Advanced AC Tune-up"]
["General Project Information"]
[]
[null,"General Information"]
[null,"Project Name:",{"$f":"'Inspection Report'!F8","v":0},null,"Street Address:",{"$f":"+'Applicant Info'!E18","v":0}]
[null,"Project Number:",{"$f":"+'Applicant Info'!J3","v":0},null,"City, State:",{"$f":"+'Applicant Info'!E21","v":0}]
[null,"Number of Units:",{"$f":"SUM(C9:D17)+SUM(F9:G16)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:D17,F9:G15)","v":{"$error":"#REF!"}},"# of units","# of Circuits","Pre-Test Diagnosis was to…","because…","Post-test diagnosis was…","due to..","Ref. Charge","Unit Rejected"]
[null,"3-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"12.5-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,"check for leaks and repair","it did not meet size requirements.","that it did not qualify","failed post test.","Yes","Yes"]
[null,"4-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"15-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,"tune up high-side","safe and reasonable performance.","that no further repair is needed","safe and reasonable performance.","No","No"]
[null,"5-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"17.5-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,"tune up low-side","a Refrigerant Flow Restriction.","to check for leaks and repair","unknown reasons"]
[null,"6-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"20-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,"leave as-is","it's overcharged.","to tune up high-side","customer declined repairs"]
[null,"7.5-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"25-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"not tune up unit","a High Side Heat Transfer problem.","to tune up low-side"]
[null,"8-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"30-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"make a major repair","a Low Side Heat Transfer problem.","not conducted"]
[null,"9-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"35-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"recover charge","improper evaporator airflow."]
[null,"10-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,"40-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,"it was undercharged."]
[null,"11-ton",{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH(#REF!,#REF!,0)),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,"faulty txV valve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,"it's a TxV unit with hot condensor and high SC."]
[null,"Project Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,"it's a fixed orifice unit with cold evap and high SH."]
[null,"Name:",{"$f":"'Applicant Info'!A15","v":0},null,"Phone:",null,{"$f":"'Applicant Info'!D16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,"this is a fixed orifice unit with high superheat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Building Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,"Unit Name","Model","Serial #","Pre-Test Diagnosis","Because…","Post-test","due to…","Ref. Charge Added? Yes/No","Unit Passed? Yes/No","Notes",null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,"RTU-1",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,"RTU-2",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,"RTU-3",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,"RTU-4",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,"RTU-5",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,"RTU-6",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,"RTU-7",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,"RTU-8",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-9",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-10",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-11",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-12",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-13",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-14",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"RTU-15",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Pictures","index":6,"n_rows":5,"n_cols":22,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,3,18],[0,19,0,23],[1,19,3,23],[4,0,4,5],[4,6,4,18],[4,19,4,20],[4,21,4,23]]}
["    Post Inspection Pictures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Applicant Info'!J3","v":0}]
[]
[]
["Project Name:",null,null,null,null,null,{"$f":"+'Applicant Info'!A13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"+'Applicant Info'!K6","v":"00:00:00"}]