User:Peacefulness/Beer

From ATITD7

Jump to: navigation, search
  • 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";"")



Contents

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, 60LMyesscreenshot 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 HNot Known
VP Dry Fruity Hint of HoneyFinish: 60 LM, 40 MM, 15 HNot Known
Fruity Dry Brown HoneyUse the location in the "Cinnamon" section
Fruity Dry Black HoneyUse the location in the "Cinnamon" section

Cherry

Yeast 49 at the 7L location does not have the same max alcohol as the Y49 in South Egypt

Yeast 49 at 129, -2175 in 7L. Seal at 1378 Recipe Success? Notes
Failed VP Fruity Honey CherryStart: 50 H
Finish: 40 MM, 40 LM, 10 RW
Cloyingsee above
VP Fruity Honey CherryStart: 50 H
Finish: 40 MM, 45 LM, 40 RW
yesHint honey, hint cherry
VP Fruity Sweet (Honey) CherryStart 15 RW, 60 H.
Finish 45 MM, 45 LM
yesexact flavor levels not recorded
VP Fruity Brown Honey CherryStart: 15 BM, 50 H
Finish: 35 MM, 45 LM, 40 RW
yesNotes
VP Fruity Sweet Brown (Honey) CherryStart: 15 BM, 15 RW, 60 H.
Finish: 45 MM, 45 LM.
yesexact flavor levels not recorded
VP Fruity Black Honey CherryStart: 40 BM, 50 H
Finish: 30 MM, 45 LM, 45 RW
yesNotes
VP Fruity Sweet Black (Honey) CherryStart: 40 BM, 15 RW, 60 H.
Finish: 45 MM, 40 LM.
yesexact flavor levels not recorded
Potent Fruity Honey Cherry@720: 40H.
@240: 35 MM, 35 LM.
Finish: 20 RM, 10 RW.
yesNoticeable Honey
Hint Cherry
Potent Fruity Brown Honey Cherry Start: 15 BM
@325: 30H
@240: 35 MM, 40 LM
Finish: 10 RW 20 RM
yesNoticeable honey
Hint cherry
Potent Fruity Black Honey Cherry Start: 40 BM
@325: 30H
@240: 35 MM, 40 LM
Finish: 10 RW 20 RM
yesNoticeable honey
Hint cherry
Yeast 49 at 1242, -6141 in SE. Open Kettle Recipe Success? Notes
Potent Fruity Dry Honey CherryStart: 75 H, 5 RW.
Finish: 25 MM, 15 LM.
no not dry
Potent Fruity Dry Honey CherryStart: 80 H.
Finish 10 MM, 10 LM.
no Cloying
Potent Fruity Dry Brown Honey CherryStart: 20 BM, 75 H, 5 RW.
Finish: 25 MM, 15 LM.
no not dry
Potent Fruity Dry Brown Honey CherryStart: 20 BM, 80 H.
Finish: 10 MM, 10 LM.
no Cloying.
Potent Fruity Dry Black Honey CherryStart: 45 BM, 70 H.
Finish: 10 MM, 10 LM.
nono cherry.
Potent Fruity Sweet Honey CherryStart: 10 RW, 70H.
Finish: 30 MM, 30 LM.
no Not Sweet
Potent Fruity Sweet Brown Honey CherryStart: 10 BM, 5 RM, 5 BW, 8 RW, 60 H.
Finish: 45 MM, 23 LM.
yes hint honey, hint cherry
Potent Fruity Sweet Black Honey CherryStart: 30 BM, 5 RM, 10 BW, 8 RW, 55 H.
Finish: 45 MM, 23 LM.
yeshint honey, hint cherry

Cinnamon

