Details on the latest Microsoft Excel® Workbook Orbital Dynamics Calculations v11.3.2 can be found below.
Login here for current subscribers to download updates and new users to download the workbook, which is now being provided free of charge to anyone for non-commercial personal use.
The current version has only been tested using the Microsoft Windows® operating system and using Microsoft Excel 2007® and newer with Google Earth™.

Links to basic instructions on the use of the workbook can be found at the bottom of this page.

Used with permission from Microsoft.

The main tab is titled "Satellites". From here you can view the currently selected group of satellites and choose pull-down's for any other group of satellites. Choosing "Run" will generate the KML group at set intervals. Selecting "Single" will generate the KML for the chosen satellite and place a link on your desktop.

When the "Single" KML is selected, Google Earth™ will open showing the satellite's location, field of regard (FOR) if chosen, the satellite's path, and the chosen ground site. A "Use Multiple Ground Sites" option is available if you desire to show more than one ground site. Multiple ground sites can be selected from the hidden "Multiple_Ground_Sites" tab. You can choose from approximately 1500 worldwide ground sites currently available in the workbook.

Single View
Google and the Google logo are registered trademarks of Google Inc., used with permission.

The view of the satellite will show the satellite image or model, if available, the orbit path, and the FOR cone (if chosen). Other options for Single, Multiple, or Constellation include generating SATRAN (Satellite Reconnaissance Advance Notice) views at the next time the satellite is in view of the chosen ground site, including generating a CSV file of up to the next 10 days of views over the chosen ground site, generating fixed (accounting for rotation of the Earth) and inertial (disregarding Earth's rotation) orbit views, and generating the path forward or reverse from either the current time, epoch time, or from any other desired time (chosen from the "Date_and_Time" tab).

Used with permission from Microsoft.

You can also choose to only view operational satellites by choosing the appropriate check box.

Additionally, you may pull-down a group of satellites, or constellation, and then create that specific group. GPS is shown below, linked to Colorado Springs, CO, by cones that show which satellites are in view of the chosen ground site at the time that the KML was created.

Constellation View
Google and the Google logo are registered trademarks of Google Inc., used with permission.

From here you can view each individual satellite in the group and pull-up various information on the satellite.

Used with permission from Microsoft.

Similarly, by choosing Multiple on the "Satellites" tab you can generate any combination of satellites up to 32 as shown here (selected from the "Multiple_Pull_Down" tab).

Used with permission from Microsoft.

An additional function on this tab is to conduct a search for any satellite, or group of similarly named satellites (i.e. NAVSTAR) from the downloaded TLE information. Satellites found will be imported into the tab, to be generated if desired.

Used with permission from Microsoft.

Of interest to some users may be the ability to pull-down information on various other central bodies (instead of the Earth). These include Solar System central bodies (i.e. the Sun) as well as fictional central bodies as used in the popular game Kerbal Space Program™. From the "Orbital_Mechanics" tab choose the central body of interest to view orbital parameters, including velocity (useful for conducting orbital maneuvers in the game). Generating these orbits is not available because there is no way to actually show these other central bodies correctly in Google Earth™.

Other options on this tab include calculating Delta-V (change in Velocity) for Hohmann Transfer Maneuvers as well as calculating time of transfer burn, mass of initial two stages following separation, etc. You may also generate a KML of the hypothetical Hohmann Transfer, if desired.

Used with permission from Microsoft.

I've built into the workbook many other functions not mentioned here (see complete catalog screenshot below). The ideas keep flowing so this is perpetually a work in progress. If you think of something that would be cool to see, let me know and maybe I can incorporate it into the project.

In short I created this workbook to display a wide variety of useful information for the amateur astrodynamicist. I've committed countless untold hours toward this and I believe that you will be very satisfied with it. If you have any questions about what other options are available for creation, or just want to know more about Orbital Mechanics or how I did all of this, please let me know. I can be reached at

Google and the Google logo are registered trademarks of Google Inc., used with permission.

Demonstration and Instructional Videos

00. Capabilities Demonstration
01. Basic Instructions to setup and get started
02. Single Satellite Modification Options
03. Single Satellite Orbit Options
04. Single Satellite Propagation Options
05. Single Satellite Perturbation Options
06. Multiple Object Options
07. Single Ground and Radar Options
08. Multiple Ground and Radar Options
09. Constellation Group Options
10. Search Functions
11. Date and Time Functions
12. SATRAN Options
13. Conjunction Analysis
14. Custom Objects and Walker Constellations
15. Launch Windows and Maneuvers
16. Communications Relays
17. Using Models

Back to top