Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- Daily Download 4: Continuous Beam Analysis
- Daily Download 5: Frame Analysis
- The angle between two vectors, Python version
- Downloads
- About Newton Excel Bach
Recent Comments
Category Archives: Newton
Scipy solver update
The py_SolveFS function calls the Scipy optimize.root function to solve multi-variable equations. Examples are found on the py_Solvers spreadsheet, see Scipy Functions with Excel and pyxll 4 – Solvers 2. One problem with using this function is that the input data … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Python, PyXLL, py_SolveFS, SciPy, Scipy root function, Solver functions, UDFs
Leave a comment
Pale Blue Dot
34 years ago Carl Sagan presented an image of the Earth taken from outer space, known as the pale blue dot. An event very different from a 13 year old boy singing a song he had written himself, but the … Continue reading
Rory Phillips – The Truth
“‘The Truth’ is a passionate call to action on climate change from 13 year old Rory Phillips. “I wanted to say something with this song. The lyrics are subtle, not in your face; but the message is clear. We need … Continue reading
Let, Lambda, and py_Eval
I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365 subscribers, so I have now looked at … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged evaluate text strings, Excel, Lambda Function, Let function, Python, PyXLL, py_Eval function, UDF
Leave a comment
SLS Concrete design with Python
I am in the process of converting the SLS design related functions in the RC Design Functions spreadsheet to Python code. The current version can be downloaded from: py_RC Elastic.zip For details of the pyxll app required to conect the … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Circular sections, Excel, moment curvature, Python FEA code, PyXLL, Reinforced Concrete, SLS design functions, UDFs
2 Comments