[Excel/Online] KSP 64k Orbital Calculator

[westamastaflash]

I made a spreadsheet to help calculate various things in the 6.4x Sized Kerbin (The "64k" version with a 24 hour kerbin day).

It could be used for any star system, if you enter the orbital data.

All "input values" are shaded in brown.

This is a constant work in progress.

View/Download on OneDrive here. You should be able to use it in your own Excel Online as well.

Details for each tab:

"Constants" - has the orbital parameters of the various bodies in the system.

"Useful Orbits" - Some common orbits I find myself using often. Note that "safe pe" for the highly eccentric orbits is a minimum of the Atmo+5 or 15 km. Safe may be higher or lower depending on your celestial body.

"Orbital Period and SMA" is a set of calculators that give the orbital parameters when given a ap/pe, a SMA, or a orbital period (+ optional ap/pe)

"Hohmann Transfer" computes the delta v requirements for each stage of the transfer, the transfer time, as well as the slide phase time and slide phase angle, which is useful for positioning a satellite behind or in front of another in the same orbit.

"Surface Longitude Change" tries to calculate the appropriate target apside in order to arrive at the target longitude on the next orbit. I'm not sure I have this working right yet though.

"Body Distance" gives a very, very rough estimate of the minimum and maximum possible distances between two celestial bodies, which assumes complete circular orbits (obviously wrong with moho). I just use it to help me estimate the appropriate remotetech dish I need.

"RemoteTech" has a vessel EC requirement calculator given darkness time (which can be calculated for a circular orbit in the Orbital Period and SMA tab). It also includes a Cone Calculator which tells you how far away you need to be from a specific body in order to cover that body (or a specific altitude above that body), with a specific dish. Also, if you use MultipleAntennaMultiplier, you can set it and it will tell you how far out your omnis will go.

"TAC" is in progress. I'm working on a comprehensive calculator for TAC life support (including possibly simulating the generators over time) which will eventually end up here, I hope.

"DataForMapSatAltitude" and "ScannersForMapSatAltitude" are for inputs into the MapSatAltitude script's text files to help generate the scansat charts, tables, and graphs.

Edited February 27, 2015 by westamastaflash