Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Using Linest for non-linear curve fitting, examples, hints and warnings
- 3DFrame - 3D Frame analysis for Excel
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Newton
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
The iccanobiF Sequence
Coincidentally, following the previous post, New Scientist’s regular brain teaser featured the iccanobiF Sequence, which is just like the Fibonacci Sequence, except that after adding the two previous numbers the digits of the results are reversed. Obviously the sequences are … Continue reading
Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs
Tagged Excel, Fibonacci Sequence, iccanobiF Sequence, Python, PyXLL, UDF's
Leave a comment
Python functools and the Fibonacci Sequence
The Python functools module has been around since 2006, so it’s not exactly new, but it is something I don’t currently use, but with potential to be useful. This link: Functools module in Python provides details and examples of all … Continue reading
Random numbers, palindromes and Numpy update
This post looks at some of the options for generating random numbers in Excel and Python. The code and example spreadsheets can be downloaded from: Updated Numpy files at: py_SciPy.zipCode added to the Pandigital files at: Pandigitals.zip The py_SciPy download … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Numpy, Palindrome numbers, Python, PyXLL, Random numbers, UDFs
Leave a comment
Python Data Classes
I have recently been catching up with new Python features, starting with Data Classes which were introduced in Python version 3.7. For information and code examples I have referred to: Data Classes in Python 3.7+ (Guide) at Real Python The … Continue reading
Posted in Coordinate Geometry, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Python, Python Data Classes, PyXLL, Real Python, Spherical distance, UDFs, Vincenty's method
2 Comments