Longitudinal Aircraft Dynamics #4 – virtual aircraft definition

05/27/2011

This section of the tutorial explains how to create the  2D aircraft components for the animated longitudinal stability model. The first part deals with extracting the x-y coordinates for the fuselage, canopy, vertical stabilizer and rudder. The second part handles the main wing airfoil and the horizontal stabilizer airfoil. All thses parts will be put together in the next section. [sociallocker][/sociallocker]

Read More >>

VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #2

05/15/2011

The first macro created in this section of the tutorial improves on the previously developed macro by correcting the up-down orientation of the shape, referencing the shape position to the coordinate of the first drawn point and closing the shape by repeating the coordinates of the first point at the end of the table. A last macro is then created which can retrieve multiple shape vertex coordinates, placing them in a table…

Read More >>

VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #1

05/14/2011

Using autoshape freeforms is a very easy way to duplicate object outlines from pictures. It is convenient to create a freeform and once created, its vertices (points) can be edited with without difficulty.  Aditional points can be inserted and others can be deleted. This is a tutorial about a series of macros which allow the extraction of freeform vertex coordiantes to a worksheet range in Excel. These coordinates can be later employed to create 3D wireframe…

Read More >>

How to make a game of PONG in Excel – part #10 – final

03/08/2011

The previous section explained the VBA upgrades needed to make the score functional and new-game and end-game sound effects were added. This tutorial shows how fix some previous bugs and create a “demo play” option which means that both bats are automatically run by worksheet logic. This is the final part of the of the Pong tutorial series. [sociallocker][/sociallocker]

Read More >>

How to make a game of PONG in Excel – part #9

03/07/2011

The previous section explained how to add a game score in the upper part of the pong court. This section (which is a continuation of part#8) will explain the VBA upgrades needed to make the score functional.  We will add here new-game and end-game sound effects too. Next tutorial will explain how to create a “demo play” option which means that both bats will be automatically run by worksheet logic. [sociallocker][/sociallocker]

Read More >>