GP formulae

From Sagataflwiki

(Difference between revisions)
Jump to: navigation, search
(Functions from a023 spreadsheet: Inserting BR tags)
(Commentary and translation: adding more translation)
Line 16: Line 16:
<br>AFRUND((((C7/5)^2.5)*100)+C7*50,0)+HVIS(Skills!AN2=SAND,Tables!F227,0)+J31
<br>AFRUND((((C7/5)^2.5)*100)+C7*50,0)+HVIS(Skills!AN2=SAND,Tables!F227,0)+J31
=== Commentary and translation ===
=== 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.
+
"AFRUND" is simply the Danish language version of the rounding function, and rounds to nearest whole number. "HVIS" is the IF function, and "SAND" means "TRUE"
 +
 
 +
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 ===
=== Lossless Simplification ===
This section deals with the functions from the v a023 spreadsheet, removing everything defined as "can be ignored" in the previous section.
This section deals with the functions from the v a023 spreadsheet, removing everything defined as "can be ignored" in the previous section.

Revision as of 23:48, 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. "HVIS" is the IF function, and "SAND" means "TRUE"

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

Personal tools