Yeast 40 at -85, -2047. Seal at 1450 Recipe Success? Notes
Fruity Dry Brown Honey
no cinnamon
Start: 20 BM.
@72: 50 H
Finish: 15 RM
yesNoticeable honey.
477 honey, 219 cinnamon
Fruity Dry Black Honey
no cinnamon
Start: 43 BM.
@72: 50 H
Finish: 10 RM
yesNoticeable honey.
477 Honey, 217 cinnamon
Dry Black Honey CinnamonStart: 43 BM.
@100: 50H
Finish: 10 RM
Not TestedShould give 397 honey, 219 cinnamon
Potent Fruity Spicy Sweet Brown Honey CinnamonStart: 15 BM
@60: 70 H
Finish: 45 MM, 20 RM
YesNoticeable Honey
Noticeable Cinnamon
Potent Fruity Spicy Sweet Black Honey CinnamonStart: 40 BM
@60: 70 H
Finish: 40 MM, 20 RM
YesNotes
Potent Fruity Spicy Dry Honey CinnamonStart: 2 RW.
@ 150: 80 H.
Finish: 7 LM, 10 RM.
yesNoticeable Honey
Hint Cinnamon
Potent Fruity Spicy Dry Brown Honey CinnamonStart: 20 BM, 2 RW.
@ 150: 80 H.
Finish: 7 LM, 4 RM.
yesNoticeable Honey.
Hint Cinnamon
Potent Fruity Spicy Dry Black Honey CinnamonStart: 45 BM, 2 RW.
@ 150: 80 H.
Finish: 2 LM, 4 RM.
yesNoticeable Honey.
Hint Cinnamon


Yeast 88 at 7L CS; 1409, -1151; seal 1344 Recipe Success? Notes
Spicy Dry Cinnamon Honey @60: 22H, 10 LM, 20 LW yes hint cinnamon, hint honey
Fruity Spicy Dry Brown Cinnamon Honey Start: 20 BW.
Fin: 10 LM, 34H.
yes noticeable honey (569),
hint cinnamon (348)
Fruity Spicy Dry Black Cinnamon Honey Start: 10 BM, 38 BW.
Fin: 10 LM, 30 H.
yes noticeable honey (502),
hint cinnamon (358)
Fruity Spicy Sweet Cinnamon Honey Fin: 25 LM, 10 LW, 30 H. yes noticeable cinnamon (748),
noticeable honey (505)
Fruity Spicy Sweet Brown Cinnamon Honey Start: 20 BM.
Fin: 20 LM, 10 LW, 30 H.
yes noticeable honey (506),
noticeable cinnamon (843)
Fruity Spicy Sweet Black Cinnamon Honey Start: 45 BM.
Fin: 20 LM, 10 LW, 30 H.
yes noticeable honey(507),
noticeable cinnamon (917)


Open kettle at -94 -2038, VP Cinnamon Recipe Success? Notes
VP Spicy Cinnamon Beer for Hathor Start: 75 H.
Fin: 30 MM, 25 LM
Yes Noticeable (434) cinnamon flavor.
VP Fruity Spicy Dry Brown Honey Cinnamon. Start: 20 BM.
@ 300: 115 H.
Fin: 14 RM, 14 RW.
Yes Noticeable (422) honey flavor.
Hint (309) of cinnamon flavor.
VP Fruity Spicy Dry Honey Cinnamon.@300: 115 H.
Fin 5 LM, 11 RM, 10 RW
Yes Noticeable (418) honey flavor.
Hint (268) of cinnamon flavor.
VP Fruity Spicy Dry Black Honey CinnamonStart: 45 BM.
@ 300: 115 H.
Fin: 6 RM, 15 RW
yes Noticeable (427) honey flavor.
Hint (335) of cinnamon flavor.
VP Fruity Spicy Sweet Honey Cinnamon Start: 10 RW.
@ 100: 70H.
Fin: 30 LM, 35 MM
yes Noticeable (587) honey flavor.
Hint (378) of cinnamon flavor.
VP Fruity Spicy Sweet Brown Honey Cinnamon Start: 15 BM, 10 RW.
@100: 70 H.
Finish: 30 LM, 35 MM.
Yes Noticeable (590) honey flavor.
Hint (387) of cinnamon flavor.
VP Fruity Spicy Sweet Black Honey Cinnamon. Start: 40 BM, 5 RW.
@ 100: 70 H.
Finish: 30 LM, 30 MM.
yes Noticeable (637) honey flavor.
Noticeable (411) cinnamon flavor.
VP Spicy Sweet Brown Cinnamon Barley. Start: 7 BM, 5 RW, 45 H.
@ 800: 45 MM, 40 LM.
Not Tested Notes
VP Spicy Sweet Black Cinnamon Barley. Start: 40 BM, 5 RW, 50 H.
@ 700: 40 MM, 35 LM.
Not Tested Notes

Orange Honey

Yeast 56 at -237,-2022. Open Kettle Recipe Success? Notes
VP Fruity Dry OrangeStart: 45 H
Finish: 40 MM, 40 LM
yesRetested malt flavor profiles.
VP Fruity Dry Honey Orange @100: 65 H
Finish: 25 MM, 25 LM
yes Noticeable Honey (532) Noticeable Orange (453)
VP Fruity Dry Brown Orange Honey Start: 15 BM
@150: 60 H
Finish: 25 MM, 30 LM
yes Noticeable Orange (468) Hint Honey (386)
VP Fruity Dry Black Orange HoneyStart: 40 BM
@240: 55 H, 35 MM, 25 LM.
yes Noticeable Orange (488) Hint Honey (263)
VP Fruity Sweet Orange Honey Start: 20 LW
@300: 60H, 35 MM, 37 LM
yes Hint Orange (379), Hint Honey (226)
VP Fruity Sweet Brown Orange Honey Start: 15 BM, 5 RM, 15 RW
@300: 65 H.
Finish: 30 MM, 45 LM
yesNoticeable Orange (418), Hint Honey (244)
VP Fruity Sweet Black Orange Honey Start: 35 BM, 20 LW
@450: 30 MM, 35 LM
@ 100: 60 H
yes Noticeable Honey (489), Noticeable Orange (406)
Potent Fruity Dry Honey Orange@60: 40 H
Fin: 20 MM, 20 LM
yesNoticeable Honey, Hint Orange
Potent Fruity Dry Brown Honey OrangeStart: 20 BM
@60: 40 H
Fin: 20 MM, 20 LM
yesNoticeable Honey, Hint Orange
Potent Fruity Dry Black Honey OrangeStart: 45 BM
@60: 35 H
Fin: 20 MM, 20 LM
YesHint honey, Hint orange
Fruity Dry Honey Orange@120: 35 H
Fin: 15 MM, 15 LM
yesHint honey, Hint orange
Fruity Dry Brown Honey OrangeStart: 20 BM
@120: 35 H
Fin: 10 MM, 15 LM
YesHint honey, Hint orange
Fruity Dry Black Orange HoneyStart: 45 BM
@120: 35 H
Fin: 10 MM, 15 LM
YesHint 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
yes Noticeable barley (441) Hint Orange (386)
VP Fruity Sweet Brown Orange Barley Start: 15 BM, 20 LW
60 H, 35 MM, 35 LM
yes Noticeable Barley (410), Hint Orange (396)
VP Fruity Sweet Black Orange Barley Start: 60 H,
40 BM, 35 MM, 35 LM, 10 LW
yes Noticeable Orange, Noticeable Barley

Orange Clove

Yeast 75 at OE 340, 6530. Seal at 1100 Recipe Success? Notes
Potent Fruity Sweet Honey OrangeStart: 2 RW.
@ 100: 50 H.
Finish: 30 MM, 25 LM.
YesHint Honey
Hint Orange
Potent Fruity Sweet Brown Honey OrangeStart: 2 RW, 20 BM.
@ 100: 50 H.
Finish: 25 MM, 25 LM.
YesHint Honey
Hint Orange
Potent Fruity Sweet Black Honey no OrangeStart: 3 RW, 45 BM.
@ 100: 55 H.
Finish 21 MM, 21 LM.
Not really Orange (204) does not show.
Too much Honey (433)
Potent Spicy Sweet Clove BarleyStart: 20 MM, 20 LM, 7 LW.
@ 700: 90 H.
yesHint Clove
Hint Barley
Potent Fruity Spicy Sweet Brown Barley HoneyStart: 50 MM, 50 LM, 11 LW.
@150: 50 H.
yesNoticeable Barley
Hint Honey.
Potent Fruity Spicy Sweet Black Beer. Muddled (Barley Clove Honey)Start: 20 BM, 50 MM, 50 LM,
5 BW, 12 LW.
@ 150: 50 H.
Not really 596 Barley
306 Clove
304 Honey

Barley

Yeast 24 produces 1241 alcohol, but no significant flavors. Should be good for VP Barley Honey recipes.

Yeast 24 at -1,-2049, Seal at 2364Recipe Success? Notes
VP Sweet Brown Barley Bread Start: 30 MM, 20 LM, 5 BW, 45 LW, 60 HNot TestedNotes
VP Sweet Black Barley BreadStart: 30 MM, 20 LM, 30 BW, 45 LW, 60 HNot TestedNotes
VP Fruity Dry Barley HoneyStart: 50 MM
@48: 40 H
Fin: 50 MW
YesNoticeable Honey, Hint Barley
VP Fruity Dry Brown Barley HoneyStart: 10 BM, 20 MM, 15 LM.
@240: 90 H.
Finish: 5 RW.
yesHint Honey (400), Hint Barley (208)
VP Fruity Dry Black Barley HoneyStart: 36 BM, 20 MM, 15 LM.
@240: 85 H.
FInish: 5 RW
YesNoticeable Honey, Hint Barley
VP Fruity Sweet Barley Honey@ 900: 35 MM, 30 LM.
@ 180: 80 H
YesNoticeable Honey (443), Hint Barley (307)
VP Fruity Sweet Brown Barley HoneyStart: 10 BM
@ 900: 35 MM, 30 LM.
@ 180: 80 H
yesNoticeable Honey (443), Hint Barley (307)
VP Fruity Sweet Black Barley HoneyStart: 35 BM
@ 900: 35 MM, 30 LM.
@ 180: 70 H
yesHint Honey (393), Hint Barley (306)

Date

Yeast 66Recipe Success? Notes
Dry Fruity DateStart: 5 LM, 20 H
@650: 10 RM
Not KnownNotes
Dry Brown Fruity DateStart: 5 LM, 20 BW, 5 RW, 20 H
@700: 10 RM
Not KnownNotes
Dry Black Fruity DateStart: 5 LM, 45 BW, 5 RW, 20 H
@700: 5 RM
Not KnownNotes
Potent Dry Fruity DateStart: 5 LM, 80 H
@400: 10 RM
Not KnownNotes
Potent Dry Brown Fruity DateStart: 5 LM, 20 BW, 80H
@400: 10 RM
Not KnownNotes
Potent Dry Black Fruity DateStart: 5 LM, 45 BW, 80H
@400: 5 RM
Not KnownNotes
Brown Fruity DateStart: 15 BM, 20 LM, 20 LW, 10 HNot KnownNotes
Black Fruity DateStart: 40 BM, 20 LM, 20 LW, 10 HNot KnownNotes
Potent Fruity Brown DateStart: 15 BM, 30 LM, 20 LW, 55 HYesNoticeable date.
Potent Fruity Black DateStart: 40 BM, 30 LM, 20 LW, 50 HYesNoticeable date.
Potent Fruity Sweet Brown Date BananaStart: 15 BM, 30 LM, 30 LW, 70 HYesNoticeable date
Noticeable banana
Potent Fruity Sweet Black DateStart: 40 BM, 30 LM, 30 LW, 65 HYesBold date.
Yeast 66 Open KettleRecipe Success? Notes
VP Fruity Dry DateStart: 120 H.
Finish: 10 RM
YesBold (1686) Date flavor. 1204 alcohol
VP Fruity Dry Brown DateStart: 120 H, 20 BM.
Finish: 10 RM
YesBold (1686) Date flavor. 1204 alcohol
VP Fruity Dry Black DateStart: 120 H, 45 BM.
Finish: 5 RM, 5 RW
not yetResidual maltose still too high. Cloying.
VP Fruity Dry Black DateStart: 45 BW, 10 RW.
@600: 10 RM
@300: 120 H.
VP Fruity Sweet DateStart: 65 H.
@900: 45 MM, 35 LM
YesBold (1773) Date flavor. 1262 alcohol.
VP Fruity Sweet Brown DateStart: 60H, 5 BM.
@900: 45 MM, 35 LM
YesBold (1773) Date flavor. 1262 alcohol.
VP Fruity Sweet Black DateStart: 55H, 35 BM.
@900: 45 MM, 35 LM
YesBold (1773) Date flavor. 1262 alcohol.

