Spreadsheet simulation

ABSTRACT

"Spreadsheet simulation" refers to the use of a spreadsheet as a platform for representing simulation models and performing simulation experiments. This tutorial explains the reasons for using this platform for simulation, discusses why this is frequently an efficient way to build simulation models and execute them, describes how to setup a spreadsheet simulation, and finally examines some limitations on the use of spreadsheets for simulation.

REFERENCES

• 1: Alexopoulos, C., and A. F. Seila. 1998. Output data analysis. In Handbook of Simulation: Principles, Methodology, Advances, Applications, and Practice, ed. J. Banks. New York: John Wiley.
• 2: Cheng, R. C. H. 1998. Random variate generation. In Handbook of Simulation: Principles, Methodology, Advances, Applications, and Practice, ed. J. Banks. New York: John Wiley.
• 3: Fishman, G. S. 1996. Monte carlo concepts, algorithms and applications. New York: Springer.
• 4: F. Fumero , C. Vercellis , Hai Yang , Thomas A. Grossman, Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues, Interfaces, v.29 n.3, p.88-103, March 1999 [doi>10.1287/inte.29.3.88]
• 5: L'Ecuyer, P. 1998. Random number generation. In Handbook of Simulation: Principles, Methodology, Advances, Applications, and Practice, ed. J. Banks. New York: John Wiley.
• 6: Mattesich, R. 1961. Budgeting models and system simulation. The Accounting Review 36:384--397.
• 7: Seila, A. F., V. Ceric, and P. Tadikamalla. 2003. Applied simulation modeling. Belmont, California: Brooks-Cole.
• 8: Wayne L. Winston, Simulation Modeling Using @Risk, Wadsworth Publ. Co., Belmont, CA, 1996