I have inserted the ones we have knowledge of.Any chance of getting a contract end date column? Would be a very handy reference with that.
Added. Had to work the age average out myself as I can't get my head around how to do the formula for that format. Not my forte.Chance of an 'average' row for the next update? Thanks
Plowman Jones Docherty
Byrne Weitering Marchbank
Cuningham Cripps Lang
Kreuzer Kennedy Murphy
C Curnow Casboult Pickett
J Silvagni McKay Wright
Williamson Petrevski-Seton E Curnow Simpson
White Glass-McCasker ____
Thomas A Silvagni ______
Smedts Graham Boekhorst
Lobbe Kerridge Fisher
Lamb Rowe Polson
Phillips Kerr LeBois
#3 #10 #30 ______
Of course injuries will play their part but can you imagine how much better the VFL side will be with ASOS and Rowe filling key posts, Lobbe in the ruck and the leadership of Thomas?
Thinking Silvagni is building a full 22 of 7.5/10 rated players. Untaggable, unstoppable. No Dusty types!List profile looks good - better than three years ago. Feels we are missing 1-2 AA quality though. But not discounting generic growth of Charlie, Marchy, Samo, Weits etc...
Geez, putting me on the spot. Obv i can't tell which if any will become the next Dusty or Buddy type. Neither could SoS when drafting kids at 17.Even if we draft Rayner?...
Does that mean you also think that Cripps, Charlie, Samo, Weitering, etc all have a ceiling of 75%?
I do get what you're saying though and I tend to agree. Over the course of the last year and particularly the last couple of months I'm really cooling on the idea of paying through the teeth for Lynch or any other 'messiah' player, especially if it's going to make things more difficult to retain players when our young list matures and are in contention for some kind of success.Geez, putting me on the spot. Obv i can't tell which if any will become the next Dusty or Buddy type. Neither could SoS when drafting kids at 17.
My point is more of an attainable ideal - an awesome situation if possible. This way Carlton aren't held to ransom by a player like Richmond (Dusty) have been and Sydney before them (Buddy). Those contracts severely restrict the oncoming years. Tiges got their flag but that doesnt mean it's the only way. A cross the board group of 7.5 rated players would (in theory) see Carlton stay up longer than maybe a tigers outfit.
Hi ODN,Have added Mullett and removed Boekhorst, White and Smedts.
Have inserted spreadsheet as an actual spreadsheet, not just a cut and paste adding an average age formula and hopefully the ages will always be current to the day they are being looked at. Will check on that tomorrow.
Column D creates Column E. I usually hide Column D but it automatically showed itself when I published it.Hi ODN,
Instead of using column D and changing the date everyday, use the TODAY() function. This gives you the date every time you refresh calculations or re-open the file.
For example, the formula for Simmo's age is: =DATEDIF(C2,TODAY(),"y") &" years,"&DATEDIF(C2,TODAY(),"ym") &" months," &DATEDIF(C2,TODAY(),"md") &" days"
Edit: I didn't realize column D was itself the TODAY() function, apologies! Unnecessary step but I suppose improves readability for other users.