Katwick
Cartographer
Cauldrons 101 - N Diploma Recipe Design - Sheets - Katwick 2023B20 << Febuary 20th, but I like to keep my archives 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 that 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!
The Negative Contribution Value Beast
I'm now working on a more complex Google Sheet that accounts for Negative Value contributions (but without any factoring), I'm also trying to collapse the hand-calculated contribution values, and therefore a separate tab for each Diploma level, into just a single sheet that automatically shows what happens to the piecemeal contributions as you add ingredients or get additional Diplomas.
Last edited: