XCOM Long War Beta 15a

	A	B	C	D	E	F	G	H	I	K	L	M	N	O	P	Q	R	S	T	U	V
1	About This Sheet									Variables
2	Use: Estimate the average number of full-duration interceptions required to down a UFO. 1) Go up to File and then "Make a Copy" in order to edit this sheet. 2) Input your variables in N2 through N12. 3) Match your weapon and alien UFO in the "# Encounter" table at K14. Caveats: 1) Sheet assumes full-duration encounters so aborting is not factored in. 2) Sheet does not model received damage, you'll have to learn this on your own. 3) Tracking Modules are not modeled, but they have the same effect as Elerium Afterburners. Basic Air-Game Advice: In my most recent Let's Play I got to December before losing a single country to panic on Impossible. The air-game strategy that I used is as follows: 1) Always go Aggressive until Laser + UFO Countermeasures, then always go Defensive. 2) Only attack Scout/Raiders in the beginning and Fighters (blinking) if you have Stingray. 3) Do not engage Destroyers (medium blinking) until Pen Weapons 4) Rush Laser. XenoBio->Alien Weapons->Beam->Adv Beam 5) Prioritize Seeker Autopsy and Advanced Aero Techs. 6) A Defensive Laser Cannon Interceptor with UFO Countermeasures & Improved Avionics will have a 50% to hit (with 0 pilot kills, up to 80% with 10) an alien UFO while said UFO will have a single digit chance to hit the interceptor in the early months. UFOs gain approximatly 3% to hit per month, but you can completely dominate small and medium UFOs with minimal repair time. I only keep 3 interceptors per continent and it's more than enough. 7) Skip Wingtip Sparrowhawks entirely and delay Armored Fighters until very late to save resources, it's just not needed with the above strategy unless you want to take on bigger UFOs.									Pilot Kills			0
3										Penetrator Weapons			FALSE
4										Improved Avionics			FALSE
5										Firestorm			FALSE
6										Super Capacitors			FALSE
7										Elerium Afterburners			FALSE
8										Analysis Complete			FALSE
9										Stance			Bal
10										Wingtip Sparrowhawks			FALSE
11										Cinematic (2nd wave)			FALSE
12										Enhanced Coilgun			FALSE
13
14										# Encounter	Scout	Fighter	Raider	Destroyer	Harvester	Abductor	Transport	Terror	Battleship	A Carrier	Overseer
15										Avalanche	1.4	3.7	2.7	20.3	69.1	82.6	72.2	97.1	271.8	241.6	145.5
16										Stingray	1.8	2.1	2.6	4.3	8.8	105.3	92.1	24.8	346.5	154.0	185.5
17										Phoenix	1.3	2.1	1.9	5.3	12.6	75.2	65.8	88.4	247.5	220.0	132.5
18										Laser	0.6	1.0	0.9	2.5	5.9	35.2	30.8	41.4	115.9	103.0	62.0
19										Plasma	0.3	0.4	0.5	0.5	0.9	1.8	1.9	1.5	11.8	4.5	19.0
20										EMP	0.5	0.6	0.8	0.8	1.4	1.7	1.6	2.0	7.8	4.9	5.9
21										Fusion	0.3	0.3	0.5	0.5	0.8	1.2	1.2	1.1	6.4	3.2	5.7
22
23	About The Author										1 Engage
24	Created by xwynns										2 Engage
25	Message me on Reddit										3 Engage
26	Check out my hyper-efficient, aggressive and rapid-action Long War Impossible series on Youtube										4 Engage
27											5 Engage
28
29
30	Advanced values and addition information below this line. It can be safely ignored. :)
31
32	Weapon	Range	Low D	Avg D	High D	RoF	Hit %	Pen	ID	DPS	Scout	Fighter	Raider	Destroyer	Harvester	Abductor	Transport	Terror	Battleship	A Carrier	Overseer
33	Avalanche	100	340	425	510	2	40%	0	3	Avalanche	89	36	67	9	4	4	4	4	4	4	4
34	Stingray	100	200	250	300	1.5	40%	10	2	Stingray	70	63	70	42	35	4	4	18	4	7	4
35	Phoenix	100	140	175	210	0.75	40%	5	1	Phoenix	98	64	98	34	25	5	5	5	5	5	5
36	Laser	100	290	362.5	435	1	55%	5	4	Laser	209	136	209	73	52	10	10	10	10	10	10
37	Plasma	100	650	812.5	975	1	40%	22	5	Plasma	361	341	353	341	341	205	171	290	102	239	34
38	EMP	100	310	387.5	465	0.55	30%	30	6	EMP	243	230	238	224	222	222	200	222	155	222	111
39	Fusion	100	1200	1500	1800	1.25	30%	26	7	Fusion	407	385	398	378	378	302	265	378	189	340	113
40
41	Ship	HP	Armor	ID	Speed	Engage T				DPS Time	Scout	Fighter	Raider	Destroyer	Harvester	Abductor	Transport	Terror	Battleship	A Carrier	Overseer
42	Scout	750	0	4	42	7.1				Avalanche	8.4	23.8	22.4	179.3	784.3	896.4	1120.4	1344.5	2016.8	1792.7	560.2
43	Fighter	850	12	10	40	7.5				Stingray	10.7	13.5	21.4	38.1	100.0	1142.9	1428.6	342.9	2571.4	1142.9	714.3
44	Raider	1500	5	11	32	9.4				Phoenix	7.7	13.3	15.3	46.6	142.9	816.3	1020.4	1224.5	1836.7	1632.7	510.2
45	Destroyer	1600	18	5	30	10.0				Laser	3.6	6.2	7.2	21.8	66.9	382.1	477.7	573.2	859.8	764.3	238.8
46	Harvester	3500	20	12	24	12.5				Plasma	2.1	2.5	4.3	4.7	10.3	19.5	29.3	20.7	87.9	33.5	73.3
47	Abductor	4000	30	6	25	12.0				EMP	3.1	3.7	6.3	7.1	15.8	18.0	25.0	27.0	57.9	36.0	22.5
48	Transport	5000	32	7	18	16.7				Fusion	1.8	2.2	3.8	4.2	9.3	13.2	18.9	15.9	47.6	23.5	22.0
49	Terror	6000	25	13	20	15.0
50	Battleship	9000	36	8	35	8.6				DPS:	Raw expected damage per second against target
51	A Carrier	8000	28	14	35	8.6				DPS Time:	Raw number of seconds for a kill. Color coding does not factor in time to close on target (Range stat)
52	Overseer	2500	40	9	60	5.0				# Encounter:	Adjusted number of encounters for a kill. Color coding DOES factor in time to close on target.
53
54	Interceptor	2500	5	1	10					Source: XGItemTree
55	Firestorm	4000	25	3	15
56
57
58		Advanced
59	C, D, E	Weapon Damage Column			d	Lowest possible damage (C), Average damage (D), Highest possible damage (E)
60	0-3	Crit Damage			1	Critical hit damage gain over base hit. 1=100%. 0.5=50%
61		Alien Tech Level			0
62
63
64	Values
65	3
66	5	Penetrator Weapons
67	10	Improved Avionics
68	5	Firestorm
69
70	5	Elerium Afterburners
71	10	Analysis Complete
72	15	Stance
73
74	15	Cinematic (2nd wave)
75