Ephemeris Tool 4.5 Excel



Alcyone Ephemeris 4.3 is an accurate and fast astronomical ephemeris calculator covering the period 3000 BC to AD 3000. It calculates heliocentric, geocentric, and topocentric positions of the Sun (Earth), planets, 18 natural satellites, and small bodies (minor planets and comets) in ecliptical, equatorial, and horizontal coordinates, with optional corrections for parallax and refraction. How to Make Normal Distribution Graph in Excel? Normal Distribution Graph in Excel. Normal distribution graph in excel is a continuous probability function. It is a common method to find the distribution of data. A formula has been found in excel to find a normal distribution which is categorized under statistical functions.

Ephemeris Tool 4.5 Excel Spreadsheet

  • Additional Swiss ephemeris data in excel selection. Kutools for Excel. Kutools provide more than 300 advanced functions and tools for MS Excel through its toolbar addon. It allows you to easily combine worksheets, merge cells without losing data, paste to only visible cells, etc. Its Enhanced Edit Bar will enhance the formula bar and display.
  • Use Excel spreadsheet templates for tracking to conveniently record and tally your business expenses. Microsoft even provides free planner templates and tracking templates for many of your favorite hobbies or to help streamline activities like vacation prep and meal plans. Plan like a pro with Office planner templates.
  • The daily GPS broadcast ephemeris file is a merge of the individual site navigation files into one, non-redundant file that can be utilized by users instead of the many individual navigation files. The daily file created at BKG each day contains unique navigation messages from sites in Europe.

This page lists various fan-made tools that can help calculations related to the gameplay of Kerbal Space Program. Unlike addons, they do not directly influence the game, as they are run separately.

The table cells that are shaded blue are links to the KSP Forums, to indicate open source tools and compatibility with the latest version of KSP. Conversely, tools who's last known compatible version is too far into the past are shaded red as are non-free tools and websites gone missing.

The KSP forums have a section dedicated to such tools here, which is where it is most likely that new tools and versions will be announced.

  • 1Online tools and calculators
  • 2Offline applications
  • 3External tools not directly related to KSP

Online tools and calculators

Orbit and maneuver calculators

Title Developer Description Last Update KSP Version compatibility [note 1] Notes Forum post Link
Sat-Net Spacing Calcjwarner87 Calculates deployment orbit for an evenly spaced satellite network in a single launch bundle. Supports alternate sized solar systems. 24 April 2016 1.0.5 Based on Ens-Gijs spreadsheet.https://jwarner3412.github.io/kerbility/
Interactive illustrated interplanetary guide and calculatorOlex Calculates Δv and angles for orbital transfer between celestial bodies 2013 0.22 Based on this forum postforum posthttp://ksp.olex.biz/
Launch Window Planneralexmoon Provides a total Δv calculation for orbital transfer based on launch parameters 6 Apr 2014 0.23.5open source

(License: CC BY-NC-SA 4.0)

forum posthttp://alexmoon.github.io/ksp/
KSP Aerobraking Calculatoralterbaron Calculates a maneuver to perform the intended aerobraking 20 Nov 2013 0.90open sourceforum posthttp://alterbaron.github.io/ksp_aerocalc/
Kerb CalculatorAbeck Calculates Δv based on fuel remaining in stage. Really useful if you're already in flight. New coming soon! 06 Feb 2016 (V0.2) 1.0.5MATLAB .m fileforum post Get it at the forum post
Lead angle calculatorTuupertunut Calculates the lead angle to reach a target orbit 6 Sept 2018https://instacalc.com/51180
Resonance orbit calculator Calculates periapsis based on orbit height and the requested orbital resonance based on wiki information and this forum posthttp://www.ksp.interrutt.com/

Simple Orbital calculating spreadsheet

