Recent Comments
Category Archives: UDFs
Using RC Design Functions – 1
Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Examples, Excel, RC Design Functions, Reinforced Concrete, UDF, VBA
13 Comments
Section properties for groups of defined shapes
Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, section properties, section properties of multiple shapes, VBA
13 Comments
Tanh-Sinh Quadrature V4.1
The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes 1. Small but useful accuracy improvements have been … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
1 Comment
what Microsoft think VBA is good for …
The front page of Excel for Developers now has a link entitled VBA, which takes you to: VBA for Excel developers which has a link entitled When to use VBA and why which says: There are three principal reasons to consider VBA … Continue reading
Newton Excel Bach, not (just) an Excel Blog 