Accessory Dynamic Excel "Wiesbaden Charactersheet"

[Blackwood]

First, I would like to give a big thanks for making this sheet, I love sheets that auto-calculate a lot of things.

Second, a bug report:
There appears to be a bug in adding the proficiency bonus for simple ranged weapons. The proficiency bonus for simple ranged weapons (like slings and hand crossbows) is not showing up on any class I've tried except for Rogues (who have a specialized list of proficiencies, rather than just blanket "simple ranged").

[ReadError]

Alertness feat doesn't give the +2 to perception

[Yarthok]

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

Thanks Infocynic! The same format method works in OOCalc. The result is as you described with the display showing a plus sign, but the value can be used directly in numeric calculations in other cells.

As a cascading side effect, my test change to SkillInsight caused cell $'Charsheet I'.CN15 to incorrectly show blank. However, the fix was to simplify CN15 to use SkillInsight directly.

I changed the following:

$'Charsheet I'.AR73 (SkillInsight)
FROM ==> =IF(F73+B73+J73+N73+R73+V73+Z73+AD73>0;"+"&F73+B73+J73+N73+R73+V73+Z73+AD73;F73+B73+J73+N73+R73+V73+Z73+AD73)
TO ==>   =IF(F73+B73+J73+N73+R73+V73+Z73+AD73>0;F73+B73+J73+N73+R73+V73+Z73+AD73;F73+B73+J73+N73+R73+V73+Z73+AD73)
CELL FORMAT CODE CHANGED TO ==> +#0;-#
VALUE DISPLAYED ==> +5
 
$'Charsheet I'.CU15 (PassiInsight)
FROM ==>          =10+VALUE(SkillInsight)
RESTORED TO ==>   =10+SkillInsight
VALUE DISPLAYED ==> 15
 
$'Charsheet I'.CN15 
FROM ==> =MID(SkillInsight;2;2)
TO ==>   =SkillInsight
VALUE DISPLAYED ==> 5

I will start to come up with a list of cells that might benefit from using your suggested formatting and report back... probably this weekend.

[James McMurray]

Would it be possible for the "other bonuses" field to include a spot for your Warlord's Intelligence or Charisma modifier, then automatically calculate the appropriate bonuses? Also, a slot for warlords with Combat Commander would be nice.

The Angelic Avenger's weapon trainig doesn't appear to be working. Selecting Bastard Sword for the weapon does not add a proficiency bonus on the character sheet.

[CharlesCurtisStanley]

The ranged weapon proficiencies on the hidden section of the Attacks sheet are incorrectly calculated, owing to the "Improvised Melee" line in the Weapon section of the Class Overview sheet.

For example, the formula in cell AA50 of the Attacks sheet presently begins:

