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/Coastal Plains/Cooking/Theory"

From A Tale in the Desert
Jump to navigationJump to search
Line 142: Line 142:
  
 
= Spreadsheet =
 
= Spreadsheet =
 +
 +
 +
 +
== Old information from T3 the old spreadsheet no long available ==
  
 
The remainder of this page discusses a Microsoft Excel tool that will allow you to more easily get the results that you want, using the herbs and mushrooms that you already have on-hand. The file is a bit too large to include as a wiki attachment, so you'll need to download it from [[Insertfile]].
 
The remainder of this page discusses a Microsoft Excel tool that will allow you to more easily get the results that you want, using the herbs and mushrooms that you already have on-hand. The file is a bit too large to include as a wiki attachment, so you'll need to download it from [[Insertfile]].

Revision as of 16:38, 4 September 2009

Cooking

Back to cooking

Tests page

Contributions


Information from Tale 3:

Consider a Glazed Doughnut

In the middle of the Glazed Doughnut there's a hole that contributes nothing, but if the hole gets too large, you won't have a doughnut any more.

The Doughnut provides most of the bulk, and a bit of the flavor.

The Glazing provides most of the flavor, and a bit of the bulk.

Cooking works that way too!

  • The radius of each base "doughnut" is always exactly 1000 seconds of duration (16.6 minutes).
  • The distance between a Base and an Additive (measured in seconds of duration), determines the size of the hole.
    • The size of the base "doughnut" that's left, after you remove the hole, provides most of the bulk and a bit of the potency.
  • The flavor of each additive "glaze" provides most of the potency and a bit of the bulk.

Back to top

Servings

Your cooking skill level determines the number of Bases that you can use in a recipe, one Base per cooking level. If the number of bases in a recipe exceeds your cooking skill level, you will get muddled results. There are 7 ingredients per serving, and the general formula is Servings = (Na + Nb) modulo 7, where Na is the number of Additive Ingredients and Nb is the number of Base Ingredients. In a typical production recipe there will be one Additive Ingredient per Base, and 7s-1 of each Base ingredient where S is the total number of servings per Base. In other words, a level 5 cook might cook 5*(Na+34Nb)/7 servings, for a recipe with 5 different Additives each paired with an effective Base, which would yield 5*35/7=25 servings.

If your Gastronomy level is 7 or more, from eating Masterpiece Recipes, you will have a Critically Evaluate this Food menu on the kitchen, that will indicate the integer Duration (to the nearest second) and the integer Stats for that recipe.

Back to top

Duration

