General topics about Barons of the Galaxy
Freighter/Frigate Spread Sheet
|
TyreCorp Posts: 2
5/25/2017
|
I recently Did a spread sheet to help me find the values of how much should I upgrade my frigates and freighters in Cargo and Speed given how far my destination is and how many products I am picking up and such. I hope this spreadsheet helps you guys out as well. I posted this in discord earlier. If you have any questions please let me know.
https://docs.google.com/spreadsheets/d/1YDsklyiDaDAITI0JUYUMnKwaPBYn1FzbxXfCvll3hwE/edit?usp=sharing
|
|
|
0
link
|
|
TimurThunder Posts: 28
8/1/2017
|
This is very useful to me, forgot to say thanks!
The travel time calculation can be off by a turn: You calculate max of (distance x; distance y) divided by speed. It needs to be min of (distance x; distance y) divided by speed rounded up + [max of (distance x; distance y) minus min of (distance x; distance y)] divided by speed rounded up. You have one or more diagonal moves with the last cut off when you reach the right row/column, and then the rest of the movement cut off at the target.
Also, a column for required cargo capacity divided by cargo per transport can come in handy.
edited by TimurThunder on 8/1/2017
|
|
|
0
link
|
|
RedCircle Posts: 13
8/4/2017
|
I'm so efficient now \o/.
Big thanks.
|
|
|
0
link
|