re: 2017-2018 TD Fantasy Premier League Thread

Posted by different arse

'Merica

Member since Apr 2014

4301 posts

Posted on 10/26/17 at 7:47 am to GeauxColonels

I'm aiming to be the highest scoring last place team ever. #goals #ambition #ftge

Posted by different arse

'Merica

Member since Apr 2014

4301 posts

Posted on 10/26/17 at 7:58 am to different arse

Loaf Pinchers FC - Week 10 Lineup

GK - Petr Cech (Arsenal)

DF - Jamaal Lascelles (Newcastle)
DF - Ben Davies (Spurs)
DF - Laurent Koscielny (Arsenal)

MF - Pascal Groß (Brighton and Hove Albion)
MF - Kevin De Bruyne [VC] (Man City)
MF - Roberto Pereyra (Watford)
MF - Manuel Lanzini (West Ham)

FW - Sergio Agüero [C] (Man City)
FW - Joshua King (Bournemouth)
FW - Jay Rodriguez (West Brom)

Bench:
1. MF - Jesé Rodríguez Ruiz (Stoke)
2. MF - Nathan Redmond (Southampton)
3. DF - Joel Matip (Liverpool)
GK - Jonas Lössl (Huddersfield)

At Home:
DF - Danilo (Manchester City)

Posted by The Mick

Member since Oct 2010

43223 posts

Posted on 10/26/17 at 8:07 am to The Mick

Hand of God - Week 10 Lineup:

GK
de Gea - MU

Def
Alonso - Chel
Otamendi - MC
Maguire - Lei

Mid
Coutinho - Liv (vc)
Doucoure - Wat
Delph - MC
Stanislas - Bou
Xhaka - Ars

F
Jesus - MC (*C*)
Diouf - Stk

Subs
Fabregas - Chel
Okazaki - Lei
Femenia - Wat
Hennessy - CP

Reserves
Clyne - Liv

This post was edited on 10/26/17 at 8:14 am

3 ...

Posted by The Mick

Member since Oct 2010

43223 posts

Posted on 10/26/17 at 8:11 am to The Mick

Drop: Georgio Wijnaldum - Mid, Liv
Add: Junior Stanislas - Mid, Bou

2 ...

Posted by etm512

Mandeville, LA

Member since Aug 2005

20760 posts

Posted on 10/26/17 at 8:25 am to GeauxColonels

I have a max score of 49?!?!? Woof

Posted by Vicks Kennel Club

29-24 #BlewDat

Member since Dec 2010

31084 posts

Posted on 10/26/17 at 8:25 am to GeauxColonels

Yeah, I built the skeleton of the spreadsheet years ago before I knew how to do a few things in Excel, so now I just copy and paste each year.

I will look at improving it if I can. What stats do you track? Points scored, ppg, points against, papg, max for, min for.

I think the key will be to build a tab where every team's numbers are in one row/column and I can pull data easier. This will be fun to build out I get the time.

This post was edited on 10/26/17 at 8:30 am

Posted by etm512

Mandeville, LA

Member since Aug 2005

20760 posts

Posted on 10/26/17 at 8:31 am to Vicks Kennel Club

Drop: Marko Arnautovic, MF, WHU
Add: Kevin Mirallas, MF, Eve

Posted by etm512

Mandeville, LA

Member since Aug 2005

20760 posts

Posted on 10/26/17 at 8:36 am to etm512

Roque's Stache and the Dodgy Flappers Week 9 Lineup

GK
Mathew Ryan - BHA

Def
Serge Aurier - Spurs
Danny Rose - Spurs
Gary Cahill - Che

MF
Mesut Özil - Ars (VC)
Tom Ince - Hud
Henrikh Mkhitaryan - ManU
Solomon March - BHA
Kevin Mirallas - Eve

Fwd
Álvaro Morata - Che (C)
Manolo Gabbiadini - South

Bench
1) Daniel Sturridge - Liv
2) Luciano Narsingh - Swans
3) Ahmed El-Sayed Hegazi - WBA
GK2) Kasper Schmeichel - LC

Cheap Seats: Martin Olsson - Swans

2 ...

Posted by GeauxColonels

Tottenham Fan | LSU Fan

Member since Oct 2009

25604 posts

Posted on 10/26/17 at 9:56 am to Vicks Kennel Club

quote:
What stats do you track? Points scored, ppg, points against, papg, max for, min for.

