What you will learn
Turn a consistently formatted workbook into a WinLoG borehole
The tutorial follows the complete import workflow, from reviewing the source workbook through opening and checking the newly created borehole.
Prepare and review the Excel workbook
Start a new-borehole Excel import
Select the destination log template
Map header and footer information
Map lithology and sample ranges
Save reusable import mappings
Create the new borehole
Review the completed log
Video chapters
Jump to a step
0:00 Introduction Preview the completed log and the Excel-to-WinLoG workflow.0:24 Review the Excel workbook Check borehole details, project data, units, depths, lithology and samples.1:17 Start the import Open the destination project and launch the Boring/Well Data import.1:53 Select the Excel file Browse to the source workbook and load its cells into the import form.2:56 Select the WinLoG template Choose the template that defines the new log's data structure and layout.3:38 Map the borehole number Connect the required identifier cell to the Borehole Number field.4:24 Map general information Connect project, coordinate, elevation, drilling and date fields.5:37 Map depth-related data Select corresponding ranges for layers, lithology, samples and test results.6:15 Save, import and review Save the import script, create the borehole and verify the completed log.
