Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Daily Download 5: Frame Analysis
- Contour plots with Excel and Matplotlib
- Downloads
- Latex Maths Text in Excel
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: Numpy
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
Numpy where and split, and py_Numpy update
The py_Numpy spreadsheet and associated code has been updated, with two new functions, links to the Numpy on-line help updated, and updates to sorting and polynomial functions. The updated code and spreadsheet can be downloaded from: Updated Numpy files included … Continue reading
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
Importing text files with Python and pyxll
VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading
Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs
Tagged Convert string to values, Excel, import text, Numpy, PyXLL, UDFs
Leave a comment