Character Planner spreadsheet

[binnsr]

Made some monky modifications and uploaded a new file..

- Added Monk Feats (Stunning Fist and Deflect Arrows)
- Added Monk Enhancements (thanks again to Ron for getting his tool updated first so that I could leach his Enhancement list)
- Added stance bonuses and penalties to the Ability Scores section and bonuses to the Saves for being in Water Stance.

[Xirxx]

Great Tool! one minor thing I found - Paladin Aura starts at level 1, not level 2
Need to update Aura of Good and AC section

formula for Aura of Good - =IF(U8>=1,IF(VLOOKUP("Paladin Resistance of Good III",$AX:$AY,2,FALSE),4,IF(VLOOKUP("Paladin Resistance of Good II",$AX:$AY,2,FALSE),3,IF(VLOOKUP("Paladin Resistance of Good I",$AX:$AY,2,FALSE)=1,2,1))),"n/a")

formula for AC - =IF($U$8>=1,IF(VLOOKUP("Paladin Bulwark of Good III",$AX:$AY,2,FALSE),4,IF(VLOOKUP("Paladin Bulwark of Good II",$AX:$AY,2,FALSE),3,IF(VLOOKUP("Paladin Bulwark of Good I",$AX:$AY,2,FALSE),2,1))),"")

[binnsr]

Well that was pretty stupid.. I think that's been in there since forever - and since I never stop with a 1lvl Pally splash, I never noticed that..

Fixed and a new copy uploaded.

[prometheus303]

maybe its just me...but i tried to download your planner and am getting a 404 error when connecting to the website...

[binnsr]

somehow I managed to change filenames from build_template.xls to build-template.xls.. I've fixed the link and you should be good to go now.

[binnsr]

I've updated the AC section to include a separate counter for Armor Bracers, a toggle for the Icy Vestments and a line for the Tempest enhancement.

I've also added the enhancements that I was missing (primarily the ranger PrC enhancements)

[binnsr]

With the toughness enhancements changes, I have updated a couple of things in preparation for Mod 8.

I've added the Racial enhancements and separated class and race toughness enhancements in the HP chart
I've also added the other new enhancements that are listed in the Risia Release Notes.

[binnsr]

Updated the spreadsheet with some good stuff.

-- Most of the behind-the-scenes tables have been revamped to make the saved file much smaller (the template is about 580KB now as opposed to the previous version saving at 1.5MB)
-- AE2-AE21 now only show feats that are appropriate for the class listed to the left of that cell (i.e. for the Ranger level one feat, you can only select a favored enemy - and for Wizard lvl1, you can only select one of the MetaMagic feats.)
-- Added the Competency to-hit bonus
-- Added Mod8 Enhancements (I was tempted to add in the Mod9 PrE enhancements and capstones that have been covered, but decided to wait until we have more information)
-- Added a version tag at A1 (white text on a white background so it doesn't clutter things up)

There were a lot of behind the scenes changes for this version - if you find anything that doesn't work, or doesn't work as expected, please let me know.

[staples]

Too few people have said thanks for all the effort...one of the best tools out there.

[binnsr]

Thanks bro .. appreciate it

[binnsr]

anti-forum-purge preemptive strike post..

[binnsr]

IMPORTANT NOTE: OpenOffice.org Calc now supports cell validation, removing the last hitch that I know of for using this tool in that product.

I rebuilt one of my linux boxes today and after testing USB functionality by loading a Flash drive (which had this spreadsheet on it), I discovered that openoffice.org Calc now supports cell validation.

The version of openoffice.org Calc loaded on my system is: openoffice.org-calc-2.3.0-6.5.4.el5_2 with the newest version of OpenOffice.org available being: 3.0.1

[binnsr]

I've been fiddling with more automation (and a simple damage calculation tab) and have gotten the sheet so that it has a couple of macros. They're nothing that will break anything if they're not enabled, but I wanted to poll the community that uses this as to whether or not they would still download this if it had macros?

[Rentz]

hey Binnsr,
I've been away from the game for something like a year and a half..just coming back for a stint and glad to see you still maintaining this!!

Cheers~!

[kwip]

Binnsr, just wanted to chime in w/ how much I love this spreadsheet. Great job, very useful. Thanks!

[binnsr]

Now that the NDA has been lifted, I've started working on adding Favored Soul to this and hope to release a new version (1.2.0) in the next week or two (depending on free time of course)

If there are changes to the FvS class between now and DDO:EU launch, I'll release a 1.2.1 version as well.

New items will be:

• Prestige Enhancements
• Capstone Enhancements
• Favored Soul and associated feats, enhancements, etc.

[binnsr]

Build 1.2.0 is now available.

All of the mod9/DDO:EU enhancements, feats and abilities are included. Still to be completed are going through the PrE's and adding AC/Hit/Damage modifications from the Fighter and Pally ones. For now, they can be manaully added in the 'Miscellany' blocks for each section.

I have also added a rudimentary damage calculator - this is definitely to be considered a beta addition as it does not handle TWF styles very well Inclusion of this forced me to add a couple of macros. The code for the macros is easily accessed if enabling macros bothers you and you want to look at what they're doing - a simple sort macro, as well as one to list sheets for the damage calculator dropdown. Disabling macros in no way hinders the functionality of the individual character sheets - just makes the damage calculator more difficult to manipulate.

There were quite a few changes in this version, so if you come across anything that doesn't work as you expect, let me know and I'll try to get 'er fixed

Thanks for playing and have a Go Army! day.

[binnsr]

Uploaded v1.2.1 .. this modification focused only on the damage calculator.

It now takes into account fighting style from the character tab, including offhand damage, and TWF feats.

[binnsr]

v1.2.2 is now available.

I added the enhancements for "Kensai [Specific Weapon] Mastery I/II/III" and corrected a named range issue.

I still haven't found the time to actually add the PrE benefits to attack, damage and AC.
I also want to add a macro to generate forum code to make exporting a character easier, but figure that's going to be a while out given my time constraints lately

[theweehours]

Thanks for such a great tool! One quick note: the Paladin Improved Turning APs are showing 2, 4, and 6 points needed and should be 1, 2, and 3.