To see less ads Register or Login ----- Daily Fantasy Sports games 18+

FPL Fixtures and Results Grid 2015/16

A Fantasy Football forum for news on fantasy football games run by the Premierleague (FPL).
User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

FPL Fixtures and Results Grid 2015/16

Post by RomynPG »

Back for another year - hopefully useful to some.

Latest Copy: as at GW38
(edited 18/05/2016)

Same principle as previous years
(Last years thread & Last years completed grid)

(The printarea is set to fit everything on one page when printed).

Initial Team Rankings based on odds at Odds-Checker (17/06/15) and will be updated closer to the start of the season. Once the season is underway Rankings are then adjusted with results on a pro-rata basis.

(calc method outlined in a sheet in the spready)
Last edited by RomynPG on 18 May 2016, 11:47, edited 20 times in total.

mike_d99
Grumpy Old Man
Posts: 2657
Joined: 13 Oct 2005, 18:50
Location: cut down like a vegetable by your hard kickin mother who's an animal
FS Record: 269th TFF 08/09, 11th TFFO 08/09, 49th TFFE 08/09, 50th Elephant 10/11, 92nd Sky Sports 10/11

Re: FPL Fixtures and Results Grid 2015/16

Post by mike_d99 »

Thanks Romyn. Kind of you to share :)

User avatar
Mav3rick
FISO Jedi Knight
Posts: 20858
Joined: 20 Jul 2009, 20:35
FS Record: FPL: 1082, 1201, 1800, 10203

The stats are dark and full of errors.

Re: FPL Fixtures and Results Grid 2015/16

Post by Mav3rick »

Nice one... Thanks again for continuing to produce these RomynPG, I always use your spreadsheet at the start of the season for planning.

User avatar
RidleyMTB
Grumpy Old Man
Posts: 3316
Joined: 04 Nov 2006, 14:33

Re: FPL Fixtures and Results Grid 2015/16

Post by RidleyMTB »

Thanks again Romyn - this is really useful. :D

User avatar
liquidfootball2
Dumbledore
Posts: 8672
Joined: 05 Jan 2012, 16:14
FS Record: Best fpl finish 233 in 14/15

Re: FPL Fixtures and Results Grid 2015/16

Post by liquidfootball2 »

Thanks Romyn, great help.

User avatar
SuperGrover
Grumpy Old Man
Posts: 1540
Joined: 12 Sep 2012, 15:38
Location: Chicago, USA

Re: FPL Fixtures and Results Grid 2015/16

Post by SuperGrover »

Thanks Romyn.

I use this as a base and reformat the core schedule for ease of processing in Excel. Anyone who at wants it can access it at http://www97.zippyshare.com/v/P6T6rHJK/file.html.

User avatar
quarky
Treebeard
Posts: 229
Joined: 10 Aug 2014, 18:46

Re: FPL Fixtures and Results Grid 2015/16

Post by quarky »

Thanks RomynPG and SuperGrover!

User avatar
DrBunker
FISO Knight
Posts: 19050
Joined: 02 Jan 2007, 11:13
Location: Proud to be owned by DMWSL613 Limited
FS Record: FISODAS season 21 Premiership champion

Re: FPL Fixtures and Results Grid 2015/16

Post by DrBunker »

RomynPG wrote:Back for another year - hopefully useful to some.
Maybe just one or two. ;)

OIEIAO
FISOhead
Posts: 981
Joined: 27 Aug 2014, 22:13

Re: FPL Fixtures and Results Grid 2015/16

Post by OIEIAO »

Excellent, many thanks.

User avatar
zdren
Kevin and Perry
Posts: 35
Joined: 26 Jul 2012, 07:40
Location: Zagreb

Re: FPL Fixtures and Results Grid 2015/16

Post by zdren »

Thanks!

Jason87
Treebeard
Posts: 221
Joined: 09 Nov 2009, 15:49

Re: FPL Fixtures and Results Grid 2015/16

Post by Jason87 »

Any chance getting this onto a google doc?
Sorry i know i asked before, i don't have Excel

Edit:
I've copied to google drive
https://docs.google.com/spreadsheets/d/ ... sp=sharing

How about this for a start?

User avatar
ManagerXI
Cheetah
Posts: 8
Joined: 06 Aug 2015, 14:42
FS Record: 2137

Re: FPL Fixtures and Results Grid 2015/16

Post by ManagerXI »

That is fantastic Romyn, thank you.

User avatar
gouldie7
Wideboy
Posts: 53
Joined: 08 Mar 2007, 19:53
Location: Doncaster

Re: FPL Fixtures and Results Grid 2015/16

Post by gouldie7 »

First time I've seen it, thanks!

Would love to know if it's ever been filled in with last years scores before? (Substitute promoted for relegated). Red win, yellow draw, blue lose for example.

