• Please visit and share your knowledge at our sister communities:
  • If you have not, please join our official Australia and New Zealand Homebrewers Facebook Group!

    Australia and New Zealand Homebrewers Facebook Group

2017 SEQ Christmas Case Swap - Tasting thread

Australia & New Zealand Homebrewing Forum

Help Support Australia & New Zealand Homebrewing Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
EBC0DA25-0D1C-4D66-98F0-6212B541A340.jpeg


I can't edit the spreadsheet from phone, but mine is ready. 5.3%
 
Black #2 is the Robust Porter, Red #2 is the Hoppy Saison. Colirs indicated are the writing on the lid. Schedules are on the spreadsheet.
 
Mine will be a few weeks at least. May need some age to smooth off the alcohol. I'll update the thread when ready.

Edit: can't edit on phone either. Got the app already installed.
 
Mine is carbed and ready, but I’d say give it a few weeks.
 
20171203_191933.jpg

2. Madperrie robust porter. Poured this then hopped into an epson salt bath... i am sore as **** this arvo. Great beer mellow roast with a malt sweetness on the nose and taste. Very easy to drink. Finishes dry and morish. A well brewed beer mate
 
Last edited:
Thanks to @earle for starting the thread and updating the spreadsheet.

I've added a few more columns so you can put in a Best After and Best Before date, in case freshness is an issue for a hoppy beer for example.

The Yes/No/??? column is restricted to a drop down and is colour coded, so just click on it and pick your option and fill out the dates.
 
The numbering system has got a bit out-of-whack. eg - my Julebryg, with "5" on the cap, shows on the spreadsheet as "6". I won't risk stuffing things up by attempting to change the spreadsheet, but someone who understands the finer points of spreadsheet editing might give it a go.

EDIT - I might have been looking at a superceded version! Looks OK now...
 
The numbering system has got a bit out-of-whack. eg - my Julebryg, with "5" on the cap, shows on the spreadsheet as "6". I won't risk stuffing things up by attempting to change the spreadsheet, but someone who understands the finer points of spreadsheet editing might give it a go.

EDIT - I might have been looking at a superceded version! Looks OK now...

Hi Roger

You might be looking at the spreadsheet row number, rather than the number in the first column.

It shows you as lid numbers 5 and 9.
 
According to my brew log mine will be ready to go on 18/12/17. That said it's a wheat beer so it'll probably be fine after another week.
 
I've updated the spreadsheet with some conditional formatting, so it should automatically turn green when beers are ready.

Just waiting on @Zorco & @Bribie G to fill out their dates, and @angus_grant to confirm when his is good to go.
 
I'm pretty sure that after having a RR Saison and one of Troy's RIS's, two decimal points is the best you're gonna get.
 
I'm pretty sure that after having a RR Saison and one of Troy's RIS's, two decimal points is the best you're gonna get.

How are you measuring to 2 points? I wouldn't have thought any home brew methods are that precise.
 
But still, how? You might be accurate, but I doubt it's that precise.

If using a hydrometer, only a 2 point difference (i.e. one line) on either OG or FG can throw your ABV by 0.25%. Double that error if you're wrong on both OG and FG.

Even if you could get it to a 1 point difference, you're still talking 0.125% error.

I've made up a look up table based on this calculator: http://pint.com.au/calculators/alcohol/

A wine making friend testing a few of my beers for ***** and giggles with an ebulliometer and found it was pretty spot on (within 0.1% generally).
 
okay Mr Science Man that's enough outta you

Spreadsheet attached.

Of course the 0.25% error varies with OG and FG (it's not linear), but that's for an OG of 1050 and an FG of 1010.
 

Attachments

  • ABV calculator.xlsm
    33.4 KB
Back
Top