Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Downloads by category
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- Using conditional formatting with array formulas
- P-Y Curve function
Recent Comments
Category Archives: Finite Element Analysis
Scipy linear algebra functions in Excel
The file pyLinAlgfuncs3.zip has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Liear algebra functions, Link to Python, PyPardiso, PyXLL, Scipy Linalg, UDFs
Leave a comment
LU Decomposition with Python and Scipy
This post was prompted by a question at the Eng-Tips forum: LU Decomposition which asked why Mathcad was generating LU matrices different to those calculated from the basic theory. The short answer was that there is more than one way … Continue reading
Posted in Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, linear algebra, LUsolve, Python, PyXLL, SciPy
1 Comment
Secondary moments in prestressed beams with FEA-2
Following the first post in this series, this post compares friction losses in prestressing cables as defined in the Australian Concrete Structures Code (AS 3600), compared with a cable modelled with contact elements in Strand7. The example used is based … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7
Tagged contact elements, Excel, FEA, Friction losses, prestressing, sticking friction stiffness, Strand7
1 Comment
Secondary moments in prestressed beams with FEA
Secondary (or hyperstatic) bending moments occur in prestressed beams that are continuous over internal supports, or have other redundant support conditions. Any eccentric prestress force will cause a beam to deflect, and if these deflections are restrained at internal supports, … Continue reading
Installing Python and pyxll from scratch
Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading
Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, installation, kaleido, MatPlotlib, mpmath, Numba, Numpy, Pint, plotly, PyPardiso, Python, PyXLL, SciPy, sectionproperties, Sympy
Leave a comment