ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
You need to download this file and the train stats file both on your computer and open them in MS Excel.
[Enable macros!] Fill the orange fields >> You need to select the source train stats file below.
There're a few standard names, it's better to stay to them or their variations/copies (there're some additional text features releated to standard names).

You need to open the train stats file (This tool works only with open MS Excel files)
The location of file doesn't matter, it can be in the same folder or in any other place

Then you need to select the train you need. If you only need stats for all trains, you can keep it empty, but it's better to select one to avoid side errors.
If file name and train name were saved with this file, you may need to reselect the train anyway - to refresh internal values.

Then you need to select a report.
There're plenty of them related to all trains (named "All trains ...") and to selected one (named "This train ..."), usually new. "All trains" stats (usually) not included the stats of unfinished train(s) in the source file, such as train(s) with data column left to the right side of Total column on Games/Conductors pages, and the train(s) with empty "Entries..." columns

Some reports use the lowest accepted value. There're defaults, but you can write you own minimum value in the corresponding orange field.

Reports with * are related to the switches in the source file (the carts/keys switches etc.)
So, for example, to get top contributors in keys instead of carts (giveaways), you need to change switch in the Conductors page of the source file.

Some reports take the time to compile, wait until the indicator above the result field changes to "done".
Copy the result from the field below, paste it into SG comment/GA description. Some additional editing may be required.
2
Pls, do not delete rows, and do not move the fields and other cells in rows from 10 till 22
9
10
Select or write the name of source train stats file: XMas_Trains_stats.xlsx
11
train workbook not found, you need to open file in Excel first and keep it opened
12
Select the name of the train page (or write it manually): 5th (Dec 2025)
13
train is not found
14
15
Select the report:This train. Always a key report
16
open train file first
17
18
The lowest value: default:result:
19
minimum value is not required
20
21
22
done
23
#NAME?
24
25
The tool doesn't read/write anything to disk/system etc.

When you try to close the source train stats file, you may be asked if you want to save changes.
Don’t save (or save, if you like): this tool can change the active cell/worksheet in the source file, that only change happens there
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106