Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- P-Y Curve function
- Daily Download 4: Continuous Beam Analysis
- Downloads
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
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 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
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