Mens Tennis Forums banner
61 - 80 of 150 Posts
Replying here

I will make a final update after the final with it sorted that way. I tried to catch all errors in spelling if it was a winning pick. (ie no changes to Djokovic in the final. I am pretty sure about R1 and R2, I will have to look closely at QF, SF and F tomorrow.
There's an easy way to identify whether or not all errors have been caught.
In the stats sheet, calculate a sum of each column. The number of picks for winner should be the same as the number of players. Number of picks for SF winners should be double that, and so on. That way you can catch which column has the error, and you can keep dividing it into individual row blocks to figure out where the error is.
 
Replying here



There's an easy way to identify whether or not all errors have been caught.
In the stats sheet, calculate a sum of each column. The number of picks for winner should be the same as the number of players. Number of picks for SF winners should be double that, and so on. That way you can catch which column has the error, and you can keep dividing it into individual row blocks to figure out where the error is.
That is a lot easier. I will do the final update tonight and catch the errors.

Thank you :)
 
I have it all done! Thanks to Pratik! for helping with the errors and thanks to BMT with sorting.

How do you guys upload such beautiful jpgs?
 
I have it all done! Thanks to Pratik! for helping with the errors and thanks to BMT with sorting.

How do you guys upload such beautiful jpgs?
I copy the entire thing(literally, with a ctrl-c) and paste it in an image manipulation software. Usually paint. If I'm on linux(with KDE), I used KolourPaint. Then upload the image to uploadir or tinypic or anything like that.

But I do know that there are some managers who do it directly, without saving the image. Don't know how.
 
I copy the entire thing(literally, with a ctrl-c) and paste it in an image manipulation software. Usually paint. If I'm on linux(with KDE), I used KolourPaint. Then upload the image to uploadir or tinypic or anything like that.

But I do know that there are some managers who do it directly, without saving the image. Don't know how.
Imgur lets you upload an image directly from the clipboard when you copy from Excel and paste into Imgur's uploader.
 
WELCOME FOR A NEW SEASON OF FITD!!!

JAN 4
Brisbane (250, 28) : Arsenalex
Doha (250, 32) : Ponas Donny
Chennai (250, 28) : bhamism

JAN 11
Sydney (250, 28) : Ponas Donny
Auckland (250, 28) : bhamism

JAN 18
Australian Open (GS, 128) : Singles: BMT360 Doubles: bhamism/Pratik

FEB 1
Montpellier (250, 28) : Ponas Donny
Sofia (250, 28) : Ponas Donny
Quito (250, 28) : Thexc

FEB 8
Rotterdam (500, 32) : bhamism
Memphis (250, 28) : Ponas Donny
Buenos Aires (250, 28) : Ponas Donny

FEB 16
Rio de Janeiro (500, 32) : Pratik
Marseille (250, 28) : bry17may
Delray Beach (250, 32) : BMT360

FEB 22
Dubai (500, 32) : Eddy DoubleD/Snowwy
Acapulco (500, 32) : bry17may
Sao Paulo (250, 28) : BMT360

MAR 7
Indian Wells (1000, 96) : Ponas Donny

MAR 21
Miami (1000, 96) : BMT360

APR 4
Marrakech (250, 28) : BMT360
Houston (250, 28) : ESPNGEEK

APR 10
Monte-Carlo (1000, 56) : ESPNGEEK

APR 18
Barcelona (500, 48) : Arsenalex
Bucharest (250, 28) : Eddy DoubleD

APR 25
Munich (250, 28) : Snowwy
Istanbul (250, 28) : Ponas Donny
Estoril (250, 28) : Arsenalex

MAY 1
Madrid (1000, 56) : BMT360

MAY 8
Rome (1000, 56) :

MAY 15
Nice (250, 28) :
Geneva (250, 28):

MAY 22
Roland Garros (GS, 128) : Singles: Doubles:

JUN 6
’s-Hertogenbosch (250, 28) :
Stuttgart (250, 28) :

JUN 13
Halle (500, 32) :
Queen's (500, 32) :

JUN 20
Nottingham (250, 48) :

JUN 27
Wimbledon (GS, 128) : Singles: Doubles:

JUL 11
Hamburg (500, 32) :
Newport (250, 28) :
BĂĄstad (250, 28) :

JUL 18
Washington D.C. (500, 48) :
Umag (250, 28) :
Gstaad (250, 28) :
KitzbĂĽhel (250, 28):

JUL 25
Toronto (1000, 56) :

AUG 1
Atlanta (250, 28):

AUG 8
Rio de Janeiro (OG, 64) :
Los Cabos (250, 28):

AUG 17
Cincinnati (Masters 1000, 56) :

AUG 22
Winston Salem (250, 48) :

AUG 29
US Open (GS, 128) : Singles: Doubles:

SEP 19
Metz (250, 28) :
St. Petersburg (250, 28) :

SEP 26
Shenzhen (250, 28) :
Kuala Lumpur (250, 28) :

OCT 3
Beijing (500, 32) :
Tokyo (500, 32) :

OCT 10
Shanghai (1000, 56) :

OCT 17
Stockholm (250, 28) :
Moscow (250, 28) :
Valencia (250, 28) :

OCT 24
Vienna (250, 28) :
Basel (500, 32) :

OCT 31
Paris (1000, 48) :

NOV 14
London (YEC, 8) :


Manager count:



Spreadsheets

1. Old spreadsheet (manual inserting the predictions and correcting the spelling errors and spaces after names)

2. New spreadsheet - ask bhamism for permission to access his document (automatic extraction of predictions and highlights the spelling errors and spaces after names)
I've taken Istanbul. Also, here's the updated managers list.
 
  • Like
Reactions: BMT360 and ESPNGEEK
Discussion starter · #76 ·
I have to give up on the Bucharest tournament. Does anyone want to take it? :)
 
Toss it my way :)
 
I will have a tough time posting the Munich draw as I am away from civilisation next weekend. I will post the thread on Friday, but I may need someone else to post the draw.
 
@Snowwy @Ponas Donny @BMT360 I could make a spreadsheet tomorrow on Google Drive if you want like bhamism's live updating sheet except using the old sheet. Would be easy for me maybe will take 20 minutes. Basically the only difference is that there would be a view only link where any player can see the standings of every draw that week, but it will still need manual updates to standings and everything we do... It could be helpful of course for Snowwy, if you are away then others could help out by posting your draw and entering player's draws. Managers should still be posting updates in the thread.

Let me know if you would be interested in doing this joint spreadsheet so I can see how many tournaments I will need to make and I can PM you the editor's link :)
 
61 - 80 of 150 Posts