View Single Post
Old 02-22-2020, 05:04 PM   #32
coronatiger
 
Join Date: Apr 2018
Location: Trondheim, Norway
Default Re: Excel Character Sheet

Version 16.0 was just released.

I changed the formulas that calculate the cost of traits depending on Self Control and Frequency of Appearance values; it's now possible to select any SC or FoA from 3 to 18, with these results:

SC Cost modifier
18 x0
17 x1/6
16 x1/3 (2/6)
15 x1/2 (3/6)
14 x2/3 (4/6)
13 x5/6
12 x1 (6/6)
11 x7/6
10 x4/3 (8/6)
9 x3/2 (9/6)
8 x5/3 (10/6)
7 x11/6
6 x2 (12/6)
5 x13/6
4 x7/3 (14/6)
3 x5/2 (15/6)

FoA Cost modifier
18 x4 (12/3)
17 x11/3
16 x10/3
15 x3 (9/3)
14 x8/3
13 x7/3
12 x2 (6/3)
11 x5/3
10 x4/3
9 x1 (3/3 = 6/6)
8 x5/6
7 x2/3 (4/6)
6 x1/2 (3/6 = 6/12)
5 x5/12
4 x1/3 (4/12)
3 x1/4 (3/12)

I also added a color scheme for "setup" or "config" cells. These cells are editable cells, previously marked with green background color like the other input cells, but contain values that rarely should be altered during play, like Tech Level, skill difficulty and World gravity.

A new "house rule" is added. If this rule is turned on, results of formulas in "Calculations" sheet are presented in metric units, if it's off, imperial units are used.

I fixed a couple of small bugs, too.
__________________
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
coronatiger is offline   Reply With Quote