Class Worksheet

<<UNDER CONSTRUCTION>>

The Class Worksheet is where you can create up to 3 new custom classes for your character. You can also Load and Save characters you made, and share them with other subscribers to TOS+. One set of Load/Save/Reset button is given for each of the 3 custom classes. Quick links are provided to jump to various sections.

Buttons and Link Area

The top portion of the Class Worksheet displays, for each class, a Load, Save and Clear button (which do what they say) and some blue links under the buttons. Use those link to navigate quickly to sections of the custom class.

Spell Lists

When creating a casting class, you need to tell the sheet the whole list of spells that this new class can cast, and at which level. Using this section, you simply create a semi-column delimited list of spell names that your Class can cast. There are actually 1 list per level, from level 0 (cantrips/orison) to level 9. The list should not end with a semi-column, as this is only used to seperate entries.

Example of a list for a first level custom Caster:

Alarm;Animate Rope;Burning Hands;Magic Missile;Shield

Once you created the list (or even during creation!) you can click the Assign Spell for Class button. When clicked, The Sheet will go through each spell you listed, and try to find it in the Spell Data Worksheet. Once found, it will assign the proper level in the correct column in the Spell Table, to allow the Spell Planner to find the level of the spell for your custom class!!

If you enter spells which are not found, a warning with all the missing spells will be displayed. Fix the spell names for which you used the wrong syntax. If you entered names of 'new' spells that at not currently in the Spell Data Worksheet, you will also get a warning. You can safely ignore those warnings for 'new' spells.

If you decide to add those new spells to the Spell Data Worksheet after you have pressed the Assign Spell for Class button, you will need to press it again to refresh the lists! If those new spells are already present when either the Class or the Character loads, the Sheet will automatically update the spell levels in the Spell Data Worksheet!!

Creating the spell list can take some time if the casting class has a lot of available spells. If you have access to an electronic form of the spell list, it becomes much easier to work on a copy of this spell list, and simply place the semi-column character between spell names. Also note that Spells descriptors in The Sheet are placed in parenthesis, like Confusion (Lesser), or Enlarge Person (Mass)

Adding Formulas for non-static spell levels

In some cases, a spell available to a class is not static: It depends on a variable, like the class's level, or something else. In such cases, it is possible to ADD a formula to the spell name, which will be used instead of the static level number. To use a formula, use a hash symbol (#) after the spell name, then followed by a valid Excel formula.

For example, let us assume that the ALARM spell requires the custom class be 2nd level before it has access to that spell. Assuming the custom class uses slot #1, here is how it would look:

Alarm#=IF(lvl_Custom1>1,1,"");Animate Rope;Burning Hands;Magic Missile;Shield

• lvl_Custom1: value of the level of the custom class currently in Slot #1 on the Class worksheet.

So for the Alarm spell, it will be available as a 1st level spell ONLY when the custom class level is 2 or more!

Power Lists

Power lists work in the same fashion as Spell List - check the section above. But remember that there are no 0-level powers as they are spells!

Creator's Notes

The Creator's Note section is used to display design notes about the Class.