I recently devised a method to perform Monte Carlo simulations with Open Office Calc. I have long considered this a complicating feature of Open Office Calc, and would welcome comments that improve upon what I produced below. By perform simulations, I mean my procedure produces a data table with the following qualities:
- Rows represent simulation results of my desired model
- Columns represent individual outcome variables of interest
- Multiple.Operations is used to establish the data table
- The results in each cell entry are based on random numbers applied to individual variables within my model
- The entire table recalculates for any change to a model parameter, automatic or manual at my choice Read more
