Tipping Spreadsheets (for tournament managers) - TennisForum.com
TennisForum.com   Wagerline.com MensTennisForums.com TennisUniverse.com
TennisForum.com is the premier Women's Tennis forum on the internet. Registered Users do not see the above ads.Please Register - It's Free!
Reply

Old Jan 29th, 2012, 01:01 AM   #1
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
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: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13

Last edited by Frederik : Jun 25th, 2013 at 11:41 PM.
Frederik is offline View My Blog!   Reply With Quote
Sponsored Links
Advertisement
 

Old Apr 14th, 2012, 05:31 PM   #2
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
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: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13

Last edited by Frederik : Apr 14th, 2012 at 05:50 PM.
Frederik is offline View My Blog!   Reply With Quote
Old Apr 20th, 2012, 09:04 PM   #3
country flag WhoAmI?
Senior Member
 
WhoAmI?'s Avatar
 
Join Date: Aug 2009
Posts: 7,458
WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute WhoAmI? has a reputation beyond repute
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 View My Blog!   Reply With Quote
Old May 4th, 2012, 09:33 PM   #4
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

thanks
__________________
TT Singles: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13
Frederik is offline View My Blog!   Reply With Quote
Old Aug 17th, 2012, 09:52 PM   #5
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
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: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13

Last edited by Frederik : Aug 18th, 2012 at 04:23 AM.
Frederik is offline View My Blog!   Reply With Quote
Old Sep 17th, 2012, 08:54 AM   #6
country flag Håkon
Senior Member
 
Håkon's Avatar
 
Join Date: Apr 2010
Location: Bonn, NRW
Posts: 19,620
Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute Håkon has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

How's the new spreadsheet coming along?
__________________
i defeated the mountains
i severed the oceans
i was the stronger of us
yet the weakest one still



twitter
Håkon is offline View My Blog!   Reply With Quote
Old Sep 17th, 2012, 01:18 PM   #7
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

I posted it in some of the tipping threads.

I'll post it here later.
__________________
TT Singles: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13
Frederik is offline View My Blog!   Reply With Quote
Old Sep 22nd, 2012, 04:44 AM   #8
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

http://www.tennisforum.com/showpost....4&postcount=19

It's here

Edit:

looks like the file has been deleted... I'll re-upload it soon
__________________
TT Singles: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13
Frederik is offline View My Blog!   Reply With Quote
Old Jun 25th, 2013, 11:42 PM   #9
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

links updated
__________________
TT Singles: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13
Frederik is offline View My Blog!   Reply With Quote
Old Aug 5th, 2013, 07:51 AM   #10
country flag mariusz_pol
Senior Member
 
mariusz_pol's Avatar
 
Join Date: Mar 2012
Posts: 2,605
mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of mariusz_pol has much to be proud of
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 Midland'14, W ITF Istanbul'13, W ITF Versmold'13 (all w/Javi.)
Tipping 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 (all w/Markmen)
Suicide W Baku'14, W Tashkent'13, F Moscow'13 ||| FITD F Paris'14, F Auckland'14, F Luxembourg'13, F Toronto '13
FITD Doubles W Kuala Lumpur'14, W Tokyo'13, W Baku'13
mariusz_pol is offline View My Blog!   Reply With Quote
Old Aug 5th, 2013, 11:21 AM   #11
country flag Frederik
Senior Member
 
Frederik's Avatar
 
Join Date: Jun 2010
Posts: 20,407
Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute Frederik has a reputation beyond repute
Re: Tipping Spreadsheets (for tournament managers)

no

the rule didn't exist when I created this spreadsheet.
__________________
TT Singles: #199 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: #52 CH: #10 Titles: Dallas '12, Brussels '13, Cincinnati '13, US Open '14 Finals: Seoul '12, Brisbane '13 SF: Wimbledon '12, US Open '12, TOC '12, Dubai '13, New Haven '13, Tokyo '13
Frederik is offline View My Blog!   Reply With Quote
Reply


Thread Tools

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 On
HTML code is Off
Forum Jump


Copyright (C) Verticalscope Inc
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
vBCredits v1.4 Copyright ©2007, PixelFX Studios