Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Zvenn]

ok i guess i should edit that and say it works fine for me hehe im running it on 2003

[PhantomAOJ]

I tried it again, I am using the sheet in the zip labeled "wiesbaden_charsheet_v1_17_XPversion" with MS Office 2003 sp3 (11.8169.8172) and receiving Too many Formats.

Other than the magic Item Bonus counting twice for damage, 1_16 is working for me.

Thanks!
PhantomAOJ.

[Wraith Form]

You could get the Office 2007 compatability pack, free from Microsoft's Office web site.

Here's a linkie to help:
Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

[dulac50]

Bottom line is that the version listed in the download as weisbaden_charsheet_v1_17XPversion DOES NOT work on the XP version of Excel or Excel 2003. Therefore the lable is incorrect. It is not an XP version. I have also looked at the weisbaden_charsheet_v1_16XPversion that downloads with the 1.17 version and it still has the magic bonus doubling problem.

[Mithreinmaethor]

Originally Posted by Wraith Form

You could get the Office 2007 compatability pack, free from Microsoft's Office web site.

Here's a linkie to help:
Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

I downloaded this and installed it. I am using Office XP. Unfortunately it still does not work for me. Its ok I dont mind using Open Office for this.

[ReadError]

Originally Posted by Wraith Form

You could get the Office 2007 compatability pack, free from Microsoft's Office web site.

Here's a linkie to help:
Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

The format limit is in the program, a compatibility pack wont help.

[xone01]

I notice several people still having problems with magic item bonuses doubling. I posted this solution a little while back and it seems to fix the problem, so here it is again...

Originally Posted by xone01

All right, I think i've isolated the problem with adding enhancement damage twice. On the Transport Attack sheet, the "modifiers sign" formula (in row 12) should be "=IF(C11>=0,"+"&C11,C11)"
obviously, this formula needs to be translated for each power to the corresponding cells

...

loving this sheet, keep up the good work.

hope that helps

[Blackwood]

There are some issues with some feats on the Character Sheets I & II that I noticed while working on Genasi characters.

1) Versatile Resistance has a description on the feat page of 5 resist to cold, fire, and thunder. On the Character Sheet I resistances section, it shows up as 5 Lightning rather than Thunder. The Thunder part also does not show up at all on the Extra Bonuses tab (in neither lightning nor thunder spots, though fire and cold show up correctly)

2) The Genasi Feats in the Dragon Magazine 367 section seem to look two spaces up when copying the text onto Character Sheet 2. ie: selecting Primodial Surge shows up in the feats section as "Primordial Surge: Your 'firepulse' power deals an extra 1d6 damage, and gains the reliable keyword". Similarly "Firepulse Master" references the text of Earthshock Master, and the drow feats below have the same property. They all seem to be off by 2 cells.

[xone01]

Originally Posted by Blackwood

There are some issues with some feats on the Character Sheets I & II that I noticed while working on Genasi characters.

1) Versatile Resistance has a description on the feat page of 5 resist to cold, fire, and thunder. On the Character Sheet I resistances section, it shows up as 5 Lightning rather than Thunder. The Thunder part also does not show up at all on the Extra Bonuses tab (in neither lightning nor thunder spots, though fire and cold show up correctly)

2) The Genasi Feats in the Dragon Magazine 367 section seem to look two spaces up when copying the text onto Character Sheet 2. ie: selecting Primodial Surge shows up in the feats section as "Primordial Surge: Your 'firepulse' power deals an extra 1d6 damage, and gains the reliable keyword". Similarly "Firepulse Master" references the text of Earthshock Master, and the drow feats below have the same property. They all seem to be off by 2 cells.

For the Issue with the Dragon #367 feats, simply go to the Feats tab and in cell Z300 (you'll have to unhide it) change the error portion of the formula to K300 and then copy and paste down to the bottom of the section

The Versatile Resistance problem takes a little more digging... On the Extra Bonuses tab, find cell Q23. This is the Resistance Table. The first thing you need to do is fix an incorrect reference here: In cells X25 and Y28, Replace "$W$23" with "X23" and "Y23" respectively. Next, go ahead and change the formulas in X24, Y24, W25, Y25, X28, and Y28 to "0". In order to apply the resistances, we need to change cell S24 to "=IF(F26=0,MAX(V24:AA24)+U24+AB24+IF($AA$20=TRUE,5 ,0),F26)". Then go ahead and copy and paste that formula into S26 and S28.

