Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

7
  • $\begingroup$ You haven’t shown the Excel formulas for the velocity or position. Are you using the acceleration calculated in B4? If so, that’s only the initial acceleration. $\endgroup$
    – Ghoster
    Commented Apr 22, 2023 at 5:20
  • $\begingroup$ @ghoster oh yes, the acceleration must be recalculated every step. i will update. $\endgroup$
    – James
    Commented Apr 22, 2023 at 5:23
  • $\begingroup$ The balls separated by 1 meter will hit each other in 2.93 days. The earth and the sun in the same situation will hit in 65.05 days. $\endgroup$
    – James
    Commented Apr 22, 2023 at 11:41
  • $\begingroup$ @James hi, can I have your excel file please ? I'm not very good at excel $\endgroup$
    – Michael
    Commented Apr 22, 2023 at 14:33
  • 1
    $\begingroup$ @James 2.93 days This agrees with the analytic formula. $\endgroup$
    – Ghoster
    Commented Apr 22, 2023 at 16:05