AB
1
2
Destiny 2 PvE Legendary Weapon Damage Generator
3
Spreadsheet created and maintained by RokDC and Maeix - Contact at the bottom
4
5
6
Version:3.0
7
Most recent version available:3.0
8
9
Link to the original sheet for updates:https://docs.google.com/spreadsheets/d/1rY_iChu08CVnIMfHliZQwup10-GnmPtEu5FG0DNy8VM/edit?usp=sharing
10
Hyperlink to share the sheet: https://destiny2.science/damage-generator
11
Get started You can browse the public version of the spreadsheet. For full access to the sheet and all of its features you need to make a personal copy.
(File > Create a copy; Google account required)

Your personal copy will notify you about future updates.
Please do not request access to the original spreadsheet.
12
v3.0 NewsHello everyone,

after a while of no updates (last one was the tentative TFS update), I finally got around to bringing the sheet up to date - BUT I had to make a couple of minor and major changes to the spreadsheet that I want to talk about:

The elephant in the room is maintenance requirements versus available time. The sheet grew a lot over the years to a point where it wasn't really bearable anymore to spend the first two days of every content release on Zulmak damage testing. The main culprit here is the increasing number and complexity of exotics - Since many of them don't follow the rules of the default archetypes, getting their data requires a lot of manual data collection, their often unique behavior also requires a lot of mental gymnastics to make them fit our framework and damage model. I therefore made the hard decision to omit Exotics entirely from the spreadsheet and focus on legendary weapons that work way better with our modular system.

In return, I wanted to expand on said modular system - This means less manual data collection and more formulas, allowing for a more versatile system:

- Reload times are now accurately calculated using reload formulas instead of being manually measured. This allows for more options regarding reload perks, mods or exotics.

- Magazine and Reserves now include a base value and a max value thanks to Mossys exhausting data, which also allows for more user interaction.

- RPM is also customizable but it only really affects Cascade Point and Adagio

Which brings us to the crafting feature - I also omitted curated rolls from the sheet as they were pretty arbitrary. The old version only allowed for one crafted weapon at a time in the Database and the UX wasnt really nice since you had switch between pages. Crafting is now baked in to the Database, which should make it a lot more pleasant and accessible to use. There are also many new perks available thanks to the more modular approach described above.

Damage testing will from now on be performed in a two-way setup on Kalli and the Enclave instead of Zulmak, Zulmak was a historic decision shortly after sunsetting was announced but as it turns out, Last Wish was not the next raid on the chopping block :)

***

Some features of the old version are still missing, most importantly the damage over time graphs (the staircase visualization) - I'm working on implementing it for the new version.

Expect some bugs or minor mistakes, I had to rebuild the sheet almost from scratch, i'll work on fixing them asap. I appreciate any message pointing me to things you found.

The old pages including the old Database with all Exotics are still available as hidden pages. They will remain in TFS launch state but can be accessed for now

***

