ED Weapon Calc

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	How to calculate how long you can fire a weapon group (updated 1/29/17)
2	1. Make a copy of this sheet (file -> make copy...)
3	2. Figure out your power distrib.		http://www.edshipyard.com/
4	3. edit row 8
5	4. Add Weapons rows 11-15
6	Power Distrib1									Power Distrib2
7	Class	Rating								Class	Rating
8	8	a								8	a
9	Enter Weapon(s)				Caclulated				VS	Enter Weapon(s)				Caclulated
10	Class?	aTracking (F/G/T)	Type?	Qty?	EPS	DPS	DP Shield	DP Hull		Class?	aTracking (F/G/T)	Type?	Qty?	EPS	DPS	DP Shield	DP Hull
11	4	g	multi	1	1.26	23.3	13.98	27.96		4	g	multi	1	1.26	23.3	13.98	27.96
12	3	g	multi	1	1.68	18.9	11.34	22.68		3	g	multi	1	1.68	18.9	11.34	22.68
13	3	t	beam	2	7.02	28.8	34.6	28.8		3	t	burst	2	3.48	22	26.4	22
14	2	t	multi	2	0.74	14.6	8.76	17.52		2	t	burst	2	2.18	13.6	16.4	13.6
15	1	t	burst	2	1.34	8.4	10	8.4		1	t	burst	2	1.34	8.4	10	8.4
16				total	12.04	94	78.68	105.36					total	9.94	86.2	78.12	94.64
17									DIFF		Unit
18					Coupling WEP Gen			7.2		7.2	EPS
19					Coupling WEP Capacity			72.0		72.0	MJ
20					Weapon EPS			12.04	← 2.1	9.94	EPS
21					Damage DPS			94	← 7.8	86.2	DPS
22					Shields DPS			78.68	← 0.56	78.12	DPS
23					Hull DPS			105.36	← 10.72	94.64	DPS
24					Net EPS Burn EPS			4.84	2.1 →	2.74	EPS
25					Time to overload			14.9	-11.4 →	26.3	Sec									POWER DISTRIBS
26					Total Damage			1398.3	-866.76 →	2265.1	(Damage before overload)									Class	Rating	Mass (T)	Power Draw	Weapons		Engines		Systems		Price (CR)
27
28
29			WEAPON	Class	Track	Type	FDev	Shield	Hull	RoF	DPS	DPSvS	DPSvH	Draw	EPS	DPE	EvS	EvH	APV
30			c4 Beam - f	4	f	beam	-	-	-	-	41.4	49.7	41.4	8.19	8.19	5.05	6.07	5.05	60					Capacity	Recharge	Capacity	Recharge	Capacity	Recharge
31			c4 Beam - g	4	g	beam	-	-	-	-	32.7	39.2	32.7	8.99	8.99	3.64	4.36	3.64	60	1	A	1.3	0.48	14	1.8	12	0.6	12	0.6	20,195
32			c4 Burst - f	4	f	burst	20.6	24.72	20.60	1.6	32.3	38.8	32.3	2.98	4.77	6.91	8.13	6.77	65	1	B	2	0.44	13	1.7	11	0.6	11	0.6	8,078
33			c4 Burst - g	4	g	burst	12.1	14.52	12.1	2.1	25.9	31.1	25.9	2.41	5.06	5.02	6.14	5.12	65	1	C	1.3	0.4	12	1.5	10	0.5	10	0.5	3,231
34			c4 Cannon - f	4	f	cannon	83.1	49.9	99.7	0.4	31.6	19	37.9	1.61	0.64	51.61	29.69	59.22	90	1	D	0.5	0.36	11	1.4	9	0.5	9	0.5	1,293
35			c4 Cannon - g	4	g	cannon	56.5	34	67.9	0.4	22.6	13.6	27.1	1.72	0.69	32.85	19.71	39.28	90	1	E	1.3	0.32	10	1.2	8	0.4	8	0.4	517
36			c4 Multi - f	4	f	multi	4.6	2.76	5.52	3	28	16.8	33.6	0.24	0.72	19.17	23.33	46.67	68	2	A	2.5	0.54	18	2.2	14	0.8	14	0.8	56,547
37			c4 Multi - g	4	g	multi	3.5	2.1	4.2	3.4	23.3	13.98	27.96	0.37	1.26	9.46	11.1	22.2	68	2	B	4	0.5	17	2	13	0.8	13	0.8	22,619
38			c4 PA	4	f	pa	125.2	120.2	130.2	0.3	31.3	30.05	32.56	21.04	6.31	5.95	4.96	5.16	100	2	C	2.5	0.45	15	1.8	12	0.7	12	0.7	9,048
39			c4 Pulse - f	4	f	pulse	10.2	12.24	10.2	2.6	26.9	32.3	26.9	1.48	3.85	6.89	8.38	6.99	65	2	D	1	0.41	14	1.6	11	0.6	11	0.6	3,619
40			c4 Pulse - g	4	g	pulse	7.8	9.36	7.8	2.8	21.7	26	21.7	1.56	4.37	5	5.96	4.97	65	2	E	2.5	0.36	12	1.4	10	0.6	10	0.6	1,448
41			c3 Adv Acc	3	f		34.4	35.78	35.78	0.8	28.7	27.55	29.85	5.5	4.4	6.25	6.26	6.78	100	3	A	5	0.6	24	2.8	18	1.3	18	1.3	158,331
42			c3 Beam - f	3	f	beam	-	-	-	-	25.8	31	25.8	5.1	5.1	5.06	6.07	5.06	50	3	B	8	0.55	22	2.5	17	1.2	17	1.2	63,333
43			c3 Beam - g	3	g	beam	-	-	-	-	20.3	24.4	20.3	5.58	5.58	3.64	4.37	3.64	50	3	C	5	0.5	20	2.3	15	1.1	15	1.1	25,333
44			c3 Beam - t	3	t	beam	-	-	-	-	14.4	17.3	14.4	3.51	3.51	4.1	4.93	4.1	50	3	D	2	0.45	18	2.1	14	1	14	1	10,133
45			c3 Burst - f	3	f	burst	7.7	9.24	7.70	2.7	20.8	25	20.8	1.11	3	6.94	8.32	6.93	52	3	E	5	0.4	16	1.8	12	0.9	12	0.9	4,053
46			c3 Burst - g	3	g	burst	5.2	6.24	5.2	3.2	16.6	19.9	16.6	1.03	3.3	5.05	6.04	5.03	52	4	A	10	0.67	32	3.5	23	1.9	23	1.9	443,328
47			c3 Burst - t	3	t	burst	3.5	4.2	3.5	3.1	11	13.2	11	0.56	1.74	6.25	7.59	6.32	52	4	B	16	0.62	30	3.2	21	1.8	21	1.8	177,331
48			c3 Cannon - f	3	f	cannon	55.6	33.4	66.7	0.4	23.4	14	28.1	1.07	0.43	51.96	32.56	65.12	70	4	C	10	0.56	27	2.9	19	1.6	19	1.6	70,932
49			c3 Cannon - g	3	g	cannon	37.4	22.4	44.9	0.4	16.5	9.9	19.8	1.14	0.46	32.81	21.52	43.04	70	4	D	4	0.5	24	2.6	17	1.4	17	1.4	28,373
50			c3 Cannon - t	3	t	cannon	30.3	18.2	36.4	0.4	11.2	6.7	13.4	0.53	0.21	57.17	31.9	63.81	70	4	E	10	0.45	22	2.3	15	1.3	15	1.3	11,349
51			c3 Frag - f	3	f	frag	4.6	2.76	5.52	4.5	249.3	149.6	299.2	0.57	2.57	8.07	58.2	116.4	45	5	A	20	0.74	41	4.3	29	2.5	29	2.5	1,241,317
52			c3 Frag - g	3	g	frag	3.8	2.28	4.56	4.8	215.4	129.2	258.5	0.81	3.89	4.69	33.2	66.4	45	5	B	32	0.68	37	4	26	2.3	26	2.3	496,527
53			c3 Frag - t	3	t	frag	3	1.8	3.6	4	143.3	86	172	0.37	1.48	8.11	58.1	116.2	45	5	C	20	0.62	34	3.6	24	2.1	24	2.1	198,611
54			c3 Multi - f	3	f	multi	3.9	2.34	4.68	5.9	23.1	13.86	27.72	0.18	1.06	21.67	13.08	26.15	54	5	D	8	0.56	31	3.2	22	1.9	22	1.9	79,444
55			c3 Multi - g	3	g	multi	2.8	1.68	3.36	6.7	18.9	11.34	22.68	0.25	1.68	11.2	6.75	13.5	54	5	E	20	0.5	27	2.9	19	1.7	19	1.7	31,778
56			c3 PA	3	f	pa	83.4	80.06	86.74	0.3	24.2	23.23	25.17	13.6	4.08	6.13	5.93	6.17	100	6	A	40	0.82	50	5.2	35	3.2	35	3.2	3,475,688
57			c3 Pacifier	3	f		4	2.04	4.8	4.5	216	129.6	259.2	0.57	2.57	7.02	50.4	100.9	45	6	B	64	0.75	46	4.7	32	3	32	3	1,390,275
58			c3 Pulse - f	3	f	pulse	6	7.2	6	3	18.1	21.7	18.1	0.86	2.58	6.98	8.42	7.02	52	6	C	40	0.68	42	4.3	29	2.7	29	2.7	556,110
59			c3 Pulse - g	3	g	pulse	4.6	5.52	4.6	3.2	14.8	17.8	14.8	0.92	2.94	5	6.04	5.03	52	6	D	16	0.61	38	3.9	26	2.4	26	2.4	222,444
60			c3 Pulse - t	3	t	pulse	3.5	4.2	3.5	2.7	9.5	11.4	9.5	0.56	1.51	6.25	7.55	6.29	52	6	E	40	0.54	34	3.4	23	2.2	23	2.2	88,978
61			c2 Beam - f	2	f	beam	-	-	-	-	16	19.2	16	3.16	3.16	5.06	6.08	5.06	35	7	A	80	0.89	61	6.1	41	4	41	4	9,731,925
62			c2 Beam - g	2	g	beam	-	-	-	-	12.5	15	12.5	3.44	3.44	3.63	4.36	3.63	35	7	B	128	0.81	56	5.6	37	3.6	37	3.6	3,892,770
63			c2 Beam - t	2	t	beam	-	-	-	-	8.8	10.6	8.8	2.16	2.16	4.07	4.91	4.07	35	7	C	80	0.74	51	5.1	34	3.3	34	3.3	1,557,108
64			c2 Burst - f	2	f	burst	3.5	4.2	3.5	3.7	13	15.6	13	0.5	1.85	7	8.43	7	35	7	D	32	0.67	46	4.6	31	3	31	3	622,843
65			c2 Burst - g	2	g	burst	2.5	3	2.5	4.2	10.3	12.4	10.3	0.49	2.06	5.1	6.02	5	35	7	E	80	0.59	41	4.1	27	2.6	27	2.6	249,137
66			c2 Burst - t	2	t	burst	1.7	2.04	1.7	3.9	6.8	8.2	6.8	0.28	1.09	6.07	7.52	6.24	35	8	A	160		72	7.2	48	4.8	48	4.8	27,249,391
67			c2 Cannon - f	2	f	cannon	36.9	22.1	44.3	0.5	17	10.2	20.4	0.7	0.35	52.71	29.14	58.29	50	8	B	256		66	6.6	44	4.4	44	4.4	10,899,756
68			c2 Cannon - g	2	g	cannon	25.5	13.5	27	0.5	12.3	7.4	14.8	0.75	0.38	34	19.73	39.47	50	8	C	160		60	6	40	4	40	4	4,359,903
69			c2 Cannon - t	2	t	cannon	19.8	11.88	23.76	0.4	8.01	4.81	9.61	0.34	0.14	58.24	34.36	68.71	50	8	D	64		54	5.4	36	3.6	36	3.6	1,743,961
70			c2 Frag - f	2	f	frag	3	1.8	3.6	5	179.1	107.5	214.9	0.37	1.85	8.11	58.11	116.22	30	8	E	160		48	4.8	32	3.2	32
71			c2 Frag - g	2	g	frag	2.3	1.38	2.76	5.3	143.6	86.2	172.3	0.49	2.6	4.7	33.15	66.3	30
72			c2 Frag - t	2	t	frag	1.7	1.02	2.04	4.3	87.1	52.3	104.5	0.21	0.9	8.09	58.1	116.2	30
73			c2 Imp Ham	2	f		15	15	16	4.1	61.4	61.4	65.51	2.0*	8.2	7.5	7.49	7.99	48
74			c2 Mining Laser	2	f	mining	-	-	-	-	4	4.8	4	3	3	1.33	1.6	1.33	18
75			c2 Multi - f	2	f	multi	2.2	1.32	2.64	7.1	15.6	9.36	18.72	0.11	0.78	20	12	24	37
76			c2 Multi - g	2	g	multi	1.6	0.96	1.92	7.7	12.6	7.56	15.12	0.14	1.08	11.43	7	14	37
77			c2 Multi - t	2	t	multi	1.2	0.72	1.44	6.2	7.3	4.38	8.76	0.06	0.37	20	11.84	23.68	37
78			c2 PA	2	f	pa	54.3	56.47	56.47	0.3	17.18	17.18	18.62	8.65	2.6	6.28	6.61	7.16	100
79			c2 Pulse - f	2	f	pulse	3.5	4.2	3.5	3.4	12.1	14.5	12.1	0.5	1.7	7	8.53	7.12	35
80			c2 Pulse - g	2	g	pulse	2.7	3.24	2.7	3.6	9.6	11.5	9.6	0.54	1.94	5	5.94	4.95	35
81			c2 Pulse - t	2	t	pulse	2	2.4	2	3	6.2	7.4	6.2	0.33	0.99	6.06	7.47	6.26	35
82			c2 Pulse Disruptor*	2	f	pulse	2.8	3.36	2.8	1.7	4.7	5.6	4.7	0.9	1.53	3.11	3.66	3.07	35
83			c2 Rail	2	f	rail	41.5	41.5	44.3	1.2	50	50	53.35	5.11	6.13	8.12	8.16	8.7	48
84			c1 Beam - f	1	f	beam	-	-	-	-	9.8	11.8	9.8	1.94	1.94	5.05	6.08	5.05	18
85			c1 Beam - g	1	g	beam	-	-	-	-	7.7	9.2	7.7	2.11	2.11	3.65	4.38	3.65	18
86			c1 Beam - t	1	t	beam	-	-	-	-	5.4	6.5	5.4	1.32	1.32	4.09	4.92	4.09	18
87			c1 Burst - f	1	f	burst	1.7	2.04	1.70	4.7	8.1	9.7	8.1	0.25	1.18	6.8	8.22	6.86	20
88			c1 Burst - g	1	g	burst	1.2	1.44	1.20	5.3	6.4	7.7	6.4	0.24	1.27	5	6.06	5.04	20
89			c1 Burst - t	1	t	burst	0.9	1.08	0.90	4.8	4.2	5	4.2	0.14	0.67	6.43	7.46	6.27	20
90			c1 Cannon - f	1	f	cannon	22.5	13.5	27.00	0.5	11.3	6.78	13.56	0.46	0.23	48.91	29.48	58.96	35
91			c1 Cannon - g	1	g	cannon	15.9	9.54	19.08	0.5	8.3	4.98	9.96	0.48	0.24	33.13	20.75	41.5	35
92			c1 Cannon - t	1	t	cannon	12.8	7.68	15.36	0.4	5.56	3.34	6.67	0.22	0.09	58.18	37.11	74.22	35
93			c1 Cytoscrambler**	1	f		3.6	4.32	3.6**	7.6	27.4	32.9	27.4**	0.31	2.4	11.61	13.7	11.42**	1
94			c1 Enforcer	1	f		2.9	1.74	3.48	4.3	12.4	7.4	14.9	0.12	0.52	24.17	14.23	28.65	30
95			c1 Frag - f	1	f	frag	1.4	0.84	1.68	5.6	95.3	57.2	114.4	0.21	1.18	6.67	48.5	96.9	20
96			c1 Frag - g	1	g	frag	1	0.6	1.20	5.9	71.3	42.8	85.6	0.26	1.53	3.85	28	55.9	20
97			c1 Frag - t	1	t	frag	0.7	0.42	0.84	4.8	39.4	23.6	47.3	0.1	0.48	7	49.2	98.3	20
98			c1 Mining Laser	1	f		-	-	-	-	2	2.4	2	1.5	1.5	1.33	1.6	1.33	18
99			c1 Multi - f	1	f	multi	1.1	0.66	1.32	7.7	8.6	5.16	10.32	0.06	0.46	18.33	11.22	22.43	22
100			c1 Multi - g	1	g	multi	0.8	0.48	0.96	8.3	6.8	4.08	8.16	0.07	0.58	11.43	7.03	14.06	22