SOLVED Ladder Ranking for Tennis

**clundeen** · 01-11-2011, 05:37 PM

We have a round robin doubles league for Platform Tennis and I want to have a master ladder worksheet to score and generate rankings. I have a worksheet named Rankings with a 1-63 currently setup. Across the top I have wins, losses, games won, lost. I figure if someone wins 6-0, 6-1 they deserve a bonus to the win loss record.

I now generated a template with blank fields to enter player number and simple calculation cells to determine games won lost and who won match. What I can't figure out...is there a way to add that data from week 1, week 2 worksheets to the win/loss columns for the player entered in the "rankings" worksheet? Meaning the say, cell F3 is 12 and represents player ranked 12th. He won 17 games , lost 12 and won match . Take that data and look on "rankings worksheet" column A for the number = 12 and add a 1 to current total of wins column K add 17 to column L and 12 to column M in what ever line that has number same as number entered in schedule template

Any thoughts?

**watersev** · 01-11-2011, 05:49 PM

without your sample workbook it sounds like a rocket science

**clundeen** · 01-11-2011, 11:28 PM

Here is a sample match where 1st, 2nd, 7th and 9th rank play a match. 1 plays with 9 and 2 with 7 selected via =small. The set scores are in yellow and I created match won (MW) match loss (ML), game won(GW) and game loss(GL) on the far right. The H column just reorgs in order in case there is a sub.

I want to transfer the data from MW,ML,GW,GL columns to another workbook that coresponds to a predetermined columns but have the row in that workbook be determined by value in H3,H4,H5,H6. In otherwords, I want a add 1 match won for 1&9 and ML for 2&7....similar to GW, GL