User:Peacefulness/Beer

I've found that the Beer Calculator does not include Barley flavor when calculating Muddled. The fix is simple, and hopefully accurate.
In cell V39, enter the formula: =H24
And if you want to be fancy, you can also type Barley into cell V38 and adjust the border so it fits.

I believe I have correctly written a small Beer Calculator Modification which will show when a recipe should create a Fruity or Spicy beer.
Label cell A30 as Fruit.
In cell B30, enter in this formula: =IF(SUM(D39:H39)>500;"Fruity";IF(SUM(D39:H39)<=500;""))
Label cell A31 as Spice
In cell B31, enter in this formula: =IF(I39+J39>300;"Spicy";IF(I39+J39<=300;""))

BAD RECIPES

Sigh. There's a flaw in the spreadsheet I originally used to write the recipes listed below. When I tested the first "VP fruity honey cherry" recipe, it failed, giving a cloying beer. Comparing the spreadsheet results to the actual results, there are two possible reasons.

1) The recipe uses 82 malt and 10 wheat. The wiki statement seems to be correct, in that the brew "will produce both malt and wheat flavors, in proportion to the relative quantities of malt and wheat it contains." The spreadsheet results, however, show nearly-full production of wheat flavors, which is not what happens in-game.

2) The wiki formula for cloying is when Glucose + 0.5 Maltose is greater than Tannin + Cinnamon + Nutmeg. The spreadsheet also includes Clove as a cloying counteractant. This may still be the case. However, the spreadsheet lists 60 clove, while the game recipe only produces 6 clove. If the in-game brew did produce 60 clove (try adding more wheat) it may not be a cloying brew.

All recipes whose success is "not known" need to be revised in the Beer Calculator

Honey

Yeast 81 at -142, -2066. Seal at 1500	Recipe	Success?	Notes
VP Fruity Hint of Honey	Finish: 50MM, 25H, 60LM	yes	screenshot below
VP Fruity Dry Hint of Honey	Finish: 55 LM, 40 MM, 10 RW, 20 H	yes
VP Fruity Dry Hint of Honey	Start: 20 MM, 80 H. Fin: 20 LM, 20 H	assumed	From beer recipes page
Dry Honey Beer	15 RM @ 300 to 175, Finish: 25 LM, 15 H	Not Known
Potent Dry Fruity Hint of Honey	Finish: 60 LM, 20 H	Not Known
VP Dry Fruity Hint of Honey	Finish: 60 LM, 40 MM, 15 H	Not Known

Cherry

Yeast 49 at 129, -2175. Seal at 1400	Recipe	Success?	Notes
Failed VP Fruity Honey Cherry	Start: 50 H Finish: 40 MM, 40 LM, 10 RW	Cloying	see above
VP Fruity Honey Cherry	Start: 50 H Finish: 40 MM, 45 LM, 40 RW	yes	Hint honey, hint cherry
VP Fruity Brown Honey Cherry	Start: 15 BM, 50 H Finish: 35 MM, 45 LM, 40 RW	yes	Notes
VP Fruity Black Honey Cherry	Start: 40 BM, 50 H Finish: 30 MM, 45 LM, 45 RW	yes	Notes
Potent Fruity Honey Cherry	@720: 40H. @240: 35 MM, 35 LM. Finish: 20 RM, 10 RW.	yes	Noticeable Honey Hint Cherry
Potent Fruity Brown Honey Cherry	Start: 15 BM @325: 30H @240: 35 MM, 40 LM Finish: 10 RW 20 RM	yes	Noticeable honey Hint cherry
Potent Fruity Black Honey Cherry	Start: 40 BM @325: 30H @240: 35 MM, 40 LM Finish: 10 RW 20 RM	yes	Noticeable honey Hint cherry

Cinnamon

Yeast 40 at -85, -2047. Seal at 1450	Recipe	Success?	Notes
Brown Cinnamon	Start: 20 BM or BW, 45 H Finish: 10 MM, 10 LM	Not Known	Notes
Black Cinnamon	Start: 45 BM or BW, 45 H Finish: 10 MM, 10 LM	Not Known	Notes
Spicy Brown Cinnamon	20 BM or BW, 45 H Finish: 10 MM, 20 LM	Not Known	Notes
Spicy Black Cinnamon	Start: 45 BM or BW, 45 H Finish: 10 MM, 20 LM	Not Known	Notes
Spicy Fruity Brown Honey Cinnamon	Start: 20 BM or BW @60: 45 honey Finish: 10 MM, 20 LM	Not Known	Notes
Potent Spicy Cinnamon	Start: 45 H Finish: 50 LM	Not Known	Notes
Fruity Dry Brown Honey no cinnamon	Start: 20 BM. @72: 50 H Finish: 15 RM	yes	Noticeable honey. 477 honey, 219 cinnamon
Fruity Dry Black Honey no cinnamon	Start: 43 BM. @72: 50 H Finish: 10 RM	yes	Noticeable honey. 477 Honey, 217 cinnamon
Dry Black Honey Cinnamon	Start: 43 BM. @100: 50H Finish: 10 RM	Not Tested	Should give 397 honey, 219 cinnamon
Potent Fruity Spicy Sweet Brown Honey Cinnamon	Start: 15 BM @60: 70 H Finish: 45 MM, 20 RM	Yes	Noticeable Honey Noticeable Cinnamon
Potent Fruity Spicy Sweet Black Honey Cinnamon	Start: 40 BM @60: 70 H Finish: 40 MM, 20 RM	Yes	Notes

