This is the second part of a tutorial targeted at modeling logic gates in MS Excel 2003. The first part introduced the basic logic gates,, symbols and associated logic equations. This model includes no delay or loading for the gates. The following type of gates will are described: inverter, AND, NAND, OR, NOR, XOR (exclusive or) and XNOR. The tutorial has several partsContinue Reading
This is a preview to the 3D flight simulator model previously published on this blog. You can download the Excel Model or check out how to build this animation from scratch here: 1, 2, 3, 4, 5, 6, 7.Continue 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 an older Excel model of a speedometer. [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 the first section of a tutorial about the creation of a Tetris game in Excel using mainly spreadsheet formulas and very little VBA. [sociallocker][/sociallocker] Building a game of Tetris #1- the generation and the rotation of the Tetris parts by George Lungu – This tutorial explains the creation of a game of Tetris in Excel using spreadsheet formulasContinue 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 to an older post. [sociallocker][/sociallocker]Continue Reading
A video preview to an older model. [sociallocker] [/sociallocker]Continue Reading
This is a video preview of an animated triple spring mass damper system moving in a 2-dimensional space. The model will work in all versions of excel but it will be slow in 2007 and 2010. [sociallocker][/sociallocker]Continue Reading
This is an older model of planetary motion in 3D containing eight planets. A video preview can be watched here. [sociallocker][/sociallocker]Continue Reading
This post contains the first part of a series of tutorials demonstrating how to build a lively game of Pong in Excel. The section deals with the bat movement VBA macro, and plotting the “court” or “tennis-table” on a 2D scatter chart. [sociallocker][/sociallocker] Excel PONG Tutorial #1 – creating the pong table and bat animation by George Lungu PONG facts:Continue Reading
In this tutorial, most of the calculations for the numerical simulation a SMD (spring-mas-damper) system will be consolidated into a single formula, the coordinate formula. In this case, in order to calculate the coordinate at the end of a any time step, we will need just the coordinates from the previous two time steps and of course the input parameters (constants). TheseContinue Reading