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

FPL Fixtures and Results Grid 2014/15

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

Re: FPL Fixtures and Results Grid 2014/15

Post by RomynPG »


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

Re: FPL Fixtures and Results Grid 2014/15

Post by OIEIAO »

This is excellent, many 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 2014/15

Post by RomynPG »


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

Re: FPL Fixtures and Results Grid 2014/15

Post by Jason87 »

Any chance of moving this to Google Drive?
Not everyone has MS office and it will save you uploading a new spreadsheet each time you make an edit!

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 2014/15

Post by DrBunker »

It's been suggested before but the sheet is too complicated even for the excellent Google Drive.

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 2014/15

Post by RomynPG »


Biscuitman
FISOhead
Posts: 808
Joined: 20 Apr 2007, 21:41
FS Record: 10th TFFO 2009/10

Re: FPL Fixtures and Results Grid 2014/15

Post by Biscuitman »

RomynPG wrote:as at GW31
Thank you, very useful.

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 2014/15

Post by DrBunker »

Perfect timing, thanks again.

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

Re: FPL Fixtures and Results Grid 2014/15

Post by Jason87 »

DrBunker wrote:It's been suggested before but the sheet is too complicated even for the excellent Google Drive.
It doesn't look that complicated, I'm sure i could convert this for you in an hour

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 2014/15

Post by DrBunker »

Romyn has said he'll look into it when he has the time (viewtopic.php?f=18&t=111031&p=2572484&h ... e#p2572484) but my money's on the conditional formatting being the issue...

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 2014/15

Post by RomynPG »

as at GW35


It should be possible to convert to a different format. The sheet I post is a paste from another sheet - values and formats only. You should be able to delete all the hidden columns and the sheet will still look the same. There are no formulas, references or code. (My source sheet doesn't have any conditional formatting as my version of excel, 2000 :), only allows 3 conditions and I needed 5 so I do my formatting from vba code)

Now that DataCo have lost that European case and publishing fixture lists doesn't send you to the gulag I need to do this on the web rather than offline in excel ... but that's for another day at the moment.

User avatar
chandler
Grumpy Old Man
Posts: 2236
Joined: 06 Aug 2010, 22:12
Contact:

Re: FPL Fixtures and Results Grid 2014/15

Post by chandler »

Hello RomynPG, this was so useful last season I was wondering if you are drawing it up again for the new season? I've been trying to find something similar but with no success.

Edit - just found it!

Biscuitman
FISOhead
Posts: 808
Joined: 20 Apr 2007, 21:41
FS Record: 10th TFFO 2009/10

Re: FPL Fixtures and Results Grid 2014/15

Post by Biscuitman »

chandler wrote:Hello RomynPG, this was so useful last season I was wondering if you are drawing it up again for the new season? I've been trying to find something similar but with no success.

Edit - just found it!
I'm still looking: where is it, please? Agreed, a very useful sheet.

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 2014/15

Post by Mav3rick »

This what you're after?

viewtopic.php?f=18&t=116559

View Latest: 1 Day View Your posts
Locked

Return to “Fantasy PremierLeague.com (FPL)”