Page 3 of 3

Re: Spreadsheets at High Altitude: Gimbal Toolkit

PostPosted: Fri Feb 13, 2015 4:35 pm
by Blurb
SimpleHyperChicken wrote:I value it, but when'd you switch to ods file format? My excel two-thousand-and-something balks at importing it and google docs is throwing errors on some of the formulas.


Switched to .ods because I didn't feel like coughing up for a new office package.
Tried converting it to .xls, which appears to mostly work. Only ammo seems outright wrong.
https://dl.dropboxusercontent.com/u/107 ... _One-3.xls

Re: Spreadsheets at High Altitude: Gimbal Toolkit

PostPosted: Fri Feb 13, 2015 4:47 pm
by Vendan
I've written up a ton of info about thrust and drag forces. Here's some links

Written docs:
https://docs.google.com/document/d/1IU3 ... sp=sharing

Thrust Calc Sheet:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

The thrust calc sheet gets within 10's of units of the ingame top speed(and most of that is you have to eyeball the intersection), so I'm happy with it :)

Re: Spreadsheets at High Altitude: Gimbal Toolkit

PostPosted: Sat Feb 14, 2015 10:35 am
by Vendan
Also just added a 10 second long physics calculation, so you can put in a ship with specific engines, mass, and drag then see the acceleration/velocity profiles. Note, it's a lot of math that needs to be run through in the bottom section, so it may take a while to update!

ugh, as it turns out, doing 1000 row numerical phyiscs simulations is one way to break google sheets. Gonna get it into a standard spreadsheet form

Ok, now I've got the maneuvering thrusters done correctly. Matches my built ship to within 10mph!

edit: I'm going to keep the "main copy" on google sheets, but I highly recommend downloading and using an excel or ods version of the sheet if you want to play with it. Google sheets takes a few minutes to do the formula recalculations

Re: Spreadsheets at High Altitude: Gimbal Toolkit

PostPosted: Fri Mar 17, 2017 7:03 am
by MoodBooster
Hello,

Do you still have that ship building excel? I just started my own excel and typed all the data to it from the hangar information already. After that I noticed that someone has made exactly same thing earlier. You have quite nice research about drag and thrust here, I was planning to make simple top speed calculator to my excel. And foremost it would help building ship to check the budget all the time.

Are you still playing the game?

I bought just six licenses to my friends, when we get together in LAN party. It would be cool if this could get more players.