Evita's TT Management Spreadsheet - Page 7 - MensTennisForums.com
Reply
 
LinkBack Thread Tools
post #91 of 124 (permalink) Old 09-25-2012, 03:43 PM
Registered User
 
Join Date: Feb 2011
Age: 31
Posts: 4,620
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by Direnan View Post
Guys, the Spreadsheet have 1 mistake:

It count shootout in matches with retirement.
Quote:
Originally Posted by -Evita- View Post
Actually the rules were changed recently and the correct winner in a retirement match should count for shootout. If you remove the "sr" tag and don't enter a set score then everything should be fine I think
Yeah that works.

TT Singles: W 2014: Heilbronn I
TT Singles: W 2013: Marseille, Sarasota
TT Singles: W 2012: Blois Fut; QF USO
TT Singles ranking: 88 (High: 52)

TT Doubles: W 2015: Wimbledon, Gstaad, Moscow, Sarasota, Fergana (w/ appleGirl)
TT Doubles: W 2013: Winston-Salem, Sarajevo; SF USO (w/ appleGirl)
TT Doubles: W 2012: Antalya, Tiburon; SF USO (w/ appleGirl)
TT Doubles: W 2011: Izmir CH (w/ appleGirl)
TT Doubles ranking: 20 (High: 15)


-- TT Board Member --
Mahqz is online now  
Sponsored Links
Advertisement
 
post #92 of 124 (permalink) Old 09-25-2012, 03:50 PM
Registered User
 
Direnan's Avatar
 
Join Date: Apr 2010
Age: 28
Posts: 4,844
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by -Evita- View Post
Actually the rules were changed recently and the correct winner in a retirement match should count for shootout. If you remove the "sr" tag and don't enter a set score then everything should be fine I think
Quote:
Originally Posted by Mahqz View Post
Yeah that works.
If two players, pick in the same player, shootout don't will count.

But, I will try this. Thanks.

Suicide: Roland Garros
DTT:Hamburg
Thomaz, Feijão, Monteiro, Clezar, Laranja, Julinho, Rogerinho
NALBA, Nadal, Yoshi, Farah, Elias, Sousa, Ferrer, De Bakker, Wawrinka, Gil, Alves, Mello, B. Baker, Gasquet

Bartoli, Matekkão, Wozniack, Minella, Rezai, De Brito, Cirstea, Cornet, Bouchard, Robson
Duarte, Segnini, Hermenegildo, Nanda, Vaisemberg, Bia
Direnan is offline  
post #93 of 124 (permalink) Old 10-30-2012, 11:34 AM
Not exactly average.
 
erickmartins's Avatar
 
Join Date: Jan 2011
Location: Coventry
Age: 30
Posts: 1,036
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

I had a very strange problem: specifically one pick from one player in doubles is not accepted. Nothing I write in the cell is seen as correct by the spreadsheet. I've tried even copying a valid pick from another player, but the only thing I could do to prevent the spreadsheet from saying "incorrect pick" was to put a no pick there. (if it's any help, it's exactly cell F73 from the doubles sheet). Any ideas?

TT Palmarès

Titles: Astana 2 CH '11, Challenger Tour Finals '11, Kuala Lumpur '12 (w/Dudisela75), Bressuire Futures '13 (w/Marita)

Finals: Fürth CH '11, Orleans CH '11, Petange CH '12, TT Euro '12 (w/Vilnietè)

SF: Australian Open '12, Memphis '12
erickmartins is offline  
post #94 of 124 (permalink) Old 10-30-2012, 11:53 PM
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Posts: 14,171
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by erickmartins View Post
I had a very strange problem: specifically one pick from one player in doubles is not accepted. Nothing I write in the cell is seen as correct by the spreadsheet. I've tried even copying a valid pick from another player, but the only thing I could do to prevent the spreadsheet from saying "incorrect pick" was to put a no pick there. (if it's any help, it's exactly cell F73 from the doubles sheet). Any ideas?

Never had a problem like that - only thing I can think of - have you possibly done something to corrupt the cell?
Does the same thing happen if you download a new sheet and re:input the same picks?

You can contact me on my TF Account or adriancollins@hotmail.com. I rarely log on here anymore as became TF Admin.
AdeyC is offline  
post #95 of 124 (permalink) Old 10-31-2012, 08:41 AM
Not exactly average.
 
erickmartins's Avatar
 
Join Date: Jan 2011
Location: Coventry
Age: 30
Posts: 1,036
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Yes, I've tried starting from a clean, downloaded sheet - same thing. Well, it didn't cause me any trouble in the end, I just wanted to see if it has happened to anyone else. I'm using LibreOffice, that might explain something.

TT Palmarès

Titles: Astana 2 CH '11, Challenger Tour Finals '11, Kuala Lumpur '12 (w/Dudisela75), Bressuire Futures '13 (w/Marita)

Finals: Fürth CH '11, Orleans CH '11, Petange CH '12, TT Euro '12 (w/Vilnietè)

SF: Australian Open '12, Memphis '12
erickmartins is offline  
post #96 of 124 (permalink) Old 01-10-2013, 10:06 AM
.
 
Join Date: Apr 2010
Age: 24
Posts: 33,923
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Let's move this thread on page 1


Tennis Tipping 2016


Singles : 165 (Best 88) -
Doubles : 54 (Best 50) -

Finals CH

Singles : 4:4
Doubles : 10:9 CH (ATP 3:0)
dinkulpus is offline  
post #97 of 124 (permalink) Old 03-29-2013, 02:34 PM
.
 
Join Date: Apr 2010
Age: 24
Posts: 33,923
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Up


Tennis Tipping 2016


Singles : 165 (Best 88) -
Doubles : 54 (Best 50) -

Finals CH

Singles : 4:4
Doubles : 10:9 CH (ATP 3:0)
dinkulpus is offline  
post #98 of 124 (permalink) Old 03-30-2013, 01:34 PM
Registered User
 
traddles's Avatar
 
Join Date: Jan 2012
Age: 32
Posts: 1,436
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

I had this situation yesterday:

Code:
Don Corleone	        catgamer
CHIUDINELLI 64 36 63	Chiudinelli 64 67 63
TEIXEIRA 21	        Teixeira 21
VELOTTI 21	        Velotti 20
DI MAURO 20	        di Mauro 20
The results were:

CHIUDINELLI 64 26 61
SANDGREN 60 76
walkover
DI MAURO 62 61

So, I had to cancel SR3. I changed the day of that match to '0', then I changed 'The number of matches in this round' to '3'.

The result was:
02:02 | Don Corleone (BRA) vs. (Q) catgamer (GER) #SRs: 2-2, Shootout: SR3

So, in spite of the fact I cancelled that match, the Spreadsheet used it for TB.

Rafa Nadal


Novak Djokovic *** Gael Monfils *** Kei Nishikori *** Andy Murray


TT: London - Special Olympic Games - Doubles Gold Medal (w/ justafanYYC)
traddles is offline  
post #99 of 124 (permalink) Old 05-23-2013, 04:25 PM
-LIFETIME MEMBER-
 
rvugt's Avatar
 
Join Date: Feb 2008
Location: Nijmegen
Age: 30
Posts: 6,584
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Btw, why isn't this thread stickied yet?

Member of Suicide tennis board!

For all tt results from the past:

http://tt-statistics.info/
rvugt is offline  
post #100 of 124 (permalink) Old 01-13-2014, 09:41 AM
Registered User
 
Join Date: May 2010
Location: Cairo
Posts: 6,607
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

I think with the new shootout rule change in slams you have to check matches with shootouts manually, right?

Es irrt der Mensch so lang er strebt
Roger Federer .. Malek Jaziri
abollo is offline  
post #101 of 124 (permalink) Old 01-13-2014, 12:14 PM
.
 
