Gaarst

Orbits calculator spreadsheet

Recommended Posts

This probably already exists but I wanted to see what I remembered of Excel (this didn't really test anything but, for once, I've produced something useful).

It basically calculates 4 things:

  1. Delta-V from a circular orbit to another circular orbit;
  2. Delta-V from a circular orbit to an elliptical transfer orbit;
  3. Circular orbit that can be reached from a circular orbit using a given amount of dV;
  4. Transfer orbit that can be reached from a circular orbit using a given amount of dV.

It works both ways: from lower to higher orbit and vice-versa. Retrograde burns will be indicated by negative dV (going opposite direction of motion).

It is set as default for Kerbin (I wrote it for RSS Earth and the values seemed sensible so I think it's correct, I won't take responsibility for missions failing because of erroneous calculations) but you can easily adapt it for any planet by changing the planet µ and radius which can both be accessed from the Tracking Station.

Since I can't solve transcendental equations (or be bothered checking that they are actually transcendental for that matter), the last two calculations require the "Solver" function of Excel which might not be installed by default but is free AFAIK. If you don't have it, you can just trial-and-error your way through using the first two calculators (this is basically what the Solver does anyway only automatically and using fancy numerical analysis methods).

The spreadsheet should contain enough instructions for you to be able to use it. If not, just ask.

Download link (.xslx file written on Excel 2013)

(This isn't really a tutorial but I think it fits in the section, if not, just say it and I'll ask for it to be moved wherever)

Edited by Gaarst

Share this post


Link to post
Share on other sites
This thread is quite old. Please consider starting a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.