Post by thedogspollocks on Sept 24, 2021 5:33:30 GMT
Hi all,
I'm currently attempting to data fit (curve fit) age, ov and value data in order to figure out the formula used.
As part of this process, I'm making a visual table to show which combinations are worth which value.
The benefit of this is to clear up any ambiguity as to a players potential OV rating.
I have managed to collect data for over 1000 players thus far, however, this still isn't enough. At the top and bottom ends, the data available is limited.
Therefore, I was hoping people would be willing to post their team sheets in order for me to complete the following:
The issue that I face is two fold:
As such, I was hoping that people would be willing to provide their team sheets for me to figure this out. I have, thus far, been using my extra actions to purchase as many team sheets as possible. This is not exactly cost effective, nor is it efficient.
If this sounds like something you're happy to help with, can I ask that we post it in 1 format. Another problem I face at present is the ease with which I can insert the data into a spreadsheet. Having everything sources from the exact same place would be a great help, and save literal hours.
To make life easier for anyone who'd like to help, can I ask that you please only post your teamsheets as they are in the e-mail which neil sends alongside your pdf version. To be clear, I mean the text based version of your turn sent to you via email, e.g.:
Squad Sheet - Lyon
Team Number: 197
Number Name Age D.O.B. Pos Ft Sp Ag Co Di Cr Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0085 Sergio Rico 28 09-01-93 GK R 75 95 65 90 70 90 90 95 70 82 u 11 0 0 SPA 10000 12 6.12m 6.82
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0102 Julian Pollersbec27 16-08-94 GK R 90 85 70 75 75 75 85 95 85 79 u 0 0 0 GER 8250 16 1.14m 0.00
0117 Marko Malenica 27 02-08-94 GK R 80 75 90 60 90 70 90 20 95 79 - 0 0 0 CRO 10000 16 1.14m 0.00
8624 Mile Svilar 22 27-08-99 GK R 70 95 80 75 85 85 80 80 95 80 - 2 0 0 BEL 7500 30 1.68m 6.00
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
1430 Willy Boly 30 02-03-91 DEF R 75 75 80 95 95 95 60 95 80 82 u 8 0 0 FRA 10000 24 4.92m 6.88 wk5
2786 Francisco Montero22 14-01-99 DEF L 95 95 95 80 70 50 75 70 95 79 u 1 0 0 SPA 5940 18 0.61m 6.00
3943 Ludwig Augustinss27 21-04-94 DEF L 95 95 95 60 70 95 65 95 70 82 u 11 0 0 SWE 10250 27 17.42m 6.73
11021 Jason Denayer 26 28-06-95 DEF R 85 90 65 90 85 70 90 95 80 82 u 11 0 0 BEL 10000 17 11.43m 6.73
11245 Rob Holding 26 20-09-95 DEF R 90 45 65 90 95 95 75 90 95 79 u 0 0 0 ENG 8100 46 4.77m 0.00 wk9
11766 Youcef Atal 25 17-05-96 DEF R 95 90 95 85 60 80 55 65 85 80 - 1 0 0 ALG 9900 13 5.15m 5.00
12556 Leonardo Balerdi 22 26-01-99 DEF E 85 95 50 95 90 85 50 75 95 78 u 0 0 0 ARG 7980 23 1.68m 0.00
13617 Nikola Katic 24 10-10-96 DEF R 85 90 95 95 80 45 65 95 95 79 u 1 0 0 CRO 7260 19 1.44m 7.00
14581 Felipe Camargo 22 01-08-99 DEF E 50 95 45 95 95 95 70 90 95 77 u 1 0 0 BRA 6530 21 0.61m 7.00
16067 Vadim Karpov 19 14-07-02 DEF R 65 95 90 65 80 60 90 40 95 77 u 0 0 0 RUS 6600 13 0.71m 0.00
18422 Goncalo Cardoso 20 21-10-00 DEF L 45 40 95 95 95 90 90 90 80 78 u 0 0 0 POR 6530 23 0.68m 0.00
18764 Zaidu Sanusi 24 13-06-97 DEF L 90 95 95 50 75 75 90 90 80 80 - 2 0 0 NIG 9350 15 1.44m 5.50
18876 Rafael Camacho 21 22-05-00 DEF R 60 80 45 70 95 95 95 95 75 77 u 0 0 0 POR 6530 21 0.64m 0.00
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0078 Romain Faivre 23 14-07-98 MID R 80 60 90 75 80 85 80 95 85 78 u 0 0 0 FRA 7260 32 1.56m 0.00
0930 Maxence Caqueret 21 15-02-00 MID R 70 85 70 80 95 80 55 90 95 78 u 0 0 0 FRA 8250 16 1.81m 0.00
3579 Jean Lucas 23 22-06-98 MID R 75 80 80 85 70 60 95 90 75 77 u 2 0 0 BRA 7180 18 0.57m 6.00
3619 Edouard Michut 18 03-04-03 MID R 65 65 85 80 80 80 80 90 95 76 u 0 0 0 FRA 4350 33 0.50m 0.00
3801 Yangel Herrera 23 01-07-98 MID R 95 95 95 45 95 55 95 90 80 81 u 9 1 0 VEN 8100 18 5.99m 7.22
3908 Okay Yokuslu 27 03-09-94 MID R 85 85 75 95 60 80 80 95 70 80 u 0 0 0 TUR 10000 24 10.59m 0.00 wk5
4125 Alexis Saelemaeke22 27-06-99 MID R 90 90 95 65 85 60 75 65 95 80 - 1 0 0 BEL 5940 14 6.45m 7.00
4928 F. L Martins 29 03-03-92 MID R 95 95 95 65 80 65 80 90 80 82 u 1 0 0 BRA 10000 24 5.65m 7.00 wk5
5593 Naby Keita 25 02-10-95 MID R 95 70 65 85 75 95 85 95 75 81 u 11 3 3 GUI 11000 19 11.43m 7.45
5816 Mads Bidstrup 20 25-02-01 MID R 70 95 60 70 95 70 85 65 95 77 u 0 0 0 DEN 7860 34 0.68m 0.00
7791 Pablo P Hernandez34 24-10-86 MID R 65 65 85 95 95 70 95 95 70 81 u 4 0 0 CHI 10000 24 2.70m 7.00 wk5
7801 Moussa Diaby 22 07-07-99 MID L 95 85 80 95 55 95 60 60 85 80 - 0 0 0 FRA 8910 13 6.45m 0.00
8209 Harry Wilson 24 22-03-97 MID L 95 80 95 65 70 65 90 65 95 80 u 6 1 0 WAL 8100 18 5.56m 7.00
10158 Sergio Mota 31 16-11-89 MID R 75 85 80 80 75 65 85 75 95 77 u 0 0 0 BRA 5400 23 0.31m 0.00 wk7
11447 Arsen Zakharyan 18 26-05-03 MID R 90 85 65 65 80 70 60 65 95 75 - 0 0 0 RUS 8190 8 0.50m 0.00
11604 Enzo Le Fee 21 02-03-00 MID R 65 50 90 95 75 85 70 90 90 76 u 0 0 0 FRA 4950 16 0.52m 0.00
11632 A. Tchouameni 21 27-01-00 MID R 70 95 85 95 65 75 85 70 90 80 - 6 0 0 FRA 10000 27 1.81m 7.00
11871 Guus Til 23 22-12-97 MID R 90 60 95 95 75 95 45 90 95 79 u 1 0 0 NLD 7260 18 1.56m 6.00
11934 Hannes Wolf 22 16-04-99 MID R 85 85 50 70 75 95 90 95 85 78 u 0 0 0 AUS 7980 25 1.68m 0.00
19714 J. De Guzman 34 13-09-87 MID R 95 95 95 75 90 50 75 70 80 82 u 0 0 0 NLD 10000 24 2.70m 0.00 wk5
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
5691 Luka Jovic 23 23-12-97 ATT E 95 70 70 75 75 95 95 95 75 82 u 10 2 0 SER 12000 17 14.29m 7.30
6839 Olivier Giroud 34 30-09-86 ATT L 60 65 95 90 95 80 95 90 75 82 u 5 1 0 FRA 12000 27 2.70m 7.40 wk8
7422 Donyell Malen 22 19-01-99 ATT R 85 95 60 65 80 95 95 90 80 81 u 9 2 0 NLD 11250 14 6.45m 7.00
10182 Edin Dzeko 35 17-03-86 ATT L 40 95 95 95 95 85 90 95 70 85 u 2 2 0 BOS 45040 17 13.30m 8.00 wk4
11450 K. Tyukavin 19 22-06-02 ATT R 80 75 60 60 75 85 75 65 95 75 - 0 0 0 RUS 7200 8 0.47m 0.00
11741 Armand Lauriente 23 12-04-98 ATT R 80 90 50 55 80 85 85 90 90 76 u 0 0 0 FRA 6600 19 0.50m 0.00
15215 Mbwana Samatta 28 13-12-92 ATT E 45 50 95 95 95 95 95 95 70 81 u 3 0 0 CON 9720 45 1.63m 7.00 wk9
19066 Aleksandr Sobolev24 03-07-97 ATT R 80 50 80 95 60 80 95 95 70 77 u 1 0 0 RUS 9720 16 0.44m 7.00
19082 Daniil Lesovoy 22 01-12-98 ATT L 70 90 60 95 85 85 45 90 95 76 u 0 0 0 RUS 6600 19 0.47m 0.00
Injuries and Suspensions
2235 Edmond Tapsoba 22 02-02-99 DEF R Injured (52% fit)4weeks 81 (Lyon ) BKF 9500 27 6.45m 7.17
11601 Borna Barisic 28 11-10-92 DEF L Injured (72% fit)2weeks 82 (Lyon ) CRO 12200 45 14.33m 6.11
Also, can you please avoid any injured players. Though the information is there, it makes it difficult when things aren't exactly the same.
Thanks for your time and any help provided.
All the best,
Pollock
I'm currently attempting to data fit (curve fit) age, ov and value data in order to figure out the formula used.
As part of this process, I'm making a visual table to show which combinations are worth which value.
The benefit of this is to clear up any ambiguity as to a players potential OV rating.
I have managed to collect data for over 1000 players thus far, however, this still isn't enough. At the top and bottom ends, the data available is limited.
Therefore, I was hoping people would be willing to post their team sheets in order for me to complete the following:
The issue that I face is two fold:
- You need enough players of the same value to be able to see the OV spread - players that have been improved by 2 OV points and those that haven't. This provides certainty about their starting point.
- You need to reverse any age changes that have occurred since the start of the game, so as not link incorrect ages with values.
As such, I was hoping that people would be willing to provide their team sheets for me to figure this out. I have, thus far, been using my extra actions to purchase as many team sheets as possible. This is not exactly cost effective, nor is it efficient.
If this sounds like something you're happy to help with, can I ask that we post it in 1 format. Another problem I face at present is the ease with which I can insert the data into a spreadsheet. Having everything sources from the exact same place would be a great help, and save literal hours.
To make life easier for anyone who'd like to help, can I ask that you please only post your teamsheets as they are in the e-mail which neil sends alongside your pdf version. To be clear, I mean the text based version of your turn sent to you via email, e.g.:
Squad Sheet - Lyon
Team Number: 197
Number Name Age D.O.B. Pos Ft Sp Ag Co Di Cr Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0085 Sergio Rico 28 09-01-93 GK R 75 95 65 90 70 90 90 95 70 82 u 11 0 0 SPA 10000 12 6.12m 6.82
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0102 Julian Pollersbec27 16-08-94 GK R 90 85 70 75 75 75 85 95 85 79 u 0 0 0 GER 8250 16 1.14m 0.00
0117 Marko Malenica 27 02-08-94 GK R 80 75 90 60 90 70 90 20 95 79 - 0 0 0 CRO 10000 16 1.14m 0.00
8624 Mile Svilar 22 27-08-99 GK R 70 95 80 75 85 85 80 80 95 80 - 2 0 0 BEL 7500 30 1.68m 6.00
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
1430 Willy Boly 30 02-03-91 DEF R 75 75 80 95 95 95 60 95 80 82 u 8 0 0 FRA 10000 24 4.92m 6.88 wk5
2786 Francisco Montero22 14-01-99 DEF L 95 95 95 80 70 50 75 70 95 79 u 1 0 0 SPA 5940 18 0.61m 6.00
3943 Ludwig Augustinss27 21-04-94 DEF L 95 95 95 60 70 95 65 95 70 82 u 11 0 0 SWE 10250 27 17.42m 6.73
11021 Jason Denayer 26 28-06-95 DEF R 85 90 65 90 85 70 90 95 80 82 u 11 0 0 BEL 10000 17 11.43m 6.73
11245 Rob Holding 26 20-09-95 DEF R 90 45 65 90 95 95 75 90 95 79 u 0 0 0 ENG 8100 46 4.77m 0.00 wk9
11766 Youcef Atal 25 17-05-96 DEF R 95 90 95 85 60 80 55 65 85 80 - 1 0 0 ALG 9900 13 5.15m 5.00
12556 Leonardo Balerdi 22 26-01-99 DEF E 85 95 50 95 90 85 50 75 95 78 u 0 0 0 ARG 7980 23 1.68m 0.00
13617 Nikola Katic 24 10-10-96 DEF R 85 90 95 95 80 45 65 95 95 79 u 1 0 0 CRO 7260 19 1.44m 7.00
14581 Felipe Camargo 22 01-08-99 DEF E 50 95 45 95 95 95 70 90 95 77 u 1 0 0 BRA 6530 21 0.61m 7.00
16067 Vadim Karpov 19 14-07-02 DEF R 65 95 90 65 80 60 90 40 95 77 u 0 0 0 RUS 6600 13 0.71m 0.00
18422 Goncalo Cardoso 20 21-10-00 DEF L 45 40 95 95 95 90 90 90 80 78 u 0 0 0 POR 6530 23 0.68m 0.00
18764 Zaidu Sanusi 24 13-06-97 DEF L 90 95 95 50 75 75 90 90 80 80 - 2 0 0 NIG 9350 15 1.44m 5.50
18876 Rafael Camacho 21 22-05-00 DEF R 60 80 45 70 95 95 95 95 75 77 u 0 0 0 POR 6530 21 0.64m 0.00
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
0078 Romain Faivre 23 14-07-98 MID R 80 60 90 75 80 85 80 95 85 78 u 0 0 0 FRA 7260 32 1.56m 0.00
0930 Maxence Caqueret 21 15-02-00 MID R 70 85 70 80 95 80 55 90 95 78 u 0 0 0 FRA 8250 16 1.81m 0.00
3579 Jean Lucas 23 22-06-98 MID R 75 80 80 85 70 60 95 90 75 77 u 2 0 0 BRA 7180 18 0.57m 6.00
3619 Edouard Michut 18 03-04-03 MID R 65 65 85 80 80 80 80 90 95 76 u 0 0 0 FRA 4350 33 0.50m 0.00
3801 Yangel Herrera 23 01-07-98 MID R 95 95 95 45 95 55 95 90 80 81 u 9 1 0 VEN 8100 18 5.99m 7.22
3908 Okay Yokuslu 27 03-09-94 MID R 85 85 75 95 60 80 80 95 70 80 u 0 0 0 TUR 10000 24 10.59m 0.00 wk5
4125 Alexis Saelemaeke22 27-06-99 MID R 90 90 95 65 85 60 75 65 95 80 - 1 0 0 BEL 5940 14 6.45m 7.00
4928 F. L Martins 29 03-03-92 MID R 95 95 95 65 80 65 80 90 80 82 u 1 0 0 BRA 10000 24 5.65m 7.00 wk5
5593 Naby Keita 25 02-10-95 MID R 95 70 65 85 75 95 85 95 75 81 u 11 3 3 GUI 11000 19 11.43m 7.45
5816 Mads Bidstrup 20 25-02-01 MID R 70 95 60 70 95 70 85 65 95 77 u 0 0 0 DEN 7860 34 0.68m 0.00
7791 Pablo P Hernandez34 24-10-86 MID R 65 65 85 95 95 70 95 95 70 81 u 4 0 0 CHI 10000 24 2.70m 7.00 wk5
7801 Moussa Diaby 22 07-07-99 MID L 95 85 80 95 55 95 60 60 85 80 - 0 0 0 FRA 8910 13 6.45m 0.00
8209 Harry Wilson 24 22-03-97 MID L 95 80 95 65 70 65 90 65 95 80 u 6 1 0 WAL 8100 18 5.56m 7.00
10158 Sergio Mota 31 16-11-89 MID R 75 85 80 80 75 65 85 75 95 77 u 0 0 0 BRA 5400 23 0.31m 0.00 wk7
11447 Arsen Zakharyan 18 26-05-03 MID R 90 85 65 65 80 70 60 65 95 75 - 0 0 0 RUS 8190 8 0.50m 0.00
11604 Enzo Le Fee 21 02-03-00 MID R 65 50 90 95 75 85 70 90 90 76 u 0 0 0 FRA 4950 16 0.52m 0.00
11632 A. Tchouameni 21 27-01-00 MID R 70 95 85 95 65 75 85 70 90 80 - 6 0 0 FRA 10000 27 1.81m 7.00
11871 Guus Til 23 22-12-97 MID R 90 60 95 95 75 95 45 90 95 79 u 1 0 0 NLD 7260 18 1.56m 6.00
11934 Hannes Wolf 22 16-04-99 MID R 85 85 50 70 75 95 90 95 85 78 u 0 0 0 AUS 7980 25 1.68m 0.00
19714 J. De Guzman 34 13-09-87 MID R 95 95 95 75 90 50 75 70 80 82 u 0 0 0 NLD 10000 24 2.70m 0.00 wk5
Number Name Age D.O.B. Pos Ft Sp Ag Co Pa Hd Sh Th Fm Fi OV. Mo Pl Gl Di Nat Wage Ct Value AvePerf
5691 Luka Jovic 23 23-12-97 ATT E 95 70 70 75 75 95 95 95 75 82 u 10 2 0 SER 12000 17 14.29m 7.30
6839 Olivier Giroud 34 30-09-86 ATT L 60 65 95 90 95 80 95 90 75 82 u 5 1 0 FRA 12000 27 2.70m 7.40 wk8
7422 Donyell Malen 22 19-01-99 ATT R 85 95 60 65 80 95 95 90 80 81 u 9 2 0 NLD 11250 14 6.45m 7.00
10182 Edin Dzeko 35 17-03-86 ATT L 40 95 95 95 95 85 90 95 70 85 u 2 2 0 BOS 45040 17 13.30m 8.00 wk4
11450 K. Tyukavin 19 22-06-02 ATT R 80 75 60 60 75 85 75 65 95 75 - 0 0 0 RUS 7200 8 0.47m 0.00
11741 Armand Lauriente 23 12-04-98 ATT R 80 90 50 55 80 85 85 90 90 76 u 0 0 0 FRA 6600 19 0.50m 0.00
15215 Mbwana Samatta 28 13-12-92 ATT E 45 50 95 95 95 95 95 95 70 81 u 3 0 0 CON 9720 45 1.63m 7.00 wk9
19066 Aleksandr Sobolev24 03-07-97 ATT R 80 50 80 95 60 80 95 95 70 77 u 1 0 0 RUS 9720 16 0.44m 7.00
19082 Daniil Lesovoy 22 01-12-98 ATT L 70 90 60 95 85 85 45 90 95 76 u 0 0 0 RUS 6600 19 0.47m 0.00
Also, can you please avoid any injured players. Though the information is there, it makes it difficult when things aren't exactly the same.
Thanks for your time and any help provided.
All the best,
Pollock