Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Hadrian the Builder]

I just tried it on a windows machine with excel 2007 on it and it worked fine.

In the 2004 excel version for Mac, I was clicking the dropdown button and nothing happened, but it is moot now.

[Superboy]

Hmm as I was creating my swordmage character I noticed:

Level 16 utility power "Sudden Escape" isn't in the sheet.
All the swordmage level 17 encounter powers are missing.

[beachman]

I had to change the following:

"Charactersheet I!W149" to =IF(Attacks!M28="","",Attacks!M47)

Otherwise the ability for favorite power 3 said "4" on Character Sheet I. The Pro Sheet worked fine though.

BTW, I love this sheet.

[Cryptos]

XP Version:

* Artificers can't choose Alchemist instead of Ritualist.
* Selecting Alchemist in place of ritualist doesn't seem to do anything for Clerics and Wizards in terms of appearing on the character sheet. (It still says "Ritual Caster: You master and perform rituals.")
* Artificers have Acrobatics as trained rather than Arcana.
* Where does a half-elf select their dilettante power on the latest sheet?

Also, I edited the older version of my sheet to include the Dragon magazine Illusion spells, starlock powers, and some other things introduced in various articles. As you're adding non-core stuff, will these ever appear in the sheet without having to edit them in?

[ReadError]

Originally Posted by Cryptos

* Where does a half-elf select their dilettante power on the latest sheet?

It's in the powers sheet, the line under the first daily power. If you select half-elf as your race, you will see a +1 appear there in the encounter powers column.

[nytecoldawn]

I am using the full version of the spreedsheet in Office 2007.

I have noticed my rogue has gained additional points in three skills as a race/skill bonus. This is regardless of which race is chosen. The three affected skills are acrobatics, athletics, and stealth.

I have made selections on the basics tab, powers tab, and skills tab when I see this problem.

I do not understand why this +2 bonus is there. Have I missed something? This problem only seems to affect the rogue class. I have not been able to duplicate this with any other classes.

[nytecoldawn]

I have noticed that character sheet 1 does not auto populate the resistances field. It is also not set to allow for self entry as it has been in the past.

[Genolen]

I don't get the weapon proficiency of the halbert, if i choose the Dwarven weapon training feat.
I think I should get it, since the halbert is also an axe.
Or do I have to insert it myself, in the Feat field on the attack page?

[gamer900]

I skimmed through the two threads on this Spreadsheet and have tried to figure out how to do this, so maybe you can help. I made a two-weapon fighting Ranger but I can't find a way to put two seperate bonuses for powers like Twin Strike. It makes you use both of your weapons, but it has no way to put in two seperate bonuses. This gets troublesome when you have two weapons with seperate attack bonuses. The same can be said for damage. If you have two different damaging weapons, there is no way to put it into the power. Any suggestions or are you still trying to fix this?

[sdt]

Do I need to enable macros for this sheet? Office 2007 wanted me to save it in .xlsm (macro) format.

As stated many time previously, Great Sheet!

[Mithreinmaethor]

Sorry to be off topic here, but I knew that someone here could provide me with the correct information. I believe that there was a PDF version of the Weisbaden character sheet layout somewhere. Just the plain old print it and write out your character sheet. I have several people that like the layout but dont have computers etc to use the XLS files upon.

Thanks

[Yarthok]

Another great rev of this excellent character sheet! Let me say again how much I appreciate your efforts. I note that most of displayed "+" signs have been accomplished through the use of the "+#0;-#" custom cell formatting. This goes a long way to making the sheet compatible with OOC!

When I first opened the 1.16b sheet up, none of the drop downs on the 'Powers' sheet worked correctly. This was caused by some blank entries in a table on the 'At Will' sheet. (My suggested fix below, item 1.)
There was also one place where the "+#0;-#" was not used that caused a problem. (Suggested fix item 2 below.)

1) $'At Will'.C2:C4 ==> Set to zero instead of blank.
 
2) $'ExportSheet'.O36:O41
OLD template: =IF(VLOOKUP(Dexterity;A2:B51;2;FALSE())>0;"+"&VLOOKUP(Dexterity;A2:B51;2;FALSE());VLOOKUP(Dexterity;A2:B51;2;FALSE()))
NEW template: =IF(VLOOKUP(Dexterity;A2:B51;2;FALSE())>0;VLOOKUP(Dexterity;A2:B51;2;FALSE());VLOOKUP(Dexterity;A2:B51;2;FALSE()))
Change Cell Format to: +#0;-#

