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

[oldbone]

How do you edit armor of you have Eladrin armor? I tried overriding the -1 speed/skill check and it didn't change my speed. (I tried 0, -1, and 1)

 

[Amurayi]

First off: Thanks warderbrad for helping answering questions. We appreciate it! And a big thanks to everyone posting, reporting bugs and contributing suggestions here. We read every post and consider every option you guys propose!

Biggest thanks goes to Anna, who covers all the Excel programming now!

Some requests for more infos:

>Selection of Skill Training as a Feat triggers the list prompt, but the list is inaccessible, making actual selection of the Skill Training impossible.

No idea what you mean here. Please give more details. Thanks!

>On Character Sheet II within the Class/Path/Destiny Features: Paragon Path Features longer than two lines do not display properly. On Character Sheet II within the Feats: Epic Tier Feats longer than one line do not display properly.

We can't recreate this problem. Please give an example of class, level and Paragon Path. Thanks!

>The First Favorite Powers (RANGED BASIC ATTACK) by default Eldritch Blast, in independence of a class

Huh, sorry? What do you mean here?

>For powers 6-N can't they be entered on the same chart and then just display #6 on using the same format on the 2nd character sheet? That way you can track them all in the same format.

Please explain a bit further. We don't understand what you want here.

Selection of Skill Training as a Feat triggers the list prompt, but the list is inaccessible, making actual selection of the Skill Training impossible.

It seems to work for us. Please details your char build and when the error accurs. Thanks!

Bug: if you enter 0 for the damage (e.g., "Cause Fear" Cleric Encounter 1), critical damage will be #VALUE instead of 0

Simply don't enter anything. That should do it, too.




Some insights:

Would it be possible to have fields for all the things that could add to a particular ability for damage bonuses? For instance, individual fields for the user to type in bonuses from feats, from enhancements, and then a couple of miscellaneous fields

We considered and did a rough layout. It turned out to look more complicated than doing the math for D&D really is. So instead we'll leave it as is to keep it simple.

>I am also wondering if it's intentional that armor and shield are entered twice on the Armor & Equipment tab (under armor & shild and under equipment) as opposed to one looking it up from the other.

In the equipment table you can enter whatever fantasy name you want for your items. In the left table you have to select the proper type so the bonuses calculate correctly.

Open Office / Macros / Saving char in external file

We started to go throguh the current file to make it more compatible for Open Office. It's not our prime focus atm though
.
We have no expierience with macro programming. So unless someone else does you most likely won't see any kind of feature like this from us. Sorry!

I input the data into the powers sheet that happily spat out the numbers for BAB, but the corresponding basic attack stuff had to be entered by hand. Was this the intent?

The Basic Attacks could be different for every class. So we leave it up to the player to enter whatever they want.

I have spent the last day and a half entering all the data from the PHB powers and am in the process of redoing the entire attacks tab

We won't cross this line for copyright reasons. If all the powers would be fully implemented you wouldn't need a PHB anymore. The new 4E gaming license doesn't even allow to create char generating software. We are walking on thin ice here already. You won't offer a file which has all the details of the PHB. Go buy the book and look forward to WotC CharGenerator tool in D&D Insider! Meanwhile use our lil' tool here.

What is your opinion of someone ripping out your calculations and using you layout for a very differently focused sheet?

You're welcome to do it!

any chance the fields or text could be made a bit larger for folks wearing readin glasses?

Hmm, we have a LOT of infos to give. Hardly see a way to make parts bigger. Anything in particular you find hard to read? But we are are fiddling with options to make the fints bigger on page 2 if you have less than X feats for example.

how do I: 1) Edit the backpack section? Can't find it.
2) Type in the Equipment's Weight

You edit the backpack section irght on teh charsheet. Everythign that's yellow there can be edited. Don't write down weight! The excel sheet will delete itself if you write down the weight of objects!
(Seriously: We believe that weight is nothing a hero should be concerned about. There are no weight fields.)

The second part of the full description (the part that describes the damage) of the Multi-class Sneak Attack from the Class Overview Sheet, cell X19 is missing.

Cell X19 is for the rogue class, not for the multiclass feature. We might add the damage info in an upcoming version though.



Some things people considers bugs but aren't:
- Rangers do get "Toughness" if they chosoe "Two Weapon FIghtign Style". They do NOT get "Two Weapon Fighting" (p.201). See page 104.
- Extra feats and skills for humans and Eladrins will automatically be added to your "skills/feats avaiable".

 

[Kralin Thornberry]

>The First Favorite Powers (RANGED BASIC ATTACK) by default Eldritch Blast, in independence of a class

Huh, sorry? What do you mean here?

First off, let me thank YOU for making this sheet, it's awesome!

Now, what he means by this is, no matter what class/race you make, Eldritch Blast comes up at the Ranged Basic Attack on the attack section.

It appears that name place holder (for an example of what to put) is always Eldritch Blast.

Easy enough solution is to click on the box and type in short bow, crossbow, etc.

 

[Eccles]

The lvl 9 warlock daily Curse of the Black Frost is misnamed Curse of the Black Forest.

That's a much better name! Can we leave the spreadsheet as it is and change the PHB?

 

[Amurayi]

That's a much better name! Can we leave the spreadsheet as it is and change the PHB?

ROFL!!!

Damn, guess the reason why we misread this is that we actually DO LIVE close to the original "Black Forest" in Germany.



New version online:

Version 1.11: RELEASED 06-20-08
New features:
- Expanded Spellbook is featured now
- Design Update: Some fields vanish if you do not need to select anything (like no Extra Power selection if you are not a Wizard)
earlier
- Override field for race
- Override field for abilitys (works up to 50)
- Under "equipment" you can select a weapons you noted on the "attacks" page in Weapon slot 1
Design changes:
- Potions can now be deleted from backpack
- Shield will appear on charsheet even you don't enter a description
- changed postions of "rituals" and "utility" powers field so all powers are closer together
- Human and Half-elf extra powers are now listed under the regular power table
- If you select a skill you are already trained in, the X turns red
- "Power Attack" feat got a bit longer description
Bug fixes:
- Several spelling erros
- "Toughness" appears on Feats list of you pick the Ranger's Two Wepon fighting style (hp were calculated correctly before though)
- Override fields for armor skill and speed penalty fixed
- East Rift now selectable as LFR region (now for sure! )
- Eladrins now gain their proficiency with Longswords as intended
- All "Range" fields don't give out dates anymore
- Tiefling Fire resistance bonus was calculated incorrectly
- Attack bonus override now is a real override
- Armor Check bonus override now works as intended
- "Toughness" now correctly appears if you select the Ranger's Two-Weapon fighting style
- "Rogue Weapon talent" now works as intended
- "Arcane Initiate" feat: You can now select powers
- Fighter attack bonus for one-handed or two-handed weapons now shows up in all BAB fields

 

[warderbrad]

Quote:
Open Office / Macros / Saving char in external file

We started to go through the current file to make it more compatible for Open Office. It's not our prime focus atm though
.
We have no experience with macro programming. So unless someone else does you most likely won't see any kind of feature like this from us. Sorry!

Actually making it Open Office compatible and putting in macros are exclusive, since Open Office does not support Macros.

As for saving to an external file, it is not hard, but at the current time the sheet is not so big as to need it anyway. When the sheet gets to the point that it is so big it cannot be emailed even by zipping it then such a thing should be considered.

One macro that would be easy enough and would help (again not usable in Open Office) would be one that would reset all fields to their default values. This can be replicated by saving a fresh copy and never overwriting it but accidents can happen. The question then becomes should the sheet strive for compatibility with OO or be more robust and such.

 

[GorTeX]

I like what you've done with this sheet so far.

I think splitting the damage out would work better (see attached)

Makes changing one thing easier (change of weapons, ability mod, feats etc).
I just added lines
Damage die (XdY)
Ability Mod to Damage
Feat Mod To Damage
Misc Mod to Damage

the damage line is now the formula of
=IF(E37<>"",E37&"+"&TEXT((E39+E41+E43+E10),"0"),"")

 

[Superboy]

ROFL!!!


- Fighter attack bonus for one-handed or two-handed weapons now shows up in all BAB fields

Awesome! Thanks!

 

[Hambot]

What is the best way to update a character sheet version 1.10 to 1.11?

ie. What is the best way to copy and paste the data across in excel 07 from an existing sheet to the new version? Is there a way to do it sheet by sheet, or are you stuck doing it cell by cell?

Other than typing it all out again with each update, that is.

 

[GorTeX]

if you copy sheet for sheet, you'll lose the new additions or mess up some formulas (most likely).

Doing it by hand again isn't that difficult, and you can copy/paste the text only cells