Resource 2023 Provisional AFL Draft Order (updated live throughout the season)

[Lore]

See OP for details: click here

To embed this elsewhere on the forum please copy and paste the code below:

[MEDIA="googlespreadsheetnew"]12YGiwni9NZd5-KWuig45hRKGqvkjmlqml5rzjdrX2vQ[/MEDIA]

 

[Lore]

Draft Night Trade 3: Sydney and Hawthorn
Hawthorn get: #18
Sydney get: 27, future 2nd, future 3rd (both tied to Hawthorn according to Ethan's Landsberger tweet above)

 

[giantroo]

We received the Dees F3

 

[Lore]

it's been deleted.

Was Landsberger saying the two futures Hawthorn traded to Sydney were tied to the Hawks' own finishing position.

I wonder if it was wrong or if it had a typo and he wanted to repost it

 

[eth-dog]

it's been deleted.

Was Landsberger saying the two futures Hawthorn traded to Sydney were tied to the Hawks' own finishing position.

I wonder if it was wrong or if it had a typo and he wanted to repost it

Hawks twitter also saying it was theirs though.

 

[Stamos]

Fox Footy saying they are the Hawks' picks.

And then after all of that, Sydney struck a deal with Hawthorn, sending out pick 18 in exchange for pick 27 plus the Hawks’ future second and third-round picks.

That could be an incredible deal for the Swans, given most expect the Hawks to be a wooden spoon contender in 2023. Sydney may end up giving away 18, but getting roughly 20, 27 and 40 – which would be a huge return.

Cats’ ‘remarkable’ coup sounds warning; Brisbane bargain as trade gamble pays off: Talking Pts

Cats’ ‘remarkable’ coup sounds warning; Brisbane bargain as trade gamble pays off: Talking Pts

www.foxsports.com.au

 

[briztoon]

Hey Lore, there’s a mistake with the third round pick we traded to Hawthorn.

We traded the Bulldog’s future third round pick to Hawthorn.

So we should hold our own future third round pick and Gold Coast’s future third round pick.

 

[Lore]

Hey Lore, there’s a mistake with the third round pick we traded to Hawthorn.

We traded the Bulldog’s future third round pick to Hawthorn.

So we should hold our own future third round pick and Gold Coast’s future third round pick.

View attachment 1564237

Yeah that's the one that Hawthorn and Sam Landsberger both initially reported as being Brisbane's own pick.

I've taken notes for any assumptions I've made so we can double check it once this draft is over.

There's a couple that might be misplaced but you should have the right number of picks in each round which is the main thing for me currently.

 

[briztoon]

Yeah that's the one that Hawthorn and Sam Landsberger both initially reported as being Brisbane's own pick.

I've taken notes for any assumptions I've made so we can double check it once this draft is over.

There's a couple that might be misplaced but you should have the right number of picks in each round which is the main thing for me currently.

 

[Lore]

Carlton get: pick 30
Collingwood get: F2 (tied to Carlton)

Adelaide get: 43, F2 (tied to GWS/GC?) and F3 (tied to Gold Coast/Geelong)
Gold Coast get: 79, F2 (tied to Adelaide) and F3 (tied to Collingwood)

The F2 traded to Adelaide could be either GWS or GC's, depending on which one GC got from Brisbane in the trade period.

The F3 traded to Adelaide could be either Gold Coast or Geelong's. I assumed GC's own, but it's now confirmed as Geelong's by Adelaide, who later on-traded it (see above/below)

The F2 traded to Gold Coast had to be Adelaide's own, as it's the only one they had.

The F3 traded to Gold Coast must be tied to Collingwood as the only other one Gold Coast had came from Adelaide in the first place, and can't be traded back to them (unless it's been elsewhere first...)

Adelaide get: pick 50
Brisbane get: F3 (thought to be Gold Coast's, actually Geelong's)

Hawthorn get: pick 51
GWS get: F4 (tied to Bris)

Only one that Hawthorn has atm.

Hey Lore, there’s a mistake with the third round pick we traded to Hawthorn.

We traded the Bulldog’s future third round pick to Hawthorn.

So we should hold our own future third round pick and Gold Coast’s future third round pick.

View attachment 1564237

Now fixed with regard to these two issues ^

 

[Vindicater]

Geelong with the long wait next year between 1st and second picks at the moment.

 

[Pure_Ownage]

Geelong with the long wait next year between 1st and second picks at the moment.

Yep although no doubt we will have a couple of players leave via trade that will bring in picks in the 40s etc.

 

[Mofra]

I seem to have missed a trade or two, but how did Freo get St Kilda's 2023 first rounder?

 

[eth-dog]

I seem to have missed a trade or two, but how did Freo get St Kilda's 2023 first rounder?

They didn't

 

[Lore]

I seem to have missed a trade or two, but how did Freo get St Kilda's 2023 first rounder?

They didn't

did the gremlins get in again?

 

[Lore]

I think it's fixed for now, something happened with the ladder scrape and that led to cascading issues with traded picks. It should be right now, or as right as it was on the night of November 30, but let me know if there's anything that looks dodgy.

The two priority picks that were traded from North to Freo will probably break every time North's ladder position changes, and with it perhaps other issues with the 2nd and 3rd rounders that trade places with the priority picks. I will probably have to fix it manually each week...

 

[Vindicater]

You are an absolute champion Lore

 

[RedmanWasHere]

Just a thought.

Not sure if it's feasible but could an editable draft order work?


You'd do a ladder prediction and, whatever position you have the team on, the draft order adjusts accordingly.

 

[Lore]

Just a thought.

Not sure if it's feasible but could an editable draft order work?


You'd do a ladder prediction and, whatever position you have the team on, the draft order adjusts accordingly.

It’s extremely easy to do, I used to have a tab that was based on the squiggle’s predicted ladder, and I could really type anything into the ladder tab and the rest would update accordingly as long as the team names are spelled consistently.

Can’t really do it in a way that other people can type in their own ladder predictions though. Would have to build a website or something for it, which I don’t have the time or inclination to do, not to mention all the additional maintenance every time it breaks (the google sheet is a bit unreliable in an ordinary year, let alone with the moving targets that north’s trades priority picks create).

 

[RedmanWasHere]

It’s extremely easy to do, I used to have a tab that was based on the squiggle’s predicted ladder, and I could really type anything into the ladder tab and the rest would update accordingly as long as the team names are spelled consistently.

Can’t really do it in a way that other people can type in their own ladder predictions though. Would have to build a website or something for it, which I don’t have the time or inclination to do, not to mention all the additional maintenance every time it breaks (the google sheet is a bit unreliable in an ordinary year, let alone with the moving targets that north’s trades priority picks create).

Yeah that's all understandable, malleable and straightforward.

Just thought I'd suggest it as it was an idea needing to escape.