drewmacrae Detailed calculation spreadsheet for Hohmann transfer orbits 21 Mar 2012 See forum post for usage detailsforum postGoogle Docs link
Browser based orbit calculatorcjameshuff Interactive orbit shape and property calculator 18 Jul 2011forum posthttp://files.arklyffe.com/orbcalc.html
Satellite Deployment CalculatorEns Gijs Makes precisely deploying evenly spaced satellites easy! 8 Aug 2015 Protected spreadsheet, you are free to edit any YELLOW fields.Google Docs link
KSP Orbital Sooper Calculatormadbadger2742 Mutli-functional calculator including satellite arrangements 4 Dec 2013 Google Docs spreadsheet - Usage details on the first page of the spreadsheetforum postGoogle Docs link
Orbit Night/Darkness, Req. Battery Capacity, Satellite Relay CoveragePeppe Calculate orbital darkness time and corresponding battery capacity needed 9 Oct 2013 Google Docs spreadsheetforum postGoogle Docs link
KSP Un-Orbiter CaclulatorSharpCoder Calculate roughly when to burn retrograde to achieve the most efficient landing 20 Oct 2016forum posthttp://sharpcoder.github.io/KspUnorbiter/

Part and construction calculators

Title Developer Description Last Update KSP Version compatibility Notes Forum post Link
Reusable Rocket Calculatorcy4n Calculates the cost to put 1 ton of payload into orbit on any given launcher. 31 Oct 2016 1.2 Google Docs spreadsheetGoogle Docs link
Rocket Calculatoravylazyboy Calculates and saves values for DeltaV, Isp, Thrust, and TWR for multi-stage rockets 7 July 2016 1.1.3 Open Source, written in C#forum posthttps://github.com/AveryPratt/RocketCalculator
kspalculator Determines the best rocket propulsion designs for one stage of a rocket, given a set of constraints and preferences 8 Aug 2016 1.3Open Source, written in Pythonforum posthttps://kspalculator.appspot.com/
KSP Optimal Rocket CalculatorGaryCourt Generates a rocket design optimized for the given parameters 6 May 2015 1.2open source (License: permissive)forum posthttp://garycourt.github.io/korc/
KSP Parachute Calculatorcheck Calculates the needed mass and type of parachutes for landers 19 Sep 2013 0.21.1forum posthttp://ksp.freeiz.com/
Engine Cluster Calculatorblizzy Generates an engine layout for a given payload (asparagus staging) 8 Apr 2014 0.23.5 Based on this forum posthttp://blizzy.de/asparagus/
KSP Calculator Cameron Hessler Escape velocity and stage Δv calculators 2012 0.16http://www.kerbalspacecalculator.net16.net/index.php
Thrust calculator Calculate TWR based on engines, fuel, payload and gravityhttp://iyates.co.uk/ThrustCalc/
KSP Plannereschatonic Staged rocket planner and Δv calculator 0.22reddit posthttp://dhmholley.co.uk/ksplanner/
Craft FixerEzriilc Fixes duplicate ids in .craft files and can optionally remove add-on parts 27 Apr 2015 1.0forum posthttp://www.kerbaltek.com/craftkitchen
Delta-V CalculatorJellyGoggles Calculates Δv per stage 15 Feb 2012 0.13.2 Google Docs spreadsheetforum postGoogle Docs link
Optimal Single-stage Lander Design Tooltavert Calculates engines and fuel needed for a single-stage landed based on payload 14 Dec 2013 Wolfram-based (Requires Wolfram CDF Player Plugin)forum postdropbox (.html)

Science

Title Developer Description Last Update KSP Version compatibility Notes Forum post Link
KSP Science Calculator Calculates amount of science gained in different environments 0.23 (see notes) data based on the wiki article on science - Does not include Kerbol (16-04-2014)reddit postGoogle Drive link
Remaining Scienceacalculus Reads save file and displays remaining science for all celestial objects and experiments in a large table 5 May 2014 0.23.5open sourceforum posthttp://kerbal-science-remaining.s3-website-us-east-1.amazonaws.com/
Simple Science SummaryOarc Provides an overview of science done and remaining based on a save file and science definitions file - support for mods that affect science [WIP] 27 Mar 2014 0.23.5 open source (entirely client-side javascript) [note 2]forum posthttp://oarcinae.us/ScienceParser/kspScienceParser.html
Science Checklistcelem Generates a table for each celestial body showing what science is available 6 Mar 2014 0.23.5 open source (entirely client-side javascript) (License: customized BSD, see forum post)forum posthttp://www.celemsoft.net/kspsci.html
KSP Checklist Generatornobody44 Generates an simple online mission checklist including science gathering 14 Feb 2014 0.23 (version agnostic)open source (License GPL v3)forum posthttp://pweingardt.github.io/kspchecklist/
Printable Complete Stock Science ChecklistsJAFO Spreadsheet with individually printable sheets for every body in the Kerbin system. Experiments which need to be performed more than once to obtain max science can be checked off twice. 12 Sept 2018 1.4.x Includes versions for MS Office and Open/Libre Office.forum posthttps://drive.google.com/open?id=1boxrIH8NZt8sarvIzCwnEo-2KX-PdlOC
Jacke's KSP Science ChecklistsJacke Spreadsheet with individually printable sheets for every body in the Kerbin system with all available experiments. 6 March 2019 1.6forum posthttps://www.dropbox.com/s/fj0bewwh7elea47/KSP-Jacke-Science_Checklists.20190306a.161.ods?dl=1
  1. This indicates the version of KSP that the tool is known to work for, or was the latest version when the tool was last updated. Most tools will work fine on later versions.
  2. To view javascript source, go to the url and either select 'View Source' from the right-click menu or use the browser's developer tools.

Deprecated

The tools in this table are known but are un-maintained, they websites are gone missing or the tools are too old to be relevant to recent versions of KSP

Title Developer Description Last Update KSP Version compatibility Notes Forum post Link
Fairing Factory Nathan Nifong Generates a downloadable fairing based on the given design non-functional (16-04-2014) losthttp://nathannifong.com/FairingFactory/
Where can I go?GavinZac Calculates possible destinations based on given Δv link dead (28-06-2020)forum posthttp://www.gavingolden.com/wherecanigo.php
MrFibble's KSP CalculatorsMrFlibble1978 Tools to calculate information on orbits Feb 2014 0.23 Dropbox link dead (28-06-2020)steam community thread
Delta V Calculatorinterwound Gives Δv required to reach a celestial body with or without a round trip link dead (28-06-2020)http://deltavmap.com/
Fuel Tank Calculatoropensesame11 Calculates the amount of fuel tanks for a given Δv 23 Oct 2013 link dead (17-04-2014)forum post


Offline applications

These tools can be downloaded and used offline. Keep in mind that the presence of an application here does not mean it has been tested or is otherwise trustworthy - apply reasonable caution when downloading and running the below applications. Generally, if something is widely used, it should be safe.

Title Developer Description Last Update KSP Version compatibility Notes Platform Forum post Link
KSP UtilitiesROFLCopter64bit Utility collection primarily for save file handling and analysis 4 Apr 2014 0.23.5open source (License: LGPL v3+) Windows (pre-compiled) (author reports partial cross-platforming from source)forum post (multiple downloads - see forum post)
Trajectory Optimization ToolArrowstar Helps find optimal burn trajectories for interplanetary transfers 24 January 2019 1.7 Matlab-based (License: CC BY-NC-ND 3.0 US) Windows, Linuxforum post (has dependencies - see forum post)
KSP Rocket CalculatorVRGhost Calculates rocket properties and aids in the design process 31 Oct 2012 0.17.1open sourcePython (python script - use source)
De-orbit and Staged Ascent SimulatorsShane Colton Calculate a de-orbit maneuver to land on a specific part of a celestial object - Evaluate whether a staged craft can reach orbit 22 Dec 2013 0.23 Scilab scripts Scilab (see external tools section)blog post (see blog post for .sce files)
Zord's KSP Multi-calculatorLord_Zord Calculate Δv, effective Isp, TWR and acceleration 23 Feb 2014 0.23 binary and python components (License: MIT) - author informs that Avast AV gives a false positive with the file (16-04-2014) Windows (possibly cross-platform, see downloads provided)forum posthttp://sourceforge.net/projects/zordskspcalc/
KSP CalculatorsJonv4n Semi-major axis and orbital period calculations 18 Jul 2013 0.20.2 LibreOffice Calc and MS Excel spreadsheetsLibreOffice Calc (cross-platform) / MS Excelforum post (multiple downloads - see forum post)
Fix my dockingAlo Finds and fixes bugs with docking ports from a quicksave 16 Apr 2014 0.23.5 (unclear)open source (License: CC BY-NC-SA 4.0) - written in Pascal Windowsforum postdropbox (.exe)
Delta V Calculatorfreeskier93 Calculates Δv for target celestial body with orbit height, inclination, angle and launch height are used to compute the final value 22 Mar 2014 0.23.5open source (License: GPL v2) Matlab-based - large dependency (MCR) Windowsforum postdropbox (.exe)
KOrbitSchildConstruct Orbital calculator and plotter 28 Oct 2011 0.11.1open source (License: Permissive) - inspired by Warringer Windowsforum post
Vessel ViewerChrison Allows viewing of .craft files outside of KSP 4 Oct 2013 0.10.1open source (License: GPL v3) Windowsforum posthttp://kerbalspaceport.com/ksp-vessel-viewer/
KSP Part Listercybutek Lists parts used in .craft files 2 Sep 2012 0.16open source (License: CC BY-NC-SA 3.0 GB) Windowsforum posthttp://cybutek.net/ksp/part_lister/1.0/KSP%20Part%20Lister%20v1.0.zip
Handy DV, TWR and orbital velocity Calcpizzaboy150 25 Oct 2013 Windowsforum postGoogle Drive (.exe)
Kerbal ToolsRockyTV TWR, Δv and Isp calculator 15 Nov 2013Google Chrome extensionforum postChrome Web Store

