Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Daily Download 4: Continuous Beam Analysis
- Deflections and Moments in Rectangular Plates
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Category Archives: Finite Element Analysis
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
2 Comments
Installing PyPardiso and speed of Scipy spsolve
I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs. For my linear … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
4 Comments
SectionProperties update 3
The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading
Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL
Tagged Excel, Python, PyXLL, Section-Properties, Torsion, Warping
3 Comments
SectionProperties update update
Since my previous post on the Python SectionProperties program it has been updated to Rel. 2.02, with some major changes: The mesh generation library has been changed from MeshPY to Triangle New functions have been added for: Steel sections Concrete … Continue reading
Posted in Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged Excel, Python, PyXLL, Section-Properties, Torsion
2 Comments