CP's Brew Workbook

Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum

Help Support Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.

CPooley4

Well-Known Member
Joined
Apr 14, 2009
Messages
393
Reaction score
22
Location
Cottage Grove
CP's Brew Workbook

Hello All,

Recently finished an update to my Brew Workbook. I published a few earlier versions as well here. It's a free download (yes, free as in no money out of your pocket). Much of the upgrades over previous versions were to automate as much as possible for the user. I'm sure something else could be automated, but I couldn't find anything. Ultimately this workbook should cover just about anything and everything you'll need for all grain batch sparge brewing.

The brewday tab was updated fairly extensively. Two of my favorite upgrades were:

1. Volume calculator. You know longer need to measure the volume based upon markings on your kettle. Just input the equipment specs and measure the height of the liquid volume in your kettle and the volume calculates for you.

2. Gravity adjustment calculator. No more looking in your book/notes for gravity adjustments. Just plug in the measured gravity and the temperature measured at and the actual gravity calculates for you.

Please don't hesitate to ask questions and offer feedback. Much of the improvements over previous versions were a direct result of user feedback here. It's appreciated and certainly helpful as I don't think this project would be where it is today without it.

For those that have not used this in the past, here is a brief description of what you'd find if you download:

This workbook allows you to design your beers and take them from the recipe design stage all the way to first taste while giving you the ability to do things optimally to produce the best beer you can. Each tab contains how to information based upon best practices found within the homebrewing community. You should find everything easy to use, automated where possible, and designed to help you concentrate on brewing and brewing well rather than math. If you use the Brewday tab properly it will do all the brewday math for you so you can just concentrate on your process and measurements. You will be able to track everything you need to track in order to replicate or troubleshoot the beer in the future.

There is a screen shot of the Recipe Sheet tab below where you would plan the beer you want to brew. Each ingredient on the right hand side can be scrolled over and a window with a description of the ingredient and info on how to best use will pop up. There are also tabs for Brewday, Water Profile, Color, Yeast Pitch, Bottling/Kegging, Cost Analysis, BJCP Guidelines, Designing Beers, List/Specs, and Instructions. I can post more screen shots if anyone is interested.


Hope you enjoy it.

cp

CP's Brew Workbook.jpg
 
This thing is amazing. I've been using it since v 2.0 for all my brews. Keep up the good work. The only recommendation I have is to carry over more info from the main tab into the brewday. For example, the hop schedule shouldn't be different so it would be useful to just carry that information over.
 
CP's Brew Workbook

Hello All,

Recently finished an update to my Brew Workbook. I published a few earlier versions as well here. It's a free download (yes, free as in no money out of your pocket). Much of the upgrades over previous versions were to automate as much as possible for the user. I'm sure something else could be automated, but I couldn't find anything. Ultimately this workbook should cover just about anything and everything you'll need for all grain batch sparge brewing.

The brewday tab was updated fairly extensively. Two of my favorite upgrades were:

1. Volume calculator. You know longer need to measure the volume based upon markings on your kettle. Just input the equipment specs and measure the height of the liquid volume in your kettle and the volume calculates for you.

2. Gravity adjustment calculator. No more looking in your book/notes for gravity adjustments. Just plug in the measured gravity and the temperature measured at and the actual gravity calculates for you.

Please don't hesitate to ask questions and offer feedback. Much of the improvements over previous versions were a direct result of user feedback here. It's appreciated and certainly helpful as I don't think this project would be where it is today without it.

For those that have not used this in the past, here is a brief description of what you'd find if you download:

This workbook allows you to design your beers and take them from the recipe design stage all the way to first taste while giving you the ability to do things optimally to produce the best beer you can. Each tab contains how to information based upon best practices found within the homebrewing community. You should find everything easy to use, automated where possible, and designed to help you concentrate on brewing and brewing well rather than math. If you use the Brewday tab properly it will do all the brewday math for you so you can just concentrate on your process and measurements. You will be able to track everything you need to track in order to replicate or troubleshoot the beer in the future.

There is a screen shot of the Recipe Sheet tab below where you would plan the beer you want to brew. Each ingredient on the right hand side can be scrolled over and a window with a description of the ingredient and info on how to best use will pop up. There are also tabs for Brewday, Water Profile, Color, Yeast Pitch, Bottling/Kegging, Cost Analysis, BJCP Guidelines, Designing Beers, List/Specs, and Instructions. I can post more screen shots if anyone is interested.


Hope you enjoy it.

cp

Wow. I use BeerSmith and I've also done a lot of my own fairly complex spreadsheets. I just wanted you to know (after using your spreadsheet for a few minutes) that it is really nicely done!
 
Hello All - First, thanks for the comments. Sorry, I just saw this thread popped back up. The link currently may not be working. It's an older version now than what I'm currently working on and they may expire the document after a certain timeframe. Have been away from it for a while due to a move and building a new home. Will be a few months probably before I finalize this newer version.

For anyone interested in obtaining a copy please feel free to pm me. I can email you a copy of the unfinished update. It's fully operational with some updates over the past version. Will be updating a few other items before I post a link to it. With life being a bit busy right now it's going to be a little while.

Thanks,

cp
 
Back
Top