|
|
|
|
|
New in WinLoG Version 4 is the ability to import project data for multiple boreholes from an Excel spreadsheet. This feature can be used to import bulk data for one or more boreholes in a project. If the boreholes do not exist in the project they will be created. One use for this feature would be to import all of the survey data for the boreholes in a project at the same time from a single Excel spreadsheet.
To import Excel project data select the Import Excel Project Data menu item from the Edit menu.The Import Excel project 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 General Borehole data that can be imported using the borehole that is opened.
One or more of these fields can be imported from the spreadsheet and stored in the boreholes for the project.
To specify the cell range in the spreadsheet to use for the borehole general data type, double click on each Select column. A Select button will be displayed for that data type, click on the button to display the spreadsheet and select the cell range.
Alternatively, if a previously saved Script file is available it can be opened using the Open Script button. This script will contain the cell ranges to import from the Excel spreadsheet. This feature is useful when you have several Excel spreadsheets with the same format that are for different projects.
For example, double click on the Borehole Number’s select column. This will 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 Project Data form. The selected cell range will be filled in on the form.
After all of the cell ranges have been specified, the Save Script button will save a script file that maybe used at a later point to import Excel project data that is in the exact same format.
Click on the OK Button to add the data to the project database. If no cell range is specified then data for that Data Type will not be imported.