It appears that the pro sheet does not reflect the damage bonus for magical weapons. (Example: Cell $'Attacks'.E56 reflects the damage bonus from cell $'Attacks'.E10, but cell $'Pro Sheet'.BG38 does not reflect the damage plus from $'Attacks'.E10. Maybe this is your intent (?), to allow different weapons to be easily used with the Pro Sheet, but the Enhc box in the DEX block ($'Pro Sheet'.BH18) does reflect weapon enhancement. Otherwise, I think this is a logic error unrelated to OOC, but I do not have Excel, so I cannot confirm. If so, I believe the value needs to come from looking up based on the chosen attack bonus selection. It might help to have this value as an intermediate calculation to easily support the check for non-zero before displaying it on the Pro Sheet. Perhaps cell $'Attacks'.E69 could have code like...

=HLOOKUP(E31;$E$5:$M$10;6;FALSE())

The resulting value could then be used in $'Pro Sheet'.BG38 to check non-zero to determine if it needs to be displayed?

Thanks!

[Ganadai]

Selecting the Blade Initiate Multiclass Feat does not unlock the Novice, Acolyte or Adept Power Feats.

Choosing the Genasi, Firesoul race gives you resist 5 fire, 5 cold, 5 lighting. It should only give resist 5 fire. Lightning is also spelled wrong.

[Mithreinmaethor]

I am not all that familiar with Open Office but I noticed that the Dragonborns Fortitude is showing up as ###. Any ideas why.

I have been messing with the sheet in open office because several people within my gaming group dont own excel.

[Henry]

Originally Posted by Mithreinmaethor

I am not all that familiar with Open Office but I noticed that the Dragonborns Fortitude is showing up as ###. Any ideas why.

I've never used Openoffice myself, but usually that behavior in Excel means that the column is too narrow to display its numerical information, and widening the column (with the mouse, or by the menu option) will fix it.

[Mithreinmaethor]

Orcs "Warriors Surge" does not show up in the drop down for powers on the attack sheet. Instead you see like 4 or 5 #REF statements. Any idea how to do a quick fix for that?

I also noticed for some reason that my Dwarf Fighter was getting a +1 to ac for race/class for some reason

[RtrnofdMax]

My cleric is getting the warpriest ac bonus even at 1st level. There seems to be a significant change to how you handle paragon paths and the logical you are checking for the AC bonus isn't correct.

[Anywhere]

Originally Posted by Mithreinmaethor

I am not all that familiar with Open Office but I noticed that the Dragonborns Fortitude is showing up as ###. Any ideas why.

I have been messing with the sheet in open office because several people within my gaming group dont own excel.

found the mistake

Thanks to all reporting bugs!!!

[Amurayi]

Originally Posted by Mithreinmaethor

Sorry to be off topic here, but I knew that someone here could provide me with the correct information. I believe that there was a PDF version of the Weisbaden character sheet layout somewhere. Just the plain old print it and write out your character sheet. I have several people that like the layout but dont have computers etc to use the XLS files upon.

Thanks

The PDF version can also be downloaded here: D&D 4E Files


Q quick everybody what we are wokring on atm:
We fixed all bugs you reported as far as we could recreate them. Thanks for your input! Without your help this sheet wouldn't be as good!

We are currently finetuning the Prosheet again. We want it to work like this:
If you enter [W] as damage in the attacks tab it ignores the weapon specfifc damage and only lists damage the power gives (thus ignoring magic enhancement bonuses etc.)
If you enter a damage dice (i.e. 1d12) as damage in teh attacks tab the power adds up all bonuses from the weapon you designated as well (incl. magic enhancement bonuses etc.)

With this we want to give users maximum flexibility.

Additional new features with upcoming version:
- updated gnoll player stats from Dragon
- new FR epic destinys from Dragon
- 12 attack powers instead of 6 only
- if you enter a custom name for your weapon only then it lists the weapon type in brackets as property)

[lcquincy]

Originally Posted by Amurayi

The PDF version can also be downloaded here: D&D 4E Files


Q quick everybody what we are wokring on atm:
We fixed all bugs you reported as far as we could recreate them. Thanks for your input! Without your help this sheet wouldn't be as good!

We are currently finetuning the Prosheet again. We want it to work like this:
If you enter [W] as damage in the attacks tab it ignores the weapon specfifc damage and only lists damage the power gives (thus ignoring magic enhancement bonuses etc.)
If you enter a damage dice (i.e. 1d12) as damage in teh attacks tab the power adds up all bonuses from the weapon you designated as well (incl. magic enhancement bonuses etc.)

With this we want to give users maximum flexibility.

Additional new features with upcoming version:
- updated gnoll player stats from Dragon
- new FR epic destinys from Dragon
- 12 attack powers instead of 6 only
- if you enter a custom name for your weapon only then it lists the weapon type in brackets as property)

So when is the new 1.17 supposed to be posted?

Tom Nolan