Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Rorik]

Howdy ya'll,
Just wanted to say that this sheet is awesome, thank you for spending so much time on it!!!


Is there a way to import from the xpversion to the xpextras?

[tecnowraith]

Any way to transfer characters between updates?

[Amurayi]

Originally Posted by Rorik

Howdy ya'll,
Just wanted to say that this sheet is awesome, thank you for spending so much time on it!!!


Is there a way to import from the xpversion to the xpextras?

No sorry. But even in the full version there is hardly a connection between the sheets.

[tecnowraith]

Does the XP tab do autocalculate the xp gained for each session? If so where to put the xp?

[dulac50]

I really appreciate the work on this. I initially had trouble with the fact that I use Excel 2003 and was getting the "too many formats" errors.

I have been using the charsheet to create several characters for an upcoming local convention in California known (once again, long story) as Pacificon.

The character that I have been working on that I observed problems regarding is a swordmage.

Items noticed thus far:
1. Corellon on Basics page deity dropdown page is spelled Coreelon.
2. The at-will spell list for the swordmage does not include Sword Burst on the powers page.

On the attacks page, I cannot figure out how to enter the ability that the power is based on. For example, Earthshock (a Genasi racial power) is based on STR or DEX or CON ability modifier (player chooses one and the character alway uses that ability modifier) +2. However, I cannot figure out how to get the STR ability modifier to show up in the ability box on the powers section of the sheet.

On the Character Sheet, Earthshock should show up as Ability 3 (based on STR=17) with a +2 (should be in BAB or added to ability amount).

I have the same problem with the other powers. I can't figure out how to enter the ability amount for any power.

Thanks for your help!

[dulac50]

I forgot to mention that the character sheet does not show the proficiency bonus of the longsword in the basic attach bonus.

[Liane the Wayfarer]

Nice! I really like the functionality you guys managed to fit in! One foible I noticed: I created a Warforged Artificer, and under the Skills tab, it lists Acrobatics as "trained" -- this should probably be "Arcana" on row down.

I should note that this is with full version 1.15 of the sheet.

[James McMurray]

Great work!

I've been working to add my quick view stuff to this new version, and just adding it in caused the "too many formats" error. I got around it by going in and stripping all of the formatting from the hidden sheets, since the stuff nobody sees doesn't usually need to look great. It can still be bodered and made bold or italic for readability.

I don't know if that would be enough to let older excel open the combined version or not, but it might be worth looking into. That way you've only got a single file to update when changes are made, and there's no chance of the two accidentally drifting apart.

[James McMurray]

I did a quick test by just copying the sheets into the one without formatted hidden pages and they all fit except the LFR tracker, but if I fiddle with it I could probably squeeze it in as well with a little standardization of the formatting of other pages.

[Mithreinmaethor]

Originally Posted by dulac50

I forgot to mention that the character sheet does not show the proficiency bonus of the longsword in the basic attach bonus.

This Problem has to do with the fact that the weapon prof of the Swordmage is so screwy. And in the sheet it is not listed the same as the writeup. I believe the longsword shows correctly on all other classes sheets.

[Christopher Robin]

Also, on the attacks tab, when picking implements, there's no option for a Swordmage, who use their weapon. Wait, can I just select my normal weapon but use Int instead of Str? Ninja Edit: That would be a no, because then it adds weapon proficiency. Silly me, I should have realized that ahead of time.

Also, how do I add something like Flame Cyclone to the attacks tab? It uses 2 bonus' of Int and Str, how do I add a second bonus under favorite powers?

[Mage189]

I found a bug in things. You've got Artificer's trained class skill set to Acrobatics instead of Arcana.

Looks nice so far though. Thanks for making a version for those of us per Excel 2007.

[CharlesCurtisStanley]

On the Class Features sheet, change the formula in cell W48 to read:

=IF($U38=TRUE,", "&$B38&$X48,$X48)

This fixes the problem of two of the Swordmage's class features being printed twice in the Class/Path/Destiny Features section of CharsheetII.

[infocynic]

Originally Posted by Christopher Robin

