Brewlog

Google Docs Spreadsheet

Here is a quick view of the sheet but you will get a nicely formatted 1 page print by using the link above.

Style:			Key
Beer Name:			ABV = Alcohol by Volume		AA = Alpha Acids
Beer Style/Category:			ABW = Alcohol by Weight		AAU = Alpha Acid Units
Brewer(s):			S.G. = Specific Gravity		IBU = International Bittering Units
Recipe Source:			O.G. = Original Gravity		EstSG = Estimated Specific Gravity
Date:			F.G. = Final Gravity		GU = Gravity Units
			gr = grain
Specifications:		Efficiency Est	Formulas
Total Batch Volume:			Gravity Units = (O.G. -1)*1000*Volume
Original Gravity:			Predicted Final Gravity = ((O.G. - 1)*(1-Attenuation%)) + 1
Final Gravity:			ABV = O.G. – F.G / 7.5
Assumed Efficiency:			ABW = ABV * 7.5
Yeast Attenuation:			F.G. = 1 - Attenuation as Decimal * GU
Pre-Boil Volume:			Evaporation % =100 - (postboil vol x 100 -;- preboil vol)
Pre-Boil Gravity:			EstSG = PreBoil SG in GU * PreBoil Vol / PostBoil Vol
Boil Duration:			Strike tmp = .2 / ration * msh tmp – gr tmp + msh tmp
Post-Boil Volume:			Ex Strke tmp = (.2 / 1.25)(152 – 70) + 152 = 165.12 F
ABV:			AAU = Hop Weight * A.A. %
Mash:			Scaling Hops = AAU / AA
Mash Type:			Scaling Ex. Recipe Calls ½ oz 8.1% you have 5.4%.
Total Grain Weight:			.5 * 8.1 = 4.05 AAU
Grain/Water Ratio:			y * 5.4 = 4.05 | y = 4.05 / 5.4 | y=.75 oz of 5.4
Strike Volume/Temp.:			Bitterness Ratio = IBUs / O.G.
Mash Temp./Duration:			Degress Plato = S.G. / 4
Additional Step Temp./Duration/Vol.:			Recipe Total Gravity = GU * Batch Volume (5.5Gal)
Additional Step Temp./Duration/Vol.:			Efficiency = O.G. GU / Grain Potential GU
Actual Efficiency:			(EstSG)GU After Boil = Preboil GU * Preboil Volume / Ending Boil Volume
			GU Adj w/Extrct = Target GU - Preboil GU / Extrct GU per LB per Gal (Light DME=44)
Fermentation:
Stage	Vessel	Temp.	Date	Gravity
Primary:
Racked:
Racked:
Bottle/Keg
Date:
Carbonation Level:
Priming Method:
Notes: