TT Management Spreadsheet with ISRs + TBs | v 1.2.3 (another minor bug fix :angel:) - TennisForum.com
 16Likes
Reply
 
LinkBack Thread Tools
post #1 of 78 (permalink) Old Jul 23rd, 2013, 05:43 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
TT Management Spreadsheet with ISRs + TBs | v 1.2.3 (another minor bug fix :angel:)

I've made some modifications to Evita's spreadsheet in order to make it easier to manage TT tournaments with in on TF. The spreadsheet includes all TB rules and ISRs. SR Shootout has been removed.

99% of the credit goes to Evita for the work on the original spreadsheet. The original version of that spreadsheet can be found HERE.

Features:

Quote:
Originally Posted by -Evita- View Post
* Automatically provides differences for singles and doubles
* Automatically calculates results
* Provides picks statistics
IMPORTANT:

1. always use OpenOffice with the sheet and not Excel.
2. if the sheet tells you to look at CB, save and open the sheet again.

Download: 1.2.3

Singles 32 - Doubles 16

Download: 1.03

Singles 128
Doubles 128


changelog:

Code:
0.81: 

- fixed TB error for the match between TT player 1 and 2

0.82:

- added ISRs to the diffs on day 2 in 2-day rounds

0.9:

- added ISRs to the doubles sheet

0.91:

- 2-1 vs. no SR now counts as an ISR (if both picked the loser)
- fixed an error that led to ISRs counting before the result was entered (didn't lead to wrong results)

0.92:

- added ISRs to the diffs on day 2 of 2-day rounds (doubles)

0.93:

- 2-1 vs. no SR now counts as an ISR (if both picked the loser) - doubles
- fixed an error that led to ISRs counting before the result was entered (doubles)
- retirements don't count for TB shootout anymore

0.94:

- fixed an error that led to wrong calculation of # of games for 10-8 or 11-9 sets

1.0:

- added TBs to the doubles sheet

1.01:

- fixed an error that led to a wrong SR score in the results in doubles (didn't show wrong winner)

1.02:

- fixed an error that led to wrong TB results (doubles)

1.03:

- TB matches don't have to be in the first 3 rows of the OOP anymore

v1.04
- fixed an error that led to wrong results in case of a retirement (ISR & TB)

v1.1
- identical picks now cancel each other out (new doubles ISR rule)

v1.1.1
- fixed an error that led to wrong amount of ISRs in doubles

v.1.1.2
- added option to show all ISRs in results

v1.2
- added Pick Stats formatted for TF (3 different versions usable with (code) on TF)
- fixed an error that led to wrong pick counts if two or more WTA players have the same name

v.1.2.1
- fixed an error that led to wrong ISR results in doubles

v.1.2.2
- fixed an error that led to wrong pick counts

v.1.2.3
- fixed a minor error that led to wrong ISR scores before a result was entered. (didn't affect the final score)

Thanks Evita




Quote:
Originally Posted by -Evita- View Post
I've created a TT management spreadsheet to reduce the time the managers have to spend on managing and to eliminate mistakes when creating differences and counting correct picks.

Small 0.92 xls 2.91 MB
Small 0.92 zip 482 KB

Singles Big 0.9 xls 14.46 MB
Singles Big 0.9 zip 2.37 MB

Doubles Big 0.9 xls 14.5 MB
Doubles Big 0.9 zip 2.39 MB

Singles Best-Of-Five 0.9 xls 14.97 MB
Singles Best-Of-Five 0.9 zip 2.41 MB

Doubles Best-Of-Five 0.9 xls 14.79 MB

Features:

* Automatically provides differences for singles and doubles
* Automatically calculates results
* Provides picks statistics

Everyone is free to use this spreadsheet if they want to

These are possibly the final versions. If you have any comments, questions or suggestions please post them here

Last edited by Frederik; Feb 14th, 2016 at 08:01 PM. Reason: Added the original link for Evita's sheet - for the large doubles sheet
Frederik is offline  
Sponsored Links
Advertisement
 
post #2 of 78 (permalink) Old Jul 23rd, 2013, 05:45 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet - v 0.8

I've tested it for about a week but there could still be a couple of bugs. so be sure to check for unusual/suspicious results.

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 #3 of 78 (permalink) Old Jul 23rd, 2013, 06:36 PM
-LIFETIME MEMBER-
 
goOudinUSA's Avatar
 
Join Date: May 2012
Location: Believe
Posts: 39,150
                     
Re: TT Management Spreadsheet - v 0.8

Thanks so much guys!!

Azarenka Ivanovic Oudin Sharapova Soylu
goOudinUSA is offline  
post #4 of 78 (permalink) Old Jul 23rd, 2013, 06:37 PM
Kookie Supporter
 
James's Avatar
 
Join Date: Dec 2001
Location: Wherever I lay my hat
Posts: 65,052
                     
Re: TT Management Spreadsheet - v 0.8

Looks nice
James is offline  
post #5 of 78 (permalink) Old Jul 23rd, 2013, 07:01 PM
Senior Member
 
Milan.'s Avatar
 
Join Date: Oct 2012
Location: Anapolis
Posts: 26,541
                     
Re: TT Management Spreadsheet - v 0.8

Fred

It's awsome

'We can be heroes, for ever and ever. What d'you say?'

aleks krunić ♔ ana ivanović ♔ venus williams
maria sharapova • sabine lisicki • martina hingis • tsvetana pironkova • ons jabeur • elina svitolina • barbora strycova • ashleigh barty • nina stojanovic
Milan. is offline  
post #6 of 78 (permalink) Old Jul 23rd, 2013, 07:21 PM
Senior Member
 
joe87's Avatar
 
Join Date: Mar 2007
Posts: 9,984
                     
Re: TT Management Spreadsheet - v 0.8

Thanks Frederik

Suicide Tennis: Rank: #47 Highest: #2 Titles: 2007 Bad Gastein, 2008 US Open, 2009 Sydney, Miami, YEC Doha 2010 Dubai, Budapest, Prague 2011 Brussels 2013 Strasbourg
Tennis Tipping: Rank: #16 Highest: #1 Doubles: Rank: #26 Highest: #1
Titles S: 2009 ITF Dubai 2010 Bad Gastein, Tashkent 2011 Sydney, ITF Nassau, ITF Alphen, Seoul 2012 ITF Civitavecchia, Wimbledon, Carlsbad 2015 Tokyo Pre 2016 Tokyo Int
Titles D: 2009 5x ITF 2010 Fes, Rome, Tokyo, YEC Doha 2011 ITF Monzon, Baku, Seoul 2012 Paris, Taipei, ITF Pune 2013 4x ITF, Charleston, Nürnberg 2014 2x ITF, Tashkent 2015 Sydney, Toronto 2016 Sydney, ITF Versmold
joe87 is offline  
post #7 of 78 (permalink) Old Jul 23rd, 2013, 08:32 PM
TT Board Member/BSG co:Creator w/sfar
 
AdeyC's Avatar
 
Join Date: Dec 2008
Location: Brighton
Posts: 35,333
                     
Re: TT Management Spreadsheet - v 0.8

Quote:
Originally Posted by Frederik View Post
I've tested it for about a week but there could still be a couple of bugs. so be sure to check for unusual/suspicious results.
I've spent some time testing it at the weekend and I haven't noticed anything either Fred

Tennis Tipping
Singles (Rank : 24) (High : 1 - 11 weeks)

Titles (11) - 2012 - New Haven, SF - WIMBLEDON, 2013 - Beijing, GB Fed Cup, 2014 - Brisbane, Dubai, Stuttgart, Rome, YEC Singapore, 2015 - Stanford, GB Fed Cup, ITF - Antayla, 2016 - Bogota, Olympics
Doubles - (Rank : 29) (High : 1 - 32 weeks)
Titles - (19) (w/tennisbuddy12) 2010 - Bad Gastein, (w/Tuckii) 2013 - ITF Bertioga, (w/James) 2016 - ITF Toyota (w/mateusz2904) - 2010 - Bogota, ITF Karuizawa, ITF Montpellier, 2011 - Bogota, Birmingham, ITF Poitiers, ITF Bratislava, 2012 - ITF Opole, 2013 - Bad Gastein, 2014 - WIMBLEDON, Bad Gastein, 2015 - Nottingham, ITF Ortisei, 2016 - Brisbane, ITF Glasgow, St Petersburg
AdeyC is online now  
post #8 of 78 (permalink) Old Jul 23rd, 2013, 09:02 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet - v 0.8

there was a little bug with the set scores if someone picked two of the same. But that has been fixed in the version I uploaded here. Not sure if that bug was already in the sheet I sent you or if I "added" it later.

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 78 (permalink) Old Jul 23rd, 2013, 09:30 PM
TT Board Member/BSG co:Creator w/sfar
 
AdeyC's Avatar
 
Join Date: Dec 2008
Location: Brighton
Posts: 35,333
                     
Re: TT Management Spreadsheet - v 0.8

Quote:
Originally Posted by Frederik View Post
there was a little bug with the set scores if someone picked two of the same. But that has been fixed in the version I uploaded here. Not sure if that bug was already in the sheet I sent you or if I "added" it later.
Ah, that might be possible - I tested it with a old set of MTF picks for testing where you rarely get 6-3 6-3 or 6-4 6-4 picks.

Tennis Tipping
Singles (Rank : 24) (High : 1 - 11 weeks)

Titles (11) - 2012 - New Haven, SF - WIMBLEDON, 2013 - Beijing, GB Fed Cup, 2014 - Brisbane, Dubai, Stuttgart, Rome, YEC Singapore, 2015 - Stanford, GB Fed Cup, ITF - Antayla, 2016 - Bogota, Olympics
Doubles - (Rank : 29) (High : 1 - 32 weeks)
Titles - (19) (w/tennisbuddy12) 2010 - Bad Gastein, (w/Tuckii) 2013 - ITF Bertioga, (w/James) 2016 - ITF Toyota (w/mateusz2904) - 2010 - Bogota, ITF Karuizawa, ITF Montpellier, 2011 - Bogota, Birmingham, ITF Poitiers, ITF Bratislava, 2012 - ITF Opole, 2013 - Bad Gastein, 2014 - WIMBLEDON, Bad Gastein, 2015 - Nottingham, ITF Ortisei, 2016 - Brisbane, ITF Glasgow, St Petersburg
AdeyC is online now  
post #10 of 78 (permalink) Old Jul 24th, 2013, 01:05 AM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet - v 0.82

new version 0.81

Code:
0.81: 

- fixed TB error for the match between TT player 1 and 2
Edit:

new version 0.82

Code:
0.82:

- added ISRs to the diffs on day 2 in 2-day rounds

v 0.9 with ISRs for doubles on the way

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 #11 of 78 (permalink) Old Jul 24th, 2013, 02:21 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet v 0.9 | with ISRs + TBs

v 0.9

ISRs now work in the doubles sheet

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 78 (permalink) Old Jul 24th, 2013, 08:12 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet with ISRs + TBs | v 0.92

Code:
0.91:

- 2-1 vs. no SR now counts as an ISR (if both picked the loser)
- fixed an error that led to ISRs counting before the result was entered (didn't lead to wrong results)

0.92:

- added ISRs to the diffs on day 2 of 2-day rounds (doubles)

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 #13 of 78 (permalink) Old Jul 24th, 2013, 08:46 PM
Senior Member
 
Part Time Lover's Avatar
 
Join Date: Aug 2011
Location: Third house on the left
Posts: 18,214
                     
Re: TT Management Spreadsheet with ISRs + TBs | v 0.92

Thanks Frederik

Will there be more changes?

I love my hater he makes me feel greater

My Tennis Tipping Profile

THE TRUTH IS OUT THERE

Part Time Lover is offline  
post #14 of 78 (permalink) Old Jul 24th, 2013, 08:52 PM Thread Starter
잊지마
 
Join Date: Jun 2010
Posts: 23,554
                     
Re: TT Management Spreadsheet with ISRs + TBs | v 0.92

yeah. I'll add a few more things

TT Singles: #66 CH: #2 Titles: Eastbourne '16 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: #7 CH: #6 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 #15 of 78 (permalink) Old Jul 24th, 2013, 08:54 PM
Senior Member
 
Part Time Lover's Avatar
 
Join Date: Aug 2011
Location: Third house on the left
Posts: 18,214
                     
Re: TT Management Spreadsheet with ISRs + TBs | v 0.92

Ok then, I'll wait a little bit to download it.

I love my hater he makes me feel greater

My Tennis Tipping Profile

THE TRUTH IS OUT THERE

Part Time Lover 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









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



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