The ultimate goal is to rank each player after each match so that I know from
week to week who the top three are. After the matches, we are going to do a
tournament and it would be cool if I could maintain it and know the minute
the last match was played, I'd know how to set up the tournament.

Two out of three sets to win.

Column Headings (maybe):

Name (plain text)
Score Set 1 (number 0-6)
Score Set 2 (number 0-6)
Score Set 3 (only if needed)
Matches Won (If there are 2 6's in any of the scores cells, consider it a win
and input a 1?)
Matches Lost (same above only reverse)
Sets Won (is there a way I can tell it look at the three cells and count if
there are
any 6s and calculate the number of sets won? or is it just as
easy/accurate
for me to input that?)
Sets Lost (same as above, if not 6 or higher would be a loss?)
Games Won (This would count all the scores 6-0, 6-0 and make it equal 12)
Games Lost (Not sure how I could get it to calculate this?)
Total Points (You get a point for each match won)
Points Lost (you get a point for each match loss)
Ranking (based on number of points, if tied, look at games won)

Not sure how I tell this worksheet who they played each week to generate the
games won/lost.

So, I can do all of this manually, but I know it should be able to calculate
all this for me. <grin

After that, I would want it to be accumulative. Am I going about this all
wrong? How am I going to get it to add the stats together each week?

I have 14 players and 13 matches, so it wouldn't be too hard to do it
manually, but I'd love for it to do it automagically.

Any help would be appreciated. Too hard to help me?

Gloria

Several formulas will be needed
For matches won - what happens if there is a tie breaker and the both have 6
games won?

Ignoring that question

assume
score set 1 is in column b
score set 2 is in column c
score set 3 is in column d
matches won is in column e

in E2
=(b2=6)*(c2=6)+(len(d2)0)*(d2=6)
In words - if the person wins the first two set - score a 1 - otherwise if
they win the third set - score a 1


Matches lost is in column f
if F2
=1-(b2=6)*(c2=6)+(len(d2)0)*(d2=6)

Sets won is in column g
= (B2=6)+(c2=6)+(len(d2)0)*(d2=6)

Sets lost is in column g
= (B2<6)+(c2<6)+(len(d2)0)*(d2<6)

The other formulas are similar - does that get you started?

Click yes for success
--
Wag more, bark less


"airolg" wrote:

The ultimate goal is to rank each player after each match so that I know from
week to week who the top three are. After the matches, we are going to do a
tournament and it would be cool if I could maintain it and know the minute
the last match was played, I'd know how to set up the tournament.

Two out of three sets to win.

Column Headings (maybe):

Name (plain text)
Score Set 1 (number 0-6)
Score Set 2 (number 0-6)
Score Set 3 (only if needed)
Matches Won (If there are 2 6's in any of the scores cells, consider it a win
and input a 1?)
Matches Lost (same above only reverse)
Sets Won (is there a way I can tell it look at the three cells and count if
there are
any 6s and calculate the number of sets won? or is it just as
easy/accurate
for me to input that?)
Sets Lost (same as above, if not 6 or higher would be a loss?)
Games Won (This would count all the scores 6-0, 6-0 and make it equal 12)
Games Lost (Not sure how I could get it to calculate this?)
Total Points (You get a point for each match won)
Points Lost (you get a point for each match loss)
Ranking (based on number of points, if tied, look at games won)

Not sure how I tell this worksheet who they played each week to generate the
games won/lost.

So, I can do all of this manually, but I know it should be able to calculate
all this for me. <grin

After that, I would want it to be accumulative. Am I going about this all
wrong? How am I going to get it to add the stats together each week?

I have 14 players and 13 matches, so it wouldn't be too hard to do it
manually, but I'd love for it to do it automagically.

Any help would be appreciated. Too hard to help me?

Gloria