The duration formulas, for a two ingredient recipe, are:

  • Duration = Additive Boost + Base Bulk
    • Additive Boost, or simply boost is a proportional part of the potency of the additive.
      • If the recipe is 1:6 Additive:Base, then the Additive Boost will be Additive Potency * 1/7.
      • If the recipe is 1:13 Additive:Base, then the Additive Boost will be Additive Potency * 1/14.
      • If you know the duration difference between two recipes that vary only by ratio, you can back out the effect of the Base Bulk, and thereby isolate a hypothetical value for pure potency, even though the value can never be directly measured.
      • Potency fluctuates inversely with usage and perhaps with inventory. Rare herbs are therefore more potent than common ingredients and, to preserve their potency, should only be used as additives. (Don't use Oyster Meat as a base.)
  • Boost = Potency * Na/(Na+Nb), where Na and Nb indicate the units of the same Additive and the same Base.
    • Na < Nb, as their relative amount is what determines their role in a recipe. (Only use Copper Pots.)
  • Bulk = Duration - Boost
  • Distance = 1000 - Bulk

If you use multiple different additives per base, and it's all determined based on distance whether you intended it that way or not, you'll kill your duration.

  • MultipleDiffAdditiveBulk = 1000/Ndiffa^2 - Distance/Ndiffa, where diff indicates different additives that are associated with a base.
    • If there is only one additive, the equation collapses to Bulk = 1000 - Distance.
    • The consequent durations are added together, so if the Additives are at about the same distance the equation collapses to Bulk = 1000/Na - Daverage, so you can't possibly increase your duration by using multiple different additive.
  • If you use more than one of a particular additive, it does increase the duration. If you use three units of a rare herb and 4 units of a seldom used base, you'd get nearly three times the duration, but only one serving.
    • Don't go there unless you are tuning a recipe to be a possible masterpiece. One unit of a rare herb is just as potent as three units of that same herb, and you wouldn't get poor nearly as fast if you made a huge recipe, say 1 additive and 104 of the base ingredient = 105/7 = 15 servings, and ate more often. At cooking level 5 you can easily get 80 minutes of duration with a single additive per base, and that's plenty of time for most activities.
    • Using multiples of rare herbs, even if you could afford it, would be a bad idea anyway as the potency of the herb would drop very rapidly, and you'd have ruined that herb for everybody.

Recipes will spoil after a few days. Each Pyramid of Renewal adds 2 days, Salt adds 2 days, and the recipe itself adds two days. That's a maximum of 18 days, but we're not there just yet.

Duration, which is just the Doughnut in actual practice, determines how long a recipe will effect your performance statistics.

Back to top

Performance Stats

Each recipe also provides an overall performance decrease/neutral/increase in each stat. Although there are seven different stats they are independent of each other. The only variables that effect the statistics are:

  • The potency of the additive (important)
  • The potency * 1/9 of the base (trivial)
  • The characteristics of each ingredient, which are one of three multipliers (-1, 0, 1) for each stat.

Each ingredient provides a different combination of stats, so the Art of Cooking lies in selecting a combination of ingredients that will provide you with the desired performance, without killing your duration or your pocketbook.

  • Str = Strength (Safari: Debens of carry weight, mining, cement, grinding, pumping, coconuts)
  • Dex = Dexterity (Acrobatics: Debens of carry bulk, off-road velocity)
  • End = Endurance (Oyster Catcher: Flax processing, digging, pumping, cement)
  • Spd = Speed (Cicada: On-road velocity, fishing, beekeeping)
  • Con = Constitution(none: Smoking, toxin lab, chemistry lab)
  • Foc = Focus (none: Tooth limestone prospecting, carving, dowsing)
  • Per = Perception (Food, Wine, Beer, Fumeology: Tapping, gathering wood, dowsing, mining)
  • There's a complete listing at Stats.

Going back to our doughnut analogy, when you eat the doughnut the bulk and the glazing all get mushed together, and flavor, rather than size, becomes the important factor.

  • Stat = Sqrt(Sum( Potency/17.2 * Bulk/1000 )), where each stat for each Additive:Base pairing is considered separately.
    • Potency is scaled by a factor of 1/17.2 (The scaling factor might be a bit more or a bit less than 17.2, and Teppy may be messing with it to control game balance.)
      • If an ingredient is being used as a base, its potency is further scaled by a factor of 1/9. The square root of 1/9 is only 1/3, so this isn't as bad as it sounds.
    • Bulk is a characteristic of the pair. Bulk has no meaning for a single ingredient.
      • If bulk <= 0, you will get 0 as the Stat contribution, Teppy took away our negative duration feedback, but you may still get a positive duration if your Additives provide enough of a kick.
    • The contribution from each Additive:Base pair (we have to give up on our doughnut analogy at this point) is then separately multiplied by the characteristic (-1, 0, 1) of each Stat for each separate ingredient, and then the contributions are accumulated in a separate register for each Stat. That's the summation part.
      • Oyster Meat is unique in that it has a +2 multiplier for Endurance. Please don't ever use Oyster Meat as a base. It's far too valuable as an END Boost for Aqueduct Pumps, Clinker Vats, Barrel Grinders, etc, etc, etc, for it's potency to be killed by using it as a base. Sadly, the potency of Oyster Meat is already down to 1582, so we may have already lost this battle.
    • The sign of the accumulated contributions is retained, but only the signed square root of the magnitude is carried forward.
      • Rare herbs aren't as wonderful as they might seem. Herbs really take a hit when the signed square root is calculated.
      • Mushrooms and common herbs hold up quite nicely.
    • The square root of the accumulated contributions is then tinkered a bit.
      • Add 1.2 if the value is negative.
      • Add 0.5 if the value is positive and the ingredient is being used as a base.
      • Add 0.2 if the value is positive and the ingredient is being used as an additive.
      • Our testing technique, wherein we analyze a 1/14th portion of the hypothetical potency, and then multiply by 14, gives potencies that are in multiples of 14. That's OK for most purposes, but if you want to be precise, you'll need finer granularity.
    • Now truncate the stat values. Only the truncated value is retained, so a bite of the recipe will only have an integer effect on your stats.
  • If you are using multiple different additives per base (or if you screw up), the worst bulk is used for that base and every associated additive. Otherwise, the contribution of the base is tossed into the same discrete hoppers as everything else.
    • Multiple additives, however, will kill your duration.
  • Your current cooking level limits the number of bases that you can use. If you use more bases than your current level, everything becomes muddled.
  • Bases are defined as the set of ingredients that have the same quantity as the maximum for any single ingredient. Be careful! Verify any critical recipe before you cook it, and don't accidentally use the nerfed Iron Cooking Pot. If you accidentally add just one more item to a base, everything else suddenly becomes an additive.
    • Only 21 different ingredients are allowed in a recipe.
    • As a practical matter 3 additives per base would be a lot of additives, and with Cooking Skill level 5 you can use 5 bases, so 5*(3+1) = 20 which is still less than 21 but you'll never need that many different ingredients anyway.

Stats, which is just the Glazing in actual practice, determines what you'll be able to do while the recipe is in effect.

Back to top

Location

The distances that we derived earlier can be regarded as the radii of circles whose location is determined by the separation, and therefore the relative location, of the Additives and Bases in a R2 space that uses seconds as the metric.

Huh??? OK. The dotted circles are the Doughnut Holes.

Intercepts.png

The analytical technique expresses the circles with equations of the form X2 + Y2 = (2R)2, solves the consequent quadratic equations for the intercepts, and connects the consequent point pairs to create a star burst pattern that visually identifies the single point, the location of the additive, that all of the circles must have in common. The distance between any two ingredients, if one of them is sufficiently potent, can be mapped onto a 2000x2000 unit plane (an R^2 space) where the units are expressed in seconds. We'll skip over the painful exercise of normalizing the R^2 space, and simply thank Quizzical for his efforts. For our purposes, the location of several base ingredients is well known, and we can use those bases as our reference points.

As cheap, well positioned bases, we particularly like:

( 499, -468) Cabbage
(-582,  793) Camel Milk
( 366,  615) Coconut Meat
(-367, -580) Oil
(- 80, -102) Garlic, which is sometimes needed if potencies are low.  
  • Start by determining the distance between the unknown location of the additive and the known location of the reference base.
  • Inscribe a circle of radius distance about the known location of the reference base. You know that the additive must lie somewhere on that circle.
  • Continue by determining the distance between the unknown location of the additive and the known location of a different base.
  • Inscribe a circle about that base.
  • We'll duck some lovely geometrical proofs, and simply state that the inscribed circles will have exactly two points in common.
  • Draw a line between those two points.
  • Do it some more and you'll get the following Starburst pattern.

Zanthoxylum.png

Take particular note that Zanthoxylum is collinear with Coconut Meat and Oil, and that the associated chord is therefore a very short line. We'll discuss collinearity, and tangent circles, in more detail when we get to calibration.

Back to top

Spreadsheet

Old information from T3 the old spreadsheet no long available

The remainder of this page discusses a Microsoft Excel tool that will allow you to more easily get the results that you want, using the herbs and mushrooms that you already have on-hand. The file is a bit too large to include as a wiki attachment, so you'll need to download it from Insertfile. The remaining portions of this wiki page includes enough explanatory information for you to follow the action, but it's mostly a discussion regarding the use of the spreadsheet, and how it's structured.

There are five tabs in the spreadsheet:

  • Instructions
  • Inventory
  • Tests
  • Calibration
  • Contributions

Instructions

Inventory.png

The inventory is a pretty simple concept, but it will save you an enormous amount of time.

  • If you don't have something, you can't use it in a recipe.
  • Use the next best thing.

Don't even try to maintain a manual inventory. Folks are constantly adding herbs and using ingredients. You'll go nuts and the inventory won't be accurate anyway. To start a new cycle:

  • Select Data > Subtotals, and Remove All.
  • Highlight the current data rows (between the Header and 9999 Zzformulas row) and Edit > Delete.

The in-game Utility menu for Chests and Tents allows you to copy the container contents to your clipboard. Go in-game, and take a look at the inventory in all of your cooking containers.

  • Use the Utility menu on each in-game chest and tent, and Copy the Contents to the Clipboard
  • Paste the chest data into the inventory tab, beginning on row 3.
  • Use the Chest column if you wish to include various private owner chests.
    • As you won't be able to copy the contents of a private chest, ask the owner to open a private chat, and say Hi or something to create a new line character.
    • Have them copy the contents of their chest and paste it into the chat window.
      • We're talking to Pharaoh about it, but the current chat buffer only supports 2500 characters which isn't enough for most herb chests.
      • Have them verify that the last item in their pasted inventory actually appears in the chat box. If not, have them paste their inventory into Notepad, or some such, copy just the truncated portion, and paste the missing portion into their chat tab.
    • /copy and paste the private chat into Notepad or some other editor
    • Copy the newline character (the little box)
    • Ctl+H and replace "____" (four blanks) with newline (you just copied it)
    • Now you can copy/paste the chest contents into the Inventory.
    • Don't forget to drag the person's name into the Chest column.
  • Drag the formulas in the 2nd row ( 0 Zzformulas, all but the chest data that you just added) to the bottom of the data.
  • The spreadsheet will parse the Chest Data, and will isolate the Ingredient Name and the Quantity.
  • Sort by Verify, Chest, Ingredient, and either correct or delete any item that isn't a cooking ingredient except the Zzzformula row.

Now create the lookup table.

  • Resort the data if you've done anything fancy.
    • It would be possible to lookup the Type of the ingredient as well as verifying it's existence, but it's not worth the bother. This inventory page is in simple alphabetical order. The inventory that you're really after is the lookup value in the Contributions tab, and that stays with the other ingredient data as you sort and filter.
  • Highlight columns F1:Gxxx (the end of the data)
  • Use the Excel Subtotal capability to group all instances of each ingredient name, summing the quantity.
  • Once you have your subtotals, note the row number at the end of the Inventory table.
  • Go to the Contributions tab and select cell AC2 (the first entry in the Chests column). If the Inventory!$F$2:$G$nnn value in the lookup range (the actual end of the Inventory lookup table) doesn't match your observed Gnnn row number, correct it and drag the healed value down the length of the Chests column.

A magic lookup table is now available.

  • Because you paid attention to the Verify column, you already know that the Ingredient names in the main spreadsheet are spelled exactly as they are defined in the chest inventory.
  • The spreadsheet uses a concatenated string, =Ingredient & " Total", as a Vlookup index that will find only the subtotals. Presto! You now have a comprehensive inventory that:
    • Is automatic
    • Is easy to maintain
    • Stays with the ingredients as you sort and filter them on the Contributions tab
    • Can itself be used as a filter criteria

We use the inventory to track several private Herb Chests, plus our main pantry. Consequently we have several different user names in the Chest column.

  • To exclude one or two users from the currently available inventory, use a custom filter of "Does not begin with <name>.
  • To include only a few users, use a custom filter of "Equals <null>" to pick up the subtotal line, OR "Begins with <name>."
  • There's no need to reestablish the subtotals, as they are filter sensitive.

Back to top

Tests

TestData.png

We've included Serpentfish because a bad location has been floating around. Wheat, with various roasts, is a new ingredient. We're accumulating test results on the Tests page, and you're more than welcome to contribute additional data.

Simply being organized is a major advantage when you are testing a lot of recipes.

The best approach is to set up your test plan ahead of time, you don't necessarily need to test everything if you're getting good results. Assign an identity to each test. The identity doesn't really matter, it just allows you to sort the data in various orders and autofilter to selectively look at test results. Easy Wiki Tables explains how to transfer bulk information from a spreadsheet to the wiki. Save your native mode *.xls file before you SaveAs with the *.cvs extension, which only saves the current tab. Carefully correct headers that include a nextline character. You may want to insert a break instead.
is the html code for a break. Replace the comma in Wheat (Dried, Raw). When you type an ingredient into the Additive or Base fields, the spreadsheet will fetch the ingredient type from the Contributions Tab. This is mostly to verify your spelling, but it also allows you to sort the test data in Chest sequence.

The Tests Tab has the following columns:

Column Description
Additive
(always 1)
Only one Additive is used in this series of 1:6 tests
Ta The type of the additive allows you to sort your test data to match the chest sequence. The main purpose of the lookup, however, is verification that the tested ingredient is spelled correctly, and is included in the database.
Potency This is a calculated value. Potency = (Duration-Bulk) * (Na+Nb)/Na Proportion
Bulk This is also a calculated value, using the same formula. You should try to pair an additive with the most effective available base, if you can, as the recipe will then:
  • Provide better Stats granularity
  • Verify that the Bulk values are still the same, and that you can therefore trust the test data.
Base 1:6 then
1:13 if needed
Each line of test data implies two related tests:
  • 1:6 Additive:Base
  • 1:13 Additive:Base
Tb Verification that the Base exists.
1:6 The calculated Duration, in total seconds, reported by the first test.
1:13 The calculated Duration, in total seconds, reported by the second test.
7m User entered minutes from the Critical Evaluation of the first test.

Add 60 if the duration is more than an hour.

7s User entered seconds from the Critical Evaluation of the first test
14m User entered minutes from the Critical Evaluation of the first test
14s User entered seconds from the Critical Evaluation of the first test
Tester Who did the testing
GameDate When was the testing done
  • If you set the rows to a height of 25 pts, you'll have plenty of room for writing in your own test results.
  • You may also wish to write down the observed Stats. We don't need them right now, but they'll be needed in the next step.

Back to top

Calibration

The Starburst chart that we looked at earlier is controlled by the following elements.

Distances.png

The Calibration tab is much easier to use, than to explain. There's a lot of heavy duty math going on behind the scenes, but the Starburst chart that we looked at earlier is the visible result of all of the analysis.

Durations Starting in the top row, you may enter the name of any Ingredient (usually an Additive) in cell A2, and up to four other Ingredients (usually Bases) in B2:E2. The spreadsheet will automatically look up the (X,Y) location of each base.

  • The sections where manual data entry is appropriate are all colored green.

Moving to the right, to cells G3:H10, copy/paste the 1:6 test results that you developed on the Test tab and manually add the specific 1:13 test results. If you don't want to keep a record of your test results in the Tests tab, you can work directly on the Calibration tab and then simply print out the results.

  • The 1:6 test that yielded the highest duration will be detected, and the associated 1:13 fields will be highlighted for your convenience.

Moving down the page a bit to G11:H12, please take the time to enter the Tester and the Game Date. We use the convention of entering the game date as "3 ", rather than "Year 3, ", because the stray comma causes all sorts of grief later on when we're trying to parse data using a *.csv (comma separated values) format when preparing material for the wiki.

Statistics On the testing tab we ignored the actual stats, in part because there was no reliable way to back out the base contribution, nor any graceful way to present comparative contributions. In this tab we assume that you have provided test results for a selected additive, and have paired it with several different bases. Please enter your observed Stats results, all 4*7=28 values, as -1, 0, 1. The program then tries to isolate the Statistical Contribution of the Additive, by backing out the Statistical Contribution of each base. We can reliably get within one unit of the correct value but, as we have no way of outguessing the roundup error, there is still a bit of noise. By comparing the behavior of the Additive against several different Bases, it's normally fairly easy to discern the Characteristics of the additive.

Distances The hypothetical potency of the additive is calculated, as was previously discussed, is placed in Cell B28, and is used to calculate the distance between the Additive and each of the associated bases. If you'll think back to the earlier discussion, the potency of a base has nothing whatever to do with either duration or distance, so don't be mislead by their position in B29:B32. The unused potencies are comforting, and nice to know, but the potency of a base is not used any of the duration calculations, but they do help when trying to understand where the Stats are coming from. You may recall that high potency herbs allowed us to see out beyond the 1000 second bulk horizon. Zanthozylum is definitely a Rare Herb, its potency is 28,240 which is the maximum value for Herbs, and the additive boost is substantial enough for us to see all the way out to 1255 seconds.

Starburst Patterns Dropping straight down to Cells C34:F39, we've presented the two intercept points for each of pair of circles. As each of the 4 base circles pairs with each of the other 3 circles, with 2 symmetrical intercepts per pair, there are 4*3/2*2=12 different possible locations for the Additive. If you look at the Starburst pattern however, which is directly created using these intercept point pairs, you will be able to identify the single common point where all of the circles must intersect.

  • Move over to Cells G34:G39, and manually indicate your visual assessment of the Starburst pattern.
    • Enter 0 to exclude a line if the Additive was too far away to return a duration value, or if the location of the additive is too close to the centerline to provide reliable readings.
    • Enter 1 to select the first pair.
    • Enter 2 to select the second pair.

If the target ingredient is collinear (lines up with) a pair of reference bases, then the associated circles will be tangential rather than crossing at a nice angle. Errors in the location of either base would therefore be amplified, so we want to avoid the collinear regions. A good fit is identified by calculating the distance between the location of each pair of Bases, and the distance between the related intercepts. The smaller value is divided by the larger value to obtain a ratio expressed as a percentage.

  • The percentage of fitness goes to 0% if the Additive is collinear with a pair of Base locations, and therefore lies in a region that is sensitive to positional errors.
  • The percentage of fitness peaks at 100% when the Centerline and the Chord are exactly the same length, which indicates that the additive is comfortably off to the side of the centerline.

Back to top

Contributions

Contributions.png

The important thing to notice is that we predictively nailed the recipe stats and duration.

  • The negative Con is off by only 1 unit.
  • The duration is off by only 5 seconds.

If your predicted and observed Stats are off by more than 1 unit, figure out the most likely culprit and go test the current potency of that ingredient.

We're not even going to try to explain the various factors, sorts, and autofilters that are available when you're hunting for the perfect recipe. Training is needed to effective use this portion of the spreadsheet, and training is available as indicated at the bottom of this page.

We'll itemize all of the columns on this tab, although some of the columns are normally hidden.

Column Description
Ingredient The ingredients in red are treated as bases. They contribute 1/9th of their potency, and they are ignored when calculating the proportional additive portion of the Bulk calculations.
  • Sorting by Type, Ingredient is a reference sort.
  • Sorting by either Contribution or one of the Masterpiece Duration columns provides a more useful sort when you are designing a recipe.
  • Be aware that ATITD sorts a space character last while Excel (and the rest of the world) sorts a space character first, so the sequence is inverted for ingredients such as Bluebottle Clover and Blue Damian.
st - pe Potency/17.2 * Bulk/1000 * Characteristic of the additive (or 1/9th of that value if the ingredient is a base.)
Potency Manually entered; copied from the Tests tab was where Potency was determined.
Contribution This is a generic value that is then multiplied by the Characteristics to obtain the Contributions for each Stat.
MP3:4 - 5*1:69 These fields are used for tuning Masterpiece Recipes, and also for calculating the duration of various ingredient mixes. While the bulk of the additive/base pair is known, it's right there as part of the additive line, it's only used once, in a given recipe.
  • If you're using multiple different additives per base, use the worst bulk associated with that base. You must also divide the duration contributed by that base by the number of different associated additives.
  • It's possible for an ingredient that's normally a base to be used as an additive, so bulk is shown for pairings with the nearest other bases. If you're playing these sorts of games, you'll need to mentally multiply the contribution of the "basic additive" by 9 (10 is easier) to correct for the normal 1/9th base contribution factor.
str - per The familiar (- 0 +) characteristics of each ingredients.
X,Y As was determined on the Calibration tab; use copy/Paste Special, Values only so that you don't lose any precision.
Tp The type of ingredient, so that we can almost match the Chest presentation sequence.
Tester The tester's name.
GameDate The date the tests were conducted. Use the convention of "3 " to represent "Year 3, ".
Chest A hidden column that allows us to deal with missing inventory items.
Inventory Simply knowing what else you might be able to use is a huge help when designing a recipe.
Price Your opinion. Our formula considers the usefulness of an ingredient in a single serving recipe, and for tuition. We ignore it's desireability for stats contributions.
f The flag field allow us to select arbitrary ingredients for inclusion in the recipe. Use nonblank as your selection criteria, to pick up the subtotals.
1st This is the bulk of the most effective pairing
Base1 The name of the most effective Base.
2nd - 4th Less Bulk
Base2 - Base4 Less effective Bases.
Row Allows us to us an arbitrary row as the index for a table that contains the Name and X,Y coordinates of each Base.
R The crosstab array in AM2:Bx333 is where all the work is done. Every Additive:Base Pair Distance is calculated, and then Base = 1000 - Distance is calculated.

The most effective approach is to sort the spreadsheet by either Contribution or Bulk, and then use AutoFiltering to select the ingredients that will match your objectives.

Back to top

Masterpiece Recipes

There is never any guarantee that a particular recipe will be a masterpiece.

- HOWEVER -

When cooking long duration recipes with unusual combinations of ingredients, and especially so if an inexperienced chef actually cooks the recipe, we have achieved a Masterpiece rate as high as 1 in 7 (during a cookout, when weird combinations were fine), and have consistently achieved a Masterpiece rate of 1 in 14 for targeted recipes.

  • Our working theory is that duration is first analyzed to establish that it is greater than 1h10m (4200 seconds).
    • It as been established that a 1:13 recipe (less than 4200s) followed by a 1:6 recipe (more than 4200s) using identical ingredients, can yield a masterpiece.
  • The Database Identity of the Cook (Name is just a field) and each Unique Ingredient is XORed, and the consequent value is hashed into your personal 7*7*7*7 = 2401 (reduced to 2048) bit cooking space.
  • If you hash into an unoccupied slot in the first 7*7*7 = 343 bits of your cooking space, your recipe will be a Masterpiece.
    • You have about one chance in seven of getting a masterpiece if the duration of your recipe exceeds 1h10m = 4200 seconds, and you have never before cooked a recipe with either ingredient.
    • Only 50 or so ingredients are actually used as bases, but the reduction is odds is barely noticeable.
  • You also have an independent 2401 bit (reduced to 2048) eating space. In other words, you can cook a masterpiece recipe and then get a hash collision when you eat it.
    • You will get a Gastronomy (Perception) point at 7, 49, and 243 Masterpieces. You can score additional gastronomy points, but they don't tranlate into any additional perception points.

Assuming a pair bulk of at least 700 seconds leaves the remaining 3500 seconds to be provided by the Additive proportional potency.

  • For 1:6, 3500*7/1 = 24500 (28420 is the maximum potency of a herb)
  • For 2:5, 3500*7/2 = 12250 (many herbs and a few mushrooms will qualify)
  • For 3:4, 3500*7/3 = 8167 (most herbs and many mushrooms will qualify)
  • An ingredient with less than 8167 will never provide a single serving Masterpiece Recipe
  • The spreadsheet highlights the MP3:4, MP2:5, and MP1:6 that are potential single serving recipes that can be prepared with a Cooking 1 skill level.
  • If you are cooking small serving recipes, potent herbs are the dominate duration factor.
  • If you are cooking large serving recipes, effective pairing dominates duration factors.
  • As the total number of ingredients climbs, you will need multiple bases to attain durations sufficient for Masterpieces.
  • The secret of cooking Masterpieces is to always use novel, high duration combinations, and cooks with limited experience. That approach is entirely consistent with the Sunset philosophy of hitting just the targets that you need, while using just the Herbs and other ingredients that you have on-hand.


Back to top