Standard Practices
[UNDER CONSTRUCTION]
These standard practices will help you create content that is conform with the current content. This will help make all information have the same look & feel!
Times per Day
When creating an Ability that has a "times per day" limitation, you should always add a simple formula that will display the check marks representing that number of times per day, which is very useful for those using the paper version of TOS+. Here is an example:
="Dimension door (Sp): 1/day, CL 7 "&IF(t_CheckMark="",""," <"&t_CheckMark&">"
The named cell t_CheckMark represent the Character (by default, the capital 'O' character) that will be used to denote each 'check mark'. The times per day for an ability should always be displayed as part of the description (in this case as 1/day). For an ability that is used more than once per day, the REPT() excel function can be used to repeat the number of desired check marks, as shown here:
="Dimension door (Sp): 3/day "&IF(t_CheckMark="",""," <"&REPT(t_CheckMark,3)&">"
Evidently, a formula returning an Integer can be used for times per day that can change according to some other factor.
 Those who wish, can 'turn off' the use of the Check Marks, by going to the Customize worksheet, click on the 'CheckMarks' link found in the "Other" section. One of the option there represent the character used for check marks: If that character is deleted, then all check marks will disappear (at least, those coded as shown!) |
Computing Efficiency
When creating an Ability that has a complex formula, try, if possible, to avoid having excel compute that formula when it does NOT apply to the current Character. For example, this Racial Trait for the Nixie race:
=IF(tSel_Race="Nixie","Charm person (Sp): 3/day, CL 4, DC"&11+i_CHAModif&" Will "&IF(t_CheckMark="",""," <"&REPT(t_CheckMark,3)&">"),"Inactive")
As you can see, the first thing that this formula checks is IF the current race is a "Nixie". (tSel_Race contains the race that has been selected on the Front Worksheet). Only if the current race is a "Nixie", will the Charm Person ability be computed and displayed. If the current race is not a Nixie, then this will evaluate to "Inactive", just to note this formula is not currently needed.
BACK to the Creator's Guide