A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tennis Scorecard Help



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2010, 03:24 AM posted to microsoft.public.excel.worksheet.functions
airolg
external usenet poster
 
Posts: 1
Default Tennis Scorecard Help

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







  #2  
Old May 24th, 2010, 03:42 AM posted to microsoft.public.excel.worksheet.functions
Brad
external usenet poster
 
Posts: 943
Default Tennis Scorecard Help

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
= (B26)+(c26)+(len(d2)0)*(d26)

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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.