Standard Practices: Difference between revisions

From Wiki for The Only Sheet
Jump to navigation Jump to search
No edit summary
 
No edit summary
Line 2: Line 2:


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.
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. This formula is always in the form '''<OOO>''' where the Capital 'O' represent the
The named cell '''t_CheckMark''' represent the Character (in the Arial Font) that will be used to denote the 'mark'. The formula is, for abilities that have a fixed amount per day:
{|width="80%" align="center" style="background:#ffdead;"
|-
|style="border:none;padding:1px;" |
[[Image:Exclamation.gif||left]]
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!)
|}
== Racial Traits ==
When listing the Racial traits of a race,
== 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:
<code>=IF(tSel_Race="Nixie","Charm person (Sp): 3/day, CL 4, DC"&11+i_CHAModif&" Will  "&IF(t_CheckMark="",""," <"&REPT(t_CheckMark,3)&">"),"Inactive")</code>
As you can see, the first thing that this formula checks is '''IF''' the current race is a "Nixie". 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 in use.

Revision as of 22:03, 14 April 2007

[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. This formula is always in the form <OOO> where the Capital 'O' represent the

The named cell t_CheckMark represent the Character (in the Arial Font) that will be used to denote the 'mark'. The formula is, for abilities that have a fixed amount per day:


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!)


Racial Traits

When listing the Racial traits of a race,

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". 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 in use.