Hi folks, as a continuation to the previous tutorial here is a 3-body planetary model where the solution to the equations is contained in a static form, as a lookup table (I previously called it a “pure spreadsheet solution”).
The model is static in the sense that after any parameter is changed, the solution data remains unchanged in a table until a new parameter is updated by the user. The display is dynamic however since an “Offset()” function will selectively collect data from the table, which data is being displayed on a 2D scatter chart.
A very basic VBA routine is used to generate a counter. The output of the counter is pasted “real-time” in cell “AD30” (called “Increment”). This counter output data is used by the offset function to display a dynamic sequence of the planets’ coordinates on the chart, which gives the illusion of planet movement.
This is a more crude model than the “sequential” models described previously and it has a limited run length (in this particular case 30000 time steps). Click “Demo” to run through a series of setups or “Run” to experiment with your own setup.
This is one of my first Newtonian models, and I did it in the fall of 2008 out of boredom while on a contract in Phoenix. The file is a .zip archive so you need to save it first. Do you have something to say?
I’d love to hear from you so leave me a comment below.