Is there an easy way to validate a high-level Sorcerer's spell list?

Is there an easy way to validate a high-level Sorcerer's spell list?



Suppose I'm running a one-shot that starts at level 9, and I instruct players to generate characters using any officially published Sourcebooks to create their characters.



One of my players chooses to create a Sorcerer, and when they hand me their Spell List, they've generated this character with the following spells:



Looks fine, right? Ten spells in total, which is correct for a 9th level Sorcerer, and no spells are higher than 5th level.



...... Except they have way too many 5th level spells! By the normal rules of how Sorcerers generate spells, it's not possible to have more than 2 5th level spells known at level 9.



You know two 1st-level spells of your choice from the sorcerer spell list.



You learn an additional sorcerer spell of your choice at each level except 12th, 14th, 16th, 18th, 19th, and 20th. Each of these spells must be of a level for which you have spell slots. For instance, when you reach 3rd level in this class, you can learn one new spell of 1st or 2nd level.



Additionally, when you gain a level in this class, you can choose one of the sorcerer spells you know and replace it with another spell from the sorcerer spell list, which also must be of a level for which you have spell slots.



So that's an easy one, right? But what about a list that looks like this:



This still isn't right! The number of 5th level spells is possible for a 9th level Sorcerer, but with the total number of 4th level spells, they still know too many high level spells for their level.



Now, I can spend a half hour doing the math, trying to work out whether their chosen spells line up with what's possible for a Sorcerer, but that's a lot of busywork for me. Does there exist a simple rule or table I can follow to validate whether a Sorcerer's Known Spells are valid for their level?



Note that I've only specified Sorcerers, but practically speaking, this is just as valid a question for Bards, Warlocks, Eldritch Knights, and Arcane Tricksters, since they use nearly-identical schemes for learning spells.





$begingroup$
Even if he could use this list (not by RAW) it is a very bad idea. What would he do after the third combat round? Or the 6th, if he traded all the 1-3 slots to sorcery points and back to high level slots. You should let him use the first list, that would be its own punishment
$endgroup$
– András
Sep 18 '18 at 6:56





$begingroup$
@WakiNadiVellir That's a reasonable thing to request. "Show me how this character got to this point." Put it on them to explain why it's a legit list.
$endgroup$
– Monty Harder
Sep 18 '18 at 21:35





$begingroup$
@MontyHarder Decided to write that as an answer as an alternative solution to the actual problem of OP.
$endgroup$
– WakiNadiVellir
Sep 19 '18 at 4:53





$begingroup$
Programming Puzzles & Code Golf decided to help you check if a spell list is valid for a sorcerer level... with programs... in the less bytes possible ;)
$endgroup$
– Olivier Grégoire
Sep 20 '18 at 11:59




5 Answers
5



This is the rule causing all the headache:



Additionally, when you gain a level in this class, you can choose one of the sorcerer spells you know and replace it with another spell from the sorcerer spell list, which also must be of a level for which you have spell slots.



Spells Learned Normally]



In the first table, we simply tabulate all the opportunities to learn a spell normally.



Spell Opportunities for Replacement



In the second table, we assume that the player is always replacing a spell of their lowest level. While this might not be the case, this assumption allows us to get a meaningful upper bound for their highest levels of spells known.



Maximum Spell Count Adjusted for Replacing at Each Level



In this third table, we assume that we are ALWAYS applying replacement and that we are replacing our lowest levels of spells known. This gives us the upper bound for how many spells of the highest levels we can have. If the player has fewer spells of those highest levels, they can have instead the remaining as lower-level spells.



For example, at level 20, it's possible to have five level 9 spells. If instead, the player had four level 9 spells, they could have that vacancy filled with a level 8th or lower spell.



In the case of a 9th level caster, which is relevant to you, we have the following upper limits:



Level 3: 4 known spells

Level 4: 4 known spells

Level 5: 2 known spells



Since this is an upper bound, you should read this like so instead:



4 spells of Level 3 or lower

4 spells of Level 4 or lower

2 spells of Level 5 or lower



I hope this helps.



For this table, we populate every row with a count of how many spells of each spell level a character learns at the current character level. We assume that characters always pick the spell of the highest possible spell level. While they can always pick a spell of lower level, we can account for it later.



In the case of Bards, we should see 4 Level 1 spells, and 0 of every other spell level for Character Level 1. In the case above, Sorcerers have 2 at level 1.



Also, any spells gained through features like the Divine Soul Sorcerer should be included at the level they are gained.



Calculate the totals at the bottom to make some of the next steps more easily.