Cheers,
Maeix
13
You can find a tutorial on how to use this spreadsheet on YouTube (outdated)
14
RokDC and this spreadsheet on PvE: Podcast Versus Enemies
15
16
Spreadsheet Overview
17
DatabaseCentral HUB - Includes all Special and and Heavy Legendary Weapons, their base data and various Damage metrics
18
Main features- Select an encounter for discrete damage output
19
- Apply global modifiers regarding magazine size, reserves or reload speed
20
- Sort and Filter by many parameters
21
- Apply Buffs and Debuffs to the calculations
22
- Craft weapons by selecting Element and Perks
23
Buffs/DebuffsAdvanced buff/debuff stacking calculator, can be applied to the 'Database'
24
Damage ChartVisualisation of Damage and DPS of all weapons in the database
27
28
Changelog
29
2024-10-27 v3.0Rework of the spreadsheet including removal of any exotic weapons and addition of new features - See more in the v3.0 News above
30
2024-06-06 v2.7Tentative Update of the Database based on the Patchnotes for Final Shape - In-game testing will take place after the Raid race; Visual comparisons have not been updated yet nor has the Scaling feature
31
2024-05-16 v2.6.5Various Hotfixes (thanks to users crossboy and reichembach on Discord); Adjustements/corrections
32
2024-04-18 v2.6.4Into the Light patch; GL Impact changes; Micro-Missile frame added; 1KV reserves
33
2024-03-15 v2.6.3Implementing undocumented changes to special GLs; Unclear if intended from Bungie, might get rolled back/fixed at any time
34
2024-03-06 v2.6.2Hotfix for Update 2.6.1; Anarchy ticks, Wendigo, Backend stuff
35
2024-03-06 v2.6.1Midseason patch for Season of the Wish; Rocket and HGL Reserves, Spike Grenades; Misc;
36
2023-11-29 v2.6Season of the Wish launch update; Swords; Glaives; New Exotic; Misc
37
2023-09-17 v2.5.1Sword update; Updating combos and resulting damage values after the charge time changes; Adding in recently added sword archetypes; Addition of Crota's End encounters
38
2023-08-24 v2.5Season of the Witch patch; New exotic weapons and reserve changes
39
2023-06-25 v2.4Catch-up update for timelines and Buffs and Debuffs, now up to date with Lightfall and Season of the Deep sandbox changes
40
2023-05-31 v2.3Provisional update for Season of the Deep; Includes weapon changes; Timelines (Visual Comparison) not updated yet; Buffs/Debuffs still not updated
41
2023-04-28 v2.2.3Implementing mid season patch - Reserve changes; Trace rifle precision multiplier changes
42
2023-04-05 v2.2.2Hotfix; Corrected Scaling for SoW and RoN
43
2023-03-19 v2.2.1Addition of new LF exotics and catalysts, addition of RoN encounters, Updated timelines
44
2023-03-03 v2.2Provisional sandbox update of the database (Lightfall launch); New Scaling for master content
45
2023-02-05 v2.1.2Several hotfixes/tweaks; Replacing Inteference VI with Wendigo GL3; Some backend preparations for Lightfall release
46
2022-12-22 v2.1.1Several hotfixes over the last couple days; addition of Target Lock to the crafting feature - happy holidays everyone
47
2022-12-12 v2.1Season of the Seraph sandbox changes, ending beta phase of the scaling feature
48
2022-11-26 v2.0.1 (beta)Various improvements / additions / hotfixes to the new encounter scaling feauture, addition of elemental burn modifiers to the Buffs/Debuffs section
49
2022-11-25 v2.0 (beta)Implementation of a damage scaling feature that includes power level scaling as well as damage and precision modifiers from all bosses. Feature is in beta state, please contact us for any corrections/bugs. Scaling is based on Mossys findings, see 'How to use'
50
2022-10-20 v1.13Mid-season patch 6.2.5 (LoW buff); Fixes to the interaction of Boss Spec and the Crafting feature (via Fading Shadow)
51
2022-09-18 v1.12Few minor corrections (Izanagi Reload, Rocket visual RPM)
52
2022-09-12 v1.11Updated patch notes numbers with actual ingame testing (small deviations); Updated Lament (new combo); Addition of Thunderlord Catalyst; Addition of Delicate Tomb
53
2022-08-24 v1.10Updated for Season of Plunder; Trench Barrel on Acrius (Please check 'How To Use' for details), Heavy GL buff (Intended for 10%) and more; New curated RL rolls, corrections to Trace RPM. Thunderlord Catalyst and Delicate Tomb will follow in a later update
54
2022-07-21 v1.9.7Hotfix thanks to feedback - Additional Legend of Acrius damage instance (via Darkflameo), Tractor Cannon adjustments and some background changes
55
2022-07-21 v1.9.6Implementation of patch 4.1.5 (Solstice) - Stormchaser nerf, Pellet shotgun buff and more
56
2022-06-04 v1.9.5Few Hotfixes, Addition of Heartshadow (via azmatr4z)
57
2022-06-04 v1.9.4Addition of the new Radiant buff, Addition of Aggressive LFRs and Stormchaser
58
2022-05-25 v1.9.3.1Quick hotfix for some issues that slipped through the last one, updated Ager's Scepter and corrected the Rocket Launcher values. Apologies for the double update.
59
2022-05-25 v1.9.3Updated to Season of the Haunted Weapon Sandbox, Corrected Forerunner to use Headshot Value (Thanks Jay), Prometheus DoT is currently ignored due to bug. Timelines are not up to date, as such visual comparison will be incorrect until a later update.
60
2022-04-28 v1.9.2Magazine and reserves QA, correcting some values
61
2022-03-15 v1.9.1Hotfix for the interaction of Weaken and Divinity (Weaken does not override Divinity anmyore); Some corrections based on feedback
62
2022-03-12 v1.9Addition of a weapon build / perk selection feature ('Crafting'); replaces most curated rolls. Implementation of patch 4.0.0.3 as well as more undocumented sandbox changes (via CourtRoom)
63
2022-03-02 v1.8.2Hotfix for an issue where applying buffs would cause an error on rocket launchers; Changed Wardcliff Coil values caused by an undocumented change (rollback in v1.9)
64
2022-02-27 v1.8.1Changing Bannershield to 40% in the buff calculator (via CourtRoom)
65
2022-02-26 v1.8Implementation of patch 4.0.0.1 (Witch Queen) - Addition of new exotic weapons and the Glaives, other weapon sandbox changes as well as changes to buffs and debuffs. Curated rolls inlcuding crafting will follow after the raid weapons are released.
66
2022-01-16 v1.7.2A number of cosmetic changes; Addition of Arbalest catalyst (+1 in the magazine)
67
2022-01-12 v1.7.1Hotifx for the Buff/Debuff redirection which linked to the tab in the original spreadsheet instead of the tab in your copy before
68
2022-01-10 v1.7Adding an advanced Buff/Debuff selection tab that can be applied to the Database. Buffs and Debuffs are now opt-in. See 'How to use' for more information
69
2021-12-14 v1.6.1Seperating Particle Deconstruction and Divnity Stacking into 2 seperate toggles; Gradients in the Database tab are now colorblind friendly; Minor adjustments to some values
70
2021-12-10 v1.6Implementation of patch 3.4.0 (Gjallarhorn, Wolfpack Rounds, LFRs, Shotguns, Vorpal etc.)
71
2021-10-18 v1.5.3Addition of Reed's Regret with Firing Line now that the perk is fixed. Note that Reed's Regret does not work with Focusing Lens in a Well of Radiance as it is a stasis (=/= light) weapon. Addition of Canis Major with Vorpal as a slightly inferior but more consistent alternative to Full Court on a Grenade Launcher.
72
2021-09-24 v1.5.2Addition of Ager's Scepter (Will Given and normal mode), Replacing Hezen Vengeance with Ascendancy now that Explosive Light is fixed
73
2021-09-08 v1.5.1Implementation of the artifact mod 'Particle Deconstruction' as a toggle (opt-in)
74
2021-08-26 v1.5Implementation of Season of the Lost sandbox changes (Patch 3.3.0), addition of Lorentz Driver
75
2021-07-24 v1.4.4Reload timings QA - Checked all measured reload timings against the reload formulas and doing small adjustments where necessary; Addition of Trace Rifle mods
76
2021-07-15 v1.4.3Addition of Uzume RR4 (Replacing Adored)
77
2021-07-15 v1.4.2Addition of the 'Damage Chart' diagram
78
2021-07-10 v1.4.1Implementation of mid-season patch 3.2.1 (Sleeper buff etc.), addition of several new weapon rolls (Crownsplitter, VoG weapons). Changed default database sorting to 'Optimized DPS'
79
2021-05-12 v1.4Implementation of Season of the Splicer Sandbox changes (LFR Buff, Vortex and Lament Heavy nerf)
80
2021-05-01 v1.3.5Hotfix 'Optimized DPS' for some specific perk/weapon combinations; Addition of Royal Entry with Clown Cartridge
81
2021-04-30 v1.3.4Addition of 'Optimized DPS' metric (ending on the last full magazine); Intermediate calculations for the discrete encounter damage are now hidden by default.
82
2021-04-11 v1.3.3Minor adjustments/corrections to some damage models; Addition of Frozen Orbit, Salvager's Salvo
83
2021-04-10 v1.3.2Addition of curated weapon rolls with new perks (reconstruction, lasting impression); Adjusted slug shotgun total reserves (from 16 to 20)
84
2021-04-02 v1.3.1Sword update; sharpening some assumptions and improving some rotation models for swords for more precise values.
85
2021-03-31 v1.3Implementation of Season of the Chosen Sandbox changes (RL and Swords) as well as addition of all missing post-DSC release exotics
86
2020-11-27 v1.2.3Updated all damage values for BL (Most moved by tiny fractions due to rounding, others seemingly silently nerfed, rocket launcher impact damage especially). Added Thunderlord adaptive RPM and lightning damage. Updated Prospector to include DoT (Thanks to user Marblewight for noticing the error and letting us know)
87
2020-11-26 v1.2.2Addition of BL Exotics, updated how to use for those exotics. Added approximate Taniks duration as a boss encounter.
88
2020-11-18 v1.2.1Addition of Adored
89
2020-11-18 v1.2Implemented BL Sandbox Changes (Rocket Launcher Reserves, Merciless Reserves, Vortex Frame Heavy Attack, Leviathan's Breath Catalyst)
90
2020-11-02 v1.1.1Adjusted Boss Spec Mod to 7,768% (was 8%)
91
2020-10-30 v1.1Public release
92
2020-10-27 v1.0.4Addition of the Izanagi's Burden / Auto-Loading Grenade Launcher combination, Addition of 'How-To-Use'-tab, Addition of Caster Frame swords
93
2020-10-24 v1.0.3Addition of selected Swords, Addition of 'Sustained DPS'
94
2020-10-22 v1.0.2Addition of selected legendary 'god rolls' (marked blue); Addition of selectable Boss Spec for legendary weapons
95
2020-10-16 v1.0.1Addition of selectable raid encounters
96
2020-10-15 v1.0Private release
97
98
Upcoming fixes / additions / To-doFeatures we want to implement, no ETA
99
Visual comparisonDecrease visual intervals for the graph to 0,1s
100
101
Disclaimer /
Remarks
All data got collected manually and therefore can include mistakes like false values or information. If you happen to notice one, please contact us! Some of the parameters are relatively hard to determine precisely and we obviously can't guarantee them to always be correct. As most of the data on timings got determined using frame counting on 60fps recordings, the general margin of error is 16.66ms. This is even more of an issue as some of the values listed in game turned out to be misleading or straight up wrong. (Example: Truth is listed as 15 RPM while it actually is 45 RPM). Even the slightest change in values or assumptions can cause significant movement among the rankings so judge the weapons with caution and common sense and don't blindly rely on this spreadsheet.
102
Some (exotic) weapon mechanics exceed what the formulas can handle and therefore got slightly simplified. Read more on those cases in the 'How-To-Use'-tab