This is a members piece by Carl. He is a wiz with Excel and an excellent fantasy manager... a deadly combo that has seen him create a powerful Sky tool with a host of features that help Sky managers climb the ranks. Our contributors get a commission for their work, but Carl has very kindly offered to put any money he gets towards community competition prizes. If you haven't already signed up, and want part of your £2 membership fee to go towards community prizes. Please follow the link below (click on the restricted members image).
Damn Carl.. This gets better the more I use it. Nice work
Glad you like it. It should be updated after each game week and will be more useful as more data comes in.
Cheers Carl. My favourite is the prediction tool… will become even more powerful as the season goes on.
Hi Carl. Apologies if this is a stupid question but I’m just trying to work my way around the predictions and find out how best to use it to identify players for upcoming weeks. If for example I was looking specifically at Leicester for the upcoming Monday night game and beyond, is it just a simple case of selecting ‘LEI’ in N8, and then sort by ‘Pred tot’ in N13?
How many gameweeks does the predicted total (Column X) cover? eg Vardy 56.3
Also, the columns U-W are currently showing as GW4-6. Does this mean they are just reporting previous weeks data?
Again, I’m really sorry if this is pretty basic stuff that I’m asking but the formulas here are way above my knowledge of basic spreadsheet functions.
There is one more cell to change and that is AD2 and this is the GW you want to start from. Just type in the number 8 and it gives predictions for the next 3 weeks.
There are several draw-backs with that initial approach and I have built a new model just for the forecasting element which was in the article
https://fantasyfootballhub.co.uk/forecasting-model-fantasy-football/
I believe this will be more accurate, though it doesn’t include the points for playing (which you will know or better be able to estimate) or MotM
And there are no stupid questions. It is better to ask and be sure, than be stupid and stay silent doing the wrong thing.
Happy to discuss anything you wish.
Thanks Carl. Had used the forecasting model quite a bit but was trying to get a feel for both to see how they differ/correspond. It really is great work and gives further credence to your shift away from the 3 strikers article. Invaluable!!
[…] that have missed a game through injury or being rested etc. The chart below comes from the Sky toolkit that plots midfielders who have played at least 3 […]
[…] Sky fantasy football toolkit […]
[…] Sky fantasy football toolkit […]
[…] Sky fantasy football toolkit […]
[…] the last few months, I’ve started using Carl Week’s spreadsheet. Goodness, this thing is useful! Not only does it highlight captaincy blanks, but it also suggests […]
[…] see these stats and more view this Carl’s Sky Toolkit spreadsheet. You can also view his very clever prediction tool with integrated […]