J-i APPENDIX J. IMBUILD MODEL

. TABLE OF CONTENTS J.1 INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . J-1 J.2 SPREADSHEET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . J-1J-1 APPENDIX J. IMBUILD MODEL

J.1 INTRODUCTION This appendix provides a brief guide to the use of ImBuild, the input/output model of the U.S. economy that estimates the effects of standards on major sectors of the economy related to buildings and the net impact of standards on jobs. 1 ImBuild (which stands for Im pact of Build ing Energy Efficiency Programs) is the model used in Chapter 15, Net National Employment Results, to estimate impacts of water heater efficiency standards on employment. J.2 SPREADSHEET The following are the steps for using the ImBuild model spreadsheet: 1. Open Excel. 2. Open two files in memory: techs_1.xls imb98_1.xls When it asks you to enable macros, reply "yes." When it asks you to reestablish links, reply "no." NOTE: At some point in running the model, you will get an error if techs_1.xls is not open. You also need to have the INLIB_1.xls accessible (i.e., in the same subdirectory where you’ve opened the original imb98_1.xls file). 3. A model can be run by going to the cover sheet (i.e., the first worksheet) of imb98_1.xls and clicking on the START button. 4. It will then ask you for the forecast years that you want to forecast. Enter the years you want. The deflators should be: capital = 1 operations = 1 income = 1.144 [This will cause it to take the defaults of the model as originally used by PNNL.] 5. When it asks what results you would like to see, click on the button for "Effects of Financing" under "Graphical Employment." 6. When it asks if you would like to keep these results, these are the results that were saved fromthe last time the model was run. If you're doing new runs, the answer should be "no". Otherwise your new runs will be overlayed on the existing run.J-2 Let's assume you enter, "no." 7. If you are doing a new series of runs and you want to keep the inputs for them, you can reply "no" to "Delete previous runs?" Let's assume that you will delete previous runs so click on all the relevant boxes. 8. For "Run Title", enter the name that you want for the run. Use a simple, easily remembered name as you will need to refer to it later on. Enter the number and the title. 9. Enter the technology that you want to analyze. Generally, you will want to analyze a technology that we've entered and that's under "OTHER" Adding New Technology: 10. If you're doing a new analysis, it often works best to input a new technology, so reply "yes." Enter the name of the new technology. Again, this should be an easy-to-remember name as you will refer to it again later on. 11. It will then ask you whether or not the name of the technology is what you wanted. If so, reply “yes”. When it asks whether or not you're satisfied with inputs for the technology (which if you've defined a new one, you won't be otherwise you're using the default for some other product analyzed by PNNL), it is at this point that you say "no" to enter the following inputs from the NES Spreadsheet data: - Years. Which are the same as the analysis years you entered in Step Number 4. NOTE: Gas and LPG need to be summed from the NES Spreadsheet into a “combined gas” category for the ImBuild runs. - System Capital Cost Increase. The total additional incremental manufacturing costs (relative to the no-standards case) due to standards (e.g., the costs of the new water heaters) for the appropriate fuel type. This number should be positive if there are increased costs. These numbers should be in millions of $. - System Installation Cost Increase. The total additional incremental installation costs (relative to the no-standards case) due to standards (e.g., the costs of the new water heaters) for the appropriate fuel type. This number should be positive if thereJ-3 are increased costs. These numbers should be in millions of $. - System Energy Cost Increase or Decrease. This is where you enter the $ energy cost savings. If there are savings due to standards (the normal case) then this number should be negative and in millions of $. If given in $bil and they need to be converted. - System Non-Energy Cost Increases or Savings (e.g., this can happen if there are interactions, for example, between HVAC and lighting). For the most part, this should probably be zero. - System Energy Saved. This is the energy savings in *trillions* of Btus. NOTE: The NES spreadsheet normally has this number in quads so a conversion is necessary.
When you're done, hit the [OK] button. The program will verify that you agree with the inputs. Technologies: 12. Click on "OTHER" The name of the technology should be the same as the one you entered in Step Number 10. 13. Percentage of Investment by Sector. For water heaters, this is 100% in Household Appliances. Accept all further default entries until you get to Impact on Energy Sector Investments. To run the model with utility impacts, make sure the boxes are checked. Otherwise, uncheck them. 14. The model will then ask if you want to run it with these inputs that you've entered. Answer “yes” and the model will generate results for the years you’ve input. Repeat for each set of years you want to analyze. Note: The first year of each set of years analyzed is hard-coded as “1989" so if you are running analyses for multiple sets of years, you should discard the first year of any set. To maintain continuity, you should probably do overlapping years for the last year of each successive set.J-4 REFERENCE 1. Pacific Northwest National Laboratory, ImBuild: Impact of Building Energy Efficiency Programs, 1998. Richland, WA. Prepared for the U.S. Department of Energy under Contract DE-AC06-76RLO 1830

.