Forum Discussion
Multiple Values in Scenario Manager
- I'm thinking you could utilise the 2nd approach I put in the original attached file. Where the DataTable is just used to trigger scenarios. You would have to layout those scenarios in a few columns.
It does sound like DataTables are what you need.
I've attached a couple of examples and an article I wrote on it
HI Wyn! Wyn Hopkins
Maybe there was a lack of explaining from my part, and I've already worked it out, but I think that there are better ways to do it. Anyway, I think that it's going to be good for future cases if we cover this up. This case is a little bit more complex
I'm helping my brother with the projections of his business. so basically he runs some workshops. And the tricky part here is that the number of students triggers a lot of different things across the worksheet. So for example, if there are 15 students enrolled, 2 teachers are needed, if there are 8 students enrolled, only 1 teacher is needed. If there are 5 students enrolled 5 tools are needed, with 12, 8 tools are needed, etc. So I need to do a scenario for all the possibilities of students, 4,5,6,7,8,9, etc. Because each number triggers plenty of different cells that affect the estimated cost of the workshop.
The percentage part is the scenarios of the utility so, how much would be the price of the workshop if we want 50%, or 40% percent of utility.
So in the end, the final calculations are fittable for the data table, but only after all the scenarios have been made.
I hope that I made myself clear!
- I'm thinking you could utilise the 2nd approach I put in the original attached file. Where the DataTable is just used to trigger scenarios. You would have to layout those scenarios in a few columns.
I am trying to apply your tables paper to a workbook which has multiple tabs and the 2 variables I am changing are set in different tabs. I am trying to change the interest rate and the number of months the loan amortizes to determine how much the total principal and interest would be over 5 and 10 years. Each of the variables are in a different tab (they are highlighted in yellow). I am not clear how to set up the table to change these variables and have the sums calculating in a third tab (DS comparison tab). Can you guide me in the right direction?
