Rebel Brewer Giveaway!
 Home Brew Forums > CP's Brew Chart 3.0

02-16-2011, 10:34 PM   #21
CPooley4
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 12 Times on 8 Posts

Not a problem Tim. I appreciate it.

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!

02-16-2011, 11:09 PM   #22
hogie1980
Feedback Score: 0 reviews
Recipes

Join Date: Jan 2011
Location: Charlottetown, PEI
Posts: 13

Thanks for telling me about this in my other post. Trying it out now and I have a few questions... What is the water to grain ratio it's using? Does it assume a 10% absorption? Is it possible to unprotect the Strike temp because I was planning on 170F?

__________________

02-17-2011, 01:13 AM   #23
CPooley4
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 12 Times on 8 Posts

Quote:
 Originally Posted by hogie1980 Thanks for telling me about this in my other post. Trying it out now and I have a few questions... What is the water to grain ratio it's using? Does it assume a 10% absorption? Is it possible to unprotect the Strike temp because I was planning on 170F?
No problem.

The water to grain ratio is a calculation designed so that you will obtain half of your boil volume from your mash and the other half from your sparge. The number you see in the cell is in gallons. To convert it to quarts you would multiply by 4. My work in this area of the brew chart was based on the work/research of Ken Schwartz and Kai at braukaiser.com Their work/research on batch sparge brewing shows that our best efficiency is obtained this way. You can read more about this at:

Kai - http://braukaiser.com/wiki/index.php/Batch_Sparging_Analysis

It assumes an absorption of .125 gallons per pound of grain.

If you go to the brewday tab you'll see the brewer schedule as well. This details my process which may be of some help. You can of course re-write that if you'd like as well.

If you have any further questions please don't hesitate to ask. Appreciate any feedback as it allows me to keep improving this thing. The last time I posted a version there was some great feedback which propelled it to where it is now. It's essentially turned into a homebrewtalk thing and not just my thing which is pretty cool.

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!

02-17-2011, 02:23 AM   #24
Jrome
Feedback Score: 0 reviews
Recipes

Join Date: Mar 2010
Location: Trenton, NJ
Posts: 17

Hey CP,
So I used your 2.0 version for a tripel I brewed and everything went great! Volumes spot on, temps spot on, it was probably my most successful brew day to date.

My only question is regarding the mash ratio. While the 50% mash 50% sparge worked well for me when I tried it, I can't help but wonder why almost everything I've read has the mash at 1.25 q/lbs or something along those lines.

Are there any foreseeable drawbacks to mashing in with so much water?

__________________

02-17-2011, 02:41 AM   #25
CPooley4
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 12 Times on 8 Posts

That's great to hear. The whole purpose of this project was to help not only myself on brewdays, but whomever else I could as well. Make sure to download version 3.0 and transfer your brews to it. It's quite an upgrade over 2.0.

I'm not aware of any drawbacks. If there are any I'd like to see the research behind it. Kai has done great research over at www.braukaiser.com. It's really great stuff if you get a chance to review it. Covers most everything you'd like covered on batch sparging.

1.25 q/lbs is perfectly fine as well. However, it's not going to get you 50/50 on your runnings. Plenty of ways to brew with even more opinions out there on how to do it. I've chosen to base my work on the best info/research I could find out there. It works great for me and many others. My opinion is if I'm going to spend all this time brewing I want to do things optimally as it should lead to the best product I can produce. I hope that others find this tool pushing/leading them towards producing a better product as well.

If you have other questions etc... please don't hesitate to let me know.

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!

02-17-2011, 01:17 PM   #26
millstone
Feedback Score: 0 reviews
Recipes

Join Date: Sep 2007
Location: In front of my computer in Hammond IN
Posts: 128
Liked 1 Times on 1 Posts
Likes Given: 2

Quote:
 Originally Posted by MX1 Tom, Have you tried converting this to Numbers, and if so, have you found any issues yet?
If you mean did I try putting a number in the cell just to the right of the radio buttons, yes. I put in number 1 for the Bicarbonate radio button, number 2 for the Alkalinity button and a 0 for no radio button. Also, selecting either of the radio buttons using a MAC worked also.

tom
__________________

02-17-2011, 01:19 PM   #27
MX1
Feedback Score: 0 reviews
Recipes

Join Date: May 2008
Posts: 700
Liked 22 Times on 17 Posts
Likes Given: 41

Quote:
 Originally Posted by millstone If you mean did I try putting a number in the cell just to the right of the radio buttons, yes. I put in number 1 for the Bicarbonate radio button, number 2 for the Alkalinity button and a 0 for no radio button. Also, selecting either of the radio buttons using a MAC worked also. tom
No, what I was asking is have you converted it from Excel to Numbers ( Mac's spreadsheet program)
__________________

"The ART of brewing Beer, is the ACT of brewing Beer"

Next: New Brewery Under Construction
Primary:
Storing:
Serving:

02-17-2011, 01:33 PM   #28
millstone
Feedback Score: 0 reviews
Recipes

Join Date: Sep 2007
Location: In front of my computer in Hammond IN
Posts: 128
Liked 1 Times on 1 Posts
Likes Given: 2

Quote:
 Originally Posted by MX1 No, what I was asking is have you converted it from Excel to Numbers ( Mac's spreadsheet program)
No, I don't have iWork on my MAC

tom
__________________

02-17-2011, 01:36 PM   #29
MX1
Feedback Score: 0 reviews
Recipes

Join Date: May 2008
Posts: 700
Liked 22 Times on 17 Posts
Likes Given: 41

Quote:
 Originally Posted by millstone No, I don't have iWork on my MAC tom
ahh ok then.

Tim
__________________

"The ART of brewing Beer, is the ACT of brewing Beer"

Next: New Brewery Under Construction
Primary:
Storing:
Serving:

02-17-2011, 02:11 PM   #30
chaserchap
Feedback Score: 0 reviews
Recipes

Join Date: Feb 2011
Location: Charleston, SC
Posts: 194
Liked 6 Times on 6 Posts

Does this support partial boils and partial extracts? Couldn't change boil size.

__________________