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
- Intersections, interpolations, and rotations
- Downloads
- Fitting high order polynomials
- Buckling of columns with varying cross section
Recent Comments
Category Archives: Maths
Mandelbrot, Mojo, Numpy and Numba
I recently read an article about connecting Python to the new Mojo language: Python Can Now Call Mojo The article had some code examples, including code to plot the Mandelbrot set, comparing plain Python, Python with Numpy, and Mojo, and what … Continue reading
Posted in Arrays, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Mandelbrot, Numba, Numba Guvectorize, Numpy, Plot Python in Excel, Python, PyXLL
Leave a comment
py_Numpy update 2: Polynomial functions
Continuing from the previous post, this post looks at the polynomial functions in the revised py_Numpy spreadsheet. The updated code and spreadsheet can be downloaded from: py_SciPy.zip The available functions call the Numpy functions for solution and evaluation of polynomials, … Continue reading
Posted in Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Numba, Numpy, Polynomial functions, Python, PyXLL, UDFs
Leave a comment
Long integers in Python and Excel and py_Fact
I have added a new py_Fact function to the py_Scipy module, that returns the factorial of an integer as a float if it is up to 15 digits long, or a string for longer numbers. The revised code, and the … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Factorial function, Python, PyXLL, SciPy, UDFs
Leave a comment
Python functions for rotation
I have recently needed code to rotate 2D coordinates, either about the origin, or some specified other point, using pyxll to call the code from Excel. My first attempt was a direct translation of some VBA code, that also worked … Continue reading
Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, PyXLL
Tagged Excel, Matrix methods, Numpy, Python, PyXLL, rotation functions, UDFs
Leave a comment
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