Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- ULS Design Functions 2.13
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Downloads
- Fitting high order polynomials
- Buckling of columns with varying cross section
Recent Comments
Category Archives: Newton
py_ConBeamU and Strand7 check updates
Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
Leave a comment
ConBeamU and Strand7 check update
Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units, VBA, Working with units.
1 Comment
py_UMom 1-05
Following the previous post the OptShearCap3600 function has been modified to give correct results with negative bending moments. The revised spreadsheet and Python code can be downloaded from: py_UMom.zip Typical output with negative moment input:
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete
Leave a comment
py_UMom 1.04
The py_UMom spreadsheet has been updated with further revisions to the py_OptShearCap3600 function. The new version can be downloaded from: py_UMom.zip For more information on the other functions in the spreadsheet see: py_UMom spreadsheet and OptShearCap3600 function. The changes to the … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete
1 Comment
Mandelbrot, Mojo, Numpy and Numba
I recently read an article about connecting Python to the new Mojo language: Python Can Now Call Mojo The article had some code examples, including code to plot the Mandelbrot set, comparing plain Python, Python with Numpy, and Mojo, and what … Continue reading
Posted in Arrays, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Mandelbrot, Numba, Numba Guvectorize, Numpy, Plot Python in Excel, Python, PyXLL
Leave a comment