Excel Formula Help Part 2

[flynfiddle]

I'm working on a Flight Planning spreadsheet and be damned if I can find a formula for spitting out a Groundspeed given True Course, TAS, Wind Direction and Wind Speed. Anyone have any suggestions? I'm Googled out!

Thanks

[Louis]

Hello,

What you're trying to figure out is sometimes called a wind or velocity triangle.

In any case this little page came in handy when I made my own flight planning sheets:

http://williams.best.vwh.net/avform.htm

Goodbye,

Louis

[flynfiddle]

Thanks Louis .. I actually stumbled on to that site in my search and tried the formula but being a complete TOOL I was unable to make it work for me, too many "if"s for my limited Excel know-how. I'll have another go at it tonight.

[Louis]

Let me know if you want me to take a look. You'd even have a reason to use the attachments function we now have on the board.

Goodbye,

Louis

[schleprock]

here's my ground speed calc from my spreadsheet

ROUND("TAS"*SQRT(1-(("wind velocity"/"TAS")*SIN(RADIANS("wind direction"-"true track")))^2)-"wind velocity"*COS(RADIANS("wind direction"-"true track")),0)