Newton–Raphson method

[Engineer32]

Hi everybody!
I'm new in using Excel together with VB utilities and my problem is the following one:
I want to program the Newton–Raphson method (or a similar one) in a excel spreadsheet. The point is that the required value (let’s say cell D24) depends on the cell on the left (cell C24) and on the cell above (cell D23). The next step would be doing the same but for the cell on the right (cell E24) which would be depending on cell D24 and on cell E23. In fact, I’ve already solve it with the Maple-Excel Add in (command “fsolve”) but it works very slow.
Does anybody have any idea? Does anybody know how to program the Newton–Raphson method in VBA?


Thank you

 

[macropod]

Hi Engineer32,

Given what the Newton–Raphson method has to do, it's not surprising that it can take a while to do its thing - especially if there are a lot of data to work with.

It's almost certain your Maple-Excel Addin was written with vba - or maybe even something else with better optimisations, and you're unlikely to get a significant improvement by writing your own version.

FWIW, a web search on 'Newton–Raphson vba' turns up lots of hits. See, for example:

http://forums.devx.com/showthread.php?t=134018

and

http://www.digimode10.com/1shareware/ExcelVBAModelsSet3.htm

Cheers

[MS MVP - Word]

 

[electricpete]

Have you tried excel's solver add-in?