This boring and well log template was developed by W. Zachary Dickson of Dickson & Associates, LLC, Castle Rock, Colorado. It is designed to bring a significant level of automation to the creation of single and multi-page boring and well logs while also addressing the complexity and variability associated with boring and well log data.

The template includes a full borehole log, integrating lithology, descriptive soil layers, field measurements, and well construction details – all aligned by depth. It provides a clear and practical way to visualize subsurface conditions and installation design, making it especially useful for geotechnical, environmental, and hydrogeologic investigations.

The main log displays lithologic units with patterns fills and associated descriptions, while the right side includes a well construction diagram showing casing, screen, grout, and seal materials. Together, these elements empower users to relate construction details directly to subsurface conditions.

The worksheet data provided has several sheets of examples for reference and can be used to format your own data to then populate the template:

• DA Example Log Data1.xlsx
• DA Example Well Data1.xlsx

Dickson & Associates, LLC are environmental data experts with extensive experience in the in preparation and creation of forensic environmental databases, data models, environmental visualizations and So Much More!

Please see their website at DicksonAndAssocates.com for a summary of their history and experience. Be sure to explore their publicly available Microsoft Power BI interactive data models and the associated educational videos.

Industry Focus: Mining, Oil and Gas, Water Resources
Graph Features: Floating Bar, Line