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

Ok just to fill in a bit more info I seem to be specifically coming unstuck in filling out the right spaces for the basic attacks and then the powers section below it. Out of interest, how do you fill in the section that are not highlighted like "effect" etc? I can see this saving me a lot of time if I can only figure out how you're supposed to use it.

thanks

Ab
 

log in or register to remove this ad

Ok just to fill in a bit more info I seem to be specifically coming unstuck in filling out the right spaces for the basic attacks and then the powers section below it. Out of interest, how do you fill in the section that are not highlighted like "effect" etc? I can see this saving me a lot of time if I can only figure out how you're supposed to use it.

thanks

Ab
0. Please don't double-post. :)
1. Create an attack bonus for each Ability / Weapon combination that you attack with. For a cleric, you might have Strength / Mace, Wisdom / Holy Symbol, Strength / Javelin. If you cross-classed Wizard and took Scorching Burst, then you might have Intelligence / Wand as another.
--1a. Select the weapon or implement type at the top right under "Attack Bonus". If you want, give it a name, for example, a fighter could have an axe named "Great Cleaver"... it's just for flavor.
--1b. If the weapon or implement has a magic item bonus (+1 to +6 unless you're using custom things not in the PHB), add that next
--1c. Select the ability that you use with attacks based on this weapon or implement. So for the Mace and Javellin, this would be Strength, and for the Holy Symbol, Wisdom. If you have a multiclass wizard feat, then you would have one that uses Intelligence with the Implement you chose.
--1d. If you have a feat that gives you +1 or more to attack rolls (these are very rare) and that feat would apply to this attack, enter that bonus under ability.
--1e. The Misc bonus is calculated for you. It's usually 0 unless you're a fighter with a weapon talent that applies. If it's wrong, you can override it in the last yellow box.
--1f. The sheet adds up all the bonuses including the proficiency bonus for the weapon (assuming you ARE proficient) and comes up with a Base Attack Bonus. For example, a level 1 fighter who chooses 1-handed weapons as his class feature, wields a battleaxe, and has a Strength +3, would be at +6 for a Strength / Battleaxe attack. If that same fighter grabbed a Maul, it would only be +5 because the Maul is 2-handed. If this number doesn't look right, check your earlier steps.

2. Define attacks. You will have one attack for basic melee, one attack for basic ranged, and up to 5 powers, which covers MOST level 1 characters. Higher-level characters should emphasize listing powers they use most often.
---2a. Select the name of the power. If you entered your powers earlier, they will be in the drop-down now.
---2b. Select the attack bonus that applies. You just created attack bonuses for various situations, use the one that fits with this attack. Is this a Strength attack like Priest's Shield? Select your Strength/Mace attack bonus. Is this a Wisdom attack like Lance of Faith? Select your Wisdom/Holy Symbol attack bonus. The sheet fills in the base attack bonus in the white cell below the defense.
---2c. Select the defense that the attack is against. See the PHB for the definition of your attack if you don't recall.
---2d. If for any reason the attack bonus for this attack doesn't match up with what you think it should (unlikely), you can enter an override in the yellow here.
---2e. Enter your damage dice. For weapon attacks, you need to look up the weapon value (Mace is 1d8) [or use the modified version I posted earlier, but I'm assuming for now you're using the official version]. For non-weapon attacks, the damage is usually part of the power description, like Lance of Faith is 1d8 or Turn Undead is 1d10. Enter just the part that's "[x]d[y]" here.
---2f. If you have a damage bonus from the power, from a feat or otherwise (racial, class, perhaps) then enter that bonus next. Don't enter things like +3 for Strength here, the sheet will take care of that next. For example, if there were a power that said "Deal 1[W]+2+Strength modifier damage" you would put that 2 in the damage bonus field.
---2g. Select the ability to deal extra damage based on, or none if there is no extra damage (for example, Ranger's Twin Strike is 1[W] but does not add ability modifier damage).
---2h. The sheet will caclulate the damage expression (e.g., 1d8+4 for Lance of Faith if you have 18 WIS). If it looks wrong, you can check your work or enter an override. If you enter an override, give the whole damage expression like 1d10+3.
---2i. The sheet will calculate the critical damage (= max all dice), including any "High Crit" bonuses that apply. If this isn't right, check your work or enter an override which can either be a single number or an expression (the only time you would have 1d8 or 1d6 etc in the crit expression is when you have a high crit or magic weapon).
---2j. Enter the keywords for the attack from the PHB. These don't impact the damage or attack calculations but are important to know.
---2k. Enter the range, such as Melee, or 10/20 for a thrown javelin, or 5 for Lance of Faith, or Close Burst 2 for Turn Undead
---2l. Enter the target, such as "One creature" or "All undead in burst", etc. See the PHB if unsure.
---2m. Under effect, give the text of the power for Hit (not for effect, slightly confusing but such is life). If there is no effect beyond damage, you don't need to list anything here. For Lance of Faith you might put "Radiant damage. One ally I can see gains +2 power bonus to next attack vs. the target".
---2n. Select the Action type (Standard, move, minor) and the Power Type (At-will, Encounter, Daily). See the PHB if unsure. Last, enter a PHB reference page so you can go look it up again if you have any questions during play.
 

The versions of the sheet that I have downloaded, including 1.12, do not seem to support Paragon multi-classing. Or at least, the Eladrin Warlord/Wizard I was creating was unable to select wizard powers at 11th and 12th level after taking the 4 required feats.

Do any of the versions support Paragon multi-classing?
 

HI infocynic and first of all thanks for answering my question in such detail. I am working through your answers. First off, why under basic attack am I getting the sheet giving me n/a under damage. I have put in the right value in the field damage dice?

Also I am getting the message use critical overide? is it because I've made a mistake somewhere?

I will work through the rest shortly...family has arrived etc ;)

thanks

Ab
 


INfocynic I've emailed you from here since i don't have a way to get your email otherwise, pm or email back the address you want me to zip it to you.

Thank you. I appreciate the help.

Ab
 

Love the new version 1.12, but I found a semi-large bug.

The Initiative Cards have the Passive Arcana and Nature pointing to the AC and giving that value. I can probably fix this if I know what I should change those cells to, otherwise these cards can't really be used as is right now.

Also on the Attacks tab you have all the formulas and such on the right side un-hidden (probably a mistake).

Also as a note you should have an area on the sheet for the sex of the character (male/female) as that is usually found on these sheets.

But I love the sheet! Wish you had more room for the Power effects on the 1st page, or at least make the font smaller as it's impossible to fit the "full text" inside the area you have for any one power. Thanks!
 

Love the new version 1.12, but I found a semi-large bug.

The Initiative Cards have the Passive Arcana and Nature pointing to the AC and giving that value. I can probably fix this if I know what I should change those cells to, otherwise these cards can't really be used as is right now.

=SArcana+10
=SNature+10
 

I do not know if this has been noted. But when you chose a magic bonus on the attacks page it does not populate the enhancement bonus to the damage for the weapon.
 


Remove ads

Top