Katwick
Cartographer
4 Diploma T1 Recipe Design for Trader's Basic Goods
So you just completed your Cauldron Tech?? Yep, it's as complicated as it looks, but it's a very elegant design. You're encouraged to grab some popcorn and download a copy of the Google Sheet that we've developed, because insight is a wonderful thing.
Cauldrons 101 - N Diploma Recipe Design - Sheets - Katwick 2023B20 << Febuary 20th, but I like to keep my files orderly.
This downloadable Google Sheet works fine for the four adjacent Ingredients which contribute the Primary Values for each Effect, but there's more to it.
Each Brewery Ingredient is a 12 column vector. The Ingredients are STAGGERED and they wrap around ( column "13" wraps to column 1) .
I've posted two similar recipes for each Cauldron Diploma level through level 12, for CLUSTERED INGREDIENTS ONLY
AS IF Recipes are listed later in this thread. They don't really exist, but you can fake them by overloading the 4 Diploma T1 Recipe Template.
4 Diploma T1 Recipe with Diamonds
SCALING
Each of the numbers that you'll actually see is scaled by exactly the same factor. If you mouseover cell N18, you'll see one of several tool tips.
Change Log
So you just completed your Cauldron Tech?? Yep, it's as complicated as it looks, but it's a very elegant design. You're encouraged to grab some popcorn and download a copy of the Google Sheet that we've developed, because insight is a wonderful thing.
Cauldrons 101 - N Diploma Recipe Design - Sheets - Katwick 2023B20 << Febuary 20th, but I like to keep my files orderly.
This downloadable Google Sheet works fine for the four adjacent Ingredients which contribute the Primary Values for each Effect, but there's more to it.
Each Brewery Ingredient is a 12 column vector. The Ingredients are STAGGERED and they wrap around ( column "13" wraps to column 1) .
- 2 Negative Factors
- 3 Positive Factors
- 3 Negative Values
- 4 Positive Values
-2f | -2f | 1f | 1f | 2f | -2v | -1v | -1v | 1v | 1v | 2v | 3v | 34_Ear_Truffle_is_the_only_Brewery_Ingredient_that_doesn't_wraparound |
- Positive Values are Contributions associated with each Ingredient. That's all we're considering at the moment, and they're all you need to worry about if you're just focusing the 4 Ingredients associated with a particular Effect. That's all our Google Sheet does at the moment, and there's a separate tab for each Diploma level, because the contributions for each level have been calculated by hand.
- Negative Values are also Contributions, but they're further away from a particular Effect. We're working on a Google Sheet that includes the negative contributions, but what we're really after is a spreadsheet that has every Diploma Level on a single sheet, so that you can tell what adding a Diploma will do to your favorite recipe, with automatic contribution updates as youi add Ingredients, so that you can FOLLOW what's actually happening as you add Ingredients, and thereby develop some intuition for Recipe Design.
- Positive and Negative Factors are the Ingredients don't influence YOU, or more to the point, don't influence YOUR primary Effect. Factors raise or lower the contribution of the Ingredients on the opposite side of the Ingredient circle, where your "blanks" are located.
- I'm never going to worry about developing an Intuition for Factors. It's not going to happen.
- I do, however, highly recommend the Excel Spreadsheet that Karvest has presented in the Beta Forum. It includes factoring, and focuses on recipe optimization
- Start with a mix of Ingredients that you THINK is pretty good
- Indicate any Ingredients that you want to avoid, because they cost Diamonds this week
- Indicate how many Witch Points you can expend
- Indicate your Diploma level
- Indicate which Effects you're trying to optimize
- Push the button
- Wait while Excel does it's thing, and don't worry about exactly what's happening in the Black Box.
- Drink up!
I've posted two similar recipes for each Cauldron Diploma level through level 12, for CLUSTERED INGREDIENTS ONLY
- A good recipe that uses 5+4+3+2=14 Ingredients
- An excellent recipe that uses 8+6+4+3=21 Ingredients
- Each week four (random) Ingredients will cost 25 Diamonds each, if you're willing to spend a few Diamonds
- 5+4+3+2 assumes 14 Witch Point Ingredients
- 8+6+4+3 assumes 8*25=200 Diamond Ingredients plus 6+4+3=13 Witch Point Ingredients
- In a later post we'll be discussing costs, but for now let's assume that you lucked out, and the BEST of your ingredients is "On Sale." At Diploma Level 10, because that's what I can test myself:
- 2379 Witch Points is the cost of 5+4+3+2 = 14 Ingredients
- 2540 Witch Points is the cost of the remaining (after the 8 Diamonds) 6+4+3 = 13 Ingredients, because even though I'm using fewer TOTAL Witch Point Ingredients, I'm using MORE of all three than I used before, because I'm trying to push up the % Success Rate for the Effect that I'm after.
- 7616 Witch Points would be the cost if I wanted to avoid Diamonds altogether, and could still use the second recipe.
- Each week four (random) Ingredients will cost 25 Diamonds each, if you're willing to spend a few Diamonds
To Zoom, use Ctrl + or Ctrl - on a PC, or a two-finger stretch on a touchscreen.
AS IF Recipes are listed later in this thread. They don't really exist, but you can fake them by overloading the 4 Diploma T1 Recipe Template.
- 1 Diploma C_ Recipe for Coins
- 2 Diploma WS Recipe for Workstation Supplies
- 3 Diploma SB Recipe for Barracks Strength
4 Diploma T1 Recipe with Diamonds
- The Dark Red columns are the Effects that you can't brew. Your current level, in cell Q1, is just for Conditional Formatting which is used to turn future levels RED. There's a separate tab for each Diploma Level, because the guts of the spreadsheet, in the A5:L16 range, was hand calculated.
- The Gold Horizontal stripes indicate which Ingredients will cost you some Diamonds. While the M5:M16 range is formatted for Short Dates, any non-blank value will yield a gold stripe.
- 1/7+1/7+2/7+3/7 = 7/7 = 1, and EVERY Ingredient fills four adjacent cells
- If a column is zeroed out, it's because you don't have the Diploma for that Effect
- So the "missing" potency is simply distributed over the remaining cells. <<<< THIS IS IMPORTANT!!
_______ | 0 | 0 | 0 | 0 | *_7/7 | (Just_exactly_the_reverse_of_how_THIS_cell_forces_the_other_columns_to_be_narrower.)_______________________________ |
0 | 0 | 0 | 3 | *_7/3 | ||
0 | 0 | 2 | 0 | *_7/2 | ||
0 | 0 | 2 | 3 | *_7/5 | ||
0 | 1 | 0 | 0 | *_7/1 | ||
0 | 1 | 0 | 3 | *_7/4 | ||
0 | 1 | 2 | 0 | *_7/3 | ||
0 | 1 | 2 | 3 | *_7/6 | ||
1 | 0 | 0 | 0 | *_7/1 | ||
1 | 0 | 0 | 3 | *_7/4 | ||
1 | 0 | 2 | 0 | *_7/3 | ||
1 | 0 | 2 | 3 | *_7/4 | ||
1 | 1 | 0 | 0 | *_7/2 | ||
1 | 1 | 0 | 3 | *_7/5 | ||
1 | 1 | 2 | 0 | *_7/4 | ||
1 | 1 | 2 | 3 | *_7/7 | |
SCALING
Each of the numbers that you'll actually see is scaled by exactly the same factor. If you mouseover cell N18, you'll see one of several tool tips.
- This is a static scaling factor that's used simply to match the %_Success display in the Brewery.
- The formula for the Scaling_Factor is = (N/25) * (4/7) * (1/100) where N is the Number of Ingredients.
- =(N/25) because 25 Ingredients yields 100% Success
- *(4 because there are 4 elements per Effect but
- /7) 7 points per Ingredient are distributed.
- *(1/100) so we can match the %_Success display.
- The Brewery_% Success rate, In-World, is sequenced from the HIGHEST % Success Rate to the LOWEST. For our purposes, it's better left next to the related Ingredient.
- % Success Rate can be verified in the In-World Brewery window.
Change Log
- 2023B22 - Created and Shared a Google Sheet, rather than an Excel Spreadsheet
- 2023B23 - Clarified how to Zoom, and added a bunch of Diploma Recipes
- 2023B23 - A couple of standardized recipes are now posted for 1-12 Diploma Recipes
- 2023B23 - Production Release
- 2023B27 - Warned everybody that the current spreadsheet is ONLY for clustered ingredients
Last edited: