I put together this page while a friend and I tried to open a small brewpub in Sun Prairie, WI. If you're interested in the early startup process (we made it to the financing stage), you can read about our experiences at the RePublic Brewpub weblog. This site, which I plan to continue updating, contains a bunch of brewing calculations, business planning tools, and educational presentations.

Several of the files are Excel spreadsheets. If their calculations return error values, you may need to do the following:

1. Select 'Tools' from the top menu bar.
2. Select 'Add-Ins'.
3. Check the box for 'Analysis ToolPak'.
4. Restart Excel.

Descriptions marked with asterisks indicate files that have not been tested in the real world.

If you'd like to learn more about nerdy brewing topics, check out the Five Gallons At A Time series I write for Madison Beer Review.

Joe
Brewhouse_Efficiency.xlsx
View Download
Calculations used to predict brewhouse efficiencies in the recipe spreadsheets   5548k v. 3 Jan 30, 2012 8:13 AM Joe Walts
Brewlog_Barrels.xlsx
View Download
Brewlog for commercial batches  19k v. 3 May 14, 2012 5:16 AM Joe Walts
Brewlog_Gallons.xlsx
View Download
Brewlog for homebrew batches  18k v. 3 May 14, 2012 5:18 AM Joe Walts
Business_Plan.pdf
View Download
Business plan with some information removed to protect the innocent  750k v. 1 Nov 22, 2009 6:24 AM Joe Walts
Carbonation_Barrels.xlsx
View Download
Carbonation calculator for commercial batches  14k v. 2 Feb 18, 2012 5:42 AM Joe Walts
Carbonation_Gallons.xlsx
View Download
Carbonation calculator for homebrew batches  14k v. 2 Feb 18, 2012 5:42 AM Joe Walts
Draught_Balance.xls
View Download
Tubing length calculator for draught systems   9k v. 2 Apr 30, 2010 9:24 AM Joe Walts
FM_Brewpub.xls
View Download
Financial model for startup and growth of brewpubs*   266k v. 8 Oct 29, 2010 2:17 PM Joe Walts
FM_Packaging.xls
View Download
Financial model for startup and at-capacity operation of packaging breweries*  118k v. 1 Oct 29, 2010 2:17 PM Joe Walts
FM_RePublic.xls
View Download
Financial model used to create the RePublic business plan.  276k v. 1 Jun 13, 2010 5:28 AM Joe Walts
FV_Capping_Plato.xls
View Download
Capping gravity calculator in degrees Plato*  18k v. 1 Jun 14, 2011 7:17 PM Joe Walts
FV_Capping_SG.xls
View Download
Capping gravity calculator in specific gravity*  17k v. 1 Jun 14, 2011 7:17 PM Joe Walts
Gravity_Correction.xlsx
View Download
Hydrometer temperature correction  26k v. 5 Feb 16, 2012 9:22 AM Joe Walts
MBAA_Water.pdf
View Download
Presentation on brewhouse water chemistry given to the Master Brewers Association of the Americas, District Milwaukee in 2012  86k v. 2 May 20, 2012 7:33 AM Joe Walts
MHTG_Recipes.pdf
View Download
Introduction to recipe formulation and brewing calculations presented to the Madison Homebrewers and Tasters Guild in 2009  303k v. 13 May 20, 2012 7:31 AM Joe Walts
MHTG_Yeast.pdf
View Download
Presentation on yeast given to the Madison Homebrewers and Tasters Guild in 2008  213k v. 3 May 20, 2012 7:31 AM Joe Walts
Oxygenation.xls
View Download
Inline oxygenation calculator*   24k v. 2 Jun 22, 2011 5:17 PM Joe Walts
Recipe_Barrels.xlsx
View Download
Recipe calculator for commercial batches    47k v. 6 Mar 26, 2012 9:40 AM Joe Walts
Recipe_Gallons.xlsx
View Download
Recipe calculator for homebrew batches    47k v. 6 Mar 26, 2012 9:40 AM Joe Walts
Recipe_School.xls
View Download
Basic recipe calculator for MHTG Beer School               29k v. 15 Sep 23, 2011 1:47 PM Joe Walts
Water_Barrels.xlsx
View Download
Water treatment calculator for commercial batches    18k v. 5 Mar 4, 2012 12:57 PM Joe Walts
Water_Gallons.xlsx
View Download
Water treatment calculator for homebrew batches    18k v. 5 Mar 4, 2012 12:57 PM Joe Walts
Yeast_Barrels.xlsx
View Download
Yeast pitch rate calculator for commercial batches  16k v. 3 Apr 29, 2012 1:39 PM Joe Walts
Yeast_Gallons.xlsx
View Download
Yeast pitch rate calculator for homebrew batches  16k v. 3 Apr 29, 2012 1:39 PM Joe Walts