Hi team,
I created 10 scenarios on my model using scenario manager and scenario modules, and found the errors below from row No. 302 to 307 after I further added 6 new scenarios.
Of note, I don't put any variable scenario on debt and interest-on-cash modules. And when I change the formular to see the results of interest expenses (instead of net interest expenses i.e. interest on cash - interest expenses), the table worked again. Some other tables have the same issue such as closing cash balance, net profit after tax, etc.
Anyone else had this problem before? Thank you in advance!
Hi Hoang,
It’s hard to understand what’s happening based only on that image. Does the formula in cell J302 contain an error reference or is the formula valid but evaluating to an error?
And does your model contain errors when you set the active scenario to Scenario 11?
Michael
Hi Michael, thank you for your prompt response. The cell J302 is valid but returned to an error. The model does not contain errors when I made the Scenario 11 active.
After checking related formulas, I figured out why. In the scenario assumption input, the active scenario cells did not capture newly added columns as I set formula wrongly when I built a scenario module and added new scenario columns in the model.
Btw, I believe Modano will add more how-to videos in the upcoming period but wanted to share some tips on scenario analysis I found helpful for inexperienced users. It is worth noting that we can (i) add any scenario analysis for any variable in our model and see side-by-side scenario results, and (ii) extend the time series by just drilling right the data table (in case your model time series is longer than default data table setting). In the example below, I added different scenarios for No. of learning pupils by adjusting the highlighted formula on cell I157!
Hi Hoang,
Thanks for the update, great to see you found the culprit.
It's great that you've figured out how to extend the foundational scenario analysis modules, this is exactly what they were designed for.
We're absolutely aiming to provide a wide and increasing range of How To Videos, we'll keep you posted via our newsletter.
Michael