Radiation belt transit times to GEO and the Moon

LibreOffice spreadsheet here

Excel/97 version here. Not sure whether this will work with your version of Excel, this is the translation made by LibreOffice, and I don't have any computers that run any of the myriad versions of Windoze or Excel.

LibreOffice is available for free download here.

I used the equations here on the server sky website.

• 1 - from the altitudes and Earth's equatorial radius, compute radii
  • assume all source and destination orbits are circular equatorial. Inclined orbits require expensive plane changes after circularization.
• 2 - Given apogee and perigee and the Earth gravitational parameter, compute
  • Semimajor axis
  • Eccentricity
  • Orbit angular velocity
• 3 - Given the radius of the lower and upper bounds of the inner belt (altitudes 200 and 1000 km), compute
  • true anomaly angle
  • eccentric anomaly angle
  • mean anomaly angle
• 4 - from the difference in the mean anomaly angles and the orbital angular velocity, compute transit time

Conclusion: a Hohmann transfer orbit from ISS altitude to GEO takes 21.8 minutes to pass through the inner van Allen belt, and 18.2 minutes to pass through the inner belt on the way to the Moon.