Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
Recent Comments
Category Archives: VBA
Two views on VBA
First from Microsoft: Microsoft are continuing their quest to make downloading spreadsheets with macros ever more difficult, and now any downloaded spreadsheet has VBA code disabled by default. Unblocking the code (if you know and trust the source of the … Continue reading
ULS Design Functions 2.16
The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading
Using ConbeamU
This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/viewthread.cfm?qid=501339 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, UDFs, Units, VBA, Working with units
5 Comments
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
1 Comment
Solving cubic equations – background and timing
For more information on the polynomial functions, including quartic and higher order solvers, see: Solving Quadratic, Cubic, Quartic and higher order equations; examples Re-reading the Wikipedia article on solving cubic equations, I noticed that the trigonometrical solution for finding 3 real … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged cubic equations, Excel, Numba, Numpy, Polynomials, Pyhon, PyXLL, Quartic equations, UDFs, VBA
Leave a comment