Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Mithreinmaethor]

Originally Posted by CharlesCurtisStanley

I've offered some minor fixes in the past, and last night spent a couple of hours tweaking the 1.16 release (XP version) to automatically incorporate the "Extra Manifestation" genasi feat into certain calculations.

However, I don't own a copy of Excel 2007, and do not have the spare time to install Open Office. (My work system has the latest version, of course, but my employers take a dim view of non-work-related exercises... ) Hence, I'm unable to work on -- or even use -- the 1.17 release.

Lol if you have the time to post here you can download and install Open Office Just set it to download and then install it later.

I uninstalled my office xp. It was not of much use to me. So I use OO exclusively now

[kristov]

Has the weisbaden one been updated with info from Martial Power book yet? Will it be? Anyone know?

Thanks for the help.

[Obryn]

Originally Posted by kristov

Has the weisbaden one been updated with info from Martial Power book yet? Will it be? Anyone know?

Thanks for the help.

Nope, but fortunately there's a Custom page, where you can put in any feats or powers that you like. (I don't think there's anything for Custom Class Features, though I could be wrong.)

-O

[Undrhil]

If someone could just fix the level 29 powers to show up properly, I'll be happy. Sure, it's not a problem right now (what with my character only being level 3) but I like to plan ahead and I like playing out different character setups.

Surely someone else had seen this before v1.17 came out? If it's new to 1.17, then surely someone else has seen it by now ....

[CharlesCurtisStanley]

Here's an attempt at correcting issues with the Genasi Frost Affinity and Versatile Resistance feats:

In the "Extra Bonuses" sheet:
Cell S28: =IF(F25=0,MAX(V28:AA28)+U28+AC28,F25)
Cell W24: =IF(W23=TRUE,AA19,0)+IF(AND(W23=TRUE,AA20=TRUE),5,0)
Cell W25: 0
Cell W26: =IF(AA20=TRUE,5,0)
Cell X25: =IF(X23=TRUE,AA19,0)
Cell X26: =IF(AA20=TRUE,5,0)
Cell Y25: 0
Cell Y26: =IF(AA20=TRUE,5,0)
Cell Y28: =IF(Y23=TRUE,AA19,0)+IF(AND(Y23=TRUE,AA20=TRUE),5,0)

The problems solved here are:

• The +3 bonus for Frost Affinity was not being added to Cold Resistance
• Versatile Resistance provides a +5 bonus to Thunder, not Lightning
• The racial resistance bonuses to Fire and Cold (for Firesoul and Windsoul Genasi, respectively) stack with those provided by Versatile Resistance. The sheet was allowing the Versatile Resistance bonus to override the racial bonus.

So, for example, a Stormsoul Genasi (heroic tier) with both feats would have resistance of 5 Fire, 5 Lightning, 5 Thunder, and 8 Cold.

I would appreciate the collective wisdom of the group giving this offering a thorough review. Thank you.

[Tar79]

Sorry I'm abandoning this sheet for the time being, might revisit it if somebody decides to continue the work, but with Wonko's and Harknail's sheets going strong, with alot more options (actual power and items implemented into the sheet) I'm going to have to go with one of them.

[Mixmaster]

I'm staying with it as the Pro sheet to add other options (especially the Clerical Divinity options) has been a boon to remembering all my choices in a combat. There is nothing wrong with using the Custom page to add something from the Martial Power book.

Give the people time. They may have "real life" issues to contend with (or a major update). Moreover, it's the impatience for all updates NOW that caused Lone Paladin (Christopher Mathieu), BlackBart (Scott Greene) and Robert Daneri to name a few to "burn out" programming Heroforge as they were always updating........

Careful before you start burning out Wonko and Harknail!

[TheMarko]

Minor update:
Feats tab, field C81
Change:
"=IF(OR('Basics Transport'!P19="Ritual Caster";'Basics Transport'!O19="Ritual Caster";'Basics Transport'!T19="Ritual Caster");"x";"")"
To:
"=IF(OR('Basics Transport'!P19="Ritual Casting";'Basics Transport'!O19="Ritual Casting";'Basics Transport'!T19="Ritual Casting");"x";"")"

