Guides > Cooking > Kitchen Enterprises

Kitchen Enterprises

This page discusses the theoretical underpinnings of ATITD Tale 3 Cooking, and how to use our spreadsheet to optimize your cooking efforts.

• See Tests for recent test data.
• See Contributions for the currently known information about all Herbs and other cooking ingredients.
• See http://www.marvl.com/Downloads.html for the actual Microsoft Excel spreadsheet.
  • The current version is 2007H05. It includes the data on Baobab, Kuka, Allbright, and Ukpo.

The Sunset Guild is offering Tutoring sessions for Cooking in general, and particularly to explain effective use of the Kitchen_Enterprises spreadsheet. For a fee, 10,000 potency potency points worth of herbs and other ingredients to support our on-going research efforts, we will:

• Visit your camp
• Help you create a cooking inventory
• Set up a respectable single additive per base, five base recipe using ingredients that you have on hand.
• Explain how and why the recipe works, and how to use the spreadsheet to create similar recipes.
• Show you how to walk through your herb stash, cooking a Masterpiece about one/seventh of the time.
• Briefly discuss how to verify the potency and R^2 location of cooking ingredients.
• Generally ensure that key members of your guild are able to effectively use all of those herbs that you have rotting in that chest.

Foraging and Cooking Skills

Cooking lessons, with a reasonable likelihood of Masterpiece Gastronomy points (for Critical Evaluation), are recommended as one of your earlier efforts.

• Buy your Foraging skill at the SWorship (level 2, 300 Thorns, 30 Cactus Sap).
• Make the UWorship tour to each region, and collect your allotment of 4*12=48 Veggie Seeds.
  • If you don't get some Veggie Seeds of each type, we'll swap you like for like.
  • Gather herbs while you're on your UWorship tour.
  • Decide which of the Flower Bulbs and Sea Lillies you want, and get them too.
• Buy your Cooking 1 skill at the SWorship (level 2, 100 each of Cabbage, Carrots, Onions, Leeks, and Garlic).
  • Build a kitchen, and fiddle with it for a while to establish that you don't know what you're doing :-)
  • Read through the information on this page, and decide that that doesn't help very much either.
• Seshat will design a recipe to your needs, and explain how and why it works, and how to make similar recipes.
  • We'll show you how to walk through your herb stash, and get a Masterpiece about 1/7th of the time.
  • You can (probably) only cook 7*7*7=343 Masterpieces in your entire life, and each one has to be different.
    • Leeks that you grow immediately after eating a Masterpiece, whether or not you score a Gastronomy point, will produce an extra seed.
  • With seven Gastronomy points, critical evaluation becomes available, which helps a ton.
• There's no way that you can tiptoe into cooking. You have to jump in and start swimming.
  • Cooking is pretty deep, but you can be a competent amateur with about 6 hours of training and experimentation.
  • You don't have to understand everything about cooking. There are only four people in Egypt who are that interested.

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.

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.

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.

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.

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 R² space that uses seconds as the metric.

Huh??? OK. The dotted circles are the Doughnut Holes. 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.

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.

Acknowledgments

As well you can imagine, a great many people contributed to our understanding of cooking. http://www.atitd.net/forum/showthread.php?t=11121 is an excellent starting place for further investigation, and other ways of explaining cooking.

May I Please Have A Spreadsheet?

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 http://www.marvl.com/downloads/Kitchen_Enterprises_2007H05.xls .

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

The instructions tab points back to the wiki, provides some contact information, and indicates the current spreadsheet revision with a revision log.

Inventory

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.

Tests

• 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. <br> 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.

Calibration

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

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.

Contributions

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.

Tutoring

Sunset Enterprises will show you how to be a competent cook, in accordance with the following fee schedule.

1. 100,000 Potency points for a Camp Visit, Inventory, one custom recipe, and training. Reserve about 3 hours.
2. 100,000 Potency points for designing each additional custom recipes, or for significantly improving a recipe that is offered for review. The fee is actually for the additional training. Reserve an additional 3 hours.
3. 100,000 Potency points for providing the ingredients that are needed for a Sunset designed recipe up to 25 servings.

The indicated prices are based on the potencies of Herbs and Other Ingredients, as shown in the spreadsheet that was posted at Contributions when the visit was scheduled or in your spreadsheet at the end of the visit, whichever source provides the lower price.

• 6 Rare Herbs (average potency of 18,000) would be worth 108,000 Potency points
• 36 Mushrooms or Common Herbs (average potency of 3,000) would be worth 108,000 Potency points.
• 216 Base Ingredients (average potency of 500) would be worth 108,000 Potency points.

While Herbs and other ingredients are the preferred method of payment, we'll also accept a 1/4 share of whatever you're accomplishing, using the recipe, in lieu of a 100,000 potency points payment. In other words, Sunset will provide training and everything for a dig (including high quality shovels) at your camp for a 1/2 share of the stones if we provide everything, or for a 1/4 share if you provide the Herbs and other ingredients.