Also, on the attacks tab, when picking implements, there's no option for a Swordmage, who use their weapon. Wait, can I just select my normal weapon but use Int instead of Str? Ninja Edit: That would be a no, because then it adds weapon proficiency. Silly me, I should have realized that ahead of time.

Also, how do I add something like Flame Cyclone to the attacks tab? It uses 2 bonus' of Int and Str, how do I add a second bonus under favorite powers?

For powers with two attributes determining the attack roll: I would pick whichever one is more likely to increase as the attribute for the bonus and punch the other in the Attack Bonus (i.e., Feat) or Misc Bonus Override.

For powers with two attributes determining the damage bonus: Again, pick whichever is more likely to increase as the bonus ability damage and put the other in damage bonus (any).

[Yarthok]

Thanks again for creating your excellent character designer!

I don't own a copy of Excel and instead use OpenOffice 2.4.1 (latest non-beta release) on Vista. In order to get some of the calculations to work in openoffice, I made the changes listed below. If the changes are appropriate to Excel, then I hope you will consider adding them to your version. The list is only what I have discovered for the characters and levels I have designed.

(Modifications to wiesbaden_charsheet_v1_15_Full.xls to work with OpenOffice 2.4.1)
 
$'Transport Attack'.D8 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =D6*C8
new value ==> =VALUE(D6)*VALUE(C8)
 
$'Transport Attack'.C25 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =IF(D17=TRUE();C19*C20+C21;"")
new value ==> =IF(D17=TRUE();VALUE(C19)*VALUE(C20)+VALUE(C21);"")
 
$'Transport Attack'.D25 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =IF(D17=FALSE();IF(AND(D19=0;D20=0;D21=0);D23;D19*D20-D21);"")
new value ==> =IF(D17=FALSE();IF(AND(VALUE(D19)=0;VALUE(D20)=0;VALUE(D21)=0);VALUE(D23);VALUE(D19)*VALUE(D20)-VALUE(D21));"")
 
$'Charsheet I'.CT15
old value ==> =10+SkillInsight
new value ==> =10+VALUE(SkillInsight)
 
$'Charsheet I'.CT21
old value ==> =10+SkillPerception
old value ==> =10+VALUE(SkillPerception)
 
$'Pro Sheet'.BG58
old value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.J44;.$8:$14;2;FALSE())&IF(OR(.J42="";.J42=0);"";"+"&.J42);.J46))
new value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.I44;.$8:$14;2;FALSE())&IF(OR(.I42="";.I42=0);"";"+"&.I42);.I46))
 
$'Pro Sheet'.AH20
old value ==> =10+SArcana
new value ==> =10+VALUE(SArcana)
 
$'Pro Sheet'.AH23
old value ==> =10+SNature
new value ==> =10+VALUE(SNature)

Again, thanks so much for your hard work. I know you chose Excel 2007 as your target. Anything you can do to accomodate openoffice user's is very appreciated, but I recognize the difficulty of trying to make your spreadsheet work in multiple programs.

I am not an Excel or a Calc guru, so any feedback on the above code is appreciated.

[ExilOstfriese]

i found a bug:

xpversion powers tab

in the wizards extra daily & utility dropdowns the last 3 selections are cut off, starting at lvl 5
the illusion spells (phantom chasm, phantasmal terrain,...) are missing completely

ie:

lvl 10 utility:
main----------extra
blur-----------blur
mirror image
resistance
illusory wall

lvl 15 daily
main----------extra
bigbys--------bigbys
blast of cold--blast of cold
otilukes
prismatic b.
wall of ice

---------edit-----------
the expanded spellbook column acts wonky, too

[infocynic]

Originally Posted by Yarthok

Thanks again for creating your excellent character designer!

I don't own a copy of Excel and instead use OpenOffice 2.4.1 (latest non-beta release) on Vista. In order to get some of the calculations to work in openoffice, I made the changes listed below. If the changes are appropriate to Excel, then I hope you will consider adding them to your version. The list is only what I have discovered for the characters and levels I have designed.

(Modifications to wiesbaden_charsheet_v1_15_Full.xls to work with OpenOffice 2.4.1)
 
$'Transport Attack'.D8 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =D6*C8
new value ==> =VALUE(D6)*VALUE(C8)
 
$'Transport Attack'.C25 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =IF(D17=TRUE();C19*C20+C21;"")
new value ==> =IF(D17=TRUE();VALUE(C19)*VALUE(C20)+VALUE(C21);"")
 
$'Transport Attack'.D25 (repeat for all 'basic attack' & 'power' blocks on the same sheet)
old value ==> =IF(D17=FALSE();IF(AND(D19=0;D20=0;D21=0);D23;D19*D20-D21);"")
new value ==> =IF(D17=FALSE();IF(AND(VALUE(D19)=0;VALUE(D20)=0;VALUE(D21)=0);VALUE(D23);VALUE(D19)*VALUE(D20)-VALUE(D21));"")
 
$'Charsheet I'.CT15
old value ==> =10+SkillInsight
new value ==> =10+VALUE(SkillInsight)
 
$'Charsheet I'.CT21
old value ==> =10+SkillPerception
old value ==> =10+VALUE(SkillPerception)
 
$'Pro Sheet'.BG58
old value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.J44;.$8:$14;2;FALSE())&IF(OR(.J42="";.J42=0);"";"+"&.J42);.J46))
new value ==> =IF(AQ54="";"";IF(.I46="";.I40&"+"&VLOOKUP(.I44;.$8:$14;2;FALSE())&IF(OR(.I42="";.I42=0);"";"+"&.I42);.I46))
 
$'Pro Sheet'.AH20
old value ==> =10+SArcana
new value ==> =10+VALUE(SArcana)
 
$'Pro Sheet'.AH23
old value ==> =10+SNature
new value ==> =10+VALUE(SNature)

Again, thanks so much for your hard work. I know you chose Excel 2007 as your target. Anything you can do to accomodate openoffice user's is very appreciated, but I recognize the difficulty of trying to make your spreadsheet work in multiple programs.

I am not an Excel or a Calc guru, so any feedback on the above code is appreciated.

If you were to change the number format of the cells that you have to VALUE() to number from general or text, would that get around the VALUE() problem? Seems kind of lame for a spreadsheet program to require you to put VALUE() around any cell you want to use as a number in a formula... shouldn't that be the default? I've never used OO, but obviously I've used Excel a lot...

[Yarthok]

Originally Posted by infocynic

If you were to change the number format of the cells that you have to VALUE() to number from general or text, would that get around the VALUE() problem? Seems kind of lame for a spreadsheet program to require you to put VALUE() around any cell you want to use as a number in a formula... shouldn't that be the default? I've never used OO, but obviously I've used Excel a lot...

Infocynic,

Thanks for the suggestion. I checked and the cell format is already set to 'number'. I can't seem to force a text string cell value into a number when the cell value is produced by a formula that results in a text string.

e.g SkillInsight is produced from (partial... ;"+"&F73+B73+ ...) which, by using the text concatenation operator '&', converts the numeric addition calculation into a text string with a '+' prefix. The final resulting cell value is a text string. The VALUE() function, that I used in other cell formulas is converting that text string into a number so it can then be used in a mathematical function (e.g. to compute passive insight.)

If the origin cell starts out as a number, then no conversion is required.

[Kralin Thornberry]

Every time I try to create a drow character, it gives me an error (and I cannot select the drow from under the FR selection either).

[infocynic]

The right way to do it then, Yarthok, is to use custom formatting on these cells.... and I realize this isn't your problem per se, but in Excel, we can set custom formatting on the cells, so I can give this string

+#0;-#

and it will give me +X if X is 0 or more and -X if X is negative. (It's also possible to get a third format in for exactly 0, but I didn't see the need here).

The formula bar still shows "10" for example and it works like it should in calculations.

This of course requires changing a lot of formulas all over the place, but if this works, we don't have to mess with "VALUE()" any more. It also makes writing new pieces easier because you don't have to mess with ugly IF tests that are only there for formatting a "+" or "-".

I'd do it myself but I'm working on another side project for this tool...