If You want Your characters to gain free Ritual Caster feat for Ritual casters

[infocynic]

Well, I still haven't heard anything. I would suggest we take over the project. I don't necessarily want to volunteer even though I've done a lot of work on it in the past, simply because I am very busy with RL. I have not looked at the other sheets from other authors to see if they're better or not, but more choices doesn't hurt anyone. I would recommend someone be in charge of publishing new releases, and maybe 2-3 other people can work with him or her to make the changes (it's hard because you can't just auto-merge changes into a binary file... really you want one person editing at a time, so a version control system with file locking may be a good idea). Alternatively, one person could be in charge of the O2007 version and one in charge of the O2003, but still share all your bugfixes between each other.

Someone who wants to help and doesn't know Excel would probably find that going through this thread since the official release of 1.17 and finding all the changes that people have posted, and simply making a new post with all those changes, and the developers can maybe use that post as a reference.

[Basacag]

Hi Charles

Works for me. Where did you find that the resistances stack though? My Akanul Genasi Firesoul should be 12 fire 7 thnder 7 cold with VR - which your fix does, but I can not see the rule that allows it to stack with the genasi fire 5 resistance...

Also sheet shows Lightning 0 which is cool but would be 'nicer' without.

Thanks for the fix though, makes life easier.

Originally Posted by CharlesCurtisStanley

Here's an attempt at correcting issues with the Genasi Frost Affinity and Versatile Resistance feats:

In the "Extra Bonuses" sheet:
Cell S28: =IF(F25=0,MAX(V28:AA28)+U28+AC28,F25)
Cell W24: =IF(W23=TRUE,AA19,0)+IF(AND(W23=TRUE,AA20=TRUE),5,0)
Cell W25: 0
Cell W26: =IF(AA20=TRUE,5,0)
Cell X25: =IF(X23=TRUE,AA19,0)
Cell X26: =IF(AA20=TRUE,5,0)
Cell Y25: 0
Cell Y26: =IF(AA20=TRUE,5,0)
Cell Y28: =IF(Y23=TRUE,AA19,0)+IF(AND(Y23=TRUE,AA20=TRUE),5,0)

The problems solved here are:

• The +3 bonus for Frost Affinity was not being added to Cold Resistance
• Versatile Resistance provides a +5 bonus to Thunder, not Lightning
• The racial resistance bonuses to Fire and Cold (for Firesoul and Windsoul Genasi, respectively) stack with those provided by Versatile Resistance. The sheet was allowing the Versatile Resistance bonus to override the racial bonus.

So, for example, a Stormsoul Genasi (heroic tier) with both feats would have resistance of 5 Fire, 5 Lightning, 5 Thunder, and 8 Cold.

I would appreciate the collective wisdom of the group giving this offering a thorough review. Thank you.

[Tar79]

Originally Posted by Basacag

Hi Charles

Works for me. Where did you find that the resistances stack though? My Akanul Genasi Firesoul should be 12 fire 7 thnder 7 cold with VR - which your fix does, but I can not see the rule that allows it to stack with the genasi fire 5 resistance...

Also sheet shows Lightning 0 which is cool but would be 'nicer' without.

Thanks for the fix though, makes life easier.

The rule that allows them to stack is right in the Akanul Region benefits (or your existing resistance to these damage types increases by 2).

"AKANÛL REGIONAL BENEFIT
You gain resist 2 cold, resist 2 fire, and resist 2 thunder (or your existing resistance to these damage types increases by 2). At 11th level, these values improve to resist 3 (or increase by 3), and at 21st level, they improve to resist 5 (or increase by 5)."

As for Versatile Resistance stacking with Firesoul and Windsoul, I've had this conversation with other people and we do not believe this to be correct, as nowhere in the feat or race description does it say that the bonus is in addition to any other resistance you might have, unlike the Akanul resistance that specifically says to increase existing resistance.

[Mithreinmaethor]

Well I guess the sheet is dead for the most part from following this thread.

