{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["RevisionHistory","Directions","Application","Building Details","Building Envelope","DX_gas furnace","Interior Lighting","Air Source Heat Pump","Water Source Heat Pump","Variable Refrigerant Flow","Other","Ground Source Heat Pump","Service Water Heating","Fixtures_plug loads","Garage","Incentive calculation","Checklist","Submittal Requirements_Final","Submittal Requirements"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":3,"defined_names":33,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RevisionHistory","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Version History"]
["Program Year","Date of Revision","Description of Changes","Updated By:"]
[2021,"2021-10-07","Added RevisionHistory tab; Added Conditioned garage space to Lighting tab/calculations; Added clarifying language regarding must complete all six sections before submitting application; Added clarifying language regarding exterior and unconditioned garage spaces","Melissa"]
[2021,"2021-10-21","Added an 'N/A' option to the drop down menus","Jeremiah"]
[2021,"2021-12-22","Building Details tab: Added Number of floors question and unconditioned garage ft2 questions, rearranged questions to sum square footage; shaded 'notes' cells light blue; Interior Ltg tab: Added Watts/ft2 column","Melissa"]
[2022,"2022-01-05","Fixed macro so that correct HVAC tab displays when selected on Building Details tab. Updated application tab to reflect changes to catalog. Also fixed 'squished' text on application tab. Also fixed %Progress tracker on Water Heating, Fixture and Garage tabs.","Jeremiah"]
[2022,"2022-02-15","Fixed 'Incentive calculation' tab so it properly pulled ratings from Buidling Envelope tab","Paul"]
[2022,"2022-02-18","Fixed 'Other' tab to include a rating for the equipment installed in addition to the controls rating. ","Jeremiah"]
[2022,"2022-02-24","Fixed formula on Incentive Calculation D3-7 to say =IFERROR(IF($D$8>0,C3*0.1,C3*0.1),\"\") instead of =IFERROR(IF($C$8>0,C3*0.1,C3*0.1),\"\") to allow for MF with no conditioned garage to no longer include the Garage in the weighted total.","Evan"]
[2022,"2022-06-09","Fixed formulas on Interior Lighting Cells B16, 17, and 18. The formula was using improper cells from the building application page. B16 - changed from B6 to B4. B17 changed from B7 to B5. B18 changed from B8 to B6.  ","Evan"]
[2022,"2022-07-27","Incentive Calculation Sheet: Corrected the total incentive calculation to use the B7, total conditioned sqf from Building Details Tab, instead of B5, which is only in unit square footage. ","Evan"]

{"sheet":"Directions","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,10,1,14],[3,5,3,8],[1,0,1,8],[0,0,0,8],[24,0,24,3],[4,0,4,3],[10,0,10,3],[13,0,13,3],[19,0,19,3],[21,0,21,3]]}
["MULTIFAMILY NEW CONSTRUCTION PRODUCT/EQUIPMENT PERFORMANCE OFFERING",null,null,null,null,null,null,null,null,null,"Last Revised:",{"$f":"MAX(RevisionHistory!B5:B41)","v":"2022-07-27"}]
["The Multifamily New Construction Product/Equipment Performance offering is a holistic approach to providing financial incentives for multifamily new construction projects.  After providing information on basic aspects of the building design, the building is given a Good, Better, or Best rating.  This building rating determines the incentive rate for the project, ranging from $0.03 per square foot to $0.17 per square foot. All six areas (building envelope, interior lighting, HVAC system, service water heating, fixtures/plug loads, and conditioned garage) must be completed before submitting an application.\n\nTo qualify for this offering, your building must meet the following eligibility requirements:\n- Building must be served by an electric and/or natural gas utility participating in Focus on Energy. Incentive may be adjusted if job site does not have a participating gas or electric utility.\n- Building must be classified as multifamily which is defined as a single building with 4 or more living units.\n- Project must be new construction (new building) or major renovation of an existing building (change of space use).\n- The building design must meet the minimum requirements for the Good category.\n\nDirections to complete:\n1. Complete all tabs of the workbook.  All blue shaded cells require input.  Incomplete workbooks will delay processing of the incentive.  \n2. Provide all submittal documents as detailed on Incentive calculation tab.\n3. Submit the workbook and required submittal documents at www.focusonenergy.com/MFPEP.  A separate workbook is required for each building if this is part of a larger complex.\n\nIf your building design falls outside of the described systems in this workbook or there are additional space types, contact Focus on Energy at 888.623.2146 for guidance.  \n\nFor any exterior lighting or unconditioned garage lighting fixtures, apply for incentives using prescriptive lighting measures. Refer to www.focusonenergy.com/catalogs."]
[]
[null,"GOOD","BETTER","BEST",null,"INCENTIVE STRUCTURE"]
["Envelope: Improved Glazing, Insulation, Infiltration",null,null,null,null,"Building Type","GOOD","BETTER","BEST"]
["Unit U-value: > 0.38 to ≤ 0.42\nCOG U-value: > 0.25 to ≤ 0.30",null,null,null,null,"Multifamily, Conditioned Garage","$0.03/SF","$0.11/SF","$0.17/SF"]
["Argon Fill // Unit U-value > 0.28 to ≤ 0.38 // COG U-value ≤ 0.25",null,null,null,null,"Multifamily, No Conditioned Garage","$0.03/SF","$0.08/SF","$0.15/SF"]
["Argon Fill // Non-metal frame // Unit U-value ≤ 0.28 // COG ≤ 0.25"]
["Roof and wall insulation R-values ","<24","24-29",">30"]
["≤ 2.4 air exchanges per hour at 50 pascals (blower door test) "]
["Lighting: Improved Lighting Power Density (LPD), Occupancy Sensor Controls"]
["LPD reduction ","10-19%","20-29%",">30%"]
["Occupancy sensors in common areas "]
["HVAC "]
["Improved heating and cooling efficiency",0.1,0.2,0.3]
["Mid-efficiency DX cooling"]
["High-efficiency DX cooling"]
["In Unit Control Type ","Standard","Programmable","Smart"]
["In-Unit Heat recovery"]
["Service Water Heating "]
["Efficiency Rating","<90%","90-94%",">95%"]
["Fixtures & Appliances "]
["ENERGY STAR® clothes washers, dishwashers, and refrigerators "]
["Low-flow showerheads "]
["Garage (if conditioned) "]
["Indirect-fired furnace/unit heater "]
["Carbon monoxide (CO) sensor control of ventilation "]

{"sheet":"Application","index":2,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[55,16,55,20],[57,16,57,20],[59,16,59,18],[41,16,41,20],[43,16,43,20],[45,16,45,18],[51,16,51,19],[53,16,53,17],[53,18,53,20],[17,16,17,18],[23,16,23,19],[25,16,25,17],[25,18,25,20],[46,9,46,10],[28,9,28,11],[38,9,38,13],[40,9,40,13],[42,9,42,11],[44,9,44,13],[27,16,27,20],[29,16,29,20],[31,16,31,18],[37,16,37,19],[39,16,39,17],[39,18,39,20],[9,16,9,19],[11,16,11,17],[11,18,11,20],[13,16,13,20],[15,16,15,20],[47,9,49,13],[48,1,48,6],[60,1,60,4],[54,9,54,10],[54,11,54,13],[56,9,57,13],[58,12,58,13],[58,1,58,6],[59,9,60,13],[50,5,50,6],[64,9,66,13],[50,9,50,13],[50,1,50,4],[51,9,51,13],[52,9,52,10],[52,1,52,4],[52,5,52,6],[23,2,23,6],[24,9,24,13],[25,1,25,6],[26,9,26,13],[27,1,27,6],[44,5,44,6],[29,1,29,6],[31,1,31,4],[33,10,33,12],[33,1,33,6],[37,1,37,4],[15,12,15,13],[22,9,22,10],[22,11,22,13],[20,9,20,13],[11,1,11,4],[12,1,14,7],[15,1,15,4],[15,5,15,7],[0,0,3,8],[0,9,3,13],[5,0,8,7],[7,9,7,13],[9,9,9,10],[9,11,9,13]]}
["MULTIFAMILY PRODUCT/EQUIPMENT PERFORMANCE\nFOR PROJECTS COMPLETED BY 12/31/2022 ",null,null,null,null,null,null,null,null,"Note: This workbook uses features only available in the full version of Excel.  Using Excel Online may result in the workbook not functioning properly."]
[]
[]
[]
[]
["COMPLETE ALL SECTIONS. INCOMPLETE APPLICATIONS CANNOT BE PROCESSED AND WILL DELAY PAYMENT OF INCENTIVES. APPLICATIONS MUST BE SUBMITTED WITHIN 60 DAYS OF COMPLETED PROJECT INSTALLATION, NO LATER THAN JANUARY 31, 2023. FOR ADDITIONAL COPIES OF THIS FORM, VISIT FOCUSONENERGY.COM/CATALOGS."]
[null,null,null,null,null,null,null,null,null,"CUSTOMER CONTACT INFORMATION",null,null,null,null,null,null,"Subcontractor "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Check one or write in which type of contractor.)"]
[null,null,null,null,null,null,null,null,null,"JOB SITE CUSTOMER CONTACT NAME",null,null,null,null,null,null,"       Lighting Contractor","                HVAC Contractor",null,"Other (Type): "]
[]
[null,"ACCOUNT AND CUSTOMER INFORMATION",null,null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS",null,null,null,null,"TRADE ALLY CONTACT NAME"]
[null,"TAX IDENTIFICATION NUMBER  (Check one.) ",null,null,null,"          FEIN   OR","  SSN",null,null,"         I opt in to receive program updates via text message."]
[null,"IF YOU USE A SOCIAL SECURITY NUMBER (SSN) AS YOUR TAX IDENTIFICATION NUMBER, DO NOT PROVIDE IT BELOW. YOU WILL BE CONTACTED BY THE PROGRAM VIA EMAIL TO PROVIDE A COPY OF YOUR W-9 USING A SECURE ONLINE PORTAL, IF IT IS NOT ALREADY ON FILE. YOU MUST LIST",null,null,null,null,null,null,null,"Preferred method of contact:",null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[null,null,null,null,null,null,null,null,null,"         Call","  E-mail","  Text"]
[null,null,null,null,null,null,null,null,null,"If Focus on Energy has a question about this application, we should contact:",null,null,null,null,null,null,"TRADE ALLY COMPANY NAME"]
[null,"AN E-MAIL ADDRESS IN SECTION 3.",null,null,null,null,null,null,null,"       Customer","Trady Ally","      Other"]
[null,null,null,null,null,"FEIN",null,null,null,null,null,null,null,null,null,null,"ADDRESS"]
[null,"BUSINESS CLASSIFICATION OF CUSTOMER"]
[null,"(Check one. Required for all businesses, including non-profits.)",null,null,null,null,null,null,null,"General Contractor ",null,null,null,null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,"Sole Proprietorship",null,"Individual",null,"Single Member - LLC",null,null,null,"Complete this section and any applicable to right"]
[null,"C Corporation",null,"S Corporation",null,"Partnership",null,null,null,null,null,null,null,null,null,null,"Subcontractor "]
[null,"Limited Liability Company - C Corp",null,null,null,"Limited Liability Company - S Corp",null,null,null,"TRADE ALLY CONTACT NAME",null,null,null,null,null,null,"(Check one or write in which type of contractor.)"]
[null,"Limited Liability Company - Partnership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       Lighting Contractor","                  HVAC Contractor",null,"Other (Type): "]
[null,"Other:",null,null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRADE ALLY CONTACT NAME"]
[null,null,null,null,null,null,null,null,null,"TRADE ALLY COMPANY NAME"]
[null,"OWNER NAME (REQUIRED IF SSN IS USED AS TAX IDENTIFICATION NUMBER)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[null,null,null,null,null,null,null,null,null,"ADDRESS"]
[null,"COMPANY NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRADE ALLY COMPANY NAME"]
[null,null,null,null,null,null,null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,"LEGAL ADDRESS (AS SHOWN ON COMPANY W-9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADDRESS"]
[null,null,null,null,null,null,null,null,null,"BUSINESS PAYMENT INFORMATION"]
[null,"CITY",null,null,null,"STATE","ZIP",null,null,"Make incentive check payable to:",null,null,null,null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,null,null,null,null,null,null,null,null,"        Customer","Trade Ally (complete item A)"]
[null,"WHO DID YOU WORK WITH FROM FOCUS ON ENERGY ON THIS PROJECT? (CONTACT NAME)",null,null,null,null,null,null,null,"        Other Payee (complete item B)",null,null,null,null,null,null,"Subcontractor "]
[null,null,null,null,null,null,null,null,null,"Mail check to:",null,null,null,null,null,null,"(Check one or write in which type of contractor.)"]
[null,"How did you hear about us? (Check one.)",null,null,null,null,null,null,null,"       Customer Address","  Job Site Address",null,"          Trade Ally Address",null,null,null,"       Lighting Contractor","                  HVAC Contractor",null,"Other (Type): "]
[null,"                Community Association/Agency",null,null,null,"Distributor/Supplier",null,null,null,"       Other Payee or Alternate Address (complete below)"]
[null,"Focus Direct Mail/Postcard",null,null,null,"Focus Email","Focus Event",null,null,null,null,null,null,null,null,null,"TRADE ALLY CONTACT NAME"]
[null,"Focus Staff/Energy Advisor",null,null,null,"Focus Website","Internet Search",null,null,"COMPANY NAME"]
[null,"Manufacturer",null,null,"Nat'l Rebate Administrator",null,"            Newspaper",null,null,null,null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[null,"Past Participation",null,null,"Radio","Social Media","            Trade Ally/Contractor",null,null,"ADDRESS"]
[null,"Trade Show/Fair",null,null,"TV","Utility Bill Insert/Direct Mail",null,null,null,null,null,null,null,null,null,null,"TRADE ALLY COMPANY NAME"]
[null,"        Utility Contact",null,null,"Utility Email","           Utility Website",null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,"                Word of Mouth - Referral",null,null,"            Other:",null,null,null,null,null,null,null,null,null,null,null,"ADDRESS"]
[null,null,null,null,null,null,null,null,null,"ATTENTION TO (OPTIONAL)"]
[null,"JOB SITE INFORMATION",null,null,null,null,null,null,null,"A. For Trade Ally Payee ",null,null,null,null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,"(Please refer to your utility bills for account numbers below.)",null,null,null,null,null,null,null,"To receive payment, a Trade Ally must be registered with a current W-9 on file. Provide the Trade Ally's Tax Identification Number. If you use a Social Security number as the company tax ID, do not provide it here. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subcontractor "]
[null,"JOB SITE BUSINESS NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Check one or write in which type of contractor.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       Lighting Contractor","                  HVAC Contractor",null,"Other (Type): "]
[null,"ELECTRIC UTILITY AT JOB SITE",null,null,null,"ELECTRIC ACCOUNT #",null,null,null,"FEIN"]
[null,null,null,null,null,null,null,null,null,"B. For Other Payee ",null,null,null,null,null,null,"TRADE ALLY CONTACT NAME"]
[null,"GAS UTILITY AT JOB SITE",null,null,null,"GAS ACCOUNT #",null,null,null,"1. Individual Contact Information:"]
[null,"IF CUSTOMER DOES NOT HAVE PARTICIPATING GAS OR ELECTRIC INCENTIVE MAY BE PRORATED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[null,"Job Site Address is same as Legal Address",null,null,null,null,null,null,null,"NAME",null,"EMAIL ADDRESS"]
[null,"Job Site Address is different (complete below.)",null,null,null,null,null,null,null,"2. Specify relationship to utility account holder (this is required if check is payable to someone other than the Customer or Trade Ally):",null,null,null,null,null,null,"TRADE ALLY COMPANY NAME"]
[]
[null,null,null,null,null,null,null,null,null," Tenant                 Building Owner",null," Other (specify)",null,null,null,null,"ADDRESS"]
[null,"JOB SITE ADDRESS",null,null,null,null,null,null,null,"3. Select your business classification (Check one. Required for all businesses, including non-profits.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CITY",null,null,"STATE","ZIP"]
[null,"CITY",null,null,null,"STATE","ZIP",null,null,"Sole Proprietorship","    Individual","          Single-Member LLC",null,"C Corporation"]
[null,null,null,null,null,null,null,null,null,"        S Corporation","Partnership","LLC - C Corp","    LLC - S Corp"]
[null,null,null,null,null,null,null,null,null," LLC - Partnership","   Other"]
[null,null,null,null,null,null,null,null,null,"4. A representative of Focus on Energy will reach out to you via email with a method to securely provide a copy of your W-9. This is required to receive payment. Provide the email address (if different than the one provided above): "]

{"sheet":"Building Details","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,3,3,3],[2,4,3,5],[13,0,14,1],[1,0,1,1]]}
["BUILDING DETAILS"]
["Complete blue shaded boxes"]
["Building type",null,null,"Your Building's Rating",{"$f":"IF('Incentive calculation'!B10=FALSE, \"Pending\", 'Incentive calculation'!B11)","v":"Pending"},null,null,null,"Building type","HVAC System"]
["Common Area Square Footage"]
["In-Unit Square Footage",null,null,"Your Progress","Status","% Complete",null,null,"Multifamily with Conditioned Garage","DX Cooling and Gas Furnace"]
["Conditioned Garage Square Footage",null,null,"Building Envelope",{"$f":"IF('Building Envelope'!L10=0,\"Complete\", \"In Progress\")","v":"In Progress"},{"$f":"'Building Envelope'!L11","v":0},null,null,"Multifamily no Conditioned Garage","Air Source Heat Pump"]
["Total Conditioned Square Footage (with garage)",{"$f":"SUM(B4:B6)","v":0},null,"Interior Lighting",{"$f":"IF('Interior Lighting'!L4=0,\"Complete\", \"In Progress\")","v":"In Progress"},{"$f":"'Interior Lighting'!L5","v":0},null,null,null,"Water Source Heat Pump"]
["Unconditioned Garage Square Footage (if applicable)",null,null,{"$f":"A9","v":"HVAC System"},{"$f":"IF(B9=\"\",\"In Progress\",IF(VLOOKUP(B9,'Incentive calculation'!O3:S8,4,FALSE)=0,\"Complete\",\"In Progress\"))","v":"In Progress"},{"$f":"IF(B9=\"\",0,(VLOOKUP(B9,'Incentive calculation'!O3:S8,5,FALSE)))","v":0},null,null,"Yes","Variable Refrigerant Flow"]
["HVAC System",null,null,"Service Water Heating",{"$f":"IF('Service Water Heating'!J1=0,\"Complete\", \"In Progress\")","v":"In Progress"},{"$f":"'Service Water Heating'!K1","v":0},null,null,"No","Ground Source Heat Pump"]
["Completion Date of Building (Occupancy Date)",null,null,"Fixtures/Plug Loads",{"$f":"IF('Fixtures_plug loads'!H11=0,\"Complete\", \"In Progress\")","v":"In Progress"},{"$f":"'Fixtures_plug loads'!I11","v":0},null,null,null,"Other"]
["Number of units",null,null,{"$f":"IF(B3=\"multifamily with conditioned garage\",\"Conditioned Garage\",\"\")","v":""},{"$f":"IF(D11=\"Conditioned Garage\",(IF(Garage!C17=0,\"Complete\", \"In Progress\")),\" \")","v":" "},{"$f":"IF(D11=\"Conditioned Garage\",Garage!D17,\" \")","v":" "}]
["Number of floors (In-Units)"]
[]
["If you have questions about any of the details in this workbook, please contact 888.623.2146 or business@focusonenergy.com "]

{"sheet":"Building Envelope","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,0,11,1],[8,0,8,1],[0,3,1,3],[0,4,1,5],[0,0,0,1],[1,0,1,1],[9,0,9,1]]}
["BUILDING ENVELOPE",null,null,{"$f":"'Building Details'!D3","v":"Your Building's Rating"},{"$f":"'Building Details'!E3","v":"Pending"}]
["Complete blue shaded boxes"]
["Type","Choose from list in each category",null,{"$f":"'Building Details'!D5","v":"Your Progress"},{"$f":"'Building Details'!E5","v":"Status"},{"$f":"'Building Details'!F5","v":"% Complete"},null,null,null,null,null,"Score","Score","Glazing","Score"]
["Glazing",null,null,{"$f":"'Building Details'!D6","v":"Building Envelope"},{"$f":"'Building Details'!E6","v":"In Progress"},{"$f":"'Building Details'!F6","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B4,N4:O8,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(#REF!,N4:O7,3,FALSE),\"\")","v":""},"No Glazing",0]
["Wall Insulation",null,null,{"$f":"'Building Details'!D7","v":"Interior Lighting"},{"$f":"'Building Details'!E7","v":"In Progress"},{"$f":"'Building Details'!F7","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B5,N12:O14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(#REF!,N11:O13,3,FALSE),\"\")","v":""},"Improved Glazing: unit > 0.38 to ≤ 0.42 and center of glass > 0.25 to ≤ 0.30",1]
["Roof Insulation",null,null,{"$f":"'Building Details'!D8","v":"HVAC System"},{"$f":"'Building Details'!E8","v":"In Progress"},{"$f":"'Building Details'!F8","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B6,N17:O20,2)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(#REF!,N16:O19,3,FALSE),\"\")","v":""},"Improved Glazing w/ argon: unit > 0.28 to ≤ 0.38 and center of glass ≤ 0.25",2]
["Air Infiltration",null,null,{"$f":"'Building Details'!D9","v":"Service Water Heating"},{"$f":"'Building Details'!E9","v":"In Progress"},{"$f":"'Building Details'!F9","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B7,N24:O26,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(#REF!,N23:O25,3,FALSE),\"\")","v":""},"Improved Glazing w/ argon; non-metal frame: unit ≤ 0.28 and center of glass ≤ 0.25",3]
[null,null,null,{"$f":"'Building Details'!D10","v":"Fixtures/Plug Loads"},{"$f":"'Building Details'!E10","v":"In Progress"},{"$f":"'Building Details'!F10","v":0},null,null,null,null,null,{"$f":"SUM((L4:L7)/4)","v":{"$error":"#N/A"}},null,"N/A",0]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Details'!D11","v":""},{"$f":"'Building Details'!E11","v":" "},{"$f":"'Building Details'!F11","v":" "},null,null,null,null,null,{"$f":"IF(L8<>\"\",IF(L8<=1.99,\"Good\",IF(C11<=2.99,\"Better\",IF(C11>=3,\"Best\",\"\"))))","v":{"$error":"#N/A"}},{"$f":"SUM(M4:M7)/4","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Fields Complete",{"$f":"COUNTBLANK(B4:B7)","v":4},{"$f":"IF(M9<>\"\",IF(M9<=1.99,\"Good\",IF(M9<=2.99,\"Better\",IF(M9>=3,\"Best\"))))","v":"Good"}]
[null,null,null,null,null,null,null,null,null,null,"% Complete",{"$f":"(4-L10)/4","v":0},null,"Wall Insulation","Score"]
["Documentation Required",null,null,null,null,null,null,null,null,null,null,null,null,"Insulation values < R-24 with thermal bridging",1]
["Glazing",{"$f":"'Submittal Requirements_Final'!C4","v":""},null,null,null,null,null,null,null,null,null,null,null,"Insulation values ≥ R-24 with thermal bridging",3]
["Wall Insulation",{"$f":"'Submittal Requirements_Final'!C6","v":""},null,null,null,null,null,null,null,null,null,null,null,"N/A",0]
["Roof Insulation",{"$f":"'Submittal Requirements_Final'!C5","v":""}]
["Air Infiltration",{"$f":"'Submittal Requirements_Final'!C7","v":""},null,null,null,null,null,null,null,null,null,null,null,"Roof Insulation","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulation values < R-24",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulation values ≥ R-24 and < R-29",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulation values ≥ R-30",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Infiltration","Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No reduction in air infiltration",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ 2.4 air changes per hour (ACH) at 50 pascals (blower door test)",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",0]

{"sheet":"DX_gas furnace","index":5,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":true,"merged":[[7,11,7,12],[12,11,12,12],[6,15,6,16],[12,15,12,16],[5,19,5,20],[10,11,10,12],[8,15,8,16],[26,0,26,1],[12,0,12,1],[13,0,16,0],[17,0,20,0],[21,0,24,0],[3,11,3,12],[3,15,3,16],[11,15,11,16],[0,0,0,1],[2,11,2,12],[4,11,4,12],[5,11,5,12],[6,11,6,12],[11,11,11,12],[10,15,10,16],[9,11,9,12],[9,0,9,1],[10,0,10,1],[1,0,1,1],[0,3,1,3],[0,4,1,5],[2,19,2,20],[3,19,3,20],[4,19,4,20],[9,15,9,16],[2,15,2,16],[4,15,4,16],[5,15,5,16]]}
["IN-UNIT HVAC - DX COOLING & GAS FURNACE",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"}]
["Complete blue shaded boxes"]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,null,{"$f":"IFERROR(VLOOKUP(B4,L3:N7,3,FALSE),\"\")","v":""},null,"DX Cooling",null,"Score",null,"Common Area DX Compressor",null,"Score",null,"Furnace",null,"Score"]
["DX Cooling (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B5,P3:R6,3,FALSE),\"\")","v":""},null,"Does not meet efficiency requirements",null,0,null,"IEER < 3 above EER",null,1,null,"< 95% efficient gas furnace",null,2]
["DX Compressor (Common Area Only)",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B6,T3:V5,3,FALSE),\"\")","v":""},null,"Mid-efficiency DX Cooling",null,1,null,"IEER 3 to 5 above EER or digital scroll compressor",null,2,null,"≥ 95% efficient gas furnace",null,3]
["Furnace (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B7,L10:N12,3,FALSE),\"\")","v":""},null,"High-efficiency DX Cooling",null,2,null,"IEER > 5 or more above EER",null,3,null,"N/A"]
["Heat Recovery (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(B8,P9:R12,3,FALSE),\"\")","v":""},null,"Premium-efficiency DX Cooling",null,3,null,"N/A"]
["Controls (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,null,null,null,null,"N/A"]
[null,null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},null,null,null,{"$f":"SUM(J3:J7)/5","v":0},null,null,null,null,null,"Controls",null,"Score"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,null,null,null,null,null,null,null,null,"Heat Recovery",null,"Score",null,"Non-programmable thermostat",null,1]
[null,null,null,null,null,null,null,null,null,null,null,"No heat recovery",null,2,null,"Programmable thermostat",null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Total heat recovery",null,3,null,"Smart thermostat",null,3]
["DX Cooling",null,null,null,null,null,null,null,"Fields Empty",{"$f":"COUNTBLANK(B4:B8)","v":5},null,"N/A",null,null,null,"N/A"]
["Mid-efficiency DX Cooling","Units ≤ 5.42 Tons with SEER > 16.0 to < 17.0 SEER",null,null,null,null,null,null,"% Complete",{"$f":"(5-J13)/5","v":0}]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) > 12.0 to < 13.0 EER"]
[null,"PTAC > 13.1 to < 14.3 EER",null,null,null,null,null,null,"Overall Rating","Good/Better/Best",{"$f":"IF(J9<>\"\",IF(J9<=1.99,\"Good\",IF(J9<=2.99,\"Better\",IF(J9>=3,\"Best\",\"\"))))","v":"Good"}]
[null,"VTAC > 11.0 to < 12.0 EER"]
["High-efficiency DX Cooling","Units ≤ 5.42 Tons with SEER > 17.0 to < 18.0 SEER"]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) > 13.0 to < 14.0 EER"]
[null,"PTAC > 14.3 to < 15.5 EER"]
[null,"VTAC > 12.0 to < 13.0 EER"]
["Premium-efficiency DX Cooling","Units ≤ 5.42 Tons with SEER ≥ 18.0 SEER"]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) ≥ 14.0 EER"]
[null,"PTAC ≥ 15.5 EER"]
[null,"VTAC≥ 13.0 EER"]
[]
["Documentation Required"]
["DX Cooling (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["DX Compressor (Common Area Only)",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Furnace (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Recovery (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B8,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Interior Lighting","index":6,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,1,31,2],[29,0,29,2],[32,1,32,2],[19,15,19,16],[20,15,20,16],[21,15,21,16],[26,0,26,2],[27,0,27,1],[0,0,0,2],[21,11,21,12],[22,11,22,12],[23,11,23,12],[19,11,19,12],[0,4,1,4],[0,5,1,6],[20,11,20,12],[1,0,1,2],[8,0,9,1]]}
["INTERIOR LIGHTING",null,null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
["Complete blue shaded boxes",null,null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0},null,null,null,null,{"$f":"COUNTBLANK(B4:B12)","v":9}]
["Total Proposed Wattages (Per COMcheck)","Watts","Watts/ft2",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,null,null,{"$f":"L2-4","v":5}]
["Common area",null,null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,null,null,{"$f":"L3/5","v":1}]
["In unit",null,null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,null,null,{"$f":"1-L4","v":0}]
["Conditioned Garage",null,null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0}]
["** For unconditioned garage lighting incentive, complete a separate Interior Lighting Workbook/Application using LPD measure",null,null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0}]
["Percentage of area per unit with no connected fixtures*.  ",null,"of square feet",null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0}]
["*A connected fixture is hard-wired light fixture, such as an overhead light fixture, wall sconce, or recessed can light.",null,null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "}]
[]
[]
["Common Area Occupancy Sensors",null,null,null,"Enter Proposed Wattages from COMcheck - see example below:"]
[]
[]
[null,"Total Allowed Watts"]
["Common Area ",{"$f":"IF(B4=0,0,0.73*'Building Details'!B4)","v":0}]
["In unit",{"$f":"IF(B5=0,0,1.1*'Building Details'!B5)","v":0}]
["Conditioned Garage",{"$f":"IF(B6=0,0,0.21*'Building Details'!B6)","v":0}]
["Improvement",{"$f":"IF(B16+B17+B18=0,0,(1-(B4+(B8*'Building Details'!B7*1.1)+B5+B6)/SUM(B16:B18)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Lighting Power Density",null,"Score",null,"Occupancy Sensors",null,"Score"]
["Type","Score",null,null,null,null,null,null,null,null,null,"Less than 10% improved ",null,0,null,"No",null,1]
["Lighting Power Density",{"$f":"IFERROR(IF(B19>0.3,3,IF(B19>0.2,2,IF(B19>0.1,1,0))),\"\")","v":0},null,null,null,null,null,null,null,null,null,"10-19% improved",null,1,null,"Yes",null,3]
["Occupancy Sensors",{"$f":"IFERROR(VLOOKUP(B12,P20:R22,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,"20-29% improved",null,2]
[null,null,null,null,null,null,null,null,null,null,null,"30%+ improved",null,3]
["Average Score",{"$f":"SUM(B22:B23)/2","v":0}]
["Overall Rating",{"$f":"IF(B25<>\"\",IF(B25<=1.99,\"Good\",IF(B25<=2.99,\"Better\",IF(B25>=3,\"Best\",\"\"))))","v":"Good"}]
["Notes  (include any deviations from selection or clarifications)"]
[]
[]
["Documentation Required"]
[]
["Lighting Power Density",{"$f":"'Submittal Requirements_Final'!C10","v":"None"}]
["Occupancy Sensors",{"$f":"'Submittal Requirements_Final'!C11","v":""}]

{"sheet":"Air Source Heat Pump","index":7,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":true,"merged":[[25,0,25,1],[26,0,29,0],[30,0,33,0],[34,0,37,0],[20,0,23,0],[16,0,19,0],[8,0,8,1],[1,0,1,1],[9,0,9,1],[12,16,12,17],[11,12,11,13],[11,16,11,17],[13,16,13,17],[5,12,5,13],[6,12,6,13],[7,16,7,17],[0,3,1,3],[0,4,1,5],[0,0,0,1],[7,12,7,13],[12,12,12,13],[11,0,11,1],[12,0,15,0],[2,20,2,21],[3,20,3,21],[4,20,4,21],[9,12,9,13],[10,12,10,13],[9,16,9,17],[10,16,10,17],[2,16,2,17],[4,16,4,17],[5,16,5,17],[6,16,6,17],[2,12,2,13],[4,12,4,13]]}
["IN-UNIT HVAC - AIR SOURCE HEAT PUMP",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0},null,null,{"$f":"COUNTBLANK(K4:K7)","v":4},{"$f":"(4-I1)/4","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,null,null,"Score",null,"Air Source Heat Pump cooling efficiency",null,"Score",null,"Air Source Heat Pump heating efficiency",null,"Score"]
["Heat Pump Cooling Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B4,M3:O7,3,FALSE),\"\")","v":""},null,"Does not meet efficiency requirements",null,0,null,"Does not meet efficiency requirements",null,0]
["Heat Pump Heating Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,Q3:S7,3,FALSE),\"\")","v":""},null,"Mid-efficiency ASHP Cooling",null,1,null,"Mid-efficiency ASHP Heating",null,1]
["Heat Recovery (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B6,M10:O12,3,FALSE),\"\")","v":""},null,"High-efficiency ASHP Cooling",null,2,null,"High-efficiency ASHP Heating",null,2]
["Controls (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(B7,Q10:S13,3,FALSE),\"\")","v":""},null,"Premium-efficiency ASHP Cooling",null,3,null,"Premium-efficiency ASHP Heating",null,3]
[null,null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,null,null,null,null,null,"N/A",null,null,null,"N/A"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K7)/5","v":0},null,"Heat Recovery",null,"Score",null,"Controls",null,"Score"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10<>\"\",IF(K10<=1.99,\"Good\",IF(K10<=2.99,\"Better\",IF(K10>=3,\"Best\",\"\"))))","v":"Good"},null,"No heat recovery",null,2,null,"Non-programmable thermostat",null,1]
["Air Source Heat Pump Cooling Efficiency",null,null,null,null,null,null,null,null,null,null,null,"Total heat recovery",null,3,null,"Programmable thermostat",null,2]
["Mid-efficiency ASHP Cooling","Units ≤ 5.42 Tons with SEER > 16.0 to 17.0 SEER",null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,"Smart thermostat",null,3]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) > 12.0 to < 13.0 EER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"PTAC/PTHP > 13.1 to < 14.3 EER"]
[null,"VTAC/SPVAC > 11.0 to < 12.0 EER"]
["High-efficiency ASHP Cooling","Units ≤ 5.42 Tons with SEER > 17.0 to 18.0 SEER"]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) > 13.0 to < 14.0 EER"]
[null,"PTAC/PTHP > 14.3 to < 15.5 EER"]
[null,"VTAC/SPVAC > 12.0 to < 13.0 EER"]
["Premium-efficiency ASHP Cooling","Units ≤ 5.42 Tons with SEER ≥ 18.0 SEER"]
[null,"Units > 5.42 Tons with EER (except packaged terminal units) ≥ 14.0 EER"]
[null,"PTAC/PTHP ≥ 15.5 EER"]
[null,"VTAC/SPVAC ≥ 13.0 EER"]
[]
["Air Source Heat Pump Heating Efficiency"]
["Mid-efficiency ASHP Heating","COP Units (except packaged terminal units) > 3.6 to < 4.0 COP"]
[null,"PTHP > 3.0 to < 3.3 COP"]
[null,"SPVHP > 3.3 to < 3.6 COP"]
[null,"HSPF Units > 8.5 to < 9.2 HSPF"]
["High-efficiency ASHP Heating","COP Units (except packaged terminal units) > 4.0 to < 4.3 COP"]
[null," PTHP > 3.3 to < 3.5 COP"]
[null,"SPVHP > 3.6 to < 3.9 COP"]
[null,"HSPF Units > 8.5 to < 9.2 HSPF"]
["Premium-efficiency ASHP Heating","COP Units (except packaged terminal units) ≥ 4.3 COP"]
[null,"PTHP ≥ 3.3 COP"]
[null,"SPVHP ≥ 3.9 COP"]
[null,"HSPF Units ≥ 10.0 HSPF"]
[]
["Documentation Required"]
["Heat pump cooling efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat pump heating efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Recovery (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Water Source Heat Pump","index":8,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":true,"merged":[[8,22,8,23],[11,10,11,11],[14,18,14,19],[11,14,11,15],[13,18,13,19],[1,0,1,1],[7,18,7,19],[11,18,11,19],[12,18,12,19],[0,3,1,3],[0,4,1,5],[0,0,0,1],[3,10,3,11],[4,10,4,11],[5,10,5,11],[3,14,3,15],[4,14,4,15],[5,14,5,15],[8,18,8,19],[6,10,6,11],[6,14,6,15],[3,22,3,23],[5,22,5,23],[6,22,6,23],[12,0,12,1],[7,22,7,23],[10,18,10,19],[8,10,8,11],[9,10,9,11],[10,10,10,11],[8,14,8,15],[9,14,9,15],[10,14,10,15],[3,18,3,19],[5,18,5,19],[6,18,6,19],[11,0,11,1]]}
["IN-UNIT HVAC - WATER SOURCE HEAT PUMP",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0},null,{"$f":"COUNTBLANK(I5:I11)","v":7},{"$f":"(7-H1)/7","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"}]
["Controls on Water Source Heat Pump (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,"Score",null,"Water Source Heat pump",null,"Score",null,"Cooling tower fan",null,"Score",null,"Heat Pump Cooling Efficiency",null,"Score",null,"Heat Pump Heating Efficiency",null,"Score"]
["Controls on Cooling Tower Fan (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B4,K4:M6,3,FALSE),\"\")","v":""},null,"No VFD",null,0,null,"No VFD",null,0,null,"AHRI-rating < 14.3 EER",null,0,null,"AHRI Rating < 4.7 COP",null,0]
["Heat Pump Cooling Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B5,O4:Q6,3,FALSE),\"\")","v":""},null,"VFD on water source heat pump circulator pump",null,3,null,"VFD on cooling tower fan",null,3,null,"AHRI-rating ≥ 14.3 to < 15.6 EER",null,1,null,"AHRI-rating ≥ 4.7 to < 5.2 COP",null,1]
["Heat Pump Heating Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B6,S4:U8,3,FALSE),\"\")","v":""},null,"N/A",null,null,null,"N/A",null,null,null,"AHRI-rating ≥ 15.6 to < 16.9 EER",null,2,null,"AHRI-rating ≥ 5.2 to < 5.6 COP",null,2]
["Water loop Gas Boiler Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B7,W4:Y8,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,"AHRI-rating ≥ 16.9 EER",null,3,null,"AHRI-rating ≥ 5.6 COP",null,3]
["Heat Recovery (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},null,null,{"$f":"IFERROR(VLOOKUP(B8,K9:M11,3,FALSE),\"\")","v":""},null,"Water loop Gas Boiler efficiency",null,"Score",null,"Heat Recovery",null,"Score",null,"N/A",null,null,null,"N/A"]
["Controls (In-Unit Only)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B9,O9:Q11,3,FALSE),\"\")","v":""},null,"Non-condensing water loop gas boiler",null,2,null,"No heat recovery",null,2]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B10,S11:U14,3,FALSE),\"\")","v":""},null,"Condensing water loop gas boiler",null,3,null,"Total heat recovery",null,3,null,"Controls",null,"Score"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,null,null,null,null,null,null,null,"N/A",null,null,null,"N/A",null,null,null,"Non-programmable thermostat",null,1]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I11)/7","v":0},{"$f":"IF(I13<>\"\",IF(I13<=1.99,\"Good\",IF(I13<=2.99,\"Better\",IF(I13>=3,\"Best\",\"\"))))","v":"Good"},null,null,null,null,null,null,null,null,"Programmable thermostat",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart thermostat",null,3]
["Documentation Required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Controls on water source heat pump (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Controls on cooling tower fan (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Pump Cooling Efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Pump Heating Efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Water loop Gas Boiler efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B8,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Recovery (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B9,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B10,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Variable Refrigerant Flow","index":9,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":true,"merged":[[8,0,8,1],[10,7,10,8],[11,11,11,12],[11,0,11,1],[9,0,9,1],[10,11,10,12],[0,0,0,1],[2,7,2,8],[2,11,2,12],[5,7,5,8],[5,11,5,12],[0,3,1,3],[0,4,1,5],[1,0,1,1],[7,7,7,8],[7,11,7,12],[8,7,8,8],[8,11,8,12],[9,7,9,8],[9,11,9,12],[5,15,5,16],[3,15,3,16],[2,15,2,16],[3,7,3,8],[3,11,3,12],[4,15,4,16],[4,7,4,8],[4,11,4,12]]}
["IN-UNIT HVAC - VARIABLE REFRIGERANT FLOW",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,"VRF System",null,"Score",null,null,null,null,null,"DX Compressor ",null,"Score",null,"Score"]
["Variable Refrigerant Flow System",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,"VRF installed",null,3,null,null,null,null,null,"IEER < 3 above EER",null,1,null,{"$f":"IFERROR(VLOOKUP(B4,H3:J6,3,FALSE),\"\")","v":""}]
["Heat Recovery (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,"N/A",null,null,null,null,null,null,null,"IEER 3 to 5 above EER or digital scroll compressor",null,2,null,{"$f":"IFERROR(VLOOKUP(B5,H8:J10,3,FALSE),\"\")","v":""}]
["Controls (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,null,null,null,null,null,null,null,"IEER > 5 above EER",null,3,null,{"$f":"IFERROR(VLOOKUP(B6,L8:N11,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0}]
[null,null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,"Heat Recovery",null,"Score",null,"Controls",null,"Score",null,null,null,null,null,{"$f":"SUM(T4:T6)/3","v":0}]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},null,"No heat recovery",null,2,null,"Non-programmable thermostat",null,1]
[null,null,null,null,null,null,null,"Total heat recovery",null,3,null,"Programmable thermostat",null,2,null,null,null,null,null,{"$f":"IF(T8<>\"\",IF(T8<=1.99,\"Good\",IF(T8<=2.99,\"Better\",IF(T8>=3,\"Best\",\"\"))))","v":"Good"}]
[null,null,null,null,null,null,null,"N/A",null,null,null,"Smart thermostat",null,3]
["Documentation Required",null,null,null,null,null,null,null,null,null,null,"N/A"]
["VRF System",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Heat Recovery (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"COUNTBLANK(T4:T6)","v":3},{"$f":"(3-C16)/3","v":0}]

{"sheet":"Other","index":10,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,3,1,3],[0,4,1,5],[5,0,5,1],[11,0,11,1],[10,0,10,1],[1,0,1,1],[0,0,0,1],[6,0,8,1],[13,0,13,1],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9]]}
["HVAC - OTHER HVAC SYSTEM",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,"Controls",null,"Score"]
["Controls (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,"Non-programmable thermostat",null,null,null,null,null,null,{"$f":"IFERROR(IF(N4=\"TBD\",\"TBD\",\"\"),\"\")","v":""}]
[null,null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,"Programmable thermostat",null,null,null,null,"Good"]
["Describe HVAC system and efficiency components",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,"Smart thermostat",null,null,null,null,"Better"]
[null,null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,"N/A",null,null,null,null,"Best"]
[null,null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0}]
[null,null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},null,null,null,null,null,null,null,"Score"]
["Rating (Select from Dropdown):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10=\"Good\",1,IF(B10=\"Better\",2,IF(B10=\"Best\",3,\"\")))","v":""}]
["Notes  (include any deviations from selection or clarifications)"]
[]
[]
["Documentation Required"]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Ground Source Heat Pump","index":11,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":true,"merged":[[7,13,7,14],[7,9,7,10],[13,13,13,14],[11,0,11,1],[9,13,9,14],[10,9,10,10],[10,13,10,14],[12,13,12,14],[8,0,8,1],[11,9,11,10],[11,13,11,14],[9,9,9,10],[9,0,9,1],[12,9,12,10],[5,17,5,18],[2,9,2,10],[2,13,2,14],[0,0,0,1],[2,17,2,18],[4,9,4,10],[4,13,4,14],[4,17,4,18],[3,17,3,18],[6,9,6,10],[6,13,6,14],[0,3,1,3],[0,4,1,5],[1,0,1,1],[5,9,5,10],[5,13,5,14]]}
["IN-UNIT HVAC - GROUND SOURCE HEAT PUMP",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,"Score","Heat pump cooling efficiency",null,"Score",null,"Heat Pump heating efficiency",null,"Score",null,"DX Compressor ",null,"Score"]
["Heat Pump Cooling Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B4,J3:L7,3,FALSE),\"\")","v":""},"AHRI-rating < 19.8 EER",null,0,null,"AHRI-rating < 4.1 COP",null,0,null,"IEER < 3 above EER",null,1]
["Heat pump Heating Efficiency (In-Unit & Common Area)",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B5,N3:P7,3,FALSE),\"\")","v":""},"AHRI-rating ≥ 19.8 to < 21.6 EER",null,1,null,"AHRI-rating ≥ 4.1 to < 4.4 COP",null,1,null,"IEER ≥ 3 to < 5 above EER or digital scroll compressor",null,2]
["Heat Recovery (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B6,J10:L12,3,FALSE),\"\")","v":""},"AHRI-rating ≥ 21.6 to < 23.4 EER",null,2,null,"AHRI-rating ≥ 4.4 to < 4.8 COP",null,2,null,"IEER ≥ 5 above EER",null,3]
["Controls (In-Unit Only)",null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B7,N10:P13,3,FALSE),\"\")","v":""},"AHRI-rating ≥ 23.4 EER",null,3,null,"AHRI-rating ≥ 4.8 COP",null,3]
[null,null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,null,{"$f":"SUM(I4:I7)/4","v":0},"N/A",null,null,null,"N/A"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I8<>\"\",IF(I8<=1.99,\"Good\",IF(I8<=2.99,\"Better\",IF(I8>=3,\"Best\",\"\"))))","v":"Good"},"Heat Recovery",null,"Score",null,"Controls",null,"Score"]
[null,null,null,null,null,null,null,null,null,"No heat recovery",null,2,null,"Non-programmable thermostat",null,1]
["Documentation Required",null,null,null,null,null,null,null,null,"Total heat recovery",null,3,null,"Programmable thermostat",null,2]
["Heat pump cooling efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"N/A",null,null,null,"Smart thermostat",null,3]
["Heat pump heating efficiency (In-Unit & Common Area)",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Heat Recovery (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""},{"$f":"COUNTBLANK(I4:I7)","v":4},{"$f":"(4-C15)/4","v":0}]
["Controls (In-Unit Only)",{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Service Water Heating","index":12,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,3,1,3],[0,4,1,5],[0,0,0,1],[8,0,8,1],[1,0,1,1],[11,0,11,1],[3,7,3,8],[4,7,4,8],[5,7,5,8],[6,7,6,8],[9,0,9,1],[7,7,7,8]]}
["SERVICE WATER HEATING",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0},null,null,null,{"$f":"COUNTBLANK(B4)","v":1},{"$f":"(1-J1)/1","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"},null,null,null,null,null,null,"Score"]
["Service Water Heating Efficiency",null,null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,"Service Water Heating Efficiency",null,"Score",null,null,{"$f":"IFERROR(VLOOKUP(B4,H4:J7,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,"< 90% SWH Efficiency",null,1]
[null,"Average Score",null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,"90 to 95% SWH Efficiency",null,2,null,null,{"$f":"SUM(M4)/1","v":0}]
["Overall Rating","Good/Better/Best",null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,"≥ 95% SWH Efficiency",null,3,null,null,{"$f":"IF(M6<>\"\",IF(M6<=1.99,\"Good\",IF(M6<=2.99,\"Better\",IF(M6>=3,\"Best\",\"\"))))","v":"Good"}]
[null,null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,"N/A"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "}]
[]
[]
["Documentation Required"]
["Service Water Heating Efficiency",{"$f":"'Submittal Requirements_Final'!C22","v":""}]

{"sheet":"Fixtures_plug loads","index":13,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,17,6,18],[11,9,11,10],[9,0,9,1],[10,0,10,1],[0,0,0,1],[3,17,3,18],[4,17,4,18],[5,17,5,18],[8,9,8,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[3,13,3,14],[4,13,4,14],[5,13,5,14],[0,3,1,3],[0,4,1,5],[1,0,1,1],[6,9,6,10],[6,13,6,14]]}
["FIXTURES/PLUG LOADS",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
["Complete blue shaded boxes",null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
["If any of these appliances are not available in-unit, please specifcy in the Notes section.",null,null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,"Score","Clothes Washer",null,"Score",null,"Dishwasher",null,"Score",null,"Refrigerator",null,"Score"]
["Clothes Washer",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B5,J4:L6,3,FALSE),\"\")","v":""},"Non-ENERGY STAR",null,0,null,"Non-ENERGY STAR",null,0,null,"Non-ENERGY STAR",null,0]
["Dishwasher",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B6,N4:P6,3,FALSE),\"\")","v":""},"ENERGY STAR Clothes Washer",null,3,null,"ENERGY STAR Dishwasher",null,3,null,"ENERGY STAR Refrigerator",null,3]
["Refrigerator",null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B7,R4:T6,3,FALSE),\"\")","v":""},"N/A",null,null,null,"N/A",null,null,null,"N/A"]
["Showerheads",null,null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},null,null,{"$f":"IFERROR(VLOOKUP(B8,J9:L11,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},null,null,{"$f":"SUM(I5:I8)/4","v":0},"Showerheads",null,"Score"]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,null,null,null,null,{"$f":"IF(I9<>\"\",IF(I9<=1.99,\"Good\",IF(I9<=2.99,\"Better\",IF(I9>=3,\"Best\",\"\"))))","v":"Good"},null,"Showerheads > 2.0 GPM flow",null,1]
[null,null,null,null,null,null,null,{"$f":"COUNTBLANK(B5:B8)","v":4},{"$f":"(4-H11)/4","v":0},"Low Flow Showerheads ≤ 2.0 GPM",null,3]
[null,null,null,null,null,null,null,null,null,"N/A"]
["Documentation Required"]
["Clothes Washer",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Dishwasher",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Refrigerator",{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Showerheads",{"$f":"IFERROR(VLOOKUP(B8,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Garage","index":14,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,6,8,7],[8,10,8,11],[5,10,5,11],[6,10,6,11],[7,10,7,11],[5,6,5,7],[6,6,6,7],[7,6,7,7],[0,3,1,3],[0,4,1,5],[1,0,1,1],[11,0,11,1],[9,0,9,1],[8,0,8,1]]}
["CONDITIONED GARAGE",null,null,{"$f":"'Building Envelope'!D1","v":"Your Building's Rating"},{"$f":"'Building Envelope'!E1","v":"Pending"},{"$f":"'Building Envelope'!F1","v":0}]
[{"$f":"IF('Building Details'!B3=\"Multifamily with Conditioned Garage\",\"Complete blue shaded boxes\",\"This tab is not required for your application\")","v":"This tab is not required for your application"},null,null,{"$f":"'Building Envelope'!D2","v":0},{"$f":"'Building Envelope'!E2","v":0},{"$f":"'Building Envelope'!F2","v":0}]
[null,null,null,{"$f":"'Building Envelope'!D3","v":"Your Progress"},{"$f":"'Building Envelope'!E3","v":"Status"},{"$f":"'Building Envelope'!F3","v":"% Complete"}]
["Type","Choose from list in each category",null,{"$f":"'Building Envelope'!D4","v":"Building Envelope"},{"$f":"'Building Envelope'!E4","v":"In Progress"},{"$f":"'Building Envelope'!F4","v":0},null,null,null,null,null,null,null,null,null,null,null,"Score"]
["Garage Ventilation",null,null,{"$f":"'Building Envelope'!D5","v":"Interior Lighting"},{"$f":"'Building Envelope'!E5","v":"In Progress"},{"$f":"'Building Envelope'!F5","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B5,G6:I8,3,FALSE),\"\")","v":""}]
["Garage Conditioning",null,null,{"$f":"'Building Envelope'!D6","v":"HVAC System"},{"$f":"'Building Envelope'!E6","v":"In Progress"},{"$f":"'Building Envelope'!F6","v":0},"Garage Ventilation",null,"Score",null,"Garage Conditioning",null,"Score",null,null,null,null,{"$f":"IFERROR(VLOOKUP(B6,K6:M8,3,FALSE),\"\")","v":""}]
[null,null,null,{"$f":"'Building Envelope'!D7","v":"Service Water Heating"},{"$f":"'Building Envelope'!E7","v":"In Progress"},{"$f":"'Building Envelope'!F7","v":0},"No controls",null,1,null,"Indirect-fired furnace/unit heater",null,1]
[null,"Average Score",null,{"$f":"'Building Envelope'!D8","v":"Fixtures/Plug Loads"},{"$f":"'Building Envelope'!E8","v":"In Progress"},{"$f":"'Building Envelope'!F8","v":0},"CO sensor control of ventilation (Garage only)",null,3,null,"Direct-fired furnace/unit heater",null,3,null,null,null,null,{"$f":"SUM(R5:R6)/2","v":0}]
["Notes (include any deviations from selection or clarifications if 'N/A' selected)",null,null,{"$f":"'Building Envelope'!D9","v":""},{"$f":"'Building Envelope'!E9","v":" "},{"$f":"'Building Envelope'!F9","v":" "},"N/A",null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R8<>\"\",IF(R8<=1.99,\"Good\",IF(R8<=2.99,\"Better\",IF(R8>=3,\"Best\",\"\"))))","v":"Good"}]
[]
["Documentation Required"]
["Garage Ventilation",{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Garage Conditioning",{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[]
[]
[null,null,{"$f":"COUNTBLANK(B5:B6)","v":2},{"$f":"(2-C17)/2","v":0}]

{"sheet":"Incentive calculation","index":15,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,1,60,5],[61,1,61,5],[42,1,42,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[59,1,59,5],[58,1,58,5],[57,1,57,5],[56,1,56,5],[55,1,55,5],[44,0,44,5],[50,0,50,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[27,0,27,5],[37,0,37,5],[54,0,54,5],[51,1,51,5],[52,1,52,5],[38,1,38,5],[39,1,39,5],[20,0,20,1],[22,0,22,1],[24,0,24,1],[31,0,31,5],[17,0,17,5],[18,0,18,5],[20,4,20,5],[26,0,26,5],[29,0,29,5],[30,0,30,5]]}
["Hidden Content"]
["Sections","Rating","Score","Weighted Score"]
["Envelope",{"$f":"'Building Envelope'!M10","v":"Good"},{"$f":"IFERROR('Building Envelope'!L8,\"\")","v":""},{"$f":"IFERROR(IF($D$8>0,C3*0.1,C3*0.1),\"\")","v":""},null,null,"HVAC System Agnostic","Conditioned Garage","No Garage",null,null,null,null,null,"DX Cooling and Gas furnace",{"$f":"'DX_gas furnace'!J9","v":0},{"$f":"'DX_gas furnace'!K16","v":"Good"},{"$f":"'DX_gas furnace'!J13","v":5},{"$f":"'DX_gas furnace'!J14","v":0}]
["Lighting",{"$f":"'Interior Lighting'!B26","v":"Good"},{"$f":"'Interior Lighting'!B25","v":0},{"$f":"IFERROR(IF($D$8>0,C4*0.2,C4*0.25),\"\")","v":0},null,null,"Good",0.03,0.03,null,null,null,"HVAC Score",null,"Air Source Heat Pump",{"$f":"'Air Source Heat Pump'!K10","v":0},{"$f":"'Air Source Heat Pump'!K11","v":"Good"},{"$f":"'Air Source Heat Pump'!I1","v":4},{"$f":"'Air Source Heat Pump'!J1","v":0}]
["HVAC",{"$f":"IFERROR(VLOOKUP('Building Details'!B9,'Incentive calculation'!O3:Q8,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('Building Details'!B9,'Incentive calculation'!O3:Q8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF($D$8>0,C5*0.35,C5*0.4),\"\")","v":""},null,null,"Better",0.11,0.08,null,null,null,"HVAC Rating",null,"Water Source Heat pump",{"$f":"'Water Source Heat Pump'!I13","v":0},{"$f":"'Water Source Heat Pump'!J13","v":"Good"},{"$f":"'Water Source Heat Pump'!H1","v":7},{"$f":"'Water Source Heat Pump'!I1","v":0}]
["Service Water Heating",{"$f":"'Service Water Heating'!M7","v":"Good"},{"$f":"'Service Water Heating'!M6","v":0},{"$f":"IFERROR(IF($D$8>0,C6*0.1,C6*0.1),\"\")","v":0},null,null,"Best",0.17,0.15,null,null,null,null,null,"Variable Refrigerant Flow",{"$f":"'Variable Refrigerant Flow'!T8","v":0},{"$f":"'Variable Refrigerant Flow'!T10","v":"Good"},{"$f":"'Variable Refrigerant Flow'!C16","v":3},{"$f":"'Variable Refrigerant Flow'!D16","v":0}]
["Fixtures/plug loads",{"$f":"'Fixtures_plug loads'!H10","v":"Good"},{"$f":"'Fixtures_plug loads'!I9","v":0},{"$f":"(IF($D$8>0,C7*0.15,C7*0.15))","v":0},null,null,null,null,null,null,null,null,null,null,"Ground Source Heat Pump",{"$f":"'Ground Source Heat Pump'!I8","v":0},{"$f":"'Ground Source Heat Pump'!I10","v":"Good"},{"$f":"'Ground Source Heat Pump'!C15","v":4},{"$f":"'Ground Source Heat Pump'!D15","v":0}]
["Garage",{"$f":"IF('Building Details'!B3=\"Multifamily with Conditioned Garage\",Garage!R10,\"N/A\")","v":"N/A"},{"$f":"IF('Building Details'!B3=\"Multifamily with Conditioned Garage\",Garage!R8,\"N/A\")","v":"N/A"},{"$f":"IF(B8=\"N/A\",0,C8*0.1)","v":0},{"$f":"IF(C8>0,C8,0)","v":"N/A"},null,"Bonuses:","Per Square Ft.",null,null,null,null,null,null,"Other",{"$f":"IF(Q8=\"Good\",1,IF(Q8=\"Better\",2,IF(Q8=\"Best\",3,\"\")))","v":""},{"$f":"IFERROR(Other!B10,\"\")","v":0},{"$f":"COUNTBLANK(Other!B4)","v":1},{"$f":"1-R8","v":0}]
[null,null,null,null,"Incentive Rate",null,"VRF",0.04]
[null,{"$f":"IF(D10=0,\"Pending\",_xlfn.IFS(D10<=1.99,\"Good\",D10<=2.99,\"Better\",D10>=3,\"Best\"))","v":"Pending"},{"$f":"IFERROR(IF(E8>0,AVERAGE(C3:C8),\"\"),\"\")","v":0},{"$f":"SUM(D3:D8)","v":0},{"$f":"IFERROR(VLOOKUP(C21,G3:I6,2,FALSE),\"0\")","v":"0"},null,"GSHP",0.17]
["Final",{"$f":"IF('Building Details'!B9=\"Other\",\"Contact Focus on Energy\",'Incentive calculation'!B10)","v":"Pending"}]
[]
["Bonus Incentive","Eligible","Per Square Ft."]
["VRF",{"$f":"IF('Building Details'!B9=\"variable refrigerant flow\",\"Yes\",\"No\")","v":"No"},{"$f":"IF('Building Details'!B9=\"variable refrigerant flow\", 'Incentive calculation'!H9,0)","v":0}]
["GSHP",{"$f":"IF('Building Details'!B9=\"ground source heat pump\",\"Yes\",\"No\")","v":"No"},{"$f":"IF('Building Details'!B9=\"ground source heat pump\", 'Incentive calculation'!H10,0)","v":0}]
[]
[]
[{"$f":"Application!A1","v":"MULTIFAMILY PRODUCT/EQUIPMENT PERFORMANCE\nFOR PROJECTS COMPLETED BY 12/31/2022 "}]
["INCOMPLETE APPLICATIONS CANNOT BE PROCESSED AND WILL DELAY PAYMENT OF INCENTIVES. \nAPPLICATIONS MUST BE SUBMITTED WITHIN 60 DAYS OF COMPLETED PROJECT INSTALLATION, NO LATER THAN JANUARY 31, 2023. "]
[]
["Your Building Rating:",null,{"$f":"B10","v":"Pending"},null,"Bonuses Included"]
[null,null,null,null,{"$f":"A14","v":"VRF"},{"$f":"B14","v":"No"}]
["Incentive per Sq. Ft",null,{"$f":"IFERROR(E10+C14+C15,\"\")","v":0},null,{"$f":"A15","v":"GSHP"},{"$f":"B15","v":"No"}]
[]
["Total Incentive",null,{"$f":"IFERROR(C23*'Building Details'!B7,\"\")","v":0}]
[]
["Next Steps"]
["Gather the documentation below and submit with your application at www.focusonenergy.com/MFPEP."]
[]
["General Documentation"]
["Submit building plan that includes building layout and/or square footage table."]
["Building Envelope Documentation"]
[{"$f":"'Submittal Requirements_Final'!A4","v":"Glazing"},{"$f":"'Submittal Requirements_Final'!C4","v":""}]
[{"$f":"'Submittal Requirements_Final'!A5","v":"Roof Insulation"},{"$f":"'Submittal Requirements_Final'!C5","v":""}]
[{"$f":"'Submittal Requirements_Final'!A6","v":"Wall Insulation"},{"$f":"'Submittal Requirements_Final'!C6","v":""}]
[{"$f":"'Submittal Requirements_Final'!A7","v":"Air Infiltration"},{"$f":"'Submittal Requirements_Final'!C7","v":""}]
[null,{"$f":"'Submittal Requirements_Final'!C8","v":""}]
["Lighting Documentation",{"$f":"'Submittal Requirements_Final'!C9","v":""}]
[{"$f":"'Submittal Requirements_Final'!A10","v":"Lighting Power Density"},{"$f":"'Submittal Requirements_Final'!C10","v":"None"}]
[{"$f":"'Submittal Requirements_Final'!A11","v":"Common Area Occupancy Sensors"},{"$f":"'Submittal Requirements_Final'!C11","v":""}]
[null,{"$f":"'Submittal Requirements_Final'!C12","v":""}]
["Service Water Heating Documentation",{"$f":"'Submittal Requirements_Final'!C21","v":""}]
[{"$f":"'Submittal Requirements_Final'!A22","v":"Service Water Heating"},{"$f":"'Submittal Requirements_Final'!C22","v":""}]
[]
["Fixtures/Plug Load Documentation",{"$f":"'Submittal Requirements_Final'!C24","v":""}]
[{"$f":"'Submittal Requirements_Final'!A25","v":"Clothes Washer"},{"$f":"'Submittal Requirements_Final'!C25","v":""}]
[{"$f":"'Submittal Requirements_Final'!A26","v":"Dishwasher"},{"$f":"'Submittal Requirements_Final'!C26","v":""}]
[{"$f":"'Submittal Requirements_Final'!A27","v":"Refrigerator"},{"$f":"'Submittal Requirements_Final'!C27","v":""}]
[{"$f":"'Submittal Requirements_Final'!A28","v":"Showerheads"},{"$f":"'Submittal Requirements_Final'!C28","v":""}]
[]
["Garage Documentation",{"$f":"'Submittal Requirements_Final'!C30","v":""}]
[{"$f":"'Submittal Requirements_Final'!A31","v":"Garage Ventilation"},{"$f":"'Submittal Requirements_Final'!C31","v":"None"}]
[{"$f":"'Submittal Requirements_Final'!A32","v":"Garage Conditioning"},{"$f":"'Submittal Requirements_Final'!C32","v":"None"}]
[]
["HVAC System Documentation",{"$f":"'Submittal Requirements_Final'!C13","v":""}]
[{"$f":"'Submittal Requirements_Final'!A14","v":{"$error":"#N/A"}},{"$f":"'Submittal Requirements_Final'!C14","v":"None"}]
[{"$f":"'Submittal Requirements_Final'!A15","v":{"$error":"#N/A"}},{"$f":"'Submittal Requirements_Final'!C15","v":""}]
[{"$f":"'Submittal Requirements_Final'!A16","v":{"$error":"#N/A"}},{"$f":"'Submittal Requirements_Final'!C16","v":""}]
[{"$f":"'Submittal Requirements_Final'!A17","v":{"$error":"#N/A"}},{"$f":"'Submittal Requirements_Final'!C17","v":""}]
[{"$f":"'Submittal Requirements_Final'!A18","v":{"$error":"#N/A"}},{"$f":"'Submittal Requirements_Final'!C18","v":""}]
[{"$f":"'Submittal Requirements_Final'!A19","v":""},{"$f":"'Submittal Requirements_Final'!C19","v":""}]
[{"$f":"'Submittal Requirements_Final'!A20","v":""},{"$f":"'Submittal Requirements_Final'!C20","v":""}]

{"sheet":"Checklist","index":16,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[[3,8,4,8],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,4,6],[3,7,4,7],[6,7,7,7],[6,8,7,8],[8,0,9,6],[8,7,9,7],[8,8,9,8],[10,0,10,6],[11,0,11,6],[12,0,12,6],[5,0,5,6],[6,0,7,6]]}
["CESA Check-list:",null,null,null,null,null,null,"Completed by:","Notes"]
["Needed documents accounted for"]
["If COMcheck is used, is it 2015 IECC"]
["If COMcheck is not used, a professional lighting layout with spec sheets showing quantity and input wattage. "]
[]
["Building plan included that has the layout and/or square footage"]
["Building square footage verified and noted.  Please say where in the notes section to the right.  EX - Ltg Plan or Bldg Plan"]
[]
["All sections of the application filled in, including utility account numbers"]
[]
["Extra items, if any (exterior lighting) added to the incentive calc tab"]

{"sheet":"Submittal Requirements_Final","index":17,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Submittal Requirements"]
["Type","Best Practice","Required Documentation"]
["Envelope:"]
["Glazing",{"$f":"IFERROR(VLOOKUP('Building Envelope'!B4,'Submittal Requirements'!$E$1:$F$11,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B4,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Roof Insulation",{"$f":"IFERROR(VLOOKUP('Building Envelope'!B6,'Submittal Requirements'!$E$1:$F$11,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B5,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Wall Insulation",{"$f":"IFERROR(VLOOKUP('Building Envelope'!B5,'Submittal Requirements'!$E$1:$F$11,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Air Infiltration",{"$f":"IFERROR(VLOOKUP('Building Envelope'!B7,'Submittal Requirements'!$E$1:$F$11,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B7,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B8,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Lighting:",null,{"$f":"IFERROR(VLOOKUP(B9,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Lighting Power Density",{"$f":"'Interior Lighting'!B19","v":0},{"$f":"IF(B10<0.1,\"None\",(IFERROR(VLOOKUP(A10,'Submittal Requirements'!$E:$G,3,FALSE),\"\")))","v":"None"}]
["Common Area Occupancy Sensors",{"$f":"'Interior Lighting'!B12","v":0},{"$f":"IFERROR(VLOOKUP(B11,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B12,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["HVAC:",null,{"$f":"IFERROR(VLOOKUP(B13,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!A4,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!A4,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A4,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!A4,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!A4, 'Building Details'!$B$9=\"Other\",Other!A4)","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!B4,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!B4,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B4,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!B4,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!B4, 'Building Details'!$B$9=\"Other\",Other!B4),\"N/A\")","v":"N/A"},{"$f":"IFERROR(VLOOKUP(B14,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":"None"}]
[{"$f":"_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!A5,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!A5,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A5,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!A5,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!A5, 'Building Details'!$B$9=\"Other\",\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!B5,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!B5,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B5,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!B5,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!B5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!A6,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!A6,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A6,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!A6,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!A6, 'Building Details'!$B$9=\"Other\",\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!B6,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!B6,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B6,'Building Details'!$B$9=\"Variable Refrigerant Flow\",'Variable Refrigerant Flow'!B6,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!B6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!A7,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!A7,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A7,'Building Details'!$B$9=\"Variable Refrigerant Flow\",\" \",'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!A7, 'Building Details'!$B$9=\"Other\",\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!B7,'Building Details'!$B$9=\"Air Source Heat Pump\",'Air Source Heat Pump'!B7,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B7,,,'Building Details'!$B$9=\"Ground Source Heat Pump\",'Ground Source Heat Pump'!B7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!A8,'Building Details'!$B$9=\"Air Source Heat Pump\",\"\",'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A8,'Building Details'!$B$9=\"Variable Refrigerant Flow\",\" \",'Building Details'!$B$9=\"Ground Source Heat Pump\",\"\", 'Building Details'!$B$9=\"Other\",\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(_xlfn.IFS('Building Details'!$B$9=\"DX Cooling and Gas Furnace\",'DX_gas furnace'!B8,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B8),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(_xlfn.IFS(,,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A9),\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(,,,,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B9),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(_xlfn.IFS(,,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!A10),\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(,,,,'Building Details'!$B$9=\"Water Source Heat Pump\",'Water Source Heat Pump'!B10),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Service Water Heating:",null,{"$f":"IFERROR(VLOOKUP(B21,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Service Water Heating",{"$f":"'Service Water Heating'!B4","v":0},{"$f":"IFERROR(VLOOKUP(B22,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B23,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Fixtures:",null,{"$f":"IFERROR(VLOOKUP(B24,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Clothes Washer",{"$f":"'Fixtures_plug loads'!B5","v":0},{"$f":"IFERROR(VLOOKUP(B25,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Dishwasher",{"$f":"'Fixtures_plug loads'!B6","v":0},{"$f":"IFERROR(VLOOKUP(B26,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Refrigerator",{"$f":"'Fixtures_plug loads'!B7","v":0},{"$f":"IFERROR(VLOOKUP(B27,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Showerheads",{"$f":"'Fixtures_plug loads'!B8","v":0},{"$f":"IFERROR(VLOOKUP(B28,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B29,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Garage:",null,{"$f":"IFERROR(VLOOKUP(B30,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]
["Garage Ventilation",{"$f":"IF('Building Details'!B3=\"multifamily with conditioned garage\",Garage!B5,\"N/A\")","v":"N/A"},{"$f":"IFERROR(VLOOKUP(B31,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":"None"}]
["Garage Conditioning",{"$f":"IF('Building Details'!B3=\"multifamily with conditioned garage\",Garage!B6,\"N/A\")","v":"N/A"},{"$f":"IFERROR(VLOOKUP(B32,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":"None"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B33,'Submittal Requirements'!$E:$G,3,FALSE),\"\")","v":""}]

{"sheet":"Submittal Requirements","index":18,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Envelope:",null,null,null,"Improved Glazing: unit > 0.38 to ≤ 0.42 and center of glass > 0.25 to ≤ 0.30","Glazing cut sheets showing the U-value (unit > 0.38 to ≤ 0.42 and center of glass> 0.25 to ≤ 0.30), solar heat gain coefficient, and visible light transmittance value","Cut sheets showing U-value, solar heat gain coefficient, and visible light transmittance value"]
[null,null,null,null,"Improved Glazing w/ argon: unit > 0.28 to ≤ 0.38 and center of glass ≤ 0.25","Glazing cut sheets showing the U-value (unit > 0.28 to ≤ 0.38 and center of glass ≤ 0.25), solar heat gain coefficient, and visible light transmittance value","Cut sheets showing U-value, solar heat gain coefficient, and visible light transmittance value"]
[null,null,null,null,"Improved Glazing w/ argon; non-metal frame: unit ≤ 0.28 and center of glass ≤ 0.25","Glazing cut sheets showing the U-value (unit ≤ 0.28 and center of glass ≤ 0.25), solar heat gain coefficient, and visible light transmittance value","Cut sheets showing U-value, solar heat gain coefficient, and visible light transmittance value"]
[null,null,null,null,"No Glazing",null,"None"]
[null,null,null,null,"Insulation values < R-24 with thermal bridging",null,"None"]
[null,null,null,null,"Insulation values ≥ R-24 with thermal bridging","Wall insulation cut sheets showing R-value ≥ 24. Also include typical exterior wall section showing the installed material types, dimensions, and layering scheme within the assembly.","1. Cut sheets showing R-value ≥ 24.  \n2. Documentation showing exterior wall section installed material types, dimensions, and layering scheme within the assembly."]
[null,null,null,null,"Insulation values < R-24",null,"None"]
[null,null,null,null,"Insulation values ≥ R-24 and < R-29","Roof insulation cut sheets showing R-value ≥ 24. Include a roof insulation plan, section, and shop drawings showing the installed material types, dimensions, and layering scheme within the assembly.","1. Insulation cut sheets.\n2. Roof insulation plan, section, and shop drawings showing the installed material types, dimensions, and layering scheme within the assembly."]
[null,null,null,null,"Insulation values ≥ R-30","Roof insulation cut sheets showing R-value ≥ 30. Include a roof insulation plan, section, and shop drawings showing the installed material types, dimensions, and layering scheme within the assembly.","1. Insulation cut sheets.\n2. Roof insulation plan, section, and shop drawings showing the installed material types, dimensions, and layering scheme within the assembly."]
[null,null,null,null,"No reduction in air infiltration",null,"None"]
[null,null,null,null,"≤ 2.4 air changes per hour (ACH) at 50 pascals (blower door test)","Signed blower door test reports with ≤ 2.4 air changes per hour (ACH) at 50 pascals for a representative sample of units (common areas not needed)","Signed blower door test reports with ≤ 2.4 air changes per hour (ACH) at 50 pascals for a representative sample of units (common areas not needed)"]
["Lighting:",null,null,null,"Lighting Power Density","Documentation to verify square footage as-built (COMcheck or professional floorplan with dimensions). Include documentation to verify total connected wattage as-built (COMcheck or professional lighting layout indicating where fixtures are installed PLUS fixture cut sheets for all installed fixtures, lamps and ballasts showing quantity and input wattage).","1. Documentation to verify square footage as-built.  Acceptable documentation includes:\n      A. COMcheck\n      B. Professional floorplan with dimensions\n2. Documentation to verify total proposed wattage.  Acceptable documentation includes:\n      A. COMcheck\n      B. Professional lighting layout with installed fixture location AND cut sheets for installed fixtures, lamps and ballasts showing quantity and input wattage."]
[null,null,null,null,"No",null,"None"]
[null,null,null,null,"Yes","Cut sheets for photo-sensors, occupancy sensors and other lighting control equipment installed in common areas (corridors, lobby, fitness room). Include the most recent revision of the electrical plans and schedules that show the location of lighting control sensors.","1. Cut sheets for photo-sensors, occupancy sensors and other lighting control equipment installed in common areas.\n2. Most recent electrical plans and schedules showing the location of lighting control sensors."]
["HVAC:",null,null,null,"Mid-efficiency ASHP Cooling","Air source heat pump cooling equipment cut sheets showing unit size and AHRI-rating (SEER Rated Units > 16.0 to 17.0 SEER,  EER Rated Units (except packaged terminal units) > 12.0 to < 13.0 EER, PTAC/PTHP > 13.1 to < 14.3 EER, VTAC/SPVAC > 11.0 to < 12.0 EER)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"High-efficiency ASHP Cooling","Air source heat pump cooling equipment cut sheets showing unit size and AHRI-rating (SEER Rated Units > 17.0 to 18.0 SEER,  EER Rated Units (except packaged terminal units) > 13.0 to < 14.0 EER, PTAC/PTHP > 14.3 to < 15.5 EER, VTAC/SPVAC > 12.0 to < 13.0 EER)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"Premium-efficiency ASHP Cooling","Air source heat pump cooling equipment cut sheets showing unit size and AHRI-rating (SEER Rated Units ≥ 18.0 SEER,  EER Rated Units (except packaged terminal units) ≥ 14.0 EER, PTAC/PTHP ≥ 15.5 EER, VTAC/SPVAC ≥ 13.0 EER)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"Mid-efficiency ASHP Heating","Air source heat pump heating equipment cut sheets showing unit size and AHRI-rating (COP Units (except packaged terminal units) > 3.6 to < 4.0 COP, PTHP > 3.0 to < 3.3 COP, SPVHP > 3.3 to < 3.6 COP, HSPF Units > 8.5 to < 9.2 HSPF)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"High-efficiency ASHP Heating","Air source heat pump heating equipment cut sheets showing unit size and AHRI-rating (COP Units (except packaged terminal units) > 4.0 to < 4.3 COP, PTHP > 3.3 to < 3.5 COP, SPVHP > 3.6 to < 3.9 COP, HSPF Units > 8.5 to < 9.2 HSPF)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"Premium-efficiency ASHP Heating","Air source heat pump heating equipment cut sheets showing unit size and AHRI-rating (COP Units (except packaged terminal units) ≥ 4.3 COP, PTHP ≥ 3.3 COP, SPVHP ≥ 3.9 COP, HSPF Units ≥ 10.0 HSPF)","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 14.3 to < 15.6 EER","Water source heat pump cooling equipment cut sheets showing unit size and AHRI-rating > 14.3 to < 15.6 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 15.6 to < 16.9 EER","Water source heat pump cooling equipment cut sheets showing unit size and AHRI-rating > 15.6 to < 16.9 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 16.9 EER","Water source heat pump cooling equipment cut sheets showing unit size and AHRI-rating ≥ 16.9 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating < 14.3 EER",null,"None"]
[null,null,null,null,"AHRI Rating < 4.7 COP",null,"None"]
[null,null,null,null,"AHRI-rating ≥ 4.7 to < 5.2 COP","Water source heat pump heating equipment cut sheets showing unit size and AHRI-rating > 4.7 to < 5.2 COP","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 5.2 to < 5.6 COP","Water source heat pump heating equipment cut sheets showing unit size and AHRI-rating > 5.2 to < 5.6 COP","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 5.6 COP","Water source heat pump heating equipment cut sheets showing unit size and AHRI-rating ≥ 5.6 COP","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 19.8 to < 21.6 EER","Ground source heat pump cooling equipment cut sheets showing unit size and AHRI-rating > 19.8 to < 21.6 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 21.6 to < 23.4 EER","Ground source heat pump cooling equipment cut sheets showing unit size and AHRI-rating > 21.6 to < 23.4 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 23.4 EER","Ground source heat pump cooling equipment cut sheets showing unit size and AHRI-rating ≥ 23.4 EER","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 4.1 to < 4.4 COP","Ground source heat pump heating equipment cut sheets showing unit size and AHRI-rating > 4.1 to < 4.4 COP","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"AHRI-rating ≥ 4.4 to < 4.8 COP","Ground source heat pump heating equipment cut sheets showing unit size and AHRI-rating > 4.4 to < 4.8 COP","Equipment cut sheets showing unit size and AHRI-rating ","Smart Thermostat in unit"]
[null,null,null,null,"AHRI-rating ≥ 4.8 COP","Ground source heat pump heating equipment cut sheets showing unit size and AHRI-rating ≥ 4.8 COP","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"Mid-efficiency DX Cooling","DX cooling equipment cut sheets showing unit size and AHRI-rating (SEER Units > 16.0 to < 17.0 SEER, EER Units > 12.0 to < 13.0 EER, PTAC/PTHP > 13.1 to < 14.3 EER, VTAC/SPVAC > 11.0 to < 12.0 EER).","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"High-efficiency DX Cooling","DX cooling equipment cut sheets showing unit size and AHRI-rating (SEER Units > 17.0 to < 18.0 SEER, EER Units > 13.0 to < 14.0 EER, PTAC/PTHP > 14.3 to < 15.5 EER, VTAC/SPVAC > 12.0 to < 13.0 EER).","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"Premium-efficiency DX Cooling","DX cooling equipment cut sheets showing unit size and AHRI-rating (SEER Units ≥ 18.0 SEER, EER Units ≥ 14.0 EER, PTAC/PTHP ≥ 15.5 EER, VTAC/SPVAC≥ 13.0 EER).","Equipment cut sheets showing unit size and AHRI-rating "]
[null,null,null,null,"VRF Installation","Cut sheets with VRF system details","Cut sheets with VRF system details"]
[null,null,null,null,"< 95% efficient gas furnace",null,"None"]
[null,null,null,null,"≥ 95% efficient gas furnace","Furnace cut sheets showing rated thermal efficiency ≥ 95%","Equipment cut sheets showing rated thermal efficiency","Reference: Applies to Common Areas, expect projects that are modelled using larger RTUs to not achieve this metric. Accounts for 2% of model savings."]
[null,null,null,null,"Non-Condensing water loop gas boiler",null,"None"]
[null,null,null,null,"Does not meet efficiency requirements",null,"None"]
[null,null,null,null,"Condensing water loop gas boiler",null,"None"]
[null,null,null,null,"≥ 95% efficient water loop gas boiler","Boiler cut sheets showing rated thermal efficiency ≥ 95%","Equipment cut sheets showing rated thermal efficiency"]
[null,null,null,null,"No VFD",null,"None"]
[null,null,null,null,"VFD on water source heat pump circulator pump","Mechanical controls submittal showing sequences associated with VFD control on water source heat pump circulating pump","Mechanical controls submittal showing sequences associated with VFD control on water source heat pump circulating pump"]
[null,null,null,null,"AHRI-rating < 19.8 EER",null,"None"]
[null,null,null,null,"AHRI-rating < 4.1 COP",null,"None"]
[null,null,null,null,"VFD on cooling tower fan","Mechanical controls submittal showing sequences associated with VFD control on cooling tower fan","Mechanical controls submittal showing sequences associated with VFD control on cooling tower fan"]
[null,null,null,null,"IEER < 3 above EER",null,"None"]
[null,null,null,null,"IEER 3 to 5 above EER or digital scroll compressor","DX cooling equipment cut sheets showing unit size and AHRI rated IEER","Equipment cut sheets showing unit size and AHRI rated IEER"]
[null,null,null,null,"IEER > 5 or more above EER","DX cooling equipment cut sheets showing unit size and AHRI rated IEER","Equipment cut sheets showing unit size and AHRI rated IEER"]
[null,null,null,null,"No heat recovery",null,"None"]
[null,null,null,null,"Total Heat Recovery","Shop drawings stating sensible and latent effectiveness","Shop drawings stating sensible and latent effectiveness","Will use effectiveness on shop drawing to use in model to determine savings - let's discuss how to 'give credit for this one' with Alex/Adam"]
[null,null,null,null,"Non-Programmable Thermostat",null,"None"]
[null,null,null,null,"Programmable Thermostat","Thermostat cut sheets showing programmable capabilities and locations installed","1. Equipment cut sheets showing capabilities\n2. Floor plan identifying locations installed"]
[null,null,null,null,"Smart thermostat","Thermostat cut sheets showing smart capabilities and locations installed","1. Equipment cut sheets showing capabilities\n2. Floor plan identifying locations installed","Uncertain if savings for Smart thermostats will be available in NEO immediately, but would not hurt savings/incentive ratio as it would be a more stringent requirement"]
["Service water heating:",null,null,null,"90 to 95% SWH Efficiency","Service water heater cut sheets showing rated thermal efficiency ≥ 90% to < 95%","Equipment cut sheets showing rated thermal efficiency"]
[null,null,null,null,"< 90% SWH Efficiency",null,"None"]
[null,null,null,null,"≥ 95% SWH Efficiency","Service water heater cut sheets showing rated thermal efficiency ≥ 95%","Equipment cut sheets showing rated thermal efficiency"]
["Fixtures/Plug loads:",null,null,null,"ENERGY STAR Clothes Washer","Clothes washer cut sheet including make and model number","Equipment cut sheet showing make and model number"]
[null,null,null,null,"ENERGY STAR Dishwasher","Dishwasher cut sheet including make and model number","Equipment cut sheet showing make and model number"]
[null,null,null,null,"ENERGY STAR Refrigerator","Refrigerator cut sheet including make and model number","Equipment cut sheet showing make and model number"]
[null,null,null,null,"Non-Energy Star",null,"None"]
[null,null,null,null,"Showerheads > 2.0 GPM flow",null,"None"]
[null,null,null,null,"Low Flow Showerheads ≤ 2.0 GPM","Showerhead cutsheets showing flow ratings ≤ 2.0 GPM","Product cut sheet showing flow ratings"]
["Garage:",null,null,null,"CO sensor control of ventilation (Garage only)","Mechanical controls submittal showing sequences associated with CO control of garage ventilation","Mechanical controls submittal showing sequences associated with CO control of garage ventilation","Reference: CO system must control more than 50% of the garage ventilation, 50% is code minimum"]
[null,null,null,null,"N/A",null,"None"]
[null,null,null,null,"No Controls",null,"None"]
[null,null,null,null,"Indirect-fired furnace/unit heater",null,"None"]
[null,null,null,null,"Direct-fired furnace/unit heater","Furnace cut sheet showing direct-fired technology","Equipment cut sheet showing direct-fired technology"]