http://forum.baronsofthegalaxy.com/topic2624-freighterfrigate-spread-sheet.aspx Barons of the Galaxy Forum - General Discussion - Freighter/Frigate Spread Sheet - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Fri, 04 Aug 2017 03:12:43 GMT Fri, 04 Aug 2017 03:12:43 GMT http://forum.baronsofthegalaxy.com/topic2624-freighterfrigate-spread-sheet.aspx
Big thanks.]]> Fri, 04 Aug 2017 03:12:43 GMT http://forum.baronsofthegalaxy.com/topic2624-freighterfrigate-spread-sheet.aspx
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]]> Tue, 01 Aug 2017 14:30:07 GMT http://forum.baronsofthegalaxy.com/topic2624-freighterfrigate-spread-sheet.aspx
https://docs.google.com/spreadsheets/d/1YDsklyiDaDAITI0JUYUMnKwaPBYn1FzbxXfCvll3hwE/edit?usp=sharing]]> Thu, 25 May 2017 20:26:59 GMT