Jump to content
  • 0
Volt_Cruelerz

Damage 2.0 Spreadsheet

Question

Warframe PC Build: 11.8.0 (Surfaced Calculations update in progress though)

 

As many of you may know, I made a gargantuan spreadsheet for damage 1.0. I've been working on a new one for Damage 2.0, but I've been waiting for the storm to die down a bit and for us to get a better handle on the new mechanics before publishing it.

While it doesn't have quite everything yet, I feel I'm ready to put this out there.

In general there are some color coding elements that you should pay heed to if you intend to download a copy and keep it up to date (or if I fall off the map and someone else decides to maintain it instead).

Color Coding
- Blue: elemental statistic
Light Blue: non-elemental statistic
Red: resistance statistic
Green: Mods or other variable to be modified by the user
Yellow: holder statistic (columns containing these are hidden)
Dark Grey: calculated statistic
Red Berry: critical calculated statistic (these are all at the far right of sheet 1)

 

Terms Used

Physical Total: the total amount of physical (impact+puncture+slash) done by the weapon

Total Base: total base damage (physical+elemental)

Procs/Minute: the average number of status effects per minute (assuming no more than one proc per bullet in the case of rifles or trigger pull in the case of shotguns)

Proc Odds: the chance that a given ammo expenditure will impart a status on the target

Mag Life: the time it takes to empty the magazine when firing at the maximum rate

Crit Modifier: averaged effect of critical hits

Unsurfaced: the effect of a weapon's damage assuming a hypothetical enemy that took exactly 100% from all elemental types

Surfaced: the effect of a weapon's damage on a given enemy type (shield, armor, flesh, infested, or robotic)

DPS: damage per second; in the vast majority of cases, the main measure of a weapon's performance (exceptions include things like snipers and burst rifles which specialize in being able to kill the target very rapidly).

BDPS: when someone says DPS, they usually mean BDPS which is "burst damage per second."  BDPS is the average damage dealt to a target per second as long as the magazine lasts or assuming an infinite magazine.  Useful to determine rates of killing normal enemies.

SDPS: sustained damage per second; this is what happens when you start accounting for reload times.  Useful for determining the effectiveness against high-health enemies like bosses.

Average Damage: average total unsurfaced damage dealt per click.  Also known as "Ammo Efficiency."  Usually the secondary measure of a weapon's performance.
DPS Rank: the rank of a given weapon in regards to unsurfaced BDPS when considered from descending order.  Higher is better.
Ammo Efficiency Rank: the rank of a given weapon in regards to ammo efficiency when considered from descending order.  Higher is better.
Mod Efficiency: a measure of the amount mods have improved the weapon's Unsurfaced BDPS (final_UBDPS-initial_UBDPS)/initial_UBDPS)
Mod Efficiency Rank: the rank given as above only for mod efficiency.  Not displayed in any graphs as this is not a meaningful statistic in regards to how well a weapon will perform in-game.  It is only relevant for build development.
 

Damage 2.0 Spreadsheet

 

Best Equipment

Rifle: Soma

Sniper: Lanka (for single-target damage) or Snipetron Vandal (for general use)

Bow: Dread

Shotgun: Boar Prime

Primary: Boar Prime

Secondary: Brakk

Melee: Galatine

 

Sheets
1. Weapon Stats: Raw damage calculations (don't look at it unless you really want to see lots of numbers)
2. Graphs: contains graphs for DPS, ammo efficiency, and more
3. Rank Graph: meant as a general indication of which equipment is best. I have it set up to be such that higher is better.
4. Resistances by Element: shown in a way that closely matches the way the wiki displays them. Very human-readable.
5. Element by Resistances: used in internal calculations. Less human-readable.
6. Steve's Sheet: a sheet containing the implications of Steve's original system that he posted to the design council. The numbers may be very different than they were in that image, so this sheet is merely for posterity.

Regarding Mod Builds
1. I have chosen builds that in most cases attempt to maximize DPS.
2. Note that there are crit-based pistol builds, but as I found in Damage 1.0 in general, those are not any more viable than their traditional counterparts. I have not seen sufficient evidence thus far to adjust pistols as a whole to crit builds. That said, the Brakk and a couple others (Magnus perhaps?) may get a crit build once I get the chance to do the math.
3. If you don't like a build I have, please download a copy and toy with the green values to find a better build. Please respond in the thread with the reasons and the numbers that support your claim, preferably using the aforementioned "critical calculated statistics."

Known Issues
1. Some cells say "NEED DATA."  This is because I'm waiting on others to perform the necessary tests/datamining to determine what these stats are.
2. Elemental Procs do not factor into damage done. This is because we do not yet understand them well enough.

Other Notes
1. I will update cells that have "NEED DATA" as I become aware of what the numbers are.  If you'd like to expedite the process, you can post in the thread saying that one of the weapons with "NEED DATA" now has data and giving me a source.
2. If you notice an issue with my math that is not covered above, please let me know. Sans-rage is preferable.
3. Feel free to download a copy and play with the green columns to try out different builds. Beware that there is no prohibition on impossible builds!
4. If I don't update it for more than a month, someone can PM me. If I don't respond within a week, the person is free to take over and republish it on google docs so others can see it and so that it can be under their control. (Due to trolls, there's no way I'm just going to open up the spreadsheet for just anyone to modify.)
5. I base the statistics on what I find in-game and on the wikia. I try to avoid using the testing of others until I have verified it or they have submitted pictures/videos of it.
6. Some statistics cannot be accounted for without making assumptions about the conditions of the scenario! The Ignis and Ogris have AoE. The Miter and Glaive-type weapons can bounce.  Shotguns have falloff.  The Torid is off in its own little world.  The Gorgon, Supra, and Cestra have spool times. Accuracy is ignored.

7. Because I am a PC player, I will do my best to keep it up to date according to the PC build update schedule.  There is the possibility that information may be slightly off around the time of updates for PS4 players.  At the time of this writing, the Brakk's damage was reallocated today on the PC build.  I don't know and don't care to keep track of when this change will happen on PS4.

Current Status
- Weapons: waiting on dataminers/testers to find out the numbers for the nine remaining weapons.
- Abilities: incomplete

Edited by Volt_Cruelerz
  • Upvote 31

Share this post


Link to post
Share on other sites

Recommended Posts

  • 0

Thanks for the info.

 

Guess crit damage being wrongly displayed should be added to another thing that is wrong with the in game information displayed in the arsenal for weapons.  

 

I would have thought that crit damage would have been displayed correctly at the very least in the arsenal.

It probably just means that a different person wrote the UI code and didn't know how the in-game code worked so they went with the most logical one.  I originally used the same system, but was corrected after people pointed out just how absurdly OP any and all crit weapons would be if that were the case.

  • Upvote 1

Share this post


Link to post
Share on other sites
  • 0

Hate to double post, but since you brought this up, I figured I'd test it.

 

Soma without Vital Sense crits (with assorted damage mods) vs Infested: 218
With Maxed Vital Sense: 481

Non-Crit vs Infested: 72

 

6.6*72=475 (close enough to 481 to blame rounding)

 

218*(1+1.2)=481

 

Looks like you were correct after all.  I guess the testing I'd based it off previously was incorrect?  Weird.  Welp...  Soma wins...

Share this post


Link to post
Share on other sites
  • 0

I only noticed this when comparing your spreadsheet to dpsframe.com  since most other things lined up.  When I read your post I actually tried to contact Gogge who maintains the site to tell him of the potential error on crit numbers and how most of the crit based weapons would be wrongly calculated in this case.

 

Glad to see it helped in some way.

Share this post


Link to post
Share on other sites
  • 0

Updated to 11.3.0 as best I can.  Don't know the elemental distribution of the charge attack of the Dual Heat Swords or the Penta.  Waiting on those.

Share this post


Link to post
Share on other sites
  • 0

Updated to 11.3.0 as best I can.  Don't know the elemental distribution of the charge attack of the Dual Heat Swords or the Penta.  Waiting on those.

 

Hmm.  

Error in Bolto/Akbolto somewhere?

Final DPS number seem to have changed dramatically...

Share this post


Link to post
Share on other sites
  • 0

Hmm.  

Error in Bolto/Akbolto somewhere?

Final DPS number seem to have changed dramatically...

They got a huge buff this patch.  The numbers you see are straight from the Codex.

Share this post


Link to post
Share on other sites
  • 0

The boltor still reads 1.8/14.4/1.8 on the spreadsheet, could you update it to 2.5/20/2.5? I noticed that you updated several other weapons but this one seemed to of been over looked.

Share this post


Link to post
Share on other sites
  • 0

The boltor still reads 1.8/14.4/1.8 on the spreadsheet, could you update it to 2.5/20/2.5? I noticed that you updated several other weapons but this one seemed to of been over looked.

fixed

Share this post


Link to post
Share on other sites
  • 0

For anyone following this thread, I made my own spreadsheet that has all the basic equations built in that's up to date.

 

All you have to do is enter in easily obtainable information (weapon base stats and enemy armor values).

 

Here is link with better description.

https://forums.warframe.com/index.php?/topic/261845-dps-spreadsheet-found-here-includes-procs-and-armor-scaling/#entry3043420

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...