Transfer Stage Design Helper

RadHazard Helps design interplanetary transfer stages 9 Oct 2013open source (License: Permissive, included in forum post) Javaforum postdropbox link (.zip)
FireMarshaldraeath For a given Δv and vessel information provides maneuver, fuel and mass change details 9 Jan 2014open source (License: CC BY 4.0) Pythonforum post (python script - use source)
Delta V Calculatorsneakytreesnake Calculates Δv per stage 15 Jan 2014 MS Excel (.xlsx) (LibreOffice Calc can probably parse it as well)forum post
Printable Complete Stock Science ChecklistsJAFO Spreadsheet with individually printable sheets for every body in the Kerbin system. Experiments which need to be performed more than once to obtain max science can be checked off twice. 07 Aug 2015 1.0.4 LibreOffice Calc and MS Excel spreadsheetsLibreOffice Calc (cross-platform) / MS Excelforum posthttps://app.box.com/s/rrb117aiuhubmb4e0fehtx12e9odp57a

Deprecated

Title Developer Description Last Update KSP Version compatibility Notes Platform Forum post Link
KSP Orbital CalculatorWarringer Calculates orbital speeds for circular orbit injectionsopen source (License: LGPL)Javaforum postGoogle Code (zip file)
KSP Orbit MechanicWX_Echo Optimizes orbits 19 Aug 2012 Javaforum post
Weight calczweerify Calculates weight per stage 24 Oct 2011 0.11.1 .xls spreadsheet (can be parsed by MS Excel or LibreOffice Calc)forum postdropbox link (.zip)
KSP Orbit CalculatorZeno Calculates Δv and angles for orbital transfer between celestial bodies (see notes) 27 Jul 2013 (google play) - 12 Aug 2013 (source) 0.22 (see notes) Android (2.3.3+) based on Olex's calculator - open source (License: WTFPL])forum postGoogle Play link
KSP OrbitEric Meythaler Calculates orbit characteristics 20 Jul 2011 0.8.5 Android (2.1+)Google Play link
KSP Delta-V CalculatorIodyne Labs Calculates Δv per stage 10 Apr 2014 0.23.5 Android (4+)Google Play link
KSP DeltaV CalculatorJulien Quartier Calculates Δv required to reach celestial objects 2 Jan 2014 0.23 Android (2.2+)Google Play link


External tools not directly related to KSP

Tool

Online

Title Developer Description Last Update Notes Forum post Link
Delta-V Calculator and Rocket SimulatorJoe Strout Calculate Δv - Simulate rocket flight 14 Oct 2009 - 29 Jan 2000 Intended for Earth-based craft - Java source available
Δv calculator for LEO/MEO/GEO injection Eric Johnston (Satellite Signals) Calculate Δv to transfer to various orbital levels based on initial low orbit 20 Nov 2013 Intended for Earth-based craftdelta-v-geo-injection-calculator.htm

