Evita's TT Management Spreadsheet - Page 3 - 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 05-17-2009, 01:01 PM   #31
country flag ExcaliburII
Registered User
 
ExcaliburII's Avatar
 
Join Date: Oct 2006
Location: El Enzo Francescoli
Age: 24
Posts: 34,660
ExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond reputeExcaliburII has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

insane work. Thanks a lot
__________________
The Magic Treble
© ExcaliburII

ExcaliburII is offline View My Blog!   Reply With Quote
Sponsored Links
Advertisement
 

Old 07-27-2009, 12:42 PM   #32
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,182
-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 - Singles Best Of 5 Available

It's been more than two months and finally I have a new update - version 0.9 of the small spreadsheet. There are three new things:

- On the last update, I added the possibility to turn off displaying all SRs for Singles in Results. Now I added the same for Doubles.

- I have had a lot of difficulty explaining to managers why it's very important that there are no spelling mistakes in picks. They just ignore the red warning So I implemented a new, more effective method to let them know some picks are incorrect - Differences aren't displayed anymore for the matches that contain mistakes.

- This is something Jess suggested, I think. When a round lasts two days, the correct SR count from the previous day is displayed in Differences.

Small 0.9 xls 2.88 MB
Small 0.9 zip 479 KB

Have fun
__________________
한국어 너무 좋아요
-Evita- is online now View My Blog!   Reply With Quote
Old 07-29-2009, 03:35 AM   #33
country flag savesthedizzle
#freeviktor
 
savesthedizzle's Avatar
 
Join Date: Oct 2004
Location: formerly known as Troickitard
Posts: 93,381
savesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond reputesavesthedizzle has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Yesss that was my suggestion

Can't wait to use it

I don't know how people manage to ignore the red warning
__________________
Troicki - Djokovic - Del Potro - Kyrgios - Berankis
Cibulkova - Robson - Kirilenko - Azarenka
Retired but always loving Ferrero - Ancic - Kiefer

savesthedizzle is offline View My Blog!   Reply With Quote
Old 07-29-2009, 04:13 AM   #34
country flag mcarvalho
Registered User
 
mcarvalho's Avatar
 
Join Date: Mar 2008
Posts: 3,746
mcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond reputemcarvalho has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

I am already using it. It works very well! Thanks Evita.

I really don't know how you could manage tournaments before the Evita SS.
mcarvalho is offline View My Blog!   Reply With Quote
Old 08-23-2009, 05:08 PM   #35
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,182
-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 - Singles Best Of 5 Available

I'm glad to see that many managers use my spreadsheets - less mistakes this way and easier life for everyone

I think I'm done with this now. I have updated Singles Big and Singles for GS to version 0.9 (they're in the first post) and finally I've also created the big version for Doubles. I've also got the Best of 5 for Doubles but I'm going to test it on USO before uploading it. So... I think I'm done, everything's done!

Please feel free to write how awesome my spreadsheet is, I can never get enough of that Or also if you find any bugs or if you have suggestions for improvements.
__________________
한국어 너무 좋아요
-Evita- is online now View My Blog!   Reply With Quote
Old 12-02-2009, 04:20 PM   #36
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,182
-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 - Singles Best Of 5 Available

Quote:
Originally Posted by -Evita- View Post
Please feel free to write how awesome my spreadsheet is, I can never get enough of that Or also if you find any bugs or if you have suggestions for improvements.
Nobody wrote anything

Small 0.91 xls 2.91 MB
Small 0.91 zip 480 KB

This is a new version, here's what's changed:

