Nov 27 2019 04:52 PM
Nov 27 2019 04:52 PM
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!
Nov 28 2019 07:16 PM
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!
Nov 28 2019 07:22 PMSolution
Aug 03 2021 05:21 PM
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?