View source

This is a temporary page intended to house various possible GP-to-category point conversion functions (or formulae), until a final decision can be made.

== Functions from a023 spreadsheet ==
These are the functions taken from the a023 version, the latest, of the MS Excel character creation spreadshet. Note that they are several years old, and at that time Attributes and aDvantages were separate categories.

'''Attribute Points (AP)'''
AFRUND(((C4/5)^2)+(C4/2),0)+((2*J33)/5)

'''aDvantage Points (DP)'''
AFRUND(((C5/5)^2.25)+(C5),0)-((1*J33)/1)

'''Perk Points (PP)'''
AFRUND(((C6/5)^2.5)+(C6*2),0)+J29

'''Skill Points (SP)'''
AFRUND((((C7/5)^2.5)*100)+C7*50,0)+HVIS(Skills!AN2=SAND,Tables!F227,0)+J31
=== Commentary and translation ===
"AFRUND" is simply the Danish language version of the rounding function, and rounds to nearest whole number. J33 is a cell that lets the user convert DPs to APs, and the other way around, so we can ignore that. J29 is "added Perk Points". I can't recall what that was used for. J29 is "added Skill Points". These can be ignored too. The middle part of the Skill Points function almost certainly deals with free SPs given out to pay for Gravity and Atmosphere Familiarity Skills. This, too, can be ignored.
=== Lossless Simplification ===
This section deals with the functions from the v a023 spreadsheet, removing everything defined as "can be ignored" in the previous section.

'''AP = (GP/5)^2 + (GP/2)'''

'''DP = (GP/5)^2.25 + GP'''

'''PP = (GP/5)^2.5 + (GP*2)'''

'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''

=== Analysis and modifications ===
APs and DPs will be combined into DPs, using a ^2 exponent. and probably no overall multiplier. This is probably a good choice:

'''DP = (GP/5)^2 + GP'''

Perk Points need to be multiplied somewhat, to get rid of the half-points used throughout older documents. Maybe multiply by 3, to get a nice and fine-grained scale.

'''PP = ((GP/5)^2.5 + GP*2)*3'''

The SP formulae yields almost 28k Skill Points for 46 Goodie Points. I'm not sure that is super-good, but it doesn't need much upward tweaking.

'''SP = ((GP/5)^2.5 + GP) * 120'''

The only change is, I'm giving the linear component doubled weight, and using a multipier of *120 instead of *100.

==== Conclusion ====
The above is probably good.

[[Category:Editor stuff]]