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

{"sheet":"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],[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,19,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 # 14.2"}]
["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 customers 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 per Project type. Details of the program, including incentive levels and technical requirements, are subject to change without prior notice.  You may go to www.DominionEnergy.com/ForYourBizSC to get the most current program information, or you may call 877-784-7234.\n                                                                                                                                                                                                                                   Eligible Participants\nEnergyWise for Your Business is open to all non-residential electric customers within our service territory, except for customers eligible for Rate 23 that have elected to opt out of the Demand Side Management (DSM) programs by notifying us in writing using the Opt-Out form.\n                                                                                                                                                                                                                                  Eligible Equipment\nEligible equipment and incentive amounts are listed on the Equipment Tabs.  Eligible equipment include HVAC Unitary equipment, Window Film, HVAC Chillers, Cool Roofs, 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",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.DominionEnergy.com/ForYourBizSC or contact us at SCEnergyExperts@SC.DominionEnergyAccount.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. Physical signature is required on W-9. 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."]
["Pre-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. \n"]
[]
["\nQuestions\nIf you have questions about the program, call 877-784-7234, email SCEnergyExperts@SC.DominionEnergyAccount.com, or visit www.DominionEnergy.com/ForYourBizSC.\n\n",null,null,null,null,null,null,null,null,null,"Email:","SCEnergyExperts@SC.DominionEnergyAccount.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 \n$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."]
[null,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. Proof of purchase must include an itemized invoice for all Energy Conservation Measures (ECMs) that may qualify for the EnergyWise for Your Business incentive. Each individual product or model number must include the corresponding costs and quantity. 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],[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],[26,0,26,15],[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],[7,0,8,10],[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],[5,0,5,2],[5,3,5,6],[5,8,5,9],[5,11,5,14],[6,0,6,12],[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],[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":"14.2"}]

{"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). Physical signature is required on W-9. 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. See Terms and Conditions for invoicing requirements."]
["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":"14.2"}]

{"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],[2,0,5,0],[2,1,5,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 eligible Customers pursuant to the Program is referred to herein as a “Project” or “Projects”.  Customers eligible for Rate 23 who have elected to opt out of Demand Side Management programs, by notifying us 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 our exceeding its 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 per Project type.\n 2. Project Types: The Program includes the following four Project types: Lighting Projects, HVAC/Motors Projects, Food Service and High Efficiency Equipment Projects, and Custom Projects. Lighting projects include Projects that use the Retrofit and New Construction Lighting worksheet.  HVAC/Motors Projects include Projects listed on the HVAC Application including Unitary HVAC, Chillers, Window Film, or Variable Frequency Drives.  Food Service and High Efficiency Equipment Projects include all cooking equipment and “plug load” equipment that is incentivized under the prescriptive Program. Restaurant cooking equipment, ice machines, vending machine and refrigeration controls, commercial washers/dryers, and lighting that may be included inside the aforementioned equipment are considered Food Service and High Efficiency Equipment Projects.  Custom Projects are Projects that can demonstrate cost effective and lasting energy efficiency and do not fall under one of the aforementioned Project types. These Projects are “custom” tailored to the Customer for each Project and cannot receive a prescriptive incentive as the savings varies widely with each Project and technology.  Strategic Energy Management, Building controls, Building Tune-ups, Whole Building Solutions, Technical Services, and new emerging technologies generally fall under this Project type.  The above examples are provided for illustrative purposes only and may not be inclusive of all Projects.                                                                                                \n3. 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 not 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.\n 4.  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. 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).\n5. 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.  \n6.  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.\n 7.  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 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. ","8.  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.\n9.  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.\n10.  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.             \n11.  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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                     12.  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.                                                                                                                                                                                                                                                        \n13.  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. \n14.  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, Inc. 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.\n15.  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.    \n16.  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.       \n17.  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 14.2"}]

{"sheet":"Equipment Input Instructions","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,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,"▪   Cool Roof - Reflective roof systems"]
[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@SC.DominionEnergyAccount.com"]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 14.2"}]

