FPL Fixtures and Results Grid 2014/15

[RomynPG]

Back for another year - not as prompt as previous years - oh my old bones - hopefully useful to some.

Latest Copy: as at GW35
(edited 07/05/2015)

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 (11/08/14) 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)

[jeffmcgow]

Great work, RomynPG! Just what I was looking for.

I'm discovering all manner of good things in this FPL forum.

[Mav3rick]

Nice work RomynPG, this will be used thanks!

[HungryHungrySuarez]

Hi

I was looking for this, great timing thanks lol!

Just a quick question and feel free to tell me to PO obviously, but would it be possible to stick it up on Google Docs also? that way when there's an update it'll not necessitate everyone downloading a new file (unless they really want a local copy) - it'll just update the version they have bookmarked / linked. (plus it would be more accessible to those without excel )


Love the work and i find the grid *really* useful so many thanks.

[Ralfbergs]

Thanks RomynPG, was really waiting for this !

[DrBunker]

Hi

I was looking for this, great timing thanks lol!

Just a quick question and feel free to tell me to PO obviously, but would it be possible to stick it up on Google Docs also? that way when there's an update it'll not necessitate everyone downloading a new file (unless they really want a local copy) - it'll just update the version they have bookmarked / linked. (plus it would be more accessible to those without excel )


Love the work and i find the grid *really* useful so many thanks.

I could be wrong but I don't think the conditional formatting functionality of Google docs is good enough to match those available on Excel.

[Surprised]

Nice work and thanks for sharing.
Would it be possible to also show the rating on each of the fixtures rather than just the colour?

[Moist von Lipwig]

would it be possible to sticky this thread, or add it to the what you need to know etc one.

I can never bloody find this when I need it.

[travatron]

would it be possible to sticky this thread, or add it to the what you need to know etc one.

I can never bloody find this when I need it.

tip: save it to your desktop.

[DrBunker]

would it be possible to sticky this thread, or add it to the what you need to know etc one.

I can never bloody find this when I need it.

And as if by magic...

[SuperGrover]

Thank you much. Saved much a boat load of time.

FWIW, I have utilized this as a base and made a simple 20 x 38 matrix (with a header row and column) with just team name and "@" is on the road. I am happy to share that to anyone who needs it for any fancy Excel tricks.

[gibbo42]

RomynPG - thanks very much for sharing, always interesting to compare this to personal opinions / rankings.

One question (apologies if this has been asked in previous years) - is this the actual colour allocation manual or formula driven? If the latter, any chance you'd mind sharing ... thought being that it would be great to be able to play with those rankings based on opinion & see the changes driven straight into the chart.

If not, will have a play & see if I can put something on here.

Also curious if yourself and/or others have played with the home/away weighting for specific clubs, e.g. Crystal Palace, Stoke, and impact on the chart, and any challenges faced in doing so?

[DrBunker]

The second tab of the spreadsheet should answer most of your questions I think.

[gibbo42]

The second tab of the spreadsheet should answer most of your questions I think.

- Understand that this covers the calculation method - what I was actually wondering was whether RomynPG had then created the formula to create this difference rating by selecting the relevant team cross-reference & perhaps applied conditional formatting on the result to create colours ... if so, was hoping to leverage this existing back-end work rather than doing myself!

Interesting in creating something that will give live, *pretty* colour changes if you play with the back-end rankings table, to then update into a formula & then conditional formatting (or other) in the front-end graph.

Have a week to myself with the wife & monkey away soon, and working out how much time I can justifiably invest in spreadsheet fun ...

[Sutter Kane]

Have a week to myself with the wife & monkey away soon, and working out how much time I can justifiably invest in spreadsheet fun ...

110-130 hours seems reasonable enough to allow for sleep, etc.

Nice work RomynPG.

[RidleyMTB]

Thanks RoymnPG

[RomynPG]

as at GW1

[buckers]

Great bit of spreadsheet work.

+1 for a Google Drive though

[jacksosi]

Thanks for doing this and sharing it, saves me a lot of work.

I also just use it for the raw data, and then have gone off into my own world of formulae and conditional formatting, several hours wasted so far

[RomynPG]

as at GW3

.. will look at something like Google Drive when I have time.

[KingCabbage]

Nice work.

Just as an Excel tip, if you're like me and you prefer to have the team on the left, with that team's fixtures running along a row (as opposed to down each column), you can copy all the cells > paste > transpose and it'll flip it around so that the teams are down column A and that team's fixtures run along rows.

[RomynPG]

as at GW4

[RomynPG]

as at GW5

[RomynPG]

as at GW8

[RomynPG]

as at GW10

[RomynPG]

as at GW11

[RomynPG]

as at GW16

[RomynPG]

as at GW20

[Robin Write]

Thanks a bunch.

[RomynPG]

as at GW22