Category Archives: Spreadsheets

My Brewing Spreadsheet – FREE Brew Day Tracking!

homebrew spreadsheet

My Brew Day Spreadsheet!

The spreadsheet is setup from my perspective, as a batch sparger.  Having said that, almost everything applies equally to a fly sparger with the possible exceptions of the computed mash ratio (more below), planning on a set volume of sparge water and the step by step batch sparge directions.

img_brewday

 This is the main sheet where you will fill in information about your beer and your mash parameters.  Click to enlarge.

Need More?

My brew day spreadsheet helps you calculate water volumes and temps and helps you do simple tracking.

If you’re looking for a powerful, full featured solution for building recipes, brew day tracking and loads more, consider Brewfather.

Continue reading →

BIAB Brew Day Spreadsheet – Water Calculations + Narrative Step by Step Directions

biab homebrew spreadsheet

Why BIAB?

Brew in a Bag (BIAB) is a quick, easy and economical way to brew all grain batches of beer.  I released my brew day spreadsheet some time ago along with a version of that to be used for small batch beers.  See below for links.  Either of those could be modified to work with BIAB by changing variables,  This version is specifically designed for full size BIAB batches.

Main Page (click to enlarge):

homebrew brew in a bag biab spreadsheet

Related:

Hobby Homebrew MESH...image
Hobby Homebrew MESH GRAIN BAG BIAB Brew-in-A-Bag Grain Mash Straining Bag with Handles (27.5 x 32.5 in) BAG29 Size HUGE From KegLand fits 10 Gallon Igloo Water Cooler
$23.94
Brew Bag, 26
Brew Bag, 26" x 22", 2 Pack, 100% Unbleached Cotton Bag for Homebrewing, Fine Cheesecloth Bag for Fruit/Cider/Wine/Beer, Reusable Drawstring Straining
$12.95
Bellamei Brew Bags...image
Bellamei Brew Bags Extra Large Reusable 2 Pack 250 Micron Fine Mesh Bag for Fruit Cider Apple Grape Wine Press Drawstring Straining Brew in a Bag (2 pack-22"×26")
$7.99 -$5.15 $2.84
Jillmo Brew Bag,...image
Jillmo Brew Bag, Extra Large (31”X22”) Reusable Brew in a Bag, 2 Pack, New Version
$9.99

Need More?

My brew day spreadsheet helps you calculate water volumes and temps and helps you do simple tracking.

If you’re looking for a powerful, full featured solution for building recipes, brew day tracking and loads more, consider Brewfather.

How I Use Brew Day Spreadsheets

How do I use brew day spreadsheets?  First, I do use recipe formulation software.  Some of those programs have brew day components.  I’ve just never gotten into using those features.  For better or worse, I use a spreadsheet.  I make a copy and name it using the batch number and beer name and then quickly plug in the basics.  This creates a one sheet printable page that I can use on brew day.  That gives me a single piece of paper with all of my numbers and a spot for brew day notes.  Notes can go back into the spreadsheet for archival.

Continue reading →

Step by Step Small Batch, All Grain Stove Top Brewing!

small batch homebrew

I periodically brew small (1-3) gallon all grain batches of beer on my stove top.  Some reasons I do that… 1.  The weather – it’s too cold, too hot or too something else, 2.  Time or 3.  I want to test something.  It’s a fun, simple, quick and economical way to brew all grain with minimal investment.

For the extract brewer, what kind of gear is needed to accomplish this amazing feat?  A comprehensive list follows…

Continue reading →

Our Collection of Homebrewing Spreadsheets – Brewing Spreadsheet, Brew in a Bag, Small Batch & Hard Seltzer

homebrewing spreadsheets

Homebrew recipe and brew day software can be handy.  Something like BeerSmith or Brewfather – Free Non-Expiring Brewfather Trial Account – can be invaluable for creating recipes, figuring SRM, figuring IBUs, fitting beers into established styles and lots more.  Some are BeerSmith power users and track every recipe and every brew day in this great software.

Sometimes you just want to brew.  It’s a recipe that you’ve brewed before, something you’re putting together on the fly, or you just want something quick and easy to tell you temperatures and volumes.  Even though I have and use recipe software, I just find it easier to use brew day spreadsheets to track each individual beer.  I’ve developed three that I use in different situations.