{"sheet":"HVAC Unitary","index":5,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,1,59,12],[8,16,8,18],[38,12,40,12],[40,4,40,6],[38,9,40,9],[41,1,41,3],[41,4,41,6],[41,7,41,8],[46,10,46,11],[41,10,41,11],[42,1,42,3],[37,1,37,12],[45,1,45,12],[36,1,36,3],[50,1,50,3],[50,4,50,6],[50,7,50,8],[50,10,50,11],[56,1,56,3],[51,1,51,12],[48,10,48,11],[43,4,43,6],[43,7,43,8],[46,4,46,6],[47,10,47,11],[38,1,38,3],[46,7,46,8],[39,1,39,3],[40,1,40,3],[39,4,39,6],[39,7,39,8],[39,10,39,11],[1,1,1,13],[2,1,2,13],[19,10,19,12],[18,3,18,13],[15,1,16,1],[5,0,5,14],[19,9,20,9],[19,13,20,13],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[7,0,14,14],[6,0,6,14],[19,1,20,1],[19,2,20,2],[19,20,20,20],[19,19,20,19],[19,16,20,16],[19,17,20,17],[19,18,20,18],[36,4,36,6],[36,7,36,8],[36,10,36,11],[19,14,20,14],[19,7,20,7],[19,8,20,8],[35,1,35,12],[57,1,57,3],[57,7,57,8],[57,10,57,11],[56,4,58,6],[58,1,58,3],[58,7,58,8],[58,10,58,11],[53,1,53,3],[53,7,53,8],[53,10,53,11],[52,4,54,6],[54,1,54,3],[54,7,54,8],[54,10,54,11],[52,1,52,3],[52,7,52,8],[52,10,52,11],[55,1,55,12],[56,7,56,8],[56,10,56,11],[49,1,49,3],[49,4,49,6],[49,7,49,8],[49,10,49,11],[48,1,48,3],[48,4,48,6],[48,7,48,8],[46,1,47,3],[38,4,38,6],[42,4,42,6],[42,7,42,8],[42,10,42,11],[43,10,43,11],[44,1,44,3],[44,4,44,6],[44,7,44,8],[44,10,44,11],[43,1,43,3],[38,7,38,8],[40,7,40,8],[38,10,38,11],[40,10,40,11],[47,4,47,6],[47,7,47,8]]}
[]
[]
[]
[null,"C&I Prescriptive - Unitary HVAC"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 14.2"}]
["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 1.\n§ Units being installed must meet all minimum requirements listed in Table 2.\n§    In 2023, new efficiency rating systems were introduced for A/C and Heat Pump systems less than 65,000 BTUh in size. Both efficiency systems minimum qualifying efficiency ratings are listed below where applicable. When entering efficiency ratings for these units below, please\n         indicate in column H, which rating system is being provided. The two rating systems are:\n         \"EER / SEER / HSPF\" and \"EER2 / SEER2 / HSPF2\". "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary Table"]
[null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q23:Q32)","v":0},{"$f":"SUM(R23:R32)","v":0},{"$f":"SUM(S23:S32)","v":0}]
[]
[]
[]
[]
[null,"Input Cells"]
[null,null,"Data input allowed in shaded cells only.",null,null,null,null,null,null,null,null,"*If print button malfunctions, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide these columns for public facing document"]
[null,null,null,"Unitary HVAC"]
[null,"Line Item","Building Type","Device Type","Manufacturer","Model #","Size (tons)","AHRI Cooling Capacity\n(BTUh)","AHRI Heating Capacity\n(BTUh)","If AC or HP unit is nominally\n ≤ 65,000 BTUh, indicate if efficiencies entered are \nEER / SEER / HSPF or \nEER2 / SEER2 / HSPF2","Unit Efficiency",null,null,"Quantity","Incentive Requested",null,"Total kWh Saved","Summer Coincident Peak kW Saved","Total Incentive","Incentive per Ton or unit","Unit Qualifies"]
[null,null,null,null,null,null,null,null,null,null,"EER or EER2","SEER2 or IEER","HSPF2 or COP"]
[null,"Ex.","Office","Split System Heat Pump","klanvbk",32160,5,61000,56000,"EER2 / SEER2 / HSPF2",12.5,16,8,1,{"$f":"S22","v":0}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(S23*U23,0)","v":0},null,{"$f":"HVACCalcs!AN5","v":0},{"$f":"HVACCalcs!AO5","v":0},{"$f":"IFERROR(IF(VLOOKUP(D23,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N23*T23,N23*T23*G23),0)","v":0},{"$f":"HVACCalcs!AD5","v":0},{"$f":"IF(HVACCalcs!AC5=\"Yes\",1,0)","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(S24*U24,0)","v":0},null,{"$f":"HVACCalcs!AN6","v":0},{"$f":"HVACCalcs!AO6","v":0},{"$f":"IFERROR(IF(VLOOKUP(D24,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N24*T24,N24*T24*G24),0)","v":0},{"$f":"HVACCalcs!AD6","v":0},{"$f":"IF(HVACCalcs!AC6=\"Yes\",1,0)","v":0}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN7","v":0},{"$f":"HVACCalcs!AO7","v":0},{"$f":"IFERROR(IF(VLOOKUP(D25,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N25*T25,N25*T25*G25),0)","v":0},{"$f":"HVACCalcs!AD7","v":0},{"$f":"IF(HVACCalcs!AC7=\"Yes\",1,0)","v":0}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN8","v":0},{"$f":"HVACCalcs!AO8","v":0},{"$f":"IFERROR(IF(VLOOKUP(D26,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N26*T26,N26*T26*G26),0)","v":0},{"$f":"HVACCalcs!AD8","v":0},{"$f":"IF(HVACCalcs!AC8=\"Yes\",1,0)","v":0}]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN9","v":0},{"$f":"HVACCalcs!AO9","v":0},{"$f":"IFERROR(IF(VLOOKUP(D27,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N27*T27,N27*T27*G27),0)","v":0},{"$f":"HVACCalcs!AD9","v":0},{"$f":"IF(HVACCalcs!AC9=\"Yes\",1,0)","v":0}]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN10","v":0},{"$f":"HVACCalcs!AO10","v":0},{"$f":"IFERROR(IF(VLOOKUP(D28,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N28*T28,N28*T28*G28),0)","v":0},{"$f":"HVACCalcs!AD10","v":0},{"$f":"IF(HVACCalcs!AC10=\"Yes\",1,0)","v":0}]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN11","v":0},{"$f":"HVACCalcs!AO11","v":0},{"$f":"IFERROR(IF(VLOOKUP(D29,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N29*T29,N29*T29*G29),0)","v":0},{"$f":"HVACCalcs!AD11","v":0},{"$f":"IF(HVACCalcs!AC11=\"Yes\",1,0)","v":0}]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN12","v":0},{"$f":"HVACCalcs!AO12","v":0},{"$f":"IFERROR(IF(VLOOKUP(D30,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N30*T30,N30*T30*G30),0)","v":0},{"$f":"HVACCalcs!AD12","v":0},{"$f":"IF(HVACCalcs!AC12=\"Yes\",1,0)","v":0}]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN13","v":0},{"$f":"HVACCalcs!AO13","v":0},{"$f":"IFERROR(IF(VLOOKUP(D31,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N31*T31,N31*T31*G31),0)","v":0},{"$f":"HVACCalcs!AD13","v":0},{"$f":"IF(HVACCalcs!AC13=\"Yes\",1,0)","v":0}]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"HVACCalcs!AN14","v":0},{"$f":"HVACCalcs!AO14","v":0},{"$f":"IFERROR(IF(VLOOKUP(D32,Validation!$C$3:$G$9,5,FALSE)=\"Unit\",N32*T32,N32*T32*G32),0)","v":0},{"$f":"HVACCalcs!AD14","v":0},{"$f":"IF(HVACCalcs!AC14=\"Yes\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF('Project Information'!$L$6=\"\",\"Please fill in zip code in cell L6 on Project Information tab\",IF(OR(VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE)=\"Charleston\",VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE)=\"Columbia\"),1)),\"Ineligible zip code. Please check cell L6 on Project Information tab\")","v":"Please fill in zip code in cell L6 on Project Information tab"}]
[]
[]
[null,"TABLE 2: QUALIFYING EFFICIENCY AND INCENTIVES"]
[null,"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"]
[null,"Air Conditioners (Cooling Mode) - Unitary and Split Systems"]
[null,"< 3.75",null,null,"Split System",null,null,"16.0 SEER or 15.2 SEER2",null,"$75/ton","17.0 SEER or 16.2 SEER2",null,"$100/ton"]
[null,"≥ 3.75 and < 5.4",null,null,"Split System",null,null,"16.0 SEER or 15.2 SEER2",null,null,"17.0 SEER or 16.2 SEER2"]
[null,"< 5.4",null,null,"Single Package",null,null,"15.0 SEER or 14.3 SEER2",null,null,"16.0 SEER or 15.2 SEER2"]
[null,"≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"15.3 IEER",null,"$60/ton","15.8 IEER",null,"$75/ton"]
[null,"≥ 11.25 and < 20",null,null,"Split System and Single Package",null,null,"14.7 IEER",null,"$50/ton","15.10 IEER",null,"$70/ton"]
[null,"≥ 20 and < 63.3",null,null,"Split System and Single Package",null,null,"13.6 IEER",null,"$40/ton","14.10 IEER",null,"$60/ton"]
[null," ≥ 63.3",null,null,"Split System and Single Package",null,null,"11.6 IEER",null,"$15/ton","12.0 IEER",null,"$20/ton"]
[null,"Air Source Heat Pumps (Cooling Mode) - Unitary and Split Systems"]
[null,"< 5.4",null,null,"Split System",null,null,"16.0 SEER and 9.1 HSPF\n15.2 SEER2 and 7.8 HSPF2",null,"$100/ton","17.0 SEER and 9.4 HSPF\n16.2 SEER2 and 8.0 HSPF2",null,"$125/ton"]
[null,null,null,null,"Single Package",null,null,"15.0 SEER and 8.3 HSPF\n14.3 SEER2 and 7 HSPF2",null,"$100/ton","16.0 SEER and 8.5 HSPF\n15.2 SEER2 and 7.2 HSPF2",null,"$125/ton"]
[null,"≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"15.3 IEER",null,"$75/ton","15.8 IEER",null,"$100/ton"]
[null,"≥ 11.25 and < 20",null,null,"Split System and Single Package",null,null,"14.7 IEER",null,"$55/ton","15.10 IEER",null,"$80/ton"]
[null,"≥ 20",null,null,"Split System and Single Package",null,null,"13.6 IEER",null,"$50/ton","14.10 IEER",null,"$75/ton"]
[null,"Packaged Terminal Air Conditioner (PTAC)"]
[null,"< 0.75",null,null,"Single Package",null,null,"12.0 EER",null,"$20/unit","N/A",null,"N/A"]
[null,"≥ 0.75 and < 1.0",null,null,null,null,null,"11.5 EER",null,"$30/unit","N/A",null,"N/A"]
[null,"≥ 1.0",null,null,null,null,null,"10.5 EER",null,"$40/unit","N/A",null,"N/A"]
[null,"Packaged Terminal Heat Pump (PTHP)"]
[null,"< 0.75",null,null,"Single Package",null,null,"12.0 EER and 3.3 COP",null,"$40/unit","N/A",null,"N/A"]
[null,"≥ 0.75 and < 1.0",null,null,null,null,null,"11.5 EER and 3.2 COP",null,"$50/unit","N/A",null,"N/A"]
[null,"≥ 1.0",null,null,null,null,null,"10.3 EER and 3.2 COP",null,"$60/unit","N/A",null,"N/A"]
[null,"Note: Tons are based on 12,000 BTUH net output per ton."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 14.2"}]

{"sheet":"HVAC Unitary-old","index":6,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":true,"merged":[[48,9,48,10],[29,3,29,5],[29,6,29,7],[29,9,29,10],[29,8,30,8],[43,6,43,7],[44,6,44,7],[40,0,40,2],[40,3,40,5],[40,6,40,7],[40,9,40,10],[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],[49,0,49,11],[27,9,27,10],[27,6,27,7],[30,6,30,7],[31,6,31,7],[33,6,33,7],[45,0,45,11],[46,0,46,2],[46,3,48,5],[47,0,47,2],[48,0,48,2],[46,6,46,7],[47,6,47,7],[41,0,41,11],[42,0,42,2],[42,3,44,5],[43,0,43,2],[44,0,44,2],[42,9,42,10],[43,9,43,10],[35,0,35,11],[36,3,36,5],[36,6,36,7],[36,9,36,10],[42,6,42,7],[48,6,48,7],[44,9,44,10],[46,9,46,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],[33,0,33,2],[33,3,33,5],[34,0,34,2],[47,9,47,10],[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"]
["S",12,null,12,5,null,18,18,null,1,{"$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,{"$f":"IF(OR(A9=#REF!,'HVAC Unitary'!D23=#REF!),'HVAC Unitary'!T23*'HVAC Unitary'!N23,R23*'HVAC Unitary'!N23*'HVAC Unitary'!G23)","v":{"$error":"#REF!"}}]
["U",2,null,2,2,15,15,null,null,2,{"$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":50},null,{"$f":"IF(OR(AND(A10=\"P\")),J10*K10,IF(OR(AND(A10=\"T\")),J10*K10,E10*J10*K10))","v":200},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":"Yes"},{"$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"}]
["P",2,null,2,2,15,15,null,null,1,35,null,35,null,null,null,null,null,null,null,"H","Yes","N/A"]
["T",1,null,1,3,15,15,null,8,1,30,null,30,null,null,null,null,null,null,null,"P","Yes","N/A"]
["H",1,null,1,3,15,15,null,8,1,50,null,150,null,null,null,null,null,null,null,"T","Yes","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"]
[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":415}]
[]
[]
["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,"$75/ton","16.0 SEER and 12.5 EER",null,"$100/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,"$60/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,"$70/ton"]
["≥ 20 and < 63.3",null,null,"Split System and Single Package",null,null,"10.6 EER and 12.1 IEER",null,"$40/ton","10.6 EER and 12.4 IEER",null,"$60/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,"$100/ton","16.0 SEER and 14.6 EER",null,"$125/ton"]
["≥ 5.4 and < 11.25",null,null,"Split System and Single Package",null,null,"12.0 EER and 13.4 IEER",null,"$75/ton","12.0 EER and 13.8 IEER",null,"$100/ton"]
["≥ 11.25 and < 20",null,null,"Split System and Single Package",null,null,"11.8 EER and 12.8 IEER",null,"$55/ton","11.8 EER and 13.2 IEER",null,"$80/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,"$20/ton","10.3 EER and 12.3 IEER",null,"$25/ton"]
["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,"$30/unit","N/A",null,"N/A"]
["≥ 1.0",null,null,null,null,null,"10.5 EER",null,"$40/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,"$40/unit","N/A",null,"N/A"]
["≥ 0.75 and < 1.0",null,null,null,null,null,"11.5 EER and 3.2 COP",null,"$50/unit","N/A",null,"N/A"]
["≥ 1.0",null,null,null,null,null,"10.3 EER and 3.2 COP",null,"$60/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 14.2"}]

{"sheet":"HVACCalcs","index":7,"n_rows":70,"n_cols":41,"rows_kept":70,"cut":false,"hidden":true,"merged":[[20,6,20,8],[2,9,3,9],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,8,3,8],[2,7,3,7],[2,27,3,27],[2,29,3,29],[2,35,2,37],[2,6,3,6],[2,4,3,4],[2,14,3,14],[2,31,3,31],[2,30,3,30],[2,32,3,32],[2,34,3,34],[2,33,3,33],[2,28,3,28],[2,10,3,10],[2,18,2,20],[2,21,2,23],[2,24,2,26],[2,3,3,3],[2,1,3,1],[2,2,3,2],[2,5,3,5],[2,15,2,17]]}
[]
[null,"Proposed Unit Tier Qualification",null,null,null,null,null,null,null,null,null,null,2,3,4]
[null,"Input sheet row","Device Type","System Type","System Type","Unit Tons","Nominal BTUh"," BTUh Cooling"," BTUh Heating","Size Category","Rating System","Concat","AC/HP Full Load Lookup Reference","AC/HP Full Load Lookup Reference","AC/HP Full Load Lookup Reference","Proposed Unit Efficiencies",null,null,"Baseline Efficiencies",null,null,"Tier 1 required efficiency",null,null,"Tier 2 required efficiency",null,null,"Tier Achieved","Unit Qualifies","Incentive/ton or unit for PTAC/HP","Quantity","Total Incentive","Building Type","EFLHc","EFLHh","kWh Savings/ton or unit",null,null,"kW Savings/ton or unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER","Part Load","COP","Full Load","Part Load","COP","Full Load","Part Load","COP","Full Load","Part Load","COP",null,null,null,null,null,null,null,null,"Cooling Energy Savings ","Heating Energy Savings ","Combined Energy Savings","Summer Peak Savings ","Total kWh Savings","Summer Peak Coincidence kW Savings"]
[null,1,{"$f":"'HVAC Unitary'!D23","v":0},{"$f":"IFERROR(VLOOKUP(C5,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C5,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G23","v":0},{"$f":"F5*12000","v":0},{"$f":"'HVAC Unitary'!H23","v":0},{"$f":"'HVAC Unitary'!I23","v":0},{"$f":"VLOOKUP(G5,INDIRECT(D5&\"Baseline\"),1)","v":{"$error":"#REF!"}},{"$f":"IF('HVAC Unitary'!J23=\"\",\"\",IF('HVAC Unitary'!J23=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$f":"_xlfn.CONCAT(D5,J5,E5,K5)","v":{"$error":"#REF!"}},{"$f":"IFERROR(IF(OR($D5=\"AC\",$D5=\"HP\"),VLOOKUP($L5,$F$23:$I$70,M$2,FALSE),0),0)","v":0},0,0,{"$f":"'HVAC Unitary'!K23","v":0},{"$f":"'HVAC Unitary'!L23","v":0},{"$f":"IF(G5>65000,'HVAC Unitary'!M23,'HVAC Unitary'!M23/IF(D5=\"PTHP\",1,3.413))","v":0},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",VLOOKUP($G5,PTACBaseline,3)+VLOOKUP($G5,PTACBaseline,4)*$G5/1000,IF($D5=\"PTHP\",VLOOKUP($G5,PTHPBaseline,3)+VLOOKUP($G5,PTHPBaseline,4)*$G5/1000,IF($D5=\"AC\",VLOOKUP($G5,ACBaseline,M5),IF($D5=\"HP\",VLOOKUP($G5,HPBaseline,M5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",0,IF($D5=\"PTHP\",0,IF($D5=\"AC\",VLOOKUP($G5,ACBaseline,N5),IF($D5=\"HP\",VLOOKUP($G5,HPBaseline,N5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",0,IF($D5=\"PTHP\",VLOOKUP($G5,PTHPBaseline,6)+VLOOKUP($G5,PTHPBaseline,7)*$G5/1000,IF($D5=\"AC\",0,IF($D5=\"HP\",VLOOKUP($G5,HPBaseline,O5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",VLOOKUP($G5,PTACMinEffT1,3),IF($D5=\"PTHP\",VLOOKUP($G5,PTHPMinEffT1,3),IF($D5=\"AC\",VLOOKUP($G5,ACMinEffT1,M5),IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT1,M5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",0,IF($D5=\"PTHP\",0,IF($D5=\"AC\",VLOOKUP($G5,ACMinEffT1,N5),IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT1,N5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",0,IF($D5=\"PTHP\",VLOOKUP($G5,PTHPMinEffT1,5),IF($D5=\"AC\",0,IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT1,O5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",999,IF($D5=\"PTHP\",999,IF($D5=\"AC\",VLOOKUP($G5,ACMinEffT2,M5),IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT2,M5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",0,IF($D5=\"PTHP\",0,IF($D5=\"AC\",VLOOKUP($G5,ACMinEffT2,N5),IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT2,N5),\"\")))))","v":""},{"$f":"IF($D5=\"\",\"\",IF($D5=\"PTAC\",999,IF($D5=\"PTHP\",999,IF($D5=\"AC\",0,IF($D5=\"HP\",VLOOKUP($G5,HPMinEffT2,O5),\"\")))))","v":""},{"$f":"IFERROR(IF(OR(C5=0,F5=0),\"-\",IF(AND(P5>=Y5,Q5>=Z5,R5>=AA5),\"Tier 2\",IF(AND(P5>=V5,Q5>=W5,R5>=X5),\"Tier 1\",\"-\"))),\"-\")","v":"-"},{"$f":"IFERROR(IF(AB5=\"-\",\"No\",\"Yes\"),\"No\")","v":"No"},{"$f":"IF(D5=\"PTAC\",VLOOKUP(G5,PTACMinEffT1,5),IF(D5=\"PTHP\",VLOOKUP(G5,PTHPMinEffT1,7),IF(AB5=\"Tier 1\",IF(D5=\"AC\",VLOOKUP(G5,ACMinEffT1,15),IF(D5=\"HP\",VLOOKUP(G5,HPMinEffT1,21),4)),IF(AB5=\"Tier 2\",IF(D5=\"AC\",VLOOKUP(G5,ACMinEffT2,15),IF(D5=\"HP\",VLOOKUP(G5,HPMinEffT2,21),4)),0))))","v":0},{"$f":"'HVAC Unitary'!N23","v":0},{"$f":"AD5*AE5","v":0},{"$f":"'HVAC Unitary'!C23","v":0},{"$f":"VLOOKUP(AG5,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG5,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(AC5=\"No\",0,H5/1000*(1/IF(OR(D5=\"AC\",D5=\"HP\"),T5,S5)-(1/IF(OR(D5=\"AC\",D5=\"HP\"),Q5,P5)))*AH5),0)","v":0},{"$f":"IFERROR(IF(AC5=\"No\",0,I5/3412*(1/IF(OR(D5=\"AC\",D5=\"PTAC\"),1,U5)-(1/IF(OR(D5=\"AC\",D5=\"PTAC\"),1,R5)))*AI5),0)","v":0},{"$f":"AK5+AJ5","v":0},{"$f":"IFERROR(IF(AC5=\"No\",0,G5/1000*((1/S5)-(1/P5))*0.8),0)","v":0},{"$f":"AL5*$AE5","v":0},{"$f":"AM5*$AE5","v":0}]
[null,2,{"$f":"'HVAC Unitary'!D24","v":0},{"$f":"IFERROR(VLOOKUP(C6,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C6,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G24","v":0},{"$f":"F6*12000","v":0},{"$f":"'HVAC Unitary'!H24","v":0},{"$f":"'HVAC Unitary'!I24","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J24=\"\",\"\",IF('HVAC Unitary'!J24=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K24","v":0},{"$f":"'HVAC Unitary'!L24","v":0},{"$f":"IF(G6>65000,'HVAC Unitary'!M24,'HVAC Unitary'!M24/IF(D6=\"PTHP\",1,3.413))","v":0},"","","","","","","","","","-",{"$f":"IFERROR(IF(AB6=\"-\",\"No\",\"Yes\"),\"No\")","v":"No"},0,{"$f":"'HVAC Unitary'!N24","v":0},{"$f":"AD6*AE6","v":0},{"$f":"'HVAC Unitary'!C24","v":0},{"$f":"VLOOKUP(AG6,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG6,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},{"$f":"IFERROR(IF(AC6=\"No\",0,H6/1000*(1/IF(OR(D6=\"AC\",D6=\"HP\"),T6,S6)-(1/IF(OR(D6=\"AC\",D6=\"HP\"),Q6,P6)))*AH6),0)","v":0},{"$f":"IFERROR(IF(AB6=\"-\",0,I6/3412*(1/IF(OR(D6=\"AC\",D6=\"PTAC\"),1,U6)-(1/IF(OR(D6=\"AC\",D6=\"PTAC\"),1,R6)))*AI6),0)","v":0},0,{"$f":"IFERROR(IF(AC6=\"No\",0,G6/1000*((1/S6)-(1/P6))*0.8),0)","v":0},{"$f":"AL6*$AE6","v":0},{"$f":"AM6*$AE6","v":0}]
[null,3,{"$f":"'HVAC Unitary'!D25","v":0},{"$f":"IFERROR(VLOOKUP(C7,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C7,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G25","v":0},0,{"$f":"'HVAC Unitary'!H25","v":0},{"$f":"'HVAC Unitary'!I25","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J25=\"\",\"\",IF('HVAC Unitary'!J25=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K25","v":0},{"$f":"'HVAC Unitary'!L25","v":0},{"$f":"IF(G7>65000,'HVAC Unitary'!M25,'HVAC Unitary'!M25/IF(D7=\"PTHP\",1,3.413))","v":0},"","","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N25","v":0},0,{"$f":"'HVAC Unitary'!C25","v":0},{"$f":"VLOOKUP(AG7,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG7,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,4,{"$f":"'HVAC Unitary'!D26","v":0},{"$f":"IFERROR(VLOOKUP(C8,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C8,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G26","v":0},0,{"$f":"'HVAC Unitary'!H26","v":0},{"$f":"'HVAC Unitary'!I26","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J26=\"\",\"\",IF('HVAC Unitary'!J26=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K26","v":0},{"$f":"'HVAC Unitary'!L26","v":0},{"$f":"IF(G8>65000,'HVAC Unitary'!M26,'HVAC Unitary'!M26/IF(D8=\"PTHP\",1,3.413))","v":0},"","","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N26","v":0},0,{"$f":"'HVAC Unitary'!C26","v":0},{"$f":"VLOOKUP(AG8,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG8,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,5,{"$f":"'HVAC Unitary'!D27","v":0},{"$f":"IFERROR(VLOOKUP(C9,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C9,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G27","v":0},0,{"$f":"'HVAC Unitary'!H27","v":0},{"$f":"'HVAC Unitary'!I27","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J27=\"\",\"\",IF('HVAC Unitary'!J27=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K27","v":0},{"$f":"'HVAC Unitary'!L27","v":0},{"$f":"IF(G9>65000,'HVAC Unitary'!M27,'HVAC Unitary'!M27/IF(D9=\"PTHP\",1,3.413))","v":0},"","","","","","","","","",{"$f":"IFERROR(IF(OR(C9=0,F9=0),\"-\",IF(AND(P9>=Y9,Q9>=Z9,R9>=AA9),\"Tier 2\",IF(AND(P9>=V9,Q9>=W9,R9>=X9),\"Tier 1\",\"-\"))),\"-\")","v":"-"},"No",0,{"$f":"'HVAC Unitary'!N27","v":0},0,{"$f":"'HVAC Unitary'!C27","v":0},{"$f":"VLOOKUP(AG9,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG9,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,6,{"$f":"'HVAC Unitary'!D28","v":0},{"$f":"IFERROR(VLOOKUP(C10,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C10,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G28","v":0},0,{"$f":"'HVAC Unitary'!H28","v":0},{"$f":"'HVAC Unitary'!I28","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J28=\"\",\"\",IF('HVAC Unitary'!J28=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K28","v":0},{"$f":"'HVAC Unitary'!L28","v":0},{"$f":"IF(G10>65000,'HVAC Unitary'!M28,'HVAC Unitary'!M28/IF(D10=\"PTHP\",1,3.413))","v":0},"","","","","","","","","",{"$f":"IFERROR(IF(OR(C10=0,F10=0),\"-\",IF(AND(P10>=Y10,Q10>=Z10,R10>=AA10),\"Tier 2\",IF(AND(P10>=V10,Q10>=W10,R10>=X10),\"Tier 1\",\"-\"))),\"-\")","v":"-"},"No",0,{"$f":"'HVAC Unitary'!N28","v":0},0,{"$f":"'HVAC Unitary'!C28","v":0},{"$f":"VLOOKUP(AG10,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG10,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,7,{"$f":"'HVAC Unitary'!D29","v":0},{"$f":"IFERROR(VLOOKUP(C11,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C11,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G29","v":0},0,{"$f":"'HVAC Unitary'!H29","v":0},{"$f":"'HVAC Unitary'!I29","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J29=\"\",\"\",IF('HVAC Unitary'!J29=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K29","v":0},{"$f":"'HVAC Unitary'!L29","v":0},{"$f":"IF(G11>65000,'HVAC Unitary'!M29,'HVAC Unitary'!M29/IF(D11=\"PTHP\",1,3.413))","v":0},"","","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N29","v":0},0,{"$f":"'HVAC Unitary'!C29","v":0},{"$f":"VLOOKUP(AG11,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG11,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,8,{"$f":"'HVAC Unitary'!D30","v":0},{"$f":"IFERROR(VLOOKUP(C12,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C12,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G30","v":0},0,{"$f":"'HVAC Unitary'!H30","v":0},{"$f":"'HVAC Unitary'!I30","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J30=\"\",\"\",IF('HVAC Unitary'!J30=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K30","v":0},{"$f":"'HVAC Unitary'!L30","v":0},{"$f":"IF(G12>65000,'HVAC Unitary'!M30,'HVAC Unitary'!M30/IF(D12=\"PTHP\",1,3.413))","v":0},"","","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N30","v":0},0,{"$f":"'HVAC Unitary'!C30","v":0},{"$f":"VLOOKUP(AG12,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG12,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,9,{"$f":"'HVAC Unitary'!D31","v":0},{"$f":"IFERROR(VLOOKUP(C13,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C13,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G31","v":0},0,{"$f":"'HVAC Unitary'!H31","v":0},{"$f":"'HVAC Unitary'!I31","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J31=\"\",\"\",IF('HVAC Unitary'!J31=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K31","v":0},{"$f":"'HVAC Unitary'!L31","v":0},{"$f":"IF(G13>65000,'HVAC Unitary'!M31,'HVAC Unitary'!M31/IF(D13=\"PTHP\",1,3.413))","v":0},{"$f":"IF(D13=\"\",\"\",IF(D13=\"PTAC\",VLOOKUP(G13,PTACBaseline,3)+VLOOKUP(G13,PTACBaseline,4)*G13/1000,IF(D13=\"PTHP\",VLOOKUP(G13,PTHPBaseline,3)+VLOOKUP(G13,PTHPBaseline,4)*G13/1000,0)))","v":""},"","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N31","v":0},0,{"$f":"'HVAC Unitary'!C31","v":0},{"$f":"VLOOKUP(AG13,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG13,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[null,10,{"$f":"'HVAC Unitary'!D32","v":0},{"$f":"IFERROR(VLOOKUP(C14,Validation!$C$3:$E$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C14,Validation!$C$3:$F$9,4,FALSE),\"\")","v":""},{"$f":"'HVAC Unitary'!G32","v":0},0,{"$f":"'HVAC Unitary'!H32","v":0},{"$f":"'HVAC Unitary'!I32","v":0},{"$error":"#REF!"},{"$f":"IF('HVAC Unitary'!J32=\"\",\"\",IF('HVAC Unitary'!J32=\"EER / SEER / HSPF\",\"Old\",\"New\"))","v":""},{"$error":"#REF!"},0,0,0,{"$f":"'HVAC Unitary'!K32","v":0},{"$f":"'HVAC Unitary'!L32","v":0},{"$f":"IF(G14>65000,'HVAC Unitary'!M32,'HVAC Unitary'!M32/IF(D14=\"PTHP\",1,3.413))","v":0},{"$f":"IF(D14=\"\",\"\",IF(D14=\"PTAC\",VLOOKUP(G14,PTACBaseline,3)+VLOOKUP(G14,PTACBaseline,4)*G14/1000,IF(D14=\"PTHP\",VLOOKUP(G14,PTHPBaseline,3)+VLOOKUP(G14,PTHPBaseline,4)*G14/1000,0)))","v":""},"","","","","","","","","-","No",0,{"$f":"'HVAC Unitary'!N32","v":0},0,{"$f":"'HVAC Unitary'!C32","v":0},{"$f":"VLOOKUP(AG14,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",4,5))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG14,Validation!$C$13:$G$24,IF(VLOOKUP('Project Information'!$L$6,Validation!$B$116:$D$514,3,FALSE)=\"Charleston\",2,3))","v":{"$error":"#N/A"}},0,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,"Baseline Lookup Column Refernces for AC/HP "]
[null,null,null,null,null,null,"Lookup Column Value"]
[null,"Btu/h","System Type","S/P","Rating","Concat","Full Load","Part Load","Heating"]
[null,0,"AC","S","Old",{"$f":"_xlfn.CONCAT(C23,B23,D23,E23)","v":"AC0SOld"},9,12]
[null,45000,"AC","S","Old",{"$f":"_xlfn.CONCAT(C24,B24,D24,E24)","v":"AC45000SOld"},9,12]
[null,65000,"AC","S","Old","AC65000SOld",4,7]
[null,135000,"AC","S","Old","AC135000SOld",4,7]
[null,240000,"AC","S","Old","AC240000SOld",4,7]
[null,760000,"AC","S","Old","AC760000SOld",4,7]
[null,0,"AC","P","Old","AC0POld",10,13]
[null,45000,"AC","P","Old","AC45000POld",10,13]
[null,65000,"AC","P","Old","AC65000POld",4,7]
[null,135000,"AC","P","Old","AC135000POld",4,7]
[null,240000,"AC","P","Old","AC240000POld",4,7]
[null,760000,"AC","P","Old","AC760000POld",4,7]
[null,0,"AC","S","New",{"$f":"_xlfn.CONCAT(C35,B35,D35,E35)","v":"AC0SNew"},3,6]
[null,45000,"AC","S","New",{"$f":"_xlfn.CONCAT(C36,B36,D36,E36)","v":"AC45000SNew"},3,6]
[null,65000,"AC","S","New","AC65000SNew",4,7]
[null,135000,"AC","S","New","AC135000SNew",4,7]
[null,240000,"AC","S","New","AC240000SNew",4,7]
[null,760000,"AC","S","New","AC760000SNew",4,7]
[null,0,"AC","P","New","AC0PNew",4,7]
[null,45000,"AC","P","New","AC45000PNew",4,7]
[null,65000,"AC","P","New","AC65000PNew",4,7]
[null,135000,"AC","P","New","AC135000PNew",4,7]
[null,240000,"AC","P","New","AC240000PNew",4,7]
[null,760000,"AC","P","New","AC760000PNew",4,7]
[null,0,"HP","S","Old",{"$f":"_xlfn.CONCAT(C47,B47,D47,E47)","v":"HP0SOld"},12,15,18]
[null,45000,"HP","S","Old",{"$f":"_xlfn.CONCAT(C48,B48,D48,E48)","v":"HP45000SOld"},12,15,18]
[null,65000,"HP","S","Old","HP65000SOld",4,7,10]
[null,135000,"HP","S","Old","HP135000SOld",4,7,10]
[null,240000,"HP","S","Old","HP240000SOld",4,7,10]
[null,760000,"HP","S","Old","HP760000SOld",4,7,10]
[null,0,"HP","P","Old","HP0POld",13,16,19]
[null,45000,"HP","P","Old","HP45000POld",13,16,19]
[null,65000,"HP","P","Old","HP65000POld",4,7,10]
[null,135000,"HP","P","Old","HP135000POld",4,7,10]
[null,240000,"HP","P","Old","HP240000POld",4,7,10]
[null,760000,"HP","P","Old","HP760000POld",4,7,10]
[null,0,"HP","S","New",{"$f":"_xlfn.CONCAT(C59,B59,D59,E59)","v":"HP0SNew"},3,6,9]
[null,45000,"HP","S","New",{"$f":"_xlfn.CONCAT(C60,B60,D60,E60)","v":"HP45000SNew"},3,6,9]
[null,65000,"HP","S","New","HP65000SNew",4,7,10]
[null,135000,"HP","S","New","HP135000SNew",4,7,10]
[null,240000,"HP","S","New","HP240000SNew",4,7,10]
[null,760000,"HP","S","New","HP760000SNew",4,7,10]
[null,0,"HP","P","New","HP0PNew",4,7,10]
[null,45000,"HP","P","New","HP45000PNew",4,7,10]
[null,65000,"HP","P","New","HP65000PNew",4,7,10]
[null,135000,"HP","P","New","HP135000PNew",4,7,10]
[null,240000,"HP","P","New","HP240000PNew",4,7,10]
[null,760000,"HP","P","New","HP760000PNew",4,7,10]

{"sheet":"HVACLookups","index":8,"n_rows":63,"n_cols":69,"rows_kept":63,"cut":false,"hidden":true,"merged":[[58,19,58,20],[58,1,58,2],[58,13,58,14],[48,1,48,2],[26,38,26,40],[26,1,26,2],[26,3,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,14],[35,26,35,28],[35,29,35,31],[35,32,35,34],[35,35,35,37],[58,26,58,27],[58,28,58,29],[26,41,26,43],[26,15,26,17],[26,18,26,20],[26,26,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,37],[4,3,4,5],[4,6,4,8],[4,9,4,11],[58,15,58,16],[58,17,58,18],[48,13,48,14],[48,17,48,18],[4,12,4,14],[14,26,14,28],[14,29,14,31],[14,32,14,34],[14,35,14,37],[4,26,4,28],[4,29,4,31],[4,32,4,34],[4,35,4,37],[26,54,26,56],[26,57,26,59],[26,60,26,62],[4,51,4,53],[4,54,4,56],[4,57,4,59],[14,51,14,53],[14,54,14,56],[14,57,14,59],[14,60,14,62],[26,63,26,65],[26,66,26,68],[4,38,4,39],[58,3,58,5],[58,6,58,8],[48,3,48,5],[48,24,48,25],[58,24,58,25],[35,38,35,40],[35,41,35,43],[35,44,35,45],[14,38,14,39],[26,44,26,45],[4,60,4,62],[26,49,26,50],[26,51,26,53],[35,63,35,65],[35,66,35,68],[35,49,35,50],[35,51,35,53],[35,54,35,56],[35,57,35,59],[35,60,35,62]]}
["P",30000,"Electric",{"$f":"VLOOKUP(B1,B7:I12,IF(AND(B1<65000,A1=\"U\"),4,3))","v":11.7}]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,"Air Conditioning - Unitary and Split System baseline efficiency*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Efficiencies For Incentives - AC Units (Tier 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Conditioning - Baseline Checks Tier 1"]
[null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,null,null,null,null,null,null,null,null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"Incentive",null,null,null,null,null,null,null,null,null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"EER - Full Load",null,null,"SEER - Part Load"]
[null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit",null,null,null,null,null,null,null,null,null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","Amount","Unit",null,null,null,null,null,null,null,null,null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit"]
[null,0,0,11.7,10.6,"EER2",14.3,13.4,"SEER2",{"$f":"D7/0.95","v":12.315789473684211},{"$f":"E7/0.95","v":11.157894736842106},"EER",{"$f":"G7/0.95","v":15.05263157894737},{"$f":"H7/0.95","v":14.105263157894738},"SEER",null,null,null,null,null,null,null,null,null,0,{"$f":"Y7/12000","v":0},null,null,"EER2",15.2,14.3,"SEER2",null,null,"EER",{"$f":"AD7/0.95","v":16},15,"SEER",75,"Ton",null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(OR(AA7=\"\",$D$7=\"\"),\"\",(AA7/$D$7))","v":""},{"$f":"IF(OR(AB7=\"\",$E$7=\"\"),\"\",(AB7/$E$7))","v":""},"EER2",{"$f":"IF(OR(AD7=\"\",$G$7=\"\"),\"\",(AD7/$G$7))","v":1.0629370629370629},{"$f":"IF(OR(AE7=\"\",$H$7=\"\"),\"\",(AE7/$H$7))","v":1.0671641791044777},"SEER2",{"$f":"IF(OR(AG7=\"\",$J$7=\"\"),\"\",(AG7/$J$7))","v":""},{"$f":"IF(OR(AH7=\"\",$K$7=\"\"),\"\",(AH7/$K$7))","v":""},"EER",{"$f":"IF(OR(AJ7=\"\",$M$7=\"\"),\"\",(AJ7/$M$7))","v":1.0629370629370629},{"$f":"IF(OR(AK7=\"\",$N$7=\"\"),\"\",(AK7/$N$7))","v":1.0634328358208955},"SEER"]
[null,45000,3.75,11.2,10.6,"EER2",13.8,13.4,"SEER2",{"$f":"D8/0.95","v":11.789473684210526},{"$f":"E8/0.95","v":11.157894736842106},"EER",{"$f":"G8/0.95","v":14.526315789473685},{"$f":"H8/0.95","v":14.105263157894738},"SEER",null,null,null,null,null,null,null,null,null,45000,3.75,null,null,"EER2",15.2,14.3,"SEER2",null,null,"EER",{"$f":"AD8/0.95","v":16},15,"SEER",75,"Ton",null,null,null,null,null,null,null,null,null,45000,3.75,{"$f":"IF(OR(AA8=\"\",$D$8=\"\"),\"\",(AA8/$D$8))","v":""},{"$f":"IF(OR(AB8=\"\",$E$8=\"\"),\"\",(AB8/$E$8))","v":""},"EER2",{"$f":"IF(OR(AD8=\"\",$G$8=\"\"),\"\",(AD8/$G$8))","v":1.1014492753623186},{"$f":"IF(OR(AE8=\"\",$H$8=\"\"),\"\",(AE8/$H$8))","v":1.0671641791044777},"SEER2",{"$f":"IF(OR(AG8=\"\",$J$8=\"\"),\"\",(AG8/$J$8))","v":""},{"$f":"IF(OR(AH8=\"\",$K$8=\"\"),\"\",(AH8/$K$8))","v":""},"EER",{"$f":"IF(OR(AJ8=\"\",$M$8=\"\"),\"\",(AJ8/$M$8))","v":1.1014492753623188},{"$f":"IF(OR(AK8=\"\",$N$8=\"\"),\"\",(AK8/$N$8))","v":1.0634328358208955},"SEER"]
[null,65000,{"$f":"B9/12000","v":5.416666666666667},null,11,"EER",null,14.6,"IEER",null,null,"EER",null,null,"IEER",null,null,null,null,null,null,null,null,null,65000,5.416666666666667,null,null,"EER",null,15.3,"IEER",null,null,null,null,null,null,60,"Ton",null,null,null,null,null,null,null,null,null,65000,{"$f":"AX9/12000","v":5.416666666666667},{"$f":"IF(OR(AA9=\"\",$D$9=\"\"),\"\",(AA9/$D$9))","v":""},{"$f":"IF(OR(AB9=\"\",$E$9=\"\"),\"\",(AB9/$E$9))","v":""},"EER",{"$f":"IF(OR(AD9=\"\",$G$9=\"\"),\"\",(AD9/$G$9))","v":""},{"$f":"IF(OR(AE9=\"\",$H$9=\"\"),\"\",(AE9/$H$9))","v":1.047945205479452},"IEER",{"$f":"IF(OR(AG9=\"\",$J$9=\"\"),\"\",(AG9/$J$9))","v":""},{"$f":"IF(OR(AH9=\"\",$K$9=\"\"),\"\",(AH9/$K$9))","v":""},"EER",{"$f":"IF(OR(AJ9=\"\",$M$9=\"\"),\"\",(AJ9/$M$9))","v":""},{"$f":"IF(OR(AK9=\"\",$N$9=\"\"),\"\",(AK9/$N$9))","v":""},"IEER"]
[null,135000,11.25,null,10.8,"EER",null,14,"IEER",null,null,"EER",null,null,"IEER",null,null,null,null,null,null,null,null,null,135000,11.25,null,null,"EER",null,14.7,"IEER",null,null,null,null,null,null,50,"Ton",null,null,null,null,null,null,null,null,null,135000,11.25,{"$f":"IF(OR(AA10=\"\",$D$10=\"\"),\"\",(AA10/$D$10))","v":""},{"$f":"IF(OR(AB10=\"\",$E$10=\"\"),\"\",(AB10/$E$10))","v":""},"EER",{"$f":"IF(OR(AD10=\"\",$G$10=\"\"),\"\",(AD10/$G$10))","v":""},{"$f":"IF(OR(AE10=\"\",$H$10=\"\"),\"\",(AE10/$H$10))","v":1.05},"IEER",{"$f":"IF(OR(AG10=\"\",$J$10=\"\"),\"\",(AG10/$J$10))","v":""},{"$f":"IF(OR(AH10=\"\",$K$10=\"\"),\"\",(AH10/$K$10))","v":""},"EER",{"$f":"IF(OR(AJ10=\"\",$M$10=\"\"),\"\",(AJ10/$M$10))","v":""},{"$f":"IF(OR(AK10=\"\",$N$10=\"\"),\"\",(AK10/$N$10))","v":""},"IEER"]
[null,240000,20,null,9.8000000000000007,"EER",null,13,"IEER",null,null,"EER",null,null,"IEER",null,null,null,null,null,null,null,null,null,240000,20,null,null,"EER",null,13.6,"IEER",null,null,null,null,null,null,40,"Ton",null,null,null,null,null,null,null,null,null,240000,20,{"$f":"IF(OR(AA11=\"\",$D$11=\"\"),\"\",(AA11/$D$11))","v":""},{"$f":"IF(OR(AB11=\"\",$E$11=\"\"),\"\",(AB11/$E$11))","v":""},"EER",{"$f":"IF(OR(AD11=\"\",$G$11=\"\"),\"\",(AD11/$G$11))","v":""},{"$f":"IF(OR(AE11=\"\",$H$11=\"\"),\"\",(AE11/$H$11))","v":1.0461538461538462},"IEER",{"$f":"IF(OR(AG11=\"\",$J$11=\"\"),\"\",(AG11/$J$11))","v":""},{"$f":"IF(OR(AH11=\"\",$K$11=\"\"),\"\",(AH11/$K$11))","v":""},"EER",{"$f":"IF(OR(AJ11=\"\",$M$11=\"\"),\"\",(AJ11/$M$11))","v":""},{"$f":"IF(OR(AK11=\"\",$N$11=\"\"),\"\",(AK11/$N$11))","v":""},"IEER"]
[null,760000,63.333333333333336,null,9.5,"EER",null,11,"IEER",null,null,"EER",null,null,"IEER",null,null,null,null,null,null,null,null,null,760000,63.333333333333336,null,null,"EER",null,11.6,"IEER",null,null,null,null,null,null,15,"Ton",null,null,null,null,null,null,null,null,null,760000,63.333333333333336,{"$f":"IF(OR(AA12=\"\",$D$12=\"\"),\"\",(AA12/$D$12))","v":""},{"$f":"IF(OR(AB12=\"\",$E$12=\"\"),\"\",(AB12/$E$12))","v":""},"EER",{"$f":"IF(OR(AD12=\"\",$G$12=\"\"),\"\",(AD12/$G$12))","v":""},{"$f":"IF(OR(AE12=\"\",$H$12=\"\"),\"\",(AE12/$H$12))","v":1.0545454545454545},"IEER",{"$f":"IF(OR(AG12=\"\",$J$12=\"\"),\"\",(AG12/$J$12))","v":""},{"$f":"IF(OR(AH12=\"\",$K$12=\"\"),\"\",(AH12/$K$12))","v":""},"EER",{"$f":"IF(OR(AJ12=\"\",$M$12=\"\"),\"\",(AJ12/$M$12))","v":""},{"$f":"IF(OR(AK12=\"\",$N$12=\"\"),\"\",(AK12/$N$12))","v":""},"IEER"]
[]
[null,null,"*Black text from CEAM. Red text from AR TRM v9.2. Blue text is calculated from CEAM conversion factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Efficiencies For Incentives - AC Units (Tier 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Conditioning - Baseline Checks Tier 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"Incentive",null,null,null,null,null,null,null,null,null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"EER - Full Load",null,null,"SEER - Part Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","Amount","Unit",null,null,null,null,null,null,null,null,null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Y17/12000","v":0},null,null,"EER2",16.149999999999999,15.2,"SEER2",null,null,"EER",{"$f":"AD17/0.95","v":17},{"$f":"AE17/0.95","v":16},"SEER",100,"Ton",null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(OR(AA17=\"\",$D$7=\"\"),\"\",(AA17/$D$7))","v":""},{"$f":"IF(OR(AB17=\"\",$E$7=\"\"),\"\",(AB17/$E$7))","v":""},"EER2",{"$f":"IF(OR(AD17=\"\",$G$7=\"\"),\"\",(AD17/$G$7))","v":1.1293706293706292},{"$f":"IF(OR(AE17=\"\",$H$7=\"\"),\"\",(AE17/$H$7))","v":1.1343283582089552},"SEER2",{"$f":"IF(OR(AG17=\"\",$J$7=\"\"),\"\",(AG17/$J$7))","v":""},{"$f":"IF(OR(AH17=\"\",$K$7=\"\"),\"\",(AH17/$K$7))","v":""},"EER",{"$f":"IF(OR(AJ17=\"\",$M$7=\"\"),\"\",(AJ17/$M$7))","v":1.1293706293706292},{"$f":"IF(OR(AK17=\"\",$N$7=\"\"),\"\",(AK17/$N$7))","v":1.1343283582089552},"SEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45000,{"$f":"Y18/12000","v":3.75},null,null,"EER2",16.149999999999999,15.2,"SEER2",null,null,"EER",{"$f":"AD18/0.95","v":17},{"$f":"AE18/0.95","v":16},"SEER",100,"Ton",null,null,null,null,null,null,null,null,null,45000,3.75,{"$f":"IF(OR(AA18=\"\",$D$8=\"\"),\"\",(AA18/$D$8))","v":""},{"$f":"IF(OR(AB18=\"\",$E$8=\"\"),\"\",(AB18/$E$8))","v":""},"EER2",{"$f":"IF(OR(AD18=\"\",$G$8=\"\"),\"\",(AD18/$G$8))","v":1.1702898550724636},{"$f":"IF(OR(AE18=\"\",$H$8=\"\"),\"\",(AE18/$H$8))","v":1.1343283582089552},"SEER2",{"$f":"IF(OR(AG18=\"\",$J$8=\"\"),\"\",(AG18/$J$8))","v":""},{"$f":"IF(OR(AH18=\"\",$K$8=\"\"),\"\",(AH18/$K$8))","v":""},"EER",{"$f":"IF(OR(AJ18=\"\",$M$8=\"\"),\"\",(AJ18/$M$8))","v":1.1702898550724636},{"$f":"IF(OR(AK18=\"\",$N$8=\"\"),\"\",(AK18/$N$8))","v":1.1343283582089552},"SEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65000,5.416666666666667,null,null,"EER",null,15.8,"IEER",null,null,null,null,null,null,75,"Ton",null,null,null,null,null,null,null,null,null,65000,{"$f":"AX19/12000","v":5.416666666666667},{"$f":"IF(OR(AA19=\"\",$D$9=\"\"),\"\",(AA19/$D$9))","v":""},{"$f":"IF(OR(AB19=\"\",$E$9=\"\"),\"\",(AB19/$E$9))","v":""},"EER",{"$f":"IF(OR(AD19=\"\",$G$9=\"\"),\"\",(AD19/$G$9))","v":""},{"$f":"IF(OR(AE19=\"\",$H$9=\"\"),\"\",(AE19/$H$9))","v":1.0821917808219179},"IEER",{"$f":"IF(OR(AG19=\"\",$J$9=\"\"),\"\",(AG19/$J$9))","v":""},{"$f":"IF(OR(AH19=\"\",$K$9=\"\"),\"\",(AH19/$K$9))","v":""},"EER",{"$f":"IF(OR(AJ19=\"\",$M$9=\"\"),\"\",(AJ19/$M$9))","v":""},{"$f":"IF(OR(AK19=\"\",$N$9=\"\"),\"\",(AK19/$N$9))","v":""},"IEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135000,11.25,null,null,"EER",null,15.1,"IEER",null,null,null,null,null,null,70,"Ton",null,null,null,null,null,null,null,null,null,135000,11.25,{"$f":"IF(OR(AA20=\"\",$D$10=\"\"),\"\",(AA20/$D$10))","v":""},{"$f":"IF(OR(AB20=\"\",$E$10=\"\"),\"\",(AB20/$E$10))","v":""},"EER",{"$f":"IF(OR(AD20=\"\",$G$10=\"\"),\"\",(AD20/$G$10))","v":""},{"$f":"IF(OR(AE20=\"\",$H$10=\"\"),\"\",(AE20/$H$10))","v":1.0785714285714285},"IEER",{"$f":"IF(OR(AG20=\"\",$J$10=\"\"),\"\",(AG20/$J$10))","v":""},{"$f":"IF(OR(AH20=\"\",$K$10=\"\"),\"\",(AH20/$K$10))","v":""},"EER",{"$f":"IF(OR(AJ20=\"\",$M$10=\"\"),\"\",(AJ20/$M$10))","v":""},{"$f":"IF(OR(AK20=\"\",$N$10=\"\"),\"\",(AK20/$N$10))","v":""},"IEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240000,20,null,null,"EER",null,14.1,"IEER",null,null,null,null,null,null,60,"Ton",null,null,null,null,null,null,null,null,null,240000,20,{"$f":"IF(OR(AA21=\"\",$D$11=\"\"),\"\",(AA21/$D$11))","v":""},{"$f":"IF(OR(AB21=\"\",$E$11=\"\"),\"\",(AB21/$E$11))","v":""},"EER",{"$f":"IF(OR(AD21=\"\",$G$11=\"\"),\"\",(AD21/$G$11))","v":""},{"$f":"IF(OR(AE21=\"\",$H$11=\"\"),\"\",(AE21/$H$11))","v":1.0846153846153845},"IEER",{"$f":"IF(OR(AG21=\"\",$J$11=\"\"),\"\",(AG21/$J$11))","v":""},{"$f":"IF(OR(AH21=\"\",$K$11=\"\"),\"\",(AH21/$K$11))","v":""},"EER",{"$f":"IF(OR(AJ21=\"\",$M$11=\"\"),\"\",(AJ21/$M$11))","v":""},{"$f":"IF(OR(AK21=\"\",$N$11=\"\"),\"\",(AK21/$N$11))","v":""},"IEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,760000,63.333333333333336,null,null,"EER",null,12,"IEER",null,null,null,null,null,null,20,"Ton",null,null,null,null,null,null,null,null,null,760000,63.333333333333336,{"$f":"IF(OR(AA22=\"\",$D$12=\"\"),\"\",(AA22/$D$12))","v":""},{"$f":"IF(OR(AB22=\"\",$E$12=\"\"),\"\",(AB22/$E$12))","v":""},"EER",{"$f":"IF(OR(AD22=\"\",$G$12=\"\"),\"\",(AD22/$G$12))","v":""},{"$f":"IF(OR(AE22=\"\",$H$12=\"\"),\"\",(AE22/$H$12))","v":1.0909090909090908},"IEER",{"$f":"IF(OR(AG22=\"\",$J$12=\"\"),\"\",(AG22/$J$12))","v":""},{"$f":"IF(OR(AH22=\"\",$K$12=\"\"),\"\",(AH22/$K$12))","v":""},"EER",{"$f":"IF(OR(AJ22=\"\",$M$12=\"\"),\"\",(AJ22/$M$12))","v":""},{"$f":"IF(OR(AK22=\"\",$N$12=\"\"),\"\",(AK22/$N$12))","v":""},"IEER"]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Heat Pumps - Unitary and Split System baseline efficiency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Efficiencies For Incentives - HP units - (Tier 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Pumps - Baseline Checks Tier 1"]
[null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"HSPF2/COP - Heating Eff",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"HSPF as COP - Heating Eff",null,null,"HSPF",null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"HSPF2/COP Heating Eff",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"HSPF as COP - Heating Eff",null,null,"Incentive",null,"HSPF",null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"HSPF2/COP Heating Eff",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"HSPF as COP - Heating Eff"]
[null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P",null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","Amount","Unit","S","P",null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit"]
[null,0,{"$f":"B29/12000","v":0},11.7,10.6,"EER2",14.3,13.4,"SEER2",{"$f":"7.5/3.413","v":2.1974802226779961},{"$f":"6.7/3.413","v":1.9630823322590099},"COP",{"$f":"D29/0.95","v":12.315789473684211},{"$f":"E29/0.95","v":11.157894736842106},"EER",{"$f":"G29/0.95","v":15.05263157894737},{"$f":"H29/0.95","v":14.105263157894738},"SEER",{"$f":"J29/0.85","v":2.5852708502094073},{"$f":"K29/0.84","v":2.3370027764988213},"COP",{"$f":"S29*3.413","v":8.8235294117647065},{"$f":"T29*3.413","v":7.9761904761904763},null,0,{"$f":"Y29/12000","v":0},null,null,"EER2",15.2,14.3,"SEER2",{"$f":"7.8/3.413","v":2.2853794315851159},{"$f":"7/3.413","v":2.0509815411661294},"COP",null,null,"EER",{"$f":"AD29/0.95","v":16},15,"SEER",{"$f":"9.1/3.413","v":2.6662760035159683},{"$f":"8.3/3.413","v":2.4318781130969827},"COP",100,"ton",{"$f":"AP29*3.413","v":9.1},{"$f":"AQ29*3.413","v":8.3000000000000007},null,0,{"$f":"AX29/12000","v":0},{"$f":"IF(OR(AA29=\"\",$D$29=\"\"),\"\",(AA29/$D$29))","v":""},{"$f":"IF(OR(AB29=\"\",$E$29=\"\"),\"\",(AB29/$E$29))","v":""},"EER2",{"$f":"IF(OR(AD29=\"\",$G$29=\"\"),\"\",(AD29/$G$29))","v":1.0629370629370629},{"$f":"IF(OR(AE29=\"\",$H$29=\"\"),\"\",(AE29/$H$29))","v":1.0671641791044777},"SEER2",{"$f":"IF(OR(AG29=\"\",$J$29=\"\"),\"\",(AG29/$J$29))","v":1.04},{"$f":"IF(OR(AH29=\"\",$K$29=\"\"),\"\",(AH29/$K$29))","v":1.044776119402985},"COP",{"$f":"IF(OR(AJ29=\"\",$M$29=\"\"),\"\",(AJ29/$M$29))","v":""},{"$f":"IF(OR(AK29=\"\",$N$29=\"\"),\"\",(AK29/$N$29))","v":""},"EER",{"$f":"IF(OR(AM29=\"\",$P$29=\"\"),\"\",(AM29/$P$29))","v":1.0629370629370629},{"$f":"IF(OR(AN29=\"\",$Q$29=\"\"),\"\",(AN29/$Q$29))","v":1.0634328358208955},"SEER",{"$f":"IF(OR(AP29=\"\",$S$29=\"\"),\"\",(AP29/$S$29))","v":1.0313333333333332},{"$f":"IF(OR(AQ29=\"\",$T$29=\"\"),\"\",(AQ29/$T$29))","v":1.0405970149253732},"COP"]
[null,45000,{"$f":"B30/12000","v":3.75},11.7,10.6,"EER2",14.3,13.4,"SEER2",{"$f":"7.5/3.413","v":2.1974802226779961},{"$f":"6.7/3.413","v":1.9630823322590099},"COP",{"$f":"D30/0.95","v":12.315789473684211},{"$f":"E30/0.95","v":11.157894736842106},"EER",{"$f":"G30/0.95","v":15.05263157894737},{"$f":"H30/0.95","v":14.105263157894738},"SEER",{"$f":"J30/0.85","v":2.5852708502094073},{"$f":"K30/0.84","v":2.3370027764988213},"COP",{"$f":"S30*3.413","v":8.8235294117647065},{"$f":"T30*3.413","v":7.9761904761904763},null,45000,{"$f":"Y30/12000","v":3.75},null,null,"EER2",15.2,14.3,"SEER2",{"$f":"7.8/3.413","v":2.2853794315851159},{"$f":"7/3.413","v":2.0509815411661294},"COP",null,null,"EER",{"$f":"AD30/0.95","v":16},15,"SEER",{"$f":"9.1/3.413","v":2.6662760035159683},{"$f":"8.3/3.413","v":2.4318781130969827},"COP",100,"ton",{"$f":"AP30*3.413","v":9.1},{"$f":"AQ30*3.413","v":8.3000000000000007},null,45000,{"$f":"AX30/12000","v":3.75},{"$f":"IF(OR(AA30=\"\",$D$30=\"\"),\"\",(AA30/$D$30))","v":""},{"$f":"IF(OR(AB30=\"\",$E$30=\"\"),\"\",(AB30/$E$30))","v":""},"EER2",{"$f":"IF(OR(AD30=\"\",$G$30=\"\"),\"\",(AD30/$G$30))","v":1.0629370629370629},{"$f":"IF(OR(AE30=\"\",$H$30=\"\"),\"\",(AE30/$H$30))","v":1.0671641791044777},"SEER2",{"$f":"IF(OR(AG30=\"\",$J$30=\"\"),\"\",(AG30/$J$30))","v":1.04},{"$f":"IF(OR(AH30=\"\",$K$30=\"\"),\"\",(AH30/$K$30))","v":1.044776119402985},"COP",{"$f":"IF(OR(AJ30=\"\",$M$30=\"\"),\"\",(AJ30/$M$30))","v":""},{"$f":"IF(OR(AK30=\"\",$N$30=\"\"),\"\",(AK30/$N$30))","v":""},"EER",{"$f":"IF(OR(AM30=\"\",$P$30=\"\"),\"\",(AM30/$P$30))","v":1.0629370629370629},{"$f":"IF(OR(AN30=\"\",$Q$30=\"\"),\"\",(AN30/$Q$30))","v":1.0634328358208955},"SEER",{"$f":"IF(OR(AP30=\"\",$S$30=\"\"),\"\",(AP30/$S$30))","v":1.0313333333333332},{"$f":"IF(OR(AQ30=\"\",$T$30=\"\"),\"\",(AQ30/$T$30))","v":1.0405970149253732},"COP"]
[null,65000,{"$f":"B31/12000","v":5.416666666666667},null,10.8,"EER",null,13.9,"IEER",null,3.4,"COP",null,null,null,null,null,null,null,null,null,null,null,null,65000,5.416666666666667,null,null,"EER",null,15.3,"IEER",null,0,"COP",null,null,"EER",null,null,null,null,null,null,75,"ton",null,null,null,65000,{"$f":"AX31/12000","v":5.416666666666667},{"$f":"IF(OR(AA31=\"\",$D$31=\"\"),\"\",(AA31/$D$31))","v":""},{"$f":"IF(OR(AB31=\"\",$E$31=\"\"),\"\",(AB31/$E$31))","v":""},"EER",{"$f":"IF(OR(AD31=\"\",$G$31=\"\"),\"\",(AD31/$G$31))","v":""},{"$f":"IF(OR(AE31=\"\",$H$31=\"\"),\"\",(AE31/$H$31))","v":1.1007194244604317},"IEER",{"$f":"IF(OR(AG31=\"\",$J$31=\"\"),\"\",(AG31/$J$31))","v":""},{"$f":"IF(OR(AH31=\"\",$K$31=\"\"),\"\",(AH31/$K$31))","v":0},"COP",{"$f":"IF(OR(AJ31=\"\",$M$31=\"\"),\"\",(AJ31/$M$31))","v":""},{"$f":"IF(OR(AK31=\"\",$N$31=\"\"),\"\",(AK31/$N$31))","v":""},null,{"$f":"IF(OR(AM31=\"\",$P$31=\"\"),\"\",(AM31/$P$31))","v":""},{"$f":"IF(OR(AN31=\"\",$Q$31=\"\"),\"\",(AN31/$Q$31))","v":""},null,{"$f":"IF(OR(AP31=\"\",$S$31=\"\"),\"\",(AP31/$S$31))","v":""},{"$f":"IF(OR(AQ31=\"\",$T$31=\"\"),\"\",(AQ31/$T$31))","v":""}]
[null,135000,11.25,null,10.4,"EER",null,13.3,"IEER",null,3.3,"COP",null,null,null,null,null,null,null,null,null,null,null,null,135000,11.25,null,null,"EER",null,14.7,"IEER",null,0,"COP",null,null,"EER",null,null,null,null,null,null,55,"ton",null,null,null,135000,11.25,{"$f":"IF(OR(AA32=\"\",$D$32=\"\"),\"\",(AA32/$D$32))","v":""},{"$f":"IF(OR(AB32=\"\",$E$32=\"\"),\"\",(AB32/$E$32))","v":""},"EER",{"$f":"IF(OR(AD32=\"\",$G$32=\"\"),\"\",(AD32/$G$32))","v":""},{"$f":"IF(OR(AE32=\"\",$H$32=\"\"),\"\",(AE32/$H$32))","v":1.1052631578947367},"IEER",{"$f":"IF(OR(AG32=\"\",$J$32=\"\"),\"\",(AG32/$J$32))","v":""},{"$f":"IF(OR(AH32=\"\",$K$32=\"\"),\"\",(AH32/$K$32))","v":0},"COP",{"$f":"IF(OR(AJ32=\"\",$M$32=\"\"),\"\",(AJ32/$M$32))","v":""},{"$f":"IF(OR(AK32=\"\",$N$32=\"\"),\"\",(AK32/$N$32))","v":""},null,{"$f":"IF(OR(AM32=\"\",$P$32=\"\"),\"\",(AM32/$P$32))","v":""},{"$f":"IF(OR(AN32=\"\",$Q$32=\"\"),\"\",(AN32/$Q$32))","v":""},null,{"$f":"IF(OR(AP32=\"\",$S$32=\"\"),\"\",(AP32/$S$32))","v":""},{"$f":"IF(OR(AQ32=\"\",$T$32=\"\"),\"\",(AQ32/$T$32))","v":""}]
[null,240000,20,null,9.3000000000000007,"EER",null,12.3,"IEER",null,3.2,"COP",null,null,null,null,null,null,null,null,null,null,null,null,240000,20,null,null,"EER",null,13.6,"IEER",null,0,"COP",null,null,"EER",null,null,null,null,null,null,50,"ton",null,null,null,240000,20,{"$f":"IF(OR(AA33=\"\",$D$33=\"\"),\"\",(AA33/$D$33))","v":""},{"$f":"IF(OR(AB33=\"\",$E$33=\"\"),\"\",(AB33/$E$33))","v":""},"EER",{"$f":"IF(OR(AD33=\"\",$G$33=\"\"),\"\",(AD33/$G$33))","v":""},{"$f":"IF(OR(AE33=\"\",$H$33=\"\"),\"\",(AE33/$H$33))","v":1.1056910569105689},"IEER",{"$f":"IF(OR(AG33=\"\",$J$33=\"\"),\"\",(AG33/$J$33))","v":""},{"$f":"IF(OR(AH33=\"\",$K$33=\"\"),\"\",(AH33/$K$33))","v":0},"COP",{"$f":"IF(OR(AJ33=\"\",$M$33=\"\"),\"\",(AJ33/$M$33))","v":""},{"$f":"IF(OR(AK33=\"\",$N$33=\"\"),\"\",(AK33/$N$33))","v":""},null,{"$f":"IF(OR(AM33=\"\",$P$33=\"\"),\"\",(AM33/$P$33))","v":""},{"$f":"IF(OR(AN33=\"\",$Q$33=\"\"),\"\",(AN33/$Q$33))","v":""},null,{"$f":"IF(OR(AP33=\"\",$S$33=\"\"),\"\",(AP33/$S$33))","v":""},{"$f":"IF(OR(AQ33=\"\",$T$33=\"\"),\"\",(AQ33/$T$33))","v":""}]
[]
[null,null,"*Black text from CEAM. Red text from AR TRM v9.2. Blue text is calculated from CEAM conversion factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Efficiencies For Incentives - HP units - (Tier 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Pumps - Baseline Checks Tier 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"HSPF2/COP Heating Eff",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"HSPF as COP - Heating Eff",null,null,"Incentive",null,"HSPF",null,null,null,null,"EER2/EER - Full Load",null,null,"SEER2/IEER - Part Load",null,null,"HSPF2/COP Heating Eff",null,null,"EER - Full Load",null,null,"SEER - Part Load",null,null,"HSPF as COP - Heating Eff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","Amount","Unit","S","P",null,"Btu/h","Tons","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit","S","P","Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Y38/12000","v":0},null,null,"EER2",16.149999999999999,15.2,"SEER2",{"$f":"8/3.413","v":2.3439789041898624},{"$f":"7.2/3.413","v":2.1095810137708764},"COP",null,null,"EER",{"$f":"AD38/0.95","v":17},{"$f":"AE38/0.95","v":16},"SEER",{"$f":"9.4/3.413","v":2.7541752124230885},{"$f":"8.5/3.413","v":2.4904775857017287},"COP",125,"ton",{"$f":"AP38*3.413","v":9.4},{"$f":"AQ38*3.413","v":8.5},null,0,{"$f":"AX38/12000","v":0},{"$f":"IF(OR(AA38=\"\",$D$29=\"\"),\"\",(AA38/$D$29))","v":""},{"$f":"IF(OR(AB38=\"\",$E$29=\"\"),\"\",(AB38/$E$29))","v":""},"EER2",{"$f":"IF(OR(AD38=\"\",$G$29=\"\"),\"\",(AD38/$G$29))","v":1.1293706293706292},{"$f":"IF(OR(AE38=\"\",$H$29=\"\"),\"\",(AE38/$H$29))","v":1.1343283582089552},"SEER2",{"$f":"IF(OR(AG38=\"\",$J$29=\"\"),\"\",(AG38/$J$29))","v":1.0666666666666667},{"$f":"IF(OR(AH38=\"\",$K$29=\"\"),\"\",(AH38/$K$29))","v":1.0746268656716418},"COP",{"$f":"IF(OR(AJ38=\"\",$M$29=\"\"),\"\",(AJ38/$M$29))","v":""},{"$f":"IF(OR(AK38=\"\",$N$29=\"\"),\"\",(AK38/$N$29))","v":""},"EER",{"$f":"IF(OR(AM38=\"\",$P$29=\"\"),\"\",(AM38/$P$29))","v":1.1293706293706292},{"$f":"IF(OR(AN38=\"\",$Q$29=\"\"),\"\",(AN38/$Q$29))","v":1.1343283582089552},"SEER",{"$f":"IF(OR(AP38=\"\",$S$29=\"\"),\"\",(AP38/$S$29))","v":1.0653333333333332},{"$f":"IF(OR(AQ38=\"\",$T$29=\"\"),\"\",(AQ38/$T$29))","v":1.0656716417910448},"COP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45000,{"$f":"Y39/12000","v":3.75},null,null,"EER2",16.149999999999999,15.2,"SEER2",{"$f":"8/3.413","v":2.3439789041898624},{"$f":"7.2/3.413","v":2.1095810137708764},"COP",null,null,"EER",{"$f":"AD39/0.95","v":17},{"$f":"AE39/0.95","v":16},"SEER",{"$f":"9.4/3.413","v":2.7541752124230885},{"$f":"8.5/3.413","v":2.4904775857017287},"COP",125,"ton",{"$f":"AP39*3.413","v":9.4},{"$f":"AQ39*3.413","v":8.5},null,45000,{"$f":"AX39/12000","v":3.75},{"$f":"IF(OR(AA39=\"\",$D$30=\"\"),\"\",(AA39/$D$30))","v":""},{"$f":"IF(OR(AB39=\"\",$E$30=\"\"),\"\",(AB39/$E$30))","v":""},"EER2",{"$f":"IF(OR(AD39=\"\",$G$30=\"\"),\"\",(AD39/$G$30))","v":1.1293706293706292},{"$f":"IF(OR(AE39=\"\",$H$30=\"\"),\"\",(AE39/$H$30))","v":1.1343283582089552},"SEER2",{"$f":"IF(OR(AG39=\"\",$J$30=\"\"),\"\",(AG39/$J$30))","v":1.0666666666666667},{"$f":"IF(OR(AH39=\"\",$K$30=\"\"),\"\",(AH39/$K$30))","v":1.0746268656716418},"COP",{"$f":"IF(OR(AJ39=\"\",$M$30=\"\"),\"\",(AJ39/$M$30))","v":""},{"$f":"IF(OR(AK39=\"\",$N$30=\"\"),\"\",(AK39/$N$30))","v":""},"EER",{"$f":"IF(OR(AM39=\"\",$P$30=\"\"),\"\",(AM39/$P$30))","v":1.1293706293706292},{"$f":"IF(OR(AN39=\"\",$Q$30=\"\"),\"\",(AN39/$Q$30))","v":1.1343283582089552},"SEER",{"$f":"IF(OR(AP39=\"\",$S$30=\"\"),\"\",(AP39/$S$30))","v":1.0653333333333332},{"$f":"IF(OR(AQ39=\"\",$T$30=\"\"),\"\",(AQ39/$T$30))","v":1.0656716417910448},"COP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65000,5.416666666666667,null,null,"EER",null,15.8,"IEER",null,0,"COP",null,null,null,null,null,null,null,null,null,100,"ton",null,null,null,65000,{"$f":"AX40/12000","v":5.416666666666667},{"$f":"IF(OR(AA40=\"\",$D$31=\"\"),\"\",(AA40/$D$31))","v":""},{"$f":"IF(OR(AB40=\"\",$E$31=\"\"),\"\",(AB40/$E$31))","v":""},"EER",{"$f":"IF(OR(AD40=\"\",$G$31=\"\"),\"\",(AD40/$G$31))","v":""},{"$f":"IF(OR(AE40=\"\",$H$31=\"\"),\"\",(AE40/$H$31))","v":1.1366906474820144},"IEER",{"$f":"IF(OR(AG40=\"\",$J$31=\"\"),\"\",(AG40/$J$31))","v":""},{"$f":"IF(OR(AH40=\"\",$K$31=\"\"),\"\",(AH40/$K$31))","v":0},"COP",{"$f":"IF(OR(AJ40=\"\",$M$31=\"\"),\"\",(AJ40/$M$31))","v":""},{"$f":"IF(OR(AK40=\"\",$N$31=\"\"),\"\",(AK40/$N$31))","v":""},null,{"$f":"IF(OR(AM40=\"\",$P$31=\"\"),\"\",(AM40/$P$31))","v":""},{"$f":"IF(OR(AN40=\"\",$Q$31=\"\"),\"\",(AN40/$Q$31))","v":""},null,{"$f":"IF(OR(AP40=\"\",$S$31=\"\"),\"\",(AP40/$S$31))","v":""},{"$f":"IF(OR(AQ40=\"\",$T$31=\"\"),\"\",(AQ40/$T$31))","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,135000,11.25,null,null,"EER",null,15.1,"IEER",null,0,"COP",null,null,null,null,null,null,null,null,null,80,"ton",null,null,null,135000,11.25,{"$f":"IF(OR(AA41=\"\",$D$32=\"\"),\"\",(AA41/$D$32))","v":""},{"$f":"IF(OR(AB41=\"\",$E$32=\"\"),\"\",(AB41/$E$32))","v":""},"EER",{"$f":"IF(OR(AD41=\"\",$G$32=\"\"),\"\",(AD41/$G$32))","v":""},{"$f":"IF(OR(AE41=\"\",$H$32=\"\"),\"\",(AE41/$H$32))","v":1.1353383458646615},"IEER",{"$f":"IF(OR(AG41=\"\",$J$32=\"\"),\"\",(AG41/$J$32))","v":""},{"$f":"IF(OR(AH41=\"\",$K$32=\"\"),\"\",(AH41/$K$32))","v":0},"COP",{"$f":"IF(OR(AJ41=\"\",$M$32=\"\"),\"\",(AJ41/$M$32))","v":""},{"$f":"IF(OR(AK41=\"\",$N$32=\"\"),\"\",(AK41/$N$32))","v":""},null,{"$f":"IF(OR(AM41=\"\",$P$32=\"\"),\"\",(AM41/$P$32))","v":""},{"$f":"IF(OR(AN41=\"\",$Q$32=\"\"),\"\",(AN41/$Q$32))","v":""},null,{"$f":"IF(OR(AP41=\"\",$S$32=\"\"),\"\",(AP41/$S$32))","v":""},{"$f":"IF(OR(AQ41=\"\",$T$32=\"\"),\"\",(AQ41/$T$32))","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,240000,20,null,null,"EER",null,14.1,"IEER",null,0,"COP",null,null,null,null,null,null,null,null,null,75,"ton",null,null,null,240000,20,{"$f":"IF(OR(AA42=\"\",$D$33=\"\"),\"\",(AA42/$D$33))","v":""},{"$f":"IF(OR(AB42=\"\",$E$33=\"\"),\"\",(AB42/$E$33))","v":""},"EER",{"$f":"IF(OR(AD42=\"\",$G$33=\"\"),\"\",(AD42/$G$33))","v":""},{"$f":"IF(OR(AE42=\"\",$H$33=\"\"),\"\",(AE42/$H$33))","v":1.1463414634146341},"IEER",{"$f":"IF(OR(AG42=\"\",$J$33=\"\"),\"\",(AG42/$J$33))","v":""},{"$f":"IF(OR(AH42=\"\",$K$33=\"\"),\"\",(AH42/$K$33))","v":0},"COP",{"$f":"IF(OR(AJ42=\"\",$M$33=\"\"),\"\",(AJ42/$M$33))","v":""},{"$f":"IF(OR(AK42=\"\",$N$33=\"\"),\"\",(AK42/$N$33))","v":""},null,{"$f":"IF(OR(AM42=\"\",$P$33=\"\"),\"\",(AM42/$P$33))","v":""},{"$f":"IF(OR(AN42=\"\",$Q$33=\"\"),\"\",(AN42/$Q$33))","v":""},null,{"$f":"IF(OR(AP42=\"\",$S$33=\"\"),\"\",(AP42/$S$33))","v":""},{"$f":"IF(OR(AQ42=\"\",$T$33=\"\"),\"\",(AQ42/$T$33))","v":""}]
[]
[]
[]
[]
[null,1,2,3,4,5,null,null,null,null,null,null,null,1,2,3,4,5,null,null,null,null,null,null,1,2,3,4]
[null,"PTAC",null,null,null,null,null,null,null,null,null,null,null,"PTAC - Minimum Efficiencies allowed",null,null,null,null,null,null,null,null,null,null,"PTAC - Baseline checks"]
[null,null,null,"Baseline Cooling Efficiency",null,null,null,null,null,null,null,null,null,null,null,"Minimum Cooling Efficiency",null,"Incentive",null,null,null,null,null,null,null,null,"Minimum Cooling Efficiency"]
[null,"Btu/h","Tons","Standard and Non-Standard","Capacity Multiplier","Unit",null,null,null,null,null,null,null,"Btu/h","Tons","Standard and Non-Standard","Unit","Amount","Unit",null,null,null,null,null,"Btu/h","Tons","Standard and Non-Standard","Unit"]
[null,0,{"$f":"B51/12000","v":0},12.5,-0.21299999999999999,"EER",null,null,null,null,null,null,null,0,{"$f":"N51/12000","v":0},12,"EER",20,"Unit",null,null,null,null,null,0,{"$f":"Y51/12000","v":0},null,"EER"]
[null,9000,{"$f":"B52/12000","v":0.75},12.5,-0.21299999999999999,"EER",null,null,null,null,null,null,null,9000,{"$f":"N52/12000","v":0.75},11.5,"EER",30,"Unit",null,null,null,null,null,9000,{"$f":"Y52/12000","v":0.75},null,"EER"]
[null,12000,{"$f":"B53/12000","v":1},12.5,-0.21299999999999999,"EER",null,null,null,null,null,null,null,12000,{"$f":"N53/12000","v":1},10.5,"EER",40,"Unit",null,null,null,null,null,12000,{"$f":"Y53/12000","v":1},null,"EER"]
[null," "]
[]
[]
[null,1,2,3,4,5,6,7,8,null,null,null,null,1,2,3,4,5,6,null,null,null,null,null,1,2,3,4,5,6]
[null,"PTHP",null,null,null,null,null,null,null,null,null,null,null,"PTHP - Minimum Efficiencies allowed",null,null,null,null,null,null,null,null,null,null,"PTHP - Minimum Efficiencies allowed"]
[null,null,null,"Baseline Cooling Efficiency",null,null,"Baseline Heating Efficiency",null,null,null,null,null,null,null,null,"Minimum Cooling Efficiency",null,"Minimum Heating Efficiency",null,"Incentive",null,null,null,null,null,null,"Minimum Cooling Efficiency",null,"Minimum Heating Efficiency"]
[null,"Btu/h","Tons","Standard and Non-Standard","Capacity Multiplier","Unit","Standard and Non-Standard","Capacity Multiplier","Unit",null,null,null,null,"Btu/h","Tons","Standard and Non-Standard","Unit","Standard and Non-Standard","Unit","Amount","Unit",null,null,null,"Btu/h","Tons","Standard and Non-Standard","Unit","Standard and Non-Standard","Unit"]
[null,0,{"$f":"B61/12000","v":0},12.3,-0.21299999999999999,"EER",3.2,-2.5999999999999999E-2,"COP",null,null,null,null,0,{"$f":"N61/12000","v":0},12,"EER",3.3,"COP",40,"Unit",null,null,null,0,{"$f":"Y61/12000","v":0},null,"EER",null,"COP"]
[null,9000,{"$f":"B62/12000","v":0.75},12.3,-0.21299999999999999,"EER",3.2,-2.5999999999999999E-2,"COP",null,null,null,null,9000,{"$f":"N62/12000","v":0.75},11.5,"EER",3.2,"COP",50,"Unit",null,null,null,9000,{"$f":"Y62/12000","v":0.75},null,"EER",null,"COP"]
[null,12000,1,12.3,-0.21299999999999999,"EER",3.2,-2.5999999999999999E-2,"COP",null,null,null,null,12000,{"$f":"N63/12000","v":1},10.3,"EER",3.2,"COP",60,"Unit",null,null,null,12000,{"$f":"Y63/12000","v":1},null,"EER",null,"COP"]

{"sheet":"Window Film","index":9,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[8,0,8,7]]}
["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.\n§     Square feet installed must be entered as a whole number."]
["Building Type","Location/Floor/Suite #","Total Square Feet Installed","Number of Windows","Film Manufacturer / \nProduct Code","SHGC","Incentive Per Sq. Ft.","Window Facing Orientation","Total Incentive",null,null,"Incentive","Window Orientation","kWh/SF","kW/SF","Therms/SF","kWh","kW","Therms"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\",L5,\"/sq. ft.\")","v":"$1/sq. ft."},null,{"$f":"IF(OR(AND(F5>0,F5<=0.24,A5<>\"\")),C5*1,0)","v":0},null,null,1,"South",{"$f":"IF(I5=0,0,VLOOKUP($A5,'Window Film Lookups'!$C$9:$F$22,2,FALSE))","v":0},{"$f":"IF(I5=0,0,VLOOKUP($A5,'Window Film Lookups'!$C$9:$F$22,4,FALSE))","v":0},{"$f":"IF(I5=0,0,VLOOKUP($A5,'Window Film Lookups'!$C$9:$F$22,3,FALSE))","v":0},{"$f":"N5*$C5","v":0},{"$f":"O5*$C5","v":0},0]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\",L6,\"/sq. ft.\")","v":"$1/sq. ft."},null,{"$f":"IF(OR(AND(F6>0,F6<=0.24,A6<>\"\")),C6*1,0)","v":0},null,null,{"$f":"L5","v":1},"East",{"$f":"IF(I6=0,0,VLOOKUP($A6,'Window Film Lookups'!$C$9:$F$22,2,FALSE))","v":0},{"$f":"IF(I6=0,0,VLOOKUP($A6,'Window Film Lookups'!$C$9:$F$22,4,FALSE))","v":0},{"$f":"IF(I6=0,0,VLOOKUP($A6,'Window Film Lookups'!$C$9:$F$22,3,FALSE))","v":0},{"$f":"N6*$C6","v":0},{"$f":"O6*$C6","v":0},{"$f":"P6*$C6","v":0}]
[null,null,null,null,null,null,"$1/sq. ft.",null,{"$f":"IF(OR(AND(F7>0,F7<=0.24,A7<>\"\")),C7*1,0)","v":0},null,null,{"$f":"L6","v":1},"West",{"$f":"IF(I7=0,0,VLOOKUP($A7,'Window Film Lookups'!$C$9:$F$22,2,FALSE))","v":0},{"$f":"IF(I7=0,0,VLOOKUP($A7,'Window Film Lookups'!$C$9:$F$22,4,FALSE))","v":0},{"$f":"IF(I7=0,0,VLOOKUP($A7,'Window Film Lookups'!$C$9:$F$22,3,FALSE))","v":0},0,0,0]
[null,null,null,null,null,null,"$1/sq. ft.",null,{"$f":"IF(OR(AND(F8>0,F8<=0.24,A8<>\"\")),C8*1,0)","v":0},null,null,1,null,{"$f":"IF(I8=0,0,VLOOKUP($A8,'Window Film Lookups'!$C$9:$F$22,2,FALSE))","v":0},{"$f":"IF(I8=0,0,VLOOKUP($A8,'Window Film Lookups'!$C$9:$F$22,4,FALSE))","v":0},{"$f":"IF(I8=0,0,VLOOKUP($A8,'Window Film Lookups'!$C$9:$F$22,3,FALSE))","v":0},0,0,0]
["Total Requested Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I5:I8)","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 14.2"}]

{"sheet":"Cool Roof","index":10,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,13,11,15],[0,0,0,7],[1,0,1,7],[2,0,2,7],[8,0,8,6]]}
[]
["COOL ROOF TECHNICAL REQUIREMENTS AND INCENTIVES"]
["§ Roof coverings must be certified by CRRC (Cool Roof Rating Council).                                                                 \t                                                                                                                                                   \n§    The roof must have at least an initial rated reflectance of 0.65, and a rated reflectance of 0.50 after 3 years of exposure.                                                                                                                                                         \n§    The roof covering can’t be ballasted, or otherwise mostly covered with other materials.   \n§ Roof must be located over an air-conditioned space.                         "]
["Building Type","Roofing Brand/Manufacturer \n& Product Code","Cool Roof Application","Initial Reflectance","Aged Reflectanace","Roof Area (sq. ft.)","Incentive Per Sq. Ft.","Total Incentive",null,null,"Location","ESF","DSF","kWh","kW","kWh/SF","kW/SF"]
[null,null,null,null,null,null,0.1,{"$f":"IF(OR(D5=\"\",E5=\"\",F5=\"\"),0,IF(OR(K5=$L$16,K5=$L$17),K5,IF(AND(D5>=0.65,E5>=0.5),F5*0.1,0)))","v":0},null,null,{"$f":"IFERROR(IF(A5=\"\",\"\",IF('Project Information'!$L$6=\"\",$L$16,VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE))),$L$17)","v":""},{"$f":"IFERROR(INDEX(Validation!D$52:D$87,MATCH(1,($A5=Validation!$B$52:$B$87)*($K5=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"IFERROR(INDEX(Validation!E$52:E$87,MATCH(1,($A5=Validation!$B$52:$B$87)*($K5=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"$F5*L5","v":0},{"$f":"$F5*M5","v":0},{"$f":"IFERROR(N5/F5,0)","v":0},{"$f":"IFERROR(O5/F5,0)","v":0}]
[null,null,null,null,null,null,0.1,{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\"),0,IF(OR(K6=$L$16,K6=$L$17),K6,IF(AND(D6>=0.65,E6>=0.5),F6*0.1,0)))","v":0},null,null,{"$f":"IFERROR(IF(A6=\"\",\"\",IF('Project Information'!$L$6=\"\",$L$16,VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE))),$L$17)","v":""},{"$f":"IFERROR(INDEX(Validation!D$52:D$87,MATCH(1,($A6=Validation!$B$52:$B$87)*($K6=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"IFERROR(INDEX(Validation!E$52:E$87,MATCH(1,($A6=Validation!$B$52:$B$87)*($K6=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"$F6*L6","v":0},{"$f":"$F6*M6","v":0},{"$f":"IFERROR(N6/F6,0)","v":0},{"$f":"IFERROR(O6/F6,0)","v":0}]
[null,null,null,null,null,null,0.1,0,null,null,{"$f":"IFERROR(IF(A7=\"\",\"\",IF('Project Information'!$L$6=\"\",$L$16,VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE))),$L$17)","v":""},{"$f":"IFERROR(INDEX(Validation!D$52:D$87,MATCH(1,($A7=Validation!$B$52:$B$87)*($K7=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"IFERROR(INDEX(Validation!E$52:E$87,MATCH(1,($A7=Validation!$B$52:$B$87)*($K7=Validation!$C$52:$C$87),0)),0)","v":0},0,0,0,0]
[null,null,null,null,null,null,0.1,0,null,null,{"$f":"IFERROR(IF(A8=\"\",\"\",IF('Project Information'!$L$6=\"\",$L$16,VLOOKUP('Project Information'!$L$6,Validation!$B$115:$D$514,3,FALSE))),$L$17)","v":""},{"$f":"IFERROR(INDEX(Validation!D$52:D$87,MATCH(1,($A8=Validation!$B$52:$B$87)*($K8=Validation!$C$52:$C$87),0)),0)","v":0},{"$f":"IFERROR(INDEX(Validation!E$52:E$87,MATCH(1,($A8=Validation!$B$52:$B$87)*($K8=Validation!$C$52:$C$87),0)),0)","v":0},0,0,0,0]
["Total Requested Incentive",null,null,null,null,null,null,{"$f":"SUM(H5:H8)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 14.2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kWh ","Total Summer Coincident Peak (kW)","Total Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N5:N8)","v":0},{"$f":"SUM(O5:O8)","v":0},{"$f":"H9","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Missing zip code message:","Fill in zip code in cell L6 on Project Information tab"]
[null,null,null,null,null,null,null,null,null,null,"Non-eligible zip code message:","Ineligible zip code. Please check cell L6 on Project Information tab"]

{"sheet":"Window Film Lookups","index":11,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[[4,2,7,2]]}
[]
[null,null,"Data Provided from the evaluator"]
[]
[]
[null,null,"BuildingTypeWF","Annual window film savings/sq. ft."]
[null,null,null,"Measure","Measure","Measure Coincident Summer Elec. Peak Differential"]
[null,null,null,"Total Elec. Differential","Total Gas Differential","(kW)"]
[null,null,null,"(kWh)","(Therms)"]
[null,null,"Elementary School",5,0.159,2E-3]
[null,null,"Fast Food",12,-0.379,4.0000000000000001E-3]
[null,null,"Full Restaurant ",11,-0.36699999999999999,4.0000000000000001E-3]
[null,null,"Grocery",2,-0.52,2E-3]
[null,null,"High School",6,4.7E-2,2E-3]
[null,null,"Hospital",35,2.2000000000000002,5.0000000000000001E-3]
[null,null,"Large Hotel",7,8.9999999999999993E-3,2E-3]
[null,null,"Large Office",16,4.5999999999999999E-2,4.0000000000000001E-3]
[null,null,"OutPatient",32,1.1020000000000001,5.0000000000000001E-3]
[null,null,"Retail",10,-0.33500000000000002,4.0000000000000001E-3]
[null,null,"Small Hotel",12,-0.13100000000000001,3.0000000000000001E-3]
[null,null,"Small Office",12,-0.253,4.0000000000000001E-3]
[null,null,"Strip Mall",9,-0.43,4.0000000000000001E-3]
[null,null,"Warehouse",6,-0.32500000000000001,3.0000000000000001E-3]

{"sheet":"HVAC Chillers","index":12,"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,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],[38,6,39,6],[31,9,31,10],[34,9,34,10],[32,9,32,10],[33,9,33,10],[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],[40,9,41,9],[40,10,41,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],[23,4,24,5],[23,7,24,7],[23,9,24,9],[25,4,26,5],[25,7,26,7],[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],[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,3,12,3],[13,3,14,3],[11,1,12,1],[11,10,12,10],[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],[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],[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],[13,1,14,1],[13,4,14,5],[13,7,14,7],[13,8,14,8],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[13,9,14,9],[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],[25,1,26,1],[29,9,30,10],[38,9,39,9],[38,10,39,10],[38,11,39,11],[37,3,37,6],[15,1,16,1],[15,4,16,5],[13,10,14,10],[13,11,14,11],[15,10,16,10]]}
["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,20,{"$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,20,{"$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,35,{"$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,35,{"$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,25,{"$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,20,{"$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,20,{"$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,20,{"$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"]
[]
[]
[]
[]
[]
["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 14.2"}]

{"sheet":"Validation","index":13,"n_rows":514,"n_cols":9,"rows_kept":514,"cut":false,"hidden":true,"merged":[[10,3,10,4],[10,5,10,6],[29,1,29,2]]}
[]
[null,null,"Equipment Name","Measure Code","System Type","Split/Packaged","Incentive Per"]
[null,null,"Split System A/C","S","AC","S","Ton"]
[null,null,"Unitary A/C","U","AC","P","Ton"]
[null,null,"Split System Heat Pump","SH","HP","S","Ton"]
[null,null,"Unitary Heat Pump","UH","HP","P","Ton"]
[null,null,"Packaged Terminal A/C","PTAC","PTAC","P","Unit"]
[null,null,"Packaged Terminal Heat Pump","PTHP","PTHP","P","Unit"]
[]
[]
[null,null,null,"EFLHHEAT",null,"EFLHCOOL"]
[null,"3.2.2 Equivalent Full Load Hours","HVAC Measure Building Type","Charleston","Columbia","Charleston","Columbia"]
[null,null,"Assembly",475,565,3141,2888]
[null,null,"Education",434,516,1694,1558]
[null,null,"Garage",226,269,2340,2151]
[null,null,"Grocery",454,540,1966,1807]
[null,null,"Health",371,442,3285,3021]
[null,null,"Industrial",188,224,2149,1976]
[null,null,"Lodging",464,552,2311,2125]
[null,null,"Multi-Family",353,420,1960,1802]
[null,null,"Office",418,497,3056,2810]
[null,null,"Retail",348,415,1430,1315]
[null,null,"Warehouse",381,453,558,513]
[null,null,"Other",530,631,2068,1901]
[]
[]
[null,null,null,null,null,null,null,"Convenience/C-Store",{"$f":"_xlfn.CONCAT(H27,\"|\",H27,\"|\")","v":"Convenience/C-Store|Convenience/C-Store|"}]
[null,null,null,null,null,null,null,"Fitness/Recreation ",{"$f":"_xlfn.CONCAT(H28,\"|\",H28,\"|\")","v":"Fitness/Recreation |Fitness/Recreation |"}]
[null,null,null,null,null,null,null,"Grocery","Grocery|Grocery|"]
[null,"Minimum Roof Area by Building Type",null,null,null,null,null,"Health Facility","Health Facility|Health Facility|"]
[null,"Building Type","Minimum Area (sq. ft.)",null,null,null,null,"Industrial","Industrial|Industrial|"]
[null,"Office-small",5500,null,null,null,null,"Lodging","Lodging|Lodging|"]
[null,"Office-medium",17875.948254299998,null,null,null,null,"Multifamily","Multifamily|Multifamily|"]
[null,"Office-large",38352.995360100002,null,null,null,null,"Office","Office|Office|"]
[null,"Hotel-small",10800.614933099998,null,null,null,null,"Religious Facility","Religious Facility|Religious Facility|"]
[null,"Hotel-large",21300.055664400003,null,null,null,null,"Restaurant","Restaurant|Restaurant|"]
[null,"Hospital",40250,null,null,null,null,"Retail","Retail|Retail|"]
[null,"Warehouse-conditioned",49495.149157499996,null,null,null,null,"School","School|School|"]
[null,"Retail-stand alone",24692.301900899998,null,null,null,null,"University","University|University|"]
[null,"Retail-strip mall",22499.801072999995,null,null,null,null,"Warehouse","Warehouse|Warehouse|"]
[null,"School-primary",73958.82561,null,null,null,null,"Other","Other|Other|"]
[null,"School-secondary",128112.05681999998]
[null,"Other",39348.88625211818]
[]
[null,"Cool Roof Location"]
[null,"Charleston"]
[null,"Columbia"]
[null,"Greenville"]
[]
[]
[null,"Building Type","Location","ESF","DSF"]
[null,"Office-small","Charleston",0.22075680254705482,9.5861927024675118E-5]
[null,"Office-small","Columbia",0.21360585974854884,8.8201723834139672E-5]
[null,"Office-small","Greenville",0.1769502735167747,8.5956572119191162E-5]
[null,"Office-medium","Charleston",0.31856887527112832,2.0566853001018485E-4]
[null,"Office-medium","Columbia",0.29665648373338921,1.941262052582447E-4]
[null,"Office-medium","Greenville",0.22249624797583875,1.5668427543843804E-4]
[null,"Office-large","Charleston",0.4082361429922543,3.3820174612736529E-4]
[null,"Office-large","Columbia",0.37354041685791445,1.0290695584381792E-4]
[null,"Office-large","Greenville",0.27691390607861599,1.043845457808832E-4]
[null,"Hotel-small","Charleston",0.2852995809503866,4.8880550160346946E-5]
[null,"Hotel-small","Columbia",0.24275671159481482,6.1577049466120121E-5]
[null,"Hotel-small","Greenville",0.13279856982031119,6.48055693435491E-5]
[null,"Hotel-large","Charleston",0.81516586100491073,5.8862756969017402E-5]
[null,"Hotel-large","Columbia",0.72445565535556211,1.5721555158172104E-4]
[null,"Hotel-large","Greenville",0.64307079795054845,1.259973233067847E-4]
[null,"Hospital","Charleston",0.83858586199362717,1.1499881129359591E-4]
[null,"Hospital","Columbia",0.83189097898017172,1.4457503088395233E-4]
[null,"Hospital","Greenville",0.79593186506259339,1.2658284098505989E-4]
[null,"Warehouse-conditioned","Charleston",0.22238012705054439,7.9799739312463408E-5]
[null,"Warehouse-conditioned","Columbia",0.21441841514906912,7.7748225139289144E-5]
[null,"Warehouse-conditioned","Greenville",0.1785618058354399,6.9729055447790967E-5]
[null,"Retail-stand alone","Charleston",0.7863460751703446,2.2693995976923271E-4]
[null,"Retail-stand alone","Columbia",0.75368089560879237,2.3249351247364811E-4]
[null,"Retail-stand alone","Greenville",0.69253690877846685,1.8801244285089472E-4]
[null,"Retail-strip mall","Charleston",0.80161594331044717,1.0165378763035654E-4]
[null,"Retail-strip mall","Columbia",0.7676493753225393,1.7281975015619703E-4]
[null,"Retail-strip mall","Greenville",0.72308662098521725,1.6293832945924705E-4]
[null,"School-primary","Charleston",0.96279149150157983,3.5629297494465758E-4]
[null,"School-primary","Columbia",0.90432985458783754,3.8609239349710636E-4]
[null,"School-primary","Greenville",0.79313855569805836,3.2936204434141729E-4]
[null,"School-secondary","Charleston",1.0196797136264741,3.2202043292430812E-4]
[null,"School-secondary","Columbia",0.97894534856467141,3.5636809784535999E-4]
[null,"School-secondary","Greenville",0.90728886235400319,3.1560269192156193E-4]
[null,"Other","Charleston",0.60722058867443207,1.771982923787458E-4]
[null,"Other","Columbia",0.57290272686393739,1.7946586327087242E-4]
[null,"Other","Greenville",0.50388858309598805,1.57277790090438E-4]
[]
[]
[null,"county","Cool Roof Representative Zone"]
[null,"Abbeville","Columbia"]
[null,"Aiken","Columbia"]
[null,"Allendale","Columbia"]
[null,"Bamberg","Columbia"]
[null,"Barnwell","Columbia"]
[null,"Beaufort","Charleston"]
[null,"Berkeley","Charleston"]
[null,"Calhoun","Columbia"]
[null,"Charleston","Charleston"]
[null,"Colleton","Charleston"]
[null,"Dorchester","Charleston"]
[null,"Edgefield","Columbia"]
[null,"Fairfield","Columbia"]
[null,"Hampton","Charleston"]
[null,"Jasper","Charleston"]
[null,"Lexington","Columbia"]
[null,"McCormick","Columbia"]
[null,"Orangeburg","Columbia"]
[null,"Richland","Columbia"]
[null,"Richland/Fairfield","Columbia"]
[null,"Richland/Kershaw","Columbia"]
[null,"Saluda","Columbia"]
[]
[]
[null,"Zip","County","Cool Roof Zone"]
[null,29901,"Beaufort",{"$f":"VLOOKUP(C116,$B$91:$C$112,2,FALSE)","v":"Charleston"}]
[null,{"$f":"B116+1","v":29902},"Beaufort",{"$f":"VLOOKUP(C117,$B$91:$C$112,2,FALSE)","v":"Charleston"}]
[null,29902,"Beaufort","Charleston"]
[null,29902,"Beaufort","Charleston"]
[null,{"$f":"B119+1","v":29903},"Beaufort","Charleston"]
[null,{"$f":"B120+1","v":29904},"Beaufort","Charleston"]
[null,29906,"Beaufort","Charleston"]
[null,29906,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,{"$f":"B127+1","v":29911},"Beaufort","Charleston"]
[null,29911,"Hampton","Charleston"]
[null,29913,"Hampton","Charleston"]
[null,29914,"Beaufort","Charleston"]
[null,29915,"Beaufort","Charleston"]
[null,29916,"Hampton","Charleston"]
[null,29918,"Hampton","Charleston"]
[null,29922,"Hampton","Charleston"]
[null,29923,"Hampton","Charleston"]
[null,29924,"Hampton","Charleston"]
[null,29925,"Beaufort","Charleston"]
[null,29926,"Beaufort","Charleston"]
[null,29928,"Beaufort","Charleston"]
[null,29933,"Hampton","Charleston"]
[null,29935,"Beaufort","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29945,"Jasper","Charleston"]
[null,29945,"Jasper","Charleston"]
[null,29931,"Beaufort","Charleston"]
[null,29938,"Beaufort","Charleston"]
[null,29939,"Hampton","Charleston"]
[null,29943,"Jasper","Charleston"]
[null,29944,"Hampton","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29927,"Jasper","Charleston"]
[null,29941,"Beaufort","Charleston"]
[null,29943,"Jasper","Charleston"]
[null,29929,"Colleton","Charleston"]
[null,29932,"Hampton","Charleston"]
[null,29934,"Jasper","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29016,"Richland/Fairfield","Columbia"]
[null,29044,"Richland","Columbia"]
[null,29045,"Richland/Kershaw","Columbia"]
[null,29052,"Richland","Columbia"]
[null,29061,"Richland","Columbia"]
[null,29177,"Richland","Columbia"]
[null,29201,"Richland","Columbia"]
[null,29202,"Richland","Columbia"]
[null,29203,"Richland","Columbia"]
[null,29204,"Richland","Columbia"]
[null,29205,"Richland","Columbia"]
[null,29206,"Richland","Columbia"]
[null,29207,"Richland","Columbia"]
[null,29208,"Richland","Columbia"]
[null,29209,"Richland","Columbia"]
[null,29211,"Richland","Columbia"]
[null,29216,"Richland","Columbia"]
[null,{"$f":"B176+1","v":29217},"Richland","Columbia"]
[null,{"$f":"B177+1","v":29218},"Richland","Columbia"]
[null,{"$f":"B178+1","v":29219},"Richland","Columbia"]
[null,{"$f":"B179+1","v":29220},"Richland","Columbia"]
[null,29214,"Richland",{"$f":"VLOOKUP(C181,$B$91:$C$112,2,FALSE)","v":"Columbia"}]
[null,{"$f":"B181+1","v":29215},"Richland","Columbia"]
[null,{"$f":"B182+1","v":29216},"Richland","Columbia"]
[null,{"$f":"B183+1","v":29217},"Richland","Columbia"]
[null,{"$f":"B184+1","v":29218},"Richland","Columbia"]
[null,{"$f":"B185+1","v":29219},"Richland","Columbia"]
[null,29210,"Richland","Columbia"]
[null,{"$f":"B187+1","v":29211},"Richland","Columbia"]
[null,{"$f":"B188+1","v":29212},"Richland","Columbia"]
[null,29212,"Richland","Columbia"]
[null,29215,"Richland","Columbia"]
[null,{"$f":"B191+1","v":29216},"Richland","Columbia"]
[null,{"$f":"B192+1","v":29217},"Richland","Columbia"]
[null,{"$f":"B193+1","v":29218},"Richland","Columbia"]
[null,29240,"Richland","Columbia"]
[null,29250,"Richland","Columbia"]
[null,29260,"Richland","Columbia"]
[null,29260,"Richland","Columbia"]
[null,29290,"Richland","Columbia"]
[null,29292,"Richland","Columbia"]
[null,29147,"Richland","Columbia"]
[null,29461,"Berkeley","Charleston"]
[null,29445,"Berkeley","Charleston"]
[null,29456,"Berkeley","Charleston"]
[null,29436,"Berkeley","Charleston"]
[null,29461,"Berkeley","Charleston"]
[null,29920,"Berkeley","Charleston"]
[null,29437,"Charleston","Charleston"]
[null,29439,"Charleston","Charleston"]
[null,29422,"Charleston","Charleston"]
[null,29470,"Charleston","Charleston"]
[null,29449,"Charleston","Charleston"]
[null,29417,"Charleston","Charleston"]
[null,29415,"Charleston","Charleston"]
[null,29405,"Charleston","Charleston"]
[null,29420,"Charleston","Charleston"]
[null,29410,"Charleston","Charleston"]
[null,29426,"Charleston","Charleston"]
[null,29404,"Charleston","Charleston"]
[null,29455,"Charleston","Charleston"]
[null,29455,"Charleston","Charleston"]
[null,29414,"Charleston","Charleston"]
[null,29457,"Charleston","Charleston"]
[null,{"$f":"B223+1","v":29458},"Charleston","Charleston"]
[null,29401,"Charleston","Charleston"]
[null,29407,"Charleston","Charleston"]
[null,29449,"Charleston","Charleston"]
[null,29406,"Charleston","Charleston"]
[null,29409,"Charleston","Charleston"]
[null,29413,"Charleston","Charleston"]
[null,29451,"Charleston","Charleston"]
[null,29418,"Charleston","Charleston"]
[null,29422,"Charleston","Charleston"]
[null,29423,"Charleston","Charleston"]
[null,29492,"Charleston","Charleston"]
[null,29451,"Charleston","Charleston"]
[null,29413,"Charleston","Charleston"]
[null,29412,"Charleston","Charleston"]
[null,29424,"Charleston","Charleston"]
[null,29425,"Charleston","Charleston"]
[null,29487,"Charleston","Charleston"]
[null,29419,"Charleston","Charleston"]
[null,{"$f":"B242+1","v":29420},"Charleston","Charleston"]
[null,29416,"Charleston","Charleston"]
[null,29417,"Charleston",{"$f":"VLOOKUP(C245,$B$91:$C$112,2,FALSE)","v":"Charleston"}]
[null,29458,"Charleston","Charleston"]
[null,29464,"Charleston","Charleston"]
[null,29465,"Charleston","Charleston"]
[null,29466,"Charleston","Charleston"]
[null,29482,"Charleston","Charleston"]
[null,29433,"Colleton","Charleston"]
[null,29435,"Colleton","Charleston"]
[null,29438,"Colleton","Charleston"]
[null,29446,"Colleton","Charleston"]
[null,29452,"Colleton","Charleston"]
[null,29488,"Colleton","Charleston"]
[null,29474,"Colleton","Charleston"]
[null,29488,"Colleton","Charleston"]
[null,29493,"Colleton","Charleston"]
[null,29475,"Colleton","Charleston"]
[null,29481,"Colleton","Charleston"]
[null,29082,"Colleton","Charleston"]
[null,29437,"Dorchester","Charleston"]
[null,29447,"Dorchester","Charleston"]
[null,29448,"Dorchester","Charleston"]
[null,29483,"Dorchester","Charleston"]
[null,29484,"Dorchester","Charleston"]
[null,29485,"Dorchester","Charleston"]
[null,29471,"Dorchester","Charleston"]
[null,29472,"Dorchester","Charleston"]
[null,29477,"Dorchester","Charleston"]
[null,29437,"Dorchester","Charleston"]
[null,29447,"Dorchester","Charleston"]
[null,29448,"Dorchester","Charleston"]
[null,29483,"Dorchester","Charleston"]
[null,29484,"Dorchester","Charleston"]
[null,29485,"Dorchester","Charleston"]
[null,29471,"Dorchester","Charleston"]
[null,29472,"Dorchester","Charleston"]
[null,29477,"Dorchester","Charleston"]
[null,29475,"Colleton","Charleston"]
[null,29481,"Colleton","Charleston"]
[null,29082,"Colleton","Charleston"]
[null,29003,"Bamberg","Columbia"]
[null,29628,"Abbeville","Columbia"]
[null,29801,"Aiken","Columbia"]
[null,29802,"Aiken","Columbia"]
[null,29803,"Aiken","Columbia"]
[null,29804,"Aiken","Columbia"]
[null,29804,"Aiken","Columbia"]
[null,29804,"Aiken","Columbia"]
[null,29805,"Aiken","Columbia"]
[null,29808,"Aiken","Columbia"]
[null,29809,"Aiken","Columbia"]
[null,29810,"Allendale","Columbia"]
[null,29812,"Barnwell","Columbia"]
[null,29813,"Barnwell","Columbia"]
[null,29816,"Aiken","Columbia"]
[null,29817,"Barnwell","Columbia"]
[null,29821,"McCormick","Columbia"]
[null,29822,"Aiken","Columbia"]
[null,29824,"Edgefield","Columbia"]
[null,29826,"Barnwell","Columbia"]
[null,29827,"Allendale","Columbia"]
[null,29828,"Aiken","Columbia"]
[null,29829,"Aiken","Columbia"]
[null,29831,"Aiken","Columbia"]
[null,29834,"Aiken","Columbia"]
[null,29839,"Aiken",{"$f":"VLOOKUP(C309,$B$91:$C$112,2,FALSE)","v":"Columbia"}]
[null,29841,"Aiken","Columbia"]
[null,29842,"Aiken","Columbia"]
[null,29850,"Aiken","Columbia"]
[null,29850,"Aiken","Columbia"]
[null,29836,"Allendale","Columbia"]
[null,29846,"Allendale","Columbia"]
[null,29846,"Allendale","Columbia"]
[null,29849,"Allendale","Columbia"]
[null,29849,"Allendale","Columbia"]
[null,29843,"Bamberg","Columbia"]
[null,29832,"Edgefield","Columbia"]
[null,29847,"Edgefield","Columbia"]
[null,29847,"Edgefield","Columbia"]
[null,29835,"McCormick","Columbia"]
[null,29838,"McCormick","Columbia"]
[null,29840,"McCormick","Columbia"]
[null,29844,"McCormick","Columbia"]
[null,29845,"McCormick","Columbia"]
[null,29851,"Aiken","Columbia"]
[null,29851,"Aiken","Columbia"]
[null,29853,"Barnwell","Columbia"]
[null,29853,"Barnwell","Columbia"]
[null,29856,"Aiken","Columbia"]
[null,29856,"Aiken","Columbia"]
[null,29860,"Aiken","Columbia"]
[null,29861,"Aiken","Columbia"]
[null,29123,"Lexington","Columbia"]
[null,29073,"Lexington","Columbia"]
[null,29133,"Orangeburg","Columbia"]
[null,29112,"Orangeburg","Columbia"]
[null,29116,"Orangeburg","Columbia"]
[null,29146,"Orangeburg","Columbia"]
[null,29135,"Calhoun","Columbia"]
[null,29015,"Fairfield","Columbia"]
[null,29065,"Fairfield","Columbia"]
[null,29106,"Fairfield","Columbia"]
[null,29135,"Orangeburg","Columbia"]
[null,29113,"Orangeburg","Columbia"]
[null,29130,"Fairfield","Columbia"]
[null,29132,"Fairfield","Columbia"]
[null,29048,"Orangeburg","Columbia"]
[null,29036,"Lexington","Columbia"]
[null,29169,"Lexington","Columbia"]
[null,29172,"Lexington","Columbia"]
[null,29176,"Fairfield","Columbia"]
[null,29170,"Lexington","Columbia"]
[null,29018,"Orangeburg","Columbia"]
[null,29170,"Lexington","Columbia"]
[null,29171,"Lexington","Columbia"]
[null,29053,"Lexington","Columbia"]
[null,29432,"Orangeburg","Columbia"]
[null,29030,"Orangeburg","Columbia"]
[null,29038,"Orangeburg","Columbia"]
[null,29171,"Lexington","Columbia"]
[null,29039,"Orangeburg","Columbia"]
[null,29054,"Lexington","Columbia"]
[null,29047,"Orangeburg","Columbia"]
[null,29059,"Orangeburg","Columbia"]
[null,29180,"Fairfield","Columbia"]
[null,29160,"Lexington","Columbia"]
[null,29071,"Lexington","Columbia"]
[null,29063,"Lexington","Columbia"]
[null,29033,"Lexington","Columbia"]
[null,29172,"Lexington",{"$f":"VLOOKUP(C373,$B$91:$C$112,2,FALSE)","v":"Columbia"}]
[null,29070,"Lexington","Columbia"]
[null,29072,"Lexington","Columbia"]
[null,29142,"Orangeburg","Columbia"]
[null,29115,"Orangeburg","Columbia"]
[null,29117,"Orangeburg","Columbia"]
[null,29163,"Orangeburg","Columbia"]
[null,29160,"Lexington","Columbia"]
[null,29169,"Lexington","Columbia"]
[null,29118,"Orangeburg","Columbia"]
[null,29006,"Lexington","Columbia"]
[null,29107,"Orangeburg","Columbia"]
[null,29107,"Orangeburg","Columbia"]
[null,29081,"Bamberg","Columbia"]
[null,29105,"Saluda","Columbia"]
[null,29129,"Saluda","Columbia"]
[null,29137,"Aiken","Columbia"]
[null,29137,"Aiken","Columbia"]
[null,29138,"Saluda","Columbia"]
[null,29138,"Saluda","Columbia"]
[null,29164,"Aiken","Columbia"]
[null,29164,"Aiken","Columbia"]
[null,29166,"Saluda","Columbia"]
[null,29166,"Saluda","Columbia"]
[null,29166,"Saluda","Columbia"]
[null,29166,"Saluda","Columbia"]
[null,29073,"Lexington","Columbia"]
[null,29042,"Bamberg","Columbia"]
[null,29461,"Berkeley","Charleston"]
[null,29445,"Berkeley","Charleston"]
[null,29456,"Berkeley","Charleston"]
[null,29436,"Berkeley","Charleston"]
[null,29461,"Berkeley","Charleston"]
[null,29920,"Berkeley","Charleston"]
[null,29437,"Charleston","Charleston"]
[null,29439,"Charleston","Charleston"]
[null,29422,"Charleston","Charleston"]
[null,29470,"Charleston","Charleston"]
[null,29449,"Charleston","Charleston"]
[null,29417,"Charleston","Charleston"]
[null,29415,"Charleston","Charleston"]
[null,29405,"Charleston","Charleston"]
[null,29420,"Charleston","Charleston"]
[null,29410,"Charleston","Charleston"]
[null,29426,"Charleston","Charleston"]
[null,29404,"Charleston","Charleston"]
[null,29455,"Charleston","Charleston"]
[null,29455,"Charleston","Charleston"]
[null,29414,"Charleston","Charleston"]
[null,29457,"Charleston","Charleston"]
[null,{"$f":"B422+1","v":29458},"Charleston","Charleston"]
[null,29401,"Charleston","Charleston"]
[null,29412,"Charleston","Charleston"]
[null,29407,"Charleston","Charleston"]
[null,29487,"Charleston","Charleston"]
[null,29418,"Charleston","Charleston"]
[null,29419,"Charleston","Charleston"]
[null,29449,"Charleston","Charleston"]
[null,{"$f":"B430+1","v":29450},"Charleston","Charleston"]
[null,29406,"Charleston","Charleston"]
[null,29409,"Charleston","Charleston"]
[null,29413,"Charleston","Charleston"]
[null,29416,"Charleston","Charleston"]
[null,29417,"Charleston","Charleston"]
[null,29422,"Charleston",{"$f":"VLOOKUP(C437,$B$91:$C$112,2,FALSE)","v":"Charleston"}]
[null,29423,"Charleston","Charleston"]
[null,29424,"Charleston","Charleston"]
[null,29425,"Charleston","Charleston"]
[null,29492,"Charleston","Charleston"]
[null,29451,"Charleston","Charleston"]
[null,29413,"Charleston","Charleston"]
[null,29451,"Charleston","Charleston"]
[null,29458,"Charleston","Charleston"]
[null,29464,"Charleston","Charleston"]
[null,29465,"Charleston","Charleston"]
[null,29466,"Charleston","Charleston"]
[null,29482,"Charleston","Charleston"]
[null,29433,"Colleton","Charleston"]
[null,29435,"Colleton","Charleston"]
[null,29438,"Colleton","Charleston"]
[null,29446,"Colleton","Charleston"]
[null,29452,"Colleton","Charleston"]
[null,29488,"Colleton","Charleston"]
[null,29474,"Colleton","Charleston"]
[null,29488,"Colleton","Charleston"]
[null,29493,"Colleton","Charleston"]
[null,29475,"Colleton","Charleston"]
[null,29481,"Colleton","Charleston"]
[null,29082,"Colleton","Charleston"]
[null,29437,"Dorchester","Charleston"]
[null,29447,"Dorchester","Charleston"]
[null,29448,"Dorchester","Charleston"]
[null,29483,"Dorchester","Charleston"]
[null,29484,"Dorchester","Charleston"]
[null,29485,"Dorchester","Charleston"]
[null,29471,"Dorchester","Charleston"]
[null,29472,"Dorchester","Charleston"]
[null,29477,"Dorchester","Charleston"]
[null,29901,"Beaufort","Charleston"]
[null,{"$f":"B471+1","v":29902},"Beaufort","Charleston"]
[null,29902,"Beaufort","Charleston"]
[null,29902,"Beaufort","Charleston"]
[null,{"$f":"B474+1","v":29903},"Beaufort","Charleston"]
[null,{"$f":"B475+1","v":29904},"Beaufort","Charleston"]
[null,29906,"Beaufort","Charleston"]
[null,29906,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,29910,"Beaufort","Charleston"]
[null,{"$f":"B482+1","v":29911},"Beaufort","Charleston"]
[null,29911,"Hampton","Charleston"]
[null,29913,"Hampton","Charleston"]
[null,29914,"Beaufort","Charleston"]
[null,29915,"Beaufort","Charleston"]
[null,29916,"Hampton","Charleston"]
[null,29918,"Hampton","Charleston"]
[null,29922,"Hampton","Charleston"]
[null,29923,"Hampton","Charleston"]
[null,29924,"Hampton","Charleston"]
[null,29925,"Beaufort","Charleston"]
[null,29926,"Beaufort","Charleston"]
[null,29927,"Jasper","Charleston"]
[null,29928,"Beaufort","Charleston"]
[null,29929,"Colleton","Charleston"]
[null,29931,"Beaufort","Charleston"]
[null,29932,"Hampton","Charleston"]
[null,29933,"Hampton","Charleston"]
[null,29934,"Jasper",{"$f":"VLOOKUP(C501,$B$91:$C$112,2,FALSE)","v":"Charleston"}]
[null,29935,"Beaufort","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29936,"Jasper","Charleston"]
[null,29938,"Beaufort","Charleston"]
[null,29939,"Hampton","Charleston"]
[null,29941,"Beaufort","Charleston"]
[null,29943,"Jasper","Charleston"]
[null,29943,"Jasper","Charleston"]
[null,29944,"Hampton","Charleston"]
[null,29945,"Jasper","Charleston"]
[null,29945,"Jasper","Charleston"]

{"sheet":"VFDs","index":14,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,0,28,5],[28,6,28,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[31,15,31,16],[26,6,26,7],[27,6,27,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[16,0,16,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],[14,0,14,7],[15,0,15,1],[15,2,15,4],[15,5,15,7],[12,0,12,5],[13,0,13,5],[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],[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 "]
["$75.00 when Horse Power is .25 to 1.00"]
["$50.00 when Horse Power is greater than 1.00"]
["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 / Model","VFD & Motor Horsepower (Table 2)","Controlling Parameter (Table 3)","Quantity","Location/Designation","Requested Incentive "]
[null,null,null,null,null,null,{"$f":"IF(C19=\"\",\"\",IF(C19<=1,75*E19,50*C19*E19))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(C20=\"\",\"\",IF(C20<=1,75*E20,50*C20*E20))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,"",null,null,null,"SAF",5,"DP"]
[null,null,null,null,null,null,"",null,null,null,"RAF",7.5,"DT"]
[null,null,null,null,null,null,"",null,null,null,"CTF",10,"Other"]
[null,null,null,null,null,null,"",null,null,null,"CWP",15]
[null,null,null,null,null,null,"",null,null,null,"HWP",20]
[null,null,null,null,null,null,"",null,null,null,"WHP",25]
[null,null,null,null,null,null,{"$f":"IF(C28=\"\",\"\",IF(C28<=1,75*E28,50*C28*E28))","v":""},null,null,null,null,30]
["Total Requested Incentive",null,null,null,null,null,{"$f":"SUM(G19:H28)","v":0},null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,{"$f":"\"Version \"  &  'Version Tracking'!C4","v":"Version 14.2"},null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,75]
[]
[null,null,null,null,null,null,null,null,null,null,null,100]

{"sheet":"Inventory Instructions","index":15,"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":"Input Key","index":16,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Building Type",null,"Device Type","Measure code"]
[null,"Office",null,"Split System A/C","S"]
[null,"Retail",null,"Unitary A/C","U"]
[null,"School",null,"Split System Heat Pump","SH"]
[null,"University",null,"Unitary Heat Pump","UH"]
[null,"Religious Facility",null,"Packaged Terminal A/C","PTAC"]
[null,"Grocery",null,"Packaged Terminal Heat Pump","PTHP"]
[null,"Lodging"]
[null,"Industrial"]
[null,"Warehouse"]
[null,"Health Facility"]
[null,"Multifamily"]
[null,"Fitness/Recreation "]
[null,"Restaurant"]
[null,"Other"]

{"sheet":"Measure Code Summary","index":17,"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 # 14.2"}]
[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":"'Project Information'!D4","v":0},null,null,"Prepared By"]
[null,null,"Project Address",{"$f":"'Project Information'!D5","v":0},null,null,"Contact Person",{"$f":"'Project Information'!D16","v":0}]
[null,null,"City",{"$f":"'Project Information'!D6","v":0},null,null,"Phone",{"$f":"'Project Information'!D17","v":0}]
[null,null,"ZIP",{"$f":"'Project Information'!L6","v":0},null,null,"Email",{"$f":"'Project Information'!L17","v":0}]
[]
[]
[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('HVAC Unitary'!D23=\"\",\"\",'HVAC Unitary'!D23)","v":""},{"$f":"IF('HVAC Unitary'!E23=\"\",\"\",'HVAC Unitary'!E23)","v":""},{"$f":"IF('HVAC Unitary'!F23=\"\",\"\",'HVAC Unitary'!F23)","v":""},{"$f":"IF('HVAC Unitary'!G23=\"\",\"\",'HVAC Unitary'!G23)","v":""},{"$f":"IF('HVAC Unitary'!L23=\"\",\"\",'HVAC Unitary'!L23)","v":""},{"$f":"IF('HVAC Unitary'!K23=\"\",\"\",'HVAC Unitary'!K23)","v":""},{"$f":"IF('HVAC Unitary'!M23=\"\",\"\",'HVAC Unitary'!M23)","v":""},{"$f":"IF(OR(K20=\"\",E20=\"\"),\"\",K20/E20/J20)","v":""},{"$f":"IF('HVAC Unitary'!N23=\"\",\"\",'HVAC Unitary'!N23)","v":""},{"$f":"IF('HVAC Unitary'!O23=\"\",\"\",'HVAC Unitary'!O23)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D24=\"\",\"\",'HVAC Unitary'!D24)","v":""},{"$f":"IF('HVAC Unitary'!E24=\"\",\"\",'HVAC Unitary'!E24)","v":""},{"$f":"IF('HVAC Unitary'!F24=\"\",\"\",'HVAC Unitary'!F24)","v":""},{"$f":"IF('HVAC Unitary'!G24=\"\",\"\",'HVAC Unitary'!G24)","v":""},{"$f":"IF('HVAC Unitary'!L24=\"\",\"\",'HVAC Unitary'!L24)","v":""},{"$f":"IF('HVAC Unitary'!K24=\"\",\"\",'HVAC Unitary'!K24)","v":""},{"$f":"IF('HVAC Unitary'!M24=\"\",\"\",'HVAC Unitary'!M24)","v":""},{"$f":"IF(OR(K21=\"\",E21=\"\"),\"\",K21/E21/J21)","v":""},{"$f":"IF('HVAC Unitary'!N24=\"\",\"\",'HVAC Unitary'!N24)","v":""},{"$f":"IF('HVAC Unitary'!O24=\"\",\"\",'HVAC Unitary'!O24)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D25=\"\",\"\",'HVAC Unitary'!D25)","v":""},{"$f":"IF('HVAC Unitary'!E25=\"\",\"\",'HVAC Unitary'!E25)","v":""},{"$f":"IF('HVAC Unitary'!F25=\"\",\"\",'HVAC Unitary'!F25)","v":""},{"$f":"IF('HVAC Unitary'!G25=\"\",\"\",'HVAC Unitary'!G25)","v":""},{"$f":"IF('HVAC Unitary'!L25=\"\",\"\",'HVAC Unitary'!L25)","v":""},{"$f":"IF('HVAC Unitary'!K25=\"\",\"\",'HVAC Unitary'!K25)","v":""},{"$f":"IF('HVAC Unitary'!M25=\"\",\"\",'HVAC Unitary'!M25)","v":""},"",{"$f":"IF('HVAC Unitary'!N25=\"\",\"\",'HVAC Unitary'!N25)","v":""},{"$f":"IF('HVAC Unitary'!O25=\"\",\"\",'HVAC Unitary'!O25)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D26=\"\",\"\",'HVAC Unitary'!D26)","v":""},{"$f":"IF('HVAC Unitary'!E26=\"\",\"\",'HVAC Unitary'!E26)","v":""},{"$f":"IF('HVAC Unitary'!F26=\"\",\"\",'HVAC Unitary'!F26)","v":""},{"$f":"IF('HVAC Unitary'!G26=\"\",\"\",'HVAC Unitary'!G26)","v":""},{"$f":"IF('HVAC Unitary'!L26=\"\",\"\",'HVAC Unitary'!L26)","v":""},{"$f":"IF('HVAC Unitary'!K26=\"\",\"\",'HVAC Unitary'!K26)","v":""},{"$f":"IF('HVAC Unitary'!M26=\"\",\"\",'HVAC Unitary'!M26)","v":""},"",{"$f":"IF('HVAC Unitary'!N26=\"\",\"\",'HVAC Unitary'!N26)","v":""},{"$f":"IF('HVAC Unitary'!O26=\"\",\"\",'HVAC Unitary'!O26)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D27=\"\",\"\",'HVAC Unitary'!D27)","v":""},{"$f":"IF('HVAC Unitary'!E27=\"\",\"\",'HVAC Unitary'!E27)","v":""},{"$f":"IF('HVAC Unitary'!F27=\"\",\"\",'HVAC Unitary'!F27)","v":""},{"$f":"IF('HVAC Unitary'!G27=\"\",\"\",'HVAC Unitary'!G27)","v":""},{"$f":"IF('HVAC Unitary'!L27=\"\",\"\",'HVAC Unitary'!L27)","v":""},{"$f":"IF('HVAC Unitary'!K27=\"\",\"\",'HVAC Unitary'!K27)","v":""},{"$f":"IF('HVAC Unitary'!M27=\"\",\"\",'HVAC Unitary'!M27)","v":""},"",{"$f":"IF('HVAC Unitary'!N27=\"\",\"\",'HVAC Unitary'!N27)","v":""},{"$f":"IF('HVAC Unitary'!O27=\"\",\"\",'HVAC Unitary'!O27)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D28=\"\",\"\",'HVAC Unitary'!D28)","v":""},{"$f":"IF('HVAC Unitary'!E28=\"\",\"\",'HVAC Unitary'!E28)","v":""},{"$f":"IF('HVAC Unitary'!F28=\"\",\"\",'HVAC Unitary'!F28)","v":""},{"$f":"IF('HVAC Unitary'!G28=\"\",\"\",'HVAC Unitary'!G28)","v":""},{"$f":"IF('HVAC Unitary'!L28=\"\",\"\",'HVAC Unitary'!L28)","v":""},{"$f":"IF('HVAC Unitary'!K28=\"\",\"\",'HVAC Unitary'!K28)","v":""},{"$f":"IF('HVAC Unitary'!M28=\"\",\"\",'HVAC Unitary'!M28)","v":""},"",{"$f":"IF('HVAC Unitary'!N28=\"\",\"\",'HVAC Unitary'!N28)","v":""},{"$f":"IF('HVAC Unitary'!O28=\"\",\"\",'HVAC Unitary'!O28)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D29=\"\",\"\",'HVAC Unitary'!D29)","v":""},{"$f":"IF('HVAC Unitary'!E29=\"\",\"\",'HVAC Unitary'!E29)","v":""},{"$f":"IF('HVAC Unitary'!F29=\"\",\"\",'HVAC Unitary'!F29)","v":""},{"$f":"IF('HVAC Unitary'!G29=\"\",\"\",'HVAC Unitary'!G29)","v":""},{"$f":"IF('HVAC Unitary'!L29=\"\",\"\",'HVAC Unitary'!L29)","v":""},{"$f":"IF('HVAC Unitary'!K29=\"\",\"\",'HVAC Unitary'!K29)","v":""},{"$f":"IF('HVAC Unitary'!M29=\"\",\"\",'HVAC Unitary'!M29)","v":""},"",{"$f":"IF('HVAC Unitary'!N29=\"\",\"\",'HVAC Unitary'!N29)","v":""},{"$f":"IF('HVAC Unitary'!O29=\"\",\"\",'HVAC Unitary'!O29)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D30=\"\",\"\",'HVAC Unitary'!D30)","v":""},{"$f":"IF('HVAC Unitary'!E30=\"\",\"\",'HVAC Unitary'!E30)","v":""},{"$f":"IF('HVAC Unitary'!F30=\"\",\"\",'HVAC Unitary'!F30)","v":""},{"$f":"IF('HVAC Unitary'!G30=\"\",\"\",'HVAC Unitary'!G30)","v":""},{"$f":"IF('HVAC Unitary'!L30=\"\",\"\",'HVAC Unitary'!L30)","v":""},{"$f":"IF('HVAC Unitary'!K30=\"\",\"\",'HVAC Unitary'!K30)","v":""},{"$f":"IF('HVAC Unitary'!M30=\"\",\"\",'HVAC Unitary'!M30)","v":""},"",{"$f":"IF('HVAC Unitary'!N30=\"\",\"\",'HVAC Unitary'!N30)","v":""},{"$f":"IF('HVAC Unitary'!O30=\"\",\"\",'HVAC Unitary'!O30)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D31=\"\",\"\",'HVAC Unitary'!D31)","v":""},{"$f":"IF('HVAC Unitary'!E31=\"\",\"\",'HVAC Unitary'!E31)","v":""},{"$f":"IF('HVAC Unitary'!F31=\"\",\"\",'HVAC Unitary'!F31)","v":""},{"$f":"IF('HVAC Unitary'!G31=\"\",\"\",'HVAC Unitary'!G31)","v":""},{"$f":"IF('HVAC Unitary'!L31=\"\",\"\",'HVAC Unitary'!L31)","v":""},{"$f":"IF('HVAC Unitary'!K31=\"\",\"\",'HVAC Unitary'!K31)","v":""},{"$f":"IF('HVAC Unitary'!M31=\"\",\"\",'HVAC Unitary'!M31)","v":""},"",{"$f":"IF('HVAC Unitary'!N31=\"\",\"\",'HVAC Unitary'!N31)","v":""},{"$f":"IF('HVAC Unitary'!O31=\"\",\"\",'HVAC Unitary'!O31)","v":0}]
[null,{"$f":"IF('HVAC Unitary'!D32=\"\",\"\",'HVAC Unitary'!D32)","v":""},{"$f":"IF('HVAC Unitary'!E32=\"\",\"\",'HVAC Unitary'!E32)","v":""},{"$f":"IF('HVAC Unitary'!F32=\"\",\"\",'HVAC Unitary'!F32)","v":""},{"$f":"IF('HVAC Unitary'!G32=\"\",\"\",'HVAC Unitary'!G32)","v":""},{"$f":"IF('HVAC Unitary'!L32=\"\",\"\",'HVAC Unitary'!L32)","v":""},{"$f":"IF('HVAC Unitary'!K32=\"\",\"\",'HVAC Unitary'!K32)","v":""},{"$f":"IF('HVAC Unitary'!M32=\"\",\"\",'HVAC Unitary'!M32)","v":""},"",{"$f":"IF('HVAC Unitary'!N32=\"\",\"\",'HVAC Unitary'!N32)","v":""},{"$f":"IF('HVAC Unitary'!O32=\"\",\"\",'HVAC Unitary'!O32)","v":0}]
[null,null,null,null,null,null,null,null,"Total Pre-approved Incentive",null,{"$f":"SUM(K20:K29)","v":0}]

{"sheet":"Version Tracking","index":18,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B49991<>\"\"),B1:B49991)","v":"14.2"}]
[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"]
[null,10.199999999999999,"Updated Cap, and adjusted incentive ammounts","2021-02-16","JSE"]
[null,10.3,"fixed incentive calculator ","2021-03-19","JSE"]
[null,10.3,"I renamed the Input tab to HVAC Unitary, and moved the incentive guidance to this tab.  This will allow input data to nom longer need to be transcribed.\nAlso removed many of the superflous fields on the AEG import tab","3/99/2021","mds"]
[null,10.4,"Fixed incentives for Heatpump up dated PY11 Table","2021-03-26","JSE"]
[null,10.5,"Sixed incentive for VFDs < 1HP","2021-03-31"]
[null,10.6,"Added Cool Roof calculator tab","2021-07-27","Sean Creel"]
[null,10.7,"Added cool roof savings calculations and AEG import for cool roof and window film. ","2022-03-22","JME"]
[null,10.8,"Updated AEG import to be total savings and incentives and not based on a per unit amount /\nUpdated Eligibility language on T&Cs and added w-9 and invoicing requirements","2022-09-15","JME / LS"]
[null,10.9,"Updated efficiency requirements on HVAC application. Added model request on VFD/Cool Roof/Window Film tabs. \nReworked HVAC measures to be calculated savings and incorporate new SEER ratings","2023-03-22","LS / JME"]
[null,"10.10","Fixed formula for HSPF conversion to COP on min requirements","2023-05-21","JME"]
[null,"10.11","Fixed proposed PTHP heating efficiency calcs","2023-08-09","JME"]
[null,"10.12","Updated Email and Website. Updated Cool Roof requirements. Fixed incentive calculation error in table on HVAC unitary tab","2023-09-14","LS / JME"]
[null,"14.1","Updated the calculator to reflect latest  TRM changes","2023-11-20","Thomaskutty Jaison"]
[null,"14.2","Fixed email and radio buttons. ","2024-02-16","LS"]

{"sheet":"Old Summary","index":19,"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 # 14.2"}]
[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('HVAC Unitary'!D11=\"\",\"\",'HVAC Unitary'!D11)","v":""},null,null,"Prepared By",{"$f":"IF('HVAC Unitary'!G11=\"\",\"\",'HVAC Unitary'!G11)","v":""}]
[null,null,"Project Address",{"$f":"IF('HVAC Unitary'!D12=\"\",\"\",'HVAC Unitary'!D12)","v":""},null,null,"Contact Person",{"$f":"IF('HVAC Unitary'!G12=\"\",\"\",'HVAC Unitary'!G12)","v":""}]
[null,null,"City",{"$f":"IF('HVAC Unitary'!D13=\"\",\"\",'HVAC Unitary'!D13)","v":""},null,null,"Phone",{"$f":"IF('HVAC Unitary'!G13=\"\",\"\",'HVAC Unitary'!G13)","v":""}]
[null,null,"ZIP",{"$f":"IF('HVAC Unitary'!D14=\"\",\"\",'HVAC Unitary'!D14)","v":""},null,null,"Email",{"$f":"IF('HVAC Unitary'!G14=\"\",\"\",'HVAC Unitary'!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('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B22,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$20 / ton","15.0 SEER and 12.5 EER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B22,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B22,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B22,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[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('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B24,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$20 / ton","12.0 EER and 12.2 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B24,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B24,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B24,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,20,63,"Split System and Single Package","10.5 EER and 10.6 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B25,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$20 / ton","10.85 EER and 11.0 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B25,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B25,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B25,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,63,null,"Split System and Single Package","9.7 EER and 9.8 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B26,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$10 / ton","10.2 EER and 10.3 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B26,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$15 / ton",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Unitary_\"&$B26,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Unitary_\"&$B26,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[]
[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('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B29,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B29,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B29,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B29,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,5.4,11.25,"Split System and Single Package","14.0 EER and 14.2 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B30,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B30,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B30,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B30,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,11.25,null,"Split System and Single Package","14.0 EER and 14.2 IEER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B31,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$30 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B31,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_Water_\"&$B31,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_Water_\"&$B31,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[]
[null,"Packaged Terminal Air Conditioner (PTAC)"]
[null,0,0.75,"Single Package","11.8 EER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B34,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$10 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B34,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B34,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B34,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,0.75,1,null,"11.0 EER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B35,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$15 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B35,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B35,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B35,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,1,null,null,"10.3 EER",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B36,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$20 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B36,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTAC_\"&$B36,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTAC_\"&$B36,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[]
[null,"Packaged Terminal Heat Pump (PTHP)"]
[null,0,0.75,"Single Package","11.5 EER and 3.3 COP",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B39,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$10 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B39,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B39,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B39,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,0.75,1,null,"10.8 EER and 3.2 COP",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B40,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$15 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B40,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B40,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B40,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,1,null,null,"10.1 EER and 3.1 COP",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B41,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"$20 / ton","N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B41,'HVAC Unitary'!$N$23:$N$32)","v":{"$error":"#REF!"}},"N/A",{"$f":"SUMIF('HVAC Unitary'!#REF!,\"Tier 1_PTHP_\"&$B41,'HVAC Unitary'!$S$23:$S$32)+SUMIF('HVAC Unitary'!#REF!,\"Tier 2_PTHP_\"&$B41,'HVAC Unitary'!$S$23:$S$32)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Total Incentive",{"$f":"SUM(K22:K41)","v":{"$error":"#REF!"}}]

{"sheet":"AEG Import","index":20,"n_rows":22,"n_cols":30,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Measure #","Import?","building_type_sel","EER","SEER","COP","EER_2","SEER_2","HSPF_2","Full_Load","Half_Load","Base_incentive_Per_Unit","Base_Total_incentive_Per_Unit","Performance_Incentive_Per_Unit","Performance_Total_Incentive_Per_Unit","Elec_Util_cust_Incentive","Incentive_Per_Unit","kW_Impact","kW_Summer_Gross","kWh_Impact","Manufacturer","Measure_Life","Model","name","quantity","Tons","SUB_COMPONENT_1","SUB_COMPONENT_2","Cool Roof Location","SHGC"]
[{"$f":"VLOOKUP(X2,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(P2=0,\"No\",\"Yes\")","v":"No"},{"$f":"'HVAC Unitary'!C23","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!K23,\"\")=0,\"\",IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!K23,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!L23,\"\")=0,\"\",IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!L23,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!M23,\"\")=0,\"\",IF(OR(HVACCalcs!$K5=\"Old\",HVACCalcs!$K5=\"\"),'HVAC Unitary'!M23,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!K23,\"\")=0,\"\",IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!K23,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!L23,\"\")=0,\"\",IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!L23,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!M23,\"\")=0,\"\",IF(HVACCalcs!$K5=\"New\",'HVAC Unitary'!M23,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S23/IF(Y2=0,1,Y2)),\" \",'HVAC Unitary'!S23/IF(Y2=0,1,Y2))","v":0},{"$f":"'HVAC Unitary'!T23","v":0},{"$f":"S2","v":0},{"$f":"'HVAC Unitary'!R23/IF(Y2=0,1,Y2)","v":0},{"$f":"'HVAC Unitary'!Q23/IF(Y2=0,1,Y2)","v":0},{"$f":"'HVAC Unitary'!E23","v":0},15,{"$f":"'HVAC Unitary'!F23","v":0},{"$f":"'HVAC Unitary'!D23","v":0},{"$f":"'HVAC Unitary'!N23","v":0},{"$f":"'HVAC Unitary'!G23","v":0}]
[{"$f":"VLOOKUP(X3,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(P3=0,\"No\",\"Yes\")","v":"No"},{"$f":"'HVAC Unitary'!C24","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!K24,\"\")=0,\"\",IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!K24,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!L24,\"\")=0,\"\",IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!L24,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!M24,\"\")=0,\"\",IF(OR(HVACCalcs!$K6=\"Old\",HVACCalcs!$K6=\"\"),'HVAC Unitary'!M24,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!K24,\"\")=0,\"\",IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!K24,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!L24,\"\")=0,\"\",IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!L24,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!M24,\"\")=0,\"\",IF(HVACCalcs!$K6=\"New\",'HVAC Unitary'!M24,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S24/IF(Y3=0,1,Y3)),\" \",'HVAC Unitary'!S24/IF(Y3=0,1,Y3))","v":0},{"$f":"'HVAC Unitary'!T24","v":0},0,{"$f":"'HVAC Unitary'!R24/IF(Y3=0,1,Y3)","v":0},{"$f":"'HVAC Unitary'!Q24/IF(Y3=0,1,Y3)","v":0},{"$f":"'HVAC Unitary'!E24","v":0},15,{"$f":"'HVAC Unitary'!F24","v":0},{"$f":"'HVAC Unitary'!D24","v":0},{"$f":"'HVAC Unitary'!N24","v":0},{"$f":"'HVAC Unitary'!G24","v":0}]
[{"$f":"VLOOKUP(X4,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C25","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!K25,\"\")=0,\"\",IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!K25,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!L25,\"\")=0,\"\",IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!L25,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!M25,\"\")=0,\"\",IF(OR(HVACCalcs!$K7=\"Old\",HVACCalcs!$K7=\"\"),'HVAC Unitary'!M25,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!K25,\"\")=0,\"\",IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!K25,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!L25,\"\")=0,\"\",IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!L25,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!M25,\"\")=0,\"\",IF(HVACCalcs!$K7=\"New\",'HVAC Unitary'!M25,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S25/IF(Y4=0,1,Y4)),\" \",'HVAC Unitary'!S25/IF(Y4=0,1,Y4))","v":0},{"$f":"'HVAC Unitary'!T25","v":0},0,{"$f":"'HVAC Unitary'!R25/IF(Y4=0,1,Y4)","v":0},{"$f":"'HVAC Unitary'!Q25/IF(Y4=0,1,Y4)","v":0},{"$f":"'HVAC Unitary'!E25","v":0},15,{"$f":"'HVAC Unitary'!F25","v":0},{"$f":"'HVAC Unitary'!D25","v":0},{"$f":"'HVAC Unitary'!N25","v":0},{"$f":"'HVAC Unitary'!G25","v":0}]
[{"$f":"VLOOKUP(X5,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C26","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!K26,\"\")=0,\"\",IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!K26,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!L26,\"\")=0,\"\",IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!L26,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!M26,\"\")=0,\"\",IF(OR(HVACCalcs!$K8=\"Old\",HVACCalcs!$K8=\"\"),'HVAC Unitary'!M26,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!K26,\"\")=0,\"\",IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!K26,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!L26,\"\")=0,\"\",IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!L26,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!M26,\"\")=0,\"\",IF(HVACCalcs!$K8=\"New\",'HVAC Unitary'!M26,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S26/IF(Y5=0,1,Y5)),\" \",'HVAC Unitary'!S26/IF(Y5=0,1,Y5))","v":0},{"$f":"'HVAC Unitary'!T26","v":0},0,{"$f":"'HVAC Unitary'!R26/IF(Y5=0,1,Y5)","v":0},{"$f":"'HVAC Unitary'!Q26/IF(Y5=0,1,Y5)","v":0},{"$f":"'HVAC Unitary'!E26","v":0},15,{"$f":"'HVAC Unitary'!F26","v":0},{"$f":"'HVAC Unitary'!D26","v":0},{"$f":"'HVAC Unitary'!N26","v":0},{"$f":"'HVAC Unitary'!G26","v":0}]
[{"$f":"VLOOKUP(X6,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C27","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!K27,\"\")=0,\"\",IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!K27,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!L27,\"\")=0,\"\",IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!L27,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!M27,\"\")=0,\"\",IF(OR(HVACCalcs!$K9=\"Old\",HVACCalcs!$K9=\"\"),'HVAC Unitary'!M27,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!K27,\"\")=0,\"\",IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!K27,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!L27,\"\")=0,\"\",IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!L27,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!M27,\"\")=0,\"\",IF(HVACCalcs!$K9=\"New\",'HVAC Unitary'!M27,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S27/IF(Y6=0,1,Y6)),\" \",'HVAC Unitary'!S27/IF(Y6=0,1,Y6))","v":0},{"$f":"'HVAC Unitary'!T27","v":0},0,{"$f":"'HVAC Unitary'!R27/IF(Y6=0,1,Y6)","v":0},{"$f":"'HVAC Unitary'!Q27/IF(Y6=0,1,Y6)","v":0},{"$f":"'HVAC Unitary'!E27","v":0},15,{"$f":"'HVAC Unitary'!F27","v":0},{"$f":"'HVAC Unitary'!D27","v":0},{"$f":"'HVAC Unitary'!N27","v":0},{"$f":"'HVAC Unitary'!G27","v":0}]
[{"$f":"VLOOKUP(X7,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C28","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!K28,\"\")=0,\"\",IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!K28,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!L28,\"\")=0,\"\",IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!L28,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!M28,\"\")=0,\"\",IF(OR(HVACCalcs!$K10=\"Old\",HVACCalcs!$K10=\"\"),'HVAC Unitary'!M28,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!K28,\"\")=0,\"\",IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!K28,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!L28,\"\")=0,\"\",IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!L28,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!M28,\"\")=0,\"\",IF(HVACCalcs!$K10=\"New\",'HVAC Unitary'!M28,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S28/IF(Y7=0,1,Y7)),\" \",'HVAC Unitary'!S28/IF(Y7=0,1,Y7))","v":0},{"$f":"'HVAC Unitary'!T28","v":0},0,{"$f":"'HVAC Unitary'!R28/IF(Y7=0,1,Y7)","v":0},{"$f":"'HVAC Unitary'!Q28/IF(Y7=0,1,Y7)","v":0},{"$f":"'HVAC Unitary'!E28","v":0},15,{"$f":"'HVAC Unitary'!F28","v":0},{"$f":"'HVAC Unitary'!D28","v":0},{"$f":"'HVAC Unitary'!N28","v":0},{"$f":"'HVAC Unitary'!G28","v":0}]
[{"$f":"VLOOKUP(X8,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C29","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!K29,\"\")=0,\"\",IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!K29,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!L29,\"\")=0,\"\",IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!L29,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!M29,\"\")=0,\"\",IF(OR(HVACCalcs!$K11=\"Old\",HVACCalcs!$K11=\"\"),'HVAC Unitary'!M29,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!K29,\"\")=0,\"\",IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!K29,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!L29,\"\")=0,\"\",IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!L29,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!M29,\"\")=0,\"\",IF(HVACCalcs!$K11=\"New\",'HVAC Unitary'!M29,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S29/IF(Y8=0,1,Y8)),\" \",'HVAC Unitary'!S29/IF(Y8=0,1,Y8))","v":0},{"$f":"'HVAC Unitary'!T29","v":0},0,{"$f":"'HVAC Unitary'!R29/IF(Y8=0,1,Y8)","v":0},{"$f":"'HVAC Unitary'!Q29/IF(Y8=0,1,Y8)","v":0},{"$f":"'HVAC Unitary'!E29","v":0},15,{"$f":"'HVAC Unitary'!F29","v":0},{"$f":"'HVAC Unitary'!D29","v":0},{"$f":"'HVAC Unitary'!N29","v":0},{"$f":"'HVAC Unitary'!G29","v":0}]
[{"$f":"VLOOKUP(X9,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C30","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!K30,\"\")=0,\"\",IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!K30,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!L30,\"\")=0,\"\",IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!L30,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!M30,\"\")=0,\"\",IF(OR(HVACCalcs!$K12=\"Old\",HVACCalcs!$K12=\"\"),'HVAC Unitary'!M30,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!K30,\"\")=0,\"\",IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!K30,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!L30,\"\")=0,\"\",IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!L30,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!M30,\"\")=0,\"\",IF(HVACCalcs!$K12=\"New\",'HVAC Unitary'!M30,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S30/IF(Y9=0,1,Y9)),\" \",'HVAC Unitary'!S30/IF(Y9=0,1,Y9))","v":0},{"$f":"'HVAC Unitary'!T30","v":0},0,{"$f":"'HVAC Unitary'!R30/IF(Y9=0,1,Y9)","v":0},{"$f":"'HVAC Unitary'!Q30/IF(Y9=0,1,Y9)","v":0},{"$f":"'HVAC Unitary'!E30","v":0},15,{"$f":"'HVAC Unitary'!F30","v":0},{"$f":"'HVAC Unitary'!D30","v":0},{"$f":"'HVAC Unitary'!N30","v":0},{"$f":"'HVAC Unitary'!G30","v":0}]
[{"$f":"VLOOKUP(X10,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C31","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!K31,\"\")=0,\"\",IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!K31,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!L31,\"\")=0,\"\",IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!L31,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!M31,\"\")=0,\"\",IF(OR(HVACCalcs!$K13=\"Old\",HVACCalcs!$K13=\"\"),'HVAC Unitary'!M31,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!K31,\"\")=0,\"\",IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!K31,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!L31,\"\")=0,\"\",IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!L31,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!M31,\"\")=0,\"\",IF(HVACCalcs!$K13=\"New\",'HVAC Unitary'!M31,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S31/IF(Y10=0,1,Y10)),\" \",'HVAC Unitary'!S31/IF(Y10=0,1,Y10))","v":0},{"$f":"'HVAC Unitary'!T31","v":0},0,{"$f":"'HVAC Unitary'!R31/IF(Y10=0,1,Y10)","v":0},{"$f":"'HVAC Unitary'!Q31/IF(Y10=0,1,Y10)","v":0},{"$f":"'HVAC Unitary'!E31","v":0},15,{"$f":"'HVAC Unitary'!F31","v":0},{"$f":"'HVAC Unitary'!D31","v":0},{"$f":"'HVAC Unitary'!N31","v":0},{"$f":"'HVAC Unitary'!G31","v":0}]
[{"$f":"VLOOKUP(X11,Validation!$C$3:$D$9,2,FALSE)","v":{"$error":"#N/A"}},"No",{"$f":"'HVAC Unitary'!C32","v":0},{"$f":"IF(IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!K32,\"\")=0,\"\",IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!K32,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!L32,\"\")=0,\"\",IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!L32,\"\"))","v":""},{"$f":"IF(IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!M32,\"\")=0,\"\",IF(OR(HVACCalcs!$K14=\"Old\",HVACCalcs!$K14=\"\"),'HVAC Unitary'!M32,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!K32,\"\")=0,\"\",IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!K32,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!L32,\"\")=0,\"\",IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!L32,\"\"))","v":""},{"$f":"IF(IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!M32,\"\")=0,\"\",IF(HVACCalcs!$K14=\"New\",'HVAC Unitary'!M32,\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR('HVAC Unitary'!S32/IF(Y11=0,1,Y11)),\" \",'HVAC Unitary'!S32/IF(Y11=0,1,Y11))","v":0},{"$f":"'HVAC Unitary'!T32","v":0},0,{"$f":"'HVAC Unitary'!R32/IF(Y11=0,1,Y11)","v":0},{"$f":"'HVAC Unitary'!Q32/IF(Y11=0,1,Y11)","v":0},{"$f":"'HVAC Unitary'!E32","v":0},15,{"$f":"'HVAC Unitary'!F32","v":0},{"$f":"'HVAC Unitary'!D32","v":0},{"$f":"'HVAC Unitary'!N32","v":0},{"$f":"'HVAC Unitary'!G32","v":0}]
[null,"No","Cool Roof Measures"]
["CR",{"$f":"IF(OR('Cool Roof'!H5=0,'Cool Roof'!H5=\"Fill in zip code in cell L6 on Project Information tab\"),\"No\",\"Yes\")","v":"No"},{"$f":"'Cool Roof'!A5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q13","v":0.1},{"$f":"'Cool Roof'!G5","v":0.1},{"$f":"'Cool Roof'!Q5","v":0},{"$f":"R13","v":0},{"$f":"'Cool Roof'!P5","v":0},{"$f":"'Cool Roof'!B5","v":0},{"$f":"IF('Cool Roof'!C5=\"New Roof\",15,10)","v":10},null,"Cool Roof",{"$f":"'Cool Roof'!F5","v":0},null,{"$f":"'Cool Roof'!D5","v":0},{"$f":"'Cool Roof'!E5","v":0},{"$f":"'Cool Roof'!K5","v":""}]
["CR",{"$f":"IF('Cool Roof'!H6=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Cool Roof'!A6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q14","v":0.1},{"$f":"'Cool Roof'!G6","v":0.1},{"$f":"'Cool Roof'!Q6","v":0},{"$f":"R14","v":0},{"$f":"'Cool Roof'!P6","v":0},{"$f":"'Cool Roof'!B6","v":0},{"$f":"IF('Cool Roof'!C6=\"New Roof\",15,10)","v":10},null,"Cool Roof",{"$f":"'Cool Roof'!F6","v":0},null,{"$f":"'Cool Roof'!D6","v":0},{"$f":"'Cool Roof'!E6","v":0},{"$f":"'Cool Roof'!K6","v":""}]
["CR",{"$f":"IF('Cool Roof'!H7=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Cool Roof'!A7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"'Cool Roof'!G7","v":0.1},{"$f":"'Cool Roof'!Q7","v":0},0,{"$f":"'Cool Roof'!P7","v":0},{"$f":"'Cool Roof'!B7","v":0},{"$f":"IF('Cool Roof'!C7=\"New Roof\",15,10)","v":10},null,"Cool Roof",{"$f":"'Cool Roof'!F7","v":0},null,{"$f":"'Cool Roof'!D7","v":0},{"$f":"'Cool Roof'!E7","v":0},{"$f":"'Cool Roof'!K7","v":""}]
["CR",{"$f":"IF('Cool Roof'!H8=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Cool Roof'!A8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"'Cool Roof'!G8","v":0.1},{"$f":"'Cool Roof'!Q8","v":0},0,{"$f":"'Cool Roof'!P8","v":0},{"$f":"'Cool Roof'!B8","v":0},{"$f":"IF('Cool Roof'!C8=\"New Roof\",15,10)","v":10},null,"Cool Roof",{"$f":"'Cool Roof'!F8","v":0},null,{"$f":"'Cool Roof'!D8","v":0},{"$f":"'Cool Roof'!E8","v":0},{"$f":"'Cool Roof'!K8","v":""}]
[null,"No","Window Film Measures"]
["WF",{"$f":"IF('Window Film'!I5=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Window Film'!A5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18","v":1},{"$f":"'Window Film'!L5","v":1},{"$f":"'Window Film'!O5","v":0},{"$f":"R18","v":0},{"$f":"'Window Film'!N5","v":0},null,15,null,"Window Film",{"$f":"'Window Film'!C5","v":0},null,null,null,null,{"$f":"'Window Film'!F5","v":0}]
["WF",{"$f":"IF('Window Film'!I6=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Window Film'!A6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Window Film'!L6","v":1},{"$f":"'Window Film'!O6","v":0},{"$f":"R19","v":0},{"$f":"'Window Film'!N6","v":0},null,15,null,"Window Film",{"$f":"'Window Film'!C6","v":0},null,null,null,null,{"$f":"'Window Film'!F6","v":0}]
["WF",{"$f":"IF('Window Film'!I7=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Window Film'!A7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Window Film'!L7","v":1},{"$f":"'Window Film'!O7","v":0},0,{"$f":"'Window Film'!N7","v":0},null,15,null,"Window Film",{"$f":"'Window Film'!C7","v":0},null,null,null,null,{"$f":"'Window Film'!F7","v":0}]
["WF",{"$f":"IF('Window Film'!I8=0,\"No\",\"Yes\")","v":"No"},{"$f":"'Window Film'!A8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Window Film'!L8","v":1},{"$f":"'Window Film'!O8","v":0},0,{"$f":"'Window Film'!N8","v":0},null,15,null,"Window Film",{"$f":"'Window Film'!C8","v":0},null,null,null,null,{"$f":"'Window Film'!F8","v":0}]
[null,"No","End"]