Master Spreadsheet - Stats and Loadouts

Hey everybody, I have been working on consolidating and cleaning up my data repository for all stat related info for Warzone.

In the process of doing this (plus patch adjustments) I realized that a whole bunch of numbers won't do anybody any good. So I decided to add some form and organization to this sheet this way y'all will have something reference when either searching for a build, substituting attachments, or able to do an Apples to Apples comparison.

On the spreadsheet below under Optimized Master list you can sort and filter by any category by selecting the little wine glass in the top right corner of the Column header. For example: You can sort the weapons by fastest TTK, filter out Long Range options, and then filter weapons that exceed 325ms ADS time!

In the weapon category header you can select the "All-Purpose" "Long Range" ect and it will bring you to the sheet with the list of attachments. Then from the AR Builds sheet you can click the Weapon Category to bring you right to the weapon stats. This should be helpful to find relative data either stats or builds depending on how you want to search a weapon.

Future plan is to create a link directly to the XE Tactical build that talks about shows the TTK Chart, Pros/Cons! Thats in the works! For now, you can search a weapon, see the final stats, click the link to see the actual attachments used. All nice and neat.

I tell ya this will be an awesome tool for everyone.

Link Below:

https://docs.google.com/spreadsheets/d/1ujOeOInB3XIrBX2JSQ2MgLgeRx5O2n0waY_1vGt9IiE/edit?usp=sharing

 

MW Assault Rifles are complete and up-to-date. Going through CW ARs now --- then SMGs

 

SMGs have been added - Aug (MW) needs a second review for TTK.

 

LMGs have been added - The FiNN LMG I included the Chaingun Build under Short Range. Long Range and All Purpose builds are standard and "adverse" respectively.

 

OBD is now built into the weapons TTK - rule of thumb:

You TTK will be about .50ms faster if your gun is all ready firing. SO when reviewing TTK, keep in mind as you change targets your weapon will kill faster.... Looking at you Mac10.

 

Added Marksmen weapons - for organization sake Marksman Rifles and Tactical Rifles builds could be found on the same tab since they share similar uses.

 

Added Kar98, Spr 208, LW3 Tundra, and the crossbow - I have a little bit of data on the Pellington, Swiss, and Dragonuv, but I never actually used or tested the Big Sniper rifles. If anyone has any info on the ZRG, HDR, AX50

 

The shotguns have been added - never full tested them so the grading will be loose at best. But should be a good indication to know what is worth using

 

Fara has been reclassified as an All-Purpose AR. Still competitive in range but bullet velocity isn't there to make a true long range weapon.

 

Fara has been reclassified as an All-Purpose AR. Still competitive in range but bullet velocity isn't there to make a true long range weapon.

 

Update - I will be updating the sheet as soon as the vanguard guns merge. Until then happy hunting.

Love,
The Kitten

 

Vanguard AR / SMG base stats have been added

 

At this point there is not way the current weapon stats for Vanguard weapons will come over to warzone without creating a BO scenario all over again. I will update the sheet once the initial season patch launches. In the mean time I would keep an eye out on the Automaton, AS44, Combat Shotgun, 1928, and the Owen Gun... laugh all you want but the Owen Gun might sleep like an MP7

 

Im assuming the great rebalance patch will come out this week. Probably over two rounds so another the following week.

I will begin adding some Vanguard weapons to master list and adjusting several CW / MW weapons. There is still some information I havent be able to test or reconfirm because I think some attachments either are not working or work with only certain weapons.

There is another headache forming. Because on vanguard weapons you can increase/decrease the weapons rate of fire, coupled with damage modifications with lower or higher rates of fire, and combination of increased or decreased damage like vital, or aiming, or limb shots. There really is no way to create a true TTK - I know some modifiers are extremely marginal but there will be major disparity among builds. Here is an example of a same weapon having two wildly different TTKs:

Fear
Shots to kills:
9.000000
Time to impact:
0.001687
Damage on impact:
33.000000
Damage per second:
647.900000
Time spent firing:
0.382775
Time spend reloading:
0.000000
Total time to kill:
0.382775
+Modifier DoT 09.00000 -Modifier -02.000000 One Head Total time to Kill 0.312211

JGod
Shots to kills:
9.000000
Time to impact:
0.001993
Damage on impact:
31.000000
Damage per second:
499.616667
Time spent firing:
0.496381
Time spend reloading:
0.000000
Total time to kill:
0.496381

-Modifier -02.000000 One Limb Total Time to Kill: 0.544611 One Head Total time to Kill: 0.398381

AceShots to kills:
8.000000
Time to impact:
0.001333
Damage on impact:
34.000000
Damage per second:
693.900000
Time spent firing:
0.372775
Time spend reloading:
0.000000
Total time to kill:
0.366577
Modifier 01.000000 One Head Total time to Kill 0.366577
The cleanest way to see results is usually Shots to Kill - problem is two weapons can have equal shots to kill but wildly different TTK speeds. Thats why you see alot of folks arguing in comments or reddit about why a shitty gun is just as good but its not. A LC10 is 10 shot kill but so is a holger, the lc10 has double the rate of fire therefore it kills twice as fast. Its a fundamental I never understood how people never understand it. But Vanguard you are taking the same weapon, not changing the shots to kill, but getting wildly different time to kills. In the above example, there are ton of factors not available but c'mon why would you not choose a .382 TTK over a .496?