Reply to thread

Message: <blockquote data-quote="DrSpunj" data-source="post: 1537491" data-attributes="member: 994">Alright, because of ouini & SSquirrel's comments I spent a little time tonight getting friendly with the Excel Index function. The result (after about 1.5 hours) is the spreadsheet I've attached below.Enter the PC's name, their number of Basic & Advanced Magic levels, and their relevant Ability Score. It then dumps out your total Spell Slots Per Day & Spells Readied At One Time through the Base Magic Power tables I linked to above. It also does an amazing computation (called "addition" by some) and outputs your Caster Level.If you print in Landscape the whole thing prints out on a single sheet.Now, this exactly matches the Mage Blade & Magister outputs from AU except for the fact that I bumped the 0-level Bonus Spells due to your Ability Scores by one step, so you'll always end up with one extra 0-level Spell Slot and Spell Readied. Why? Because, like SSquirrel, I believe Cantrips are cheap and like to see them used. I've always pictured high level casters using things like Mage Hand to bring the wine decanter over to them and being able to do stuff like that all day long (with Cantrips) paints a good picture for me.If you don't feel the same just Unprotect the Sheet (there's no password), and copy that entire column down EDIT: two steps, then delete the '1's in the 10 and 11 rows so that the column matches that from AU. No biggie.Note that the Ability Table only goes up to 45, like it does in the PHB & AU. Anyone wanting something higher than that will have to expand the Ranges in the Index functions (which is a bit of a repetitive pain; I've warned you!).Under this system it's probably important to note/realize that if you have the potential to cast magic from two different sources that use different ability scores (like Divine Training using Wisdom and Bardic Music using Charisma), your Bonus Spells and Spell DCs should always be calculated using the higher of the two abilities. That's a minor benefit for a mixed caster as Ability damage that lowers their highest ability (say Wisdom) below that of their other casting attribute (Charisma) would mean that Bonus Spells and Spell DCs would now be based off of the new high score (Charisma). I figure if they've studied two or more various forms of magic and broadened their magical abilities/knowledge accordingly, they deserve such a minor perk.Thanks.DrSpunj</blockquote>

Verification