In the box B21, enter the value 0,2 or 20%.Įnter the informations for the second scenario. Enter the appropriate valuesfor each scenario in the boxes. We must now enter values for each scenario. Otherwise, the scenario manager will overwrite your formulas in preparation of the summary report and your model will no longer be valid. While pressing the Ctrl key, click on other cells that you need for the scenario.ĬAUTION : Always make sure that the cells that you select for the changing cells must be values never formulas. In the Changing cells box, enter each cell address, separating them with a " ".Ĭlick the first cell you wish for the scenario. There are two ways to select multiple cells for a scenario. In the box Changing cells, enter the cells B21 B5. In the Scenario name box, enter the text : Scenario 1. For the first scenario, these are the cells B21 and B5. These are the cells you want to change the values. The first step in creating a scenario is to name the scenario and determine what are the variable cells. Or you won't be able to return to your original values.įrom the scenario manager window, press the Add button. The Show option allows you to view the impact of the scenario on your entire model. The summary option will generate a new worksheet that will able you to compare the results of these scenarios on the important values in your model. You can also merge scenarios that are located in other worksheets.
#Trnsys excel link exercises windows
It's form this Scenario manager windows that you can create, change and delete scenarios. Under the button What-If Analysis, select the Scenario Manager option. Which proposition is more interesting for the company? In this case, we want to know which scenario will give the highest cummulative profit that is in cell D19. Scenario 3: Growth Rate of 40%, but sales of the product 100 to start at $ 95 000. Scenario 2: Growth Rate of 30%, but sales of the product 200 to start at $ 50 000. Scenario 1: Growth Rate of 20%, but sales of the product 300 to start at $ 50 000. Here are three proprositions to increase the profitability for the quarter (cell D19) Select the worksheet named Completed Model. To follow this exercise, you can use the file excel2007-2010-exercises.xlsx on the demonstrations files web page. Also, all variables must be on the same worksheet. This command is only useful if you have a complete and operational model.
However, the scenario manager allows you to quickly compare several hypotheses, or scenarios for using the term of Excel, and generate a summary table with the results. But which is better? You could try them in your model one after another. We offer several options to improve your performance. You have created a model that meets your needs. The View option and it's trap Introduction Excel 2007 : Exercise on Scenario ManagerĮxcel 2010 - Exercise on Scenario Manager