A Family of Speedometers – video preview
2011-07-04
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
A Legacy Speedometer Model – video preview
2011-07-03
This is a video preview of an older Excel model of a speedometer. [sociallocker][/sociallocker]Continue Reading
An Analog Clock Model – video preview
2011-07-01
This is a video preview of the analog clock series which include a model section and a tutorial section. [sociallocker][/sociallocker]Continue Reading
Building a game of Tetris #1– the generation and the rotation of the “tetrominoes”
2011-06-30
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
A Game of Tetris in Excel – video preview
2011-06-28
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
A 3D Octal Planetary Model – video preview
2011-06-26
This is a video preview to an older post. [sociallocker][/sociallocker]Continue Reading
3-Body Planetary System with Options – video preview
2011-06-25
A video preview to an older model. [sociallocker] [/sociallocker]Continue Reading
An Animated 2D Spring Oscillator – video preview
2011-06-23
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
A Legacy 3D Octal Planetary Model
2011-04-17
This is an older model of planetary motion in 3D containing eight planets. A video preview can be watched here. [sociallocker][/sociallocker]Continue Reading
How to make a game of PONG in Excel – part #1
2011-02-23
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
Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5
2011-02-22
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
Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4
2011-02-21
This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations. [sociallocker][/sociallocker] A casual approach to numerical modeling – part #4 – a Spring-Mass-Damper-System – creating the animation by George Lungu – We are trying to generate animation for the system sketched above knowing the deviation from the equilibrium function of time. This deviation isContinue Reading
Creating a Speedometer in Excel, Part #2 – tutorial
2011-02-11
The previous tutorial (first half) explained how to download a speedometer picture from www.flickr.com and how to alter it (delete the needle) using a freeware called Gimp (similar to Photoshop). – The model replaces the deleted needle from the picture with a moving one created from a chart line. – This second half of the tutorial explains the geometry, trigonometryContinue Reading
Creating a Speedometer in Excel, Part #1 – tutorial
2011-02-10
This is the first half of a tutorial which shows how to create a speedometer in Excel. The model is essentially a 2D scatter chart having as background the picture of a speedometer dial downloaded from www.flickr.com. Before using the photograph you need to erase the arm of the speedometer from the picture using Photoshop or other photo editing software. In theContinue Reading
A Family of Speedometers in Excel
2011-02-09
Hi guys, by popular demand, this is a file containing five different animated speedometers and a tachometer (rpm-meter). I can recognize two models: a Toyota Camry and a Ford Crown Victoria. They work great. The rest I am not sure what they are, I would appreciate if you tell me. Just leave a comment. The model works in all versions of Excel. Cheers, GeorgeContinue Reading
Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions
2011-02-02
This tutorial explains a pair of important user defined functions, the “Navigator_u()” and the “Navigator_v()”. These functions save the user nine columns of formulas by calculating the effects of: 3-dimensional shift, rotations around the three axes of coordinates and 3D-2D perspective mapping. These user defined functions are also easy to use compared to writing all the perspective mapping equations fromContinue Reading