|
|
|
|
|
To import an Excel Deviation survey select the Excel File menu item from the Import Deviation Survey submenu. This will open up the Import Excel Deviation Survey form.
Then select the name of the Excel File you wish to import the deviation survey from. After the Ok button has been pressed the Import Excel Deviation Survey Form will contain three rows and three columns.
The Row Headers are:
Measured Depth: The measured depth at which a deviation survey reading was taken.
Inclination: This is the dip of the borehole from true vertical.
Azimuth: The azimuth (az) angle is the compass bearing, relative to true (geographic) north, of a point on the horizon directly beneath an observed object. The horizon is defined as a huge, imaginary circle centered on the observer, equidistant from the zenith (point straight overhead).
The Column Headers are:
Data Type: The data type to be stored in a cell.
Cells: The cells chosen from the spread sheet for a data type. In general you should choose the same number of cells for the measured Depth, as you do for the Inclination and azimuth.
Select: Clicking the select column once shows the Select button for that row. Double clicking it opens up the This column opens up a Excel Spread sheet from which you can select the deviated survey data.
To add Measured Depth data, click on the Select column and then click on the Select button. This will display the Excel spreadsheet on the Excel Spreadsheet form. Select the cells you wish to use for the Measured depth data then click the right mouse button. This operation can then be repeated for the Inclination and Azimuth.
After the cell ranges have been specified, click the OK button to import the data.