compass

  1. E

    VBA adaptation - Help!

    Hi guys, I'm looking to create a macro to automatically filter out any data from one tab that matches any values in my Mids tab Column C. To do this, I have used a countif function to work out if there is a match or not then filter out the true values. Once done, I use some other VBA code to...
  2. S

    Calculate distance and bearing, given latitude and longitude of points

    Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate: A: distance B: bearing (initial bearing along a great circle ie the shortest distance) C: bearing along rhumb lines ("constant bearing") For example if you want to go from 0, 0 to 0, 90E, the answer to C would...
  3. R

    Arrow pointer compass type

    Hi I want to rotate an arrow image to exactly a value entered in a cell (dropdown of values between 0 and 180) e.g. if the value is 0 it should point south, if East or West 90+ or - and if pointing North 180. Also all value between these e.g. 45 for South East or South West etc. I need some...
  4. A

    Average the degrees on a compass

    I'm trying to figure out a way to average directions given in compass degrees- where 0 is north, 90 is east, 180 is south, 270 is west and 360 is back to north. It is easy until I get two compass readings that are north east and north west-- for example, an average of 350 degrees and 10...
  5. M

    Working with DEGREES, RADIANS and compass headings ...

    I'm in a bit of a jam. I'm trying to figure out an Excel spreadsheet problem using RADIANS and DEGREES and just can't seem to figure it out. This has to do with ship (maritime) navigation. Here's the problem: I want to input any given course within the 360° of a circle and output the...

Some videos you may like

This Week's Hot Topics

Top