Offline

Title Developer Description Last Update Notes Platform Forum post Link
Scilab Scilab Enterprises General scientific computing software - contains aerospace and celestial mechanics modules (ATOMS) 2013open source (License: CeCILL GPL-compatible) Can convert Matlab scripts to its own format Cross-platform (Windows, MacOSX, GNU/Linux)http://www.scilab.org/
GNU Octave John W. Eaton (and others) General scientific computing software - no specific related modules or packages, but might be preferable for some 2013open source (License: GPL v3) Syntax is highly compatible with Matlab Cross-platform (Windows, MacOSX, Unix/Unix-like)http://www.gnu.org/software/octave/index.html
Sage William A. Stein (and others) General scientific computing software - utilizes other computational software as part of its backend 30 Jan 2014open source (License: Multiple (FOSS)) Very practical for python users MacOSX, Unix/Unix-like (binaries), Windows (virtualization)http://www.sagemath.org/
Anaconda Continuum Analytics General scientific computing software - primarily a python scientific computing frontend 9 Apr 2014 (License: EULA) An alternative to Sage on Windows for python computing Cross-platform (Windows, MacOSX, GNU/Linux)https://www.anaconda.com/

See Also

Retrieved from 'https://wiki.kerbalspaceprogram.com/index.php?title=Calculation_tools&oldid=98684'

We can use Excel to plot XY graph, also known as scatter chart or XY chart. With such charts, we can directly view trends and correlations between the two variables in our diagram. In this tutorial, we will learn how to plot the X vs. Y plots, add axis labels, data labels, and many other useful tips.

Figure 1 – How to plot data points in excel

Excel Plot X vs Y

We will set up a data table in Column A and B and then using the Scatter chart; we will display, modify, and format our X and Y plots.

  • We will set up our data table as displayed below.

Figure 2 – Plotting in excel

  • Next, we will highlight our data and go to the Insert Tab.

Figure 3 – X vs. Y graph in Excel

  • If we are using Excel 2010 or earlier, we may look for the Scatter group under the Insert Tab
  • In Excel 2013 and later, we will go to the Insert Tab; we will go to the Charts group and select the X and Y Scatter chart. In the drop-down menu, we will choose the second option.

Figure 4 – How to plot points in excel

  • Our Chart will look like this:

Figure 5 – How to plot x and y in Excel

Add Axis Titles to X vs Y graph in Excel

  • If we wish to add other details to our graph such as titles to the horizontal axis, we can click on the Plot to activate the Chart Tools Tab. Here, we will go to Chart Elements and select Axis Title from the drop-down lists, which leads to yet another drop-down menu, where we can select the axis we want.

Figure 6 – Plot chart in Excel

  • If we add Axis titles to the horizontal and vertical axis, we may have this

Figure 7 – Plotting in Excel

Add Data Labels to X and Y Plot

We can also add Data Labels to our plot. These data labels can give us a clear idea of each data point without having to reference our data table.

Ephemeris Tool 4.5 Excel Spreadsheets

  • We can click on the Plot to activate the Chart Tools Tab. We will go to Chart Elements and select Data Labels from the drop-down lists, which leads to yet another drop-down menu where we will choose More Data Table options

Figure 8 – How to plot points in excel

  • In the Format Data Table dialog box, we will make sure that the X-Values and Y-Values are marked.

Figure 9 – How to plot x vs. graph in excel

  • Our chart will look like this;

Figure 10 – Plot x vs. y in excel

Ephemeris Tool 4.5 Excel Tutorial

  • To Format Chart Axis, we can right click on the Plot and select Format Axis

Figure 11 – Format Axis in excel x vs. y graph

  • In the Format Axis dialog box, we can modify the minimum and maximum values.

Figure 12 – How to Activate kaspersky endpoint security for mac. plot x vs. y in excel

  • Our chart becomes;

Ephemeris Tool 4.5 Excel Shortcut

Figure 13 – How to plot data points in excel

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.