Originally Posted by OldFrog75
I'm using Excel spreadsheet and not getting the right answers. Might be using wrong formulas for example:
None of these formulas give me the expected result:
A = 0.15; not 0.86
B = 6.48; not 1.15
C = 1.02; not 1.15
I have prepared an excel spreadsheet for you and uploaded it.
In it, you enter the straight line distance in B1. This will be the long side of your isosceles triangle.
Enter the angle off the wind in degrees in B2.
I convert degrees to radians for you. The answer will appear in B3.
Then the distance over the bottom appears in B4.
Your third formula is almost right.
If you had tried:
Distance over bottom = straight line distance / (COS(2*PI()*)Angle off wind/360)), you would have had it.
To convert from degrees to radians, divide the angle in degrees by 360 and multiply by the result by twice pi.