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

FPL Fixtures and Results Grid 2017/18

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 2017/18

Post by RomynPG »

Back again - hopefully useful to some.

(on Google Drive)

Last years complete FPL_FixturesResults_2016_17_complete.xls


201718 - as at GW38- complete (14/05/18)


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

Initial Team Rankings based on odds at Odds-Checker (14/06/17) 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 14 May 2018, 16:39, edited 18 times in total.

User avatar
jacksosi
Grumpy Old Man
Posts: 4669
Joined: 13 Oct 2005, 18:28
FS Record: TFF : 87th 06/07 ; FPL 1401st 08/09 ; 5AS champions 21/22 🔫🍸

Re: FPL Fixtures and Results Grid 2017/18

Post by jacksosi »

Thanks again for this.

Is there anywhere I can get an Excel dump of all of the player prices?

User avatar
MoSe
Dumbledore
Posts: 9550
Joined: 10 Sep 2014, 12:25
Location: next door S.Siro stadium
FS Record: FISODAS CUP Winner Season 25
FISO H2H Winner: 15/16 Div2 - 16/17 Div1
FISO Mirror: 16/17 PL Winner

Re: FPL Fixtures and Results Grid 2017/18

Post by MoSe »

Copy-paste fpl player-list into excel :mrgreen:
https://fantasy.premierleague.com/player-list/
I'll do it sometimes for sure, can't promise when tho.
Monday, if I can carve time in work-pauses, can't promise

User avatar
jacksosi
Grumpy Old Man
Posts: 4669
Joined: 13 Oct 2005, 18:28
FS Record: TFF : 87th 06/07 ; FPL 1401st 08/09 ; 5AS champions 21/22 🔫🍸

FPL Fixtures and Results Grid 2017/18

Post by jacksosi »

MoSe wrote:Copy-paste fpl player-list into excel :mrgreen:
https://fantasy.premierleague.com/player-list/
I'll do it sometimes for sure, can't promise when tho.
Monday, if I can carve time in work-pauses, can't promise
Nope, that's great thanks, I've managed to copy that from my phone into email and into excel Image

(Can't access FPL at work, that's the issue)

rohitpotter
Kevin and Perry
Posts: 20
Joined: 17 Jul 2017, 21:51
FS Record: https://fantasy.premierleague.com/a/entry/698/history

Re: FPL Fixtures and Results Grid 2017/18

Post by rohitpotter »

Thanks man... looks cool and helpful at the same time :)

abuhaneefah
FISOhead
Posts: 697
Joined: 28 May 2014, 16:28

Re: FPL Fixtures and Results Grid 2017/18

Post by abuhaneefah »

RomynPG wrote: 14 Jun 2017, 15:25 Back again - hopefully useful to some.

(on Google Drive)

Last years complete FPL_FixturesResults_2016_17_complete.xls


201718 PROVISIONAL - as at now (14/06/17)


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

Initial Team Rankings based on odds at Odds-Checker (14/06/17) 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)
This is great.

At a glance you can see that the Manchester teams & Southampton are probably the best teams to start with if you are planning an early wildcard.

Might have to re-jig my team now.
I have only 1 Man Utd player!

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 2017/18

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 2017/18

Post by RomynPG »


User avatar
fred1266
Dumbledore
Posts: 5354
Joined: 16 Mar 2012, 22:56
Location: Trinidad
FS Record: EFCL Fantasy League & Jurassic League Winner 11/12, EFCL Fantasy League Winner 13/14. EFCL, FISO 5AS The Kangals, Jurassic League, 3DM PRINTERS TT & Trini Gunners Winner 14/15
Contact:

Re: FPL Fixtures and Results Grid 2017/18

Post by fred1266 »

RomynPG wrote: 18 Sep 2017, 13:18 As at GW5
hi rom you mind explaining to me how this works i never really understood 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 2017/18

Post by RomynPG »

fred1266 wrote: 18 Sep 2017, 15:55
RomynPG wrote: 18 Sep 2017, 13:18 As at GW5
hi rom you mind explaining to me how this works i never really understood it
Not much to it really.

It's a single main sheet - formatted to print on a single page - that lists all fixtures and results when available - colour coded for levels of hot/cold based on a simple team ranking formula (explained in additional sheet)

