CP's Brew Chart 3.0 - Page 3 - Home Brew Forums

 Home Brew Forums > CP's Brew Chart 3.0

02-16-2011, 10:34 PM   #21
CPooley4
Recipes

Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 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
Recipes

Jan 2011
Charlottetown, PEI
Posts: 15

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
Recipes

Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 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:

Ken Schwartz - http://home.roadrunner.com/~brewbeer.../nbsparge.html
Kai - http://braukaiser.com/wiki/index.php...rging_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
Recipes

Mar 2010
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
Recipes

Apr 2009
Cottage Grove, Wisconsin
Posts: 393
Liked 14 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
Recipes

Sep 2007
In front of my computer in Hammond IN
Posts: 201
Liked 10 Times on 8 Posts

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

Recipes

May 2008
Posts: 1,218
Liked 79 Times on 63 Posts

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

02-17-2011, 01:33 PM   #28
millstone
Recipes

Sep 2007
In front of my computer in Hammond IN
Posts: 201
Liked 10 Times on 8 Posts

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

Recipes

May 2008
Posts: 1,218
Liked 79 Times on 63 Posts

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

02-17-2011, 02:11 PM   #30
chaserchap

Recipes

Feb 2011
Charleston, SC
Posts: 182
Liked 6 Times on 6 Posts

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