The Wiki for Tale 4 is in read-only mode and is available for archival and reference purposes only. Please visit the current Tale 11 Wiki in the meantime.
If you have any issues with this Wiki, please post in #wiki-editing on Discord or contact Brad in-game.
Difference between revisions of "Guilds/NERF/Ikuu's spreadsheet info"
(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/...) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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. |
| − | + | 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. | ||
Latest revision as of 04:22, 2 October 2009
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/. 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 [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.
