Spreadsheet to calculate Doomfletch Prism real DPS

https://docs.google.com/spreadsheets/d/1-07g0X2xWxTRclVmD9ow0z0IG6jb8rrZIeaQELfeBRk/edit#gid=0

I'm playing a Doomfletch build (Mathil's), and i wanted to be able to make informed decisions (inc phys dmg vs crit multi on jewels?), and since the sheet DPS in-game is useless, I made this spreadsheet to help me out. Hopefully it'll help out some of you too.

Let me know if any of my math is wrong!

ps: I quickly looked at Mathil's build video and inputed most of his stats into the spreadsheet, here's the result. I didn't look at his attack speed and some other values, but that should be a good indication. Seems like he was reaching almost 1 million dps with diamond and dying sun flasks up. I also don't take into account some of the inquisitor bonuses that are condifitional.

Track your map runs: http://pathofmaps.com (retired)

Retired item indexer: https://github.com/niuage/poexplorer
Last edited by niuage#2922 on Dec 8, 2016, 4:37:08 PM
Last bumped on Dec 13, 2016, 8:19:53 AM
Really cool. But to calculate the converted elemental damage you're just making the formula "=B17 * 1.1" which just takes the flat phys damage, not considering the increases and more multipliers. This is wrong right?

EDIT: Oh you made a note about that right below, I didn't see

So I didn't know that the increases to physical damage are not applied to the elemental damage.

So if I have 100 flat physical damage, then in my belt I have "20% increased physical damage", the bow will convert just this 100 damage to 110 anyway? Instead of converting 120 damage to 132?
Last edited by Linck#0716 on Dec 13, 2016, 8:28:51 AM

Report Forum Post

Report Account:

Report Type

Additional Info