Coolship Calc - Cylindrical and Rectangular
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To use this spreadsheet simply enter values into the blue cells. This will tell you the ideal volume for a given kettle diameter to reach a SA/V ratio of .67 and an estimate of your cooling time based on your temperatures and SG.
2
3
Kettle Diameter16inches
4
Calculation:
5
Surface Area to Volume Ratio Target
0.67
6
Side Surface0.1862898622m2
7
Ideal Volume to reach target ratio
15.58921836gallons
Bottom Surface
0.1297171146m2
8
Circumference
1.276743254m
9
Actual Volume5gallonsTop Surface0.1297171146m2
10
A_k0.3160069769m3
Total Surface Area Outside of Kettle
11
Actual Surface Area to Volume Ratio
2.08895526h_air12W/m2*K
Overall Heat Transfer Coefficient for the top surface of wort.
12
A_l0.1297171146m3
Area of Liquid Surface
13
rho1040Kg/m3
Density of Wort
14
V0.01892705m3
Volume of Wort
15
Cp3806J/Kg*K
Specific Heat of Wort
16
h_kettle11.2W/m2*K
Overall Heat Transfer Coefficient for the kettle sides and bottom
17
SG Wort1.04h_coolship11.43282047W/m2*K
Overall Heat Transfer Coefficient of the coolship
18
19
Initial Wort Temp190F
Ref: Introduction to Heat Transfer, 5th Edition, Incropera/DeWitt/Bergmann/Lavine
20
21
Average Ambient Air Temp33FValues for heat transfer coefficients were taken from what I could find in textbooks or other sources scattered about the internet. They are only estimates. They should get you in the ball park. You may adjust the overall heat transfer coefficient of the coolship once you have used your coolship several times and can back out a value of your own from emperical data. It will also vary with conditions such as wind, humidty, etc. The ideal coolship surface area to volume ratio was found in the coolship section of the MTF wiki from James Howat's writeup about homebrew coolships.
22
23
Desired Wort Temp64F
24
25
Estimated Cooling Time6.62hr
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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
Loading...
Main menu