Tipping Spreadsheets (for tournament managers) - TennisForum.com

 
LinkBack Thread Tools
post #1 of 12 (permalink) Old Jan 29th, 2012, 12:01 AM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Tipping Spreadsheets (for tournament managers)

A lot of people asked for a tipping spreadsheet...

Here are the spreadsheets that I created:

DOWNLOAD:

32-player draw (5 rounds): http://www.mediafire.com/download/dk...ipping_32.xlsx
64-player draw (6 rounds): http://www.mediafire.com/download/m0...ipping_64.xlsx
128-player draw (7 rounds): http://www.mediafire.com/download/5m...pping_128.xlsx

What it does:

- calculates scores
- creates a ranking
- breaks ties

The spreadsheets only work for up to 62 tipping players. If you need a "bigger" sheet... send me a PM.


Please read this tutorial on how to use the spreadsheet before using it:



Tutorial:

Step 1: Open the Excel file:

http://img515.imageshack.us/img515/5305/25985431.jpg

Step 2: Type in the entry-list



Step 3: Highlight the names and select "Sort&Filter"->"Sort A to Z" to sort the names from A to Z



Step 4: select "continue with the current selection"

http://img31.imageshack.us/img31/2595/48599962.jpg

Step 5: Put in everyone's picks - TIP: you only have to put in "A", in this case for "Azarenka" if you already put in "Azarenka" in the same row. If both players' names start with the same letter (for example: Schiavone vs. Sharapova) use F. Schiavone and M. Sharapova (you don't have to but it'll save you a lot of time)

The OOP of the day was: (example)

Azarenka vs. Watson
Dellacqua vs. Jovanovski
Jankovic vs. Robson
Brianti vs. Falconi
Voskoboeva vs. Wickmayer



Step 6: AFTER THE MATCHES ARE FINISHED: select "find&select"->"replace"



Step 7: Replace the winner with the correct amount of points (1 for Round 1; 2 for Round 2 etc.). Type in the name of the winner in "Find what" (in this case "Azarenka") and put in the points in "replace with" (1 for Round 1; 2 for Round 2 etc.).





Azarenka, Dellacqua, Jankovic, Brianti and Voskoboeva won their first round matches (1 point).



Step 8: Replace the loser's names with a "0" to avoid problems in later rounds.



Step 9: Hide completed rounds (not necessary but recommended)





Step 10: Switch to the "Ranking" sheet to have a look at the (automatically) calculated ranking.



Step 11: Repeat steps 5-10 for the following rounds (minus the final) - (remember to change the amount of points according to the round)





Step 12: BEFORE THE FINAL: put in everyone's picks (just like in the other rounds) AND the number of games in the row "Games" and the time of the pick in "Time". Time means the position at which a player posted his pick:

example:

These players posted a pick for the final (in the following order):

Djezonfly
JustPetko
Drake1980
klever58
SamR03A
Kev.

etc.

That means that you have to put in a "1" for Djezonfly, a "2" for JustPetko, a "3" for Drake1980 etc under "time".




