CFD Online Discussion Forums

CFD Online Discussion Forums (https://www.cfd-online.com/Forums/)
-   Main CFD Forum (https://www.cfd-online.com/Forums/main/)
-   -   Microsoft Excel Goal Seek Algorithm (https://www.cfd-online.com/Forums/main/16379-microsoft-excel-goal-seek-algorithm.html)

Bren February 20, 2009 08:53

Microsoft Excel Goal Seek Algorithm
 
Hi Guys, I was wondering if anyone knows what solution method Microsoft Excel uses in its Goal Seek function?

It seems pretty fast and I was wondering whether it may be worthwhile duplicating the algorithm for solving some nonlinear eqns in Fortran. Cheers Bren

Nethanel Rukhimovich March 5, 2009 04:35

Re: Microsoft Excel Goal Seek Algorithm
 
Revealed by MS itself: http://support.microsoft.com/kb/100782

marygrace June 12, 2012 03:13

So you mean there are also algorithm goals soak in the microsoft excel? I just don't know that means to me too and i really want to learn from that too. project 2007 online training


All times are GMT -4. The time now is 09:37.