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

 1Likes
Reply
 
LinkBack Thread Tools
post #46 of 124 (permalink) Old 02-09-2010, 03:14 PM
Moderator
 
ibreak4coffee's Avatar
 
Join Date: Jun 2009
Location: New York
Posts: 13,022
                     
Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by l_mac View Post
Just upload it to mediafire, or similar, and PM the link to Evita.
My enlightened place of work firewalls mediafire (and a variety of other cool websites, thankfully not menstennisforums.com however)

If that's the prefered option then I will do it when I get home from work tonight
ibreak4coffee is offline  
Sponsored Links
Advertisement
 
post #47 of 124 (permalink) Old 02-09-2010, 03:26 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,969
                     
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.
Version 0.91 is relatively recent and it's always possible (though not likely) that there's a new bug in a new version. Your case sounds different though with all the conversions you did, I think I'll publish the spreadsheet in .ods format too to make it more convenient for people like you But I'm curious about the third row, it would be strange if it was just a coincidence that kai had a problem with it too.

한국어 너무 좋아요
-Evita- is offline  
post #48 of 124 (permalink) Old 02-09-2010, 03:49 PM
Moderator
 
ibreak4coffee's Avatar
 
Join Date: Jun 2009
Location: New York
Posts: 13,022
                     
Re: Evita's TT Management Spreadsheet - Singles Best Of 5 Available

Quote:
Originally Posted by -Evita- View Post
Version 0.91 is relatively recent and it's always possible (though not likely) that there's a new bug in a new version. Your case sounds different though with all the conversions you did, I think I'll publish the spreadsheet in .ods format too to make it more convenient for people like you But I'm curious about the third row, it would be strange if it was just a coincidence that kai had a problem with it too.
Exactly. When I saw kai's post I instantly recognized the problem. It is pretty important too since if managers aren't double checking the spreadsheet they are copying diffs that are not correct.
ibreak4coffee is offline  
post #49 of 124 (permalink) Old 02-09-2010, 04:53 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,969
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Boarder35m just figured out the third row problem There's nothing wrong with the spreadsheet, it's just that the third row has a sample winner (I put it there to show how the entering of winners should be done) and kai accidentally deleted the formula in J3 when deleting the sample data. You probably did something similar.

한국어 너무 좋아요
-Evita- is offline  
post #50 of 124 (permalink) Old 02-09-2010, 05:29 PM
-LIFETIME MEMBER-
 
kai.'s Avatar
 
Join Date: Nov 2006
Location: N.Hollywood
Age: 27
Posts: 10,533
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

, so what should i do to take out the result from 3rd row..
kai. is offline  
post #51 of 124 (permalink) Old 02-09-2010, 05:36 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,969
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Quote:
Originally Posted by kai. View Post
, so what should i do to take out the result from 3rd row..
Delete the data but don't remove formulas. If you see the cell starts with "=" like J3 then don't touch it. In fact, you can see that column J is grey which means it should never be touched. You should only enter and delete stuff in the yellow and blue areas - yellow is what you fill in before matches start and blue is the results.

한국어 너무 좋아요
-Evita- is offline  
post #52 of 124 (permalink) Old 02-09-2010, 06:17 PM
-LIFETIME MEMBER-
 
kai.'s Avatar
 
Join Date: Nov 2006
Location: N.Hollywood
Age: 27
Posts: 10,533
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

ok got it XD iam used to use the "delete" key for delete not the backspace.. m* i will try with the backspace this time..

thanks
kai. is offline  
post #53 of 124 (permalink) Old 02-11-2010, 11:46 AM
country flag Nev
Registered User
 
Nev's Avatar
 
Join Date: May 2006
Location: Cordoba, Argentina
Age: 29
Posts: 2,220
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Hi -Evita-
I'm using your spreadsheet for a tournament in DTT.
Just a couple of things.
In the doubles sheet there are some cells which have formulas in the results part:

Does it have some meaning?

And second, now it's a 2 day round, and in the same round there are matches which have the same protagonists (facing other doubles team) but in a different match.
When the stats are counted, it also counts the picks of the previous day.
Is there a solution to that?
Thanks in advance

2011 DTT singles US Open champion
2010 DTT doubles RG champion with *Jean*


Genius1787
Nev is online now  
post #54 of 124 (permalink) Old 02-11-2010, 04:50 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,969
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Quote:
Originally Posted by Nev View Post
Does it have some meaning?
Oops No, you should delete it, it's not supposed to be there. I think I was just experimenting with formulas and I forgot to delete that. I'll fix it in the next version

Quote:
And second, now it's a 2 day round, and in the same round there are matches which have the same protagonists (facing other doubles team) but in a different match.
When the stats are counted, it also counts the picks of the previous day.
Is there a solution to that?
I know what you mean and unfortunately there's no solution for that for now. There are many things to improve in the stats part, I haven't worked on it seriously yet. In fact, it would be helpful if you all would provide me some suggestions for the Stats sheet, what it should look like, then I'd have some ideas what to do

한국어 너무 좋아요
-Evita- is offline  
post #55 of 124 (permalink) Old 02-12-2010, 11:10 PM
country flag Nev
Registered User
 
Nev's Avatar
 
