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: MatPlotlib
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
Plotting Carlyle’s Circle with Matplotlib in Excel
Recently I happened to read of Carlyle’s Circle, which is a circle that has two intersection points with a parabola on the X axis. See the Wikipedia article for more details: https://en.wikipedia.org/wiki/Carlyle_circle This post looks at the options for plotting … Continue reading
Posted in Charts, Drawing, Excel, Link to Python, Maths, Newton, PyXLL, UDFs
Tagged Carlyle's Circle., Excel, MatPlotlib, Plotting functions, Python, PyXLL, py_EvalU
Leave a comment
3DFrame-py rel. 0.50
Following the recent post on the Python lru_cache function (Python functools and the Fibonacci Sequence) I have had a look at using lru_cache in the 3DFrame-py spreadsheet. So far using lru_cache in this code has provided little to no speed improvement, … Continue reading
Posted in Beam Bending, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 3D plots, Excel, Frame Analysis, MatPlotlib, Numba, PyPardiso, Python, PyXLL
Leave a comment
Scipy Functions with Excel and pyxll 9 – Special, distance, space and constants functions and FFT
In the final post in this series I will look at linking Excel to the Scipy special, distance, space and constants functions and also the Fast-Fourier Transform (FFT) functions. The py_Special-Dist and py_FFT spreadsheet, with associated Python code in PythonSpaceFuncs3.py … Continue reading
Posted in AlgLib, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged CODATA constants, Distance functions, Excel, FFT, Help function, MatPlotlib, Python, PyXLL, SciPy, Scipy comstants, Scipy Constants, Space functions, Special functions, UDFs
Leave a comment
3D plots with the latest Matplotlib
Installing Python on a new computer, I found I had to downgrade Matplotlib to release 3.5.2 to get my 3D plotting functions to work. Further investigation found that the problem was the Axes3D function. Changing: ax = axes3d.Axes3D(fig)to: … Continue reading
Posted in Animation, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
4 Comments