{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Option 1","Option 2","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":false,"merged":[[26,4,26,6],[18,4,18,6],[14,4,14,6],[22,4,22,6],[2,4,2,6],[5,4,5,6],[10,4,10,6],[6,4,6,6]]}
[]
[]
[null,null,null,null,"Minimum Energy Performance Retail Calculator\nLEED v4 EA Prerequisite Minimum Energy Performance and EA Credit Optimize Energy Performance, Option 1 and Option 2"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros."]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Unit of measurement",null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"For projects attempting Option 1. Whole-Building Energy Simulation"]
[null,null,null,null,"Complete the Option 1 tab for all retail equipment in the project. "]
[]
[]
[null,null,null,null,"For projects attempting Option 2. Prescriptive Compliance Path"]
[null,null,null,null,"Complete the Option 2 tab for all retail equipment in the project."]
[]
[null,null,null,null,"Step 4."]
[null,null,null,null,"For projects attempting Option 1. Whole-Building Energy Simulation"]
[null,null,null,null,"All savings for retail equipment must be taken via an Exceptional Calculation Method (ECM) in the Minimum Energy Performance Calculator. Refer to the LEED Reference Guide and the Minimum Energy Performance Calculator for additional information. Upload the completed spreadsheet to LEED Online as well as all supporting documentation. "]
[]
[]
[null,null,null,null,"For projects attempting Option 2. Prescriptive Compliance Path"]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[null,null,null,null,null,null,null,null,null,"UOM"]
[null,null,null,null,null,null,null,"V01",null,{"$f":"IF(G10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,null,"Copyright © 2012"]
[null,null,null,null,null,null,null,"U.S. Green Building Council",null,"Kitchen Appliance Type",null,"Kitchen Appliance Type",null,null,"Convert to Mbtu\n(IP)","Convert to MJ\n(SI)"]
[null,null,null,null,null,null,null,"All Rights Reserved",null,"Broiler, underfired - Gas",null,{"$f":"J33","v":"Broiler, underfired - Gas"},null,"kWh",3.4120000000000001E-3,{"$f":"O33*1055.056","v":3.5998510720000003}]
[null,null,null,null,null,null,null,null,null,"Combination ovens, steam mode - Electric or Gas",null,{"$f":"J34","v":"Combination ovens, steam mode - Electric or Gas"},null,"MWh",3.4119999999999999,{"$f":"O34*1055.056","v":3599.8510719999999}]
[null,null,null,null,null,null,null,null,null,"Combination ovens, convection mode - Electric or Gas",null,{"$f":"J35","v":"Combination ovens, convection mode - Electric or Gas"},null,"kBtu",1E-3,1.055056]
[null,null,null,null,null,null,null,null,null,"Convection oven, full-size - Electric or Gas",null,{"$f":"J36","v":"Convection oven, full-size - Electric or Gas"},null,"therm",0.1,105.50560000000002]
[null,null,null,null,null,null,null,null,null,"Convection oven, half-size - Electric",null,{"$f":"J37","v":"Convection oven, half-size - Electric"},null,"MBtu",1,1055.056]
[null,null,null,null,null,null,null,null,null,"Conveyor oven, > 25 inch belt - Gas",null,"Conveyor oven, > 63.5 cm belt - Gas",null,"MJ",9.4799999999999995E-4,1]
[null,null,null,null,null,null,null,null,null,"Conveyor oven, ≤ 25 inch belt - Gas",null,"Conveyor oven, < 63.5 cm belt - Gas",null,"Ton hours",1.2E-2,12.660672]
[null,null,null,null,null,null,null,null,null,"Fryer - Electric or Gas",null,{"$f":"J40","v":"Fryer - Electric or Gas"}]
[null,null,null,null,null,null,null,null,null,"Griddle (based on 3 ft model) - Electric or Gas",null,"Griddle (based on 90 cm model) - Electric"]
[null,null,null,null,null,null,null,null,null,"Hot food holding cabinets (excluding drawer warmers and heated display),  0 < V < 13 cu ft - Electric",null,"Hot food holding cabinets (excluding drawer warmers and heated display) 0 < V < 0.368 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Hot food holding cabinets (excluding drawer warmers and heated display), 13 ≤ V < 28 cu ft - Electric",null,"Hot food holding cabinets (excluding drawer warmers and heated display), 0.368 ≤ V < 0.793 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Hot food holding cabinets (excluding drawer warmers and heated display), 28 cu ft ≤ V - Electric",null,"Hot food holding cabinets (excluding drawer warmers and heated display), 0.793 cu m  ≤ V - Electric"]
[null,null,null,null,null,null,null,null,null,"Large vat fryer - Electric or Gas",null,{"$f":"J45","v":"Large vat fryer - Electric or Gas"}]
[null,null,null,null,null,null,null,null,null,"Rack oven, double - Gas",null,"Rack oven, double - Gas"]
[null,null,null,null,null,null,null,null,null,"Rack oven, single - Gas",null,"Rack oven, single - Gas"]
[null,null,null,null,null,null,null,null,null,"Range - Electric or Gas",null,"Range - Electric or Gas"]
[null,null,null,null,null,null,null,null,null,"Steam cooker, batch cooking - Electric or Gas",null,"Steam cooker, batch cooking - Electric or Gas"]
[null,null,null,null,null,null,null,null,null,"Steam cooker, high production or cook to order - Electric or Gas",null,"Steam cooker, high production or cook to order - Electric or Gas"]
[null,null,null,null,null,null,null,null,null,"Toaster - Electric",null,"Toaster - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, IMH (ice-making head, H = ice harvest), H > 450 lb/day - Electric",null,"Ice machine, IMH (ice making head, H = ice harvest) H ≥ 204 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, IMH (ice-making head), H < 450 lb/day - Electric",null,"Ice machine, IMH (ice making head), H < 204 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, RCU (remote condensing unit, w/o remote compressor, H < 1,000 lb/day - Electric",null,"Ice machine, RCU  (remote condensing unit, w/o remote compressor) H < 454 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, RCU (remote condensing unit), 1600 > H > 1000 lb/day - Electric",null,"Ice machine, RCU (remote condensing unit) 726 > H ≥ 454 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, RCU (remote condensing unit),   H ≥ 1600 lb/day - Electric",null,"Ice machine, RCU (remote condensing unit),   H > 726kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, SCU (self-contained unit), H < 175 lb/day - Electric",null,"Ice machine, SCU (self contained unit), H < 79 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine self-contained unit, H > 175 lb/day - Electric",null,"Ice machine, SCU (self contained unit), H ≥ 79 kg/day - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled ice-making head, H > 1436 lb/day (must be on chilled loop) - Electric",null,"Ice machine, water-cooled ice-making head,  H ≥ 651 kg/day(must be on a chilled loop) - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled ice-making head, 500 lb/day < H < 1436 (must be on chilled loop) - Electric",null,"Ice machine, water-cooled ice-making head,  227 ≤ H < 651 kg/day (must be on a chilled loop) - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled ice-making head, H < 500 lb/day (must be on chilled loop) - Electric",null,"Ice machine, water-cooled ice-making head, H < 227 kg/day( must be on a chilled loop) - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled once-through (open loop) - Electric",null,{"$f":"J62","v":"Ice machine, water-cooled once-through (open loop) - Electric"}]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled SCU (self-contained unit), H < 200 lb/day (must be on chilled loop) - Electric",null,"Ice machine, water cooled SCU (self-contained unit) H < 91 kg/day (must be on a chilled loop) - Electric"]
[null,null,null,null,null,null,null,null,null,"Ice machine, water-cooled self-contained unit, H > 200 lb/day (must be on chilled loop) - Electric",null,"Ice machine, water cooled SCU (self-contained unit) H > 91 kg/day (must be on a chilled loop) - Electric"]
[null,null,null,null,null,null,null,null,null,"Chest freezer, solid or glass door - Electric",null,{"$f":"J65","v":"Chest freezer, solid or glass door - Electric"}]
[null,null,null,null,null,null,null,null,null,"Chest refrigerator, solid or glass door - Electric",null,{"$f":"J66","v":"Chest refrigerator, solid or glass door - Electric"}]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in freezer, 0 < V < 15 cu ft - Electric",null,"Glass-door reach-in freezer, 0 < V < 0.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in freezer, 15 ≤ V < 30 cu ft - Electric",null,"Glass-door reach-in freezer, 0.42 ≤ V < 0.85 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in freezer, 30 ≤ V < 50 cu ft - Electric",null,"Glass-door reach-in freezer, 0.85 ≤ V < 1.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in freezer, 50 ≤ V cu ft - Electric",null,"Glass-door reach-in freezer, 1.42 ≤ V cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in refrigerator,  0 < V < 15 cu ft - Electric",null,"Glass-door reach-in refrigerator, 0 < V < 0.42cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in refrigerator, 15 ≤ V < 30 cu ft - Electric",null,"Glass-door reach-in refrigerator, 0.42 ≤ V < 0.85 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in refrigerator, 30 ≤ V < 50 cu ft - Electric",null,"Glass-door reach-in refrigerator, 0.85 ≤ V < 1.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Glass-door reach-in refrigerator, 50 ≤ V cu ft - Electric",null,"Glass-door reach-in refrigerator, 1.42 ≤ V cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in freezer, 0 < V < 15 cu ft - Electric",null,"Solid-door reach-in freezer, 0 < V < 0.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in freezer, 15 ≤ V < 30 cu ft - Electric",null,"Solid-door reach-in freezer, 0.42 ≤ V < 0.85 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in freezer, 30 ≤ V < 50 cu ft - Electric",null,"Solid-door reach-in freezer, 0.85 ≤ V < 1.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in freezer, 50 ≤ V cu ft - Electric",null,"Solid-door reach-in freezer, 1.42 ≤ V cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in refrigerator, 0 < V < 15 cu ft - Electric",null,"Solid-door reach-in refrigerator, 0 < V < 0.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in refrigerator, 15 ≤ V < 30 cu ft - Electric",null,"Solid-door reach-in refrigerator, 0.42 ≤ V < 0.85 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in refrigerator, 30 ≤ V < 50 cu ft - Electric",null,"Solid-door reach-in refrigerator, 0.85 ≤ V < 1.42 cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Solid-door reach-in refrigerator, 50 ≤ V cu ft - Electric",null,"Solid-door reach-in refrigerator, 1.42 ≤ V cu m - Electric"]
[null,null,null,null,null,null,null,null,null,"Clothes washer - Gas",null,{"$f":"J83","v":"Clothes washer - Gas"}]
[null,null,null,null,null,null,null,null,null,"Door-type dish machine, high temp - Electric",null,"Door-type dish machine, high temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Door-type dish machine, low temp - Electric",null,"Door-type dish machine, low temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Multitank rack conveyor dish machine, high temp - Electric",null,"Multitank rack conveyor dish machine, high temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Multitank rack conveyor dish machine, low temp - Electric",null,"Multitank rack conveyor dish machine, low temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Single-tank rack conveyor dish machine, high temp - Electric",null,"Single-tank rack conveyor dish machine, high temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Single-tank rack conveyor dish machine, low temp - Electric",null,"Single-tank rack conveyor dish machine, low temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Undercounter dish machine, high temp - Electric",null,"Undercounter dish machine, high temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Undercounter dish machine, low temp - Electric",null,"Undercounter dish machine, low temp - Electric"]
[null,null,null,null,null,null,null,null,null,"Nondefault: Table 2 - Supermarket refrigeration (specify)",null,"Nondefault: Table 2 - Supermarket refrigeration (specify)"]
[null,null,null,null,null,null,null,null,null,"Nondefault: Table 3 - Walk-in coolers and freezers (specify)",null,"Nondefault: Table 3 - Walk-in coolers and freezers (specify)"]
[null,null,null,null,null,null,null,null,null,"Nondefault: Table 4 - Commercial kitchen ventilation (specify)",null,"Nondefault: Table 4 - Commercial kitchen ventilation (specify)"]

{"sheet":"Option 1","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,1,31,4],[32,1,32,4],[5,1,5,7],[18,1,18,4],[19,1,19,4],[20,1,20,4],[25,1,25,4],[24,1,24,4],[30,1,30,4],[17,1,17,7],[23,1,23,7],[29,1,29,7],[26,1,26,4]]}
[]
[null,"Option 1. Whole-Building Energy Simulation"]
[]
[]
[null,"Commercial Kitchen Appliances"]
[null,"Complete the table with the proposed and baseline energy consumption derived from the Food Service Technology Center's life cycle cost calculators. Note: Provide copies of the calculator(s) outputs in the LEED credit form."]
[null,"Commerical Kitchen Appliance Type","Quantity","Unit of Measurement","Baseline\nAnnual Consumption","Proposed\nAnnual Consumption",{"$f":"CONCATENATE(\"Total \nBaseline\nAnnual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total \nBaseline\nAnnual Consumption\n(MBtu)"},{"$f":"CONCATENATE(\"Total \nProposed\nAnnual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total \nProposed\nAnnual Consumption\n(MBtu)"}]
[{"$f":"IF(C8>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR((E8*IF(UOM=1,VLOOKUP(D8,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D8,Instructions!$N$33:$P$39,3,FALSE)))*C8,0)","v":0},{"$f":"IFERROR((F8*IF(UOM=1,VLOOKUP(D8,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D8,Instructions!$N$33:$P$39,3,FALSE)))*C8,0)","v":0}]
[0,null,null,null,null,null,{"$f":"IFERROR((E9*IF(UOM=1,VLOOKUP(D9,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D9,Instructions!$N$33:$P$39,3,FALSE)))*C9,0)","v":0},{"$f":"IFERROR((F9*IF(UOM=1,VLOOKUP(D9,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D9,Instructions!$N$33:$P$39,3,FALSE)))*C9,0)","v":0}]
[{"$f":"IF(C10>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR((E10*IF(UOM=1,VLOOKUP(D10,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D10,Instructions!$N$33:$P$39,3,FALSE)))*C10,0)","v":0},{"$f":"IFERROR((F10*IF(UOM=1,VLOOKUP(D10,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D10,Instructions!$N$33:$P$39,3,FALSE)))*C10,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR((E11*IF(UOM=1,VLOOKUP(D11,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D11,Instructions!$N$33:$P$39,3,FALSE)))*C11,0)","v":0},{"$f":"IFERROR((F11*IF(UOM=1,VLOOKUP(D11,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D11,Instructions!$N$33:$P$39,3,FALSE)))*C11,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR((E12*IF(UOM=1,VLOOKUP(D12,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D12,Instructions!$N$33:$P$39,3,FALSE)))*C12,0)","v":0},{"$f":"IFERROR((F12*IF(UOM=1,VLOOKUP(D12,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(D12,Instructions!$N$33:$P$39,3,FALSE)))*C12,0)","v":0}]
["A",{"$f":"CONCATENATE(\"Totals \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Totals (MBtu)"},null,null,null,null,{"$f":"SUM(G8:G12)","v":0},{"$f":"SUM(H8:H12)","v":0}]
[null,"A"]
[]
[]
[null,"Supermarket Refrigeration"]
[null,"Complete the table with proposed and baseline energy consumption. A narrative describing all proposed and baseline assumptions as well as the calculation methodology used must be provided as backup documentation. Addendum g to ASHRAE 90.1-2010 may be used for the baseline energy consumption. Any other baseline claimed which is less stringent than this addendum must be justfied by providing a recently published document (published within five years of the project registration date), an existing utility program that incentivizes the equipment installed, or by documenting systems used to perform the same function in other newly constructed facilities (three facilities built within the past five years of the project registration date)."]
[null,"Total Supermarket Refrigeration Energy Consumption",null,null,null,"Unit of Measurement","Annual Consumption",{"$f":"CONCATENATE(\"Annual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Annual Consumption\n(MBtu)"}]
[{"$f":"IF(C20>=0,0,0)","v":0},"Baseline",null,null,null,null,null,{"$f":"IFERROR(G20*IF(UOM=1,VLOOKUP(F20,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F20,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]
[0,"Proposed",null,null,null,null,null,{"$f":"IFERROR(G21*IF(UOM=1,VLOOKUP(F21,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F21,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]
[]
[null,"Walk-In Coolers and Freezers"]
[null,"Complete the table with proposed and baseline energy consumption. A narrative describing all proposed and baseline assumptions as well as the calculation methodology used must be provided as backup documentation. The baseline utilized must be justfied by providing a recently published document (published within five years of the project registration date), an existing utility program that incentivizes the equipment installed, or by documenting systems used to perform the same function in other newly constructed facilities (three facilities built within the past five years of the project registration date)."]
[null,"Total Walk-In Cooler and Freezer Energy Consumption",null,null,null,"Unit of Measurement","Annual Consumption",{"$f":"CONCATENATE(\"Annual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Annual Consumption\n(MBtu)"}]
[{"$f":"IF(C26>=0,0,0)","v":0},"Baseline",null,null,null,null,null,{"$f":"IFERROR(G26*IF(UOM=1,VLOOKUP(F26,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F26,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]
[0,"Proposed",null,null,null,null,null,{"$f":"IFERROR(G27*IF(UOM=1,VLOOKUP(F27,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F27,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]
[]
[null,"Commercial Kitchen Ventilation"]
[null,"Complete the table with proposed and baseline energy consumption. A narrative describing all proposed and baseline assumptions as well as the calculation methodology used must be provided as backup documentation. Section 6.5.7.1 Kitchen Exhaust Systems of ASHRAE 90.1-2010 may be used for the baseline assumptions. Any other baseline claimed which is less stringent than this addendum must be justfied by providing a recently published document (published within five years of the project registration date), an existing utility program that incentivizes the equipment installed, or by documenting systems used to perform the same function in other newly constructed facilities (three facilities built within the past five years of the project registration date)."]
[null,"Total Commercial Kitchen Ventilation Energy Consumption",null,null,null,"Unit of Measurement","Annual Consumption",{"$f":"CONCATENATE(\"Annual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Annual Consumption\n(MBtu)"}]
[{"$f":"IF(C32>=0,0,0)","v":0},"Baseline",null,null,null,null,null,{"$f":"IFERROR(G32*IF(UOM=1,VLOOKUP(F32,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F32,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]
[0,"Proposed",null,null,null,null,null,{"$f":"IFERROR(G33*IF(UOM=1,VLOOKUP(F33,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(F33,Instructions!$N$33:$P$39,3,FALSE)),0)","v":0}]

{"sheet":"Option 2","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,1,5,6],[17,1,17,4]]}
[]
[null,"Option 2. Prescriptive Compliance Path"]
[]
[]
[null,"Appendix 3, All Equipment"]
[null,"Complete the table with the proposed and baseline energy consumption derived from the Food Service Technology Center's life cycle cost calculators, ENERGY STAR calculators, or user-generated calculators. Provide copies of the calculator(s) outputs in the LEED credit form (optional if 100% of installed equipment is compliant with the prescriptive requirements).  \n\nIf total energy consumption cannot be calculated for items in Tables 2-4, use the default method (below) for those items."]
[null,"Appliance Type","Compliant with prescriptive requirements?","Quantity","Unit of Measurement","Annual Consumption",{"$f":"CONCATENATE(\"Total \nAnnual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total \nAnnual Consumption\n(MBtu)"}]
[{"$f":"IF(D8>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR((F8*IF(UOM=1,VLOOKUP(E8,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(E8,Instructions!$N$33:$P$39,3,FALSE)))*D8,0)","v":0}]
[{"$f":"IF(D9>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR((F9*IF(UOM=1,VLOOKUP(E9,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(E9,Instructions!$N$33:$P$39,3,FALSE)))*D9,0)","v":0}]
[{"$f":"IF(D10>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR((F10*IF(UOM=1,VLOOKUP(E10,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(E10,Instructions!$N$33:$P$39,3,FALSE)))*D10,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR((F11*IF(UOM=1,VLOOKUP(E11,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(E11,Instructions!$N$33:$P$39,3,FALSE)))*D11,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR((F12*IF(UOM=1,VLOOKUP(E12,Instructions!$N$33:$P$39,2,FALSE),VLOOKUP(E12,Instructions!$N$33:$P$39,3,FALSE)))*D12,0)","v":0}]
["A",{"$f":"CONCATENATE(\"Total calculated annual consumption \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total calculated annual consumption (MBtu)"},null,null,null,null,{"$f":"SUM(G8:G12)","v":0}]
[null,{"$f":"CONCATENATE(\"Total calculated annual consumption for compliant appliances \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total calculated annual consumption for compliant appliances (MBtu)"},null,null,null,null,{"$f":"SUMIF(C8:C12,\"=Yes\",G8:G12)","v":0}]
[null,"A"]
[]
[null,"Appendix 3, Tables 2-4 Equipment"]
[null,"For Tables 2-4, input actual process energy consumption (above) or use the default method (below) in which each category (Tables 2, 3, 4) is assumed to be 25% of total process energy consumption (for categories present in the project).  Projects must meet the prescriptive criteria in order to use this method."]
[null,"Appliance Type","Compliant with prescriptive requirements?","Annual Consumption",{"$f":"CONCATENATE(\"Total \nAnnual Consumption\n\",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total \nAnnual Consumption\n(MBtu)"}]
[null,"Default: Table 2 - Supermarket Refrigeration",null,{"$f":"IF(C20=\"Yes\",25%,\"\")","v":""},{"$f":"IFERROR(D20*$E$23,\"\")","v":""}]
[null,"Default: Table 3 - Walk-in Coolers and Freezers",null,{"$f":"IF(C21=\"Yes\",25%,\"\")","v":""},{"$f":"IFERROR(D21*$E$23,\"\")","v":""}]
[null,"Default: Table 4 - Commercial Kitchen Ventilation",null,"",""]
[null,{"$f":"CONCATENATE(\"Total annual consumption, calculated + default \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total annual consumption, calculated + default (MBtu)"},null,null,{"$f":"G13/(1-SUM(D20:D22))","v":0}]
[null,{"$f":"CONCATENATE(\"Total annual consumption for compliant appliances, calculated + default \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total annual consumption for compliant appliances, calculated + default (MBtu)"},null,null,{"$f":"SUM(E20:E22)+G14","v":0}]

{"sheet":"Summary","index":3,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[23,3,24,5],[23,10,24,10],[25,3,26,4],[27,3,27,6],[19,2,20,5]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab. "]
[]
[null,null,"Option 1. Whole-Building Energy Simulation"]
[]
[null,null,{"$f":"CONCATENATE(\"Total baseline annual consumption \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total baseline annual consumption (MBtu)"},null,null,null,null,{"$f":"SUM('Option 1'!G13,'Option 1'!H20,'Option 1'!H26,'Option 1'!H32)","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total proposed annual consumption \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total proposed annual consumption (MBtu)"},null,null,null,null,{"$f":"SUM('Option 1'!H13,'Option 1'!H21,'Option 1'!H27,'Option 1'!H33)","v":0}]
[]
[null,null,"Option 2. Prescriptive Compliance Path"]
[]
[null,null,{"$f":"CONCATENATE(\"Total annual consumption \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total annual consumption (MBtu)"},null,null,null,null,{"$f":"'Option 2'!E23","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total annual consumption for compliant appliances \",IF(UOM=1,\"(MBtu)\",\"(MJ)\"))","v":"Total annual consumption for compliant appliances (MBtu)"},null,null,null,null,{"$f":"'Option 2'!E24","v":0}]
[]
[null,null,"Annual consumption for compliant appliances as a percentage of total annual consumption (%)",null,null,null,null,{"$f":"IFERROR(H16/H14,0)","v":0}]
[]
[null,null,"Project has met 90% of total energy consumption for all process equipment with compliant appliances",null,null,null,null,{"$f":"IF(H18>=0.9,\"Yes\",\"No\")","v":"No"}]