Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
- Retrieving unique values from a range or array ...
Recent Comments
Tag Archives: PYsparse
Python for VBA users- 7; Making Python go Faster
As reported in the previous post in this series, although the compiled routines included in packages such as Numpy, Scipy, and Pysparse are very fast, other parts of the code turned out to be slower than the equivalent in VBA. … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, Frame Analysis, PYsparse, Python, sparse matrices. Numba, VBA
Leave a comment
Python for VBA users- 6; Using Pysparse with Excel
Previous Python Post The analysis of structural frames requires the solution of large sparse matrix systems, which rapidly becomes very time consuming using a VBA based solver, especially for 3D analysis. I have previously presented versions of my frame analysis … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, VBA
Tagged Excel, Frame Analysis, PYsparse, Python, sparse matrices, VBA
1 Comment