With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, August 14, 2011
yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern - 2
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