Category Archives: UDFs

ConBeamU 4.05 and ConBeampy 1.02

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

New and updated links

I have just updated my Blogroll, with 9 new links, and a couple of updates: Colin Caprani’s site is now back on-line I have updated the link to Jon Peltier’s blog dataprose.org was the source of many of the new links, … Continue reading

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

Conbeam – Python version

I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython.  To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Dealing with dates 3: opening and saving csv files without data corruption

This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files.  The latest version includes a routine for saving the imported data in csv format.  It can be downloaded (including full open-source … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , | 2 Comments

Dealing with dates 2: Getting cell data type and format code

When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data.  This may not be obvious, for instance in the previous post we … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , , , | 6 Comments