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

3-Body Planetary System with Options

Planetary model
10/08/2010

Here is a 3-body system with 3D graphics. I made it about 2 years ago but I’ve been updating it lately. This model  works at about 30 frames/second in Excel 2003 on a modern PC. In Excel 2007 it will run 10-15 times slower. I know 2010 is a lot faster than 2007. I’ve just bought a legit copy from<technicallysolutions.com> for 50$ but I didn’t have a chance to install it yet. I need to add  few more…

Read More >>