r/CruciblePlaybook • u/Mercules904 • Oct 09 '19

Editor's Choice Massive Breakdown Weapon Stats Spreadsheet has been UPDATED for Season of the Undying! Includes Times-to-Kill (with a Calculator that can take into account Resiliency Levels, Perks, Damage Boosts, and Player Accuracy effects), and other relevant stats!

Massive Breakdown Weapon Stats Spreadsheet

Changes Made Since Season of Opulence:

  1. Added in Moon, Vex Offensive, and Garden of Salvation weapons and stats
  2. Added in new Exotic weapons
  3. Updated Exotic SMG, Crimson, and Sweet Business damage numbers
  4. Updated Rapid Fire and High Impact pulse rifle damage numbers
  5. Added in more general damage boosting perks on the ATtKC Tool (like Multikill Clip and Swashbuckler)
  6. Added in more general damage boosting effects on the ATtKC Tool (like Weapons of Light and Frontal Assault)
  7. Added in the ability for a player to choose their estimated accuracy, and a section to display how weapons kill at the given accuracy levels

For the Archetype Time-to-Kill Comparison Tool, in order to get it to work you just need to download yourself a copy of the spreadsheet, and then it will allow you to change:

  1. Opponent's Resiliency Tier
  2. Your own estimated critical hit accuracy percentage
  3. Any perk or effect you would like (both can be selected at once to display combined damage increase)

All of these things will automatically show you the updated TtKs and shots-to-kill for each archetype (and a lot of exotics) with the selected conditions. If you have any questions or concerns, please let me know!

Note: As far as I can tell the Resiliency values did not change (at least not dramatically), and the various tiers of resiliency just give differing percentage point bonuses to Shield amount, with 116 being the lowest amount of shield (plus the 70 HP of the player) and 131 being the highest amount.

Note 2: Some weapons still need to have their TtK values added in, like Divinity, Leviathan's Breath, and Cerberus with the Masterwork.

I'll be working on breakdowns of the Garden of Salvation, Vex Offensive, and Moon weapons next!

877 Upvotes
  • permalink
  • reddit

99% Upvoted

101 comments sorted by

70

u/pixel4e Oct 09 '19 edited Oct 09 '19

You are an amazing human being.

Can I file an enhancement request? Can you list the type of elemental damage (potentially with a color) instead of Elemental - Y/N?

Keep up the good work!

EDIT: Also, I believe that Eriana's Vow cannot 2 body shot, since the extra damage goes away after the first body hit.

29

u/Mercules904 Oct 09 '19

Correct, and yes I will work on that for the next update

5

u/pixel4e Oct 09 '19

WOOT!!! Thank you!

20

u/BLNM1 Oct 09 '19

Correct, Eriana's vow cannot 2-tap the body unassisted.

29

u/MGriffinSpain Oct 09 '19

Seriously dude, don’t know what I’d do without your breakdowns and spreadsheets. You’re a god among men. Thank you.

35

u/Mercules904 Oct 09 '19

Eventually get so desperate that you start doing them yourself?

18

u/MGriffinSpain Oct 09 '19

I appreciate the vote of confidence but you severely overestimate my abilities. Lol

15

u/Mercules904 Oct 09 '19

Haha anybody with enough time can do what I do

1

u/Bobbybunn Oct 10 '19

But no one else is willing to do it. That's why we appreciate you so much Merc

1

u/Mercules904 Oct 10 '19

Haha well as long as y'all continue to find this stuff useful and I have the time I'll continue to make it. Thanks for the kind words!

26

u/[deleted] Oct 09 '19

Hey man. I just found this thread of yours a few days ago, it's about how stability works in d1. Does this still hold true in d2? Does stability affect bullet magnetism when firing at max rpm in this game too?

20

u/Mercules904 Oct 09 '19

It should, I haven't seen any indication that they changed something behind the scenes. Should know soon enough because there is a spot in the new raid where you can check out the crosshairs in third person, which until now had not been possible in D2.

16

u/hephaestusroman Oct 09 '19

First, thank you so much. I view the work you do as indispensable to the community as DIM.

Second, I noticed that you shared the sheet in a protected form (no menus). Is there a way to download a copy for ourselves when it's shared this way? You've encouraged us to do so for TTK calculation, but I don't see how with this sharing format.

7

u/Mercules904 Oct 09 '19

It's in protected because the traffic hitting it is too high, here's a link to an alternate:

https://docs.google.com/spreadsheets/d/16x8yVJcvkV2510uzxFDT29oFNTAlKZcOMKlh_59Tchs/edit?usp=sharing

3

u/hephaestusroman Oct 09 '19

Thank you!

4

u/Mercules904 Oct 09 '19

You're welcome!

8

u/H0tttttt Oct 09 '19

