Macroless Quick View Page for the Wiesbaden Wondersheet

[btcorrad]

I'm really torn here ...
I LOVE your updates to the Wiesbaden. However, I really prefer the Power 1-5 on the Wiesbaden attack page rather than being forced into including an off-hand and implement attack on the final sheet as part of my 5 favorite powers. Is there a way to have the [W] functionality and other bonuses (like regular updates) from your update combined with the configurable freedom of the 5 favorite powers from the original?

 

[James McMurray]

I haven't tested it, but since I didn't change anything on the character sheet you should be able to write over the off-hand and implement slots and have them show up on the character sheet. You'll get funky results on the quick view page if you ever pick up a power that uses an implement or two weapons.

I'll play around with it some this weekend and see if it still works that way. And if not, I'll see what I need to do to fix it.

 

[btcorrad]

I tried to replace off hand with dragon breath, using Attack Bonus 5 (STR with attack bonus 2). I replaced 1[W] with 1d6 and the damage field didn't propagate. It also tells me the damage field is protected. Now, I know I can just change the protections but it seems a shame that 1[W] works so well in the other attack columns and propagates nicely to the damage field but I can't get a similar effect for any other attack columns I would change.

I am not complaining, you clearly have experience and great knowledge with Excel. Also, I'm sure that I'm not the only one who can't thank you enough for continuing work on such a great tool.

 

[GorTeX]

I haven't tested it, but since I didn't change anything on the character sheet you should be able to write over the off-hand and implement slots and have them show up on the character sheet. You'll get funky results on the quick view page if you ever pick up a power that uses an implement or two weapons.

I'll play around with it some this weekend and see if it still works that way. And if not, I'll see what I need to do to fix it.

You need to copy over the formulas (which might mean unprotecting the sheet)

Copy G28 to I28 and K28 (this copys the selection drop down as well..so you can change the type of attack, even include a power)

Copy I48 to K48 (damge for implement has been blanked out, this fixes that)

Copy I51 to K41 (Crit damage for implement is 'different' than all the other lines..this fixes that)

Do we really need an 'Implement attack' section? You never use an implement by itself, only with powers..

The power name on Character Sheet 1 uses the Power selected line, not the title, for the power name, so you don't have to worry about the Title (in bold) 'Off Hand Basic Attack', as it'll use what ever is in the box below it for the power name.

 

[btcorrad]

^^
You guys are awesome! That saves me a lot of time. My experience with excel is limited and I've been swamped at work. I still haven't decided whether to just change data validation to 'any' for the Weapon 1 slot on the equipment tab or just fill in the hidden list and propagate the drop-down to the other weapon fields.
And, I am lazy LOL

 

[pukunui]

Thanks for the sheet, James.

I like this new sheet better ... however, I'm finding that the Quick View isn't calculating attack bonuses correctly. My one of my players has a dragonborn paladin with 18 CHA and a battleaxe. He's just reached level 2, so his attack modifier for his CHA-based powers is 4 + 2 + 1 = +7 but the Quick View is only coming up with +6 for the powers, so it would appear that it's not including the 1/2 level modifier. Either that or it's using STR instead of CHA (his STR is only +3). Any thoughts? Am I doing something wrong?

Cheers,
Jonathan


EDIT: It would appear there are quite a few errors with the Quick View page. The ranger's Hunter's Bear Trap and Evasive Strike powers have "#VALUE!" in their Effect section, and Nimble Strike uses a ranged attack but gives the wrong damage (d8 instead of d10 for a longbow). Twin Strike has "#VALUE!" in the attack section.

 

[Hawke]

There's certainly bugs, but this is the most promising sheet out there right now. The more we get the details to James, the more quickly everything can be ironed out... any tips on bug tracking that'll help you make the corrections?

 

[GorTeX]

Macroless sheet..probably from now on, as I really like it..

Data Sheet: (hidden)

1) Wizard Spell Cloud of Daggers: the formula for the desciption reads

