CP's Brew Chart 3.0 - Page 4 - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Brewing Software > CP's Brew Chart 3.0

Reply
 
Thread Tools
Old 02-18-2011, 01:01 AM   #31
CPooley4
Recipes 
 
Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts


Quote:
Originally Posted by chaserchap View Post
Does this support partial boils and partial extracts? Couldn't change boil size.
Not really. It's set up for full boil batch sparge brewing. You could probably finagle it to work somehow, but it wouldn't be optimal. I've personally never brewed with partial boils or partial extracts.

I'd be willing to put in the time to convert this to that type of setup if there are enough people interested. Could have two spreadsheets - the original and a partial boil/extract version. I don't think it would take all that much to do so.

cp
__________________
CP's Brew Workbook

If you're considering buying brewing software do yourself a favor and download my Brew Chart/Workbook first. You may not need to spend that money.

I like beer math!

 
Reply With Quote
Old 02-18-2011, 01:39 AM   #32
chaserchap
 
chaserchap's Avatar
Recipes 
 
Feb 2011
Charleston, SC
Posts: 182
Liked 6 Times on 6 Posts


I'd definitely like it, but don't base your decision on me alone. I don't have the setup or the space for anything but extract/partial...one day I'll get into big boy brewing.

 
Reply With Quote
Old 02-19-2011, 02:26 AM   #33
BrotherFreeman
Recipes 
 
Jan 2011
Oxnard, CA
Posts: 57
Liked 1 Times on 1 Posts


Quick question. On the Recipe Sheet, there is a box for yeast. Is this cell dynamic in anyway? Will it affect calculations elsewhere in the spreadsheet? Also, the mash ratio seems to be off (low). Once I input the ingredients, it reads of a ratio of .241. Mash Volume and and Sparge volume seem to be accurate but I would like to have a better idea of my ratio. Maybe its just me being lazy not wanting to do the math on the side =]

 
Reply With Quote
Old 02-19-2011, 03:56 AM   #34
CPooley4
Recipes 
 
Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts


Quote:
Originally Posted by BrotherFreeman View Post
Quick question. On the Recipe Sheet, there is a box for yeast. Is this cell dynamic in anyway? Will it affect calculations elsewhere in the spreadsheet? Also, the mash ratio seems to be off (low). Once I input the ingredients, it reads of a ratio of .241. Mash Volume and and Sparge volume seem to be accurate but I would like to have a better idea of my ratio. Maybe its just me being lazy not wanting to do the math on the side =]
No, the yeast cell is just your yeast choice.

Can you post your recipe? I'll have a better chance to answer your question that way. The mash ratio cell is in gallons per lb of grain so just multiply it by 4 to get quarts per lb. Though your ratio seems low regardless so I'd like to better understand your recipe if possible. Just list the amount of grains and the batch/boil size and I should be able to take it from there.
__________________
CP's Brew Workbook

If you're considering buying brewing software do yourself a favor and download my Brew Chart/Workbook first. You may not need to spend that money.

I like beer math!

 
Reply With Quote
Old 02-19-2011, 10:06 PM   #35
Jrome
Recipes 
 
Mar 2010
Trenton, NJ
Posts: 17

So I've come to my conclusion:

I love this spreadsheet. For me, it beats the brewing software by leaps and bounds. It's simple, easy, comprehensive and free; what else is there to ask for?

CP thanks for making this available, I am definitely a convert. Two brews down, all of the calc's were spot on.

If you are thinking about getting some brewing software, do yourself a favor, try this first!

 
Reply With Quote
Old 02-19-2011, 10:31 PM   #36
CPooley4
Recipes 
 
Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts


Thanks Jrome, I really appreciate it. It's been a lot of work, but also very worthwhile and enjoyable work.

If you end up with any questions or ideas for improvement please don't hesitate to post them. I'd like/intend to keep developing this for the board.

cp
__________________
CP's Brew Workbook

If you're considering buying brewing software do yourself a favor and download my Brew Chart/Workbook first. You may not need to spend that money.

I like beer math!

 
Reply With Quote
Old 02-20-2011, 09:13 AM   #37
MX1
HBT_SUPPORTER.png
 
MX1's Avatar
Recipes 
 
May 2008
Colorado Springs, CO
Posts: 1,216
Liked 79 Times on 63 Posts


Said it before, and I will say it again....

This Brew Sheet is Rock Star Silly.....

Now, if I can only learn the fundamentals of Mash water, I can put one more part of it to use.

Tim
__________________
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

 
Reply With Quote
Old 02-20-2011, 06:05 PM   #38
havadog
Recipes 
 
Feb 2010
philadelphia
Posts: 5

Hey CP - thanks for the spreadsheet. Couple suggestions (some easy, some probably less so). 1st - it would be really nice if the cells in which user inputs are needed are highlighted a different color than the non-modifiable cells. 2nd - would be nice to have an option of doing a mash out prior to 1st runnings to increase efficiency. Finally, being able to print out a brew-day action plan would be awesome. As it stands, it is necessary to flip back and forth between the recipe sheet and brewday sheet to determine mash volume and temperatures. Anyway, really great stuff, so thanks!

 
Reply With Quote
Old 02-20-2011, 07:01 PM   #39
Brewenstein
Recipes 
 
Apr 2009
West Suburbs of Chicago
Posts: 674
Liked 99 Times on 74 Posts


CP,

I just downloaded this and began playing with it. I usually do 6 gallon batches with 7 gallons to start. The boil size cell is locked. Does it matter?

EDIT: Nevermind. I just figured out that when I added my boil off, it adjusted the pre-boil volume

Reason: I am an idiot.

 
Reply With Quote
Old 02-20-2011, 11:39 PM   #40
CPooley4
Recipes 
 
Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts


Quote:
Originally Posted by havadog View Post
Hey CP - thanks for the spreadsheet. Couple suggestions (some easy, some probably less so). 1st - it would be really nice if the cells in which user inputs are needed are highlighted a different color than the non-modifiable cells. 2nd - would be nice to have an option of doing a mash out prior to 1st runnings to increase efficiency. Finally, being able to print out a brew-day action plan would be awesome. As it stands, it is necessary to flip back and forth between the recipe sheet and brewday sheet to determine mash volume and temperatures. Anyway, really great stuff, so thanks!
Thanks for the suggestions. I'll keep all of that in mind for the next release. If you think of anything else please don't hesitate to post.

cp
__________________
CP's Brew Workbook

If you're considering buying brewing software do yourself a favor and download my Brew Chart/Workbook first. You may not need to spend that money.

I like beer math!

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
CP's Brew Chart 1.1 CPooley4 Brewing Software 3 05-16-2012 02:18 PM
CP's Brew Chart 2.0 CPooley4 Brewing Software 15 02-10-2011 03:56 AM
CP's Brew Chart 1.1 **Updated** CPooley4 Brewing Software 0 12-30-2010 01:53 AM
CP's Brew Chart 1.0 CPooley4 Brewing Software 2 12-26-2010 08:34 PM


Forum Jump