Recent Comments
OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… 
dougaj4 on Biaxial bending update 
DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update 
Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function 
Zhitong Zhang on P-Y Curve function 
Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin…
Tag Archives: ExcelPython
Use Matplotlib from Excel with xlwings
Xlwings is another free and open source package allowing communication between Excel and Python. It now incorporates ExcelPython, and is included in the Anaconda Python package, so will support my ExcelPython based spreadsheets after installation of xlwings using: conda install … Continue reading
Posted in Drawing, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, VBA
Tagged Excel, ExcelPython, link Excel to Python, MatPlotlib, Python, VBA, xlwings
8 Comments
Tanh-Sinh Quadrature via F2PY – Part 3
For the last of the current series on combining Fortran, Python and Excel with F2PY and ExcelPython I have updated the xlSciPy spreadsheet to include two other variants of the Tanh-Sinh function: Quad_TSi integrates a non-periodic function over a semi-infinite … Continue reading
xlSciPy – Python SciPy for Excel; Update with new functions
The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text. The new version (including full open-source VBA … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Integration, minimization, Python, root finding, SciPy, SciPy.optimize, solvers, UDF, VBA
Leave a comment
Solving non-linear equations with two or more unknowns – 5
This will be the last of the series on solving non-linear equations (for now). Up until now all the examples have had two unknown values, and two target values. This can be extended by making three changes to the code: … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, moment curvature, Newton's Method, Python, SciPy, SciPy optimize function, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
3 Comments
IP2 and IP2_py
The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading
Conbeam – Python version
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 … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged Conbeampy, ConBeamU, continuous beam analysis, Excel, ExcelPython, Python, UDF, VBA
Leave a comment
xlSciPy 1.01
The xlSciPy spreadsheet, introduced here, has been updated with many new functions. The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy. It … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel. VBA, ExcelPython, Fast Fourier Transform, Python, SciPy distance functions, sparse solvers, UDF
Leave a comment
