User:Peacefulness/Beer

From ATITD7

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.

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, 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 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 Cherry

Start: 50 HFinish: 40 MM, 40 LM, 10 RW

Cloying

see above

VP Fruity Honey Cherry

Start: 50 HFinish: 40 MM, 45 LM, 40 RW

yes

Hint honey, hint cherry

VP Fruity Sweet (Honey) Cherry

Start 15 RW, 60 H.Finish 45 MM, 45 LM

yes

exact flavor levels not recorded

VP Fruity Brown Honey Cherry

Start: 15 BM, 50 H Finish: 35 MM, 45 LM, 40 RW

yes

Notes

VP Fruity Sweet Brown (Honey) Cherry

Start: 15 BM, 15 RW, 60 H.Finish: 45 MM, 45 LM.

yes

exact flavor levels not recorded

VP Fruity Black Honey Cherry

Start: 40 BM, 50 HFinish: 30 MM, 45 LM, 45 RW

yes

Notes

VP Fruity Sweet Black (Honey) Cherry

Start: 40 BM, 15 RW, 60 H.Finish: 45 MM, 40 LM.

yes

exact flavor levels not recorded

Potent Fruity Honey Cherry

@720: 40H. @240: 35 MM, 35 LM. Finish: 20 RM, 10 RW.

yes

Noticeable HoneyHint Cherry

Potent Fruity Brown Honey Cherry

Start: 15 BM @325: 30H @240: 35 MM, 40 LM Finish: 10 RW 20 RM

yes

Noticeable honeyHint cherry

Potent Fruity Black Honey Cherry

Start: 40 BM@325: 30H @240: 35 MM, 40 LM Finish: 10 RW 20 RM

yes

Noticeable honeyHint cherry

Yeast 49 at 1242, -6141 in SE. Open Kettle

Recipe

Success?

Notes

Potent Fruity Dry honey cherry

Start: 110 H Finish 20 RM.

yes

noticeable honeyhint cherry

Potent Fruity Dry Brown Honey Cherry

Start: 20 BM, 75 H, 5 RW. Finish: 25 MM, 15 LM.

no

not dry

Potent Fruity Dry Brown Honey Cherry

Start: 20 BM, 80 H. Finish: 10 MM, 10 LM.

no

Cloying.

Potent Fruity Dry Brown Honey Cherry

Start: 110 H, 20 BM. Finish 15 RM.

no

Cloying, but otherwise dry. Needs more tannin

Potent Fruity Dry Black Honey Cherry

Start: 45 BM, 70 H. Finish: 10 MM, 10 LM.

no

no cherry.may not be possible at this loc.

Potent Fruity Sweet Honey Cherry

Start: 10 RW, 75 H. @300: 10 RM. Finish: 30 MM, 25 LM

yes

hint honeyhint cherry

Potent Fruity Sweet Brown Honey Cherry

Start: 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 Cherry

Start: 30 BM, 5 RM, 10 BW, 8 RW, 55 H. Finish: 45 MM, 23 LM.

yes

hint 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 HFinish: 15 RM

yes

Noticeable honey.477 honey, 219 cinnamon

Fruity Dry Black Honeyno cinnamon

Start: 43 BM.@72: 50 HFinish: 10 RM

yes

Noticeable honey. 477 Honey, 217 cinnamon

Dry Black Honey Cinnamon

Start: 43 BM.@100: 50HFinish: 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

Potent Fruity Spicy Dry Honey Cinnamon

Start: 2 RW. @ 150: 80 H. Finish: 7 LM, 10 RM.

yes

Noticeable HoneyHint Cinnamon

Potent Fruity Spicy Dry Brown Honey Cinnamon

Start: 20 BM, 2 RW. @ 150: 80 H. Finish: 7 LM, 4 RM.

yes

Noticeable Honey. Hint Cinnamon

Potent Fruity Spicy Dry Black Honey Cinnamon

Start: 45 BM, 2 RW. @ 150: 80 H. Finish: 2 LM, 4 RM.

yes

Noticeable 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 Cinnamon

Start: 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.

yes

Noticeable Cinnamon, Hint Barley

VP Spicy Sweet Black Cinnamon Barley.

Start: 40 BM, 5 RW, 50 H.@ 700: 40 MM, 35 LM.

yes

Noticeable CinnamonHint Barley

Orange Honey

Yeast 56 at -237,-2022. Open Kettle

Recipe

Success?

Notes

VP Fruity Dry Orange

Start: 45 HFinish: 40 MM, 40 LM

yes

Retested malt flavor profiles.

VP Fruity Dry Honey Orange

@100: 65 HFinish: 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 Honey

Start: 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

yes

Noticeable 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 HFin: 20 MM, 20 LM

yes

Noticeable Honey, Hint Orange

Potent Fruity Dry Brown Honey Orange

Start: 20 BM@60: 40 HFin: 20 MM, 20 LM

yes

Noticeable Honey, Hint Orange

Potent Fruity Dry Black Honey Orange

Start: 45 BM@60: 35 HFin: 20 MM, 20 LM

Yes

Hint honey, Hint orange

Fruity Dry Honey Orange

@120: 35 HFin: 15 MM, 15 LM

yes

Hint honey, Hint orange

Fruity Dry Brown Honey Orange

Start: 20 BM@120: 35 HFin: 10 MM, 15 LM

Yes

Hint honey, Hint orange

Fruity Dry Black Orange Honey

Start: 45 BM@120: 35 HFin: 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 LW60H, 35 MM, 40 LM

yes

Noticeable barley (441) Hint Orange (386)

VP Fruity Sweet Brown Orange Barley

Start: 15 BM, 20 LW60 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 Orange

Start: 2 RW. @ 100: 50 H. Finish: 30 MM, 25 LM.

Yes

Hint Honey Hint Orange

Potent Fruity Sweet Brown Honey Orange

Start: 2 RW, 20 BM. @ 100: 50 H. Finish: 25 MM, 25 LM.

Yes

Hint HoneyHint Orange

Potent Fruity Sweet Black Honey no Orange

Start: 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 Barley

Start: 20 MM, 20 LM, 7 LW. @ 700: 90 H.

yes

Hint CloveHint Barley

Potent Fruity Spicy Sweet Brown Barley Honey

Start: 50 MM, 50 LM, 11 LW. @150: 50 H.

yes

Noticeable 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 Barley306 Clove304 Honey

Barley

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