Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 5: Frame Analysis
- Automating chart scale limits - update
- Downloads
- About Newton Excel Bach
Recent Comments
Category Archives: Finite Element Analysis
SectionProperties Release 3
Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Python, PyXLL, sectionproperties
Leave a comment
3DFrame-py update
The Python 3DFrame spreadsheet has been updated to allow for analysis including torsional warping effects. The new spreadsheet and associated Python files can be downloaded from: 3DFrame-py.zip The download file includes four sample spreadsheets comparing analysis results with output from … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame-py, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
Mastan2
Mastan2 is a free frame analysis program based on Matlab. The linked site provides alternative downloads for those with or without Matlab installed. The site also provides a link to the book Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
3DFrame-py
My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, VBA
Tagged 3DFrame-py, Excel, Frame Analysis, Numba, PyPardiso, Python, PyXLL, SciPy
3 Comments
Speed of Scipy Linear Algebra Solvers
The files presented in the recent post on Scipy Linear Algebra Solvers include a wide range of different solver types, with in some cases numerous sub-options, allowing the functions to be called from Excel, and greatly extending and speeding up … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, linear algebra, PyPardiso, Python, PyXLL, Solver times
2 Comments