Because of this, the calculations for J23 and J25 need to change:
J23 -> =CEILING((B23-F23)*H23,1), then change Format to General
J25 -> =CEILING((B25-F25)*H25,1), then change Format to General
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. Also, Excel won't complain about an odd calculation in the middle of the others.
First, thanks for your pointing out the four wrong calculations.
Secondly, to anyone using OpenOffice -- the changes I quoted above don't work as quoted, they generate an error code. I didn't try the versions with the sign function, but since it's the same ceiling format, I assume... anyway, I left those cells alone and saw no problems, albeit with only one use. Naturally, the math changes (which I didn't quote) worked fine.
Lucky timing for me, to have come here for this just after you caught and flagged those mistakes! Thanks again.
Excel Character Sheet for 6th Edition
in HERO System 6th Edition Documents
1,106 5Posted
First, thanks for your pointing out the four wrong calculations.
Secondly, to anyone using OpenOffice -- the changes I quoted above don't work as quoted, they generate an error code. I didn't try the versions with the sign function, but since it's the same ceiling format, I assume... anyway, I left those cells alone and saw no problems, albeit with only one use. Naturally, the math changes (which I didn't quote) worked fine.
Lucky timing for me, to have come here for this just after you caught and flagged those mistakes! Thanks again.