Sorrows Posted October 1 Report Share Posted October 1 so i have a formula for how many engines i need based on current tonage without engines. i also have a formula for bridges (same formula really) currentTonnage/((thrust/AP desired)-100) or same with bridge currentTonnage/((bridgeSTR/tgts)-weight) but when you add one you have to add more of the other until it averages out. So is there a way to figure out both simultaneously? like a spreadsheet formula that you just add the thruster power, desired AP, bridge str, #tgts, and bridge weight(usually 100 but some are more) Quote Link to comment Share on other sites More sharing options...
Sakarissa Posted October 8 Report Share Posted October 8 My ship building spreadsheet calculates APs, FC, integrity, shield strength, etc automatically as I put stuff into the design. I fine tune by taking and adding things in the design until I get the stats I want out of the design. Quote Link to comment Share on other sites More sharing options...
Rufus Firefly Posted October 9 Report Share Posted October 9 What you have is a set of simultaneous equations. There might be a solver for that in Excel. Quote Link to comment Share on other sites More sharing options...
Sorrows Posted October 14 Author Report Share Posted October 14 Sakarissa, would you mind sharing that spreadsheet with me? Quote Link to comment Share on other sites More sharing options...
hobknob Posted October 18 Report Share Posted October 18 Lots of spreadsheets out there for ship design... Quote Link to comment Share on other sites More sharing options...
Sakarissa Posted October 18 Report Share Posted October 18 Mine is in Google Sheets. Do you have a gmail account? Quote Link to comment Share on other sites More sharing options...
Sorrows Posted October 21 Author Report Share Posted October 21 Yes I do. Jedimonkeyfish@ Quote Link to comment Share on other sites More sharing options...
Sakarissa Posted October 25 Report Share Posted October 25 Sorrows, just sent you the share link for the sheet. Quote Link to comment Share on other sites More sharing options...
Rufus Firefly Posted October 25 Report Share Posted October 25 Could you share it with edmund.hack@ on Gmail Quote Link to comment Share on other sites More sharing options...
Sakarissa Posted October 25 Report Share Posted October 25 Rufus, done. 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.