{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Form Instructions","Project Information","Checklist & Acknowledgement","Terms and Conditions","Technical Requirements","Equipment Input Instructions","HE Food Prep Equip","Ice Machines","Refrig & Freezers","Clothes Washers","HE Refrig Components","Receptacle Load Controls","Inventory Instructions","Inputs","Input Key","Measure Code Summary","Validation","Lookups","Version Tracking","AEG Import"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":49,"defined_names":2595,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

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

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

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

{"sheet":"Technical Requirements","index":4,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,14,13,15],[11,0,11,14],[12,0,12,14],[7,0,7,14],[8,0,8,14],[9,0,9,14],[3,0,3,14],[10,0,10,14],[0,0,0,14],[1,0,1,14],[2,0,2,14],[4,0,4,14],[5,0,5,14],[6,0,6,14]]}
[]
["TECHNICAL REQUIREMENTS: HIGH-EFFICIENCY COMMERCIAL EQUIPMENT"]
["§ Only ENERGY STAR®-qualified equipment is eligible for incentives under this application. \n§ Cook and hold food cabinets are not eligible for incentives.\n§ Electric steam cookers with greater than six-pan capacity may be considered for incentives under the Custom application.\n§ Only air-cooled machines (self-contained, ice making heads or remote condensing) are eligible. Commercial ice machines with remote condensing units must be purchased with their ARI-rated cuber.\n§ Drawer cabinets, prep tables, deli cases, and open air units are not eligible for incentives.\n§ For lists of qualified products, visit:"]
["http://www.energystar.gov/products?s=mega"]
["TECHNICAL REQUIREMENTS: HIGH-EFFICIENCY REFRIGERATION COMPONENTS"]
["§ Anti-sweat heater controls must sense the relative humidity or dew point of the surrounding air to control glass door or frame anti-sweat heaters."]
["§ The replacement unit must be an Electronically Commutated Motor, which is a brushless DC motor that operates more efficiently than standard electro-mechanical\nrefrigeration fan motors. Electronically Commutated Motor fan motors must replace an existing standard-efficiency shaded-pole evaporator or permanent split\ncapacitor fan motor in refrigerated walk-in, reach-in, or display boxes (coolers or freezers)."]
["§    Refrigeration night covers must be applied for a minimum of six hours per day to qualify for incentives. Covers may be applied to medium- or low-temperature open cases of horizontal or vertical configuration."]
["§ LED refrigerated case lighting must be installed as a retrofit measure to replace existing linear fluorescent case lighting. To qualify for incentives, the existing ballast and lampholders must be permanently removed and replaced with an LED refrigeration retrofit kit certified by a Nationally Recognized Testing Laboratory (NRTL). Existing wiring may be reused, if necessary."]
["§ LED refrigerated case lighting controls may be installed for stand-alone or aisle refrigerated cases."]
["TECHNICAL REQUIREMENTS: RECEPTACLE LOAD CONTROLS"]
["§ Vending machine controls may be installed to de-energize machines when the facility is not occupied. Controls must include a passive infrared sensor to turn off\nlighting. For refrigerated machines, controls must be able to cycle the compressor to maintain products at a maximum desired temperature."]
["§    Personal receptacle occupancy sensors may be installed in open, private or common areas of office facilities. Controls must include a passive infrared occupancy\nsensor and connected power strip. The power strip must be able to maintain constant power for selected loads. To qualify for incentives, provide information on\naverage connected load per sensor. Suggested loads include task lighting, personal printers, monitors, and related equipment."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"Equipment Input Instructions","index":5,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,7,31,8],[27,2,27,6],[13,3,13,6],[26,2,26,6],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[24,2,24,6],[25,2,25,6],[5,1,5,7]]}
[]
[]
[]
[]
[null,"Food Service High Efficiency Equipment"]
[]
[null,null,null,"Copyright © 2015 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[]
[]
[]
[]
[]
[null,null,null,"*If an error occurs when using buttons above, manually navigate to appropriate tab"]
[]
[null,null,"Instructions"]
[null,null,"The following tabs are available Equipment tabs for the Food Service High Efficiency Application"]
[null,null,"▪    HE Food Prep Equip - High efficiency electric commercial cooking equipment including steam cookers, insulated hot holding cabinets, fryers, griddles, and ovens"]
[null,null,"▪    Ice Machines - Commercial ice machines with remote condensing units"]
[null,null,"▪    Refrig & Freezers - Commercial solid or glass reach-in units"]
[null,null,"▪    Clothes Washers - for commerical clothes washer only"]
[null,null,"▪    HE Refrig Components - Including anti-sweat heater controls, ECM motors, night covers and LED case lighting and controls"]
[null,null,"▪    Receptacle Load Controls - Including vending machine controls and personal receptacle occupancy sensors"]
[]
[null,null,"1. Read Technical Requirements tab for detailed information on equipment requirements and eligibility."]
[null,null,"2. Enter make, model and quantity of equipment being applied for in shaded areas of applicable Equipment tab(s)"]
[null,null,"3. Measure Code Summary tab will be automatically populated based on Equipment tab entries."]
[null,null,"4. Application packages must be submitted by email."]
[null,null,null,"Email Address:"]
[null,null,null,"SCEnergyExperts@DominionEnergySC.com"]
[]
[null,null,null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"HE Food Prep Equip","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,6,16,7],[0,0,0,6],[1,0,1,6],[14,0,14,5],[3,0,6,0],[7,0,9,0]]}
["Fill in Blue Cells Only!"]
["HIGH-EFFICIENCY FOOD PREPARATION EQUIPMENT"]
["Measure","Type/Size","Incentive/Unit","Make and Model","For Insulated Hot Holding Cabinets Enter Volume (ft3)","Quantity of Units Installed ","Total Incentive"]
["Steam Cookers","3 Pan",800,null,null,null,{"$f":"C4*F4","v":0}]
[null,"4 Pan",800,null,null,null,{"$f":"C5*F5","v":0}]
[null,"5 Pan",1200,null,null,null,0]
[null,"6 Pan",1200,null,null,null,0]
["Insulated Hot Holding Cabinets","Half Size                                      0 < V < 13",300,null,null,null,{"$f":"C8*F8","v":0}]
[null,"3/4 Size                                                          13 ≤ V < 28 ",400,null,null,null,{"$f":"C9*F9","v":0}]
[null,"Full Size                                                               28 ≤ V",500,null,null,null,0]
["High-Efficiency Electric Fryers","Large Vat","$300/Vat",null,null,null,{"$f":"F11*300","v":0}]
["Electric Griddles","All",300,null,null,null,{"$f":"C12*F12","v":0}]
["High-Efficiency Electric Convection Ovens","All","$400/oven",null,null,null,{"$f":"F13*400","v":0}]
["High-Efficiency Electric Combination Ovens","All",1000,null,null,null,{"$f":"C14*F14","v":0}]
["Total Requested Incentive",null,null,null,null,null,{"$f":"SUM(G4:G14)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"Ice Machines","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,6],[0,0,0,5],[1,0,1,5],[9,0,9,4],[3,0,5,0],[6,0,8,0]]}
["Fill in Blue Cells Only!"]
["COMMERCIAL ICE MACHINES"]
["Measure","Type/Size","Incentive/Unit","Make and Model","Quantity of Units Installed ","Total Incentive"]
["Ice Machine - Batch","Ice Making Head",150,null,null,{"$f":"C4*E4","v":0}]
[null,"Split System",100,null,null,{"$f":"C5*E5","v":0}]
[null,"Self-Contained",50,null,null,0]
["Ice Machine - Continuous","Ice Making Head",125,null,null,{"$f":"C7*E7","v":0}]
[null,"Split System",150,null,null,{"$f":"C8*E8","v":0}]
[null,"Self-Contained",75,null,null,0]
["Total Requested Incentive",null,null,null,null,{"$f":"SUM(F4:F9)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"Refrig & Freezers","index":8,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,5,21,6],[0,0,0,5],[1,0,1,5],[3,0,6,0],[11,0,14,0],[19,0,19,4],[7,0,10,0],[15,0,18,0]]}
["Fill in Blue Cells Only!"]
["COMMERCIAL REACH-IN REFRIGERATORS AND FREEZERS"]
["Measure","Type/Size","Incentive/Unit","Make and Model","Quantity of Units Installed ","Total Incentive"]
["Commercial Reach-in\nRefrigerators","V < 15 cubic feet",20,null,null,{"$f":"C4*E4","v":0}]
[null,"15 ≤ V < 30 cubic feet",30,null,null,{"$f":"C5*E5","v":0}]
[null,"30 ≤ V < 50 cubic feet",50,null,null,0]
[null,"V ≥ 50 cubic feet",100,null,null,0]
["Commercial Glass Door Reach-in\nRefrigerators","V < 15 cubic feet",55,null,null,{"$f":"C8*E8","v":0}]
[null,"15 ≤ V < 30 cubic feet",55,null,null,{"$f":"C9*E9","v":0}]
[null,"30 ≤ V < 50 cubic feet",75,null,null,0]
[null,"V ≥ 50 cubic feet",100,null,null,0]
["Commercial Reach-in\nFreezers","V < 15 cubic feet",50,null,null,{"$f":"C12*E12","v":0}]
[null,"15 ≤ V < 30 cubic feet",75,null,null,{"$f":"C13*E13","v":0}]
[null,"30 ≤ V < 50 cubic feet",125,null,null,{"$f":"C14*E14","v":0}]
[null,"V ≥ 50 cubic feet",175,null,null,0]
["Commercial Glass-Door Reach-in\nFreezers","V < 15 cubic feet",75,null,null,{"$f":"C16*E16","v":0}]
[null,"15 ≤ V < 30 cubic feet",100,null,null,{"$f":"C17*E17","v":0}]
[null,"30 ≤ V < 50 cubic feet",150,null,null,{"$f":"C18*E18","v":0}]
[null,"V ≥ 50 cubic feet",200,null,null,0]
["Total Requested Incentive",null,null,null,null,{"$f":"SUM(F4:F19)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"Clothes Washers","index":9,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[22,5,22,6],[6,5,6,6]]}
["Fill in Blue Cells Only!"]
["HIGH-EFFICIENCY CLOTHES WASHERS"]
["Measure","Type/Size","Incentive/Unit","Make and Model","Quantity of Units Installed ","Total Incentive"]
["Commercial Clothes Washers","Electric Water Heater",50,null,null,{"$f":"C4*E4","v":0}]
["Commercial Clothes Washers","Non-Electric Water Heater",50,null,null,{"$f":"C5*E5","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"HE Refrig Components","index":10,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,8,23,9],[19,8,19,9],[0,0,0,8],[1,0,1,8],[4,0,5,0],[6,0,11,0],[17,0,17,7],[12,0,13,0],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,4,2,5]]}
["Fill in Blue Cells Only!"]
["HIGH-EFFICIENCY REFRIGERATION COMPONENTS"]
["Measure","Type/Size","Incentive/Unit","Make and Model","For Refrigerated Case Lighting Enter the Proposed and Existing Bulb Wattage",null,"For Refrigerated Case Lighting Controls Measure Enter the Lighting Wattage Controlled ","Quantity of Units Installed ","Total Incentive"]
[null,null,null,null,"Proposed Bulb Watts","Existing Bulb Watts"]
["Anti-Sweat Heater Controls","Cooler Doors","$50/door",null,null,null,null,0,{"$f":"H5*50","v":0}]
[null,"Freezer Doors","$50/door",null,null,null,null,0,{"$f":"H6*50","v":0}]
["Electronically Commutated\nMotors (Walk-in,\nReach-in, and Display\nCoolers/Freezers)","Walk-in Cooler/Freezer Replacing Shaded Pole","$100/motor",null,null,null,null,0,{"$f":"H7*100","v":0}]
[null,"Walk-in Cooler/Freezer Replacing PSC Motor","$50/motor",null,null,null,null,0,{"$f":"H8*50","v":0}]
[null,"Reach-in Cooler ","$35/motor",null,null,null,null,0,{"$f":"H9*35","v":0}]
[null,"Reach-in Freezer","$35/motor",null,null,null,null,0,0]
[null,"Display Cooler","$35/motor",null,null,null,null,0,0]
[null,"Display Freezer","$35/motor",null,null,null,null,0,0]
["Refrigeration Night Covers","Linear Feet\n(Freezers)","$5/foot",null,null,null,null,0,{"$f":"H13*5","v":0}]
[null,"Linear Feet\n(Coolers)","$5/foot",null,null,null,null,0,{"$f":"H14*5","v":0}]
["LED Refrigerated Case Lighting","Coolers","$25/door",null,null,null,null,0,{"$f":"H15*25","v":0}]
["LED Refrigerated Case Lighting","Freezers","$25/door",null,null,null,null,0,{"$f":"H16*25","v":0}]
["LED Refrigerated Case Lighting\nControls","All","$5/door",null,null,null,null,0,{"$f":"H17*5","v":0}]
["Total Requested Incentive",null,null,null,null,null,null,null,{"$f":"SUM(I5:I17)","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

{"sheet":"Receptacle Load Controls","index":11,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,4,0],[6,0,6,5],[22,5,22,6],[8,6,8,7]]}
["Fill in Blue Cells Only!"]
["RECEPTACLE LOAD CONTROLS"]
["Measure","Type/Size","Incentive/Unit","Make and Model","Average Connected Load","Quantity of Units Installed ","Total Incentive"]
["Vending Machine Controls\n(Vending Misers)","Refrigerated",20,null,"n/a",null,{"$f":"C4*F4","v":0}]
[null,"Non-Refrigerated",10,null,"n/a",null,{"$f":"C5*F5","v":0}]
["Personal Receptacle\nOccupancy Sensors\n(Cubicle Controls)","Power Strip with Occupancy Sensor","$5/control",null,null,null,{"$f":"F6*5","v":0}]
["Total Requested Incentive",null,null,null,null,null,{"$f":"SUM(G4:G6)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"\"Version \" & 'Version Tracking'!C4","v":"Version 14.1"}]

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

{"sheet":"Inputs","index":13,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[[18,10,18,11],[15,1,16,1],[8,1,8,6],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[18,3,18,8],[8,11,8,13],[5,1,5,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9]]}
[]
[]
[]
[null,"C&I Prescriptive - Food Service & \nHigh-Efficiency Equipment"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 14.1"}]
[null," "]
[null,"Copyright © 2011 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[null,"Required General Project Information",null,null,null,null,null,"Administrative Use Only",null,null,null,"Summary Table"]
[null,null,null,null,null,null,null,null,null,null,null,"Total kWh ","Total Summer Coincident Peak (kW)","Total Incentive"]
[null,null,"Project Name",null,null,"Prepared By",null,"Project ID",null,null,null,{"$f":"SUM(K23:K32)","v":0},{"$f":"SUM(L23:L32)","v":0},{"$f":"SUM(M23:M32)","v":0}]
[null,null,"Project Address",null,null,"Contact Person",null,"Data Input By"]
[null,null,"City",null,null,"Phone",null,"Input Date"]
[null,null,"ZIP",null,null,"Email"]
[]
[null,"Input Cells"]
[null,null,"Data input allowed in shaded cells only.",null,null,null,null,"*If print button malfunctions, "]
[null,null,null,null,null,null,null,"select printer settings manually from print menu"]
[null,null,null,"Food Service & High-Efficiency Equipment",null,null,null,null,null,"Incentives","Savings"]
[null,"Line Item","Building Type","Measure Type","Type/Size","Make","Model","Quantity","Units of Quantity","Incentive Requested","Total kWh Saved","Summer Coincident Peak kW Saved","Incentive"]
[]
[null,"Ex.","Office","ECM (Coolers/Freezers)","Reach-in Cooler",null,null,1,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,Lookups!$D$3:$E$22,2,0))","v":"Units"},{"$f":"IF(OR(D22=\"\",E22=\"\"),\"\",VLOOKUP($D22&\"_\"&$E22,Lookups!$J$3:$M$56,2,0)*$H22)","v":35},{"$f":"IF(OR(D22=\"\",E22=\"\"),\"\",VLOOKUP($D22&\"_\"&$E22,Lookups!$J$3:$M$56,3,0)*$H22)","v":477},{"$f":"IF(OR(D22=\"\",E22=\"\"),\"\",VLOOKUP($D22&\"_\"&$E22,Lookups!$J$3:$M$56,4,0)*$H22)","v":4.1700000000000001E-2},{"$f":"$J22","v":35}]
[null,1,null,null,null,null,null,1,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D23=\"\",E23=\"\"),\"\",VLOOKUP($D23&\"_\"&$E23,Lookups!$J$3:$M$56,2,0)*$H23)","v":""},{"$f":"IF(OR(D23=\"\",E23=\"\"),\"\",VLOOKUP($D23&\"_\"&$E23,Lookups!$J$3:$M$56,3,0)*$H23)","v":""},{"$f":"IF(OR(D23=\"\",E23=\"\"),\"\",VLOOKUP($D23&\"_\"&$E23,Lookups!$J$3:$M$56,4,0)*$H23)","v":""},{"$f":"$J23","v":""}]
[null,2,null,null,null,null,null,1,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",VLOOKUP($D24&\"_\"&$E24,Lookups!$J$3:$M$56,2,0)*$H24)","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",VLOOKUP($D24&\"_\"&$E24,Lookups!$J$3:$M$56,3,0)*$H24)","v":""},{"$f":"IF(OR(D24=\"\",E24=\"\"),\"\",VLOOKUP($D24&\"_\"&$E24,Lookups!$J$3:$M$56,4,0)*$H24)","v":""},""]
[null,3,null,null,null,null,null,1,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",VLOOKUP($D25&\"_\"&$E25,Lookups!$J$3:$M$56,2,0)*$H25)","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",VLOOKUP($D25&\"_\"&$E25,Lookups!$J$3:$M$56,3,0)*$H25)","v":""},{"$f":"IF(OR(D25=\"\",E25=\"\"),\"\",VLOOKUP($D25&\"_\"&$E25,Lookups!$J$3:$M$56,4,0)*$H25)","v":""},""]
[null,4,null,null,null,null,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",VLOOKUP($D26&\"_\"&$E26,Lookups!$J$3:$M$56,2,0)*$H26)","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",VLOOKUP($D26&\"_\"&$E26,Lookups!$J$3:$M$56,3,0)*$H26)","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\"),\"\",VLOOKUP($D26&\"_\"&$E26,Lookups!$J$3:$M$56,4,0)*$H26)","v":""},""]
[null,5,null,null,null,null,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",VLOOKUP($D27&\"_\"&$E27,Lookups!$J$3:$M$56,2,0)*$H27)","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",VLOOKUP($D27&\"_\"&$E27,Lookups!$J$3:$M$56,3,0)*$H27)","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",VLOOKUP($D27&\"_\"&$E27,Lookups!$J$3:$M$56,4,0)*$H27)","v":""},""]
[null,6,null,null,null,null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D28=\"\",E28=\"\"),\"\",VLOOKUP($D28&\"_\"&$E28,Lookups!$J$3:$M$56,2,0)*$H28)","v":""},{"$f":"IF(OR(D28=\"\",E28=\"\"),\"\",VLOOKUP($D28&\"_\"&$E28,Lookups!$J$3:$M$56,3,0)*$H28)","v":""},{"$f":"IF(OR(D28=\"\",E28=\"\"),\"\",VLOOKUP($D28&\"_\"&$E28,Lookups!$J$3:$M$56,4,0)*$H28)","v":""},""]
[null,7,null,null,null,null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D29=\"\",E29=\"\"),\"\",VLOOKUP($D29&\"_\"&$E29,Lookups!$J$3:$M$56,2,0)*$H29)","v":""},{"$f":"IF(OR(D29=\"\",E29=\"\"),\"\",VLOOKUP($D29&\"_\"&$E29,Lookups!$J$3:$M$56,3,0)*$H29)","v":""},{"$f":"IF(OR(D29=\"\",E29=\"\"),\"\",VLOOKUP($D29&\"_\"&$E29,Lookups!$J$3:$M$56,4,0)*$H29)","v":""},""]
[null,8,null,null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",VLOOKUP($D30&\"_\"&$E30,Lookups!$J$3:$M$56,2,0)*$H30)","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",VLOOKUP($D30&\"_\"&$E30,Lookups!$J$3:$M$56,3,0)*$H30)","v":""},{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",VLOOKUP($D30&\"_\"&$E30,Lookups!$J$3:$M$56,4,0)*$H30)","v":""},""]
[null,9,null,null,null,null,null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",VLOOKUP($D31&\"_\"&$E31,Lookups!$J$3:$M$56,2,0)*$H31)","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",VLOOKUP($D31&\"_\"&$E31,Lookups!$J$3:$M$56,3,0)*$H31)","v":""},{"$f":"IF(OR(D31=\"\",E31=\"\"),\"\",VLOOKUP($D31&\"_\"&$E31,Lookups!$J$3:$M$56,4,0)*$H31)","v":""},""]
[null,10,null,null,null,null,null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,Lookups!$D$3:$E$23,2,0))","v":""},{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",VLOOKUP($D32&\"_\"&$E32,Lookups!$J$3:$M$56,2,0)*$H32)","v":""},{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",VLOOKUP($D32&\"_\"&$E32,Lookups!$J$3:$M$56,3,0)*$H32)","v":""},{"$f":"IF(OR(D32=\"\",E32=\"\"),\"\",VLOOKUP($D32&\"_\"&$E32,Lookups!$J$3:$M$56,4,0)*$H32)","v":""},""]

{"sheet":"Input Key","index":14,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Building Type",null,"Measure Type"]
[null,"Office",null,"Steam Cookers"]
[null,"Retail",null,"Hot Holding Cabinets"]
[null,"School",null,"Fryers"]
[null,"University",null,"Griddles"]
[null,"Religious Facility",null,"Convection Ovens"]
[null,"Grocery",null,"Combination Ovens"]
[null,"Lodging",null,"Ice Machines Tier 1"]
[null,"Industrial",null,"Ice Machines Tier 2 - Cube"]
[null,"Warehouse",null,"Ice Machines Tier 2 - Flake"]
[null,"Health Facility",null,"Reach-in Refrigerators"]
[null,"Multifamily",null,"Glass Door Reach-in Refrig"]
[null,"Restaurant",null,"Reach-in Freezers"]
[null,"Other",null,"Clothes Washers"]
[null,null,null,"Anti-Sweat Heater Controls"]
[null,null,null,"ECM (Coolers/Freezers)"]
[null,null,null,"Refrigeration Night Covers"]
[null,null,null,"LED Refrig Case Lighting"]
[null,null,null,"LED Refrig Case Lighting Controls"]
[null,null,null,"Vending Machine Controls "]
[null,null,null,"Personal Recept Occ Sensors"]

{"sheet":"Measure Code Summary","index":15,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":true,"merged":[[11,3,11,4],[17,5,18,6],[17,9,18,9],[17,7,18,7],[17,8,18,8],[10,7,10,8],[17,3,18,3],[17,4,18,4],[13,3,13,4],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[12,3,12,4],[5,1,5,9],[8,1,8,9],[11,7,11,8],[12,7,12,8],[17,1,18,1],[17,2,18,2],[10,3,10,4],[29,7,29,8],[19,5,19,6],[23,5,23,6],[25,5,25,6],[13,7,13,8],[28,5,28,6],[26,5,26,6],[27,5,27,6],[24,5,24,6],[20,5,20,6],[21,5,21,6],[22,5,22,6]]}
[]
[]
[null,"C&I Prescriptive Program"]
[null,"Food Service and High-Efficiency Equipment"]
[null,"Measure Summary"]
[null,{"$f":"\"Version # \"&'Version Tracking'!C4","v":"Version # 14.1"}]
[null,"Copyright © 2015 ICF Resources, LLC, All Rights Reserved. Do not copy, distribute or quote without ICF’s written permission."]
[]
[null,"Required General Project Information"]
[]
[null,null,"Project Name",{"$f":"IF(Inputs!D11=\"\",\"\",Inputs!D11)","v":""},null,null,"Prepared By",{"$f":"IF(Inputs!G11=\"\",\"\",Inputs!G11)","v":""}]
[null,null,"Project Address",{"$f":"IF(Inputs!D12=\"\",\"\",Inputs!D12)","v":""},null,null,"Contact Person",{"$f":"IF(Inputs!G12=\"\",\"\",Inputs!G12)","v":""}]
[null,null,"City",{"$f":"IF(Inputs!D13=\"\",\"\",Inputs!D13)","v":""},null,null,"Phone",{"$f":"IF(Inputs!G13=\"\",\"\",Inputs!G13)","v":""}]
[null,null,"ZIP",{"$f":"IF(Inputs!D14=\"\",\"\",Inputs!D14)","v":""},null,null,"Email",{"$f":"IF(Inputs!G14=\"\",\"\",Inputs!G14)","v":""}]
[]
[]
[null,"Food Service & High Efficiency Equipment Information"]
[null,"Measure Type","Type/Size","Make","Model","Incentive/Units",null,"Units","Quantity","Subtotal Incentive"]
[]
[null,{"$f":"IF(Inputs!D23=\"\",\"\",Inputs!D23)","v":""},{"$f":"IF(Inputs!E23=\"\",\"\",Inputs!E23)","v":""},{"$f":"IF(Inputs!F23=\"\",\"\",Inputs!F23)","v":""},{"$f":"IF(Inputs!G23=\"\",\"\",Inputs!G23)","v":""},{"$f":"IF(OR(B20=\"\",C20=\"\"),\"\",VLOOKUP(B20&\"_\"&C20,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I23=\"\",\"\",Inputs!I23)","v":""},{"$f":"IF(Inputs!I23=\"\",\"\",Inputs!I23)","v":""},{"$f":"IF(Inputs!H23=\"\",\"\",Inputs!H23)","v":1},{"$f":"IF(Inputs!J23=\"\",\"\",Inputs!J23)","v":""}]
[null,{"$f":"IF(Inputs!D24=\"\",\"\",Inputs!D24)","v":""},{"$f":"IF(Inputs!E24=\"\",\"\",Inputs!E24)","v":""},{"$f":"IF(Inputs!F24=\"\",\"\",Inputs!F24)","v":""},{"$f":"IF(Inputs!G24=\"\",\"\",Inputs!G24)","v":""},{"$f":"IF(OR(B21=\"\",C21=\"\"),\"\",VLOOKUP(B21&\"_\"&C21,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I24=\"\",\"\",Inputs!I24)","v":""},{"$f":"IF(Inputs!I24=\"\",\"\",Inputs!I24)","v":""},{"$f":"IF(Inputs!H24=\"\",\"\",Inputs!H24)","v":1},{"$f":"IF(Inputs!J24=\"\",\"\",Inputs!J24)","v":""}]
[null,{"$f":"IF(Inputs!D25=\"\",\"\",Inputs!D25)","v":""},{"$f":"IF(Inputs!E25=\"\",\"\",Inputs!E25)","v":""},{"$f":"IF(Inputs!F25=\"\",\"\",Inputs!F25)","v":""},{"$f":"IF(Inputs!G25=\"\",\"\",Inputs!G25)","v":""},{"$f":"IF(OR(B22=\"\",C22=\"\"),\"\",VLOOKUP(B22&\"_\"&C22,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I25=\"\",\"\",Inputs!I25)","v":""},{"$f":"IF(Inputs!I25=\"\",\"\",Inputs!I25)","v":""},{"$f":"IF(Inputs!H25=\"\",\"\",Inputs!H25)","v":1},{"$f":"IF(Inputs!J25=\"\",\"\",Inputs!J25)","v":""}]
[null,{"$f":"IF(Inputs!D26=\"\",\"\",Inputs!D26)","v":""},{"$f":"IF(Inputs!E26=\"\",\"\",Inputs!E26)","v":""},{"$f":"IF(Inputs!F26=\"\",\"\",Inputs!F26)","v":""},{"$f":"IF(Inputs!G26=\"\",\"\",Inputs!G26)","v":""},{"$f":"IF(OR(B23=\"\",C23=\"\"),\"\",VLOOKUP(B23&\"_\"&C23,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I26=\"\",\"\",Inputs!I26)","v":""},{"$f":"IF(Inputs!I26=\"\",\"\",Inputs!I26)","v":""},{"$f":"IF(Inputs!H26=\"\",\"\",Inputs!H26)","v":""},{"$f":"IF(Inputs!J26=\"\",\"\",Inputs!J26)","v":""}]
[null,{"$f":"IF(Inputs!D27=\"\",\"\",Inputs!D27)","v":""},{"$f":"IF(Inputs!E27=\"\",\"\",Inputs!E27)","v":""},{"$f":"IF(Inputs!F27=\"\",\"\",Inputs!F27)","v":""},{"$f":"IF(Inputs!G27=\"\",\"\",Inputs!G27)","v":""},{"$f":"IF(OR(B24=\"\",C24=\"\"),\"\",VLOOKUP(B24&\"_\"&C24,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I27=\"\",\"\",Inputs!I27)","v":""},{"$f":"IF(Inputs!I27=\"\",\"\",Inputs!I27)","v":""},{"$f":"IF(Inputs!H27=\"\",\"\",Inputs!H27)","v":""},{"$f":"IF(Inputs!J27=\"\",\"\",Inputs!J27)","v":""}]
[null,{"$f":"IF(Inputs!D28=\"\",\"\",Inputs!D28)","v":""},{"$f":"IF(Inputs!E28=\"\",\"\",Inputs!E28)","v":""},{"$f":"IF(Inputs!F28=\"\",\"\",Inputs!F28)","v":""},{"$f":"IF(Inputs!G28=\"\",\"\",Inputs!G28)","v":""},{"$f":"IF(OR(B25=\"\",C25=\"\"),\"\",VLOOKUP(B25&\"_\"&C25,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I28=\"\",\"\",Inputs!I28)","v":""},{"$f":"IF(Inputs!I28=\"\",\"\",Inputs!I28)","v":""},{"$f":"IF(Inputs!H28=\"\",\"\",Inputs!H28)","v":""},{"$f":"IF(Inputs!J28=\"\",\"\",Inputs!J28)","v":""}]
[null,{"$f":"IF(Inputs!D29=\"\",\"\",Inputs!D29)","v":""},{"$f":"IF(Inputs!E29=\"\",\"\",Inputs!E29)","v":""},{"$f":"IF(Inputs!F29=\"\",\"\",Inputs!F29)","v":""},{"$f":"IF(Inputs!G29=\"\",\"\",Inputs!G29)","v":""},{"$f":"IF(OR(B26=\"\",C26=\"\"),\"\",VLOOKUP(B26&\"_\"&C26,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I29=\"\",\"\",Inputs!I29)","v":""},{"$f":"IF(Inputs!I29=\"\",\"\",Inputs!I29)","v":""},{"$f":"IF(Inputs!H29=\"\",\"\",Inputs!H29)","v":""},{"$f":"IF(Inputs!J29=\"\",\"\",Inputs!J29)","v":""}]
[null,{"$f":"IF(Inputs!D30=\"\",\"\",Inputs!D30)","v":""},{"$f":"IF(Inputs!E30=\"\",\"\",Inputs!E30)","v":""},{"$f":"IF(Inputs!F30=\"\",\"\",Inputs!F30)","v":""},{"$f":"IF(Inputs!G30=\"\",\"\",Inputs!G30)","v":""},{"$f":"IF(OR(B27=\"\",C27=\"\"),\"\",VLOOKUP(B27&\"_\"&C27,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I30=\"\",\"\",Inputs!I30)","v":""},{"$f":"IF(Inputs!I30=\"\",\"\",Inputs!I30)","v":""},{"$f":"IF(Inputs!H30=\"\",\"\",Inputs!H30)","v":""},{"$f":"IF(Inputs!J30=\"\",\"\",Inputs!J30)","v":""}]
[null,{"$f":"IF(Inputs!D31=\"\",\"\",Inputs!D31)","v":""},{"$f":"IF(Inputs!E31=\"\",\"\",Inputs!E31)","v":""},{"$f":"IF(Inputs!F31=\"\",\"\",Inputs!F31)","v":""},{"$f":"IF(Inputs!G31=\"\",\"\",Inputs!G31)","v":""},{"$f":"IF(OR(B28=\"\",C28=\"\"),\"\",VLOOKUP(B28&\"_\"&C28,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I31=\"\",\"\",Inputs!I31)","v":""},{"$f":"IF(Inputs!I31=\"\",\"\",Inputs!I31)","v":""},{"$f":"IF(Inputs!H31=\"\",\"\",Inputs!H31)","v":""},{"$f":"IF(Inputs!J31=\"\",\"\",Inputs!J31)","v":""}]
[null,{"$f":"IF(Inputs!D32=\"\",\"\",Inputs!D32)","v":""},{"$f":"IF(Inputs!E32=\"\",\"\",Inputs!E32)","v":""},{"$f":"IF(Inputs!F32=\"\",\"\",Inputs!F32)","v":""},{"$f":"IF(Inputs!G32=\"\",\"\",Inputs!G32)","v":""},{"$f":"IF(OR(B29=\"\",C29=\"\"),\"\",VLOOKUP(B29&\"_\"&C29,Lookups!$J$3:$K$56,2,0))","v":""},{"$f":"IF(Inputs!I32=\"\",\"\",Inputs!I32)","v":""},{"$f":"IF(Inputs!I32=\"\",\"\",Inputs!I32)","v":""},{"$f":"IF(Inputs!H32=\"\",\"\",Inputs!H32)","v":""},{"$f":"IF(Inputs!J32=\"\",\"\",Inputs!J32)","v":""}]
[null,null,null,null,null,null,null,"Total Pre-approved Incentive",null,{"$f":"SUM(J20:J29)","v":0}]

{"sheet":"Validation","index":16,"n_rows":56,"n_cols":35,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,{"$f":"COUNTA(G3:G17)","v":4},{"$f":"COUNTA(H3:H17)","v":3},1,1,1,1,3,3,3,4,4,4,4,1,2,{"$f":"COUNTA(V3:V15)","v":8},2,1,1,2,1]
[null,"Building Type",null,"Measure Type","Useful Life",null,"Steam Cookers","Hot Holding Cabinets","Fryers","Griddles","Convection Ovens","Combination Ovens","Ice Machines Tier 1","Ice Machines Tier 2 - Cube","Ice Machines Tier 2 - Flake","Reach-in Refrigerators","Glass Door Reach-in Refrig","Reach-in Freezers","Glass Door Reach-in Freezers","Clothes Washers","Anti-Sweat Heater Controls","ECM (Coolers/Freezers)","Refrigeration Night Covers","LED Refrig Case Lighting","LED Refrig Case Lighting Controls","Vending Machine Controls","Personal Recept Occ Sensors",null,null,null,"Measure Type","Size","MeasureType+Size","Measure Code","Useful Life"]
[null,"Office",null,"Steam Cookers",12,null,"3 Pan","Half Size","Large Vat","All","All","All","< 450 lbs","< 450 lbs","< 450 lbs","< 15 cubic feet","< 15 cubic feet","< 15 cubic feet","< 15 cubic feet","All","Cooler Doors","Reach-in Cooler","Freezers","All","All","Refrigerated","Power Strip with Occupancy Sensor",null,null,null,"Steam Cookers","3 Pan",{"$f":"CONCATENATE(AE3, \" \",AF3)","v":"Steam Cookers 3 Pan"},"SC3",{"$f":"VLOOKUP(AE3,$D$3:$E$23,2,FALSE)","v":12}]
[null,"Retail",null,"Hot Holding Cabinets",12,null,"4 Pan","3/4 Size",null,null,null,null,"451 - 1000 lbs","451 - 1000 lbs","451 - 1000 lbs","15 - 30 cubic feet","15 - 30 cubic feet","15 - 30 cubic feet","15 - 30 cubic feet",null,"Freezer Doors","Reach-in Freezer","Coolers",null,null,"Non-Refrigerated",null,null,null,null,"Steam Cookers","4 Pan",{"$f":"CONCATENATE(AE4, \" \",AF4)","v":"Steam Cookers 4 Pan"},"SC4",12]
[null,"School",null,"Fryers",12,null,"5 Pan","Full Size",null,null,null,null,"> 1001 lbs","> 1001 lbs","> 1001 lbs","31 - 50 cubic feet","31 - 50 cubic feet","31 - 50 cubic feet","31 - 50 cubic feet",null,null,"Display Cooler",null,null,null,null,null,null,null,null,"Steam Cookers","5 Pan","Steam Cookers 5 Pan","SC5",12]
[null,"University",null,"Griddles",12,null,"6 Pan",null,null,null,null,null,null,null,null,"> 50 cubic feet","> 50 cubic feet","> 50 cubic feet","> 50 cubic feet",null,null,"Display Freezer",null,null,null,null,null,null,null,null,"Steam Cookers","6 Pan","Steam Cookers 6 Pan","SC6",12]
[null,"Religious Facility",null,"Convection Ovens",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk-in Cooler Replacing PSC",null,null,null,null,null,null,null,null,"Hot Holding Cabinets","Half Size","Hot Holding Cabinets Half Size","HC1",12]
[null,"Grocery",null,"Combination Ovens",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk-in Freezer Replacing PSC",null,null,null,null,null,null,null,null,"Hot Holding Cabinets","3/4 Size","Hot Holding Cabinets 3/4 Size","HC2",12]
[null,"Lodging",null,"Ice Machines Tier 1",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk-in Cooler Replacing Shaded Pole",null,null,null,null,null,null,null,null,"Hot Holding Cabinets","Full Size","Hot Holding Cabinets Full Size","HCF",12]
[null,"Industrial",null,"Ice Machines Tier 2 - Cube",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk-in Freezer Replacing Shaded Pole",null,null,null,null,null,null,null,null,"Fryers","Large Vat","Fryers Large Vat","FLV",12]
[null,"Warehouse",null,"Ice Machines Tier 2 - Flake",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Griddles","All","Griddles All","GRD",12]
[null,"Health Facility",null,"Reach-in Refrigerators",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convection Ovens","All","Convection Ovens All","CVO",12]
[null,"Multifamily",null,"Glass Door Reach-in Refrig",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination Ovens","All","Combination Ovens All","CMBO",12]
[null,"Restaurant",null,"Reach-in Freezers",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 1","< 450 lbs","Ice Machines Tier 1 < 450 lbs","IC26",12]
[null,"Other",null,"Glass Door Reach-in Freezers",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 1","451 - 1000 lbs","Ice Machines Tier 1 451 - 1000 lbs","IC27",12]
[null,null,null,"Clothes Washers",11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 1","> 1001 lbs","Ice Machines Tier 1 > 1001 lbs","IC28",12]
[null,null,null,"Anti-Sweat Heater Controls",16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Cube","< 450 lbs",{"$f":"CONCATENATE(AE17, \" \",AF17)","v":"Ice Machines Tier 2 - Cube < 450 lbs"},"IC29",12]
[null,null,null,"ECM (Coolers/Freezers)",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Cube","451 - 1000 lbs",{"$f":"CONCATENATE(AE18, \" \",AF18)","v":"Ice Machines Tier 2 - Cube 451 - 1000 lbs"},"IC30",12]
[null,null,null,"Refrigeration Night Covers",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Cube","> 1001 lbs",{"$f":"CONCATENATE(AE19, \" \",AF19)","v":"Ice Machines Tier 2 - Cube > 1001 lbs"},"IC31",12]
[null,null,null,"LED Refrig Case Lighting",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Flake","< 450 lbs","Ice Machines Tier 2 - Flake < 450 lbs","IC32",12]
[null,null,null,"LED Refrig Case Lighting Controls",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Flake","451 - 1000 lbs","Ice Machines Tier 2 - Flake 451 - 1000 lbs","IC33",12]
[null,null,null,"Vending Machine Controls",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Machines Tier 2 - Flake","> 1001 lbs","Ice Machines Tier 2 - Flake > 1001 lbs","IC34",12]
[null,null,null,"Personal Recept Occ Sensors",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Refrigerators","< 15 cubic feet","Reach-in Refrigerators < 15 cubic feet","RR1",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Refrigerators","15 - 30 cubic feet","Reach-in Refrigerators 15 - 30 cubic feet","RR2",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Refrigerators","31 - 50 cubic feet","Reach-in Refrigerators 31 - 50 cubic feet","RR3",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Refrigerators","> 50 cubic feet","Reach-in Refrigerators > 50 cubic feet","RR4",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Refrig","< 15 cubic feet","Glass Door Reach-in Refrig < 15 cubic feet","GDR1",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Refrig","15 - 30 cubic feet","Glass Door Reach-in Refrig 15 - 30 cubic feet","GDR2",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Refrig","31 - 50 cubic feet","Glass Door Reach-in Refrig 31 - 50 cubic feet","GDR3",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Refrig","> 50 cubic feet","Glass Door Reach-in Refrig > 50 cubic feet","GDR4",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Freezers","< 15 cubic feet","Reach-in Freezers < 15 cubic feet","RF1",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Freezers","15 - 30 cubic feet","Reach-in Freezers 15 - 30 cubic feet","RF2",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Freezers","31 - 50 cubic feet","Reach-in Freezers 31 - 50 cubic feet","RF3",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reach-in Freezers","> 50 cubic feet","Reach-in Freezers > 50 cubic feet","RF4",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Freezers","< 15 cubic feet",{"$f":"CONCATENATE(AE35, \" \",AF35)","v":"Glass Door Reach-in Freezers < 15 cubic feet"},"GDR1",{"$f":"VLOOKUP(AE35,$D$3:$E$23,2,FALSE)","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Freezers","15 - 30 cubic feet","Glass Door Reach-in Freezers 15 - 30 cubic feet","GDR2",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Freezers","31 - 50 cubic feet","Glass Door Reach-in Freezers 31 - 50 cubic feet","GDR3",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Door Reach-in Freezers","> 50 cubic feet","Glass Door Reach-in Freezers > 50 cubic feet","GDR4",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clothes Washers","All","Clothes Washers All","CLW",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anti-Sweat Heater Controls","Cooler Doors","Anti-Sweat Heater Controls Cooler Doors","ASCD",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anti-Sweat Heater Controls","Freezer Doors","Anti-Sweat Heater Controls Freezer Doors","ASFD",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Cooler Replacing PSC",{"$f":"CONCATENATE(AE42, \" \",AF42)","v":"ECM (Coolers/Freezers) Walk-in Cooler Replacing PSC"},"ECMW1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Freezer Replacing PSC","ECM (Coolers/Freezers) Walk-in Freezer Replacing PSC","ECMW2",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Cooler Replacing Shaded Pole","ECM (Coolers/Freezers) Walk-in Cooler Replacing Shaded Pole","ECMW1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Freezer Replacing Shaded Pole","ECM (Coolers/Freezers) Walk-in Freezer Replacing Shaded Pole","ECMW2",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Reach-in Cooler","ECM (Coolers/Freezers) Reach-in Cooler","ECMR1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Reach-in Freezer","ECM (Coolers/Freezers) Reach-in Freezer","ECMR2",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Display Cooler","ECM (Coolers/Freezers) Display Cooler","ECMD1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECM (Coolers/Freezers)","Display Freezer","ECM (Coolers/Freezers) Display Freezer","ECMD2",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refrigeration Night Covers","Freezers","Refrigeration Night Covers Freezers","RNC1",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refrigeration Night Covers","Coolers","Refrigeration Night Covers Coolers","RNC2",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Refrig Case Lighting","All",{"$f":"CONCATENATE(AE52, \" \",AF52)","v":"LED Refrig Case Lighting All"},"LEDRL",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Refrig Case Lighting Controls","All","LED Refrig Case Lighting Controls All","LEDRC",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vending Machine Controls","Refrigerated","Vending Machine Controls Refrigerated","VMC1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vending Machine Controls","Non-Refrigerated","Vending Machine Controls Non-Refrigerated","VMC2",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal Recept Occ Sensors","Power Strip with Occupancy Sensor","Personal Recept Occ Sensors Power Strip with Occupancy Sensor","PROS",10]

{"sheet":"Lookups","index":17,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Units of Quantity",null,null,"Measure Type","Type/Size","Incentive","Concatanation","Incentive","kWh Savings","kW Savings","Source"]
[null,null,null,"Steam Cookers","Units",null,"Steam Cookers","3 Pan",800,{"$f":"G3&\"_\"&H3","v":"Steam Cookers_3 Pan"},{"$f":"I3","v":800},11187.801510989011,2.5542925824175824,"South Carolina Measure Database"]
[null,null,null,"Hot Holding Cabinets","Units",null,"Steam Cookers","4 pan",800,{"$f":"G4&\"_\"&H4","v":"Steam Cookers_4 pan"},{"$f":"I4","v":800},12459.011374358317,2.5542925824175824,"South Carolina Measure Database"]
[null,null,null,"Fryers","Vats",null,"Steam Cookers","5 Pan",1200,"Steam Cookers_5 Pan",1200,13830.965323665834,2.5542925824175824,"South Carolina Measure Database"]
[null,null,null,"Griddles","Units",null,"Steam Cookers","6 Pan",1200,"Steam Cookers_6 Pan",1200,15169.515115384613,2.5542925824175824,"South Carolina Measure Database"]
[null,null,null,"Convection Ovens","Ovens",null,"Hot Holding Cabinets","Half Size",300,"Hot Holding Cabinets_Half Size",300,1788.354,0.32664000000000004,"South Carolina Measure Database"]
[null,null,null,"Combination Ovens","Units",null,"Hot Holding Cabinets","3/4 Size",400,"Hot Holding Cabinets_3/4 Size",400,2831.67,0.51719999999999999,"South Carolina Measure Database"]
[null,null,null,"Ice Machines Tier 1a","Units",null,"Hot Holding Cabinets","Full Size",500,"Hot Holding Cabinets_Full Size",500,5277.9,0.96399999999999997,"South Carolina Measure Database"]
[null,null,null,"Ice Machines Tier 2 - Cube","Units",null,"Fryers","Large Vat",300,"Fryers_Large Vat",300,1789,0.4,"South Carolina Measure Database"]
[null,null,null,"Ice Machines Tier 2 - Flake","Units",null,"Griddles","All",300,"Griddles_All",300,1637,0.4,"South Carolina Measure Database"]
[null,null,null,"Reach-in Refrigerators","Units",null,"Convection Ovens","All",400,"Convection Ovens_All",400,2262,0.5,"South Carolina Measure Database"]
[null,null,null,"Glass Door Reach-in Refrig","Units",null,"Combination Ovens","All",1000,"Combination Ovens_All",1000,18432,4.2,"South Carolina Measure Database"]
[null,null,null,"Reach-in Freezers","Units",null,"Ice Machines Tier 1","< 450 lbs",50,"Ice Machines Tier 1_< 450 lbs",50,140,4.2200000000000001E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Glass Door Reach-in Freezers","Units",null,"Ice Machines Tier 1","451 - 1000 lbs",100,"Ice Machines Tier 1_451 - 1000 lbs",100,643,5.7500000000000002E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Clothes Washers","Units",null,"Ice Machines Tier 1","> 1001 lbs",150,"Ice Machines Tier 1_> 1001 lbs",150,1344,0.36670000000000003,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Anti-Sweat Heater Controls","Doors",null,"Ice Machines Tier 2 - Cube","< 450 lbs",75,"Ice Machines Tier 2 - Cube_< 450 lbs",75,370,4.2200000000000001E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"ECM (Coolers/Freezers)","Units",null,"Ice Machines Tier 2 - Cube","451 - 1000 lbs",125,{"$f":"G18&\"_\"&H18","v":"Ice Machines Tier 2 - Cube_451 - 1000 lbs"},125,1485,5.7500000000000002E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Refrigeration Night Covers","Linear Feet",null,"Ice Machines Tier 2 - Cube","> 1001 lbs",150,"Ice Machines Tier 2 - Cube_> 1001 lbs",150,3212,0.36670000000000003,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"LED Refrig Case Lighting","Doors",null,"Ice Machines Tier 2 - Flake","< 450 lbs",100,"Ice Machines Tier 2 - Flake_< 450 lbs",100,1212,4.2200000000000001E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"LED Refrig Case Lighting Controls","Doors",null,"Ice Machines Tier 2 - Flake","451 - 1000 lbs",175,"Ice Machines Tier 2 - Flake_451 - 1000 lbs",175,2249,5.7500000000000002E-2,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Vending Machine Controls","Units",null,"Ice Machines Tier 2 - Flake","> 1001 lbs",250,"Ice Machines Tier 2 - Flake_> 1001 lbs",250,5548,0.36670000000000003,"ENERGY STAR Calculator (http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=CIM)"]
[null,null,null,"Personal Recept Occ Sensors","Controls",null,"Reach-in Refrigerators","< 15 cubic feet",20,"Reach-in Refrigerators_< 15 cubic feet",20,905,0.10299999999999999,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Refrigerators","15 - 30 cubic feet",30,"Reach-in Refrigerators_15 - 30 cubic feet",30,1069,0.122,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Refrigerators","31 - 50 cubic feet",50,"Reach-in Refrigerators_31 - 50 cubic feet",50,1069,0.122,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Refrigerators","> 50 cubic feet",100,"Reach-in Refrigerators_> 50 cubic feet",100,1361,0.155,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Glass Door Reach-in Refrig","< 15 cubic feet",55,"Glass Door Reach-in Refrig_< 15 cubic feet",55,725,8.3000000000000004E-2,"Fishnick Calculator  (14 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Refrig","15 - 30 cubic feet",55,"Glass Door Reach-in Refrig_15 - 30 cubic feet",55,672,7.6999999999999999E-2,"Fishnick Calculator  (22.5 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Refrig","31 - 50 cubic feet",75,"Glass Door Reach-in Refrig_31 - 50 cubic feet",75,734,8.4000000000000005E-2,"Fishnick Calculator  (40.5 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Refrig","> 50 cubic feet",100,"Glass Door Reach-in Refrig_> 50 cubic feet",100,945,0.108,"Fishnick Calculator  (75 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Reach-in Freezers","< 15 cubic feet",50,"Reach-in Freezers_< 15 cubic feet",50,520,5.8999999999999997E-2,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Freezers","15 - 30 cubic feet",75,"Reach-in Freezers_15 - 30 cubic feet",75,507,5.8000000000000003E-2,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Freezers","31 - 50 cubic feet",125,"Reach-in Freezers_31 - 50 cubic feet",125,507,5.8000000000000003E-2,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Reach-in Freezers","> 50 cubic feet",175,"Reach-in Freezers_> 50 cubic feet",175,483,5.5E-2,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Glass Door Reach-in Freezers","< 15 cubic feet",75,{"$f":"G35&\"_\"&H35","v":"Glass Door Reach-in Freezers_< 15 cubic feet"},{"$f":"I35","v":75},725,8.3000000000000004E-2,"Fishnick Calculator  (14 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Freezers","15 - 30 cubic feet",100,"Glass Door Reach-in Freezers_15 - 30 cubic feet",100,672,7.6999999999999999E-2,"Fishnick Calculator  (22.5 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Freezers","31 - 50 cubic feet",150,"Glass Door Reach-in Freezers_31 - 50 cubic feet",150,734,8.4000000000000005E-2,"Fishnick Calculator  (40.5 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Glass Door Reach-in Freezers","> 50 cubic feet",200,"Glass Door Reach-in Freezers_> 50 cubic feet",200,945,0.108,"Fishnick Calculator  (75 Cub Ft) (http://www.fishnick.com/saveenergy/tools/calculators/glasscoolercalc.php)"]
[null,null,null,null,null,null,"Clothes Washers","All",50,"Clothes Washers_All",50,87.24,0.12,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Anti-Sweat Heater Controls","Cooler Doors",50,"Anti-Sweat Heater Controls_Cooler Doors",50,1489,0,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Anti-Sweat Heater Controls","Freezer Doors",50,"Anti-Sweat Heater Controls_Freezer Doors",50,1489,0,"South Carolina Measure Database"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Cooler Replacing PSC",50,"ECM (Coolers/Freezers)_Walk-in Cooler Replacing PSC",50,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Freezer Replacing PSC",50,"ECM (Coolers/Freezers)_Walk-in Freezer Replacing PSC",50,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Cooler Replacing Shaded Pole",100,{"$f":"G44&\"_\"&H44","v":"ECM (Coolers/Freezers)_Walk-in Cooler Replacing Shaded Pole"},{"$f":"I44","v":100},477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Walk-in Freezer Replacing Shaded Pole",100,"ECM (Coolers/Freezers)_Walk-in Freezer Replacing Shaded Pole",100,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Reach-in Cooler",35,"ECM (Coolers/Freezers)_Reach-in Cooler",35,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Reach-in Freezer",35,"ECM (Coolers/Freezers)_Reach-in Freezer",35,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Display Cooler",35,"ECM (Coolers/Freezers)_Display Cooler",35,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"ECM (Coolers/Freezers)","Display Freezer",35,"ECM (Coolers/Freezers)_Display Freezer",35,477,4.1700000000000001E-2,"ODC South Carolina Guidance"]
[null,null,null,null,null,null,"Refrigeration Night Covers","Freezers",5,"Refrigeration Night Covers_Freezers",5,105,0,"South Carolina Measure Database"]
[null,null,null,null,null,null,"Refrigeration Night Covers","Coolers",5,"Refrigeration Night Covers_Coolers",5,105,0,"South Carolina Measure Database"]
[null,null,null,null,null,null,"LED Refrig Case Lighting","All",25,"LED Refrig Case Lighting_All",25,{"$f":"410.0556*(8000/8760)","v":374.48},4.6809999999999997E-2,"CT Savings Documentation 2008 - compressor factor for refrigerator"]
[null,null,null,null,null,null,"LED Refrig Case Lighting Controls","All",5,"LED Refrig Case Lighting Controls_All",5,{"$f":"285.136*(8000/8760)","v":260.39817351598174},0.148671,"DEER 2005 - modified by (8000/8760) in order to reduce lighting hours per ODC SC Guidance"]
[null,null,null,null,null,null,"Vending Machine Controls","Refrigerated",50,"Vending Machine Controls_Refrigerated",50,1612,0,"DEER 2005"]
[null,null,null,null,null,null,"Vending Machine Controls","Non-Refrigerated",20,"Vending Machine Controls_Non-Refrigerated",20,387,0,"DEER 2005"]
[null,null,null,null,null,null,"Personal Recept Occ Sensors","Power Strip with Occupancy Sensor",10,"Personal Recept Occ Sensors_Power Strip with Occupancy Sensor",10,24,0,"NEEP Mid-Atlantic TRM Phase 2 Development"]

{"sheet":"Version Tracking","index":18,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B50001<>\"\"),B1:B50001)","v":14.1}]
[null,"Version","Notes","Date","Updated By"]
[null,1,"Initial creation of Food Service and High-Efficiency Equipment tool for SCANA.","2011-04-11","Drew Durkee"]
[null,1.1000000000000001,"modify measure name length to fit vision number of character requirement","2011-04-15","O'Neil Morgan"]
[null,1.2,"modify measure name length to fit vision number of character requirement","2011-04-19","O'Neil Morgan"]
[null,1.3,"CREATE MEASURE CODE ","2011-05-05","O'Neil Morgan"]
[null,1.4,"update aeg tab","2011-05-26","O'Neil Morgan"]
[null,1.5,"updated EULs to align with BGE program","2011-07-05","Charlie Haack"]
[null,1.6,"Removed extra space from G45 and G46 of 'Lookups' tab","2011-07-19","Charlie Haack"]
[null,1.7,"add a space between LED Refrig and Case Lighting on the validation tab","2011-09-01","O'Neil Morgan"]
[null,1.8,"convert watts to kw for the LED Refrig and Case Lighting measure","2011-09-23","O'Neil Morgan"]
[null,1.9,"made adjustment to AEG tab so that savings are reported on a per unit basis","2011-10-20","O'Neil Morgan"]
[null,2,"Remove commas from validation tab info","2011-10-25","Colin Odell"]
[null,2.1,"made adjustment to kWsavings for ECM motor measure ","2012-01-17","O'Neil Morgan"]
[null,2.2000000000000002,"CEE Ice machine update","2012-02-25","CGO"]
[null,2.2999999999999998,"CEE Ice machine update","2012-05-30","O'Neil Morgan"]
[null,2.4,"Made adjustments for ECM in refrigeration cases and LED in reach in cases per ODC Instructions and SCEG Approval","2012-12-06","Drew Durkee"]
[null,2.5,"Adjusted the measure code for ice m/c to match the vision codes","2013-06-10","O'Neil Morgan"]
[null,2.6,"Created tabs for the application form fields","2015-06-29","Rachael Miller"]
[null,2.7,"all revisions and updates","2015-09-25","Joy Zins"]
[null,2.8,"Formatting, added buttons to tabs, addressed Jennifer's comments","2015-10-21","Rachael Miller"]
[null,2.9,"Fixed T&C's, minor edits","2015-10-21","Joy Zins"]
[null,3,"Added Equipment Instruction Input tab, changed color of equipment tabs","2015-10-21","Joy Zins"]
[null,3.1,"Added Equipment tab buttons","2015-10-21","Rachael Miller"]
[null,3.2,"Formating & printing edits","2015-10-27","Jennifer Mosser"]
[null,3.3,"minor formatting, fix T&C button","2015-11-20","JZ and RM"]
[null,3.4,"changes to application per ODC's Commercial Energy Algorithm Manual (CEAM)","2016-07-19","CVH/O'Neil Morgan"]
[null,3.5,"Fixed password protection, minor edits","2016-09-14","RC"]
[null,3.6,"Updated incentives for 2017","2017-01-20","RC"]
[null,3.7,"Updated langauge for pre approval, added contact","2017-01-23","JZ  "]
[null,3.8,"Revisions per Annika's comments","2017-01-30","Mary Freibert"]
[null,3.9,"Language revisions and fixed buttons","2017-11-13","RC"]
[null,4,"Added fields to capture additional data on holding cabinets, case lighting, and controls","2019-01-18","RC"]
[null,10.1,"Updated Dominion branding and T&Cs","2020-08-28","JSE"]
[null,10.199999999999999,"Updated T&Cs and incentive ammounts","2021-02-01","JSE"]
[null,10.3,"Updated version number for consistency with other applications","2021-06-30","Malena Wood"]
[null,10.4,"Updated T&Cs Re: \"Customers eligible for Rate 23 \" and replaced SCE&G logos with Dominion. And invoicing rqmts","2022-08-08","Liv Stewart"]
[null,14.1,"Removed repeating content controls from Informaion Tab","2023-11-07","Liv Stewart"]

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