I was looking at the sheet and if someone could expand the custom powers sheet and allow it to show in the drop down for powers that would go a long way for people to add in the newer stuff.

[CharlesCurtisStanley]

Originally Posted by Tar79

As for Versatile Resistance stacking with Firesoul and Windsoul, I've had this conversation with other people and we do not believe this to be correct, as nowhere in the feat or race description does it say that the bonus is in addition to any other resistance you might have, unlike the Akanul resistance that specifically says to increase existing resistance.

After further review, I now agree that my previous interpretation of Versatile Resistance was partly incorrect. It does stack with the Akanul regional bonus, but does not override the previous resistance value; one uses the larger of the two, so a Paragon or Epic tier Firesoul or Windsoul Genasi character with Versatile Resistance would have Resist 10 (Paragon) or 15 (Epic) for fire or cold (respectively) and Resist 5 for the other.

Thank you for your review and comments.

[Tar79]

Originally Posted by CharlesCurtisStanley

After further review, I now agree that my previous interpretation of Versatile Resistance was partly incorrect. It does stack with the Akanul regional bonus, but does not override the previous resistance value; one uses the larger of the two, so a Paragon or Epic tier Firesoul or Windsoul Genasi character with Versatile Resistance would have Resist 10 (Paragon) or 15 (Epic) for fire or cold (respectively) and Resist 5 for the other.

Thank you for your review and comments.

Manifest Resistance does stack however (as it specifically says increases the racial bonus), and my Genasi Swordmage will be taking the Paragon Elemental Tempest for the dual manifestation ability (otherwise have to wait till epic to take the feat) With this combination (Akanul, Manifest Resistance and dual manifestations) at level 11 I will have 18 cold, 18 fire and 3 thunder as Firesoul/Windsoul or 3 cold, 18 fire, 15 Lightning, 3 thunder as Firesoul/Stormsoul. I'm sinking all my pre-Paragon feats into extra manifestations so I will be able to choose from any combination of the 5 at any given time, but I have a feeling I won't be switching out Firesoul too often.

[zlatan24]

There is not bad utility which works with excel files-how to fix corrupted Excel file,as far as i know it is free,software works on a very important report, with statistical data, graphics, tables and a lot of critical information and it is lost at once,will analyze your damaged document and show you its content in a preview window,allow you to fix files Excel and see, which elements will be recovered and which are damaged too badly,can choose, whether you'd like to recover all of your damaged documents manually and spend many days for this purpose.

[Obryn]

If this is a dead project, I'll be sad, but it's not like I'm volunteering to take the reins, either.

-O

[TheMarko]

Somewhat good news . . . I've started implementing Martial power to sheet . . . It will take some time because I don't have lots of time . . . If someone could summarize all the updates from original publish until now made by You guys . . . That would be appreciated, and one more thing . . . Someone with excellent knowledge of excel to implement few things I do not know how to . . .

[Mithreinmaethor]

So has anyone seen anything from the creator even in other posts on the board? I hope that they have just lost their desire to keep it updated and nothing has happened to keep them from doing so

[Genolen]

I have talked to them a few days ago and they are doing well.
Unfortunately, they have little time for the project. They said something of a new version, but only on their PC. How completely that is, I do not know.

[Mithreinmaethor]

Originally Posted by Genolen

I have talked to them a few days ago and they are doing well.
Unfortunately, they have little time for the project. They said something of a new version, but only on their PC. How completely that is, I do not know.

Good glad to hear that they are doing well.

Something I thought of that would make the sheet last for quite sometime without much need for updating. Remove all the powers and feats from the database all together. And rework how the custom page works with populating input there. That way all thats in the database is weapons and races and regions etc. The players go in and type in what powers and feats they have etc.

This way the only time there is a need for an update is when new races and/or new weapons are added. Would lessen the load on the developers I would think.

I dont mind typing in all of that stuff. And the sheet on attacks would only have to do basic calculations. We can add in the +2 damage for say Eladrins with the Eladrin Soldier feat in the damage section of the attacks page.

Perhaps use some of that extra space and resource power to perhaps populate power cards etc.