
All formulas are written in Excel. It is necessary to write the number of matches played, goals for and against, and total number Clear Cut Chances (and Half Chances) for and against.
As an example, I introduced the performance of my teams, and four teams under the direction of AI.
V. 2.0
-New formulas. Now one Half Chances is 0,7 It is more realistic
-Updated last column.closer to 0 means less luck(Worse your team finishing and better team finishing of the opponent). The closer to 2. The more lucky you are with goals

This table will help you compare your teams. The last column is something like xG.
In the last column, If the number is much more than 1, then you have a lot of luck. If closer to 0, you had a bad team finishing or a very good opponent team finishing.
You only need to add this:
Team
Stand (for Champ. League)
Matches
Goals for
Goal against
Clear Cut
Chances for
Half Chances for
Clear Cut
Chances against
Half Chances against
Discussion: New team statistics for FM v.2.0
1 comments have been posted so far.
https://www.mediafire.com/file/ozsd3g6v0mo6n6x/Stat._FM.xlsx/file