WooGs S9- chance to hit calc_1E.xlsx

	A	B	C	G	H	I	K	L	M	P	Q	R
1	WooGs S9 CTH Calc Special thanks to: ChatGBT, BubblesPd2, Cailitech, Bargain, Dominis
2			Search
3	Version : 1.0E		rathma	Hell				Nightmare			Normal
4	1) Enter a keyword in the blue cell (C2) to shorten the filtered drop down list. Press F9 after clicking off to cell to ensure the calculation is ran If using Google sheets u need to go into file-> settings -> calculation -> reclaculate -> change to "on change and every min". Unfortunately you will have to wait 1+min after typing the search function. 2) make a selection of the mob/boss in B2 dropdown and it will important all values. I will provide some examples below Dclone - Use "Uberdiablonew" Dclone Skellies - use "dclonesk" Rathma voidknight - use " voidKnight1 " 3) Fill all green boxes with your AR, Clvl (character level) and your -%target defense. 4) added a section for soul drainers for consecuative hits on same mob like dclone 5) Can use some key words like bastion or throne to find map mobs, but not all are coded in same way. Check monstats accordingly 6) Please use the drop down selections to select if a mob is Champ, Elite, Super Elite , and if it has stone skin or not. I did not block you for adding these to bosses, but dont do it as it dosnt make sense	rathmaPoison		Level	110		rathmaPoison	Level	110	rathmaPoison	Level	110
5				Base Def	2100	(monlvl)		Base Def	2100		Base Def	2100
6				AC Scaling	70	(monstats)		AC Scaling	140		AC Scaling	87
7				Calculated Def	1470			Calculated Def	2940		Calculated Def	1827
8				Boss Check	1	( 1 if true in monstats or super elite)		Boss Check	1		Boss Check	1
9				Champion	0			Champion	0		Champion	0
10				Elite	0			Elite	0		Elite	0
11				Super Elite	0			Super Elite	0		Super Elite	0
12				Stone Skin Mod	0			Stone Skin Mod	0		Stone Skin Mod	0
13				-% Target Def	25.00%	(from convic, battery cry, cloak)		-% Target Def	0.00%		-% Target Def	0.00%
14				-% Target Def	0.00%	(from items, runes, passives like blessed aim)		-% Target Def	5.00%		-% Target Def	5.00%
15				Attack Rating	10000			Attack Rating	10000		Attack Rating	10000
16				Defense (actual)	1102.5			Defense (actual)	2866.5		Defense (actual)	1781.325
17				Defense (Sheet)	1470			Defense (Sheet)	2940		Defense (Sheet)	1827
18				Clvl	93			Clvl	92		Clvl	92
19				Tlvl	110			Tlvl	110		Tlvl	110
20
21				Chance to hit (actual)	90%	(cap increased to 100% in s10)		Chance to hit (actual)	77%		Chance to hit (actual)	84%
22				Chance to hit (sheet)	87%	(cap increased to 100% in s10)		Chance to hit (sheet)	77%		Chance to hit (sheet)	84%
23
24
25				CTH	82.00%			CTH	70.00%		CTH Actual	76.00%
26				CTH PD2 11%	91.02%			CTH PD2 11%	77.70%		CTH PD2 11%	84.36%
27				CTH Sheet	78.00%			CTH Sheet	70.00%		CTH Sheet	76.00%
28				CTH PD2 11%	86.58%			CTH PD2 11%	77.70%		CTH PD2 11%	84.36%
29
30
31				Soul Drainers
32				Number of hits	25
33				Remaining Defense(Actual)	220
34				-% applied	165
35				CTH	90.00%
36				CTH PD2 11%	95.00%
37				Chance to hit (actual)	98%	(cap increased to 100% in s10)
38								rathmaBone
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