Join Date: Apr 2010
Age: 24
Posts: 33,923
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by abollo View Post
I think with the new shootout rule change in slams you have to check matches with shootouts manually, right?
Yes


Tennis Tipping 2016


Singles : 165 (Best 88) -
Doubles : 54 (Best 50) -

Finals CH

Singles : 4:4
Doubles : 10:9 CH (ATP 3:0)
dinkulpus is offline  
post #102 of 124 (permalink) Old 03-11-2014, 03:49 PM
Registered User
 
Thunderfish8's Avatar
 
Join Date: Apr 2011
Posts: 2,227
                     
Re: Evita's TT Management Spreadsheet

Hey Evita, I just have a quick little change that I've found useful after downloading the spreadsheet. I'm not sure if this is only possible on Macs but I've removed the gridlines from the instructions page of the workbook, and it makes the instructions much easier to read. Obviously not a reason to update every spreadsheet, but upon the next version being released (whenever that is), it might be worth considering. This spreadsheet though truly is a work of art (especially to aspiring computer science majors such as myself).


Gulbis Ferrer Nishikori
Isner Nadal Dimitrov Istomin Wawrinka B. Baker

Berdych Monaco Granollers Leo-Mayer Troicki Roger-Vasselin Lu Paire

PAW Titles: Brisbane 2012 & 2014
FITD Titles: Marseille 2014
Tennis Tipping Titles
Singles: Orleans CH '11, Tampere CH '12, Medellin CH '12, Vancouver CH '15, Opava FUT '15
Doubles: Noumea CH '13 w/ Chirag, Cherbourg CH '14, Yokohama CH '15 w/ BMT360
Thunderfish8 is offline  
post #103 of 124 (permalink) Old 05-01-2015, 11:47 AM
-LIFETIME MEMBER-
 
rvugt's Avatar
 
Join Date: Feb 2008
Location: Nijmegen
Age: 30
Posts: 6,584
                     
Re: Evita's TT Management Spreadsheet

Invalid or Deleted File.
The key you provided for file access was invalid. This is usually caused because the file is no longer stored on MediaFire. This occurs when the file is removed by the originating user or MediaFire.

Still have questions, or think we've made a mistake? Please contact support for further assistance.

When I try to download the singles big sheet, I get this error! In zip it works!

Member of Suicide tennis board!

For all tt results from the past:

http://tt-statistics.info/
rvugt is offline  
post #104 of 124 (permalink) Old 01-02-2016, 02:40 PM
Registered User
 
Join Date: Jun 2015
Location: Sweden
Age: 33
Posts: 505
                     
Re: Evita's TT Management Spreadsheet

Any chance of an update with the new tiebreaking rules?

At least remove the shootout and let us calculate the winners manually to avoid mistakes due to trusting the spreadsheet.
BobbaBobb is offline  
post #105 of 124 (permalink) Old 01-02-2016, 02:42 PM
ALT-0
 
Litotes's Avatar
 
Join Date: Mar 2012
Location: Norway
Age: 43
Posts: 54,211
                     
Re: Evita's TT Management Spreadsheet

Quote:
Originally Posted by BobbaBobb View Post
Any chance of an update with the new tiebreaking rules?

At least remove the shootout and let us calculate the winners manually to avoid mistakes due to trusting the spreadsheet.
Already done, just not sufficiently advertised:

TT Changes 2016

.
(May 1st)
ST rank 21 (best 1) - 13 wins, 3 titles (Paris 2014, Madrid + Vienna 2015) YE rank: 16 - 1 - 22
TT singles rank 61 (high 29), Titles: Memphis 2015.... TT doubles rank 28 (high 28). Titles: Quito 2015 (w/scarecrows), Basel 2015, Barcelona 2016 (w/Björki), Estoril 2016 (w/Taz Warrior)
Detailed Tennis Tipping results

Member of Tennis Tipping board and Suicide Tennis board
Litotes is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the MensTennisForums.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 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