Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

Calculator Macro for Copying Spells

Hi Rollers! I created a macro that can be used as a calculator for the costs of wizard copying spells: &{template:npcaction} {{name=}} {{rname=Downtime: Copying Spells}} {{description=To copy a total of [[ ?{Total spell levels} ]] spell levels into your spellbook, you must spend [[ceil( ?{Total spell levels} /4)]] downtime days and [[ ?{Total spell levels} *50]] gp for material components.}} Now, Adventurer's League has decided to remove "hours" and instead implement "It costs 1 downtime day for each spell up to 4th level and 2 downtime days for each spell 5th level and above." I don't know how to make use of the good ol' tip "Total the spell levels of the spells you wish to copy, then multiply it by 2 for hours and 50 for gold." when there are only 2 groups (1 day and 2 days) depending on how many of the spells are 5th level or higher. Any suggestions? Here it was I tried so far, but the downtime days are still wrong: &{template:npcaction} {{name=}} {{rname=Downtime: Copying Spells}} {{description=To copy a total of [[ ?{Total spell levels} ]] spell levels into your spellbook, you must spend [[ceil( ?{Total spell levels} * [[?{How many of them are 5th level or higher?} * 1 ]] )]] downtime days and [[ ?{Total spell levels} *50]] gp for material components.}} Thanks in advance!
1637981647
Oosh
Sheet Author
API Scripter
I guess [[ ?{Total spells} + ?{Spells of level 5+} ]] is the simplest. Or [[ ?{Spells lvl 1-4} + 2*?{Spells lvl 5+} ]] if you prefer. For an individual spell, ceil(?{Spell level}/4.5) will give you the right result, but that would need to be applied per spell. There's no way of applying it to the total spell levels since lvl 2 + lvl 2 is not the same as lvl 4.
Thank you Oosh!