Quote:
Originally Posted by Rachel Lim
I'm forming matrices A, b, and T: T is the list of teams (Tx1), b is the list of scores (2Mx1), and A is a matrix of which teams were playing which matches represented as 0s and 1s (2MxT). I think that's the same A you're referring to...
|
Yes, that is called the "design matrix" of the system of linear equations. In the case of FRC OPR, it is dichotomous (binary) and very sparse.
Quote:
The equation to solve for OPR is put into the second row of the OPR tab:
=mmult(minverse(mmult(transpose(misc!A1:CX408), misc!A1:CX408)), mmult(transpose(misc!A1:CX408), misc!CY1:CY408))
|
That may well be your problem right there.
Try replacing that entire mess with one call to the LINEST function of Google Sheets.
EDIT: make sure the 3rd parameter in the LINEST function call is FALSE.