{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Form Instructions","Project Information","Checklist & Acknowledgement","Terms and Conditions","Equipment Input Instructions","HVAC Unitary","Window Film","HVAC Chillers","VFDs","Inventory Instructions","Inputs","Input Key","Validation","Measure Code Summary","Version Tracking","Lookups","Old Summary","AEG Import"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":34,"defined_names":1432,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form Instructions","index":0,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,18],[2,5,2,13],[3,5,3,13],[4,5,4,13],[13,10,15,18],[10,4,10,14],[10,17,10,18],[17,10,17,18],[19,10,19,18],[11,10,11,18],[12,0,13,8],[16,0,17,8],[19,0,19,8],[12,10,12,18],[14,0,15,8],[18,0,18,9],[18,10,18,18]]}
[]
[]
[null,null,null,null,null,"HVAC Application - Electronic Version"]
[null,null,null,null,null,"Dominion Energy South Carolina, Inc. "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"*If an error occurs when using buttons above, manually navigate to appropriate tab         ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 10.1"}]
["Application and Instructions",null,null,null,null,null,null,null,null,null,"Participation Instructions"]
["The EnergyWise for Your Business Program is designed to help non-residential\ncustomers replace aging, inefficient equipment and systems with energy-efficient technologies. The program provides customers with incentives and technical assistance that will facilitate the installation of premium efficient equipment. For each program year (December 1–November 30), EnergyWise for Your Business incentive payments are capped per Customer Federal tax ID number at $100,000. Details of the program, including incentive levels and technical requirements, are subject to change without prior notice. \n\nEligible Participants\nEnergyWise for Your Business is open to all non-residential electric customers within our service territory, except for industrial customers and certain large retail customers that have elected to opt out of the Demand Side Management (DSM) programs by notifying us in writing using the Opt-Out form.\n\nEligible Equipment\nEligible equipment and incentive amounts are listed on the Equipment Tabs.  \n\nPre-Approval Requirements\nAll projects require pre-approval prior to purchasing and installing any equipment except for eligible HVAC Unitary projects with total incentives less than or equal to $5,000.  After the application has been pre-approved by us, the customer will be notified in writing, assigned a project identification number, and given any specific instructions. The customer may then purchase and install the pre-approved equipment. For projects not requiring pre-approval, the applicant can purchase and install the qualifying equipment and submit a completed application form and supporting documentation within 60 days of the equipment’s invoice date. ",null,null,null,null,null,null,null,null,null,"Please review the program Terms and Conditions tab for program rules and requirements.  Tabs colored Blue should be filled in by applicant. Applicant should complete at least one applicable Blue Equipment tab for submission."]
[null,null,null,null,null,null,null,null,null,null,"Step 1\nReview program materials to confirm your proposed equipment meets program requirements. Visit the program website at www.DominionEnergySC.com/ForYourBusiness or contact us at SCEnergyExperts@DominionEnergySC.com or 877-784-7234 with any questions about eligibility.\n\nStep 2\n→  Complete the Project Information tab.  Please indicate the mailing address for all correspondence under the Customer Contact Information including incentive checks if applicable.  Please indicate if the incentive payment should be made payable to the customer of record or a third party, such as the installation contractor. All incentive payments require authorization from the customer of record. IRS Form W-9 must be completed for the party receiving the incentive payment from us. This form is available at www.irs.gov. Regardless of who is receiving the incentive payment, the customer’s Federal tax ID number must be provided on this tab. \n\n→  Complete at least one Equipment Tab.\n\n→ Complete the Checklist and Acknowledgement tab.  Provide customer signature and verify that all required information and documentation are included for submission to us.  Incomplete applications will not be accepted and will be returned to the customer for completion.\n\n→ Complete application packages must be submitted by email."]
["Eligible equipment include HVAC Unitary equipment, Window Film, HVAC Chillers and Variable Frequency Drives (VFDs) . These measures are subject to the associated technical eligibility criteria described on the individual equipment tab. All equipment must be new; used or refurbished equipment is not eligible. \n\nPre-Approval Requirements\nAll projects require pre-approval prior to ordering, purchasing or installing any equipment \n"]
[]
["except for eligible HVAC Unitary projects with total incentives less than or equal to $5,000.  After the application has been pre-approved by us, the customer will be notified in writing, assigned a project identification number, and given any specific instructions. The customer may then purchase and install the pre-approved equipment. For projects not requiring pre-approval, the applicant can purchase and install the qualifying equipment and submit a completed application form, supporting documentation and invoice within 60 days of the project invoice date. \n\n\n\n\n",null,null,null,null,null,null,null,null,null,"Email:","SCEnergyExperts@DominionEnergySC.com"]
[null,null,null,null,null,null,null,null,null,null,"Step 3\nApplications will be processed and we will notify the customer in writing when the review is complete and funds have been reserved. Upon receipt of program pre-approval, customers may order, purchase and install their energy efficient equipment. We will notify customers if an inspection of the facility is necessary prior to pre-approval.  Eligible HVAC Unitary projects with total incentives less than or equal to $5,000 do not require pre-approval from us. The applicant may purchase and install the qualifying equipment and submit a completed application form and supporting documentation, including final invoice, within 60 days of the project invoice date.\n\nAny changes in the proposed equipment, quantities, or operating conditions\nmust be approved by us prior to implementing."]
["Questions\nIf you have questions about the program, call 877-784-7234, email SCEnergyExperts@DominionEnergySC.com, or visit www.DominionEnergySC.com/ForYourBusiness.",null,null,null,null,null,null,null,null,null,"Step 4\nFor all projects requiring pre-approval, upon project completion, please return the signed customer acknowledgment at bottom of the pre-approval letter along with proof of purchase. We will notify customers if an inspection of the facility is necessary prior to final payment processing."]

{"sheet":"Project Information","index":1,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[24,0,24,14],[31,0,31,2],[31,3,31,9],[31,11,31,14],[32,0,32,2],[32,3,32,6],[32,8,32,9],[32,11,32,14],[42,0,42,9],[25,0,25,14],[26,0,26,16383],[27,0,27,14],[28,0,28,2],[28,3,28,14],[29,0,29,2],[29,3,29,14],[30,0,30,2],[30,3,30,6],[30,8,30,9],[30,11,30,14],[22,11,22,14],[23,0,23,2],[23,3,23,6],[23,8,23,9],[23,11,23,14],[20,0,20,2],[20,3,20,14],[40,0,40,5],[40,6,40,9],[40,10,40,12],[40,13,40,14],[33,0,33,14],[36,3,36,9],[37,0,37,3],[38,0,38,9],[21,0,21,2],[21,3,21,6],[21,8,21,9],[21,11,21,14],[22,0,22,2],[22,3,22,9],[18,0,18,14],[19,0,19,2],[19,3,19,14],[41,1,41,14],[8,11,8,13],[39,0,39,2],[39,3,39,9],[39,11,39,14],[16,0,16,2],[16,3,16,6],[16,8,16,9],[16,11,16,14],[17,0,17,14],[34,0,34,14],[35,0,35,14],[36,0,36,2],[15,0,15,2],[15,3,15,9],[15,11,15,14],[9,0,9,7],[10,0,10,14],[11,0,11,14],[12,0,12,2],[12,3,12,14],[13,0,13,14],[14,0,14,2],[14,3,14,6],[14,8,14,9],[14,11,14,14],[7,0,7,9],[3,0,3,2],[3,3,3,9],[3,10,3,12],[3,13,3,14],[4,0,4,2],[4,3,4,9],[4,10,4,12],[4,13,4,14],[5,0,5,2],[5,3,5,6],[5,8,5,9],[5,11,5,14],[6,0,6,12],[0,0,0,14],[1,0,1,14],[2,0,2,2],[2,3,2,9],[2,10,2,12],[2,13,2,14]]}
["Fill in Blue and Orange Cells Only!"]
["PROJECT INFORMATION"]
["Application Date    ",null,null,null,null,null,null,null,null,null,"Expected Completion Date"]
["Company Name    ",null,null,null,null,null,null,null,null,null,"Electric Account # "]
["Street Address (of the facility) ",null,null,null,null,null,null,null,null,null,"Customer Federal Tax ID "]
["City   ",null,null,null,null,null,null,"State   ","SC",null,"Zip  "]
["Building Type (select one)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Please indicate \"other\" type:"]
["Project Type (select one )"]
[]
["CUSTOMER CONTACT INFORMATION"]
["Mailing Address"]
["(where all correspondence will be mailed, including incentive check if payment is to the customer)"]
["City   ",null,null,null,null,null,null,"State   ",null,null,"Zip  "]
["Contact Person     ",null,null,null,null,null,null,null,null,null,"Title"]
["Telephone No.       ",null,null,null,null,null,null,"Fax No.",null,null,"Email "]
[]
["CONTRACTOR INFORMATION"]
["Company Name  "]
["Street Address   "]
["City   ",null,null,null,null,null,null,"State   ",null,null,"Zip  "]
["Contact Person     ",null,null,null,null,null,null,null,null,null,"Title"]
["Telephone No.       ",null,null,null,null,null,null,"Fax No.",null,null,"Email "]
[]
["Please indicate if the Customer or Contractor should be primary point of contact for this project.  If another party should be primary point of contact, please indicate below:"]
["             Customer                                          Contractor                                   Other (fill out below)"]
["PRIMARY POINT OF CONTACT (IF APPLICABLE)"]
["Company Name  "]
["Street Address   "]
["City   ",null,null,null,null,null,null,"State   ",null,null,"Zip  "]
["Contact Person     ",null,null,null,null,null,null,null,null,null,"Title"]
["Telephone No.       ",null,null,null,null,null,null,"Fax No.",null,null,"Email "]
[]
["PAYMENT INFORMATION"]
["Payment to: "]
["Federal Tax ID # (of recipient)"]
["Tax Status of Recipient (select one)"]
[]
["Customer Name",null,null,null,null,null,null,null,null,null,"Title"]
["Customer Signature (if payment to contractor, Customer must type his/her name to the right and check the box below)    ",null,null,null,null,null,null,null,null,null,"Date (XX/XX/XXXX)"]
[null,"I understand and intend that my electronic, PDF or facsimile signature be accepted and have the same force and effect as an original signature."]
["Dominion Energy South Carolina, Inc. HVAC Application - Electronic Version",null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"'Version Tracking'!C4","v":10.1}]

{"sheet":"Checklist & Acknowledgement","index":2,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,1,20,14],[15,0,15,14],[16,0,16,14],[18,0,19,2],[18,3,19,7],[18,8,18,9],[18,10,18,14],[19,8,19,12],[19,13,19,14],[10,0,10,14],[0,0,0,14],[1,0,1,14],[2,0,2,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[7,0,7,14],[8,0,8,14],[9,0,9,14],[3,0,3,14],[14,1,14,14],[11,0,11,14],[12,0,13,2],[12,3,13,7],[12,8,12,9],[12,10,12,14],[13,8,13,12],[13,13,13,14]]}
["Fill in Blue and Orange Cells Only!"]
["APPLICATION CHECKLIST"]
["For faster application processing, please include the following items with your application:"]
["     Complete application (Project Information Tab, Customer Acknowledgment below and at least one Equipment tab."]
["     Electric account number (on Project Information tab). Attach copy of electric bill."]
["     IRS Form W-9 completed for payment recipient (available at www.irs.gov). If payment is to a contractor, customer's W-9 must also be provided."]
["     Supporting documentation to include manufacturer’s specification (cut) sheets for equipment included in this application."]
["     Customer signature and proof of purchase (contractor receipts), at time of project completion."]
["Applications submitted for processing will be processed in the order in which they are received. Applicants will be notified as to their pre-approval status and/or any pre-inspection requirements within 10 business days from receipt of complete application. Applicants will be notified if post-installation inspections are required prior to final payment."]
[]
["CUSTOMER ACKNOWLEDGMENT"]
["For HVAC Unitary Projects Not Requiring Pre-Approval < $5,000 Incentive"]
["Authorized Representative  ",null,null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,null,null,"Date (XX/XX/XXXX)"]
[null,"By checking this box and typing my name, I hereby certify that all statements made on this application are correct to the best of my knowledge and that I have read and agree to the Terms and Conditions. Furthermore, I understand and intend that my electronic, PDF or facsimile signature be accepted and have the same force and effect as an original signature.\n\nNote: Application must include supporting documentation and copy of invoice that is dated within 60 days before application date."]
["CUSTOMER ACKNOWLEDGMENT"]
["For All Projects Requiring Pre-Approval "]
[]
["Authorized Representative  ",null,null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,null,null,"Date (XX/XX/XXXX)"]
[null,"By checking this box and typing my name, I hereby certify that all statements made on this application are correct to the best of my knowledge and that I have read and agree to the Terms and Conditions. Furthermore, I understand and intend that my electronic, PDF or facsimile signature be accepted and have the same force and effect as an original signature.\n\nNote: Upon completion of project, customer of record must sign and return the written pre-approval letter and provide invoices for all energy efficiency measures."]
["Dominion Energy South Carolina, Inc. HVAC Application - Electronic                                                                                                                                                                                                                                                      Version 3.7",null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"'Version Tracking'!C4","v":10.1}]

{"sheet":"Terms and Conditions","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["Dominion Energy South Carolina, Inc."]
["TERMS AND CONDITIONS"]
["1.  Eligibility:  EnergyWise for Your Business Program (“Program”) incentives are available to non-residential electric customers for the purchase and installation of qualifying energy conservation measures (ECMs) in the Dominion Energy South Carolina service territory, subject to these Terms and Conditions (T&Cs). The process of purchasing and installing ECMs for an eligible Customer pursuant to the Program is referred to herein as a “Project.” Industrial customers and specific large retail customers who have elected to opt out of Demand Side Management programs, by notifying Dominion Energy South Carolina in writing using the Opt-Out form provided, are not eligible to participate. Dominion Energy South Carolina and our program implementer (“Implementer”) (together, “We”) reserve the right to deny any application that may result in exceeding our Program budget. Program incentives are limited, offered on a first-come/first-served basis, and are subject to Project and Customer eligibility and funds availability. For each Program year (December 1–November 30), Program incentive payments are capped per Customer Federal tax ID number at $100,000.\n2.  Authorization, Program Changes, Suspension, or Cancellation: We may change the program requirements, incentives or T&Cs, including suspending acceptance of applications or terminating the program, at any time and without notice. In the event of a program change, pre-approved applications will be processed to completion under the T&Cs in effect at time of pre-approval. Submission of a completed application does\nnot entitle Customer to program participation. For all projects, entitlement to program  participation and our obligation to pay incentives may occur only after we have granted written authorization, which we may grant or not at its sole discretion.","7.  Customer Tax Obligation: Customer or Customer’s designated contractor is responsible for declaring and paying any and all applicable federal, state, and local taxes that may be owed on any incentive payment. Neither Dominion Energy South Carolina, Inc. nor any of its subsidiaries shall be liable for any federal, state, and local taxes that may be owed on or as a result of any incentive payment. The party receiving the incentive payment (Customer or Contractor) must complete IRS Form W-9 and submit it to us with the incentive application materials. If payment is to a contractor, customer's W-9 must also be provided.\n8.  Compliance: Customer is responsible for obtaining any and all necessary licenses and permits related to the installation of ECMs. Customer also agrees to comply with all federal, state, and local laws, codes, and regulations related to the installation and disposal of all equipment.\n9.  Removal of Equipment: Customer agrees to remove and dispose of the equipment being replaced by the ECMs in accordance with all legal requirements. Customer agrees not to re-install any of this equipment in our service territory or transfer it to any other party for such installation.\n10.  Replacement of Failed Equipment: Customers who install ECMs are expected to replace any of the ECMs that fail with similar or superior energy savings equipment at Customer’s expense."]
["\n3.  Project Approval: Pre-approval is required for all projects except for eligible HVAC Unitary projects with total incentives less than or equal to $5,000. For projects not requiring pre-approval, the customer may purchase and install the qualifying equipment and submit a completed application form, supporting documentation and invoice within 60 days of the equipment’s invoice date. For projects requiring pre-approval, we reserve the right to inspect any project prior to pre-approval. For projects requiring pre-approval, no project-related ECMs may be ordered or installed prior to the date of our pre-approval. Violation of this prohibition will disqualify the ECM for incentives. Pre-approved projects must be completed by the date listed on the pre-approval notification letter (within 180 calendar days for retrofit projects or one year for new construction projects).\n4. Creditworthiness: An incentive payment is conditioned upon and subject to Customer maintaining its financial creditworthiness and keeping its account in good standing.   At any time prior to an issuance of an incentive check, we may request financial information to support its financial due diligence procedures. Customer agrees to assist in this reasonable financial review.  If we believe in good faith that the Customer’s account is not in good standing, or if creditworthiness of participant has been diminished, we may reject approval of an incentive payment.  ","11.  Evaluation Follow-up Visits: With advance notice, we reserve the right to make or to have its contractor(s) make follow-up visits to Customer facilities during the 36 months following completion of the project to provide us with an opportunity to review the operation of the ECMs for program evaluation purposes. Customer agrees to cooperate with this effort.\n12.  Contractor Selection: Customer may select any contractor to perform the work contemplated by the application, even after the application is pre-approved by us. However, we reserve the right, in its sole discretion, to prohibit specific contractors from program participation.\n13.  No Warranties: Dominion Energy South Carolina, Inc. does not endorse, guarantee, or warrant any particular manufacturer or product and we provide no warranties, express or implied, for any products or services, and herein specifically disclaims any such guarantees or warranties. We are not liable or responsible for any act or omission of any contractor hired by Customer. Customer’s reliance on warranties is limited to any warranties that may arise from, or be provided by contractors, vendors, etc. Customer acknowledges that neither Dominion Energy South Carolina nor any of its consultants are responsible for ensuring that the design, engineering, and construction of the facility or installation of the ECMs are proper or comply with any particular laws (including patent laws), codes, regulations, or industry standards. We make no representations of any kind regarding the results to be achieved by the ECMs or the adequacy or safety of such measures. \n\n"]
["\n5.  Proof of Purchase: Prior to our verification of the ECM installation, Customer must provide copies of all invoices or other appropriate documentation that clearly verifies the costs of purchasing and installing the ECMs, including all material, labor, and equipment discounts. Invoices must indicate a verifiable breakout of all ECMs purchased for installation under the ECM incentives application, including model numbers and quantity.\n6.  Project Verification: We (or our Third-Party Evaluator “Evaluator”) may conduct an inspection of Customer’s facility to verify pre- and post-installation conditions or verify documentation prior to incentive payment at any time after receipt of an application. No warranty is expressed or implied by this verification. We are not obligated to pay any incentive until it has performed a satisfactory post-installation inspection. Should we determine that ECMs were not installed in accordance with the approved application, or if an unapproved ECM was installed, or if the installation was not consistent  with generally accepted engineering/construction practices, changes may be required before  payment is issued. Notwithstanding anything to the contrary, should we determine at any point  before payment of the incentive that there has been significant deviation in the type, amount, cost  or performance of the ECMs underlying this incentive commitment that were set forth in the  program application and pre-approved, we retain the right to revoke this ","\n14.  Assumption of Risk and Limitation of Liability: Customer assumes and acknowledges all risks arising from its participation in the Program including but not limited to exposure to the novel coronavirus (“COVID-19”) and releases and discharges Dominion Energy, Inc., Dominion Energy South Carolina, its Implementer, Evaluator, and their respective officers, directors, employees and agents from any liability related thereto. Our sole obligation is limited to paying the properly qualified rebates specified herein. Neither Dominion Energy South Carolina, Inc., any of its subsidiaries, nor its Implementer or Evaluator shall be  liable to Customer or any other party for any special, indirect, consequential, or incidental damages,  regardless of the theory of recovery, caused by or arising from any activities associated with this  program.\n15.  Obligations between the Parties: Customer acknowledges that any contractor selected by Customer is not an agent, contractor, or subcontractor of Dominion Energy South Carolina and is an independent contractor engaged by Customer, and that we do not manage or control the contractor’s performance. We shall have no obligation to maintain, remove, or perform any work whatsoever on the ECMs installed. We shall have no liability for a contractor’s failure to perform, for failure of the energy savings measures to function, for any damage to Customer’s premises caused by the contractor, or for any and all damages to property or injuries to persons caused by or associated with the energy savings measures.\n"]
["commitment or reduce the  final incentive amount accordingly. We reserve this right despite a satisfactory post-installation inspection. Customer agrees to provide prompt notice to us of any significant deviation in the type, amount, cost or performance of the ECMs underlying this incentive commitment that were set forth in the program application and pre-approved by us.","16.  Miscellaneous: These T&Cs and this application, of which these T&Cs are an integral part, constitute the entire agreement between the parties and supersede all other communications, representations, and understandings."]
[null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 10.1"}]

{"sheet":"Equipment Input Instructions","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[13,3,13,6]]}
[]
[]
[]
[]
[null,"HVAC Application - Electronic Version"]
[]
[null,null,null,"Copyright © 2015 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[]
[]
[]
[]
[]
[null,null,null,"*If an error occurs when using buttons above, manually navigate to appropriate tab"]
[]
[null,null,"Instructions"]
[null,null,"The following tabs are available Equipment tabs for the HVAC Application"]
[null,null,"▪   HVAC Unitary - Unitary and split systems, PTACs and PTHPs"]
[null,null,"▪   Window Film - Window glazing on commercial buildings"]
[null,null,"▪   HVAC Chillers - Single speed air-cooled, single speed water-cooled and variable speed water cooled"]
[null,null,"▪   VFDs - For HVAC equipment"]
[]
[null,null,"1. Read technical requirements on each specific Equipment tab."]
[null,null,"2. Enter make, model, quantity and other specific equipment specifications of equipment being applied for in shaded areas of applicable Equipment tab(s)"]
[null,null,"3. Measure Code Summary tab will be automatically populated based on Equipment tab entries."]
[null,null,"4. Application packages must be submitted by email."]
[null,null,null,"Email Address:"]
[null,null,null,"SCEnergyExperts@DominionEnergySC.com"]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 10.1"}]

{"sheet":"HVAC Unitary","index":5,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[39,0,39,2],[39,3,39,5],[39,6,39,7],[39,9,39,10],[36,0,36,2],[37,0,37,2],[37,3,37,5],[37,6,37,7],[37,9,37,10],[38,0,38,2],[38,3,38,5],[38,6,38,7],[38,9,38,10],[51,9,51,10],[52,9,52,10],[29,3,29,5],[29,6,29,7],[29,9,29,10],[29,8,30,8],[47,6,47,7],[48,6,48,7],[43,0,43,2],[43,3,43,5],[44,0,44,2],[44,3,44,5],[43,9,43,10],[44,9,44,10],[43,6,43,7],[44,6,44,7],[41,0,41,11],[42,0,42,2],[42,3,42,5],[42,9,42,10],[40,0,40,2],[40,3,40,5],[40,6,40,7],[40,9,40,10],[53,0,53,11],[27,9,27,10],[27,6,27,7],[30,6,30,7],[31,6,31,7],[33,6,33,7],[49,0,49,11],[50,0,50,2],[50,3,52,5],[51,0,51,2],[52,0,52,2],[50,6,50,7],[51,6,51,7],[45,0,45,11],[46,0,46,2],[46,3,48,5],[47,0,47,2],[48,0,48,2],[46,9,46,10],[47,9,47,10],[35,0,35,11],[36,3,36,5],[36,6,36,7],[36,9,36,10],[46,6,46,7],[52,6,52,7],[48,9,48,10],[50,9,50,10],[34,3,34,5],[34,6,34,7],[33,9,33,10],[34,9,34,10],[28,0,28,11],[30,3,30,5],[31,0,31,2],[31,3,31,5],[30,9,30,10],[31,9,31,10],[29,0,30,2],[29,11,30,11],[32,0,32,2],[32,3,32,5],[32,6,32,7],[32,9,32,10],[42,6,42,7],[33,0,33,2],[33,3,33,5],[34,0,34,2],[23,0,23,9],[25,0,25,11],[26,0,26,11],[27,0,27,2],[27,3,27,5],[20,1,20,2],[20,10,20,11],[21,1,21,2],[21,10,21,11],[22,1,22,2],[22,10,22,11],[17,1,17,2],[17,10,17,11],[18,1,18,2],[18,10,18,11],[19,1,19,2],[19,10,19,11],[14,1,14,2],[14,10,14,11],[15,1,15,2],[15,10,15,11],[16,1,16,2],[16,10,16,11],[11,1,11,2],[11,10,11,11],[12,1,12,2],[12,10,12,11],[13,1,13,2],[13,10,13,11],[8,1,8,2],[8,10,8,11],[9,1,9,2],[9,10,9,11],[10,1,10,2],[10,10,10,11],[6,9,7,9],[6,10,7,11],[6,5,6,8],[6,0,7,0],[6,1,7,2],[6,3,7,3],[6,4,7,4],[0,0,0,17],[1,0,1,17],[2,0,2,17],[3,0,3,17],[6,12,7,12],[4,1,4,2],[4,6,4,7],[4,10,4,11],[4,8,4,9],[4,3,4,5]]}
["Fill in Blue Cells Only!"]
[" HVAC UNITARY TECHNICAL REQUIREMENTS"]
["§ Unitary and split system cooling equipment must meet Air-Conditioning and Refrigeration Institute (ARI) standards (210/240, 320, or 340/360), be certified by a Nationally Recognized Testing Laboratory (NRTL), and use a minimum ozone-depleting refrigerant (e.g., HCFC or HFC).\n§ Electric heat pumps, single packaged units, and split systems are eligible systems.\n§ Qualifying split systems must have both a new condenser and a new coil that meet ARI specifications, and matched system performance (condenser and coil) must meet or exceed the minimum SEER/EER/COP outlined in Table 2.\n§ Units being installed must meet both EER and IEER efficiency values to fulfill the requirements."]
["TABLE 1: HVAC EQUIPMENT INFORMATION"]
["S = Split A/C","U = Unitary A/C",null,"H = Split or Unitary Heat Pump",null,null,"P = PTAC",null,"T = PTHP",null,"W = Water and Evaporative"]
[]
["Equipment Type","Manufacturer",null,"Model #","Unit Size (Tons)","Unit Efficiency",null,null,null,"Quantity","Incentive $ / Ton",null,"Subtotal Incentive"]
[null,null,null,null,null,"SEER","EER","IEER","COP",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1","Tier 2"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(W9=\"Yes\", E9<63.3)),75,IF(OR(AND(W9=\"No\",V9=\"Yes\", E9<63.3)),50,IF(OR(AND(W9=\"Yes\", E9>=63.3)),20,IF(OR(AND(W9=\"No\", V9=\"Yes\", E9>=63.3)),15,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"W\")),60,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"P\",E9<0.75)),20,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"P\",E9>=0.75,E9<1)),25,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"P\",E9>=1)),35,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"T\",E9<0.75)),20,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"T\",E9>=0.75,E9<1)),25,IF(OR(AND(W9=\"N/A\",V9=\"Yes\",A9=\"T\",E9>=1)),30,0)))))))))))","v":0},null,{"$f":"IF(OR(AND(A9=\"P\")),J9*K9,IF(OR(AND(A9=\"T\")),J9*K9,E9*J9*K9))","v":0},null,null,null,null,null,null,null,"S",{"$f":"IF(OR(AND(A9=\"S\", E9<5.4, F9>=15, G9>=12),AND(A9=\"U\", E9<5.4, F9>=15, G9>=11.6),AND(A9=\"H\", E9<5.4, F9>=15, G9>=14.3),AND(A9=\"S\", E9>=5.4, E9<11.25, G9>=12, H9>=13.4),AND(A9=\"U\", E9>=5.4, E9<11.25, G9>=12, H9>=13.4),AND(A9=\"H\", E9>=5.4, E9<11.25, G9>=12, H9>=13.4),AND(A9=\"S\",E9>=11.25,E9<20,G9>=11.8,H9>=12.8),AND(A9=\"U\",E9>=11.25,E9<20,G9>=11.8,H9>=12.8),AND(A9=\"H\",E9>=11.25,E9<20,G9>=11.8,H9>=12.8),AND(A9=\"S\", E9>=20, E9<63.3, G9>=10.6, H9>=12.1),AND(A9=\"U\", E9>=20, E9<63.3, G9>=10.6, H9>=12.1),AND(A9=\"H\", E9>=20, E9<63.3, G9>=10.6, H9>=12.1),AND(A9=\"S\", E9>=63.3, G9>=10.3, H9>=12),AND(A9=\"U\", E9>=63.3, G9>=10.3, H9>=12),AND(A9=\"H\", E9>=63.3, G9>=10.3, H9>=12),AND(A9=\"W\", E9<5.4,G9>=14,H9>=13.4),AND(A9=\"W\",E9>=5.4,E9<11.25,G9>=12.8,H9>=13.1),AND(A9=\"W\",E9>=11.25,G9>=12,H9>=12.4),AND(A9=\"P\", E9<0.75, G9>=12),AND(A9=\"P\", E9>=0.75, E9<1, G9>=11.5),AND(A9=\"P\", E9>=1, G9>=10.5),AND(A9=\"T\", E9<0.75, G9>=12, I9>=3.3),AND(A9=\"T\", E9>=0.75, E9<1, G9>=11.5, I9>=3.2),AND(A9=\"T\", E9>=1, G9>=10.3, I9>=3.2)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(A9=\"S\", E9<5.4, F9>=16, G9>=12.5),AND(A9=\"U\", E9<5.4, F9>=16, G9>=12),AND(A9=\"H\", E9<5.4, F9>=16, G9>=14.6),AND(A9=\"S\", E9>=5.4, E9<11.25, G9>=12, H9>=13.8),AND(A9=\"U\", E9>=5.4, E9<11.25, G9>=12, H9>=13.8),AND(A9=\"H\", E9>=5.4, E9<11.25, G9>=12, H9>=13.8),AND(A9=\"S\",E9>=11.25,E9<20,G9>=11.8,H9>=13.2),AND(A9=\"U\",E9>=11.25,E9<20,G9>=11.8,H9>=13.2),AND(A9=\"H\",E9>=11.25,E9<20,G9>=11.8,H9>=13.2),AND(A9=\"S\", E9>=20, E9<63.3, G9>=10.6, H9>=12.4),AND(A9=\"U\", E9>=20, E9<63.3, G9>=10.6, H9>=12.4),AND(A9=\"H\", E9>=20, E9<63.3, G9>=10.6, H9>=12.4),AND(A9=\"S\", E9>=63.3, G9>=10.3, H9>=12.3),AND(A9=\"U\", E9>=63.3, G9>=10.3, H9>=12.3),AND(A9=\"H\", E9>=63.3, G9>=10.3, H9>=12.3)),\"Yes\",IF(OR(AND(A9=\"W\"),AND(A9=\"P\"),AND(A9=\"T\")),\"N/A\",\"No\"))","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(W10=\"Yes\", E10<63.3)),75,IF(OR(AND(W10=\"No\",V10=\"Yes\", E10<63.3)),50,IF(OR(AND(W10=\"Yes\", E10>=63.3)),20,IF(OR(AND(W10=\"No\", V10=\"Yes\", E10>=63.3)),15,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"W\")),60,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"P\",E10<0.75)),20,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"P\",E10>=0.75,E10<1)),25,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"P\",E10>=1)),35,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"T\",E10<0.75)),20,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"T\",E10>=0.75,E10<1)),25,IF(OR(AND(W10=\"N/A\",V10=\"Yes\",A10=\"T\",E10>=1)),30,0)))))))))))","v":0},null,{"$f":"IF(OR(AND(A10=\"P\")),J10*K10,IF(OR(AND(A10=\"T\")),J10*K10,E10*J10*K10))","v":0},null,null,null,null,null,null,null,"U",{"$f":"IF(OR(AND(A10=\"S\", E10<5.4, F10>=15, G10>=12),AND(A10=\"U\", E10<5.4, F10>=15, G10>=11.6),AND(A10=\"H\", E10<5.4, F10>=15, G10>=14.3),AND(A10=\"S\", E10>=5.4, E10<11.25, G10>=12, H10>=13.4),AND(A10=\"U\", E10>=5.4, E10<11.25, G10>=12, H10>=13.4),AND(A10=\"H\", E10>=5.4, E10<11.25, G10>=12, H10>=13.4),AND(A10=\"S\",E10>=11.25,E10<20,G10>=11.8,H10>=12.8),AND(A10=\"U\",E10>=11.25,E10<20,G10>=11.8,H10>=12.8),AND(A10=\"H\",E10>=11.25,E10<20,G10>=11.8,H10>=12.8),AND(A10=\"S\", E10>=20, E10<63.3, G10>=10.6, H10>=12.1),AND(A10=\"U\", E10>=20, E10<63.3, G10>=10.6, H10>=12.1),AND(A10=\"H\", E10>=20, E10<63.3, G10>=10.6, H10>=12.1),AND(A10=\"S\", E10>=63.3, G10>=10.3, H10>=12),AND(A10=\"U\", E10>=63.3, G10>=10.3, H10>=12),AND(A10=\"H\", E10>=63.3, G10>=10.3, H10>=12),AND(A10=\"W\", E10<5.4,G10>=14,H10>=13.4),AND(A10=\"W\",E10>=5.4,E10<11.25,G10>=12.8,H10>=13.1),AND(A10=\"W\",E10>=11.25,G10>=12,H10>=12.4),AND(A10=\"P\", E10<0.75, G10>=12),AND(A10=\"P\", E10>=0.75, E10<1, G10>=11.5),AND(A10=\"P\", E10>=1, G10>=10.5),AND(A10=\"T\", E10<0.75, G10>=12, I10>=3.3),AND(A10=\"T\", E10>=0.75, E10<1, G10>=11.5, I10>=3.2),AND(A10=\"T\", E10>=1, G10>=10.3, I10>=3.2)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(A10=\"S\", E10<5.4, F10>=16, G10>=12.5),AND(A10=\"U\", E10<5.4, F10>=16, G10>=12),AND(A10=\"H\", E10<5.4, F10>=16, G10>=14.6),AND(A10=\"S\", E10>=5.4, E10<11.25, G10>=12, H10>=13.8),AND(A10=\"U\", E10>=5.4, E10<11.25, G10>=12, H10>=13.8),AND(A10=\"H\", E10>=5.4, E10<11.25, G10>=12, H10>=13.8),AND(A10=\"S\",E10>=11.25,E10<20,G10>=11.8,H10>=13.2),AND(A10=\"U\",E10>=11.25,E10<20,G10>=11.8,H10>=13.2),AND(A10=\"H\",E10>=11.25,E10<20,G10>=11.8,H10>=13.2),AND(A10=\"S\", E10>=20, E10<63.3, G10>=10.6, H10>=12.4),AND(A10=\"U\", E10>=20, E10<63.3, G10>=10.6, H10>=12.4),AND(A10=\"H\", E10>=20, E10<63.3, G10>=10.6, H10>=12.4),AND(A10=\"S\", E10>=63.3, G10>=10.3, H10>=12.3),AND(A10=\"U\", E10>=63.3, G10>=10.3, H10>=12.3),AND(A10=\"H\", E10>=63.3, G10>=10.3, H10>=12.3)),\"Yes\",IF(OR(AND(A10=\"W\"),AND(A10=\"P\"),AND(A10=\"T\")),\"N/A\",\"No\"))","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,"H","No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,"P","No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,"T","No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,"W","No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,"No","No"]
["Attach additional worksheets if needed",null,null,null,null,null,null,null,null,null,"Total Requested Incentive",null,{"$f":"SUM(M9:M23)","v":0}]
[]
[]
["TABLE 2: QUALIFYING EFFICIENCY AND INCENTIVES"]
["Size Category (tons)",null,null,"Sub-Category",null,null,"Tier 1 Minimum Requirement",null,"Tier 1 Incentive","Tier 2 Minimum Requirement",null,"Tier 2 Incentive"]
["Air Conditioners (Cooling Mode) - Unitary and Split Systems"]
["< 5.4",null,null,"Split System",null,null,"15.0 SEER and 12.0 EER",null,"$50/ton","16.0 SEER and 12.5 EER",null,"$75/ton"]
[null,null,null,"Single Package",null,null,"15.0 SEER and 11.6 EER",null,null,"16.0 SEER and 12.0 EER"]
["≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"12.0 EER and 13.4 IEER",null,"$50/ton","12.0 EER and 13.8 IEER",null,"$75/ton"]
["≥ 11.25 and < 20",null,null,"Split System and Single Package",null,null,"11.8 EER and 12.8 IEER",null,"$50/ton","11.8 EER and 13.2 IEER",null,"$75/ton"]
["≥ 20 and < 63.3",null,null,"Split System and Single Package",null,null,"10.6 EER and 12.1 IEER",null,"$50/ton","10.6 EER and 12.4 IEER",null,"$75/ton"]
[" ≥ 63.3",null,null,"Split System and Single Package",null,null,"10.3 EER and 12.0 IEER",null,"$15/ton","10.3 EER and 12.3 IEER",null,"$20/ton"]
["Air Source Heat Pumps (Cooling Mode) - Unitary and Split Systems"]
["< 5.4",null,null,"Split System and Single Package",null,null,"15.0 SEER and 14.3 EER",null,"$50/ton","16.0 SEER and 14.6 EER",null,"$75/ton"]
["≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"12.0 EER and 13.4 IEER",null,"$50/ton","12.0 EER and 13.8 IEER",null,"$75/ton"]
["≥ 11.25 and < 20",null,null,"Split System and Single Package",null,null,"11.8 EER and 12.8 IEER",null,"$50/ton","11.8 EER and 13.2 IEER",null,"$75/ton"]
["≥ 20 and < 63.3",null,null,"Split System and Single Package",null,null,"10.6 EER and 12.1 IEER",null,"$50/ton","10.6 EER and 12.4 IEER",null,"$75/ton"]
[" ≥ 63.3",null,null,"Split System and Single Package",null,null,"10.3 EER and 12.0 IEER",null,"$15/ton","10.3 EER and 12.3 IEER",null,"$20/ton"]
["Air Conditioners and Heat Pumps (Cooling Mode) - Water and Evaporative"]
["< 5.4",null,null,"Split System and Single Package",null,null,"14.0 EER and 13.4 IEER",null,"$60/ton","N/A",null,"N/A"]
["≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"12.8 EER and 13.1 IEER",null,"$60/ton","N/A",null,"N/A"]
["≥ 11.25",null,null,"Split System and Single Package",null,null,"12.0 EER and 12.4 IEER",null,"$60/ton","N/A",null,"N/A"]
["Packaged Terminal Air Conditioner (PTAC)"]
["< 0.75",null,null,"Single Package",null,null,"12.0 EER",null,"$20/unit","N/A",null,"N/A"]
["≥ 0.75 and < 1.0",null,null,null,null,null,"11.5 EER",null,"$25/unit","N/A",null,"N/A"]
["≥ 1.0",null,null,null,null,null,"10.5 EER",null,"$35/unit","N/A",null,"N/A"]
["Packaged Terminal Heat Pump (PTHP)"]
["< 0.75",null,null,"Single Package",null,null,"12.0 EER and 3.3 COP",null,"$20/unit","N/A",null,"N/A"]
["≥ 0.75 and < 1.0",null,null,null,null,null,"11.5 EER and 3.2 COP",null,"$22/unit","N/A",null,"N/A"]
["≥ 1.0",null,null,null,null,null,"10.3 EER and 3.2 COP",null,"$30/unit","N/A",null,"N/A"]
["Note: Tons are based on 12,000 BTUH net output per ton."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 10.1"}]

{"sheet":"Window Film","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[8,0,8,5]]}
["Fill in Blue Cells Only!"]
["WINDOW FILM TECHNICAL REQUIREMENTS AND INCENTIVES"]
["§ To qualify for an incentive window film must be installed on south, east or west facing windows and cover the entire window. Installation on north facing windows is not eligible.\n§ Window film must have a maximum Solar Heat Gain Coefficient (SHGC) of 0.24."]
["Location/Floor/Suite #","Total Square Feet Installed","Number of Windows","SHGC","Incentive Per Sq. Ft.","Window Facing Orientation","Total Incentive"]
[null,null,null,null,"$1/sq. ft.",null,{"$f":"IF(OR(AND(D5>0,D5<=0.24)),B5*1,0)","v":0},null,null,"South"]
[null,null,null,null,"$1/sq. ft.",null,{"$f":"IF(OR(AND(D6>0,D6<=0.24)),B6*1,0)","v":0},null,null,"East"]
[null,null,null,null,"$1/sq. ft.",null,0,null,null,"West"]
[null,null,null,null,"$1/sq. ft.",null,0]
["Total Requested Incentive",null,null,null,null,null,{"$f":"SUM(G5:G8)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 10.1"}]

{"sheet":"HVAC Chillers","index":7,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[60,9,60,10],[61,9,61,10],[62,9,62,10],[63,9,63,10],[54,11,55,11],[56,0,56,11],[57,0,57,11],[58,0,59,0],[58,1,59,1],[58,2,58,4],[58,5,58,8],[58,9,59,10],[58,11,59,11],[54,1,55,1],[54,4,55,5],[54,7,55,7],[54,8,55,8],[54,9,55,9],[54,10,55,10],[50,0,55,0],[54,3,55,3],[50,11,51,11],[52,1,53,1],[52,4,53,5],[52,7,53,7],[52,8,53,8],[52,9,53,9],[52,10,53,10],[52,11,53,11],[48,9,49,9],[48,10,49,10],[48,11,49,11],[50,1,51,1],[50,4,51,5],[50,7,51,7],[50,8,51,8],[50,9,51,9],[50,10,51,10],[50,3,51,3],[52,3,53,3],[48,6,49,6],[50,6,51,6],[52,6,53,6],[44,10,45,10],[44,11,45,11],[46,1,47,1],[46,7,47,7],[46,8,47,8],[46,9,47,9],[46,10,47,10],[46,11,47,11],[44,0,49,0],[44,1,45,1],[44,4,45,5],[44,7,45,7],[44,8,45,8],[44,9,45,9],[48,1,49,1],[48,4,49,5],[48,7,49,7],[48,8,49,8],[44,3,45,3],[46,3,47,3],[48,3,49,3],[46,4,47,5],[44,6,45,6],[46,6,47,6],[40,9,41,9],[40,10,41,10],[40,11,41,11],[42,1,43,1],[42,7,43,7],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[40,4,41,5],[42,4,43,5],[40,0,43,0],[40,1,41,1],[40,7,41,7],[40,8,41,8],[40,3,41,3],[42,3,43,3],[40,6,41,6],[42,6,43,6],[37,1,39,1],[37,2,39,2],[38,3,39,3],[38,4,39,5],[38,8,39,8],[38,9,39,9],[38,10,39,10],[38,11,39,11],[37,3,37,6],[38,6,39,6],[31,9,31,10],[34,9,34,10],[32,9,32,10],[33,9,33,10],[21,11,22,11],[23,11,24,11],[25,11,26,11],[21,10,22,10],[23,10,24,10],[25,10,26,10],[29,11,30,11],[27,0,27,11],[28,0,28,11],[29,0,30,0],[29,1,30,1],[29,2,29,4],[29,5,29,8],[23,1,24,1],[23,4,24,5],[23,7,24,7],[23,9,24,9],[25,1,26,1],[25,4,26,5],[25,7,26,7],[29,9,30,10],[15,3,16,3],[17,3,18,3],[19,3,20,3],[21,3,22,3],[23,3,24,3],[25,3,26,3],[17,4,18,5],[21,8,22,8],[23,8,24,8],[25,8,26,8],[15,10,16,10],[17,10,18,10],[19,10,20,10],[15,8,16,8],[17,8,18,8],[19,8,20,8],[17,7,18,7],[17,9,18,9],[19,4,20,5],[19,7,20,7],[19,9,20,9],[15,7,16,7],[15,9,16,9],[11,11,12,11],[9,7,10,7],[9,8,10,8],[25,9,26,9],[21,0,26,0],[21,1,22,1],[21,4,22,5],[21,7,22,7],[21,9,22,9],[15,11,16,11],[17,11,18,11],[19,11,20,11],[11,0,14,0],[11,4,12,5],[11,8,12,8],[17,1,18,1],[11,7,12,7],[11,9,12,9],[19,1,20,1],[15,0,20,0],[15,1,16,1],[15,4,16,5],[13,10,14,10],[13,11,14,11],[13,1,14,1],[13,4,14,5],[13,7,14,7],[13,8,14,8],[13,9,14,9],[11,3,12,3],[13,3,14,3],[11,1,12,1],[11,10,12,10],[0,0,0,11],[1,0,1,11],[5,0,5,11],[8,7,8,11],[6,0,6,11],[7,0,7,11],[2,0,2,11],[3,0,3,11],[9,3,10,3],[8,0,10,0],[8,1,10,1],[8,2,10,2],[9,4,10,5],[4,0,4,11],[8,3,8,6],[9,6,10,6],[9,9,10,9],[9,10,10,10],[9,11,10,11],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[54,6,55,6],[11,6,12,6],[13,6,14,6],[15,6,16,6],[17,6,18,6],[19,6,20,6],[21,6,22,6],[23,6,24,6],[25,6,26,6],[30,5,30,6],[31,5,31,6],[33,5,33,6],[32,5,32,6],[34,5,34,6],[35,0,35,11],[36,0,36,11],[37,7,37,11],[38,7,39,7],[37,0,39,0]]}
["Fill in Blue Cells Only!"]
["HVAC CHILLER TECHNICAL REQUIREMENTS"]
["§ Air and water cooled chilling packages used in a single chiller HVAC are eligible systems.\n§ If the chiller serves HVAC and non-HVAC loads, the non-HVAC load may not exceed 25 percent of the chiller’s rated capacity.\n§ Chillers being installed must meet the full load and Integrated Part Load Value (IPLV) efficiency values.\n§ For chillers that are manufactured with variable frequency devices (VFDs) as part of the chiller package, the VFDs will not be independently eligible for additional incentives.\n§ Chillers with a VFD controlling the compressor must be applied for using table 2.\n§ Water chilling equipment must meet current Air-Conditioning and Refrigeration Institute (ARI) standards 550/590, be UL listed, and use a minimum ozone-depleting refrigerant.\n§ Chillers purchased and installed for backup or redundant systems are not eligible for incentives."]
[]
["INCENTIVE CALCULATION INSTRUCTIONS"]
["Incentives are available for high-efficiency base units and any incremental part load efficiency improvements. To calculate total incentive, follow these steps:\nStep 1\nIdentify the appropriate table for reviewing the eligibility requirements and calculating the incentive. Use Table 1 to review the requirements and enter information for\nsingle-speed chillers. Use Table 2 to review the requirements and enter information for VFD-controlled chillers.\n                    Base Unit Incentive is calculated by the following formula:\n                    Chiller Size (Net Tons) x Base Unit Incentive = Base Total Incentive\n\n                    Performance Incentive is calculated as follows:\n                  § Air Cooled Chillers (Capped at $125/ton for VFD-controlled air cooled chillers)\n                    [(Proposed Equipment Unit Efficiency – Minimum Incentive Efficiency) x 10] x Chiller Size (Net Tons) x Performance Incentive = Performance Total Incentive\n\n                  § Water Cooled Chillers\n                   [(Minimum Incentive Efficiency – Proposed Equipment Unit Efficiency) x 100] x Chiller Size (Net Tons) x Performance Incentive = Performance Total Incentive  \n\nThe efficiency value (EER, IPLV, or kW/ton) that represents the greater difference between the Minimum Incentive Efficiency and the Proposed Equipment Unit Efficiency should be used in calculating the incentive \nStep 2\nComplete Table 1A or Table 2A with the Chiller Plant Operating Parameters. Be sure to insert total estimated plant load (Tons)."]
[]
["TABLE 1: HVAC CHILLER INCENTIVES - SINGLE-SPEED CHILLERS"]
["Type","Unit Size - ARI Net Tons","Minimum Efficiency \n(Full Load and IPLV)","Proposed Equipment",null,null,null,"Incentives"]
[null,null,null,"Chiller Size (Net Tons)","Full Load",null,"IPLV","Base Unit Incentive per Ton","Base Total Incentive","Performance Incentive per Ton","Performance Total Incentive","Requested Incentive"]
[]
["Air Cooled Chiller with Condenser","< 150 tons","10.2 EER",null,null,null,null,15,{"$f":"IF(AND(E12>=10.2,G12>=13.34),D12*H12,0)","v":0},3,{"$f":"IF(OR(AND(I12>0,(E12-10.2)>=(G12-13.34))),(E12-10.2)*10*D12*J12,IF(OR(AND(I12>0,(E12-10.2)<(G12-13.34))),(G12-13.34)*10*D12*J12,0))","v":0},{"$f":"I12+K12","v":0}]
[null,null,"13.34 IPLV"]
[null,"≥ 150 tons","10.2 EER",null,null,null,null,15,{"$f":"IF(AND(E14>=10.2,G14>=13.6),D14*H14,0)","v":0},3,{"$f":"IF(OR(AND(I14>0,(E14-10.2)>=(G14-13.6))),(E14-10.2)*10*D14*J14,IF(OR(AND(I14>0,(E14-10.2)<(G14-13.6))),(G14-13.6)*10*D14*J14,0))","v":0},{"$f":"I14+K14","v":0}]
[null,null,"13.6 IPLV"]
["Water Cooled Screw and Reciprocating Chillers","< 150 tons","0.71 kW/ton",null,null,null,null,30,{"$f":"IF(OR(AND(E16<=0.71,E16>0,G16<=0.56,G16>0)),D16*H16,0)","v":0},4,{"$f":"IF(OR(AND(I16>0,(0.71-E16)>=(0.56-G16))),(0.71-E16)*100*D16*J16,IF(OR(AND(I16>0,(0.71-E16)<(0.56-G16))),(0.56-G16)*100*D16*J16,0))","v":0},{"$f":"I16+K16","v":0}]
[null,null,"0.56 IPLV"]
[null,"≥ 150 tons and \n< 300 tons","0.58 kW//ton",null,null,null,null,30,{"$f":"IF(OR(AND(E18<=0.58,E18>0,G18<=0.47,G18>0)),D18*H18,0)","v":0},3,{"$f":"IF(OR(AND(I18>0,(0.58-E18)>=(0.47-G18))),(0.58-E18)*100*D18*J18,IF(OR(AND(I18>0,(0.58-E18)<(0.47-G18))),(0.47-G18)*100*D18*J18,0))","v":0},{"$f":"I18+K18","v":0}]
[null,null,"0.47 IPLV"]
[null,"≥ 300","0.56 kW/ton",null,null,null,null,20,{"$f":"IF(OR(AND(E20<=0.56,E20>0,G20<=0.45,G20>0)),D20*H20,0)","v":0},2,{"$f":"IF(OR(AND(I20>0,(0.56-E20)>=(0.45-G20))),(0.56-E20)*100*D20*J20,IF(OR(AND(I20>0,(0.56-E20)<(0.45-G20))),(0.45-G20)*100*D20*J20,0))","v":0},{"$f":"I20+K20","v":0}]
[null,null,"0.45 IPLV"]
["Water Cooled Centrifugal Chillers","< 300 tons","0.59 kW/ton",null,null,null,null,15,{"$f":"IF(OR(AND(E22<=0.59,E22>0,G22<=0.56,G22>0)),D22*H22,0)","v":0},3,{"$f":"IF(OR(AND(I22>0,(0.59-E22)>=(0.56-G22))),(0.59-E22)*100*D22*J22,IF(OR(AND(I22>0,(0.59-E22)<(0.56-G22))),(0.56-G22)*100*D22*J22,0))","v":0},{"$f":"I22+K22","v":0}]
[null,null,"0.56 IPLV"]
[null,"≥ 300 and    \n< 600 tons","0.56 kW/ton",null,null,null,null,15,{"$f":"IF(OR(AND(E24<=0.56,E24>0,G24<=0.53,G24>0)),D24*H24,0)","v":0},3,{"$f":"IF(OR(AND(I24>0,(0.56-E24)>=(0.53-G24))),(0.56-E24)*100*D24*J24,IF(OR(AND(I24>0,(0.56-E24)<(0.53-G24))),(0.53-G24)*100*D24*J24,0))","v":0},{"$f":"I24+K24","v":0}]
[null,null,"0.53 IPLV"]
[null,"≥ 600 tons","0.55 kW/ton",null,null,null,null,15,{"$f":"IF(OR(AND(E26<=0.55,E26>0,G26<=0.52,G26>0)),D26*H26,0)","v":0},2,{"$f":"IF(OR(AND(I26>0,(0.55-E26)>=(0.52-G26))),(0.55-E26)*100*D26*J26,IF(OR(AND(I26>0,(0.55-E26)<(0.52-G26))),(0.52-G26)*100*D26*J26,0))","v":0},{"$f":"I26+K26","v":0}]
[null,null,"0.52 IPLV"]
[]
["TABLE 1A: CHILLER PLANT OPERATING PARAMETERS"]
["Chiller Type","Tons","Evaporator",null,null,"Condenser",null,null,null,"Peak kW/ton",null,"IPLV kW/ton"]
[null,null,"Gallons per minute","Entering Water Temperature","Leaving Water Temperature","Gallons per minute",null,"Entering Water Temperature","Leaving Water Temperature"]
["Water-Cooled Centrifugal",1000,1500,"56 F","40 F",3000,null,"76 F","85.22 F",0.54500000000000004,null,0.498]
[]
[]
[]
[]
["TABLE 2: HVAC CHILLER INCENTIVES - VFD-CONTROLLED CHILLERS"]
["Type","Unit Size - ARI Net Tons","Minimum Efficiency \n(Full Load and IPLV)","Proposed Equipment",null,null,null,"Incentives"]
[null,null,null,"Chiller Size (Net Tons)","Full Load",null,"IPLV","Base Unit Incentive per Ton","Base Total Incentive","Performance Incentive per Ton (Capped at $125/ton for air cooled chillers)","Performance Total Incentive","Requested Incentive"]
[]
["Air Cooled Chiller with Condenser\n","< 150 tons","10.2 EER",null,null,null,null,10,{"$f":"IF(AND(E41>=10.2,G41>=13.34),D41*H41,0)","v":0},4,{"$f":"IF(AND(I41>0,(E41-10.2)>=(G41-13.36),((E41-10.2)*10*D41*J41)>=(125*D41)),125*D41,IF(AND(I41>0,(E41-10.2)>=(G41-13.36),((E41-10.2)*10*D41*J41)<(125*D41)),(E41-10.2)*10*D41*J41,IF(AND(I41>0,(E41-10.2)<(G41-13.36),((G41-13.36)*10*D41*J41)>=(125*D41)),125*D41,IF(AND(I41>0,(E41-10.2)<(G41-13.36),((G41-13.36)*10*D41*J41)<(125*D41)),(G41-13.36)*10*D41*J41,0))))","v":0},{"$f":"I41+K41","v":0}]
[null,null,"13.36 IPLV"]
[null,"≥ 150 tons","10.2 EER",null,null,null,null,10,{"$f":"IF(AND(E43>=10.2,G43>=13.6),D43*H43,0)","v":0},4,{"$f":"IF(AND(I43>0,(E43-10.2)>=(G43-13.8),((E43-10.2)*10*D43*J43)>=(125*D43)),125*D43,IF(AND(I43>0,(E43-10.2)>=(G43-13.8),((E43-10.2)*10*D43*J43)<(125*D43)),(E43-10.2)*10*D43*J43,IF(AND(I43>0,(E43-10.2)<(G43-13.8),((G43-13.8)*10*D43*J43)>=(125*D43)),125*D43,IF(AND(I43>0,(E43-10.2)<(G43-13.8),((G43-13.8)*10*D43*J43)<(125*D43)),(G43-13.8)*10*D43*J43,0))))","v":0},{"$f":"I43+K43","v":0}]
[null,null,"13.8 IPLV"]
["Water Cooled Screw and Reciprocating Chillers","< 150 tons","0.73 kW/ton",null,null,null,null,20,{"$f":"IF(OR(AND(E45<=0.73,E45>0,G45<=0.54,G45>0)),D45*H45,0)","v":0},6,{"$f":"IF(OR(AND(I45>0,(0.73-E45)>=(0.54-G45))),(0.73-E45)*100*D45*J45,IF(OR(AND(I45>0,(0.73-E45)<(0.54-G45))),(0.54-G45)*100*D45*J45,0))","v":0},{"$f":"I45+K45","v":0}]
[null,null,"0.54 IPLV"]
[null,"≥ 150 tons and \n< 300 tons","0.61 kW/ton",null,null,null,null,15,{"$f":"IF(OR(AND(E47<=0.61,E47>0,G47<=0.44,G47>0)),D47*H47,0)","v":0},6,{"$f":"IF(OR(AND(I47>0,(0.61-E47)>=(0.44-G47))),(0.61-E47)*100*D47*J47,IF(OR(AND(I47>0,(0.61-E47)<(0.44-G47))),(0.44-G47)*100*D47*J47,0))","v":0},{"$f":"I47+K47","v":0}]
[null,null,"0.44 IPLV"]
[null,"≥ 300","0.58 kW/ton",null,null,null,null,10,{"$f":"IF(OR(AND(E49<=0.58,E49>0,G49<=0.44,G49>0)),D49*H49,0)","v":0},3,{"$f":"IF(OR(AND(I49>0,(0.58-E49)>=(0.44-G49))),(0.58-E49)*100*D49*J49,IF(OR(AND(I49>0,(0.58-E49)<(0.44-G49))),(0.44-G49)*100*D49*J49,0))","v":0},{"$f":"I49+K49","v":0}]
[null,null,"0.44 IPLV"]
["Water Cooled Centrifugal Chillers","< 300 tons","0.59 kW/ton",null,null,null,null,10,{"$f":"IF(OR(AND(E51<=0.59,E51>0,G51<=0.42,G51>0)),D51*H51,0)","v":0},5,{"$f":"IF(OR(AND(I51>0,(0.59-E51)>=(0.42-G51))),(0.59-E51)*100*D51*J51,IF(OR(AND(I51>0,(0.59-E51)<(0.42-G51))),(0.42-G51)*100*D51*J51,0))","v":0},{"$f":"I51+K51","v":0}]
[null,null,"0.42 IPLV"]
[null,"≥ 300 and    \n< 600 tons","0.58 kW/ton",null,null,null,null,10,{"$f":"IF(OR(AND(E53<=0.58,E53>0,G53<=0.38,G53>0)),D53*H53,0)","v":0},4,{"$f":"IF(OR(AND(I53>0,(0.58-E53)>=(0.38-G53))),(0.58-E53)*100*D53*J53,IF(OR(AND(I53>0,(0.58-E53)<(0.38-G53))),(0.38-G53)*100*D53*J53,0))","v":0},{"$f":"I53+K53","v":0}]
[null,null,"0.38 IPLV"]
[null,"≥ 600 tons","0.57 kW/ton",null,null,null,null,10,{"$f":"IF(OR(AND(E55<=0.57,E55>0,G55<=0.38,G55>0)),D55*H55,0)","v":0},3,{"$f":"IF(OR(AND(I55>0,(0.57-E55)>=(0.38-G55))),(0.57-E55)*100*D55*J55,IF(OR(AND(I55>0,(0.57-E55)<(0.38-G55))),(0.38-G55)*100*D55*J55,0))","v":0},{"$f":"I55+K55","v":0}]
[null,null,"0.38 IPLV"]
[]
["TABLE 2A: CHILLER PLANT OPERATING PARAMETERS"]
["Chiller Type","Tons","Evaporator",null,null,"Condenser",null,null,null,"Peak kW/ton",null,"IPLV kW/ton"]
[null,null,"Gallons per minute","Entering Water Temperature","Leaving Water Temperature","Gallons per minute",null,"Entering Water Temperature","Leaving Water Temperature"]
["Water-Cooled Centrifugal",1000,1500,"56 F","40 F",3000,null,"76 F","85.22 F",0.54500000000000004,null,0.498]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 10.1"}]

{"sheet":"VFDs","index":8,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,0,31,5],[31,6,31,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[31,15,31,16],[29,6,29,7],[30,6,30,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[19,0,19,7],[8,0,8,7],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,7],[17,0,17,7],[18,0,18,1],[18,2,18,4],[18,5,18,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[3,0,3,7],[10,4,10,7],[9,4,9,7],[12,6,16,7],[7,0,7,7]]}
["Fill in Blue Cells Only!"]
["HVAC VARIABLE FREQUENCY DRIVES TECHNICAL REQUIREMENTS"]
["Replacement of failed VFDs or those installed in new construction do not qualify for incentives. Only VFD installations not required by South Carolina Code IECC 2009 are eligible for incentives.  Incentives will be provided for the installation of new VFDs controlled by an automatic signal in response to varying air or water flow. Incentives will be for VFDs from 5–100 horsepower (HP) for the HVAC applications listed in Table 1.\n\nFor chilled water and heating pump installations, at least 75 percent of pump capacity must be controlled by two-way valves. Controlled motors must\noperate a minimum of 2,000 hours per year.\n\nThe following HVAC VFD applications are NOT eligible for these incentives:\n§ Forward curve fans with inlet guide vanes\n§ Variable pitch vane-axial fans\n§ Replacement of a failed VFD\n§ VFD used solely for balancing a constant flow\n§ Control of existing two-speed cooling tower fan\n§ Two-speed control of a fan or pump\n§ Mitigation of oversized motor installation"]
["Published manufacturer’s information must be submitted with each application to demonstrate compliance for each of the following criteria:\n§ 15 millisecond minimum ride through on the VFD control at full load and no inertia\n§ Auto restart\n§ Flying restart (start into rotating motor, speed search)\n§ Under voltage trip 85 percent or less\n§ Minimum 3 percent in-line reactor or equivalent (choke, isolation transformer) based on drive HP\n§ 95 percent minimum drive efficiency at full load and full speed\n§ 0.95 minimum displacement power factor"]
[]
["IMPORTANT INFORMATION ABOUT VFDs"]
["§ It is good engineering practice to ensure that the application of VFDs within a facility does not cause excessive facility harmonic distortion.\n§ If the cable length between a VFD and controlled motor is greater than 50 feet, additional motor winding insulation on the first few windings,\nor the installation of an LC filter on the output of the inverter, might be required.\n§ The VFD should be grounded in accordance with the manufacturer’s grounding requirements for noise, as long as the requirement complies with\napplicable electric codes.\n§ The facility owner might want to consider: VFD startup by manufacturer representative, overcurrent trip protection, and critical frequency lockout.\nSee IEEE 519 for further information."]
[]
["Table 1:  VFD Installation Type"]
["SAF = HVAC Supply Air Fan",null,"CTF =  Cooling Tower Fan",null,"HWP = Heat Water Pump"]
["RAF = HVAC Return Air Fan",null,"CWP = Chilled Water Pump",null,"WHP = Water Source Heat Pump Circulator Loop"]
["Table 2: VFD Size and Incentive "]
["Motor HP","Incentive","Motor HP","Incentive","Motor HP","Incentive"]
[5,250,20,1000,50,2500]
[7.5,375,25,1250,60,3000]
[10,500,30,1500,75,3750]
[15,750,40,2000,100,5000]
["Table 3: Controlling Parameters"]
["DP = Differential Pressure",null,"DT = Differential Temperature",null,null,"Other: (Specify)  "]
["Table 4: Incentive Table  From Tables 1, 2 and 3 above fill in using one row per VFD"]
["Installation Type (Table 1)","Manufacturer","VFD & Motor Horsepower (Table 2)","Controlling Parameter (Table 3)","Quantity","Location/Designation","Requested Incentive "]
[null,null,null,null,null,null,{"$f":"C22*E22*50","v":0},null,null,null,"SAF",5,"DP"]
[null,null,null,null,null,null,{"$f":"C23*E23*50","v":0},null,null,null,"RAF",7.5,"DT"]
[null,null,null,null,null,null,0,null,null,null,"CTF",10,"Other"]
[null,null,null,null,null,null,0,null,null,null,"CWP",15]
[null,null,null,null,null,null,0,null,null,null,"HWP",20]
[null,null,null,null,null,null,0,null,null,null,"WHP",25]
[null,null,null,null,null,null,0,null,null,null,null,30]
[null,null,null,null,null,null,0,null,null,null,null,40]
[null,null,null,null,null,null,0,null,null,null,null,50]
[null,null,null,null,null,null,0,null,null,null,null,60]
["Total Requested Incentive",null,null,null,null,null,{"$f":"SUM(G22:H31)","v":0},null,null,null,null,75]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 10.1"},null,null,null,100]

{"sheet":"Inventory Instructions","index":9,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":true,"merged":[[17,2,17,6],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[11,2,11,6]]}
[]
[]
[]
[null,"C&I Prescriptive Program"]
[null,"Unitary HVAC"]
[]
[null,null,null,"Copyright © 2010 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[]
[null,null,"Instructions"]
[null,null,"1.  Read \"Eligibility Requirements\" for detailed information on participation for this program"]
[null,null,"2. This worksheet is required for all VFD Instllation projects.The completed application must be completed and submitted electronically to the email address below or may be submitted in writing either by mail or fax."]
[null,null,null,"Mailing Address:",null,"Fax Number:","Email Address:"]
[null,null,null,"SCE&G - EnergyWise for Your Business",null,"877-646-7234","EnergyExperts@sceg.com"]
[null,null,null,"Mail Code: DSM"]
[null,null,null,"220 Operation Way"]
[null,null,null,"Cayce, SC 29033"]
[null,null,"3. Enter the required project information in the shaded areas only. A description of this information is provided below in the Inputs section.                                    "]
[null,null,null,"- All other information will be populated automatically."]
[null,null,"4. Save file with a project name and date using the naming convention: project name_YY_MM_DD.xls"]
[null,null,"5. Email the renamed Excel spreadsheet and the completed project application form to EnergyExperts@sceg.com"]
[]
[null,null,"Inputs"]
[null,null,"Building Method Fields",null,"Unit","Input Range","Description"]
[null,null,"1.","Building Type","n/a","Select from Building Types","Enter the building type that most closely matches where the installation of the HVAC system is taking place"]
[null,null,"2.","Device Type","n/a","Select From HVAC Type","Types include Unitary A/C, Split System A/C, Heat Pump, Packaged Terminal HP, Packaged Terminal AC, Water Cooled"]
[null,null,"3.","Manufacturer","n/a","Any","Enter the manufacturer of the HVAC unit"]
[null,null,"4.","Model Number","n/a","Any","Enter the model number of the HVAC unit"]
[null,null,"5.","Size","Tons","Any","Enter the size in tons of the HVAC unit"]
[null,null,"6.","Cooling Efficiency","EER","Any","Enter the efficiency in tons of the HVAC unit"]
[null,null,"7.","Quantity","Whole Number","Any","Enter the quantity of HVAC units being installed"]

{"sheet":"Inputs","index":10,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[[19,17,20,17],[8,14,8,16],[18,11,18,12],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[1,1,1,10],[2,1,2,10],[3,1,3,10],[19,7,19,9],[4,1,4,10],[18,3,18,10],[15,1,16,1],[8,1,8,6]]}
[]
[]
[]
[null,"C&I Prescriptive - Unitary HVAC"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 10.1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!D24=Lookups!D4","v":false}]
[null," "]
[null,"Copyright © 2010 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[null,"Required General Project Information",null,null,null,null,null,"Administrative Use Only",null,null,null,null,null,null,"Summary Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kWh ","Total Summer Coincident Peak (kW)","Total Incentive"]
[null,null,"Project Name",null,null,"Prepared By",null,"Project ID",null,null,null,null,null,null,{"$f":"SUM(O23:O32)","v":0},{"$f":"SUM(P23:P32)","v":0},{"$f":"SUM(Q23:Q32)","v":0}]
[null,null,"Project Address",null,null,"Contact Person",null,"Data Input By"]
[null,null,"City",null,null,"Phone",null,"Input Date"]
[null,null,"ZIP",null,null,"Email"]
[]
[null,"Input Cells"]
[null,null,"Data input allowed in shaded cells only.",null,null,null,null,null,"*If print button malfunctions, "]
[null,null,null,null,null,null,null,null,"select printer settings manually from print menu"]
[null,null,null,"Unitary HVAC",null,null,null,null,null,null,null,"Savings",null,"Incentive"]
[null,"Line Item","Building Type","Device Type","Manufacturer","Model #","Size (tons)","Unit Efficiency",null,null,"Quantity","Incentive Requested","Tier 1 Qualify?","Tier 2 Qualify?","Total kWh Saved","Summer Coincident Peak kW Saved","Incentive","Incentive per Ton or unit","Translate for Counting"]
[null,null,null,null,null,null,null,"EER","SEER or IEER","COP"]
[null,"Ex.","Office","Split System","klanvbk",32160,5,12.5,16,null,1,{"$f":"Q22","v":300},"Yes","Yes",{"$f":"IF(N22=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G22,Lookups!$J$6:$J$17,1)+1),1,MATCH(G22,Lookups!$J$6:$J$17,1)+1),MATCH(D22,Lookups!$K$4:$P$4,0))*G22,IF(M22=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G22,Lookups!$B$6:$B$17,1)+1),1,MATCH(G22,Lookups!$B$6:$B$17,1)+1),MATCH(D22,Lookups!$C$4:$H$4,0))*G22,0))*K22","v":860},{"$f":"IF(N22=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G22,Lookups!$J$6:$J$17,1)+1),1,MATCH(G22,Lookups!$J$6:$J$17,1)+1),MATCH(D22,Lookups!$K$4:$P$4,0))*G22,IF(M22=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G22,Lookups!$B$6:$B$17,1)+1),1,MATCH(G22,Lookups!$B$6:$B$17,1)+1),MATCH(D22,Lookups!$C$4:$H$4,0))*G22,0))*K22","v":0.57000000000000006},{"$f":"IF(D22=0,\"-\",IF(OR(D22=Lookups!C3,Inputs!D22=Lookups!D3),Inputs!R22*Inputs!K22,R22*Inputs!K22*Inputs!G22))","v":300},60,{"$f":"IF(N22=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G22,Lookups!$B$6:$B$17,1)+1),1,MATCH(G22,Lookups!$B$6:$B$17,1)+1),MATCH(D22,Lookups!$C$4:$H$4,0)),IF(M22=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G22,Lookups!$B$6:$B$17,1)+1),1,MATCH(G22,Lookups!$B$6:$B$17,1)+1),MATCH(D22,Lookups!$C$4:$H$4,0))))","v":"Tier 2_Unitary_0"}]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"Q23","v":"-"},{"$f":"IF(OR(Lookups!N111=\"Tier 1\",Lookups!N111=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N111=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N23=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G23,Lookups!$J$6:$J$17,1)+1),1,MATCH(G23,Lookups!$J$6:$J$17,1)+1),MATCH(D23,Lookups!$K$4:$P$4,0))*G23,IF(M23=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G23,Lookups!$B$6:$B$17,1)+1),1,MATCH(G23,Lookups!$B$6:$B$17,1)+1),MATCH(D23,Lookups!$C$4:$H$4,0))*G23,0))*K23","v":0},{"$f":"IF(N23=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G23,Lookups!$J$6:$J$17,1)+1),1,MATCH(G23,Lookups!$J$6:$J$17,1)+1),MATCH(D23,Lookups!$K$4:$P$4,0))*G23,IF(M23=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G23,Lookups!$B$6:$B$17,1)+1),1,MATCH(G23,Lookups!$B$6:$B$17,1)+1),MATCH(D23,Lookups!$C$4:$H$4,0))*G23,0))*K23","v":0},{"$f":"IF(D23=0,\"-\",IF(OR(D23=Lookups!$C$4,Inputs!D23=Lookups!$D$4),Inputs!R23*Inputs!K23,R23*Inputs!K23*Inputs!G23))","v":"-"},{"$f":"Lookups!O111","v":"-"},{"$f":"IF(N23=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G23,Lookups!$B$6:$B$17,1)+1),1,MATCH(G23,Lookups!$B$6:$B$17,1)+1),MATCH(D23,Lookups!$C$4:$H$4,0)),IF(M23=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G23,Lookups!$B$6:$B$17,1)+1),1,MATCH(G23,Lookups!$B$6:$B$17,1)+1),MATCH(D23,Lookups!$C$4:$H$4,0))))","v":false}]
[null,2,null,null,null,null,null,null,null,null,null,{"$f":"Q24","v":"-"},{"$f":"IF(OR(Lookups!N112=\"Tier 1\",Lookups!N112=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N112=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N24=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G24,Lookups!$J$6:$J$17,1)+1),1,MATCH(G24,Lookups!$J$6:$J$17,1)+1),MATCH(D24,Lookups!$K$4:$P$4,0))*G24,IF(M24=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G24,Lookups!$B$6:$B$17,1)+1),1,MATCH(G24,Lookups!$B$6:$B$17,1)+1),MATCH(D24,Lookups!$C$4:$H$4,0))*G24,0))*K24","v":0},{"$f":"IF(N24=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G24,Lookups!$J$6:$J$17,1)+1),1,MATCH(G24,Lookups!$J$6:$J$17,1)+1),MATCH(D24,Lookups!$K$4:$P$4,0))*G24,IF(M24=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G24,Lookups!$B$6:$B$17,1)+1),1,MATCH(G24,Lookups!$B$6:$B$17,1)+1),MATCH(D24,Lookups!$C$4:$H$4,0))*G24,0))*K24","v":0},{"$f":"IF(D24=0,\"-\",IF(OR(D24=Lookups!$C$4,Inputs!D24=Lookups!$D$4),Inputs!R24*Inputs!K24,R24*Inputs!K24*Inputs!G24))","v":"-"},{"$f":"Lookups!O112","v":"-"},{"$f":"IF(N24=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G24,Lookups!$B$6:$B$17,1)+1),1,MATCH(G24,Lookups!$B$6:$B$17,1)+1),MATCH(D24,Lookups!$C$4:$H$4,0)),IF(M24=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G24,Lookups!$B$6:$B$17,1)+1),1,MATCH(G24,Lookups!$B$6:$B$17,1)+1),MATCH(D24,Lookups!$C$4:$H$4,0))))","v":false}]
[null,3,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N113=\"Tier 1\",Lookups!N113=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N113=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N25=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G25,Lookups!$J$6:$J$17,1)+1),1,MATCH(G25,Lookups!$J$6:$J$17,1)+1),MATCH(D25,Lookups!$K$4:$P$4,0))*G25,IF(M25=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G25,Lookups!$B$6:$B$17,1)+1),1,MATCH(G25,Lookups!$B$6:$B$17,1)+1),MATCH(D25,Lookups!$C$4:$H$4,0))*G25,0))*K25","v":0},{"$f":"IF(N25=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G25,Lookups!$J$6:$J$17,1)+1),1,MATCH(G25,Lookups!$J$6:$J$17,1)+1),MATCH(D25,Lookups!$K$4:$P$4,0))*G25,IF(M25=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G25,Lookups!$B$6:$B$17,1)+1),1,MATCH(G25,Lookups!$B$6:$B$17,1)+1),MATCH(D25,Lookups!$C$4:$H$4,0))*G25,0))*K25","v":0},{"$f":"IF(D25=0,\"-\",IF(OR(D25=Lookups!$C$4,Inputs!D25=Lookups!$D$4),Inputs!R25*Inputs!K25,R25*Inputs!K25*Inputs!G25))","v":"-"},{"$f":"Lookups!O113","v":"-"},{"$f":"IF(N25=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G25,Lookups!$B$6:$B$17,1)+1),1,MATCH(G25,Lookups!$B$6:$B$17,1)+1),MATCH(D25,Lookups!$C$4:$H$4,0)),IF(M25=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G25,Lookups!$B$6:$B$17,1)+1),1,MATCH(G25,Lookups!$B$6:$B$17,1)+1),MATCH(D25,Lookups!$C$4:$H$4,0))))","v":false}]
[null,4,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N114=\"Tier 1\",Lookups!N114=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N114=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N26=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G26,Lookups!$J$6:$J$17,1)+1),1,MATCH(G26,Lookups!$J$6:$J$17,1)+1),MATCH(D26,Lookups!$K$4:$P$4,0))*G26,IF(M26=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G26,Lookups!$B$6:$B$17,1)+1),1,MATCH(G26,Lookups!$B$6:$B$17,1)+1),MATCH(D26,Lookups!$C$4:$H$4,0))*G26,0))*K26","v":0},{"$f":"IF(N26=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G26,Lookups!$J$6:$J$17,1)+1),1,MATCH(G26,Lookups!$J$6:$J$17,1)+1),MATCH(D26,Lookups!$K$4:$P$4,0))*G26,IF(M26=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G26,Lookups!$B$6:$B$17,1)+1),1,MATCH(G26,Lookups!$B$6:$B$17,1)+1),MATCH(D26,Lookups!$C$4:$H$4,0))*G26,0))*K26","v":0},{"$f":"IF(D26=0,\"-\",IF(OR(D26=Lookups!$C$4,Inputs!D26=Lookups!$D$4),Inputs!R26*Inputs!K26,R26*Inputs!K26*Inputs!G26))","v":"-"},{"$f":"Lookups!O114","v":"-"},{"$f":"IF(N26=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G26,Lookups!$B$6:$B$17,1)+1),1,MATCH(G26,Lookups!$B$6:$B$17,1)+1),MATCH(D26,Lookups!$C$4:$H$4,0)),IF(M26=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G26,Lookups!$B$6:$B$17,1)+1),1,MATCH(G26,Lookups!$B$6:$B$17,1)+1),MATCH(D26,Lookups!$C$4:$H$4,0))))","v":false}]
[null,5,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N115=\"Tier 1\",Lookups!N115=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N115=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N27=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G27,Lookups!$J$6:$J$17,1)+1),1,MATCH(G27,Lookups!$J$6:$J$17,1)+1),MATCH(D27,Lookups!$K$4:$P$4,0))*G27,IF(M27=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G27,Lookups!$B$6:$B$17,1)+1),1,MATCH(G27,Lookups!$B$6:$B$17,1)+1),MATCH(D27,Lookups!$C$4:$H$4,0))*G27,0))*K27","v":0},{"$f":"IF(N27=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G27,Lookups!$J$6:$J$17,1)+1),1,MATCH(G27,Lookups!$J$6:$J$17,1)+1),MATCH(D27,Lookups!$K$4:$P$4,0))*G27,IF(M27=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G27,Lookups!$B$6:$B$17,1)+1),1,MATCH(G27,Lookups!$B$6:$B$17,1)+1),MATCH(D27,Lookups!$C$4:$H$4,0))*G27,0))*K27","v":0},{"$f":"IF(D27=0,\"-\",IF(OR(D27=Lookups!$C$4,Inputs!D27=Lookups!$D$4),Inputs!R27*Inputs!K27,R27*Inputs!K27*Inputs!G27))","v":"-"},{"$f":"Lookups!O115","v":"-"},{"$f":"IF(N27=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G27,Lookups!$B$6:$B$17,1)+1),1,MATCH(G27,Lookups!$B$6:$B$17,1)+1),MATCH(D27,Lookups!$C$4:$H$4,0)),IF(M27=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G27,Lookups!$B$6:$B$17,1)+1),1,MATCH(G27,Lookups!$B$6:$B$17,1)+1),MATCH(D27,Lookups!$C$4:$H$4,0))))","v":false}]
[null,6,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N116=\"Tier 1\",Lookups!N116=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N116=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N28=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G28,Lookups!$J$6:$J$17,1)+1),1,MATCH(G28,Lookups!$J$6:$J$17,1)+1),MATCH(D28,Lookups!$K$4:$P$4,0))*G28,IF(M28=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G28,Lookups!$B$6:$B$17,1)+1),1,MATCH(G28,Lookups!$B$6:$B$17,1)+1),MATCH(D28,Lookups!$C$4:$H$4,0))*G28,0))*K28","v":0},{"$f":"IF(N28=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G28,Lookups!$J$6:$J$17,1)+1),1,MATCH(G28,Lookups!$J$6:$J$17,1)+1),MATCH(D28,Lookups!$K$4:$P$4,0))*G28,IF(M28=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G28,Lookups!$B$6:$B$17,1)+1),1,MATCH(G28,Lookups!$B$6:$B$17,1)+1),MATCH(D28,Lookups!$C$4:$H$4,0))*G28,0))*K28","v":0},{"$f":"IF(D28=0,\"-\",IF(OR(D28=Lookups!$C$4,Inputs!D28=Lookups!$D$4),Inputs!R28*Inputs!K28,R28*Inputs!K28*Inputs!G28))","v":"-"},{"$f":"Lookups!O116","v":"-"},{"$f":"IF(N28=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G28,Lookups!$B$6:$B$17,1)+1),1,MATCH(G28,Lookups!$B$6:$B$17,1)+1),MATCH(D28,Lookups!$C$4:$H$4,0)),IF(M28=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G28,Lookups!$B$6:$B$17,1)+1),1,MATCH(G28,Lookups!$B$6:$B$17,1)+1),MATCH(D28,Lookups!$C$4:$H$4,0))))","v":false}]
[null,7,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N117=\"Tier 1\",Lookups!N117=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N117=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N29=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G29,Lookups!$J$6:$J$17,1)+1),1,MATCH(G29,Lookups!$J$6:$J$17,1)+1),MATCH(D29,Lookups!$K$4:$P$4,0))*G29,IF(M29=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G29,Lookups!$B$6:$B$17,1)+1),1,MATCH(G29,Lookups!$B$6:$B$17,1)+1),MATCH(D29,Lookups!$C$4:$H$4,0))*G29,0))*K29","v":0},{"$f":"IF(N29=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G29,Lookups!$J$6:$J$17,1)+1),1,MATCH(G29,Lookups!$J$6:$J$17,1)+1),MATCH(D29,Lookups!$K$4:$P$4,0))*G29,IF(M29=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G29,Lookups!$B$6:$B$17,1)+1),1,MATCH(G29,Lookups!$B$6:$B$17,1)+1),MATCH(D29,Lookups!$C$4:$H$4,0))*G29,0))*K29","v":0},{"$f":"IF(D29=0,\"-\",IF(OR(D29=Lookups!$C$4,Inputs!D29=Lookups!$D$4),Inputs!R29*Inputs!K29,R29*Inputs!K29*Inputs!G29))","v":"-"},{"$f":"Lookups!O117","v":"-"},{"$f":"IF(N29=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G29,Lookups!$B$6:$B$17,1)+1),1,MATCH(G29,Lookups!$B$6:$B$17,1)+1),MATCH(D29,Lookups!$C$4:$H$4,0)),IF(M29=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G29,Lookups!$B$6:$B$17,1)+1),1,MATCH(G29,Lookups!$B$6:$B$17,1)+1),MATCH(D29,Lookups!$C$4:$H$4,0))))","v":false}]
[null,8,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N118=\"Tier 1\",Lookups!N118=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N118=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N30=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G30,Lookups!$J$6:$J$17,1)+1),1,MATCH(G30,Lookups!$J$6:$J$17,1)+1),MATCH(D30,Lookups!$K$4:$P$4,0))*G30,IF(M30=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G30,Lookups!$B$6:$B$17,1)+1),1,MATCH(G30,Lookups!$B$6:$B$17,1)+1),MATCH(D30,Lookups!$C$4:$H$4,0))*G30,0))*K30","v":0},{"$f":"IF(N30=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G30,Lookups!$J$6:$J$17,1)+1),1,MATCH(G30,Lookups!$J$6:$J$17,1)+1),MATCH(D30,Lookups!$K$4:$P$4,0))*G30,IF(M30=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G30,Lookups!$B$6:$B$17,1)+1),1,MATCH(G30,Lookups!$B$6:$B$17,1)+1),MATCH(D30,Lookups!$C$4:$H$4,0))*G30,0))*K30","v":0},{"$f":"IF(D30=0,\"-\",IF(OR(D30=Lookups!$C$4,Inputs!D30=Lookups!$D$4),Inputs!R30*Inputs!K30,R30*Inputs!K30*Inputs!G30))","v":"-"},{"$f":"Lookups!O118","v":"-"},{"$f":"IF(N30=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G30,Lookups!$B$6:$B$17,1)+1),1,MATCH(G30,Lookups!$B$6:$B$17,1)+1),MATCH(D30,Lookups!$C$4:$H$4,0)),IF(M30=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G30,Lookups!$B$6:$B$17,1)+1),1,MATCH(G30,Lookups!$B$6:$B$17,1)+1),MATCH(D30,Lookups!$C$4:$H$4,0))))","v":false}]
[null,9,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N119=\"Tier 1\",Lookups!N119=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N119=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N31=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G31,Lookups!$J$6:$J$17,1)+1),1,MATCH(G31,Lookups!$J$6:$J$17,1)+1),MATCH(D31,Lookups!$K$4:$P$4,0))*G31,IF(M31=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G31,Lookups!$B$6:$B$17,1)+1),1,MATCH(G31,Lookups!$B$6:$B$17,1)+1),MATCH(D31,Lookups!$C$4:$H$4,0))*G31,0))*K31","v":0},{"$f":"IF(N31=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G31,Lookups!$J$6:$J$17,1)+1),1,MATCH(G31,Lookups!$J$6:$J$17,1)+1),MATCH(D31,Lookups!$K$4:$P$4,0))*G31,IF(M31=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G31,Lookups!$B$6:$B$17,1)+1),1,MATCH(G31,Lookups!$B$6:$B$17,1)+1),MATCH(D31,Lookups!$C$4:$H$4,0))*G31,0))*K31","v":0},{"$f":"IF(D31=0,\"-\",IF(OR(D31=Lookups!$C$4,Inputs!D31=Lookups!$D$4),Inputs!R31*Inputs!K31,R31*Inputs!K31*Inputs!G31))","v":"-"},{"$f":"Lookups!O119","v":"-"},{"$f":"IF(N31=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G31,Lookups!$B$6:$B$17,1)+1),1,MATCH(G31,Lookups!$B$6:$B$17,1)+1),MATCH(D31,Lookups!$C$4:$H$4,0)),IF(M31=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G31,Lookups!$B$6:$B$17,1)+1),1,MATCH(G31,Lookups!$B$6:$B$17,1)+1),MATCH(D31,Lookups!$C$4:$H$4,0))))","v":false}]
[null,10,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(OR(Lookups!N120=\"Tier 1\",Lookups!N120=\"Tier 2\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(Lookups!N120=\"Tier 2\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(N32=\"Yes\",INDEX(Lookups!$K$39:$P$51,IF(ISNA(MATCH(G32,Lookups!$J$6:$J$17,1)+1),1,MATCH(G32,Lookups!$J$6:$J$17,1)+1),MATCH(D32,Lookups!$K$4:$P$4,0))*G32,IF(M32=\"Yes\",INDEX(Lookups!$C$39:$H$51,IF(ISNA(MATCH(G32,Lookups!$B$6:$B$17,1)+1),1,MATCH(G32,Lookups!$B$6:$B$17,1)+1),MATCH(D32,Lookups!$C$4:$H$4,0))*G32,0))*K32","v":0},{"$f":"IF(N32=\"Yes\",INDEX(Lookups!$K$57:$P$69,IF(ISNA(MATCH(G32,Lookups!$J$6:$J$17,1)+1),1,MATCH(G32,Lookups!$J$6:$J$17,1)+1),MATCH(D32,Lookups!$K$4:$P$4,0))*G32,IF(M32=\"Yes\",INDEX(Lookups!$C$57:$H$69,IF(ISNA(MATCH(G32,Lookups!$B$6:$B$17,1)+1),1,MATCH(G32,Lookups!$B$6:$B$17,1)+1),MATCH(D32,Lookups!$C$4:$H$4,0))*G32,0))*K32","v":0},{"$f":"IF(D32=0,\"-\",IF(OR(D32=Lookups!$C$4,Inputs!D32=Lookups!$D$4),Inputs!R32*Inputs!K32,R32*Inputs!K32*Inputs!G32))","v":"-"},{"$f":"Lookups!O120","v":"-"},{"$f":"IF(N32=\"Yes\",INDEX(Lookups!$K$90:$P$102,IF(ISNA(MATCH(G32,Lookups!$B$6:$B$17,1)+1),1,MATCH(G32,Lookups!$B$6:$B$17,1)+1),MATCH(D32,Lookups!$C$4:$H$4,0)),IF(M32=\"Yes\",INDEX(Lookups!$C$90:$H$102,IF(ISNA(MATCH(G32,Lookups!$B$6:$B$17,1)+1),1,MATCH(G32,Lookups!$B$6:$B$17,1)+1),MATCH(D32,Lookups!$C$4:$H$4,0))))","v":false}]

{"sheet":"Input Key","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Building Type",null,"Device Type","Measure code"]
[null,"Office",null,"Split System","S"]
[null,"Retail",null,"Unitary A/C","U"]
[null,"School",null,"Heat Pump","H"]
[null,"University",null,"Packaged Terminal A/C","PTAC"]
[null,"Religious Facility",null,"Packaged Terminal Heat Pump","PTHP"]
[null,"Grocery",null,"Water Cooled","W"]
[null,"Lodging"]
[null,"Industrial"]
[null,"Warehouse"]
[null,"Health Facility"]
[null,"Multifamily"]
[null,"Restaurant"]
[null,"Other"]

{"sheet":"Validation","index":12,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Building Type",null,"Device Type","Translate","Device Type"]
[null,"Office",null,"Split System","Unitary","Split System"]
[null,"Retail",null,"Unitary A/C","Unitary","Unitary A/C"]
[null,"School",null,"Heat Pump","Unitary","Heat Pump"]
[null,"University",null,"Packaged Terminal A/C","PTAC","Packaged Terminal A/C"]
[null,"Religious Facility",null,"Packaged Terminal Heat Pump","PTHP","Packaged Terminal Heat Pump"]
[null,"Grocery",null,"Water Cooled","Water","Water Cooled"]
[null,"Lodging"]
[null,"Industrial"]
[null,"Warehouse"]
[null,"Health Facility"]
[null,"Multifamily"]
[null,"Restaurant"]
[null,"Other"]

{"sheet":"Measure Code Summary","index":13,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,8,29,9],[8,1,8,10],[12,3,12,4],[17,10,18,10],[17,8,18,8],[17,1,18,1],[16,1,16,10],[13,3,13,4],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,17,7],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[17,9,18,9],[5,1,5,9],[10,3,10,4],[11,3,11,4]]}
[]
[]
[]
[null,"Measure Summary"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 10.1"}]
[null," "]
[null,"Copyright © 2015 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[null,"Required General Project Information"]
[]
[null,null,"Project Name",{"$f":"IF(Inputs!D11=\"\",\"\",Inputs!D11)","v":""},null,null,"Prepared By"]
[null,null,"Project Address",{"$f":"IF(Inputs!D12=\"\",\"\",Inputs!D12)","v":""},null,null,"Contact Person",{"$f":"IF(Inputs!G12=\"\",\"\",Inputs!G12)","v":""}]
[null,null,"City",{"$f":"IF(Inputs!D13=\"\",\"\",Inputs!D13)","v":""},null,null,"Phone",{"$f":"IF(Inputs!G13=\"\",\"\",Inputs!G13)","v":""}]
[null,null,"ZIP",{"$f":"IF(Inputs!D14=\"\",\"\",Inputs!D14)","v":""},null,null,"Email",{"$f":"IF(Inputs!G14=\"\",\"\",Inputs!G14)","v":""}]
[]
[]
[null,"Unitary HVAC Equipment Information"]
[null,"Equipment","Manufacturer","Model Number","Unit Size (Tons)","Unit Efficiency",null,null,"Incentive $/Ton","Quantity","Subtotal Incentive"]
[null,null,null,null,null,"SEER or IEER","EER","COP"]
[null,{"$f":"IF(Inputs!D23=\"\",\"\",Inputs!D23)","v":""},{"$f":"IF(Inputs!E23=\"\",\"\",Inputs!E23)","v":""},{"$f":"IF(Inputs!F23=\"\",\"\",Inputs!F23)","v":""},{"$f":"IF(Inputs!G23=\"\",\"\",Inputs!G23)","v":""},{"$f":"IF(Inputs!I23=\"\",\"\",Inputs!I23)","v":""},{"$f":"IF(Inputs!H23=\"\",\"\",Inputs!H23)","v":""},{"$f":"IF(Inputs!J23=\"\",\"\",Inputs!J23)","v":""},{"$f":"IF(OR(K20=\"\",E20=\"\"),\"\",K20/E20/J20)","v":""},{"$f":"IF(Inputs!K23=\"\",\"\",Inputs!K23)","v":""},{"$f":"IF(Inputs!L23=\"\",\"\",Inputs!L23)","v":"-"}]
[null,{"$f":"IF(Inputs!D24=\"\",\"\",Inputs!D24)","v":""},{"$f":"IF(Inputs!E24=\"\",\"\",Inputs!E24)","v":""},{"$f":"IF(Inputs!F24=\"\",\"\",Inputs!F24)","v":""},{"$f":"IF(Inputs!G24=\"\",\"\",Inputs!G24)","v":""},{"$f":"IF(Inputs!I24=\"\",\"\",Inputs!I24)","v":""},{"$f":"IF(Inputs!H24=\"\",\"\",Inputs!H24)","v":""},{"$f":"IF(Inputs!J24=\"\",\"\",Inputs!J24)","v":""},{"$f":"IF(OR(K21=\"\",E21=\"\"),\"\",K21/E21/J21)","v":""},{"$f":"IF(Inputs!K24=\"\",\"\",Inputs!K24)","v":""},{"$f":"IF(Inputs!L24=\"\",\"\",Inputs!L24)","v":"-"}]
[null,{"$f":"IF(Inputs!D25=\"\",\"\",Inputs!D25)","v":""},{"$f":"IF(Inputs!E25=\"\",\"\",Inputs!E25)","v":""},{"$f":"IF(Inputs!F25=\"\",\"\",Inputs!F25)","v":""},{"$f":"IF(Inputs!G25=\"\",\"\",Inputs!G25)","v":""},{"$f":"IF(Inputs!I25=\"\",\"\",Inputs!I25)","v":""},{"$f":"IF(Inputs!H25=\"\",\"\",Inputs!H25)","v":""},{"$f":"IF(Inputs!J25=\"\",\"\",Inputs!J25)","v":""},"",{"$f":"IF(Inputs!K25=\"\",\"\",Inputs!K25)","v":""},{"$f":"IF(Inputs!L25=\"\",\"\",Inputs!L25)","v":"-"}]
[null,{"$f":"IF(Inputs!D26=\"\",\"\",Inputs!D26)","v":""},{"$f":"IF(Inputs!E26=\"\",\"\",Inputs!E26)","v":""},{"$f":"IF(Inputs!F26=\"\",\"\",Inputs!F26)","v":""},{"$f":"IF(Inputs!G26=\"\",\"\",Inputs!G26)","v":""},{"$f":"IF(Inputs!I26=\"\",\"\",Inputs!I26)","v":""},{"$f":"IF(Inputs!H26=\"\",\"\",Inputs!H26)","v":""},{"$f":"IF(Inputs!J26=\"\",\"\",Inputs!J26)","v":""},"",{"$f":"IF(Inputs!K26=\"\",\"\",Inputs!K26)","v":""},{"$f":"IF(Inputs!L26=\"\",\"\",Inputs!L26)","v":"-"}]
[null,{"$f":"IF(Inputs!D27=\"\",\"\",Inputs!D27)","v":""},{"$f":"IF(Inputs!E27=\"\",\"\",Inputs!E27)","v":""},{"$f":"IF(Inputs!F27=\"\",\"\",Inputs!F27)","v":""},{"$f":"IF(Inputs!G27=\"\",\"\",Inputs!G27)","v":""},{"$f":"IF(Inputs!I27=\"\",\"\",Inputs!I27)","v":""},{"$f":"IF(Inputs!H27=\"\",\"\",Inputs!H27)","v":""},{"$f":"IF(Inputs!J27=\"\",\"\",Inputs!J27)","v":""},"",{"$f":"IF(Inputs!K27=\"\",\"\",Inputs!K27)","v":""},{"$f":"IF(Inputs!L27=\"\",\"\",Inputs!L27)","v":"-"}]
[null,{"$f":"IF(Inputs!D28=\"\",\"\",Inputs!D28)","v":""},{"$f":"IF(Inputs!E28=\"\",\"\",Inputs!E28)","v":""},{"$f":"IF(Inputs!F28=\"\",\"\",Inputs!F28)","v":""},{"$f":"IF(Inputs!G28=\"\",\"\",Inputs!G28)","v":""},{"$f":"IF(Inputs!I28=\"\",\"\",Inputs!I28)","v":""},{"$f":"IF(Inputs!H28=\"\",\"\",Inputs!H28)","v":""},{"$f":"IF(Inputs!J28=\"\",\"\",Inputs!J28)","v":""},"",{"$f":"IF(Inputs!K28=\"\",\"\",Inputs!K28)","v":""},{"$f":"IF(Inputs!L28=\"\",\"\",Inputs!L28)","v":"-"}]
[null,{"$f":"IF(Inputs!D29=\"\",\"\",Inputs!D29)","v":""},{"$f":"IF(Inputs!E29=\"\",\"\",Inputs!E29)","v":""},{"$f":"IF(Inputs!F29=\"\",\"\",Inputs!F29)","v":""},{"$f":"IF(Inputs!G29=\"\",\"\",Inputs!G29)","v":""},{"$f":"IF(Inputs!I29=\"\",\"\",Inputs!I29)","v":""},{"$f":"IF(Inputs!H29=\"\",\"\",Inputs!H29)","v":""},{"$f":"IF(Inputs!J29=\"\",\"\",Inputs!J29)","v":""},"",{"$f":"IF(Inputs!K29=\"\",\"\",Inputs!K29)","v":""},{"$f":"IF(Inputs!L29=\"\",\"\",Inputs!L29)","v":"-"}]
[null,{"$f":"IF(Inputs!D30=\"\",\"\",Inputs!D30)","v":""},{"$f":"IF(Inputs!E30=\"\",\"\",Inputs!E30)","v":""},{"$f":"IF(Inputs!F30=\"\",\"\",Inputs!F30)","v":""},{"$f":"IF(Inputs!G30=\"\",\"\",Inputs!G30)","v":""},{"$f":"IF(Inputs!I30=\"\",\"\",Inputs!I30)","v":""},{"$f":"IF(Inputs!H30=\"\",\"\",Inputs!H30)","v":""},{"$f":"IF(Inputs!J30=\"\",\"\",Inputs!J30)","v":""},"",{"$f":"IF(Inputs!K30=\"\",\"\",Inputs!K30)","v":""},{"$f":"IF(Inputs!L30=\"\",\"\",Inputs!L30)","v":"-"}]
[null,{"$f":"IF(Inputs!D31=\"\",\"\",Inputs!D31)","v":""},{"$f":"IF(Inputs!E31=\"\",\"\",Inputs!E31)","v":""},{"$f":"IF(Inputs!F31=\"\",\"\",Inputs!F31)","v":""},{"$f":"IF(Inputs!G31=\"\",\"\",Inputs!G31)","v":""},{"$f":"IF(Inputs!I31=\"\",\"\",Inputs!I31)","v":""},{"$f":"IF(Inputs!H31=\"\",\"\",Inputs!H31)","v":""},{"$f":"IF(Inputs!J31=\"\",\"\",Inputs!J31)","v":""},"",{"$f":"IF(Inputs!K31=\"\",\"\",Inputs!K31)","v":""},{"$f":"IF(Inputs!L31=\"\",\"\",Inputs!L31)","v":"-"}]
[null,{"$f":"IF(Inputs!D32=\"\",\"\",Inputs!D32)","v":""},{"$f":"IF(Inputs!E32=\"\",\"\",Inputs!E32)","v":""},{"$f":"IF(Inputs!F32=\"\",\"\",Inputs!F32)","v":""},{"$f":"IF(Inputs!G32=\"\",\"\",Inputs!G32)","v":""},{"$f":"IF(Inputs!I32=\"\",\"\",Inputs!I32)","v":""},{"$f":"IF(Inputs!H32=\"\",\"\",Inputs!H32)","v":""},{"$f":"IF(Inputs!J32=\"\",\"\",Inputs!J32)","v":""},"",{"$f":"IF(Inputs!K32=\"\",\"\",Inputs!K32)","v":""},{"$f":"IF(Inputs!L32=\"\",\"\",Inputs!L32)","v":"-"}]
[null,null,null,null,null,null,null,null,"Total Pre-approved Incentive",null,{"$f":"SUM(K20:K29)","v":0}]

{"sheet":"Version Tracking","index":14,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B49991<>\"\"),B1:B49991)","v":10.1}]
[null,"Version","Notes","Date","Updated By"]
[null,2.1,"All editing and revisions required","2015-09-24","JZ"]
[null,2.2000000000000002,"Added formulas to calculate incentives","2015-09-25","RC"]
[null,2.2999999999999998,"Removed link to external workbook","2015-09-29","RM"]
[null,2.4,"Formatting, added buttons for tab, adjusted based on Jennifer's feedback","2015-10-21","RM"]
[null,2.5,"Added equipment tab instructions, changed tab colors, minor edits","2015-10-22","JZ"]
[null,2.6,"Added equipment buttons","2015-10-22","RM"]
[null,2.7,"Minor content edits","2015-10-27","Jennifer Mosser"]
[null,2.8,"Minor edits and fix radio button on CI tab","2015-11-20","JZ and RM"]
[null,2.9,"Additional minor edits","2015-11-20","JZ and RC"]
[null,3,"Increased >1 ton PTHP COP requirement and adjusted formulas","2016-02-29","RC"]
[null,3.1,"Fixed text on Equipment Input Instructions tab","2016-09-14","RC"]
[null,3.2,"Updated unitary and chiller incentives for 2017","2017-01-18","RC"]
[null,3.3,"Added additonal contact.  Changed Project Informaiton tab title from Customer Information tab.  Formatting","2017-01-20","JZ"]
[null,3.4,"Increased ACC VFD performance incentive cap","2017-01-23","RC"]
[null,3.5,"reduced incentives, increased ACC VFD IPLV","2017-02-02","RC"]
[null,3.6,"Revisions requested by Annika Goodson","2017-02-02","Mary Freibert"]
[null,3.7,"Language revisions and fixed buttons","2017-11-13","RC"]
[null,3.8,"Updated efficiency requirements","2018-07-17","RC"]
[null,3.9,"Final efficiency requirements","2018-07-31","RC"]
[null,10.1,"Updated Dominion Branding and T&Cs","2020-08-27","JSE"]

{"sheet":"Lookups","index":15,"n_rows":120,"n_cols":20,"rows_kept":120,"cut":false,"hidden":true,"merged":[[108,1,109,1],[108,2,109,2],[108,3,109,3],[108,14,109,14],[108,15,109,15],[2,17,2,19],[108,4,108,6],[108,7,108,9],[108,10,108,12],[108,13,109,13]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Lookups!$K$6:$P$17,MATCH(63,Lookups!$J$6:$J$17,1)+1,MATCH(\"Heat Pump\",Lookups!$K$4:$P$4,0))","v":10.199999999999999}]
[]
[null,"Tier 1 Efficiencies",null,"Full Load",null,null,null,null,null,"Tier 2 Efficiencies",null,"Full Load",null,null,null,null,null,"PTHP COP"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Packaged Terminal Heat Pump","T1","T2"]
[null,0.25,11.8,11.5,12,11.6,12,14,null,0.25,100,100,12.5,12,12.5,100,null,0.25,3.3,0]
[null,0.74,11.8,11.5,12,11.6,12,14,null,0.74,100,100,12.5,12,12.5,100,null,0.75,3.3,0]
[null,0.75,11,10.8,12,11.6,12,14,null,0.75,100,100,12.5,12,12.5,100,null,1,3.3,0]
[null,0.99,11,10.8,12,11.6,12,14,null,0.99,100,100,12.5,12,12.5,100,null,1.01,3.1,0]
[null,1,10.3,10.1,12,11.6,12,14,null,1,100,100,12.5,12,12.5,100,null,100,3.1,0]
[null,1.42,10.3,10.1,12,11.6,12,14,null,1.42,100,100,12.5,12,12.5,100]
[null,5.4,10.3,10.1,11.5,11.5,12,14,null,5.4,100,100,12.5,12,12.5,100]
[null,5.41,10.3,10.1,11.5,11.5,11.5,14,null,5.41,100,100,12,12,12,100]
[null,11.25,10.3,10.1,11.5,11.5,11.5,14,null,11.25,100,100,12,12,12,100]
[null,20,10.3,10.1,10.5,10.5,10.5,14,null,20,100,100,10.85,10.85,10.85,100]
[null,62.999000000000002,10.3,10.1,10.5,10.5,10.5,14,null,62.999000000000002,100,100,10.85,10.85,10.85,100]
[null,63,10.3,10.1,9.6999999999999993,9.6999999999999993,9.6999999999999993,14,null,63,100,100,10.199999999999999,10.199999999999999,10.199999999999999,100]
[null,1000,10.3,10.1,9.6999999999999993,9.6999999999999993,9.6999999999999993,14,null,1000,100,100,10.199999999999999,10.199999999999999,10.199999999999999,100]
[]
[]
[null,"Tier 1 Efficiencies",null,"Part Load",null,null,null,null,null,"Tier 2 Efficiencies",null,"Part Load"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled"]
[null,0.25,0,0,14,14,14,0,null,0.25,100,100,15,15,15,100]
[null,0.74,0,0,14,14,14,0,null,0.74,100,100,15,15,15,100]
[null,0.75,0,0,14,14,14,0,null,0.75,100,100,15,15,15,100]
[null,0.99,0,0,14,14,14,0,null,0.99,100,100,15,15,15,100]
[null,1,0,0,14,14,14,0,null,1,100,100,15,15,15,100]
[null,1.42,0,0,14,14,14,0,null,1.42,100,100,15,15,15,100]
[null,5.4,0,0,11.7,11.7,14,0,null,5.4,100,100,15,12.2,15,100]
[null,5.41,0,0,11.7,11.7,11.7,0,null,5.41,100,100,12.2,12.2,12.2,100]
[null,11.25,0,0,11.7,11.7,11.7,0,null,11.25,100,100,12.2,12.2,12.2,100]
[null,20,0,0,10.6,10.6,10.6,0,null,20,100,100,11,11,11,100]
[null,62.999000000000002,0,0,10.6,10.6,10.6,0,null,62.999000000000002,100,100,11,11,11,100]
[null,63,0,0,9.8000000000000007,9.8000000000000007,9.8000000000000007,0,null,63,100,100,10.3,10.3,10.3,100]
[null,1000,0,0,9.8000000000000007,9.8000000000000007,9.8000000000000007,0,null,1000,100,100,10.3,10.3,10.3,100]
[]
[]
[null,"Tier 1 kWh Savings",null,null,null,null,null,null,null,"Tier 2 kWh Savings"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled"]
[null,0.25,221.98352138465702,243.1782009687542,86,86,90,62,null,0.25,221.98352138465702,243.1782009687542,172,172,180,279.99999999999898]
[null,0.74,221.98,243.1782009687546,86,86,90,83,null,0.74,221.98,243.1782009687546,172,172,180,279.99999999999898]
[null,0.75,221.97647861534301,243.17820096875499,86,86,90,118,null,0.75,221.97647861534301,243.17820096875499,172,172,180,279.99999999999898]
[null,0.99,221.97295723068601,243.17820096875499,86,86,90,118,null,0.99,221.97295723068601,243.17820096875499,172,172,180,279.99999999999932]
[null,1,230.48,243.17820096875599,86,86,90,118,null,1,203.48489460260203,243.17820096875599,172,172,180,279.99999999999932]
[null,1.42,184.98626782054737,221.07109178977663,86,86,90,118,null,1.42,184.98626782054737,221.07109178977663,172,172,180,279.99999999999898]
[null,5.4,184.98626782054737,221.07109178977663,86,86,90,280,null,5.4,184.98626782054737,221.07109178977663,132.35714285714295,172,180,279.99999999999898]
[null,5.41,184.98626782054737,221.07109178977663,39.333333333333407,39.33,72.272727272727295,279.99999999999932,null,5.41,184.98626782054737,221.07109178977663,104.88888888888894,104.88888888888894,144.54545454545459,279.99999999999898]
[null,11.25,184.98626782054737,221.07109178977663,39.333333333333407,39.33,72.272727272727295,279.99999999999932,null,11.25,184.98626782054737,221.07109178977663,104.88888888888894,104.88888888888894,144.54545454545459,279.99999999999898]
[null,20,184.986267820547,221.071091789777,69.666666666666671,69.67,162,3267,null,20,184.986267820547,221.071091789777,139.33333333333334,139.33333333333334,252,279.99999999999898]
[null,62.999000000000002,184.986267820547,221.071091789777,69.666666666666671,69.67,162,3267,null,62.999000000000002,184.986267820547,221.071091789777,139.33333333333334,139.33333333333334,252,279.99999999999898]
[null,63,184.986267820547,221.071091789777,77.857142857142932,77.857142857142932,90.416666666666714,10292,null,63,184.986267820547,221.071091789777,132.35714285714295,132.35714285714295,180.83333333333343,279.99999999999898]
[null,1000,184.986267820547,221.071091789777,0,77.86,90.416666666666714,163364,null,1000,184.986267820547,221.071091789777,80.5,80.5,180.83333333333343,279.99999999999898]
[]
[]
[]
[null,"Tier 1 kW Savings",null,null,null,null,null,null,null,"Tier 2 kW Savings"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled"]
[null,0.25,0.10892079432420153,0.12334035902666832,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,0.25,0.10892079432420153,0.12334035902666832,0.114,0.114,0.104,0.146666666666666]
[null,0.74,9.9844061463851289E-2,0.12334035902666851,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,0.74,0.11,0.12334035902666851,0.114,0.114,0.104,0.146666666666666]
[null,0.75,9.0767328603501202E-2,0.11212759911515305,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,0.75,9.0767328603501202E-2,0.123340359026669,0.114,0.114,0.104,0.146666666666666]
[null,0.99,9.0767328603501202E-2,0.11212759911515305,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,0.99,9.0767328603501202E-2,0.123340359026669,0.114,0.114,0.104,0.14666666666666631]
[null,1,9.0767328603501202E-2,0.11212759911515305,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,1,9.0767328603501202E-2,0.123340359026669,0.114,0.114,0.104,0.14666666666666631]
[null,1.42,9.0767328603501202E-2,0.11212759911515305,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.1,null,1.42,9.0767328603501202E-2,0.11212759911515305,0.114,0.114,0.104,0.146666666666666]
[null,5.4,9.0767328603501202E-2,0.11212759911515305,5.7000000000000002E-2,5.7000000000000002E-2,5.1999999999999998E-2,0.15,null,5.4,9.0767328603501202E-2,0.11212759911515305,0.114,0.114,0.104,0.2]
[null,5.41,9.0767328603501202E-2,0.11212759911515305,2.6333333333333386E-2,2.6333333333333386E-2,4.0909090909090923E-2,0.15,null,5.41,9.0767328603501202E-2,0.11212759911515305,7.0222222222222255E-2,7.0222222222222255E-2,8.1818181818181845E-2,0.2]
[null,11.25,9.0767328603501202E-2,0.11212759911515305,2.6333333333333386E-2,2.6333333333333386E-2,4.0909090909090923E-2,0.15,null,11.25,9.0767328603501202E-2,0.11212759911515305,7.0222222222222255E-2,7.0222222222222255E-2,8.1818181818181845E-2,0.2]
[null,20,9.0767328603501202E-2,0.11212759911515301,4.6666666666666669E-2,4.6666666666666669E-2,0.9,0.15,null,20,9.0767328603501202E-2,0.11212759911515301,9.3333333333333338E-2,9.3333333333333338E-2,1.4,0.2]
[null,62.999000000000002,9.0767328603501202E-2,0.11212759911515301,4.6666666666666669E-2,4.6666666666666669E-2,0.9,0.15,null,62.999000000000002,9.0767328603501202E-2,0.11212759911515301,9.3333333333333338E-2,9.3333333333333338E-2,1.4,0.2]
[null,63,9.0767328603501202E-2,0.11212759911515301,5.2142857142857192E-2,5.2142857142857192E-2,5.0833333333333362E-2,0.15,null,63,9.0767328603501202E-2,0.11212759911515301,8.864285714285719E-2,8.864285714285719E-2,0.10166666666666672,0.2]
[null,1000,9.0767328603501202E-2,0.11212759911515301,0,0,5.0833333333333362E-2,0.15,null,1000,9.0767328603501202E-2,0.11212759911515301,5.4000000000000006E-2,5.4000000000000006E-2,0.10166666666666672,0.2]
[]
[]
[]
[null,"Tier 1 Incentives",null,null,null,null,null,null,null,"Tier 2 Incentives"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled"]
[null,0.25,20,20,40,40,40,60,null,0.25,20,20,60,60,30,60,null,0.25,20]
[null,0.75,25,22,40,40,40,60,null,0.75,25,22,60,60,30,60,null,0.75,25]
[null,0.99,25,22,40,40,40,60,null,0.99,25,22,60,60,30,60,null,1,30]
[null,1,35,30,40,40,40,60,null,1,35,22,60,60,30,60,null,10,30]
[null,1.42,35,30,40,40,40,60,null,1.42,35,30,60,60,30,60]
[null,5.4,35,30,40,40,40,60,null,5.4,35,30,60,60,30,60]
[null,5.41,35,30,40,40,40,60,null,5.41,35,30,60,60,30,60]
[null,11.25,35,30,40,40,40,60,null,11.25,35,30,60,60,30,60]
[null,20,35,30,40,40,40,60,null,20,35,30,60,60,30,60]
[null,62.999000000000002,35,30,40,40,40,60,null,62.999000000000002,35,30,60,60,30,60]
[null,63,35,30,40,40,40,60,null,63,35,30,60,60,30,60]
[null,1000,35,30,10,10,10,60,null,1000,35,30,15,15,15,60]
[]
[null,"Tier 1 Counting",null,null,null,null,null,null,null,"Tier 2 Counting"]
[null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled",null,"Tonnage Under","Packaged Terminal A/C","Packaged Terminal Heat Pump","Split System","Unitary A/C","Heat Pump","Water Cooled"]
[null,0.25,"Tier 1_PTAC_0","Tier 1_PTHP_0","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Water_0",null,0.25,"Tier 2_PTAC_0","Tier 2_PTHP_0","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Water_0"]
[null,0.74,"Tier 1_PTAC_0.75","Tier 1_PTHP_0.75","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Water_0",null,0.74,"Tier 2_PTAC_0.75","Tier 2_PTHP_0.75","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Water_0"]
[null,0.75,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Water_0",null,0.75,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Water_0"]
[null,0.99,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Water_0",null,0.99,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Water_0"]
[null,1,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_1","Tier 1_Water_5.4",null,1,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_1","Tier 2_Water_5.4",null,0.99]
[null,1.42,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_0","Tier 1_Unitary_0","Tier 1_Unitary_2","Tier 1_Water_11.25",null,1.42,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_0","Tier 2_Unitary_0","Tier 2_Unitary_2","Tier 2_Water_11.25"]
[null,5.4,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_5.4","Tier 1_Unitary_5.4","Tier 1_Unitary_5.4","Tier 1_Water_5.4",null,5.4,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_5.4","Tier 2_Unitary_5.4","Tier 2_Unitary_5.4","Tier 2_Water_5.4",null,{"$f":"VLOOKUP(R94,R75:S78,2)","v":25}]
[null,5.41,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_11.25","Tier 1_Unitary_11.25","Tier 1_Unitary_11.25","Tier 1_Water_11.25",null,5.41,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_11.25","Tier 2_Unitary_11.25","Tier 2_Unitary_11.25","Tier 2_Water_11.25"]
[null,11.25,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_11.25","Tier 1_Unitary_11.25","Tier 1_Unitary_11.25","Tier 1_Water_11.25",null,11.25,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_11.25","Tier 2_Unitary_11.25","Tier 2_Unitary_11.25","Tier 2_Water_11.25"]
[null,20,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_20","Tier 1_Unitary_20","Tier 1_Unitary_20","Tier 1_Water_11.25",null,20,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_20","Tier 2_Unitary_20","Tier 2_Unitary_20","Tier 2_Water_11.25"]
[null,62.999000000000002,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_20","Tier 1_Unitary_20","Tier 1_Unitary_20","Tier 1_Water_11.25",null,62.999000000000002,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_20","Tier 2_Unitary_20","Tier 2_Unitary_20","Tier 2_Water_11.25"]
[null,63,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_63","Tier 1_Unitary_63","Tier 1_Unitary_63","Tier 1_Water_11.25",null,63,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_63","Tier 2_Unitary_63","Tier 2_Unitary_63","Tier 2_Water_11.25"]
[null,1000,"Tier 1_PTAC_1","Tier 1_PTHP_1","Tier 1_Unitary_63","Tier 1_Unitary_63","Tier 1_Unitary_63","Tier 1_Water_11.25",null,1000,"Tier 2_PTAC_1","Tier 2_PTHP_1","Tier 2_Unitary_63","Tier 2_Unitary_63","Tier 2_Unitary_63","Tier 2_Water_11.26"]
[]
[]
[]
[]
[]
[null,"Proposed Unit Tier Qualification"]
[null,"Input sheet row","Device Type","Unit Tons","Proposed Unit Efficiencies",null,null,"Tier 1 required efficiency",null,null,"Tier 2 required efficiency",null,null,"Tier Achieved","Incentive/ton or unit for PTAC/HP"]
[null,null,null,null,"EER","SEER or IEER","COP","Full Load","Part Load","COP","Full Load","Part Load","COP"]
[null,1,{"$f":"Inputs!D23","v":0},{"$f":"Inputs!G23","v":0},{"$f":"Inputs!H23","v":0},{"$f":"Inputs!I23","v":0},{"$f":"Inputs!J23","v":0},{"$f":"IF(C111=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D111,Lookups!$B$5:$B$17,1),MATCH(C111,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C111=0,\"-\",INDEX($C$22:$H$34,MATCH(D111,Lookups!$B$22:$B$34,1),MATCH(C111,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C111=0,\"-\",IF(C111=D4,VLOOKUP(D111,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C111=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D111,Lookups!$J$5:$J$17,1),MATCH(C111,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C111=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D111,Lookups!$J$22:$J$34,1),MATCH(C111,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C111=0,\"-\",IF(C111=D4,VLOOKUP(D111,$R$5:$T$9,3,1),0))","v":"-"},{"$f":"IF(C111=0,\"-\",IF(AND(E111>=K111,F111>=L111,G111>=M111),\"Tier 2\",IF(AND(E111>=H111,F111>=I111,G111>=J111),\"Tier 1\",\"-\")))","v":"-"},{"$f":"IF(C111=0,\"-\",IF(N111=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D111,Lookups!$B$75:$B$86,1),MATCH(C111,Lookups!$C$74:$H$74,0)),IF(N111=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D111,Lookups!$J$75:$J$86,1),MATCH(C111,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,2,{"$f":"Inputs!D24","v":0},{"$f":"Inputs!G24","v":0},{"$f":"Inputs!H24","v":0},{"$f":"Inputs!I24","v":0},{"$f":"Inputs!J24","v":0},{"$f":"IF(C112=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D112,Lookups!$B$5:$B$17,1),MATCH(C112,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C112=0,\"-\",INDEX($C$22:$H$34,MATCH(D112,Lookups!$B$22:$B$34,1),MATCH(C112,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C112=0,\"-\",IF(C112=D5,VLOOKUP(D112,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C112=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D112,Lookups!$J$5:$J$17,1),MATCH(C112,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C112=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D112,Lookups!$J$22:$J$34,1),MATCH(C112,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C112=0,\"-\",IF(C112=D5,VLOOKUP(D112,$R$5:$T$9,3,1),0))","v":"-"},{"$f":"IF(C112=0,\"-\",IF(AND(E112>=K112,F112>=L112,G112>=M112),\"Tier 2\",IF(AND(E112>=H112,F112>=I112,G112>=J112),\"Tier 1\",\"-\")))","v":"-"},{"$f":"IF(C112=0,\"-\",IF(N112=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D112,Lookups!$B$75:$B$86,1),MATCH(C112,Lookups!$C$74:$H$74,0)),IF(N112=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D112,Lookups!$J$75:$J$86,1),MATCH(C112,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,3,{"$f":"Inputs!D25","v":0},{"$f":"Inputs!G25","v":0},{"$f":"Inputs!H25","v":0},{"$f":"Inputs!I25","v":0},{"$f":"Inputs!J25","v":0},{"$f":"IF(C113=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D113,Lookups!$B$5:$B$17,1),MATCH(C113,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C113=0,\"-\",INDEX($C$22:$H$34,MATCH(D113,Lookups!$B$22:$B$34,1),MATCH(C113,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C113=0,\"-\",IF(C113=D6,VLOOKUP(D113,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C113=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D113,Lookups!$J$5:$J$17,1),MATCH(C113,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C113=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D113,Lookups!$J$22:$J$34,1),MATCH(C113,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C113=0,\"-\",IF(C113=D6,VLOOKUP(D113,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C113=0,\"-\",IF(N113=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D113,Lookups!$B$75:$B$86,1),MATCH(C113,Lookups!$C$74:$H$74,0)),IF(N113=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D113,Lookups!$J$75:$J$86,1),MATCH(C113,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,4,{"$f":"Inputs!D26","v":0},{"$f":"Inputs!G26","v":0},{"$f":"Inputs!H26","v":0},{"$f":"Inputs!I26","v":0},{"$f":"Inputs!J26","v":0},{"$f":"IF(C114=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D114,Lookups!$B$5:$B$17,1),MATCH(C114,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C114=0,\"-\",INDEX($C$22:$H$34,MATCH(D114,Lookups!$B$22:$B$34,1),MATCH(C114,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C114=0,\"-\",IF(C114=D9,VLOOKUP(D114,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C114=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D114,Lookups!$J$5:$J$17,1),MATCH(C114,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C114=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D114,Lookups!$J$22:$J$34,1),MATCH(C114,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C114=0,\"-\",IF(C114=D9,VLOOKUP(D114,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C114=0,\"-\",IF(N114=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D114,Lookups!$B$75:$B$86,1),MATCH(C114,Lookups!$C$74:$H$74,0)),IF(N114=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D114,Lookups!$J$75:$J$86,1),MATCH(C114,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,5,{"$f":"Inputs!D27","v":0},{"$f":"Inputs!G27","v":0},{"$f":"Inputs!H27","v":0},{"$f":"Inputs!I27","v":0},{"$f":"Inputs!J27","v":0},{"$f":"IF(C115=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D115,Lookups!$B$5:$B$17,1),MATCH(C115,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C115=0,\"-\",INDEX($C$22:$H$34,MATCH(D115,Lookups!$B$22:$B$34,1),MATCH(C115,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C115=0,\"-\",IF(C115=D10,VLOOKUP(D115,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C115=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D115,Lookups!$J$5:$J$17,1),MATCH(C115,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C115=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D115,Lookups!$J$22:$J$34,1),MATCH(C115,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C115=0,\"-\",IF(C115=D10,VLOOKUP(D115,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C115=0,\"-\",IF(N115=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D115,Lookups!$B$75:$B$86,1),MATCH(C115,Lookups!$C$74:$H$74,0)),IF(N115=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D115,Lookups!$J$75:$J$86,1),MATCH(C115,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,6,{"$f":"Inputs!D28","v":0},{"$f":"Inputs!G28","v":0},{"$f":"Inputs!H28","v":0},{"$f":"Inputs!I28","v":0},{"$f":"Inputs!J28","v":0},{"$f":"IF(C116=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D116,Lookups!$B$5:$B$17,1),MATCH(C116,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C116=0,\"-\",INDEX($C$22:$H$34,MATCH(D116,Lookups!$B$22:$B$34,1),MATCH(C116,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C116=0,\"-\",IF(C116=D11,VLOOKUP(D116,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C116=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D116,Lookups!$J$5:$J$17,1),MATCH(C116,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C116=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D116,Lookups!$J$22:$J$34,1),MATCH(C116,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C116=0,\"-\",IF(C116=D11,VLOOKUP(D116,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C116=0,\"-\",IF(N116=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D116,Lookups!$B$75:$B$86,1),MATCH(C116,Lookups!$C$74:$H$74,0)),IF(N116=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D116,Lookups!$J$75:$J$86,1),MATCH(C116,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,7,{"$f":"Inputs!D29","v":0},{"$f":"Inputs!G29","v":0},{"$f":"Inputs!H29","v":0},{"$f":"Inputs!I29","v":0},{"$f":"Inputs!J29","v":0},{"$f":"IF(C117=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D117,Lookups!$B$5:$B$17,1),MATCH(C117,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C117=0,\"-\",INDEX($C$22:$H$34,MATCH(D117,Lookups!$B$22:$B$34,1),MATCH(C117,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C117=0,\"-\",IF(C117=D13,VLOOKUP(D117,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C117=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D117,Lookups!$J$5:$J$17,1),MATCH(C117,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C117=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D117,Lookups!$J$22:$J$34,1),MATCH(C117,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C117=0,\"-\",IF(C117=D13,VLOOKUP(D117,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C117=0,\"-\",IF(N117=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D117,Lookups!$B$75:$B$86,1),MATCH(C117,Lookups!$C$74:$H$74,0)),IF(N117=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D117,Lookups!$J$75:$J$86,1),MATCH(C117,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,8,{"$f":"Inputs!D30","v":0},{"$f":"Inputs!G30","v":0},{"$f":"Inputs!H30","v":0},{"$f":"Inputs!I30","v":0},{"$f":"Inputs!J30","v":0},{"$f":"IF(C118=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D118,Lookups!$B$5:$B$17,1),MATCH(C118,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C118=0,\"-\",INDEX($C$22:$H$34,MATCH(D118,Lookups!$B$22:$B$34,1),MATCH(C118,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C118=0,\"-\",IF(C118=D14,VLOOKUP(D118,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C118=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D118,Lookups!$J$5:$J$17,1),MATCH(C118,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C118=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D118,Lookups!$J$22:$J$34,1),MATCH(C118,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C118=0,\"-\",IF(C118=D14,VLOOKUP(D118,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C118=0,\"-\",IF(N118=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D118,Lookups!$B$75:$B$86,1),MATCH(C118,Lookups!$C$74:$H$74,0)),IF(N118=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D118,Lookups!$J$75:$J$86,1),MATCH(C118,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,9,{"$f":"Inputs!D31","v":0},{"$f":"Inputs!G31","v":0},{"$f":"Inputs!H31","v":0},{"$f":"Inputs!I31","v":0},{"$f":"Inputs!J31","v":0},{"$f":"IF(C119=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D119,Lookups!$B$5:$B$17,1),MATCH(C119,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C119=0,\"-\",INDEX($C$22:$H$34,MATCH(D119,Lookups!$B$22:$B$34,1),MATCH(C119,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C119=0,\"-\",IF(C119=D16,VLOOKUP(D119,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C119=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D119,Lookups!$J$5:$J$17,1),MATCH(C119,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C119=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D119,Lookups!$J$22:$J$34,1),MATCH(C119,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C119=0,\"-\",IF(C119=D16,VLOOKUP(D119,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C119=0,\"-\",IF(N119=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D119,Lookups!$B$75:$B$86,1),MATCH(C119,Lookups!$C$74:$H$74,0)),IF(N119=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D119,Lookups!$J$75:$J$86,1),MATCH(C119,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]
[null,10,{"$f":"Inputs!D32","v":0},{"$f":"Inputs!G32","v":0},{"$f":"Inputs!H32","v":0},{"$f":"Inputs!I32","v":0},{"$f":"Inputs!J32","v":0},{"$f":"IF(C120=0,\"-\",INDEX(Lookups!$C$5:$H$17,MATCH(D120,Lookups!$B$5:$B$17,1),MATCH(C120,Lookups!$C$4:$H$4,0)))","v":"-"},{"$f":"IF(C120=0,\"-\",INDEX($C$22:$H$34,MATCH(D120,Lookups!$B$22:$B$34,1),MATCH(C120,Lookups!$C$21:$H$21,0)))","v":"-"},{"$f":"IF(C120=0,\"-\",IF(C120=D17,VLOOKUP(D120,$R$5:$T$9,2,1),0))","v":"-"},{"$f":"IF(C120=0,\"-\",INDEX(Lookups!$K$5:$P$17,MATCH(D120,Lookups!$J$5:$J$17,1),MATCH(C120,Lookups!$K$4:$P$4,0)))","v":"-"},{"$f":"IF(C120=0,\"-\",INDEX(Lookups!$K$22:$P$34,MATCH(D120,Lookups!$J$22:$J$34,1),MATCH(C120,Lookups!$K$21:$P$21,0)))","v":"-"},{"$f":"IF(C120=0,\"-\",IF(C120=D17,VLOOKUP(D120,$R$5:$T$9,3,1),0))","v":"-"},"-",{"$f":"IF(C120=0,\"-\",IF(N120=\"Tier 1\",INDEX(Lookups!$C$75:$H$86,MATCH(D120,Lookups!$B$75:$B$86,1),MATCH(C120,Lookups!$C$74:$H$74,0)),IF(N120=\"Tier 2\",INDEX(Lookups!$K$75:$P$86,MATCH(D120,Lookups!$J$75:$J$86,1),MATCH(C120,Lookups!$K$74:$P$74,0)),0)))","v":"-"}]

{"sheet":"Old Summary","index":16,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[38,3,40,3],[16,1,16,10],[21,1,22,1],[33,3,35,3],[21,9,22,9],[17,5,19,5],[17,6,19,6],[17,7,19,7],[37,1,37,10],[32,1,32,10],[27,1,27,10],[17,1,18,2],[17,3,19,3],[21,2,22,2],[21,6,22,6],[21,5,22,5],[8,1,8,10],[20,1,20,10],[21,10,22,10],[10,3,10,4],[11,3,11,4],[12,3,12,4],[17,8,19,8],[17,10,19,10],[21,8,22,8],[13,3,13,4],[17,9,19,9],[17,4,19,4],[1,1,1,10],[2,1,2,10],[5,1,5,10],[3,1,3,10],[4,1,4,10]]}
[]
[]
[]
[null,"Measure Summary"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 10.1"}]
[null," "]
[null,"Copyright © 2010 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[null,"Required General Project Information"]
[]
[null,null,"Project Name",{"$f":"IF(Inputs!D11=\"\",\"\",Inputs!D11)","v":""},null,null,"Prepared By",{"$f":"IF(Inputs!G11=\"\",\"\",Inputs!G11)","v":""}]
[null,null,"Project Address",{"$f":"IF(Inputs!D12=\"\",\"\",Inputs!D12)","v":""},null,null,"Contact Person",{"$f":"IF(Inputs!G12=\"\",\"\",Inputs!G12)","v":""}]
[null,null,"City",{"$f":"IF(Inputs!D13=\"\",\"\",Inputs!D13)","v":""},null,null,"Phone",{"$f":"IF(Inputs!G13=\"\",\"\",Inputs!G13)","v":""}]
[null,null,"ZIP",{"$f":"IF(Inputs!D14=\"\",\"\",Inputs!D14)","v":""},null,null,"Email",{"$f":"IF(Inputs!G14=\"\",\"\",Inputs!G14)","v":""}]
[]
[]
[null,"Unitary HVAC Measures and Incentives"]
[null,"Size Category (Tons)",null,"Sub-Category","Tier 1 Minimum Requirement","Tier 1 Quantity","Tier 1 Incentive","Tier 2 Minimum Requirement","Tier 2 Quantity","Tier 2 Incentive","Total Incentive"]
[]
[null,"Minimum Size (Greater Than or Equal To)","Maximum Size (Less Than, Not Equal To)"]
[null,"Air Conditioners and Heat Pumps (Cooling Mode) - Unitary and Matched Split Systems"]
[null,0,5.4,"Split System","14.0 SEER and 12.0 EER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B22,Inputs!$K$23:$K$32)","v":0},"$20 / ton","15.0 SEER and 12.5 EER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B22,Inputs!$K$23:$K$32)","v":0},"$30 / ton",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B22,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B22,Inputs!$Q$23:$Q$32)","v":0}]
[null,null,null,"Single Package","14.0 SEER and 11.6 EER",null,null,"15.0 SEER and 12.0 EER"]
[null,5.4,20,"Split System and Single Package","11.5 EER and 11.7 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B24,Inputs!$K$23:$K$32)","v":0},"$20 / ton","12.0 EER and 12.2 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B24,Inputs!$K$23:$K$32)","v":0},"$30 / ton",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B24,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B24,Inputs!$Q$23:$Q$32)","v":0}]
[null,20,63,"Split System and Single Package","10.5 EER and 10.6 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B25,Inputs!$K$23:$K$32)","v":0},"$20 / ton","10.85 EER and 11.0 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B25,Inputs!$K$23:$K$32)","v":0},"$30 / ton",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B25,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B25,Inputs!$Q$23:$Q$32)","v":0}]
[null,63,null,"Split System and Single Package","9.7 EER and 9.8 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B26,Inputs!$K$23:$K$32)","v":0},"$10 / ton","10.2 EER and 10.3 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B26,Inputs!$K$23:$K$32)","v":0},"$15 / ton",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Unitary_\"&$B26,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Unitary_\"&$B26,Inputs!$Q$23:$Q$32)","v":0}]
[]
[null,"Air Conditioners and Heat Pumps (Cooling Mode) - Water and Evaporative"]
[null,0,5.4,"Split System and Single Package","14.0 EER and 14.2 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B29,Inputs!$K$23:$K$32)","v":0},"$30 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B29,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B29,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B29,Inputs!$Q$23:$Q$32)","v":0}]
[null,5.4,11.25,"Split System and Single Package","14.0 EER and 14.2 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B30,Inputs!$K$23:$K$32)","v":0},"$30 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B30,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B30,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B30,Inputs!$Q$23:$Q$32)","v":0}]
[null,11.25,null,"Split System and Single Package","14.0 EER and 14.2 IEER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B31,Inputs!$K$23:$K$32)","v":0},"$30 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B31,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_Water_\"&$B31,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_Water_\"&$B31,Inputs!$Q$23:$Q$32)","v":0}]
[]
[null,"Packaged Terminal Air Conditioner (PTAC)"]
[null,0,0.75,"Single Package","11.8 EER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B34,Inputs!$K$23:$K$32)","v":0},"$10 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B34,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B34,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B34,Inputs!$Q$23:$Q$32)","v":0}]
[null,0.75,1,null,"11.0 EER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B35,Inputs!$K$23:$K$32)","v":0},"$15 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B35,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B35,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B35,Inputs!$Q$23:$Q$32)","v":0}]
[null,1,null,null,"10.3 EER",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B36,Inputs!$K$23:$K$32)","v":0},"$20 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B36,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTAC_\"&$B36,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTAC_\"&$B36,Inputs!$Q$23:$Q$32)","v":0}]
[]
[null,"Packaged Terminal Heat Pump (PTHP)"]
[null,0,0.75,"Single Package","11.5 EER and 3.3 COP",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B39,Inputs!$K$23:$K$32)","v":0},"$10 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B39,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B39,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B39,Inputs!$Q$23:$Q$32)","v":0}]
[null,0.75,1,null,"10.8 EER and 3.2 COP",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B40,Inputs!$K$23:$K$32)","v":0},"$15 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B40,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B40,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B40,Inputs!$Q$23:$Q$32)","v":0}]
[null,1,null,null,"10.1 EER and 3.1 COP",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B41,Inputs!$K$23:$K$32)","v":0},"$20 / ton","N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B41,Inputs!$K$23:$K$32)","v":0},"N/A",{"$f":"SUMIF(Inputs!$S$23:$S$32,\"Tier 1_PTHP_\"&$B41,Inputs!$Q$23:$Q$32)+SUMIF(Inputs!$S$23:$S$32,\"Tier 2_PTHP_\"&$B41,Inputs!$Q$23:$Q$32)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Incentive",{"$f":"SUM(K22:K41)","v":0}]

{"sheet":"AEG Import","index":17,"n_rows":11,"n_cols":234,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Measure #","Import?","1st_Yr_Non_Resource_Benefits","Adjusted_Volume","AFUE","AHRI_Ref_number","Air_Leakage","amperage","Annual_Cords_Saved","Annual_Cords_Used","Annual_Gallons_Saved","Annual_Gallons_Used","Annual_Non_Resource_Benefits","Annual_Pounds_Saved","Annual_Pounds_Used","Annual_Therms_Saved","Annual_Therms_Used","Area_Lit","Avg_Wind_Speed","ballast_type_sel","Base_or_Efficiency_Case_sel","basecase_age","basecase_Capacity_or_size","basecase_efficiency","basecase_other","basecase_quantity","basecase_system_rating","basecase_type","basecase_unit_rating","Baseline_equipment_cost","Baseline_Installed_Cost","Baseline_system_age","BEF","Benefit_1_Description_sel","Benefit_1a_Description","Benefit_2_Description","Benefit_2a_Description","benefit_multiplier","Blower_Fan_E_Use","Blower_Fan_motor_control_sel","Boiler_Type_sel","BTU","BTU_Cool","BTU_Heat","Btuh","Building_Conditioned_Area","building_type_sel","Capacity","CEE_Tier_sel","CFM","CO2_Generator","CO2_Pt_Source_or_Meter","Comm_Coincidence","Comm_Coincidence_Factor","Commercial Spillover","Commercial_Free_Driver","Commercial_Free_Ridership","Commercial_Net_to_Gross_Ratio","Commercial_Snap_Back","Commissioned_sel","Control_Type_sel","Cooling_Bonus","COP","CRI","CTRL_Comm_Type_sel","Customer_refID","DeltaTemp","Description","discount_rate","Door_type_sel","Duct_Leakage","Economizer_Type_sel","EER","ef","Efficiency","Elec_Savings_Adj","Elec_Util_cust_Incentive","Eligibility_Status_sel","End_Use_sel","ENERGY_STAR_Compliant_sel","Equip_Orientation_sel","equipment_cost","Exist_Equip_Age","Exist_Equip_Life","Fed_Tax_Credit_Eligible_sel","Fixture_Efficiency","fixture_mounting_sel","Fixture_Size","fixture_style_sel","Flow","fuel_used_2_sel","fuel_used_3_sel","fuel_used_sel","Full_Cost_for_Retrofit","Full_Load_Hours","Full_Load_Hours_Cool","Full_Load_Hours_Heat","Gas_Util_Cust_Incentive","Geothermal_Loop_Type_sel","Green_Certification_sel","Heat_Exchanger_Type_sel","Heating_Penalty","Heating_Type_sel","HERS_rating","HiEff_Blower_Fan_sel","Horse_Power","Hrs_of_Use","HSPF","Hub_Height","Incentive_Per_Unit","Incremental_Installed_Cost","Install_Type_sel","Installed_Cost","Insulation_Location_sel","Insulation_Material_sel","IPLV","IRR","IsElectric","IsTested","kW_Impact","kw_pjm_peak_adjusted","kw_pjm_peak_unadjusted","kW_Summer_Gross","kW_Summer_Net","kw_ton_IPLV","kw_ton_peak","kW_Winter_Gross","kW_Winter_Net","kWh_Gross","kWh_Impact","kWh_Net","kwh_nonsummer_offpeak_adjusted","kwh_nonsummer_offpeak_unadjusted","kwh_nonsummer_peak_adjusted","kwh_nonsummer_peak_unadjusted","kwh_summer_offpeak_adjusted","kwh_summer_offpeak_unadjusted","kwh_summer_peak_adjusted","kwh_summer_peak_unadjusted","Lamp_Length","lamp_type_sel","Line_loss_kW","Line_loss_kWh","Load","LoadFactor","Loadshape_sel","Loan_Interest_Rate","Location","Lumens","Manufacturer","Manufacturer_Non_split_system","Manufacturer_Split_System_Coil","Manufacturer_Split_System_Condenser","Manufacturer_sub_components_1","Manufacturer_sub_components_2","Manufacturer_sub_components_3","MBtuh_Input","MBtuh_Output","Measure_Life","Meets_building_code_sel","MEF","Model","Motor_Enclosure_Type_sel","name","Name_Plate_Power_Rating","Natural_Gas_Savings_Adjustment","Natural_Gas_Savings_mmbtu","New_Baseline_Inst_Cost","nox","NPV","number_lamps","Number_of_Panes","Number_Units","Output_Watts","Phase_sel","Pool_pump_type_sel","pool_size","pool_type_sel","Program_Name","quantity","R_value","rebate_kwh","rebate_ton","rebate_watt","refid","Resi_coincidence","Resi_Coincidence_factor","Residential Spillover","Residential_Freedriver","Residential_Freeridership","Residential_Net_to_Gross_Ratio","Residential_Snap_back","RLA","RLA_Actual","RNC_Tier_sel","RPM","SEER","SENS_Latent_Total","Sensor_Type_sel","Serial_number","SHGC","Solar_AC_kW_Net","sox","SRI","Steady_state_efficiency","Style","Thermal_efficiency","Thickness","Tilt_Angle","Tons","Tons_Controlled","Tune_up_equipment_type_sel","turbine_rating_capacity","U_value","Units_Controlled_by_Control","Unused_Incentive","userid","ventilation_type_sel","Volts","Volume_ft3","Warranty","Water","Water_Consumption","Water_Factor","water_gallons_per_minute_ton","Water_Heating_Type_sel","Water_Storage_Capacity","Wattage","Watts_sqft","Watts_sqft_Saved","Wind_Output_Reduction","Window_Frame_Material_sel","Window_Gas_sel","Window_Type_sel"]
[{"$f":"VLOOKUP(FH2,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G23=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J23","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H23","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q23/IF(FX2=0,1,FX2)),\" \",Inputs!Q23/IF(FX2=0,1,FX2))","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,{"$f":"Inputs!R23","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"DS2","v":0},null,null,{"$f":"Inputs!P23/IF(FX2=0,1,FX2)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O23/IF(FX2=0,1,FX2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E23","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F23","v":0},null,{"$f":"Inputs!D23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G23","v":0}]
[{"$f":"VLOOKUP(FH3,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G24=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J24","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H24","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q24/IF(FX3=0,1,FX3)),\" \",Inputs!Q24/IF(FX3=0,1,FX3))","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,{"$f":"Inputs!R24","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"DS3","v":0},null,null,{"$f":"Inputs!P24/IF(FX3=0,1,FX3)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O24/IF(FX3=0,1,FX3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E24","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F24","v":0},null,{"$f":"Inputs!D24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G24","v":0}]
[{"$f":"VLOOKUP(FH4,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G25=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H25","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q25/IF(FX4=0,1,FX4)),\" \",Inputs!Q25/IF(FX4=0,1,FX4))","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,{"$f":"Inputs!R25","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"DS4","v":0},null,null,{"$f":"Inputs!P25/IF(FX4=0,1,FX4)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O25/IF(FX4=0,1,FX4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E25","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F25","v":0},null,{"$f":"Inputs!D25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G25","v":0}]
[{"$f":"VLOOKUP(FH5,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G26=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J26","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H26","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q26/IF(FX5=0,1,FX5)),\" \",Inputs!Q26/IF(FX5=0,1,FX5))","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,{"$f":"Inputs!R26","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P26/IF(FX5=0,1,FX5)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O26/IF(FX5=0,1,FX5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E26","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F26","v":0},null,{"$f":"Inputs!D26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G26","v":0}]
[{"$f":"VLOOKUP(FH6,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G27=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J27","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H27","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q27/IF(FX6=0,1,FX6)),\" \",Inputs!Q27/IF(FX6=0,1,FX6))","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,{"$f":"Inputs!R27","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P27/IF(FX6=0,1,FX6)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O27/IF(FX6=0,1,FX6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E27","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F27","v":0},null,{"$f":"Inputs!D27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G27","v":0}]
[{"$f":"VLOOKUP(FH7,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G28=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J28","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H28","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q28/IF(FX7=0,1,FX7)),\" \",Inputs!Q28/IF(FX7=0,1,FX7))","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,{"$f":"Inputs!R28","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P28/IF(FX7=0,1,FX7)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O28/IF(FX7=0,1,FX7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E28","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F28","v":0},null,{"$f":"Inputs!D28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G28","v":0}]
[{"$f":"VLOOKUP(FH8,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G29=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J29","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H29","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q29/IF(FX8=0,1,FX8)),\" \",Inputs!Q29/IF(FX8=0,1,FX8))","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,{"$f":"Inputs!R29","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P29/IF(FX8=0,1,FX8)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O29/IF(FX8=0,1,FX8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E29","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F29","v":0},null,{"$f":"Inputs!D29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G29","v":0}]
[{"$f":"VLOOKUP(FH9,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G30=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J30","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H30","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q30/IF(FX9=0,1,FX9)),\" \",Inputs!Q30/IF(FX9=0,1,FX9))","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,{"$f":"Inputs!R30","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P30/IF(FX9=0,1,FX9)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O30/IF(FX9=0,1,FX9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E30","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F30","v":0},null,{"$f":"Inputs!D30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G30","v":0}]
[{"$f":"VLOOKUP(FH10,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G31=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J31","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H31","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q31/IF(FX10=0,1,FX10)),\" \",Inputs!Q31/IF(FX10=0,1,FX10))","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,{"$f":"Inputs!R31","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P31/IF(FX10=0,1,FX10)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O31/IF(FX10=0,1,FX10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E31","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F31","v":0},null,{"$f":"Inputs!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G31","v":0}]
[{"$f":"VLOOKUP(FH11,'Input Key'!$D$4:$E$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Inputs!G32=\"\",\"No\",\"Yes\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!J32","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'AEG Import'!H32","v":0},null,null,null,{"$f":"IF(ISERROR(Inputs!Q32/IF(FX11=0,1,FX11)),\" \",Inputs!Q32/IF(FX11=0,1,FX11))","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,{"$f":"Inputs!R32","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"Inputs!P32/IF(FX11=0,1,FX11)","v":0},null,null,null,null,null,null,{"$f":"Inputs!O32/IF(FX11=0,1,FX11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!E32","v":0},null,null,null,null,null,null,null,null,15,null,null,{"$f":"Inputs!F32","v":0},null,{"$f":"Inputs!D32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!K32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!G32","v":0}]