Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- ULS Design Functions 2.13
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Buckling of columns with varying cross section
- Intersections, interpolations, and rotations
- Fitting high order polynomials
- Downloads
Recent Comments
Tag Archives: Sympy
Evaluate and display definite integrals in Excel with Latex and Matplotlib
The py_Evalu spreadsheet was last presented at Scipy Functions with Excel and pyxll 5 – Evaluate with Units and included the Plot_Math function, which converts a text string to Latex format, then uses Matplotlib to convert this to a graphic image, … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, PyXLL, UDFs
Tagged Definite Integrals, Excel, Latex, MatPlotlib, Plot_Math, Plot_Quad, Python, PyXLL, py_EvalU, py_Scipy, SciPy, Sympy, UDFs
Leave a comment
Scipy Functions with Excel and pyxll 6 – Integration
The py_Integrate spreadsheet, with associated Python code in pyScipy3.py, are included in the download file: py_SciPy.zip The spreadsheet and associated Python packages have had significant edits since the first post in this series, so please download the latest file. Details … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Integration, multiple integration, Numpy, Python, PyXLL, Quadrature, SciPy, Sympy, Tanh-Sinh Quadrature, UFFs
Leave a comment
Scipy Functions with Excel and pyxll 5 – Evaluate with Units
The Scipy series continues with the py_EvalU spreadsheet included in the download file: py_SciPy.zip The spreadsheet and associated Python packages have had significant edits since the first post in this series, so please download the latest file. Details of the … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Implied units, Latex, mpmath, Numpy, Optimize, Pint, Python, PyXLL, py_EvalU, SciPy, Sympy, UDFs, Unit conversion
2 Comments
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 EvalU, Excel, Latex, Math Text, mpmath, Pint, Python, PyXLL, Sympy, UDFs, Unit-aware calculation
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 Excel, installation, kaleido, MatPlotlib, mpmath, Numba, Numpy, Pint, plotly, PyPardiso, Python, PyXLL, SciPy, sectionproperties, Sympy
2 Comments