Topic: Treasure Companion Table 9.1 Inconsistent rounding

[dagorhir]

I have added the armor table to a spreadsheet to calculate the bonuses but I ran into a problem with the rounding. I think there's a problem on Table 9.1 (Pg 49)

Assuming superior design and 0.85 weight I get the following results

AT 18  -9 / -85 / -0 / -9
AT 19  -21 / -119 / -17 / -17
AT 20  -30 / -132 / -26 / -26

Table 9.1 (Pg 49)
AT 18  -8 / -85 / -0 / -8
AT 19  -21 / -119 / -17 / -17
AT 20  -30 / -131 / -25 / -25

Doesn't matter how I setup the rounding in the spreadsheet (regular, up or down), I never get the same results. Some ATs are rounded down, some are rounded up. It's just not consistent.

Thanks

[Ecthelion]

Negative numbers rounded down, positive numbers rounded up?

[dagorhir]

Negative numbers rounded down, positive numbers rounded up?

Aren't they all negative number? 

I kinda trust Excel when it comes to rounding and all the numbers are in fact negative (penalties).

Here's the formula: =IF(ROUND(((C2+CraftsBonus)*WeightFactor),0)>0,0,ROUND(((C2+CraftsBonus)*WeightFactor),0))
C2 is the cell that holds the minimum maneuver penalty (for AT 1 in the case).