2012 FITD Management Thread - Page 5 - MensTennisForums.com
Reply
 
LinkBack Thread Tools
post #61 of 171 (permalink) Old 03-25-2012, 06:50 AM
Registered User
 
Chris.'s Avatar
 
Join Date: Jan 2011
Posts: 4,387
                     
Re: 2012 FITD Management Thread

I will take Estoril
Chris. is offline  
Sponsored Links
Advertisement
 
post #62 of 171 (permalink) Old 03-26-2012, 06:06 AM
Registered User
 
jervisjames's Avatar
 
Join Date: Jun 2009
Location: Sydney, Australia
Age: 43
Posts: 4,446
                     
Re: 2012 FITD Management Thread

ANNOUNCEMENT!

After investigating the issues that Thunderfish had with the Miami spreadsheet, I have noticed a major mistake in the formulas for the 128 player stats page.

ALL columns that look like this need to have a number higher than 160 after $IU$, I had 144 which wasn't big enough for it to do the auto-calculate.

=IF(N7=1;HLOOKUP($A7;$PlayersPicks.$B$144:$IU$144;16;0);"")

In most of the other sheets I just added a 2 to make 2144 or 2145, etc. But must have forgot this one...

I am uploading the fixed version to Keep&Share, but if you want to do the fix yourself, the only thing needed changing is the $IU$ number to 160 or higher. Like this:

=IF(N7=1;HLOOKUP($A7;$PlayersPicks.$B$144:$IU$2144;16;0);"")

I noticed there is a problem also in the first 1 or 2 rows in the 32 draw sheet. Exactly the same problem, the number is too small. But only for the first few Positiions. The 64 draw sheet is fine and most of 32 draw sheet.
jervisjames is offline  
post #63 of 171 (permalink) Old 03-26-2012, 06:22 AM
Registered User
 
jervisjames's Avatar
 
Join Date: Jun 2009
Location: Sydney, Australia
Age: 43
Posts: 4,446
                     
Re: 2012 FITD Management Thread

http://www.keepandshare.com/doc/3006...mplate-1-2-meg

http://kvisit.com/S0MC3AQ

Here are the links to the file. The old one has been removed and replaced with the new file. I think it is the same link as before.
jervisjames is offline  
post #64 of 171 (permalink) Old 03-26-2012, 06:29 AM
Registered User
 
jervisjames's Avatar
 
Join Date: Jun 2009
Location: Sydney, Australia
Age: 43
Posts: 4,446
                     
Re: 2012 FITD Management Thread

I can do Belgrade. It's been a long while since I managed!!