Step 13: BEFORE THE FINAL: Go to the "Ranking" sheet and replace "Player A" and "Player B" (found in the yellow (they aren't yellow in the actual spreadsheet) cells) with the names of the two finalists to get a projected ranking which includes the 2 possible outcomes. (OPTIONAL)



Step 14: AFTER THE FINAL: Put in the number of games (example: Azarenka def. Sharapova 6-3 6-0 ---> 15)



Step 15: Replace the winner's name (in the "Picks" sheet) with the correct number of points (in this case (Grand Slam): 7 points)



Step 16: Switch to the "Ranking" sheet to see the final score



Step 17: Highlight the ranking and select "copy"->"copy as picture"->"bitmap" if you want to post the score in the forum. (You also have to paste it into a program like Photoshop and upload it to an imagehoster like "ImageShack oder ImageBanana" if you want to post it here)






IMPORTANT:

Here are a couple of names that you shouldn't type in/replace:

King: Use V. King or Vania King or whatever you want but NEVER use the replace-option for "king". You won't be able to use the spreadsheet anymore after replacing "king"... so be careful.
Radwanska, Rodionova etc.: use A. Radwanska and U. Radwanska if they're both playing the tournament
Kirilenko: don't use Kirilenko if DAVAJ MKirilenko is playing the tournament
Li: the name "li" is too short. Use Na Li if you don't want the spreadsheet to replace "Lisicki" with "1sicki" (if it was a 1st round match)

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13

Last edited by Frederik; Jun 25th, 2013 at 10:41 PM.
Frederik is offline  
Sponsored Links
Advertisement
 
post #2 of 12 (permalink) Old Apr 14th, 2012, 04:31 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

let me know if the files are down (like they are now)... I'll re-upload them asap

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13

Last edited by Frederik; Apr 14th, 2012 at 04:50 PM.
Frederik is offline  
post #3 of 12 (permalink) Old Apr 20th, 2012, 08:04 PM
Senior Member
 
WhoAmI?'s Avatar
 
Join Date: Aug 2009
Posts: 8,544
                     
Re: Tipping Spreadsheets (for tournament managers)

You can use King if you choose Find&Search -> Replace, there's a button Options>>


mark Match entire cell contents


This shouldn't screw up the formulas.
WhoAmI? is offline  
post #4 of 12 (permalink) Old May 4th, 2012, 08:33 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

thanks

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13
Frederik is offline  
post #5 of 12 (permalink) Old Aug 17th, 2012, 08:52 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

I'm working on a new/better spreadsheet.

I'll either post it tomorrow or in 3 weeks (after my vacation)


TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13

Last edited by Frederik; Aug 18th, 2012 at 03:23 AM.
Frederik is offline  
post #6 of 12 (permalink) Old Sep 17th, 2012, 07:54 AM
Senior Member
 
Chiquitita.'s Avatar
 
Join Date: Apr 2010
Location: Bonn, NRW
Posts: 25,499
                     
Re: Tipping Spreadsheets (for tournament managers)

How's the new spreadsheet coming along?

but somehow I can't help from hoping
to find someone to talk to
who likes the way I am
who when he sees me wants to again

GM SH ВФA СAK CSN AСП KB AB HW JJL MB NG ÇB NO PMȚ KS AvU RH VK/JJC CAM IdV UE TA MS DP MH SA | twitter
Chiquitita. is offline  
post #7 of 12 (permalink) Old Sep 17th, 2012, 12:18 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

I posted it in some of the tipping threads.

I'll post it here later.

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13
Frederik is offline  
post #8 of 12 (permalink) Old Sep 22nd, 2012, 03:44 AM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

Tipping #204 | New Haven - Final Scores out! #3 Congrats Хлоэ!

It's here

Edit:

looks like the file has been deleted... I'll re-upload it soon

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13
Frederik is offline  
post #9 of 12 (permalink) Old Jun 25th, 2013, 10:42 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

links updated

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13
Frederik is offline  
post #10 of 12 (permalink) Old Aug 5th, 2013, 06:51 AM
Senior Member
 
mariusz_pol's Avatar
 
Join Date: Mar 2012
Posts: 3,199
                     
Re: Tipping Spreadsheets (for tournament managers)

Does this spreadsheet also count bonus points (every correct point one point and points for TOP8)?

TT Singles W ITF Karuizawa'14, W ITF Istanbul'14 ||| TT Doubles W ITF Wuhan'15, W ITF Burnie'15, W ITF Midland'14, W ITF Istanbul'13, W ITF Versmold'13
Tipping W Roland Garros'15, W Budapest'13, W Rome'12, F Acapulco'14, F Bastad'13, F Indian Wells'13
Tipping doubles W Cincinnati'14, W Roland Garros'14, W Rome'14, W Madrid'14, W Miami'14, W Indian Wells'14, W Beijing'13, W US Open'13
Suicide W Miami'15, W Dubai'15, W Baku'14, W Tashkent'13 ||| FITD F Paris'14, F Auckland'14, F Luxembourg'13, F Toronto '13
mariusz_pol is offline  
post #11 of 12 (permalink) Old Aug 5th, 2013, 10:21 AM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,503
                     
Re: Tipping Spreadsheets (for tournament managers)

no

the rule didn't exist when I created this spreadsheet.

TT Singles: #108 CH: #2 Finals: Luxembourg '12, Miami '13, Carlsbad '13, YEC '13 SF: Dallas '12, US Open '12, Indian Wells '13, Cincinnati '13, New Haven '13, Tokyo '13
TT Doubles: #10 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14, New Haven '15, Hong Kong '15, Moscow '15 Finals: Seoul '12, Brisbane '13, Monterrey '15, Stuttgart '15, YEC '15 (GS) SF: Wimbledon '12, US Open '12 RR: YEC '13
Frederik is offline  
post #12 of 12 (permalink) Old Feb 11th, 2015, 12:19 PM
Senior Member
 
okck's Avatar
 
Join Date: Jun 2010
Posts: 974
                     
Re: Tipping Spreadsheets (for tournament managers)

I couldn't get the second page of the 32-player draw spreadsheet to work, so I am using the 64-player spreadsheet and have deleted the column for R3
okck is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the TennisForum.com forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in









Image Verification
Please enter the six letters or digits that appear in the image opposite.

Registration Image

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome