Recent Comments
Category Archives: Excel
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 Conversion, Excel, Open source, UDF, Units, VBA
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 COM624, Excel, Laterally loaded pile, LatPilePY, UDF, VBA
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 DigitGraph, Dome, Excel, FEA, Florence Cathedral, IP2, S& API Tools, UDF, VBA
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
Extracting selected data with array functions.
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
