APPENDIX A. INSTRUCTIONS FOR USING THE ENGINEERING ANALYSIS SPREADSHEET

TABLE OF CONTENTS

A.1 INTRODUCTION

.......................................................................................................... A-1 A.2 USING THE ENGINEERING ANALYSIS SPREADSHEET

...................................... A-1 A.2.1 Start Here Worksheet

.......................................................................................... A-1 A.2.2 Introduction Worksheet

...................................................................................... A-2 A.2.3 Results Worksheet

.............................................................................................. A-3 A.2.4 Calculation Worksheet

........................................................................................ A-7 A.2.5 Equipment Classes Worksheet

............................................................................ A-8 A.2.6 Assumptions Worksheet

..................................................................................... A-9 A.2.7 Model Worksheet

................................................................................................ A-9 A.2.8 Design Options Worksheet

................................................................................. A-9 A.2.9 Supporting Worksheets

....................................................................................... A-9

LIST OF FIGURES

Figure A.2.1 Screen shot of the Start Here worksheet

............................................................... A-2 Figure A.2.2 Screen shot of the Introducti on worksheet (not all content shown).

.................... A-3 Figure A.2.3 Screen shot of the Results worksheet.

.................................................................. A-4 Figure A.2.4 Screen shot of Desi gn Specifications worksheet

.................................................. A-6 Figure A.2.5 Screen shot of the Design Option Order worksheet

.............................................. A-7 Figure A.2.6 Screen shot of the Calculati on worksheet (not all content shown)

....................... A-8

A-iA-iiAPPENDIX A. INSTRUCTIONS FOR USING THE ENGINEERING ANALYSIS SPREADSHEET

A.1 INTRODUCTION

This appendix presents instructions for us ing the engineering anal ysis spreadsheet for commercial refrigeration equipment (CRE ), which can be found on DOE’s website: http://www1.eere.energy.gov/build ings/appliance_standards/comm ercial/refrigeration_equipmen t.html

. The engineering analysis spreadsheet details the assumptions, methodology, and calculation of cost-efficiency curves using a de sign-option approach (see Chapter 5 of this TSD for more information on this approach). It was developed using Microsoft Excel © , which is a general spreadsheet application a nd is known to most stakeholders . In addition, the engineering analysis spreadsheet is designed to be stand-al one, and has been thoroughly documented. This appendix serves as additional guidance on how to navigate, use, and under stand the engineering analysis spreadsheet.

A.2 USING THE ENGINEERING ANALYSIS SPREADSHEET

The content of the spreadsheet is co ntained on eight primary worksheets:

• Start Here – General information on how to navigate the spreadsheet.

• Introduction – Overview of the spreadsheet.

• Results – DOE’s cost-efficiency results.

• Calculation – Detailed calculations of energy consumption and cost.

• Equipment Classes – Description of covered equipment classes.

• Assumptions – List of numerical and non- numerical assumptions used.

• Model – Description of the en ergy-consumption model.

• Design Options – Description of design options.

A.2.1 Start Here Worksheet

When the spreadsheet is opened, the Start Here worksheet will be displayed (see Figure A.2.1). a This worksheet contains a legend that describes the formatting used throughout the spreadsheet. This formatting is intended to high light different types of information and areas of user input ( e.g., yellow boxes are used to highlight impor tant information and green boxes with dashed gray borders accept user input). The Start Here worksheet also contains navigation links to the other main worksheets, which are duplicat ed on each of the primary sheets for navigation.

a The eight primary worksheets are limited in width in order to fit comfortably on all monitors. Scrolling down may be necessary to see all content. Each primary worksheet has an “END OF PAGE” foot er to indicate the end of
content.

A-1Figure A.2.1 Screen shot of the Start Here worksheet.

A.2.2 Introduction Worksheet

The Introduction worksheet provides general background information on the CRE rulemaking and a brief description of each of th e other primary content worksheets (see Figure A.2.2). Additionally, a link is provided to the online TSD for reference. The buttons before each worksheet description can be us ed to go to those worksheets.

A-2Figure A.2.2 Screen shot of the Introducti on worksheet (not all content shown).

A.2.3 Results Worksheet

The Results worksheet provides pl ots and tables of cost-efficiency results for each of the fifteen equipment classes DOE directly examin ed (see Figure A.2.3). The top portion of the worksheet contains a button that activates a pop-up window for sele cting an equipment class, as well as several user-selectable options for displaying different information about that class. The “Equipment Class Selection” menu appears when the “Change Equipment Class” button is clicked, and allows the user to select the e quipment family, condensing unit type, and operating temperature using the ap propriate radio buttons. b Displayed below the button are the equipment class description, a picture of the equipment, and tabulated cost-efficiency data for both the analytically derived DOE curve a nd the user-defined curve. Below that information are tables containing a more detailed brea kdown of the components of th e refrigeration load and daily energy consumption for both the DOE and user-defined curves. Beneath those tables, a costb Equipment class designations consist of a combination (in sequential order separated by periods) of a product family code (VOP=vertical open, SVO=semivertical open, HZO=horizontal open, VCT=vertical transparent doors, VCS=vertical solid doors, HCT=horizo ntal transparent doors, HCS=horizont al solid doors, or SOC=service over counter), an operating mode code (RC=remote condensing or SC=self-contained), and a rating temperature code (M=medium temperature (38°F), L=low te mperature (0°F), or I=ice-cream temperature (-15°F)). For example, “VOP.RC.M” refers to the “vertical open, remote condensing, medium temperature” equipment class. See Chapter 3, market and technology assessment, for a more detailed explanation of the equipment class terminology.

A-3efficiency plot with the appropriate curves is displayed on the left, and, where applicable, industry-supplied data is shown on the right. c

Figure A.2.3 Screen shot of the Results worksheet.

c Industry-supplied curves were provided for the VO P.RC.M, SVO.RC.M, HZO.RC.L , and VCT.RC.L equipment classes. The option to display an industry-supplied curve is not provided for other equipment classes.

A-4Figure A.2.3 Screen shot of Results worksheet (continued).

The tabulated cost-efficiency data can be displayed without normalization, or be normalized by total display area (TDA), or refrigerated volume (V). Use the “Data Normalization” radio buttons in the top right of the screen to select. The data can also be displayed as manufacturer produc tion cost (MPC), manufactur er selling price (MSP), or manufacturer list price (MLP). Use the “Manufac turer Cost” radio buttons in the upper right of the screen to select. (Note that the industry-supplied data is al ways displayed in the form of TDA-normalized MLP and CDEC, and is not affected by the radi o button selection.)

To view or modify case design specifications, press the “View/Change Design Specifications” button located in the upper section of the worksheet. This button takes the user to the “Design Specifications” sh eet (see Figure A.2.4), which c ontains the DOE specifications, as well as a column to input user-defined specifi cations. Initially, user design specifications are identical to DOE design specificatio ns. However, any changes made to the spreadsheet will be stored, meaning that if the spreadsheet is saved, any changes to user-defined design specifications will be saved as well. The user may change the user design specification values by entering new values in the “User” column, and th en clicking the “Save and Return to Results” button. Clicking the “Save and Return to Results” button will return the user to the results sheet and instantly update the user-defin ed results tables with the results from the user-input values.

A-5The “Set to DOE Default Specifica tions” button will reset the user-d efined values to the default DOE specifications. Press the “Cancel” button to cancel any changes and return to the Results sheet.

Figure A.2.4 Screen shot of Design Specifications worksheet

The “View/Change Design Options” button in the upper middle portion of the page takes the user to the “Design Option Order” sheet, which contains a design op tions selection matrix (see Figure A.2.5). Use this design option selection matrix to cha nge the baseline design options and implementation order of design options for th e current equipment cla ss. Design options not applicable to the current equipment class are ha shed gray, and design options changed from the previous level are highlighted in yellow. Us ing the in-cell drop-down menus, select baseline design options, then select one or more design option changes for each level above the baseline, up to 15 levels. If there are fewer than 15 design option changes, fill the remaining levels with the last configuration. To order design options automatically by payback period (shortest to longest), press the "Auto-Sort Design Options" bu tton after selecting baseline design options. To compare to the order DOE used (where applicab le), press the "View DOE Design Option Order" button, and a pop-up window containing a design op tions selection matrix (similar to the one seen in Figure A.2.5) with the design option orde r used by DOE will be displayed. To return the design option matrix to the default DOE values (where applicable), press the “Set to DOE Design Option Order” button. When complete, pre ss the “Save and Return to Results” button to return to the Results worksheet. Press the “Cance l” button to cancel any changes and return to the Results sheet.

