VPP - more things to do



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.

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

Tidal current offset for laylines

Image
When the current direction is across your track, or partly, you will shunted up or down compared to where the boat is pointing. The shunt an gle dep ends on the ratio between the speed of your boat and the component of current that is across your heading. The faster the boatspeed vs the current component, the greater the shunt angle. If sailing with the current is aligned with your track on one tack, it won't deviate your course, but will merely change your speed over the ground. The other tack will have current closer to 90degrees so the shunt is greatest. The rest of this note is brought to you by the number 60.  One degree is a slope of 1 in 60, 2 degrees is a slope of 1 in 30. * To estimate the shunt due to current, mostly all you need to remember is 60. Take the ratio of your boatspeed and the speed of the current across your course at 90degrees. That ratio is the slope of how much you are shunted up or down. Multiply the slope by 60 and you have degrees. ...
Read more