{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["HOME","Applicant Info","Checklist","Terms & Conditions","Multi-Facility","Interior Lighting","Exterior Lighting","HVAC","Food Service","Pool Pumps","Industrial","Custom","NC Whole Bldg"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":10,"defined_names":288,"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":[[13,9,13,12],[0,0,1,1],[5,0,5,3],[13,6,13,8],[14,6,14,8],[7,6,8,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[11,1,13,4],[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],[6,6,6,8]]}
[null,null,"2024 New Construction Application 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":"Applicant Info","index":1,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[47,5,47,8],[47,9,47,10],[0,3,0,8],[3,0,3,5],[3,6,3,8],[26,8,26,10],[23,6,23,7],[25,0,25,3],[25,4,25,5],[25,6,25,7],[24,4,24,10],[16,6,16,10],[0,0,0,1],[10,0,10,5],[21,0,21,3],[5,2,5,3],[20,6,20,7],[20,8,20,10],[19,0,19,5],[19,6,19,10],[45,0,45,10],[30,0,30,3],[30,4,30,10],[32,6,32,7],[31,0,31,3],[31,4,31,10],[26,0,26,3],[35,7,36,10],[0,9,0,10],[47,0,47,4],[5,7,5,8],[58,0,58,4],[49,0,49,10],[9,0,9,10],[52,0,52,10],[50,0,50,10],[51,0,51,10],[29,6,29,8],[32,0,32,3],[32,4,32,5],[29,9,29,10],[27,0,27,10],[29,4,29,5],[29,0,29,3],[62,1,62,4],[37,4,37,10],[37,0,37,3],[40,3,40,5],[33,0,33,10],[42,6,42,7],[38,0,38,5],[40,6,40,7],[54,5,54,6],[56,7,56,10],[58,7,58,10],[56,0,56,4],[38,6,38,10],[46,9,46,10],[46,0,46,4],[46,5,46,8],[16,0,16,5],[44,4,44,5],[14,0,14,5],[15,0,15,5],[10,6,10,8],[22,4,22,10],[22,0,22,3],[43,0,43,3],[43,4,43,10],[41,0,41,3],[23,0,23,3],[24,0,24,3],[23,4,23,5],[42,0,42,3],[41,4,41,10],[26,4,26,5],[7,7,7,8],[6,7,6,8],[13,6,13,10],[44,8,44,10],[28,4,28,10],[40,8,40,10],[39,0,39,5],[39,6,39,10],[28,0,28,3],[17,0,17,5],[17,6,17,10],[18,6,18,10],[18,0,18,5],[21,4,21,10],[20,3,20,5],[42,4,42,5],[54,0,54,4],[53,0,53,4],[55,0,55,4],[57,0,57,4],[53,7,53,10],[54,7,54,10],[55,7,55,10],[57,7,57,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,"New Construction",null,null,null,null,"Pre-Notification",null,"Date",null,null,null,null,null,{"$f":"IF(G6>0,\"Yes\",)","v":0}]
[null,null,null,null,null,null,null,"or",null,null,null,null,null,null,"New pre notification checkbox flag:"]
[null,null,null,null,null,null,null,"Final Application",null,"Date",null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Customer Information*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifacility checkbox flag:"]
["PNM Account Number where measures installed ",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"This Application represents multiple accounts / premises",null,null,null,"1. Enter number of Accounts / Premises ------->",null,null,null,"_________",null,null,{"$f":"is","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,"2. If yes: Complete Multi-Facility Worksheet -------> CLICK HERE"]
["Building Type*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Business Type",null,"Tax Status",null,"State"]
["Name of Company*",null,null,null,null,null,"Name Exactly as it Appears on Your Utility Bill*",null,null,null,null,null,"Assembly",null,"Corporation (Inc, PC, etc.)",null,"AL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"College/University",null,"Government Agency",null,"AK"]
["Name of Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,"Grocery",null,"Individual",null,"AZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Heavy Industry",null,"Partnership",null,"AR"]
["Telephone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,"Hotel/Motel Common Areas",null,"Exempt",null,"CA"]
["Email Address*",null,null,null,null,null,null,null,null,null,null,null,"Light Industry",null,null,null,"CO"]
["Address Where Measures Installed*",null,null,null,null,null,null,null,null,null,null,null,"Medical",null,null,null,"CT"]
["City Where Measures Installed*",null,null,null,null,null,"State*",null,{"$f":"IF(E24=\"\",\"\",\"NM\")","v":""},"Zip*",null,null,"Office",null,null,null,"DE"]
["Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,"Restaurant",null,null,null,"FL"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,"Retail/Service",null,null,null,"GA"]
["Taxpayer ID Number (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,"K-12 School",null,null,null,"HI"]
["Contractor Information",null,null,null,null,null,null,null,null,null,null,null,"Warehouse",null,null,null,"ID"]
["Contracting Company*",null,null,null,null,null,null,null,null,null,null,null,"Dwelling Unit",null,null,null,"IL"]
["Contractor Name*",null,null,null,null,null,"Contractor Phone Number*",null,null,null,null,null,"Miscellaneous",null,null,null,"IN"]
["Contractor Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
["Contractor Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"KY"]
["Third Party Payment Release",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,"I request that the incentive check be sent to the third party below",null,null,null,null,"Check here if the third party payee is the contractor (Contractor must be a PNM Authorized Contractor to be eligible for third party payment)",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"]
["Name of Third Party*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
["Name of Third Party Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
["Third Party Phone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,null,null,null,null,"MO"]
["Third Party Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
["Third Party City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"NE"]
["Third Party Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
["Third Party Taxpayer ID # (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,null,null,null,null,"NH"]
["Incentive Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
["Total Incentive Requested",null,null,null,null,"Total Project Cost  PRE-TAX * REQUIRED *",null,null,null,{"$f":"IF(AND(O8=TRUE,P9=TRUE),\"Project Completion Date\",IF(O8=TRUE, \"Estimated Project Completion Date\", \"Project Completion Date\"))","v":"Project Completion Date"},null,null,null,null,null,null,"NM"]
[{"$f":"MIN(F63, F48*0.5,400000)","v":0},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"]
["AGREEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
["I understand that in the event funds are reserved based on a pre-notification, the payment of incentives will be based upon the Final Application and program terms and conditions, and that the PNM Business Energy Efficiency program is subject to change or cancellation at any time and without notice. PNM is not responsible for any lost, late, stolen, ineligible, illegible, misdirected or postage-due mail. All completed submissions become the property of PNM and will not be returned. PNM makes no guarantees about the availability of products or rebate forms. By participating in the PNM Business Energy Efficiency program, customers agree to waive any claims and release PNM from any liability for damages of any kind. Rebates are funded by a charge on PNM electric customer bills.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
["I have read and understand the program requirements, measure specifications, and Terms & Conditions set forth in this application and agree to abide by those requirements. Furthermore, I concur that I must meet all eligibility criteria in order to be paid under this program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
["As an eligible customer, I verify that the signature below is my own and that the information is correct. I am requesting consideration for participation under this program. By signing this agreement I attest that I understand and agree to abide by all Program terms and conditions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
["Customer Signature (PNM Customer)",null,null,null,null,null,null,"Third Party Signature",null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,"Please sign by hand or via DocuSign®",null,null,null,null,null,null,null,null,null,null,"RI"]
["Print Customer Name",null,null,null,null,null,null,"Print Third Party Name",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"]
["Date",null,null,null,null,null,null,"Date",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,"For Office Use Only",null,null,null,{"$f":"SUM(F64:F71)","v":0},null,null,null,null,null,null,null,null,null,null,"WA"]
[null,"NC Interior Lighting Incentive",null,null,null,{"$f":"'Interior Lighting'!H23","v":0},null,null,null,null,null,null,null,null,null,null,"WI"]
[null,"NC Exterior Lighting Incentive",null,null,null,{"$f":"'Exterior Lighting'!L24","v":0},null,null,null,null,null,null,null,null,null,null,"WV"]
[null,"HVAC Incentive",null,null,null,{"$f":"HVAC!H79","v":0},null,null,null,null,null,null,null,null,null,null,"WY"]
[null,"Food Service Incentive",null,null,null,{"$f":"'Food Service'!J42","v":0}]
[null,"Pool Pumps Incentive",null,null,null,{"$f":"'Pool Pumps'!J10","v":0}]
[null,"Industrial Incentives",null,null,null,{"$f":"Industrial!I44","v":0}]
[null,"Custom Incentive",null,null,null,{"$f":"Custom!I51","v":0}]
[null,"NC Whole Building Incentives",null,null,null,{"$f":"'NC Whole Bldg'!I55","v":0}]

{"sheet":"Checklist","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,1,41,2],[42,1,42,2],[28,1,28,2],[39,0,39,2],[26,0,26,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[29,1,29,2],[30,1,30,2],[3,0,3,2],[1,0,1,2],[40,1,40,2],[24,0,24,2],[21,0,21,2],[17,0,17,2],[31,1,31,2],[32,1,32,2],[22,1,22,2],[23,1,23,2],[18,1,18,2],[34,1,34,2],[35,1,35,2],[0,0,0,3],[14,1,14,2],[2,1,2,2],[33,0,33,2],[27,0,27,2],[12,0,12,2],[9,0,9,2],[4,0,4,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[25,1,25,2]]}
[]
["1) Verify"]
[null,"Submit application within 6 months of project completion, and include the following components:"]
["2) Application Information Form"]
["CUSTOMER INFORMATION"]
[null,"Customer name is the same as it appears on PNM bills."]
[null,"PNM account number is complete and accurate (NOTE: New Construction account information may not be available for Pre-Notification, but is required for the Final Application.)"]
[null,"Taxpayer ID is complete and accurate."]
[null,"First-time customers/payees MUST submit IRS From W-9 with application."]
["CONTRACTOR INFORMATION"]
[null,"Provide complete contact information for project contractor. (We may need to contact your contractor to verify any project details.)"]
[null,"If the job is completed by in-house staff, list Contractor as \"done-in-house.\""]
["INCENTIVE CHECK INFORMATION"]
[null,"Complete contact information and taxpayer ID."]
[null,"Indicate whether the customer or a third party should receive the check. If a third party is to receive the check:"]
[null,null,"Customer must check box indicating third party payment."]
[null,null,"Both the customer and third party must sign the Agreement Form."]
["3) Total Incentives Required"]
[null,"Fill out the following sections:"]
[null,null,"Total Project Cost (pre-tax)"]
[null,null,"Project Completion Date"]
["4) Terms & Conditions of Applications"]
[null,"Customer must read and agree with the Terms & Conditions of the PNM Business Energy Efficiency Program."]
[null,"If a third party is applying on behalf of the customer, customer must sign the Agreement Form, allowing the third party to sign the application on the customer's behalf."]
["5) Incentive Worksheets"]
[null,"Complete the incentive worksheet for each application measure (e.g., lighting, HVAC, refrigeration). Calculations are included where required (e.g., occupancy sensors)."]
["6) Additional Documentation"]
["FOR PRE-APPLICATION"]
[null,"Submit cost estimate or purchase order that lists the installation address, which must be in PNM service territory."]
[null,"Submit Agreement between Owner and General Contractor."]
[null,"Submit construction drawings (electrical and mechanical)."]
[null,"Submit interior/exterior lighting COMchecks (or) Energy Star Target Finder."]
[null,"Submit project manual."]
["FOR FINAL APPLICATION"]
[null,"Submit invoices dated no more than 6 months prior to rebate application date."]
[null,"List the installation address, which must be in PNM service territory, on invoices."]
[null,"Provide approved submittal or manufacturer's specification sheet for each measure installed (e.g., lamp, ballast, controls, refrigerator, freezer, ice machine, etc.)."]
[null,"Ensure specification sheets include all program eligibility requirements for the measure (e.g., CRI of lamps, ballast factors, IPLV for AC units, etc.). Note: AHRI (Air-conditioning, Heating, and Refrigeration Institute) offers a helpful website for cooling specifications at www.ahridirectory.org."]
[null,"Submit General Contractor Pay Application."]
["7) Submit Application"]
[null,"Submit completed application to PNM Business Energy Efficiency Program via email (preferred), fax, or postal mail. All contact information is on the HOME tab of this document."]
[null,"If submitting via email, pring a hard copy of the AGREEMENT section of the Applicant Info tab, sign, scan, and email. If using DocuSign® please attach both the completed Excel application and the signed Docusign® PDF. Preferred file type for the completed application is in Excel, while supporting documents are preferred as PDFs."]
[null,"Print a full, final hard copy of all pages of your application for your records."]

{"sheet":"Terms & Conditions","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["TERMS & CONDITIONS"]

{"sheet":"Multi-Facility","index":4,"n_rows":446,"n_cols":7,"rows_kept":446,"cut":false,"hidden":false,"merged":[[4,3,4,4],[5,1,5,2],[7,0,7,4],[0,0,0,6]]}
["LIGHTING MULTIPLE FACILITY WORKSHEET"]
["Use this worksheet ONLY if installing the SAME measure in facilities with different service addresses and unique account numbers."]
["If a project encompasses multiple buildings at the same premise, this worksheet is not required."]
["For official use only","Pre-Notification Date:",{"$f":"IF(ISBLANK('Applicant Info'!$K$6),\" \",'Applicant Info'!$K$6)","v":" "},"Final Application Date:",{"$f":"IF(ISBLANK('Applicant Info'!$K$8),\" \",'Applicant Info'!$K$8)","v":" "}]
["Application #",null,"Business Name:",{"$f":"IF(ISBLANK('Applicant Info'!$A$18),\" \",'Applicant Info'!$A$18)","v":" "}]
["Prepared by:",{"$f":"IF(ISBLANK('Applicant Info'!$A$20),\" \",'Applicant Info'!$A$20)","v":" "},null,"Contact #:",{"$f":"'Applicant Info'!$D$21","v":0}]
[]
["Project Locations "]
["Service Address","Account #","Replacement Equipment Type 1","Replacement Equipment Type 2","Replacement Equipment Qty","Existing Equipment Description","Existing Equipment Qty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,null,{"$f":"SUM(E10:E34)","v":0},null,{"$f":"SUM(G10:G34)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Measure Type 1"]
["Interior Lighting"]
["Exterior Lighting"]
["24/7 Lighting"]
["Plug Load Controls"]
["Custom"]
["HVAC"]
["Envelope"]
["Refrigeration"]
["Food Service Equipment"]
["Motors"]
["VSDs"]
[]
["Measure Type 1","Measure Type 2","Unit","Incentive",null,"Measure Type 1"]
["Interior Lighting","Screw-in Compact Fluorescent Lights 5-15 Watts","Lamp",1,null,"Interior Lighting"]
["Interior Lighting","Screw-in Compact Fluorescent Lights 16-26 Watts","Lamp",1,null,"Exterior Lighting"]
["Interior Lighting","Screw-in Compact Fluorescent Lights 27 Watts or higher","Lamp",2,null,"24/7 Lighting"]
["Interior Lighting","Screw-in Compact Fluorescent Lights  Inside Dwelling Units 5-15 Watts","Lamp",1,null,"HVAC"]
["Interior Lighting","Screw-in Compact Fluorescent Lights  Inside Dwelling Units 16-26 Watts","Lamp",1,null,"Envelope"]
["Interior Lighting","Screw-in Compact Fluorescent Lights  Inside Dwelling Units 27 Watts or higher","Lamp",2,null,"Refrigeration"]
["Interior Lighting","Hardwired Compact Fluorescent Fixtures 29W or Less","Fixture",20,null,"Food Service Equipment"]
["Interior Lighting","Hardwired Compact Fluorescent Fixtures 30W or Greater","Fixture",40,null,"Plug Load Controls"]
["Interior Lighting","Hardwired Compact Fluorescent Lights  Inside Dwelling Units 29W or Less","Fixture",5,null,"Motors"]
["Interior Lighting","Hardwired Compact Fluorescent Lights  Inside Dwelling Units 30W or Greater","Fixture",10,null,"VSDs"]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 2-ft Lamp - T12 basecase","Lamp Removed",4.5]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 3-ft Lamp - T12 basecase","Lamp Removed",6]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 4-ft Lamp - T12 basecase","Lamp Removed",7.5]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 8-ft Lamp - T12 basecase","Lamp Removed",15]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 2-ft Lamp - T8 basecase","Lamp Removed",3]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 3-ft Lamp - T8 basecase","Lamp Removed",4]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 4-ft Lamp - T8 basecase","Lamp Removed",5]
["Interior Lighting","Permanent Removal of Lamp from Existing Fixture 8-ft Lamp - T8 basecase","Lamp Removed",10]
["Interior Lighting","High Performance (HP) T8 or Reduced Wattage (RW) 4-Foot T8 and Electronic Ballast 4-ft HP Lamp and Ballast","Lamp",6]
["Interior Lighting","High Performance (HP) T8 or Reduced Wattage (RW) 4-Foot T8 and Electronic Ballast  4-ft RW Lamp and Ballast","Lamp",6]
["Interior Lighting","High Performance (HP) T8 or Reduced Wattage (RW) 4-Foot T8 and Electronic Ballast  1 Lamp 8-ft T12 to 2 Lamp 4-ft HP T8","Lamp",6]
["Interior Lighting","High Performance (HP) T8 or Reduced Wattage (RW) 4-Foot T8 and Electronic Ballast  1 Lamp 8-ft T12 to 2 Lamp 4-ft RW T8","Lamp",6]
["Interior Lighting","Standard T8 and Electronic Ballast 2-ft Lamp and Ballast","Lamp",3]
["Interior Lighting","Standard T8 and Electronic Ballast 3-ft Lamp and Ballast","Lamp",3]
["Interior Lighting","Standard T8 and Electronic Ballast 4-ft or U-Tube and Ballast","Lamp",3]
["Interior Lighting","T12 to T5 Lamps and Ballast","Lamp",6]
["Interior Lighting","Reduced Wattage 8 Foot T8 and Electronic Ballast 8-foot T12 to RW T8 ","Lamp",6]
["Interior Lighting","Reduced Wattage (RW) 4-Foot OR 8-Foot T8 LAMP ONLY 4-ft T8 Reduced Wattage Lamp Only","Lamp",0.5]
["Interior Lighting","Reduced Wattage (RW) 4-Foot OR 8-Foot T8 LAMP ONLY 8-ft T8 Reduced Wattage Lamp Only","Lamp",0.5]
["Interior Lighting","New High Bay T8/T5 Fluorescent Fixtures with Electronic Ballast replacing HID T8/T5 (w/ electronic ballast)","Watt Reduction***",0.3]
["Interior Lighting","LED Lighting LED, T-1, or Electroluminescent Exit Signs","Sign",20]
["Interior Lighting","LED Lighting LED Lamp *NEW Higher Rebate!","Lamp",12]
["Interior Lighting","LED Lighting LED Recessed Downlight Fixture *NEW Higher Rebate!","Fixture",20]
["Interior Lighting","LED Lighting LED Open Sign","Sign",25]
["Interior Lighting","LED Lighting LED Channel Sign ≤ 2 feet Interior","Letter",8]
["Interior Lighting","LED Lighting LED Channel Sign > 2 feet Interior","Letter",16]
["Interior Lighting","High Efficiency HID Fixture Integrated Ballast Ceramic Metal Halide Lamps","Fixture",8]
["Interior Lighting","High Efficiency HID Fixture Metal Halide (Pulse Start or Ceramic) 100W or Less","Fixture",20]
["Interior Lighting","High Efficiency HID Fixture Metal Halide (Pulse Start or Ceramic) 101W - 200W","Fixture",25]
["Interior Lighting","High Efficiency HID Fixture Metal Halide (Pulse Start or Ceramic) 201W - 350W","Fixture",45]
["Interior Lighting","High Efficiency HID Fixture Metal Halide (Pulse Start or Ceramic) 351W - 400W","Fixture",65]
["Interior Lighting","Specialty Lamps Cold Cathode","Lamp",3]
["Interior Lighting","Specialty Lamps Dimmable; 3-way; Locking Base CFL","Lamp",5]
["Interior Lighting","Specialty Lamps Dimmable; 3-way; Locking Base CFL (dwelling units)","Lamp",3]
["Interior Lighting","Controls  Occupancy Sensors","Watts Controlled",0.06]
["Interior Lighting","Controls  Daylighting Sensor Controls","Watts Controlled",0.06]
["Exterior Lighting","Exterior LED Lighting LED Channel Sign ≤ 2 feet Exterior","Letter",8]
["Exterior Lighting","Exterior LED Lighting LED Channel Sign > 2 feet Exterior","Letter",16]
["Exterior Lighting","Exterior LED Lighting Bi-Level LED Parking Lot Fixture","Fixture",60]
["Exterior Lighting","Exterior LED Lighting Bi-Level LED Wall Pack Fixture","Fixture",60]
["Exterior Lighting","Exterior Specialty Lamps Cold Cathode","Lamp",3]
["Exterior Lighting","Exterior Specialty Lamps CFL - High Wattage (>40W) Screw-In , Dimmable, or 3-way","Lamp",15]
["Exterior Lighting","Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 100W or Less","Fixture",20]
["Exterior Lighting","Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 101W - 200W","Fixture",25]
["Exterior Lighting","Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 201W - 350","Fixture",45]
["Exterior Lighting","Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 351W - 400W","Fixture",65]
["Exterior Lighting","Outdoor Area or Street Lights LED or Induction replacing 175W or Less HID","Fixture",40]
["Exterior Lighting","Outdoor Area or Street Lights LED or Induction replacing 176W - 250W HID","Fixture",50]
["Exterior Lighting","Outdoor Area or Street Lights LED or Induction replacing 251W - 400W HID","Fixture",60]
["Exterior Lighting","Exterior Hardwired Compact Fluorescent Fixtures 29W or Less","Fixture",20]
["Exterior Lighting","Exterior Hardwired Compact Fluorescent Fixtures 30W or Greater","Fixture",40]
["24/7 Lighting","24/7 LED Lighting Bi-Level LED Parking Lot Fixture","Fixture",60]
["24/7 Lighting","24/7 LED Lighting Bi-Level LED Wall Pack Fixture","Fixture",60]
["24/7 Lighting","24/7 Specialty Lamps Cold Cathode","Lamp",3]
["24/7 Lighting","24/7 Specialty Lamps CFL - High Wattage (>40W) Screw-In (Exterior ONLY)","Lamp",15]
["24/7 Lighting","24/7 Specialty Lamps CFL - Dimmable, or 3-way","Lamp",15]
["24/7 Lighting","24/7 Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 100W or Less","Fixture",20]
["24/7 Lighting","24/7 Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 101W - 200W","Fixture",25]
["24/7 Lighting","24/7 Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 201W - 350","Fixture",45]
["24/7 Lighting","24/7 Outdoor Area or Street Lights Metal Halide (Pulse Start or Ceramic) 351W - 400W","Fixture",65]
["24/7 Lighting","24/7 Outdoor Area or Street Lights LED or Induction replacing 175W or Less HID","Fixture",40]
["24/7 Lighting","24/7 Outdoor Area or Street Lights LED or Induction replacing 176W - 250W HID","Fixture",50]
["24/7 Lighting","24/7 Outdoor Area or Street Lights LED or Induction replacing 251W - 400W HID","Lamp",60]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Green 8\"","Lamp",10]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Green 12\"","Lamp",20]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Red 8\"","Lamp",10]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Red 12\"","Lamp",20]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Walk/Don't Walk or Arrow - 9\"","Lamp",5]
["24/7 Lighting","24/7 Traffic and Pedestrain Signals LED traffic lights - Walk/Don't Walk or Arrow - 12\"","Lamp",5]
["24/7 Lighting","24/7 New T8/T5 Fluorescent Fixtures with Electronic Ballast  replacing HID T8/T5 (w/ electronic ballast)","Watt Reduction***",0.3]
["24/7 Lighting","24/7 Controls Bi-Level Stairwell/Hall/Garage Fixtures w/ integrated sensors","Fixture",20]
[]
[null,null,"Unit","Incentive"]
["Envelope","Window Film","Sq. Ft. of Glazing",1.2]
[]
[null,null,"Unit","Incentive"]
["Refrigeration","Strip Curtains on Walk-ins and Freezers","Sq. Ft.",3]
["Refrigeration","Night Covers for Displays","Lin. Ft. of Case",5]
["Refrigeration","EC Motor for Reach-in Refrigerator or Freezer Cases","Motor",25]
["Refrigeration","Evaporator Fan Controller - Shade Pole Motor","Motor",40]
["Refrigeration","Anti Sweat Heater Controls","Lin. Ft. of Case",20]
["Refrigeration","LED Refrigeration Case Lighting","Door",40]
["Refrigeration","ENERGY STAR® Solid Door Freezer","Unit",100]
["Refrigeration","ENERGY STAR® Glass Door Freezer","Unit",350]
[]
[null,null,"Unit","Incentive"]
["Food Service Equipment","ENERGY STAR® Steam Cookers","Unit",400]
["Food Service Equipment","Combination Oven","Unit",800]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - 1/2 size","Unit",200]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - 3/4 size","Unit",300]
["Food Service Equipment","ENERGY STAR® Hot Holding Cabinet - Full size","Unit",400]
["Food Service Equipment","ENERGY STAR® Beverage Vending Machine","Unit",80]
["Food Service Equipment","ENERGY STAR® Commercial Vat Fryer","Unit",225]
["Food Service Equipment","ENERGY STAR® Griddle","Unit",125]
[]
[null,null,"Unit","Incentive"]
["Plug Load Controls","Beverage Vending Machine Control","Unit","Contact for offer"]
["Plug Load Controls","Refrigerated Cooler Control","Unit","Contact for offer"]
["Plug Load Controls","Snack Machine Control","Unit","Contact for offer"]
["Plug Load Controls","Plug Load Occupancy Sensors","Unit",25]
[]
[null,null,"Unit","Incentive"]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
["Motors","1200 RPM -  1 HP - Open ","motor",1]
["Motors","1200 RPM -  1 HP - Open ","motor",1.5]
["Motors","1200 RPM -  1 HP - Open ","motor",2]
["Motors","1200 RPM -  1 HP - Open ","motor",3]
["Motors","1200 RPM -  1 HP - Open ","motor",4]
["Motors","1200 RPM -  1 HP - Open ","motor",9]
["Motors","1200 RPM -  1 HP - Open ","motor",10]
["Motors","1200 RPM -  1 HP - Open ","motor",11]
["Motors","1200 RPM -  1 HP - Open ","motor",12]
["Motors","1200 RPM -  1 HP - Open ","motor",15]
["Motors","1200 RPM -  1 HP - Open ","motor",17]
["Motors","1200 RPM -  1 HP - Open ","motor",20]
["Motors","1200 RPM -  1 HP - Open ","motor",24]
["Motors","1200 RPM -  1 HP - Open ","motor",25]
["Motors","1200 RPM -  1 HP - Open ","motor",30]
["Motors","1200 RPM -  1 HP - Open ","motor",40]
["Motors","1200 RPM -  1 HP - Open ","motor",50]
["Motors","1200 RPM -  1 HP - Open ","motor",60]
["Motors","1200 RPM -  1 HP - Open ","motor",75]
[]
[]
[null,null,"Unit","Incentive"]
["HVAC",null,"kWh",0.06]
[]
[null,null,"Unit","Incentive"]
["Custom",null,"kWh",7.4999999999999997E-2]

{"sheet":"Interior Lighting","index":5,"n_rows":105,"n_cols":17,"rows_kept":105,"cut":false,"hidden":false,"merged":[[8,0,8,3],[0,1,0,8],[20,4,20,5],[19,4,19,5],[20,2,20,3],[19,2,19,3],[20,0,20,1],[19,0,19,1],[2,0,2,8],[10,0,10,3],[11,0,11,3],[16,0,16,7],[1,0,1,1],[82,0,85,8],[12,0,12,3],[14,0,14,3],[15,0,15,3],[13,0,13,3],[22,0,22,6],[22,7,22,8],[20,7,20,8],[19,7,19,8],[9,0,9,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3]]}
[null,"NEW CONSTRUCTION INTERIOR LIGHTING INCENTIVES"]
["Applicant: fill in gray fields",null,null,null,null,null,null,"See specs at the bottom of the page!"]
["IMPORTANT NOTICE: Only approved LED lighting is eligible for a rebate; fluorescent and incandescent do not qualify."]
["Interior Lighting Power Density (for Areas with improvement over ASHRAE 90.1-2016)",null,null,null,null,null,null,null,null,null,null,null,null,null,"2021 V2"]
["Building Type",null,null,null,"Lighting Power Density1\n(W/ft2)","Actual LPD\n(W/ft2)","Building Area\n(ft2)","Watts Reduced","Incentive Subtotal \n($0.53/Watt)2",null,null,null,2019,"2020 20% over 2007","ASHRAE 90.1 2016","Avg of 2007 and 2016","% Improvement over 2007"]
[null,null,null,null,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,$L$6:$P$37,4,FALSE))","v":""},null,null,{"$f":"IF(E6=\"\",\"\",IF(AND(ISNUMBER(F6),E6-F6>0),(E6-F6)*G6,0))","v":""},{"$f":"IF(F6>E6,0,IF(ISNUMBER(F6),H6*0.53,0))","v":0},null,null,"Automotive",0.9,0.7,0.71,0.81,0.11111111111111116]
[null,null,null,null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,$L$6:$P$37,4,FALSE))","v":""},null,null,"",0,null,null,"Convention Center",1.2,1,0.76,0.98,0.22448979591836737]
[null,null,null,null,"",null,null,"",0,null,null,"Court House",1.2,1,0.9,1.05,0.14285714285714279]
[null,null,null,null,"",null,null,"",0,null,null,"Dining: Bar Lounge/Leisure",1.3,1,0.9,1.1000000000000001,0.18181818181818166]
[null,null,null,null,"",null,null,"",0,null,null,"Dining: Cafeteria/Fast Food",1.4,1.1000000000000001,0.79,1.1000000000000001,0.27272727272727249]
[null,null,null,null,"",null,null,"",0,null,null,"Dining: Family",1.6,1.3,0.78,1.19,0.34453781512605053]
[null,null,null,null,"",null,null,"",0,null,null,"Dormitory",1,0.8,0.61,0.81,0.23456790123456783]
[null,null,null,null,"",null,null,"",0,null,null,"Exercise Center",1,0.8,0.65,0.83,0.20481927710843384]
[null,null,null,null,"",null,null,"",0,null,null,"Fire Station",null,null,0.53,0.53]
[null,null,null,null,"",null,null,"",0,null,null,"Gymnasium",1.1000000000000001,0.9,0.68,0.89,0.23595505617977541]
[null,null,null,null,"",null,null,"",0,null,null,"Health Care",1,0.8,0.82,0.84,0.19047619047619047]
["Interior LPD Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I6:I16)","v":0},null,null,"Hospital",1.2,1,1.05,1.01,0.18811881188118806]
[null,null,null,null,null,null,null,null,null,null,null,"Hotel ",1,0.8,0.75,1.03,-2.9126213592232997E-2]
["Daylighting Controls",null,null,null,null,null,null,null,null,null,null,"Library",1.3,1,0.78,1.03,0.26213592233009719]
["Equipment",null,"Unit Incentive\n$/Watt",null,"Connected Watts\n(Total)",null,"# of Sensors","Incentive",null,null,null,"Manufacturing Facility",1.3,1,0.9,1.04,0.25]
["Daylighting Controls***",null,0.06,null,null,null,null,{"$f":"C21*E21","v":0},null,null,null,"Motion Picture Theatre",1,0.8,0.83,0.95,5.2631578947368363E-2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H22","v":0},"Multi-Family (Non-residential meter only)",1.2,1,0.68,1.02,0.17647058823529416]
["Total New Construction Interior Lighting Incentives",null,null,null,null,null,null,{"$f":"SUM(I6:I16,H21)","v":0},null,null,null,"Museum",0.7,0.5,1.06,0.69,1.449275362318847E-2]
["NOTES:",null,null,null,null,null,null,null,null,null,null,"Office",1.1000000000000001,0.9,0.79,1.08,1.8518518518518601E-2]
["1. Lighting Power Density Incentive for Areas with improvement over ASHRAE 90.1-2016",null,null,null,null,null,null,null,null,null,null,"Parking Garage",1,0.8,0.15,0.9,0.11111111111111116]
["2. Incentive = (LPD baseline - LPD actual) x area x $0.53",null,null,null,null,null,null,null,null,null,null,"Penitentiary",0.3,0.2,0.75,0.23,0.30434782608695632]
["3. A COMCheck document or PNM Interior LPD calculator with supporting calculations must accompany the final application",null,null,null,null,null,null,null,null,null,null,"Performing Arts Theater",1,0.8,1.18,0.88,0.13636363636363646]
["4. Manufacturer's specification sheets must accompany the final application",null,null,null,null,null,null,null,null,null,null,"Police/Fire Station",1.6,1.3,0.8,1.39,0.15107913669064765]
["4. This lighting incentive worksheet should be used for new construction or major renovation projects",null,null,null,null,null,null,null,null,null,null,"Post Office",1,0.8,0.67,0.9,0.11111111111111116]
["5. If the lighting project is for retrofit projects, please use the Retrofit Rebate application",null,null,null,null,null,null,null,null,null,null,"Religious Building",1.1000000000000001,0.9,0.94,0.89,0.23595505617977541]
["6. Include any lighting layout drawings for inspection purposes",null,null,null,null,null,null,null,null,null,null,"Retail",1.3,1,1.06,1.1200000000000001,0.16071428571428559]
[null,null,null,null,null,null,null,null,null,null,null,"School/University",1.5,1.2,0.81,1.28,0.171875]
[null,null,null,null,null,null,null,null,null,null,null,"Sports Arena",1.2,1,0.87,1.01,0.18811881188118806]
[null,null,null,null,null,null,null,null,null,null,null,"Town Hall",1.1000000000000001,0.9,0.8,0.99,0.11111111111111116]
[null,null,null,null,null,null,null,null,null,null,null,"Transportation",1.1000000000000001,0.9,0.61,0.95,0.15789473684210531]
[null,null,null,null,null,null,null,null,null,null,null,"Warehouse",1,0.8,0.48,0.81,0.23456790123456783]
[null,null,null,null,null,null,null,null,null,null,null,"Workshop",0.8,0.6,0.9,0.64,0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The following lighting equipment and applications are excluded from the calculation of interior lighting power. However, any such lighting shall not be exempt unless it is an addition to general lighting and is controlled by an independent control device."]
[]
[]
[]
["1. Display or accent lighting that is an essential element for the function performed in galleries, museums, and monuments."]
["2. Lighting that is integral to equipment or instrumentation and is installed by its manufacturer."]
["3. Lighting specifically designed for use only during medical or dental procedures and lighting integral to medical equipment."]
["4. Lighting integral to both open and glass-enclosed refrigerator and freezer cases."]
["5. Lighting integral to food warming and food preparation equipment."]
["6. Lighting specifically designed for the life support of nonhuman life forms."]
["7. Lighting in retail display windows, provided the display area is enclosed by ceiling-height partitions."]
["8. Lighting in interior spaces that have been specifically designated as a registered interior historic landmark."]
["9. Lighting that is an integral part of advertising or directional signage."]
["10. Exit signs."]
["11. Lighting that is for sale or lighting educational demonstration systems."]
["12. Lighting for theatrical purposes, including performance, stage, and film and video production."]
["13. Lighting for television broadcasting in sporting activity areas."]
["14. Casino gaming areas."]
["15. Furniture-mounted supplemental task lighting that is controlled by automatic shutoff and complies with Section 9.4.1.3(c)."]
["16. Mirror lighting in dressing rooms and accent lighting in religious pulpit and choir areas."]
["17. Parking garage transition lighting—lighting for covered vehicle entrances and exits from buildings and parking structures—that complies with"]
["Section 9.4.1.2(a) and 9.4.1.2(c) of ASHRAE 90.1-2016; each transition zone shall not exceed a depth of 66 ft inside the structure and a width of "]
["50 ft."]

{"sheet":"Exterior Lighting","index":6,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,3,0,7],[2,0,2,11],[4,0,4,2],[5,0,5,2],[49,0,52,11],[1,0,1,1],[23,0,23,10],[12,0,12,2],[13,0,13,2],[22,0,22,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[20,0,20,2],[21,0,21,2],[6,0,6,2],[7,0,7,2],[14,0,14,2],[15,0,15,2]]}
[null,null,null,"NEW CONSTRUCTION EXTERIOR LIGHTING INCENTIVES"]
["Applicant: fill in gray fields",null,null,null,null,null,null,null,null,"See specs at the bottom of the page!"]
["IMPORTANT NOTICE: Only approved LED lighting is eligible for a rebate; fluorescent and incandescent do not qualify."]
["Exterior Lighting Power Density (for Areas with improvement over ASHRAE 90.1-2016)"]
["SURFACE TYPE",null,null,"Area or Length","Allowed LPD1\n(W/ft2, ft or location)","Fixture Description","Building Area, Length or Qty","Number of Fixtures","Fixture Wattage","Total Wattage","Actual LPD (W/ft2, ft or location)","Incentive Subtotal 2\n($0.63/Watt)",null,null,null,"ASHRAE 90.1 2016"]
[null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(A6,$O$6:$U$26,3,FALSE),\"\")","v":""},{"$f":"(_xlfn.IFNA(ROUND(VLOOKUP(A6,$O$6:$U$26,2,FALSE),2),\"\"))","v":""},null,null,null,null,{"$f":"IF(I6=\"\", \" \", H6*I6)","v":" "},{"$f":"(IF(OR(F6=\"\",G6=\"\"),\"\",ROUNDDOWN(J6/G6,2)))","v":""},{"$f":"IF(OR(A6=\"\",H6=\"\",J6=0), \" \", IF(K6>E6,0,(E6-K6)*0.63*G6))","v":" "},null,null,"Uncovered Parking Lots and Drives",0.06,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Walkway less than 10' Wide",0.6,"Length"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Walkway 10' Wide or Greater",0.11,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Plaza Areas",0.11,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Special Feature Areas",0.11,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Dining Areas",0.75,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Stairways",0.7,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Landscaping",0.04,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Main Entries - Pedestrian and vehicular",21,"Length"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Entry - Canopies and Overhangs",0.4,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Loading Docks",0.35,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Sales Canopy - Free standing and attached",0.6,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Outdoor Sales Open Area",0.35,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Outdoor Sales Street Frontage",7,"Length"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Building Façade - Area",0.15,"Area"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Building Façade - Length",3.75,"Length"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Automated Teller Machines",135,"Location"]
[null,null,null,"","",null,null,null,null," ",""," ",null,null,"Gatehouse Inspection Stations",0.5,"Area"]
["New Construction Exterior Lighting Incentive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L23)","v":0},null,null,"Loading for Law Enforcement",0.35,"Area"]
["NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Drive Through Windows",200,"Location"]
["1. Lighting Power Density Incentive for Areas with improvement over ASHRAE 90.1-2016",null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking Near 24 Hour Retail",400,"Entry"]
["2. Incentive = (LPD baseline - LPD actual) x area x $0.63"]
["3. A COMCheck document or supporting calculations must accompany the final application"]
["4. Manufacturer's specification sheets must accompany the final application"]
["4. This lighting incentive worksheet should be used for new construction or major renovation projects"]
["5. If the lighting project is for retrofit projects, please use the Retrofit Rebate application"]
["6. Include any lighting layout drawings for inspection purposes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The following are exempt for both lighting used for exterior applications when equipped with a complying control device and is independent of the control of the nonexempt lighting, and lighting used for exterior applications when controlled seperately."]
[]
[]
[]
["1. Lighting used for the following exterior applications is exempt when equipped with a control device that complies with the requirements of Section 9.4.1.4 of ASHRAE 90.1-2016, and is "]
["independent of the control of the nonexempt lighting:"]
["     a. Lighting that is integral to signage and installed in the signage by the manufacturer."]
["     b. Lighting for athletic playing areas."]
["     c. Lighting for industrial production, material handling, transportation sites, and associated storage areas."]
["     d. Theme elements in theme/amusement parks."]
["     e. Lighting used to highlight features of public monuments, public art displays, and registered historic landmark structures or buildings."]
["     f. Lighting for water features."]
["2. Lighting used for the following exterior applications is exempt when controlled separately:"]
["     a. Specialized signal, directional, and marker lighting associated with transportation."]
["     b. Lighting integral to equipment or instrumentation and installed by its manufacturer."]
["     c. Lighting for theatrical purposes, including performance, stage, film production, and video production."]
["     d. Temporary lighting."]
["     e. Lighting for hazardous locations."]
["     f. Lighting for swimming pools."]
["     g. Searchlights."]

{"sheet":"HVAC","index":7,"n_rows":153,"n_cols":50,"rows_kept":153,"cut":false,"hidden":false,"merged":[[14,9,15,9],[16,9,17,9],[18,9,19,9],[20,8,29,8],[75,2,75,3],[53,4,53,5],[55,6,55,7],[53,6,53,7],[30,7,31,7],[49,6,49,7],[44,4,44,5],[44,6,44,7],[45,4,45,5],[45,6,45,7],[46,4,46,5],[46,6,46,7],[47,4,47,5],[47,6,47,7],[30,3,30,5],[30,8,31,8],[51,6,51,7],[74,4,74,5],[72,2,72,3],[14,6,15,6],[78,0,78,6],[72,4,72,5],[78,7,78,8],[56,0,56,7],[55,4,55,5],[75,4,75,5],[73,4,73,5],[54,4,54,5],[54,6,54,7],[72,0,72,1],[76,0,76,7],[73,0,73,1],[74,0,74,1],[75,0,75,1],[73,2,73,3],[74,2,74,3],[64,1,64,8],[65,1,65,8],[66,1,66,8],[67,1,67,8],[63,1,63,8],[13,7,19,7],[13,8,19,8],[32,8,33,8],[48,4,48,5],[48,6,48,7],[18,6,19,6],[49,4,49,5],[38,0,40,2],[13,0,19,2],[18,3,19,5],[14,3,15,5],[34,0,37,2],[34,3,34,5],[35,3,35,5],[37,3,37,5],[26,3,26,5],[21,3,21,5],[25,0,29,2],[29,3,29,5],[25,3,25,5],[20,0,24,2],[23,3,23,5],[28,3,28,5],[22,3,22,5],[13,3,13,5],[33,3,33,5],[27,3,27,5],[20,3,20,5],[24,3,24,5],[32,3,32,5],[36,3,36,5],[4,16,12,16],[4,17,12,17],[5,12,6,14],[5,15,6,15],[7,12,8,14],[7,15,8,15],[32,0,32,2],[33,0,33,2],[16,3,17,5],[5,3,6,5],[4,3,4,5],[30,0,31,2],[31,3,31,5],[7,6,8,6],[9,6,10,6],[11,6,12,6],[5,6,6,6],[11,3,12,5],[16,6,17,6],[7,3,8,5],[9,3,10,5],[20,7,29,7],[5,9,6,9],[7,9,8,9],[9,12,10,14],[9,15,10,15],[11,12,12,14],[11,15,12,15],[1,1,1,6],[0,1,0,5],[3,12,3,14],[4,11,12,11],[4,12,4,14],[3,0,3,2],[1,7,1,8],[9,9,10,9],[11,9,12,9],[3,3,3,5],[4,0,12,2],[4,7,12,7],[4,8,12,8],[20,17,29,17],[13,11,19,11],[13,12,13,14],[13,16,19,16],[13,17,19,17],[14,12,15,14],[14,15,15,15],[16,12,17,14],[16,15,17,15],[18,12,19,14],[18,15,19,15],[25,12,25,14],[28,12,28,14],[29,12,29,14],[25,11,29,11],[20,12,20,14],[23,12,23,14],[24,12,24,14],[21,12,21,14],[22,12,22,14],[20,11,24,11],[26,12,26,14],[27,12,27,14],[20,16,29,16],[32,12,32,14],[35,7,37,7],[38,7,40,7],[57,0,61,8],[62,0,62,8],[42,6,42,7],[52,6,52,7],[50,6,50,7],[50,4,50,5],[51,4,51,5],[52,4,52,5],[40,3,40,5],[39,3,39,5],[38,3,38,5],[43,6,43,7],[43,4,43,5],[41,6,41,7],[41,4,41,5],[42,4,42,5],[69,0,69,8],[68,1,68,8],[30,17,31,17],[30,16,31,16],[34,12,34,14],[35,12,35,14],[38,16,40,16],[38,17,40,17],[38,11,40,11],[40,12,40,14],[32,17,33,17],[33,12,33,14],[35,16,37,16],[35,17,37,17],[36,12,36,14],[37,12,37,14],[35,8,37,8],[39,12,39,14],[38,12,38,14],[30,12,30,14],[30,11,31,11],[38,8,40,8],[34,11,37,11],[31,12,31,14]]}
[null,"HVAC INCENTIVES",null,null,null,null,null,"See specs at the bottom of the page! ",null,null,null,"USE THIS SECTION TO REPLACE THE TABLE IN THE SPECS WORKSHEET"]
["Applicant: fill in gray fields at bottom","See instructions to complete this worksheet at the bottom of the page"]
["HVAC Units"]
["Equipment Type",null,null,"Size Category",null,null,"Qualifying Efficiency*","Incentive \n(per ton)","Efficiency Bonus","New Qualifying Efficiency*",null,"Equipment Type","Size Category",null,null,"Qualifying Efficiency*","Incentive \n(per ton)","Efficiency Bonus"]
["Unitary and Split Air Conditioning Systems",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"15.0 SEER",25,15,"15.0 SEER",null,"Unitary and Split Air Conditioning Systems","< 65,000 Btu/h (5.4 tons)",null,null,{"$f":"J5","v":"15.0 SEER"},25,15]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"13.7 IEER**",null,null,"11.8 EER**",null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"13.7 IEER**"]
[]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"13.3 IEER**",null,null,"11.6 EER**",null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"13.3 IEER**"]
[]
[null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"12.4 IEER**",null,null,"10.5 EER**",null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"12.4 IEER**"]
[]
[null,null,null,"≥ 760,000 Btu/h (> 63 tons)",null,null,"12.0 IEER**",null,null,"10.2 EER**",null,null,"≥ 760,000 Btu/h (> 63 tons)",null,null,"12.0 IEER**"]
[]
["Air Source Heat Pumps",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"15 SEER and 8.6 HSPF",40,15,"15 SEER and 8.6 HSPF",null,"Air Source Heat Pumps","< 65,000 Btu/h (5.4 tons)",null,null,"15 SEER and 8.6 HSPF",40,15]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"12.9 IEER** and 3.5 COP",null,null,"11.6 EER** and 3.5 COP",null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"12.9 IEER** and 3.5 COP"]
[]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"12.4 IEER** and 3.4 COP",null,null,"11.1 EER** and 3.4 COP",null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"12.4 IEER** and 3.4 COP"]
[]
[null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"11.4 IEER** and 3.4 COP",null,null,"10.0 EER** and 3.4 COP",null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",null,null,"11.4 IEER** and 3.4 COP"]
[]
["Chillers: Water-Cooled, Centrifugal***",null,null,"≤ 150 tons",null,null,"0.495 kW/ton-IPLV",20,20,"0.495 kW/ton-IPLV",null,"Chillers: Water-Cooled, Centrifugal","≤ 150 tons",null,null,"0.495 kW/ton-IPLV",20,20]
[null,null,null,">150 tons and ≤ 300 tons",null,null,"0.495 kW/ton-IPLV",null,null,"0.495 kW/ton-IPLV",null,null,">150 tons and ≤ 300 tons",null,null,"0.495 kW/ton-IPLV"]
[null,null,null,"> 300 tons to ≤ 400 tons",null,null,"0.468 kW/ton-IPLV",null,null,"0.468 kW/ton-IPLV",null,null,"> 300 tons to ≤ 400 tons",null,null,"0.468 kW/ton-IPLV"]
[null,null,null,"> 400 tons to ≤ 600 tons",null,null,"0.450 kW/ton-IPLV",null,null,"0.450 kW/ton-IPLV",null,null,"> 400 tons to ≤ 600 tons",null,null,"0.450 kW/ton-IPLV"]
[null,null,null,"> 600",null,null,"0.450 kW/ton-IPLV",null,null,"0.450 kW/ton-IPLV",null,null,"> 600",null,null,"0.450 kW/ton-IPLV"]
["Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***",null,null,"≤ 75 tons",null,null,"0.54 kW/ton-IPLV",null,null,"0.54 kW/ton-IPLV",null,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***","≤ 75 tons",null,null,"0.54 kW/ton-IPLV"]
[null,null,null,"> 75 tons and ≤ 150 tons",null,null,"0.504 kW/ton-IPLV",null,null,"0.504 kW/ton-IPLV",null,null,"> 75 tons and ≤ 150 tons",null,null,"0.504 kW/ton-IPLV"]
[null,null,null,">150 tons and ≤ 300 tons",null,null,"0.486 kW/ton-IPLV",null,null,"0.486 kW/ton-IPLV",null,null,">150 tons and ≤ 300 tons",null,null,"0.486 kW/ton-IPLV"]
[null,null,null,"> 300 tons and ≤ 600 tons",null,null,"0.468 kW/ton-IPLV",null,null,"0.468 kW/ton-IPLV",null,null,"> 300 tons and ≤ 600 tons",null,null,"0.468 kW/ton-IPLV"]
[null,null,null,"> 600 tons",null,null,"0.540 kW/ton-IPLV",null,null,"0.540 kW/ton-IPLV",null,null,"> 600 tons",null,null,"0.540 kW/ton-IPLV"]
["Chillers: Air-Cooled",null,null,"≤ 150",null,null,"0.788 kW/ton-IPLV",40,20,"0.788 kW/ton-IPLV",null,"Chillers: Air-Cooled","≤ 150",null,null,"0.788 kW/ton-IPLV",40,20]
[null,null,null,"> 150",null,null,"0.771 kW/ton-IPLV",null,null,"0.771 kW/ton-IPLV",null,null,"> 150",null,null,"0.771 kW/ton-IPLV"]
["Packaged Terminal AC",null,null,"ALL",null,null,"14.5-(0.300 x Btu/h/1000) EER",50,0,"14.5-(0.300 x Btu/h/1000) EER",null,"Packaged Terminal AC","ALL",null,null,"14.5-(0.300 x Btu/h/1000) EER",50,0]
["Packaged Terminal HP",null,null,"ALL",null,null,"14.5-(0.300 x Btu/h/1000) EER",100,null,"14.5-(0.300 x Btu/h/1000) EER",null,"Packaged Terminal HP","ALL",null,null,"14.5-(0.300 x Btu/h/1000) EER",100]
["Variable Refrigerant Flow HP",null,null,"< 65,000 Btu/h (5.4 tons)",null,null,"13.9 SEER and 8.3 HSPF",40,20,"13.9 SEER and 8.3 HSPF",null,"Variable Refrigerant Flow HP","< 65,000 Btu/h (5.4 tons)",null,null,"13.9 SEER and 8.3 HSPF",40,20]
[null,null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"15.4 IEER and 3.5 COP",40,25,"15.4 IEER and 3.5 COP",null,null,"≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"15.4 IEER and 3.5 COP",40,25]
[null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"14.7 IEER and 3.4 COP",null,null,"14.7 IEER and 3.4 COP",null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"14.7 IEER and 3.4 COP"]
[null,null,null,"≥ 240,000 Btu/h (20 Tons)",null,null,"13.4 IEER and 3.4 COP",null,null,"13.4 IEER and 3.4 COP",null,null,"≥ 240,000 Btu/h (20 Tons)",null,null,"13.4 IEER and 3.4 COP"]
["Computer Room Air Conditioners",null,null,"< 65,000 Btuh",null,null,"8.2 EER","$8.00/Mbtu","N/A",null,null,"Computer Room Air Conditioners","< 65,000 Btuh",null,null,"8.2 EER","$8.00/Mbtu","N/A"]
[null,null,null,"≥ 65,000 Btuh to < 240,000 Btuh",null,null,"7.5 EER ",null,null,null,null,null,"≥ 65,000 Btuh to < 240,000 Btuh",null,null,"7.5 EER "]
[null,null,null,"≥ 240,000",null,null,"7.2 EER",null,null,null,null,null,"≥ 240,000",null,null,"7.2 EER"]
["Equipment Model","Tons (use Btuh for CRAC)","Efficiency Rating","Quantity","Equipment Type",null,"Size Category",null,"Incentive"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E43=\"\",\"\",IF(LEFT(E43,2)<>\"Ch\",B43*D43*IF(VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,2,FALSE)>C43,0,VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,3,FALSE)+(C43-(VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,4,FALSE))),B43*D43*IF(VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,2,FALSE)<C43,0,VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,2,FALSE))-C43)*(VLOOKUP(CONCATENATE(E43,G43),$V$108:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
["HVAC Units Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I43:I56)","v":0}]
["* Use SEER for Unitary and Split Units less than 5.4 tons and IEER for units larger than 5.4 tons; values available from CEE 2012 Tier 2; Use IEER for VRF Units; IPLV values based on ASHRAE 90.1-2016; see specifications page for complete list. Attach AHRI Rating Sheet. \n** Units with electric resistance heating must have IEER values 0.2 higher than the efficiencies listed.\n*** Unit efficiency for chillers should be provided in kW per ton – IPLV where IPLV = Integrated Part Load Value; values based on ASHRAE 90.1-2016. Attach manufacturer's rating sheet for credit."]
[]
[]
[]
[]
["INSTRUCTIONS TO COMPLETE THIS WORKSHEET:"]
["Equipment Model:","Enter the equipment model as shown on the invoice; provide the specification sheet(s) that accompany the model"]
["Tons:","Enter the equipment tonnage from the AHRI or manufacturer specification sheet"]
["Efficiency Rating:","Enter the equipment efficiency rating from the AHRI or manufacturer specification sheet; for chillers, kW/ton = 12/IPLV EER"]
["Quantity:","Enter the number of units that fit this size and efficiency rating"]
["Equipment Type:","Enter the equipment type from the drop-down menu"]
["Size Category:","Enter the equipment size from the drop-down menu"]
["Note: The reference standard in IECC 2018 is ASHRAE 90.1-2016"]
[]
["Guest Room Energy Management System"]
["Type/ Description",null,"Incentive Unit",null,"Unit Size (tons)",null,"Quantity","Incentive/ Ton","Incentive"]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,75,{"$f":"IF(G74*H74*E74=0,\"\",G74*H74*E74)","v":""}]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,75,{"$f":"IF(G75*H75*E75=0,\"\",G75*H75*E75)","v":""}]
["Hotel Guest Room Occupancy Sensor ",null,"Per Ton Per Room",null,null,null,null,75,{"$f":"IF(G76*H76*E76=0,\"\",G76*H76*E76)","v":""}]
["GREM Incentive",null,null,null,null,null,null,null,{"$f":"IF(SUM(I74:I76)=0,\"\",SUM(I74:I76))","v":""}]
[]
["Total HVAC Incentives",null,null,null,null,null,null,{"$f":"SUM(I57,I77)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems"]
[null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Centrifugal"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled: Scroll, Screw or Reciprocating"]
[null,null,null,null,null,null,null,null,null,null,"Chillers: Air-Cooled"]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal AC"]
[null,null,null,null,null,null,null,null,null,null,"Packaged Terminal HP"]
[null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"< 65,000 Btu/h (5.4 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 65,000 Btu/h and < 135,000 Btu/h (5.4-11.25 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)"]
[null,null,null,null,null,null,null,null,null,null,"≥ 760,000 Btu/h (> 63 tons)"]
[null,null,null,null,null,null,null,null,null,null,"≤ 75 tons"]
[null,null,null,null,null,null,null,null,null,null,"≤ 150 tons"]
[null,null,null,null,null,null,null,null,null,null,"> 150 tons"]
[null,null,null,null,null,null,null,null,null,null,">150 tons and ≤ 300 tons"]
[null,null,null,null,null,null,null,null,null,null,">300 tons and ≤ 400 tons"]
[null,null,null,null,null,null,null,null,null,null,"> 400 tons and ≤ 600 tons"]
[null,null,null,null,null,null,null,null,null,null,">600"]
[null,null,null,null,null,null,null,null,null,null,"ALL"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level Normal (2021 V2)","2021 V2 Rounded","Level Normal (2021 V1)",null,"Level Normal","Incentive","Bonus","Level 2","Level 3","Level 4","Min","Max"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.000020000000001,{"$f":"ROUND(S110,1)","v":15},14,"Unitary and Split Air Conditioning Systems< 65,000 Btu/h (5.4 tons)",{"$f":"T110","v":15},25,15,{"$f":"W110+1","v":16},{"$f":"Z110+1","v":17},18,0,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.714304000000002,13.7,12,"Unitary and Split Air Conditioning Systems≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",13.7,25,15,{"$f":"W111+1","v":14.7},15.7,16.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.285732000000001,13.3,12,"Unitary and Split Air Conditioning Systems≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",13.3,25,15,{"$f":"W112+1","v":14.3},15.3,16.3,11.25,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.428588000000001,12.4,10.8,"Unitary and Split Air Conditioning Systems≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",12.4,25,15,{"$f":"W110+1","v":16},{"$f":"Z110+1","v":17},{"$f":"AA110+1","v":18},20,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.000016,12,10.199999999999999,"Unitary and Split Air Conditioning Systems≥ 760,000 Btu/h (> 63 tons)",12,25,15,{"$f":"W114+1","v":13},{"$f":"Z114+1","v":14},15,63,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.000020000000001,15,14,"Air Source Heat Pumps< 65,000 Btu/h (5.4 tons)",15,40,15,{"$f":"W115+1","v":16},17,18,0,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.85716,12.9,11.6,"Air Source Heat Pumps≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",12.9,40,15,{"$f":"W116+1","v":13.9},14.9,15.9,5.4,11.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.428588000000001,12.4,11.2,"Air Source Heat Pumps≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",12.4,40,15,{"$f":"W117+1","v":13.4},14.4,15.4,11.25,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.357158,11.4,10,"Air Source Heat Pumps≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",11.4,40,15,{"$f":"W115+1","v":16},{"$f":"Z115+1","v":17},{"$f":"AA115+1","v":18},20,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9642990000000022,10,10,"Air Source Heat Pumps≥ 760,000 Btu/h (> 63 tons)",10,40,15,{"$f":"W119+1","v":11},{"$f":"Z119+1","v":12},{"$f":"AA119+1","v":13},63,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49500000000000005,{"$f":"S120","v":0.49500000000000005},0.56899999999999995,"Chillers: Water-Cooled, Centrifugal***≤ 150 tons",0.49500000000000005,20,20,0.54,{"$f":"ROUNDUP(W120/0.9*0.7,2)","v":0.39},{"$f":"ROUNDUP(W120/0.9*0.6,2)","v":0.33},0,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49500000000000005,0.49500000000000005,0.50700000000000001,"Chillers: Water-Cooled, Centrifugal***>150 tons and ≤ 300 tons",0.49500000000000005,20,20,0.54,0.39,0.33,150,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46800000000000003,0.46800000000000003,0.46700000000000003," ",0.46800000000000003,20,20,0.48,0.37,0.32,300,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.45,"New Size category","Chillers: Water-Cooled, Centrifugal***> 400 tons to ≤ 600 tons",0.45,20,20,0.44,0.35,0.3,400,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.45,"New Size Category","Chillers: Water-Cooled, Centrifugal***> 600",0.45,20,20,0.42,0.35,0.3,600,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,0.54,0.59199999999999997,"Chillers: Water-Cooled: ReciprocatingALL",0.54,20,20,0.54,0.42,0.36,0,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,0.54,"New Size Category","Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***≤ 75 tons",0.54,20,20,0.54,0.42,0.36,0,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.504,0.504,0.57499999999999996,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 75 tons and ≤ 150 tons",0.504,20,20,0.54,0.4,0.34,75,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48599999999999999,0.48599999999999999,0.53400000000000003,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***>150 tons and ≤ 300 tons",0.48599999999999999,20,20,0.5,0.38,0.33,150,300,null,null,null,null,null,null,null,null,null,null,null,"Chillers: Air-Cooled","Unitary and Split Air Conditioning Systems","Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***","Chillers: Water-Cooled, Centrifugal***","Air Source Heat Pumps","Variable Refrigerant Flow HP","Packaged Terminal AC","Packaged Terminal HP","Computer Room Air Conditioners"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46800000000000003,0.46800000000000003,0.48599999999999999,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 300 tons and ≤ 600 tons",0.46800000000000003,20,20,0.46,0.37,0.32,300,600,null,null,null,null,null,null,null,null,null,null,null,"≤ 150","< 65,000 Btu/h (5.4 tons)","≤ 75 tons","≤ 150 tons","< 65,000 Btu/h (5.4 tons)","< 65,000 Btu/h (5.4 tons)","ALL","ALL","< 65,000 Btuh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.45,"New Size Category","Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 600 tons",0.45,20,20,0.42,0.35,0.3,600,10000,null,null,null,null,null,null,null,null,null,null,null,"> 150","≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)","> 75 tons and ≤ 150 tons",">150 tons and ≤ 300 tons","≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)","≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",null,null,"≥ 65,000 Btuh to < 240,000 Btuh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78800000000000003,0.78800000000000003,0.86699999999999999,"Chillers: Air-Cooled≤ 150",0.78800000000000003,40,20,{"$f":"ROUND(W131/0.9*0.8,2)","v":0.7},0.62,0.53,0,150,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",">150 tons and ≤ 300 tons","> 300 tons to ≤ 400 tons","≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)","≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",null,null,"≥ 240,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77100000000000002,0.77100000000000002,0.86699999999999999,"Chillers: Air-Cooled> 150",0.77100000000000002,40,20,{"$f":"ROUND(W132/0.9*0.8,2)","v":0.69},0.6,0.52,150,100000,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)","> 300 tons and ≤ 600 tons","> 400 tons to ≤ 600 tons","≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)","≥ 240,000 Btu/h (20 Tons)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"14.5-(0.3*_xlfn.IFNA(INDEX($A$40:$I$53,MATCH(\"Packaged Terminal AC\",$E$40:$E$53,0),2),0)*12000/1000)","v":14.5},14.5,{"$f":"12.5-(0.213*B43*12000/1000)","v":12.5},"Packaged Terminal ACALL",14.5,50,0,{"$f":"W133+1","v":15.5},{"$f":"Z133+1","v":16.5},17.5,0,100000,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 760,000 Btu/h (> 63 tons)","> 600 tons","> 600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"14.5-(0.3*_xlfn.IFNA(INDEX($A$40:$I$53,MATCH(\"Packaged Terminal HP\",$E$40:$E$53,0),2),0)*12000/1000)","v":14.5},14.5,{"$f":"12.3-(0.213*B44*12000/1000)","v":12.3},"Packaged Terminal HPALL",14.5,100,0,15.5,16.5,17.5,0,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.428592000000002,{"$f":"ROUND(S135,1)","v":15.4},14.8,"Variable Refrigerant Flow HP≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",15.4,40,25,16.399999999999999,17.399999999999999,18.399999999999999,5.4,11.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.678591000000001,14.7,14.2,"Variable Refrigerant Flow HP≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",14.7,40,25,15.7,16.7,17.7,11.25,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.392875000000002,13.4,12.7,"Variable Refrigerant Flow HP≥ 240,000 Btu/h (20 Tons)",13.4,40,25,14.4,15.4,16.399999999999999,20,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.928590000000002,13.9,15.6,"Variable Refrigerant Flow HP< 65,000 Btu/h (5.4 tons)",13.9,40,25,14.9,15.9,16.899999999999999,63,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1839999999999993,8.1999999999999993,null,"Computer Room Air Conditioners< 65,000 Btuh",8.1999999999999993,8.0000000000000002E-3,0,9.1999999999999993,10.199999999999999,11.2,0,65000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5020000000000007,7.5,null,"Computer Room Air Conditioners≥ 65,000 Btuh to < 240,000 Btuh",7.5,8.0000000000000002E-3,0,8.5,9.5,10.5,65000,240000,null,null,null,null,null,null,null,"Categories","Column1","Column2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1610000000000005,7.2,null,"Computer Room Air Conditioners≥ 240,000",7.2,8.0000000000000002E-3,0,8.1999999999999993,9.1999999999999993,10.199999999999999,240000,10000000,null,null,null,null,null,null,null,"Unitary and Split Air Conditioning Systems","UnitarySplit",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Source Heat Pumps","AirSourceHP",2]
[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,"**used stated values for Level 2, if available.  Else was rounded up to the  10s of watts",null,null,null,null,null,null,null,null,null,null,null,"Variable Refrigerant Flow HP","VRF",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4,{"$f":"W144*3.41","v":8.1839999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***","ChillerHelical",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,{"$f":"W145*3.41","v":7.5020000000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,"Chillers: Water-Cooled, Centrifugal***","ChillerCent",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,{"$f":"W146*3.41","v":7.1610000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,"Chillers: Air-Cooled","ChillerAir",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Packaged Terminal AC","PTAC",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Packaged Terminal HP","PTHP",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer Room Air Conditioners","CRAC",9]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test, Category","Test, Dropdown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer Room Air Conditioner","< 65,000 Btuh"]

{"sheet":"Food Service","index":8,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,0,33,4],[32,0,32,4],[28,0,28,4],[25,0,25,4],[27,0,27,4],[38,0,38,4],[37,0,37,4],[36,0,36,4],[26,0,26,4],[21,9,21,10],[33,9,33,10],[37,9,37,10],[36,9,36,10],[35,0,35,4],[37,6,37,7],[36,6,36,7],[35,6,35,7],[38,9,38,10],[21,0,21,4],[21,6,21,7],[34,0,34,4],[0,1,0,10],[28,6,28,7],[3,0,3,4],[27,6,27,7],[26,6,26,7],[13,0,13,4],[17,0,17,4],[16,0,16,4],[15,0,15,4],[19,0,19,4],[18,0,18,4],[20,9,20,10],[20,0,20,4],[41,9,41,10],[41,0,41,8],[10,0,10,8],[10,9,10,10],[22,9,22,10],[22,0,22,8],[29,0,29,8],[29,9,29,10],[39,9,39,10],[38,6,38,7],[14,0,14,4],[33,6,33,7],[32,6,32,7],[34,6,34,7],[17,6,17,7],[39,0,39,8],[13,6,13,7],[16,9,16,10],[35,9,35,10],[34,9,34,10],[32,9,32,10],[19,6,19,7],[18,6,18,7],[28,9,28,10],[27,9,27,10],[26,9,26,10],[25,9,25,10],[20,6,20,7],[14,6,14,7],[16,6,16,7],[19,9,19,10],[17,9,17,10],[18,9,18,10],[25,6,25,7],[42,0,43,7],[42,8,43,10],[4,9,4,10],[3,9,3,10],[8,9,8,10],[7,9,7,10],[6,9,6,10],[5,9,5,10],[8,6,8,7],[7,6,7,7],[9,9,9,10],[13,9,13,10],[15,9,15,10],[14,9,14,10],[15,6,15,7],[6,6,6,7],[5,6,5,7],[3,6,3,7],[4,6,4,7],[9,6,9,7]]}
[null,"FOOD SERVICE INCENTIVES"]
["Applicant: fill in gray fields"]
["ENERGY STAR® Ovens & Fryers"]
["Equipment Type",null,null,null,null,"Incentive Unit","Incentive/Unit",null,"# of Units","Incentive",null,null,"kWh/Unit","kWh Savings"]
["Combination Oven - Full Size",null,null,null,null,"Unit",800,null,null,{"$f":"IF(ISBLANK(I5),\"\",I5*G5)","v":""},null,null,6368,{"$f":"M5*I5","v":0}]
["Convection Oven - Half Size",null,null,null,null,"Unit",100,null,null,"",null,null,3043,0]
["Convection Oven - Full Size < 5 pans",null,null,null,null,"Unit",300,null,null,"",null,null,4633,0]
["Convection Oven - Full size ≥ 5 pans",null,null,null,null,"Unit",350,null,null,"",null,null,244,0]
["Commercial Vat Fryer - Standard",null,null,null,null,"Unit",250,null,null,"",null,null,3272,0]
["Commercial Vat Fryer - Large",null,null,null,null,"Unit",300,null,null,"",null,null,2696,0]
["Ovens & Fryers Incentive",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:K10)","v":0}]
[]
["ENERGY STAR® Steam Cookers"]
["Equipment Type",null,null,null,null,"Incentive Unit","Incentive/Unit",null,"# of Units","Incentive"]
["Boiler Based - 3 Pan",null,null,null,null,"Unit",1200,null,null,{"$f":"IF(ISBLANK(I15),\"\",I15*G15)","v":""},null,null,11784,{"$f":"M15*I15","v":0}]
["Boiler Based - 4 Pan",null,null,null,null,"Unit",1400,null,null,"",null,null,14553,0]
["Boiler Based - 5 Pan",null,null,null,null,"Unit",1600,null,null,"",null,null,17268,0]
["Boiler Based - ≥6 Pan",null,null,null,null,"Unit",1800,null,null,"",null,null,19990,0]
["Steam Generator - 3 Pan",null,null,null,null,"Unit",800,null,null,"",null,null,9967,0]
["Steam Generator - 4 Pan",null,null,null,null,"Unit",900,null,null,"",null,null,12107,0]
["Steam Generator - 5 Pan",null,null,null,null,"Unit",1000,null,null,"",null,null,14186,0]
["Steam Generator - ≥6 Pan",null,null,null,null,"Unit",1200,null,null,"",null,null,16270,0]
["Steam Coookers Incentive",null,null,null,null,null,null,null,null,{"$f":"SUM(J15:K22)","v":0}]
[]
["ENERGY STAR® Hot Food Holding Cabinet"]
["Equipment Type",null,null,null,null,"Incentive Unit","Incentive/Unit",null,"# of Units","Incentive"]
["Half size",null,null,null,null,"Unit",125,null,null,{"$f":"IF(ISBLANK(I27),\"\",I27*G27)","v":""},null,null,1215,{"$f":"M27*I27","v":0}]
["Three-quarter size",null,null,null,null,"Unit",300,null,null,{"$f":"IF(ISBLANK(I28),\"\",I28*G28)","v":""},null,null,2770,{"$f":"M28*I28","v":0}]
["Full-size",null,null,null,null,"Unit",500,null,null,{"$f":"IF(ISBLANK(I29),\"\",I29*G29)","v":""},null,null,4832,{"$f":"M29*I29","v":0}]
["Hot Food Holding Cabinets Incentive",null,null,null,null,null,null,null,null,{"$f":"SUM(J27:K29)","v":0}]
[]
["ENERGY STAR® High Efficiency Ice Makers"]
["Equipment Type",null,null,null,null,"Installed kWk/100 lbs","Incentive/Unit",null,"# of Units","Incentive"]
["150 lb/24 hours",null,null,null,null,"Unit",100,null,null,{"$f":"IF(ISBLANK(I34),\"\",I34*G34)","v":""},null,null,401,{"$f":"M34*I34","v":0}]
["250 lb/24 hours",null,null,null,null,"Unit",125,null,null,"",null,null,469,0]
["350 lb/24 hours",null,null,null,null,"Unit",150,null,null,"",null,null,357,0]
["450 lb/24 hours",null,null,null,null,"Unit",150,null,null,"",null,null,440,0]
["750 lb/24 hours",null,null,null,null,"Unit",200,null,null,"",null,null,850,0]
["1500 lb/24 hours",null,null,null,null,"Unit",250,null,null,"",null,null,1436,0]
["High Efficiency Ice Makers Incentive",null,null,null,null,null,null,null,null,{"$f":"SUM(J34:K39)","v":0}]
[]
["Total Food Service Equipment Incentives",null,null,null,null,null,null,null,null,{"$f":"SUM(J5:K10,J15:K22,J27:K29,J34:K39)","v":0}]
["I certify that I have not already received an 'at the counter' rebate from a participating distributor for the equipment listed above. I understand that if I have already received a rebate that this application will be cancelled."]

{"sheet":"Pool Pumps","index":9,"n_rows":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,6,5,7],[11,0,11,9],[7,6,7,7],[8,6,8,7],[8,0,8,4],[10,0,10,9],[7,0,7,4],[6,6,6,7],[3,18,3,25],[1,0,1,2],[4,6,4,7],[5,19,9,19],[5,20,9,20],[2,0,3,9],[9,0,9,8],[6,0,6,4],[5,0,5,4],[4,0,4,4]]}
["POOL PUMP INCENTIVES"]
["Applicant: fill in gray fields at bottom",null,null,null,null,null,"See specs at the bottom of the page!"]
["Pool Pump (0.5 - 3 HP)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGYSTAR Pool Pump Assumptions"]
["Pump Type",null,null,null,null,"Incentive Unit","Incentive/Unit",null,"Quantity","Incentive",null,"kWh Saved/Unit","Annual kWh Saved","kW Saved/Unit","kW Saved",null,null,null,"Rated Hp","Hours, HighSpeed","Hours, LowSpeed","PFR, HighSpeed","EF, \nHighSpeed","PFR, LowSpeed","EF, LowSpeed","kWh, ENERGYSTAR"]
["Energy Star Pump - In-ground",null,null,null,null,"Unit",100,null,null,{"$f":"IF(ISBLANK(I6),\"\",G6*I6)","v":""},null,307.7,{"$f":"L6*$I6","v":0},0.22,{"$f":"N6*$I6","v":0},null,null,null,"<1.25",4.3,9.6999999999999993,56,2.3980000000000001,31,5.407,{"$f":"+((V6*60*$T$6*365)/(W6*1000))+((X6*60*$U$6*365)/(Y6*1000))","v":3417.059372114084}]
["CEE Tier 1* Pump - In-ground",null,null,null,null,"Unit",100,100,null,{"$f":"IF(ISBLANK(I7),\"\",G7*I7)","v":""},null,null,{"$f":"L7*$I7","v":0},null,{"$f":"N7*$I7","v":0},null,null,null,"1.25 < HP <1.75",null,0.20849999999999999,61,2.2669999999999999,31.9,5.4329999999999998,{"$f":"+((V7*60*$T$6*365)/(W7*1000))+((X7*60*$U$6*365)/(Y7*1000))","v":3781.1964873291849}]
["Energy Star Pump - Above Ground",null,null,null,null,"Unit",100,100,null,{"$f":"IF(ISBLANK(I8),\"\",G8*I8)","v":""},null,189.5,{"$f":"L8*$I8","v":0},0.48,{"$f":"N8*$I8","v":0},null,null,null,"1.75 < HP <2.25",null,0.25159999999999999,66.400000000000006,1.9510000000000001,33.299999999999997,5.2210000000000001,{"$f":"+((V8*60*$T$6*365)/(W8*1000))+((X8*60*$U$6*365)/(Y8*1000))","v":4559.8629963113717}]
["CEE Tier 1* Pump - Above Ground",null,null,null,null,"Unit",100,null,null,{"$f":"IF(ISBLANK(I9),\"\",G9*I9)","v":""},null,null,{"$f":"L9*$I9","v":0},null,{"$f":"N9*$I9","v":0},null,null,null,"2.25 < HP <2.75",null,0.30809999999999998,66,2.024,34,4.7960000000000003,{"$f":"+((V9*60*$T$6*365)/(W9*1000))+((X9*60*$U$6*365)/(Y9*1000))","v":4576.7283424592961}]
["Pool Pumps Incentive",null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J9)","v":0},null,null,null,null,null,null,null,null,"2.75 < HP <3.00",null,0.3639,74,1.617,37,4.7640000000000002,{"$f":"+((V10*60*$T$6*365)/(W10*1000))+((X10*60*$U$6*365)/(Y10*1000))","v":5959.4284475869581}]
["* If BOTH Energy Star and CEE Tier 1 certified, use the CEE Tier 1 line item(s)."]

{"sheet":"Industrial","index":10,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,0,6,7],[27,0,27,3],[26,0,26,3],[25,0,25,3],[24,0,24,3],[23,0,23,3],[22,0,22,3],[13,0,13,3],[17,0,17,3],[16,0,16,3],[38,0,38,3],[43,0,43,7],[14,0,14,3],[12,0,12,3],[21,0,21,3],[37,0,37,3],[41,0,41,7],[40,0,40,3],[39,0,39,3],[0,0,0,8],[18,0,18,7],[34,0,34,7],[33,0,33,3],[32,0,32,3],[31,0,31,3],[30,0,30,3],[29,0,29,3],[28,0,28,3],[11,0,11,3],[10,0,10,3],[9,0,9,3],[15,0,15,3],[5,0,5,3],[4,0,4,3],[3,0,3,3]]}
["INDUSTRIAL INCENTIVES"]
["Applicant: fill in gray fields"]
["Compressed Air Storage Receiver Tanks"]
["Equipment Size Category",null,null,null,"Incentive Unit","Incentive/Unit","Horsepower (HP)","# of Units","Incentive"]
["≤50 HP",null,null,null,"HP",40,null,null,{"$f":"IF(ISBLANK(H5),\"\",F5*G5*H5)","v":""}]
["51-200 HP",null,null,null,"HP",40,null,null,{"$f":"IF(ISBLANK(H6),\"\",F6*G6*H6)","v":""}]
["Efficient Compressor Air Nozzles Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I5:I6)","v":0}]
[]
["VSD Air Compressors"]
["Equipment Type",null,null,null,"Incentive Unit","Incentive/Unit","Horsepower (HP)","# of Units","Incentive"]
["Modulating w/ Blowdown <= 50 hp",null,null,null,"Per HP",80,null,null,{"$f":"IF(ISBLANK(H11),\"\",F11*G11*H11)","v":""}]
["Load/No Load w/ 1 Gallon/CFM <= 50 hp",null,null,null,"Per HP",80,null,null,""]
["Load/No Load w/ 3 Gallon/CFM <= 50 hp",null,null,null,"Per HP",80,null,null,""]
["Load/No Load w/ 5 Gallon/CFM <= 50 hp",null,null,null,"Per HP",80,null,null,""]
["Modulating w/ Blowdown 51-200 hp",null,null,null,"Per HP",100,null,null,""]
["Load/No Load w/ 1 Gallon/CFM 51-200 hp",null,null,null,"Per HP",100,null,null,""]
["Load/No Load w/ 3 Gallon/CFM 51-200 hp",null,null,null,"Per HP",100,null,null,""]
["Load/No Load w/ 5 Gallon/CFM 51-200 hp",null,null,null,"Per HP",100,null,null,""]
["VSD Air Compressor Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I11:I18)","v":0}]
[]
["Efficient Desiccant Compressed Air Dryers"]
["Equipment Type",null,null,null,"Incentive Unit","Incentive/Unit","CFM","# of Units","Incentive"]
["Heated - Reciprocating - On/off Control",null,null,null,"per CFM",3,null,null,{"$f":"IF(ISBLANK(H23),\"\",F23*G23*H23)","v":""}]
["Heated - Reciprocating - Load/Unload",null,null,null,"per CFM",3,null,null,""]
["Heated - Screw - Load/Unload or Variable Displacement",null,null,null,"per CFM",3,null,null,""]
["Heated - Screw - VFD",null,null,null,"per CFM",3,null,null,""]
["Blower Purge w/Compressed Air Cooling - Reciprocating - On/off Control",null,null,null,"per CFM",5,null,null,""]
["Blower Purge w/Compressed Air Cooling - Reciprocating - Load/Unload",null,null,null,"per CFM",5,null,null,""]
["Blower Purge w/Compressed Air Cooling - Screw - Load/Unload or Variable Displacement",null,null,null,"per CFM",5,null,null,""]
["Blower Purge w/Compressed Air Cooling - Screw - VFD",null,null,null,"per CFM",5,null,null,""]
["Blower Purge \"Zero Purge\" - Reciprocating - On/off Control",null,null,null,"per CFM",7,null,null,""]
["Blower Purge \"Zero Purge\" - Reciprocating - Load/Unload",null,null,null,"per CFM",7,null,null,""]
["Blower Purge \"Zero Purge\" - Screw - Load/Unload or Variable Displacement",null,null,null,"per CFM",7,null,null,""]
["Blower Purge \"Zero Purge\" - Screw - VFD",null,null,null,"per CFM",7,null,null,""]
["Efficient Desiccant Compressed Air Dryer Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I23:I34)","v":0}]
[]
["Efficient Refrigerated Compressed Air Dryers"]
["Equipment Type",null,null,null,"Incentive Unit","Incentive/ Unit","CFM","# of Units","Incentive"]
["Thermal-Mass",null,null,null,"Per CFM",1,null,null,{"$f":"IF(ISBLANK(H39),\"\",F39*G39*H39)","v":""}]
["VSD",null,null,null,"Per CFM",1,null,null,{"$f":"IF(ISBLANK(H40),\"\",F40*G40*H40)","v":""}]
["Digital Scroll",null,null,null,"Per CFM",1,null,null,{"$f":"IF(ISBLANK(H41),\"\",F41*G41*H41)","v":""}]
["Total Efficient Refrigerated Compressed Air Dryer Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I39:I41)","v":0}]
[]
["Total Industrial Incentives",null,null,null,null,null,null,null,{"$f":"SUM(I7,I19,I35,I42)","v":0}]

{"sheet":"Custom","index":11,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[40,0,48,3],[40,4,40,5],[40,7,48,7],[40,8,48,9],[41,4,41,6],[61,0,61,9],[64,0,64,9],[66,0,66,9],[68,0,68,9],[58,0,59,9],[48,4,48,5],[49,0,49,9],[50,0,50,7],[50,8,50,9],[35,4,35,6],[36,4,36,5],[37,0,37,9],[38,0,38,9],[39,0,39,3],[39,4,39,6],[42,4,42,5],[43,4,43,6],[44,4,44,5],[45,4,45,6],[46,4,46,5],[47,4,47,6],[39,8,39,9],[28,0,36,3],[28,4,28,5],[28,7,36,7],[28,8,36,9],[29,4,29,6],[30,4,30,5],[31,4,31,6],[32,4,32,5],[33,4,33,6],[34,4,34,5],[23,4,23,6],[24,4,24,5],[25,0,25,9],[26,0,26,9],[27,0,27,3],[27,4,27,6],[27,8,27,9],[16,0,24,3],[16,4,16,5],[16,7,24,7],[16,8,24,9],[17,4,17,6],[18,4,18,5],[19,4,19,6],[20,4,20,5],[21,4,21,6],[22,4,22,5],[80,0,80,9],[0,6,0,9],[70,0,70,9],[72,0,72,9],[74,0,74,9],[76,0,76,9],[10,4,10,5],[0,3,0,5],[1,0,1,2],[2,0,2,9],[13,0,13,9],[14,0,14,9],[15,0,15,3],[15,4,15,6],[15,8,15,9],[78,0,78,9],[3,0,3,3],[3,4,3,6],[3,8,3,9],[11,4,11,6],[12,4,12,5],[4,0,12,3],[4,4,4,5],[4,7,12,7],[4,8,12,9],[5,4,5,6],[6,4,6,5],[7,4,7,6],[8,4,8,5],[9,4,9,6]]}
[null,null,null,"CUSTOM INCENTIVES",null,null,"See specs at the bottom of the page!"]
["Applicant: fill in gray fields",null,null,"*Please attach supporting documentation as described in the specifications*"]
["Item 1"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G5>0,G11>0,G13>0),MIN(G5*H5,G11,0.5*G13),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 2"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G17>0,G23>0,G25>0),MIN(G17*H17,G23,0.5*G25),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 3"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G29>0,G35>0,G37>0),MIN(G29*H29,G35,0.5*G37),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 4"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.08,{"$f":"IF(AND(G41>0,G47>0,G49>0),MIN(G41*H41,G47,0.5*G49),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Total Custom Incentives",null,null,null,null,null,null,null,{"$f":"I5+I17+I29+I41","v":0}]
[]
["Incremental measure cost (IMC) is the difference between the cost of an energy-efficient piece of equipment and a new"]
["standard-efficiency piece of equipment. The IMC of energy-efficient equipment installed before an old piece of equipment"]
["reaches the end of its life (such as lighting equipment) generally is equal to the total cost of the energy-efficient equipment,"]
["including labor. The IMC of energy-efficient equipment installed at or near the end of life of an old piece of equipment (such as"]
["chillers, motors, air-conditioning units) generally is equal to the difference in cost between the energy-efficient equipment and"]
["the new standard-efficiency piece of equipment, not including labor."]
["The rebate will be shown as 100% of the Incremental Measure Cost or 50% of the Total Project Cost. All Custom measures subject to approval using the Utility Cost Test (UCT). Submit calculations and costs for assistance."]

{"sheet":"NC Whole Bldg","index":12,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[31,0,31,3],[31,4,31,6],[13,4,13,6],[31,8,31,9],[51,4,51,6],[27,0,27,9],[30,0,30,9],[32,4,32,5],[34,4,34,5],[18,7,26,7],[18,8,26,9],[6,0,14,3],[24,4,24,5],[25,4,25,6],[26,4,26,5],[11,4,11,6],[18,0,26,3],[19,4,19,6],[21,4,21,6],[23,4,23,6],[22,4,22,5],[18,4,18,5],[20,4,20,5],[54,0,54,7],[36,4,36,5],[55,7,55,9],[40,4,40,5],[44,4,44,5],[46,4,46,5],[48,4,48,5],[49,4,49,6],[54,8,54,9],[43,0,43,3],[38,4,38,5],[43,4,43,6],[41,0,41,9],[32,0,40,3],[32,7,40,7],[39,4,39,6],[45,4,45,6],[47,4,47,6],[43,8,43,9],[32,8,40,9],[53,0,53,9],[44,0,52,3],[44,7,52,7],[44,8,52,9],[52,4,52,5],[50,4,50,5],[42,0,42,9],[37,4,37,6],[33,4,33,6],[35,4,35,6],[15,0,15,9],[17,0,17,3],[6,4,6,5],[8,4,8,5],[10,4,10,5],[16,0,16,9],[14,4,14,5],[17,4,17,6],[17,8,17,9],[12,4,12,5],[9,4,9,6],[7,4,7,6],[6,7,14,7],[6,8,14,9],[0,1,0,5],[4,0,4,9],[5,0,5,3],[5,4,5,6],[0,6,0,9],[5,8,5,9]]}
[null,"NC WHOLE BUILDING INCENTIVES",null,null,null,null,"See specs at the bottom of the page!"]
["Applicant: fill in gray fields"]
["New Construction Whole Building Performance - 10% to 20% Savings"]
["Please attach supporting documentation as described in the specifications. Savings relative to ASHRAE 90.1 - 2016."]
["Item 1"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.1,{"$f":"IF(AND(G7>0,G13>0,G15>0),MIN(G7*H7,G13,0.5*G15),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 2"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.1,{"$f":"IF(AND(G19>0,G25>0,G27>0),MIN(G19*H19,G25,0.5*G27),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["New Construction Whole Building Performance - Greater than 20% Savings"]
["Please attach supporting documentation as described in the specifications. Savings relative to ASHRAE 90.1 - 2016."]
["Item 1"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.12,{"$f":"IF(AND(G33>0,G39>0,G41>0),MIN(G33*H33,G39,0.5*G41),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Item 2"]
["Description",null,null,null,null,null,null,"$/kWh","Subtotal"]
[null,null,null,null,"Annual kWh Savings",null,null,0.12,{"$f":"IF(AND(G45>0,G51>0,G53>0),MIN(G45*H45,G51,0.5*G53),0)","v":0}]
[]
[null,null,null,null,"kW Savings"]
[]
[null,null,null,null,"Annual Operating Hours"]
[]
[null,null,null,null,"Incremental Measure Cost"]
[]
[null,null,null,null,"Total Project Cost"]
[]
["Total New Construction Whole Building Incentives",null,null,null,null,null,null,null,{"$f":"I7+I19++I33+I45","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(L55>300000,\"Measure Cap Reached\",\"\")","v":""}]