Evita's TT Management Spreadsheet - Page 7 - MensTennisForums.com

MensTennisForums.com

MenstennisForums.com is the premier Men's Tennis forum on the internet. Registered Users do not see the above ads.Please Register - It's Free!

Reply

Old 09-25-2012, 03:43 PM   #91
country flag Mahqz
Registered User
 
Join Date: Feb 2011
Age: 29
Posts: 3,823
Mahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond reputeMahqz has a reputation beyond repute
Default 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: 57 (High: 52)

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: 42 (High: 39)


-- TT Board Member --
Mahqz is online now View My Blog!   Reply With Quote
Sponsored Links
Advertisement
 

Old 09-25-2012, 03:50 PM   #92
country flag Direnan
Registered User
 
Direnan's Avatar
 
Join Date: Apr 2010
Age: 26
Posts: 4,844
Direnan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond reputeDirenan has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 10-30-2012, 11:34 AM   #93
country flag erickmartins
Not exactly average.
 
erickmartins's Avatar
 
Join Date: Jan 2011
Location: Coventry
Age: 28
Posts: 1,035
erickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond repute
Default 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 Rankings - Singles: 292 (best 13) / Doubles: 271 (best 165)

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 View My Blog!   Reply With Quote
Old 10-30-2012, 11:53 PM   #94
country flag AdeyC
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Location: Brighton, UK
Posts: 14,148
AdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond reputeAdeyC has a reputation beyond repute
Default 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
AdeyC is offline View My Blog!   Reply With Quote
Old 10-31-2012, 08:41 AM   #95
country flag erickmartins
Not exactly average.
 
erickmartins's Avatar
 
Join Date: Jan 2011
Location: Coventry
Age: 28
Posts: 1,035
erickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond reputeerickmartins has a reputation beyond repute
Default 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 Rankings - Singles: 292 (best 13) / Doubles: 271 (best 165)

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 View My Blog!   Reply With Quote
Old 01-10-2013, 10:06 AM   #96
country flag dinkulpus
-_-
 
Join Date: Apr 2010
Age: 22
Posts: 26,670
dinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Let's move this thread on page 1
__________________

Tennis Tipping 2014


Singles : 115 (Best 88) - QF Auckland, QF Houston
Doubles : 67 (Best 65) - Won Sao Paulo, SF Rome, SF Chennai, SF Buenos Aires, SF Queens (with stbanchile) RU : Sarasota CH (with Litotes), Mohammedia CH, Manta CH (with Daniel_amr)

Finals CH

Singles : 3:3
Doubles : 9:6 (ATP 1:0)
dinkulpus is offline View My Blog!   Reply With Quote
Old 03-29-2013, 02:34 PM   #97
country flag dinkulpus
-_-
 
Join Date: Apr 2010
Age: 22
Posts: 26,670
dinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Up
__________________

Tennis Tipping 2014


Singles : 115 (Best 88) - QF Auckland, QF Houston
Doubles : 67 (Best 65) - Won Sao Paulo, SF Rome, SF Chennai, SF Buenos Aires, SF Queens (with stbanchile) RU : Sarasota CH (with Litotes), Mohammedia CH, Manta CH (with Daniel_amr)

Finals CH

Singles : 3:3
Doubles : 9:6 (ATP 1:0)
dinkulpus is offline View My Blog!   Reply With Quote
Old 03-30-2013, 01:34 PM   #98
country flag traddles
Registered User
 
traddles's Avatar
 
Join Date: Jan 2012
Age: 31
Posts: 1,436
traddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond reputetraddles has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 05-23-2013, 04:25 PM   #99
country flag rvugt
-LIFETIME MEMBER-
 
rvugt's Avatar
 
Join Date: Feb 2008
Age: 28
Posts: 5,830
rvugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond reputervugt has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Btw, why isn't this thread stickied yet?
__________________
Member of Suicide tennis board!

rvugt is offline View My Blog!   Reply With Quote
Old 01-13-2014, 09:41 AM   #100
country flag abollo
Tennis Player
 
Join Date: May 2010
Location: Cairo
Posts: 5,557
abollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond reputeabollo has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 01-13-2014, 12:14 PM   #101
country flag dinkulpus
-_-
 
Join Date: Apr 2010
Age: 22
Posts: 26,670
dinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond reputedinkulpus has a reputation beyond repute
Default 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 2014


Singles : 115 (Best 88) - QF Auckland, QF Houston
Doubles : 67 (Best 65) - Won Sao Paulo, SF Rome, SF Chennai, SF Buenos Aires, SF Queens (with stbanchile) RU : Sarasota CH (with Litotes), Mohammedia CH, Manta CH (with Daniel_amr)

Finals CH

Singles : 3:3
Doubles : 9:6 (ATP 1:0)
dinkulpus is offline View My Blog!   Reply With Quote
Old 03-11-2014, 03:49 PM   #102
country flag Thunderfish8
Registered User
 
Thunderfish8's Avatar
 
Join Date: Apr 2011
Posts: 1,983
Thunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond reputeThunderfish8 has a reputation beyond repute
Default 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 Wawrinka
Isner Nadal Mahut Dimitrov Istomin Tsonga B. Baker

Berdych Monaco Granollers 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
Doubles: Noumea CH '13 w/ Chirag, Cherbourg CH '14 w/ BMT360
Thunderfish8 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