A.B 3 Posted April 27, 2023 Share Posted April 27, 2023 This is proving to be a bit harder than I thought. Or maybe I've lost a few brain cells lately. During a longer type race I what know the TWA for the legs ahead. For sail selection purposes. I want to enter the TWD as the varible. The course heading for the leg has already been entered. Press enter and out spits the TWA. The difficulty is having the answer as a port or starboard tack (+ or -) less than 180deg. Any suggestions would be helpful. Thank you. Quote Link to post Share on other sites
Clipper 363 Posted April 27, 2023 Share Posted April 27, 2023 =IF(TWD-Bearing<=-180,TWD-Bearing+360,TWD-Bearing) 2 Quote Link to post Share on other sites
A.B 3 Posted April 27, 2023 Author Share Posted April 27, 2023 Cheers Quote Link to post Share on other sites
K4309 386 Posted April 28, 2023 Share Posted April 28, 2023 Haha - resolving the excel formula logic has always confused me so much, I've always just worked out the next leg TWA in my head. I do keep course cards (printed & laminated) onboard with the leg headings on them. Then I can spend all day strategizing about the next leg. Also gives me a good feel if the wind veers or backs a tad if a particular sail will be a bit marginal or not. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.