The Efficacy of Spreadsheet Modelling As an Alternative Means of Teaching Process Simulation

Abstract

Spreadsheet based simulation has many advantages over the pre-programmed simulation applications more commonly used in teaching simulation in undergraduate courses. They are almost universally ubiquitous in business settings around the world. There is near certainty that students will have access to them after graduation since spreadsheets are a standard business tool used by nearly all engineers [1]. In addition, spreadsheets are already present within most standard operating systems. This means that there will be no need to buy or get approvals from Information Technology software committees or other managerial roadblocks. As an alternative to this, there are now free OpenOffice and LibreOffice spreadsheets available on most platforms which make their access effectively universal. Aside from their excellent availability, spreadsheets are an extremely capable learning tool for best practices in process simulation. Most engineering students are arriving at college with a good set of spreadsheet skills from their primary education and then the rest tend to pick it up early as underclassmen [2]. Spreadsheet simulation is easy to explain and generally very simple to debug. Although the now mainly antiquated code-based simulation packages used to offer these same advantages, they have now been largely replaced by more graphically oriented packages which depend in part on subtle mouse clicks and sometimes complex sub-menu structures. In addition, spreadsheets offer easily accessible native analysis and excellent graphing capabilities. Several advantages and potential disadvantages of spreadsheet simulation are presented in comparison to contemporary process simulation. Several simulation projects are then discussed related to Markovian processes including stochastic scatter patterns, sequential random object movement, multi-server queueing processes, dynamic intercept models, complex traffic and evacuation models, and Susceptible-Infected-Removed infections design simulations were taught using spreadsheet simulation.