Comments

• 

  @Ian Parrin

  Sep 15 at 7:2AM

  Hope you guys find it useful, and if there are any queries just fire away.

  I do have the good fortune to be away this week, however holiday resort Internet is better than it used to be!

  

  @Will Thomas

  Sep 15 at 4:2PM

  Thanks Ian. Super useful resource for Sky managers

  

  @Mohamed Medani

  Jul 31 at 9:1AM

  This is super useful tool. What an effort !
  Just have small inquiry; how to update value in AP and Player by cost sheets ?

  

  @Ian Parrin

  Aug 1 at 1:3PM

  Glad you’re finding it useful Mohamed. I’ll be doing an update once the transfer window has closed, then regularly when fixtures change for TV and/or Europe.

  

  @Paul Heaton

  Jan 9 at 9:19AM

  Not really sure how to work it on my Mac. Been trying for the last couple of months

  

  @Will Thomas

  Jan 9 at 7:35PM

  Posted by: Paul Heaton

  Not really sure how to work it on my Mac. Been trying for the last couple of months

  Hi @horaceheatonjnr, I use this on my Mac. What are you struggling with exactly? Are you using excel?

  

  @djyoung9

  Jul 28 at 7:54PM

  Hi Ian could you possibly email this to me. Does not load for me on iPad. Just opens in web browser.

  

  @Snapper

  Jul 31 at 6:35PM

  Hi Ian, thanks for the planner. I cannot input the players in B14-24, any idea why?

• 

  @Hornet

  Sep 15 at 7:4AM

  Excellent resource again, Ian. Gets you organised and this is perfect for planning ahead. Transfer count always seems to drop too quickly though…..! Many thanks for your time and effort getting this together.

• 

  @Paul Jones

  Sep 15 at 3:43PM

  Love this toolkit, Ian. Was lucky enough to have access to it last year and it became increasingly essential as the season progressed. Made navigating that ridiculous TV schedule over the final weeks so much easier.

  Given how this year has started with the Friday and Monday night games, can see this being vital from the off for me so thanks for posting it.

• 

  @Dan Cox

  Sep 16 at 10:3PM

  Ian that is a fantastic bit of kit. very, very clever.

• 

  @Ian Parrin

  Sep 25 at 10:17PM

  Provisional attacking line-up for November 19th, having used only 6 transfers thus far to get there:

  Antonio (C)
  Salah
  Hazard
  Mkhitaryan

  Lacazette
  Kane
  Aguero

  Note: 2 players (Sanchez being one) will have already been transferred in/out from this front seven.

  Guesses to the other player (he hasn’t been in my side so far) in the the replies box :)

  

  @Hornet

  Oct 1 at 10:41AM

  Nice line-up and planning, Ian. Jesus now for Aguero, although his ribs might heal for a re-think by Nov 19th. I’m guessing Vardy is the in/out hokey-cokey man??!!

  

  @Ian Parrin

  Oct 1 at 11:39AM

  Spot on ?

• 

  @Hornet

  Oct 9 at 11:8PM

  Thanks for update, Ian. Lots to think about this week!

  

  @Ian Parrin

  Oct 9 at 11:41PM

  Plan It Sky – Octoberfest article out tomorrow Hornet. Hopefully some ideas to help you out!

  

  @Hornet

  Oct 18 at 9:23AM

  cheers….City players headache now…..rotation the main problem!

• 

  @Ian Parrin

  Oct 10 at 7:15PM

  Now looking at this front 8 on November 26th, having just used 5 transfers to get there:

  Richarlison
  Salah
  Hazard
  Mkhitaryan

  Sanchez A
  Kane
  Aguero

  Only 2 matches where I won’t have had an attacking captain in that period.

  Jamie Vardy is the player that will have been and gone.

  

  @Ian Parrin

  Oct 11 at 7:20PM

  Or this with 7, if Aguero and Pogba are back:

  Richarlison
  Salah
  Hazard
  de Bruyne
  Pogba

  Aguero
  Kane

• 

  @Henry Beadle

  Nov 23 at 7:47PM

  No chance of a Google Docs version of this?

