Metamagic

Introduction

As of version 6.0 of TOS+, Metamagic feats have been integrated thanks to the help of our friendly global moderator, Shai-Hulud. The 3 Spell Planner have been upgraded to provide users the ability to apply up to SIX Metamagic feats on a spell! This is done on the right side of the Spell Planner, in the Metamagic section.

SpellData - Breaking Down a Spell

The first 58 columns of the SpellData worksheet are well-documented already. This section will describe how to use the columns beginning with column 59.

Enhanced Metamagic?: If this column has a value of Yes, TOS+ will expect the remaining columns of the SpellData worksheet to be filled out for the spell. This will determine how metamagic feats affect a spell.

Arcane Components: This column describes which components the spell has when cast as an arcane spell. Many spells have different components when they are cast as arcane or divine spells, and this section is to make it more clear to anyone using the spell which components are needed. This column may include a formula for whether or not certain components are needed for the spell.

Divine Components: Similar to arcane components, this column lists the components for the spell when it is cast as a divine spell. The goal is to remove any confusion over what components a spell has.

Material Components: This field is used to describe the material component(s). Currently, this is not displayed anywhere, but it may be soon.

Maximum material cost in GP: This column is used to determine whether or not a spell has a material component cost. Feats such as Eschew Materials can cause a spell to lose their material component when the components cost less than a certain amount of gold. This field is used to allow those feats to work. So, this column has been added to track the GP cost of material components. A ParseEffect has been added: "Ignore Material Component Up To Value". So, instead of just adding "M" to the arcane and/or divine components, a spell that has material components might instead include the formula:

IF(PE_Spells_IgnoreMaterialComponentValue>VLOOKUP("SpellName",t_Spells,index_Spell_MaxMaterialGP,FALSE),"","M"). This allows the addition of other feats that might allow a caster to ignore material components up to 10 gold, or 100 gold. This field is not currently displayed on the Spell Planners, but it may be displayed elsewhere.

Arcane Focus: Some spells specify different focuses for arcane spells or in general. This field stores the description of any required arcane foci.

Maximum Arcane Focus cost in gp: This column was added to mimic the functionality of material components. If a custom feat is added that removes the need for certain arcane focuses, the formula could use this column to determine if the spell qualifies.

Focus: See above for arcane focus. This is the more generic focus that is required for arcane or divine spells.

Maximum Focus cost in gp: As above for the Maximum Arcane Focus cost in gp.

XP: This is only used in 3.5 where some spells have XP costs.

Maximum XP cost: Some spells have variable XP costs depending on how the spell is cast. Perhaps a feat or ability allows you to ignore XP costs up to 250 XP, and a spell may be cast so that it can cost 250 XP or 500 XP. You can ignore the XP cost when it costs 250, but not 500. So, you can write the formula to display the cost regardless since it may apply.

Casting Time

Casting Time Number: This is the numerical portion of the casting time. It may be a formula, but it must evaluate to a number.

Casting Time Type: This is the text portion of the casting time. It may be a formula, but it must evaluate to text. Do not add quote marks around the casting time. This is one of the few situations where the text portion is not evaluated inside another formula, so it does not need quotes.

Range

Range Number: This is the numerical portion of the range of a spell. For instance, a 60 foot ray would have a Range Number of 60. This may be a formula, but it must evaluate to a number.

Range Type: This is the units for a range. It may be feet, miles, or any other descriptive term. It may also be a type like Close, Medium, Long, Touch, or Personal. If this field is used in the Range Formula (see below), it must evaluate to text enclosed in quote marks!!! It will generate an error otherwise. It does not need quotes if it is not used in the formula. For example, if the range is Long, you will not see the range type of Long on the Spell Planner worksheet. Instead, it will evaluate to a Range Number of 400+40*i_EffectiveCasterlevel and a Range Type of "ft." (the quotes are necessary).

Range Formula: May be text like Personal or Touch (no quote marks), or a formula like {Range Number}&" "&{Range Type}. This formula replaces the {Range Number} with whatever is in the range number field. It replaces the {Range Type} with whatever the Range Type evaluates to. If you are using the formula for Range Formula, and the Range Type does not have quotes around it, it will think that whatever you put as the Range Type is a named cell in TOS+, and it will break. There is no named cell called ft. Example: a 60 ft ray would have:

