AEPL Game Analysis (PS W3) (Cup Final)

[CrowsFan]

Well done HP a worthy winner of the cup with that score!
I currently have pre season nerves but they will be gone by next week :)

[Fletch74]

Forgot to list everyone's teams

Q's Champions vs Hello

Q's Champions

GK   Howard   8   
Def   O'Shea   0   SR
Def   Skrtel   1   
Def   Givet   6   
Mid   Malouda   3   
Mid   Arteta   8   
Mid   Nolan   0   SR
Mid   Scholes   1   
Fwd   Bent   2   
Fwd   Odemwingie   0   SR
Fwd   Jones   2   
         
Captain   Arteta   8   
Vice-Captain   Bent   2   
         
Subs GK   Robinson   10   
Subs   Williamson   1   
Subs   Walcott   0   
Subs   Alex   0   
         
   Total   40   
   Subs Req'd   3   

5 players not playing...

Hello

GK   Hart   1   
Def   Varmaelen   0   SR
Def   Baines   6   
Def   Ivanovic   6   
Def   Elmohamady   5   
Mid   Milner   5   
Mid   Arshavin   2   
Mid   Nani   10   
Mid   Henderson   3   
Fwd   Berbatov   7   
Fwd   Agbonlahor   0   SR
         
Captain   Milner   5   
Vice-Captain   Nani   10   
         
Subs GK   Jaaskelainen   2   
Subs   Davies   8   
Subs   Johnson   0   
Subs   Brunt   11   
         
   Total   69   
   Subs Req'd   2   

2 subs required, and they were magic.

   

[Fletch74]

ZZ's Zanny Zebra's vs Hawka FC

ZZ's Zanny Zebra's

GK   Van der Sar   1   
Def   Terry   5   
Def   Assou-Ekotto   2   
Def   Young L   0   SR
Def   Richards   0   
Mid   Young A   3   
Mid   Nasri   7   
Mid   Cole   2   
Mid   Bale   5   
Fwd   Rooney   1   
Fwd   Carew   2   
         
Captain   Rooney   1   
Vice-Captain   Bale   5   
         
Subs GK   Carson   1   
Subs   A Ferdinand   0   
Subs   Kuyt   0   
Subs   Van Persie   0   
         
   Total   29   
   Subs Req'd   1

No subs available for Zz to use

Hawka FC

GK   Friedel   7   
Def   Evra   -1   
Def   Agger   0   SR
Def   Sagna   0   SR
Def   Ridgewell   1   
Def   Samba   -2   
Mid   Cahill   9   
Mid   Barry   2   
Mid   Barton   2   
Mid   Essien   4   
Fwd   Drogba   0   SR
         
Captain   Drogba   0   
Vice-Captain   Cahill   9   
         
Subs GK   Sorenson   2   
Subs   Ebanks-Blake   1   
Subs   Saha   0   
Subs   Gardner   0   
         
   Total   32   
   Subs Req'd   3

3 subs required, but only one could be used.   

[Fletch74]

The Matchbox Matadors vs Didhedive Drogba

The Matchbox Matadors

GK   Reina   1   
Def   Koscielny   0   SR
Def   Ferdinand R   1   
Def   Boateng   6   
Mid   Lee   7   
Mid   Lampard   0   SR
Mid   Gerrard   2   
Mid   Etherington   2   
Mid   Fellaini   0   SR
Fwd   Rodellega   1   
Fwd   Torres   1   
         
Captain   Rodellega   1   
Vice-Captain   Ferdinand R   1   
         
Subs GK   Gilks   2   
Subs   Jagielka   7   
Subs   Jerome   0   
Subs   Dunne   1   
         
   Total   30   
   Subs Req'd   3

3 subs required for CF, but only 2 were available   

Didhedive Drogba

GK   Cech   6   
Def   Vidic   1   
Def   Bosingwa   1   
Def   Toure   0   SR
Mid   Fabregas   0   SR
Mid   Johnson A   2   
Mid   Larsson   2   
Mid   Van der Vaart   7   
Mid   Silva   8   
Fwd   Carroll   4   
Fwd   Chamakh   12   
         
