Genshin Roll Calculator .xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	P	Q	R	S	T	U	V	W	X
1	Hi, feel free to edit however you want. If the math is wrong please let me know on discord : eddyy#2020 )										don’t mind this
2											roll	160
3											Com/Day	60
4	Green = Insert Data		Blue = Final Result/ What you want				White = Maths / Don’t mind it				soft pity	76
5											hard pity	90
6	Primo Today	38287									W s pity	55
7	Days Till Rolling	21									W h pity	80
8	Intertwined Fate	16									Abyss	50
9	Abyss Stars	33									Shop	5
10	Shop (Y/N)	n	(type y for yes and n for no)								character trial	20
11	Character Trial (Y/N)	y	(type y for yes and n for no)								Update	600
12	Update (Y/N)	y	(type y for yes and n for no)								BP	680
13	Battle Pass(Y/N)	n	(type y for yes and n for no)								BP R	4
14
15
16
17	ComPrimo Total	1260
18	Abyss	550
19	Update	600
20	Other		Add any extra amount
21
22	BattlePass
23	Character Trial	20
24
25	BP Roll	0
26	Shop	0
27	Rolls Today	239.29375
28
29	FINAL PRIMO	40717
30	FINAL ROLLS	254.48125
31
32
33
34	Event Banner	0	(insert pity count/90)
35
36	soft pity	194.48	extra rolls!		or	31,117	primogems
37	hard pity	180.48	extra rolls!		or	28,877	primogems
38
39
40
41	Weapon Banner	0	(insert pity count/90)
42
43	soft pity	215.48	extra rolls!		or	34,477	primogems
44	hard pity	190.48	extra rolls!		or	30,477	primogems
45
46
47
48	Standard Banner	58	(insert pity count/90)
49
50	soft pity	236.48	extra rolls!		or	37,837	primogems
51	hard pity	222.48	extra rolls!		or	35,597	primogems
52
53
54
55	DO NOT INPUT ANYTHING HERE
56
57	This is every possible scenario when rolling on the event banners. The number in each cell represents the number of rolls that is extra (if positive) or needed (negative)
58	The colour code is simply to show "good, okay, bad" luck. The Possibility % is the percentage of every positive scenario, every scenario where you get the 5*
59	S = soft, H = hard
60	S - S : You get the 5* at soft pity, you get the Guaranteed 5* on soft pity again
61	note: s-s-h or h-s-s or s-h-s are all the same thing
62
63	C0	1st 5*	1st 5*	2nd 5*	2nd 5*	2nd 5*							C1
64		s	h	s-s	h-s	h-h									s	h	s-s	s-h	h-h
65		194.48	180.48	118.48	104.48	90.48								194.48	139.48	104.48	63.48	49.48	14.48
66														180.48	125.48	90.48	49.48	35.48	0.48
67		Possibility		100%										118.48	63.48	28.48	- 12.52	- 26.52	- 61.52
68														104.48	49.48	14.48	- 26.52	- 40.52	- 75.52
69														90.48	35.48	0.48	- 40.52	- 54.52	- 89.52
70	Weapon
71			s	h	s-s	s-h	h-h	s-s-s	s-s-h	s-h-h	h-h-h				Possibility		64%
72		215.48	160.48	135.48	105.48	80.48	55.48	50.48	25.48	0.48	- 24.52		C1 + Weapon
73		190.48	135.48	110.48	80.48	55.48	30.48	25.48	0.48	- 24.52	- 49.52
74															s	h	s-s	s-h	h-h	s-s-s	s-s-h	s-h-h	h-h-h
75		Possibility		83%										139.48	84.48	59.48	29.48	4.48	- 20.52	- 25.52	- 50.52	- 75.52	- 100.52
76														125.48	70.48	45.48	15.48	- 9.52	- 34.52	- 39.52	- 64.52	- 89.52	- 114.52
77	C0 + Weapon													63.48	8.48	- 16.52	- 46.52	- 71.52	- 96.52	- 101.52	- 126.52	- 151.52	- 176.52
78			s	h	s-s	s-h	h-h	s-s-s	s-s-h	s-h-h	h-h-h			49.48	- 5.52	- 30.52	- 60.52	- 85.52	- 110.52	- 115.52	- 140.52	- 165.52	- 190.52
79		194.48	139.48	114.48	84.48	59.48	34.48	29.48	4.48	- 20.52	- 45.52			35.48	- 19.52	- 44.52	- 74.52	- 99.52	- 124.52	- 129.52	- 154.52	- 179.52	- 204.52
80		180.48	125.48	100.48	70.48	45.48	20.48	15.48	- 9.52	- 34.52	- 59.52			104.48	49.48	24.48	- 5.52	- 30.52	- 55.52	- 60.52	- 85.52	- 110.52	- 135.52
81		118.48	63.48	38.48	8.48	- 16.52	- 41.52	- 46.52	- 71.52	- 96.52	- 121.52			90.48	35.48	10.48	- 19.52	- 44.52	- 69.52	- 74.52	- 99.52	- 124.52	- 149.52
82		104.48	49.48	24.48	- 5.52	- 30.52	- 55.52	- 60.52	- 85.52	- 110.52	- 135.52			28.48	- 26.52	- 51.52	- 81.52	- 106.52	- 131.52	- 136.52	- 161.52	- 186.52	- 211.52
83		90.48	35.48	10.48	- 19.52	- 44.52	- 69.52	- 74.52	- 99.52	- 124.52	- 149.52			14.48	- 40.52	- 65.52	- 95.52	- 120.52	- 145.52	- 150.52	- 175.52	- 200.52	- 225.52
84														0.48	- 54.52	- 79.52	- 109.52	- 134.52	- 159.52	- 164.52	- 189.52	- 214.52	- 239.52
85		Possibility		44%										63.48	8.48	- 16.52	- 46.52	- 71.52	- 96.52	- 101.52	- 126.52	- 151.52	- 176.52
86														49.48	- 5.52	- 30.52	- 60.52	- 85.52	- 110.52	- 115.52	- 140.52	- 165.52	- 190.52
87														- 12.52	- 67.52	- 92.52	- 122.52	- 147.52	- 172.52	- 177.52	- 202.52	- 227.52	- 252.52
88														- 26.52	- 81.52	- 106.52	- 136.52	- 161.52	- 186.52	- 191.52	- 216.52	- 241.52	- 266.52
89														- 40.52	- 95.52	- 120.52	- 150.52	- 175.52	- 200.52	- 205.52	- 230.52	- 255.52	- 280.52
90														49.48	- 5.52	- 30.52	- 60.52	- 85.52	- 110.52	- 115.52	- 140.52	- 165.52	- 190.52
91														35.48	- 19.52	- 44.52	- 74.52	- 99.52	- 124.52	- 129.52	- 154.52	- 179.52	- 204.52
92														- 26.52	- 81.52	- 106.52	- 136.52	- 161.52	- 186.52	- 191.52	- 216.52	- 241.52	- 266.52
93														- 40.52	- 95.52	- 120.52	- 150.52	- 175.52	- 200.52	- 205.52	- 230.52	- 255.52	- 280.52
94														- 54.52	- 109.52	- 134.52	- 164.52	- 189.52	- 214.52	- 219.52	- 244.52	- 269.52	- 294.52
95														14.48	- 40.52	- 65.52	- 95.52	- 120.52	- 145.52	- 150.52	- 175.52	- 200.52	- 225.52
96														0.48	- 54.52	- 79.52	- 109.52	- 134.52	- 159.52	- 164.52	- 189.52	- 214.52	- 239.52
97														- 61.52	- 116.52	- 141.52	- 171.52	- 196.52	- 221.52	- 226.52	- 251.52	- 276.52	- 301.52
98														- 75.52	- 130.52	- 155.52	- 185.52	- 210.52	- 235.52	- 240.52	- 265.52	- 290.52	- 315.52
99														- 89.52	- 144.52	- 169.52	- 199.52	- 224.52	- 249.52	- 254.52	- 279.52	- 304.52	- 329.52
100