anyone know if there is a straightforward formula for figuring out the azimuth and dip based on the following two points?
Point 1 (XYZ)
1239.848 3169.079 302.443
Point 2 (XYZ)
1243.823 3166.507 302.292
Thanks in advance
anyone know if there is a straightforward formula for figuring out the azimuth and dip based on the following two points?
Point 1 (XYZ)
1239.848 3169.079 302.443
Point 2 (XYZ)
1243.823 3166.507 302.292
Thanks in advance
This (ancient!) thread might be helpful:
http://www.excelforum.com/excel-gene...ordinates.html
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly, an ancient one indeed some of the links don't exist. So I have in the meantime figured out the answer. Thought I should post it as I had some trouble finding it in the first place. So if the X co-ords are in C4 and C3 and Y co-ords are in B4 and B3 as below, the formula follows;
Point 1 (XYZ)
1239.848 3169.079 302.443
Point 2 (XYZ)
1243.823 3166.507 302.29
=ABS(ATAN((C4-C3)/(B4-B3))*180/PI())
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks