Tag Archives: UDFs

Units4Excel Update

Posted on 29/12/2020 by dougaj4

As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 5 Comments

Extracting text from an Internet table

Posted on 11/12/2020 by dougaj4

For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 3 Comments

Tanh-Sinh Quadrature update

Posted on 26/11/2020 by dougaj4

Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading →

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

Numerical Integration With Tanh-Sinh Quadrature v 5.0

Posted on 29/10/2020 by dougaj4

Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 5.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: The Tanh-Sinh quadrature workbook has been … Continue reading →

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

Reinforced Concrete Design for Circular Sections to Eurocode 2

Posted on 26/07/2020 by dougaj4

As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular  or a parabolic-linear stress block.  A new CircuPF function has now been added, for codes … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment