AA Gun Calculator v1.4.2 - Public

	A	B	C	D	E	F	G	H	I
1	Gun Mount	Reload Stat	Anti-Air Stat	Slot Efficiency	Anti-Air Gun	Adjusted Damage per Tick	Adjusted Rate of Fire	Range	Comments - no effect on calculation
2	1	168	286	80	STAAG	296.448	1.19109474	30	Gascogne
3	2	189	321	80	Twin 76mm Mk27	316.592	1.090642135	30	Ryuuhou
4	3	181	378	110	Twin 90mm (Model 1939)	630.96	1.368958554	31	Noshiro
5	4	186	418.6	130	Sextuple 40mm Bofors	1011.27	1.478403152	28	Kinu
6	5
7	6
8	7
9	8
10	9
11	10
12	11
13	12
14	13
15	14
16	15
17
18	Anti-Air Circle Totals
19	Range	Ticks per Second	Damage Per Tick	Total AA DPS
20	29.75	0.7798641295	2255.27	1758.804175
21
22
23
24
25
26
27
28	Notes
29	Fill The Blue In Yourself. Leave unused gun mount slots blank.	Enter the reload stat of the ship holding respective gun mount, including bonuses from equipment (and possibly fleet tech).	Enter the AA stat of the ship holding the respective gun mount, including bonuses from equipment, skills, (and possibly fleet tech).	Enter the slot efficiency for the slot corresponding to each AA gun mount.	Select the AA gun used from the dropdown. Note that two gun mounts in the same slot need to have the same AA gun.	If you have suggetsions or fixes, contact me on discord:	You will have to copy this file to your own drive to be able to edit it, because Google Sheets provides no way to allow multiple people to use the calculator at once.
30						Sedna#4917
31
32
33
34
35
36
37
38
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