View Single Post
Old 09-29-2018, 04:02 AM   #2
coronatiger
 
Join Date: Apr 2018
Location: Trondheim, Norway
Default 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
  • Make notes here :)

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"
__________________
You don't need to spend 100 CP on Status 5 [25] and Multimillionaire [75] to feel like a princess, when Delusion [-10] will do.

Character sheet: Google Drive link (See this thread for details.)

Campaign logs: Chaotic Pioneering / Confessions of a Forked Tongue

Last edited by coronatiger; 05-26-2022 at 11:47 AM. Reason: New version of character sheet
coronatiger is offline   Reply With Quote