FPL Fixtures and Results Grid 2017/18
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
FPL Fixtures and Results Grid 2017/18
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)
(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.
- 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:
Re: FPL Fixtures and Results Grid 2017/18
Thanks again for this.
Is there anywhere I can get an Excel dump of all of the player prices?
Is there anywhere I can get an Excel dump of all of the player prices?
- 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
Copy-paste fpl player-list into excel
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
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
- 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:
FPL Fixtures and Results Grid 2017/18
Nope, that's great thanks, I've managed to copy that from my phone into email and into excelMoSe wrote:Copy-paste fpl player-list into excel
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
(Can't access FPL at work, that's the issue)
-
- 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
Thanks man... looks cool and helpful at the same time
-
- FISOhead
- Posts: 697
- Joined: 28 May 2014, 16:28
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
This is great.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)
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!
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- fred1266
- Dumbledore
- Posts: 5353
- 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
- FPL:
- Contact:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
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.
- fred1266
- Dumbledore
- Posts: 5353
- 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
- FPL:
- Contact:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- 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.
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
I wonder, is there an easy way of displaying the grid as an image in the OP, 5AS modernisation stylee?
(Thanks for update)
(Thanks for update)
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
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 : )
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
as at GW28
Blanks for GW31 included - other postponed fixtures tba
@BenCrellin 's spreadsheet <-for better DGW planning
Blanks for GW31 included - other postponed fixtures tba
@BenCrellin 's spreadsheet <-for better DGW planning
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
Re: FPL Fixtures and Results Grid 2017/18
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
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
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
- RomynPG
- Dumbledore
- Posts: 9639
- Joined: 13 Oct 2005, 18:32
- FS Record: FPL 134 overall 06/07 ... never close since
- FPL:
View Latest: 1 Day View Your posts