FANDOM


(Added information about OACS.)
 
 
Line 1: Line 1:
 
'''{{PAGENAME}} (OACS)''' is a fan made character sheet that automatically calculates the stats for your character. It is made on a spreadsheet.
 
'''{{PAGENAME}} (OACS)''' is a fan made character sheet that automatically calculates the stats for your character. It is made on a spreadsheet.
   
It is current in version 2.2 and can be found [https://docs.google.com/spreadsheets/d/1gBMLNUUUk4DvrXKRwdT3Se0BPZGOhn6KfPWIlHZcgjU/edit?usp=sharing here].
+
It is currently in version 2.5 and can be found [https://docs.google.com/spreadsheets/d/1gBMLNUUUk4DvrXKRwdT3Se0BPZGOhn6KfPWIlHZcgjU/edit?usp=sharing here].
   
 
== Instructions ==
 
== Instructions ==
Line 22: Line 22:
 
# 2) To increase skill after an adventure, go to "Rank Up". enter values in the current adventure level, increase adventure level, remove old ticks from the character sheet
 
# 2) To increase skill after an adventure, go to "Rank Up". enter values in the current adventure level, increase adventure level, remove old ticks from the character sheet
   
== Version 2.2 ==
+
== Version 2.5 ==
 
* Automated Backgrounds,Weapon and Cybernetic skill and attribute boost (except for the intellipistol)
 
* Automated Backgrounds,Weapon and Cybernetic skill and attribute boost (except for the intellipistol)
 
* Automated Weapon, Equipment, Background, Karma, Cybernetic, Enhancement, Armour Lists
 
* Automated Weapon, Equipment, Background, Karma, Cybernetic, Enhancement, Armour Lists
Line 28: Line 28:
 
* Automated Skill Tick system for skill increase per adventure and Rank Up
 
* Automated Skill Tick system for skill increase per adventure and Rank Up
 
* Automated Cybernetic Karma and CR costs
 
* Automated Cybernetic Karma and CR costs
* New Ship sheet (partially automated)
+
* Ship sheet discontinued
* Allows inclusion of custom Weapons and Equipment in the "Ranged Weapons", "Melee Weapons" and "Equipment sheets" as well as custom formulas via the "bus" sheet
+
* Allows inclusion of custom Weapons and Equipment in the "Ranged Weapons", "Melee Weapons" and "Equipment sheets" as well as custom formulas via the "bus" sheet.
  +
* UI improvements to character sheet. Conditional formatting, layout.
  +
* Bug fixes to armour social factor display, weapon to hit display, Karma capabilitites
  +
* implemented Military, Espionage, Supertrader supplement's new Enhancements, backgrounds, karma capabilities equipment and weapons.
   
 
== Under the Hood ==
 
== Under the Hood ==
Line 41: Line 41:
   
 
=== Reference Data ===
 
=== Reference Data ===
Reference data for Backgrounds, Equipment, Weapons are stored on separate sheets with a Datalist sheet consolidating specific lists required for drop down menus and other formula usage.
+
Reference data for Backgrounds, Equipment, Weapons are stored on separate sheets with a Datalist sheet called "equipment lists" consolidating specific lists required for drop down menus and other formula usage.

Latest revision as of 12:46, March 20, 2018

Olivia's Automated Character Sheet (OACS) is a fan made character sheet that automatically calculates the stats for your character. It is made on a spreadsheet.

It is currently in version 2.5 and can be found here.

Instructions Edit

  1. 1) Copy this character sheet
  2. 2) Input spaces are dark green
  3. 3) Go to Creation Settings and Choose your backgrounds (4 choices)
  4. 4) If you backgrounds give you skill or enhancement choices, select them from V25:AG32
  5. 5) Choose 3 Karma Abilities and hide the sheet. (right click tab and left click "Hide sheet"
  6. 6) If you are a cyborg, choose prostheses from "Cybernetic Upgrades". (It is not required to switch "Purchase Cybernetics" to "Yes" if you have the background)
  7. 7) Choose 10 skills to bump up for Independent learning
  8. 8)"Add Equipment to Carried Weapons", "Worn Clothing", "Equipment Stored in Pack" and "Equipment stored in Ship"
  9. On Rank Up
  10. 1) Find the "Rank up" sheet and add skill points after the adventure has ended.
  11. 2) Choose an enhancement or "Karma"
  12. 3) If you choose "Karma" Choose a new Karma ability in the Karma table.
  13. 4) Roll a d10, 10 times and add those values to 10 different skills in the row for that rank

Notes Edit

  1. 1) If you wish to remove an option, left-click the cell and press backspace.
  2. 2) To increase skill after an adventure, go to "Rank Up". enter values in the current adventure level, increase adventure level, remove old ticks from the character sheet

Version 2.5 Edit

  • Automated Backgrounds,Weapon and Cybernetic skill and attribute boost (except for the intellipistol)
  • Automated Weapon, Equipment, Background, Karma, Cybernetic, Enhancement, Armour Lists
  • Automated Cybernetics effects and Carried Weapon slots
  • Automated Skill Tick system for skill increase per adventure and Rank Up
  • Automated Cybernetic Karma and CR costs
  • Ship sheet discontinued
  • Allows inclusion of custom Weapons and Equipment in the "Ranged Weapons", "Melee Weapons" and "Equipment sheets" as well as custom formulas via the "bus" sheet.
  • UI improvements to character sheet. Conditional formatting, layout.
  • Bug fixes to armour social factor display, weapon to hit display, Karma capabilitites
  • implemented Military, Espionage, Supertrader supplement's new Enhancements, backgrounds, karma capabilities equipment and weapons.

Under the Hood Edit

The Bus Edit

Each stat is a sum of the result of all chosen backgrounds, and skill score increases from levelling up and end of adventure skill usage. they are stored separately in one row for that particular skill on a sheet named Bus so they can be easily summed up and displayed on the character sheet.

This applies to skillcap, attributes such as movement distance and weight carried.

Doing it this way allows one to easily add on extra mechanics that influence a stat because all they would have to do is enter the formula for their new feature in the next empty row for the stats that it affects.

Reference Data Edit

Reference data for Backgrounds, Equipment, Weapons are stored on separate sheets with a Datalist sheet called "equipment lists" consolidating specific lists required for drop down menus and other formula usage.

Community content is available under CC-BY-SA unless otherwise noted.