Ghostwind said:
Maybe someone who is experienced with modifying the programs would care to write a tutorial with the necessary formulas for inserting such things as skills, feats, spells, weapons and armor. Adding classes probably adds a new layer of complexity, but maybe the above won't.
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.