Chief Delphi - OPR Formula

Page 5 of 5

Show 100 post(s) from this thread on one page

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)

- Scouting (http://www.chiefdelphi.com/forums/forumdisplay.php?f=36)

- - OPR Formula (http://www.chiefdelphi.com/forums/showthread.php?t=101390)

Ben Martin

26-02-2012 13:49

Re: OPR Formula

Quote:

Originally Posted by Ether (Post 1135024)

Is this limited to processing single tournaments, or can it process an entire year's worth of data (in one large matrix) to get a year-end ranking?

I tried adapting the file to do this, but my current computing resources lack the memory to pull this off with my current algorithm. It does pull data and calculate for single competitions, though.

Ether

26-02-2012 15:16

Re: OPR Formula

Quote:

Originally Posted by BMartin 234 (Post 1135127)

I tried adapting the file to do this, but my current computing resources lack the memory to pull this off with my current algorithm. It does pull data and calculate for single competitions, though.

I see you are using Excel 2007 Mac. Is the problem a limit in the maximum number of columns in a worksheet?

If so, there are options:

1) You could upgrade to Excel 2010 which I believe has substantially expanded the maximum number of columns in a worksheet

2) You could construct the matrix in a VBA macro instead of spreadsheet cells and do the math on it there.

If you do option 2, you should seriously consider factoring the matrix instead of inverting. It's far faster and less susceptible to numerical instability.

Ben Martin

26-02-2012 15:23

Re: OPR Formula

Quote:

Originally Posted by Ether (Post 1135177)

I see you are using Excel 2007 Mac. Is the problem a limit in the maximum number of columns in a worksheet?

If so, there are options:

1) You could upgrade to Excel 2010 which I believe has substantially expanded the maximum number of columns in a worksheet

2) You could construct the matrix in a VBA macro instead of spreadsheet cells and do the math on it there.

If you do option 2, you should seriously consider factoring the matrix instead of inverting. It's far faster and less susceptible to numerical instability.

1) Nope, already using Excel 2010 on a Purdue University Windows computer.
2) Already doing this, all the calculations are done in code

I'll look into factoring. This was a quick-and-dirty, how easy can I make this solution originally intended for just finding OPR's for a given regional.

Ether

26-02-2012 15:34

Re: OPR Formula

Quote:

Originally Posted by BMartin 234 (Post 1135182)

1) Nope, already using Excel 2010 on a Purdue University Windows computer.

I was going by what was posted here.

Quote:

Already doing this, all the calculations are done in code

Why are you running out of memory? Even 2 Gig should be plenty, no?

Quote:

I'll look into factoring. This was a quick-and-dirty, how easy can I make this solution originally intended for just finding OPR's for a given regional.

Google Cholesky. It's not hard to code.

MarkOfDinosaur

26-02-2012 17:21

Re: OPR Formula

Finally got it. Thanks for all your help Ether. Phew, it's very satisfying to finally have it working. Thanks again.

Ether

26-02-2012 17:39

Re: OPR Formula

Quote:

Originally Posted by MarkOfDinosaur (Post 1135233)

Finally got it. Thanks for all your help Ether. Phew, it's very satisfying to finally have it working. Thanks again.

Way to hang in there !!!

All times are GMT -5. The time now is 04:18.

Page 5 of 5

Show 100 post(s) from this thread on one page