{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["HOME","Checklist","Applicant Info","Multi-Facility","Terms & Conditions","Indoor Agriculture Rebates","HVAC","Custom"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":6,"defined_names":214,"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":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,0,44,2],[41,3,44,4],[42,5,42,7],[41,5,41,7],[38,0,39,8],[28,9,28,12],[26,1,29,3],[26,5,26,8],[30,1,33,3],[34,0,37,4],[27,5,27,8],[33,5,33,8],[22,5,25,8],[34,5,34,8],[32,5,32,8],[21,1,23,3],[21,5,21,8],[2,0,13,8],[0,0,1,1],[0,3,0,8],[1,3,1,8],[19,0,19,4],[16,1,18,2],[16,4,18,5],[16,7,18,8],[15,0,15,8]]}
[null,null,null,"2023 Indoor Agriculture Application"]
[null,null,null,"PNM Business Energy Efficiency Program"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Why improve energy efficiency?"]
[null,"Directly improves profitability by cutting operating costs",null,null,"Distinguishes your business as an energy efficiency steward in the community",null,null,"Qualifies your business for rebates that can cover portions of the upgrade cost"]
[]
[]
["Application Process",null,null,null,null,"Click on a quick link below:"]
[]
["1.","Submit a Pre-Notification Application to reserve funding (if required).",null,null,null,"Administrative"]
[]
[]
["2.","Install the qualified technology."]
[]
["3.","Complete, sign and submit Final Application with all required documentation within 6 months of project completion."]
[null,null,null,null,null,"Worksheets"]
[]
[]
["4.","The incentive check will be sent 4 to 6 weeks after approval of the Final Application."]
[]
[]
[]
[]
[]
[]
[]
["Contact Our PNM Business Energy Efficiency Team"]
[]
[]
["320 Gold Avenue SW, Ste 500 Albuquerque, NM 87102",null,null,"(505) 938-9400 Main",null,"energyefficiency@pnm.com"]
[null,null,null,null,null,"www.pnmenergyefficiency.com"]

{"sheet":"Checklist","index":1,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,62,9],[0,3,0,6]]}
[null,null,null,"APPLICATION CHECKLIST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["APPLICATION CHECKLIST  (CONTINUED)"]

{"sheet":"Applicant Info","index":2,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[59,0,59,4],[55,7,55,10],[56,7,56,10],[57,7,57,10],[59,7,59,10],[66,1,66,4],[60,7,60,10],[60,0,60,4],[56,5,56,6],[58,7,58,10],[58,0,58,4],[56,0,56,4],[55,0,55,4],[57,0,57,4],[26,0,26,3],[25,4,25,5],[28,4,28,5],[13,6,13,10],[30,4,30,10],[41,0,41,5],[32,0,32,3],[32,4,32,10],[39,4,39,10],[39,0,39,3],[35,0,35,10],[40,0,40,5],[24,0,24,3],[25,0,25,3],[28,0,28,3],[54,0,54,10],[52,0,52,10],[53,0,53,10],[31,6,31,8],[34,0,34,3],[34,4,34,5],[31,9,31,10],[40,6,40,10],[48,9,48,10],[31,4,31,5],[31,0,31,3],[42,3,42,5],[44,6,44,7],[42,6,42,7],[34,6,34,7],[33,0,33,3],[33,4,33,10],[51,0,51,10],[47,0,47,10],[48,0,48,4],[48,5,48,8],[46,4,46,5],[45,0,45,3],[45,4,45,10],[43,0,43,3],[44,0,44,3],[43,4,43,10],[46,8,46,10],[42,8,42,10],[37,7,38,10],[0,9,0,10],[49,0,49,4],[5,7,5,8],[7,7,7,8],[6,7,6,8],[41,6,41,10],[30,0,30,3],[15,0,15,5],[15,6,15,10],[18,6,18,10],[18,0,18,5],[21,4,21,10],[20,3,20,5],[44,4,44,5],[7,2,7,3],[6,2,6,3],[23,4,23,10],[49,5,49,8],[49,9,49,10],[0,3,0,8],[3,0,3,5],[3,6,3,8],[29,0,29,10],[28,8,28,10],[25,6,25,7],[27,0,27,3],[27,4,27,5],[27,6,27,7],[26,4,26,10],[14,6,14,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],[9,0,9,10],[14,0,14,5],[10,6,10,8],[24,4,24,10]]}
[null,null,null,"APPLICANT INFORMATION",null,null,null,null,null,"For office use only:",null,null,"Business Type","Tax Status",null,null,"State"]
[null,null,null,null,null,null,null,null,null,"Application #","Revision #",null,"Assembly","Corporation (Inc, PC, etc.)",null,null,"AK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"College/University","Government Agency",null,null,"AL"]
["Application Type:",null,null,null,null,null,"Check ONE box below:*",null,null,null,null,null,"Dwelling Unit","Individual",null,null,"AR"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grocery","Partnership",null,null,"AZ"]
[null,null,"New Construction",null,null,null,null,"Pre-Notification",null,"Date",null,null,"Heavy Industry","Exempt",null,{"$f":"IF(G6>0,\"Yes\",)","v":0},"CA"]
[null,null,"or",null,null,null,null,"or",null,null,null,null,"Hotel/Motel Common Areas",null,"New pre notification checkbox flag:",null,"CO"]
[null,null,"Retrofit",null,null,null,null,"Final Application",null,"Date",null,null,"K-12 School",null,false,null,"CT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Light Industry",null,null,null,"DE"]
["Customer Information*",null,null,null,null,null,null,null,null,null,null,null,"Medical",null,"Multifacility checkbox flag:",null,"FL"]
["PNM Account Number where measures installed ",null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous",null,false,null,"GA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Office",null,null,null,"HI"]
[null,null,"This Application represents multiple accounts / premises",null,null,null,"1. Enter number of Accounts / Premises ------->",null,null,null,"_________",null,"Restaurant",null,{"$f":"is","v":{"$error":"#NAME?"}},null,"IA"]
[null,null,null,null,null,null,"2. If yes: Complete Multi-Facility Worksheet -------> CLICK HERE",null,null,null,null,null,"Retail/Service",null,null,null,"ID"]
["Name of Company*",null,null,null,null,null,"Name Exactly as it Appears on Your Utility Bill*",null,null,null,null,null,"Warehouse",null,null,null,"IL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
["Name of Contact Person*",null,null,null,null,null,"Title*",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,"MA"]
["Telephone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,null,null,null,null,"MD"]
["Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
["Building Type*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
["Address Where Measures Installed*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
["City Where Measures Installed*",null,null,null,null,null,"State*",null,{"$f":"IF(E26=\"\",\"\",\"NM\")","v":""},"Zip*",null,null,null,null,null,null,"MN"]
["Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"MO"]
["Taxpayer ID Number (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,null,null,null,null,"MT"]
["Contractor Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
["Contracting Company*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
["Contractor Name*",null,null,null,null,null,"Contractor Phone Number*",null,null,null,null,null,null,null,null,null,"NH"]
["Contractor Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
["Contractor Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"NY"]
["Third Party Payment Release",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,"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,"OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
["Name of Third Party*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
["Name of Third Party Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
["Third Party Phone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,null,null,null,null,"TN"]
["Third Party Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
["Third Party City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"UT"]
["Third Party Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
["Third Party Taxpayer ID # (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,null,null,null,null,"VT"]
["Incentive Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
["Total Incentive Requested",null,null,null,null,"Total Project Cost  PRE-TAX * REQUIRED *",null,null,null,{"$f":"IF(O8=TRUE, \"Estimated Project Completion Date\", \"Project Completion Date\")","v":"Project Completion Date"},null,null,null,null,null,null,"WI"]
[{"$f":"MIN(F67, F50*0.5,400000)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]
["AGREEMENT"]
["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."]
["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."]
["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."]
["Customer Signature (PNM Customer)",null,null,null,null,null,null,"Third Party Signature"]
[null,null,null,null,null,"Please sign by hand or via DocuSign®"]
["Print Customer Name",null,null,null,null,null,null,"Print Third Party Name"]
[]
["Date",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[null,"For Office Use Only",null,null,null,{"$f":"SUM(F68:F70)","v":0}]
[null,"Indoor Agricutlure Incentive",null,null,null,{"$f":"+'Indoor Agriculture Rebates'!L23","v":0}]
[null,"HVAC Incentives",null,null,null,{"$f":"HVAC!H55","v":0}]
[null,"Custom Incentive",null,null,null,{"$f":"Custom!F18","v":0}]

{"sheet":"Multi-Facility","index":3,"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,1,0,3]]}
[null,"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$16),\" \",'Applicant Info'!$A$16)","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":"Terms & Conditions","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["TERMS & CONDITIONS"]

{"sheet":"Indoor Agriculture Rebates","index":5,"n_rows":57,"n_cols":35,"rows_kept":57,"cut":false,"hidden":false,"merged":[[48,18,48,21],[43,18,43,21],[53,18,53,21],[1,0,1,2],[2,0,2,11],[30,15,30,16],[6,0,6,2],[7,0,7,2],[9,0,9,2],[4,0,5,2],[4,9,5,9],[4,10,5,10],[20,0,20,2],[18,18,18,20],[19,18,19,20],[32,15,32,16],[19,0,19,2],[31,15,31,16],[22,0,22,10],[19,6,19,7],[20,6,20,7],[20,3,20,5],[0,1,0,11],[3,0,3,11],[17,0,17,11],[18,0,18,2],[18,3,18,5],[10,0,10,2],[4,11,5,11],[18,8,18,9],[10,7,10,8],[9,7,9,8],[8,0,8,2],[8,7,8,8],[7,7,7,8],[6,7,6,8],[10,3,10,4],[33,15,33,16],[19,3,19,5],[19,8,19,9],[20,8,20,9],[18,10,18,11],[19,10,19,11],[20,10,20,11],[18,6,18,7],[29,15,29,16],[9,3,9,4],[8,3,8,4],[7,3,7,4],[6,3,6,4],[10,5,10,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[6,5,6,6],[15,0,15,2],[14,0,14,2],[13,0,13,2],[12,0,12,2],[11,0,11,2],[15,3,15,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[11,3,11,4],[15,5,15,6],[14,5,14,6],[13,5,13,6],[12,5,12,6],[11,5,11,6],[15,7,15,8],[14,7,14,8],[13,7,13,8],[12,7,12,8],[11,7,11,8],[4,3,5,4],[4,22,5,22],[4,21,5,21],[4,20,5,20],[4,19,5,19],[4,18,5,18],[4,17,5,17],[4,16,5,16],[4,15,5,15],[4,7,5,8],[4,5,5,6]]}
[null,"Indoor Agriculture Rebates (Commercial Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qualifies","Evaporative","No Cooling","Fans",null,null,"AirCon",null,"Crop Type ","Baseline Technology Type","Baseline PPE (umol/J)","Baseline Fixture Wattage","Hours of Use","Coincidence Factor","EUL, years","IMC","Incentive per watt Reduced"]
["Applicant: fill in gray fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J11+J12","v":{"$error":"#VALUE!"}},"Evaporative Cooling does not apply","Only cooled spaces apply","Ventilation fan cooling does not apply",null,null,"Yes, DX Cooling",null,"Flowering Crops (Tomatoes and Peppers)","HPS",1.7,1100,4200,0.68,9.5,430.45499999999998,0.6]
["IMPORTANT NOTICE: Only approved LED lighting is elegible for a rebate; fluorescent and incandescent do not qualify.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, Evaporative",null,"Vegetative Growth","MH",1.25,640,6300,0.89,9.5,430.45499999999998,0.6]
["Indoor Agriculture Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, fans",null,"Microgreens","T5 HO",1,358,6300,0.68,9.5,430.45499999999998,0.6]
["Commercial LED Grow Lights\n Retrofit OR New Construction",null,null,"Proposed PPF (µmol/s)",null,"Proposed Fixture Wattage",null,"Qty",null,"Watts Reduced","Incentive per Watt","Incentive\n ($0.60/Watt Reduced)",null,null,null,"Baseline PPE (µmol/J)","kWBaseline","kWInstalled","Savings (kW)","hrs ","Savings / year (kWh)","Cost Effectiveness","With HVAC savings",null,null,null,"Propagation","T5 HO",1,234,6300,0.89,9.5,430.45499999999998,0.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,"No cooling",null,"Medical Cannabis - Flowering Stage","HPS",1.7,1100,4200,0.68,9.5,430.45499999999998,0.6]
["Flowering Crops (Tomatoes and Peppers)",null,null,null,null,null,null,null,null,{"$f":"IF(AND(D7=\"\",F7=\"\",H7=\"\"),\"\",IF(Q7<R7,0,(Q7-R7)*1000))","v":""},0.6,{"$f":"IF(J7=\"\",\"\",J7*K7)","v":""},null,null,null,1.7,{"$f":"((D7*H7)/(P7*1000))","v":0},{"$f":"F7*H7/1000","v":0},{"$f":"J7/1000*1.21","v":{"$error":"#VALUE!"}},4200,{"$f":"S7*T7","v":{"$error":"#VALUE!"}},{"$f":"L7/U7","v":{"$error":"#VALUE!"}},null,null,null,null,"Medical Cannabis - Vegetative Stage","MH",1.25,640,6300,0.89,9.5,430.45499999999998,0.6]
["Vegetative Growth",null,null,null,null,null,null,null,null,{"$f":"IF(AND(D8=\"\",F8=\"\",H8=\"\"),\"\",IF(Q8<R8,0,(Q8-R8)*1000))","v":""},0.6,{"$f":"IF(J8=\"\",\"\",J8*K8)","v":""},null,null,null,1.25,{"$f":"((D8*H8)/(P8*1000))","v":0},{"$f":"F8*H8/1000","v":0},{"$error":"#VALUE!"},6300,{"$f":"S8*T8","v":{"$error":"#VALUE!"}},{"$f":"L8/U8","v":{"$error":"#VALUE!"}},null,null,null,null,"Medical Cannabis - Cloning, Seeding and Propagation","T5 HO",1,234,6300,1,9.5,430.45499999999998,0.6]
["Microgreens",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,1,0,0,{"$error":"#VALUE!"},6300,{"$f":"S9*T9","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,null,null,"Recreational Cannabis - Flowering Stage","HID/LED/Other",2.2000000000000002,850,4200,0.68,9.5,430.45499999999998,0.6]
["Propagation",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,1,0,0,{"$error":"#VALUE!"},6300,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,"Recreational Cannabis - Vegetative Stage","HID/LED/Other",2.2000000000000002,640,6300,0.89,9.5,430.45499999999998,0.6]
["Medical Cannabis - Flowering Stage",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,1.7,0,0,{"$error":"#VALUE!"},4200,{"$f":"S11*T11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,null,null,"Recreational Cannabis - Cloning, Seeding and Propagation","T5/LED/Other",2.2000000000000002,234,6300,1,9.5,430.45499999999998,0.6]
["Medical Cannabis - Vegetative Stage",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,1.25,0,0,{"$error":"#VALUE!"},6300,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Medical Cannabis - Cloning, Seeding and Propagation",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,1,0,0,{"$error":"#VALUE!"},6300,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Recreational Cannabis - Flowering Stage",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,2.2000000000000002,0,0,{"$f":"J14/1000*1.21","v":{"$error":"#VALUE!"}},4200,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Recreational Cannabis - Vegetative Stage",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,2.2000000000000002,0,0,{"$error":"#VALUE!"},6300,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Recreational Cannabis - Cloning, Seeding and Propagation",null,null,null,null,null,null,null,null,"",0.6,"",null,null,null,2.2000000000000002,0,0,{"$error":"#VALUE!"},6300,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Dehumidification for Indoor Agriculture Facilities"]
["Equipment Type",null,null,"Capacity (Pints / Day) per Unit",null,null,"# of Units",null,"Incentive per Capacity ",null,"Incentive"]
["Indoor Dehumidification Units \n≤ 155 Pint / Day Capacity",null,null,null,null,null,null,null,{"$f":"P33","v":2.5},null,{"$f":"IF(Q26=\"\",\"\",IFERROR(D20*P33,\"\")*G20)","v":""},null,"Added"]
["Indoor Dehumidification Units\n > 155 pints/day capacity",null,null,null,null,null,null,null,{"$f":"P34","v":3.5},null,{"$f":"IF(Q27=\"\",\"\",IFERROR(D21*P34,\"\")*G21)","v":""},null,"Added",null,null,"75% duty cycle, 80% load factor, 8760 hrs.  Energy Star over Federal Standard.",null,null,null,null,"Unit Incentive\n$/Watt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.7]
["Total Incentive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L16,K20:L21)","v":0},null,null,null,"Capacity","Savings","Efficacy",null,0.45,1]
[]
["Horticultural Specifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Incentive\n$/Watt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D20","v":0},{"$f":"IF(OR((U55*D20*G20)=0,D20>155),\"\",U55*G20)","v":""},{"$f":"K20/Q26/G20","v":{"$error":"#VALUE!"}},null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21","v":0},{"$f":"IF(OR((V55*D21*G21)=0,D21<156),\"\",V55*G21)","v":""},{"$f":"K21/Q27/G21","v":{"$error":"#VALUE!"}},null,null,1.3]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive per Capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤155 Pints/Day",">155 Pints/Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity (Pints/Day)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D20","v":0},{"$f":"D21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity (Liters/Hr)",{"$f":"S39*0.0197157","v":{"$error":"#REF!"}},{"$f":"T39*0.0197157","v":{"$error":"#REF!"}},0,{"$f":"V39*0.0197","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Hours",8760,8760,8760,8760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duty Cycle",0.7,0.7,0.75,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load Factor",0.8,0.8,0.8,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrated Energy Factor (L/kWh) Under",1.57,1.8,3.3,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual kWh",{"$f":"((S40/S45)*S41*S42*S43)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T45)*T41*T42*T43)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U45)*U41*U42*U43)","v":0},{"$f":"((V40/V45)*V41*V42*V43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual kW",{"$f":"((S40/S45)*S42)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T45)*T42)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U45)*U42)","v":0},{"$f":"((V40/V45)*V42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak kW",{"$f":"((S40/S45)*S42*0.9)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T45)*T42*0.9)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U45)*U42*0.9)","v":0},{"$f":"((V40/V45)*V42*0.9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrated Energy Factor (L/kWh) Over",1.3,1.6,2.8,1.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual kWh",{"$f":"((S40/S50)*S41*S42*S43)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T50)*T41*T42*T43)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U50)*U41*U42*U43)","v":0},{"$f":"((V40/V50)*V41*V42*V43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual kW",{"$f":"((S40/S50)*S42)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T50)*T42)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U50)*U42)","v":0},{"$f":"((V40/V50)*V42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak kW",{"$f":"((S40/S50)*S42*0.9)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((T40/T50)*T42*0.9)*(1+(0.95/3.517))","v":{"$error":"#REF!"}},{"$f":"((U40/U50)*U42*0.9)","v":0},{"$f":"((V40/V50)*V42*0.9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual kWh",{"$f":"-S46+S51","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"(-U46+U51)*(1+(0.95/3.517))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual kW",{"$error":"#REF!"},{"$error":"#REF!"},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak kW",{"$error":"#REF!"},{"$error":"#REF!"},0,0]

{"sheet":"HVAC","index":6,"n_rows":156,"n_cols":49,"rows_kept":156,"cut":false,"hidden":false,"merged":[[8,15,9,15],[1,1,1,6],[0,1,0,5],[1,7,1,8],[2,0,2,2],[2,3,2,5],[2,12,2,14],[6,15,7,15],[3,12,3,14],[6,12,7,14],[10,3,11,5],[10,6,11,6],[10,12,11,14],[10,15,11,15],[8,3,9,5],[8,6,9,6],[8,9,9,9],[8,12,9,14],[6,6,7,6],[6,9,7,9],[3,3,3,5],[3,7,11,7],[3,8,11,8],[3,11,11,11],[3,0,11,2],[10,9,11,9],[3,16,11,16],[3,17,11,17],[4,3,5,5],[4,6,5,6],[4,9,5,9],[4,12,5,14],[4,15,5,15],[6,3,7,5],[12,0,18,2],[12,3,12,5],[12,7,18,7],[12,8,18,8],[12,11,18,11],[12,12,12,14],[15,12,16,14],[13,15,14,15],[15,3,16,5],[15,6,16,6],[15,9,16,9],[17,3,18,5],[17,6,18,6],[17,9,18,9],[17,12,18,14],[17,15,18,15],[15,15,16,15],[25,3,25,5],[25,12,25,14],[26,3,26,5],[26,12,26,14],[12,16,18,16],[12,17,18,17],[13,3,14,5],[13,6,14,6],[13,9,14,9],[13,12,14,14],[19,16,28,16],[19,17,28,17],[20,3,20,5],[20,12,20,14],[21,3,21,5],[21,12,21,14],[22,3,22,5],[22,12,22,14],[23,3,23,5],[23,12,23,14],[19,0,23,2],[19,3,19,5],[19,7,28,7],[19,8,28,8],[19,11,23,11],[19,12,19,14],[24,0,28,2],[24,3,24,5],[24,11,28,11],[24,12,24,14],[31,17,32,17],[32,0,32,2],[32,3,32,5],[32,12,32,14],[27,12,27,14],[28,3,28,5],[28,12,28,14],[29,0,30,2],[29,3,29,5],[29,7,30,7],[30,12,30,14],[31,0,31,2],[31,3,31,5],[31,8,32,8],[31,12,31,14],[27,3,27,5],[29,8,30,8],[29,11,30,11],[29,12,29,14],[30,3,30,5],[33,0,36,2],[33,3,33,5],[33,11,36,11],[33,12,33,14],[34,3,34,5],[34,7,36,7],[34,8,36,8],[34,12,34,14],[34,16,36,16],[34,17,36,17],[35,3,35,5],[35,12,35,14],[36,3,36,5],[36,12,36,14],[37,4,37,5],[37,6,37,7],[38,4,38,5],[38,6,38,7],[39,4,39,5],[39,6,39,7],[40,4,40,5],[40,6,40,7],[41,4,41,5],[41,6,41,7],[42,4,42,5],[42,6,42,7],[54,0,54,6],[54,7,54,8],[43,4,43,5],[43,6,43,7],[44,4,44,5],[44,6,44,7],[45,4,45,5],[45,6,45,7],[65,1,65,8],[66,1,66,8],[55,0,59,8],[60,0,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[46,4,46,5],[46,6,46,7],[47,4,47,5],[47,6,47,7],[48,4,48,5],[48,6,48,7],[52,0,52,7],[49,4,49,5],[49,6,49,7],[50,4,50,5],[50,6,50,7],[51,4,51,5],[51,6,51,7]]}
[null,"HVAC INCENTIVES",null,null,null,null,"See specs at the bottom of the page! ",null,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"]
["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":"J4","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,"11.8 EER**"]
[]
[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,"11.6 EER**"]
[]
[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,"10.5 EER**"]
[]
[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,"10.2 EER**"]
[]
["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,"11.6 EER** 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,"11.1 EER** 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,"10.0 EER** 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"]
[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",40,20]
["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"]
["Equipment Model","Tons","Efficiency Rating","Quantity","Equipment Type",null,"Size Category",null,"Incentive"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E39=\"\",\"\",IF(LEFT(E39,1)<>\"C\",B39*D39*IF(VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,2,FALSE)>C39,0,VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,3,FALSE)+(C39-(VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,4,FALSE))),B39*D39*IF(VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,2,FALSE)<C39,0,VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,2,FALSE))-C39)*(VLOOKUP(CONCATENATE(E39,G39),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E40=\"\",\"\",IF(LEFT(E40,1)<>\"C\",B40*D40*IF(VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,2,FALSE)>C40,0,VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,3,FALSE)+(C40-(VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,4,FALSE))),B40*D40*IF(VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,2,FALSE)<C40,0,VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,2,FALSE))-C40)*(VLOOKUP(CONCATENATE(E40,G40),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E41=\"\",\"\",IF(LEFT(E41,1)<>\"C\",B41*D41*IF(VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,2,FALSE)>C41,0,VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,3,FALSE)+(C41-(VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,4,FALSE))),B41*D41*IF(VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,2,FALSE)<C41,0,VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,2,FALSE))-C41)*(VLOOKUP(CONCATENATE(E41,G41),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E42=\"\",\"\",IF(LEFT(E42,1)<>\"C\",B42*D42*IF(VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,2,FALSE)>C42,0,VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,3,FALSE)+(C42-(VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,4,FALSE))),B42*D42*IF(VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,2,FALSE)<C42,0,VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,2,FALSE))-C42)*(VLOOKUP(CONCATENATE(E42,G42),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E43=\"\",\"\",IF(LEFT(E43,1)<>\"C\",B43*D43*IF(VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,2,FALSE)>C43,0,VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,3,FALSE)+(C43-(VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,4,FALSE))),B43*D43*IF(VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,2,FALSE)<C43,0,VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,2,FALSE))-C43)*(VLOOKUP(CONCATENATE(E43,G43),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E44=\"\",\"\",IF(LEFT(E44,1)<>\"C\",B44*D44*IF(VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,2,FALSE)>C44,0,VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,3,FALSE)+(C44-(VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,4,FALSE))),B44*D44*IF(VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,2,FALSE)<C44,0,VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,2,FALSE))-C44)*(VLOOKUP(CONCATENATE(E44,G44),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E45=\"\",\"\",IF(LEFT(E45,1)<>\"C\",B45*D45*IF(VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,2,FALSE)>C45,0,VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,3,FALSE)+(C45-(VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,4,FALSE))),B45*D45*IF(VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,2,FALSE)<C45,0,VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,2,FALSE))-C45)*(VLOOKUP(CONCATENATE(E45,G45),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E46=\"\",\"\",IF(LEFT(E46,1)<>\"C\",B46*D46*IF(VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,2,FALSE)>C46,0,VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,3,FALSE)+(C46-(VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,4,FALSE))),B46*D46*IF(VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,2,FALSE)<C46,0,VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,2,FALSE))-C46)*(VLOOKUP(CONCATENATE(E46,G46),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E47=\"\",\"\",IF(LEFT(E47,1)<>\"C\",B47*D47*IF(VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,2,FALSE)>C47,0,VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,3,FALSE)+(C47-(VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,4,FALSE))),B47*D47*IF(VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,2,FALSE)<C47,0,VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,2,FALSE))-C47)*(VLOOKUP(CONCATENATE(E47,G47),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E48=\"\",\"\",IF(LEFT(E48,1)<>\"C\",B48*D48*IF(VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,2,FALSE)>C48,0,VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,3,FALSE)+(C48-(VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,4,FALSE))),B48*D48*IF(VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,2,FALSE)<C48,0,VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,2,FALSE))-C48)*(VLOOKUP(CONCATENATE(E48,G48),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E49=\"\",\"\",IF(LEFT(E49,1)<>\"C\",B49*D49*IF(VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,2,FALSE)>C49,0,VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,3,FALSE)+(C49-(VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,4,FALSE))),B49*D49*IF(VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,2,FALSE)<C49,0,VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,2,FALSE))-C49)*(VLOOKUP(CONCATENATE(E49,G49),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E50=\"\",\"\",IF(LEFT(E50,1)<>\"C\",B50*D50*IF(VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,2,FALSE)>C50,0,VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,3,FALSE)+(C50-(VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,4,FALSE))),B50*D50*IF(VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,2,FALSE)<C50,0,VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,2,FALSE))-C50)*(VLOOKUP(CONCATENATE(E50,G50),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E51=\"\",\"\",IF(LEFT(E51,1)<>\"C\",B51*D51*IF(VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,2,FALSE)>C51,0,VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,3,FALSE)+(C51-(VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,4,FALSE))),B51*D51*IF(VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,2,FALSE)<C51,0,VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,2,FALSE))-C51)*(VLOOKUP(CONCATENATE(E51,G51),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E52=\"\",\"\",IF(LEFT(E52,1)<>\"C\",B52*D52*IF(VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,2,FALSE)>C52,0,VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,3,FALSE)+(C52-(VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,2,FALSE)))*(VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,4,FALSE))),B52*D52*IF(VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,2,FALSE)<C52,0,VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,3,FALSE)+((VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,2,FALSE))-C52)*(VLOOKUP(CONCATENATE(E52,G52),$V$111:$Y$141,4,FALSE))/0.1)))","v":""}]
["Total HVAC Incentives",null,null,null,null,null,null,null,{"$f":"SUM(I39:I52)","v":0}]
[]
["Total All HVAC Form Incentives",null,null,null,null,null,null,{"$f":"SUM(I53)","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 EER 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"]
[]
[]
[" HVAC Specifications","Note: The reference standard in IECC 2018 is ASHRAE 90.1 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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(S113,1)","v":15},14,"Unitary and Split Air Conditioning Systems< 65,000 Btu/h (5.4 tons)",{"$f":"T113","v":15},25,15,{"$f":"W113+1","v":16},{"$f":"Z113+1","v":17},{"$f":"AA113+1","v":18},0,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.714304000000002,{"$f":"ROUND(S114,1)","v":13.7},12,"Unitary and Split Air Conditioning Systems≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",{"$f":"T114","v":13.7},25,15,{"$f":"W114+1","v":14.7},{"$f":"Z114+1","v":15.7},{"$f":"AA114+1","v":16.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.285732000000001,{"$f":"ROUND(S115,1)","v":13.3},12,"Unitary and Split Air Conditioning Systems≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",{"$f":"T115","v":13.3},25,15,{"$f":"W115+1","v":14.3},{"$f":"Z115+1","v":15.3},{"$f":"AA115+1","v":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,{"$f":"ROUND(S116,1)","v":12.4},10.8,"Unitary and Split Air Conditioning Systems≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",{"$f":"T116","v":12.4},25,15,{"$f":"W113+1","v":16},{"$f":"Z113+1","v":17},{"$f":"AA113+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,{"$f":"ROUND(S117,1)","v":12},10.199999999999999,"Unitary and Split Air Conditioning Systems≥ 760,000 Btu/h (> 63 tons)",{"$f":"T117","v":12},25,15,{"$f":"W117+1","v":13},{"$f":"Z117+1","v":14},{"$f":"AA117+1","v":15},63,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.000020000000001,{"$f":"ROUND(S118,1)","v":15},14,"Air Source Heat Pumps< 65,000 Btu/h (5.4 tons)",{"$f":"T118","v":15},40,15,{"$f":"W118+1","v":16},{"$f":"Z118+1","v":17},{"$f":"AA118+1","v":18},0,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.85716,{"$f":"ROUND(S119,1)","v":12.9},11.6,"Air Source Heat Pumps≥ 65,000 Btu/h and \n< 135,000 Btu/h (5.4-11.25 tons)",{"$f":"T119","v":12.9},40,15,{"$f":"W119+1","v":13.9},{"$f":"Z119+1","v":14.9},{"$f":"AA119+1","v":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,{"$f":"ROUND(S120,1)","v":12.4},11.2,"Air Source Heat Pumps≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",{"$f":"T120","v":12.4},40,15,{"$f":"W120+1","v":13.4},{"$f":"Z120+1","v":14.4},{"$f":"AA120+1","v":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,{"$f":"ROUND(S121,1)","v":11.4},10,"Air Source Heat Pumps≥ 240,000 Btu/h and < 760,000 Btu/h (20-63 Tons)",{"$f":"T121","v":11.4},40,15,{"$f":"W118+1","v":16},{"$f":"Z118+1","v":17},{"$f":"AA118+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,{"$f":"ROUND(S122,1)","v":10},10,"Air Source Heat Pumps≥ 760,000 Btu/h (> 63 tons)",{"$f":"T122","v":10},40,15,{"$f":"W122+1","v":11},{"$f":"Z122+1","v":12},{"$f":"AA122+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":"S123","v":0.49500000000000005},0.56899999999999995,"Chillers: Water-Cooled, Centrifugal***≤ 150 tons",{"$f":"T123","v":0.49500000000000005},20,20,0.54,{"$f":"ROUNDUP(W123/0.9*0.7,2)","v":0.39},{"$f":"ROUNDUP(W123/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,{"$f":"S124","v":0.49500000000000005},0.50700000000000001,"Chillers: Water-Cooled, Centrifugal***>150 tons and ≤ 300 tons",{"$f":"T124","v":0.49500000000000005},20,20,0.54,{"$f":"ROUNDUP(W124/0.9*0.7,2)","v":0.39},{"$f":"ROUNDUP(W124/0.9*0.6,2)","v":0.33},150,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46800000000000003,{"$f":"S125","v":0.46800000000000003},0.46700000000000003,"Chillers: Water-Cooled, Centrifugal***> 300 tons to ≤ 400 tons",{"$f":"T125","v":0.46800000000000003},20,20,0.48,{"$f":"ROUNDUP(W125/0.9*0.7,2)","v":0.37},{"$f":"ROUNDUP(W125/0.9*0.6,2)","v":0.32},300,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,{"$f":"S126","v":0.45},"New Size category","Chillers: Water-Cooled, Centrifugal***> 400 tons to ≤ 600 tons",{"$f":"T126","v":0.45},20,20,0.44,{"$f":"ROUNDUP(W126/0.9*0.7,2)","v":0.35},{"$f":"ROUNDUP(W126/0.9*0.6,2)","v":0.3},400,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,{"$f":"S127","v":0.45},"New Size Category","Chillers: Water-Cooled, Centrifugal***> 600",{"$f":"T127","v":0.45},20,20,0.42,{"$f":"ROUNDUP(W127/0.9*0.7,2)","v":0.35},{"$f":"ROUNDUP(W127/0.9*0.6,2)","v":0.3},600,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,{"$f":"S128","v":0.54},0.59199999999999997,"Chillers: Water-Cooled: ReciprocatingALL",{"$f":"T128","v":0.54},20,20,0.54,{"$f":"ROUNDUP(W128/0.9*0.7,2)","v":0.42},{"$f":"ROUNDUP(W128/0.9*0.6,2)","v":0.36},0,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54,{"$f":"S129","v":0.54},"New Size Category","Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***≤ 75 tons",{"$f":"T129","v":0.54},20,20,0.54,{"$f":"ROUNDUP(W129/0.9*0.7,2)","v":0.42},{"$f":"ROUNDUP(W129/0.9*0.6,2)","v":0.36},0,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.504,{"$f":"S130","v":0.504},0.57499999999999996,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 75 tons and ≤ 150 tons",{"$f":"T130","v":0.504},20,20,0.54,{"$f":"ROUNDUP(W130/0.9*0.7,2)","v":0.4},{"$f":"ROUNDUP(W130/0.9*0.6,2)","v":0.34},75,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48599999999999999,{"$f":"S131","v":0.48599999999999999},0.53400000000000003,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***>150 tons and ≤ 300 tons",{"$f":"T131","v":0.48599999999999999},20,20,0.5,{"$f":"ROUNDUP(W131/0.9*0.7,2)","v":0.38},{"$f":"ROUNDUP(W131/0.9*0.6,2)","v":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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46800000000000003,{"$f":"S132","v":0.46800000000000003},0.48599999999999999,"Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 300 tons and ≤ 600 tons",{"$f":"T132","v":0.46800000000000003},20,20,0.46,{"$f":"ROUNDUP(W132/0.9*0.7,2)","v":0.37},{"$f":"ROUNDUP(W132/0.9*0.6,2)","v":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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,{"$f":"S133","v":0.45},"New Size Category","Chillers: Water Cooled Scroll, Helical-Rotary or Reciprocating***> 600 tons",{"$f":"T133","v":0.45},20,20,0.42,{"$f":"ROUNDUP(W133/0.9*0.7,2)","v":0.35},{"$f":"ROUNDUP(W133/0.9*0.6,2)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78800000000000003,{"$f":"S134","v":0.78800000000000003},0.86699999999999999,"Chillers: Air-Cooled≤ 150",{"$f":"T134","v":0.78800000000000003},40,20,{"$f":"ROUND(W134/0.9*0.8,2)","v":0.7},{"$f":"ROUNDUP(W134/0.9*0.7,2)","v":0.62},{"$f":"ROUNDUP(W134/0.9*0.6,2)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77100000000000002,{"$f":"S135","v":0.77100000000000002},0.86699999999999999,"Chillers: Air-Cooled> 150",{"$f":"T135","v":0.77100000000000002},40,20,{"$f":"ROUND(W135/0.9*0.8,2)","v":0.69},{"$f":"ROUNDUP(W135/0.9*0.7,2)","v":0.6},{"$f":"ROUNDUP(W135/0.9*0.6,2)","v":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,14.5,{"$f":"S136","v":14.5},{"$f":"12.5-(0.213*B39*12000/1000)","v":12.5},"Packaged Terminal ACALL",{"$f":"T136","v":14.5},50,0,{"$f":"W136+1","v":15.5},{"$f":"Z136+1","v":16.5},{"$f":"AA136+1","v":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,14.5,{"$f":"S137","v":14.5},{"$f":"12.3-(0.213*B40*12000/1000)","v":12.3},"Packaged Terminal HPALL",{"$f":"T137","v":14.5},100,0,{"$f":"W137+1","v":15.5},{"$f":"Z137+1","v":16.5},{"$f":"AA137+1","v":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(S138,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)",{"$f":"T138","v":15.4},40,25,{"$f":"W138+1","v":16.399999999999999},{"$f":"Z138+1","v":17.399999999999999},{"$f":"AA138+1","v":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,{"$f":"ROUND(S139,1)","v":14.7},14.2,"Variable Refrigerant Flow HP≥ 135,000 Btu/h and < 240,000 Btu/h (11.25-20 tons)",{"$f":"T139","v":14.7},40,25,{"$f":"W139+1","v":15.7},{"$f":"Z139+1","v":16.7},{"$f":"AA139+1","v":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,{"$f":"ROUND(S140,1)","v":13.4},12.7,"Variable Refrigerant Flow HP≥ 240,000 Btu/h (20 Tons)",{"$f":"T140","v":13.4},40,25,{"$f":"W140+1","v":14.4},{"$f":"Z140+1","v":15.4},{"$f":"AA140+1","v":16.399999999999999},20,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.928590000000002,{"$f":"ROUND(S141,1)","v":13.9},15.6,"Variable Refrigerant Flow HP< 65,000 Btu/h (5.4 tons)",{"$f":"T141","v":13.9},40,25,{"$f":"W141+1","v":14.9},{"$f":"Z141+1","v":15.9},{"$f":"AA141+1","v":16.899999999999999},63,100000]
[]
[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,"Categories","Column1","Column2"]
[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,"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,null,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,null,null,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,null,null,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,null,null,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,"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,"Unitary and Split Air Conditioning Systems","< 65,000 Btu/h (5.4 tons)"]

{"sheet":"Custom","index":7,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,5,0,6],[3,0,3,6],[27,0,27,2],[4,0,14,6],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[2,0,2,6],[28,0,28,6],[17,4,27,4],[17,5,27,6],[15,0,15,3],[15,5,15,6],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2]]}
[null,null,null,"CUSTOM INCENTIVES"]
["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,null,null,{"$f":"IF(ISNUMBER(F5)=TRUE,F5,0)","v":0}]
[]
[]
[]
[]
[]
[]
["Information",null,null,null,"$/kWh","Subtotal"]
[]
["Annual kWh Savings",null,null,null,0.08,{"$f":"IF(AND(D18>0,D24>0,D26>0),MIN(D18*E18,D24,0.5*D26),0)","v":0}]
[]
["kW Savings"]
[]
["Annual Operating Hours",null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F18)=TRUE,F18,0)","v":0}]
[]
["Incremental Measure Cost"]
[]
["Total Project Cost"]
[]
["Simple Payback",null,null,{"$f":"IFERROR(ROUND(D24/(D18*0.11+F18+D20*12),1)&\" Years\",\"\")","v":""}]