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…
Category Archives: xlwings
mpmath for Excel
mpmath has been mentioned in passing here before, but not in any detail. The mpmath site says: mpmath is a free (BSD licensed) Python library for real and complex floating-point arithmetic with arbitrary precision. It has been developed by Fredrik … Continue reading
Posted in Excel, Link to Python, Maths, PyXLL, UDFs, VBA, xlwings
Tagged evaluate pi, Excel, high precision maths, mpmath, Python, PyXLL, UDFs, VBA, xlwings
Leave a comment
More SciPy Solvers
The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function. The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged bolt group, Excel, Python, SciPy, solvers, UDFs, VBA, xlwings
Leave a comment
More iterative solvers
Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem. The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading
Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment
Iterative solvers and arrays
A recent thread at Eng-Tips was looking for a solution to the problem described below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading
Posted in Arrays, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Brents method, Excel, Python, SciPy, UDFs, VBA, xlwings, xlwSciPy3
2 Comments
VBA vs Power Query vs Python
A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits. This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading
Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment
Units and solvers with Pint and Sympy
Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units. I have applied the functions to finding the depth of neutral axis of a … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings
Tagged Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
Leave a comment
Working with units in Excel – using VBA and Python
One of the most frequent reasons given for not using Excel for engineering and scientific applications is its very limited facilities for dealing with calculations involving units. It is possible to overcome this deficiency with VBA (see Daily Download 24: … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged evaluate text strings, Excel, Python, Sympy, UDFs, Unyt, VBA, xlwings
4 Comments
