Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Biaxial bending update
- Fitting high order polynomials
- Daily Download 3: ULS design of reinforced concrete sections
- Buckling of columns with varying cross section
- Linking Excel to C - 2
- Retrieving unique values from a range or array ...
Recent Comments

Z on Downloads 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…
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