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
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
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…
Tag Archives: Numpy
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
Pandigital sums and Python permutations and combinations
The New Scientist brain twister from last weeks edition has several problems involving pandigital sums, which are additions that use each of the digits from 0 to 9 exactly once, and with no number within the sum that starts with … Continue reading
Posted in Arrays, Computing - general, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged combinations, itertools, Numpy, Pandigital sums, permutations, Python, PyXLL, VBA
Leave a comment
3DFrame-py-comb
The 3DFrame-py spreadsheet has now been updated with provisions for saving multiple load cases and the associated results, and analysis with factored combinations of multiple load cases. The new files can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and … Continue reading
3DFrame-py rel. 0.40
A new version of 3DFrame-py has been released and can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and details of other Python modules required. Also see Python and pyxll for details of the required pyxll package, including a coupon code for … Continue reading
3D-Frame-py with Numba
I recently upgraded to Python 3.12, and installed the latest version of the Numba just-in-time compiler (0.60.0) which also required upgrading Matplotlib (3.9.3), and downgrading Numpy (2.0.2). I have also edited calls to Numba in the py_3DFrame1_1.py module, and added … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 3DFrame-py, Excel, Frame Analysis, Geometric non-linearity, Installing Python packages, Material non-linearity, non-linear analysis, Numba, Numpy, PyPardiso, Python, PyXLL, SciPy
Leave a comment