Well, before yesterday I just tracked the weekly scores, total scores and standings. After the couple of posts yesterday, I quickly built the formulas to track max & min PF & PA as well as avg scoring. Good thing for me is that I've been tracking the data since the 2014-15 season in this same spreadsheet in the same format.

Here are the 2 stat sheets I have (click them for full size). I also track all of the transactions, rosters and the weekly scores for my team and my opponents.

This post was edited on 10/26/17 at 10:07 am

2 ...

Posted by WarSlamEagle

Manchester United Fan

Member since Sep 2011

24611 posts

Posted on 10/26/17 at 10:07 am to GeauxColonels

ADD: Heurelho Gomes, GK, Watford
DROP: Nick Pope, GK, Burnley

ADD: Shane Duffy, DEF, Brighton and Hove Albion
DROP: Christian Fuchs, DEF, Leicester City

ADD: Aaron Mooy, MID, Huddersfield Town
DROP: Tom Carroll, MID, Swansea City

This post was edited on 10/26/17 at 10:21 am

Posted by WarSlamEagle

Manchester United Fan

Member since Sep 2011

24611 posts

Posted on 10/26/17 at 10:28 am to WarSlamEagle

We've been putting up nothing but lumps of coal lately.

The Chuck Blazer Memorial All-Stars
Round 10 Lineup

GK
Heurelho Gomes (Watford)

DEF
Antonio Valencia (Manchester United)
Cedric (Southampton)
Shane Duffy (Brighton and Hove Albion)

MID
David Silva (Manchester City) *VC*
Wilfried Zaha (Crystal Palace)
Aaron Mooy (Huddersfield Town)
Christian Atsu (Newcastle United)

FWD
Romelu Lukaku (Manchester United) *C*
Jordan Ayew (Swansea City)
Ayoze Perez (Newcastle United)

SUBS
1. Nemanja Matic (Manchester United)
2. Saed Kolasinac (Arsenal)
3. Chris Löwe (Huddersfield Town)
GK. Lukasz Fabianski (Swansea City)

IR
Christian Benteke (Crystal Palace)

3 ...

Posted by GeauxColonels

Tottenham Fan | LSU Fan

Member since Oct 2009

25604 posts

Posted on 10/26/17 at 10:43 am to WarSlamEagle

DROP: D Antonio Rüdiger (CHE)
ADD: M Tiemoué Bakayoko (CHE)

Posted by GeauxColonels

Tottenham Fan | LSU Fan

Member since Oct 2009

25604 posts

Posted on 10/26/17 at 10:51 am to GeauxColonels

LSC ANGRY BOYS
18 PTS (6-0-3) | Matchday 10 Starting XI (4-5-1)
G Fraser Forster (SOU)
D Steven Ward (BUR)
D Kyle Walker (MCI) [VC]
D Kyle Naughton (SWA)
D Mathias ‘Zanka’ Jørgensen (HUD)
M Christian Eriksen (TOT)
M Juan Mata (MUN)
M Raheem Sterling (MCI) [C]
M Eric Maxim Choupo-Moting (STK)
M Tiemoué Bakayoko (CHE)
F Jamie Vardy (LEI)

Bench
M Dusan Tadic (SOU)
F Kelechi Iheanacho (LEI)
F Chris Wood (BUR)
G Tom Heaton (BUR)

Reserve
F Danny Welbeck (ARS)

Posted by The Mick

Member since Oct 2010

43223 posts

Posted on 10/26/17 at 1:07 pm to GeauxColonels

Posted by jackwoods4

Member since Sep 2013

28667 posts

Posted on 10/26/17 at 1:17 pm to The Mick

quote:
Drop: Georgio Wijnaldum - Mid, Liv
Add: Junior Stanislas - Mid, Bou

I was going to add him last week, but I didn't know who to drop.

Posted by Vicks Kennel Club

29-24 #BlewDat

Member since Dec 2010

31084 posts

Posted on 10/26/17 at 4:27 pm to WarSlamEagle

Your Chuck Blazer photo catalog is getting scary.

(I am sure they can all easily be found on Google. I hope...)

This post was edited on 10/26/17 at 4:28 pm

Posted by WarSlamEagle

Manchester United Fan

Member since Sep 2011

24611 posts

Posted on 10/26/17 at 5:18 pm to Vicks Kennel Club

All from a very special personal collection

Posted by BleedPurpleGold

New Orleans

Member since Apr 2005

18922 posts

Posted on 10/26/17 at 10:13 pm to The Mick

Add: Georgio Wijnaldum - Mid, Liv
Drop: Ilkay Gundogan - Mid, Man City