Mars-Bound Hokie Posted September 27 Share Posted September 27 (edited) I made an Excel spreadsheet that can calculate: Distance between up to five different sets of coordinates on ALL celestial bodies you can land on in the Kerbol system. Point 1 --> Point 2 --> Point 3 --> Point 4 --> Point 5 Kerbol and Jool not included, since you'll blow up if you hit the "surface." Earth (IRL) included on there as a bonus, so you can calculate the distance between points on our world. Estimated time to travel to said points given velocity in m/s. Expected range for an aircraft given velocity and fuel consumption rate. Includes how much of Kerbin's circumference you can expect to cover. Distance traveled if you flew directly north from KSC, if you want a full range test. Convert U.S. units (mph, ft altitude, miles distance) to metric (m/s, km altitude, km distance) and vice versa. Comes in handy if you want to compare your replica's performance to their real-life counterpart's. Below is the link to my calculator. Have fun: https://mega.nz/file/XeIX1aKB#FszTd3jm-ZEgG5EFn54PZiwbYJtoVOwzd2uGfVVMkyE The spoiler below contains a sneak peek on what it can do, if you're interested. Spoiler Sneak preview of the distance calculator worksheet. Point 1 --> Point 2: KSC to some point in the ocean. Point 2 --> Point 3: Aforementioned point in the ocean to Island Airfield. Point 3 --> Point 4: Island Airfield to Rangefinder Mountains ~400 km north of the KSC. Math already loaded in spreadsheet as a demonstration (and as practice). Gray cells are yours to add numbers to. Don't worry about positive or negative in the coordinates. That's already accounted for by clicking on N/S or E/W in the drop-down menus. Change the planet or moon, and the radius and circumference - hence the distances and ETA - automatically change with it. Sneak preview of the range calculator worksheet. I started making this spreadsheet for my USAF Museum replica showcase, but it can be used on original airplane designs too. As a bonus, this spreadsheet also includes the coordinates of known bases and Easter eggs. This thing took me quite a long time to make. If you have any questions, concerns, or comments on it, feel free to reply to this thread. I would love to know how it worked out for its users, and I especially would love to know if there's a problem with it so I can fix it. Thank you. Edited September 27 by Mars-Bound Hokie Cleanup after multiple site crashes Quote Link to comment Share on other sites More sharing options...
Gargamel Posted September 27 Share Posted September 27 Moved to tools and apps Quote Link to comment Share on other sites More sharing options...
Mars-Bound Hokie Posted September 27 Author Share Posted September 27 3 hours ago, Gargamel said: Moved to tools and apps Thank you. I was wondering where would be the most appropriate page for this. I didn't consider looking under the Mods section since this is an Excel sheet. Quote Link to comment Share on other sites More sharing options...
Kimera Industries Posted September 28 Share Posted September 28 I love KSP and I love Excel, thank you for your hard work. Quote Link to comment Share on other sites More sharing options...
Mars-Bound Hokie Posted September 28 Author Share Posted September 28 3 hours ago, Kimera Industries said: I love KSP and I love Excel, thank you for your hard work. You're welcome. Did you try it yet? How's it working out for you? Quote Link to comment Share on other sites More sharing options...
Kimera Industries Posted September 28 Share Posted September 28 1 hour ago, Mars-Bound Hokie said: You're welcome. Did you try it yet? How's it working out for you? Sadly, my current computer doesn't have Excel, but if it did, I'd download it in a heartbeat. Quote Link to comment Share on other sites More sharing options...
Mars-Bound Hokie Posted September 28 Author Share Posted September 28 Have you tried opening it in Google Sheets? Quote Link to comment Share on other sites More sharing options...
Kimera Industries Posted September 28 Share Posted September 28 O frabjous day! Callooh! Callay! I didn't know they were compatible. I'm going to use it to math out my Minmus Elcano. Quote Link to comment Share on other sites More sharing options...
Mars-Bound Hokie Posted November 7 Author Share Posted November 7 On 9/28/2024 at 6:49 PM, Kimera Industries said: O frabjous day! Callooh! Callay! I didn't know they were compatible. I'm going to use it to math out my Minmus Elcano. So, how did your journey go? Was my calculator helpful? Quote Link to comment Share on other sites More sharing options...
Kimera Industries Posted November 7 Share Posted November 7 1 hour ago, Mars-Bound Hokie said: So, how did your journey go? Was my calculator helpful? Unfortunately I cannot play KSP right now, and it could be months before I can, so until then, I'll just quote the Voyager spacecraft: *sad beep* Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.