Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Time in hours and minutes between two dates
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The angle between two vectors, Python version
- Cubic Splines
Recent Comments
Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…
Tag Archives: composite concrete beam
Composite Beam Spreadsheet 3
The Composite Beam Analysis spreadsheet, previously discussed at: https://newtonexcelbach.wordpress.com/2012/04/27/composite-beam-spreadsheet-2/ has now been updated with a VBA User Defined Function (UDF) in place of the previous macro that used the Excel Goal-Seek command. This has two main advantages: The UDF is much faster … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Brents method, composite concrete beam, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
5 Comments
Composite Beam Spreadsheet – 2
The previous post on this topic presented a spreadsheet performing elastic analysis of composite reinforced or prestressed composite beams, available for download from: Composite Design Functions-GS.zip. This post will look in more detail at how the spreadsheet works, and a preview … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
4 Comments
Composite Beam Spreadsheet
As promised in the previous post, a spreadsheet for designing reinforced or prestressed concrete composite beams has now been uploaded to my web site. It can be downloaded from: Composite Design Functions-GS.zip . As usual, the spreadsheet includes full open-source code. … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments