Category Archives: Spreadsheets

Step by Step Small Batch, All Grain Stove Top Brewing! + Limited Time Deal on 3 Gallon Fermonsters!

small batch homebrew

Updated: February 12, 2025

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.


Limited Time DEAL (2/12/25 only) – 3 Gallon Fermonster for $23.99

3 Gallon Ported FerMonster Large Mouth Fermenter from MoreBeer

More Info

From the product description, check product page for current description, price and availability:

The Fermonster is a brand new fermenter designed specifically for fermentation. MoreBeer! gave product feedback for over 2 years of development and we think they nailed the design. The large lid allows for easy filling and makes hop or oak additions a breeze. The smooth sides are fantastic for sanitization – no ribs or texture to collect yeast or bacteria. The punted bottom allows sediment to collect to the sides so that you can siphon liquid from the center. Because they are made from vigin PET plastic, they’re nearly unbreakable and a lot safer than similar glass carboys. Also notice the conical top which reduces surface area if you plan to store beer or wine long term.

  • 4″ inner diameter wide mouth carboy – easy to clean!
  • Food grade PET plastic construction is nearly impermeable to oxygen penetration
  • No hard to clean dimples or ribs
  • Punted bottom
  • O-Ring and Lid with one hole is included (Fits #10 Stopper)
  • Additional O-Rings and Lids available
  • Weight: 1.5 lbs
  • Temperature Limit: 140° F
  • Height: 14.6 inches
  • Diameter: 9 inches
  • Completely taste and odor free
  • Perfect for Beer, Wine, Cider, Mead, Kombucha or any other fermented beverage!

 

Limited Availability Deal of the Day: As of this posting, this on sale as as a MoreBeer Deal of the DayShipping is also free to addresses in the contiguous US with most $59 Orders. Availability: This is available today only, while supplies last. Quantities are limited. Check the MoreBeer’s Deal of the Day to check today’s offering.

Product Description – Here – Use coupon code BEERDEAL to get this discount.

FerMonster 3 Gallon Ported Carboy With Spigot FE260


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 BrewfatherFree 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

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:


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

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 BrewfatherFree 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:


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

Updated: February 12, 2025

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.


Limited Time DEAL (2/12/25 only) – 3 Gallon Fermonster for $23.99

3 Gallon Ported FerMonster Large Mouth Fermenter from MoreBeer

More Info

From the product description, check product page for current description, price and availability:

The Fermonster is a brand new fermenter designed specifically for fermentation. MoreBeer! gave product feedback for over 2 years of development and we think they nailed the design. The large lid allows for easy filling and makes hop or oak additions a breeze. The smooth sides are fantastic for sanitization – no ribs or texture to collect yeast or bacteria. The punted bottom allows sediment to collect to the sides so that you can siphon liquid from the center. Because they are made from vigin PET plastic, they’re nearly unbreakable and a lot safer than similar glass carboys. Also notice the conical top which reduces surface area if you plan to store beer or wine long term.

  • 4″ inner diameter wide mouth carboy – easy to clean!
  • Food grade PET plastic construction is nearly impermeable to oxygen penetration
  • No hard to clean dimples or ribs
  • Punted bottom
  • O-Ring and Lid with one hole is included (Fits #10 Stopper)
  • Additional O-Rings and Lids available
  • Weight: 1.5 lbs
  • Temperature Limit: 140° F
  • Height: 14.6 inches
  • Diameter: 9 inches
  • Completely taste and odor free
  • Perfect for Beer, Wine, Cider, Mead, Kombucha or any other fermented beverage!

 

Limited Availability Deal of the Day: As of this posting, this on sale as as a MoreBeer Deal of the DayShipping is also free to addresses in the contiguous US with most $59 Orders. Availability: This is available today only, while supplies last. Quantities are limited. Check the MoreBeer’s Deal of the Day to check today’s offering.

Product Description – Here – Use coupon code BEERDEAL to get this discount.

FerMonster 3 Gallon Ported Carboy With Spigot FE260


Continue reading