Thank you so much sir for a very useful video you've created...now i can make my own computation, including, distance, bearing, azimuth, departure, latitude, Easting,and northing 😊
I am a US Army retiree and have used MGRS my whole life. I taught myself how to read a map using LAT/LONG. Now I wanted to understand my Survey PLAT in how to turn a LAT/LONG Bearing into an azimuth. What a great video. I not only learned how but in the process learned more about excel. Thank you for posting this awesome video. You have earned another subscriber.
I am a forester and this was very helpful. I thought I was clever for figuring out the if/then functions necessary to go from DMS bearings to decimal degree Azimuths (basically similar to your last steps), but I was still transcribing the D, M, and S values into different cells. It occurred to me someone may have done a better job and posted a video, which you did. Bearings aren't any worse to follow in the field or using a protractor on paper, but when I want to get things to work with my GIS program, I can only seem to get the syntax right with decimal degree azimuths and decimal feet. These surveys usually have bearings rather than azimuths, but I am lucky that they tend to use decimal feet nowadays. Better than using excel to parse out chains, rods and links and having to convert that part too. I may try to add in a double-meridian distance function to what you started here. Thanks a bunch!