In this part of the tutorial, the analysis of the ball movement is continued. The effects of the collision events are introduced in the equations of movement. [sociallocker][/sociallocker] Excel PONG Tutorial #5 by George Lungu – combining kinematics with collision events – In this tutorial (which is a continuation of part#4) the kinematics of the ball is further analyzed… Read More... "How to make a game of PONG in Excel – part #5"
This section is dedicated to modeling the 3D perspective effect in Excel 2003 standard.
In this part of the tutorial the analysis of the ball movement is taken farther, to include such effects as bouncing off the walls of the court and collision with the bats. [sociallocker][/sociallocker] Excel PONG Tutorial #4 – combining kinematics with collision events by George Lungu – In this tutorial (which is a continuation of part#3) the kinematics of… Read More... "How to make a game of PONG in Excel – part #4"
In this tutorial (which is a continuation of part#2) the kinematics of the ball starts being implemented. Two new macros are being introduced, the “Serve” macro and the “Play” macro. [sociallocker][/sociallocker] Excel PONG Tutorial #3 – ball kinematics analysis – the serve by George Lungu – In this tutorial (which is a continuation of part#2) the kinematics of the ball… Read More... "How to make a game of PONG in Excel – part #3"
In this section two bats are created (the opponent’s bat and the player’s bat). The player’s bat movements are controlled by the vertical mouse movement. The geometry of movement, placement and charting of the bats are explained. [sociallocker][/sociallocker] Excel PONG Tutorial #2 – creating the pong bat animation with various options by George Lungu -In this tutorial (which is a… Read More... "How to make a game of PONG in Excel – part #2"
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"
Most of the models on this blog are designed for Excel 2003 or earlier versions. Sometimes however, Excel 2007 or 2010 are the only versions available even though they might be far slower when running these models. This presentation is an introduction to Excel 2007 and it was suggested to me by one of my readers. [sociallocker] [/sociallocker] Creating, Sizing,… Read More... "Creating, Sizing, Translating and Rotating 2D Shapes in Excel 2007"
In certain models we need to be able to change the scale of the chart axes function of the result of a simulation. Excel charts do have auto-scaling as a default option but sometimes the scaling values we get are not what we need. Another reason against using auto-scaling is that during the time the model runs, the scale self-adjusts and… Read More... "Easy Zoom – Chart Axis Scaling Using VBA"
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"
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"
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"
Hi Folks, As a kid was fascinated with high power rifles, sniper rifles, cannons and in general, fast projectiles. I’ve been brainwashed with all sorts of urban legends about how far an AK 47 or a pistol can shoot or how thick a steel metal plate a bullet can penetrate at various distances. I’ve also watched some documentary about snipers… Read More... "2D Projectile Motion Model #1 – a virtual tactical shooting range"
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"
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"
In computer graphics we often need to be able to display a three-dimensional image in two dimensions and preserve the perspective appearance. If we walk on a straight road, it appears that the road narrows with the distance. This is the perspective effect and it is a result of mapping a three-dimensional image on a two-dimensional surface (i.e. a computer… Read More... "3D-2D Perspective Mapping in Excel – part #1"