Ahh yes i'm fixing that in this next version. Got a few bugs I found including that one. THANKS! :)
Version 19 I think I make to many changes to fast I should probably fix more things in bulk and then release them!
Added some fields for Traits/Talents under minions for group types etc...
Fixed some spelling issues in armour types for calculations
Fixed weapons for minions
Added missing weapons
Thanks for feedback and helping me fix bugs guys!
Few spelling issues fixed and made the minion sheet a little easier to use for creating minions.
Hey dude, awesome sheet.
1) Assigning the Best Quality/Good Quality to a Ranged weapon adds the bonuses for melee weapons. Quality has different effects for melee and ranged.
2) I was confused as to what the three different columns are for characteristics. Adding some instructions or headings would be worthwhile. I assume the blue is for your bonus, and the second for the second digit of the stat, but what about the third? Also, if these guesses are correct, then the sheet also has the following issues:
3) The (blue) bonus characteristic column does not allow for Unnatural Stats or other characteristic bonus modifiers. Putting the modified bonus into the blue column causes the skills to calculate far too high. For example, If my Space Marine has STR 42, his bonus is actually 8 because he has UN Strength 4. This causes the althletics skills to read as "82".
4) Putting a "0" in the second column for characteristics does not work. It simply removes the zero. This isn't a big deal, but should be easy to fix.
5) For weapon stats, putting "Non-Primitive" is irrelevant. Primitive is now a special, numbered quality.
Love the sheet, thanks for the good work :)
Thanks i'll look into fixing those issues. As for the characteristics the 3rd box is used for unnatural characteristics. So if your str if 45 you put 4 in first box 5 in send and 4 in 3rd for SM characters. The UC is not added into any calculations on the sheet it's more just for the character to know they have it. I'll start working on those issues this weekend.
Updated with fixes:
Fixed zero not showing in characteristic space
Removed Lathe Blade from weapon quality
Removed Non-Primitive from weapon descriptions as no longer relevant
Fixed weapon addons and quality for WS vs BS items
Found issue with minion weapon calculations. Fixed.
Movement rate for an agility bonus of 0 is 1/2, not 0. Black Crusade pg 39.
The sheet makes your movement "0". Should be 1/2, 1, 2, 3.
Thanks for the find and it's fixed now.
Just another thing. Noticed that the Space marines don't get their +1 Movement for being Hulking size. Maybe add a size field which is apply to correct modifiers to size/stealth etc?
What page is that on don't recall seeing it.
Power armour changes your size to hulking. pg 175.
Anything of hulking size gets +1 movement. Table-4-8, pg 142.
Black carapace just removes the to hit penalty for SM's being Hulking size. The other changes would still apply.
So I guess it's actually a power armour change, not a "race" change. If you add it though, maybe also add an option in there for terminator armour *or* power armour?
Having issue getting that +1 in there for the 1/2 movement with zero Agility Bonus so not looking pretty. Haven't forgotten about this :)
Redeucer is back in action and made a bunch of changes to the file to fix errors. Link is updated if you like the sheet.
Any chance an admin or someone could sticky this thread so folks can find the sheet easier?