Want to place an ad email luke@realbeer.co.nz
$50+GST / month

RealBeer.co.nz

I thought it might be useful to 'open source' my modified spreadsheet for malt subs.

When I first started all grain brewing I looked for a malt substitution spreadsheet that targeted malt available in NZ.  The closest complete resource I could find was via the Knights of the Mash Fork link Joseph had posted on the Liberty website at the time.

While being a good start it wasn't really what I was looking for (i.e it contained some irrelevant info, was inaccurate in places and needed NZ malts added).

So over time I modified that one with new info from maltsters, my own thoughts and observations along with ideas cadged from other sources (in particular gems of knowledge from brewers on this forum who are far wiser and more experienced than me). 

The idea was to keep some references to US, UK and Euro malts to help convert recipes found on the various overseas forums and databases but to relate them to malts available here.

I use it now more for sparking ideas and recipe formulation but thought it could be useful for other local brewers.   

I'm also keen to get feedback and comments on any improvements that it needs - so have a look at the attached spreadsheet, throw your own thoughts into the mix and lets see how to make this thing better.

Cheers

 

Views: 1971

Attachments:

Reply to This

Replies to This Discussion

Updated today after looking at the Gladfields site and seeing their increased range.  SRM values are approximate and midrange of the those stated on the website.

Attachments:

So you mean I have to download it again :-P

Haha - yep. I'll have a chat to the editor about releasing un-finished versions.  What do you reckon?  Inaccuracies? Need any changes?

Looks pretty good to me although I can't say I have used enough of the malts yet to know. I still home roast a couple of mine. Ask me in a couple of years when I have finished my apprenticeship :-P

I have this site saved for use but it is great you have put together a local example. My focus has been elsewhere for a few months plus with the water shortage I haven't brewed for months. Will have to do a marathon week soon and put down four or five.

Looking good Tilt!

Thanks mate - yeah home roasting is another game entirely! You're probably building such an in depth knowledge you can go by look, smell and taste alone -'roast to order bespoke malts'!

This table was based on the one you mention - but as I started to understand more about malts and looked closely at it there were some areas that I thought could be tweaked. 

Good luck with that marathon - nothing like a house/shed smelling like wort for a week - heaven.

Excellent spreadsheet.  BTW:  Gladfields have a few more malts not on your spreadsheet now:  Redback, Aurora, Brown, Biscuit and Toffee.

I grabbed a bag of RedBack yesterday.  The grains have a distinctly rich red hue - looks fantastic.

Hi Tilt, Where can i get a copy of your spreadsheet. Id be interested to see where the Gladfields and Malteurope malts sit.

Click on the highlighted link above - if that doesn't work happy to send it if you PM me.  I haven't included Malteruop as I dont use them but would be happy to add a column with some guidance on where they fit.

RSS

© 2024   Created by nzbrewer.   Powered by

Badges  |  Report an Issue  |  Terms of Service