Here is another example of sprite animation in Excel (Office 2007 will work fine, though a little bit slower). We’d love to hear from you. George Read More... "City Lights in North America – sprite animation"
Three-Pendulum Harmonograph (#1)- an automatic drawing machine
Ladies and Gentlemen, you will like this. Here is a harmonograph in MS Excel 2003 which models a real one build by Karl Sims. Watch the video first to know what to expect. I could have built it from the bare drawing equations but that would have been too easy and no fun at all so I tried to model the… Read More... "Three-Pendulum Harmonograph (#1)- an automatic drawing machine"
A basic 3-body Planetary System
Hi folks, as a continuation to the previous tutorial here is a 3-body planetary model where the solution to the equations is contained in a static form, as a lookup table (I previously called it a “pure spreadsheet solution”). The model is static in the sense that after any parameter is changed, the solution data remains unchanged in a table until a new parameter is updated by the… Read More... "A basic 3-body Planetary System"
How to Model a Basic 2-body Planetary System
Here is a tutorial explaining how to model a two dimensional 2-body planetary system in Excel. It uses the Euler method of integration. The tutorial starts with explaining the simple Newtonian laws acting on the two planets. There are essentially just two forces acting on each body at any time: the inertia and the gravitational attraction. During each small time step,… Read More... "How to Model a Basic 2-body Planetary System"
Day and Night Over the Atlantic – an example of sprite animation
Hi guys, here is an animation I made yesterday by downloading 120 pictures of the Earth taken 12 minutes apart by satelites above the equator at 30 degrees longitude west on 10/01/2010. The pictures are 500 x 500 pixels and they are pasted as a background of a chart by a slimmed down VBA macro. You can change the speed of… Read More... "Day and Night Over the Atlantic – an example of sprite animation"
A Speedometer in Excel
Here is a speedometer in Excel 2003. It’s an old file and the charting wasn’t done in the most economic fashion. I used too many series while I could have consolidated a lot of the dial curves. It is still a good example of animation and displaying custom numbers on a chart. There are two VBA macros involved, one for changing… Read More... "A Speedometer in Excel"
A Realistic Looking Digital Clock Model
Hi guys, here is a dynamic digital clock model in Excel I made today. The display looks very realistic. I studied for this all the clocks in the house including the stove, microwave oven and washing machine clocks, plus some pictures on Google. It will display your local computer time. It uses “sprites” as a method of creating the digits. I… Read More... "A Realistic Looking Digital Clock Model"
Tutorial – a Static Lissajous Emulator
Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level. Good luck, George [sociallocker][/sociallocker] A Lissajous emulator in Excel by George Lungu Introduction: Jules A. Lissajous was a French mathematician from the 19th century – He wanted to visualize… Read More... "Tutorial – a Static Lissajous Emulator"
How to Make an Analog Clock in Excel
Hello folks, here is a tutorial about building a clock in Excel. Enjoy! [sociallocker][/sociallocker] Building a live Excel clock by George Lungu Here are a few date and time functions in VBA: Now : Current date and time. Example: 7/5/00 3:16:38 PM returned by Now Date : Current date only. Example: 7/5/00 returned by Date Time : Current time only. … Read More... "How to Make an Analog Clock in Excel"
Time in VBA Part#1 – Japanese Clocks
Hi guys, here is a simple file with a bunch of clocks. The code is very basic and the whole workbook is fully open so you can see how it’s done. All the spread sheet calculations are contained in the upper left corner and the VBA code is just few lines long. Click the “Run-Pause Clock” button to start or pause… Read More... "Time in VBA Part#1 – Japanese Clocks"
A Game of Tetris in Excel
Hi there, this is a Tetris game I made in Excel two years back. To start or to pause, click the yellow “sun” icon in the upper right corner of the chart. You can adjust the game level on the top side of the chart and also change the landscape by clicking “Landscape” on the bottom right. The landscape will… Read More... "A Game of Tetris in Excel"
Dynamic Macros #1
Hi everybody, Today we’ll talk about dynamic macros very useful in engineering modeling, scientific modeling, games etc. Dynamic macros are created using two different type of loops: “For” and “Do”. – Two different but equivalent conditional “Do” loops are explored. – It is shown that macros can be assigned to drawing shapes, pictures, graph, etc. – A highly valuable Run/Pause macro… Read More... "Dynamic Macros #1"
RLC-Parallel
This RLC parallel circuit model has several sound effects so it must be dearchived in the same subdirectory. [sociallocker][/sociallocker] Read More... "RLC-Parallel"
Resizing, Translating and Rotating Shapes in Excel
Five different shape alterations are presented: 1. Resizing – which can be done independently on each axis by multiplying the coordinates by a certain factor while the shape is centered in the origin. 2. Translation – which can be done independently on each axis by adding or subtracting a term to each coordinate. 3. Simple rotation – formulas were derived… Read More... "Resizing, Translating and Rotating Shapes in Excel"