Data Tables and Monte Carlo Simulations (Update)
Problem –
A few people have told me that the example files in Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide either Hangs or Freezes there computer.
Thats not good!
This may be due to the file having quite a few large Data Tables especially when opened on lower end pc’s.
Solution –
I have seperated each Tab as a seperate Excel 2007 file, see below:
1. 1 Way.xlsx
2. 2 Way.xlsx
3. Monitor Multi Variables.xlsx
4. Multiway Table.xlsx
5. Monte Carlo (Simple).xlsx
6. Monte Carlo (Adv).xlsx
Also the Data Tables in some files have ben removed and instructions left as to how to reinstate them
The above links have also been placed in the original post.
I hope you can continue to enjoy this post.
Hui…
Hello Awesome...
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:

Leave a Reply
« Countdown Timer App in VBA to Remind you about the VBAClasses Closing Time!!!  VBA Classes Registration Closing in a Few Hours – Join Now! » 
8 Responses to “Data Tables and Monte Carlo Simulations (Update)”
Hi Hui,
Many thanks for this. Very helpful indeed!
Regards,
Nitin
I was interested in testing that spreadsheet before. I have a core i5750 @3.6GHz and 8GB of RAM and yes it seems to crash/freeze a lot, so I didn't bother looking much further into the spreadsheet.
Maybe these new ones are less crashy.
Thanks a lot hui for breaking down the file and making it easier for opening.
This was by far the most comprehensive post on a very important model and extremely informative too (for tenderfoots like me).
Raghav
Hi Hui
Many many thanks it will be very useful for me.
Regards,
Abhijit Sharma
Hui, this is much appreciated. It achieves essentially what AtRisk or Crystal software does. One question pls: Can decision tree be addedin? So, instead of (or/and in addition to) probabilistic formulae, we can have some decision branches, in simple Yes/No, and simple discrete probabilities like 30%, 40%, 30% (i.e. low, mid, high cases). I'm not Excel adept to draw/model decision trees; if such a tool exists in Excel (or not?). Best
@David
Monte Carlo analysis is a method of running the model repeatedly, assigning different values taken randomly from a known distribution into a number of input variables to the model, and saving the inputs and outputs for later analysis.
Decision Trees are part of the logic that is/can be built into the model, so yes this can be done.
Hui & Chando,
It will be great, if you can build something regarding decision trees..
Cheers,
Ayush
@Ayush
Have a look at
http://office.microsoft.com/enus/marketplace/treeplanEM010243456.aspx