Conbeam – Python version

Posted on June 24, 2015 by dougaj4

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 Scipy.  Everything else is included in the download file, including all the necessary ExcelPython files.

The spreadsheet (including full open source code) can be downloaded from Conbeampy.zip.  To run the spreadsheet just unzip everything to any directory.

The file ConBeampy.xlsb includes all the new functions with one example of each.

ConBeampy-check.xlsb also includes checks of the Conbeam function results against results from Strand7, for 15 different configurations of beams with different span arrangements and support conditions.  The screenshot below shows there was close agreement for all 15 cases.

Conbeampy1-1

Click for full size view

More examples of using each of the included functions will be provided in future posts.

This entry was posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.