List Mgmt. Fremantle FC Contract List/Depth Chart

[wayToGo_]

I have added this but I want to be very transparent about how I worked it out so that it doesn't cause any issues if someone wants to use that data for something important, they can check my numbers etc.

It is calculated by the total days between the date of birth and the current date listed in the bottom left of the spreadsheet, the total days divided by the number of players for average days then divided by 365.25 for leap years.

Think you can use this Excel function to calculate a precise live age...

=YEARFRAC(BD, TODAY(), 1)

Replacing BD with the cell containing their birthday.

 

[Taylor]

Think you can use this Excel function to calculate a precise live age...

=YEARFRAC(BD, TODAY(), 1)

Replacing BD with the cell containing their birthday.

That is a far more simple solution, thanks
The two numbers came out the same so that makes me happy.

 

[Taylor]

Special thanks to _Wildcard_ for his late night help bashing this out.

 

[Proud SJW]

Saw a movie called "Revenge of the Nerds" in 1984, been trying to get laid teaching women how to use spreadsheets ever since.
Never worked yet... that movie lied to me.

 

[trentjac]

Saw a movie called "Revenge of the Nerds" in 1984, been trying to get laid teaching women how to use spreadsheets ever since.
Never worked yet... that movie lied to me.

 

[wayToGo_]

Saw a movie called "Revenge of the Nerds" in 1984, been trying to get laid teaching women how to use spreadsheets ever since.
Never worked yet... that movie lied to me.

Think you are confusing spreadsheets with spread sheets.

 

[mr.11]

Wilson will take #14 (sit next to his close mate Bennell)

Matera in the magic #30 for Freo

 

[M_rash]

Wilson will take #14 (sit next to his close mate Bennell)

Matera in the magic #30 for Freo

I’ll locking Wilson in for #3. His Freo photo shoot was done in front of it

 

[Geoff]

Based on the numbers taken from the AFL site we have reduced our list by 11 to 33. Is there a need for any more delistings?


On iPad using BigFooty.com mobile app

 

[Taylor]

Only those who are out of contract, which I'm not sure extends beyond Suban

 

[couldhavebeen]

Suban has been delisted

 

[M_rash]

Still can’t believe we extended Sheridan’s contract!

 

[Dormammu]

Tayl0r, love the spreadsheet, just wondering if it would be possible to add a further tab showing player's positions (i.e., "F" for Forward, "M" for Midfielder and "D" for Defender) to give an idea of list depth by position?

 

[freo_leo29]

Time for an update with 2017 to be taken off too as we have officially passed those contracts (November 1st)

 

[Taylor]

Tayl0r, love the spreadsheet, just wondering if it would be possible to add a further tab showing player's positions (i.e., "F" for Forward, "M" for Midfielder and "D" for Defender) to give an idea of list depth by position?

I had thought to do that but there is way too much room for arguments over whether the likes of Logue, Cox, Alex Pearce are strictly defenders or forwards too. You can imagine the pedantic pointless "discussions" that would take place over it.

Ultimately I decided that the mantra of players can play anywhere will suit for now.

Time for an update with 2017 to be taken off too as we have officially passed those contracts (November 1st)

I'm waiting for the draft to give it a big update

 

[Dormammu]

I had thought to do that but there is way too much room for arguments over whether the likes of Logue, Cox, Alex Pearce are strictly defenders or forwards too. You can imagine the pedantic pointless "discussions" that would take place over it.

Well, you could give yourself a get-out clause by using the description assigned to them by the club when they're drafted, or another third-party like Twomey or Chris25.

 

[DaveLister]

Player list has been updated on the website http://www.fremantlefc.com.au/footy-centre/team/senior-players
and Nyhuis is still on the senior list

 

[Tommo]

Great work Tayl0r, would it be possible to add the average age?

 

[Taylor]

Great work Tayl0r, would it be possible to add the average age?

It should be at the bottom of the master sheet but keep in mind it is about to get smashed down with a group of 18 year olds.

 

[M_rash]

Special thanks to _Wildcard_ for his late night help bashing this out.

Matera is a three year deal. Can’t really find the link but he mentions it in his presser.

“(I’ll look to) carry that into this pre-season and into the next three years at the Fremantle Dockers.”

Matera looks to lure family back to their footy roots
http://m.fremantlefc.com.au/news/2017-11-15/home-comforts-to-drive-matera.mobileapp

 

[M_rash]

Think Matera was 3yrs and wilson 4yrs. Matera should be 2020, not 2021

 

[DaveLister]

Player list has been updated on the website http://www.fremantlefc.com.au/footy-centre/team/senior-players
and Nyhuis is still on the senior list

So the latest and final draft order has us with 9 picks which means we have 9 senior list positions which means Nyhuis hasn't been upgraded (yet)

Edit: confirmation Nyhuis a retained rookie:

 

[Taylor]

It is my understanding that a player may be nominated at the start of next season by the club as our "testimonial player", who has been on the list for ten years. They have to lodge a plan for the honouring of this player, such as a round dedicated to him, and then this allows an extra $100,000 to be paid to him outside the salary cap after the preseason draft of the year he is nominated as that "testimonial player".

So we can offer Sandi that in 2018, pay Johnson $100,000 less if he wants to play on in 2019 or do that for Mundy instead and the players aren't disadvantaged.

Item #18 of the AFLPA

 

[freo_leo29]

It is my understanding that a player may be nominated at the start of next season by the club as our "testimonial player", who has been on the list for ten years. They have to lodge a plan for the honouring of this player, such as a round dedicated to him, and then this allows an extra $100,000 to be paid to him outside the salary cap after the preseason draft of the year he is nominated as that "testimonial player".

So we can offer Sandi that in 2018, pay Johnson $100,000 less if he wants to play on in 2019 or do that for Mundy instead and the players aren't disadvantaged.

Item #18 of the AFLPA

interesting, this is new for next season?
Sandilands and then Mundy would be the go for the next two seasons if true, would Hill be ready the season after Mundy?

 

[Taylor]

interesting, this is new for next season?
Sandilands and then Mundy would be the go for the next two seasons if true, would Hill be ready the season after Mundy?

I believe it takes effect from November 1st 2017 but the rule has to be used the year the player retires, hopefully Hill plays until he is 34