Get the Spreadsheets

Homebrewing Spreadsheets – Brewing Spreadsheet, Brew in a Bag, Small Batch & Hard Seltzer

homebrewing spreadsheets

Homebrew recipe and brew day software can be handy.  Something like BeerSmith or Brewfather – Free Non-Expiring Brewfather Trial Account – can be invaluable for creating recipes, figuring SRM, figuring IBUs, fitting beers into established styles and lots more.  Some are BeerSmith power users and track every recipe and every brew day in this great software.

Sometimes you just want to brew.  It’s a recipe that you’ve brewed before, something you’re putting together on the fly, or you just want something quick and easy to tell you temperatures and volumes.  Even though I have and use recipe software, I just find it easier to use brew day spreadsheets to track each individual beer.  I’ve developed three that I use in different situations.

Get the Spreadsheets

BIAB Brew Day Spreadsheet – Water Calculations + Narrative Step by Step Directions

biab homebrew spreadsheet

Why BIAB?

Brew in a Bag (BIAB) is a quick, easy and economical way to brew all grain batches of beer.  I released my brew day spreadsheet some time ago along with a version of that to be used for small batch beers.  See below for links.  Either of those could be modified to work with BIAB by changing variables,  This version is specifically designed for full size BIAB batches.

Main Page (click to enlarge):

homebrew brew in a bag biab spreadsheet

Related:

Bellamei Brew Bags...image
Bellamei Brew Bags Extra Large Reusable 2 Pack 250 Micron Fine Mesh Bag for Fruit Cider Apple Grape Wine Press Drawstring Straining Brew in a Bag (2 pack-22"×26")
$7.99 -$5.15 $2.84
Jillmo Brew Bag,...image
Jillmo Brew Bag, Extra Large (31”X22”) Reusable Brew in a Bag, 2 Pack, New Version
$9.99
Brew Bag, 26
Brew Bag, 26" x 22", 2 Pack, 100% Unbleached Cotton Bag for Homebrewing, Fine Cheesecloth Bag for Fruit/Cider/Wine/Beer, Reusable Drawstring Straining
$12.95
Hobby Homebrew MESH...image
Hobby Homebrew MESH GRAIN BAG BIAB Brew-in-A-Bag Grain Mash Straining Bag with Handles (27.5 x 32.5 in) BAG29 Size HUGE From KegLand fits 10 Gallon Igloo Water Cooler
$23.94

Need More?

My brew day spreadsheet helps you calculate water volumes and temps and helps you do simple tracking.

If you’re looking for a powerful, full featured solution for building recipes, brew day tracking and loads more, consider Brewfather.

How I Use Brew Day Spreadsheets

How do I use brew day spreadsheets?  First, I do use recipe formulation software.  Some of those programs have brew day components.  I’ve just never gotten into using those features.  For better or worse, I use a spreadsheet.  I make a copy and name it using the batch number and beer name and then quickly plug in the basics.  This creates a one sheet printable page that I can use on brew day.  That gives me a single piece of paper with all of my numbers and a spot for brew day notes.  Notes can go back into the spreadsheet for archival.

Continue reading →

My Brewing Spreadsheet

homebrew spreadsheet

My Brew Day Spreadsheet!

The spreadsheet is setup from my perspective, as a batch sparger.  Having said that, almost everything applies equally to a fly sparger with the possible exceptions of the computed mash ratio (more below), planning on a set volume of sparge water and the step by step batch sparge directions.

img_brewday

 This is the main sheet where you will fill in information about your beer and your mash parameters.  Click to enlarge.

Need More?

My brew day spreadsheet helps you calculate water volumes and temps and helps you do simple tracking.

If you’re looking for a powerful, full featured solution for building recipes, brew day tracking and loads more, consider Brewfather.

Continue reading →

Small Batch, All Grain Stove Top Brewing + Water Calculation Spreadsheet

small batch homebrew

I periodically brew small (1-3) gallon all grain batches of beer on my stove top.  Some reasons I do that… 1.  The weather – it’s too cold, too hot or too something else, 2.  Time or 3.  I want to test something.  It’s a fun, simple, quick and economical way to brew all grain with minimal investment.

For the extract brewer, what kind of gear is needed to accomplish this amazing feat?  A comprehensive list follows…

Continue reading →