Performing Monte Carlo Simulations within OpenOffice Calc

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:

  1. Rows represent simulation results of my desired model
  2. Columns represent individual outcome variables of interest
  3. Multiple.Operations is used to establish the data table
  4. The results in each cell entry are based on random numbers applied to individual variables within my model
  5. The entire table recalculates for any change to a model parameter, automatic or manual at my choice Continue reading “Performing Monte Carlo Simulations within OpenOffice Calc”