Page **1** of **2**

### I made Gravity Simulations in Excel

Posted: **Thu Dec 28, 2017 6:41 pm**

by **AlternateGravity**

I figured out how to simulate orbital motion in Excel using time step increments, formulas, and graphs.

I started by simulating orbital motion using the inverse square law

- First Year Inverse Square Law Orbit.png (135.78 KiB) Viewed 7014 times

- Every Year Inverse Square Law Orbit.png (153.15 KiB) Viewed 7014 times

I also simulated an orbit using the Linear Law

- Every Year Linear Law Simulation.png (162.51 KiB) Viewed 7014 times

### Re: I made Gravity Simulations in Excel

Posted: **Thu Dec 28, 2017 6:45 pm**

by **AlternateGravity**

### Re: I made Gravity Simulations in Excel

Posted: **Thu Dec 28, 2017 6:49 pm**

by **AlternateGravity**

### Re: I made Gravity Simulations in Excel

Posted: **Thu Dec 28, 2017 6:51 pm**

by **AlternateGravity**

### Re: I made Gravity Simulations in Excel

Posted: **Thu Dec 28, 2017 6:54 pm**

by **AlternateGravity**

Finally I simulated orbital motion using the inverse factorial law

- First Year Inverse Factorial Law Simulation.png (134.71 KiB) Viewed 7012 times

- First through Fourth Year Inverse Factorial Law Simulation.png (312.04 KiB) Viewed 7012 times

### Re: I made Gravity Simulations in Excel

Posted: **Sat Dec 30, 2017 11:44 am**

by **AlternateGravity**

I did some more of the simulation using the inverse cube law

- First though Third Spiral inverse cube Law Simulation.png (153.86 KiB) Viewed 7009 times

Also these are the excel files I used. I had to shrink them down to the minimum amount of information needed to replicate the data needed for the graphs as when I had them filled to row 300000 they were to big to attach. You can simulate orbits, using these excel files, by filling from Row three to Row 300000.

### Re: I made Gravity Simulations in Excel

Posted: **Sat Dec 30, 2017 11:48 am**

by **AlternateGravity**

Unfortunately I could not attach the factorial law and inverse factorial law simulation.

### Re: I made Gravity Simulations in Excel

Posted: **Sat Dec 30, 2017 1:31 pm**

by **AlternateGravity**

To help with replicating the factorial law simulation for Row 2 Increments=0.00000025, X-Position of Planet=9.00, Y-Position of Planet=0, X-Velocity of Planet=0, and Y-Velocity of Planet=6000.

To help with replicating the inverse factorial law simulation for Row 2 Increments=0.00005, X-Position of Planet=2.70, Y-Position of Planet=0, X-Velocity of Planet=0, and Y-Velocity of Planet=6.

To help with replicating both simulations; In Row 2 the mass of the planet and the mass of the star is the same as in the other simulations, the position and velocity of the star are the reverse of the position and velocity of the planet divided by 10000, and the time passed is 0. In Row 3 the formulas for the positions, velocities, increments, and time passed, and masses use the same formulas as in the other simulations. Also the formula for x! in excel when x may not be an integer and when x is positive is x*EXP(GAMMALN(x)). Also I used ten graphs with the first graph going from B2 to C30000, the second graph going from B2:C60000, the third graph going from B2:C90000, and so on to the tenth graph.

### Re: I made Gravity Simulations in Excel

Posted: **Tue Jan 02, 2018 2:40 pm**

by **AlternateGravity**

I did some more simulations using excel starting with a simulation of a hyperbolic "orbit" using the inverse square law

- Inverse Square Law Hyperbole Simulation.png (72.14 KiB) Viewed 6991 times

I also simulated orbital motion using the Sin Law

- First Year Sin Law Simulation.png (152.56 KiB) Viewed 6991 times

- First through Sixth Year Sin Law Simulation.png (324.73 KiB) Viewed 6991 times

### Re: I made Gravity Simulations in Excel

Posted: **Tue Jan 02, 2018 2:45 pm**

by **AlternateGravity**