Articles

VBA and Excel for Engineers and Scientists – Part 2

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.

[…]

Embankment Dams in Earth Fissure Risk Zones - A Regulator's Dilemma
Articles

Embankment Dams in Fissure Risk Zones

Embankment Dams in Earth Fissure Risk Zones - A Regulator's Dilemma

Is it possible to safely rehabilitate dams in earth fissure risk zones to continue to provide economical flood protection to the public, or does the risk of dam failure due to an undetected fissure present too great a threat to the public? Read the article to find out the view of the Arizona Department of Water Resources.

[…]

gINT Professional Software screenshot
Articles

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.

[…]

Apollo 11 LM Pad
Articles

The Ultimate Geotechnical Engineering Challenge

The Lunar Module landing pad

Most people are aware that Apollo 11 was the NASA where man first set foot on the Moon. But before they could set foot on it, they had to set the landing pads of the LM there! How did they come up with geotechnical soil parameters for the design of the LM’s footpads? How did they determine a bearing capacity of lunar soil? Click through for this facinating article that I hope you will share with your colleagues.

[…]

No Picture
Articles

LRFD for Geotech – Note 1

GeoPrac.net is very pleased to present this article on Load Resistance Factor Design (LRFD) for Bridge Substructure Design by Naresh C. Samtani, PE, PhD. This will hopefully be the first in a series of technical notes by Naresh on this topic. He is the lead instructor for the Ryan R. Berg and Associates, Inc. team of instructors for the LRFD Course for design of substructures offered through the FHWA’s National Highway Institute (NHI).

[…]

vba toolbar
Articles

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.

[…]