The following ingredients are in short supply because they are required for the indicated Tuitions. They therefore count as double their indicated potency.

• Peasant Foot Mushrooms (7 for Cooking 4th Degree, 20 for Botanical ID 2nd Degree) (counts triple)
• Salt Water Fungus (20 for Botanical ID 2nd Degree) (counts triple)
• Chukkah (7 for Cooking 5th Degree) (counts triple)
• Crimson Lettuce (7 for Cooking 5th Degree)
• Crumpled Leaf Basil (7 for Cooking 5th Degree)
• Dwarf Wild Lettuce (7 for Cooking 5th Degree)
• Jaivanti (7 for Cooking 5th Degree)
• Orange Sweetgrass (1-7 for Eastern Meditation various Degrees)
• Royal Rosemary (7 for Cooking 5th Degree) (counts triple)
• Wild Garlic (7 for Cooking 5th Degree)

Our service always includes full documentation of the recipes, and an explanation regarding the whys and wherefores of the choices that are being made. In fact we'll insist on explaining it to you.

Our fundamental objective is to enhance the general level of cooking skill, throughout Egypt.

Current Shortages

If you can spare even one deben of the following ingredients, do please let us know, as we are trying to scrap together enough units so that we can test/verify the current potencies and locations. These ingredients count as triple their potency value.

All but the following mushrooms and herbs have been tested during 3 Shemu. A few of the items are in sort supply due to tuitions, but most of them are either rare or perhaps don't even exist any more.

• Peasant Foot Mushrooms (tuition)
• Salt Water Fungus Mushrooms (tuition)

• Artemisia
• Bleubilae
• Blood Blossom
• Calabash
• Cassia
• Creeping Black Nightshade
• Deadwood Tree
• Homesteader's Palm
• Ice Blossom
• Korerima
• Lamae
• Lilia
• Malice Weed
• Paradise Lily
• Sacred Palm
• Scaley Hardwood
• Sickly Root
• Vanilla Tea Tree

Data on some of these ingredients is available from secondary sources, and we've included the best available data in the spreadsheet, but we'd prefer to test the ingredients ourselves.

Camp Calls - We do the traveling

During a Camp Call we will:

• Inventory your Cooking Chests if you so desire, and create an automatic multiple chest/user inventory.
  • The automated inventory is a general approach that may also be useful Towers, Vigils, and a variety of other large projects.
• Design a respectable single additive per base, 5 base recipe of up to 25 servings, and cook it if you don't have Cooking Level 5.
• Post a current version of the Kitchen_Enterprises.xls spreadsheet, updated with your inventory and your recipe, for immediate download. We'll use this updated spreadsheet during the subsequent training.
• We'll then explain how the recipe works, and discuss how to go about creating similar recipes.
• We'll show you how to use your herb stash to cook Masterpiece recipes for Gastronomy points, and will ensure that you get to cook at least one single-serving Masterpiece.

Donations, especially donations of untested herbs (because we don't have those herbs), are always welcome.

Designing additional recipes to target requirements, or significantly improving a recipe offered for review

A significant improvement accomplishes one or more of the following, without increasing the cost of the recipe (in Potency Points), and without falling below either the target Duration or the target Stats, using only the Herbs and other ingredients that are on-hand:

• Increases the duration by 10 or more minutes, or achieves the target level
• Increases a desired stat by 10 or more points, or achieves the target level
• Lowers the cost of the recipe by 100 or more potency points.

While we will design custom recipes, for a fee, our preferred approach is to review a worthy attempt and either agree (which is free) or substantially improve the recipe (which isn't free), with an explanation of the whys and wherefores.

Visits to Sunset - You do the traveling

The Sunset Kitchens are located in northern Seven Lakes, near the UThought, in our "bright chartreuse" cooking compound at 1454,2290.

• If you're lucky, and there are still some servings of an appropriate food in our kitchens, already paid for by somebody else, then there is no charge for eating the food. We'll even loan you Monkey Island Shovels and other Sunset Enterprises equipment.
• If you're not so lucky, when you visit the Sunset Area for a dig or whatever, and we end up providing the recipe design, the Herbs and other ingredients needed for a new batch of food, and good shovels, then the fee is a 1/2 share of whatever you needed the food for, or the equivalent potency in Herbs and other ingredients.
  • Sunset Enterprises reserves the right to increase the number of servings, at our own expense, for any recipe that is cooked in our kitchens.

Beginner's Special

You are eligible for a one-time per avatar Beginner's Special if you:

• Are Level 2 or above
• Have at least the first degree of the Cooking Skill
• Have built a kitchen
• Have not yet reached Level 11

All fees other than Herb and Ingredient replacement costs will be waived if you (or a beginning member of your guild) arranges the training.

We will not build a kitchen for you. In fact, we'd prefer that you experiment with your kitchen for a few hours before our visit, so that you will have the full benefit of the training.

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.

• Sunset reserves the right to eat one bite of any multiple serving Masterpiece Recipe that is created under its supervision. Otherwise, whoever requested the visit has complete control over how a recipe is shared with others.