Following on from my earlier post, I have tried simming with a further modified version of the v6.1 DB. The Basingstoke, Guildford, Milton Keynes and Manchester rosters are the same as before (i.e. 20% of each roster has players with 20 CA, 20% with 30 CA, etc) but the other EPL rosters are the same as the v6.1 DB. All players have contract expiry dates set to 30 April 2014 and I've amended each team's rep as per the tables below.
In case it's of any use, I have uploaded a copy of the DB here (it also includes a spreadsheet showing the amended CAs, PAs and Reps for the four teams):
http://1drv.ms/1i8Oc3E
Annoyingly, the mass exodus of players still occurs at the end of the season. Seeing as players are more willing to re-sign with the increased Team Reps, it seems as though the GM/Head Coaches are simply not interested in re-signing the players. Things do seem to improve at the end of season 2 with teams retaining more players and releasing fewer, but they're still releasing far too many players. During season 1 (01/08/13 - 01/05/14), the teams on average signed approx 4 players and released 15 (approx 4 minus 15 = a net change of approx -12 on average). In season 2, these averages changed to signing 5 and releasing 10 (5 minus 10 = -5 net change).
It's interesting to see that teams with high budgets and Reps of at least 4000 would offer huge contracts to players. Due to the size of the contracts they offered, they could only sign a couple of players. E.g. Manchester had only about 5 players with the average salary being £95k!!!. Guildford and Slough were the other two $240k+ teams with a Rep of greater than 4000 and they also had small, overpaid rosters. Basingstoke, on the other hand, had a $225k budget but only a 2500 rep. Their roster retention was much better than the other three. It's also worth noting that the top three big spenders were signing fairly big imports - e.g. players from Euro elite leagues and the KHL.
From the tables below, it looks like a max Team Rep of somewhere between 4000 and 4499 would be ideal. At least with a 6 League Rep anyhow. I'm going to try dropping the League Rep down to 4 to see what effect this has.
I have posted below some tables which show how things panned out in the first two seasons in game.
SEASON 1
Team overview
This table shows the salary details of the teams at game start-up. I took the Wage Budget details from the DB which is stored in US Dollars - hence why they're in USD rather than £ in the table. Clearly budget and Team Rep play a big role in determining the salaries generated at start-up (in addition, of course, to League Rep). The wages below are shown on a per annum basis.
[table][tr][th]Team[/th][th]Reputation[/th][th]Average Wage[/th][th]Lowest Wage[/th][th]Highest Wage[/th][th]Total Wages[/th][th]Wage Budget (DB)[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]£9,000[/td][td]£2,000[/td][td]£22,000[/td][td]£150,000[/td][td]USD 240,000[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]£7,000[/td][td]£2,000[/td][td]£20,000[/td][td]£127,000[/td][td]USD 190,000[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]£5,000[/td][td]£2,000[/td][td]£16,000[/td][td]£95,000[/td][td]USD 140,000[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]£4,000[/td][td]£1,500[/td][td]£16,000[/td][td]£165,000[/td][td]USD 145,000[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]£7,000[/td][td]£2,000[/td][td]£20,000[/td][td]£160,000[/td][td]USD 245,000[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]£8,000[/td][td]£2,000[/td][td]£24,000[/td][td]£155,000[/td][td]USD 240,000[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]£5,000[/td][td]£2,000[/td][td]£18,000[/td][td]£102,000[/td][td]USD 185,000[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]£6,000[/td][td]£2,000[/td][td]£26,000[/td][td]£116,000[/td][td]USD 160,000[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]£5,000[/td][td]£2,000[/td][td]£18,000[/td][td]£88,000[/td][td]USD 165,000[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]£6,000[/td][td]£2,000[/td][td]£22,000[/td][td]£115,000[/td][td]USD 225,000[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]£3,000[/td][td]£2,000[/td][td]£10,000[/td][td]£61,500[/td][td]USD 100,000[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]£2,500[/td][td]£1,500[/td][td]£12,000[/td][td]£56,000[/td][td]USD 95,000[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]£5,625[/td][td]£1,917[/td][td]£18,667[/td][td]£115,875[/td][td]USD 177,500[/td][/tr][/table]
Roster movement as of 1 May 2014
This table shows the roster sizes of each team as of 1 May 2014. It also shows how many players they signed (IN) and released (OUT) during the season (i.e. 1 August 2013 - 1 May 2014). The Net Change shows the IN less the OUT. I.e. a negative net change shows that the roster shrunk over the season whereas a positive number shows a net increase. Post season transactions aren't included and in any event the game started after this date (i.e. 2 May 2013 - 31 July 2013).
[table][tr][th]1 May 2014[/th][th]Reputation[/th][th]Roster Size[/th][th]Net Change[/th][th]IN[/th][th]OUT[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]0[/td][td]-16[/td][td]0[/td][td]16[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]5[/td][td]-13[/td][td]0[/td][td]13[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]14[/td][td]-4[/td][td]8[/td][td]12[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]10[/td][td]-27[/td][td]0[/td][td]27[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]3[/td][td]-16[/td][td]0[/td][td]16[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]2[/td][td]-18[/td][td]1[/td][td]19[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]12[/td][td]-7[/td][td]0[/td][td]7[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]15[/td][td]-4[/td][td]7[/td][td]11[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]10[/td][td]-7[/td][td]5[/td][td]12[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]8[/td][td]-10[/td][td]4[/td][td]14[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]12[/td][td]-6[/td][td]12[/td][td]18[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]10[/td][td]-10[/td][td]10[/td][td]20[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]8[/td][td]-12[/td][td]4[/td][td]15[/td][/tr][/table]
Player signings as of 1 May 2014
This table breaks down the IN figure from the Roster Movement table above. It shows during which point of the season players were signed.
[table][tr][th]PLAYERS IN[/th][th]Reputation[/th][th]01/08/13 - 31/12/13[/th][th]01/01/14 - 01/05/14[/th][th]TOTAL[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]0[/td][td]0[/td][td]0[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]0[/td][td]0[/td][td]0[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]7[/td][td]1[/td][td]8[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]0[/td][td]0[/td][td]0[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]0[/td][td]0[/td][td]0[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]1[/td][td]0[/td][td]1[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]0[/td][td]0[/td][td]0[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]4[/td][td]3[/td][td]7[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]4[/td][td]1[/td][td]5[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]2[/td][td]2[/td][td]4[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]11[/td][td]1[/td][td]12[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]10[/td][td]0[/td][td]10[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]3[/td][td]1[/td][td]4[/td][/tr][/table]
Player releases as of 1 May 2014
This table breaks down the OUT figure from the Roster Movement table above. It shows during which point of the season players were released / traded away. Virtually all of the players released during the 01/01/14 - 01/05/14 period were as a result of contract expiries on 30/04/14.
[table][tr][th]PLAYERS OUT[/th][th]Reputation[/th][th]01/08/13 - 31/12/13[/th][th]01/01/14 - 01/05/14[/th][th]TOTAL[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]0[/td][td]16[/td][td]16[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]1[/td][td]12[/td][td]13[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]1[/td][td]11[/td][td]12[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]10[/td][td]17[/td][td]27[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]1[/td][td]15[/td][td]16[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]1[/td][td]18[/td][td]19[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]1[/td][td]6[/td][td]7[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]0[/td][td]11[/td][td]11[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]0[/td][td]12[/td][td]12[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]3[/td][td]11[/td][td]14[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]5[/td][td]13[/td][td]18[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]8[/td][td]12[/td][td]20[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]3[/td][td]13[/td][td]15[/td][/tr][/table]
SEASON 2
Team overview
[table][tr][th]Team[/th][th]Reputation[/th][th]Average Wage[/th][th]Lowest Wage[/th][th]Highest Wage[/th][th]Total Wages[/th][th]Wage Budget (DB)[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]£95,000[/td][td]£3,500[/td][td]£150,000[/td][td]£481,000[/td][td]USD 240,000[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]£7,000[/td][td]£2,000[/td][td]£14,000[/td][td]£88,500[/td][td]USD 190,000[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]£6,000[/td][td]£2,000[/td][td]£18,000[/td][td]£133,000[/td][td]USD 140,000[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]£6,000[/td][td]£2,000[/td][td]£22,000[/td][td]£109,000[/td][td]USD 145,000[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]£18,000[/td][td]£2,500[/td][td]£70,000[/td][td]£167,000[/td][td]USD 245,000[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]£18,000[/td][td]£35,000[/td][td]£50,000[/td][td]£164,000[/td][td]USD 240,000[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]£5,000[/td][td]£2,000[/td][td]£22,000[/td][td]£105,000[/td][td]USD 185,000[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]£4,500[/td][td]£2,000[/td][td]£18,000[/td][td]£112,000[/td][td]USD 160,000[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]£5,000[/td][td]£2,000[/td][td]£26,000[/td][td]£104,000[/td][td]USD 165,000[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]£4,500[/td][td]£2,000[/td][td]£14,000[/td][td]£82,000[/td][td]USD 225,000[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]£3,000[/td][td]£2,000[/td][td]£12,000[/td][td]£71,000[/td][td]USD 100,000[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]£3,000[/td][td]£1,500[/td][td]£12,000[/td][td]£62,000[/td][td]USD 95,000[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]£14,583[/td][td]£4,875[/td][td]£35,667[/td][td]£139,875[/td][td]USD 177,500[/td][/tr][/table]
Highest paid players as of 5 September 2014
This table shows in which league each of the top paid players were playing in during the previous season. For example, Manchester's highest paid player on their roster (as at 5 September 2014) played in the Swedish Hockey League (the former Elitserien) in-game last season - as did their second highest paid player. The reason for showing these stats as of 5 September is because many teams had lots of players on try out contracts which all expired on 4 September.
[table][tr][th]Top Players[/th][th]Reputation[/th][th]Highest Paid[/th][th]2nd Highest Paid[/th][th]3rd Highest Paid[/th][th]4th Highest Paid[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]Swe SHL[/td][td]Swe SHL[/td][td]Rus RSL/KHL[/td][td]Ger DEL[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]EPL[/td][td]Swe-2[/td][td]EPL[/td][td]ECHL->AHL[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]EPL[/td][td]EPL[/td][td]EPL[/td][td]EPL[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]EPL[/td][td]EPL[/td][td]Ita Elite[/td][td]EPL[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]ECHL[/td][td]Ger-3[/td][td]EIHL[/td][td]EPL[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]Rus-2[/td][td]Ger DEL[/td][td]Swe-3[/td][td]EPL[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]EPL[/td][td]Nor Elite[/td][td]EPL[/td][td]Dutch Elite[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]Fra Elite[/td][td]EPL[/td][td]Aut-2[/td][td]Swe-2[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]Fra Elite[/td][td]Ger DEL-2[/td][td]Nor Elite[/td][td]ECHL[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]MOL Liga[/td][td]EPL[/td][td]EPL[/td][td]Cze-2[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]Svk-3[/td][td]Fra-3[/td][td]Fin Liiga[/td][td]EPL[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]EPL[/td][td]EPL[/td][td]EPL[/td][td]SNL->EIHL->EPL[/td][/tr][/table]
Roster movement as of 1 May 2015
[table][tr][th]1 May 2015[/th][th]Reputation[/th][th]Roster Size[/th][th]Net Change[/th][th]IN[/th][th]OUT[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]1[/td][td]-4[/td][td]3[/td][td]7[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]11[/td][td]1[/td][td]10[/td][td]9[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]13[/td][td]-8[/td][td]3[/td][td]11[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]14[/td][td]-3[/td][td]6[/td][td]9[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]5[/td][td]-4[/td][td]8[/td][td]12[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]4[/td][td]-5[/td][td]2[/td][td]7[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]17[/td][td]-3[/td][td]5[/td][td]8[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]13[/td][td]-13[/td][td]3[/td][td]16[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]15[/td][td]-5[/td][td]2[/td][td]7[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]14[/td][td]-3[/td][td]5[/td][td]8[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]17[/td][td]-4[/td][td]10[/td][td]14[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]17[/td][td]-6[/td][td]7[/td][td]13[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]12[/td][td]-5[/td][td]5[/td][td]10[/td][/tr][/table]
Player signings as of 1 May 2015
[table][tr][th]PLAYERS IN[/th][th]Reputation[/th][th]01/08/14 - 31/12/14[/th][th]01/01/15 - 01/05/15[/th][th]TOTAL[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]2[/td][td]1[/td][td]3[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]9[/td][td]1[/td][td]10[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]3[/td][td]0[/td][td]3[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]2[/td][td]4[/td][td]6[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]8[/td][td]0[/td][td]8[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]2[/td][td]0[/td][td]2[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]2[/td][td]3[/td][td]5[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]2[/td][td]1[/td][td]3[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]1[/td][td]1[/td][td]2[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]2[/td][td]3[/td][td]5[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]6[/td][td]4[/td][td]10[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]6[/td][td]1[/td][td]7[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]4[/td][td]2[/td][td]5[/td][/tr][/table]
Player releases as of 1 May 2015
[table][tr][th]PLAYERS OUT[/th][th]Reputation[/th][th]01/08/14 - 31/12/14[/th][th]01/01/15 - 01/05/15[/th][th]TOTAL[/th][/tr]
[tr][td]Manchester[/td][td]9500[/td][td]0[/td][td]7[/td][td]7[/td][/tr]
[tr][td]Milton Keynes[/td][td]7500[/td][td]2[/td][td]7[/td][td]9[/td][/tr]
[tr][td]Telford[/td][td]6000[/td][td]2[/td][td]9[/td][td]11[/td][/tr]
[tr][td]Swindon[/td][td]5500[/td][td]1[/td][td]8[/td][td]9[/td][/tr]
[tr][td]Guildford[/td][td]5000[/td][td]0[/td][td]12[/td][td]12[/td][/tr]
[tr][td]Slough[/td][td]4500[/td][td]0[/td][td]7[/td][td]7[/td][/tr]
[tr][td]Sheffield[/td][td]4000[/td][td]1[/td][td]7[/td][td]8[/td][/tr]
[tr][td]Peterborough[/td][td]3500[/td][td]6[/td][td]10[/td][td]16[/td][/tr]
[tr][td]Bracknell[/td][td]3000[/td][td]1[/td][td]6[/td][td]7[/td][/tr]
[tr][td]Basingstoke[/td][td]2500[/td][td]1[/td][td]7[/td][td]8[/td][/tr]
[tr][td]Romford[/td][td]2500[/td][td]7[/td][td]7[/td][td]14[/td][/tr]
[tr][td]Wightlink[/td][td]2000[/td][td]2[/td][td]11[/td][td]13[/td][/tr]
[tr][td]AVERAGE:[/td][td]4625[/td][td]2[/td][td]8[/td][td]10[/td][/tr][/table]