Player Raid Efficiency Calculator 1.1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ACDEFHIJNOPQRSTUVWXYAAABACADAEAF
1
2
This shows how well clan members perform, considering Player Raid Level and Total Card Levels. In other words how well players perform in relation to their stats.
3
Step 0) Make a copy.
4
Step 1) Paste full raid export into the green cell to the left. As the actual cell value, do not paste on top of the cell and down onto all rows below! Next step choose either manual or TT2 Master.
5
Step 2) [MANUAL]: Fill in data in the green table. For players which have no data yet in the that table, you can copy the Id and Name from the export table (paste as values only). Manually add Raid and Card levels.
6
If you use the calculator for a subsequent export, you only need to add data of new clan members into the green table. Optionally adjust levels for existing members.
7
Step 2) [TT2 Master]: Use the TT2 Master (Android) app. Navigate "Clan" -> "Clan member" -> "Clan Export". Export to clipboard with only this data chosen: [ID, Name, Raid total card level, Raid player level]TT2 Master export with ID, Name, Card level, Raid level
8
Paste below
Paste the export into the green cell to the right. As the actual cell value, do not paste on top of the cell and down onto all rows below! Do this for every new raid export.
Paste below
9
Rank,Name,ID,Attacks,Damage
1,name1,id1,11,9159108
2,name2,id2,9,6980127
3,name3,id3,11,8185708
4,name4,id4,11,7982960
5,name5,id5,9,6648176
7,name6,id6,9,7148176
8,name7,id7,9,7148176
9,name8,id8,9,7148176
Manual Data input
ID,Name,Raid total card level,Raid player level
expId1,expname1,150,94
expId,expname2,150,94
10
#NameId
Attacks
AvgRaid LevelCard LevelEst.
Efficiency
Sorted ListAvg
Efficiency
NameIdRaid LevelCard LevelIdNameCard LevelRaid Level
11
1name1id1110.833911490.92390.21%name60.79499.15%name1id191149expId1expname115094
12
2name2id290.776861220.84292.07%name50.73997.86%name2id286122expIdexpname215094
13
3name3id3110.744841180.82590.19%name70.79496.94%name3id384118
14
4name4id4110.726881320.87283.18%name80.79492.69%name4id488132
15
5name5id590.739741050.75597.86%name20.77692.07%name5id574105
16
7name6id690.794801150.80199.15%name10.83390.21%name6id680115
17
8name7id790.794851130.81996.94%name30.74490.19%name7id785113
18
9name8id890.794921160.85792.69%name40.72683.18%name8id892116
19
20
21
22
23
24
25
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
Loading...