Join Date: Apr 2018
Location: Trondheim, Norway
|
Features of the Excel Character Sheet
Current Version
24.0 (released 2022-05-26)
General features- Open source; you can see and modify all formulas
- Practically no need for manual calculations (and because the character sheet is a spreadsheet, you can easily add your own formulas)
- Protected and color coded sheets to prevent unintended overwriting of formulas; no password is needed to unprotect
Front Page sheet- Information about the Character Sheet
- General information about the character (name, gender, age etc)
- Physical description
- Psychological description (aka role playing cues)
- Picture (no custom feature, just a possibility with Excel)
Attributes sheet- Purchase primary and secondary attributes
- List of points gained initially and during play
- Calculation of point value and unspent points; point value may be set to a percentage of another character's point total
- Points spent on attributes, advantages, languages, skills, techniques and spells are subtracted from unspent points
- Calculation of points received for lowered attributes and disadvantages (to make sure you don't exceed the campaign disadvantage limit)
- Extract of reaction modifiers (from Traits sheet)
- Extract of fright check modifiers (from Traits sheet)
Attr Mods sheet- Enter your list of enhancements and limitations applied to attributes (attribute costs are automatically modified)
- Customize striking strength (you can have different scores with different attacks)
- Define different movement types, like ground move, air move and water move
Form sheet- Enter your racial template and alternate forms here
- What you enter on this sheet is part of your templates, and don't count towards campaign disadvantage limit
Traits sheet- Enter your list of advantages, disadvantages, perks, quirks and 0-point features
- Calculation of costs based on base cost, level, frequency of appearance and self-control roll
- You can specify bonuses to reaction rolls, fright checks, skills (including from dabbler traits), techniques, spells, defenses and DR
Trait Mods sheet- Enter your list of enhancements and limitations applied to advantages and disadvantages (their costs are automatically modified)
- Enter your list of languages with both spoken and written comprehension levels (in a separate table)
Skills sheet- List of all the skills in Basic Set and Martial Arts; you may add more
- Calculation of skill value based on points spent, defaults and bonuses/penalties from traits
- Automatic recalculation of skill value if you choose another attribute on which to base a skill
Techniques sheet- List of all the techniques in Basic Set and Martial Arts; you may add more
- Calculation of skill values based on points spent, base skill and bonuses/penalties from traits
Spells sheet- List of all the spells in Magic and Thaumatology; you may add more
- Calculations of skill value based on points spent and bonuses/penalties from traits
- You can specify temporary bonuses/penalties to spells
- One college Magery included
- Spells can be learned/trained like skills (standard magic) or like techniques (ritual magic)
Current Status sheet- Extract of weapon stats and calculation of damage and range, with attack and defense skill values modified by posture, shield/cloak defense bonus, speed/range/size of target, aim/evaluate bonus
- Table of temporary effects which can be toggled on or off
- You can choose different skills or techniques for attack and defense scores
- Extract of armor stats
- Calculation of status based on lost HP and expended FP
- List of energy reserves
- List of power items
- Table of Per-based skills, with scores adjusted for acute senses
- Toggle which alternate form you're currently wearing
- List of body parts with to-hit-penalties and calculated armor
- DR values for both regular and crushing
Calculations sheet- Table lookups
- Calculation of probability of crit/success/fail/fumble based on effective skill
- Calculation of digging speed
- Calculation of how long you can hold your breath
- Calculation of jumping and throwing distances
- Calculation of slam, shield rush and falling damage
- Calculations related to missed sleep
- Calculation of daily travel distance
- Relative gravity included in calculations
- Extra effort included in calculations
- Conversion between units of length, area, volume, weight and temperature
- Calculation of hearing bonus/penalty based on distance and type of sound
Equipment sheet- Enter your list of equipment, including weapons, ammunition, armor and containers
- Optional auto-calculation of cost and weight based on which body parts the armor covers
- All items can be containers, and you may put containers inside other containers
- Calculation of whether you brought a weapon, armor or equipment with you, based on which container it's in
- Reduction of effective weight of items carried in a cart/wagon etc
- "Bag of holding" style containers
- You count as a container for items you carry that aren't in other containers
- Enter your horse and other characters as containers - encumbrance is calculated
- Calculation of total weight carried and encumbrance level
- Calculation of total value of items owned and carried
- Calculation of money owned and carried
Diary sheet
Time Use sheet- Keep track of what you spend your time on between adventures
- Keep track of study time towards various skills, techniques and traits
House Rules sheet- Toggle house rules on or off. All relevant formulas are recalculated.
- "Don't round off Basic Move"
- "Loss of ST due to having FP less than 1/3 max FP affects ALL ST-based quantities except HP"
- "If a spell belongs to several colleges, bonuses of all instances of college Magery stack"
- "Being reeling from both HP loss and FP loss doesn't divide Move and Dodge by 4"
- "Magery doesn't add to spell levels"
- "Convert extra damage to dice"
- "Allow ST in excess of weapon ST requirement x3 to improve damage with weapons"
- "Use metric units in Calculations sheet"
- "Don't apply encumbrance penalty to skill scores"
- "Don't apply encumbrance penalty to Dodge"
- "Don't apply encumbrance penalty to Move"
Last edited by coronatiger; 05-26-2022 at 11:47 AM.
Reason: New version of character sheet
|