ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Physical/Magical AttackWeapon AttackClassStat Coefficient
Weapon Coefficient
External Bonus AttackYou will need to create a copy to use this spreadsheet. Only fill in the yellow fields and the dropdown menus for class and gemstones.
3
3479738Archer0.624.5930
4
5
Case 1Gemslot 1Gemslot 2Gemslot 3Gemslot 4Gemslot 5Gemslot 6Gemslot 7Gemslot 8Gemslot 9Total
6
Tier / TypeT10 Main StatT10 Main StatT10 Main StatT10 Main StatT10 Main StatT10 Main StatT10 OffenseT10 OffenseAccuracy
7
Bonus Attack0000001801800360
8
Main stat363636363636000216
9
10
Before Gemstones
4831281After Gemstones7474939.56Percent Increase54.72%
11
12
Case 2Gemslot 1Gemslot 2Gemslot 3Gemslot 4Gemslot 5Gemslot 6Gemslot 7Gemslot 8Gemslot 9Total
13
Tier / TypeT10 Main StatT10 Main StatT10 Main StatT10 Main StatT10 Main StatT10 OffenseT10 OffenseT10 OffenseAccuracy
14
Bonus Attack000001801801800540
15
Main stat36363636360000180
16
17
Before Gemstones
4831281After Gemstones7499485.80Percent Increase55.23%
18
19
Physical Attack: Your projected Physical Attack value (without gemstones) by the time you reach the specified gemstones. For long term calculation make sure you consider the Attribute Points that you're currently missing from prestige rank, future level cap, or trophies.

Weapon Attack: Your projected MINIMUM Weapon Attack value by the time your reach the specified gemstones. For +15 weapons use the +0 minimum attack times 3. This calculator only takes into the account the coefficients for LEGENDARY grade weapons, as that's what everyone would eventually be using by the time they upgrade their gemstones far enough.

External Bonus Attack: The amount of bonus attack that you have from non-gemstone sources such as 40% of your pet's attack or the 3 set Panic effect.

Result: These numbers are what determines the value of the different combinations on your damage. Higher value means higher damage. The combination with the highest value is the most optimal combination in your situation. It is however important to note that certain class passives or skills can tip the scales a little bit in favor of different combinations. An example is Archer's conditioning and bronze eagle skills which makes Dexterity much more valuable than bonus attack and thefore the optimal set-up would be 6 Main stat and 2 offense instead of 5 Main stat and 3 offense.

Created by: Izaz [EU Codex]

Credits to:
SaintoneLIVE for providing me with info regarding stats and gemstones as well as class coefficient.
Zee for helping with wizard coefficients.
Lin and Slagk for helping with Berseker coefficients.
skr for helping with Assassin coefficients.
FishingMS2 and Maygi for helping with Priest coefficients.
Vero for helping with Heavy Gunner coefficients.
Society for helping with Runeblade coefficients.
Cheat for helping with Thief coefficients.
Toastitos for helping with Soul Binder.		Change rate from case 1 to case 20.33%
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