Sticking with the Power theme, here are the Premier League Top scorers Power Query Sheet.
The Power Of The Premier League Strikers
-
MemphisFlash
- Posts: 2335
- Joined: Fri May 16, 2014 10:12 pm
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
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
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!