- Fixed a small bug in Doubles for the next round list (it didn't display some countries correctly in cells N33:O36)
- Fixed a bug in Doubles when sometimes the same player's picks from the Singles sheet weren't automatically displayed (this is a great feature IMO but it doesn't work in MS Excel, it works only in OO Calc)

I hope you will let me know if there's anything else to fix or to improve
__________________
한국어 너무 좋아요
-Evita- is online now View My Blog!   Reply With Quote
Old 12-08-2009, 05:27 PM   #37
country flag 156mphserve
Registered User
 
156mphserve's Avatar
 
Join Date: Jul 2009
Posts: 13,516
156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute156mphserve has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

great work I'm going to use it when I manage DTT in January and I may decide to manage TT as this makes it much easier thanks
__________________
2012 Chennai Champion
11-13 San Jose 3-Peat
Milos

Welcome Your Newest Top 10 Member

Raonic

Proud Canadian
11-13 San Jose 3-Peat
2012 Chennai Champion
156mphserve is offline View My Blog!   Reply With Quote
Old 01-16-2010, 02:28 PM   #38
country flag tennismaster882001
Registered User
 
tennismaster882001's Avatar
 
Join Date: Apr 2004
Posts: 1,599
tennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond reputetennismaster882001 has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Got to keep this at the top here!
tennismaster882001 is offline View My Blog!   Reply With Quote
Old 02-09-2010, 12:32 AM   #39
country flag kai.
-LIFETIME MEMBER-
 
kai.'s Avatar
 
Join Date: Nov 2006
Location: N.Hollywood
Age: 25
Posts: 10,533
kai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by -Evita- View Post
Nobody wrote anything

Small 0.91 xls 2.91 MB
Small 0.91 zip 480 KB

This is a new version, here's what's changed:

- Fixed a small bug in Doubles for the next round list (it didn't display some countries correctly in cells N33:O36)
- Fixed a bug in Doubles when sometimes the same player's picks from the Singles sheet weren't automatically displayed (this is a great feature IMO but it doesn't work in MS Excel, it works only in OO Calc)

I hope you will let me know if there's anything else to fix or to improve


Ok, 1... LOVE IT .. XD

I have a problem on singles, order of play and result row 3rd when i add the winner of that row it doesnt count it on the results :S...
__________________
Feli & Nando



http://eltenisquenovemos.com.ar
kai. is offline View My Blog!   Reply With Quote
Old 02-09-2010, 04:46 AM   #40
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,182
-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 - Singles Best Of 5 Available

Quote:
Originally Posted by kai. View Post
I have a problem on singles, order of play and result row 3rd when i add the winner of that row it doesnt count it on the results :S...
You should upload your file to mediafire.net and send the link to me, I'll look at it and tell you what's wrong.
__________________
한국어 너무 좋아요
-Evita- is online now View My Blog!   Reply With Quote
Old 02-09-2010, 07:03 AM   #41
country flag kai.
-LIFETIME MEMBER-
 
kai.'s Avatar
 
Join Date: Nov 2006
Location: N.Hollywood
Age: 25
Posts: 10,533
kai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond reputekai. has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

I just downloaded again, i think is that o the 3rd row it was blake's result so i will see what happens m*

then if it keeps not showing the 3rd row result i send you the Excel
__________________
Feli & Nando



http://eltenisquenovemos.com.ar
kai. is offline View My Blog!   Reply With Quote
Old 02-09-2010, 01:57 PM   #42
country flag ibreak4coffee
Moderator
 
ibreak4coffee's Avatar
 
Join Date: Jun 2009
Location: New York
Posts: 7,098
ibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by -Evita- View Post
You should upload your file to mediafire.net and send the link to me, I'll look at it and tell you what's wrong.
I had the same problem last week as well - just skipped that row entirely.
ibreak4coffee is offline View My Blog!   Reply With Quote
Old 02-09-2010, 02:32 PM   #43
country flag -Evita-
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,182
-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 - Singles Best Of 5 Available

Quote:
Originally Posted by ibreak4coffee View Post
I had the same problem last week as well - just skipped that row entirely.
I don't know why the third row would be special Are you sure you didn't delete any formulas? Anyway, if any of you have trouble with the spreadsheet you should send it to me so I can see what's wrong and fix it if required. My goal is to have it working perfectly so I need you to tell me about all the mistakes you find
__________________
한국어 너무 좋아요
-Evita- is online now View My Blog!   Reply With Quote
Old 02-09-2010, 03:05 PM   #44
country flag ibreak4coffee
Moderator
 
ibreak4coffee's Avatar
 
Join Date: Jun 2009
Location: New York
Posts: 7,098
ibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond reputeibreak4coffee has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by -Evita- View Post
I don't know why the third row would be special Are you sure you didn't delete any formulas? Anyway, if any of you have trouble with the spreadsheet you should send it to me so I can see what's wrong and fix it if required. My goal is to have it working perfectly so I need you to tell me about all the mistakes you find
I assumed I had an isolated problem since I had to convert the file from excel to .ods format, as well as the fact I have office 2007 at home and an older office version at work. No one else brought the issue up and since to my understanding everyone uses the spreadsheet I thought it would have been raised already. Am glad to send the spreadsheet to you though.

The problem for me at least was just with diffs. Line 3 will record the correct winner, but it wont for some reason show up on the diffs. Trust me - I didnt touch a thing

Can you PM me what email I can send the spreadsheet to?
ibreak4coffee is offline View My Blog!   Reply With Quote
Old 02-09-2010, 03:10 PM   #45
country flag l_mac
I DON'T LIKE DJOKOVIC
 
l_mac's Avatar
 
Join Date: Feb 2004
Posts: 41,185
l_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond reputel_mac has a reputation beyond repute
Default Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by ibreak4coffee View Post
I assumed I had an isolated problem since I had to convert the file from excel to .ods format, as well as the fact I have office 2007 at home and an older office version at work. No one else brought the issue up and since to my understanding everyone uses the spreadsheet I thought it would have been raised already. Am glad to send the spreadsheet to you though.

The problem for me at least was just with diffs. Line 3 will record the correct winner, but it wont for some reason show up on the diffs. Trust me - I didnt touch a thing

Can you PM me what email I can send the spreadsheet to?
Just upload it to mediafire, or similar, and PM the link to Evita.
l_mac 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