[ibreak4coffee]

Originally Posted by l_mac

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

[-Evita-]

Originally Posted by ibreak4coffee

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.

[ibreak4coffee]

Originally Posted by -Evita-

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.

[-Evita-]

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.

[kai.]

, so what should i do to take out the result from 3rd row..

[-Evita-]

Originally Posted by kai.

, 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.

[kai.]

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

[Nev]

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

[-Evita-]

Originally Posted by Nev

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

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

[Nev]

Originally Posted by -Evita-

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

Originally Posted by -Evita-

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:

Originally Posted by keqtqiadv

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.

[Goldenoldie]

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-.

[Marto]

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?

[scoobs]

Originally Posted by mmarto193

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?

[bandtree]

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:

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?

[-Evita-]

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).