Tag Archives: UDF

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

RC Design Functions update

Posted on 21/05/2016 by dougaj4

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

Posted on 17/04/2016 by dougaj4

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

xlwings – dataframes and statistics

Posted on 12/04/2016 by dougaj4

Another data conversion option offered by the latest xlwings release is Pandas dataframes and dataseries.  This post will look at how to pass an Excel range as a dataframe or dataseries in a User Defined Function (UDF), and some simple … Continue reading →

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