Tag Archives: Pint

Latex Maths Text in Excel

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

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

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

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