Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jhn1611

    Compass question excel

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

    Compass question excel

    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
  3. jhn1611

    Compass question excel

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

    Compass question excel

    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
  5. jhn1611

    Compass question excel

    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
  6. jhn1611

    Compass question excel

    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...
  7. jhn1611

    Compass question excel

    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...

Part and Inventory Search

Back
Top