There's not calculations or anything - just a simple reference to highlight good/bad upcoming runs, clean sheets etc. When blanks/dbls come in to play it highlights those also.

User avatar
fred1266
Dumbledore
Posts: 5354
Joined: 16 Mar 2012, 22:56
Location: Trinidad
FS Record: EFCL Fantasy League & Jurassic League Winner 11/12, EFCL Fantasy League Winner 13/14. EFCL, FISO 5AS The Kangals, Jurassic League, 3DM PRINTERS TT & Trini Gunners Winner 14/15
Contact:

Re: FPL Fixtures and Results Grid 2017/18

Post by fred1266 »

ok 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 2017/18

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 2017/18

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 2017/18

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 2017/18

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 2017/18

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 2017/18

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 2017/18

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 2017/18

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 2017/18

Post by RomynPG »

as at GW15

(inc TOT & WHM unexpected dbl-gws)

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 2017/18

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 2017/18

Post by RomynPG »


User avatar
Stemania
FISO Jedi Knight
Posts: 20448
Joined: 27 Aug 2006, 11:54
Location: On the Iron Throne of xG, the seat of The Crown Prince of the Stat Perverts. Or if not, in the STC!
FS Record: Best: TFF 321st. FPL 129th. FFS Career HoF Peak 2nd (Live 1st). Ability since lost.

Re: FPL Fixtures and Results Grid 2017/18

Post by Stemania »

I wonder, is there an easy way of displaying the grid as an image in the OP, 5AS modernisation stylee?

(Thanks for update)

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 2017/18

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 2017/18

Post by RomynPG »

Stemania wrote: 11 Jan 2018, 21:50 I wonder, is there an easy way of displaying the grid as an image in the OP, 5AS modernisation stylee?
With difficulty as it currently stands however...

I mentioned a few times over the last couple of years my hope of moving my ancient sidegame admin to the web - from the XP based Excel/Access 2000 legacy system it is currently on.

In the end it still hinges on how the sidegame is presented and I'm a fan of the sidegame threads being the focus - I like to display updates within the thread rather than link off-site. For me now that means image screenshots and, for LiveScore, heavy bbCode with links to Sharagozs live offsite pages.

Even if I did move all my admin onto the web I'd still be stuck between linking to offsite pages or posting screenshots - which makes the whole thing a bit pointless.

What would a seriously useful feature to add to FISOs phpBB setup - for sidegames and a miriad of other things - would be a custom bbCode, along the lines of the youTube code, that would iFrame embed a page from a trusted source.

Let's say the 5AS H2H was hosted online and presented game data, in the first instance, as simple HTML/CSS views - for example the current League Table was at myfplsidegames.com/games/5ash2h/201718/23/leaguetable.html it could be posted as

[newBBCode]sourceRomyn/5ash2h/201718/23/leaguetable[/newBBCode]

... the new bbCode would build the iframe src by parsing the input, looking up the source url, (sourceRomyn=myfplsidegames.com/games/), and build the rest of the url. (Personally I'm used to param based urls /endpoint.php?x=y&a=b etc rather than RESTful - but the principle is the same)

On my end I would be ensuring my end-points looked good and were device responsive. Simple HTML/CSS would be ample for most cases but no reason why the embeds couldn't be more interesting - for those wanting to go further.

It doesn't take much imagination to see how useful it could be - sidegames, stats, fixture grids etc - I suspect I'm not the only one would who make the effort.

Build it and they will come : )

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 2017/18

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 2017/18

Post by RomynPG »

as at GW28

Blanks for GW31 included - other postponed fixtures tba


@BenCrellin 's spreadsheet <-for better DGW planning

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 2017/18

Post by RomynPG »

as at GW31

Rescheduled fixtures updated.

There are 2 sheets - one with just the confirmed fixtures with 6 still TBA - and a second with the likely schedule of those 6 in GW37. File should open on the second one (likely) but other is there for the record etc

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 2017/18

Post by RomynPG »

as at GW32

Currently unscheduled fixtures assumed to be in GW37.

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 2017/18

Post by RomynPG »


View Latest: 1 Day View Your posts
Post Reply

Return to “Fantasy PremierLeague.com (FPL)”