I wish I could magic a free day to do it! Perhaps I may be able to look at this next year...

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »

gouldie7 wrote:Would love to know if it's ever been filled in with last years scores before? (Substitute promoted for relegated). Red win, yellow draw, blue lose for example.
There's a link to last years completed grid in the op - which has colour coding on the scores (helps highlight cleansheets etc), and a WLD column. Might be close to what you are after? - although you'd still need to cross reference.

Nice idea though - where available show data from last years fixture (faded in some way).

That however opens up a whole can of worms. My base spreadsheet is in Excel 2000 and pulls it's data from an Access database (which is where I update scores and recalc ranking etc). This is all in a web of FISO/FPL databases and spreadsheets I've built up over the years ...it's a nightmare :P . There have been many great suggestions for improvements but until I move to something sensible it's a bit stuck where it is :?

Maybe this year is the year I sort it out ... but don't hold your breath :wink:

User avatar
gouldie7
Wideboy
Posts: 53
Joined: 08 Mar 2007, 19:53
Location: Doncaster

Re: FPL Fixtures and Results Grid 2015/16

Post by gouldie7 »

Thanks Romyn - I'll do it if I remember...

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »

as at GW5

MCY start looks pretty...
mcygw5.png
You do not have the required permissions to view the files attached to this post.

pfc_ivan
Treebeard
Posts: 153
Joined: 30 Aug 2015, 19:29

Re: FPL Fixtures and Results Grid 2015/16

Post by pfc_ivan »

Hey All,

I am reading this excel file, but I am still not understanding fully how to get the most out of it. Can someone please explain.

I am getting the basic idea behind the color coding, but still unsure.

Thank you.

User avatar
DrBunker
FISO Knight
Posts: 19050
Joined: 02 Jan 2007, 11:13
Location: Proud to be owned by DMWSL613 Limited
FS Record: FISODAS season 21 Premiership champion

Re: FPL Fixtures and Results Grid 2015/16

Post by DrBunker »

What are you looking to get out of it Ivan? The colour coding key is at the top and is pretty straightforward. Use it to identify which teams have a (statistically) good run coming up when making player transfers.

pfc_ivan
Treebeard
Posts: 153
Joined: 30 Aug 2015, 19:29

Re: FPL Fixtures and Results Grid 2015/16

Post by pfc_ivan »

So, from what I understand colour coding is a function of two things:

1. Odds before the start of the season
2. Current results in the season (The more you move into the season, the results carry a bigger weight factor in comparison to odds before the start of the season. Am I understanding this portion correctly?)

Now, I was thinking the excel sheet might be "pro-active", so every time I insert a score of the game, a certain colour will show up, but it doesn't seem to be that way. So when you say this sheet can be used to see which teams have a good run coming up, I am looking for the red colours (Hot), correct? But these colours can change if a team starts losing game after game?

Thanks,

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »

pfc_ivan wrote:So, from what I understand colour coding is a function of two things:

1. Odds before the start of the season
2. Current results in the season (The more you move into the season, the results carry a bigger weight factor in comparison to odds before the start of the season. Am I understanding this portion correctly?)
pretty much ... the sheet called "calc method" gives a detailed example.
pfc_ivan wrote:Now, I was thinking the excel sheet might be "pro-active", so every time I insert a score of the game, a certain colour will show up, but it doesn't seem to be that way. So when you say this sheet can be used to see which teams have a good run coming up, I am looking for the red colours (Hot), correct? But these colours can change if a team starts losing game after game?

Thanks,
again that's pretty much it. The sheet has no code/formulas so isn't editable and the colours will change slightly as the season progresses.

I'd like to make it more interactive - enabling different rankings/calc methods - but that would have to be web-based rather than excel/access. Been trying to find time for that for years now :roll: - maybe I should have another look.

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
DrBunker
FISO Knight
Posts: 19050
Joined: 02 Jan 2007, 11:13
Location: Proud to be owned by DMWSL613 Limited
FS Record: FISODAS season 21 Premiership champion

Re: FPL Fixtures and Results Grid 2015/16

Post by DrBunker »

Thanks Romyn, good timing. :)

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »


pfc_ivan
Treebeard
Posts: 153
Joined: 30 Aug 2015, 19:29

Re: FPL Fixtures and Results Grid 2015/16

Post by pfc_ivan »

Hey RomynPG, thank you so much for this! I appreciate it :)

User avatar
RomynPG
Dumbledore
Posts: 9639
Joined: 13 Oct 2005, 18:32
FS Record: FPL 134 overall 06/07 ... never close since

Re: FPL Fixtures and Results Grid 2015/16

Post by RomynPG »

as at GW20

... sorry for the neglect ... I blame Jesus :wink:

View Latest: 1 Day View Your posts
Post Reply

Return to “Fantasy PremierLeague.com (FPL)”