***OcUK Fifa 09 (PS3) Cup II - The Official Thread***

Jamesbcd said:
i think you've got the extra tables hidden as i can't see the columns your referring to.. but kudos on finding out how!! would like to have a look when your on later :)
Click to expand...

It's all tidied it up now. I've temporarily made it editable so you can see the formulas. This system works nicely but would still hit the same problem if both points and GD were the same, but you can extend the ranking system in the same way to include GF if needed and even GA. But since this is unlikely I've just left it at GD.

http://spreadsheets.google.com/ccc?key=rGl6MdLxB4dqHVE8pdmBqeg
 
Whappers said:
Guys I am unfortunately not going to be online tonight at all to post the scores / groups in the OP. This will have to be done tomorrow now! :o

If whoever is dealing with the scores, Ergon or James, could just post a link to the spreadsheet for all group games played up to tonight @9pm and make the post lettering really big, bold and noticeable for everyone else that would be fandabbydozee! :cool:
Click to expand...

I'll nominate James as he has a finished spreadsheet with all 4 groups ;):D
Oh and I'll ignore the eRgon this time whOppers :p


Edit: Oops on the double post, tried to edit the first but clearly failed :o
 
Last edited:
EgonSpengler said:
It's all tidied it up now. I've temporarily made it editable so you can see the formulas. This system works nicely but would still hit the same problem if both points and GD were the same, but you can extend the ranking system in the same way to include GF if needed and even GA. But since this is unlikely I've just left it at GD.

http://spreadsheets.google.com/ccc?key=rGl6MdLxB4dqHVE8pdmBqeg
Click to expand...

just went on it and woah.. i can see you controlling the screen on mine!! lol
 
Jamesbcd said:
just went on it and woah.. i can see you controlling the screen on mine!! lol
Click to expand...

LOL - I noticed an error in the final standings so just tweaked it! I was just thinking to myself "I wonder what you see when I do this". Now I know haha, pretty cool !
 
Jamesbcd said:
i've given up on the gd variable.. can't quit make out what to do!
Click to expand...

It's all down to column C & D

C works out the rank using the rank function - nice and easy.

D uses sumproduct, it checks if there are any values the same in the Rank column then looks in the GD column for the higher value of those. It then ranks them (greater number returns 0, lowest returns 1)

A then adds C & D together to give the final rank. It does help if you could see it working on a table where two players have the same points.
 
Last edited:
EgonSpengler said:
It's all down to column C & D

C works out the rank using the rank function - nice and easy.

D uses sumproduct, it checks if there are any values the same in the Rank column then looks in the GD column for the higher value of those. It then ranks them (greater number returns 0, lowest returns 1)

A then adds C & D together to give the final rank. It does help if you could see it working on a table where two players have the same points.
Click to expand...
finally got round to doing it.. i have it working in excel but it comes up as #N/A's on the google spreadsheet :confused:.. ah well!

http://spreadsheets.google.com/pub?key=rJVTyyqQ9LaMVCQSXtrhwcA&output=html
 
Last edited:
EgonSpengler said:
If you surround the whole sumproduct formula with the arrayformula function does it make a difference?
Click to expand...

don't think i used any arrayformulas..

it's the sumproduct that is displaying all values as "0" but in office excel, the person with joint points and lower goal difference displays "1". not sure why it's displaying "0" in googledocs though :confused:
 
Jamesbcd said:
don't think i used any arrayformulas..

it's the sumproduct that is displaying all values as "0" but in office excel, the person with joint points and lower goal difference displays "1". not sure why it's displaying "0" in googledocs though :confused:
Click to expand...

I have to admit I tested it in Excel and it worked, stuck it in my google spreadsheet and got no errors so assumed it worked, but never actually tested it on a table with equal points. I'll test it now.

Edit: Just ran a quick test with the change mentioned above (arrayformula fucntion). It fixes the problem with the #N/A's. My spreadsheet is still editable if you want to check the formula. Have a quick peek at D26 downwards.
 
Last edited:
EgonSpengler said:
I have to admit I tested it in Excel and it worked, stuck it in my google spreadsheet and got no errors so assumed it worked, but never actually tested it on a table with equal points. I'll test it now.

Edit: Just ran a quick test with the change mentioned above (arrayformula fucntion). It fixes the problem with the #N/A's. My spreadsheet is still editable if you want to check the formula. Have a quick peek at D26 downwards.
Click to expand...
you sir, are a star :)

http://spreadsheets.google.com/pub?key=rJVTyyqQ9LaMVCQSXtrhwcA&output=html
 
RESULTS UP TO THIS POST HAVE BEEN UPDATED!!

http://spreadsheets.google.com/pub?key=rJVTyyqQ9LaMVCQSXtrhwcA&output=html

Code: 
Whappers 0-1 Jojothemonkey69
Jojothemonkey69 1-1 Whappers
Jojothemonkey69 1-4 Dan7
Dan7 2-0 Jojothemonkey69
Whappers 1-6 Dan7
Dan 2-2 Whappers
Dan7 0-1 Jamesbcd
Jamesbcd 4-2 Dan7
One More Solo 1-1 Mjer1984
Mjer1984 1-1 One More Solo
Whappers 0-3 Jamesbcd
Jamesbcd 3-0 Whappers
Jojothemonkey69 1-3 Jamesbcd
James 1-0 Jojothemonkey69
Mjer1984 5-2 Topher
Topher 0-2 Mjer1984 
Gatidd 1 - 1 Ash6290
Ash6290 4 - 1 Gatidd 
Surfer 1-0 EgonSpengler 
EgonSpengler 0 - 1 Surfer
Gatidd 2-1 Sony144
Sony144 0-5 Gatidd
Surfer 1 - 2 Skippi90
Skippi90 2 - 0 Surfer
Ps3ud0 2 - 1 Jamesbcd
Jamesbcd 2 - 0 Ps3ud0
Sony144 1- 2 Ash6290
Ash6290 1- 4 Sony144
Whappers 0-1 Ps3ud0
Ps3ud0 2-2 Whappers
Skippi90 2 - 0 EgonSpengler
EgonSpengler 1 - 2 Skippi90
Andybtsn 0-1 Mjer1984
Mjer1984 1-1 Andybtsn
One More Solo 0-1 Topher
Topher 0-0 One More Solo
Surfer 0-0 Naan_H
Naan_H 2-0 Surfer
Gatidd 3-3 Beenon
Beenon 0-1 Gatidd
EgonSpengler 0-2 Naan_H
Naan_H 0-0 EgonSpengler
Beenom 4-1 Ash6290
Ash6290 1-2 Beenom 
Skippi90 6-1 Naan_H
Naan_H 2-4 Skippi90 
One More Solo 3-0 Loki
Loki 0-3 One More Solo
Steviesmith2009 1-6 Gatidd
Gatidd 2-1 Steviesmith2009
 
skippi90 said:
James.... think you ahve enough spare time to do one up if it were a league? :p

Would be interesting to see.

Basically just one big group.
Click to expand...
i'd have enough spare time but i'd rather not 'host' it - i'm pap with rules and what not.. :p though you could host! and i'd be willing to be your partner in crime :cool:
 
Didn't have a chance to come on (I did only say hopefully :() - should be on tonight.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom