#456 Prestige Classes Not Adding to Spell List

[Jheen]

This is actually related to sCoreSpell 0.9.0.0 worksheet, but it wasn't in the drop down option. When I add a prestige class that gives +1 spell level to existing spells/day (Loremaster and Mystic Theuge are the two I tested it with) and it makes a new level of spells available, the spell sheet doesn't list the new spells I can take in the spell list.

For example, if I create a 3rd level wizard, 3rd level druid, and I then add two levels of mystic theuge. Spellwise, this should make me equivalent of a 5th level wizard, 5th druid in regard to what spells I have available. It does list the correct spells/day at the top, but below all I see listed are 0th, 1st, and 2nd level spells. If I select Mystic Theuge from the drop down on the Spell Sheet, it doesn't list anything.

Best I can tell, the problem is on the the Spell Selection sheet - the formulas in AO3 to BG3 as it only counts the number of times the class is listed in the Classes range on the Engine sheet. So, if you take a prestige class, even if it adds levels to wizard or druid, since the class itself is not called Wizard or Druid, it won't add in to the maximum level. I think to correct it, it should also probably add in everything on Engine!O627:Q659 - as that's what's tied to the spell class adjustment selection the Prestige sheet - that mentions the class.

Basically, I went from =COUNTIF(Classes,AQ4) in AQ3 to =COUNTIF(Classes,AQ4)+COUNTIF(Engine!O627:Q659,AQ4)

I tested it out on my copy and that seemed to solve the problem, but I'm not sure if I'm adding any other problems to the mix.

Anyway, if you want to see a sheet of either the problem or my solution, let me know and I'll upload it

Thanks much!

[Anonymous]

Did you select wizard and druid on the prestige tab? There is a section for selecting what classes get the bonus.

[Jheen]

Of course I did, but it doesn't do anything to the formula on the Spell Selection sheet since that only looks at the Classes range on the Engine tab. The only thing that selecting the prestige sheet does is change the number of spells/day, not the actual spells available.

[thebluecanary]

I've done a little more research into this, and Wizards do not gain any additional spells known. Only spontaneous casters gain new spells known in addition to spells per day.

Does a wizard (or other character that uses a spellbook), receive bonus spells to add to his spellbook when he gains a level in a prestige class that grants an increase to spellcasting?

No. The increase to his spellcasting level does not grant any other benefits, except for spells per day, spells known (for spontaneous casters), and an increase to his overall caster level. He must spend time and gold to add new spells to his spellbook.

BUT I think application wise, you should have access to add these bonus items. You as a player would ust have to remember to spend the gold/time on the new spells. I'll work on getting this corrected.

[Jheen]

That's right, it doesn't. And I'm good with the Spellbook sheet not giving me any additional spells there when I gain a level in a prestige class for a wizard class. However, if I do purchase a spell and add it to the Spellbook sheet, it should show up in the Spell List sheet. Also, if I'm a divine spellcaster (Druid in this case) or spontaneous spellcaster, I do get the spells available to me/known to me as I go up in level in prestige class, so they should definitely show up on the Spell List.

But thanks much for getting this resolved and for creating such a kick-ass spreadsheet :)

[thebluecanary]

Your original code example was right, and I have a fix ready.

[thebluecanary]

I'll have this corrected in the next update.