• 

  @Ian Parrin

  Jan 17 at 9:16PM

  Hi everyone,

  Just to let you know that I will be doing the next update in a couple of weeks: after the transfer window has closed.

  The reason for the hiatus can now be explained: one of my sons had a double lung transplant on Christmas Eve (the best Christmas present anyone has ever had!) He is recovering well in hospital, with the medics seemingly extremely happy with his progress so far :)

  Hope all your #SkyFF 2018s have started as well as my personal new year!

  Cheers

  Ian

• 

  @Ian Parrin

  Feb 10 at 3:1PM

  Updated with new players and March fixtures :)

  

  @Will Thomas

  Feb 11 at 8:22AM

  Thanks Ian. Super useful as always

  

  @maccarfc

  Sep 3 at 10:2AM

  Hello Ian, would I be correct in thinking the spreadsheet only accessible through a laptop or pc? Just can’t seem to enter any data into cells using my phone?  Thanks. C

  

  @Ian Parrin

  Sep 3 at 9:11PM

  Good question C.
  As I only ever use excel on a laptop, I have no idea whether this has always been the case or whether it is something new? In the couple of years this spreadsheet has been around, it’s also the first time anyone has asked that question!
  I’ll see if I can find out and let you know.
  Cheers Ian

• 

  @Ian Parrin

  Mar 29 at 7:24PM

  Updated with April’s DGW and BGW fixtures.

• 

  @Ste H

  Jul 29 at 4:12PM

  This is quality

  

  @Ian Parrin

  Jul 29 at 7:54PM

  Cheers Ste, hope you find it useful :)

• 

  @chilli winter

  Jul 29 at 7:45PM

  Great spreadsheet, thank you, will you be updating after transfer deadline ? I see Richarlison is still a Watford player at mo.

  

  @Ian Parrin

  Jul 29 at 7:54PM

  Thanks CW,

  Yes will be updating after the window closes, and also when fixtures are moved for Europe and TV :)

• 

  @Barry

  Aug 2 at 2:35PM

  Hi Ian, what I’ve been told about this tool is one of the main reasons I’ve signed up here, thanks! Quick question, in your Kane AI24 example it says rows 28-32 should change automatically but the transfer remaining row (31) remained at 40. Is this a small glitch or just something that doesn’t kick in until the season starts?

  

  @Ian Parrin

  Aug 2 at 7:25PM

  Hi Barry,

  I think this must be a glitch. I will check over the weekend (as I’m off to Edgbaston tomorrow!) – and get back to you.

  Cheers

  Ian

  

  @Ian Parrin

  Aug 4 at 3:15PM

  Hi Barry,

  As I thought, just a glitch.

  I have now included an example and a download on the thread.

  I will be updating both when fixtures change for TV or Europe.

  Any questions let me know and good luck for the season :)

  Cheers

  Ian

• 

  @Benjamin Surman

  Aug 9 at 6:7PM

  Hi Ian, do you have a user guide to this great tool please?

  

  @Ian Parrin

  Aug 9 at 6:16PM

  Hi Benjamin, pretty much everything you need to do is explained in the introduction above, If you need help on anything particular, drop me a PM and I’ll help as much as possible :)

  

  @Benjamin Surman

  Aug 9 at 6:24PM

  All good Ian, thank you.

• 

  @wylecoyote

  Aug 10 at 8:53AM

  Hi Guys ,new to the site where can you download the guide ?
  Thanks ,

  

  @Will Thomas

  Aug 10 at 9:43AM

  Welcome to the site Wylecoyote. Which guide are you talking about?

  If you mean Ian’s planning sheet, it’s the link at the bottom of his post (you’ll need to be a paying member to view it).

  Cheers,

  Will

• 

  @Ian Parrin

  Aug 11 at 10:28AM

  Now updated after the August transfer window closed.

  

  @Will Thomas

  Aug 12 at 11:0AM

  Thanks Ian!

• 

  @Daznvern

  Aug 13 at 6:44PM

  Hi all.Im a new member. When theres a new update.  Do i just download it and put my current team in week 1 and amount of transfers left each time its updated.  

  

  @Ian Parrin

  Aug 13 at 7:14PM

  Hi Daz or Vern or both!

  When the spreadsheet is updated the instructions will be too. Trust me, all will be very clear when it happens

  Hope you’re finding it useful :)

  Cheers

  Ian

• 

  @Daznvern

  Aug 13 at 8:35PM

  Loving it thank you. 

• 

  @Hornet

  Aug 14 at 9:25PM

  Thanks again, Ian. Always try to get organised and start planning with this.

• 

  @gaz3376

  Aug 15 at 12:39PM

  This is great! Richarlison is down as Watford by the way.

  

  @Ian Parrin

  Aug 15 at 9:37PM

  Updated :)

• 

  @Mark Edworthy

  Aug 22 at 8:18PM

  I have decided to use this with earnest this season after using it lightly last season.. Have I got the wrong lin or is it still to be updated for theOctober fixtures?

  Already Overhaul planning see

  

  @Ian Parrin

  Aug 22 at 8:41PM

  I’ve done the basics already – just waiting to see if next week’s Champions League draw will mean further changes to the Matchday schedules.

  

  @Ian Parrin

  Sep 2 at 12:11PM

  All updated Mark :)

• 

  @Mooresyside

  Aug 25 at 8:51AM

  Hi guys is it to late to start using this spread sheet now?

  

  @Ian Parrin

  Aug 25 at 9:17AM

  You can start with it any time you like. If you’re planning to begin today, then put your team into cells AC14-AC21 and remaining transfers in AC31. Good luck  ? 

  

  @Mooresyside

  Aug 26 at 10:29AM

  Cheers, gonna give it a go from next week onwards. Poor weekend for everyone so far it looks like

  

  @Dan Cox

  Aug 30 at 1:56PM

  its never too late

• 

  @gaz3376

  Aug 27 at 12:6PM

  This is great! Richarlison is down as Watford by the way.

• 

  @Ian Parrin

  Aug 30 at 9:49PM

  Have done a quick change for the BUR v MNU fixture, and will be doing a full update when the Champions Leagues fixtures are announced.

• 

  @Will Thomas

  Sep 3 at 9:41PM

  Posted by: maccarfc

  Hello Ian, would I be correct in thinking the spreadsheet only accessible through a laptop or pc? 

  Just can’t seem to enter any data into cells using my phone? 

   

  Thanks. C

  Hi @maccarace9, you can access it if you get the Excel app. It’s not as easy to use as on PC, but still possible. Hope this helps ?

• 

  @TriXaM

  Sep 4 at 11:34AM

  Thanks for such a useful resource Ian, just started using it now ready for my post-overhaul team; along side Carl’s algorithm I feel like I stand a chance of recovering my awful position now! :lol: Just for info, while getting to grips with the spreadsheet, I noticed that Wolves fixture count isn’t counting down correctly on the “Fixtures” tab, they’re busy doing nothing on 38 fixtures for the rest of the season! :grin: Thanks again!

  

  @Ian Parrin

  Sep 4 at 9:18PM

  Thanks @trixam sorted now :smile:

• 

  @Ian Parrin

  Sep 4 at 7:47PM

  Hi @paulcaffrey5

  Once you click on the link it should download. You can then open it up in excel to input your team.

  Hope this helps :smile:

  Ian

• 

  @Will Thomas

  Sep 5 at 7:47PM

  Posted by: Paulcaffrey5

  Thanks Ian appreciate the help, would it be possible if you could reply to me a link so I can just click on it having trouble clicking the link sorry to be a pain

  Hi @paulcaffrey5, you can’t see the link as you’re no longer a member. Please resubscribe using the link on Ian’s post to gain access to his planner. Thanks, Will

• 

  @Will Thomas

  Sep 5 at 7:57PM

  No worries @paulcaffrey5. Be sure to use the link on Ian’s post to register as that will support him. Or use code PARRIN at checkout (this will also give you 24-hour free access) ? 

  

  @smclean

  Sep 5 at 8:10PM

  Thanks for putting all this together Ian. Big appreciation here.

