Dynamic Excel "Wiesbaden Charactersheet" D&D (v1.11)

[ra-punzel72]

There is only one real issue for me: no update possibility. I have done a similar sheet for 3.5 (which was a real burden because of the much more complex rules and calculations) and have solved it with three input pages.

1. Charakter Data: In this page you used only one column for input and selection. Copy and paste just this one column to a newer version.

2. Weapon Data: choose weapons, damage, modifier, type and so on
Copy the "table" with the input fields to the new version

3. Items. Same as Weapon Data.

So a update was only to copy one column and two tables.
It would be great if there would be something similar in this GREAT GREAT sheet

PS: Yes, i have donated

 

[Arbanax]

Where am I going wrong

In an effort to better use this wonderful excel sheet I've been posting on these boards. Infocynic who'se been helping suggested I post up the sheet where I've got to because some values are not coming out correctly so here is the sheet's progress so far, helpful comments appreciated.

Ab

 

[deleteme123456]

In an effort to better use this wonderful excel sheet I've been posting on these boards. Infocynic who'se been helping suggested I post up the sheet where I've got to because some values are not coming out correctly so here is the sheet's progress so far, helpful comments appreciated.

Ab

You're getting NA for damage because your ability score selected in the dropdown (Charisma +1) doesn't match any of your actual ability scores (you have charisma +2 currently). Given that you're using a Ranged basic attack, you should put Dexterity in there for Bonus Ability Damage. The Melee basic basic attack should be using Strength. Careful Strike does not use ability damage and should be set to "no bonus". When you put in Hit & Run and other powers, you can put in Strength or Dexterity, depending on whether it's melee or ranged. All ranger powers that I know of either use Strength (Hit and Run), Dexterity (Nimble Strike), or no ability (Careful Strike, Twin Strike) for bonus damage.

Note that there is a bug in 1.12 relating to weapon proficiencies, so you're not actually going to be at +5 to attack with that bastard sword. I'll post a corrected version 1.12c later today hopefully.

 

[deleteme123456]

Version 1.12c (or c.2 or something)

FIXED: Weapon proficiencies were using your simple melee proficiency for all weapons. Sadly, you're no longer all proficient with Bastard Swords.
CHANGED: Adding an "magic item bonus" to your weapon will cause that number to be picked up and added in with [W]. The "bonus damage" field will not be multiplied by the number of [W]s, so if your level 21 rogue had a +4 dagger and used Sly Flourish, you could put your charisma modifier in the bonus damage (say +6 for example), and just 2[W] for the damage dice. The damage field would calculate 2(1d4+4)+6+DEXMOD = 2d4+8+6+DEXMOD.

Worksheets changed: Attacks, Transport Attack.

(Note to author: the racial and class weapon proficiencies [for specific weapons, like the Rogue or Wizard] are not being done well and will become a nightmare to deal with when additional rulebooks are available. I would recommend expanding the table on Race/Class Overview into a full grid that has a list of the weapons, one per row, and TRUE/FALSE for racial/class proficiency... this would just be an override in case you weren't proficient with a specific class of weapons (Dwarf Rogue isn't proficient with Military Melee but is still proficient with Throwing Hammer)... I can provide an example if this is unclear).

 

[Arbanax]

Man you are good, thanks for pointing that out...there are so many options but I think I'm getting the hang of it. Cheers mate.

Ab

 

[James McMurray]

Version 1.12c

It doesn't look like the damage bonus field (I42 on Attacks) is getting added in. For instance, if I put 3d8 into the damage field and 5 into the bonus damage, my calculated damage is still 3d8 (24 crit).

Also, shouldn't the magic item bonus add itself to the damage as well as the attack?

 

[deleteme123456]

It doesn't look like the damage bonus field (I42 on Attacks) is getting added in. For instance, if I put 3d8 into the damage field and 5 into the bonus damage, my calculated damage is still 3d8 (24 crit).

Also, shouldn't the magic item bonus add itself to the damage as well as the attack?

Fixed the first bug at about 12:30 Eastern Daylight Time and uploaded a new version to the 1.12c post above. The second bug is a little trickier because it relies on assumptions now... but it seems like a safe assumption, which is "If you are attacking with a power that deals damage based on the weapon (i.e., your damage dice includes a [W] and your attack points to a weapon that has a damage expression like 2d6), then the magic item bonus for that weapon is multiplied by the number in front of [W]; else, the magic item bonus for that attack bonus is counted exactly once."

Thus if you have a +2 holy symbol, an attack that deals 3d8+WIS will show up as 3d8+2+WIS.

 

[James McMurray]

Thanks!

 

[James McMurray]

The utility spell "Necrtic Web" is misspelled.

 

[GorTeX]

. but it seems like a safe assumption, which is "If you are attacking with a power that deals damage based on the weapon (i.e., your damage dice includes a [W] and your attack points to a weapon that has a damage expression like 2d6), then the magic item bonus for that weapon is multiplied by the number in front of [W]; else, the magic item bonus for that attack bonus is counted exactly once."

The magic item bonus only ever get's added to damage once..it is not multiplied by the number in front of the [W]

A +2 longsword (1d8) used in a power that does 3[W] would do 3d8+STR+2 it would not be 3d8+STR+6.

(only the damage dice are 'multiplied' never any of the damage modifiers)