Enchanting Calculator

	A	B	C	D	E	F	G	H	I	J	L	M	N
1	Make a copy on your own drive for personal use. File > Make a copy.
2	Current Stacks		Cost per click		Assumed Success Threhsold		Enter current stacks, then you can see your probability of success for the next attempt (Col B). Also, the combined probability in getting it after X attempts (Cols C-H)
3	30		2.6		0.5		For example, starting at 20 (put 20 in cell A2) stacks means you have a 70% chance of getting a DUO piece in 4 tries (cell E15)
4							Enter costs per click to calculate approximate total click cost (sum of all clicks to cross above the assumed success threshold (cell E2)). The Total Click Cost cells (col I) will highlight in green when the value is less than the cost to reach your next stack threshold
5			Chance off success in X attempts								Current Stack Cost
6	Going For	Chance of Success	2	3	4	5	6	7	Total Click Cost	Total Enhance Cost	40
7	8	52.50%	77%	89%	95%	98%	99%	99%	2.6	42.6	Cost for next threshold
8	9	45.50%	70%	84%	91%	95%	97%	99%	5.2	45.2	32
9	10	37.50%	61%	76%	85%	90%	94%	96%	5.2	45.2
10	11	32.50%	54%	69%	79%	86%	91%	94%	5.2	45.2	Approx Failstack Value
11	12	23.50%	41%	55%	66%	74%	80%	85%	7.8	47.8	Stacks	Value	Dif
12	13	20.10%	36%	49%	59%	67%	74%	79%	10.4	50.4	5	1.25	1.25
13	14	17.50%	32%	44%	54%	62%	68%	74%	10.4	50.4	10	3	1.75
14	15	15.00%	28%	39%	48%	56%	62%	68%	13	53	15	5	2
15	PRI	52.50%	77%	89%	95%	98%	99%	99%	2.6	42.6	20	10	5
16	DUO	30.00%	53%	69%	79%	86%	91%	94%	5.2	45.2	25	20	10
17	TRI	20.00%	38%	53%	65%	74%	81%	86%	7.8	47.8	30	40	20
18	TET	9.50%	19%	29%	38%	47%	56%	63%	15.6	55.6	35	72	32
19	PEN	6.00%	12%	19%	26%	33%	40%	47%	PRAY	#VALUE!	40	110	38
20											45	150	40
21	The above calculator is based on the theoretical datamined probability table shown below (link provided). DO NOT CHANGE, unless you feel the data mined is wrong										50	200	50
22	http://origin.webcdn.theblackdesertonline.net/forum/service_live/monthly_03_2016/bdo_fail_stacks.png.d2280d49a9556270326fcd3566355f27.png										55	275	75
23	Going to	Base %	% per stack	Max failstacks	Max %						60	350	75
24	1	100.00%									65	425	75
25	2	100.00%									70	500	75
26	3	100.00%
27	4	100.00%
28	5	100.00%
29	6	100.00%
30	7	100.00%
31	8	20.00%	2.50%	13	52.50%
32	9	17.50%	2.00%	14	45.50%
33	10	15.00%	1.50%	15	37.50%
34	11	12.50%	1.25%	16	32.50%
35	12	10.00%	0.75%	18	23.50%
36	13	7.50%	0.63%	20	20.10%
37	14	5.00%	0.50%	25	17.50%
38	15	2.50%	0.50%	25	15.00%
39	PRI	15.00%	1.50%	25	52.50%
40	DUO	7.50%	0.75%	35	33.75%
41	TRI	5.00%	0.50%	44	27.00%
42	TET	2.00%	0.25%	90	24.50%
43	PEN	1.50%	0.15%	124	20.10%
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