My Cheapo Brewsheet

 

There are great brewing programs around that are simple to use and very powerful. But what they lack is a seamless ease of access. Programs must be installed on whatever computer you are using, and online calculators require an internet connection. I want something I can take anywhere and access on any computer, either online or offline. I also want a file format where I could copy the recipe info and easily paste it into a variety of formats. That is why I chose to go with an Excel workbook. If I want to work on a recipe on my lunch break, I don’t need to hack my work computer to download and install a program. If I’m brewing outside without internet access and need to change a recipe on the fly, I can do that. I can view and modify my recipes on any laptop, smartphone, or tablet. At my homebrew club meeting, I can access my files via Dropbox or a cloud server, and get any recipe info I need.

Many brewing spreadsheets exist, but I found most of them either too simple or too complex. I either didn’t have all the information to formulate a recipe or the spreadsheet was so busy I got lost in it. Therefore, I decided to make my own brewing spreadsheet. I wanted a recipe formulator that was simple and easy to read. I hope you find it useful.

Download here.

My Cheapo Brewsheet sample

UPDATES
– 3.3.2 – added dropdown for SRM calculations; rearranged the sheet layouts; added new malts and yeasts; fixed some bugs
– 3.1.0 – added new malts and yeasts; removed hops drop-down – quicker just to type the name rather than scroll through a list; rearranged a few tables
– 3.0.2 – fixed Rager IBU formula
– 3.0.1 – fixed predicted 1st and 2nd runnings calculations on Brewday Datasheet
– 3.0.0 – updated ingredient dropdowns, added maltsters and malts, updated hops, redid/fixed various calculations, reconfigured layout
– 2.0.0 – replaced Brew Day Datasheet with a simplified, printer-friendly version. Added new hop varieties.
– 1.2.0 – updated styles to 2015 BJCP style guidelines
– 1.1.0 – updated Water Volume & Temp section; fixed some minor errors
– 1.0.4 – added ale, lager, hybrid drop down in yeast section; updated yeast information
– 1.0.3 – fixed IBU calculation on Brew Day Worksheet and Scale-up tabs
– 1.0.2 – added cells for grain absorption and mash tun loss