Tag Archives: UDF

Units for Excel

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

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

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

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

Return of Excel – Evaluating commas

The Newton/Galileo posts here will continue with their Italian theme for some time yet, but since I am now back in Australia it’s time to give Excel a look in again. I recently (well a couple of months ago) had … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , | 6 Comments