Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
Recent Comments
Category Archives: Newton
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
py_RC Design
The py_RC Design spreadsheet provides Python versions of the reinforced concrete design functions in the RC Design Functions spreadsheet. The current version can be downloaded from: py_RC Design.zip See also: SLS Concrete design with Python for additional SLS design related functions. … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged AS 3600, biaxial bending, Eurocode 2, Excel, Python, PyXLL, Reinforced Concrete, UDFs, ULS Design Functions
1 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