Convert an Azimuth to Bearing with Minutes and Seconds
Hello, I'm an instructor at a college and I was looking into using xcell to help me make a calculator that will convert an Azimuth to Bearing and A bearing to Azimuth. I just hate doing all the math behind all of these conversions. Can anyone help?
Thanks in Advance
miguelloya1
Hi welcome to the forum, and maybe even the internet
Google is our best friend and .... https://www.youtube.com/watch?v=9ZRKtTeevE0
This is what a simple search can give you, and there's more where that came from.
Happy coding,
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi, yes, I already created an excel with Bearings to Azimuths utilizing the exact video you suggested. I need one that converts the other way. Azimuths to Bearings.
I have searched for the video in question and to no avail. This is why I am hoping some of the experts in this website can help me.
Thank You
Well, isn't easy just to ask ... again. I typed in Google and .... https://www.youtube.com/watch?v=EJvhnPEDJHE
Another one with some information (that might help)
Thank you so much for your assistance.
This is a sample of what I am looking for:
I want to be able to type the Azimuth
Azimuth: 134.7454
And get the results shown below
Bearing: S45d15'16"E
I know it might be too much to ask to convert an azimuth to bearing that will show minutes and seconds.
The last link you shared is the closest I found. Might have to tweek that one a bit...
Thanks Once again
miguelloya1
That's what VBA is all about, loads of perspiration but also a lot of inspiration and .... patience and time to solve it.
Hope you manage
@miguelloya1;
For conversion of Azimuth to Bearing, see the link below:
https://www.excelforum.com/excel-for...ng-format.html
.
Also a spreadsheet of before and after values both ways would be good. Part of the key is how you enter things consistently to create vba code or a formula. Follow the instructions in the yellow banner
Perhaps the attached is along the lines you want
If I did everything correctly (and I believe I did), here is a function (it can be called as a UDF directly on the worksheet) that will take an azimuth and convert it to a bearing...
So, if used on a worksheet where, say, cell A1 contained your azimuth, then this formula in a cell will return the bearing...
Please Login or Register to view this content.
=az2dms(A1)
Note: For your example 134.7454 azimuth, I get a bearing of S45°15'17"E instead of your S45°15'16"E (one second difference) because I rounded the seconds portion instead of truncating it. Your value throws more than 1/2 second away. I that is what you want, then change the Round function to and Int function for the calculation of the Sec variable.
Last edited by Rick Rothstein; 07-09-2020 at 02:24 AM. Reason: Corrected small piece of the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks