GP formulae - Revision history

Peter Knutsen: /* Final(?) formulae */ Change to DP formula

Peter Knutsen — Wed, 16 Mar 2011 15:32:14 GMT

Final(?) formulae: Change to DP formula

← Older revision		Revision as of 15:32, 16 March 2011
Line 52:		Line 52:
	Here are the possibly final formulae in a cut-and-paste friendly format:		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.75 + GP2) 3'''		'''PP = ((GP/5)^2.75 + GP2) 3'''
Line 60:		Line 60:
	'''''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.		'''''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.	+	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]]

Peter Knutsen: /* Final(?) formulae */ A few changes (formulae are still not final, but the exponents are)

Peter Knutsen — Tue, 15 Mar 2011 10:28:46 GMT

Final(?) formulae: A few changes (formulae are still not final, but the exponents are)

← Older revision		Revision as of 10:28, 15 March 2011
Line 50:		Line 50:

	===== Final(?) formulae =====		===== Final(?) formulae =====
-	Here are the final~~(?)~~ formulae in a cut-and-paste friendly format:	+	Here are the possibly final formulae in a cut-and-paste friendly format:

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

-	'''PP = ((GP/5)^2.5 + GP2)3'''	+	'''PP = ((GP/5)^2.75 + GP2) 3'''

-	'''SP = ((GP/5)^2.5 + GP) * ~~120~~'''	+	'''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.

	[[Category:Editor stuff]]		[[Category:Editor stuff]]

Peter Knutsen: /* Commentary and translation */ adding more translation

Peter Knutsen — Tue, 21 Dec 2010 23:48:36 GMT

Commentary and translation: adding more translation

← Older revision		Revision as of 23:48, 21 December 2010
Line 16:		Line 16:
	<br>AFRUND((((C7/5)^2.5)100)+C750,0)+HVIS(Skills!AN2=SAND,Tables!F227,0)+J31		<br>AFRUND((((C7/5)^2.5)100)+C750,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.

Peter Knutsen: /* Functions from a023 spreadsheet */ Inserting BR tags

Peter Knutsen — Tue, 21 Dec 2010 23:28:02 GMT

Functions from a023 spreadsheet: Inserting BR tags

← Older revision		Revision as of 23:28, 21 December 2010
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)+C750,0)+HVIS(Skills!AN2=SAND,Tables!F227,0)+J31	+	<br>AFRUND((((C7/5)^2.5)100)+C750,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. 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.

Peter Knutsen: /* Conclusion */ adding final formulae section, for easy export

Peter Knutsen — Tue, 21 Dec 2010 21:17:48 GMT

Conclusion: adding final formulae section, for easy export

← Older revision		Revision as of 21:17, 21 December 2010
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 + GP2)3'''
		+
		+	'''SP = ((GP/5)^2.5 + GP) * 120'''

	[[Category:Editor stuff]]		[[Category:Editor stuff]]

Peter Knutsen: /* Lossless Simplification */ removing end paranthesis

Peter Knutsen — Tue, 21 Dec 2010 21:11:28 GMT

Lossless Simplification: removing end paranthesis

← Older revision		Revision as of 21:11, 21 December 2010
Line 18:		Line 18:
	"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. 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.

	'''AP = (GP/5)^2 + (GP/2)'''		'''AP = (GP/5)^2 + (GP/2)'''
Line 27:		Line 27:

	'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''		'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''
		+
	=== Analysis and modifications ===		=== 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:		APs and DPs will be combined into DPs, using a ^2 exponent. and probably no overall multiplier. This is probably a good choice:

Peter Knutsen: /* Analysis and modifications */ typo, adding colon

Peter Knutsen — Tue, 21 Dec 2010 21:10:53 GMT

Analysis and modifications: typo, adding colon

← Older revision		Revision as of 21:10, 21 December 2010
Line 28:		Line 28:
	'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''		'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''
	=== Analysis and modifications ===		=== 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 ~~choce~~	+	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'''		'''DP = (GP/5)^2 + GP'''

Peter Knutsen: /* Analysis and modifications */ typo, moving text, expressing myself in a less confident manner

Peter Knutsen — Tue, 21 Dec 2010 21:09:31 GMT

Analysis and modifications: typo, moving text, expressing myself in a less confident manner

← Older revision		Revision as of 21:09, 21 December 2010
Line 28:		Line 28:
	'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''		'''SP = ((GP/5)^2.5 + (GP/2)) * 100'''
	=== Analysis and modifications ===		=== Analysis and modifications ===
-	APs and DPs will be ~~cobined~~ into DPs, using a ^2 exponent. and probably no overall multiplier.	+	APs and DPs will be combined into DPs, using a ^2 exponent. and probably no overall multiplier. This is probably a good choce

-	'''DP = (GP/5)^2 + GP''' ~~is probably a very 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.		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.

Peter Knutsen: Creating the article

Peter Knutsen — Tue, 21 Dec 2010 21:04:00 GMT

Creating the article

New page

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 cobined into DPs, using a ^2 exponent. and probably no overall multiplier.

'''DP = (GP/5)^2 + GP''' is probably a very good choice

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]]