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;""))

• Also, the Beer Calculator's formula for "Muddled" is not quite the same as the description in the Beer Guide. I have had the calculator list a brew as muddled, but in game (and according to the guide) it does not qualify as muddled. To resolve this in the calculator, I have changed the formula slightly.
  

In cell D31, change the formula to: =IF(AND(LARGE(D39:V39;1)>200;LARGE(D39:V39;1)/2<LARGE(D39:V39;2);LARGE(D39:V39;1)/2<LARGE(D39:V39;3));"Muddled";"")

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. Some may work as written.

Recipes marked as "Not Tested" have been revised but have not yet been brewed in-game. They have a good chance of working.

Recipes marked as "yes" have been successfully brewed

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
Fruity Dry Brown Honey	Use the location in the "Cinnamon" section
Fruity Dry Black Honey	Use the location in the "Cinnamon" section

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

Yeast 88 at 7L CS; 1409, -1151; seal 1344)	Recipe	Success?	Notes
Spicy Dry Cinnamon Honey	@60: 22H, 10 LM, 20 LW	Not Tested	should yield 351 cinnamon, 221 honey
Spicy Dry Brown Cinnamon Honey	Start: 20 BW. Fin: 15 RM, 22H.	Not Tested	should yield 367 honey, 297 cinnamon
Spicy Dry Black Cinnamon Honey	Start: 10 BM, 38 BW. Fin: 10 LM, 20 H.	Not Tested	should yield 334 honey, 289 cinnamon

Orange Honey

Yeast 56 at -237,-2022. Open Kettle	Recipe	Success?	Notes
VP Fruity Dry Orange	Start: 45 H Finish: 40 MM, 40 LM	yes	Retested malt flavor profiles.
VP Fruity Dry Honey Orange	@100: 65 H Finish: 25 MM, 25 LM	Not Tested Revised	Should yield 453 orange, 519 honey.
VP Fruity Dry Brown Orange Honey	Start: 15 BM @150: 60 H Finish: 25 MM, 30 LM	Not Tested Revised	Should yield 468 orange, 375 honey.
VP Fruity Dry Black Orange Honey	Start: 40 BM @240: 55 H, 35 MM, 25 LM.	Not Tested Revised	Should yield 488 orange, 254 honey.
VP Fruity Sweet Orange Honey	Start: 20 LW @300: 60H, 35 MM, 37 LM	Not Tested Revised	Should yield 382 orange, 227 honey
VP Fruity Sweet Brown Orange Honey	Start: 15 BM, 20 LW @300: 60 H, 35 MM, 35 LM	Not Tested Revised	Should yield 395 orange, 227 honey
Potent Fruity Dry Honey Orange	@60: 40 H Fin: 20 MM, 20 LM	yes	Noticeable Honey, Hint Orange
Potent Fruity Dry Brown Honey Orange	Start: 20 BM @60: 40 H Fin: 20 MM, 20 LM	yes	Noticeable Honey, Hint Orange
Potent Fruity Dry Black Honey Orange	Start: 45 BM @60: 35 H Fin: 20 MM, 20 LM	Yes	Hint honey, Hint orange
Fruity Dry Honey Orange	@120: 35 H Fin: 15 MM, 15 LM	yes	Hint honey, Hint orange
Fruity Dry Brown Honey Orange	Start: 20 BM @120: 35 H Fin: 10 MM, 15 LM	Yes	Hint honey, Hint orange
Fruity Dry Black Orange Honey	Start: 45 BM @120: 35 H Fin: 10 MM, 15 LM	Yes	Hint orange, Hint honey

Orange Barley

(The ever-popular "dump and run" recipes!)

-237,-2022. Open Kettle, primarily Y56	Recipe	Success?	Notes
VP Fruity Sweet Orange Barley	Start: 20 LW 60H, 35 MM, 40 LM	Not Tested Revised	Should yield 338 orange, 450 barley.
VP Fruity Sweet Brown Orange Barley	Start: 15 BM, 20 LW 60 H, 35 MM, 35 LM	Not Tested Revised	Should yield 395 orange, 420 barley
VP Fruity Sweet Black Orange Barley	Start: 60 H, 40 BM, 35 MM, 35 LM, 10 LW	yes	Noticeable Orange, Noticeable Barley

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 Banana	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
Potent Fruity Sweet Brown Date Banana	Start: 15 BM, 30 LM, 30 LW, 70 H	Yes	Noticeable date flavor. Noticeable banana flavor. Yeast 66
Results	Recipe	Not Known	Notes

Nutmeg

Y-8 RP 1788, 4220; seal at 1900	Recipe	Success?	Notes
VP Barley Nutmeg	Start: 60H @800-500: 70 LM	Yes	Use for Hathor Hint Barley, Hint Nutmeg
VP Fruity Honey Nutmeg	@250: 65 LM, 65 H	Yes	Use for Hathor Hint Honey, Hint Nutmeg
VP Fruity Sweet Honey Nutmeg	@200: 70 H Fin: 70 LM	Yes	Noticeable honey, hint nutmeg
VP Fruity Sweet Brown Honey Nutmeg	Start: 15 BM @200: 70 H Fin: 70 MM	Yes	Noticeable honey, hint nutmeg
VP Fruity Sweet Black Honey Nutmeg	Start: 40 BM @200: 70 H Fin: 65 MM	yes	Noticeable honey, hint nutmeg
VP Fruity Dry Nutmeg Honey	@480-ish: 120 H Fin: 10 LM	yes	hint honey, hint nutmeg
VP Fruity Dry Brown Nutmeg Honey	Start: 20 BM @500: 120 H Fin: 10 RM	Yes	Hint honey, Hint Nutmeg
VP Fruity Dry Black Nutmeg Honey	Start: 45 BM @500: 120 H Fin: 10 RM	yes	Hint honey, Hint Nutmeg
Potent Dry Nutmeg Honey	@500: 100 H Fin: 10 LM	yes	hint honey, hint nutmeg
Potent Fruity Dry Nutmeg Honey	@300: 100 H Fin: 10 LM	yes	hint honey, hint nutmeg
Potent Fruity Dry Brown Nutmeg Honey	Start: 20 BM @300: 100 H Fin: 10 RM	yes	Hint honey, Hint nutmeg
Potent Fruity Dry Black Nutmeg Honey	Start: 45 BM @300: 100 H Fin: 5 RM	yes	Hint honey, Hint nutmeg
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