Tag Archives: UDF

Nearest Lookup Function

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

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 , , , , , , , , | Leave a comment

VBA routines for splitting and joining text

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

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

PlateStress Update

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

RC Design Functions update

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading

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

xlwSciPy 1.7

Following recent posts on xlwings 0.7.1, dictionaries, and optional arguments and xlwings – dataframes and statistics, I have added the associated functions and examples to the xlwSciPy spreadsheet, and also updated it to xlwings 0.71. The new spreadsheet can be … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, UDFs, VBA | Tagged , , , , , , , , | 4 Comments