I made Gravity Simulations in Excel

What did you draw?
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

I made Gravity Simulations in Excel

Post 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
First Year Inverse Square Law Orbit.png (135.78 KiB) Viewed 15161 times
Every Year Inverse Square Law Orbit.png
Every Year Inverse Square Law Orbit.png (153.15 KiB) Viewed 15161 times
I also simulated an orbit using the Linear Law
Every Year Linear Law Simulation.png
Every Year Linear Law Simulation.png (162.51 KiB) Viewed 15161 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

Every Year Linear Law Simulation.png
Every Year Linear Law Simulation.png (162.51 KiB) Viewed 15159 times
I also simulated orbital motion using the inverse law
First Year Inverse Law Simulation.png
First Year Inverse Law Simulation.png (128.83 KiB) Viewed 15159 times
First through Seventh Year Inverse Law Simulation.png
First through Seventh Year Inverse Law Simulation.png (357.74 KiB) Viewed 15159 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

Every Year Inverse Law Simulation.png
Every Year Inverse Law Simulation.png (355.26 KiB) Viewed 15159 times
I also simulated the spiral orbits of the inverse cube law
First Spiral Inverse Cube Law Simulation.png
First Spiral Inverse Cube Law Simulation.png (154.34 KiB) Viewed 15159 times
First through Second Spiral Inverse Cube Law Simulation.png
First through Second Spiral Inverse Cube Law Simulation.png (336.31 KiB) Viewed 15159 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

I also simulated orbital motion using the factorial law
First Year Factorial Law Simulation.png
First Year Factorial Law Simulation.png (157.17 KiB) Viewed 15159 times
First to Second Year Factorial Law Simulation.png
First to Second Year Factorial Law Simulation.png (211.67 KiB) Viewed 15159 times
Every Year Factorial Law Simulation.png
Every Year Factorial Law Simulation.png (308.88 KiB) Viewed 15159 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

Finally I simulated orbital motion using the inverse factorial law
First Year Inverse Factorial Law Simulation.png
First Year Inverse Factorial Law Simulation.png (134.71 KiB) Viewed 15159 times
First through Fourth Year Inverse Factorial Law Simulation.png
First through Fourth Year Inverse Factorial Law Simulation.png (312.04 KiB) Viewed 15159 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

I did some more of the simulation using the inverse cube law
First though Third Spiral inverse cube Law Simulation.png
First though Third Spiral inverse cube Law Simulation.png (153.86 KiB) Viewed 15156 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.
Inverse Square Law Ellipse Simulation.xlsx
(41.47 KiB) Downloaded 540 times
Linear Law Simulation.xlsx
(36.02 KiB) Downloaded 553 times
Last edited by AlternateGravity on Tue Jan 02, 2018 3:18 pm, edited 1 time in total.
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

Inverse Law Simulation.xlsx
(64.53 KiB) Downloaded 588 times
Inverse Cube Law Simulation.xlsx
(64.21 KiB) Downloaded 570 times
Unfortunately I could not attach the factorial law and inverse factorial law simulation.
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post 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.
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post 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
Inverse Square Law Hyperbole Simulation.png (72.14 KiB) Viewed 15138 times
I also simulated orbital motion using the Sin Law
First Year Sin Law Simulation.png
First Year Sin Law Simulation.png (152.56 KiB) Viewed 15138 times
First through Sixth Year Sin Law Simulation.png
First through Sixth Year Sin Law Simulation.png (324.73 KiB) Viewed 15138 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
AlternateGravity
Posts: 80
Joined: Thu May 15, 2014 5:45 pm

Re: I made Gravity Simulations in Excel

Post by AlternateGravity »

Every Year Sin Law Simulation.png
Every Year Sin Law Simulation.png (312.4 KiB) Viewed 15138 times
I also simulated orbital motion using the Tangent Law
First Year Tangent Law Simulation.png
First Year Tangent Law Simulation.png (177.38 KiB) Viewed 15138 times
First through Second Year Tangent Law Simulation.png
First through Second Year Tangent Law Simulation.png (256.33 KiB) Viewed 15138 times
Gravitons would be my favorite particle as their existence could prove extra dimensions.
Post Reply