Tag Archives: VBA

Tanh-Sinh Quadrature V2.1

Posted on 27/10/2011 by dougaj4

Graeme Dennes has released another update to his Tanh-Sinh Quadrature spreadsheet, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code).  Here is Graeme’s description of the changes: In Version 2.0, the nodes and weights array data … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments

Equivalent Stress Blocks

Posted on 19/10/2011 by dougaj4

Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading →

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

Spreadsheet Solutions For Structural Engineering

Posted on 07/10/2011 by dougaj4

Another site where the tasks considered suitable for programming in Excel and VBA are anything but “boring and repetitive” is Yakpol’s Spreadsheet Solutions For Structural Engineering: “This web site contains a collection of engineering spreadsheets for structural analysis and design of concrete and … Continue reading →

Posted in Beam Bending, Excel, Newton, VBA | Tagged , , , | 2 Comments

More on VBA

Posted on 06/10/2011 by dougaj4

Andy Pope posted the two links below in a comment to my previous post: A while back they added a VBA developer center to the msdn Office site. http://msdn.microsoft.com/en-gb/office/ff688774.aspx And this article on the Excel developer road map is interesting. … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , , , | Leave a comment

XLDennis, the MSDN Library, and VBA rant

Posted on 04/10/2011 by dougaj4

Dennis Wallentin, aka XLDennis, is a long time contributor to the on-line Excel community and co-author of the latest version of Professional Excel Development.  In recent years he has concentrated on the use of the VSTO and .NET products in … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , | 13 Comments