This paper presents a new interactive spreadsheet graphics animation technique which uses the spreadsheet engine’s intrinsic single step iteration capability. The well-known Lissajous figures exemplify a time variant process demonstrating the virtually unlimited movie-like animation. At any time the visible motion may be interrupted, parameters may be modified, and then the calculation can be continued. First, this paper describes a simple example without VBA and then demonstrates the method’s capability by a second more sophisticated Lissajous figures example using VBA. The downloadable workbook uses object blocks and comprises a pedagogically elaborated graphical user interface. It shows that the technique is applicable for both the unskilled student as well as the advanced programmer. This graphics animation method has the potential to revolutionize the spreadsheet usage for dynamical process simulations.
Wischniewsky, Wilfried A.L.
Movie-like Animation with Excel’s Single Step Iteration Exemplified by Lissajous Figures,
Spreadsheets in Education (eJSiE):
1, Article 4.
Available at: http://epublications.bond.edu.au/ejsie/vol3/iss1/4