TOS 2nd

TOS 2ⁿᵈ PRO edition

TOS 2ⁿᵈ PRO edition uses the same powerful engine as its brothers TOS+/TOS FIVE. In this regard, many aspects that are discussed for the other managers also apply for TOS 2ⁿᵈ PRO edition. This section discusses aspects where differences can be found.

Defining Custom Spells

The Spells sheet contains the list of all the spells currently available to the user. You can create new custom spells as needed at the bottom of the spell table. It is strongly suggested that you examine the existing spells, to see how to write any new Custom spells you might need.

i_CL (Cantrip Level)

In Pathfinder 2ⁿᵈ edition, Cantrips and Focus spells are always considered to be cast at the highest possible spell level available to the Character. In this regard, i_CL represent the highest spell level available to the user. Let's look at an example of use:

The level 1 Cantrip CHILL TOUCH deals 1d4 damage to a living creature, and with Heightened (+1), this increases by 1d4. So basically, the Description would use something like this to take into account the Heightened bonus:

="Against living creature, deals "&i_CL&"d4"

When the Character will be able to cast level 2 spells, then i_CL will be equal to 2, and the spell above will be updated to 2d4 damage!

ABILITYSCORE (Key Spellcasting Ability Score)

Sometimes, a spell will ALSO add a bonus which is based on the Key Ability Score of the Character. In such cases, we can't really KNOW the ability score that will be used, since the spell entry is created before any Characters are created! This means we cannot evaluate the formula when we create it... quite an issue right? Fear not! The sheet has the ability to evaluate the spell details AFTER the user has created his character.

Looking again at CHILL TOUCH, the book says that you also ADD your spellcasting modifier to the 1d4 damage. In this case, we would add to our description to take this into account:

"Against living creature, deals "&i_CL&"d4+"&ABILITYSCORE

Did you notice our new formula does not start with the equal sign? This is because this description will be evaluated later, on the Spell Planner (when that spell is selected. HOW does the Spell Planner knows it has to Evaluate a Description? By detecting the use of the Quotation mark!

The quotation mark is used by the Spell Planner to detect that the entry it is attempting to read, is in fact a formula that needs to be Evaluated dynamically! So do NOT use it in any part of your Spell, to avoid issues. If you need to specify inches, use two ' symbols!

So if the PC has +2 to his ability score, the 'ABILITYSCORE will be the value 2.

LVLSPELL (Level of the Spell)

If you are creating a regular spell, the LVLSPELL replacement will be useful to define spells that have a Heightened component to it. Since Cantrips and Focus spells ARE already Heightened, LVLSPELL will be more useful for the standard spells you create. Let's look at the level 1 Burning Hands spell. It deals 2d6 fire damage. And when Heightened (+1), the damage increases by 2d6. So basically, is deals twice the level of the spell:

"Deals "&2*LVLSPELL&"d6 fire damage to creatures in the area"

Again, the equal symbol is omitted at the start of the description, to allow the Spell Planner to Evaluate it dynamically.

Which columns can use ABILITYSCORE and LVLSPELL?

You can use the LVLSPELL tag in these columns on the spells worksheet:

• Area
• Description
• Duration
• Range
• Target

When evaluating a string as a formula, Microsoft has limited the length of the string that can be evaluated to 255 characters (I have no idea why!). The Sheet will let you know if you have exceeded this hard limit should your string is too long. In this case, try to reduce the length as much as possible!

NOTE: When using the special tags, you need to create a string that starts with the quotation mark (and NOT the equal sign!). This is because this string will be evaluated internally inside the Spell Planner by replacing the tags with the proper value needed. This also means that if you might need to add an empty string at the start to make sure this is detected as a string to evaluate (The Sheet actually looks at the FIRST character and checks to see if it is a quotation mark; If so, it will try to evaluate this string as a formula).

For example: ""&TRUNC((LVLSPELL+1)/2)&"0' emanation"

If you need more clarification or need help with a custom spell, be sure to ask in the appropriate HELP desk on the Community Forum or on the Discord server!

Useful Booleans

The Tables worksheet has a section for the Booleans available in The Sheet. Examined that table if you are looking for a specific "True/False" value. Ask us if you are unable to find what you are looking for.