(FLOOR((Level-1)/20,1)+1) & "d6 + " & ForceDmg + IntMod + ImpMagicBonus & ". Effect: Area does " & MIN(WisMod,1) & " to creatures in or entering the area until the end of your next turn." & ForceText

MIN(WisMod,1) should be MAX(WisMod,1)

2)Power decriptions in General
Probably should work on something to better automate the damage, instead of having to put ForceDmg + IntMod + ImpMagicBonus in each one. What if there is a misc mod that applies?

3) Abbreviations. I think you have the room to use less abbreviations.

4) you have Attack type, Range, Area and Display range columns. For the most part, the Attack Type, Range and Area are correct. However, the Display range is often not correct, especially with Ranged Burst areas--they are almost all listed as 'CL BU X'

Suggestion: develop a formula that figures the display correctly (good luck, all I'm coming up with right now is a Huge nested IF statement). otherwise, manually edit them.

For ranged Bursts, Bu X R Y
for close bursts, Cl Bu X
For Close Blasts, Bl X (there are no ranged blasts at this time)
For Walls, Wall X R Y
for ranged attacks, just X
Cloud of daggers could be 1S R10

5) Color Spray only has Cl Bl listed. Should be Cl Bl 5 (also missing range and area )

6) Wall of Fog should be W 8 R10 (missing range and area, attack type shows Bu)

now for some thing that is probably a bug in the Wiesbaden Sheet.
Wizard weapon prof. erroneously list the Rogue weapon prof.
Fixed by modifying the hidden 'Class overview' sheet. V154 should be J16 thru J23, not G17 thru G21 (could get away with just J16 and J17)



Keep up the good work. It amazing to me that so few errors creeped in with over a Thousand powers entered.

 

[btcorrad]

I keep trying to figure out how to make the attacks page work with dragon breath so that I could add it as one of the 5 favorite powers and have it display the correct [W] info and attack bonus.

I tried adding Dragon Breath as an entry under Improvised list (hidden in Z14-AB60) and copying over the TRUE entry and formula and alternatively the FALSE with no success. I can't get M20, 22, 24 to fill in so I know I'm missing some entry or formula.

EDIT: I've also unhidden the ExportSheet (added in Dragon Breath there as an improvised weapon and mad formula changes to include cell Q87) and Transport Attack sheets. This has confused me a little more because I don't really see the need for implement or Off-hand information to be available on every character sheet since such a small fraction of characters will even use that enough to need it so prevalent in the finished product.

Again, not complaining, just curious on how to modify.

 

[James McMurray]

I haven't gotten to the wizard spells yet, but all of the attack entries should now be calculated using the approporiate implement, weapon, and attribute bonuses. The fact that some powers use different attributes completely slipped my mind when I did it the first time around, so I was just referring the weapon or implement being used without regard to stat.

I also set the range to calculate itself so it won't be as vulnerable to me screwing up.

Next up is fixing the wizard spells. Then I'll go through and make sure the powers with secondary attacks are also using the right bonuses.

By that time my eyes will probably be be bleeding from starting at my screen, so I'll take a break.

I keep trying to figure out how to make the attacks page work with dragon breath so that I could add it as one of the 5 favorite powers and have it display the correct [W] info and attack bonus.

I tried adding Dragon Breath as an entry under Improvised list (hidden in Z14-AB60) and copying over the TRUE entry and formula and alternatively the FALSE with no success. I can't get M20, 22, 24 to fill in so I know I'm missing some entry or formula.

The formula for the calculation accidentally got deleted. On the attacks page in cell M20 (aka BAB5) put

=IF(M6="","",IF('Transport Attack'!I34>0,"+","")&'Transport Attack'!K34)

That should calculate the bonus for you. If you want it to automatically update your +2, +4, or +6 based on level, put the following in cell M15

=2 * (FLOOR((Level-1)/10,1)+1)

To autocalculate the damage put this in the damage dice slot for the favorite power:

=(FLOOR((Level-1)/10,1)+1) & "d" & IF(Feats!B150<>"", "10", "6")

That should give you the right dice, and make them d10s if you have the feat.