Artifact Gauntlet Reward and Chance Calculator by Cairns_6

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1		Artifact Gauntlet Reward and Chance Calculator by Cairns_6 / Lord_Renatus (Gruß an alle Säue! :))
2		Version 5 - 2018 - November - 26th																Number of wins / gauntlet	Custom % of occurence				Fix Average Winrates
3						↙		↘								Choose Assumed Average Win Rate here:	50,00%			30%	35%	40%	45%	50%	55%	60%	65%	70%	Win
4						Lose		Win								Lose Rate	50,00%			70%	65%	60%	55%	50%	45%	40%	35%	30%	Lose
5
6							Start					DARK GREY FIELDS CAN BE EDITED						0 Wins	25,00%	49,00%	42,25%	36,00%	30,25%	25,00%	20,25%	16,00%	12,25%	9,00%
7						↙		↘										1 Wins	25,00%	29,40%	29,58%	28,80%	27,23%	25,00%	22,28%	19,20%	15,93%	12,60%
8					0 - 1				1 - 0									2 Wins	18,75%	13,23%	15,53%	17,28%	18,38%	18,75%	18,38%	17,28%	15,53%	13,23%
9				↙		↘		↙		↘								3 Wins	12,50%	5,29%	7,25%	9,22%	11,03%	12,50%	13,48%	13,82%	13,46%	12,35%
10			0 - 2				1 - 1				2 - 0							4 Wins	7,81%	1,98%	3,17%	4,61%	6,20%	7,81%	9,27%	10,37%	10,93%	10,80%
11						↙		↘		↙		↘						5 Wins	7,81%	0,85%	1,71%	3,07%	5,07%	7,81%	11,32%	15,55%	20,31%	25,21%
12					1 - 2				2 - 1				3 - 0					5 to 0	3,13%	0,24%	0,53%	1,02%	1,85%	3,13%	5,03%	7,78%	11,60%	16,81%
13								↙		↘		↙		↘
14							2 - 2				3 - 1				4 - 0		% of getting something		31,25%	8,37%	12,65%	17,92%	24,15%	31,25%	39,10%	47,52%	56,30%	65,17%
15										↙		↘		↙		↘
16									3 - 2				4 - 1				5 - 0
17												↙		↘
18											4 - 2				5 - 1
19
20	* Phantom Draft tables are for Expert Phantom Draft and Expert Constructed Gauntlets																							100
21	Phantom Draft Reward Table				Keeper's Draft Reward Table					Phantom Draft summary:							Returns per Gauntlet					What to expect after ___ Gauntlets with the Win Rate of							50,00%
22		Packs	Tickets			Packs	Tickets			You have	31,3%	Chance of a reward				Phantom Draft		Keeper's Draft				Phantom Draft			Keeper's Draft
23	0 Wins	0	0		0 Wins	0	0			You need	3,37	Gauntlets to get 1 Pack				Packs	Tickets	Packs	Tickets			Packs	Tickets		Packs	Tickets
24	1 Wins	0	0		1 Wins	0	0			You need	3,20	Gauntlets to get 1 Ticket				0,00	0,00	0,00	0,00	0 Wins		29,69	18,75		48,44	37,50
25	2 Wins	0	0		2 Wins	0	0									0,00	0,00	0,00	0,00	1 Wins		$0,00	$99,00		$995,00	$198,00	Costs
26	3 Wins	0	1		3 Wins	1	2			Keeper's Draft summary:						0,00	0,00	0,00	0,00	2 Wins		$59,08	$18,56		$96,39	$37,13	Value
27	4 Wins	1	1		4 Wins	2	2			You have	31,3%	Chance of a reward				0,00	0,13	0,13	0,25	3 Wins					$995,00		Extra (due to Keepers)
28	5 Wins	2	1		5 Wins	3	2			You need	1,64	Gauntlets to get 1 Pack				0,08	0,08	0,16	0,16	4 Wins		Phantom Draft			Keeper's Draft
29	5 to 0	2	1		5 to 0	3	2			You need	1,60	Gauntlets to get 1 Ticket				0,16	0,08	0,23	0,16	5 Wins			$99,00			$1.193,00	Sum Costs
30																0,06	0,03	0,09	0,06	5 to 0			$77,64			$1.128,52	Sum Value
31																3,37	3,20	1,64	1,60	Average Gauntlets per Pack/Ticket			0,7842487374			0,9459477158	Value/Cost Coefficient
32																0	1	5	2	Original Entry Cost
33
34																												Costs
35																												Pack	Ticket
36																												$1,99	$0,99
37					Value per Cost (V/C) Graph for different Assumed Win Rates ( the greater the better). Less than 1 might be unprofitable compared to just buying packs (depends on Keeper's draft picks)
38
39
40					Win Ratio	Phantom Draft	Keeper's Draft
41					5%	0,00009	0,83404
42					10%	0,00149	0,83427
43					15%	0,0075	0,83521
44					20%	0,02344	0,83765
45					25%	0,05635	0,84261
46					30%	0,1146	0,85123
47					35%	0,2074	0,86474
48					40%	0,3443	0,88434
49					45%	0,53408	0,91111
50					50%	0,7842	0,94594
51					55%	1,1	0,98931
52					60%	1,4832	1,04128
53					65%	1,93095	1,10128
54					70%	2,43458	1,168
55					75%	2,97809	1,23923
56					80%	3,53662	1,31168
57					85%	4,08487	1,3808
58					90%	4,5431	1,44066
59					95%	4,88631	1,48366
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