Tag Archives: Goal Seek

Alternative iterative solvers

Posted on 03/03/2026 by dougaj4

This post looks at alternative solutions to a problem posted on Quora: How can 2^x = 10x be solved? One of the alternatives requires a new function linking to Scipy that has been added to the pyScipy module, that can be downloaded … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Automating Goal Seek with RC Design Functions

Posted on 29/05/2016 by dougaj4

As promised in the previous post, I will now look in more detail at the process for automating the Excel Goal Seek function with the RC Design Functions spreadsheet, to calculate reinforcement area or section depth for a range of bending … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 10 Comments

RC Design Functions update

Posted on 21/05/2016 by dougaj4

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Using Goal Seek on a multi-column range

Posted on 20/05/2013 by dougaj4

Following a comment requesting help using my Goal Seek spreadsheet I have modified the macro to allow it to operate on a multi-column range.  The spreadsheet can be downloaded from GSeek.zip, including the solution to the problem described below. The … Continue reading →

Posted in Excel, VBA | Tagged , , , | Leave a comment

Goal Seek Macro for Multiple Sheets

Posted on 30/01/2013 by dougaj4

Following a comment on the Using Goal Seek on Multiple Cells post, I have modified the macro so that the goal-seek ranges can be on a different sheet to the named input ranges.  The new file can be downloaded from: GSeek.zip. … Continue reading →

Posted in Excel, VBA | Tagged , , , | 4 Comments