Chat Figuring value for money

[palmistry]

Has anyone ever come up with a good calculation on what players give you the best value for money and which are just sucking up wage? I've been fiddling with a spreadsheet (see a snip below) where I multiply average rating by appearances and then divide by wage. It seems kind of arbitrary and I'm not sure it does much more than show who played a lot. I'd like to also to try to figure out whether someone is at the point I should sell them. I'm wondering if I should multiply by some variable for age or how much longer they are under contract.

Has anyone ever played with this kind of thing before and come up with a good equation?

Am I over-thinking this?

Player Name	Appearances	Avg Rating	Wage	Value	Age	Contract Expiry	App*Rate/Wage	Calc incl. value
Matias De Arrascaeta	35	6.51	1	27	22		227.85	254.85
Driss Sbaa	23	6.78	2	13.25	24		77.97	91.22
Shammai Tranter	31	7.61	7.5	7.5	25		31.45466667	38.95466667
Boris Klimenta	30	7.23	7.5	7.5	29		28.92	36.42
Marcel Loovens	38	6.5	9	19.25	22		27.44444444	46.69444444
Yannick Kouassi	20	6.8	5	28.5	20		27.2	55.7
Jordan Ngbakoto	33	7.51	10	19.75	24		24.783	44.533
Matias Scocco	28	7.57	10	34.5	30		21.196	55.696
Adriano Silva	33	6.96	12	14.75	23		19.14	33.89
Carlo Santon	33	6.54	12	7.5	29		17.985	25.485
Charlie Sinclair	22	6.36	8	8.25	21		17.49	25.74
Claudio Sampaoli	30	7.76	14.25	60	28		16.33684211	76.33684211

Edited February 15, 2018 by palmistry

[BatiGoal]

3 hours ago, palmistry said:

I'd like to also to try to figure out whether someone is at the point I should sell them.

Imo depends on how people play the game. Still hard to answer whether you should sell a season earlier or later. Ideally just after his prime, well, from a business point of view perhaps. But you still need to invest a chunk of those earnings in new talents. But why anyway? Early stages yes but at some point clubs have so much money to spend it makes no sense anymore to sell your star players as there are no better replacements in the market. 

I never sell my players unless they don't have the quality to be part of my squad or if the club can't afford them/meet their demands. 

[rafa]

11 hours ago, palmistry said:

Am I over-thinking this?

Short answer, yes

Long answer, as the financial system in the game is absolutely bollocks, wage expenditure stops being an issue after a few seasons. Your wage budget just exponentially increases season after season.

However, if you wanna play hardcore and consider what is 'value for money', you probably would also like to consider the player's expected valuation over time. Typically, young players get more expensive, older players get cheaper. A player's value is also proportional to how many years they have left in their contract.

[palmistry]

10 hours ago, BatiGoal said:

I never sell my players unless they don't have the quality to be part of my squad or if the club can't afford them/meet their demands. 

This seems like a simpler strategy to use, thanks!

3 hours ago, rafa said:

Short answer, yes

Long answer, as the financial system in the game is absolutely bollocks, wage expenditure stops being an issue after a few seasons. Your wage budget just exponentially increases season after season.

Thanks for confirming that I'm over-thinking things. And that I'm not alone in thinking the wage budget is a bit ridiculous a few seasons in.