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

[Egon]

hmm, 1 second

edit: ooh, found it - here

editedit: seems i have to publish it to allow others to view it..

editeditedit: here ?

LOL - I just finished doing the exact same thing to Group A. Now a fully automated system, just need to enter results and the table updates itself. Doesn't look as nice as yours though, but I could make it look pretty easily enough


Group A Results and Table


This one is up to date Whappers, I'll maintain it if you like, just stick the link in your first post. Up to you !

Edit: Oops, somehow managed to link to James' sheet, now linking to my Group A sheet

 

[Whappers]

LOL - I just finished doing the exact same thing to Group A. Now a fully automated system, just need to enter results and the table updates itself. Doesn't look as nice as yours though, but I could make it look pretty easily enough


Group A Results and Table


This one is up to date Whappers, I'll maintain it if you like, just stick the link in your first post. Up to you !

I think I'll leave the results of all the groups to tomorrow @9pm as James is working on that. Perhaps you could split the workload and take two groups each? Thats if you don't mind of course!

 

[One More Solo]

Andybtsn- on for about 9.45 tonight?

 

[stevesmith_2009]

im on to play my games anyone?

 

[topher]

We've had two types of cups so far, I'd like to see a league next.

At least people won't feel like there's nothing to play for after a couple of losses.

I agree a league would be better

 

[Egon]

Just got MetalfaceMark to play and i'm done !

 

[CliffyBiro]

I'm on now if Naan or Mark are 'bout.

 

[Jamesbcd]

LOL - I just finished doing the exact same thing to Group A. Now a fully automated system, just need to enter results and the table updates itself. Doesn't look as nice as yours though, but I could make it look pretty easily enough

ha, yeh i haven't used excel since school - the only thing i'm having trouble with is being able to sort the group table by points.. seems to tricky so i'll just cut and paste

 

[Naan_H]

I'm on now if Naan or Mark are 'bout.

5 mins dude

 

[Egon]

ha, yeh i haven't used excel since school - the only thing i'm having trouble with is being able to sort the group table by points.. seems to tricky so i'll just cut and paste

Yeah I had trouble with that. I used the rank funtion to give a "rank" or position to each player, I did this in an seperate table which is hidden, I then used a vlookup to create the real table with the correct rankings. I'd take credit if I could but I found this which helped point me in the right direction http://www.auditexcel.co.za/Automatic%20Sorting%20Project.html

Took a little fiddling to get it to work in Google, but not too much.

 

[One More Solo]

Loki or Andybtsn just message me on PSN if you can play, I'm around.

 

[stevesmith_2009]

psg are 3.5 stars
ill be marseille they are 4 stars

 

[Egon]

psg are 3.5 stars
ill be marseille they are 4 stars

LOL, we've been here before !!!!!

 

[Jamesbcd]

psg are 3.5 stars
ill be marseille they are 4 stars

it needs to be random, whappers will hopefully draw you another team asap

 

[stevesmith_2009]

it needs to be random, whappers will hopefully draw you another team asap

i just checked no one is marseille

 

[Whappers]

it needs to be random, whappers will hopefully draw you another team asap

Yeah. Two seconds guys!

 

[Whappers]

Ok. You've got Olympiacos CFP.

 

[ps3ud0]

PSG are 4 stars - me and James verified a few days ago...

And Im looking at them on Unranked while waiting for Jojo - its 4 stars...

Quite happy to provide proof if needed...

ps3ud0

 

[Jamesbcd]

something glitchy about fifa.. when both, gatid and stevie are in club selection.. they show up as 3.5 stars

but again, in exhibition.. 4 stars. makes no sense at all lol

 

[ps3ud0]

Id take whatever Unranked shows as thats the mode being played - my FIFA still shows as four stars...

ps3ud0