|
Re: OPR Formula
Ether,
Your republished numbers are very close to mine now. I also used double precision. My implementation is done in Excel using VBA. I do not actually put the 2053 X 2053 matrix inside the spreadsheet so it works in older version. The program read in the match results and assemble the matrix. It is just stored in the memory for the calculation. Solving the equations inside Excel using VBA is probably slower than outside in another app. Tom Line mentioned they are solving the equations using Excel built-in solver. I am curious what algorithm they use and how fast that would be.
How come you only have 2052 teams? I have 2053 teams in 2011.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
Last edited by Ed Law : 31-01-2012 at 16:58.
|