GP formulae
From Sagataflwiki
(→Conclusion: adding final formulae section, for easy export) |
(→Final(?) formulae: Change to DP formula) |
||
| (3 intermediate revisions not shown) | |||
| Line 5: | Line 5: | ||
'''Attribute Points (AP)''' | '''Attribute Points (AP)''' | ||
| - | AFRUND(((C4/5)^2)+(C4/2),0)+((2*J33)/5) | + | <br>AFRUND(((C4/5)^2)+(C4/2),0)+((2*J33)/5) |
'''aDvantage Points (DP)''' | '''aDvantage Points (DP)''' | ||
| - | AFRUND(((C5/5)^2.25)+(C5),0)-((1*J33)/1) | + | <br>AFRUND(((C5/5)^2.25)+(C5),0)-((1*J33)/1) |
'''Perk Points (PP)''' | '''Perk Points (PP)''' | ||
| - | AFRUND(((C6/5)^2.5)+(C6*2),0)+J29 | + | <br>AFRUND(((C6/5)^2.5)+(C6*2),0)+J29 |
'''Skill Points (SP)''' | '''Skill Points (SP)''' | ||
| - | 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. | ||
| Line 47: | Line 50: | ||
===== Final(?) formulae ===== | ===== Final(?) formulae ===== | ||
| - | Here are the final | + | Here are the possibly final formulae in a cut-and-paste friendly format: |
| - | '''DP = (GP/5)^2 + GP''' | + | '''DP = (GP/5)^2 + (GP/3)''' |
| - | '''PP = ((GP/5)^2. | + | '''PP = ((GP/5)^2.75 + GP*2) * 3''' |
| + | |||
| + | '''SP = ((GP/5)^2.75 + GP) * 100''' | ||
| + | |||
| + | '''''Note''''': The exponent for PP and SP was changed from ^2.5 to ^2.75, and at the same time the PP multiplier was changed (back) from *120 to *100. Even without further changes to the PP formula (and changes may still happen), a rough estimate needs to be made of what kinds of results the new formula gives, compared to the old formula used in the old MS Excel spreadsheet (no new spreadsheet exists, as of Mar/2011), for the purpose of converting old PP costs to new PP costs. | ||
| - | + | The exponents above are good and will not be changed, but minor tweaks may still be made so any other formulae components for any of the three. (Now the "linear component of the DP formula has been reduced from +GP to +GP/3). | |
[[Category:Editor stuff]] | [[Category:Editor stuff]] | ||
Latest revision as of 15:32, 16 March 2011
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 possibly final formulae in a cut-and-paste friendly format:
DP = (GP/5)^2 + (GP/3)
PP = ((GP/5)^2.75 + GP*2) * 3
SP = ((GP/5)^2.75 + GP) * 100
Note: The exponent for PP and SP was changed from ^2.5 to ^2.75, and at the same time the PP multiplier was changed (back) from *120 to *100. Even without further changes to the PP formula (and changes may still happen), a rough estimate needs to be made of what kinds of results the new formula gives, compared to the old formula used in the old MS Excel spreadsheet (no new spreadsheet exists, as of Mar/2011), for the purpose of converting old PP costs to new PP costs.
The exponents above are good and will not be changed, but minor tweaks may still be made so any other formulae components for any of the three. (Now the "linear component of the DP formula has been reduced from +GP to +GP/3).