=IF(OR((HLOOKUP(Class,'Class Overview'!$3:$23,17,FALSE)=TRUE)...

It should instead begin:

=IF(OR((HLOOKUP(Class,'Class Overview'!$3:$23,18,FALSE)=TRUE)...

Note the change from "17" to "18" in the HLOOKUP function. The same change is needed in AA51 and AA52, as is a similar change from "18" to "19" in AA54 and AA55, and from "19" to "20" in AA57. This adjusts the ranged weapon proficiency lookups to examine the correct table rows.

[Amurayi]

Heya all,

thanks so far for the input. We're trying to incorporate as much as possible into teh next update.

A quick note: I just received the "Forgotten Realms Player's Guide". The next version will contain all Paragon Paths, Spell Scar Options, Feats, Rituals, Sword Mage Powers, Regions and Epic Destiny of this fine book!

[mos]

You say that you're not going to put the full powers into the character sheet, which is fine, but have you considered putting in the ability for us to do so? For example, so that the attacks tab will be automatically filled out if we have edited our power descriptions?

edit: Either way, I definitely think your character sheet is the best one available so far!

[Mithreinmaethor]

FRPG is great. Cant wait to see the info here in the sheet. Makes things sooooo much easier let me tell you. Any updates on how your coding is coming?

[infocynic]

Originally Posted by mos

You say that you're not going to put the full powers into the character sheet, which is fine, but have you considered putting in the ability for us to do so? For example, so that the attacks tab will be automatically filled out if we have edited our power descriptions?

edit: Either way, I definitely think your character sheet is the best one available so far!

Only problem I could see with that is that it's very easy for someone to type in all the powers and start redistributing it in a way the authors didn't originally intend. If they're really trying to support that you have to have the books to use the sheet, then I think they have every right to be careful about how easy it is to do something like that.

[Superboy]

Oh boy! Picked up the FRPG today and can't wait for the updated character sheet with updated swordmage class/powers/feats.

Oh and are you gonna include material from the completed Dragon #366 in the next update?

[Anywhere]

Originally Posted by Superboy

Picked up the FRPG today and can't wait for the updated character sheet with updated swordmage class/powers/feats.

This update is already in, so that v.1.16 come out in the next days because some feats (Alchemist feat) from the Adventurer's Vault would then also be in.

Originally Posted by Superboy

Oh and are you gonna include material from the completed Dragon #366 in the next update?

Yes it will also be in, but we will wait until the total Dragon #366 is out

[CharlesCurtisStanley]

Originally Posted by Superboy

Oh and are you gonna include material from the completed Dragon #366 in the next update?

It's been available for a week or more; see

http://www.wizards.com/download.asp?filename=366_Dragon_Hi.pdf

for the download.

[Superboy]

Originally Posted by Anywhere

This update is already in, so that v.1.16 come out in the next days because some feats (Alchemist feat) from the Adventurer's Vault would then also be in.




Yes it will also be in, but we will wait until the total Dragon #366 is out

Umm no.
1.15 just had swordmage powers from Living FR preview. Not the complete list which is in FRPG which came out AFTER 1.15 came out. Plus Amurayi says he'll be adding all the FRPG stuff in next update.

[infocynic]

FYI, I've been working on (and will hopefully complete 2-3 days after 1.16 is out) a macro-based solution for exporting from 1.15 and importing into 1.16. Right now I can only write half of this (the export) but since 90% of the import should be to just put stuff back where it came from, unless things moved around a lot more than that, it should be pretty easy to write the import. Because it uses VBA, I don't know how OO or Calc will deal with it... I can make the VBA code readily available to anyone who wants to script a solution for those platforms if this doesn't work.

I'm basing it off the "main" file for the Office 2003 version because it should still work with Office 2007 -- just the few extra sheets in there won't copy, and I might be able to put that in as a secondary macro of something, I just don't have Office 2007 on the computer where I normally do my programming, so it might not happen with this first release.

[Korvax]

Originally Posted by Superboy

Umm no.
1.15 just had swordmage powers from Living FR preview. Not the complete list which is in FRPG which came out AFTER 1.15 came out. Plus Amurayi says he'll be adding all the FRPG stuff in next update.

I'm pretty sure Anywhere meant that the FRPG info is already in the work-in-progress version of 1.16 and that they are just waiting on getting Adventurer's Vault to add the new feat(s?) from there into the new version prior to release. Anywhere is part of the development team for the sheet too.

By the way, keep up the great work guys! I love this sheet!

[Superboy]

Originally Posted by Korvax

I'm pretty sure Anywhere meant that the FRPG info is already in the work-in-progress version of 1.16 and that they are just waiting on getting Adventurer's Vault to add the new feat(s?) from there into the new version prior to release. Anywhere is part of the development team for the sheet too.

By the way, keep up the great work guys! I love this sheet!

Ahh good point.

[Anywhere]

Ok, I also have my books now. So release should be in two or three days.
Then all the stuff from:
- Dragon 364-366
- Forgotten Realms Player's Guide
- Adventurer's Vault
is in.

[GamesterGX]

Keep up the amazing work, guys and gals. I'll be anxiously waiting for the release of 1.16, considering our group just wiped and we all made new characters, including a swordmage .

GamesterGX

[Tearlach]

Like many others, I cant express my gratitude to you for making this fine product! My fellow dnders and I thank you from the bottom of our hearts!

I have been using the sheets for some time now, but have only just noticed these two bugs (well potential, it could just be me being a moron, so I do apologise if its my error).

1. A rogue using shuriken should have the damage dice increased to 1d6 from the base 1d4. The sheet does not appear to account for this. However there is Damage Override, which I have used for this until now.

2. The first power that any character selects populates correctly to Charsheet1 (after having its Attack information entered in the appropriate tab). But on the 'Pro Sheet' tab, it brings through the damage as #N/A.

Hope this helps. And if it does prove to me just missing something, if people can advise, that help would be gratefully received. Sorry, I cant send cookies though

[Amurayi]

OK guys. New version is coming up soon. Before I set it up on the heroforge website we will post a preversion here in thsi thread for all fans to test and break it.

Version 1.16: RELEASED SOON (watch this thread today!)
New features:
- Added all Alchemy formulas from AV
- Added "Transfer Enchantment" ritual from AV
- Added all Masterwork Armors and Weapons from AV
- Added all feats from FRPG
- Added all Paragon Paths and the Epic Destiny from FRPG
- Added all regional benefits from FRPG
- Added all Swordmage, Dark Pact and Spellscars powers from FRPG
- New sheet: "Short Sheet". For all those minimal lovers who use powercards exclusively
- Feats, Powers, Paragon Paths of Dragon #366 for Warlocks added
- neue Epic Destiny and more crunch from Dragon #366
- Custom race is now available
- added fields in the "Extra Bonuses" tab so can enter the Warlord's Modifier
Design changes:
- colored the override fields so it's easier to see the essential fields to fill in
- rearranged the fields in the attack power tab so it follows the order of the powers as written in the original books
- added armor bonus fields for Fort, Ref, Will as the new Masterwork Armor gives this type of bonuses
- Activation time on charsheet 1 now looks similar like on the pro sheet: Moved to the far left so it's the first thing you see. Also gained a bit more space for effect descriptions with this.
- a few more things here and there
Bug fixes:
- Minorr Spelling issues
- At-Will Swordmage powers fixed
- Shuriken increase in size in the hand of rogues
- unlocked field for character number
- fixed 1st and 3rd power on pro sheet
- language fixed for Genasi
- fixed Artificer skill training, was acrobatics instead of arcana
- more open office combatible, thanks to Yarthok
- feat bonus for alertness fixed
- class skills gained from home region fixed
- damage modifier fixed, shows now negative and positive modifiers
- Warlock Multiclass feat fixed
- the new Wizard powers from Dragon can now be selected, too

Link will be provided in a few hours in this thread...