Kegconnection Complete Starter Kit and More Giveaway!


Home Brew Forums > Home Brewing Beer > General Beer Discussion > CP's Brew Chart 2.0

Reply
 
LinkBack Thread Tools
Old 01-28-2011, 01:54 AM   #1
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 13 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
Gavagai Likes This 
Reply With Quote Quick reply to this message
Old 01-28-2011, 02:10 AM   #2
BrokenDog
HBT_SUPPORTER.png
Feedback Score: 1 reviews
 
BrokenDog's Avatar
Recipes 
 
Join Date: Apr 2010
Location: St. Albans, VT
Posts: 266
Liked 11 Times on 10 Posts
Likes Given: 21

Default

I guess I'll have to check this out at home, the servers at work are currently blocking the link.

__________________
Broken Dog Brewing Est. 2010
I enjoy drinking beer
BrokenDog is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 03:21 AM   #3
PerpetualBuzz
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: Indian Land, South Carolina
Posts: 71
Likes Given: 3

Default

Just downloaded it. Looks like you went all out on this thing! Thanks!

Edit: Didn't see Magnum on the Hops list.

__________________

Last edited by PerpetualBuzz; 01-28-2011 at 03:57 AM. Reason: add suggestion
PerpetualBuzz is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 12:14 PM   #4
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 13 Times on 8 Posts

Default

Thanks PB, really appreciate it.

Magnum is under the Hallertauer cell. If you scroll over that cell you should be able to see it. Otherwise, right click on the cell and hit "show comment" and that will have the notes for that cell remain open so you can read it. When done just right click on the cell again and hit "hide comment".

If you have any other issues/questions 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-28-2011, 12:14 PM   #5
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 13 Times on 8 Posts

Default

Let me know what you think or if you have any questions once you've been able to view it Ato.

__________________
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 PM   #6
PerpetualBuzz
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: Indian Land, South Carolina
Posts: 71
Likes Given: 3

Default

Cool, I just missed it. It took me a couple of minutes to figure out what numbers to enter where, but after that I think this will be very useful. I was concerned about my next recipe, the grain bill seemed light, but after plugging things in and getting the numbers I feel ready to go!

__________________
PerpetualBuzz is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:27 PM   #7
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 13 Times on 8 Posts

Default

Great to hear PB.

If you have any further questions don't hesitate to ask. I tried to set it up as user friendly as possible while still allowing for control of aspects that you may not find in other programs (expected attenuation, adjusting potential yield/max gravity and color of each grain, etc...). It takes a bit to get used to it because of all the information/tabs, but once you get it you should find that it's very easy to use.

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:36 PM   #8
cactusgarrett
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2008
Location: Madison, WI
Posts: 984
Liked 7 Times on 5 Posts
Likes Given: 8

Default

Looks great. I get more than what i need from Beersmith, but I'm very curious as to how you're "on the fly" brewday calcs will work. I'm going to flex your spreadsheet's might compared to my Beersmith experience for my next batch.

__________________

~~ Malted barley wants to become beer. ~~

cactusgarrett is offline
 
Reply With Quote Quick reply to this message
Old 01-28-2011, 04:59 PM   #9
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 13 Times on 8 Posts

Default

Sounds good cactusgarrett. They better work, I've tested them too many times now and have worked great on all my recent brews.

Good luck and please let me know how it goes. If something is amiss I'll get it researched/corrected.

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-29-2011, 02:23 AM   #10
Beer_Guy
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2010
Location: Lubbock, TX
Posts: 622
Liked 3 Times on 3 Posts

Default

RapidShare says I need to be a RapidPro account. In other words it requires me to BUY your file.

You are getting a kick back, right?

__________________

“Anyone can drink beer, but it takes intelligence to enjoy beer.” — Stephen Beaumont

No more recipies for me. My beer MUST be mine.

Beer_Guy 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
Hop Chart boulong General Beer Discussion 15 04-07-2013 02:42 PM
Taste Chart aerod1 General Beer Discussion 2 08-28-2010 08:06 PM
Gravity Points Chart lostboysbrew General Beer Discussion 3 07-27-2010 05:27 PM
is there a chart to substitute hops agezzi General Beer Discussion 8 07-26-2010 10:30 PM
SRM color chart hammer one General Beer Discussion 4 11-28-2009 09:04 PM