Advanced - Named Cells: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 38: | Line 38: | ||
The Integer Named Cells contains integer values, and start with ''i_''. That group of Named Cells contains many useful data. Because there are veyr numerous, only the the most useful ones are listed. | The Integer Named Cells contains integer values, and start with ''i_''. That group of Named Cells contains many useful data. Because there are veyr numerous, only the the most useful ones are listed. | ||
=== | === Ability Scores === | ||
{| border="1" width="80%" align="center" class="wikitable" style="text-align:left" cellpadding="1" cellspacing="0" | {| border="1" width="80%" align="center" class="wikitable" style="text-align:left" cellpadding="1" cellspacing="0" | ||
|+ '''''Table: The Integer named cells for Ability Scores''''' | |+ '''''Table: The Integer named cells for Ability Scores''''' | ||
| Line 66: | Line 66: | ||
|- | |- | ||
|style="background:#dddddd;"|i_CHAModif|| style="background:#dddddd;"|The Charisma modifier | |style="background:#dddddd;"|i_CHAModif|| style="background:#dddddd;"|The Charisma modifier | ||
|} | |||
=== Attacks and Saves === | |||
{| border="1" width="80%" align="center" class="wikitable" style="text-align:left" cellpadding="1" cellspacing="0" | |||
|+ '''''Table: The Integer named cells for Attacks and Saves''''' | |||
! style="background:#ffdead;" | Named Cells !! style="background:#ffdead;" | Description | |||
|- | |||
|i_BaseAttack|| The base attack of the character | |||
|- | |||
|style="background:#dddddd;" |i_2ndBaseAttack|| style="background:#dddddd;" |The second base attack (if any) | |||
|- | |||
|i_3rdBaseAttack|| The third base attack (if any) | |||
|- | |||
|style="background:#dddddd;"|i_4thBaseAttack|| style="background:#dddddd;"|The fourth base attack (if any) | |||
|- | |||
|i_BaseFortitude|| The base Fortitude modifier | |||
|- | |||
|style="background:#dddddd;"|i_BaseReflex|| style="background:#dddddd;"|The base Reflex modifier | |||
|- | |||
|i_BaseWill|| The base Will modifier | |||
|} | |} | ||
Revision as of 09:59, 26 July 2006
The Sheet uses thousands of Named Cells to facilitate the creation of formulas. Althoug this page will not try to list all those named cells, the most useful ones are listed by category.
The Generic Named Cells
| Named Cells | Description |
|---|---|
| CR | CR is used to add a Carriage return to the text of a formula |
The Boolean Named Cells
These Named Cells simply return a TRUE/FALSE value, based on the status of the Character. These all start with b_.
| Named Cells | Description |
|---|---|
| b_HeavyArmor | TRUE: if the Character is wearing a Heavy Armor |
| b_HeavyLoad | TRUE: if the Load Class (from Gear) is Heavy |
| b_HoldingShield | TRUE: if the Character is holding a Shield |
| b_LightArmor | TRUE: if the Character is wearing a Light armor, or no armor |
| b_LightLoad | TRUE: if the Load Class (from Gear) is Light |
| b_MediumArmor | TRUE: if the Character is wearing a Medium Armor |
| b_MediumLoad | TRUE: if the Load Class (from Gear) is Medium |
| b_WearingArmor | TRUE: if the Character is wearing any kind of Armor |
The Integer Named Cells
The Integer Named Cells contains integer values, and start with i_. That group of Named Cells contains many useful data. Because there are veyr numerous, only the the most useful ones are listed.
Ability Scores
| Named Cells | Description |
|---|---|
| i_STR | The Strength ability score |
| i_STRModif | The Strength modifier |
| i_DEX | The Dexterity ability score |
| i_DEXModif | The Dexterity modifier |
| i_CON | The Constitution ability score |
| i_CONModif | The Constitution modifier |
| i_INT | The Intelligence ability score |
| i_INTModif | The Intelligence modifier |
| i_WIS | The Wisdom ability score |
| i_WISModif | The Wisdom modifier |
| i_CHA | The Charisma ability score |
| i_CHAModif | The Charisma modifier |
Attacks and Saves
| Named Cells | Description |
|---|---|
| i_BaseAttack | The base attack of the character |
| i_2ndBaseAttack | The second base attack (if any) |
| i_3rdBaseAttack | The third base attack (if any) |
| i_4thBaseAttack | The fourth base attack (if any) |
| i_BaseFortitude | The base Fortitude modifier |
| i_BaseReflex | The base Reflex modifier |
| i_BaseWill | The base Will modifier |