Category Archives: VBA

Ping Back Ping Backs

Posted on 22/07/2012 by dougaj4

One of the nice things about writing a blog is that when people follow a link to your site you get a link to where they came from, which often leads to interesting places you would not have otherwise found. … Continue reading →

Posted in Excel, Newton, VBA | Tagged , , , , | Leave a comment

Units for Excel

Posted on 11/07/2012 by dougaj4

One of the reasons that programs like MathCad tend to be preferred to Excel for engineering and scientific applications is that they have much better facilities for dealing with different units of measurement.  This isn’t difficult, since the only built-in function provided … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments

LatPilePY 1.04

Posted on 04/07/2012 by dougaj4

Following comments from Stephen on LatPile 1.03 I have modified the code so that if the specified Soil Properties range includes lines 8 and 9 (for specified effective depths at the top of each layer), but these lines are blank, the effective … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 15 Comments

The Dome of Santa Maria del Fiore – Dimensions

Posted on 30/06/2012 by dougaj4

This post is a continuation from The Dome of Santa Maria del Fiore in Florence Different sources give a wide variety of different dimensions for the dome, but there seems to be reasonable agreement that the “across flats” diameter of the … Continue reading →

Posted in Dome Structures, Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

Interpolation Update

Posted on 26/06/2012 by dougaj4

This post was prompted by a question at Eng-Tips.  The question was looking for ways to plot stress contours under a footing, which requires interpolation to find the depth where the stress is at the contour values, given stresses calculated … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment