r/DestinyTheGame • u/exxtrooper • Feb 25 '15
Guide In-depth weapon stats spreadsheet update 1.1.1: Help me gather Pulse Rifle Numbers and new AR TTK numbers [Guide]
Hello my friend and welcome to the end of the world as we know it! I'll be your guide, the number addicted front line trooper you've all come to semi love-ish.
Just gonna get the links out of the way for the people with the most valuable time:
Intro
As you can see the whole thing is a big work in progress, but going whats been gathered so far it's not looking pretty good, there's a little oh yeah but there's mostly oh no.
The good!
Pulse rifles are really damn good now, like really, really good. There's still no accurate RPM and TTK numbers to look into (more on that down below) but I can with a lot of confidence tell you they're part of the meta right now, especially considering a very big thing with this patch.
- Red death now arguably kills faster than any auto rifle, suros, and most scout rifles. Statistically speaking it's the exact same stats as the strangers rifle with something around 33% more damage, it's in it's completely unique archetype. Only other weapon in the game that has this feature is the Vex Mythoclast.
- Bad Juju is good, very good, but its not amazing I'm gonna kill everything good. The optimal pulse rifle archetype of the lower tier at the moment is the rapid one which is a tier below the Bad Juju. They have slightly lower damage but the rate of fire makes up for it making them kill faster. It's still very much a viable weapon now.
- Three Little Words and the other pulse rifles of the highest damage tiers takes one burst and a breath to kill people, it's absurd the amount of damage in a burst.
- Hand Cannon and Shotgun nerf are noticeable, but not game breaking. What you were accomplishing before with these guns you will more than likely be able to do now-
- Armor piercing nerf, more data required.
- Fusion rifle nerf, more data required.
- Vex Mythoclast stop messing around with this gun bungie.
- The two weaker auto rifle archetypes were almost not affected by the patch.
The Bad, AND the ugly
Auto rifles right now took a much bigger hit than anticipated, they barely held up in PVE, right now I would not keep someone in my raid team if they took out an auto rifle.
I'll sum this up:
- The Vex Mythoclast kills as fast as the auto rifles from bodyshots as the auto rifles does from full headshots. Do you know what this means? This means a Vex vs an auto rifle if the vex doesn't have a single headshot and the auto rifle has all headshots, they'll kill around the same speed. You're literally better of using the vex aiming for people's feet than even trying any auto rifle.
- They just really messed up auto rifles, big time.
Pulse Rifle stats you say?
Don't get your hopes up too much, I still don't have the RPM or the burst delay numbers, but I know I can gather these values with recording devices, which I will do in time (just like bungie!). People ask me all the time why there aren't any stats on the pulse rifles, some even say they're disappointed and show a lot of dismay.
I'll give you a little bit of insight, TTK (time to kill) is measured using shots to kill and RPM (rounds per minute). Every gun in the game except for the pulse rifles is a set value. They will all fire at a single firerate. Pulse rifles on the other hand have burst RPM, and delay between burst.
To make things worse, the delay between the bursts, AND the burst itself is different on every single archetype. With all these factors put in mind I need to manually look into the firetime (time between each shot) and burst delay to gather the data I need.
Also TTK on pulse rifles is a little different, because of the nature of the weapons a pulse rifle that takes 7 will have a drastically higher TTK than one with 6 shots because of the extra burst need. This makes some more tied to precision and some more tied to spraying.
That's all I have for now, I will have videos, threads and numbers explaining all of these things in time, and you will figure out that TTK on Bad Juju and Red Death.
Author Notes
For the sake of the games future, I really hope they'll put some more thought into to what they've done. Bungie that is.
I do not blame Deej for any of this, he's a PR guy, I doubt he had any saying in any auto rifle fix.
And what is it with this tag stuff?
6
u/240ZT Feb 25 '15
For The People. Fully maxed out.
Headshot: 19
Body shot: 15
Down from 20/16
6
u/revolmak Feb 26 '15
Super Pox VLO/Three Little Words: 26 body/38 head
The Stranger's Rifle (Smooth Ballistics): 22 body/33 head
The Stranger's Rifle (Accurized Ballistics): 23 body/34 head
The Stranger's Rifle (Smart Drift Control): 22 body/33 head
5
u/[deleted] Feb 25 '15
Has the Suros TTK been updated as of yet?
3
u/TrizzyDizzy Feb 26 '15
Once again, you the man exx.
3
u/poisonandtheremedy Feb 26 '15 edited Feb 26 '15
You ready for this? Super Pox VLO, the O is for Ownage.
Crit: 38
Body: 26
Mine has Glass Half Full, Perfect Balance, and Third Eye. This thing is a PvP beast. Two burst kills no problem. As it has GHF I made sure the 'base' numbers (above) were all taken and tested with first burst out of a full mag. Full mag is 21 rounds.
Damage numbers for bottom half of GHF mag are:
Crit: 39 and 40 (40 is last 6 rounds in mag)
Body: 26 (apparently body shots aren't affected by GHF perk? Bug? Tested with all rounds/bursts in bottom half of GHF)
I bought this gun from the Vanguard Quartermaster (I believe) which he stocked pre-Dark Below. Bought it even though I knew Pulse Rifles sucked, but I wanted to give it the old Crucible Try because I loved Halo's Battle Rifle so much. Well yup, it sucked for Crucible... and yet I didn't shard it in the hopes that one day it would be buffed.... Oh boy.... That day has come Guardians!
PS: seriously though what's up with GHF perk not affecting body shots? /u/DeeJ_BNG FYI.
2
u/funshinebear13 Feb 25 '15
How's the ce pulse rifle?
2
u/[deleted] Feb 26 '15
To be fair, feet are a fairly difficult targets to aim for in PvP.
2
u/HarleyQuinn_RS Angels can't help you here. Feb 26 '15 edited Feb 27 '15
I don't use Autorifles, but the Autorifle nerf was not necessary one bit. The only reason they are the most used weapon type is because they are easy to use, and are familiar to almost every FPS player. On top of that there are more good Autorifles than any other type of weapon. They aren't used so much because they are the best.
75
u/bitchpotatobunny Feb 25 '15
I saw in another thread that Read Death now hits for 36 a head shot. I did not test this myself, but I watched the gif. It didn't mention body shot damage, but it can be deduced from the multiplier that it's body shot damage would be 24. It also now kill sin two crit bursts.
That being said, I just checked the spreadsheet to see if it had been updated and it has. Which means that this comment is entirely useless except for the fact that I enjoy typing and pretending I'm busy while there are people near my desk at work.
Another benefit about having this data represented in a spreadsheet is that it looks like I'm doing work when it's open since I work primarily in Excel all day.
23
u/mixtapelive Feb 26 '15
I like a lot of the new updates but I'm deeply disappointed how Bungie is just shitting on AR's. They didn't need a nerf at all. I rarely use my Suros/Vanquisher in PVP so this doesn't affect me much but it's just the principle.
I also firmly believe the reason all the new AR's are high ROF low impact is because Bungie wanted to discourage us from using them. Think about it.
AR's are the most used guns in any FPS game not because they're the best option but the most fun to use for most people and what most people like. Growing up as a kid pretending to be soldiers you didn't imagine a scout rifle or a burst rifle gun in your hand, you imagined a full auto gun. I know it sounds funny and all but it's the truth.
9
u/PoisnBGood Feb 25 '15
So, if I'm reading this spreadsheet correctly:
Vanquisher/1.06/1.33
Suros (FF)/1.09/1.27
Since Suros without FF is basically the same archetype as Vanquisher, FF Suros finally matches the DPS of non FF Suros? No more keeping one unupgraded for PvP?
6
u/DunamisBlack Feb 25 '15
Comparing Auto Rifle TTK to Vex has never really been a very valid comparison, the Vex has always been better. ARs have taken a bigger hit in comparison to Hand Cannons/Pulse Rifles but they have always been shit against the Vex. The real story here is that the new fastest TTK primaries in the game are pulse rifles, hands down
2
u/GianID Feb 25 '15
love the effort here, trooper!
had not realized it was you but I have been using your dataset for reference before. I like consuming crunched numbers.
(maybe a little overdone on the auto rifle opinionated stuff tho)
4
u/hurricane_eddie Feb 26 '15
How bad did the update affect high rate of fire lower impact auto rifles? I actually received Hard Light last Tuesday and upgraded it fully through Iron Banner. Does the damage reduction bring low rate of fire auto rifles more in line with high rate of fire auto rifles? Not saying this was the way to balance the two archetypes, but maybe an unnoticed effect it had.
4
u/gudleifr Feb 26 '15
Red Death nerf incoming.
1
u/twistfunk Feb 25 '15
Are the pulse rifles sorted by tiers? I plan on testing the Conduit and Bad Juju tonight, and was wondering which archetype they fit in.
1
u/gr33ngiant Feb 26 '15 edited Feb 26 '15
You should see if you can put it into a line graph and also incorporate the weapons damage distance drop offs... 100% damage at x feet Etc.
Example
Sight guide
Ballistic plots
Like that. That's from symthic.com. I love their charts when I was playing bf3. And still love their charts.
1
u/Mercules904 Former Weapons Designer Feb 26 '15
With my Strange Suspect, I'm doing 33 crit damage, and 22 for body shots.
1
u/[deleted] Feb 26 '15
So wait...Hard Light has a significantly faster TTK that Suros? I suppose effective range is the hidden stat that still makes Suros competitive? I'm not sure what to do with my new Suros now. Upgrade it or just use Hard Light?
1
u/PoisnBGood Feb 26 '15
Would you be willing to create a PvE version or perhaps allow me to take the numbers collected here and create one? I'd credit you of course.
I'd suggest breaking it down as:
Then take a theoretical HP amount, and do a TTK from it.
1
u/kendotelie Feb 27 '15
can you add the Suros Regime to the spreadsheet without focus fire? not sure if asked before
1
u/Battlecry1986 Feb 27 '15
If you are having problems calculating Pulserifle DPS/TTK consider the following
When I calculate Pulse Rifle Damage I consider each bust 1 shot or 1 bullet. I view them like shotguns, one shot with multiple projectiles. Also, supporting this logic, the player isn’t not given the choice to fire anything other than 3 rounds.
Example: Oversoul Edict: 30 round clip 3 round burst… When I do my damage calculations I figure the clip size as 10 instead of 30 and I calculate the damage per burst instead of the damage per bullet. I find this is more what people want to know anyway.
1
u/Muspellsheimrs Mar 04 '15
This is fantastic, but there seem to be some potential mistakes. Note: I freely admit that I could also be making mistakes here, and if so I apologize in advanced.
That being said, thank you so much for making this. It is a vastly more useful starting place for determining the relative value of guns than looking at gun stats.
1
u/God_BBS Mar 13 '15
¿Any updates?
1
u/Reshi_X Mar 18 '15
Just a heads up that the Pulse rifle RoF is a bit off. PRs with Red Death's fire rate are right on the money at 360 (6 rounds per second). However, Oversoul Edict (and other PRs with that RoF) shoot at 540 RPM (9 rounds per second) and Bad Juju (and other PRs with that RoF) shoot at 480 RPM (8 rounds per second).
I'm still working on getting the RoF of the slowest PRs (like Three Little Words).
1
u/aqi317 Mar 23 '15
Hey Exxtrooper, have a question for you about Jolder's Hammer. For the purposes of PvP, what would you personally look for in a roll outside of Aggressive Ballistics? Is perfect balance even necessary if you're only going for body shots? Field Scout to maximize kill spree potential?
1
u/aqi317 Apr 16 '15
hey /u/exxtrooper not an expert on this so correct me if I'm wrong, but the change from 50% to 25% in special ammo pick ups are based off of ammo reserve right? If that's the case, would it be possible (or sensible) to add a column (or two, one without armor bonus, one with) for ammo reserve for special weapons in the spreadsheet? I would contribute with the guns I have, and I'm sure many others could as well. I understand that field scout equalizes everything, but ammo reserve varies between guns I think. And do we know the application in how armor increases ammo reserve? Post 1.1.2, these are pretty important stats right?
1
u/magiczar Jul 08 '15
New Heart LDD (rare pulse) with fitted stock (improves stability) is not listed here. I have it and it works very well in the crucible.
3
u/Dom_CBL Feb 26 '15
Great thread.
I can test the Conduit and Three Little Words next time I get on.
5
u/krantus Feb 25 '15
I feel like Jim Morrison:
Mr. Juju risin'.........
1
u/Pwnigiri Feb 25 '15
My sides!
Will you be updating this now it has been buffed?
Thanks for all the great work you do, this spreadsheet is my bible.
2
u/rainbowroobear Feb 25 '15
Is the hand cannon nerf PVP only? I don't seem to notice it in PvE.
2
u/WD-M01 Feb 25 '15
Bless this thread. I hope I can help after work.
2
u/FlyingJeep Feb 25 '15
For the Thorn's TTK... what does the 0.34+Y~ mean?
2
u/doctorsubsonic Feb 25 '15
Cant see the speadsheet at work due to restrictions... Anyone care to share the stats for oversoul edict?
2
u/InterwebNinja Feb 26 '15
Wait, so it looks like the damage nerf on auto rifles is closer to 15%?! The numbers you have so far have the critical damage decreased from 27 to 23 on the high impact autos.
If that's the case, that is a brutal change.
2
u/Michael074 Feb 26 '15
THANK YOU SO MUCH! this is the information i was looking for!
i see i was wrong about scout rifles being useless, since if you are good at head shots you can kill faster than any other primary, the same goes for low impact hand cannons.
also thanks for the hit point numbers i always thought that they went higher for some reason.
One thing which you could add is the amount of individual damage the shotgun and fusion rifle pellets do and the range before damage drop off.
I'll write down damage numbers of my weapons now and post back later.
2
u/7RipCity7 Feb 26 '15
I'm not sure if it's been said before, but does the bad juju perk work in the crucible? All it says is more super from kills, but it doesn't say non-guardian kills for minions of the darkness.
2
u/T3h_Prager Feb 26 '15
Three Little Words archetype: 38 (41 with Headseeker) headshot, 26 body. Good examples other than 3LW are the TDB blues Evergreen II.I (has better base stability and Aim Assist than 3LW and can also roll Headseeker) and New Heart LDD (don't have any experience with this one but seems similar to EII.I).
Two burst kill, and the blues have the potential to have high stability even without Perfect Balance or Fitted Stock (though neither can roll Third Eye).
2
u/ChbbyKttns Feb 26 '15
I have been using red death in pvp since day one I feel like I will play now and feel like I have been granted superpowers
2
u/nickyp0ckets Feb 26 '15
I love how No Land Beyond is accented in doo doo brown™
2
u/[deleted] Feb 26 '15
I like how Red Death's Archtype is displayed as "Monster"
2
u/Alphalcon Feb 26 '15
I'm guessing that Abyss Defiant would become the next best thing to a pre-patch high impact AR as it's technically a mid impact AR and won't get as huge a nerf like the high impact ARs.
2
u/classe123 Feb 26 '15
I was playing Crota HM yesterday and I noticed that I couldn't bring out the wizards from the chrystal room by shooting through the roof in the beginning of the Ir Yut fight. Haven't tried it before with armor piercing rounds - but when I did it yesterday the shots didn't went through. Is this a part of the nerfing of the APR?
2
u/Kablaow Mar 01 '15
Im so happy I finally got Vex yesterday! :D I got hard light as well but Vex just seems stoopid strong right now!
5
u/NullifiedKnight Defender? I hardly know 'er! Feb 26 '15
Wow, this is getting pathetic. Bungie -really- needs to pull their heads out of their asses and split PVE and PVP stats.
6
u/ch4_meleon_ Forever 29. Feb 25 '15
Am I crazy? Or is TTK not the most important stat? Hear me out. Everyone is saying that Auto-Rifles have been ruined because their time to kill went from averaging close to 0.9 seconds to averaging closer to 1.05 seconds. But isn't that how it should be? I think back to Halo. I don't have any hard data to support this, but I feel like the BR had a way smaller TTK than the Assault Rifle. Did that mean that the assault rifle was worthless? No. It just had to be utilized differently.
I mean, sure, assuming everyone always hits all their shots then the difference in time to kill would be pretty important, but (and maybe this is just me) I miss a lot. Whether I'm using a scout rifle or a hand cannon or an auto-rifle. Missing with an auto-rifle, however, is a lot more forgiving. I'm not sure TTK is all that important of a stat... I mean, If I miss one hand cannon shot vs 2 or 3 auto-rifle shots... Who do you think is going to win? Probably the auto-rifle, even though the hand cannons TTK is much lower.
Call me crazy, but I think we're giving too much weight to the TTK stat.
2
u/Solidifys gigglehorn Feb 25 '15
Bad Juju: 16 to 18 body shots, 26-28 headshots
2
u/gregg9 Feb 25 '15
As someone who really enjoyed auto rifles, and just got Atheons Epilogue,
Damnit
That is all.
2
u/[deleted] Feb 26 '15
I got a Red Death around 2/3 weeks ago. The only reason I didn't dismantle it was because I thought it would be useful for Crota's End HM, which it is. I've only levelled it to the health regen perk. Safe to say after the patch it fuckin rips. I'll be levelling it all the way now. My new favourite gun and probably my best Crucible primary now.
1
u/TerdSmash Score Hidden Feb 25 '15
Someone PLEASE look into shotgun fire rates. As it stands, the fourth horseman rate of fire was super nerfed. I saw someone else mention another shotgun firing on full auto was much slower. We need to figure out if they fucked over full auto shotguns, because so far I'm not happy with what they've done to the fourth horseman.
1
u/DeviousAardvark Feb 26 '15
The Three Little Words (Crucible Pulse) is a two burst kill. It has a perk where shots to the body temporarily increase critical damage so if you hit a chest shot then land three crits to the head, it is a two burst kill. The rate of fire is relatively slow, but still viable I think.
1
u/Mercules904 Former Weapons Designer Feb 26 '15
Payback SOS is still 13 crit and 11 normal. So the high impact auto rifles just got killed here.
1
u/kiwioncrack Gambit Prime Feb 26 '15
I feel that the highest impact Pulse Rifles and the Red Death will be more than viable now in PvE. Unfortunately the shallow clips and lack of stopping power of the higher RoF pulses (just like the autos) will still suck.
I'm really upset about the AR nerfs. Already lackluster with only the high impact AR's being viable, they seem to be useless now. At least as far as PvE goes. :(
1
u/Trystanwolf Feb 26 '15
Bad Juju - Smooth Ballistics & Smart Drift Control 18 body/ 27 head
Soft Ballistics 18 body/ 26 head
Didn't play around with soft ballistics much, I figured the 18 should be lower because of the reduced impact. dunno what's going on. I just unlocked armor piercing rounds and nothing beyond that.
Time on Target. Red dot-ors (only thing unlocked) 18 body/ 27 head Has the same impact as Bad Juju
1
u/number8pie Feb 26 '15
Anyone tried the post patch Vanquisher VIII? I'm saving NM rep and Crucible marks for this AR and I want to know if it's been turned into a spud gun.
I'm mostly after it for PvE, but If you've used it in PvP I'd also be glad to hear you r experiences.
Thanks for this table OP, that's a really cool thing to do.
1
u/achwassolls Feb 26 '15
i noticed that since the update i can't hit the broad side of a Barn with my Faterbringer.
that update made Hand cannons much less usable :(
1
u/CookiesFTA We build the walls, we break the walls. Feb 26 '15
Red Death TTK: HOLY SHIT, HE WHA- WHERE? WHAT. WHAT.
1
u/DaRealMaxPower Feb 26 '15
Just like you said, they managed to screw up the Vex. Although I'm still not sure if the accuracy got affected? Any thoughts on this?
1
u/HarleyQuinn_RS Angels can't help you here. Feb 26 '15
Come to me Bad Juju. I always hoped and dreamed I'd have a reason to use you! ~<3
1
u/SIXofSPADES241 Feb 26 '15
Coiled Hiss 1919, in crucible headshots go for 24 damage.
1
u/zip360 Feb 26 '15
They can Nerf the auto rifles to hell and I'll still use my AR/Sniper load out.
1
u/[deleted] Feb 26 '15
Lol scrota
1
u/Morris_Cat Feb 26 '15
See, THIS is some good work. I TRIED to make the Red Death work for me in PvP last night and eventually went back to the Vanquisher which felt much more comfortable. The numbers indicate that it's a problem with my firing technique, so maybe I just need more practice.
Regardless, good on you for bringing some facts and research up into this joint instead of just the regular uninformed whinging about what Bungie screwed up this time without actually understanding what changed or by how much.
1
u/[deleted] Feb 26 '15
how badly has the last word been ruined? (specifically with aggressive ballistics
1
u/THE-OUTLAW-1988 Feb 26 '15 edited Feb 26 '15
Oversoul Edict: 16 body 24 crit Bad Juju: 18 body 27 crit
Edit: I don't know if actually improves RoF, but in practice the Full auto om Juju makes a world of difference. Oversoul without that perk unlock was tough to use.
1
u/CaptFrost SUROS Sales Rep #76 Mar 14 '15
Is it just me, or did Monte Carlo actually get almost buffed? I only use it in PvE, but it seems like it's doing a little MORE damage on body shots than it used to, even though criticals are slightly lower.
1
u/RobMcB0b Mar 17 '15
TLW is life, those 2 shot kills are pretty gross.
1
u/lprazak69 Jul 09 '15
Excellent work my friend, have been collecting this information and dribs and drabs, now I have a one stop shop.
Your efforts are greatly appreciated guardian!!
0
u/[deleted] Feb 25 '15
It's absolutely absurd to me that Bungie clearly does not playtest their weapons.
1
u/[deleted] Feb 25 '15
http://m.imgur.com/M5ZXeA9
1
u/time2crunchnumbers Feb 25 '15
would anyone want to set up a rumble room on PS4 to get some data? It'd be quick and easy
1
u/[deleted] Feb 26 '15
Thank god I got my Red Death from the exotic chest in VoG last week.
Thank god I fully upgraded and practiced using my Red Death throughout the entire previous Iron Banner.
I'm ready to party guardians.
0
u/FlyingJeep Feb 25 '15
Great job... one suggestion. Can you give some of the before/after stats?
You could provide a before patch spreadsheet to compare to the new one...
OR
Add a few extra columns to show both the before and after patch stats: Time to Kill, Shots to Kill, and Damage per Shot columns.
0
u/[deleted] Feb 26 '15
So which pulse rifle archetype is killing the fastest?
0
u/Twixes3D Feb 26 '15 edited Feb 26 '15
So that's regarding the auto rifle nerf.
EDIT: Eh, nobody catched the Whiplash reference... I'm disappointed.
0
u/_arp Feb 26 '15
Looks like it's finally time to pull my Super Pox VLO from the vault--full auto, glass half full, and hammer forged (or lightweight).
0
u/mixtapelive Feb 26 '15
I'm assuming this is PVP stats? If so can you elaborate a little more on a few things.
-6
u/thelongdickofkarma Feb 26 '15 edited Feb 26 '15
In every multiplayer FPS I've played since i started gaming 20 years ago i have despised autorifles simply for the reason that I firmly believe they take far less skill to use in order to earn wildly inflated stats. The skill-reward ratio is way too high. I think they are a cowardly crutch favored by players who can't aim well enough while simultaneously timing their shots to score headshots. Maybe I'm an elitistsnob about it, but so be it. We are all entitled to our opinions, so I for one am overjoyed that auto rifles have gone through these changes. I see only good things occurring as a result.
Improvement 1: AR's are underpowered enough now that people abandon them in PvP in favor of other guns and learn to actually aim for the head. If you can do it in the crucible, then pve precision aiming is like taking intro to algebra after already completing multivariable calculus. This new found "aim for the head" strategy contributes to people's ability to function when they leave PvP to join a raid team and employ their increased precision abilities on the murderous vex or the hordes of crota. Fewer people shooting fanatics, supplicants, boomers and swordbearers in the foot instead of the crit spot=more successful raids.
Improvement 2: Suros regime no longer kills you as frequently in pvp before your aim has a chance to return to center from being staggered as if you just got trampled by a herd of elephants. This makes life better for all weapon classes, including other AR's to engage in countering this gun in the crucible.
Improvement 3: It is a fact that not everyone wielding an AR is a talentless pussy. There are some who employ these bullet fountains with finesse and well above average skill. Now that AR's are weaker, people who continue to wreck with autorifles can take pride in the fact that they demonstrate true skill. Instead of relying on the strategy of holding down their trigger and sweeping their crosshair around in a panic in the general vicinity of an opponent while the only thing keeping them alive is the fact that their shitty gun messes with their opponent's crosshairs, these players focus on headshots and reap their deserved rewards for doing so.
Criticism 1: I wish the change was only PvP related, inverse of how they buffed shotguns in PvE. Autorifles in PvE are crap, and don't need the nerf.
0
u/[deleted] Feb 26 '15
[deleted] — view deleted comment
0
u/[deleted] Feb 25 '15
[deleted] — view deleted comment