Banana

Yeast 66 Recipe Success? Notes
Potent Fruity Sweet Brown Date BananaStart: 15 BM, 30 LM, 30 LW, 70 HYesNoticeable date flavor. Noticeable banana flavor.
Yeast 2 RP 1537 3841, seal 2050-2025Recipe Success? Notes
Potent Fruity Dry Banana Honey @500: 65 H.
Fin: 15 MM, 20 LM
yes noticeable (439) banana, hint (237) honey
Potent Fruity Dry Brown Banana Start: 16 BM
@600: 60 H
Fin: 15 MM, 20 LM
yes Noticeable banana (439), not enough honey to be tasted (207)
Potent Fruity Dry Black Banana Start: 41 BM
@600: 60 H
Fin: 15 MM, 20 LM
yes Noticeable banana (439), not enough honey to be tasted (207)
Potent Fruity Sweet Banana Barley Start 35 MM, 30 LM. 55 H. yes noticeable (439) Banana, hint (387) Barley
Potent Fruity Sweet Brown Banana Barley Start 5 BM, 35 MM, 30 LM. 55 H. yes Noticeable (439) Banana, hint (385) Barley
Potent Fruity Sweet Black Banana Barley Start 31 BM, 35 MM, 25 LM. 55 H. yes noticeable (439) Banana, hint (357) Barley

Nutmeg

Y-8 RP 1788, 4220; seal at 1900Recipe Success? Notes
VP Barley NutmegStart: 60H
@800-500: 70 LM
YesUse for Hathor
Hint Barley, Hint Nutmeg
VP Fruity Honey Nutmeg@250: 65 LM, 65 HYesUse for Hathor
Hint Honey, Hint Nutmeg
VP Fruity Sweet Honey Nutmeg@200: 70 H
Fin: 70 LM
YesNoticeable honey, hint nutmeg
VP Fruity Sweet Brown Honey NutmegStart: 15 BM
@200: 70 H
Fin: 70 MM
YesNoticeable honey, hint nutmeg
VP Fruity Sweet Black Honey NutmegStart: 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 HoneyStart: 20 BM
@500: 120 H
Fin: 10 RM
YesHint honey, Hint Nutmeg
VP Fruity Dry Black Nutmeg HoneyStart: 45 BM
@500: 120 H
Fin: 10 RM
yesHint honey, Hint Nutmeg
Potent Dry Nutmeg Honey@500: 100 H
Fin: 10 LM
yeshint honey, hint nutmeg
Potent Fruity Dry Nutmeg Honey@300: 100 H
Fin: 10 LM
yeshint honey, hint nutmeg
Potent Fruity Dry Brown Nutmeg HoneyStart: 20 BM
@300: 100 H
Fin: 10 RM
yesHint honey, Hint nutmeg
Potent Fruity Dry Black Nutmeg HoneyStart: 45 BM
@300: 100 H
Fin: 5 RM
yesHint honey, Hint nutmeg
ResultsRecipeNot KnownNotes


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

Same exact recipe as above, with a seal time of 1200, allowing in a second yeast Y 81 and Y 98 beer

Personal tools