Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Yarthok]

Again, thanks for this great character sheet!

These are the changes I made for wiesbaden_charsheet_v1_17_Full.xls to work in OpenOffice 3.0.
The test character used was a level 30 elf archer ranger.
The last item in the code section below appears to be a bug for both excel & OOCalc.

'At Will' all of column E
From template =IF(Class=A2;C2;"") 
To   template =IF(Class=A2;C2;0)
 
'Encounter' Row 6 giving #REF (causing Encounter powers on 'Power' sheet to fail.)
cut row 7 columns F thru S and paste to row 6 same columns
cut row 7 columns W thru X and paste to row 6 same columns
 
'Daily' column F - zero needed rather than empty string
FROM: =IF(AND(Class=;=G$1);;"")
TO  : =IF(AND(Class=;=G$1);;0)
 
'Daily' column H - zero needed rather than empty string
FROM: =IF(AND(Class=;=I$1);;"")
TO:    =IF(AND(Class=;=I$1);;0)
also 'Daily' column J
also 'Daily' column L
also 'Daily' column N
also 'Daily' column P
also 'Daily' column R
also 'Daily' column T
 
'Utility' Column G - zero needed rather than empty string
From template =IF(AND(Class=;=H$1);;"")
To   template =IF(AND(Class=;=H$1);;0)
also 'Utility' Column I
also 'Utility' Column K
also 'Utility' Column M
also 'Utility' Column O
also 'Utility' Column Q
 
minor spelling
'Equipment'.AC30 compatibel ==> compatible
'Equipment'.AC32 compatibel ==> compatible
 
'Equipment'.AB7 - The armor check reduction for a feat should be a positive modifier instead of negative modifier.
FROM: =IF($32=FALSE();VLOOKUP(Armor_21;.$57:$63;3;FALSE());VLOOKUP(SMaterial;.$72:$120;4;FALSE()))+IF(OR(U9=TRUE();U8=TRUE());-1;0)
TO:   =IF($32=FALSE();VLOOKUP(Armor_21;.$57:$63;3;FALSE());VLOOKUP(SMaterial;.$72:$120;4;FALSE()))+IF(OR(U9=TRUE();U8=TRUE());1;0)

[Laendra]

Originally Posted by 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

Why not kill the sheets totally, and have one workbook be the "creation", and a seperate workbook become linked to the creation book and provide the charactersheets?

[Yarthok]

Originally Posted by Laendra

Why not kill the sheets totally, and have one workbook be the "creation", and a seperate workbook become linked to the creation book and provide the charactersheets?

[two cents]
Rather than maintaining two source bases (like now), or implementing a more complex solution to try to make old Excel versions and new Excel versions work on a single source base (as suggested above) , why not abandon Excel and use OpenOffice instead?

OpenOffice is FREE and anyone can download it. Works on windows, linux, and mac osx.

One version of the spreadsheet, rather than the two maintained now, means a lot less work.
One workbook is more convenient and less complex.
[/two cents]

The authors get to choose what is best and easiest for them. Whatever they choose, or, if they silently leave things the way they are, I am just grateful they have decided to share their hard work with us. The wiesbaden char sheet represents a considerable commitment of time and skill.

[Mithreinmaethor]

Originally Posted by Yarthok

[two cents]
Rather than maintaining two source bases (like now), or implementing a more complex solution to try to make old Excel versions and new Excel versions work on a single source base (as suggested above) , why not abandon Excel and use OpenOffice instead?

OpenOffice is FREE and anyone can download it. Works on windows, linux, and mac osx.

One version of the spreadsheet, rather than the two maintained now, means a lot less work.
One workbook is more convenient and less complex.
[/two cents]

The authors get to choose what is best and easiest for them. Whatever they choose, or, if they silently leave things the way they are, I am just grateful they have decided to share their hard work with us. The wiesbaden char sheet represents a considerable commitment of time and skill.

I would agree. I have Office XP and I use Open Office for this spreadsheet so I can use the latest version. It works fine and makes the file much much smaller.

Also I know this has been asked before. But any way to autopopulate the powers info you input over to the power cards perhaps?

[elandy]

I think I fixed the problem with the damage calculation for powers 6 to 12:

- On the Transport Attack sheet, in cell Q4, replace Q60 with Q6, Q67 (both) with Q13 and Q66 with Q12. Then copy this cell to cells S4, U4, W4, Y4, AA4 and AC4.

- Also on the Transpor Attack sheet, fix the R6 cell: change Attacks!#¡REF! (both) with Attacks!E97. Then copy this cell to cells T6, V6, X6, Z6, AB6 and AD6.

I think with this, and the fixes that posted xone01 (for the proper calculation of Eladrin Soldier feat to damaga, and of Dwarven Weapon Training and Eladirn Soldier to proficiencies) the Attacks tab works fine.

Hope this works for you too.

Edit: Can you add a "Combat Challenge" attack on the dropdown menu of the Choose Power cells of the Attacks tab? For those fighters with Potent Challenge feat or the like? That would be great.

Andy.-

PS: I didn't post all the command line changed, because I use a spanish verison of Office, and some commands change from the english version. I hope I've been clear with my explanation.

[thebane]

New to the forum but very happy with what I am reading.

I am currently filling out the wiesbaden_charsheet_v1_17_Full Character sheet. Having one issue so far, when filling out the 'Base Attack Bonuses (Attack Workspace)' sheet, every time I use Long Bow I get an error [err: 511]... I have tested it out and I only seem to get it when choosing Short Bow or Long Bow. Has anyone else experienced this?

