Category Archives: UDFs

Using RC Design Functions – 2

Posted on May 18, 2013 by

In the previous post we looked at a summary of the functions in the RC Design Functions spreadsheet, and ways of using the EStress function (download file with examples).  In this post we will look in more detail at the … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Using RC Design Functions – 1

Posted on May 10, 2013 by

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 , , , , , | 11 Comments

Section properties for groups of defined shapes

Posted on April 12, 2013 by

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 , , , | 1 Comment

Tanh-Sinh Quadrature V4.1

Posted on March 16, 2013 by

The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh-V4.1. 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 , , , , | Leave a comment

what Microsoft think VBA is good for …

Posted on March 6, 2013 by

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 →

Posted in Excel, UDFs, VBA | Tagged , , | 9 Comments

Function to make a list of functions …

Posted on February 11, 2013 by

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 2 Comments

Precise Angles and XNumbers

Posted on January 28, 2013 by

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Charts and Charting

Posted on January 27, 2013 by

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , | Leave a comment

New Page

Posted on January 26, 2013 by

In an effort to make the information on this site easier to access I have collected all the “Daily Download” posts from last year onto a new page, listing each of the download posts by category. It’s called “Download by … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , | Leave a comment

Extracting a hyperlink

Posted on January 21, 2013 by

Excel does not have a function to extract the address from a cell containing a hyperlink.  Here is a short UDF that will do the job: The original was a one-liner posted by Rick Rosthstein on Debra Dalgleish’s Contextures Blog.  I … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | Leave a comment