This table is going to have, for each Character Level, their highest possible substitution. A negative value in a cell means that at the current character level, that many spells of that Spell Level were replaced. A positive value in a cell means that at the current character level, that many spells of that Spell Level were acquired through replacement.



Currently, only Arcane Tricksters, Artificers, Bards, Eldritch Knights, Rangers, Sorcerers, and Warlocks are the only classes that have a replacement clause for a Spell Known feature, and all of them only replace one spell at a time. Therefore, you should only have a single -1 and a single 1 per row.



The positive 1 will always be in the column of the highest possible Spell Level knowable, if it's anywhere at all. We're assuming we always replace maximally. On a level where we can't do a replacement, there won't be one in the column.



The negative 1 (-1) will depend on the totals for that column in Table 1 (how many times we normally learned a spell of this level) and how many past opportunities were used to acquire a spell of this level through replacement (how many times we learned a spell of this level through replacement).



At the current character level, go left to right.



For classes like Arcane Trickster, there may be rows which are blank because there's no way to replace a Spell Known and end up with a higher level spell known. For Arcane Trickster, this happens at Level 11. This is fine. This just means that by this point, the character has had the opportunity to replace all their lower level spells with spells of the highest level so there's nothing to do.



To know that you are doing it right, try it on Arcane Trickster and you should notice a vertical bar of four -1s in the Spell Level 1 column and a vertical bar of eight -1s in the Spell Level 2 column with a gap of two character levels between them at Character Level 11 and 12.



We use the two previous tables together to create this third table. This table has the Upper Bounds for how many spells of each level the character can know.



We get the values of each cell by summing vertically both tables up to the Level-th row. If you're not sure on how to do this, do it step-by-step:



For Excel users, you can use the following formula =SUM(A$1:A1)+SUM(X$1:X1) for the top-left cell of Table 3 where A1 is the top-left data cell of Table 1 and X1 is the top-left data cell of Table 2. Then, use the auto-fill drag to spread that formula to all other cells and the relative formula will do it for you.


=SUM(A$1:A1)+SUM(X$1:X1)


A1


X1



Again, as with the Sorcerer, the values on the row corresponding to character level tell you how many spells of each level or lower the character can have. The reason we need to qualify or lower is because any time you can pick a high-level spell, you can pick a lower one to learn instead. But these numbers act as an upper limit to how many spells of the highest levels a character can have.



Here is the Table 3 for Arcane Trickster made using this method.



enter image description here



We would therefore say that for a 13th-Level Arcane Trickster, they know



7 spells of Level 2 or lower

2 spells of Level 3 or lower



This means that three Level 1s, three Level 2s, and three Level 3s is not a valid breakdown of spells known levels for that level whereas four Level 1s, three Level 2s, and two Level 3s is.





$begingroup$
+1 I ran the numbers and got the same results as the third table in this answer. Since you can always opt to learn a lower level spell, any combination below these upper bounds is also valid.
$endgroup$
– Quadratic Wizard
Sep 17 '18 at 22:04





$begingroup$
I was planning on self-answering my question with a table similar to what you've got here, but I think your version is much better than mine is!
$endgroup$
– Xirema
Sep 17 '18 at 23:39





$begingroup$
@Xirema: Slight aside - May be worth pointing out to the player that they do no favours to themselves picking too many high level spells because its their spell slots that determine which of those spells they can cast. By choosing mainly high-level spells, when they run out of higher slots they will be very limited in what they can do. Your player, once they have only 1st and 2nd level slots left will only be able to cast Burning Hands!
$endgroup$
– PJRZ
Sep 18 '18 at 6:54






$begingroup$
While the answer might be right the first 2 tables are really confusing matters in my eyes.
$endgroup$
– SeriousBri
Sep 18 '18 at 8:20





$begingroup$
@SeriousBri The first two tables were added to show process. Using both tables together, we construct the third (by summing vertically both tables up to the Level-th row). This was done to be general and extensible to other classes who have similar, yet different enough, spell learning schemes. For example, Bard learns an additional spell at level 10 and does not skip learning spells at level 14 and 18 due to Magical Secrets. Hence, Bard's first table would be altered. Bard also begins with 4 spells known. As a result, the second table would have more opportunities to replace 1st level spells.
$endgroup$
– Axoren
Sep 18 '18 at 12:34



Simple! Here are 2 different ways of doing it.



Ok, so let's see how Sorcerer gets spells.



enter image description here



