Running Modano files with Oracle Crystal Ball [ex. Monte-Carlo simulation]

Hi Filipe,

Our understanding is that Crystal Ball requires sheets to be unprotected - even though it's usually simply editing assumptions cells which are unlocked anyway - and this causes issues because Modano protects sheets to ensure that the modular data in your workbooks remains consistent with the Excel data.

Have you tried simply running Crystal Ball within a separate workbook that is linked to your Modano workbook via formulas? My understanding is that Crystal Ball works by changing specified assumptions and capturing specified outputs across a large number of scenarios, could you link these assumptions in your Modano workbook to corresponding assumptions in your Crystal Ball workbook and simply have Crystal Ball drive the Monte-Carlo simulation from within this workbook?

For transparency I've never personally used Crystal Ball, so apologies if this doesn't work, but I have spoken to a lot of Crystal Ball users and based on what I've learned from them I can't see why this wouldn't work. It just requires investing a bit of time to set up and link the Crystal Ball workbook.

Let me know if this works.

Either way, we'd be happy to continue think-tanking this with you via our support system at no cost - just submit a support request via: https://app.modano.com/account/support

Michael