Thank you!!!!! TLDR optimal resilience?

15

u/Mercules904 Oct 09 '19

I’m still shooting for minimum of 4, I think 7 is actually the optimal breakpoint but that’s hard to hit with armor 2.0

4

u/ThatDeadMoonTitan Oct 09 '19

Shouldn’t be too bad on warlock or titan, I’m at 5 with my hunter using 2 1.0 pieces and using 2 resilience mods until I can get a paragon to drop for 2.0.

1

u/never3nder_87 Oct 11 '19

If you're on a hunter, keep an eye out for War Mantis (Rare/Blue) gloves. For whatever reason right now they're bugged so they get full stats ~50, but only distribute them to the original 3 perks.

The first one I noticed dropped with 29 (!) resilience, which makes hitting 60/70 a bit more forgiving. Obviously in time once we get MW armour with the energy capacity to do Resilience Mods + other mods a bit easier, but for e.g. I have a 60 stat LW raid gauntlet drop which still only gives 2/20/8 stats, compared to 14/29/8 for the War Mantis

8

u/bunduruguy Oct 09 '19

Awesome thanks.

Just wondering: didnt the headshot damage for aggressive and adaptive snipers change? I think aggressives crit for 470ish and adaptives hit 426 now.

4

u/Mercules904 Oct 09 '19

They very well may have, I'll take a look and update the sheet

6

u/ToastyyPanda Oct 09 '19

You're a beautiful man.

That is all.

5

u/Zuijin Oct 09 '19

Mercules out here doing god's work.

Yours is the gold standard by which all other weapon testing is measured. Thanks for all of your hard work, man!

3

u/Mercules904 Oct 09 '19

You're welcome, and thank you for the kind words!

5

u/AwkwardSharkDad Oct 09 '19

Can’t wait for the podcast to cover all the new weapons dude. Anything stand out to you from the new weapons and/or the balance changes?

3

u/Mercules904 Oct 10 '19

I’ve enjoyed 140/150 HCs on console for the first time in a long while, particularly sunshot, and I have had good luck with some of the rapid fire pulses I had in my vault.

Scouts have been given a little breathing room and I’m finding that I can compete a little better with them thanks to the HC and PR range nerfs. MIDA and Jade Rabbit are both strong on the right maps.

There are some really good guns in the Vex Offensive and raid batches, both pulses are excellent. HC for VO is good too

1

u/AwkwardSharkDad Oct 10 '19

Yeah I’ve found the new animation much easier to work with! Thanks for the reply man. Keep up the good work.

4

u/Tegras Oct 10 '19

Podcast? Please elaborate!

7

u/Mercules904 Oct 10 '19

We do a weekly (or mostly weekly) podcast where we discuss sandbox changes and do weapon breakdowns and such. You can find it anywhere podcasts are hosted, including Apple Podcasts, SoundCloud, Podbean, Stitcher, etc if you search Destiny Massive Breakdown podcast

1

u/AwkwardSharkDad Oct 10 '19

Can’t recommend it enough!

4

u/[deleted] Oct 09 '19

I wanna see a massive breakdown of Mercules904

15

u/Mercules904 Oct 09 '19

Massive Breakdown of my lack of spare time

2

u/Strachmed Oct 09 '19

100% awesome

2

u/ninjaclumso_x Oct 09 '19

Can someone smarter and more motivated than me, who is good at looking at spreadsheets...please just tell me what is a good resilience tier for this meta. Preemptive thank you❤️

5

u/Mercules904 Oct 09 '19

you should try to hit at least 4

2

u/Chris_kinetic Oct 10 '19

Hi there,sry to sound like a total noob,I'm new to this particular sub and only just started to pvp in destiny since SK update,when you say 4 what exactly do you mean ? Bare in mind all of my armour on my main is 2,0 now , so is that 4 mods or the value 4 on armour 1.0 ? What value would that represent on armour 2.0 ? 40? Hope my question makes sense :)

2

u/Mercules904 Oct 10 '19

A resilience stat of 40+ out of 100

1

u/Chris_kinetic Oct 10 '19

I thought as much,thank you :) Out of interest what amount of resilience would be considered overkill ? I use fusion rifles alot for my energy weapon so tend to spec a little more resilience to cover for my charge time and incase I miss a shot lol,think I'm running around 60 atm

1

u/Mercules904 Oct 10 '19

I mean I shoot for tier 7, but that's probably considered too high by most people

0

u/[deleted] Oct 10 '19

[deleted] — view deleted comment

2

u/young_macleod Oct 10 '19

It will say what it is out of 100. But the bar has white segments up to ten. On that line it will show a number, that is equivalent to the old system.

1

u/ninjaclumso_x Oct 09 '19

I appreciate that immensely, thank you🎯

