Search results for query: *

Thanks to all for the help Your one seems to work perfect BridgeSmith

Hi 3DDave Sorry I cannot get it to work. Cab you explain in basic terms how to write the formula below so it calculates the angle A | B | C | D | E 1| Angle | Sin | Cos | Sin + Cos | 2| 0 | 0 | 1 | 1 | Thanks again

Thanks 3DDave for taking the time Forgive my ignorance and lack of intellect Where do I input vessel heading and bore heading? Thanks

I believe this is where MOD function could be implemented??? For example =MIN(MOD(VC-RBC,360), 360-MOD(VC-RBC,360)) This calculates a difference of 15 when VC 350 and RBC 5. 15 is =<45 and would correctly output FWD I just dont know how to combine it... Thanks

Thanks IRStuff for taking the time to post. Its nearly there... As davidbeach suggested it doesn't quite work. When we have a VC heading close to 360 and bore heading slightly greater than zero. For example VC 350 AND RBC 5 calculates AFT but should be FWD Thanks

Hi electricpete, thanks for the reply. My excel knowledge is average to basic so appreciate your help So regarding the inputs I will provide some examples Currently we are working at location where the 'Reference bore (RB)' is 3deg. The vessel is on 180 deg heading. Hence, RB is AFT in...

Hello, I came across a previous thread on here which had a very helpful formula to calculate the difference between 2 headings using the MOD function I work on a vessel and we always have a reference heading of a piece of equipment on the seabead called the 'datum bore heading'. Now...