Sunday, August 14, 2011

yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern - 2

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

gookon said ...
(for my earlier Blog post on gookon's project see ... yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern
 Hello again yogia,sorry for the late response,had to go out of town for a day.In the following spreadsheet,the 4th column under each player shows points awarded to that player after each fixture.The 5th column under each player is a total of the points awarded to that player after each fixture.I am using the 3rd column under each player to determine that players rank from the 5th column under each player.

While the worksheet is currently working correctly(with only 5 test players),it will not if there are identical rank values,that can be fixed but become extremely long when many more players are added.Your method,if it can be tweaked to work correctly would be a far more economical method.
https://spreadsheets.google.com/spreadsheet/ccc?key=0Aqj7-eahzGqPdFhIaDdVVnNvSUthQVhyRWFhUW05MWc&hl=en_US
-------------------------------------------------------------------
In my earlier post I computed the rank for points in the same row ... however that was based on forward data only to alleviate the issue of circular referencing.

So in this case, I have considered computing the rank in one row down from the row where the player points are recorded