2015 OPR After Week Three Events

[Ether]

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.