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 formulas… Read More... "Building a game of Tetris #1– the generation and the rotation of the “tetrominoes”"
A Game of Tetris in Excel – video preview
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"
A 3D Octal Planetary Model – video preview
This is a video preview to an older post. [sociallocker][/sociallocker] Read More... "A 3D Octal Planetary Model – video preview"
3-Body Planetary System with Options – video preview
A video preview to an older model. [sociallocker] [/sociallocker] Read More... "3-Body Planetary System with Options – video preview"
An Animated 2D Spring Oscillator – video preview
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] Read More... "An Animated 2D Spring Oscillator – video preview"
A Legacy 3D Octal Planetary Model
This is an older model of planetary motion in 3D containing eight planets. A video preview can be watched here. [sociallocker][/sociallocker] Read More... "A Legacy 3D Octal Planetary Model"
How to make a game of PONG in Excel – part #1
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:… Read More... "How to make a game of PONG in Excel – part #1"
Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5
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). These… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5"
Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4
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 is… Read More... "Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4"
Creating a Speedometer in Excel, Part #2 – tutorial
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, trigonometry… Read More... "Creating a Speedometer in Excel, Part #2 – tutorial"
Creating a Speedometer in Excel, Part #1 – tutorial
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 the… Read More... "Creating a Speedometer in Excel, Part #1 – tutorial"
A Family of Speedometers in Excel
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, George… Read More... "A Family of Speedometers in Excel"
Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions
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 from… Read More... "Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions"
3D-2D Perspective Mapping in Excel – part #2
The first half of this presentation dealt with mapping a 3D scene onto a 2D surface which can be a computer screen, a projection screen or the retina of the eye. By doing so we preserve much of the feel of depth of the scene. Of course when we look at an picture we get only part of the feel… Read More... "3D-2D Perspective Mapping in Excel – part #2"