Frost Mage Stat Weight Calculator

	B	C	D	E	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2	Please make a copy of this spreadsheet for editing.
3	Frost Mage Stat Weight Calculator				Enter your stats and settings in the gray columns to the right. Stat totals are shown on the left. Stat weights and formulas (based on your entries) are shown below.	Spell Power (SP)			ENTER BELOW	Spell Hit			ENTER BELOW	Spell Crit			ENTER BELOW
4	v1.0 (2019-Nov-02) by Zephriel <purged> - Skeram-NA					Gear (+Damage & Healing)		289	289	Gear (+Hit %)		2%	2	Gear (+Crit %)		3%	3
5						Gear (+Frost Only)		71	71	Base Hit (Enemy Level)		83%	63 (Boss)	Winter's Chill (Stacks)		10%	5
6	Do not edit stat totals below--use gray columns at right					Gear (+Arcane Only)		0	0	Elemental Precision		6%	3 / 3	Arcane Instability		3%	3 / 3
7	SCHOOL	Spell Power (SP)	*Spell Hit %	*Spell Crit %		Flask of Supreme Power		150	Yes	Arcane Focus		6%	3 / 5	Rallying Cry		10%	Yes
8	Frost	545	91	39.48		Greater Arcane Elixir		35	Yes	Options				Songflower Serenade		5%	Yes
9	Fire	474	91	29.48		Elixir of Frost Power		0	No	Options				Slip'kik's Savvy		3%	Yes
10	Arcane	474	91	29.48		Blessing of Blackfathom		0	No	Frostbolt Rank		Rank 10 (Trainer)		Intellect (Gear & Base)		3.90%	232
11			*Limit 99%	*Incl. Base 0.2%		Fury of Ragnaros		0	No	CoC Coefficient		(0.95 ^ 2) Method		Intellect (Buffs)		1.38%	82
12
13		FROSTBOLT (Rank 10) Stat Weights & Formulas			FROSTBOLT		Average Damage Per Cast (excluding multipliers/resistances)
14					Coefficient:	0.8143	Result	Cast %	Avg. Dmg.	Cast %	+1 SP	Cast %	+1% Hit	Cast %	+1% Crit	Cast %	+10 Int.
15					Formula: (3 / 3.5) * 0.95		Non-Crit	55.08%	496.389	55.08%	496.837	55.68%	501.844	54.17%	488.187	54.92%	495.011
16					Base (Rank 10)	457.500	Crit	35.92%	647.562	35.92%	648.147	36.32%	654.678	36.83%	663.966	36.08%	650.319
17	1% Hit in SP	= (Base + (SP * 0.8143)) / (Hit * 81.43)			SP * Coefficient	443.786	Resist	9.00%		9.00%		8.00%		9.00%		9.00%
18	12.163	= (457.5 + (545 * 0.8143)) / (0.91 * 81.43)			Total	901.286	Total		1143.951		1144.985		1156.522		1152.153		1145.329
19	1% Crit in SP	= (Base + (SP * 0.8143)) / ((1 + Crit) * 81.43)					Damage Gain (Next Point)				1.034		12.571		8.202		1.378
20	7.936	= (457.5 + (545 * 0.8143)) / ((1 + 0.3948) * 81.43)					Stat Weight (Equivalent SP)					1% Hit =	12.163	1% Crit =	7.936	10 Int. =	1.334
21
22		ARCANE EXPLOSION (Rank 6) Stat Weights & Formulas			ARCANE EXPLOSION		Average Damage Per Cast (excluding multipliers/resistances)
23					Coefficient:	0.1429	Result	Cast %	Avg. Dmg.	Cast %	+1 SP	Cast %	+1% Hit	Cast %	+1% Crit	Cast %	+10 Int.
24					Formula: (1.5 / 3.5 / 3)		Non-Crit	64.18%	209.992	64.18%	210.084	64.88%	212.299	63.27%	207.014	64.02%	209.491
25					Base (Rank 6)	259.500	Crit	26.82%	131.660	26.82%	131.717	27.12%	133.106	27.73%	136.126	26.98%	132.410
26	1% Hit in SP	= (Base + (SP * 0.1429)) / (Hit * 14.29)			SP * Coefficient	67.714	Resist	9.00%		9.00%		8.00%		9.00%		9.00%
27	25.170	= (259.5 + (474 * 0.1429)) / (0.91 * 14.29)			Total	327.214	Total		341.652		341.801		345.406		343.140		341.902
28	1% Crit in SP	= ((Base + (SP * 0.1429)) * 0.5) / ((1 + (Crit * 0.5)) * 14.29)					Damage Gain (Next Point)				0.149		3.754		1.489		0.250
29	9.981	= ((259.5 + (474 * 0.1429)) * 0.5) / ((1 + (0.2948 * 0.5)) * 14.29)					Stat Weight (Equivalent SP)					1% Hit =	25.170	1% Crit =	9.981	10 Int. =	1.678
30
31		CONE OF COLD (Rank 5) Stat Weights & Formulas			CONE OF COLD		Average Damage Per Cast (excluding multipliers/resistances)
32					Coefficient:	0.1289	Result	Cast %	Avg. Dmg.	Cast %	+1 SP	Cast %	+1% Hit	Cast %	+1% Crit	Cast %	+10 Int.
33					Formula: (1.5 / 3.5 / 3) * (0.95 ^ 2)		Non-Crit	55.08%	233.117	55.08%	233.188	55.68%	235.678	54.17%	229.265	54.92%	232.469
34					Base (Rank 5)	353.000	Crit	35.92%	304.111	35.92%	304.204	36.32%	307.453	36.83%	311.815	36.08%	305.406
35	1% Hit in SP	= (Base + (SP * 0.1289)) / (Hit * 12.89)			SP * Coefficient	70.266	Resist	9.00%		9.00%		8.00%		9.00%		9.00%
36	36.076	= (353 + (545 * 0.1289)) / (0.91 * 12.89)			Total	423.266	Total		537.228		537.391		543.131		541.079		537.875
37	1% Crit in SP	= (Base + (SP * 0.1289)) / ((1 + Crit) * 12.89)					Damage Gain (Next Point)				0.164		5.904		3.852		0.647
38	23.538	= (353 + (545 * 0.1289)) / ((1 + 0.3948) * 12.89)					Stat Weight (Equivalent SP)					1% Hit =	36.076	1% Crit =	23.538	10 Int. =	3.956
39
40	NOTE: Mages will usually be hit-capped against most relevant AoE targets (i.e., 1% Hit = 0 SP). Spell hit info for AoE spells is provided for academic purposes.
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