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.

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.

[…]