Dynamic Excel "Wiesbaden Charactersheet"

[Xris 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]

Duplicated Swordmage Class Features

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.

 

[deleteme123456]

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]

open office calc 2.4.1

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

 

[deleteme123456]

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]

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]

Drow

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).

 

[deleteme123456]

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...