Wind speed at a specified angle from direction of travel?

waddlek

New Member
Joined
Dec 5, 2011
Messages
3
Hello,
I have an unusual wind speed / crosswind problem.
I have formulas / functions to calculate headwind and crosswind given Wind Speed, Wind Direction and current heading.
These calculate the wind speed relative to the direction you are pointing and 90° left or right of the direction you are pointing.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
Function Headwind(WindSpeed As Variant, WindDir As Variant, Heading As Variant) As Variant
If Len(Heading) = 0 Then
Headwind = ""
Else
Headwind = Round(WindSpeed * Cos((WindDir - Heading) * Application.WorksheetFunction.Pi / 180), 1)
End If
End Function
<o:p> </o:p>
Function Crosswind(WindSpeed As Variant, WindDir As Variant, Heading As Variant) As Variant
If Len(Heading) = 0 Then
Crosswind = ""
Else
Crosswind = Round(WindSpeed * Sin((WindDir - Heading) * Application.WorksheetFunction.Pi / 180), 1)
End If
End Function
<o:p> </o:p>
What I need to calculate is the wind speed at a specified angle from heading.
Example:
If Heading = 360°, Wind Direction = 060°, Wind Speed = 30kts
Then Headwind = 15kts and Crosswind, or the wind speed coming directly from the right or 090°, is 26kts.
<o:p> </o:p>
I need to calculate the relative wind speed coming from x° from the heading
Using the above example I need to calculate the wind speed at 015° or 030°
<o:p> </o:p>
Thanks in advance for your help.
Kevin
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,215,169
Messages
6,123,412
Members
449,098
Latest member
ArturS75

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top