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.          Continue 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

This post shows the steps for building a first model of a single pole RC high pass filter (HPF) in Excel based on numerical solution using the finite difference method. It is quite elementary to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 2 (1-Pole High Pass Filter) Numerical Solutions to Differential EquationsContinue 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

This post shows the steps for building a first model of a single pole RC low pass filter (LPF) in Excel based on numerical solution using the finite difference method. It is quite easy to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 1 (1-Pole Low Pass Filter) – Numerical Solutions to Differential Equations (Finite DifferenceContinue 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

This is a static Lissajous emulator in the sense that the waveform is obtained by combining 2 static sinusoidal waves with different frequencies. As a parenthesis, I will be preparing a dynamic version which will look just like the wave shape seen on a real oscilloscope. The file presented here has two different worksheets, the first one contains a classic 2DContinue Reading