Tag Archives: Excel

Secondary moments in prestressed beams with FEA

Posted on 09/01/2023 by dougaj4

Secondary (or hyperstatic) bending moments occur in prestressed beams that are continuous over internal supports, or have other redundant support conditions. Any eccentric prestress force will cause a beam to deflect, and if these deflections are restrained at internal supports, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , , | 1 Comment

More on combined shear and bending design to AS 3600

Posted on 15/12/2022 by dougaj4

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 4 Comments

Latex Maths Text in Excel

Posted on 27/11/2022 by dougaj4

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , | Leave a comment

RC Design Functions 9.03; compression strut angle adjustment

Posted on 11/11/2022 by dougaj4

The RC Design Functions spreadsheet has now been updated to Version 9.03, and is available for free download from: RC Design Functions9.zip The new version includes a number of corrections to the calculation of beam shear and torsion capacity to … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 2 Comments

Linking to Python help from Excel

Posted on 06/11/2022 by dougaj4

The py_Numpy spreadsheet presented in the previous post has been updated: The new version can be downloaded from: py_Numpy.zip As before, the pyxll add-in is required for the connection from Excel to Python. All the available functions are listed on … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment