hit and luck calculator for backline shooty botes.xlsx

	A	B	C	D	E	F	G	I	J	L	M	N	O	P	Q	Z	AA	AB	AC	AD	AF	AG	AH	AI	AJ	AL	AM	AN	AO	AP
1				Luck	Hit	Increased Hitrate	Increased Critrate	FdG next salvo	Even	Have Georgia?	Yes	1	BB +hit	BBV +hit	BM +hit	Name	Luck	Hit	Increased Hit	Increased Critrate	Aux Name	Luck	Hit	Increased Hitrate	Increased Critrate	AA	Luck	Hit	Increased Hitrate	Increased Critrate
2	Name	Marco Polo		0	86	0	0	Warspite hitting a DD?	No	Queen Elizabeth lvl 120?	Yes	1	22	19	0	Abercrombie	38	81	0	0	Anything Else	0	0	0	0	Hazemeyer	0	5	0	0
3	AA Gun	STAAG		0	10	0	0	Is Kongou alive in your fleet?	No	Mikasa lvl 120?	Yes	1				Alabama	86	86	0	0	Awakening Pearl (DOA Aux)	0	25	0	0	Other	0	0	0	0
4	Aux 1	Type 1 Armor Piercing Shell (White Shell)	10	0	15	0	0	Is Nagato the flagship?	No	Giulio Cesare lvl 120?	Yes	1				Amagi	23	90	0	0	Fire Control Radar (Purple)	0	24	0	0	STAAG	0	10	0	0
5	Aux 2	High Performance Fire Control Radar (FW Radar)	10	0	36	0	0	Is Bismarck in the fleet?	Yes	Odin lvl 120?	Yes	1				Amagi-chan	23	90	0	0	Gyroscope (Purple)	0	35	0	0
6	AS	Air Supremacy		0	1.1	0	0	For Sovetskaya Rossiya, how many other Northern Parliament or Dragon Empery ships are in the same fleet, up to 4 and only during the first 2 battles she participates in. She counts as 1 already.	4	Valiant lvl 120?	Yes	1				Arizona	17	92	0	0	Heart Key (DOA Aux)	0	30	0	0
7								For Little Renown, how many Royal Navy ships including herself are in the same fleet as her, up to 4. She counts as 1 already.	4	Massachusetts lvl 120?	Yes	2				Bismarck	32	95	0	0.2	High Performance Fire Control Radar (FW Radar)	0	36	0	0	AS	Luck	Hit
8	Total Luck	Total Hit		Crit Rate	Hit Chance			Is Richelieu the flagship?	No	Warspite lvl 120?	Yes	2				California	36	91	0	0	Nelson's Pennant of Victory (Collection reward)	0	20	0	0	Air Supremacy	0	1.1	0	0
9	0	161.7		11.69%	75.04%			Is Mikasa in the same fleet and has the Z Flag equipped?	No	Champagne lvl 120?	Yes	2				Champagne	15	99	0	0	Pyoko Pyoko (Kizuna AI Headband)	2	0	0	0	Air Superiority	0	1.05	0	0
10								Is Champagne using AP?	No	Eagle Union Tech Level	9	10	7			Colorado	67	91	0	0	Random Word Generator (Kizuna AI Box)	0	25	0	0	Air Parity	0	1	0	0
11	Enemy							Is Champagne below 75% HP?	No	Trento lvl 120?	No	0				Conte di Cavour	45	84	0	0	Resplendent Astrum (Blue mic)	0	30	0	0	Air Denial	0	0.97	0	0
12	Luck	Evasion	Level					Is Howe in the fleet? Her accuracy buff is up half the time so change this as you want.	No	Anchorage lvl 120?	No	0				Duke of York	73	92	0	0	Sacred Lumière (Yellow mic)	0	30	0	0	Air Incapability	0	0.92	0	0
13	25	75	122					Is Dido sortied with Queen Elizabeth?	No							Dunkerque	35	93	0	0	SG Radar (Gold)	0	35	0	0
14								Is Tokino Sora in the fleet?	No							Erebus	91	81	0	0	Super Heavy Shell (Black Shell)	0	0	0	0.08
15	You should only modify the cells coloured in green.							Is Jean Bart using the Quadruple 380mm (Mle 1935)?	Yes							Friedrich der Große	0	87	0	0.4	Team Emblem (Hololive)	0	25	0	0	3	4	5	6
16	Using Taihou's 13-4 boss as an example							Is King George V using the Quadruple 356mm (BL 14'' Mk VII)?	Yes							Fusou	13	88	0	0	Type 1 Armor Piercing Shell (White Shell)	0	15	0	0
17	If you want to check a specific enemy and change her stats to your liking try this link below, 25 luck and 75 evasion seems to be common for bosses but not all of them do.							Did Illustrious µ launch an airstrike and get the EVA debuff?	No							Fusou Kai	13	96	0	0	Type 91 Armor Piercing Shell (Purple White Shell)	0	10	0	0
18	https://al-data.github.io/enemies							Is Vittorio Veneto in the fleet?	No							Gangut	85	83	0	0	Type 94 High Angle Director (Purple)	0	10	0	0
19	Also this assumes your girl is 120 and every skill is level 10, I don't want to look up stats for other levels															Gascogne	15	93	0	0	Washington Naval Treaty	0	30	0	0
20																Gascogne µ	0	93	0	0	White-Hot Verheerender (Red mic)	0	30	0	0
21	Didn't bother with cats since I don't really understand how some of those stats work, if someone else wants to do that feel free to do it.															Georgia	15	95	0	0	Z Flag	5	10	0	0.05
22	If I forgot something please let me know.															Giulio Cesare	65	86	0	0
23																Gneisenau	64	88	0	0.2	Aux Name	Luck	Hit	Increased Hitrate	Increased Critrate
24																Haruna	47	90	0	0	Anything Else	0	0	0	0
25																Hiei	37	90	0	0	Awakening Pearl (DOA Aux)	0	25	0	0
26	Make a copy of this spreadsheet if you wish to change these options															Honoka	91	77	0	0	Fire Control Radar (Purple)	0	24	0	0
27	https://docs.google.com/spreadsheets/d/19ecRnrr3MJ1ofBHufXWFavOzsSOA2_nE/															Hiei-chan	37	90	0	0	Gyroscope (Purple)	0	35	0	0
28																Hood	38	90	0	0	Heart Key (DOA Aux)	0	30	0	0
29																Howe	83	92	0	0	High Performance Fire Control Radar (FW Radar)	0	36	0	0
30																Hyuuga	60	92	0	0	Nelson's Pennant of Victory (Collection reward)	0	20	0	0
31																Hyuuga Kai	60	106	0	0	Pyoko Pyoko (Kizuna AI Headband)	2	0	0	0
32																Ise	60	92	0	0	Random Word Generator (Kizuna AI Box)	0	25	0	0
33																Ise Kai	60	106	0	0	Resplendent Astrum (Blue mic)	0	30	0	0
34																Izumo	15	88	0	0	Sacred Lumière (Yellow mic)	0	30	0	0
35																Jean Bart	17	88	0	0.3	SG Radar (Gold)	0	35	0	0
36																Kaga (BB)	42	93	0	0	Super Heavy Shell (Black Shell)	0	0	0	0.08
37																Kii	39	93	0	0	Team Emblem (Hololive)	0	25	0	0
38																King George V	77	92	0	0.2	Type 1 Armor Piercing Shell (White Shell)	0	15	0	0
39																Kirishima	37	90	0	0	Type 91 Armor Piercing Shell (Purple White Shell)	0	10	0	0
40																Kongou	43	92	0	0	Type 94 High Angle Director (Purple)	0	10	0	0
41																Little Renown	85	90	0.2	0	Washington Naval Treaty	0	30	0	0
42																Littorio	79	80	0	0	White-Hot Verheerender (Red mic)	0	30	0	0
43																Marco Polo	0	86	0	0	Z Flag	5	10	0	0.05
44																Maryland	70	86	0	0
45																Massachusetts	82	96	0	0
46																Mikasa	95	94	0	0
47																Monarch	15	88	0	0
48																Mutsu	34	93	0	0
49																Nagato	71	92	0	0
50																Nagisa	87	87	0	0
51																Nelson	66	92	0	0
52																Nevada	75	90	0	0
53																Nevada Kai	75	105	0	0
54																New Jersey	72	96	0	0
55																North Carolina	81	92	0	0
56																Odin	15	84	0	0.2
57																Oklahoma	38	90	0	0
58																Oklahoma Kai	38	100	0	0
59																Pennsylvania	72	92	0	0
60																Prince of Wales	19	91	0	0
61																Queen Elizabeth	25	90	0	0
62																Renown	85	94	0	0
63																Repulse	28	90	0	0
64																Richelieu	19	88	0	0
65																Rodney	81	92	0	0
66																Scharnhorst	43	88	0	0.2
67																South Dakota	76	93	0	0
68																Sovetskaya Belorussiya	46	98	0	0
69																Sovetskaya Rossiya	46	81	0.2	0
70																Super Gamer Kizuna AI	66	77	0.25	0
71																Suruga	37	90	0	0
72																Tennessee	51	91	0	0
73																Terror	19	81	0	0
74																Tirpitz	45	89	0	0.2
75																Tosa	12	93	0	0
76																Valiant	72	92	0	0
77																Vittorio Veneto	80	80	0	0
78																Warspite	90	97	0	0
79																Warspite Kai	90	122	0	0
80																Washington	89	92	0	0
81																West Virginia	61	92	0	0
82																Yamashiro	14	88	0	0
83																Yamashiro Kai	14	96	0	0
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100																Name	Luck	Hit