This program is used to read specific data fields from the RockWorks datasheet and record them in the Borehole Manager Stratigraphy tables. This can be useful if you have done some manipulation of the stratigraphic elevations in the datasheet and want the modified data to be represented in the Borehole Manager.
! This is not meant to be a means of entering stratigraphic data, but instead as a means of modifying data that has already been brought over from the Borehole Manager for editing purposes. A typical scenario might go like this: The user transfers stratigraphic top and bottom elevations from the Borehole Manager to the RockWorks datasheet. Next, the user manipulates the stratigraphic elevations (not the easting, northing, elevation, or symbol data) and/or uses various programs within the menus to process this data. Then, the user may wish to transfer these modified elevations back into the Borehole Manager (which will convert them back to depths). See Transferring Borehole Stratigraphy to the RockWorks Datasheet for information about that transfer tool.
! This transfer program assumes vertical boreholes. Any downhole survey information in the Borehole Manager database will NOT be taken into account when edited elevations are transfered back to the database and translated back into depths. (The Borehole Manager's transfer tool TO the datasheet does take downhole survey into account, but this transfer-back tool does not.)
! For the transfer to be successful, it is required that all boreholes referenced in the datasheet already exist in the Borehole Manager.
! It is required that the data in the datasheet be listed in a specific order. See Required Structure of the RockWorks Stratigraphy Data.
Menu Options
Step-by-Step Summary
There are none.
The program will read the borehole ID’s from column 1 in the datasheet. For each row in the datasheet, it will check whether a borehole record with that ID already exists. If it does, it will translate all listed stratigraphic elevations back to depths and post the data to that borehole's records (overwriting any existing data – be careful).