ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
The Great Big Comprehesive Ultimate Exhaustive Arsenal 26 and Britas Weapons Spreadsheet
2
The Formulas Used
3
Important Notes
1. All Weapon Data is taken as is from the script files included in the mods packages themselves
Hit Chance: Weapon Hit% + (Aiming Perk Hit Chance Modifier x Aiming Skill)
4
2. Damage Calculations have been done by Us and all errors therein are our own
Hit Chance is capped at 95%*
*The Sniper perk gives a flat 20% to hit chance and is added after the 95% cap is imposed making it the only way to reach 100% hit chance
5
3. All future updates will be provided using a "Nos illuc cum illuc" framework
6
Planned Future Updates
Ciritcal Chance: Weapon Crit % + (Aiming perk Critical Modifier x (Aiming Skill/2)) + (Aiming Skill x 3)
7
Include information on the interaction of range and damage
Critical chance cannot exceed 90% and cannot be less that 10%
8
Include information on how moodles affect firearm performance
9
Edit Hit Chance Calculations to account for Sniper going over the 95% cap
Damage Per Shot: Hit Chance x (Average damage + (((Average damage x (Critical Modifier - 1)) x Critical Chance))
10
Weapon Builder Section Below
Weapon By Caliber Section
11
12
13
Guns:Data 1data 2data 3
14
Index functionVLOOKUP)
15
b
16
c
17
d\
18
19
20
21
22
23
24
25
26
27
28
29
30
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