Anyone wrote VBA for calc'ing determinant of 3x3 matrix?

[MLH]

Just didn't wann reinvent the rolly thing.

[jimfortune]

MLH wrote:

Just didn't wann reinvent the rolly thing.

I'll look around at home. The VBA version I wrote is more robust than
standard Gaussian Elimination because it implements full pivoting.
When using matricies for things like linear regression, numerical
instabilities often crop up because those matricies typically have very
small determinants. The pivoting scheme gets around that problem. I
just hope the magnetic charge on that old floppy disk hasn't made it
unreadable. If you don't need pivoting, look under 'Gaussian
Elimination' in any Numerical Methods book to get an algorithm.

James A. Fortune

[MLH]

Thx, Jim. Save yourself some time. I went ahead 'n
scratched one out. Seems to work. Glad its behind
me.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 29 Aug 2005 10:38:11 -0700, ji********@compumarc.com wrote:

MLH wrote:

Just didn't wann reinvent the rolly thing.

I'll look around at home. The VBA version I wrote is more robust than
standard Gaussian Elimination because it implements full pivoting.
When using matricies for things like linear regression, numerical
instabilities often crop up because those matricies typically have very
small determinants. The pivoting scheme gets around that problem. I
just hope the magnetic charge on that old floppy disk hasn't made it
unreadable. If you don't need pivoting, look under 'Gaussian
Elimination' in any Numerical Methods book to get an algorithm.

James A. Fortune