Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Downloads
- Continuous Beam Spreadsheet - with Units
- Daily Download 4: Continuous Beam Analysis
- The angle between two vectors, Python version
Recent Comments
py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an…
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