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, 12:01 AM   #1
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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)

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

Old Apr 14th, 2012, 04:31 PM   #2
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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

Last edited by Frederik : Apr 14th, 2012 at 04:50 PM.
Frederik is offline View My Blog!   Reply With Quote
Old Apr 20th, 2012, 08:04 PM   #3
country flag WhoAmI?
Senior Member
 
WhoAmI?'s Avatar
 
Join Date: Aug 2009
Posts: 7,074
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, 08:33 PM   #4
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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
Frederik is offline View My Blog!   Reply With Quote
Old Aug 17th, 2012, 08:52 PM   #5
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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)


Last edited by Frederik : Aug 18th, 2012 at 03:23 AM.
Frederik is offline View My Blog!   Reply With Quote
Old Sep 17th, 2012, 07:54 AM   #6
country flag Håkon
Senior Member
 
Håkon's Avatar
 
Join Date: Apr 2010
Location: Bonn, NRW
Posts: 17,141
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?
__________________
My twitter | FWTT: Cornelia du Preez
game wins: FITD US Open '12, Guangzhou '10 (#1 since 8 July 2013), TT Indian Wells '11, TT doubles Moskva '11, Brussel '12, Pattaya '13, Stuttgart '13 (w/Andreas), PAW 4 titles, Suicide Olympic gold + 2 titles, Tipping 3 titles (#1 for 25 weeks, USO Series '12), Q-Ball 7 titles, Blackjack #1 2012, Pentathlon #1 2012 (5 titles)
Азарэнка | Павлюченкова | Arvidsson| Halep | Eikeri | Clijsters | Rus | Van Uytvanck | Watson | Bertens | Superboerin Hogenkamp | Schoofs
Håkon is offline View My Blog!   Reply With Quote
Old Sep 17th, 2012, 12:18 PM   #7
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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.
Frederik is offline View My Blog!   Reply With Quote
Old Sep 22nd, 2012, 03:44 AM   #8
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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
Frederik is offline View My Blog!   Reply With Quote
Old Jun 25th, 2013, 10:42 PM   #9
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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
Frederik is offline View My Blog!   Reply With Quote
Old Aug 5th, 2013, 06:51 AM   #10
country flag mariusz_pol
Senior Member
 
mariusz_pol's Avatar
 
Join Date: Mar 2012
Posts: 1,851
mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold mariusz_pol is a splendid one to behold
Re: Tipping Spreadsheets (for tournament managers)

Does this spreadsheet also count bonus points (every correct point one point and points for TOP8)?
__________________
Tipping(rank: 4): W Budapest'13, W Rome'12, F Acapulco'14, F Indian Wells'13, F Bastad'13, ll Tipping doubles: (singles) W Indian Wells'14, W US Open'13 (doubles) W Miami'14, W Indian Wells'14, W Beijing'13, W US Open'13, F Australian Open'14, F Doha'14 (all w/Markmen) ll Suicide: W Tashkent'13, F Moscow'13 ll TT Doubles: W ITF Midland'14, W ITF Versmold'13, W ITF Istanbul'13, F ITF Donetsk'13, F ITF Koksijde'13, F ITF Vallduxo'13(all w/Javi.), F ITF Nules'13(w/Christork17) ll FITD: F Paris'14, F Auckland'14, F Toronto'13, F Luxembourg'13
mariusz_pol is online now View My Blog!   Reply With Quote
Old Aug 5th, 2013, 10:21 AM   #11
country flag Frederik
Senior Member
 
Join Date: Jun 2010
Posts: 20,049
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.
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