Dynamic Excel "Wiesbaden Charactersheet"

I have found that the damage bonus being calculated incorrectly is directly related to the magic item bonus. It is giving a +X to hit but is giving +X+1 for the magic weapon. i.e +1 weapon is +2 dmg, +2 weapon is +3 dmg etc.

Not sure where to fix that one.

Also please add Gnoll Claws or just Claws as weapons somewhere for the Gnoll feat please.
 
Last edited:

log in or register to remove this ad

All right, I think i've isolated the problem with adding enhancement damage twice. On the Transport Attack sheet, the "modifiers sign" formula (in row 12) should be "=IF(C11>=0,"+"&C11,C11)"
obviously, this formula needs to be translated for each power to the corresponding cells

Also, I've noticed that Eladrin Soldier was still not granting proficiency with all spears or bonus damage with any of the weapons. The fixes were easy...

For bonus damage: On the Proficiency tab, in column J replace "$S$36" with "$S$37" (it was accidentally referring to Dwarven Weapon Training instead of Eladrin Soldier)

For weapon proficiencies: Copy the formula in cell E28 on the Proficiency tab into the cells in column E corresponding to the spear weapons. You'll also want to use the same formula for the axes and hammers, replacing "$S$37" with "$S$36" so that Dwarven Weapon Training gives the proper proficiencies as well


I did have one question, while I was throwing together a swordmage, I noticed a couple powers that weren't in the FRPG (specifically Frigid Blade and Dimensional Thunder). Can anyone tell me where these powers come from?

loving this sheet, keep up the good work.
 




Weapon Focus

Found a minor error that would make weapon focus not work properly with dwarven weapon training or eladrin soldier...

on the Proficiency tab, column G (which returns the total bonus damage from feats), you need to replace all the "MAX"es with "SUM"s. This should allow you to get the benefits of your racial training and weapon focus
 

Found a minor error that would make weapon focus not work properly with dwarven weapon training or eladrin soldier...

on the Proficiency tab, column G (which returns the total bonus damage from feats), you need to replace all the "MAX"es with "SUM"s. This should allow you to get the benefits of your racial training and weapon focus
They are all feat bonus, so they don't stack, so it's working as it should (except for the attack tab, in the "Damage" line on row 105, that is not counting any feat bonus to damage, although they are showing correctly on the "Damage Bonus, Weapon" line on row 99, except for eladrin soldier feat, but that was already explained by you how to fix it)

Andy
 

They are all feat bonus, so they don't stack, so it's working as it should (except for the attack tab, in the "Damage" line on row 105, that is not counting any feat bonus to damage, although they are showing correctly on the "Damage Bonus, Weapon" line on row 99, except for eladrin soldier feat, but that was already explained by you how to fix it)

Andy
ah, i was mistaken. must've missed that section before. thanks for clearing it up
 

Why can't the information from the attack sheet be transferred directly to the PRO sheet? Is this a design issue or a EULA problem?
 

Praise, Fighter Bug and Another Question

Hi everyone!

I'm brand new here; in fact, this is my first post! I want to first say how much I love this excel-based sheet. It makes character creation 100% easier and, in my opinion, more fun! So, hats off to the creators. This is a wonderful program and works perfectly on my OS X 10.5.5.

I think I might have found a bug, which might or might not have been discussed already. This is in Version 1.15 of the program. When one selects Fighter as their class, there is not "Mace" in the options for the Melee Weapon Group. It's available in the PHB but not in the sheet.

My next question is that I'm wondering if there will be an update to the character sheet program to include the newly released Barbarian Playtest available here: Dragon 368: Barbarian Playtest
I'm sure this has already been asked; and if it's in the works then I'll continue to wait patiently for the next version to come out.

I hope I posted these in the right place! Again, despite the bug I found, I love the excel program and will always continue to use it!

Thanks!

~Ev
 

Remove ads

Top