Recent Comments
dougaj4 on Weighted Least Squares Regress… 
NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… 
John Maddock on Numerical Integration With Tan… 
Graeme Dennes on Numerical Integration With Tan… dougaj4 on Numerical Integration With Tan… dougaj4 on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… Making Finite Elemen… on Making Finite Element Analysis… 
Chartree on ULS Design Functions 2.13 dougaj4 on ULS Design Functions 2.13 Chartree L. on ULS Design Functions 2.13 dougaj4 on ULS Design Functions 2.13 Chatree L. on ULS Design Functions 2.13 ConbeamU update | Ne… on ConbeamU 4.10
Tag Archives: Sympy
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
9 Comments
