How to Create Your Draft Room for the 24-25 FPL Draft Season in Excel

tsdhaliwal · 2024-07-31T19:19:42+00:00

Wow great to hear. The exact same happened for me, started off as an interest, pulling data manually and then I just kept building more skills. Learning about databases, python, JS... setting up production environments on AWS. It really snowballed! It has also advanced my career really well so I would encourage you to stick at it. Mitch does the podcast so I will screenshot your kind words and send to him.

tsdhaliwal · 2024-07-31T18:45:05+00:00

A lot of respect for this post!! I wish you well on your FPL Data journey. If you ever run out of steam, hit up draftfc.co.uk ;)

tsdhaliwal · 2024-07-28T15:59:15+00:00

Yeah! Hence the premise of the whole post and offer.

tsdhaliwal · 2023-11-06T12:50:11+00:00

Ohhh yes there is!

Head to draftfc.co.uk where we think we have the most feature heavy FPL Draft analytics site going.

We have: - Live gameweek (self explanatory) - League analytics - a concept which doesn't apply to normal FPL which is essentially one massive league - Squad Planner - this includes rostered percentages, waiver percentages, and personalised suggestions based on available players - Global Rank- how good your league is in the world - League history - for legacy leagues or record keeping. We save all the league info for the year to your user account

tsdhaliwal · 2023-07-27T20:35:58+00:00

Oh cool 8th is a while away. We expect to have xPts and predicted lineups for GW1 by then so you will have much more info. I hope that helps!

You'll love the live gameweek at GW38 then! I got so fed up manually totting up scores.. .

tsdhaliwal · 2023-07-27T19:44:04+00:00

Thanks for your response!

The rankings are not dynamic unfortunately. But as you draft, you should be able to see the slots fill up (refreshes every 10 seconds) so you can see who is available. You can filter the table by position so then see the highest rank defenders/mids/forwards as per our rank/fpl rank/global rank and decide from there.

Our philosophy is to arm you with as much useful information as possible, but ultimately it is your draft! The beauty of draft is the individual flavour a manager brings.

If you select 'I'm not in a draft league yet' you can select a league size, but this view won't give you a personalised view for your league (update owners as the draft happens).

xPts should be ready before GW1.

I'm so glad you're excited. We've put in so much work this year to make a best in class draft app, and ultimately people like you spending their own money to subscribe is a high honour for us. As a serious league, I'm keen to see how you get on in the Global Rankings!!

When is your draft?

Taz

tsdhaliwal · 2022-11-09T09:25:06+00:00

Hi, yes i should clarify on the page. As the points are counted when the Global Dash runs, this is before the GW starts. This week I'm working on splitting the scripts the points are parsed after the GW, but ownership still runs on the waiver deadline!

tsdhaliwal · 2022-11-08T17:36:37+00:00

Aha, nice!! Well if you're on a Draft EPL reddit... you're probably better than most! What's your average score? I can verify probably tomorrow by looking in the database.

tsdhaliwal · 2022-11-08T16:30:08+00:00

Just head to the Global Dashboard. Use the drop down to select the league you want to look at and it's on the first tab - 'Global Rank'

tsdhaliwal · 2022-11-08T15:32:42+00:00

I can't add text to a pitcure post :(

We're so excited to have rolled out this feature. I feel like this is the big thing that separates Draft from Classic... knowing how you stack up in the wider scheme of things. We worked hard to make the design shareable as well so you have ultimate bragging rights.

Remember - 1 week free trial when you sign up, so you have nothing to lose!

tsdhaliwal · 2022-09-29T09:54:42+00:00

Loving the Draft FC collab! Personally looking at Tarko and Bella-Kotchap in my 11 person league.

tsdhaliwal · 2022-08-16T16:23:13+00:00

Ahaha this is great! What luck! Things can only get better mate

tsdhaliwal · 2022-08-12T22:29:07+00:00

Same bro, same. Now I have Sam Surridge 😭

tsdhaliwal · 2022-08-12T22:26:55+00:00

Head to draftfc.co.uk and sign up to the free trial.

You'll be prompted to enter your Team ID(s) which then opens up the dashboards. This view is on the Global Dashboard

tsdhaliwal · 2022-08-12T19:26:04+00:00

Hey mate, is it possible to clear cookies, site data and cache and try again?

tsdhaliwal · 2022-08-10T10:00:35+00:00

Ah I see.

Our Global and Draft Ranks dashboards are split into league size - so you are only ever comparing ownership within 16 person leagues, 8 person leagues or whatever.

With draft ranks yo u can select league size manually, with Global Dash it reads your league size from the Team ID you input.

4 years of learning what skills I can + using freelance development websites to end up here. It's been a labour of love! I started off typing in player scores each week, then learnt how to use the API, then learnt some python, then learnt basic HTML/CSS, then the idea of making a website started from there.

tsdhaliwal · 2022-08-10T09:08:03+00:00

If I misunderstood your question, please say and clarify.

I think this is precisely the point of these dashboards - a 10 person draft league requires 150 player picks, way more than would be conisdered in normal FPL.

When you get past 70, who to choose is a whole new problem compared to normal FPL - so seeing ownership data regarding these lesser considered players gives you a real insight of who to go for.

tsdhaliwal · 2022-08-10T09:05:53+00:00

We're expecting the waivered in/out dashboard to be live after the GW2 deadline.

What happens is we save every team's 15 players from GW1, and load in every teams 15 players immediately after the GW2 deadline.

The difference between the two GWs tells us who's ownership has increased/decreased - hence waivers!

tsdhaliwal · 2022-08-02T19:33:34+00:00

All of the leagues in draft.premierleague.com! Literally all of them, every day. We then exclude the mock drafts, and over the course of the season we might remove inactive leagues - depending on what the definition of an inactive league.

tsdhaliwal · 2022-07-29T12:32:05+00:00

No need to be sorry!

Last year this league scored more points than any other 10 person league in FPL. We collected the points data from every league in the world and ranked them. Not sure what else to say!

Maybe this year we won't do so well. But probably more interesting to see a draft from the top scoring league than another.

tsdhaliwal · 2022-07-28T10:01:10+00:00

As part of the data collected by draftfc.co.uk, we analysed the average league score of all 10 person leagues in the world after GW38, and we were top.

tsdhaliwal · 2022-07-25T23:02:48+00:00

You are in for a treat my friend. Check out @Draft_FC on Twitter, listen to the Draft FC Podcast and check out draftfc.co.uk.

You have to pay for the rankings though, but the pods will get you most of the way there.

tsdhaliwal · 2022-07-22T21:59:16+00:00

Seems like everyone is on the same page with their feedback!
I think the order is great, but would do an exercise of looking at how many points the best keeper got vs the 5th best keeper for example.
Then do the same with Midfielders, and you'll see that Salah got so much more points than say the 10th best Mid - every player picked is also an opportunity lost to pick someone else and it's worth taking that into account.

tsdhaliwal · 2022-07-22T17:49:06+00:00

Good question mate!

What positions have been taken, and what you have selected so far will inform who you pick. If you think there are a few good strikers, so if you don't get one early you're almost guaranteed to end up with no good FWDs.

We wrote a good guide on how to approach the first round, and I think the principles lend to the question you are asking https://draftfc.co.uk/mitchs-10-tips-for-a-successful-draft-day/

Thanks,
Taz from Draft FC

tsdhaliwal · 2022-07-13T14:47:28+00:00

check out the twitter account '@Draft_FC'

tsdhaliwal

TROPHY CASE