Captain   Van der Vaart   7   
Vice-Captain   Silva   8   
         
Subs GK   Green   2   
Subs   Fletcher   2   
Subs   Corluka   0   
Subs   Dann   1   
         
   Total   53   
   Subs Req'd   2   

2 Subs required for Andrew, and with Fabregas and Bosingwa to come back, a formidable force to be reckoned with.

[Fletch74]

Larder's Loveable Losers vs Hilly's Heroics

Larder's Loveable Losers

GK   Alumnia   0   
Def   Hangeland   1   
Def   Squillaci   2   
Def   Carragher   1   
Mid   Kalou   0   SR
Mid   Giggs   1   
Mid   Duff   0   SR
Mid   Modric   2   
Fwd   Anelka   2   
Fwd   Elmander   2   
Fwd   Gyan   1   
         
Captain   Modric   2   
Vice-Captain   Anelka   2   
         
Subs GK   Schwarzer   2   
Subs   Adam   7   
Subs   Bramble   6   
Subs   Lescott   1   
         
   Total   29   
   Subs Req'd   2   

2 Subs required, plus a sub GK for benjy. Just as well they played...

Hilly's Heroics

GK   Gomes   3   
Def   Cole A   9   
Def   Ferreira   6   
Def   Clichy   2   
Def   Warnock   5   
Mid   Mikel   3   
Mid   Lennon   1   
Mid   Fletcher   0   SR
Mid   Downing   3   
Mid   Song   2   
Fwd   Tevez   12   
         
Captain   Fletcher   0   
Vice-Captain   Tevez   12   
         
Subs GK   Foster   3   
Subs   Jovanovic   1   
Subs   Kalinic   1   
Subs   Carr   0   
         
   Total   59   
   Subs Req'd   1

Only 1 sub for Hilly, plus a great VC effort from Tevez.

[Master Q]

Fletch I think I could help, but not with the Spreadsheet, If it's easy, PM the instructions and I'll give you the final answer. I'm ok to rove the board and post updates and scores though.

[Fletch74]

Fletch I think I could help, but not with the Spreadsheet, If it's easy, PM the instructions and I'll give you the final answer. I'm ok to rove the board and post updates and scores though.

Thanks Q. It might take me a while to write up all the instructions. I'll start tomorrow.

It's not that hard, it's just a matter of archiving the old round, then keeping up with trades, selecting the team, then exporting the data from the EPL site when the games have been finished and bonus points have been awarded. The formulae take care of the rest.

Unfortunately it needs to be done because each player is based on a current total season points less last rounds total points scoring system rather than just obtaining the weekly results. It might seem wierd to do it this way, but because the order of the players change every week on the Player Stats from the site, it was the only way.

Let me know if that seems easy enough, if not I'll do it all manually when I get back. The most arduous part is downloading the stats after each game. Takes about half an hour.

[Master Q]

Sorry Fletch, as I said I'm not to great with Formulas on Excel. I think I'll just post updates here.

[Justin Bieber]

My subs are always super :-*. Beat out my regular team just by 1 point ;D.

Thanks for the cup. Will be used well for morning tea :P.

[Fletch74]

Sorry Fletch, as I said I'm not to great with Formulas on Excel. I think I'll just post updates here.

You won't have to do anything with formulas... Just copy/paste special and extract the data from the EPL site.

[Master Q]

Don't try to lure be into it Fletch. Sorry, but it's a no.

[Fletch74]

Don't try to lure be into it Fletch. Sorry, but it's a no.

Ok, whatever ;)

[Fletch74]

As promised, here is the spreadsheet.

Pre Season Week 3

Don't use this one

[Justin Bieber]

Sorry Fletch, but can't open the page. Can't display the page.

[Fletch74]

I'll try again

AEPL Pre-Season Week 3

Works now