Range Number: 60

Range Type: "ft."

Range Formula: {Range Number}&" "&{Range Type}

When evaluated, it would show this formula:

60&" "&"ft."

Without the quotes, it would try to evaluate:

60&" "&ft.

This would generate an error because it is trying to find a named cell called ft.

Targets, Areas, and Effects

Target Number n: This is a formula that evaluates to the number of targets. It must evaluate to a number

Area Number n: This is a formula that evaluates to the numeric portion of the area covered by the spell. You may have up to three numbers for the area.

Effect Number n: This is a formula that evaluates to the numeric portion of the effects of a spell. You may have up to three numbers for the spell effects.

Area / Shape: This is a text field that stores what kind of area or shape the spell takes. This must evaluate to text in quote marks as it is used in the Area Formula below.

Energy Type: This is a text field that stores the energy type of the spell. This must evaluate to text in quote marks as it can be used in the formulas below.

Target Formula: This is a formula that can use any of the following fields: {Target Value 1}, {Target Value 2}, {Area Value 1}, {Area Value 2}, {Area Value 3}, {Effect Value 1}, {Effect Value 2}, {Effect Value 3}

Area Formula: This is a formula that can use any of the following fields: {Target Value 1}, {Target Value 2}, {Area Value 1}, {Area Value 2}, {Area Value 3}, {Effect Value 1}, {Effect Value 2}, {Effect Value 3}, {Area / Shape}

Effect Formula: This is a formula that can use any of the following fields: {Target Value 1}, {Target Value 2}, {Area Value 1}, {Area Value 2}, {Area Value 3}, {Effect Value 1}, {Effect Value 2}, {Effect Value 3}, {Energy Type}

Duration

Duration Number: The numerical portion of the spell's duration, must evaluate to a number

Duration Unit: The text portion of the spell's duration. Must evaluate to text in quotes.

Duration Formula: This formula can use the following fields: {Duration Number}, {Duration Unit}

Damage Dice/Variable Dice: n may be 1 or 2.

Number Damage Dice n: This is the number of dice (typically damage dice, but it can be used for any type of effect that has dice rolled). Must evaluate to a number.

Damage Dice Type n: This is the size of the dice. Example, 2d6 would have Number Damage Dice of 2 and Damage Dice Type of 6. This must evaluate to a number.

Damage Bonus n: This is the bonus that is added to the dice roll. Example: 2d6+5 would have Damage Bonus of 5. This must evaluate to a number.

Max Damage Bonus n: This is the cap for damage bonus. For example, Cure Light Wounds heals 1d8+caster level (max 5). That would have Number Damage Dice of 1, Damage Dice Type of 8, Damage Bonus of i_EffectiveCasterlevel, and Max Damage Bonus of 5.

Damage Type n: This is the type of damage being dealt. It must evaluate to text in quotes.

Max Number Damage Dice n: This is for effects that have a damage dice cap, like Fireball caps at 10d6. So, that would have Number Damage Dice of i_EffectiveCasterlevel, Damage Dice Type of 6, and Max Number Damage Dice of 10.

Damage Formula n: This formula may use any of the fields with the same number. Here are the available fields: {Number Damage Dice n}, {Damage Dice Type n}, {Damage Bonus n}, {Max Damage Bonus n}, {Damage Type n}, {Max Number Damage Dice n}. It may not use fields with a different number than the formula. Example, you cannot use {Number Damage Dice 2} in Damage Formula 1. You cannot use {Damage Bonus 1} in Damage Formula 2.

Similarly for Variable dice, only there is only one set of variable dice allowed. Use the Damage dice if you need additional variable dice formulas.

Description Formula: This is the description of the spell. It must evaluate to text. It can use any of the following fields: {Damage Formula 1}, {Damage Formula 2}, {Variable Formula}, {Damage Type 1}, {Damage Type 2}, {Variable Type}