I am currently using Open Office, nothing else seems to be affected.

Thanks,

[drufause]

I have the same error when i select long bow and short bow on at least my elf.

[Yarthok]

thebane, I don't have that problem. What cell does 'Err:511' display in? Also, which version of OpenOffice are you using? 3.0?

[Steve Jung]

Hi,
This is a great sheet. I have a couple issues. I'm using the 1.16xp sheet on Excel 2003. My character is from Cormyr, but his +2 on saves vs fear isn't showing up in the Extra Bonuses sheet. Is there a way of inputing item powers (e.g. Veteran's armor) so they show up on the character sheet in the proper places? Thanks.

[Mithreinmaethor]

Originally Posted by Steve Jung

Hi,
This is a great sheet. I have a couple issues. I'm using the 1.16xp sheet on Excel 2003. My character is from Cormyr, but his +2 on saves vs fear isn't showing up in the Extra Bonuses sheet. Is there a way of inputing item powers (e.g. Veteran's armor) so they show up on the character sheet in the proper places? Thanks.

I would recommend downloading open office 3.0. but i know that on the extra bonuses sheet on 1.17 fear is listed and can be input there. And not sure what you mean by the Veterans Armor. I dont forsee them adding armors and items in the extra bonuses sheet like the old buff sheet. Just have to remember that one with an item card

[thebane]

thebane, I don't have that problem. What cell does 'Err:511' display in? Also, which version of OpenOffice are you using? 3.0?

Yarthok, thanks.

I currently have Open Office 2.4 Woops!

And the error occurs on the 'Attacks' page 'E20'.
If I select Short Bow or Long Bow in the Weapon / Implement Type, the above field comes up as err: 511.

[MMKyt]

You have missed a feat "Against All Odds" from Dragon #364, p.53.

[PhantomAOJ]

Another interesting quirk. The Alchemist Feat from Adventure's vault takes up two feats instead of one. I could not determine why that is the case The code looks the same between Alchemist and any other heroic tier feat.

The work is still amazing despite the few bugs with 1?16 and 1_17. I look forward to the next version, with the corrections and updates. Please keep up the good work!
and Thank you!
PhantomAOJ

[Steve Jung]

Originally Posted by Mithreinmaethor

I would recommend downloading open office 3.0. but i know that on the extra bonuses sheet on 1.17 fear is listed and can be input there. And not sure what you mean by the Veterans Armor. I dont forsee them adding armors and items in the extra bonuses sheet like the old buff sheet. Just have to remember that one with an item card

Problem is that I'm using it on my work computer, so no installation of other programs. As far as Veteran's armor goes, it adds a +1 item bonus to attacks and defenses when you use an action point. I wanted to have that show up is the "Additional benefits when using Action points" space on Character Sheet I and the Table Tent. A place where I can input that myself so it shows up on the sheet is fine. I can do that with the defenses as a temp bonus, but not the attack bonus. No big deal.

[lcquincy]

1.16C SEEMS TO BE WORKING OK FOR ME

1.17 GETS THE WHOLE TOO MANY FORMATS THIING. IN BOTH XP AND FULL

USING MICROSOFT OFFICE 2003

Tom Nolan

[Mithreinmaethor]

Originally Posted by lcquincy

1.16C SEEMS TO BE WORKING OK FOR ME

1.17 GETS THE WHOLE TOO MANY FORMATS THIING. IN BOTH XP AND FULL

USING MICROSOFT OFFICE 2003

Tom Nolan

You will need Office 2007 or later to use 1.17.

Or you can download Open Office 3.0 for free and use 1.17 now. I would recommend opening 1.17 in Open Office let it sit for a few minutes and then save it as an open office document. Much much smaller of a footprint

[brooksgbanks]

Originally Posted by Mithreinmaethor

You will need Office 2007 or later to use 1.17.

Or you can download Open Office 3.0 for free and use 1.17 now. I would recommend opening 1.17 in Open Office let it sit for a few minutes and then save it as an open office document. Much much smaller of a footprint

Maybe I missed something, but why is there both an XP and Full version of 1.17 if it doesn't work in anything but Office 2007? Or, is that meant to indicate that there was some issue with the XP version that is going to be corrected in the next update?

[Mithreinmaethor]

Originally Posted by brooksgbanks

Maybe I missed something, but why is there both an XP and Full version of 1.17 if it doesn't work in anything but Office 2007? Or, is that meant to indicate that there was some issue with the XP version that is going to be corrected in the next update?

Unfortunately the more information they have to input the harder it will be for them to be able to make it compatible with the earlier programs. Which is why i recommend open office 3.0. It will run it just fine

[Mithreinmaethor]

It has been pretty quiet in here recently. I have not found any more bugs yet myself that have not already been stated here.

So everyone else doing fine?

With the way that Dragon puts out information and with Martial Power coming out this month, I wonder when we will see a new updated version 1.18 etc?

[Steve Jung]

Hi,
I'm trying out 1.17 on Open Office 3.0.0. Several of the resistances from the Extra Bonuses sheet aren't registering on the Initiative card. These are Acid, Force, Lightning, Necrotic, and Psychic. Even putting in an Override value doesn't work. The universal bonus to all saves granted by the Human Perseverance feat shows up on the Extra Bonus sheet, but doesn't show up on the Initiative card. The +2 to fear saves granted by the Cormyr region doesn't show up on either the Extra Bonus sheet or the Initiative card.