Tag Archives: Sympy

Latex Maths Text in Excel

Posted on November 27, 2022 by dougaj4

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , | Leave a comment

Installing Python and pyxll from scratch

Posted on September 26, 2022 by dougaj4

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 , , , , , , , , , , , , , , | Leave a comment

Pint, MPmath and implied units, working with Excel

Posted on April 30, 2022 by dougaj4

Spreadsheets linking to the Python Pint and MPmath libraries have been presented here before at: Units and solvers with Pint and Sympy mpmath for Excel I have now updated the spreadsheet to work with pyxll, and with some new functions and … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , | 2 Comments

Units and solvers with Pint and Sympy

Posted on July 29, 2018 by dougaj4

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 , , , , , , , , , , , | 1 Comment

Working with units in Excel – using VBA and Python

Posted on July 15, 2018 by dougaj4

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 , , , , , , , | 9 Comments