Upgrade your account to a Community Supporter account and remove most of the site ads.
Enchanted Trinkets Complete--a hardcover book containing over 500 magic items for your D&D games!

Reply to thread

Message: <blockquote data-quote="BlackBart" data-source="post: 1605769" data-attributes="member: 2232">Something I should do, but then I wouldn't have time to do the updates I do.Skills are problematic to some degree, as they require changes to the Class Info, Race Info, and Skills sheet to keep everything in sync, as well as the need to adjust some ranges.Feats I briefly described above, but that only accounts for a feat that has no effect on something you want to track (such as Weapon Focus).Spells are either pretty easy, if all you are doing is adding a spell, to excruciatingly difficult, if you are adding a new caster with its own spell list. Adding spells to casters that select spells known kind of sucks, as you have to go through their spell selection sheets and manually add the spell to the correct level, and there are some formulas that aren't visible. Check boxes have to point to the correct rows (for which there is a macro: AdjustSpellChecks). There are some range adjustments to keep track of as well (for Export and others). Here is a prime example of where inserting data is better than appending, though the Export ranges need to be handled separately.Classes are a nightmare. Class Info and Class Abilities sheets hold the bulk of what needs to be done, but a lot of the class abilities require modifications throughout the whole sheet (skill bonuses on the skills sheet, attack bonuses on the attacks sheet, AC adjustments, bonus spells, etc.). Woe unto you if you the class has its own spell list, or bonus feats. Major suckitude.The best approach is to simply mess with it, but you will need to have at least an intermediate ability to use excel and VBA to really figure it out. It's actually quite an interesting learning tool.</blockquote>

Verification