{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Form Instructions","Project Information","ProjectInfo Validation","Terms and Conditions","Input Instructions & Incentives","Compressed Air Measures","High Efficiency Motors","Motor Minimum Requirements","Motor Calcs","Motor Measure Validation","Compressed Air Calculations","Validation","Attribute Crosswalk","AEG Import","Version Tracking"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":44,"defined_names":1515,"comments":1,"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":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,2,26,17],[27,2,27,17],[22,2,22,17],[31,2,31,10],[31,11,31,18],[29,2,29,17],[19,1,19,18],[23,1,23,18],[25,2,25,17],[8,4,8,16],[8,17,8,18],[11,1,11,18],[13,1,13,8],[13,10,13,17],[14,1,14,8],[14,10,16,17],[15,1,15,8],[16,1,16,8],[21,2,21,17],[1,4,1,15],[2,6,2,14],[3,6,3,14],[4,6,4,14],[5,6,6,7],[5,9,6,10],[5,12,6,13],[5,3,6,4],[5,15,6,16]]}
[]
[null,null,null,null,"Compressed Air and Motors Application - Electronic Version"]
[null,null,null,null,null,null,"Dominion Energy South Carolina, Inc."]
[null,null,null,null,null,null,"Use Buttons Below to Navigate the Application"]
[]
[null,null,null,"Project Information & Signatures",null,null,"Compressed Air Measures",null,null,"High Efficiency Motors",null,null,"Input Instructions",null,null,"Terms & \nConditions"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]
[]
[null,"Application and Instructions"]
[null,"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.\n\nFor each program year (December 1–November 30), EnergyWise for Your Business incentive payments are capped per Customer Federal tax ID number at $150,000.00 per Project type. Details of the program, including incentive levels and technical requirements, are subject to change without prior notice. \n\nYou may go to www.DominionEnergy.com/ForYourBizSC to get the most current program information, or you may call 877-784-7234."]
[]
[null,"Eligible Participants",null,null,null,null,null,null,null,null,"Pre-Approval Requirements "]
[null,"EnergyWise for Your Business is open to all non-residential electric customers within our service territory, except for customers eligible for Rate 23 and certain large retail customers who have elected to opt out of the Demand Side Management (DSM) programs by notifying us in writing using the Opt-Out form.",null,null,null,null,null,null,null,null,"All projects require pre-approval prior to purchasing and installing any equipment except for projects with total incentives less than or equal to $5,000.\n\nAfter 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.\n\nFor projects not requiring pre-approval, the applicant can purchase and install the qualifying equipment and submit a completed application form and supporting documentation within 60 days of the equipment’s invoice date. "]
[null,"Eligible Equipment"]
[null,"Eligible equipment and incentive amounts are listed on the Compressed Air Measures & High Efficiency Motors tabs. Eligible equipment include Compressed Air Engineered Nozzles, Zero Loss Condensate Drains, and High Efficiency Motors. 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. "]
[]
[null,"Participation Instructions"]
[null,"Please review the program Terms and Conditions tab and the Input Instructions & Incentives tab for all program rules and requirements. Tabs colored Blue should be filled in by applicant.  "]
[null,"Step 1"]
[null,null,"Complete the Project Information tab and either the Compressed Air Measures or High Efficiency Motors tab. "]
[null,null,"Use the Input Instructions & Incentives tab as a reference for what supporting documentation is required."]
[null,"Submit completed applications to: EnergyExperts@SC.DominionEnergyAccount.com."]
[null,"Step 2"]
[null,null,"Applications will be processed and we will notify the customer in writing when the review is complete and funds have been reserved. Upon receipt\nof program pre-approval, customers may purchase and install their energy efficient equipment. We will notify customers if an inspection of the facility is necessary prior to pre-approval. "]
[null,null,"Eligible Compressed Air and High Effeciency Motors 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"]
[null,null,"Note: Any changes in the proposed equipment, quantities, or operating conditions must be approved by us prior to implementing."]
[null,"Step 3"]
[null,null,"Upon project completion, please return the signed customer acknowledgment at bottom of the pre-approval letter along with proof of purchase.   Dominion Energy South Carolina will notify customers if an inspection of the facility is necessary prior to final payment processing.\nProof of purchase must include an itemized invoice for all Energy Conservation Measures (ECMs) that may qualify for the EnergyWise for Your Business incentive. \nEach individual product or model number must include the corresponding costs and quantity. Labor and material must be listed separately when labor is included in the Overall Project Costs."]
[]
[null,"Questions","If you have questions, email EnergyExperts@SC.DominionEnergyAccount.com,",null,null,null,null,null,null,null,null,"visit  www.DominionEnergy.com/ForYourBizSC or call 877-784-7234."]

