Quote:
Originally Posted by Ed Law
I need a faster computer to do this!
|
Ed, see the email I just sent you. You can generate the [N] matrix directly (with surrogates omitted) from the raw match results data, bypassing the [A']*[A] operation. [N] will still be symmetric positive definite if you do it right. Let me know if you need more info.
FWIW:
Tools like Octave support sparse matrices. Perhaps the most recent versions of VBA also do?
Using sparse matrix technology, Octave takes only 16
milliseconds to compute [N]=[A']*[A], and another 16
milliseconds to compute [x]=[N]\[d], for 1812 teams and 7292 alliance scores (3646 matches).
PS: This might be a quick fix: Does your version of VBA support
integer multiplication of integer matrices? Both [A] and [N] are integer. Set the integer size to the native word size of your machine (probably 64-bit).
PPS: I attached the [A] and [N] matrices if anyone is curious.