Untitled spreadsheet

	A	B	C	D	E	F	G	H
1
2		Dmg	Base Reload	Salvo	Coef	Light Armor	Firepower	Spread (not included in the calculation)
3	381mm	133	17.96	2	1.1	1.4	45	22 degrees
4	410mm	154	20.02	2	1.1	1.4	25	20 degrees
5
6		edit this value and see the table below
7	Base Reload	159	Calculated Reload	381mm	15.78234192
8		159		410mm	17.592566
9
10	Firepower	DPS 381mm	DPS 410mm	Diff
11	0	37.636	33.702	3.934			DPS
12	10	40.231	36.398	3.833
13	20	42.827	39.094	3.733
14	30	45.422	41.790	3.632
15	40	48.018	44.486	3.532
16	50	50.613	47.182	3.431
17	60	53.209	49.879	3.330
18	70	55.805	52.575	3.230
19	80	58.400	55.271	3.129
20	90	60.996	57.967	3.029
21	100	63.591	60.663	2.928
22	110	66.187	63.359	2.827
23	120	68.782	66.055	2.727
24	130	71.378	68.752	2.626
25	140	73.973	71.448	2.526
26	150	76.569	74.144	2.425
27	160	79.165	76.840	2.325
28	170	81.760	79.536	2.224
29	180	84.356	82.232	2.123
30	190	86.951	84.928	2.023
31	200	89.547	87.625	1.922
32	210	92.142	90.321	1.822
33	220	94.738	93.017	1.721
34	230	97.333	95.713	1.621
35	240	99.929	98.409	1.520
36	250	102.525	101.105	1.419
37	260	105.120	103.801	1.319
38	270	107.716	106.497	1.218
39	280	110.311	109.194	1.118
40	290	112.907	111.890	1.017
41	300	115.502	114.586	0.916
42	310	118.098	117.282	0.816
43	320	120.693	119.978	0.715
44	330	123.289	122.674	0.615
45	340	125.885	125.370	0.514
46	350	128.480	128.067	0.414
47	360	131.076	130.763	0.313
48	370	133.671	133.459	0.212
49	380	136.267	136.155	0.112
50	390	138.862	138.851	0.011
51	391	139.122	139.121	0.001
52	392	139.382	139.390	-0.009	The point where 410mm overtakes 381mm
53	393	139.641	139.660	-0.019
54	394	139.901	139.930	-0.029
55	395	140.160	140.199	-0.039
56	396	140.420	140.469	-0.049
57	397	140.679	140.738	-0.059
58	398	140.939	141.008	-0.069
59	399	141.198	141.278	-0.079
60	400	141.458	141.547	-0.089
61	410	144.054	144.243	-0.190
62	420	146.649	146.940	-0.290
63	430	149.245	149.636	-0.391
64	440	151.840	152.332	-0.492
65	450	154.436	155.028	-0.592
66	460	157.031	157.724	-0.693
67	470	159.627	160.420	-0.793
68	480	162.222	163.116	-0.894
69	490	164.818	165.813	-0.995
70	500	167.414	168.509	-1.095
71
72	Game Time
73	Number of Seconds Elapsed		381mm shots	410mm shots	Difference
74	1		0	0	0		Since 381mm has a higher reload than 410mm, the longer the battle is, the more gun activations you get which is crucial for botes that have skills that rely on gun activations.
75	2		0	0	0
76	3		0	0	0
77	4		0	0	0
78	5		0	0	0
79	6		0	0	0
80	7		0	0	0
81	8		0	0	0
82	9		0	0	0
83	10		0	0	0
84	11		0	0	0
85	12		0	0	0
86	13		0	0	0
87	14		0	0	0
88	15		0	0	0
89	16		1	0	1
90	17		1	0	1
91	18		1	1	0
92	19		1	1	0
93	20		1	1	0
94	21		1	1	0
95	22		1	1	0
96	23		1	1	0
97	24		1	1	0
98	25		1	1	0
99	26		1	1	0
100	27		1	1	0