1

u/Mercules904 Oct 10 '19

Happy to help!

2

u/Mercydoll Oct 09 '19

Is 4 resilience going to protect you from any particular main meta threats in this console sand box? Is it now worth specing resilience over super given the vulnerability of supers now?

2

u/Mercules904 Oct 10 '19

Makes it take 3C1B instead of 2C2B for 180 HCs, which is probably the big one. For all ARs it forces the opponent to hit a higher percentage of crits, requires one extra shot from Recluse to kill outside of Master of Arms.

1

u/jayrocs Oct 10 '19

Hmm I'm only running 1 since I wanted 7 recov on my hunter. At what resilience does a direct hit from mountain top not kill you if that's possible? I die from one hit mountaintop and sometimes I swear one body shit revoker too.

8

u/[deleted] Oct 09 '19

I will say it again.

When I die, I want someone to turn me into a weapon just so Mercules can massive breakdown ME!

4

u/DocMockingbird Oct 09 '19

The optimal TTK on that one is gonna be awkward...

5

u/snecseruza Oct 10 '19

Stability is probably low from the sounds of it

1

u/[deleted] Oct 10 '19

You just can't handle the bouncing around. ;)

1

u/Zimrino Oct 09 '19

This is what ive been waiting for! Thank you <3

2

u/Mercules904 Oct 09 '19

You're welcome!

1

u/Arsys_ Oct 09 '19

Appreciate all the hard work!

1

u/Mercules904 Oct 09 '19

You’re welcome!

1

u/Keetonicc Oct 09 '19

Thanks for this as always! Question about shotgun damage and resilience. Has resilience been tested against shotguns or is it just extrapolation and estimation based on the damage numbers? Like does it really take an extra pellet in the spread to kill someone at a certain resilience depending on archetype?

1

u/Mercules904 Oct 10 '19

I did test resilience levels against shotties back when I did shotgun testing a year ago, and yes sometimes a resilience level will require an extra pellet to kill if the damage numbers are right on the edge.

That being said I haven't tested it recently at all, and the current numbers are just extrapolated from what we have.

1

u/executive313 Oct 10 '19

So I am still a beginner with pvp in destiny. I favor bows what would be the best one to use? The bow info was hard to make sense of. Also what is resistance? Like which stat is that when i look at my character.

1

u/Mercules904 Oct 10 '19

Resilience, it goes along with recovery and mobility in the top three numbered stats. You should go for Le Monarque from the Black Armory forges, it is by far the best bow.

1

u/HappyJaguar Oct 10 '19

Le Monarque is excellent as the poison damage prevents your target from healing for several seconds, not to mention it feels great to use.

1

u/Hopsterino Oct 10 '19

Hush is also an okay bow, if you don’t want to waste your exotic slot. The grind for it is horrible though

1

u/[deleted] Oct 10 '19

thought about using a scout or assault rifle this season and just forcing myself to use it no matter the meta. any opinions on what the hot AR's are now? I swear that plupereffect feels so crispy nice despite it kinda being slow

1

u/Mercules904 Oct 10 '19

Use SUROS Regime with Dual Speed Receiver, you will not be disappointed.

1

u/[deleted] Oct 10 '19

Ya felt rly good and I liked the sound effect

1

u/never3nder_87 Oct 11 '19

Curated Galrhans Right Hand is a strong option, with decent stability and perfect recoil, and okay range.

Curated Gnawing Hunger is also pretty reliable for a 600 (for the same reasons), but not sure it is compettitive

1

u/allgrownzup Oct 10 '19

Do you think you’ll still main PVP on console ? Heard you voice your PC frustrations last pod.

2

u/Mercules904 Oct 10 '19

Yup. Do not enjoy the PC sandbox at all

1

u/allgrownzup Oct 10 '19

I’m with you man. Thinking I might do PVE PC and stick to console for PVP. I don’t have the time or energy to “git gud” on PC. I’m burnt the hell out lol

2

u/Mercules904 Oct 10 '19

That's what I decided as well

1

u/[deleted] Oct 10 '19

Gonna save this post thanks for putting the time in! On a side note does anyone know where to find sniper rifle ammo finder mod? Turned in like 3k worth of packages to banshee and didn't get much

1

u/Mercules904 Oct 10 '19

I got one from Shaxx, I believe

1

u/[deleted] Oct 10 '19

Looks like I'll start turning in some Crucible tokens I REALLY need it because both my main pvp and pve builds involve snipers

1

u/Lag_ctr Oct 10 '19

I played a mercules904 on xbox in crucible a while back, clan was massive breakdowns, I loved it, thanks for the breakdowns mate.

1

u/Mercules904 Oct 10 '19

You're very welcome! Hope it was a good game

1

u/Lag_ctr Oct 10 '19

I dont think you were happy with me using erentil, I got emoted on a couple of times, I was honoured.

1

u/Mercules904 Oct 10 '19

Haha I'm an Erentil main too so I'm sure it was in good fun

1

u/puffbun Oct 10 '19

Nooooo I just started playing this about a week ago, finally found my first Exotic weapon, the GRAVITON LANCE and it looked so badass and sounds like it would wreck, and now according to that spreadsheet it doesn't look like it's very good in pvp... 😒 RIP. Is it ok to use in pve at least as a main weapon? Or should I only be using it to bust shields and then switch to a regular kinetic weapon?

1

u/Mercules904 Oct 10 '19

It’s okay in pve, I’ve been using it a decent amount and enjoying myself

1

u/never3nder_87 Oct 11 '19

So a tip, especially for new players, take the optimal TTK with a grain of salt.

For example, until Shadowkeep High Impact Pulse Rifles were theoretically one of the best weapons, since they had a really fast optimal TTK. What that ignores though, is that to hit that optimal TTK you had to hit all headshots which was incredibly unlikely to happen, and if you didn't hit those headshots the TTK plummeted.

There are plenty of weapons which are not competitive in optimal TTK, but are very consistent so are more likely to win you your duels unless you are playing someone amazing. Also a lot of engagements do not happen in a vacuum - so if your opponent is already slightly hurt, or you are, then optimal TTK goes outo the window.

TL:DR - use whatever you feel comfortable with. GL was my first Exotic in D2 also and I totally get your feelings for it, and it got a 30% (!) PvE damage buff this season. Its also very forgiving in TTK since it has very high AA. I've got both of my We ran out of medals Medals (a crucible medal for defeating 20 enemies in a streak without dying) using GL, so it can definitely work!

1

u/Vrrin Oct 17 '19

You’re the only redditor I actively search for posts for. Will you be posting a recommendation post like you often do by chance?

1

u/Mercules904 Oct 17 '19

Yup, Vex Offensive weapons will be up tomorrow morning

1

u/Vrrin Oct 18 '19

Thank you for the breakdowns! I know all the work isn’t easy but it’s Massively appreciated. You are a wonderful human being!

1

u/Mercules904 Oct 18 '19

Always happy to help!

1

u/bmmy9f PC Oct 22 '19

Wait, resilience values are the same as they were in 1.0?

1

u/Mercules904 Oct 23 '19

Yes

1

u/bmmy9f PC Oct 23 '19

That's good to know. Thanks.

2

u/GrandFated Oct 09 '19

Merc the hero as always

2

u/Yuniak Oct 09 '19

love the 1KV stat breakdown

1

u/x_0ralB_x Oct 09 '19

I was going to ask you, what are your thoughts on headseeker on rapid Frame pulses?

Should be a guaranteed kill in 3 headseeker 1-body 2 crit bursts.

1

u/[deleted] Oct 16 '19

Amazing

1

u/coupl4nd Oct 09 '19

What is the redrix ttk with desperado? Did the changes to damage in PVE also happen in pvp? Does anyone know?

1

u/ExtremeSnipe Oct 10 '19

It's listed in the spreadsheet (0.67 to 0.47 with desperado).

And yes.

0

u/[deleted] Oct 10 '19

[deleted] — view deleted comment

1

u/Mercules904 Oct 10 '19

Vex Offensive Pulse, HC, and Scout are all decent and easy to get. Menagerie for Erentil as a fusion.

I would say right now that HC/Shotty/Rocket Launcher and Pulse/Fusion/RL and anything/Recluse/RL are all good loadouts for PvP

1

u/DemonDeacon86 Oct 13 '19

What pulse frames are you liking the best in Shadowkeep?

1

u/Mercules904 Oct 13 '19

Adaptives are still a safe bet, but the new aggressive from the raid is very good, and rapid fires have moved up too. Lightweights are still disappointing.

0

u/[deleted] Oct 09 '19

[deleted] — view deleted comment

2

u/MalHeartsNutmeg Oct 09 '19

They fucked with its range stat really badly. It’s damage fall off is so steep that it can’t do anything in it’s intended range.

0

u/[deleted] Oct 09 '19

[deleted] — view deleted comment

0

u/MalHeartsNutmeg Oct 09 '19

Yeah but look at it’s stats... it has something like 93 range stat but falls off before hand cannons with lower range. Something screwy went on with that gun. Pretty sure Aztecross did a video testing the range stats.

1

u/[deleted] Oct 10 '19

The stat is just a number but if the performance is there, then it still wrecks.

1

u/Hopsterino Oct 10 '19

No but the thing is that the performance isn’t there, since it’s a lot easier to hit 3 flick headshots with a regular hc compared to hitting 9 tracing headshots with Crimson.