Join Date: May 2006
Location: Cordoba, Argentina
Age: 29
Posts: 2,220
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Quote:
Originally Posted by -Evita- View Post
Oops No, you should delete it, it's not supposed to be there. I think I was just experimenting with formulas and I forgot to delete that. I'll fix it in the next version
Ok
Quote:
Originally Posted by -Evita- View Post
I know what you mean and unfortunately there's no solution for that for now. There are many things to improve in the stats part, I haven't worked on it seriously yet. In fact, it would be helpful if you all would provide me some suggestions for the Stats sheet, what it should look like, then I'd have some ideas what to do
Well, maybe you can take some ideas from keqtqiadv's awards:
Quote:
Originally Posted by keqtqiadv View Post
Player of the day (best individual score)
Allez-Alejo (4 picks, 3 SRs, perfect PTS, CB 18, CB2 6, QF SR1 shootout)

- Team of the round (best doubles score)
Sheva/Allez-Alejo (8 picks, 6 SRs)


- Best TB - singles (best individual TB)
Allez-Alejo (3 SRs, perfect PTS, CB 18, CB2 6, QF SR1 shootout)

- Best TB - doubles (best doubles TB)
Sheva/Allez-Alejo (6 SRs)

- Bibon award - singles (worst individual score)
juakos17 (2 picks, 0 SRs)

- Bibon award - doubles (worst doubles score)
rototito/qczi (4 picks, 3 SRs)

- Bad luck award - singles (best losing score)
Marita (4 picks, 3 SRs)

- bad luck award - doubles (best losing score)
JMG/Spadea TT (4 picks, 4 SRs)

- Luck award - singles (worst winning score)
guille&tati4life (no picks, CB 5 picks, ...., SR2 no set to the winner)

- Luck award - doubles (worst winning score)
Overlord/Pigpen Stinks (0 picks)

- Match of the round - singles (highest combined score)
Marita vs nevito (8 picks, 6 SRs)

- Match of the round - doubles (highest combined score)
Sheva/Allez-Alejo vs Spadea TT/JMG (12 picks, 10 Srs)

- award - singles (easiest win - pick/SR differences)
Sheva (2 picks, 2 SRs)

- award - doubles (easiest win - pick/SR differences)
Sheva/Allez-Alejo (4 picks, 2 SRs)

- Pick of the day (less picked winner)
###

- award ( less picked loser)
Gasquet (juakos17)

- derossi award
###

- Traitor award
Allez-Alejo (Monfils def Blake)

- Risk taker award
JMG, Spadea TT, Hellcat, juakos17, qczi, rototito

- Bobby award (first player to send picks after the OOP is posted)
dusan1610 (day 1)
nevito (day 2)


- Labamba award (last player to send picks)
Marita (day 1)
Genius1787 (day 2)
I guess there are some nice stats there.

2011 DTT singles US Open champion
2010 DTT doubles RG champion with *Jean*


Genius1787
Nev is online now  
post #56 of 124 (permalink) Old 05-01-2010, 07:42 AM
Registered User
 
Goldenoldie's Avatar
 
Join Date: May 2009
Location: No fixed abode
Age: 72
Posts: 9,549
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

I'm just coming to the end of my first tournament as manager, and I have to say I can't imagine how anybody ever did the job before the spreadsheet was created. It must have taken hours, especially in the early rounds.

Thank you -Evita-.

M. T. F.
The biggest source of bullshit since cattle were domesticated.
Goldenoldie is offline  
post #57 of 124 (permalink) Old 11-01-2010, 10:23 AM
.
 
Join Date: Apr 2010
Age: 24
Posts: 34,766
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Why when I start entering matches in the picks columns, every time wrote that I have misspelled name, I check everything but I can't find my mistake, where I'm wrong?


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 #58 of 124 (permalink) Old 11-01-2010, 10:24 AM
Anastasia Komananov, KGB
 
scoobs's Avatar
 
Join Date: Jun 2005
Age: 38
Posts: 53,509
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Quote:
Originally Posted by mmarto193 View Post
Why when I start entering matches in the picks columns, every time wrote that I have misspelled name, I check everything but I can't find my mistake, where I'm wrong?
I assume you entered the OOP in the correct places in the top right?
scoobs is offline  
post #59 of 124 (permalink) Old 11-07-2010, 06:39 PM
Registered User
 
bandtree's Avatar
 
Join Date: Jun 2009
Posts: 2,376
                     
Re: Evita's TT Management Spreadsheet - Version 0.91 Small Available

Evita,

I'm using the small v0.91. I noticed that when a doubles team has a bye, they are automatically depicted as a winner in the diffs (ie. coloured blue with no diffs). This doesn't happen in the singles diffs however:

Quote:
ex.
00:00 | (1) Tytta! (BRA) vs. bye - Chardy, Phau, Roddick, Berdych vs. , , , SR Differences: Chardy 2-1 vs. 0-0, Phau 2-0 vs. 0-0, Roddick 2-0 vs. 0-0, Berdych 2-0 vs. 0-0
Is there any way to get the singles diffs to display like the doubles diffs?
bandtree is offline  
post #60 of 124 (permalink) Old 12-19-2010, 11:49 AM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,969
                     
Re: Evita's TT Management Spreadsheet - Version 0.92 Small Available

bandtree, I had also noticed this and finally I fixed it in the new version

Small 0.92 xls 2.91 MB
Small 0.92 zip 482 KB

I also added the Doubles Best of 5 ss to the first post (though it's been ready for some time already).

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