Competitions Lock and Load Comp - III (2020)

[Ironhawk]

Which one of IronHawk and Ironhawk is @Ironhawk ?

Add both together and I might be a chance!

 

[Beijing_Sting]

Getting there ;-)
Thanks Bermi for another error find! I think it will get much smoother once the initial bumps are ironed out.

 

[Beijing_Sting]

 

[Beijing_Sting]

I understand that the Bye round is superfluous at this stage, but this is just the initial data gathering. Plenty of time to work on format etc. Keep an eye out for my mistakes. Sadly no bonus points for when you spot them.

Cheers

 

[Bermi]

Just a very quick look at the teams, looks like I have 1 POD, Jack Steele.

 

[Beijing_Sting]

Here are the players we selected:





I think once we get settled in, someone (or the internet) can show me how to count from an array and we can investigate more on who selected what etc. Also - if there are any Excel Guru out there, I am happy to share the teams excel from in PM so that you can have some fun with it for us all. I really liked the spreadsheet from last year that displayed everyone's picks. Might try to replicate it later this weekend. For now, I am just relieved that the data entry is going smoothly (ish)

 

[Herbie66]

Here are the players we sleected:

View attachment 17888
View attachment 17889
View attachment 17890

damn I was keen on Harrison Pepper (Hawthorn) but couldn't find him in the list ?

great work organising this and providing all the teams so quickly

Cheers

 

[Beijing_Sting]

Very likely - I have some errors here: Fascinating how much you can do (and destroy) with excel and how little I really know:

 

[Beijing_Sting]

 

[Beijing_Sting]

 

[Beijing_Sting]

 

[Beijing_Sting]

So... I have the least unique team? No surprise considering I probably have the least understanding of the game considering my non-AFL background. Also, data could be wrong, Figuring out, all it takes is one extra letter and everything goes pearshaped pretty quickly. But it was fun learning how to do it and put it together.

Cheers

 

[Ironhawk]

No unique selections is a good sign in a way. Not surprised though, thought I wouldn't risk any "out there" choices and played it fairly safe.

Good job putting this together so quickly, and good luck everyone.

 

[Beijing_Sting]

I think this is correct - an update using applied ranking data. Used the date of entry as the decider on rank. Almot 100% sure that this won't be needed moving forward.

 

[Tails]

So keeping with the same format as last year here is my initial take on which teams have recruited what players ...

Serves multiple purposes for me ...
- I get an insight into various coaches thoughts whilst putting it together ...
- It is mostly automated so takes little time to update each week ...
- Gives everyone an idea of who are their respective POD players and how they are tracking by their average scores as the season unfolds ...

For the purposes of POD players I used an ownership of below 5 teams ...

So here we go ... please point out any discrepancies ...

Edit: might have been a touch slow putting it all together but still a different way of displaying the info ...

 

[Beijing_Sting]

@Tails

This is Brilliant!

Almost unbelievably so. Cheers!

 

[doc ron]

Greta job fellas. I sent you a P.M Miles

 

[Ironhawk]

So based on those tables, @Connoisseur and I are the two with the highest average for our 22nd best player, at least for now. That sounds promising.

 

[Diabolical]

So based on those tables, @Connoisseur and I are the two with the highest average for our 22nd best player, at least for now. That sounds promising.

Isn’t 16 the magic number? You are one of those too, so all good!

 

[Herbie66]

Pendles 2 , JPK 2 , Selwood 4

surprised by that and H Clark

interested to see how it all pans out , lock n load , nothing we can do now

have fun and enjoy