warderbrad said:
http://www.mediafire.com/?xy0ebnyxew1
did it fast so there could be mistakes but it shows how to use the sheet
Indeed it does show, thanks. Let me make a few comments and ask a couple of questions while at it:
1) As mentioned, heavy thrown = use Str for javelin even though ranged.
2) Notice on the Attacks tab you used attack bonus 1 for ranged basic and attack bonus 2 for melee basic, which is swapped. I only mention it because the first time I tried using the sheet I made the same mistake. I believe that most people will intuitively tend to think of their primary melee weapon first and their ranged next, although that may only be for defenders while rangers and wizards, for instance, may have the opposite. The KotS pregens show melee before ranged for basic attacks. I just wonder if the incidence of mistakes would be less if melee basic came first (column E) and ranged second (column G). Maybe there is some other creative way to facilitate getting the correct attack bonus chosen on favorites/basic.
3) I notice you overrode the attack bonus for the powers, using straight-up Str rather than the BAB, which includes weapon proficiency bonus. Those bonuses do apply to powers so there's no need for the override. I looked back at the PHB and unfortunately it is not even mentioned in the Attack section of Powers in the Classes chapter that you should include it, but weapon proficiencies (Equipment chapter, how to read weapon table) says they apply to attack rolls, which is a broad category including powers. Still, I think they could/should have made this more explicit and I hope it doesn't confuse too many people.
4) So if I want to account for using something like a dagger in melee and ranged I should use 2 attack bonus columns in the Attacks tab, one entering Str and the other Dex, right?
5) I like the way that I can just change the attack bonus # (1-5) for a power and have it update the character sheet accordingly, rather than needing a separate entry.
6) Probably too much to ask, but it would be awesome if under Base attack bonuses you could just specify a weapon and based on a lookup of its properties it could determine whether it is usable for melee, ranged, or both, and accordingly calculate cell values indicating the relevant ability. Instead of having one Ability and BAB per entry it would have two, one for melee and one for ranged. If the weapon is only applicable for one or the other, an N/A could appear in the relevant cells (not to be confused with Excel's #N/A). It would use the light vs. heavy thrown properties to determine whether ranged should use Str or Dex, etc.
7) Edit: noticed something else. The Attacks tab row with drop downs to select the weapon/implement type (row 8) is called "weapon/implement type" and the one where you entered the damage die (row 10) is called weapon/implement name. I think row 8 is name, and I'm not sure either what type means or why you entered the damage die. If you do mean to put the damage then in the future you could consider letting the damage field for the favorite powers automatically calculate that based on whether it's 1[W], 2[W], 0, etc. base damage and which attack bonus (i.e. which weapon) was chosen, where appropriate. Just a thought.
Again, thanks for your hard work!!!