i used a query to determine casting level and then used the query in the calculations. this is a basic example of the spell ray of frost @{selected|output_option} &{template:5eDefault} {{spell=1}} {{character_name=@{selected|character_name}}} @{selected|show_character_name} {{title=Ray of Frost}} {{spellschool=Evocation}} {{spellfriendlylevel=Cantrip}} 0 0 {{spellshowinfoblock=1}} {{spellshowdesc=1}} {{spelldescription=A frigid beam of blue-white light streaks toward a creature within range. Make a ranged spell attack against the target. On a hit, it takes 1d8 cold damage, and its speed is reduced by 10 feet until the start of your next turn. The spell’s damage increases by 1d8 when you reach 5th level (2d8), 11th level (3d8), and 17th level (4d8).}} 0 {{spellshowattack=1}} {{spellattack=[[d20 + @{selected|intelligence_mod} + @{selected|PB} + (@{selected|global_spell_attack_bonus})]]}} {{spellattackadv=[[d20 + @{selected|intelligence_mod} + @{selected|PB} + (@{selected|global_spell_attack_bonus})]]}} 0 0 {{spellshowdamage=1}} {{spelldamage=[[(((@{selected|wizard_level}+6.2)/5.6)-.5)d8 + 0 + 0 + (@{selected|global_spell_damage_bonus}) + 0d0]] Lightning}} 0 0 {{spellcasttime=1 Action}} {{spellduration=Instantaneous}} {{target=1 Target}} {{range=60 feet}} {{spellgainedfrom=Wizard}} {{spellcomponents=V, S}} @{selected|classactionspellcast} and this is fireball, complete with a roll query @{selected|output_option} &{template:5eDefault} {{spell=1}} {{character_name=@{selected|character_name}}} @{selected|show_character_name} {{title=Fireball}} {{spellschool=Evocation}} {{spellfriendlylevel=Level 3}} 0 0 {{spellshowinfoblock=1}} {{spellshowdesc=1}} {{spelldescription=A bright streak flashes from your pointing finger to a point you choose within range and then blossoms with a low roar into an explosion o f flame. Each creature in a 20-foot-radius sphere centered on that point must make a Dexterity saving throw. A target takes 8d6 fire damage on a failed save, or half as much damage on a successful one. The fire spreads around corners. It ignites flammable objects in the area that aren't being worn or carried.}} {{spellshowhigherlvl=1}} {{spellhigherlevel=When you cast this spell using a spell slot of 4th level or higher, the damage increases by 1d6 for each slot level above 3rd.}} {{spellshowsavethrow=1}} {{spellsavedc=[[@{selected|wizard_spell_dc} + 0]]}} {{spellsavestat=Dex}} {{spellsavesuccess=1/2 Damage}} 0 {{spellshowdamage=1}} {{spelldamage=[[(5+?{Spell Slot Level|3})d6 + 0 + 0 + (@{selected|global_spell_damage_bonus}) + 0d0]] Fire}} 0 0 {{spellcasttime=1 Action}} {{spellduration=Instaneous}} {{target=20 foot radius}} {{range=150 feet}} {{spellgainedfrom=Wizard}} {{spellcomponents=V, S, M}} @{selected|classactionspellcast} /edited to add the following: and the call for these spells from the other character sheet, or the settings macros, or whereever, looks just like this: %{WizardSpellbook|Fireball} these macros account for caster levels, reference attributes automatically, use roll templates, etc.