Resource 2017 AFL Draft Order

[Pykie]

Hawks win, unhappy Saints slip out to 3rd pick. Could Swans snaffle pick 1???? they are playing horribly.

Hawthorn are above Carlton now, #4 actually.

 

[Lore]

Round 5:

 

[goodie23]

Never would've picked Sydney to be holding pick 1 after 5 rounds. Great job

 

[Lace_Out]

Why is GWS at 15, don't they have the hawks 1st rdr?

Sent from my SM-G935F using Tapatalk

 

[teagueyubeauty]

Saints have that

 

[Lore]

You can check the second tab of the spreadsheet ('Draft order') to find out who originally had the pick and who has it now.

 

[Freomaniac]

If Squiggle is right they'll enter the trade period with their first pick at 34. Although I wouldn't want to be any of the teams that lack a first rounder :/

going to be an interesting ladder . happy for this to be updated weekly

 

[Lore]

Round 6:

 

[HBF]

Hawthorn are in a whole lot of trouble. They simply have to trade back into the first round if they can.

 

[TerryWallet]

Thanks for the graphs Fly.

 

[dewah07]

bring on a swans win this week will make the graphic even more lolworthy

 

[Lore]

Round 7:



Note: The bold/not bold for whether those are your original picks are done manually, and might be wrong as picks move around week to week. Don't think it's particularly important at this stage anyway and once the ladder settles a bit more I'll fix it up. The one that was mostly the problem was Richmond's two third rounders kept swapping places, one is originally theirs and the other obviously isn't. Similar things probably with Gold Coast's many second round picks.

 

[briztoon]

Round 7:

View attachment 368084

Note: The bold/not bold for whether those are your original picks are done manually, and might be wrong as picks move around week to week. Don't think it's particularly important at this stage anyway and once the ladder settles a bit more I'll fix it up. The one that was mostly the problem was Richmond's two third rounders kept swapping places, one is originally theirs and the other obviously isn't. Similar things probably with Gold Coast's many second round picks.

Woohoo we're winning the draft.

 

[luthor]

Woohoo we're winning the draft.

Maybe so but the thread needs more Port death-riding

 

[Lore]

Round 8:

 

[DrMike]

Note: The bold/not bold for whether those are your original picks are done manually, and might be wrong as picks move around week to week. Don't think it's particularly important at this stage anyway and once the ladder settles a bit more I'll fix it up. The one that was mostly the problem was Richmond's two third rounders kept swapping places, one is originally theirs and the other obviously isn't. Similar things probably with Gold Coast's many second round picks.

Something like this should work as a Conditional Formatting Rule:

=AND(VLOOKUP(PicksTab!$TeamColumn,DraftOrderTab!$PickRange,2,FALSE)=PicksTab!$TeamColumn,VLOOKUP($TeamColumn,DraftOrderTab!$PickRange,3,FALSE)=PicksTab!$TeamColumn)

Hope that makes sense. Probably an easier way to do it.

 

[Lore]

Something like this should work as a Conditional Formatting Rule:

=AND(VLOOKUP(PicksTab!$TeamColumn,DraftOrderTab!$PickRange,2,FALSE)=PicksTab!$TeamColumn,VLOOKUP($TeamColumn,DraftOrderTab!$PickRange,3,FALSE)=PicksTab!$TeamColumn)

Hope that makes sense. Probably an easier way to do it.

Yeah makes sense. I might look into it, it's not really difficult to do manually though, but I guess the more future trading we get the more complicated this will be in future years. Thanks!

 

[BEaston]

Since most picks are never traded would it make more sense to have the traded picks in bold rather than the other way around? Would make it easier to see those ones.

 

[Lore]

Since most picks are never traded would it make more sense to have the traded picks in bold rather than the other way around? Would make it easier to see those ones.

Good thought.

 

[BEaston]

Another thing I was thinking that could be cool is auto ranking the list on the right side, would give a quick reference to a "draft ladder". Up to you though!

 

[Lore]

Another thing I was thinking that could be cool is auto ranking the list on the right side, would give a quick reference to a "draft ladder". Up to you though!

That's a rabbit hole I probably won't go down, as it involves macros and things and would probably break googlesheets (if it doesn't break me first!) I can do a manual sort before I screenshot it each week though, I doubt it changes too much.

DrMike I'm working on your suggestion but so far no luck. Conditional formatting is finicky at the best of times and it doesn't seem to like VLOOKUPs I did get it to automatically bold the traded picks in the draft order tab though, that only took two seconds compared to the time I've spent messing around with the picks and points sheet so far! hahaha

 

[Lore]

AH-HA! DrMike Finally got the traded picks to automatically bold themselves, they should be perpetually accurate now!

Round 8 (reposted, with clubs ranked on the right hand side according to their draft points, and a few tweaks to formatting):

 

[goodie23]

Fantastic update

 

[Lore]

Fantastic update

Happy to keep changing stuff around if you or anyone else have any other suggestions too

 

[DrMike]

AH-HA! DrMike Finally got the traded picks to automatically bold themselves, they should be perpetually accurate now!

Needed to put $'s against all the ranges?