Orange

Yeast 56 at -237,-2022. Open Kettle	Recipe	Success?	Notes
VP Dry Fruity Orange	Start: 45 H Finish: 40 MM, 40 LM	yes	Retested malt flavor profiles.
VP Dry Fruity Orange Honey	@60: 45 H Finish: 40 MM, 40 LM	Not Tested	Should yield 488 orange, 484 honey.
VP Dry Brown Fruity Orange Honey	Start: 15 BW @60: 45 H Finish: 40 MM, 40 LM	Not Tested	Should yield 488 orange, 484 honey.
VP Dry Black Fruity Orange Honey	Start: 40 BW @48: 40 H Finish: 40 MM, 40 LM	Not Tested	Should yield 488 orange, 478 honey
VP Sweet Fruity Orange Honey	Start: 20 LW @300: 60H, 40 MM, 40 LM	Not Tested	Should yield 390 orange, 227 honey
VP Sweet Brown Fruity Orange Honey	Start: 15 BM, 20 LW @360: 63 H, 40 MM, 35 LM	Not Tested	Should yield 399 orange, 208 honey
VP Sweet Black Fruity Orange Honey	Start: 40 BM, 15 LW @36: 40 MM, 35 LM @240: 58 H	Not Tested	Should yield 432 orange, 262 honey
Potent Dry Fruity Honey Orange	@60: 40 H Fin: 20 MM, 20 LM	Not Tested	Should yield 301 orange, 421 honey
Potent Dry Brown Fruity Honey Orange	Start: 20 BM @60: 40 H Fin: 20 MM, 20 LM	Not Tested	Should yield 422 honey, 316 orange
Potent Dry Black Fruity Orange Honey	Start: 45 BW @60: 35 H Fin: 20 MM, 20 LM	Not Known	Notes
Dry Fruity Orange Honey	Fin: 15 MM, 20 LM, 20 H	Not Known	Notes
Dry Fruity Brown Orange Honey	Start: 20 BW Fin: 15 MM, 20 LM, 20 H	Not Known	Notes
Dry Fruity Black Orange Honey	Start: 45 BW Fin: 15 MM, 20 LM, 20 H	Not Known	Notes
Results	Recipe	Not Known	Notes

Barley

Yeast 24 at -1,-2049, Seal at 2364	Recipe	Success?	Notes
VP Sweet Brown Barley Bread	Start: 30 MM, 20 LM, 5 BW, 45 LW, 60 H	Not Known	Notes
VP Sweet Black Barley Bread	Start: 30 MM, 20 LM, 30 BW, 45 LW, 60 H	Not Known	Notes
VP Dry Fruity Barley Honey	Start: 50 MM @200: 40 H Fin: 50 MW	Not Known	Notes
Results	Recipe	Not Known	Notes
Results	Recipe	Not Known	Notes
Results	Recipe	Not Known	Notes

Date

Yeast 66	Recipe	Success?	Notes
Dry Fruity Date	Start: 5 LM, 20 H @650: 10 RM	Not Known	Notes
Dry Brown Fruity Date	Start: 5 LM, 20 BW, 5 RW, 20 H @700: 10 RM	Not Known	Notes
Dry Black Fruity Date	Start: 5 LM, 45 BW, 5 RW, 20 H @700: 5 RM	Not Known	Notes
Potent Dry Fruity Date	Start: 5 LM, 80 H @400: 10 RM	Not Known	Notes
Potent Dry Brown Fruity Date	Start: 5 LM, 20 BW, 80H @400: 10 RM	Not Known	Notes
Potent Dry Black Fruity Date	Start: 5 LM, 45 BW, 80H @400: 5 RM	Not Known	Notes
Brown Fruity Date	Start: 15 BM, 20 LM, 20 LW, 10 H	Not Known	Notes
Black Fruity Date	Start: 40 BM, 20 LM, 20 LW, 10 H	Not Known	Notes
Potent Brown Fruity Date	Start: 15 BM, 30 LM, 20 LW, 55 H	Yes	Actual Description: Potent Fruity Brown Beer. Noticeable date flavor.
Potent Black Fruity Date	Start: 40 BM, 30 LM, 20 LW, 50 H	Yes	Actual Description: Potent Fruity Black Beer. Noticeable date flavor.
Potent Sweet Brown Fruity Date	Start: 15 BM, 30 LM, 30 LW, 70 H	Yes	Actual Description: Potent Fruity Sweet Brown Beer. Noticeable date flavor. Noticeable banana flavor.
Potent Sweet Black Fruity Date	Start: 40 BM, 30 LM, 30 LW, 65 H	Yes	Actual Description: Potent Fruity Sweet Black Beer. Bold date flavor.

Banana

Yeast	Recipe	Success?	Notes
Results	Recipe	Not Known	Notes

Nutmeg

Yeast	Recipe	Success?	Notes
Results	Recipe	Not Known	Notes

Yeast 81 beer results, first attempt 50 MM @ 120, 25 H @ 60, 60 LM @ 12. Sealed at 1500.

Same exact recipe as above, with a seal time of 1200, allowing in a second yeast