Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
- About Newton Excel Bach
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Newton
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
py_RC Design 2
Following the previous post, the py_RC Design spreadsheet has been updated with improved versions of the py_UMomp and py_UMomBiax functions. The revised version can be downloaded from: py_RC Design.zip The py_UMomp function is based on the Umom function, with the … Continue reading