How to keep track of your home brew records & history


An idea to track beer making history

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? 

0 comments:

Post a Comment

Powered by Blogger.

Tags

abv acetaldehyde acid adjuncts advice about beer brewing aeration aeration kit aging air lock alcohol ale ale beer kits alkaline alkaline brewery wash all grain american 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 bottling bottling beer bottling spigot bourbon brettanomyces brew and review brew day brewing beer guide brewing salts brewing spoon brewing sugar brewing thermostat british thermal unit brix brix scale BTU bud light 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 chinook chlorine christmas chronicle cider 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 death from above demijohn dextrose distilation DIY DME dry hopping edelmetall brĂ¼ burner ekuanot electrode enhancer enzyme equipment ester ethanol experiments in beer making faucet fermcap-s fermentables fermentation fermentation system fermenter fermentis fermentor final gravity finings five star floccing foam inhibitor french fresh wort pack fridge fruit fusel alchohol garage project gas burners gelatin gift and present ideas gin ginger beer golden ale golden syrup goldings grain grain mill green bullet grist guinness gypsum hach hacks hallertauer heat pad 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 jos ruffell juniper keezer keg cooler keg regulators kegco kegerator kegging kegs kettle kombucha krausen lactic acid lager lagering lauter litmus lupulin lupulin powder lupuLN2 making beer malic acid malt malt mill maltodextrin mangrove jack's maple syrup mash mash paddle mash tun 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 pale ale panhead PBW pear pectine pectolase pete gillespie ph levels ph meter ph pen pH strips ph tester pico brewing pilsner pitching yeast plastic drum poppet valve pot powdered brewing wash precipitated chalk pressure relief valve priming probe problem solving propane and propane accessories pump system purity law re-using yeast recipe record keeping reddit refractometer reinheitsgebot removing beer labels from bottles review rice hulls riwaka rotten eggs saaz saccharomyces cerevisiae sanitization secondary regulator sediment session beer silicon simple tricks for brewing siphon site glass skunked beer small batch brewing soda ash sodium carbonate sodium carbonate peroxyhydrate sodium hydroxide sodium metasilicate sodium percarbonate sour beer sparge spigot spirals spirits spoon spraymalt star san STC-1000 steinlager stella artois steralisation sterilisation sterilization sterliization storage solution stout sucrose sugar supercharger tannins temperature temperature controller thermometer tips for beginners tri-sodium phopsphate tricks and tips trub tubing tui turkey vorlauf water water testing wet cardboard taste wet hopping whirlfloc tablets williamswarn wine winter brewing wood wort wort chiller yeast yeast energizer yeast nutrient yeast starter
Back to Top