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
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- ULS Design Functions 2.13
- Buckling of columns with varying cross section
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
Recent Comments
Category Archives: Link to Python
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
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