Static VBA Macros


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…


3-Body Planetary System with Options

Planetary model

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<> for 50$ but I didn’t have a chance to install it yet. I need to add  few more…