Forum Discussion
Multiple Values in Scenario Manager
Hi! Is there a way to put multiple values in a changing cell using scenario manager. I want to try different values in a couple of changing cells. I think that I can't use data table because the cells are not directly related, so no formulas involving both.
So basically, the values that I want to try in one changing cell are: 30%, 35%, 40%, 45%, 50%
And in the other one are: 4,5,6,7,8,9,10,11,12,13,14,15,16. This cell is related to a lot of cells across the worksheet, that's why I've chosen Scenario manager.
If I do it manually value per value it would take me forever. Is there a way to put multiple values in Scenario Manager, or what other alternatives can work?
Thanks in advance!
- 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.
5 Replies
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.
