Thread Tools

Chris. · 03-25-2012, 05:50 AM

I will take Estoril

jervisjames · 03-26-2012, 05:06 AM

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 · 03-26-2012, 05:22 AM

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 · 03-26-2012, 05:29 AM

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

Eddy DoubleD · 04-26-2012, 10:04 PM

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

ESimp · 04-28-2012, 03:23 AM

I can take Nice and the French Open if no one wants them!

jervisjames · 05-04-2012, 06:15 AM

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.

Freak3yman84 · 05-05-2012, 03:53 PM

Just confirming that I'll take Halle =D

DjokerFan3 · 05-05-2012, 11:41 PM

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

appleGirl · 05-06-2012, 07:49 AM

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

DjokerFan3 · 05-06-2012, 08:12 AM

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.

ESimp · 05-06-2012, 04:22 PM

Quote:

Originally Posted by ESimp

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.

Freak3yman84 · 05-06-2012, 05:05 PM

Quote:

Originally Posted by ESimp

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

Freak3yman84 · 05-07-2012, 11:06 PM

Quote:

Originally Posted by Freak3yman84

I'll take it =D

That's alright then? Because I want to start doing the 1st few posts on it.

Kamui010 · 05-11-2012, 12:09 AM

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.