[Ed Law]

Originally Posted by Ether

Did you try making [A], [A'], and [N] integer instead of floating point? If VBA supports integer matrix multiplication that would probably substantially reduce the computation time. Use the native word size of your machine for the integer size. Your machine is probably 64bit word size? So make the elements of each matrix 64-bit integers.



Once you've created [N]=[A'][A] you can use that [N] matrix to solve for all 6 components at once.

[N][x]=[d]

If you make [d] a 6-column matrix instead of a vector you can solve it once and get a 6-column matrix [x] with all 6 solutions.

The solver I have is expecting a vector d so I cannot use a 6 column matrix like you suggested. I agree it will have some improvement in efficiency but I cannot do it that way.