Kettle Volume calculator - Home Brew Forums

 Home Brew Forums > Kettle Volume calculator

04-13-2009, 12:35 AM   #1
nostalgia

Recipes

Feb 2008
Port Murray, NJ
Posts: 2,404
Liked 97 Times on 57 Posts

This is a calculator I made in Excel a while ago. I put it onto my website in case others find it useful. If you know the diameter of your brew kettle, and your kettle is cylindrical, you can use the calculator to convert between depth of the liquid and volume.

This lets you use a dipstick to figure out your volumes if you're not cool enough for a sight glass yet

Click and tell me what you think!

Eventually it'll store your kettle diameter in a cookie so you don't have to re-enter it every time you go to the site.

-Joe
__________________
I'm opening a brewery! Man Skirt Brewing

Progress is always up on my Facebook page

04-13-2009, 12:44 AM   #2
greencon
Recipes

Sep 2008
Farmington, MI
Posts: 57
Liked 2 Times on 2 Posts

__________________
Michigan Mashers HBT
Motor city Mashers
Primary:
Denny's Rye IPA
Northern Brewer IPA
Honkers Ale Clone
On Tap:
Auby American Wheat
Citra Plale Ale
Centennial Blonde

04-13-2009, 03:41 AM   #3
WheeledGoat
DisMember

Recipes

Sep 2008
Chicago, IL
Posts: 163
Liked 3 Times on 3 Posts

Prosted.

I feel like such a tool - why didn't I do this? I'm savvy with math and computers, yet it never occurred to me to work SMARTER instead of HARDER. I made an Excel graph where all my containers (MLT, 3, 9 and 15gal boilers, buckets, etc...) have it's own line, plotted against x=depth & y=gallons. I thought I was so smart doing this - all I have to do is dip a stick into any one of them and I can look on my chart to see the volume.

To get my data? I literally poured gallons of water from one to the next and took measurements, plugged the data into Excel and made the chart. How could I forget the wonders of pi? I'm such a dolt.

Nice work.
__________________
Primary: Imperial IPA, Biermuncher's OctoberFAST, Zombie Dust
Secondary: Caberlot (my first wine!)
Cold Crashing: Goat's Spare Tire
Kegged & On Tap: Bavarian Hefeweizen, 3-year aged Cider

Projects: The Ravens Keezer - Custom Gas System - 10gal MLT

04-13-2009, 05:41 AM   #4
TXCrash

Recipes

Sep 2005
Crazytown
Posts: 29,437
Liked 3414 Times on 3285 Posts

Might be a good idea to add a calculation for linearly changing radius's. Most kettles are smaller at the bottom than the top. Some may be tapered enough to have a significant effect on the volume.
__________________
Quote:
 Originally Posted by passedpawn You \$&\$&stik. You are my test. Part of it, anyway.

04-15-2009, 01:47 PM   #5
nostalgia

Recipes

Feb 2008
Port Murray, NJ
Posts: 2,404
Liked 97 Times on 57 Posts

Thanks for the feedback! I'll look into the changing radius thing.

Cookies should be working now, so your data will be saved. LMK if there are any other issues.

Thanks,

-Joe
__________________
I'm opening a brewery! Man Skirt Brewing

Progress is always up on my Facebook page

04-15-2009, 03:23 PM   #6
nostalgia

Recipes

Feb 2008
Port Murray, NJ
Posts: 2,404
Liked 97 Times on 57 Posts

One more update for y'all. The kettle calc now has separate boxes for volume and depth measurements, and the units have been made more flexible.

Have fun

-Joe
__________________
I'm opening a brewery! Man Skirt Brewing

Progress is always up on my Facebook page

04-18-2009, 02:50 PM   #7
Nikobrew

Recipes

Apr 2008
Posts: 643
Liked 42 Times on 37 Posts

Quote:
 Originally Posted by nostalgia One more update for y'all. The kettle calc now has separate boxes for volume and depth measurements, and the units have been made more flexible. Have fun -Joe
Awesome! Id I had this I wouldve NOT made a 7 gal batch with my first keggle run which was supposed to be 12 :P I'll definitely use this next go around especially since I plan on doing a 5 gallon batch in the keggle next.
__________________
Hops and other goodies for sale! Flat rate \$5 shipping store wide! So go ahead, throw in some more hops.. Why not? :P

http:/www.NikoBrew.com

"Samsonite, I was WAY off!" -- Lloyd Christmas

04-22-2009, 04:08 AM   #8
Q2XL

Recipes

Feb 2009
Eastpointe, Michigan
Posts: 509
Liked 3 Times on 3 Posts

Thanks!!! This is a big help!

08-05-2009, 03:27 AM   #9
nostalgia

Recipes

Feb 2008
Port Murray, NJ
Posts: 2,404
Liked 97 Times on 57 Posts

Hey guys, just wanted to let you know I just updated the calc to take thermal expansion into account. That way you can enter a hot volume and see what the depth will be cold and vise-versa. I was tired of multiplying by 0.04 or 0.96 to figure it out, so now you get both values whenever you do the calulation.

-Joe
__________________
I'm opening a brewery! Man Skirt Brewing

Progress is always up on my Facebook page

07-24-2011, 04:44 PM   #10
eh2010
Recipes

May 2011
Bay Shore, NY
Posts: 14

Quote:
 Originally Posted by nostalgia This is a calculator I made in Excel a while ago. I put it onto my website in case others find it useful. If you know the diameter of your brew kettle, and your kettle is cylindrical, you can use the calculator to convert between depth of the liquid and volume. This lets you use a dipstick to figure out your volumes if you're not cool enough for a sight glass yet Click and tell me what you think! Eventually it'll store your kettle diameter in a cookie so you don't have to re-enter it every time you go to the site. -Joe
Is there a link to this?
This one appears to be broken