Category Archives: UDFs

Reversing Bob

Posted on 31/05/2015 by dougaj4

Following our look at Weird Al Jankovic’s palindromic song, Bob, I have written two short VBA User Defined Functions (UDFs) to help writing palindromes (and possibly with other tasks as well). Reverse() will, as the name suggests, reverse any text entered as … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | Leave a comment

xlSciPy 1.01

Posted on 05/05/2015 by dougaj4

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading →

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

Time to Lookup

Posted on 27/04/2015 by dougaj4

At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading →

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

Re-sizing Array Functions

Posted on 14/04/2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

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

ConbeamU Update Update

Posted on 13/04/2015 by dougaj4

Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one.  The new version number is … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 4 Comments