Last edited by jervisjames; 03-26-2012 at 06:32 AM. Reason: removed Bucharest (Eddy's!)
jervisjames is offline  
post #65 of 171 (permalink) Old 04-26-2012, 11:04 PM
Registered User
 
Eddy DoubleD's Avatar
 
Join Date: Sep 2010
Location: Potsdam, NY
Age: 23
Posts: 6,539
                     
Re: 2012 FITD Management Thread

I want to manage Rome. I guess it would be the last one for the next 4 months.

JUAN MARTIN DEL POTRO

Grigor Dimitrov | Bernard Tomic | Kei Nishikori | Ernests Gulbis
Jiri Vesely | Nick Kirgyos | Thanasi Kokkinakis | Alexander Zverev

[TT]: Singles - Entry #123 Doubles - Entry #133 Partner: ?
[DTT]: Singles - Entry #7 Doubles - Entry #10 Partner: digor
[FITD]: Entry #43 Race #?
[PAW]: Entry #4 Race #?
[Suicide Tennis]: Entry #82 Race #?
Eddy DoubleD is online now  
post #66 of 171 (permalink) Old 04-28-2012, 04:23 AM
Registered User
 
ESimp's Avatar
 
Join Date: Apr 2011
Posts: 4,012
                     
Re: 2012 FITD Management Thread

I can take Nice and the French Open if no one wants them!
ESimp is online now  
post #67 of 171 (permalink) Old 05-04-2012, 07:15 AM
Registered User
 
jervisjames's Avatar
 
Join Date: Jun 2009
Location: Sydney, Australia
Age: 43
Posts: 4,446
                     
Re: 2012 FITD Management Thread

Note for future: Chase Visa will require assistance if he wants to manage a FITD again. No updates and no explanation is not really acceptable, if you can't do it, then don't commit to it.
jervisjames is offline  
post #68 of 171 (permalink) Old 05-05-2012, 04:53 PM
Registered User
 
Freak3yman84's Avatar
 
Join Date: Oct 2011
Posts: 12,417
                     
Re: 2012 FITD Management Thread

Just confirming that I'll take Halle =D

Oh Sheesh Y'all, 'Twas A Dream

Number of Times I've Cried Over Sucking at FITD: All but seven

W Houston and Samarkand Singles W Charlottesville W Lermontov W ATP Bastad W Bol Fut W Orleans (w/MathMul) W Cordenons (w/dinkulpus) Tashkent S&D (w/ Mr Brightside)

Quote:
Originally Posted by @Sweet Cleopatra View Post
I like how you make me appreciate my life by comparing it to yours then I take a deep breath and say: Thank God..
Freak3yman84 is offline  
post #69 of 171 (permalink) Old 05-06-2012, 12:41 AM
Registered User
 
DjokerFan3's Avatar
 
Join Date: Mar 2012
Posts: 904
                     
Re: 2012 FITD Management Thread

Hey everyone, unfortunately something has come up with me this week (work/family stuff...)
I will compile and organise all the picks onto the spreadsheet, but I'll be unable to do the daily updates for Madrid this week.

If any of the other managers are able to take over with the daily updates, then can u please send me a PM with your email address, and I'll send u the spreadsheet as an attachment.

Thanks, and sorry for the short notice.

FF

Congratulations Novak Djokovic on a superb 2015 season!
82-6 W/L, 3 slams + 6 MS1000 + WTF,
11 titles won from 15 consecutive finals


Also supporting: Federer, Tsonga, Del Potro, Wawrinka, Nishikori, Raonic, Gasquet, Berdych, Kokkinakis, Fognini, Brown, Dolgopolov, Ferrer

Not a fan of Nadal & Murray
DjokerFan3 is offline  
post #70 of 171 (permalink) Old 05-06-2012, 08:49 AM
Registered User
 
appleGirl's Avatar
 
Join Date: Feb 2011
Age: 29
Posts: 1,605
                     
Re: 2012 FITD Management Thread

I can do all the daily updates, except the very last one (on Sunday)

http://www.letsecondserve.com/

TT Singles: 38 (Best: 38) 2011: Fürth CH W, Izmir CH W, Seoul CH W, Sao Jose Do Rio Preto CH W; 2012: Tiburon CH W; 2015: 's-Hertogenbosch W; 2016: AO SF
TT Doubles: 20 (Best: 19) 2011: Izmir CH W (w/ Mahqz); 2012: US Open SF, Tiburon CH W, Antalya Fut W (w/Mahqz); 2013: Winston Salem W, US Open SF (w/Mahqz); 2015: Sarasota CH W, Fergana CH W, Wimbledon W, Gstaad W, Moscow W (w/Mahqz)
No.1vak Djokovic!

"Is something unbelievable how he returns, no? His return probably is one of the best of the history. That's my opinion, no? I never played against a player who's able to return like this. Almost every time." - R. Nadal about N. Djokovic
appleGirl is offline  
post #71 of 171 (permalink) Old 05-06-2012, 09:12 AM
Registered User
 
DjokerFan3's Avatar
 
Join Date: Mar 2012
Posts: 904
                     
Re: 2012 FITD Management Thread

Hey everyone, just letting you all know that Freak3yman84 has kindly agreed to post daily updates in Madrid for the upcoming week.

Thank you to everyone who offered.

Congratulations Novak Djokovic on a superb 2015 season!
82-6 W/L, 3 slams + 6 MS1000 + WTF,
11 titles won from 15 consecutive finals


Also supporting: Federer, Tsonga, Del Potro, Wawrinka, Nishikori, Raonic, Gasquet, Berdych, Kokkinakis, Fognini, Brown, Dolgopolov, Ferrer

Not a fan of Nadal & Murray
DjokerFan3 is offline  
post #72 of 171 (permalink) Old 05-06-2012, 05:22 PM
Registered User
 
ESimp's Avatar
 
Join Date: Apr 2011
Posts: 4,012
                     
Re: 2012 FITD Management Thread

Quote:
Originally Posted by ESimp View Post
I can take Nice and the French Open if no one wants them!
I'll need to work from Friday to Sunday with no internet the weekend that Nice picks would be due so can't properly manage there so need some else to grab this one.
ESimp is online now  
post #73 of 171 (permalink) Old 05-06-2012, 06:05 PM
Registered User
 
Freak3yman84's Avatar
 
Join Date: Oct 2011
Posts: 12,417
                     
Re: 2012 FITD Management Thread

Quote:
Originally Posted by ESimp View Post
I'll need to work from Friday to Sunday with no internet the weekend that Nice picks would be due so can't properly manage there so need some else to grab this one.
I'll take it =D

Oh Sheesh Y'all, 'Twas A Dream

Number of Times I've Cried Over Sucking at FITD: All but seven

W Houston and Samarkand Singles W Charlottesville W Lermontov W ATP Bastad W Bol Fut W Orleans (w/MathMul) W Cordenons (w/dinkulpus) Tashkent S&D (w/ Mr Brightside)

Quote:
Originally Posted by @Sweet Cleopatra View Post
I like how you make me appreciate my life by comparing it to yours then I take a deep breath and say: Thank God..
Freak3yman84 is offline  
post #74 of 171 (permalink) Old 05-08-2012, 12:06 AM
Registered User
 
Freak3yman84's Avatar
 
Join Date: Oct 2011
Posts: 12,417
                     
Re: 2012 FITD Management Thread

Quote:
Originally Posted by Freak3yman84 View Post
I'll take it =D
That's alright then? Because I want to start doing the 1st few posts on it.

Oh Sheesh Y'all, 'Twas A Dream

Number of Times I've Cried Over Sucking at FITD: All but seven

W Houston and Samarkand Singles W Charlottesville W Lermontov W ATP Bastad W Bol Fut W Orleans (w/MathMul) W Cordenons (w/dinkulpus) Tashkent S&D (w/ Mr Brightside)

Quote:
Originally Posted by @Sweet Cleopatra View Post
I like how you make me appreciate my life by comparing it to yours then I take a deep breath and say: Thank God..
Freak3yman84 is offline  
post #75 of 171 (permalink) Old 05-11-2012, 01:09 AM
Registered User
 
Kamui010's Avatar
 
Join Date: Jul 2009
Posts: 2,659
                     
Re: 2012 FITD Management Thread

Hi, sorry for posting here, but I want to know, what happened with the Estoril Tournament, it isn't updated and it doesn't say who won.

Thanks.

Titles.
Suicide Tennis Cincinnati 10, Montpellier 12, Barcelona 12, Toronto 12
Fill In The Draw Kuala Lumpur 09, Doha 11, Buenos Aires 12, Washington 12, Casablanca 13, Houston 15, Rome 15, Sofia 16
Pick A Winner Rotterdam 12, s'Hertogenbosch 12, Los Angeles 12, Stuttgart 13, Queens 14
Kamui010 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