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
VP Fruity Honey Cherry	Start: 50 H Finish: 40 MM, 40 LM, 10 RW	Cloying	see above
Revised VP Fruity Honey Cherry	Start: 50 H Finish: 40 MM, 45 LM, 40 RW	yes	Hint honey, hint cherry
Revised VP Fruity Brown Honey Cherry	Start: 15 BM, 50 H Finish: 35 MM, 45 LM, 40 RW	yes	Notes
Revised VP Fruity Black Honey Cherry	Start: 40 BM, 50 H Finish: 30 MM, 45 LM, 45 RW	yes	Notes
Revised Potent Fruity Honey Cherry	Start: 25 H @240: 35 MM, 40 LM Finish: 10 RW 20 RM	Muddled	190 barley, 206 cherry, 341 honey
Next attempt	@360: 40H @240: 35 MM, 35 LM Finish: 20 RM, 10 RW	Noticeable Honey	180 barley, 223 cherry, 458 honey.
Revised Potent Fruity Brown Honey Cherry	Start: 15 BM @240: 35 MM, 40 LM, 30 honey Finish: 10 RW 20 RM	Not Tested	Calculator shows 192 barley, 210 cherry, 448 honey. may end up as honey beer
Revised Potent Fruity Black Honey Cherry	Start: 25 H, 40 BM @240: 35 MM, 40 LM Finish: 10 RW 20 RM	Not Tested	Notes

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
Dry Brown Cinnamon	Start: 20 BM or BW, 50 H Finish: 10 RM	Not Known	Notes
Dry Black Cinnamon	Start: 42 BM or BW, 50 H Finish: 10 RM	Not Known	Notes
Potent Fruity Spicy Sweet Black Honey Cinnamon	Start: 40 BM @60: 70 H Finish: 35 MM, 20 RM	Yes	Notes

Orange

Yeast 56 at -237,-2022. Open Kettle	Recipe	Success?	Notes
VP Dry Fruity Orange (Honey)	Start: 40 H Finish: 40 MM, 40 LM	Not Tested	add honey later, at 600, to make Orange Honey beer
VP Dry Brown Fruity Orange (Honey)	Start: 15 BW, 40 H Finish: 40 MM, 40 LM	Not Tested	add honey later, at 500, to make Orange Honey beer
VP Dry Black Fruity Orange (Honey)	Start: 40 BW, 40 H Finish: 35 MM, 40 LM	Not Tested	add honey later, at 350, to make Orange Honey beer
VP Sweet Fruity Orange Honey	Start: 20 LW @1150: 55 H Fin: 40 MM, 35 LM	Not Known	Notes
VP Sweet Brown Fruity Orange Honey	Start: 15 BW, 20 LW @1150: 55 H Fin: 40 MM, 35 LM	Not Known	Notes
VP Sweet Black Fruity Orange Honey	Start: 40 BW, 15 LW @1150: 55 H Fin: 40 MM, 35 LM	Not Known	Notes
Potent Dry Fruity Orange Honey	@60: 40 H Fin: 20 MM, 20 LM	Not Known	Notes
Potent Dry Brown Fruity Orange Honey	Start: 20 BW @60: 35 H Fin: 20 MM, 20 LM	Not Known	Notes
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