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.

[…]

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

Embankment Dams in Fissure Risk Zones

September 27, 2007 Ravi Murthy Comments Off

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.

[…]

Aesthetic Blasting

August 28, 2007 Robert Cummings 1

HIGHWAY CUT SLOPES IN ROCK:SPECIALIZED EXCAVATION AND ENHANCEMENT TECHNIQUES

Bob Cummings of Saguaro GeoServices, Inc. discusses the development and implementation of aesthetic blasting and rock excavation techniques for highway cut slopes in sensitive and scenic infrastructure settings.

[…]

gINT Professional Software Explained

June 25, 2007 rockman Comments Off

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.

[…]

LRFD for Geotech – Note 2

June 21, 2007 Naresh C. Samtani Comments Off

Naresh C. Samtani, PE, PhD has contributed his second in a series of articles on LRFD for geotechnical engineering titled "LRFD for Substructures – Concept of Failure and Reliability Index".

[…]

The Ultimate Geotechnical Engineering Challenge

May 29, 2007 Ed Nowatzki Comments Off

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.

[…]

LRFD for Geotech – Note 1

April 23, 2007 Naresh C. Samtani Comments Off

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).

[…]

Articles

VBA and Excel for Engineers and Scientists

April 5, 2007 rockman Comments Off

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.

[…]