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.
-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:
Stand (for Champ. League)
Half Chances for
Half Chances against