Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- 3DFrame - 3D Frame analysis for Excel
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Category Archives: NumPy and SciPy
py_Conbeam – 3
Continuing from the previous post, we will move on to the py_Conbeam and py_MovLoad functions, that combine with the previous functions to analyse continuous beams with any number of spans and section types, under static or moving loads. As before, there … Continue reading
py_ConBeam – 2
Continuing from the previous post, today I will be looking at the Macaulay function, that performs the underlying analysis, and the application of this function to cantilevers and single span beams. There have been some significant changes to the Python … Continue reading
py_ConBeamU
I have now converted the VBA code in the ConBeamU spreadsheet to Python, connected to Excel via pyxll. The new spreadsheet and associated Python code can be downloaded from: py_ConBeamU.zip In addition to the provided files, the pyxll application is … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
4 Comments
py_RC Elastic update 2
Following the previous post, I have added a further new function, and in the process discovered that the py_Estress function was not handling tensile axial loads correctly. That has now been fixed, and the updated spreadsheet and Python files can … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Concrete creep and shrinkage, Creep and shrinkage development, Excel, Python, PyXLL, Reinforced Concrete, SciPy, UDF
Leave a comment
py_RC Elastic update
Following the previous post I have updated the py_RC Elastic spreadsheet and code to work with the new solver function, and also add new functionality. The updated files can be downloaded from: py_RC Elastic.zip For details of the pyxll app … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Concrete creep and shrinkage, Eurocode 2 concrete properties, Excel, Python, PyXLL, RC moment-curvature, UDFs.
Leave a comment