Katwick
Cartographer
I've got the Google Sheets Solver working, and I'm getting some interesting results. My standard recipe format will be changing to the following, for each Diploma Level aka Effect. The model works the same whether you use Witch Points or Diamonds, and I'll eventually add an occasional Non-Diamond recipe when the weekly selection straddles the Standard Recipe. If the Brewery Numbers are matching the Katwick Modeling numbers, then I'll post the Link for the current Early Beta version of my Google Sheet.
My preferred approach, once I'm satisfied that my model is handling Witch Points, will be to run the numbers as if you could buy all of the Herbs, each week, with Witch Points, and the do a second pass where we say,
We can live with these for a while, until we've had an opportunity to make a more exhaustive analysis.
I just noticed that we're modeling an extra 6.22% of 01_C_, so there's probably another break in the pattern, which is precisely what this series of Tests/Recipes/Posts is all about.
The green bordered block is what we'll be using in forum posts, for the most part, as it has everything that you need to Brew a recipe, in a properly sorted order.
My preferred approach, once I'm satisfied that my model is handling Witch Points, will be to run the numbers as if you could buy all of the Herbs, each week, with Witch Points, and the do a second pass where we say,
- "WOW, 150 Diamond are worth a Gazillion Witch Points this week!" or
- The Diamonds are mostly on junk Herbs for the stuff that I want, so I'll just ignore them this week.
- N Diplomas Weekly, which is a 14 Herb recipe that covers 4 POSITIVE Values with a 5432 pattern.
- N Diplomas Weekly Optimized, wherein we see what the Solver comes up with for 14 Herbs
- N Diplomas Factored, which is a 21 Herb recipe that covers the same 4 Positive Values but adds two POSITIVE Factors, with a 654321 pattern.
- N Diplomas Factored and Optimized, wherein we see what the Solver comes up with for 21 Herbs.
- 9 Orcs vs. 31 Eye Sprouts has a -1 Factors where there should be a -1 Value
- 6 T3 vs. 34 Ear Truffle has a -2 Value that should be a -1 Value
We can live with these for a while, until we've had an opportunity to make a more exhaustive analysis.
I just noticed that we're modeling an extra 6.22% of 01_C_, so there's probably another break in the pattern, which is precisely what this series of Tests/Recipes/Posts is all about.
The green bordered block is what we'll be using in forum posts, for the most part, as it has everything that you need to Brew a recipe, in a properly sorted order.
Last edited: