Tag Archives: UDF

Nearest Lookup Function

Posted on 21/10/2016 by dougaj4

The Excel Lookup functions (including VLookup, HLookup and Match) all allow for an “exact” or “closest” match on numerical data, but the closest option has a number of problems: The data must be sorted For VLookup and HLookup the data … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1

Posted on 02/10/2016 by dougaj4

The xlwSciPy spreadsheet (last presented here) has been updated for the latest version of xlwings and Scipy. The new spreadsheet can be downloaded from: xlScipy-xlw.zip including full open source code. The spreadsheet requires Python, including xlwings, Numpy, Scipy and Pandas … Continue reading →

Posted in Arrays, Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, Python Pandas, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

VBA routines for splitting and joining text

Posted on 25/09/2016 by dougaj4

As mentioned in the previous post, I have written two short VBA routines to aid the process of splitting a column of text strings into separate columns, using either a space or any other chosen character as the delimiter.  These … Continue reading →

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

ConbeamU 4.10

Posted on 28/08/2016 by dougaj4

The ConbeamU spreadsheet has been updated to Version 4.10, to fix a problem with incorrect default parameters being used if the support stiffness columns had empty cells.  The revised spreadsheet (including open-source code) can be downloaded from: ConbeamU.zip Applications in the … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 24 Comments

PlateStress Update

Posted on 13/08/2016 by dougaj4

The functions from the PlateStress spreadsheet (details here) will be incorporated in the FEA spreadsheets currently being presented. In the process of using these functions I made a couple of improvements: The required sequence of the Gauss Points numbers was clarified: … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment