Compressed Ore Margin Trading

It’s an excellent spreadsheet; however I most address a flaw in your calculation when converting ore into Compressed, compression rate is 100:1 (100 ore = 1 compressed ore), in your spread sheet you use the formula

=(“cell”/100)

this yields inaccurate results when it doesn’t yield an integer, so to fix this you should be using this formula (see below), this will discard any decimal-places and return an integer.

=floor(“cell”/100)

1 Like