Hello everyone, 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 realContinue Reading

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 fromContinue Reading

There are many available built-in spreadsheet functions in Excel. Occasionally 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 loveContinue Reading

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 macroContinue Reading

Most parameters used in animations or physical models are changed by buttons called “spin buttons”. Excel is a spreadsheet but behind the table there is a engine used to automate certain spreadsheet functions. This engine can be programmed in a language with a very easy syntax called Visual Basic for Applications, in short VBA. VBA is a very convenient featureContinue Reading

Hello everyone, I’ve been into flying wings since 2000 when I bought a Zagi online. As piloting style I can compare a flying wing to a snowboard ->> COOL. After abusing it greatly, I ended up mounting a couple of small Russian Norvel glow engines on it and eventually I had to bury it, since it became a pack of crumpled styrofoam. In 2005 I built another wing out of packaging tapeContinue Reading