Adjusting the Caster Level

Post by **slightheart** » Sat Feb 10, 2007 10:36 pm

I have v7.50.8 and have created an 11th level character, 7th level sorcerer, 4th level Elemental Savant. The question I have is in regard to the Spell Planner sheet. Specifically the calcs for determining Spells per day, Spells known and DCs. It appears to be calculating these based upon the sorcerer level and not the overall caster level. I'm unsure how to go about changing this so I get those stats based upon an 11th level caster.

Post by **shai-hulud** » Sat Feb 10, 2007 10:47 pm

On the BACK worksheet, cells AG4 and AG5 are used to adjust caster level. Assuming that Elemental Savant is loaded in Custom Class N (where N is 1, 2, or 3), enter the following formula into both cells: =lvl_CustomN

This will adjust your spells per day and spells known by your level in Elemental Savant.

Next, go to the Spell Planner worksheet. Cell K2 allows you to adjust your Effective Caster Level. You just plop in the same formula (If elemental savant does not grant +1 caster level every level, then tell me what the progression is, and I will help you create a formula for that.

Post by **slightheart** » Sat Feb 10, 2007 10:54 pm

Wow, here I hoped to have a response sometime tomorrow! The Elemental Savant grants a +1 caster level each level except every 5th. Thanks for the quick response!

Post by **shai-hulud** » Sat Feb 10, 2007 10:57 pm

In that case, for all of the formulas, you can use this:

=lvl_CustomN-IF(lvl_CustomN>4,1,0)

This will remove the extra caster level.

Post by **slightheart** » Sat Feb 10, 2007 11:01 pm

Cool, thanks! With help like this I'll definitely be telling others in my 2 gaming groups about the sheet.

Post by **shai-hulud** » Sat Feb 10, 2007 11:03 pm

Lol, Richard was about to respond, but he was falling asleep, so I told him that I would field the answers

. With TOS+ (which will be released to the public in the next short while), it automatically handles prestige classes that grant bonus caster level, so long as you only have one applicable base class to apply it to

.

Post by **slightheart** » Sat Feb 10, 2007 11:10 pm

I'm looking forward to the upgrade. This certainly makes it easier than it was back when I started playing..........1982. Whoops, my age is showing.

YouTube · Post by **admin** » Sun Feb 11, 2007 9:51 am

slightheart wrote:I'm looking forward to the upgrade. This certainly makes it easier than it was back when I started playing..........1982. Whoops, my age is showing.

I wouldn't call TOS+ an "upgrade" as it is a new product, detailed here.

And thank you Shai for replying

I was so tired (after adding dynamic power planners to TOS+) that I couldn't keep my eyes open .. !

R