TestTubeGames Forums • I made Gravity Simulations in Excel - Page 2

Page 2 of 2

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 2:49 pm

by AlternateGravity

: Every Year Tangent Law Simulation.png (250.89 KiB) Viewed 16029 times

I also simulated orbital motion using the secant law

: First Year Secant Law Simulation.png (134.83 KiB) Viewed 16029 times

: First through Third Year Secant Law Simulation.png (227.16 KiB) Viewed 16029 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 2:54 pm

by AlternateGravity

: Every Year Secant Law Simulation.png (258.56 KiB) Viewed 16029 times

I also simulated orbital motion using the Exponential Law

: First Year Exponential Law Simulation.png (147.89 KiB) Viewed 16029 times

: First through Second Year Exponential Law Simulation.png (205.37 KiB) Viewed 16029 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 2:59 pm

by AlternateGravity

I also simulated orbital motion using the Exponential Decay Law or Inverse Exponential Law

: First Year Inverse Exponential Law Simulation.png (147.63 KiB) Viewed 16029 times

: First through Fourth Year Inverse Exponential Law Simulation.png (305 KiB) Viewed 16029 times

: Every Year Inverse Exponential Law Simulation.png (298.77 KiB) Viewed 16029 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 3:06 pm

by AlternateGravity

I also simulated orbital motion using the Natural Log Law

: First Year Log Law Simulation.png (109.67 KiB) Viewed 16029 times

: Every Year Log Law Simulation.png (389.82 KiB) Viewed 16029 times

Finally I simulated orbital motion using the Natural Log Law at extremely close range

: First Year Log Law Closer Simulation.png (146.03 KiB) Viewed 16029 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 3:10 pm

by AlternateGravity

: Every Year Log Law Closer Simulation.png (356.91 KiB) Viewed 16029 times

Also these are the excel files I used for these simulations

Sin Law Simulation.xlsx: (63.09 KiB) Downloaded 797 times

Tangent Law Simulation.xlsx: (63.32 KiB) Downloaded 807 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 3:12 pm

by AlternateGravity

Secant Law Simulation.xlsx: (65.05 KiB) Downloaded 828 times

Exponential Law Simulation.xlsx: (62.62 KiB) Downloaded 821 times

Inverse Exponential Law Simulation.xlsx: (62.25 KiB) Downloaded 851 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 3:16 pm

by AlternateGravity

Log Law Simulation.xlsx: (62.64 KiB) Downloaded 825 times

Log Law Closer Simulation.xlsx: (63.21 KiB) Downloaded 826 times

Inverse Square Law Hyperbole Simulation.xlsx: (30.92 KiB) Downloaded 833 times

Re: I made Gravity Simulations in Excel

Posted: Tue Jan 02, 2018 4:07 pm

by testtubegames

Whoa - a neat use of Excel! I think natural log is my favorite so far.