Software and Spreadsheets

Engineers and geologists can’t get their job done without specialty software and spreadsheets. This category contains tutorials and reviews for visual basic for applications or VBA for Excel, finite element and finite difference methods, gINT boring log software, slope stability software, Geo-Studio, Rockware and other geo-software packages.

Incorporating geotechnical data in BIM allows considered design optioneering and refinement at the outset of a project; minimises geotechnical risk in construction and enables cost-effective repairs and maintenance of assets throughout the project’s lifetime. Image courtesy of Mott MacDonald.
Articles

The Case for BIM in Geotechnical Data

November 18, 2014 Gary Morin Comments Off on The Case for BIM in Geotechnical Data

Incorporating geotechnical data in BIM allows considered design optioneering and refinement at the outset of a project; minimises geotechnical risk in construction and enables cost-effective repairs and maintenance of assets throughout the project’s lifetime. Image courtesy of Mott MacDonald.

Getting the Message Across

Applying Building Information Modelling principles to geotechnical data will reinforce the message that geotechnics is an integral part of every phase of a project – not just site investigation, argues Gary Morin, Technical Director, Keynetix.

[Editor] In this contributed article, Gary describes the justification for using BIM for geotechnical data.  Among those benefits are the ability to perform detailed alternatives analysis and optioneering, reduction of risk during construction, and the ability to perform cost-effective repairs and maintenance during the lifetime of the geotechnical asset. Click through to read the full article. Keynetix is a sponsor of GeoPrac.net. [/Editor]

[…]

ESdat
Articles

Environmental Data Management for Groundwater Contamination

October 3, 2011 EarthScience Information Systems Pty Ltd. (EScIS) Comments Off on Environmental Data Management for Groundwater Contamination

ESdatESdat Environmental Data Management Software has been used to manage and report on large datasets generated from an investigation of groundwater contamination on an industrial facility in Adelaide. ESdat was used in managing site data and the maintenance of conceptual model and time series outputs at a complex site over an extended period. [Editor] Click through for the rest of the article. [/Editor]

[…]


Monte Carlo Simulation in Excel using VBA
Articles

VBA and Excel for Engineers and Scientists – Part 3

June 10, 2009 rockman Comments Off on VBA and Excel for Engineers and Scientists – Part 3

Monte Carlo Simulation in Excel using VBAIn this third and final installment of the popular VBA and Excel for Engineers and Scientists series, we will look at one of the most important techniques for extending Excel with VBA, the Range Object. I’ll show you the best way to refer to single cells, multiple cells, how to get values from them and put values back into ranges using the VBA. And we’ll program up a simple Monte Carlo Simulation example and lastly we’ll look at how to read and write to text files and to manipulate files and folders in Windows.

[…]

gINT colors
Articles

Variable Colours for Reports in gINT Part 1

April 30, 2009 Miles Davis Comments Off on Variable Colours for Reports in gINT Part 1

gINT colors[Editor] Miles Davis of Quantum Geotechnical Ltd. and gINTDev gives us a sneak peak at a "future feature" in gINT. Of course, gINT Software is a Premier Sponsor of GeoPrac, and the article has been published with the complete knowledge of the company. We welcome this first contribution from Miles and look forward to Part 2 and future articles sharing his gINT expertise! [/Editor]

[…]

Geotaggng images
Articles

Geotagging Images for Geoengineers

July 10, 2008 rockman Comments Off on Geotagging Images for Geoengineers

Geotaggng images

Geotagging is the process of adding geographic metadata (ie. latitude, longitude and sometimes elevation and bearing) to digital photos or other media. In this article, I will examine the equipment needed, the software to help with the process and what you can do with your geotagged photos.

[…]


Articles

VBA and Excel for Engineers and Scientists – Part 2

May 20, 2008 rockman 1

In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.

[…]

gINT Professional Software screenshot
Articles

gINT Professional Software Explained

June 25, 2007 rockman Comments Off on gINT Professional Software Explained

gINT Professional Software screenshot

Powerful Geo-Data Management

An overview of the gINT Professional software program, a tool for boring and well log creation, fence diagrams, laboratory reports… and a whole lot more than people realize.

[…]

vba toolbar
Articles

VBA and Excel for Engineers and Scientists

April 5, 2007 rockman Comments Off on VBA and Excel for Engineers and Scientists

vba toolbar

Visual Basic for Applications or VBA used in conjunction with Microsoft Excel is a tool that many scientists and engineers have yet to take full advantage of. This article is the first in a series designed to provide you with the basic understanding of how to use VBA and Excel in your practice.

[…]