I put this page together while a friend and I tried to open a small brewpub in Sun Prairie, WI in 2008-2009. If you're interested in our startup experiences, you can read about them at the RePublic Brewpub weblog. Since we dissolved the business, I've used this site primarily to share calculations and presentations with other brewers. The RePublic weblog contains a number of posts about brewing science, which I continued to write about in the Five Gallons At A Time feature at Madison Beer Review. I presented the material in a homebrewing context, but a lot of it applies to commercial brewing. Finally, please note the files and weblog posts are snapshots in time and may contain outdated information.

I hope you find this website helpful!

Joe
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ĉ
View Download
Simulations used to create equations that estimate alcohol content  197k v. 4 Feb 21, 2019, 4:05 PM Joe Walts
Ĉ
View Download
Document for tracking beer sales and filling out TTB Brewers Report of Operations  69k v. 1 Feb 8, 2017, 7:05 PM Joe Walts
Ċ
View Download
Business plan for RePublic. Numbers will not match the generic financial model spreadsheet  823k v. 1 Jun 21, 2013, 10:28 AM Joe Walts
Ĉ
View Download
Brewlog for multiple batches, including basic inventory and cost management. Streamlined for common US craft brewery processes  42k v. 10 Feb 17, 2019, 10:44 AM Joe Walts
Ĉ
View Download
Calculations for predicting safe gravities to cap fermentation vessels for CO2 capture.  19k v. 3 Mar 7, 2019, 7:04 PM Joe Walts
Ĉ
View Download
Calculations for serving gas pressures and natural carbonation  18k v. 8 Mar 7, 2019, 7:03 PM Joe Walts
Ĉ
View Download
Calculations for serving gas pressures and natural carbonation  18k v. 8 Mar 7, 2019, 7:03 PM Joe Walts
Ĉ
View Download
Temperature corrections for hydrometer and mash pH measurements  26k v. 2 Feb 26, 2017, 12:08 PM Joe Walts
Ĉ
View Download
Tubing length calculations for draught systems  16k v. 2 Nov 5, 2015, 6:22 PM Joe Walts
Ĉ
View Download
Financial model for brewpubs. Assumptions and some supplier prices are from 2010 or earlier  72k v. 4 Aug 10, 2016, 6:28 PM Joe Walts
Ĉ
View Download
Simulation used to create utilization adjustments for alpha acid saturation  57k v. 6 Jun 26, 2016, 6:28 PM Joe Walts
Ĉ
View Download
Simulation used to estimate utilization differences between pellets and whole hops  13k v. 3 Dec 2, 2018, 11:46 AM Joe Walts
Ċ
View Download
Presentation on hop science given to the Madison Homebrewers and Tasters Guild in 2015  533k v. 3 Oct 21, 2015, 4:51 PM Joe Walts
Ĉ
View Download
Sugar solution calculations for calibrating hydrometers (Plato hydrometers only)  11k v. 3 Nov 7, 2018, 7:17 PM Joe Walts
Ĉ
View Download
Detailed calculations for a single recipe. Includes complex interactions such as cereal mashes, yeast propagation, and natural carbonation   87k v. 49 Apr 14, 2019, 12:14 PM Joe Walts
Ĉ
View Download
Detailed calculations, brewlog, and batch adjustments for a single recipe. Includes complex interactions such as cereal mashes, yeast propagation, and natural carbonation   156k v. 49 Apr 14, 2019, 12:14 PM Joe Walts
Ĉ
View Download
Basic recipe calculations for MHTG Beer School  18k v. 2 Feb 26, 2017, 12:09 PM Joe Walts
Ċ
View Download
Introduction to recipe formulation and brewing calculations presented to the Madison Homebrewers and Tasters Guild in 2009  163k v. 1 Feb 25, 2015, 9:51 AM Joe Walts
Ĉ
View Download
Calculations for multiple recipes and mid-production adjustments, streamlined for common US craft brewery processes     1318k v. 33 May 18, 2019, 2:09 PM Joe Walts
Ĉ
View Download
Calculates Brewers Report of Operations and excise tax values from beer sales figures. Method of BROP reporting may not be suitable for all breweries  28k v. 2 Apr 3, 2016, 12:28 PM Joe Walts
Ĉ
View Download
Lauter simulations that show how brewhouse efficiency changes with number of batch sparges at ideal water-to-grain ratios  5455k v. 1 Feb 25, 2015, 9:52 AM Joe Walts
Ĉ
View Download
Lauter simulations that show how brewhouse efficiency changes with water-to-grain ratio for a fixed number of batch sparges  603k v. 1 Feb 25, 2015, 9:53 AM Joe Walts
Ĉ
View Download
Lauter simulations used to create equations in recipe formulation and kettle fill calculations.  881k v. 3 Oct 9, 2017, 3:08 AM Joe Walts
Ĉ
View Download
Turbid mash calculations for homebrew batches  15k v. 1 Feb 25, 2015, 9:54 AM Joe Walts
Ĉ
View Download
Calculations for brewhouse water and mash treatments   24k v. 30 Apr 14, 2019, 12:12 PM Joe Walts
Ĉ
View Download
Calculations for brewhouse water and mash treatments   24k v. 30 Apr 14, 2019, 12:12 PM Joe Walts
Ċ
View Download
Presentation on brewhouse water and mash chemistry.  6346k v. 1 Mar 21, 2018, 4:57 AM Joe Walts
Ĉ
View Download
Yeast pitching and propagation calculations  17k v. 6 Mar 7, 2019, 7:05 PM Joe Walts
Ĉ
View Download
Yeast pitching and propagation calculations  17k v. 6 Mar 7, 2019, 7:05 PM Joe Walts
Ċ
View Download
Presentation on yeast given to the Madison Homebrewers and Tasters Guild in 2008  254k v. 1 Feb 25, 2015, 9:55 AM Joe Walts
Comments