Microsoft Excel Goal Seek Algorithm

February 20, 2009, 07:53

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

March 5, 2009, 03:35

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

February 20, 2009, 07:53	Microsoft Excel Goal Seek Algorithm	#1
Bren Guest Posts: n/a	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

March 5, 2009, 03:35	Re: Microsoft Excel Goal Seek Algorithm	#2
Nethanel Rukhimovich Guest Posts: n/a	Revealed by MS itself: http://support.microsoft.com/kb/100782

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CFX11 + Fortran compiler ?	Mohan	CFX	20	March 30, 2011 18:56
Help for udf compile error	richard	FLUENT	3	October 12, 2003 23:13

June 12, 2012, 03:13		#3
marygrace New Member mary grace Join Date: Jun 2012 Posts: 1 Rep Power: 0	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