A-6Figure A.2.5 Screen shot of the De sign Option Order worksheet

A.2.4 Calculation Worksheet

The Calculation worksheet shows detailed calculations of energy consumption and cost for the current equipment class (see Figure A.2.6) . To select an equi pment class, click the “Change Equipment Class” button in the upper left of the worksheet, and on the pop up menu choose the equipment family, condensing unit type, and operating temperature using the appropriate radio buttons. The Calculation worksheet presents two sets of calculations: one using DOE's default values and one using user-i nput values. Switch be tween the two with the "Display" radio buttons. The cost-efficiency data are calculated using the case design specifications, design options, and assumptions de termined by DOE. Case design specifications are presented, followed by a matrix of design opti ons used in the model and energy consumption and cost calculations. Each row in the calculati on tables represents a different step in the calculation of cost or energy c onsumption. Each column represents a different design option level, from baseline up to the maximum technol ogy level (max-tech). Columns above the maxtech level repeat the max-tech configuration and are grayed out. View the Model sheet for a schematic representation of the mode l linked to specific calculations.

A-7Figure A.2.6 Screen shot of the Calculat ion worksheet (not all content shown).

A.2.5 Equipment Classes Worksheet

The Equipment Classes worksheet contains in formation on the equipment classes covered by this rulemaking, and the subset of 15 equi pment classes analyzed directly in DOE’s

A-8engineering analysis. Details of equipment class organization are presented in Chapter 3 of this TSD. To view the results or modify the inputs for any of th e 38 equipment classes, follow the link for that equipment class under the “Results Link” column.

A.2.6 Assumptions Worksheet

The Assumptions worksheet lists non-numer ical assumptions as well as numerical assumptions and engineering constants used in the calculation of cost -efficiency data. Nonnumerical assumptions include general assumpti ons about the analysis and design options. Numerical assumptions include c onstants and other parameters us ed in the calculation of energy use. All sources of information are documen ted in Chapter 5 of this TSD. Additional assumptions can be found for specific design op tions on their respectiv e sheets (see section A.2.8). The user can alter the numerical assumpti ons, which will immediately be reflected in the tabulated cost-efficiency data in the Results worksheet.

A.2.7 Model Worksheet

The Model worksheet contains a diagram of the energy consumption model used in the engineering analysis. Details of this model are presented in Chapter 5 of this TSD. Click any part of the model to be taken to the corresponding cal culation in the Calculation worksheet. The user can return to the Model worksheet using the navigation links that are located at the top of each sheet.

A.2.8 Design Options Worksheet

The Design Options worksheet lists the de sign options used in constructing costefficiency curves. Each design option is give n an index number and a corresponding worksheet (numbered 1.0 to 20.0) where detailed information is contained. Although the spreadsheet has room to describe 20 design options, only 13 desi gn options are currently employed in the model (see Chapter 4 and Chapter 5 of this TSD). Each design option has two to three levels, ranked by performance from lowest to highest. Each level is given a lettering code that is used to identify it in the design options matrix for each equipment class. Links are provided to the individual numbered worksheets, where detailed information is contained about the design options. Additional information is also prov ided in Chapter 5 of the TSD.

A.2.9 Supporting Worksheets

Several supporting worksheets are used in the spreadsheet in addition to the eight primary content worksheets. Some of these contain consta nts or other information not necessary for user interaction and are hidden from view. Those that are visible (the numbered design options worksheets) are accessible using the links provided on the primary worksheets when the information on the supporting worksheets is re levant (see sections A.2.3, A.2.4, and A.2.7).

A-9