Also, Excel won't complain about an odd calculation in the middle of the others.įirst, thanks for your pointing out the four wrong calculations. In fact, the above calculation column could be applied to all of column J in the Characteristics section, allowing GM's to create fraction costs for other characteristics, specific to his campaign. So if the character wants to have less than the starting number of Characteristic points, the subtraction will be negative, and the rounding will be to a negative integer.īecause of this, the calculations for J23 and J25 need to change: The SIGN function will return a positive 1, if the parameter is positive, a 0 if the parameter is 0, and a -1 if the parameter is negative.BUT, if the player is selling back points, the result of the division will be negative, and you can't round to a positive integer. We always want to round to an integer (a whole number) in the case of costs. The second parameter of CEILING is what direction you want to round and how many places.The CEILING function will round UP if there's any fractional part. In the case of END and STUN, you could end up with a fraction. But if it's a partial cost, then it would end up being divided by a whole number (or multiplied by a fraction, however you see it). If the cost is 3, then 5 would be multiplied by 3 and end up with a whole number. It multiplies this value by the other value in column H, which is the cost.
#Shadowrun character sheet 2nd edition editable Pc#
Like, if your PC has 15 STR, the default is 10, so the result of that subtraction will be 5. By subtracting the F column from the B column, you're seeing how much more than "normal" your character's Characteristic value is.If you want your Characteristic totals to show negative numbers when you "sell back" Characteristic points, change the formulas using this pattern:įor those that aren't as familiar with Excel functions, I'll explain this.
0 kommentar(er)
