Division DPS Calculation Spreadsheet

	B	C	E	F	G
1
2			Guys, be sure to check out my youtube channel for a full description of this formula (both short and long version):
3			Note:	This sheet is locked. To use it, copy and paste it to another sheet
4			Video Explanation:	https://www.youtube.com/watch?v=qeR0aMDEL-Y
5			My channel:	https://www.youtube.com/channel/UCZ7AeeVbyslLM_8-nVy2B8Q
6
7
8	Enter your values here:		Read your DPS story Here
9
10	Weapon Dmg	8724	I have a gun that does	8724.00	damage per bullet
11	Headshot Chance	0
12	Bonus Headshot Dmg	2	I have a % of bonus headshot dmg, which I convert to	2.00	bonus headshot dmg
13	Crit Chance	0.2	When I land a headshot, I do	17448.00	damage per headshot
14	Bonus Crit Dmg	1.5
15	RPM	950	I have	0.00	accuracy rating
16	Reload	1.9	The game assumes I have an	0.00	chance to land a headshot every time I fire
17	Mag Size	40	I can fire	40.00	bullets in one mag
18	Enemy Armour Dmg	0.3	Based on this, over the course of one mag,	40.00	of my bullet are not headshots
19	One Is None' Talent?	0.5	That means that the remaining	0.00	bullets are headshots
20	^Enter as either '0' or '0.5', where 0 is no talent and 0.5 is talent enabled		The One is None talent buys me an extra	0	bullets per magazine
21	Adjusted Mag Size	40.00	My adjusted magazine size is	40.00	bullets
22	^Do not touch the 'Adjusted Mag Size' field		My adjusted non-headshot bullet count is	40.00	bullets
23			My adjusted headshot bullet count is	0.00	bullets
24	Recursive 'One is None' workings
25	Total bullets	Extra bullets	I have	0.20	chance to crit
26	40	0	I have	1.50	bonus crit dmg
27	0	0	When I crit with a non-headshot, I do	13086.00	non headshot dmg
28	0	0	When I crit with a headshot, I do	21810.00	crit headshot dmg
29	0	0	Based on my crit chance,	8.00	of my non-headshots will crit
30	0	0	Based on my crit chance,	0.00	of my headshots will be crits
31	0	0
32	0	0	Over a space of	40.00	bullets (my adjusted mag size)
33	0	0	I will do a total of	32.00	non crit, non headshots
34	0	0	I will do a total of	0.00	non crit headshots
35	0	0	I will do a total of	8.00	non headshot crits
36	0	0	I will do a total of	0.00	crit headshots
37	0	0
38	0	0	In damage terms
39	0	0	I will do a total of	279168.00	non crit, non headshot dmg
40	0	0	I will do a total of	0.00	non crit headshot dmg
41	0	0	I will do a total of	104688.00	non headshot crit dmg
42	0	0	I will do a total of	0.00	crit headshot dmg
43	0	0
44	0	0	In total, over a magazine (cycle) I will deal	383856.00	damage
45	0	0
46	0	0	I have a gun that fires at a rate of	950.00	RPM
47	40		I takes	1.90	seconds to reload
48			It has an adjusted mag size of	40.00	bullets in its mag
49			It can fire	15.83	bullets per second
50			It takes	2.53	to dump its full mag
51			To dump the mag and reload takes	4.43	seconds (cycle time)
52
53			In PVE, per second I will deal	99729.53	damage
54			In PVE, excluding reload speed, per second I will deal	174734.45	burst damage
55
56			PVP DPS after modifier	36422.96	damage
57			PVP Burst DPS after modifier	63816.06	burst damage
58
59			PVP DPS after modifier and armour	24822.25	damage
60			PVP Burst DPS after modifier and armour	43490.64	burst damage
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