Class Worksheet

From Wiki for The Only Sheet
Jump to navigation Jump to search

<<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, Clear and Fetch Existing 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.

Specifically, the Fetch Existing button is used to get an existing class into the custom area, so that you have a starting point to create a custom class based on this existing class. Obviously you will need to review the class that was grabbed by the Fetch Existing button to make sure it complies to your needs.

Base Details

The basic details of the class you are creating. Many comments are available to give extra information about each of these cells.

Base Attacks & Saves

Self-explanatory

Class Options

This section allows a custom class to have options. Three links are shown on the right of that section to jump to special section:

  • Data Table setup: This is a big area that can be used to hold a lot of custom data.
  • Option setup area: This allows you to setup your OWN options for the user to chose from. These options will be shown in the drop-down combo-box of each option
  • Source Table setup: If the option you require is already an existing list, you can just tell the sheet the named cell referencing this list. For example, using t_YesNo will show a Yes/No option for the option

Spells per Day Formulas

You can define the spell progression per spell level here. The easiest way is to use the Spell Known & Spells per Day GENERATOR to easily create the formulas needed for your custom class. It is pretty simple to use; just follow the steps.

Still, here is a more elaborate explanation of what the formulas needed in this section; It is suggested you use a formula similar to the one below. For this example, we look at the level 1 spell for a custom class named 'Mage' - replace 'Mage' by the name of your custom class, and define your own progression):

=IF(COUNTIF(t_CastingClass,"Mage")=0,-1,CHOOSE(MAX(1,MIN( SUM(IF(res_Caster1="Mage",res_CasterLvl1SpD,0),IF(res_Caster2="Mage",res_CasterLvl2SpD,0),IF(res_Caster3="Mage",res_CasterLvl3SpD,0), VLOOKUP("Mage",t_Class,index_Class_SpellPerDayAdj,FALSE)),20)),1,2,2,3,3,3,4,4,4,4,4,4,4,4,4,4,4,4,4,4))

The first part of this formula check to see if your custom class is part of the casters for your character - it will be once you select it on the front worksheet, and make sure that the Is this a Spellcasting class: is set to Yes. Since the custom class can actually be added to any of the 3 custom class slots, the first part of the CHOOSE() section deals with getting the correct information if this is the case. The rest of the CHOOSE() is the value per level

  • When the value of the Spell per Day is -1, this means that there are NO spells available at that level.
  • When the value of the Spell per Day is 0, this means that the custom class may get bonus spell(s) per day as per its casting attribute (set in the basic details section)

Spell Known Formulas

While you can easily create the formulas needed for the Spell Known using the Spell Known & Spells per Day GENERATOR, you can check out this example of the formula generated for the Sorcerer (3.5 OGL) class.

=IF(COUNTIF(t_CastingClass,"Sorcerer")=0,0, CHOOSE(MIN(SUM(IF(res_Caster1="Sorcerer",res_CasterLvl1SK,0),IF(res_Caster2="Sorcerer",res_CasterLvl2SK,0),IF(res_Caster3="Sorcerer",res_CasterLvl3SK,0), VLOOKUP("Sorcerer",t_Class,index_Class_SpellKnownAdj,FALSE)),20),2,2,3,3,4,4,5,5,5,5,5,5,5,5,5,5,5,5,5,5))

For your custom needs, replace the class name, and set the CHOOSE() values to what you need.

Psionic Power Generator

Simply follow the steps to create the appropriate formulas for your Psionic class!

Effects for Class

This section holds all the effects you are defining for your custom class. You can re-use existing effects, when these are not level dependent on an existing class. For instance, the Darkvision60 effect would grant a 60 feet Darkvision ability to your Character. You can check the AbilityData worksheet for a list of ALL abilities. Review the ones you need to make sure they do not use lvl_ClassName values, which makes them class dependent.

Here are some links to more information on how to create effects

  • On the Home Page:
    • The Video section has tutorials on creating effects
  • On this Wiki:
  • On the Forum:
    • The Ask the Wizards (TOS+ Help Desk) section of the forum ha smany answered questions regarding effects. If you have an active subscription to TOS+, search that section for assistance/help!

Skills

Use the CLASS SKILLS TOOL to create the list of skills of your custom class. Just follow the steps and voila!

Class Features

This is where you define the class features of your custom class. Best way to learn on how to use this section is to fetch an existing class, and check it out!

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-colon 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-colon , 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 colon 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-colon 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.

Retrieved from "https://theonlysheet.com:443/wiki/index.php?title=Class_Worksheet&oldid=3326"