A Realistic Looking Digital Clock Model

12/12/2010

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 learned a lot while making it and I need to prepare a…

Read More >>

Time in VBA Part#1 – Japanese Clocks

12/05/2010

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 the VBA clocks. All the of them will display your local…

Read More >>

Dynamic Macros #1

11/30/2010

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 is described and implemented. The reader must pay close attention…

Read More >>

Resizing, Translating and Rotating Shapes in Excel

11/15/2010

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 for rotation of a shape centered in origin by a…

Read More >>

Introduction to Numerical Methods – Basic Filters #2

11/09/2010

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 elemetary to undersand, try to go through the proof regardless of your background. [sociallocker][/sociallocker]

Read More >>

Static VBA Macros

11/02/2010

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 feature in Excel and it can be used almost without any…

Read More >>

Introduction to Numerical Methods – Basic Filters #1

10/22/2010

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 elemetary to undersand, try to go through the proof regardless of your background. [sociallocker][/sociallocker]

Read More >>

Drafting an RC Flying Wing in Excel

10/01/2010

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 tape and  foam (see below). I’ve been dreaming of a build-up…

Read More >>