Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Category Archives: Strand7
3DFrame-py; with non-linear analysis
Exactly a year since the previous update I have revised the 3DFrame-py spreadsheet with the addition of non-linear analysis options. The new files can be downloaded from: 3DFrame-py.zip Details of file installation, and required software are at: 3DFrame-py Minor revisions … Continue reading
py_Conbeam – 5
… or perhaps one more. Following the previous post I have modified the py_BeamAct3D function to fix some problems with the non-linear analysis. The latest version, together with an additional spreadsheet comparing results with Strand7, can be downloaded from: py_ConBeamU.zip … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged beam analysis, Cantilever beams, continuous beams, Excel, Python, PyXLL, py_BeamAct3D, py_Conbeam, Strand7, UDFs
Leave a comment
py_Conbeam – 4
The last post in the current series compares results from the py_Conbeam function with beam analysis results from the Strand7 FEA software. There have been further significant changes to the Python code and the spreadsheet, so please download the latest … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged beam analysis, Cantilever beams, continuous beams, Deflection due to shear, Excel, Python, PyXLL, py_Conbeam, Strand7, UDFs
1 Comment
Solving the 4 point lift problem …
… with Excel, Python and pyxll. The problem involves the lifting of a precast concrete panel (or any other long thin object) with lifting points at four sections along the length of the panel, and with the load connected to … Continue reading
Posted in Concrete, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 4 point lifting, Excel, Non-linear solvers, precast lifting, Python, PyXLL, SciPy, UDFs
Leave a comment
3DFrame-py update
The Python 3DFrame spreadsheet has been updated to allow for analysis including torsional warping effects. The new spreadsheet and associated Python files can be downloaded from: 3DFrame-py.zip The download file includes four sample spreadsheets comparing analysis results with output from … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame-py, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment