ABCDEFGHIJKLMNOPQRST
1
Note: This spreadsheet was made to accompany the blog post: "Determining Proper hose length for your Kegerator" on MikeSoltys.com: http://www.mikesoltys.com/?p=1005 Please refer to the blog for more info on these calculations. I've also updated the website with an easy to use javascript calculater to perform these calculations.
2
3
4
5
Please Visit
6
7
http://www.mikesoltys.com/?p=1005
8
9
For the most updated calculator.
10
11
12
System Parameters (INPUTS):
13
Specific Gravity1.05
14
CO2 Pressure14[PSI]<-- Look up Correct CO2 Pressure for Beer style and temperature
15
Hose diameter0.1875[in]3/16" or 1/4" typical
16
Tap Height1.5[ft]From center of Keg to Tap
17
Desired Pint Fill Time10[sec]Average: Will be faster for full keg and slower for low keg0.16
18
19
Hose Length (OUTPUT):
20
Hose Length11.40[ft]
21
22
Assumptions:
23
Hose Roughness0.000016[ft]from http://www.pjmuth.org/beerstuff/Kegging.pdf and http://www.engineeringtoolbox.com/major-loss-ducts-tubes-d_459.html
24
Viscosity (Dynamic)0.00003279lb/ft^2 sechttp://www.regional.org.au/au/abts/1999/stewart.htm
25
*Neglecting Minor Losses
26
27
28
From Imputs (Just unit conversions)
29
Specific Weight65.52[lb/ft^3]
30
D0.015625[ft]
31
deltaP2016[lb/ft^2]
32
Q0.001671011296[ft^3/sec]
33
34
Simple Calcs
35
A=0.0001917475985[ft^2]
36
V=8.714640023[ft/sec]
37
Viscosity (Kinematic)0.00001600802343ft^2/slarger number given at : http://www.csgnetwork.com/specific_gravity_viscosity_liquids.html
38
e/D=0.001024
39
N_R=8506.125126
40
f=0.03401152214Estimated from Swamee-Jain Eq
41
42
D/f0.3895658869
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100