Kegconnection Complete Starter Kit and More Giveaway!


Home Brew Forums > Home Brewing Beer > Brewing Software > Beer Line Length and Pressure Calculator

Reply
 
LinkBack Thread Tools
Old 08-02-2007, 04:18 AM   #1
Bearcat Brewmeister
Pour, Drink, Pee, Repeat
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Bearcat Brewmeister's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Cincinnati, OH
Posts: 699
Liked 18 Times on 7 Posts

Default Beer Line Length and Pressure Calculator

Just finished this one. It uses a few formulas found on the Internet to calculate the head loss for different types of beer line and shanks (or cobra tap). You enter the items at the top: beer style, temperature range you want to see, beer line inside diameter, shank bore, height from center of keg to tap, and distance from keg output to shank. The table will then show the range of CO2 volumes that are appropriate for the style selected across the top and temperature down the side. For each temperature/CO2 volume combination, a beer line length and properly balanced psi setting to carbonate the beer and push it through the given length beer line are displayed.

Let me know how it works for you and if you have any ideas for improvements.

Beer Line Length and Pressure Calculator

__________________
Kegged: Belgian Dark Strong, Robust Porter, Ryewine, Old Ale
Secondary:
Bock
Primary:
--
Next Up: Baltic Porter, Saison
Projects: Brutus Strut-stand, Freezer Conversion (Done), HERMS (Done), Lager Fermentation Mini-fridge Extension (Done)
Drinking: Great Lakes Edmund Fitzgerald, Fuller's 1845, Lakefront Fixed Gear, New Glarus Moon Man, Tröegs Troegenator
Bearcat Brewmeister is offline
2
People Like This 
Reply With Quote Quick reply to this message
Old 08-02-2007, 05:17 AM   #2
Drunkensatyr
Feedback Score: 0 reviews
 
Drunkensatyr's Avatar
Recipes 
 
Join Date: Apr 2007
Posts: 2,017
Liked 7 Times on 3 Posts

Default

Sorry, don't have excel otherwise I would love to give you feedback. Sounds like a great project though.

__________________
Drunkensatyr is offline
 
Reply With Quote Quick reply to this message
Old 08-02-2007, 01:05 PM   #3
homebrewer_99
Feedback Score: 0 reviews
 
homebrewer_99's Avatar
Recipes 
 
Join Date: Feb 2005
Location: Atkinson (near the Quad Cities), IL
Posts: 17,951
Liked 82 Times on 72 Posts
Likes Given: 1

Default

Whoa! That's one great spreadsheet!

I appreciate the time and effort you put into the formula's. I WILL be putting this to good use.

A MILLION Thanks!

__________________
HB Bill
homebrewer_99 is offline
 
Reply With Quote Quick reply to this message
Old 08-02-2007, 02:58 PM   #4
FlyGuy
Feedback Score: 0 reviews
 
FlyGuy's Avatar
Recipes 
 
Join Date: Jan 2007
Location: Calgary, Alberta
Posts: 3,618
Liked 127 Times on 40 Posts
Likes Given: 7

Default

Hey, that's a great tool. Nicely done!

FlyGuy is offline
 
Reply With Quote Quick reply to this message
Old 08-12-2007, 04:53 PM   #5
Thalon
Feedback Score: 0 reviews
 
Thalon's Avatar
Recipes 
 
Join Date: May 2007
Location: St. Louis Park, MN
Posts: 365
Default

This is a very nice tool, but I'm slightly confused on a couple of the settings. What exactly is Height from Keg Center to Tap? Is it from the pickup tube at the bottom center of the keg to the outlet of the keg, or something different? And what exactly is Distance from Beer Out Connector to Shank? The way it's worded it almost sounds like the length of beer line, but that's one of the outputs of the spreadsheet. Can someone maybe post a picture that can illustrate the distances? That would help a TON.

__________________
Thalon is offline
 
Reply With Quote Quick reply to this message
Old 08-14-2007, 02:43 AM   #6
Bearcat Brewmeister
Pour, Drink, Pee, Repeat
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Bearcat Brewmeister's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Cincinnati, OH
Posts: 699
Liked 18 Times on 7 Posts

Default

Height from keg center to tap is the height differential that the beer has to overcome on average to get from the keg to the tap (#1 in diagram). When the keg is full, it is from roughly the top of the keg to the tap. When it is just about empty, it is from the bottom of the keg to the tap. Using the center of the keg just averages the two scenarios of full keg and empty keg. Using this estimate is obviously off by the most when the keg is either full or almost empty, but beer only loses roughly 0.5 psi of pressure per foot it is moved against gravity. Since a keg is roughly 2 feet tall, measuring from the center makes you a half pound too much pressure when full and half pound too low when almost empty - not a big issue.

Distance from keg output to tap (#2) is there strictly as a constraint. Without it, the calculator could, given the right set of inputs, tell you to use 6 inches of line when the distance from your keg outlet to your tap is 12 inches. This can definitely be an issue with Brittish and Scottish beers that require low pressure but all you have is restrictive 3/16" line or if you have to have your beer line travel some horizontal distance.

__________________
Kegged: Belgian Dark Strong, Robust Porter, Ryewine, Old Ale
Secondary:
Bock
Primary:
--
Next Up: Baltic Porter, Saison
Projects: Brutus Strut-stand, Freezer Conversion (Done), HERMS (Done), Lager Fermentation Mini-fridge Extension (Done)
Drinking: Great Lakes Edmund Fitzgerald, Fuller's 1845, Lakefront Fixed Gear, New Glarus Moon Man, Tröegs Troegenator
Bearcat Brewmeister is offline
 
Reply With Quote Quick reply to this message
Old 08-14-2007, 03:12 AM   #7
Thalon
Feedback Score: 0 reviews
 
Thalon's Avatar
Recipes 
 
Join Date: May 2007
Location: St. Louis Park, MN
Posts: 365
Default

Perfect, that explains it. Thanks!

__________________
Thalon is offline
 
Reply With Quote Quick reply to this message
Old 02-03-2008, 03:44 AM   #8
dirtymartini
Feedback Score: 0 reviews
 
dirtymartini's Avatar
Recipes 
 
Join Date: Dec 2006
Location: Northeastern PA
Posts: 138
Default

Quote:
Originally Posted by Bearcat Brewmeister
Just finished this one. It uses a few formulas found on the Internet to calculate the head loss for different types of beer line and shanks (or cobra tap). You enter the items at the top: beer style, temperature range you want to see, beer line inside diameter, shank bore, height from center of keg to tap, and distance from keg output to shank. The table will then show the range of CO2 volumes that are appropriate for the style selected across the top and temperature down the side. For each temperature/CO2 volume combination, a beer line length and properly balanced psi setting to carbonate the beer and push it through the given length beer line are displayed.

Let me know how it works for you and if you have any ideas for improvements.

Beer Line Length and Pressure Calculator
Nevermind..
__________________
Up Next: ?
Primary: Secondary: Nut Brown Ale: Tap 1: Cream Stout :




Quote:
He brews beer AND is a pilot. There is no female on this planet that would tolerate both of those time- and money-consuming hobbies at once.

Last edited by dirtymartini; 02-03-2008 at 03:48 AM.
dirtymartini is offline
 
Reply With Quote Quick reply to this message
Old 04-09-2008, 02:24 AM   #9
McKBrew
Feedback Score: 0 reviews
 
McKBrew's Avatar
Recipes 
 
Join Date: Oct 2006
Location: Hayden, Idaho
Posts: 8,292
Liked 30 Times on 27 Posts
Likes Given: 8

Default

I am using your calculator for my set-up. Has everything I need in one spot.

__________________

Make Beer, Not War.

McKBrew is offline
 
Reply With Quote Quick reply to this message
Old 04-09-2008, 03:39 AM   #10
Bearcat Brewmeister
Pour, Drink, Pee, Repeat
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Bearcat Brewmeister's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Cincinnati, OH
Posts: 699
Liked 18 Times on 7 Posts

Default

Thanks for saying so. It hasn't failed me yet. A lot of folks use a set line length, then adjust pressure until it flows right. That is back asswards. You should set your pressure to the correct serving pressure for the beer style at the particular temperature you are at, then size your line (length AND diameter) to scrub off all of the excess pressure such that your beer flows correctly.

The other important thing is to make sure that the line feeds upward in all spots. The shanks tend to be warmer that the interior of the fridge, so the beer in contact with them when it is just sitting tends to warm and CO2 breaks out of solution. If the line feeds down to the shank, even a bit, the bubbles run back towards the keg. This causes a rush of beer, then foam, then beer, which ends up with a foamy glass.

__________________
Kegged: Belgian Dark Strong, Robust Porter, Ryewine, Old Ale
Secondary:
Bock
Primary:
--
Next Up: Baltic Porter, Saison
Projects: Brutus Strut-stand, Freezer Conversion (Done), HERMS (Done), Lager Fermentation Mini-fridge Extension (Done)
Drinking: Great Lakes Edmund Fitzgerald, Fuller's 1845, Lakefront Fixed Gear, New Glarus Moon Man, Tröegs Troegenator
Bearcat Brewmeister 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
Beer Line Length for Kegerator shot0rum247 DIY Projects 12 07-07-2014 05:49 PM
Question about beer line length GroosBrewz Bottling/Kegging 7 03-19-2009 07:40 PM
beer line length jonp9576 Bottling/Kegging 4 09-26-2008 07:59 PM
Longest Beer Line Length Acropolis Bottling/Kegging 13 03-22-2008 07:58 PM
Beer line length highwayman Bottling/Kegging 3 07-29-2006 04:35 AM