Sticking with the Power theme, here are the Premier League Top scorers Power Query Sheet.
The Power Of The Premier League Strikers
-
MemphisFlash
- Posts: 2162
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
Nice, that'll work well with a vlookup on my footy sheet.MemphisFlash wrote: ↑Fri Oct 30, 2020 4:21 pmSticking with the Power theme, here are the Premier League Top scorers Power Query Sheet.
Premier League Top Strikers - Power Query.xlsx
Capture.JPG
-
paspuggie48
- Posts: 637
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
The possibilities are endless 
Thinking aloud here. Without knowing the quality of the data on a Fantasy Football site or other site, could you Power query it then do a VLOOKUP into it once the Actual team news is announced to compare the strengths of both teams playing on a position by position (roughly) basis.
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
You could create something similar to an XG model detailed to a player by player basis. Look at each forward's expected goal rate, each defenders clean sheet rate and such.
Paspuggie48 and MemphisFlash have certainly whisked up the forum recently with these sort of posts, love it!
Paspuggie48 and MemphisFlash have certainly whisked up the forum recently with these sort of posts, love it!
My thoughts exactly Callum, a few more categories might help too. XCS (Clean Sheets) XA (Assists) to give a Sum figure per player then Team Total v Team Total. Been mulling it over for a while but never been sure where/how to start it.