Category Archives: UDFs

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

Return of Excel – Evaluating commas

Posted on 14/06/2012 by dougaj4

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

Composite Beam Spreadsheet 3

Posted on 08/05/2012 by dougaj4

The Composite Beam Analysis spreadsheet, previously discussed at: https://newtonexcelbach.wordpress.com/2012/04/27/composite-beam-spreadsheet-2/ has now been updated with a VBA User Defined Function (UDF) in place of the previous macro that used the Excel Goal-Seek command.  This has two main advantages: The UDF is much faster … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 5 Comments