Evita's TT Management Spreadsheet - Page 6 - 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 01-16-2012, 08:29 AM   #76
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,269
-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Sponsored Links
Advertisement
 

Old 01-16-2012, 03:53 PM   #77
country flag Allez-Alejo
Registered User
 
Allez-Alejo's Avatar
 
Join Date: Feb 2007
Posts: 8,611
Allez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond reputeAllez-Alejo has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

OK...I've got it..thanks.
__________________
Tennis Tipping 2011:
Singles:
Entry - 43(46) Race - N/A
Doubles: W - US Open(w/orangehat)
Entry - 35(49) Race - 28


Proud supporter of University at Buffalo, Niagara University, Drexel University, 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 View My Blog!   Reply With Quote
Old 03-03-2012, 01:05 PM   #78
country flag dinkulpus
-_-
 
Join Date: Apr 2010
Age: 23
Posts: 28,372
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

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

Tennis Tipping 2014


Singles : 135 (Best 88) - QF Auckland, QF Houston
Doubles : 58 (Best 58) - Won Sao Paulo (with stbanchile), Won Stockholm (with Hellcat)

Finals CH

Singles : 3:3
Doubles : 11:6 (ATP 2:0)
dinkulpus is offline View My Blog!   Reply With Quote
Old 03-03-2012, 02:36 PM   #79
country flag Vilnietė
Registered User
 
Vilnietė's Avatar
 
Join Date: Feb 2011
Location: Europe
Age: 28
Posts: 2,720
Vilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond reputeVilnietė has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 03-13-2012, 02:53 PM   #80
country flag Deathless Mortal
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 30,871
Deathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 03-13-2012, 03:01 PM   #81
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 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 View My Blog!   Reply With Quote
Old 03-13-2012, 03:05 PM   #82
country flag Deathless Mortal
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 30,871
Deathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 03-13-2012, 03:05 PM   #83
country flag AdeyC
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Location: Brighton, UK
Posts: 14,149
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 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
AdeyC is offline View My Blog!   Reply With Quote
Old 03-13-2012, 03:09 PM   #84
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 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 View My Blog!   Reply With Quote
Old 03-13-2012, 03:11 PM   #85
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 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 View My Blog!   Reply With Quote
Old 03-13-2012, 03:14 PM   #86
country flag Deathless Mortal
♤23♤
 
Deathless Mortal's Avatar
 
Join Date: Aug 2006
Posts: 30,871
Deathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond reputeDeathless Mortal has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 04-14-2012, 02:22 AM   #87
country flag dinkulpus
-_-
 
Join Date: Apr 2010
Age: 23
Posts: 28,372
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 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 2014


Singles : 135 (Best 88) - QF Auckland, QF Houston
Doubles : 58 (Best 58) - Won Sao Paulo (with stbanchile), Won Stockholm (with Hellcat)

Finals CH

Singles : 3:3
Doubles : 11:6 (ATP 2:0)
dinkulpus is offline View My Blog!   Reply With Quote
Old 06-24-2012, 12:53 PM   #88
country flag Chris.
Registered User
 
Chris.'s Avatar
 
Join Date: Jan 2011
Posts: 4,150
Chris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond reputeChris. has a reputation beyond repute
Default 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 View My Blog!   Reply With Quote
Old 09-25-2012, 04:18 PM   #89
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

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 View My Blog!   Reply With Quote
Old 09-25-2012, 04:37 PM   #90
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,269
-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- has a reputation beyond repute-Evita- 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.
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 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