Wind Triangle

A simple calculator in Excel,
Enter: Boatspeed, True Wind Speed, True Wind Angle

Results are:
Apparent Wind Angle (the angle of the wind pennant)
Apparent Wind Speed (what you feel on your face)
Velocity Made Good into the wind direction

Wind Triangle - Excel


Trivial Notes:
- Uses named ranges (Ctrl-F3) for ease of reading and error-checking
- AWA uses MOD function to keep angle between 0 and 180

Comments

Post a Comment

Popular posts from this blog

Laser & dinghy boatspeed - VPP

Image
A previous post outlined the  basic forces  on a yacht - Righting Moment, Heeling Moment, sideforce, friction drag, induced drag. It is an essential introduction to the work here. Download or run online  "VPP Laser & dinghy v2c.xlsx" To calculate the speed of a yacht is both simple and complex. Simply find the speed where the forward thrust from the sails is equal to the aftwards drag of the yacht. When these two forces are balanced the yacht is at a steady speed. At the same time, find the heel angle or hiking position or sail twist/flatness where the Righting Moment balances the Heeling Moment. The first Velocity Prediction Program VPP was written in about 1970 by Kerwin. The link above is a VPP spreadsheet that can be run online without Excel and links the forces and moments together to calculate speed. The process of balancing them is precise. However, modelling the forces is less exact and is simplified in various ways: Thrust The forward ...
Read more

VPP - more things to do

Image
Download link here Polar A polar table can be constructed by entering the TWAs listed in the blue cells as the TWA. BS, VMG, Leeway will be collected automatically and the polar is drawn for this Camber and TWS. Note this is dynamic and will be overwritten whenever a TWA is entered out of order. This is a limitation of writing for Excel Online. Data can be saved or expanded by duplicating the worksheet and having 1 sheet for each TWS, for example. Or copying the table to another sheet or workbook. But I'm leaving this up to you. Similarly Camber and Board Length can be explored: Depending on TWS, it is better to flatten the sail before maximum hiking is reached. This is reducing the sail profile drag by more than the lift is reduced, I guess. Feel free to contact on accuracy, errors, questions, improvements, requests.
Read more

Foil section design

Image
Showing how variables affect Foil lift and Drag The simple variables - Boatspeed & Area - have the greatest effect on Angle of Attack. AoA has the largest effect on the speed along the surface, and this governs the boundary layer. When the AoA is high, the speed peak at the nose is too high to slow down enough by the trailing edge and the flow separates and causes loss of lift and very high drag. If the laminar b.l. extends too far aft, the b.l. flow doesn't have enough energy to stick to the surface and separates. If the foil shape doesn't enough laminar b.l. the drag from friction will be higher Boatspeed has a large effect because when sizing an appendage Lift varies with BS^2, so Angle of Attack varies with 1/ BS^2 AoA varies proportional to the Area - half the Area, twice the AoA Span is usually a modest effect because very low span is rare in racing yachts. Likewise with Surface finish - the difference between good and great is small Needs revisi...
Read more