Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions

02/02/2011

     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-dimenssional 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 scratch. In the previous 3D perspective tutorials we took…

Read More >>

3D-2D Perspective Mapping in Excel – part #2

01/31/2011

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 of depth because our both eyes see the same image….

Read More >>

3D-2D Perspective Mapping in Excel – part #1

01/31/2011

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 monitor, a screen, or the retina of the eye). This tutorial…

Read More >>

A Virtual Joystick – How Can You Make That ? – tutorial

01/31/2011

Hello everybody, this is a tutorial in which a virtual  Excel joystick controlled by mouse movements on a scatter chart has been demonstrated . While in operation, a macro updates the coordinates of the pointer in two spreadsheet cells. The two coordinates are then incorporated in formulas which limit the range of motion of the joystick. Just like a real device the stick head movement is confined within a square (with a side…

Read More >>

Writing Excel User Defined Functions in VBA – part #2 – time stamping, concatenating date and text while maintaining the date format

01/19/2011

Hi Folks, there are many available built-in spreadsheet functions in Excel. Ocasionaly one might need to write a special custom function. This second short tutorial is an introduction to that.  Creating a “Time Stamp” function is presented as a first example after which a concatenation function between a custom formatted date and a string (text) is introduced. This last function came about from a question I was asked by a finance person at…

Read More >>

Writing Excel User Defined Functions in VBA – part #1 – the distance function

01/14/2011

There are many available built-in spreadsheet functions in Excel. Ocasionaly one might need a very special custom function. This short tutorial is an introduction about how to write a user defined function which calculate the distance between two points in a cartesian plane. The topic will be continued and custom functions will occasionally be used in future models. We’d love to hear from you. [sociallocker][/sociallocker]

Read More >>

Digital Clock Model – an Excel 2007 adaptation

01/07/2011

Hello!  Due to some incompatibility, I re-adjusted the old digital clock for the 2007 version of Excel. In Excel 2003 or earlier if you click on a chart point twice (with a certain delay between clicks) you can paste a picture and have the data point actually convert into that picture. In 2007 the same trick works but somehow the picture expands by something like 20%, which makes a lot of…

Read More >>

Game of PONG #2

01/05/2011

Hi there, this is a better version of Pong, in which you play with a virtual opponent. It does not have a score board yet and the opponent is theoretically unbeatable. I will be improving it further. Excel 2007 is quite slow on this one. In order to get maximum speed out of Excel 2007 make sure you zoom in as much as possible so only the chart and no calculation is visible while you…

Read More >>

Game of Pong #1 – a dynamic training box with sound effects

01/02/2011

Hi folks, this is a “practice box” for pong. The green button will “Start-Stop” the model and will also link the mouse to the bat (racket) for game control . The bat control is very smooth and quick and no mouse clicking is necessary. The red “Serve” button will shoot a new ball when you loose the old one (you don’t need to stop the model while re-serving).  You can adjust the “bat size”, “stroke”…

Read More >>