BUNDLE_FROM_TUBES
This function calculates the bundle diameter needed to accommodate a target tube count for specified tube size, pitch, pass count, and layout angle. It supports multiple sizing methods consistent with tube-count routines.
The sizing relation is D_{bundle}=f(N, D_o, p, N_{tp}, \theta, \text{method}).
Excel Usage
=BUNDLE_FROM_TUBES(N, Do, pitch, Ntp, angle, bundle_meth)
N(int, required): Total number of tubes (-).Do(float, required): Tube outer diameter (m).pitch(float, required): Tube pitch (m).Ntp(int, optional, default: 1): Number of tube passes (-).angle(int, optional, default: 30): Tube layout angle (degrees).bundle_meth(str, optional, default: null): Tube count method selection (-).
Returns (float): Outer diameter of tube bundle (m).
Example 1: Bundle size using default method
Inputs:
| N | Do | pitch |
|---|---|---|
| 1285 | 0.025 | 0.03125 |
Excel formula:
=BUNDLE_FROM_TUBES(1285, 0.025, 0.03125)
Expected output:
1.19857
Example 2: Bundle size using Phadkeb method
Inputs:
| N | Do | pitch | Ntp | bundle_meth |
|---|---|---|---|---|
| 782 | 0.028 | 0.036 | 2 | Phadkeb |
Excel formula:
=BUNDLE_FROM_TUBES(782, 0.028, 0.036, 2, "Phadkeb")
Expected output:
1.10319
Example 3: Bundle size using VDI method
Inputs:
| N | Do | pitch | Ntp | bundle_meth |
|---|---|---|---|---|
| 970 | 0.00735 | 0.015 | 2 | VDI |
Excel formula:
=BUNDLE_FROM_TUBES(970, 0.00735, 0.015, 2, "VDI")
Expected output:
0.50036
Example 4: Bundle size using HEDH method
Inputs:
| N | Do | pitch | bundle_meth |
|---|---|---|---|
| 928 | 0.028 | 0.036 | HEDH |
Excel formula:
=BUNDLE_FROM_TUBES(928, 0.028, 0.036, "HEDH")
Expected output:
1.18399
Python Code
Show Code
from ht.hx import size_bundle_from_tubecount as hx_size_bundle_from_tubecount
def bundle_from_tubes(N, Do, pitch, Ntp=1, angle=30, bundle_meth=None):
"""
Calculate bundle diameter required for a specified tube count.
See: https://ht.readthedocs.io/en/latest/ht.hx.html
This example function is provided as-is without any representation of accuracy.
Args:
N (int): Total number of tubes (-).
Do (float): Tube outer diameter (m).
pitch (float): Tube pitch (m).
Ntp (int, optional): Number of tube passes (-). Default is 1.
angle (int, optional): Tube layout angle (degrees). Default is 30.
bundle_meth (str, optional): Tube count method selection (-). Valid options: Phadkeb, HEDH, VDI, Perry. Default is None.
Returns:
float: Outer diameter of tube bundle (m).
"""
try:
result = hx_size_bundle_from_tubecount(N=N, Do=Do, pitch=pitch, Ntp=Ntp, angle=angle, Method=bundle_meth)
return result
except Exception as e:
return f"Error: {str(e)}"Online Calculator
Total number of tubes (-).
Tube outer diameter (m).
Tube pitch (m).
Number of tube passes (-).
Tube layout angle (degrees).
Tube count method selection (-).