I believe that'll fix your issues with the resistances

[dulac50]

Originally Posted by xone01

For the Issue with the Dragon #367 feats, simply go to the Feats tab and in cell Z300 (you'll have to unhide it) change the error portion of the formula to K300 and then copy and paste down to the bottom of the section

The Versatile Resistance problem takes a little more digging... On the Extra Bonuses tab, find cell Q23. This is the Resistance Table. The first thing you need to do is fix an incorrect reference here: In cells X25 and Y28, Replace "$23" with "X23" and "Y23" respectively. Next, go ahead and change the formulas in X24, Y24, W25, Y25, X28, and Y28 to "0". In order to apply the resistances, we need to change cell S24 to "=IF(F26=0,MAX(V24:AA24)+U24+AB24+IF($20=TRUE,5,0) ,F26)". Then go ahead and copy and paste that formula into S26 and S28.

I believe that'll fix your issues with the resistances

This is a partial fix. I am not knowledgeable enough to trouble shoot this problem completely. However when I followed your directions, I was able to correct the resistances so that now Fire is 10 for a Firesoul Genasi, Thunder resistance is 5, and Cold resistance is 10. Obviously there is still a problem with the formulae for Cold resistance since it is still 10 and should be 5 for a firesoul.

[apearlma]

Given some of the cell formatting option issues, I was wondering if it was possible to make a custom sheet version where you enter most of the information yourself. But then it would do the calculations for you.

As an example, I don't really need to know every single feat - a page where I could type in the name of the feat, the information necessary for the sheet itself, etc...I do need to know that I've entered in the correct number of feats.

Ditto for powers - we're ending up typing in all the information anyway, not sure why we need to know the names of all the power choices available. But making sure I picked the right number of powers is important.

Don't get me wrong, I love the more complicated version, but I want something that will work on my mac, as that's a lot easier for me - regardless of how many new books they come out with.

[Anywhere]

Ok, I test a lot around and the conclusion is, that either the Initiative Card or the Short Sheet (or one other sheet) must be killed that the XPversion run in Excel2003 or fewer.

What sheet sould be killed in the XPversion? The Initiative Card or the Short Sheet?

greeting
Anywhere

[elandy]

Originally Posted by Anywhere

What sheet sould be killed in the XPversion? The Initiative Card or the Short Sheet?

I think the Short Sheet is most disposable, because the Charsheet and the Pro Sheet are two good anlternatives already. But that's only my opinion.

By the way, in version 1.16 the inititative cards where on the XPextras file (don't know if in 1.17 was like that, because I couldn't open it).

Once again, great work! Keep it going!

Andy.-

[dulac50]

I agree that the short sheet is the more readily dropped item.

[GorTeX]

Have you tried deleting all formatting on the hidden pages? that might allow you to no have to delete a sheet.

[xxxMoDxxx]

Originally Posted by Henry

Mein Deutsch ist schlecht, aber ich danke Ihnen.

According to Google Translate, you're talking about the weapon magic item bonus appearing twice, I think?

Thx for translate.
In version 1.17 the bug was not longer in.

[Thordain]

Any update including barbarian?

[Mithreinmaethor]

Originally Posted by Thordain

Any update including barbarian?

They may not wish to do that. Since the final copy of Dragon is not free property any longer. So not sure if the developers want to include stuff that is not free to the public.

[Thordain]

Originally Posted by Mithreinmaethor

They may not wish to do that. Since the final copy of Dragon is not free property any longer. So not sure if the developers want to include stuff that is not free to the public.

I'm not sure I follow your logic -- the material in the PHB isn't free either. Why would dragon magazine be any different?

[elandy]

I had the chance to try the version 1.17 in office 2007, and as xxxMoDxxx said the problem with the magic item bonus appearing twice on the damage is gone, but some other bugs regarding damage are still there:

- Still not counting the Eladrin Soldier feat (I think the fix that xone01 posted works for this)
- The damage line for powers 6 to 12 (row 105) is not counting any feat bonus to damage (although this is showing correctly on row 99).

Andy.-