Spreadsheets at High Altitude: Gimbal Toolkit

Discuss Gimbal

Re: Spreadsheets at High Altitude: Gimbal Toolkit

Postby Blurb » Fri Feb 13, 2015 4:35 pm

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
User avatar
Blurb
 
Posts: 302
Joined: September 16, 2012

Re: Spreadsheets at High Altitude: Gimbal Toolkit

Postby Vendan » Fri Feb 13, 2015 4:47 pm

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 :)
Vendan
 
Posts: 23
Joined: January 18, 2015

Re: Spreadsheets at High Altitude: Gimbal Toolkit

Postby Vendan » Sat Feb 14, 2015 10:35 am

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
Vendan
 
Posts: 23
Joined: January 18, 2015

Re: Spreadsheets at High Altitude: Gimbal Toolkit

Postby MoodBooster » Fri Mar 17, 2017 7:03 am

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.
MoodBooster
 
Posts: 1
Joined: March 17, 2017

Previous

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron