I have been trying to find a way to find the formula behind spell slot progression on the multiclass caster table, to add a spell slot table to this sheet with the best example being on the last table group at the end of the second page and there seems to be a pattern, but I can’t seem to find what the formula for it would be. Especially because many lower level slots cap out at a number around 3 after only a few levels.
I have been linked to this post a few times because it has a similar title to my question, but it does not have the answer I am looking for. If anyone has the formula for the individual level slot progression per level that would be greatly appreciated.
What is the formula that can be used to generate the spell slots for each level on the multiclassing spell slot table?
I would prefer the mathematical function that gives it, so it could be used in other projects should the time arise. But if there is no other solution a spreadsheet specific answer would be appreciated.