When to Trade - A spreadsheet tool for you

almax · May 23, 2011, 06:08:00 PM

Hey guys, slow day at work so ive whipped up this spreadsheet with formulas to calculate the 'rank' of your players.
The aim of this is to make it a little easier to see who to trade.
This is based on info from Tooserious.net and calculates the rank from the players average, their current break even and their predicted 'peak salary'
Heres the one that i have done for the players in my team in consideration for being traded.

So basically, the higher the score, the better the timing for a trade.

Average rank formula:
=rank(B2,$B$2:$B$12,0)

Breakeven Rank Formula:
=rank(D2,$D$2:$D$12,1)

Profit Rank Formula:
=rank(H2,$H$2:$H$12,0)

Cash Cow Rank Formula:
=Sum(C2,E2,I2)

note... im not really gonna trade out Broughton now he has hit rock bottom, but jeez he's pushing it!

Grazz · May 23, 2011, 07:36:09 PM

Cheers Almax, like your work. Handy.

korza · May 23, 2011, 07:43:55 PM

@Almax

Very informative well done.

almax · May 23, 2011, 11:01:32 PM

no worries guys, feel free to draw up your own, make it a template for future weeks too.

chambo3 · May 27, 2011, 06:10:04 PM

Nicework Almax.

How'd you get the salary info into your spreadsheet...? Is it exported from Tooserious.net or entered manually...?

almax · May 31, 2011, 03:11:42 PM

Chambo3- Yes all the data is from www.tooserious.net but its all entered manually.
It's a bit of stuffing around but i think it gives you a nice picture of whats going on.
Here's my one for this week, please be aware that i havent really adjusted alot of the Top Salary predicted columns from last week (they may have changed slightly)

almax · June 17, 2011, 03:38:02 PM

This weeks for anyone interested