I made a beer flavour finder

[Chris Murtagh]

Hi,

I've made a spreadsheet where you type in a flavour and it tells you what of the classic brewing ingredients will create (supposedly) that flavour. (The malt is a bit UK based but there might be equivalents in other countries, so sorry about that)

Anyway I thought it might be useful for people, let me know what you think.

link

 

[MaxStout]

That is a monster database! Thank you for sharing.

 

[Bramling Cross]

Holy smokes!

 

[Brewer Mike]

Pretty cool! But, you might want to clear the search field if you keep it comment only. I can only see things with lime.

 

[MaxStout]

I downloaded it and saved in Excel. A bit unwieldy with 1300+ rows, so I did copy/pasta of hops, yeast and malts into their own respective tabs, then moved and resized a few columns. I like to have the ingredient name in Column A and sort A-Z. Then I can do a keyword search in Excel's find function. Works great!

Good job compiling all that data. That must've been your desert island project for a year.

 

[Chris Murtagh]

Pretty cool! But, you might want to clear the search field if you keep it comment only. I can only see things with lime.

Thanks , I didn't realize this, would have thought it would be useable. I didn't really want people to be able to edit it, just in case someone messes it up, maybe I should do that and just have a backup.

 

[Chris Murtagh]

I downloaded it and saved in Excel. A bit unwieldy with 1300+ rows, so I did copy/pasta of hops, yeast and malts into their own respective tabs, then moved and resized a few columns. I like to have the ingredient name in Column A and sort A-Z. Then I can do a keyword search in Excel's find function. Works great!

Good job compiling all that data. That must've been your desert island project for a year.

yeah it took about six months working on it now and again, learnt a lot about different ingredients, so it was probably worth it. Might try to make a few posters and things with the info on there, was thinking of a family tree of hops, and hop atlas and various things.