|
|
|
|
|
Several types of data for a borehole log can be imported from an Excel spreadsheet. The types of data that can be imported will depend on the template for the log. Most of the data in the template columns can be imported.
To import the data select the Import Excel Log Data menu item from the Edit menu. The Import Excel Data form will be displayed.
The Excel spreadsheet to be imported should be specified as the File Name on the form. It can be selected using the button to the right. After the Excel file has been specified the form will be updated, as shown on the next page, with the available data that can be imported using the template.
The Data Type column on the form shows the types of data from the template that can be imported. One or more of these data types can be imported by specifying the cell range in the Cells column.
The cell range can be specified by typing it in or by clicking on the Select column. A Select button will be displayed in the column, click on this button to display the spreadsheet in the Excel Spreadsheet form.
To select the cell range, click on the first cell and then hold the left mouse button down while selecting the cells. When the cell range has been selected, click the right mouse button to return to the Import Excel Data form. The selected cell range will be filled in on the form.
This operation can be repeated until all of the cell ranges for the data types on the form have been specified. When all of the cell ranges that are to be imported are entered, click on the Ok button to import the data into the log.
To make it easier to import data from spreadsheets, script files can be used. These files contain the cell ranges for a spreadsheet. Once the cell ranges have been specified they can be saved in a script file. This script file can then be opened and used for the next borehole. Even if the Excel file is different, it can still be used with the script file as long as the data in the spreadsheet is arranged the same way.