Craig SS

import excel data

5 posts in this topic

MY collar elevation does not import from excel. Checked name, tried twice, any idea what I can do to enter collar elev simply on 200 BH data base?

what is z elevation = collar elevation?

Thank you

Share this post


Link to post
Share on other sites

Craig,

All boreholes that are input to the borehole manager need to have at least the following data fields:

  • Easting
  • Northing
  • Z Elevation
  • Collar Elevation
  • Total Depth

The Z elevation is the ground surface elevation. The collar elevation is an alternative elevation, typically above or below the ground surface, that might be used as a measuring point for water levels. If you don't have this information, you can use the Z Elevation.

If you are having trouble importing from Excel, you can paste your values into the Utilities data sheet and transfer the values to the borehole manager using the File -> transfer -> Locations->Borehole Manager function

Be sure to assign units to the column headers before transferring.

Share this post


Link to post
Share on other sites

Perfect, pasting into utilities will work, Thanks for the explanation's. Very Kind

Share this post


Link to post
Share on other sites

Database complete: now I have metric issue. Coordinates are Google UTM 10N, M = metric. Drill logs are feet, elevations are feet. RW reads all data as metric, what is best action?

Thank you

Share this post


Link to post
Share on other sites

You can assign the vertical units to meters or feet when you create your project. You may not have switched that to feet when you created the project.

You can reassign the units from the Settings/Coordinates/Reassign coordinate system and/or units without changing actual data

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now