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

 1Likes
Reply
 
LinkBack Thread Tools
post #76 of 124 (permalink) Old 01-16-2012, 07:29 AM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,970
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

No, it's not normal. Maybe you are entering the winners in the wrong column? It needs to be in the blue one, not the grey one, and just the number (1 or 2), not the name. If you can't figure it out you can send the spreadsheet to me, I'll take a look at it.

한국어 너무 좋아요
-Evita- is offline  
Sponsored Links
Advertisement
 
post #77 of 124 (permalink) Old 01-16-2012, 02:53 PM
Registered User
 
Allez-Alejo's Avatar
 
Join Date: Feb 2007
Posts: 8,855
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

OK...I've got it..thanks.

Tennis Tipping 2016:
Singles: F - Wimbledon; SF - Auckland, Monte-Carlo, Queens
Entry - 17(41) Race - 5
Doubles: W - Brisbane(w/ samanosuke), Auckland(w/ bry17may), Nussoluch CH(w/ FERNET); F - Wimbledon(w/ jervisjames), Irving CH(w/ MrEleganza), St Brieuc CH(w/ bry17may), Furth CH(w/ ZackBusner); SF - Houston(w/ Chowdahead25), Munich(w/ Tennis Passion)
Entry - 16(38) Race - 16


Proud supporter of University at Buffalo, Fairport and Kenmore West athletics....and Chelsea FC and Atlanta Braves

Fairport's Angels - Always in our Hearts 6.26.07
Allez-Alejo is offline  
post #78 of 124 (permalink) Old 03-03-2012, 12:05 PM
.
 
Join Date: Apr 2010
Age: 24
Posts: 34,779
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Someone know why always in double part, there are VALUE in column with player picks


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 #79 of 124 (permalink) Old 03-03-2012, 01:36 PM
Registered User
 
Vilnietė's Avatar
 
Join Date: Feb 2011
Location: Europe
Age: 29
Posts: 2,720
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

because there is formula which searches for that doubles player in singles and if finds him/her then uses the same picks. But this feature works only in open office, so I just delete all those formulas.

Ričardas Berankis Laurynas Grigelis Lukas Mugevičius
Vilnietė is offline  
post #80 of 124 (permalink) Old 03-13-2012, 01:53 PM
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 32,975
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

What do I do when there's one missing pick?
I tried writing "No pick" in that place but then it won't show any differences..


"a kad me opet gore vrati zahvalit' ću Mu prvo
što nam je dao komad zemlje što je za sebe sačuv'o"
Deathless Mortal is offline  
post #81 of 124 (permalink) Old 03-13-2012, 02:01 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 Deathless Mortal View Post
What do I do when there's one missing pick?
I tried writing "No pick" in that place but then it won't show any differences..
Really?

You need write "no Pick", then, in the diff's appears: "No Pick vs Nadal"

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 #82 of 124 (permalink) Old 03-13-2012, 02:05 PM
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 32,975
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by Direnan View Post
Really?

You need write "no Pick", then, in the diff's appears: "No Pick vs Nadal"
Yes, I did do that, but it doesn't show diffs as No Pick vs Nadal, it says: Incorrect pick, probably a spelling mistake


"a kad me opet gore vrati zahvalit' ću Mu prvo
što nam je dao komad zemlje što je za sebe sačuv'o"
Deathless Mortal is offline  
post #83 of 124 (permalink) Old 03-13-2012, 02:05 PM
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Posts: 14,174
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by Direnan View Post
Really?

You need write "no Pick", then, in the diff's appears: "No Pick vs Nadal"
Actually I noticed this a few weeks ago.

In the singles section it would not accept 'No Pick'

whereas in the double section it has 'Note: if a player sent picks but forgot one pick, write in the empty cell: No pick' and it will accept 'No pick' there.

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 #84 of 124 (permalink) Old 03-13-2012, 02:09 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 Deathless Mortal View Post
What do I do when there's one missing pick?
I tried writing "No pick" in that place but then it won't show any differences..
You are correct. In singles don't appears.

In doubles are ok.

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 #85 of 124 (permalink) Old 03-13-2012, 02:11 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 AdeyC View Post
Actually I noticed this a few weeks ago.

In the singles section it would not accept 'No Pick'

whereas in the double section it has 'Note: if a player sent picks but forgot one pick, write in the empty cell: No pick' and it will accept 'No pick' there.
Just! I thought that this, was only for Microsoft Office.

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 #86 of 124 (permalink) Old 03-13-2012, 02:14 PM
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 32,975
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

I guess I'll just manually correct it then.


"a kad me opet gore vrati zahvalit' ću Mu prvo
što nam je dao komad zemlje što je za sebe sačuv'o"
Deathless Mortal is offline  
post #87 of 124 (permalink) Old 04-14-2012, 01:22 AM
.
 
Join Date: Apr 2010
Age: 24
Posts: 34,779
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

Quote:
Originally Posted by Vilnietė View Post
because there is formula which searches for that doubles player in singles and if finds him/her then uses the same picks. But this feature works only in open office, so I just delete all those formulas.
Yeah, now I realise how to do delete them automatically , just write NO in column "Use single picks for doubles"


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 #88 of 124 (permalink) Old 06-24-2012, 11:53 AM
Registered User
 
Chris.'s Avatar
 
Join Date: Jan 2011
Posts: 4,392
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

The link on the first page doesnt work

EDIT: Working now.
Chris. is offline  
post #89 of 124 (permalink) Old 09-25-2012, 03:18 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

Guys, the Spreadsheet have 1 mistake:

It count shootout in matches with retirement.

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 #90 of 124 (permalink) Old 09-25-2012, 03:37 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,970
                     
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.
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

한국어 너무 좋아요
-Evita- 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