I was given a bunch of surveyed borehole data (azimuth, depth, dip, geology, etc) and am required to calculate a deviation variable. Besides querying the data and averaging the surveyed borehole results, I was wondering if anyone had any specific calculations or recommended software programs in order to calculate a deviation variable and to visualize it in a 3D view around a planned borehole?
There is a software that could have the capabilities you're looking for, its name is Target from Geosoft: http://www.geosoft.com/products/target. It works with the base software called Oasis Montaj and can be used with ArcGis also. I've worked with it and it's pretty neat, however it's not free and the licenses are quite expensive (only Oasis Montaj is about USD 11k). You can request academic licenses but also you have to pay for them as far as I know.