Guilds/NERF/Ikuu's spreadsheet info - Revision history

Ikuu at 04:22, 2 October 2009

2009-10-02T04:22:30Z

Ikuu: Guilds/NERF/Ikuus spreadsheet info moved to Guilds/NERF/Ikuu's spreadsheet info: fixing typo

2009-10-01T03:32:25Z

Guilds/NERF/Ikuus spreadsheet info moved to Guilds/NERF/Ikuu's spreadsheet info: fixing typo

Ikuu at 23:30, 30 September 2009

2009-09-30T23:30:39Z

Ikuu: New page: The basic idea that the spreadsheet uses is best shown by example. Consider Eggplant and Nature's Jug. Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/...

2009-09-30T20:25:05Z

New page: The basic idea that the spreadsheet uses is best shown by example. Consider Eggplant and Nature's Jug. Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/...

New page

The basic idea that the spreadsheet uses is best shown by example. Consider Eggplant and Nature's Jug.

Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/1. When the foods are cooked with 13 eggplant and 1 Nature's, eggplant's weight of 5 is the same for all stat values, but Nature's Jug stats are weighted at 3 for 0/0/0/-0.9/0/0/1 and 5 for 0/0/-0.89/0/0/0/.

More info later....

← Older revision		Revision as of 04:22, 2 October 2009
Line 2:		Line 2:

	Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/1. When the foods are cooked with 13 eggplant and 1 Nature's, eggplant's weight of 5 is the same for all stat values, but Nature's Jug stats are weighted at 3 for 0/0/0/-0.9/0/0/1 and 5 for 0/0/-0.89/0/0/0/. Notice how the Nature's Jug's weight 3 stats are also non-zero for Eggplant, while the weight is 5 for the ones not shared.		Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/1. When the foods are cooked with 13 eggplant and 1 Nature's, eggplant's weight of 5 is the same for all stat values, but Nature's Jug stats are weighted at 3 for 0/0/0/-0.9/0/0/1 and 5 for 0/0/-0.89/0/0/0/. Notice how the Nature's Jug's weight 3 stats are also non-zero for Eggplant, while the weight is 5 for the ones not shared.
		+
		+	Since the stats modified by a food are weighted similarly, it's natural to think of them as [[http://en.wikipedia.org/wiki/Vector_(mathematics_and_physics) vectors]]. Seven total stats means our vectors live in 7-dimensional space, but since we're only dealing with 2 foods, the vectors and their resulting combinations all live in a plane, which is 2-dimensional. The problem is that, when the resulting combinations are calculated by the game, they are rounded to integer values. This rounding drives the vector combinations away from their actual values and so the plane that the points were within can only be estimated.
		+
		+	Another difficulty is that the stat-values for a given food are initially unknown, and must be inferred from multiple recipes involving that food. The current incarnation of my spreadsheet does no calculation to determine the stat values. It just simplifies the work required to test different manually entered values.

← Older revision		Revision as of 23:30, 30 September 2009
Line 1:		Line 1:
	The basic idea that the spreadsheet uses is best shown by example. Consider Eggplant and Nature's Jug.		The basic idea that the spreadsheet uses is best shown by example. Consider Eggplant and Nature's Jug.

−	Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/1. When the foods are cooked with 13 eggplant and 1 Nature's, eggplant's weight of 5 is the same for all stat values, but Nature's Jug stats are weighted at 3 for 0/0/0/-0.9/0/0/1 and 5 for 0/0/-0.89/0/0/0/.	+	Eggplant has stats 1/0/0/1/0/-0.9/-1 and Nature's Jug has stats 0/0/-0.89/-0.9/0/0/1. When the foods are cooked with 13 eggplant and 1 Nature's, eggplant's weight of 5 is the same for all stat values, but Nature's Jug stats are weighted at 3 for 0/0/0/-0.9/0/0/1 and 5 for 0/0/-0.89/0/0/0/. Notice how the Nature's Jug's weight 3 stats are also non-zero for Eggplant, while the weight is 5 for the ones not shared.
−
−	~~More info later...~~.

← Older revision	Revision as of 03:32, 1 October 2009
(No difference)