By popular demand I am coming back to Excel after a long hiatus. This is an update of an older model previously presented on this blog. > I added a few features to the roller coaster model as follows: 1) Performance log 2) All sorts of colors and color scheme selection 3) Speed control 4) Coaster length adjustment 3) Ground… Read More... "Excel Roller Coaster Update #1"
This is a model I made quite some years back to model the stability of an air compressor driven by an electric motor. The purpose was also to try to select the motor parameters, transmission ratios, energy loss in the flexible couple. I will make the Excel file available at a later date. Read More... "Electric Motor & Air Compressor Excel Animation – Dynamic simulation demo/preview"
This is an introductory video about creating, scaling and animating wireframe shapes in MS Excel. The tutorial is made from the ground up starting with a blank workbook. A square is created. Scaling factors are added which can turn the square into a custom size rectangle. The tutorial demonstrate the use of VBA driven spin buttons and also VBA driven… Read More... "How to Create Wire Frame Shapes for Excel Animation – Video Tutorial – Part 1"
This is the second post on Excel speed. This has serious implications in creating usable Excel animations. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas. This part analyzes the effect of formula complexity on the spreadsheet speed. About the speed of animated models in MS Excel – part #2… Read More... "About the Speed of Spreadsheets #2"
This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007. It has significant effects on animations in MS Excel. In this first part, a “stopwatch” macro is described which, when incorporated in any of calculation loop, can measure the frequency your loop is executed. In this first part of the tutorial the… Read More... "About the Speed of Spreadsheets #1"
This is a video preview to the pong game model developed during a series of ten tutorials as linked in the brackets ( #1, #2, #3, #4, #5, #6, #7, #8, #9 and #10 ) [sociallocker][/sociallocker] Read More... "A Fast Pong Game with Special Effects in Excel 2003 – video preview"
A video preview of yet another sprite animation model in Excel. [sociallocker][/sociallocker] Read More... "City Lights in North America – video preview"
A video preview to a sprite animation model in Excel. [sociallocker][/sociallocker] Read More... "Day and Night Over the Atlantic – video preview"
The current is a preview of a sprite based Excel speedometer model and a series of speedometer creation series of tutorials (#1 and #2) [sociallocker][/sociallocker] Read More... "A Family of Speedometers – video preview"
This is a video preview of the digital clock series which include a model for Excel 2003 a second model for Excel 2007 or 2010 a tutorial #1 and a tutorial #2. [sociallocker][/sociallocker] [sociallocker][/sociallocker] Read More... "A Digital Clock Model – video preview"
This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker] Read More... "An Analog Clock Model – video preview"
This is a video demo of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it satisfactory in 2007.… Read More... "Excel Tetris – a video demonstration"
This is a video preview of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it in 2007. [sociallocker][/sociallocker] Read More... "A Game of Tetris in Excel – video preview"