Modeling atomic diffusion and polymerization – coding an Excel animated model
part#1 part#2 part#3 part#4Continue Reading
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.Continue Reading
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 drivenContinue Reading
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 #2Continue Reading
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 theContinue Reading
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]Continue Reading
A video preview of yet another sprite animation model in Excel. [sociallocker][/sociallocker]Continue Reading
A video preview to a sprite animation model in Excel. [sociallocker][/sociallocker]Continue Reading
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]Continue Reading
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]Continue Reading
This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker]Continue Reading
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.Continue Reading
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]Continue Reading
This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later. [sociallocker]>[/sociallocker]Continue Reading
This is a continuation of the PLL series of tutorials and it takes the recursive numerical formulas derived in the previous section, implementing a dynamic spreadsheet model with help from a copy-paste loop type of macro. This macro emulates the behavior of the phase locked loop model in time. At this point, the model is functional. Charting options for the waveformsContinue Reading
This section explains how to add score board logic on the worksheet and how to display the score on the court chart using sprites. [sociallocker][/sociallocker] Excel PONG Tutorial #8 – creating a score display by George Lungu – The previous tutorial showed how to associate sound effects (including crowd applause and laughter) to ball collision events. This section (which is aContinue Reading