This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. How to make a realistic looking digital clock in MS Excel – Part #3 This part (part #3) demonstrates how to use very… Read More... "How to make a realistic looking digital clock in MS Excel – Part #3 – (create a test “1-digit clock” – mainly VBA)"
This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. How to make a realistic looking digital clock in MS Excel – Part #2 The sprites will be created in PowerPoint and imported in Excel as images. This part (part #2) demonstrates how to use very… Read More... "How to make a realistic looking digital clock in MS Excel – Part #2 – (how to move shapes with VBA)"
I am including a preview of our next series of tutorials about creating wireframe animations and games in MS Excel. These wireframe animation methods can be used in various engineering Excel models, as well as in scientific models and games in Excel. This training will be about creating a simple internal combustion engine 2D model in MS Excel. Join out… Read More... "How to Create a Wireframe Internal Combustion Engine 2D Animation in MS Excel – Preview"
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 driven… Read More... "How to Create Wire Frame Shapes for Excel Animation – Video Tutorial – Part 1"
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] Read More... "A Digital Clock Model – video preview"
This section of the tutorial explains how to add sounds to the Pong game created previously. There are four types of sound effects: collision with the walls, collision with the bats, missed ball by the player (crowd laughter) and missed ball by the virtual opponent (crowd applause). [sociallocker][/sociallocker] Excel PONG Tutorial #7 – associating sound effects to ball collision events by George Lungu… Read More... "How to make a game of PONG in Excel – part #7"
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"
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"
Hi guys, here is the final part of tutorial about creating a digital clock in Excel. It is a good tutorial about general use of sprites in animation, especially the first half. Tell us your thoughts, George [sociallocker][/sociallocker] Building an Digital Clock in Excel – part #2 – a full digital clock model using the “digit” sprites by George Lungu… Read More... "Creating a Digital Clock #2 – sprite driver, timing macro and functions, full model"
Hi guys, this is part #1 of a tutorial showing how to generate sprites used in a digital clock model. Sprites are typically simplified images (usually two-dimensional) which are used to replace complex but remote 3D-objects in an image. When an object is far away from the viewer a three-dimensional representation is not necessary since the eye cannot see all the details,… Read More... "Creating a Digital Clock #1 – sprite generation"