• 

  @Oli Poole

  Sep 5 at 11:24PM

  Hi Ian, trying to open this in Google Drive as I don’t have Excel. It doesn’t want to open as it’s ‘too large’. Do you know any workarounds or alternatives, please? Many thanks!

  

  @Ian Parrin

  Sep 6 at 7:3PM

  Hi @olipoole I have trimmed away anything unnecessary and can now open the current link in Google Drive. Have a try and let me know how you get on? Cheers :smile:

  

  @Oli Poole

  Sep 7 at 11:2PM

  Works a treat! Many thanks :)

• 

  @Hornet

  Sep 6 at 9:10PM

  Hi IanWould you be able to update that Spurs/Man City fixture to the Monday night slot? cheers 

  

  @Ian Parrin

  Sep 6 at 9:31PM

  Done :smile:

  

  @chilli winter

  Nov 5 at 3:53PM

  Hi, thanks for this, not sure the January fixtures are right, but helpful up until then, cheers

• 

  @FPL Kangaroo

  Oct 19 at 11:38PM

  Hi Ian, thanks again for latest update but I have noticed a slight issue…it appears your COUNTIF & COUNTA formulas didn’t extend forward from Friday 7 December 2018 onwards at bottom of the Playing tab(i.e. the “Playing” tab – cells GA64 & GB64 etc).

  And I think you need to swap the NEW – WLV(Sat 8th Dec) fixture with the LEI-TOT(9th Dec 2018) match on the “Sky Transfer Plan” tab..

• 

  @Ian Parrin

  Nov 7 at 7:42PM

  All done  ? 

• 

  @jplewes

  Feb 4 at 12:9AM

  This is great. It’s a minor thing but  I noticed the orange highlights for players playing seem a bit messed up on this update?Still really useful! [attach]168[/attach]

  

  @Ian Parrin

  Feb 4 at 7:47PM

  I’m doing a transfer window and March fixtures update this week, so will take a look.

  

  @jplewes

  Feb 5 at 12:21PM

  Awesome – will be really useful for the overhaul. Thanks!

• 

  @Lee Giles

  Feb 7 at 7:50PM

  Does this work on a apple ipad? I can view it but can’t seem to add any info myself

  

  @Ian Parrin

  Feb 7 at 8:16PM

  As long as you access via the excel app it should. Not as easy as on a PC, but you’ll be able to get by.

• 

  @PalaceDean

  Jul 9 at 5:30PM

  Can’t seem to add Tielemans or Diogo Jota?

  

  @Ian Parrin

  Jul 9 at 7:19PM

  Hi @palacedean

  As described in the introduction – there is a Data Validation code on these cells to ensure that players are recognisable from the Alphabetical players tab.

  There are currently two players named Jota:
  Player Club Value Position
  Jota D WLV 9.0 MID
  Jota J AVL 7.8 MID
  So assuming you want the WLV man, then you’ll need to type Jota D

  Tielemans was not listed in the Sky game yesterday, so will be in my next update.

  Any further issues, just give me a shout.

  Cheers

  Ian

  

  @PalaceDean

  Jul 9 at 7:26PM

  Thank you for responding. I’m an idiot and read it completely wrong when reading through it all earlier. Will make sure I double read before asking and bothering you in future.

  Thanks again.

• 

  @djyoung9

  Jul 27 at 7:31AM

  Hi Ian is there anyway you can send this to me. It’s not letting me download to my ipad

  

  @Ian Parrin

  Jul 30 at 6:46PM

  Have sent you an email :)

• 

  @sjfordham

  Jul 31 at 8:57AM

  I can’t seem to get the drop down box for the players to open up. Any ideas?

  

  @Ian Parrin

  Jul 31 at 12:46PM

  I’ll have a look this evening.

  

  @joels188

  Jul 31 at 5:21PM

  I have the same issue but only for the first 4 GWs. I have to copy and paste the name of the player I want from one of the lists. When I type the name the data validation message pops up. Nothing major, still pretty easy to use

• 

  @smclean

  Jul 31 at 6:7PM

  Worth a thank you every season. Great work.