GP formulae
From Sagataflwiki
m (→Lossless Simplification: removing end paranthesis) |
(→Conclusion: adding final formulae section, for easy export) |
||
| Line 45: | Line 45: | ||
==== Conclusion ==== | ==== Conclusion ==== | ||
The above is probably good. | The above is probably good. | ||
| + | |||
| + | ===== Final(?) formulae ===== | ||
| + | Here are the final(?) formulae in a cut-and-paste friendly format: | ||
| + | |||
| + | '''DP = (GP/5)^2 + GP''' | ||
| + | |||
| + | '''PP = ((GP/5)^2.5 + GP*2)*3''' | ||
| + | |||
| + | '''SP = ((GP/5)^2.5 + GP) * 120''' | ||
[[Category:Editor stuff]] | [[Category:Editor stuff]] | ||
Revision as of 21:17, 21 December 2010
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.
Contents |
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.
Final(?) formulae
Here are the final(?) formulae in a cut-and-paste friendly format:
DP = (GP/5)^2 + GP
PP = ((GP/5)^2.5 + GP*2)*3
SP = ((GP/5)^2.5 + GP) * 120
