A linear equation solver in excel

[dooley5]

I have put some examples together in an extract I call "Matrix Magic", it demonstrates the use of a linear equation solver I created on a spreadsheet, it is useful in analysing dc electrical circuits amongst other things. It also includes a good example of linear programming, a useful tool for Production Engineers these are available at my website

http://www.anglo-african.com,

I think you would find these interesting and useful.

 

[IDS]

dooley - you might like to have a look at using the Excel functions MINVERSE() and MMULT().

More information at:

http://newtonexcelbach.wordpress.com/2008/08/27/solving-simultaneous-equations/

You can also find a Fortran program that can be accessed from Excel at:

http://newtonexcelbach.wordpress.com/2008/12/20/solving-simultaneous-equations-fortran-dll/

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/