Sorcerers learn 1 spell each level. They can also swap out 1 spell per level. So now we count, for each spell level, how many spells they could have. For sorcerer, its quite easy, it's just 2 spells per level with that spell slot.



Now we go backwards, starting at the highest spell level. Your sorcerer has a valid number of 5th level spells. Then 4th level. We see that it is invalid, he can't have 5 of them.



Imagine now that he actually had some level 3 spell instead of Far Step (5th). Following the same algorithm, he had a valid number of "Level 5 (or lower)" spells (one of 5th level, and one of 4th). Then there are 4 lvl4 spells, also valid. Then 3 lvl3 spells, also valid.



Seems complicated, but its just summing a few times.



Ok, so let's see how Sorcerer gets spells.



enter image description here



Sorcerers learn 1 spell each level. If no spells were relearned, then he should have the following 10 spells:



1 1 1 2 2 3 3 4 4 5



So, your list contains



1 3 3 4 4 4 4 4 5 5



We can scratch those that match right away (in bold), and your list is reduced to



_ _ _ 4 4 4 _ _ 5 _



So now all we have to is count how many levels there have been where the player has slots of levels 4 and 5. You don't repeat levels (since you can only switch 1 spell per level). If the amount of levels is smaller than the amount of unmatched spells, then it is an invalid spell selection. It is easier to do this backwards, starting with higher levels.



In your case, the player has 1 level with a 5th level slot. Meaning that the single unmatched 5th lvl spell is valid. After this, the player has 2 levels with a 4th level slot. Because he has 3 lvl4 spells, then this character is not valid.





$begingroup$
I think your previous rule was simpler, to be frank. I hadn't fully thought it through before you edited it out, so I'll have to check the edit history to confirm it works. However if it works, I definitely think your answer could be improved if you re-added that pattern rule.
$endgroup$
– Axoren
Sep 17 '18 at 22:05





$begingroup$
@Axoren Added! I thought it was simpler, but I guess opinions may differ :p Test it out, let me know if I messed up
$endgroup$
– BlueMoon93
Sep 17 '18 at 22:07



For the purpose of quickly checking whether a particular spell list is valid, it helps to sort the spell levels in ascending order. First, get the list of valid spell levels (Axoren's answer has these; I also include them at the bottom of this answer). Then line up the spell levels side by side, like this (I will use the level and list from the question's second example):


3333444455 (allowed)
1334444455 (chosen)



If any of the numbers on the second line are greater than the number above it, then the spell list is invalid. You can see that this spell list has one invalid spell (the 4 with a 3 above it).



For convenience, here are the spell level lists for every sorcerer level, formatted for use with this method:



Simple solution to more easily validating the characters, not limited to Sorcerer spell list:



Request players to create their characters level-by-level, providing a list on paper showing what they added each level. Then you can easily see if they added anything which is not legit.



Downside of this is, it's a bit of work for players. But this too is actually a good thing, or can be. Unless they are really seasoned players and know the system, then they get to know their character and its abilities this way, and can play it much better. I have played characters directly created to a high level, and I felt it took something away from the game, compared to building them up level-by-level, but this is of course very subjective.





$begingroup$
Given that they are supposed to build the character this way (level-by-level) anyway, it seems like a pretty reasonable request to make beforehand. :)
$endgroup$
– V2Blast
Sep 19 '18 at 5:08



Due to the fact that Sorcerers, and other "learning" casters, can swap out the spells they already know for a different one they can cast, this means that there is a large number of possible values.



Take, for example, a level 5 sorcerer, who can cast up to level 3 spells. At sorcerer level 3, they would be able to swap out one of their level 1 spells for a level 2 spell. Every sorcerer level after that, they could technically swap out every 1st level spell for another spell. By level 5, a Sorcerer could technically have no level 1 spells.



In addition, the sorcerer can opt to learn spells not of a higher spell level and instead learn a new spell of lower level.



The only reasonable thing that we can feasibly determine is what the maximum possible number of known spells of the maximum spell levels available are.



For Sorcerers, there does seem to be a barebones pattern for the maximum spell level capacity. Their maximum spell level is determined by their sorcerer level, divided by 2, rounded up.



Because of the limited number of spells known to Sorcerers, this pattern is only feasible with them. Bards, on the other hand, can know 7 more spells, and their pattern is a lot more sporadic.



Thanks for contributing an answer to Role-playing Games Stack Exchange!



But avoid



Use MathJax to format equations. MathJax reference.



To learn more, see our tips on writing great answers.



Required, but never shown



Required, but never shown




By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Popular posts from this blog

𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

Edmonton

Crossroads (UK TV series)