Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Smart Indenter and Excel 2013
- Converting from global to local coordinates (and vice versa)
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Buckling of columns with varying cross section
- Fitting high order polynomials
Recent Comments
Tag Archives: Goal Seek
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
Using Goal Seek on Multiple Cells
The Excel “goal seek” function is useful and powerful, but the procedure for using it on multiple cells is painfully slow. The spreadsheet GSeek.xls provides a simple macro to allow Goal Seek to be automatically applied to a range of … Continue reading