Ian Parrin's Sky Sports Fantasy Football Planning Spreadsheet - December and January Fixture Update  

Page 2 / 3 Prev Next
  RSS

Mohamed Medani
(@willer)
New Member
Joined: 10 months  ago
Posts: 1
31/07/2018 9:01 am  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
01/08/2018 1:03 pm  

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.


ReplyQuote
Barry
(@str8outtabrompton)
New Member
Joined: 1 year  ago
Posts: 2
02/08/2018 2:35 pm  

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?


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
02/08/2018 7:25 pm  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
04/08/2018 3:15 pm  

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


ReplyQuote
Benjamin Surman
(@surman32)
Active Member
Joined: 1 year  ago
Posts: 3
09/08/2018 6:07 pm  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
09/08/2018 6:16 pm  

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 :)


ReplyQuote
Benjamin Surman
(@surman32)
Active Member
Joined: 1 year  ago
Posts: 3
09/08/2018 6:24 pm  

All good Ian, thank you.


ReplyQuote
wylecoyote
(@wylecoyote)
New Member
Joined: 3 months  ago
Posts: 1
10/08/2018 8:53 am  

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


ReplyQuote
Will Thomas
(@ffhwill)
Founder Admin
Joined: 1 year  ago
Posts: 277
10/08/2018 9:43 am  

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

I built a website to justify my addiction.


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
11/08/2018 10:28 am  

Now updated after the August transfer window closed.


Hornet liked
ReplyQuote
Will Thomas
(@ffhwill)
Founder Admin
Joined: 1 year  ago
Posts: 277
12/08/2018 11:00 am  

Thanks Ian!

I built a website to justify my addiction.


ReplyQuote
Daznvern
(@daznvern)
Eminent Member
Joined: 3 months  ago
Posts: 10
13/08/2018 6:44 pm  

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. 

 


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
13/08/2018 7:14 pm  

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


ReplyQuote
Daznvern
(@daznvern)
Eminent Member
Joined: 3 months  ago
Posts: 10
13/08/2018 8:35 pm  

Loving it thank you. 


ReplyQuote
Hornet
(@hornet)
Eminent Member
Joined: 4 months  ago
Posts: 17
14/08/2018 9:25 pm  

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


ReplyQuote
gaz3376
(@gaz3376)
Trusted Member
Joined: 3 months  ago
Posts: 22
15/08/2018 12:39 pm  

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


ReplyQuote
gaz3376
(@gaz3376)
Trusted Member
Joined: 3 months  ago
Posts: 22
15/08/2018 12:39 pm  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
15/08/2018 9:37 pm  

Updated :)


ReplyQuote
Mark Edworthy
(@buffrey)
Active Member
Joined: 1 year  ago
Posts: 3
22/08/2018 8:18 pm  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
22/08/2018 8:41 pm  

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.


ReplyQuote
Mooresyside
(@mooresyside)
Trusted Member
Joined: 3 months  ago
Posts: 22
25/08/2018 8:51 am  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
25/08/2018 9:17 am  

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  👍 


ReplyQuote
Mooresyside
(@mooresyside)
Trusted Member
Joined: 3 months  ago
Posts: 22
26/08/2018 10:29 am  

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


ReplyQuote
Dan Cox
(@animal)
Member Moderator
Joined: 1 year  ago
Posts: 66
30/08/2018 1:56 pm  

its never too late


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
30/08/2018 9:49 pm  

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.


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
02/09/2018 12:11 pm  

All updated Mark :)


ReplyQuote
maccarfc
(@maccarfc)
New Member
Joined: 3 months  ago
Posts: 1
03/09/2018 10:02 am  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
03/09/2018 9:11 pm  

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


ReplyQuote
Will Thomas
(@ffhwill)
Founder Admin
Joined: 1 year  ago
Posts: 277
03/09/2018 9:41 pm  
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 👍

I built a website to justify my addiction.


ReplyQuote
TriXaM
(@trixam)
Active Member
Joined: 3 months  ago
Posts: 6
04/09/2018 11:34 am  

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!


ReplyQuote
Paulcaffrey5
(@paulcaffrey5)
Eminent Member
Joined: 4 months  ago
Posts: 14
04/09/2018 1:35 pm  

How do I acces it having trouble getting on the link


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
04/09/2018 7:47 pm  

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


ReplyQuote
Ian Parrin
(@ianp1970)
Member Moderator
Joined: 1 year  ago
Posts: 118
04/09/2018 9:18 pm  

Thanks @trixam sorted now :smile:


ReplyQuote
Paulcaffrey5
(@paulcaffrey5)
Eminent Member
Joined: 4 months  ago
Posts: 14
05/09/2018 4:38 pm  

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


ReplyQuote
Will Thomas
(@ffhwill)
Founder Admin
Joined: 1 year  ago
Posts: 277
05/09/2018 7:47 pm  
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

I built a website to justify my addiction.


ReplyQuote
Paulcaffrey5
(@paulcaffrey5)
Eminent Member
Joined: 4 months  ago
Posts: 14
05/09/2018 7:51 pm  

Had a new card sent out haven’t i only just relaised all done cheers will, il try again 🤞🏼


ReplyQuote
Will Thomas
(@ffhwill)
Founder Admin
Joined: 1 year  ago
Posts: 277
05/09/2018 7:57 pm  

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) 👍 

I built a website to justify my addiction.


ReplyQuote
SM
 SM
(@sm)
Eminent Member
Joined: 4 months  ago
Posts: 10
05/09/2018 8:10 pm  

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


ReplyQuote
olipoole
(@olipoole)
Trusted Member
Joined: 3 months  ago
Posts: 28
05/09/2018 11:24 pm  

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!


ReplyQuote
Page 2 / 3 Prev Next
Share: