Category Archives: VBA

Section Properties Update

Posted on 02/11/2014 by dougaj4

The Section Properties spreadsheet provides formulas for the section properties of 35 different defined shapes, calculation of section properties from coordinates, and interactive calculation and plotting of any chosen shape with defined dimensions: The latest version added the function to … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 2 Comments

ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Posted on 06/10/2014 by dougaj4

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file.  See the earlier post for details of installation and use, or download the revised files … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment

Binary functions, combining text, and finding unique columns

Posted on 30/09/2014 by dougaj4

I recently had an e-mail request asking for a method of finding unique columns in an Excel table consisting of either blank cells or an entry of 1.  An easy way to do this would be to convert the columns to … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 1 Comment

ExcelPython2, Alglib and Spline-Matrix update

Posted on 12/09/2014 by dougaj4

The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2.  The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous  version, so the … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

Extending complex UDFs with simple VBA

Posted on 05/09/2014 by dougaj4

One of the advantages of writing spreadsheet applications in the form of User Defined Functions (UDFs) is that the UDF may be used on the spreadsheet in the same way as a built-in function, allowing applications to be modified and extended … Continue reading →

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