Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 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
- Writing Arrays to the worksheet - VBA function
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 5: Frame Analysis
- Automating chart scale limits - update
- About Newton Excel Bach
- Moving averages and User Defined Array Functions
Recent Comments
Category Archives: Newton
Secondary moments in prestressed beams with FEA
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
Which was Douglas Adams’ single best line of writing?
is a question from Quora, from which my favourite of the many responses was: For many more see: https://www.quora.com/Which-was-Douglas-Adams-single-best-line-of-writing
More on combined shear and bending design to AS 3600
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 Brents method, Combined shear and bending, Excel, Longitudinal shear force, Python, PyXLL, SciPy, shear capacity, UDFs
4 Comments
Latex Maths Text in Excel
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 EvalU, Excel, Latex, Math Text, mpmath, Pint, Python, PyXLL, Sympy, UDFs, Unit-aware calculation
Leave a comment
RC Design Functions 9.03; compression strut angle adjustment
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 AS 3600, AS 5100.5, Compression block angle, Design for Shear, Excel, Longitudinal shear force, Reinforced Concrete Design Functions, UDFs, VBA
2 Comments