Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > Brewing Software > CP's Brew Chart 2.0
Reply
 
LinkBack Thread Tools
Old 01-28-2011, 02:56 AM   #1
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default CP's Brew Chart 2.0

http://rapidshare.com/files/445323364/CP_s_Brew_Chart.xls
This is a pretty extensive upgrade to my previous version. If you are considering buying brew software I would recommend downloading this first to see if you really need to spend that money. You should find that this will allow you to:

1. Design recipes with just about all ingredients at your finger tips. Each of those ingredients has detailed info as to their profile and how to use. Just scroll over any of them to see the information.
2. Your brewday is made much easier as well. The brewday section takes care of all the math for you. All you need to do is concentrate on your brewing and make sure to input the necessary information to the chart. It will calculate your expected OG post boil and make recommendations on what you can do to hit your target gravity if your expected gravity is off. You'll also be able to make hop schedule adjustments prior to boiling as well based upon the wort you've got on brewday.
3. Use TH's ez water calc along with ajdelange's water profile recommendations.
4. The yeast pitch tab gives you detailed information on the amount of cells you need for the beer you're making. Let's you know how to get there with liquid yeast or how many packets of dry yeast you'll need. Very similar to Mr. Malty.
5. Very detailed bottle priming calculator with recommended carb levels for each style of beer.
6. BJCP guidelines tab has all of the style guidelines at your finger tips.
7. Designing beers tab is an idea I have as well. I have one beer style there at this time. Want to see what people think. Info was primarily from Ray Daniel's Designing Great Beers book along with some other sources.

All told I wanted to have something that allowed me to design a recipe with all necessary information to do so right in front of me. Got tired of sitting at a table with books, guidelines, etc... all over the place. This allows me to do that. Also wanted to have something that I could take from recipe design all the way to first taste while tracking all the details. This allows you to do just that as well.

I use this for every beer I make. I created a brew folder and have a folder within that folder for each style of beer that I brew (APA, Porter, Kolsch, etc...). You would do a "save as" for each beer and save it in that styles folder. That allows me to have a record of every beer I brew while still having the original program for a new beer.

I have a couple of other ideas for down the road as well. Tab for keeping track of your ingredient inventory, kegging how to/pressure calculator, etc... If there is something that you feel would be a good addition please don't hesitate to say so. I'll also be working on getting this converted to a google doc as well. For some reason it will not map correctly, but I'll get it figured out.

Hope you enjoy 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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 03:21 AM   #2
JBrady
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2007
Location: Panama City, FL, Florida
Posts: 961
Liked 4 Times on 3 Posts

Default

Quote:
Originally Posted by CPooley4 View Post
http://rapidshare.com/files/44491979...Brew_Chart.xls

This is a pretty extensive upgrade to my previous version. If you are considering buying brew software I would recommend downloading this first to see if you really need to spend that money. You should find that this will allow you to:

1. Design recipes with just about all ingredients at your finger tips. Each of those ingredients has detailed info as to their profile and how to use. Just scroll over any of them to see the information.
2. Your brewday is made much easier as well. The brewday section takes care of all the math for you. All you need to do is concentrate on your brewing and make sure to input the necessary information to the chart. It will calculate your expected OG post boil and make recommendations on what you can do to hit your target gravity if your expected gravity is off. You'll also be able to make hop schedule adjustments prior to boiling as well based upon the wort you've got on brewday.
3. The yeast pitch tab gives you detailed information on the amount of cells you need for the beer you're making. Let's you know how to get there with liquid yeast or how many packets of dry yeast you'll need. Very similar to Mr. Malty.
4. Very detailed bottle priming calculator with recommended carb levels for each style of beer.
5. BJCP guidelines tab has all of the style guidelines at your finger tips.
6. Designing beers tab is an idea I have as well. I have one beer style there at this time. Want to see what people think. Info was primarily from Ray Daniel's Designing Great Beers book along with some other sources.

All told I wanted to have something that allowed me to design a recipe with all necessary information to do so right in front of me. Got tired of sitting at a table with books, guidelines, etc... all over the place. This allows me to do that. Also wanted to have something that I could take from recipe design all the way to first taste while tracking all the details. This allows you to do just that as well.

I use this for every beer I make. I created a brew folder and have a folder within that folder for each style of beer that I brew (APA, Porter, Kolsch, etc...). You would do a "save as" for each beer and save it in that styles folder. That allows me to have a record of every beer I brew while still having the original program for a new beer.

I have a couple of other ideas for down the road as well. Tab for keeping track of your ingredient inventory, kegging how to/pressure calculator, etc... If there is something that you feel would be a good addition please don't hesitate to say so. I'll also be working on getting this converted to a google doc as well. For some reason it will not map correctly, but I'll get it figured out.

Hope you enjoy it.

cp
How do I add my own grains into this, I'm spreadsheet illiterate.
__________________
Primary: Empty

Bottled: Janet's Brown, Session Dry Stout, Yellow Fly Cream Ale

Gallons Brewed In 2011-40
JBrady is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 03:28 AM   #3
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

Are you talking about adding grains to design a recipe (left hand side) or changing the grains on the right hand side to other grains?

If you look at the bottom of the first page you'll see instructions. Basically under the ingredients area you are going to add each malt you're using, input the amount you're using, the max gravity points from that grain, and the color.

Anywhere you see a blank cell you more than likely need to input information. Let me know if you still have any issues. It's quite simple once you figure out how to use 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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:10 AM   #4
JBrady
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2007
Location: Panama City, FL, Florida
Posts: 961
Liked 4 Times on 3 Posts

Default

Quote:
Originally Posted by CPooley4 View Post
Are you talking about adding grains to design a recipe (left hand side) or changing the grains on the right hand side to other grains?

If you look at the bottom of the first page you'll see instructions. Basically under the ingredients area you are going to add each malt you're using, input the amount you're using, the max gravity points from that grain, and the color.

Anywhere you see a blank cell you more than likely need to input information. Let me know if you still have any issues. It's quite simple once you figure out how to use it.

cp
i want to learn how to add manufactuer specific malts like fawcett halcyon to your list of malts if possible, if not how do I just use the malt in specific recipes using all the statistics from the particular grain. thanks and good work.
__________________
Primary: Empty

Bottled: Janet's Brown, Session Dry Stout, Yellow Fly Cream Ale

Gallons Brewed In 2011-40
JBrady is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:21 AM   #5
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

You could just use the malt as an ingredient for a recipe. Just type in the name, amount you are using, potential yield/max grav points, and color.

It's not setup to modify the malts/fermentables on the right hand side. It's protected so you don't accidentally delete something. Pm me your email address and I can send you a copy with that section unprotected so you can delete one of the malts and add the one you want to add.

If you have other questions just let me know.

__________________
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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:30 AM   #6
JBrady
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2007
Location: Panama City, FL, Florida
Posts: 961
Liked 4 Times on 3 Posts

Default

Quote:
Originally Posted by CPooley4 View Post
You could just use the malt as an ingredient for a recipe. Just type in the name, amount you are using, potential yield/max grav points, and color.

It's not setup to modify the malts/fermentables on the right hand side. It's protected so you don't accidentally delete something. Pm me your email address and I can send you a copy with that section unprotected so you can delete one of the malts and add the one you want to add.

If you have other questions just let me know.
Thanks CP, I'll just add them in each recipe, thats easy enough. I'm not skilled enough with spreadsheet formulas too start modifying such a amazing piece of work. Thanks for the great tool.
__________________
Primary: Empty

Bottled: Janet's Brown, Session Dry Stout, Yellow Fly Cream Ale

Gallons Brewed In 2011-40
JBrady is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:38 AM   #7
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

No problem. If we want to come up with a list of ingredients that people would like to see added that would be cool. Whether it's a malt, hop, or yeast I can more than likely get it added pretty easily for the next release.

__________________
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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:44 AM   #8
JBrady
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2007
Location: Panama City, FL, Florida
Posts: 961
Liked 4 Times on 3 Posts

Default

Quote:
Originally Posted by CPooley4 View Post
No problem. If we want to come up with a list of ingredients that people would like to see added that would be cool. Whether it's a malt, hop, or yeast I can more than likely get it added pretty easily for the next release.
It would be a pretty big list if you start getting into all the manufactuer specific stuff. I think it might be best to leave it like you have it with mostly generic commonly used types.
__________________
Primary: Empty

Bottled: Janet's Brown, Session Dry Stout, Yellow Fly Cream Ale

Gallons Brewed In 2011-40
JBrady is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 01:15 PM   #9
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

Probably right JBrady.

If you have any other questions etc... just 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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 01-30-2011, 05:28 PM   #10
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

There were two cells in the brewday section that were locked mistakenly. If you have downloaded the Brew Chart please re-download here:

http://rapidshare.com/files/445323364/CP_s_Brew_Chart.xls
I gave it a test run with an American IPA recipe last night and it worked just as intended. Will make your brewing and brewday a little easier if you let it.

Hope you're enjoying 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!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Reply



Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
CP's Brew Chart 1.1 CPooley4 Brewing Software 3 05-16-2012 03:18 PM
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



Newest Threads

LATEST SPONSOR DEALS