As you add more and more spells to a character, the performance can go down. When you add a lot of spells, the performance can drop dramatically. Yet some characters can accumulate a lot of spell choices. For casters like clerics or druids, their choices are as broad as the entirety of their class list. For them, the Shaped Script spell import command is a godsend. For casters like wizards however, there is no convenient solution. Wizards can accumulate a huge number of spells as they find spellbooks and scrolls. Even though they can prepare only a limited number at any given time, they don't have a manageable list of choices to make their prepared list for the day. Also, they could have a backlog of spells that they have found, but have not yet had time or gold enough to copy into their own spellbooks. This macro is an attempt to fix that. I wrote it for a wizard player in my campaign when I realized he had over fifty spells imported to his sheet, even though he did not yet have access to all of them. He certainly could use all of them in the course of an adventuring day. This is a complex macro, so it is parsed by a spreadsheet . The macro outputs a chat menu that allows you to quickly swap out prepared spells from a list of known spells. It also allows you to clear the decks of your list, and to load in specific spells or lists of spells. For instance, your wizard may have a set they commonly use in a dungeon, or one they use in town. This should greatly reduce the spell load on any given character. The macro requires you to be using the Shaped Sheet for D&D 5e , and to have installed the Shaped Script API script . The spreadsheet may be found here , and requires nothing more than a basic understanding of how spreadsheets work so that you can add or delete rows as needed, copying the formula down if necessary. You will need to save a personal copy of the sheet and keep one sheet per character (or copy the sheet onto a new tab, to keep all spellbook managers together). Instructions for entering spells into the spreadsheet Known? (Column A) Enter a "Y" in column A if this is a spell you have available to prepare. Leave blank if it is unavailable. Note or Separator (Column B) In Column B, Enter a note about the spell if necessary, for instance, if it comes from a particular spellbook, a scroll, from the Magical Initiate Feat or some other source. Alternatively, you can enter a note here to indicate a separator, perhaps for level or to separate sets from individual spells. In this case, enter nothing else on that row. Spell or Spell List (Column C) In Column C, enter a spell or list of spells. If you enter a single spell, it will create a button to import or delete that spell from the selected token's character sheet. If it is a list, it will create a button to import all of the spells in that list. For instance you might have a common set of spell you use "in town", or "underground". In that case, the button will be labeled according to the note in Column B. If the Column A for that spell indicates a spell you have procured through adventuring but is not yet in your spellbook, it will only display the name in italics, with no way to import. The first line of the macro will contain a button to erase all spells on the character's sheet, so that you can start with a blank slate if desired. Macro Code to Copy (Column D) To copy the macro, select the gray cells from the top to the first instance of "}}" and paste that into a token macro for the character whose spellbook this is. Chat Menu This is a token macro, so it will add or subtract spells from the character sheet whatever token is selected, not whatever sheet happens to be open. Be careful. In the resulting chat menu, you will first be presented with the option to remove all prepared spells from the selected character. For each spell, you will be shown the spells name, along with whatever note might be associated with it. In the case of the sample character Shmerlin, he has found a spellbook called the Book of Shadows, but has only managed to copy over a few spells from it. He also has some Warlock Spells from the feat "Magic Initiate". If the spell is available to be prepared, there will be buttons to add or subtract the spell from the character's list of known spells. If it is unavailable, it appears in italics and has no actionable button. At the very end are the lists of frequently prepared spell sets. Click on on one of these buttons will add all the spells in the list. This may take a minute or two to appear on the sheet, depending on the speed of your computer.
