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

[Amurayi]

Heya guys,

we created our dynamic "Wiesbaden Charactersheet" D&D 4.0 for everyone.

Here is the full dynamic Excel version. It has a LOT of options. You should be able to create any kind of character based on the PHB and the MM alternate race options. It also has power, initiative and magic item cards you can fill in. You still need the PHB for the exact details of the powers and rituals tough:
http://www.nzcomputers.net/heroforge/default4e.asp
Current Version: 1.12

PDF version incl. Power- and Magicitem Cards:
http://www.lemonbutter.com/dnd/DnD4Charsheet.zip

Updates will be under the same links.

If you find any bugs or misspelled terms or words please post them in this thread. We really appreciate it!



Thanks!

[Amurayi]

List of changes:

Version 1.12: RELEASED 07-07-08
New features:
- Power cards in trading card size!
- Magic item cards in trading card size!
- Initiative card for your char!
- Custom tab - enter everything hot and fancy you find in new non-PHB sources
- More custom fields for homebrew rules
- Instead of writing 1d8+0 you can write 1d8
- Some fields disapear if you selcet certain options
- You can edit different bonuses of your damage like attack bonus
- Override field for languages
- you can select "no weapon" for your attacks to give you no proficiency
Design changes:
- The Attack and Damage fields are now more organized
- Damage is now split up
- The "Used" box dispears for at-will-powers
- The ability name colors itself according to At-Will/Enc/Daily power
- Made at-will powers field smaller and moved them closer to the other powers on page 2 of the sheet
- Removed "Temporary effects" on charsheet III to make space for more powers
Bug fixes:
- Minoor Spellling issuez
- Magic Cloth armor gives your Dex or Int bonus as it should
- Eldritch Blast can be selected as Half-Elf power as well
- Nature not a class skill for rogues anymore
- Feats: "Warrior of the Wild" sets the right skills to trained
- Feats: Weapon Focus Polearm added
- Feats: "Dragon Frenzy" is indicated on benefits when bloodied
- Feats: "Shield Push" changed description
- Gods: Avandra appears on your charsheet if you select her
- 3rd Damage field shows correct value now
- Removed the zeros in the weapon 1 drown-down menu
- Misc bonus for fighters weapon talent appears in both basic attack boxes, not only first one
- Item bonus field for speed can now be edited
- Demigod ability bonuses fixed




Version 1.13: TO BE RELEASED
New features:
- "Buff" page
- More custom fields for homebrew rules
- Artificer class from Dragon mag
- Updated Warforged race from Dragon mag
Design changes:
- At-Will/Enc/Daily Indicator moved to first spot in Favorite Powers
Bug fixes:
- Feats bonuses don't stack anymore
In planning:
- Auto populating weapon ranges and damage.
- New landscape sheet with bigger fonts and less data

NOT A BUG!
- Skill bonus for humans and eladrins is already included in the amounts of skill you can choose. Skills you are automatically trained with are preselected as trained for you.
- Wizards DO NOT get an extra Utility power with expanded spellbook
- Make sure you scroll up and down in the pop-up menus. You might miss an option you can pick!


Known issues:
- Feat bonuses stack
- Minor issues with Open Office
- The yellow fields indicate which fields you cen edit in the charsheet. However these fields will also print yellow on a color printer.
- The charcheets are optimized for DIN A4. If you use US letter make sure you select the "Fit to page" setting in you rprinting window


Things we like and probably won't change:
- Damage fields don't generate their values automatically. For this we would have to program every power. It would be possible but we won't do this to avoid legal issues.
- Adding the full powers might be a step to far to get in trouble with the WotC legal department. We won't cross this line.
- All PHB Potions are listed in backpack. Just add the number of potions you have next to it. Sell price is per potion. Only because they are listed it doesn't mean you have them. If you don't like the potions just delete the fields (they are editable)
- No fields for ammunition is a good thing (Do you REALLY count your shot arrows?)
- No fields for character looks, background or traits. You visualize this in your head anyway. We consider doing an extra "fluff" page in the future though.
- Worshipping a specific god isn't recognized as a prerequisite for the Channel Divinity Feats. This way you can use the Override field for custom gods from other settings.
- Using a "staff" (opposed to a "quarterstaff") does not add a proficiency bonus to a Melee Basic attack power (used with Str). Use the Override field to circumvent this or pick "Quarterstaff" if you do Melee attacks with your staff implement.
- "Charsheet page 1": "Class powers" don't list the extra Daily powers Wizards aquire.
- No "Weight" fields. Ask your DM to stop being so anal if he burdens you to keep track of something like this.

[Thasmodious]

Very, very nice. Thanks for this!

I am working a character through it right now and I'll post any problems I come across.

[mrphoenix]

thanks!

[Thasmodious]

I entered a lvl 6 Dwarf wizard (mc: fighter). Went smoothly, the setup is easy and elegant. I see the staff note in your known problems. When you use a staff as an implement, rather than an attack (with your int to power spells) you don't get the prof. bonus, so that should be correct. However, when I tried to enter the quarterstaff as a weapon also, it did not give me the prof. bonus.

Didn't come across any other problems, the sheet is really fantastic. You, sir, are a god among men. This thing must have really been a ton of work.

Edit: One question - does the large PAGE 1 on each of the final character sheet pages print, if you print the sheets? I don't have a printer hooked up right now to see. And if so, why?

[withak]

Looks great! I have been working on something similar, though you have gotten a lot farther than I have.

A couple things:

Is this compatible with OpenOffice? Most of the sheet works, but I am getting a lot of error codes.
Eladrin Education isn't accounted for on the Skills tab.

[GorTeX]

Basice Ranged and Basic melee attacks are described on page 287, not 255

[wetzilla]

I really like this sheet, it looks like it's going to be very helpful. I've found a few errors in this sheet while using it in open office calc, not sure if thats the reason.

1. +1 to all skills isn't added at level 10, not sure about 20.
2. lots of 502 errors and #value errors, especially in the skill and feat pages. #value errors in the feat page seem to be for class specific feat names, except in the feat and heroic feats left boxes.
3. Weapon proficiency drop downs can't be changed, says it's protected.
4. There are many errors on the character sheets, ability modifiers aren't being added to ability check totals, lots of ### in various fields,

This sheet isn't really usable in OpenOffice, but I really appreciate the effort you obviously put into this sheet, and if these are only issues when using this software I can definitely got a copy of microsoft office, because this sheet is going to be very, very useful, as even I have trouble reading my own handwriting sometimes.

[Riley]

Your character builder is beautiful! I used to use something similar in 3e, and was hoping someone would be taking on this kind of task. (It would be a serious stretch of my Excel-fu to do this.) And as a first reaction, I also like the layout of your character sheet.

Entering my first character into it (a wiz 1), are the equipment and attack pages still works in progress? I can imagine a version of your creation in which the various attack stats would be automatically entered and calculated.

In the more immediate term, though, I don't undertand how the "Choose your attack bonus" row is supposed to work.

And again, Great Job! And Thanks!

[GorTeX]

making a fighter. On the Feats page, the feats left and heroic feats left do not decrease if I select Quick draw (I do meet the requirments).

Taking the cleric multiclass feat, Initiate of the faith gives skill training in perceptions (should be religion)

[Magus Coeruleus]

Wow this is hard core! Looks great. I found a bug and tracked it down-- when a warlord picks which commanding presence, it doesn't make the appropriate feat Tactical Assault or Inspired Recovery available on the feats sheet. It is looking on the hidden Class Overview sheet for Y26 to be either Tactical Presence or Inspired Presence, but Y26 has a much longer entry starting with the type of presence in single quotes and then a whole description (as part of an IF statement). I tried hard-coding Tactical Presence into the cell and it made it work, so that suggests that all that needs to be done is for cells like D56 and D96 on the Feats sheet to look for the target string (Tactical Presence or Inspiring Presence, accordingly) as a subset of the cell rather than being an exact match.

Cheers!

[kitoy]

I was contemplating doing something similar to this, but chickened out. This is awesome. Thanks for all the time and effort you've obviously put into this.

[Thasmodious]

Ride is listed as a skill on both the sheet and skill page.

The word 'type' is misspelled 'typ' in both the Armor and Shield sections of the Equipment page.

[NewfieDave]

Great effort! Much better than what I was working on in Excel.

Just a few things I noticed on my first run through making a Dragonborn Warlord...

1) Passive is spelled "Passiv" twice on CharsheetI.

2) I chose Strength for the Dragonborn breath weapon and the notes on the character sheet say to add Strength to both attack and damage. Strength should only be added to the attack roll; Constitution modifies the damage regardless of which ability you choose. Also noticed poison was missing as a damage type choice for this power.

[Thasmodious]

Not a bug, but it might be nice to have a place on the Equipment tab, with armor and shield, to input defense bonus from Neck items.

Also, somewhere on the character sheet to list the powers of your magic items would be nice.

[Aloïsius]

Impressive...

I noted that Eladrins don't gain longsword proficiency in the feat list and that the "expended spellbook" feat does not add the spell it should allow...

But for such an early work, this is fantastic.

[PrecociousApprentice]

I was playing with the sheet a little and found that when you set up your attacks on the attacks sheet, it won't allow you to not use an implement. As far as I know, implements are not required, they just add a bonus if magical. Setting the sheet up to reflect this would be good. Thanks.

Edit: Using Improvised, Ranged might work. I just don't know if there are other repercussions of this.

[brehobit]

VERY nice. I'll be using this!

One issue I noticed is that +4 or better armor should probably get the masterwork bonus be default...

Mark

[Kralin Thornberry]

Originally Posted by Riley

In the more immediate term, though, I don't undertand how the "Choose your attack bonus" row is supposed to work.

At the top of that tab, you input each weapon/attack with the appropriate skills and modifiiers and overrides if need be (like +2 to attack for Eladrins w/ long swords).

Under the basic attacks/powers, you then reference which weapon and pick that attack bonus.

Hope that helps!

As for my "issue" (as the Eladrin one has been pointed out already), when making a ranger with the two-blade style, there isn't enough room under the powers to add the secondary attacks and/or effects.

Also, is there away to get rid of all the magic items found on character sheet II (other than un-protecting the sheet and manually deleting them)?

[redwulf25_ci]

Point buy isn't the only system. What about those who are using the "standard array" or those who still roll?

(edit: Ok, it will let me go negative and apparently you just get the standard array by putting the starting value of 8 in the score that will be a 10 but those seem like clunky work arounds.) It looks good otherwise.