How to keep track of your home brew records & history

Monday, June 13, 2016

An idea to track beer making history

22/10/23: Fair Warning: I did this for a couple of months and then gave up. I just get experimenting and learning by doing. 

If you are looking to improve the results of your home brewing, you might like to think about keeping a record of what and how you brew.

If you write down what you did, what you used, when you did it and why you'll have a good basis on which to make an honest assessment about your beer brewing failures and successes.

If you find that you've pulled off a stunner of a beer, you might be able to remember just exactly how you brewed that beer. It could be the difference between remembering that you used a certain kind of hops in your brew or used a 50/ 50 split of them.

Or that you left the spoon in the fermenter.

I just wanted to share how I keep my beer brewing records. I use Google Sheets.

It looks something like this:

Beer brewing record keeping

This is basically an excel sheet that allows me to have a set of handy columns as below:

Date DownBrand of MaltMixed withDate BottledNotesFirst tasteFinal thoughts

Recording the date you got the brew down is hugely important because you need to know how long you've left the brew to ferment. Same for bottling. Has it been 12 days or three weeks? 

I also like to know what brand of kit I used and whether it was an ale or pilsner. And of course, did I use a brew enhancer or just dextrose? 

In my summary notes, I record my first taste experience and also final thoughts.

This is because I usually get stuck into the beer at the three-week mark but over time the beer will mature and take on different characteristics - that serves as a reminder to let the beer 'bottle condition' as much as you be patient for!

The beauty of using Google Sheets to record your beer adventures is that you can download the application to your smartphone.

This means you can quickly add records as you go (maybe you're just hiding in the shed?) and you'll reduce the need to remember to add notes to an exercise book somewhere else later on. 

This is just the way I do it, an exercise book is of course just a fine solution!

Once you are a more experienced brewer you might not need to record so much as you'll know everything.

Or will you? 

Guess who left the spoon in the beer fermenter

Saturday, June 11, 2016
Just a week after I wrote the 'I think I've contaminated my beer' post, this classic mistake happened. I'd just bottled a handy Black Rock NZ ale and went to clean the fermenter.

I found this spoon inside:

Spoon left in brew fermenter

My wife and I had been looking for that spoon for weeks!

I'd looked high and low and even behind the dishwasher with clearly no luck, and not even thinking that I had used the spoon to stir the beer wort.

I'm fairly confident the brew will be fine, a taste test proved it tasted like beer! Especially as I was a diligent brewmaster and sterilized everything before brewing.
Powered by Blogger.

Tags

absorption caps abv acetaldehyde acid adjuncts advice about beer brewing aeration aeration kit aging air lock alcohol alcohol poisoning ale ale beer kits alkaline alkaline brewery wash all grain american amylase apera apples attenuation autolysis automatic temperature compensation bacteria baker's yeast baking yeast ball lock ball valve bar keepers friend barley batch prime beer brewing beer capper beer dispenser beer filtration kit system beer gushers beer kit beer kit review beer kits beer lines beer salt beer taps beerstone best brewing equipment biotin bittering BKF black rock bleach blichmann blow off tubing bluelab bohemian pilsner boil in a bag boil over boneface bottle cap bottle caps bottle conditioning bottling bottling beer bottling spigot bourbon brettanomyces brew and review brew day brewing beer guide brewing salts brewing spoon brewing sugar brewing thermostat brewzilla british thermal unit brix brix scale BTU budvar buffer buffer solution burton snatch buyer's guide calcium chloride calcium sulphate calibration calibration probe calibration solution campden tablets capping carbon dioxide carbonation carbonation drops carboy cascade caustic soda cherry wine chinook chlorine christmas chronicle cider clarity cleaning your equipment clear beer clone recipe cloudy beer cold crashing coldbreak conditioning tablets conductivity conical fermenter contamination coopers copper tun corn sugar cornelius corny keg craft beer creamy beer crown cryo hops cubes danstar nottingham demijohn dextrose distilation DIY DME dopplebock draught dry hopping dry malt extract edelmetall brü burner eisbock ekuanot electrode enhancer enzyme equipment ester ethanol experiments in beer making faucet fermcap-s fermentables fermentation fermenter fermentis fermentor final gravity finings five star flat beer floccing foam inhibitor force carbonation french fresh wort pack fridge fruit fusel alchohol garage project gas burners gelatin gift and present ideas gin ginger beer glucose golden ale golden syrup goldings gose grain grain mill green bullet grist guinness gypsum hach hacks hallertauer heat mat heat pad heat wrap home brew honey hop schedule hops hops spider how not to brew beer how to brew that first beer how to brew with a beer kit how to grow hops how to make a hop tea how to wash yeast hydrated layer hydrogen sulfide hydrometer IBU ideas idophor infection inkbird instruments isoamyl acetate jelly beans jockey box john palmer juniper keezer keg cooler keg regulators kegco kegerator kegging kegs kettle kombucha krausen lactic acid lager lagering lauter lion brown liquid malt extract litmus LME lupulin lupulin powder lupuLN2 making beer malic acid malt malt mill maltodextrin mangrove jack's maple syrup mash mash paddle mash tun mccashins mead methanol micro brewing milling milwaukee MW102 mistakes mixing instructions moa mouth feel muntons must nano brewing New Zealand Brewer's Series no rinse nut brown ale oak oak wood chips off flavors original gravity oxygen pacific gem palaeo water pale ale panhead parsnip PBW pear pectine pectolase perlick ph levels ph meter ph pen pH strips ph tester pico brewing pilsner pitching yeast plastic drum poppet valve pot powdered brewing wash ppm precipitated chalk pressure relief valve priming prison hooch probe problem solving propane and propane accessories pruno pump system purity law radler re-using yeast recipe record keeping reddit refractometer reinheitsgebot removing beer labels from bottles review rice hulls riwaka rotten eggs saaz saccharomyces cerevisiae salt sanitization secondary regulator sediment seltzer session beer silicon simple tricks for brewing siphon site glass skunked beer small batch brewing soda soda ash soda stream sodium carbonate sodium carbonate peroxyhydrate sodium hydroxide sodium metasilicate sodium percarbonate sour beer sparge spigot spirals spirits spoon spraymalt star san starch STC-1000 steinlager steralisation sterilisation sterilization sterliization still stoke storage solution stout sucrose sugar supercharger tannins temperature temperature controller therminator thermometer tips for beginners tri-sodium phopsphate tricks and tips trub tubing tui turkey vodka infused gin vorlauf water water testing wet cardboard taste wet hopping weta whirlfloc tablets white claw williamswarn wine winter brewing wood wort wort chiller yeast yeast energizer yeast nutrient yeast rafts yeast starter yeast traps zinc
Back to Top