Thread Tools

ExcaliburII · 05-17-2009, 01:01 PM

insane work. Thanks a lot

-Evita- · 07-27-2009, 12:42 PM

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

savesthedizzle · 07-29-2009, 03:35 AM

Yesss that was my suggestion

Can't wait to use it

I don't know how people manage to ignore the red warning

mcarvalho · 07-29-2009, 04:13 AM

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.

-Evita- · 08-23-2009, 05:08 PM

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- · 12-02-2009, 04:20 PM

Quote:

Originally Posted by -Evita-

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

156mphserve · 12-08-2009, 05:27 PM

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

tennismaster882001 · 01-16-2010, 02:28 PM

Got to keep this at the top here!

kai. · 02-09-2010, 12:32 AM

Quote:

Originally Posted by -Evita-

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

-Evita- · 02-09-2010, 04:46 AM

Quote:

Originally Posted by kai.

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.

kai. · 02-09-2010, 07:03 AM

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

ibreak4coffee · 02-09-2010, 01:57 PM

Quote:

Originally Posted by -Evita-

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.

-Evita- · 02-09-2010, 02:32 PM

Quote:

Originally Posted by ibreak4coffee

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

ibreak4coffee · 02-09-2010, 03:05 PM

Quote:

Originally Posted by -Evita-

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?

l_mac · 02-09-2010, 03:10 PM

Quote:

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.

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.