Tag Archives: Excel

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

Extracting selected data with array functions.

Posted on 16/06/2012 by dougaj4

This post is in response to a query at the Eng-tips forum asking how to extract selected data from a range, so that the three best scores for each individual could be extracted from a two column Excel table listing multiple individuals, … Continue reading →

Posted in Arrays, Excel | Tagged , | 5 Comments

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