{"sheet":"Project Information","index":1,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[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],[7,0,7,14],[8,0,8,2],[8,3,8,14],[9,0,9,14],[10,0,10,2],[10,3,10,6],[10,8,10,9],[10,11,10,14],[5,0,5,2],[5,3,5,9],[5,13,5,14],[6,0,6,2],[6,3,6,9],[6,10,6,12],[6,13,6,14],[13,0,13,14],[14,0,14,14],[15,0,15,2],[15,3,15,14],[16,0,16,2],[16,3,16,14],[11,0,11,2],[11,3,11,9],[11,11,11,14],[12,0,12,2],[12,3,12,9],[12,11,12,14],[19,0,19,2],[19,3,19,9],[19,11,19,14],[20,0,20,14],[21,0,21,8],[21,9,21,14],[17,0,17,2],[17,3,17,6],[17,8,17,9],[17,11,17,14],[18,0,18,2],[18,3,18,9],[18,11,18,14],[26,0,26,2],[26,3,26,9],[26,11,26,14],[27,0,27,2],[27,3,27,9],[27,11,27,14],[22,0,22,14],[23,0,23,2],[23,3,23,14],[24,0,24,2],[24,3,24,14],[25,0,25,2],[25,3,25,6],[25,8,25,9],[25,11,25,14],[32,0,32,2],[32,3,32,9],[32,11,32,14],[33,0,33,5],[33,6,33,9],[33,10,33,12],[33,13,33,14],[28,0,28,14],[29,0,29,14],[30,0,30,2],[30,3,30,8],[31,0,31,2],[31,3,31,8],[31,9,31,12],[31,13,31,14],[41,0,41,14],[42,0,42,14],[43,0,43,14],[44,0,44,14],[45,0,45,14],[46,0,46,14],[34,1,34,14],[36,0,36,14],[37,0,37,14],[38,0,38,14],[39,0,39,14],[40,0,40,14],[49,1,49,14],[51,0,51,9],[50,1,50,14],[47,0,48,2],[47,3,48,7],[47,8,47,9],[47,10,47,14],[48,8,48,12],[48,13,48,14]]}
["Dominion Energy South Carolina, Inc. (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,false,null,null,null,null,null,null,null,"Electric Account # "]
["Street Address (of the facility)  ",null,false,null,null,null,null,null,null,null,"Customer Federal Tax ID "]
["City",null,false,null,null,null,null,null,null,null,"State   "," SC","Zip  "]
["Building Type (select one)",null,false,null,null,null,null,null,null,null,"Please indicate \"other\" type:"]
["CUSTOMER CONTACT INFORMATION",null,false]
["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,null,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,false,null,null,null,null,null,null,null,"Email"]
[]
["Please indicate if the Customer or Contractor should be primary point of contact for this project:"]
["ADDITIONAL 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,null,null,null,"Email "]
[]
["PAYMENT INFORMATION"]
["Payment to:"]
["Federal Tax ID # (of recipient)",null,null,null,null,null,null,null,null,"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 in the orange box to the right and check the box below)    ",null,null,null,null,null,null,null,null,null,"Date (XX/XX/XXXX)"]
[false,"I understand and intend that my electronic, PDF or facsimile signature be accepted and have the same force and effect as an original signature."]
[]
["Checklist & Acknowledgement"]
["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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Electric account number at top of page. Attach copy of electric bill.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["The most recent IRS Form W-9 completed for payment recipient. Physical signature is required on the W-9 Form. If payment is to a contractor, both the customer's and the contractor's W-9 Forms must be provided.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Supporting documentation to include manufacturer’s specification (cut) sheets for equipment included in this application.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Customer signature and proof of purchase (contractor receipts), at time of project completion. See Terms and Conditions for invoicing requirements.",null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["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."]
[]
["CUSTOMER ACKNOWLEDGMENT"]
["Authorized Representative  ",null,null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,null,null,"Date (XX/XX/XXXX)"]
[false,"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.\nNote: Upon completion of project, Dominion Energy South Carolina, Inc. customer of record must sign and return the written pre-approval letter and provide invoices for all energy efficiency measures."]
[false,"For Projects Not Requiring Pre-Approval ≤ $5,000 Incentive Only: \nBy 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.\nNote: Application must include supporting documentation and copy of invoice that is dated within 60 days before application date."]
["Dominion Energy South Carolina, Inc. Compressed Air and Motors Application - Electronic Version",null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"'Version Tracking'!C4","v":15.1}]

{"sheet":"ProjectInfo Validation","index":2,"n_rows":168,"n_cols":5,"rows_kept":168,"cut":false,"hidden":true,"merged":[]}
["Building Type","Primary Contact","Tax Status","Payment To","Cities"]
["Convenience/C-store","Customer","Corporation","Customer","Adams Run"]
["Fitness/Recreation","Contractor","LLC","Contractor","Aiken"]
["Grocery","Other (fill out below)","Partnership",null,"Allendale"]
["Health Facility",null,"Individual Propiertorship",null,"Arlington Estates"]
["Industrial",null,"Not for Profit",null,"Awendaw"]
["Lodging",null,null,null,"Bamberg"]
["Multifamily",null,null,null,"Barnwell"]
["Office",null,null,null,"Batesburg Leesville"]
["Religious Facility",null,null,null,"Bath"]
["Restaurant",null,null,null,"Beaufort"]
["Retail",null,null,null,"Beech Island"]
["School (K-12)",null,null,null,"Blackville"]
["School (University/College)",null,null,null,"Blair"]
["Warehouse",null,null,null,"Bluffton"]
["Other",null,null,null,"Blythewood"]
[null,null,null,null,"Bowman"]
[null,null,null,null,"Branchville"]
[null,null,null,null,"Brunson"]
[null,null,null,null,"Calhoun Falls"]
[null,null,null,null,"Cameron"]
[null,null,null,null,"Canadys"]
[null,null,null,null,"Carlisle"]
[null,null,null,null,"Cayce"]
[null,null,null,null,"Chapin"]
[null,null,null,null,"Chappels"]
[null,null,null,null,"Charleston"]
[null,null,null,null,"Childs"]
[null,null,null,null,"Clarks Hill"]
[null,null,null,null,"Columbia"]
[null,null,null,null,"Coosawatchie"]
[null,null,null,null,"Cope"]
[null,null,null,null,"Cottageville"]
[null,null,null,null,"Cross"]
[null,null,null,null,"Cross Roads"]
[null,null,null,null,"Daniel Island"]
[null,null,null,null,"Daufuskie Island"]
[null,null,null,null,"Denmark"]
[null,null,null,null,"Dorchester"]
[null,null,null,null,"Early Branch"]
[null,null,null,null,"East Lake Hills"]
[null,null,null,null,"Eastover"]
[null,null,null,null,"Edgefield"]
[null,null,null,null,"Edisto Island"]
[null,null,null,null,"Ehrhardt"]
[null,null,null,null,"Elgin"]
[null,null,null,null,"Elko"]
[null,null,null,null,"Elloree"]
[null,null,null,null,"Estill"]
[null,null,null,null,"Eutawville"]
[null,null,null,null,"Fairfax"]
[null,null,null,null,"Folly Beach"]
[null,null,null,null,"Fort Motte"]
[null,null,null,null,"Furman"]
[null,null,null,null,"Garnett"]
[null,null,null,null,"Gaston"]
[null,null,null,null,"Gifford"]
[null,null,null,null,"Gilbert"]
[null,null,null,null,"Gloverville"]
[null,null,null,null,"Goose Creek"]
[null,null,null,null,"Graniteville"]
[null,null,null,null,"Grays Hill"]
[null,null,null,null,"Green Pond"]
[null,null,null,null,"Hampton"]
[null,null,null,null,"Hanahan"]
[null,null,null,null,"Hardeeville"]
[null,null,null,null,"Harleyville"]
[null,null,null,null,"Hilda"]
[null,null,null,null,"Holly Hill"]
[null,null,null,null,"Hollywood"]
[null,null,null,null,"Hopkins"]
[null,null,null,null,"Irmo"]
[null,null,null,null,"Isle of Palms"]
[null,null,null,null,"Jackson"]
[null,null,null,null,"Jacksonboro"]
[null,null,null,null,"James Island"]
[null,null,null,null,"Jenkinsville"]
[null,null,null,null,"Johns Island"]
[null,null,null,null,"Johnston"]
[null,null,null,null,"Ladson"]
[null,null,null,null,"Ladys Island"]
[null,null,null,null,"Langley"]
[null,null,null,null,"Leesville"]
[null,null,null,null,"Lexington"]
[null,null,null,null,"Lincolnville"]
[null,null,null,null,"Little Mountain"]
[null,null,null,null,"Livingston"]
[null,null,null,null,"Lobeco"]
[null,null,null,null,"Lodge"]
[null,null,null,null,"Lugoff"]
[null,null,null,null,"Luray"]
[null,null,null,null,"Martin"]
[null,null,null,null,"Mc Clellanville"]
[null,null,null,null,"Mc Cormick"]
[null,null,null,null,"Modoc"]
[null,null,null,null,"Moncks Corner"]
[null,null,null,null,"Monetta"]
[null,null,null,null,"Montmorenci"]
[null,null,null,null,"Mount Carmel"]
[null,null,null,null,"Mount Pleasant"]
[null,null,null,null,"Muphys Estates"]
[null,null,null,null,"Newberry"]
[null,null,null,null,"North"]
[null,null,null,null,"North Augusta"]
[null,null,null,null,"North Charleston"]
[null,null,null,null,"Northeast"]
[null,null,null,null,"Norway"]
[null,null,null,null,"Oakridge"]
[null,null,null,null,"Okatie"]
[null,null,null,null,"Olar"]
[null,null,null,null,"Olympia"]
[null,null,null,null,"Orangeburg"]
[null,null,null,null,"Parksville"]
[null,null,null,null,"Peak"]
[null,null,null,null,"Pelion"]
[null,null,null,null,"Perry"]
[null,null,null,null,"Pineland"]
[null,null,null,null,"Pomaria"]
[null,null,null,null,"Pontiac"]
[null,null,null,null,"Port Royal"]
[null,null,null,null,"Prosperity"]
[null,null,null,null,"Ravenel"]
[null,null,null,null,"Reevesville"]
[null,null,null,null,"Ridge Spring"]
[null,null,null,null,"Ridgeland"]
[null,null,null,null,"Ridgeville"]
[null,null,null,null,"Ridgeway"]
[null,null,null,null,"Rosewood"]
[null,null,null,null,"Round O"]
[null,null,null,null,"Rowesville"]
[null,null,null,null,"Ruffin"]
[null,null,null,null,"Saint George"]
[null,null,null,null,"Saint Helena Island"]
[null,null,null,null,"Saluda"]
[null,null,null,null,"Santee"]
[null,null,null,null,"Scotia"]
[null,null,null,null,"Seabrook"]
[null,null,null,null,"Sheldon"]
[null,null,null,null,"Sieglers Crossroads"]
[null,null,null,null,"Smoaks"]
[null,null,null,null,"Springfield"]
[null,null,null,null,"State Park"]
[null,null,null,null,"Sullivans Island"]
[null,null,null,null,"Summerville"]
[null,null,null,null,"Swansea"]
[null,null,null,null,"Sycamore"]
[null,null,null,null,"Tillman"]
[null,null,null,null,"Trenton"]
[null,null,null,null,"Troy"]
[null,null,null,null,"Ulmer"]
[null,null,null,null,"Union"]
[null,null,null,null,"University Park"]
[null,null,null,null,"Vance"]
[null,null,null,null,"Varnville"]
[null,null,null,null,"Vaucluse"]
[null,null,null,null,"Wagener"]
[null,null,null,null,"Walterboro"]
[null,null,null,null,"Ward"]
[null,null,null,null,"Warrenville"]
[null,null,null,null,"West Columbia"]
[null,null,null,null,"White Hall"]
[null,null,null,null,"White Rock"]
[null,null,null,null,"Wildwood"]
[null,null,null,null,"Williams"]
[null,null,null,null,"Williston"]
[null,null,null,null,"Windsor"]
[null,null,null,null,"Winnsboro"]
[null,null,null,null,"Yemassee"]

{"sheet":"Terms and Conditions","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,3,2,4],[2,0,6,0],[2,1,6,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 $150,000 per Project type. \n\n 2. Project Types: The Program includes the following five Project types: Lighting Projects, HVAC and Mechanical Projects, Food Service and High Efficiency Equipment Projects, Agriculture Projects and Custom Projects. Lighting projects include Projects that use the Retrofit and New Construction Lighting Application.  HVAC and Mechanical Projects include Projects listed on the HVAC Application and the Compressed Air and Motors Application including Unitary HVAC, Chillers, Heat Pump Water Heaters, Window Film, Cool Roof, Variable Frequency Drives, Guestroom Energy Management Systems, Advanced Roof Top Controls, Compressed Air Engineered Nozzles, Zero Loss Condensate Drains and High Efficiency Motors.  Food Service and High Efficiency Equipment Projects include all cooking equipment and “plug load” equipment that is incentivized under the Food Service and High-Efficiency Equipment Application. 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.  Agriculture Projects include all agriculture equipment that is incentivized under the Agriculture Application.  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.  Building controls, Building Tune-ups, Whole Building Solutions, System Optimization, 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. \n\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\n4.  Project Approval:  Pre-approval is required for all projects except for eligible Compressed Air and Motor 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). \n\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.   \n\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\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. \n\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. \n\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.              \n\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.\n                                                                                                                                                                                                                                                                                                                                                                                                                                                                      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.                                                                                                                                                                                                                                                         \n\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.  \n\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. \n\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.     \n\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.        \n\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 understanding.",null,{"$f":"B6","v":0}]
[]
[]
[]
[]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]

{"sheet":"Input Instructions & Incentives","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,6],[9,3,9,6],[11,3,11,6],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[14,3,14,6],[15,3,15,6],[12,3,12,6],[13,3,13,6],[26,6,26,7],[19,5,19,6],[20,5,20,6],[22,3,22,6],[21,5,21,6],[23,5,23,6]]}
[]
[]
[]
[null,"Compressed Air and Motors Workbook"]
[null,"Dominion Energy South Carolina, Inc."]
[]
[null,null,null,"Copyright © 2025 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[null,null,"Instructions"]
[null,null,"1.","Read the Form Instructions tab for detailed information on participation for this program."]
[null,null,"2.","A completed applicable \"blue\" equipment tab is required for either Compressed Air Measures or High Efficiency Motors. Application packages must be submitted by email."]
[null,null,null,"Email Address:","EnergyExperts@SC.DominionEnergyAccount.com"]
[null,null,"3.","Select appropriate worksheet tab:"]
[null,null,null,"- For a compressed air project select Compressed Air Measures."]
[null,null,null,"- For a project with high efficiency motors select High Efficiency Motors tab."]
[null,null,"4.","Enter required project information at the top of the appropriate worksheet.  "]
[null,null,"5.","Enter the required project information in the blue shaded areas only. \nA description of this information is provided below in the Inputs section.\nAll other information will be populated automatically."]
[]
[null,null,"Incentives"]
[]
[null,null,null,"Measure","Incentive/Unit","Technical Requirements"]
[null,null,null,"Compressed Air\nEngineered Nozzles","$50/Nozzle","▪ The high efficiency air nozzle must replace continuous blow-offs.\n▪ High efficiency nozzles must use less than or equal to the following ratings at 80psig: \n       ▪ 1/8\" - 11 SCFM @80 psig\n       ▪ 1/4\" - 29 SCFM @80 psig\n       ▪ 5/16\" - 56 SCFM @80 psig\n       ▪ 1/2\" - 140 SCFM @80 psig"]
[null,null,null,"Zero Loss\nDrains","$100/Drain","▪ The existing drain must be a timed drain or manually operated drain.\n▪ The high efficiency drain must be a zero loss condensate drain"]
[]
[null,null,null,"High Efficiency\nMotors","$0.15/kWh reduced","▪ The installed motor must meet or exceed requirements listed on the Motor Minimum Requirements tab. Provide manufacturer spec sheets for all motors listed below when submitting the application\n▪ Motor replacements can be made for currently operational motors, motors that have failed, or new construction\n▪ New motor must be installed and operational to qualify. Motor will not qualify if stored as a backup/inventory motor"]
[]
[]
[null,null,null,null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]

{"sheet":"Compressed Air Measures","index":5,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,9],[12,0,12,10],[0,0,0,10],[2,0,2,10],[3,0,3,10],[11,0,11,10],[9,0,9,9],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3]]}
["Fill in Blue Cells Only!"]
[]
["COMPRESSED AIR ENGINEERED NOZZLES TECHNICAL REQUIREMENTS AND INCENTIVES"]
["To qualify for an incentive:\n▪ The high efficiency air nozzle must replace continuous blow-offs.\n▪ High efficiency nozzles must use less than or equal to the following ratings at 80psig: \n       ▪ 1/8\" - 11 SCFM @80 psig\n       ▪ 1/4\" - 29 SCFM @80 psig\n       ▪ 5/16\" - 56 SCFM @80 psig\n       ▪ 1/2\" - 140 SCFM @80 psig\n▪ Manufacturer’s specification sheet of the high-efficiency air nozzle must be provided along with the make and model.\n▪ For any sizes not listed above should be submitted to the Program for a Custom analysis."]
["Number of Shifts","Compressor Type","Manufacturer","Model Number","Nozzle Size","Maximum SCFM @ 80 PSI allowed","Engineered Nozzle SCFM @ 80 psi","Quantity","Incentive Per Nozzle","Qualifies","Total Incentive",null,null,null,"Incentive Per Nozzle","kWh","Summer kW","Winter kW","Total Incentive"]
[null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(E6,NozzleSize,Validation!$D$2:$D$5),\"\")","v":""},null,null,{"$f":"IFERROR(CONCATENATE(\"$\",O6,\"/Nozzle\"),\"Select Nozzle Size\")","v":"$0/Nozzle"},{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!S4,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!Y4","v":0},null,null,null,{"$f":"IF($J6=\"Yes\",'Compressed Air Calculations'!X4,0)","v":0},{"$f":"IF($J6=\"Yes\",'Compressed Air Calculations'!U4,0)","v":0},{"$f":"IF($J6=\"Yes\",'Compressed Air Calculations'!V4,0)","v":0},{"$f":"IF($J6=\"Yes\",'Compressed Air Calculations'!W4,0)","v":0},{"$f":"IF($J6=\"Yes\",'Compressed Air Calculations'!Y4,0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(E7,NozzleSize,Validation!$D$2:$D$5),\"\")","v":""},null,null,{"$f":"IFERROR(CONCATENATE(\"$\",O7,\"/Nozzle\"),\"Select Nozzle Size\")","v":"$0/Nozzle"},{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!S5,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!Y5","v":0},null,null,null,{"$f":"IF($J7=\"Yes\",'Compressed Air Calculations'!X5,0)","v":0},{"$f":"IF($J7=\"Yes\",'Compressed Air Calculations'!U5,0)","v":0},{"$f":"IF($J7=\"Yes\",'Compressed Air Calculations'!V5,0)","v":0},{"$f":"IF($J7=\"Yes\",'Compressed Air Calculations'!W5,0)","v":0},{"$f":"IF($J7=\"Yes\",'Compressed Air Calculations'!Y5,0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(E8,NozzleSize,Validation!$D$2:$D$5),\"\")","v":""},null,null,"$0/Nozzle",{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!S6,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!Y6","v":0},null,null,null,{"$f":"IF($J8=\"Yes\",'Compressed Air Calculations'!X6,0)","v":0},{"$f":"IF($J8=\"Yes\",'Compressed Air Calculations'!U6,0)","v":0},{"$f":"IF($J8=\"Yes\",'Compressed Air Calculations'!V6,0)","v":0},{"$f":"IF($J8=\"Yes\",'Compressed Air Calculations'!W6,0)","v":0},{"$f":"IF($J8=\"Yes\",'Compressed Air Calculations'!Y6,0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(E9,NozzleSize,Validation!$D$2:$D$5),\"\")","v":""},null,null,"$0/Nozzle",{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!S7,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!Y7","v":0},null,null,null,{"$f":"IF($J9=\"Yes\",'Compressed Air Calculations'!X7,0)","v":0},{"$f":"IF($J9=\"Yes\",'Compressed Air Calculations'!U7,0)","v":0},{"$f":"IF($J9=\"Yes\",'Compressed Air Calculations'!V7,0)","v":0},{"$f":"IF($J9=\"Yes\",'Compressed Air Calculations'!W7,0)","v":0},{"$f":"IF($J9=\"Yes\",'Compressed Air Calculations'!Y7,0)","v":0}]
["Total Requested Incentive",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K9)","v":0}]
[]
["ZERO LOSS CONDENSATE DRAINS"]
["To qualify for an incentive:\n▪ The existing drain must be a timed drain or manually operated drain.\n▪ The high efficiency drain must be a zero loss condensate drain."]
["Number of Shifts",null,"Compressor Type",null,"Manufacturer",null,"Model Number","Quantity","Incentive Per Drain","Qualifies","Total Incentive",null,null,null,"Incentive Per Drain","kWh","Summer kW","Winter kW","Total Incentive"]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\",O15,\"/Drain\")","v":"$0/Drain"},{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!O13,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!R13","v":0},null,null,null,{"$f":"IF($J15=\"Yes\",'Compressed Air Calculations'!Q13,0)","v":0},{"$f":"'Compressed Air Calculations'!K13","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L13","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!M13","v":{"$error":"#N/A"}},{"$f":"IF($J15=\"Yes\",'Compressed Air Calculations'!R13,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\",O16,\"/Drain\")","v":"$0/Drain"},{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!O14,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!R14","v":0},null,null,null,{"$f":"IF($J16=\"Yes\",'Compressed Air Calculations'!Q14,0)","v":0},{"$f":"'Compressed Air Calculations'!K14","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L14","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!M14","v":{"$error":"#N/A"}},{"$f":"IF($J16=\"Yes\",'Compressed Air Calculations'!R14,0)","v":0}]
[null,null,null,null,null,null,null,null,"$0/Drain",{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!O15,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!R15","v":0},null,null,null,{"$f":"IF($J17=\"Yes\",'Compressed Air Calculations'!Q15,0)","v":0},{"$f":"'Compressed Air Calculations'!K15","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L15","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!M15","v":{"$error":"#N/A"}},{"$f":"IF($J17=\"Yes\",'Compressed Air Calculations'!R15,0)","v":0}]
[null,null,null,null,null,null,null,null,"$0/Drain",{"$f":"_xlfn.XLOOKUP('Compressed Air Calculations'!O16,Validation!$A$14:$A$16,Validation!$C$14:$C$16)","v":"No. Please fill in all blue cells in this row."},{"$f":"'Compressed Air Calculations'!R16","v":0},null,null,null,{"$f":"IF($J18=\"Yes\",'Compressed Air Calculations'!Q16,0)","v":0},{"$f":"IF($J18=\"Yes\",'Compressed Air Calculations'!V16,0)","v":0},{"$f":"IF($J18=\"Yes\",'Compressed Air Calculations'!W16,0)","v":0},{"$f":"IF($J18=\"Yes\",'Compressed Air Calculations'!X16,0)","v":0},{"$f":"IF($J18=\"Yes\",'Compressed Air Calculations'!R16,0)","v":0}]
["Total Requested Incentive",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:K18)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]

{"sheet":"High Efficiency Motors","index":6,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,12,30,16],[28,0,28,15],[0,0,0,16],[2,0,2,13],[2,14,2,16],[3,0,5,13],[3,14,3,16],[6,0,6,2],[6,3,6,9],[6,10,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16]]}
["Fill in Blue Cells Only!"]
[]
["HIGH EFFICIENCY MOTORS TECHNICAL REQUIREMENTS AND INCENTIVES",null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Cost Information"]
["To qualify for an incentive:\n▪ The installed motor must meet or exceed requirements listed on the Motor Minimum Requirements tab. Provide manufacturer spec sheets for all motors listed below when submitting the application\n▪ Motor replacements can be made for currently operational motors, motors that have failed, or new construction\n▪ New motor must be installed and operational to qualify. Motor will not qualify if stored as a backup/inventory motor\n▪ For motors that don't match an application type, industry, size, number of poles, are explosion proof type, etc, please contact Program team to see if project should go through the Custom Program\n▪ Retain a photo of the existing equipment nameplate for DESC review in the case it is needed.\n\nWorkbook Instructions:\n▪ Blue cells below are required. Columns B and M will turn blue if required. Column N is optional if you know the existing motor efficiency. If existing motor efficiency is unknown, please leave blank. \n▪ For Business Type in Column A, if \"Industrial/Manufacturing\" is chosen, please also fill in the number of shifts in Column B\n▪ In Column C, specify motor use application for commercial applications or industry type for industrial applications\n▪ For existing motor information, indicate if the motor is or could be rewound in column K and if the motor is currently operational in column L \n▪ In column M, for existing age of the motor, select an age from the drop down list for any blue cells. If unknown, select Unknown\n▪ In column N, for existing motor efficiency, if motor is still operational enter nameplate efficiency if known. If unknown, leave those cells blank\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter project costs below in blue cells.\n▪ Incentive rate is $0.15/kWh saved for qualifying motors\n▪ Incentive will be capped at 75% of the total eligible project cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Cost - Materials","Project Cost - Labor","Total Project Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O6+P6","v":0}]
["General Information",null,null,"New Motor Information",null,null,null,null,null,null,"Existing Motor Information"]
["Business Type","Industrial Shift","Motor Use Application / Industry Type","Manufacturer","Model","Motor Rated Horsepower","Number of Poles","Motor Type\n(Open/Closed)","New Motor Efficiency","Motor Quantity","Can Existing Motor Be Rewound?","Is Motor Currently Operational","IF OPERATIONAL: Estimated Age of Motor (Years)","IF KNOWN: Existing Motor Efficiency","Incentive Rate","Qualifies","Total Incentive",null,null,null,"Incentive Per Motor","kWh","Winter kW","Total Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$\",MotorIncentive,\"/kwh\")","v":"$0.15/kwh"},{"$f":"IF(COUNTBLANK(A9:N9)<12,'Motor Calcs'!Y6,\"\")","v":""},{"$f":"X9","v":0},null,null,null,{"$f":"IFERROR(X9/J9,0)","v":0},{"$f":"'Motor Calcs'!AL6","v":0},{"$f":"'Motor Calcs'!AM6","v":0},{"$f":"'Motor Calcs'!AO6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A10:N10)<12,'Motor Calcs'!Y7,\"\")","v":""},{"$f":"X10","v":0},null,null,null,{"$f":"IFERROR(X10/J10,0)","v":0},{"$f":"'Motor Calcs'!AL7","v":0},{"$f":"'Motor Calcs'!AM7","v":0},{"$f":"'Motor Calcs'!AO7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A11:N11)<12,'Motor Calcs'!Y8,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL8","v":0},{"$f":"'Motor Calcs'!AM8","v":0},{"$f":"'Motor Calcs'!AO8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A12:N12)<12,'Motor Calcs'!Y9,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL9","v":0},{"$f":"'Motor Calcs'!AM9","v":0},{"$f":"'Motor Calcs'!AO9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A13:N13)<12,'Motor Calcs'!Y10,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL10","v":0},{"$f":"'Motor Calcs'!AM10","v":0},{"$f":"'Motor Calcs'!AO10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A14:N14)<12,'Motor Calcs'!Y11,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL11","v":0},{"$f":"'Motor Calcs'!AM11","v":0},{"$f":"'Motor Calcs'!AO11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A15:N15)<12,'Motor Calcs'!Y12,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL12","v":0},{"$f":"'Motor Calcs'!AM12","v":0},{"$f":"'Motor Calcs'!AO12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A16:N16)<12,'Motor Calcs'!Y13,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL13","v":0},{"$f":"'Motor Calcs'!AM13","v":0},{"$f":"'Motor Calcs'!AO13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A17:N17)<12,'Motor Calcs'!Y14,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL14","v":0},{"$f":"'Motor Calcs'!AM14","v":0},{"$f":"'Motor Calcs'!AO14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A18:N18)<12,'Motor Calcs'!Y15,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL15","v":0},{"$f":"'Motor Calcs'!AM15","v":0},{"$f":"'Motor Calcs'!AO15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A19:N19)<12,'Motor Calcs'!Y16,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL16","v":0},{"$f":"'Motor Calcs'!AM16","v":0},{"$f":"'Motor Calcs'!AO16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A20:N20)<12,'Motor Calcs'!Y17,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL17","v":0},{"$f":"'Motor Calcs'!AM17","v":0},{"$f":"'Motor Calcs'!AO17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A21:N21)<12,'Motor Calcs'!Y18,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL18","v":0},{"$f":"'Motor Calcs'!AM18","v":0},{"$f":"'Motor Calcs'!AO18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A22:N22)<12,'Motor Calcs'!Y19,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL19","v":0},{"$f":"'Motor Calcs'!AM19","v":0},{"$f":"'Motor Calcs'!AO19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A23:N23)<12,'Motor Calcs'!Y20,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL20","v":0},{"$f":"'Motor Calcs'!AM20","v":0},{"$f":"'Motor Calcs'!AO20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A24:N24)<12,'Motor Calcs'!Y21,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL21","v":0},{"$f":"'Motor Calcs'!AM21","v":0},{"$f":"'Motor Calcs'!AO21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A25:N25)<12,'Motor Calcs'!Y22,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL22","v":0},{"$f":"'Motor Calcs'!AM22","v":0},{"$f":"'Motor Calcs'!AO22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A26:N26)<12,'Motor Calcs'!Y23,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL23","v":0},{"$f":"'Motor Calcs'!AM23","v":0},{"$f":"'Motor Calcs'!AO23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A27:N27)<12,'Motor Calcs'!Y24,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL24","v":0},{"$f":"'Motor Calcs'!AM24","v":0},{"$f":"'Motor Calcs'!AO24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0.15/kwh",{"$f":"IF(COUNTBLANK(A28:N28)<12,'Motor Calcs'!Y25,\"\")","v":""},0,null,null,null,0,{"$f":"'Motor Calcs'!AL25","v":0},{"$f":"'Motor Calcs'!AM25","v":0},{"$f":"'Motor Calcs'!AO25","v":0}]
["Total Requested Incentive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q9:Q28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(L31=\"1\", L31=\"2\", L32=\"1\", L32=\"2\"), \"Error Messages:\", \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(P9:P28, \"Error Message 1 - See below\") > 0, \"1\", \"\")","v":""},{"$f":"IF(COUNTIF(P9:P28, \"Error Message 1 - See below\") > 0, 'Motor Measure Validation'!C39, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(P9:P28, \"Error Message 2 - See below\") > 0, \"2\", \"\")","v":""},{"$f":"IF(COUNTIF(P9:P28, \"Error Message 2 - See below\") > 0, 'Motor Measure Validation'!C40, \"\")","v":""},null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]

{"sheet":"Motor Minimum Requirements","index":7,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,8],[2,4,4,7],[35,7,35,9]]}
[]
[]
[null,null,null,null,"Motor Minimum Requirements"]
[]
[]
[]
[null,null,null,"Open Motor",null,null,"Closed Motor"]
[null,null,null,"6-Pole","4-Pole","2-Pole","6-Pole","4-Pole","2-Pole"]
[null,null,"Rated Motor HorsePower","1200 RPM","1800 RPM","3600 RPM","1200 RPM","1800 RPM","3600 RPM"]
[null,null,1,0.84,0.86499999999999999,0.78500000000000003,0.84,0.86499999999999999,0.78500000000000003]
[null,null,1.5,0.875,0.875,0.85499999999999998,0.88500000000000001,0.875,0.85499999999999998]
[null,null,2,0.88500000000000001,0.875,0.86499999999999999,0.89500000000000002,0.875,0.86499999999999999]
[null,null,3,0.89500000000000002,0.90200000000000002,0.86499999999999999,0.90200000000000002,0.90200000000000002,0.875]
[null,null,5,0.90200000000000002,0.90200000000000002,0.875,0.90200000000000002,0.90200000000000002,0.89500000000000002]
[null,null,7.5,0.91,0.91700000000000004,0.89500000000000002,0.91700000000000004,0.92400000000000004,0.90200000000000002]
[null,null,10,0.92400000000000004,0.92400000000000004,0.90200000000000002,0.91700000000000004,0.92400000000000004,0.91]
[null,null,15,0.92400000000000004,0.93600000000000005,0.91,0.92400000000000004,0.93,0.91700000000000004]
[null,null,20,0.93,0.93600000000000005,0.91700000000000004,0.92400000000000004,0.93600000000000005,0.91700000000000004]
[null,null,25,0.93600000000000005,0.94099999999999995,0.92400000000000004,0.93600000000000005,0.94099999999999995,0.92400000000000004]
[null,null,30,0.94099999999999995,0.94499999999999995,0.92400000000000004,0.93600000000000005,0.94099999999999995,0.92400000000000004]
[null,null,40,0.94499999999999995,0.94499999999999995,0.93,0.94499999999999995,0.94499999999999995,0.93]
[null,null,50,0.94499999999999995,0.95,0.93600000000000005,0.94499999999999995,0.95,0.93600000000000005]
[null,null,60,0.95,0.95399999999999996,0.94099999999999995,0.95,0.95399999999999996,0.94099999999999995]
[null,null,75,0.95,0.95399999999999996,0.94099999999999995,0.95,0.95799999999999996,0.94099999999999995]
[null,null,100,0.95399999999999996,0.95799999999999996,0.94099999999999995,0.95399999999999996,0.95799999999999996,0.94499999999999995]
[null,null,125,0.95399999999999996,0.95799999999999996,0.94499999999999995,0.95399999999999996,0.95799999999999996,0.95399999999999996]
[null,null,150,0.95799999999999996,0.96199999999999997,0.94499999999999995,0.96199999999999997,0.96199999999999997,0.95399999999999996]
[null,null,200,0.95799999999999996,0.96199999999999997,0.95399999999999996,0.96199999999999997,0.96499999999999997,0.95799999999999996]
[null,null,250,0.95399999999999996,0.95799999999999996,0.95,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[null,null,300,0.95399999999999996,0.95799999999999996,0.95399999999999996,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[null,null,350,0.95399999999999996,0.95799999999999996,0.95399999999999996,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[null,null,400,0.95799999999999996,0.95799999999999996,0.95799999999999996,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[null,null,450,0.96199999999999997,0.96199999999999997,0.95799999999999996,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[null,null,500,0.96199999999999997,0.96199999999999997,0.95799999999999996,0.95799999999999996,0.96199999999999997,0.95799999999999996]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 15.1"}]

{"sheet":"Motor Calcs","index":8,"n_rows":90,"n_cols":41,"rows_kept":90,"cut":false,"hidden":true,"merged":[[3,37,3,40],[2,21,2,23],[3,0,3,13],[3,25,3,27],[3,28,3,30],[3,35,3,36],[32,1,32,3],[32,4,32,6],[62,0,63,0],[62,1,62,3],[62,4,62,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Ratio",{"$f":"IFERROR(AO3/AN3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calc Incentive","Max Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error Message",null,null,null,null,null,null,null,null,null,null,null,"*Assumes 15 years if unknown age",null,null,null,null,null,{"$f":"SUM(AN6:AN25)","v":0},{"$f":"ROUND('High Efficiency Motors'!Q6*MotorCap,2)","v":0}]
["Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,null,null,"ROB Scenario (Per Motor)",null,null,"RUL Scenario (Per Motor)",null,null,null,null,null,null,"ER Scenario",null,"Total"]
["Business Type","Industrial Shift","Motor Use Application Type","Manufacturer","Model Number","Horsepower","Number of poles","Open/Closed","Proposed Efficiency","Quantity of Motors","Can Existing Motor Be Rewound?","Is Motor Currently Operational","Estimated Age of Motor (Years)","Baseline Efficiency (user input)","Sector Type","Load Factor (LF)","CFw","Estimated HOU","Lookup Concat","Minimum Motor Effiency Requirement","Rewind Eff Credit","All blue cells filled in?","Minimum requirement met?","Results","Qualifies","ROB Baseline Motor Efficiency w/ Rewind credit","kWh Savings","Winter kW savings","ER Baseline Motor Efficiency w/ Rewind credit","kWh Savings","Winter kW savings","Measure Type (ER/ROB)","EUL","Age of Motor*","RUL","kWh Savings","Winter kW savings","kWh Savings","Winter kW savings","Calculated Incentive","Cap Adjusted Incentive"]
[{"$f":"'High Efficiency Motors'!A9","v":0},{"$f":"'High Efficiency Motors'!B9","v":0},{"$f":"'High Efficiency Motors'!C9","v":0},{"$f":"'High Efficiency Motors'!D9","v":0},{"$f":"'High Efficiency Motors'!E9","v":0},{"$f":"'High Efficiency Motors'!F9","v":0},{"$f":"'High Efficiency Motors'!G9","v":0},{"$f":"'High Efficiency Motors'!H9","v":0},{"$f":"'High Efficiency Motors'!I9","v":0},{"$f":"'High Efficiency Motors'!J9","v":0},{"$f":"'High Efficiency Motors'!K9","v":0},{"$f":"'High Efficiency Motors'!L9","v":0},{"$f":"'High Efficiency Motors'!M9","v":0},{"$f":"'High Efficiency Motors'!N9","v":0},{"$f":"_xlfn.XLOOKUP(A6,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O6=\"Commercial\",_xlfn.XLOOKUP(A6,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O6=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F6,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O6=\"Commercial\",_xlfn.XLOOKUP(A6,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O6=\"Industrial\",_xlfn.XLOOKUP(B6,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O6=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A6,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C6,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O6=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F6,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C6,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},{"$f":"_xlfn.CONCAT(H6,G6)","v":"00"},{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F6,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S6,$B$32:$G$32,0))","v":{"$error":"#N/A"}},{"$f":"IF(K6=\"Yes\",_xlfn.XLOOKUP(F6,$A$35:$A$59,$H$35:$H$59)/100,0)","v":0},{"$f":"IF(AND(A6<>0,C6<>0,D6<>0,E6<>0,F6<>0,G6<>0,H6<>0,I6<>0,J6<>0,K6<>0,L6<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I6>=T6,\"Yes\",\"No\")","v":{"$error":"#N/A"}},{"$f":"IF(V6=\"Yes\",IF(W6=\"Yes\",0,$W$4),$V$4)","v":1},{"$f":"_xlfn.XLOOKUP(X6,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$f":"IF(AND(N6>0,L6=\"Yes\"),N6,INDEX($B$35:$G$59,MATCH(F6,$A$35:$A$59,1),MATCH(S6,$B$32:$G$32,0))/100)-U6","v":{"$error":"#N/A"}},{"$f":"F6*0.746*P6*(1/Z6-1/I6)*R6","v":{"$error":"#N/A"}},{"$f":"F6*0.746*P6*(1/Z6-1/I6)*Q6","v":{"$error":"#N/A"}},{"$f":"IF(AND(N6>0,L6=\"Yes\"),N6,INDEX($B$65:$G$89,MATCH(F6,$A$65:$A$89,1),MATCH(S6,$B$62:$G$62,0))/100)-U6","v":{"$error":"#N/A"}},{"$f":"F6*0.746*P6*(1/AC6-1/I6)*R6","v":{"$error":"#N/A"}},{"$f":"F6*0.746*P6*(1/AC6-1/I6)*Q6","v":{"$error":"#N/A"}},{"$f":"IF(L6=\"Yes\",\"ER\",\"ROB\")","v":"ROB"},15,{"$f":"IF(OR(M6=0,M6=\"Unknown\"),15,M6)","v":15},{"$f":"IF(AF6=\"ER\",_xlfn.XLOOKUP(AH6,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$f":"((AD6*$AI6)+(AA6*($AG6-$AI6)))/$AG6","v":{"$error":"#N/A"}},{"$f":"((AE6*$AI6)+(AB6*($AG6-$AI6)))/$AG6","v":{"$error":"#N/A"}},{"$f":"IF($Y6=\"Yes\",IF($AF6=\"ROB\",AA6,IF($AF6=\"ER\",AJ6,0)),0)*J6","v":0},{"$f":"IF($Y6=\"Yes\",IF($AF6=\"ROB\",AB6,IF($AF6=\"ER\",AK6,0)),0)*J6","v":0},{"$f":"IFERROR(AL6*MotorIncentive,0)","v":0},{"$f":"MIN(AN6,IFERROR(AN6*$AO$1, \"\"))","v":0}]
[{"$f":"'High Efficiency Motors'!A10","v":0},{"$f":"'High Efficiency Motors'!B10","v":0},{"$f":"'High Efficiency Motors'!C10","v":0},{"$f":"'High Efficiency Motors'!D10","v":0},{"$f":"'High Efficiency Motors'!E10","v":0},{"$f":"'High Efficiency Motors'!F10","v":0},{"$f":"'High Efficiency Motors'!G10","v":0},{"$f":"'High Efficiency Motors'!H10","v":0},{"$f":"'High Efficiency Motors'!I10","v":0},{"$f":"'High Efficiency Motors'!J10","v":0},{"$f":"'High Efficiency Motors'!K10","v":0},{"$f":"'High Efficiency Motors'!L10","v":0},{"$f":"'High Efficiency Motors'!M10","v":0},{"$f":"'High Efficiency Motors'!N10","v":0},{"$f":"_xlfn.XLOOKUP(A7,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O7=\"Commercial\",_xlfn.XLOOKUP(A7,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O7=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F7,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O7=\"Commercial\",_xlfn.XLOOKUP(A7,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O7=\"Industrial\",_xlfn.XLOOKUP(B7,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O7=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A7,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C7,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O7=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F7,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C7,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},{"$f":"_xlfn.CONCAT(H7,G7)","v":"00"},{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F7,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S7,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},{"$f":"IF(V7=\"Yes\",IF(W7=\"Yes\",0,$W$4),$V$4)","v":1},{"$f":"_xlfn.XLOOKUP(X7,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$f":"IF(AND(N7>0,L7=\"Yes\"),N7,INDEX($B$35:$G$59,MATCH(F7,$A$35:$A$59,1),MATCH(S7,$B$32:$G$32,0))/100)-U7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(N7>0,L7=\"Yes\"),N7,INDEX($B$65:$G$89,MATCH(F7,$A$65:$A$89,1),MATCH(S7,$B$62:$G$62,0))/100)-U7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF7=\"ER\",_xlfn.XLOOKUP(AH7,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$f":"((AD7*$AI7)+(AA7*($AG7-$AI7)))/$AG7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($Y7=\"Yes\",IF($AF7=\"ROB\",AA7,IF($AF7=\"ER\",AJ7,0)),0)*J7","v":0},{"$f":"IF($Y7=\"Yes\",IF($AF7=\"ROB\",AB7,IF($AF7=\"ER\",AK7,0)),0)*J7","v":0},0,{"$f":"MIN(AN7,IFERROR(AN7*$AO$1, \"\"))","v":0}]
[{"$f":"'High Efficiency Motors'!A11","v":0},{"$f":"'High Efficiency Motors'!B11","v":0},{"$f":"'High Efficiency Motors'!C11","v":0},{"$f":"'High Efficiency Motors'!D11","v":0},{"$f":"'High Efficiency Motors'!E11","v":0},{"$f":"'High Efficiency Motors'!F11","v":0},{"$f":"'High Efficiency Motors'!G11","v":0},{"$f":"'High Efficiency Motors'!H11","v":0},{"$f":"'High Efficiency Motors'!I11","v":0},{"$f":"'High Efficiency Motors'!J11","v":0},{"$f":"'High Efficiency Motors'!K11","v":0},{"$f":"'High Efficiency Motors'!L11","v":0},{"$f":"'High Efficiency Motors'!M11","v":0},{"$f":"'High Efficiency Motors'!N11","v":0},{"$f":"_xlfn.XLOOKUP(A8,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O8=\"Commercial\",_xlfn.XLOOKUP(A8,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O8=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F8,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O8=\"Commercial\",_xlfn.XLOOKUP(A8,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O8=\"Industrial\",_xlfn.XLOOKUP(B8,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O8=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A8,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C8,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O8=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F8,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C8,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F8,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S8,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X8,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF8=\"ER\",_xlfn.XLOOKUP(AH8,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A12","v":0},{"$f":"'High Efficiency Motors'!B12","v":0},{"$f":"'High Efficiency Motors'!C12","v":0},{"$f":"'High Efficiency Motors'!D12","v":0},{"$f":"'High Efficiency Motors'!E12","v":0},{"$f":"'High Efficiency Motors'!F12","v":0},{"$f":"'High Efficiency Motors'!G12","v":0},{"$f":"'High Efficiency Motors'!H12","v":0},{"$f":"'High Efficiency Motors'!I12","v":0},{"$f":"'High Efficiency Motors'!J12","v":0},{"$f":"'High Efficiency Motors'!K12","v":0},{"$f":"'High Efficiency Motors'!L12","v":0},{"$f":"'High Efficiency Motors'!M12","v":0},{"$f":"'High Efficiency Motors'!N12","v":0},{"$f":"_xlfn.XLOOKUP(A9,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O9=\"Commercial\",_xlfn.XLOOKUP(A9,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O9=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F9,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O9=\"Commercial\",_xlfn.XLOOKUP(A9,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O9=\"Industrial\",_xlfn.XLOOKUP(B9,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O9=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A9,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C9,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O9=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F9,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C9,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F9,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S9,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X9,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF9=\"ER\",_xlfn.XLOOKUP(AH9,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A13","v":0},{"$f":"'High Efficiency Motors'!B13","v":0},{"$f":"'High Efficiency Motors'!C13","v":0},{"$f":"'High Efficiency Motors'!D13","v":0},{"$f":"'High Efficiency Motors'!E13","v":0},{"$f":"'High Efficiency Motors'!F13","v":0},{"$f":"'High Efficiency Motors'!G13","v":0},{"$f":"'High Efficiency Motors'!H13","v":0},{"$f":"'High Efficiency Motors'!I13","v":0},{"$f":"'High Efficiency Motors'!J13","v":0},{"$f":"'High Efficiency Motors'!K13","v":0},{"$f":"'High Efficiency Motors'!L13","v":0},{"$f":"'High Efficiency Motors'!M13","v":0},{"$f":"'High Efficiency Motors'!N13","v":0},{"$f":"_xlfn.XLOOKUP(A10,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O10=\"Commercial\",_xlfn.XLOOKUP(A10,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O10=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F10,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O10=\"Commercial\",_xlfn.XLOOKUP(A10,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O10=\"Industrial\",_xlfn.XLOOKUP(B10,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O10=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A10,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C10,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O10=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F10,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C10,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F10,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S10,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X10,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF10=\"ER\",_xlfn.XLOOKUP(AH10,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A14","v":0},{"$f":"'High Efficiency Motors'!B14","v":0},{"$f":"'High Efficiency Motors'!C14","v":0},{"$f":"'High Efficiency Motors'!D14","v":0},{"$f":"'High Efficiency Motors'!E14","v":0},{"$f":"'High Efficiency Motors'!F14","v":0},{"$f":"'High Efficiency Motors'!G14","v":0},{"$f":"'High Efficiency Motors'!H14","v":0},{"$f":"'High Efficiency Motors'!I14","v":0},{"$f":"'High Efficiency Motors'!J14","v":0},{"$f":"'High Efficiency Motors'!K14","v":0},{"$f":"'High Efficiency Motors'!L14","v":0},{"$f":"'High Efficiency Motors'!M14","v":0},{"$f":"'High Efficiency Motors'!N14","v":0},{"$f":"_xlfn.XLOOKUP(A11,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O11=\"Commercial\",_xlfn.XLOOKUP(A11,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O11=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F11,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O11=\"Commercial\",_xlfn.XLOOKUP(A11,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O11=\"Industrial\",_xlfn.XLOOKUP(B11,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O11=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A11,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C11,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O11=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F11,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C11,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F11,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S11,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X11,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF11=\"ER\",_xlfn.XLOOKUP(AH11,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A15","v":0},{"$f":"'High Efficiency Motors'!B15","v":0},{"$f":"'High Efficiency Motors'!C15","v":0},{"$f":"'High Efficiency Motors'!D15","v":0},{"$f":"'High Efficiency Motors'!E15","v":0},{"$f":"'High Efficiency Motors'!F15","v":0},{"$f":"'High Efficiency Motors'!G15","v":0},{"$f":"'High Efficiency Motors'!H15","v":0},{"$f":"'High Efficiency Motors'!I15","v":0},{"$f":"'High Efficiency Motors'!J15","v":0},{"$f":"'High Efficiency Motors'!K15","v":0},{"$f":"'High Efficiency Motors'!L15","v":0},{"$f":"'High Efficiency Motors'!M15","v":0},{"$f":"'High Efficiency Motors'!N15","v":0},{"$f":"_xlfn.XLOOKUP(A12,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O12=\"Commercial\",_xlfn.XLOOKUP(A12,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O12=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F12,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O12=\"Commercial\",_xlfn.XLOOKUP(A12,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O12=\"Industrial\",_xlfn.XLOOKUP(B12,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O12=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A12,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C12,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O12=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F12,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C12,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F12,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S12,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X12,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF12=\"ER\",_xlfn.XLOOKUP(AH12,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A16","v":0},{"$f":"'High Efficiency Motors'!B16","v":0},{"$f":"'High Efficiency Motors'!C16","v":0},{"$f":"'High Efficiency Motors'!D16","v":0},{"$f":"'High Efficiency Motors'!E16","v":0},{"$f":"'High Efficiency Motors'!F16","v":0},{"$f":"'High Efficiency Motors'!G16","v":0},{"$f":"'High Efficiency Motors'!H16","v":0},{"$f":"'High Efficiency Motors'!I16","v":0},{"$f":"'High Efficiency Motors'!J16","v":0},{"$f":"'High Efficiency Motors'!K16","v":0},{"$f":"'High Efficiency Motors'!L16","v":0},{"$f":"'High Efficiency Motors'!M16","v":0},{"$f":"'High Efficiency Motors'!N16","v":0},{"$f":"_xlfn.XLOOKUP(A13,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O13=\"Commercial\",_xlfn.XLOOKUP(A13,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O13=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F13,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O13=\"Commercial\",_xlfn.XLOOKUP(A13,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O13=\"Industrial\",_xlfn.XLOOKUP(B13,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O13=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A13,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C13,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O13=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F13,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C13,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F13,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S13,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X13,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF13=\"ER\",_xlfn.XLOOKUP(AH13,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A17","v":0},{"$f":"'High Efficiency Motors'!B17","v":0},{"$f":"'High Efficiency Motors'!C17","v":0},{"$f":"'High Efficiency Motors'!D17","v":0},{"$f":"'High Efficiency Motors'!E17","v":0},{"$f":"'High Efficiency Motors'!F17","v":0},{"$f":"'High Efficiency Motors'!G17","v":0},{"$f":"'High Efficiency Motors'!H17","v":0},{"$f":"'High Efficiency Motors'!I17","v":0},{"$f":"'High Efficiency Motors'!J17","v":0},{"$f":"'High Efficiency Motors'!K17","v":0},{"$f":"'High Efficiency Motors'!L17","v":0},{"$f":"'High Efficiency Motors'!M17","v":0},{"$f":"'High Efficiency Motors'!N17","v":0},{"$f":"_xlfn.XLOOKUP(A14,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O14=\"Commercial\",_xlfn.XLOOKUP(A14,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O14=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F14,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O14=\"Commercial\",_xlfn.XLOOKUP(A14,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O14=\"Industrial\",_xlfn.XLOOKUP(B14,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O14=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A14,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C14,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O14=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F14,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C14,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F14,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S14,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X14,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF14=\"ER\",_xlfn.XLOOKUP(AH14,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A18","v":0},{"$f":"'High Efficiency Motors'!B18","v":0},{"$f":"'High Efficiency Motors'!C18","v":0},{"$f":"'High Efficiency Motors'!D18","v":0},{"$f":"'High Efficiency Motors'!E18","v":0},{"$f":"'High Efficiency Motors'!F18","v":0},{"$f":"'High Efficiency Motors'!G18","v":0},{"$f":"'High Efficiency Motors'!H18","v":0},{"$f":"'High Efficiency Motors'!I18","v":0},{"$f":"'High Efficiency Motors'!J18","v":0},{"$f":"'High Efficiency Motors'!K18","v":0},{"$f":"'High Efficiency Motors'!L18","v":0},{"$f":"'High Efficiency Motors'!M18","v":0},{"$f":"'High Efficiency Motors'!N18","v":0},{"$f":"_xlfn.XLOOKUP(A15,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O15=\"Commercial\",_xlfn.XLOOKUP(A15,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O15=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F15,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O15=\"Commercial\",_xlfn.XLOOKUP(A15,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O15=\"Industrial\",_xlfn.XLOOKUP(B15,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O15=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A15,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C15,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O15=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F15,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C15,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F15,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S15,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X15,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF15=\"ER\",_xlfn.XLOOKUP(AH15,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A19","v":0},{"$f":"'High Efficiency Motors'!B19","v":0},{"$f":"'High Efficiency Motors'!C19","v":0},{"$f":"'High Efficiency Motors'!D19","v":0},{"$f":"'High Efficiency Motors'!E19","v":0},{"$f":"'High Efficiency Motors'!F19","v":0},{"$f":"'High Efficiency Motors'!G19","v":0},{"$f":"'High Efficiency Motors'!H19","v":0},{"$f":"'High Efficiency Motors'!I19","v":0},{"$f":"'High Efficiency Motors'!J19","v":0},{"$f":"'High Efficiency Motors'!K19","v":0},{"$f":"'High Efficiency Motors'!L19","v":0},{"$f":"'High Efficiency Motors'!M19","v":0},{"$f":"'High Efficiency Motors'!N19","v":0},{"$f":"_xlfn.XLOOKUP(A16,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O16=\"Commercial\",_xlfn.XLOOKUP(A16,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O16=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F16,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O16=\"Commercial\",_xlfn.XLOOKUP(A16,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O16=\"Industrial\",_xlfn.XLOOKUP(B16,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O16=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A16,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C16,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O16=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F16,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C16,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F16,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S16,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X16,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF16=\"ER\",_xlfn.XLOOKUP(AH16,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A20","v":0},{"$f":"'High Efficiency Motors'!B20","v":0},{"$f":"'High Efficiency Motors'!C20","v":0},{"$f":"'High Efficiency Motors'!D20","v":0},{"$f":"'High Efficiency Motors'!E20","v":0},{"$f":"'High Efficiency Motors'!F20","v":0},{"$f":"'High Efficiency Motors'!G20","v":0},{"$f":"'High Efficiency Motors'!H20","v":0},{"$f":"'High Efficiency Motors'!I20","v":0},{"$f":"'High Efficiency Motors'!J20","v":0},{"$f":"'High Efficiency Motors'!K20","v":0},{"$f":"'High Efficiency Motors'!L20","v":0},{"$f":"'High Efficiency Motors'!M20","v":0},{"$f":"'High Efficiency Motors'!N20","v":0},{"$f":"_xlfn.XLOOKUP(A17,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O17=\"Commercial\",_xlfn.XLOOKUP(A17,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O17=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F17,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O17=\"Commercial\",_xlfn.XLOOKUP(A17,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O17=\"Industrial\",_xlfn.XLOOKUP(B17,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O17=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A17,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C17,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O17=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F17,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C17,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F17,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S17,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X17,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF17=\"ER\",_xlfn.XLOOKUP(AH17,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A21","v":0},{"$f":"'High Efficiency Motors'!B21","v":0},{"$f":"'High Efficiency Motors'!C21","v":0},{"$f":"'High Efficiency Motors'!D21","v":0},{"$f":"'High Efficiency Motors'!E21","v":0},{"$f":"'High Efficiency Motors'!F21","v":0},{"$f":"'High Efficiency Motors'!G21","v":0},{"$f":"'High Efficiency Motors'!H21","v":0},{"$f":"'High Efficiency Motors'!I21","v":0},{"$f":"'High Efficiency Motors'!J21","v":0},{"$f":"'High Efficiency Motors'!K21","v":0},{"$f":"'High Efficiency Motors'!L21","v":0},{"$f":"'High Efficiency Motors'!M21","v":0},{"$f":"'High Efficiency Motors'!N21","v":0},{"$f":"_xlfn.XLOOKUP(A18,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O18=\"Commercial\",_xlfn.XLOOKUP(A18,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O18=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F18,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O18=\"Commercial\",_xlfn.XLOOKUP(A18,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O18=\"Industrial\",_xlfn.XLOOKUP(B18,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O18=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A18,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C18,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O18=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F18,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C18,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F18,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S18,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X18,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF18=\"ER\",_xlfn.XLOOKUP(AH18,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A22","v":0},{"$f":"'High Efficiency Motors'!B22","v":0},{"$f":"'High Efficiency Motors'!C22","v":0},{"$f":"'High Efficiency Motors'!D22","v":0},{"$f":"'High Efficiency Motors'!E22","v":0},{"$f":"'High Efficiency Motors'!F22","v":0},{"$f":"'High Efficiency Motors'!G22","v":0},{"$f":"'High Efficiency Motors'!H22","v":0},{"$f":"'High Efficiency Motors'!I22","v":0},{"$f":"'High Efficiency Motors'!J22","v":0},{"$f":"'High Efficiency Motors'!K22","v":0},{"$f":"'High Efficiency Motors'!L22","v":0},{"$f":"'High Efficiency Motors'!M22","v":0},{"$f":"'High Efficiency Motors'!N22","v":0},{"$f":"_xlfn.XLOOKUP(A19,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O19=\"Commercial\",_xlfn.XLOOKUP(A19,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O19=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F19,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O19=\"Commercial\",_xlfn.XLOOKUP(A19,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O19=\"Industrial\",_xlfn.XLOOKUP(B19,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O19=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A19,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C19,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O19=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F19,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C19,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F19,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S19,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X19,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF19=\"ER\",_xlfn.XLOOKUP(AH19,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A23","v":0},{"$f":"'High Efficiency Motors'!B23","v":0},{"$f":"'High Efficiency Motors'!C23","v":0},{"$f":"'High Efficiency Motors'!D23","v":0},{"$f":"'High Efficiency Motors'!E23","v":0},{"$f":"'High Efficiency Motors'!F23","v":0},{"$f":"'High Efficiency Motors'!G23","v":0},{"$f":"'High Efficiency Motors'!H23","v":0},{"$f":"'High Efficiency Motors'!I23","v":0},{"$f":"'High Efficiency Motors'!J23","v":0},{"$f":"'High Efficiency Motors'!K23","v":0},{"$f":"'High Efficiency Motors'!L23","v":0},{"$f":"'High Efficiency Motors'!M23","v":0},{"$f":"'High Efficiency Motors'!N23","v":0},{"$f":"_xlfn.XLOOKUP(A20,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O20=\"Commercial\",_xlfn.XLOOKUP(A20,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O20=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F20,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O20=\"Commercial\",_xlfn.XLOOKUP(A20,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O20=\"Industrial\",_xlfn.XLOOKUP(B20,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O20=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A20,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C20,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O20=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F20,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C20,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F20,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S20,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X20,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF20=\"ER\",_xlfn.XLOOKUP(AH20,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A24","v":0},{"$f":"'High Efficiency Motors'!B24","v":0},{"$f":"'High Efficiency Motors'!C24","v":0},{"$f":"'High Efficiency Motors'!D24","v":0},{"$f":"'High Efficiency Motors'!E24","v":0},{"$f":"'High Efficiency Motors'!F24","v":0},{"$f":"'High Efficiency Motors'!G24","v":0},{"$f":"'High Efficiency Motors'!H24","v":0},{"$f":"'High Efficiency Motors'!I24","v":0},{"$f":"'High Efficiency Motors'!J24","v":0},{"$f":"'High Efficiency Motors'!K24","v":0},{"$f":"'High Efficiency Motors'!L24","v":0},{"$f":"'High Efficiency Motors'!M24","v":0},{"$f":"'High Efficiency Motors'!N24","v":0},{"$f":"_xlfn.XLOOKUP(A21,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O21=\"Commercial\",_xlfn.XLOOKUP(A21,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O21=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F21,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O21=\"Commercial\",_xlfn.XLOOKUP(A21,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O21=\"Industrial\",_xlfn.XLOOKUP(B21,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O21=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A21,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C21,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O21=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F21,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C21,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F21,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S21,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X21,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF21=\"ER\",_xlfn.XLOOKUP(AH21,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A25","v":0},{"$f":"'High Efficiency Motors'!B25","v":0},{"$f":"'High Efficiency Motors'!C25","v":0},{"$f":"'High Efficiency Motors'!D25","v":0},{"$f":"'High Efficiency Motors'!E25","v":0},{"$f":"'High Efficiency Motors'!F25","v":0},{"$f":"'High Efficiency Motors'!G25","v":0},{"$f":"'High Efficiency Motors'!H25","v":0},{"$f":"'High Efficiency Motors'!I25","v":0},{"$f":"'High Efficiency Motors'!J25","v":0},{"$f":"'High Efficiency Motors'!K25","v":0},{"$f":"'High Efficiency Motors'!L25","v":0},{"$f":"'High Efficiency Motors'!M25","v":0},{"$f":"'High Efficiency Motors'!N25","v":0},{"$f":"_xlfn.XLOOKUP(A22,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O22=\"Commercial\",_xlfn.XLOOKUP(A22,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O22=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F22,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O22=\"Commercial\",_xlfn.XLOOKUP(A22,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O22=\"Industrial\",_xlfn.XLOOKUP(B22,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O22=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A22,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C22,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O22=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F22,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C22,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F22,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S22,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X22,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF22=\"ER\",_xlfn.XLOOKUP(AH22,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A26","v":0},{"$f":"'High Efficiency Motors'!B26","v":0},{"$f":"'High Efficiency Motors'!C26","v":0},{"$f":"'High Efficiency Motors'!D26","v":0},{"$f":"'High Efficiency Motors'!E26","v":0},{"$f":"'High Efficiency Motors'!F26","v":0},{"$f":"'High Efficiency Motors'!G26","v":0},{"$f":"'High Efficiency Motors'!H26","v":0},{"$f":"'High Efficiency Motors'!I26","v":0},{"$f":"'High Efficiency Motors'!J26","v":0},{"$f":"'High Efficiency Motors'!K26","v":0},{"$f":"'High Efficiency Motors'!L26","v":0},{"$f":"'High Efficiency Motors'!M26","v":0},{"$f":"'High Efficiency Motors'!N26","v":0},{"$f":"_xlfn.XLOOKUP(A23,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O23=\"Commercial\",_xlfn.XLOOKUP(A23,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O23=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F23,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O23=\"Commercial\",_xlfn.XLOOKUP(A23,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O23=\"Industrial\",_xlfn.XLOOKUP(B23,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O23=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A23,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C23,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O23=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F23,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C23,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F23,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S23,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X23,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF23=\"ER\",_xlfn.XLOOKUP(AH23,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A27","v":0},{"$f":"'High Efficiency Motors'!B27","v":0},{"$f":"'High Efficiency Motors'!C27","v":0},{"$f":"'High Efficiency Motors'!D27","v":0},{"$f":"'High Efficiency Motors'!E27","v":0},{"$f":"'High Efficiency Motors'!F27","v":0},{"$f":"'High Efficiency Motors'!G27","v":0},{"$f":"'High Efficiency Motors'!H27","v":0},{"$f":"'High Efficiency Motors'!I27","v":0},{"$f":"'High Efficiency Motors'!J27","v":0},{"$f":"'High Efficiency Motors'!K27","v":0},{"$f":"'High Efficiency Motors'!L27","v":0},{"$f":"'High Efficiency Motors'!M27","v":0},{"$f":"'High Efficiency Motors'!N27","v":0},{"$f":"_xlfn.XLOOKUP(A24,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O24=\"Commercial\",_xlfn.XLOOKUP(A24,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O24=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F24,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O24=\"Commercial\",_xlfn.XLOOKUP(A24,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O24=\"Industrial\",_xlfn.XLOOKUP(B24,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O24=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A24,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C24,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O24=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F24,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C24,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F24,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S24,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X24,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF24=\"ER\",_xlfn.XLOOKUP(AH24,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[{"$f":"'High Efficiency Motors'!A28","v":0},{"$f":"'High Efficiency Motors'!B28","v":0},{"$f":"'High Efficiency Motors'!C28","v":0},{"$f":"'High Efficiency Motors'!D28","v":0},{"$f":"'High Efficiency Motors'!E28","v":0},{"$f":"'High Efficiency Motors'!F28","v":0},{"$f":"'High Efficiency Motors'!G28","v":0},{"$f":"'High Efficiency Motors'!H28","v":0},{"$f":"'High Efficiency Motors'!I28","v":0},{"$f":"'High Efficiency Motors'!J28","v":0},{"$f":"'High Efficiency Motors'!K28","v":0},{"$f":"'High Efficiency Motors'!L28","v":0},{"$f":"'High Efficiency Motors'!M28","v":0},{"$f":"'High Efficiency Motors'!N28","v":0},{"$f":"_xlfn.XLOOKUP(A25,BuildingTypeMotor,SectorTypeMotor)","v":{"$error":"#N/A"}},{"$f":"IF(O25=\"Commercial\",_xlfn.XLOOKUP(A25,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$G$4:$G$23),IF(O25=\"Industrial\",INDEX('Motor Measure Validation'!$L$5:$L$10,MATCH(F25,'Motor Measure Validation'!$J$5:$J$10,-1),0)))","v":{"$error":"#N/A"}},{"$f":"IF(O25=\"Commercial\",_xlfn.XLOOKUP(A25,'Motor Measure Validation'!$A$4:$A$23,'Motor Measure Validation'!$H$4:$H$23),IF(O25=\"Industrial\",_xlfn.XLOOKUP(B25,Shifts,'Motor Measure Validation'!$C$28:$C$31)))","v":{"$error":"#N/A"}},{"$f":"IF(O25=\"Commercial\",INDEX('Motor Measure Validation'!$C$4:$F$23,MATCH(A25,'Motor Measure Validation'!$A$4:$A$23,0),MATCH(C25,'Motor Measure Validation'!$C$2:$F$2,0)),IF(O25=\"Industrial\",INDEX('Motor Measure Validation'!$M$5:$R$10,MATCH(F25,'Motor Measure Validation'!$J$5:$J$10,-1),MATCH(C25,'Motor Measure Validation'!$M$4:$R$4,0))))","v":{"$error":"#N/A"}},"00",{"$f":"INDEX('Motor Minimum Requirements'!$D$10:$I$34,MATCH(F25,'Motor Minimum Requirements'!$C$10:$C$34,1),MATCH(S25,$B$32:$G$32,0))","v":{"$error":"#N/A"}},0,"No",{"$error":"#N/A"},1,{"$f":"_xlfn.XLOOKUP(X25,'Motor Measure Validation'!$A$38:$A$40,'Motor Measure Validation'!$B$38:$B$40)","v":"Error message 1 - See below"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"ROB",15,15,{"$f":"IF(AF25=\"ER\",_xlfn.XLOOKUP(AH25,MotorAge,'Motor Measure Validation'!$X$2:$X$17),0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0,0]
[]
[]
[]
["Tables Below from AR TRM"]
[]
["Premium Motor Efficiency (IE3 Standard) - ROB"]
[null,"Open6","Open4","Open2","Closed6","Closed4","Closed2","Rewound"]
[null,"Open Motor",null,null,"Closed Motor"]
["hp","6-Pole","4-Pole","2-Pole","6-Pole","4-Pole","2-Pole","Rewound Motor Credit",null,"Motor Horsepower","Efficiency Reduction Factor"]
[1,82.5,85.5,77,82.5,85.5,77,{"$f":"$K$35*100","v":1},null,"< 40",0.01]
[1.5,86.5,86.5,84,87.5,86.5,84,1,null,"≥ 40",5.0000000000000001E-3]
[2,87.5,86.5,85.5,88.5,86.5,85.5,1]
[3,88.5,89.5,85.5,89.5,89.5,86.5,1]
[5,89.5,89.5,86.5,89.5,89.5,88.5,1]
[7.5,90.2,91,88.5,91,91.7,89.5,1]
[10,91.7,91.7,89.5,91,91.7,90.2,1]
[15,91.7,93,90.2,91.7,92.4,91,1]
[20,92.4,93,91,91.7,93,91,1]
[25,93,93.6,91.7,93,93.6,91.7,1]
[30,93.6,94.1,91.7,93,93.6,91.7,1]
[40,94.1,94.1,92.4,94.1,94.1,92.4,{"$f":"$K$36*100","v":0.5}]
[50,94.1,94.5,93,94.1,94.5,93,0.5]
[60,94.5,95,93.6,94.5,95,93.6,0.5]
[75,94.5,95,93.6,94.5,95.4,93.6,0.5]
[100,95,95.4,93.6,95,95.4,94.1,0.5]
[125,95,95.4,94.1,95,95.4,95,0.5]
[150,95.4,95.8,94.1,95.8,95.8,95,0.5]
[200,95.4,95.8,95,95.8,96.2,95.4,0.5]
[250,95.4,95.4,94.5,95,95,95.4,0.5]
[300,95.4,95.4,95,95,95.4,95.4,0.5]
[350,95.4,95.4,95,95,95.4,95.4,0.5]
[400,95.4,95.4,95.4,95,95.4,95.4,0.5]
[450,95.4,95.8,95.8,95,95.4,95.4,0.5]
[500,95.4,95.8,95.8,95,95.8,95.4,0.5]
["Yellow cells are not in NEMA standard. Previous value used"]
["High Efficiency Motor (IE2 Standard) - ER"]
[null,"Open6","Open4","Open2","Closed6","Closed4","Closed2","Rewound"]
["hp","ηbaseline, Open Motors",null,null,"ηbaseline, Closed Motors"]
[null,"6-Pole","4-Pole","2-Pole","6-Pole","4-Pole","2-Pole","Rewound Motor Credit"]
[1,80,82.5,75.5,80,82.5,75.5,{"$f":"$K$35*100","v":1}]
[1.5,84,84,82.5,85.5,84,82.5,1]
[2,85.5,84,84,86.5,84,84,1]
[3,86.5,86.5,84,87.5,87.5,85.5,1]
[5,87.5,87.5,85.5,87.5,87.5,87.5,1]
[7.5,88.5,88.5,87.5,89.5,89.5,88.5,1]
[10,90.2,89.5,88.5,89.5,89.5,89.5,1]
[15,90.2,91,89.5,90.2,91,90.2,1]
[20,91,91,90.2,90.2,91,90.2,1]
[25,91.7,91.7,91,91.7,92.4,91,1]
[30,92.4,92.4,91,91.7,92.4,91,1]
[40,93,93,91.7,93,93,91.7,{"$f":"$K$36*100","v":0.5}]
[50,93,93,92.4,93,93,92.4,0.5]
[60,93.6,93.6,93,93.6,93.6,93,0.5]
[75,93.6,94.1,93,93.6,94.1,93,0.5]
[100,94.1,94.1,93,94.1,94.5,93.6,0.5]
[125,94.1,94.5,93.6,94.1,94.5,94.5,0.5]
[150,94.5,95,93.6,95,95,94.5,0.5]
[200,94.5,95,94.5,95,95,95,0.5]
[250,94.5,95.4,94.5,95,95,95.4,0.5]
[300,94.5,95.4,95,95,95.4,95.4,0.5]
[350,94.5,95.4,95,95,95.4,95.4,0.5]
[400,94.5,95.4,95.4,95,95.4,95.4,0.5]
[450,94.5,95.8,95.8,95,95.4,95.4,0.5]
[500,94.5,95.8,95.8,95,95.8,95.4,0.5]
["Yellow cells are not in NEMA standard. Previous value used"]

{"sheet":"Motor Measure Validation","index":9,"n_rows":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,2,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial","Industrial",null,"Age of Replaced System\n(Years)","RUL\n(Years)"]
[null,"Application Type","Fan","Heating Hot Water Pump","Chilled Water Pump","Condenser Water Pump",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fan","Chemical",null,"5 or less",10]
["Building Type","Sector Type","Fan Run Hours","Heating Run Hours","Cooling Run Hours","Cooling Run Hours","Load Factor","CFw",null,"Max HP","Industrial Processing","Load Factor","Hours",null,null,null,null,null,null,"Heating Hot Water Pump","Paper",null,6,9.1]
["Convenience Store","Commercial",{"$f":"MAX(D4:F4)","v":4136},4136,2084,2084,0.75,0.79,null,null,null,null,"Chemical","Paper","Metals","Petroleum Refinery","Food Production","Other",null,"Chilled Water Pump","Metals",null,7,8.1999999999999993]
["Education: College, University","Commercial",7005,7005,4065,4065,0.75,0.79,null,500,"201-500 hp",0.57999999999999996,5474,6975,7114,5311,3711,5396,null,"Condenser Water Pump","Petroleum Refinery",null,8,7.3]
["Education: K-12","Commercial",5754,5754,2895,2895,0.75,0.79,null,200,"101-200 hp",0.75,5868,6669,7362,4170,5055,4174,null,null,"Food Production",null,9,6.5]
["Garage","Commercial",4849,4849,2102,2102,0.75,0.79,null,100,"51-100 hp",0.54,5853,6741,6698,3763,5524,4732,null,null,"Other",null,10,5.7]
["Grocery","Commercial",7452,7452,5470,5470,0.75,0.79,null,50,"21-50 hp",0.6,4873,5481,4854,3025,4927,3530,null,null,null,null,11,5]
["Health Care: In-Patient","Commercial",6188,4613,6188,6188,0.75,0.79,null,20,"6-20 hp",0.51,4910,4634,4140,1944,3949,3043,null,null,null,null,12,4.4000000000000004]
["Health Care: Out-Patient","Commercial",8760,8760,6364,6364,0.75,0.79,null,5,"1-5 hp",0.54,4082,3997,4377,1582,3829,2283,null,null,null,null,13,3.8]
["Industrial/Manufacturing","Industrial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,3.3]
["Lodging: Common Areas","Commercial",{"$f":"MAX(D12:F12)","v":6340},6340,6227,6227,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,2.8]
["Lodging: Rooms","Commercial",5632,5632,4155,4155,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,2.5]
["Multifamily Housing: Common areas","Commercial",5910,5590,5910,5910,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,2.2000000000000002]
["Nursing Home","Commercial",4711,4711,4373,4373,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,1.9]
["Office","Commercial",4960,4960,4421,4421,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19+",0]
["Public Assembly","Commercial",4412,4412,2714,2714,0.75,0.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"X12","v":2.8},"If unknown, assuming EUL as age"]
["Religious Worship","Commercial",5199,5199,2830,2830,0.75,0.79]
["Restaurant","Commercial",3476,3476,2305,2305,0.75,0.79]
["Retail: Department Store","Commercial",4249,4249,2528,2528,0.75,0.79]
["Retail: Mall","Commercial",4475,4475,2266,2266,0.75,0.79]
["Warehouse","Commercial",4606,4606,770,770,0.75,0.79]
["Commercial - Other","Commercial",5078,5078,2105,2105,0.75,0.79]
[]
[]
[]
["Shift","Hours","CFw - From compressed air measure"]
["Single Shift (8/5)",1976,0.67]
["Two Shifts (16/5)",3952,0.67]
["Three Shifts (24/5)",5928,1]
["Four Shifts (24/7)",8320,1]
[]
[]
[0.75,"% of project cost"]
[0.15,"$/kWh"]
[]
["Error Number","Error Message","Qualifies"]
[0,"Yes","Yes"]
[1,"Error message 1 - See below","No. Please fill in all blue cells. Optional cells in Columns B, M, and N can be left blank if not applicable"]
[2,"Error message 2 - See below","No. Proposed motor does not meet minimum efficiency requirements"]

{"sheet":"Compressed Air Calculations","index":10,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
["Engineered Nozzle","Engineered Nozzles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[{"$f":"'Compressed Air Measures'!A5","v":"Number of Shifts"},{"$f":"'Compressed Air Measures'!B5","v":"Compressor Type"},"Manufacturer",{"$f":"'Compressed Air Measures'!D5","v":"Model Number"},{"$f":"'Compressed Air Measures'!E5","v":"Nozzle Size"},{"$f":"'Compressed Air Measures'!F5","v":"Maximum SCFM @ 80 PSI allowed"},{"$f":"'Compressed Air Measures'!G5","v":"Engineered Nozzle SCFM @ 80 psi"},{"$f":"'Compressed Air Measures'!H5","v":"Quantity"},"CFM Reduced","kW/CFM","Hours of Use","CFs","CFw","SCFM","SCFM (%Reduced)","% Use","All blue cells filled in?","SCFM at or below maximum?","Error reference","Qualifies","kWh Savings","Summer Coincident kW Savings","Winter Coincident kW Savings","Unit Incentive","Total Incentive"]
[{"$f":"'Compressed Air Measures'!A6","v":0},{"$f":"'Compressed Air Measures'!B6","v":0},{"$f":"'Compressed Air Measures'!C6","v":0},{"$f":"'Compressed Air Measures'!D6","v":0},{"$f":"'Compressed Air Measures'!E6","v":0},{"$f":"'Compressed Air Measures'!F6","v":""},{"$f":"'Compressed Air Measures'!G6","v":0},{"$f":"'Compressed Air Measures'!H6","v":0},3,{"$f":"_xlfn.XLOOKUP(B4,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A4,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A4,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A4,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E4,NozzleSize,Validation!$C$2:$C$5)","v":{"$error":"#N/A"}},0.5,0.05,{"$f":"IF(AND(A4<>0,B4<>0,E4<>0,G4<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(G4<=F4,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(Q4=\"Yes\",IF(R4=\"Yes\",0,$R$2),$Q$2)","v":1},{"$f":"IF(AND(A4<>0,B4<>0,E4<>0,G4<>\"\",G4<=F4),\"Yes\",\"No\")","v":"No"},{"$f":"N4*O4*J4*P4*K4*H4","v":{"$error":"#N/A"}},{"$f":"U4/K4*L4","v":{"$error":"#N/A"}},{"$f":"U4/K4*M4","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E4,NozzleSize,NozzleIncentive)","v":{"$error":"#N/A"}},{"$f":"IF(T4=\"Yes\",X4*H4,0)","v":0}]
[{"$f":"'Compressed Air Measures'!A7","v":0},{"$f":"'Compressed Air Measures'!B7","v":0},{"$f":"'Compressed Air Measures'!C7","v":0},{"$f":"'Compressed Air Measures'!D7","v":0},{"$f":"'Compressed Air Measures'!E7","v":0},{"$f":"'Compressed Air Measures'!F7","v":""},{"$f":"'Compressed Air Measures'!G7","v":0},{"$f":"'Compressed Air Measures'!H7","v":0},3,{"$f":"_xlfn.XLOOKUP(B5,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A5,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A5,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A5,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E5,NozzleSize,Validation!$C$2:$C$5)","v":{"$error":"#N/A"}},0.5,0.05,{"$f":"IF(AND(A5<>0,B5<>0,E5<>0,G5<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(G5<=F5,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(Q5=\"Yes\",IF(R5=\"Yes\",0,$R$2),$Q$2)","v":1},{"$f":"IF(AND(A5<>0,B5<>0,E5<>0,G5<>\"\",G5<=F5),\"Yes\",\"No\")","v":"No"},{"$f":"N5*O5*J5*P5*K5*H5","v":{"$error":"#N/A"}},{"$f":"U5/K5*L5","v":{"$error":"#N/A"}},{"$f":"U5/K5*M5","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E5,NozzleSize,NozzleIncentive)","v":{"$error":"#N/A"}},{"$f":"IF(T5=\"Yes\",X5*H5,0)","v":0}]
[{"$f":"'Compressed Air Measures'!A8","v":0},{"$f":"'Compressed Air Measures'!B8","v":0},{"$f":"'Compressed Air Measures'!C8","v":0},{"$f":"'Compressed Air Measures'!D8","v":0},{"$f":"'Compressed Air Measures'!E8","v":0},{"$f":"'Compressed Air Measures'!F8","v":""},{"$f":"'Compressed Air Measures'!G8","v":0},{"$f":"'Compressed Air Measures'!H8","v":0},3,{"$f":"_xlfn.XLOOKUP(B6,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A6,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A6,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A6,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E6,NozzleSize,Validation!$C$2:$C$5)","v":{"$error":"#N/A"}},0.5,0.05,{"$f":"IF(AND(A6<>0,B6<>0,E6<>0,G6<>0),\"Yes\",\"No\")","v":"No"},"Yes",1,{"$f":"IF(AND(A6<>0,B6<>0,E6<>0,G6<>\"\",G6<=F6),\"Yes\",\"No\")","v":"No"},{"$f":"N6*O6*J6*P6*K6*H6","v":{"$error":"#N/A"}},{"$f":"U6/K6*L6","v":{"$error":"#N/A"}},{"$f":"U6/K6*M6","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E6,NozzleSize,NozzleIncentive)","v":{"$error":"#N/A"}},0]
[{"$f":"'Compressed Air Measures'!A9","v":0},{"$f":"'Compressed Air Measures'!B9","v":0},{"$f":"'Compressed Air Measures'!C9","v":0},{"$f":"'Compressed Air Measures'!D9","v":0},{"$f":"'Compressed Air Measures'!E9","v":0},{"$f":"'Compressed Air Measures'!F9","v":""},{"$f":"'Compressed Air Measures'!G9","v":0},{"$f":"'Compressed Air Measures'!H9","v":0},3,{"$f":"_xlfn.XLOOKUP(B7,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A7,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A7,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A7,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E7,NozzleSize,Validation!$C$2:$C$5)","v":{"$error":"#N/A"}},0.5,0.05,{"$f":"IF(AND(A7<>0,B7<>0,E7<>0,G7<>0),\"Yes\",\"No\")","v":"No"},"Yes",1,{"$f":"IF(AND(A7<>0,B7<>0,E7<>0,G7<>\"\",G7<=F7),\"Yes\",\"No\")","v":"No"},{"$f":"N7*O7*J7*P7*K7*H7","v":{"$error":"#N/A"}},{"$f":"U7/K7*L7","v":{"$error":"#N/A"}},{"$f":"U7/K7*M7","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(E7,NozzleSize,NozzleIncentive)","v":{"$error":"#N/A"}},0]
[]
[]
[]
["No-Loss Condensate Drains","No Loss Drains",null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"'Compressed Air Measures'!A14","v":"Number of Shifts"},{"$f":"'Compressed Air Measures'!C14","v":"Compressor Type"},{"$f":"'Compressed Air Measures'!E14","v":"Manufacturer"},"Model number",{"$f":"'Compressed Air Measures'!H14","v":"Quantity"},"CFM Reduced","kW/CFM","Hours of Use","CFs","CFw","kWh Savings","Summer Coincident kW Savings","Winter Coincident kW Savings","All blue cells filled in?","Error reference","Qualifies","Unit Incentive","Total Incentive"]
[{"$f":"'Compressed Air Measures'!A15","v":0},{"$f":"'Compressed Air Measures'!C15","v":0},{"$f":"'Compressed Air Measures'!E15","v":0},{"$f":"'Compressed Air Measures'!G15","v":0},{"$f":"'Compressed Air Measures'!H15","v":0},3,{"$f":"_xlfn.XLOOKUP(B13,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A13,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A13,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A13,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"G13*H13*F13*E13","v":{"$error":"#N/A"}},{"$f":"K13/H13*I13","v":{"$error":"#N/A"}},{"$f":"K13/H13*J13","v":{"$error":"#N/A"}},{"$f":"IF(AND(A13<>0,B13<>0,C13<>0,E13<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(N13=\"Yes\",0,$N$11)","v":1},{"$f":"IF(N13=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"Validation!$B$6","v":100},{"$f":"IF(P13=\"Yes\",Q13*E13,0)","v":0}]
[{"$f":"'Compressed Air Measures'!A16","v":0},{"$f":"'Compressed Air Measures'!C16","v":0},{"$f":"'Compressed Air Measures'!E16","v":0},{"$f":"'Compressed Air Measures'!G16","v":0},{"$f":"'Compressed Air Measures'!H16","v":0},3,{"$f":"_xlfn.XLOOKUP(B14,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A14,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A14,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A14,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"G14*H14*F14*E14","v":{"$error":"#N/A"}},{"$f":"K14/H14*I14","v":{"$error":"#N/A"}},{"$f":"K14/H14*J14","v":{"$error":"#N/A"}},{"$f":"IF(AND(A14<>0,B14<>0,C14<>0,E14<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(N14=\"Yes\",0,$N$11)","v":1},{"$f":"IF(N14=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"Validation!$B$6","v":100},{"$f":"IF(P14=\"Yes\",Q14*E14,0)","v":0}]
[{"$f":"'Compressed Air Measures'!A17","v":0},{"$f":"'Compressed Air Measures'!C17","v":0},{"$f":"'Compressed Air Measures'!E17","v":0},{"$f":"'Compressed Air Measures'!G17","v":0},{"$f":"'Compressed Air Measures'!H17","v":0},3,{"$f":"_xlfn.XLOOKUP(B15,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A15,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A15,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A15,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"G15*H15*F15*E15","v":{"$error":"#N/A"}},{"$f":"K15/H15*I15","v":{"$error":"#N/A"}},{"$f":"K15/H15*J15","v":{"$error":"#N/A"}},{"$f":"IF(AND(A15<>0,B15<>0,C15<>0,E15<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(N15=\"Yes\",0,$N$11)","v":1},{"$f":"IF(N15=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"Validation!$B$6","v":100},{"$f":"IF(P15=\"Yes\",Q15*E15,0)","v":0}]
[{"$f":"'Compressed Air Measures'!A18","v":0},{"$f":"'Compressed Air Measures'!C18","v":0},{"$f":"'Compressed Air Measures'!E18","v":0},{"$f":"'Compressed Air Measures'!G18","v":0},{"$f":"'Compressed Air Measures'!H18","v":0},3,{"$f":"_xlfn.XLOOKUP(B16,CompressorType,Validation!$L$2:$L$8)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A16,ShiftType,Validation!$G$2:$G$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A16,ShiftType,Validation!$H$2:$H$5)","v":{"$error":"#N/A"}},{"$f":"_xlfn.XLOOKUP(A16,ShiftType,Validation!$I$2:$I$5)","v":{"$error":"#N/A"}},{"$f":"G16*H16*F16*E16","v":{"$error":"#N/A"}},{"$f":"K16/H16*I16","v":{"$error":"#N/A"}},{"$f":"K16/H16*J16","v":{"$error":"#N/A"}},{"$f":"IF(AND(A16<>0,B16<>0,C16<>0,E16<>0),\"Yes\",\"No\")","v":"No"},{"$f":"IF(N16=\"Yes\",0,$N$11)","v":1},{"$f":"IF(N16=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"Validation!$B$6","v":100},{"$f":"IF(P16=\"Yes\",Q16*E16,0)","v":0}]

{"sheet":"Validation","index":11,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Measure","Incentive","Default SCFM","Max Allowed SCFM @80psi",null,"Shift","Hours","CFs","CFw",null,"Air Compressor Type","kW/CFM"]
["1/8\" Nozzle",50,21,11,null,"Single Shift (8/5)",1976,0.59,0.67,null,"Reciprocating – On/off Control",0.184]
["1/4\" Nozzle",50,58,29,null,"Two Shifts (16/5)",3952,0.95,0.67,null,"Reciprocating – Load/Unload",0.13600000000000001]
["5/16\" Nozzle",50,113,56,null,"Three Shifts (24/5)",5928,0.95,1,null,"Screw – Load/Unload",0.152]
["1/2\" Nozzle",50,280,140,null,"Four Shifts or Continual Operation (24/7)",8320,0.95,1,null,"Screw – Inlet Modulation",5.5E-2]
["No-Loss Drain",100,null,null,null,null,null,null,null,null,"Screw – Inlet Modulation w/ Unloading",5.5E-2]
[null,null,null,null,null,null,null,null,null,null,"Screw – Variable Displacement",0.153]
[null,null,null,null,null,null,null,null,null,null,"Screw - VFD",0.17799999999999999]
[]
[]
[]
["Compressed Air Qualify Messages"]
["Reference","Qualifies","Message","Applies to:"]
[0,"Yes","Yes","Both Measures"]
[1,"No. Incomplete","No. Please fill in all blue cells in this row.","Both Measures"]
[2,"No. Max SCFM","No. SCFM rating exceeds maximum allowed.","Only Efficient Nozzles"]

{"sheet":"Attribute Crosswalk","index":12,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[]
["Product Name","Attribute","Plain English Description","Default Value","Validation Type","Question/Note",null,"Attribute used in measure"]
["Engineered Nozzles","CALCULATOR_VERSION","Calculator version",null,"TEXT",null,null,"New attribute needed"]
["Engineered Nozzles","CUSTOMER_REFID","Measure code","ENOZ","TEXT","Is this measure code?"]
["Engineered Nozzles","Quantity","Quantity of nozzles",1,"NUMERIC"]
["Engineered Nozzles","MEASURE_LIFE","Measure life",null,"NUMERIC"]
["Engineered Nozzles","KW_IMPACT","???",null,"NUMERIC","Is this summer or winter and is it total or per unit savings?"]
["Engineered Nozzles","KW_WINTER_1","Winter coincident peak demand savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["Engineered Nozzles","KW_SUMMER_GROSS","Summer coincident peak demand savings",null,"TEXT","Assumed per unit savings. Is this correct?"]
["Engineered Nozzles","KWH_IMPACT","kWh savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["Engineered Nozzles","INCENTIVE_PER_UNIT","Incentive per nozzle",null,"TEXT"]
["Engineered Nozzles","ELEC_UTIL_CUST_INCENTIVE","Incentive per nozzle",null,"TEXT"]
["Engineered Nozzles","MODEL","Model number",null,"TEXT"]
["Engineered Nozzles","BUILDING_TYPE_SEL"]
["Engineered Nozzles","INSTALL_TYPE_SEL"]
["Engineered Nozzles","NATURAL_GAS_SAVINGS_MMBTU"]
["Engineered Nozzles","Manufacturer"]
["Engineered Nozzles","NUMBER_UNITS","Number of shifts",null,"TEXT"]
["Engineered Nozzles","COMPRESSOR_TYPE","Compressor type",null,"TEXT"]
["Engineered Nozzles","SIZE","Nozzle Size",null,"TEXT"]
["Engineered Nozzles","INPUT_RATING","SCFM at 80 psi",null,"TEXT"]
[]
[]
["Product Name","Attribute","Plain English Description","Default Value","Validation Type","Question/Note"]
["Zero Loss Drains","CALCULATOR_VERSION","Calculator version",null,"TEXT"]
["Zero Loss Drains","CUSTOMER_REFID","Measure code","ZLD","TEXT","Is this measure code?"]
["Zero Loss Drains","Quantity","Quantity of nozzles",1,"NUMERIC"]
["Zero Loss Drains","MEASURE_LIFE","Measure life",null,"NUMERIC"]
["Zero Loss Drains","KW_IMPACT","???",null,"NUMERIC","Is this summer or winter and is it total or per unit savings?"]
["Zero Loss Drains","KW_WINTER_1","Winter coincident peak demand savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["Zero Loss Drains","KW_SUMMER_GROSS","Summer coincident peak demand savings",null,"TEXT","Assumed per unit savings. Is this correct?"]
["Zero Loss Drains","KWH_IMPACT","kWh savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["Zero Loss Drains","INCENTIVE_PER_UNIT","Incentive per drain",null,"TEXT"]
["Zero Loss Drains","ELEC_UTIL_CUST_INCENTIVE","Incentive per drain",null,"TEXT"]
["Zero Loss Drains","MODEL","Model number",null,"TEXT"]
["Zero Loss Drains","Manufacturer","Manufacturer"]
["Zero Loss Drains","INSTALL_TYPE_SEL"]
["Zero Loss Drains","BUILDING_TYPE_SEL"]
["Zero Loss Drains","NATURAL_GAS_SAVINGS_MMBTU"]
["Zero Loss Drains","Shifts","Number of shifts",null,"TEXT","Do we need a new attribute"]
["Zero Loss Drains","Compressor_Type","Compressor type",null,"TEXT","Do we need a new attribute"]
[]
[]
["Product Name","Attribute","Plain English Description","Default Value","Validation Type","Question/Note"]
["High Efficiency Motors","CALCULATOR_VERSION","Calculator version",null,"TEXT"]
["High Efficiency Motors","CUSTOMER_REFID","Measure code","HEM","TEXT","Is this measure code?"]
["High Efficiency Motors","Quantity","Quantity of nozzles",1,"NUMERIC"]
["High Efficiency Motors","MEASURE_LIFE","Measure life",null,"NUMERIC"]
["High Efficiency Motors","KW_IMPACT","Winter coincident peak demand savings",null,"NUMERIC"]
["High Efficiency Motors","KW_WINTER_1","Winter coincident peak demand savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["High Efficiency Motors","KWH_IMPACT","kWh savings",null,"NUMERIC","Assumed per unit savings. Is this correct?"]
["High Efficiency Motors","KW_SUMMER_GROSS","Summer peak demand savings",null,"NUMERIC"]
["High Efficiency Motors","INCENTIVE_PER_UNIT","Incentive per nozzle",null,"TEXT"]
["High Efficiency Motors","ELEC_UTIL_CUST_INCENTIVE","Total incentive",null,"TEXT"]
["High Efficiency Motors","MANUFACTURER","Manufacturer",null,"TEXT"]
["High Efficiency Motors","MODEL","Model number",null,"TEXT"]
["High Efficiency Motors","building_type_sel","Business Type",null,"TEXT"]
["High Efficiency Motors","HRS_OF_USE",null,null,"NUMERIC"]
["High Efficiency Motors","FLE_EFFICIENCY_UNIT",null,null,"NUMERIC"]
["High Efficiency Motors","NATURAL_GAS_SAVINGS_MMBTU",null,null,"NUMERIC"]
["High Efficiency Motors","BASELINE_HP",null,null,"NUMERIC"]
["High Efficiency Motors","BUILDING_TYPE_SEL",null,null,"TEXT"]
["High Efficiency Motors","INSTALL_TYPE_SEL",null,null,"TEXT"]
["High Efficiency Motors","Shifts","Number of shifts",null,"TEXT"]

{"sheet":"AEG Import","index":13,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Measure #","Import?","CALCULATOR_VERSION","CUSTOMER_REFID","Quantity","MEASURE_LIFE","KW_IMPACT","KW_WINTER_1","KW_SUMMER_GROSS","KWH_IMPACT","INCENTIVE_PER_UNIT","ELEC_UTIL_CUST_INCENTIVE","MANUFACTURER","MODEL","building_type_sel","NUMBER_UNITS","COMPRESSOR_TYPE","SIZE","INPUT_RATING"]
[null,"No","Compressed Air Engineered Nozzles"]
["ENOZ",{"$f":"IF('Compressed Air Calculations'!T4=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ENOZ",{"$f":"'Compressed Air Calculations'!H4","v":0},15,{"$f":"H3","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!W4/E3","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!V4/E3","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!U4/E3","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!X4","v":{"$error":"#N/A"}},{"$f":"K3","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!C4","v":0},{"$f":"'Compressed Air Calculations'!D4","v":0},null,{"$f":"'Compressed Air Calculations'!A4","v":0},{"$f":"'Compressed Air Calculations'!B4","v":0},{"$f":"'Compressed Air Calculations'!E4","v":0},{"$f":"'Compressed Air Calculations'!G4","v":0}]
["ENOZ",{"$f":"IF('Compressed Air Calculations'!T5=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ENOZ",{"$f":"'Compressed Air Calculations'!H5","v":0},15,{"$f":"H4","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!W5/E4","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!V5/E4","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!U5/E4","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!X5","v":{"$error":"#N/A"}},{"$f":"K4","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!C5","v":0},{"$f":"'Compressed Air Calculations'!D5","v":0},null,{"$f":"'Compressed Air Calculations'!A5","v":0},{"$f":"'Compressed Air Calculations'!B5","v":0},{"$f":"'Compressed Air Calculations'!E5","v":0},{"$f":"'Compressed Air Calculations'!G5","v":0}]
["ENOZ",{"$f":"IF('Compressed Air Calculations'!T6=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ENOZ",{"$f":"'Compressed Air Calculations'!H6","v":0},15,{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!W6/E5","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!V6/E5","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!U6/E5","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!X6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!C6","v":0},{"$f":"'Compressed Air Calculations'!D6","v":0},null,{"$f":"'Compressed Air Calculations'!A6","v":0},{"$f":"'Compressed Air Calculations'!B6","v":0},{"$f":"'Compressed Air Calculations'!E6","v":0},{"$f":"'Compressed Air Calculations'!G6","v":0}]
["ENOZ",{"$f":"IF('Compressed Air Calculations'!T7=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ENOZ",{"$f":"'Compressed Air Calculations'!H7","v":0},15,{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!W7/E6","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!V7/E6","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!U7/E6","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!X7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!C7","v":0},{"$f":"'Compressed Air Calculations'!D7","v":0},null,{"$f":"'Compressed Air Calculations'!A7","v":0},{"$f":"'Compressed Air Calculations'!B7","v":0},{"$f":"'Compressed Air Calculations'!E7","v":0},{"$f":"'Compressed Air Calculations'!G7","v":0}]
[null,"No","Zero Loss Drains"]
["ZLD",{"$f":"IF('Compressed Air Calculations'!P13=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ZLD",{"$f":"'Compressed Air Calculations'!E13","v":0},13,{"$f":"H8","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!M13/E8","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L13/E8","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!K13/E8","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!Q13","v":100},{"$f":"K8","v":100},{"$f":"'Compressed Air Calculations'!C13","v":0},{"$f":"'Compressed Air Calculations'!D13","v":0},null,{"$f":"'Compressed Air Calculations'!A13","v":0},{"$f":"'Compressed Air Calculations'!B13","v":0}]
["ZLD",{"$f":"IF('Compressed Air Calculations'!P14=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ZLD",{"$f":"'Compressed Air Calculations'!E14","v":0},13,{"$f":"H9","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!M14/E9","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L14/E9","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!K14/E9","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!Q14","v":100},{"$f":"K9","v":100},{"$f":"'Compressed Air Calculations'!C14","v":0},{"$f":"'Compressed Air Calculations'!D14","v":0},null,{"$f":"'Compressed Air Calculations'!A14","v":0},{"$f":"'Compressed Air Calculations'!B14","v":0}]
["ZLD",{"$f":"IF('Compressed Air Calculations'!P15=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ZLD",{"$f":"'Compressed Air Calculations'!E15","v":0},13,{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!M15/E10","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L15/E10","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!K15/E10","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!Q15","v":100},100,{"$f":"'Compressed Air Calculations'!C15","v":0},{"$f":"'Compressed Air Calculations'!D15","v":0},null,{"$f":"'Compressed Air Calculations'!A15","v":0},{"$f":"'Compressed Air Calculations'!B15","v":0}]
["ZLD",{"$f":"IF('Compressed Air Calculations'!P16=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"ZLD",{"$f":"'Compressed Air Calculations'!E16","v":0},13,{"$error":"#N/A"},{"$f":"'Compressed Air Calculations'!M16/E11","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!L16/E11","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!K16/E11","v":{"$error":"#N/A"}},{"$f":"'Compressed Air Calculations'!Q16","v":100},100,{"$f":"'Compressed Air Calculations'!C16","v":0},{"$f":"'Compressed Air Calculations'!D16","v":0},null,{"$f":"'Compressed Air Calculations'!A16","v":0},{"$f":"'Compressed Air Calculations'!B16","v":0}]
[null,"No","High Efficiency Motors"]
["HEM",{"$f":"IF('Motor Calcs'!Y6=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J6","v":0},{"$f":"'Motor Calcs'!AG6","v":15},{"$f":"H13","v":{"$error":"#DIV/0!"}},{"$f":"'Motor Calcs'!AM6/E13","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL6/E13","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U9","v":0},{"$f":"K13","v":0},{"$f":"'Motor Calcs'!D6","v":0},{"$f":"'Motor Calcs'!E6","v":0},{"$f":"'Motor Calcs'!A6","v":0},{"$f":"'Motor Calcs'!B6","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y7=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J7","v":0},{"$f":"'Motor Calcs'!AG7","v":15},{"$f":"H14","v":{"$error":"#DIV/0!"}},{"$f":"'Motor Calcs'!AM7/E14","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL7/E14","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U10","v":0},{"$f":"K14","v":0},{"$f":"'Motor Calcs'!D7","v":0},{"$f":"'Motor Calcs'!E7","v":0},{"$f":"'Motor Calcs'!A7","v":0},{"$f":"'Motor Calcs'!B7","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y8=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J8","v":0},{"$f":"'Motor Calcs'!AG8","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM8/E15","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL8/E15","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U11","v":0},0,{"$f":"'Motor Calcs'!D8","v":0},{"$f":"'Motor Calcs'!E8","v":0},{"$f":"'Motor Calcs'!A8","v":0},{"$f":"'Motor Calcs'!B8","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y9=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J9","v":0},{"$f":"'Motor Calcs'!AG9","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM9/E16","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL9/E16","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U12","v":0},0,{"$f":"'Motor Calcs'!D9","v":0},{"$f":"'Motor Calcs'!E9","v":0},{"$f":"'Motor Calcs'!A9","v":0},{"$f":"'Motor Calcs'!B9","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y10=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J10","v":0},{"$f":"'Motor Calcs'!AG10","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM10/E17","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL10/E17","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U13","v":0},0,{"$f":"'Motor Calcs'!D10","v":0},{"$f":"'Motor Calcs'!E10","v":0},{"$f":"'Motor Calcs'!A10","v":0},{"$f":"'Motor Calcs'!B10","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y11=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J11","v":0},{"$f":"'Motor Calcs'!AG11","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM11/E18","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL11/E18","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U14","v":0},0,{"$f":"'Motor Calcs'!D11","v":0},{"$f":"'Motor Calcs'!E11","v":0},{"$f":"'Motor Calcs'!A11","v":0},{"$f":"'Motor Calcs'!B11","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y12=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J12","v":0},{"$f":"'Motor Calcs'!AG12","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM12/E19","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL12/E19","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U15","v":0},0,{"$f":"'Motor Calcs'!D12","v":0},{"$f":"'Motor Calcs'!E12","v":0},{"$f":"'Motor Calcs'!A12","v":0},{"$f":"'Motor Calcs'!B12","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y13=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J13","v":0},{"$f":"'Motor Calcs'!AG13","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM13/E20","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL13/E20","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U16","v":0},0,{"$f":"'Motor Calcs'!D13","v":0},{"$f":"'Motor Calcs'!E13","v":0},{"$f":"'Motor Calcs'!A13","v":0},{"$f":"'Motor Calcs'!B13","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y14=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J14","v":0},{"$f":"'Motor Calcs'!AG14","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM14/E21","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL14/E21","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U17","v":0},0,{"$f":"'Motor Calcs'!D14","v":0},{"$f":"'Motor Calcs'!E14","v":0},{"$f":"'Motor Calcs'!A14","v":0},{"$f":"'Motor Calcs'!B14","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y15=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J15","v":0},{"$f":"'Motor Calcs'!AG15","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM15/E22","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL15/E22","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U18","v":0},0,{"$f":"'Motor Calcs'!D15","v":0},{"$f":"'Motor Calcs'!E15","v":0},{"$f":"'Motor Calcs'!A15","v":0},{"$f":"'Motor Calcs'!B15","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y16=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J16","v":0},{"$f":"'Motor Calcs'!AG16","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM16/E23","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL16/E23","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U19","v":0},0,{"$f":"'Motor Calcs'!D16","v":0},{"$f":"'Motor Calcs'!E16","v":0},{"$f":"'Motor Calcs'!A16","v":0},{"$f":"'Motor Calcs'!B16","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y17=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J17","v":0},{"$f":"'Motor Calcs'!AG17","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM17/E24","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL17/E24","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U20","v":0},0,{"$f":"'Motor Calcs'!D17","v":0},{"$f":"'Motor Calcs'!E17","v":0},{"$f":"'Motor Calcs'!A17","v":0},{"$f":"'Motor Calcs'!B17","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y18=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J18","v":0},{"$f":"'Motor Calcs'!AG18","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM18/E25","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL18/E25","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U21","v":0},0,{"$f":"'Motor Calcs'!D18","v":0},{"$f":"'Motor Calcs'!E18","v":0},{"$f":"'Motor Calcs'!A18","v":0},{"$f":"'Motor Calcs'!B18","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y19=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J19","v":0},{"$f":"'Motor Calcs'!AG19","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM19/E26","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL19/E26","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U22","v":0},0,{"$f":"'Motor Calcs'!D19","v":0},{"$f":"'Motor Calcs'!E19","v":0},{"$f":"'Motor Calcs'!A19","v":0},{"$f":"'Motor Calcs'!B19","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y20=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J20","v":0},{"$f":"'Motor Calcs'!AG20","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM20/E27","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL20/E27","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U23","v":0},0,{"$f":"'Motor Calcs'!D20","v":0},{"$f":"'Motor Calcs'!E20","v":0},{"$f":"'Motor Calcs'!A20","v":0},{"$f":"'Motor Calcs'!B20","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y21=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J21","v":0},{"$f":"'Motor Calcs'!AG21","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM21/E28","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL21/E28","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U24","v":0},0,{"$f":"'Motor Calcs'!D21","v":0},{"$f":"'Motor Calcs'!E21","v":0},{"$f":"'Motor Calcs'!A21","v":0},{"$f":"'Motor Calcs'!B21","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y22=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J22","v":0},{"$f":"'Motor Calcs'!AG22","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM22/E29","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL22/E29","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U25","v":0},0,{"$f":"'Motor Calcs'!D22","v":0},{"$f":"'Motor Calcs'!E22","v":0},{"$f":"'Motor Calcs'!A22","v":0},{"$f":"'Motor Calcs'!B22","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y23=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J23","v":0},{"$f":"'Motor Calcs'!AG23","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM23/E30","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL23/E30","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U26","v":0},0,{"$f":"'Motor Calcs'!D23","v":0},{"$f":"'Motor Calcs'!E23","v":0},{"$f":"'Motor Calcs'!A23","v":0},{"$f":"'Motor Calcs'!B23","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y24=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J24","v":0},{"$f":"'Motor Calcs'!AG24","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM24/E31","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL24/E31","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U27","v":0},0,{"$f":"'Motor Calcs'!D24","v":0},{"$f":"'Motor Calcs'!E24","v":0},{"$f":"'Motor Calcs'!A24","v":0},{"$f":"'Motor Calcs'!B24","v":0}]
["HEM",{"$f":"IF('Motor Calcs'!Y25=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"'Version Tracking'!$C$4","v":15.1},"HEM",{"$f":"'Motor Calcs'!J25","v":0},{"$f":"'Motor Calcs'!AG25","v":15},{"$error":"#DIV/0!"},{"$f":"'Motor Calcs'!AM25/E32","v":{"$error":"#DIV/0!"}},null,{"$f":"'Motor Calcs'!AL25/E32","v":{"$error":"#DIV/0!"}},{"$f":"'High Efficiency Motors'!U28","v":0},0,{"$f":"'Motor Calcs'!D25","v":0},{"$f":"'Motor Calcs'!E25","v":0},{"$f":"'Motor Calcs'!A25","v":0},{"$f":"'Motor Calcs'!B25","v":0}]
[null,"No","End"]

{"sheet":"Version Tracking","index":14,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B49955<>\"\"),B1:B49955)","v":15.1}]
[null,"Version","Notes","Date","Updated By"]
[null,15.1,"New workbook","2025-03-06","LL/JME"]