Wake Frequency — Calculation Excel Sheet
Use VLOOKUP or XLOOKUP to adjust ( S_t ) automatically. Create a table for different velocities and headings:
1. Theoretical Background When a fluid (wind or water) flows past a cylindrical structure, vortices alternately shed from each side, creating a periodic force. The vortex shedding frequency (( f )) is given by: wake frequency calculation excel sheet
| Velocity (m/s) | Angle (deg) | Proj. Diameter (m) | f_shed (Hz) | Resonance? | |----------------|-------------|--------------------|-------------|-------------| | 5 | 0 | 0.5 | 2.0 | OK | | 10 | 0 | 0.5 | 4.0 | RESONANCE | | 15 | 30 | 0.5 | 6.0 | OK | Use VLOOKUP or XLOOKUP to adjust ( S_t ) automatically
| Parameter | Symbol | Typical Value | Unit | Notes | |-----------|--------|---------------|------|-------| | Diameter | ( D ) | 0.5 | m | External diameter for circular sections | | Flow velocity | ( V ) | 10 | m/s | Design wind/water speed | | Strouhal number | ( S_t ) | 0.2 | - | 0.18 for subcritical, 0.2–0.25 for supercritical Re | | Kinematic viscosity | ( \nu ) | 1.5e-5 | m²/s | Air ≈1.5e-5, water ≈1e-6 | | Density of fluid | ( \rho ) | 1.225 | kg/m³ | Air at 20°C | | Structural natural frequency | ( f_n ) | 2.5 | Hz | From modal analysis or field measurement | | Allowable % deviation | ( \varepsilon ) | 20 | % | Safe band around resonance | Sheet: "Wake_Freq_Calculator" | A | B | C | D | |---|---|---|---| | Input Data | | Calculations | | | Diameter (m) | 0.5 | Reynolds number | =B2 B3/B6 | | Flow velocity (m/s) | 10 | Vortex shedding frequency (Hz) | =B4 B3/B2 | | Strouhal number | 0.2 | Critical velocity (m/s) | =B5 B2/B4 | | Natural frequency (Hz) | 2.5 | Frequency ratio (f/fn) | =C3/B4 | | Kinematic viscosity (m²/s) | 1.5E-05 | Resonance check | =IF(AND(C5>0.8, C5<1.2), "RESONANCE RISK", "OK") | | Allowable tolerance | 0.2 | Reduced velocity (Vr) | =B3/(B4 B2) | The vortex shedding frequency (( f )) is
| Re range | Strouhal number | |----------|----------------| | < 1e5 | 0.18 | | 1e5 – 3.5e6 | 0.20 | | > 3.5e6 | 0.22 |
[ f = \fracS_t \cdot VD ]
| Parameter | Value | |-----------|-------| | Mass per length (kg/m) | 200 | | Damping ratio ζ | 0.005 | | Log decrement δ | =2 PI() B9 | | Scruton number | =(2 B8 B10)/(B11*B2^2) |