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

[ccmage]

open office sheet

i modified the MS sheet v1.11 to work with open office. i havent fully tested it yet. most of the errors r fixed. if u c any problems, let me know. i will try to fix them.

http://www.savefile.com/files/1623023

thx the original creators for their good work. this is a really good worksheet.

 

[warderbrad]

I was putting an X in the trained skill for Religion. (As a cleric)
It's red, but it probably should already populate that field with one so as not to let me put another.

having it put a X in that field would require a macro which would remove all ability for the sheet to be Open Office compatible. Any level of automatic filling of info that would later be editable would result in this same issue.

Making it appear red is done with Conditional Formatting which does not require the macros.

 

[silentounce]

i modified the MS sheet v1.11. i havent fully tested it yet. some of the errors r kind of fixed. if u c any problems, let me know. i will try to fix them.

http://www.savefile.com/files/1623023

Thanks much!! Haven't even looked at it, but I'm sure that it's better than nothing! Downloading now.

And thanks to the original creators for allowing this and trying to accommodate those without MS Office.

 

[deleteme123456]

Maybe an upgrade system like Heroforge had would work. You make a 2nd sheet with macros in it that change whatever cells need to be changed in the original. Someone with only access to OpenOffice can still use the original sheet but has to reinput all their data or get a friend to do the upgrade for them (or do it at work? )... but those with Excel and macros could get a little benefit. Once it was written once you'd just have to change the macro based on what cells changed, which should be easy enough that even someone who doesn't know VBA would be able to do it if they have existing code to copy/modify.

 

[JEstr]

Ok, I feel like a total moron. Is the equipment and pricing working? I can get a price on any piece of equipment I set with a magical enhancement, but when I set to mundane I get nothing. Am I missing something?

 

[ccmage]

i think according to the rule, unless ur DM allows it, u cant sell any non-magical items.

 

[JEstr]

Ahh, my mistake then, I assumed this was for calculating the cost of the equipment you owned.

 

[Anywhere]

Maybe an upgrade system like Heroforge had would work.

Sure it would be nice to have but my intention of working without macros was to get it useable with OpenOffice. Except that I don't know anything about the work with macros.

You make a 2nd sheet with macros in it

The idea of two sheets, one with and one without macros, sounds good in the first moment, but then I must up date two sheets which is horrible.


Thank you all for using the sheet.

Lia

 

[Stonesnake]

Found a new bug. If you select the "Warrior of the Wild" feat and select the skill 'Dungoneering" you don't get the "trained" preset on the skills tab.

I think I saw one or two like this as well in the multiclass feats, but this one I am trying use, so it is pretty obvious...

Also this a small thing, but can you please remove all the presets in the "default" template. I had my players use this template to make their 4th edition PCs and they ALL had the +1 Magic Bonus for their 1st level character's armor -- it's set that way in the default template and nobody caught that error.

Even I forgot to remove it when I was a new 4th edition character. Thanks! Love the tool.

 

[elandy]

First of all, congratulations for this great tool. I was going to make something like this, but yours is better than anything I would ever do .

I found a couple of things (by now) that should be revized:

1: The bonuses from Improved Initiative and Quick Draw are both "feat bonus", so they should not stack.

2: The Drow racial power "darkfire" does not appear in the "attacks" tab.

Also, like Stonesnake said, can you please remove all the presets in the "default" template? It also has another "error": +2 to Thivery in misc. I´ve already clean it up myself before send it to my players, but it would be nice to have it clean on next versions.

Another thing that I should appreciate is if you can put enough space for all the powers in the attack tab, so that we don´t have to delete "old" powers, perhaps with a "favorite power" check cell (like that on trained skills or chosen feats) to choose what powers appear into the character sheet.

Sorry if some of this things where said before. I didn´t had time to read all 12 pages.
And sorry for my english; it´s not my foreing language.

Thank you again for such a great sheet.

Andy