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
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 2: SLS design of reinforced concrete sections ...
- Linking Excel to C - 2
- Downloads
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Author Archives: dougaj4
Some new (to me) music
Hugh Laurie started his career as straight man to Stephen Fry in comedy shows featuring sketches such as: Since then he has had great success as both a comedian and a straight actor, but until recently I had no idea … Continue reading
Posted in Bach
Tagged Bert Jansch, Fry and Laurie, Hugh Laurie, Mary Hopkin, Mr. Dalliard
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
Why use the walrus?
Continuing posts on new Python features, this one looks at the new walrus operator, which was introduced in Python 3.8. For a detailed description see Python Walrus Operator in Python 3.8. This post looks at an example using pyxll to … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs
Tagged Excel, Python, PyXLL, UDF's, walrus operator
Leave a comment
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