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 , , , , , , | 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

Posted in Excel, Maths, VBA | Tagged , , , | 17 Comments