As I couldn't find a tool to calculate how much attack speed I needed to hit the next breakpoint, or how much attack speed I had in excess of the current breakpoint, and could possibly drop from paragon points, I set out to make one myself.
I've added in some other tools I found useful as well.
So I just wanted to share it in case anyone else would find it useful: Link to spreadsheet
It's pretty self explanatory, just edit the yellow fields out on the right hand side to match your paper doll stats.
Ohh didn't know that existed, thanks
But it doesn't tell me how much IAS I need for next BP or how much excess IAS I got in the current BP, which was the whole point I did my spreadsheet
You can just take your sheet APS and multiply that by your TnT bonus. That will give you your sentry APS. For example, I have 2.02 sheet aps and 41% TnT. 2.02 * .41 = .8282 then .8282 + 2.02 = 2.8482. From that I know I need to maintain 2.02 aps with my 41% TnT.
I'm aware of that, the problem with using the paper doll APS is that it's rounded to 2 decimal points, so you might end up in a scenario where you think you're at a breakpoint, when in fact you aren't. That's why it's being calculated that way.
Weapon attack speed x weapon attack speed % bonus(if applicable) x total % aps bonus (from other sources but weapon) x tnt bonus = final sentry bonus.
So if you're using a bow with 7% aps rolled, have a total of 34% attack speed bonus from gear and paragon, 45% tnt:
1.4x 1.07x 1.34x 1.45 = 2.9106
If you wanted to know how much aps% you needed to reach a breakpoint just take the breakpoint value and work backwards from the calculation (ie. 2.84210/ weapon attack speed/ tnt bonus = aps% needed from gear and paragon)
Weapon attack speed x weapon attack speed % bonus(if applicable) x total % aps bonus (from other sources but weapon) x tnt bonus = final sentry bonus.
So if you're using a bow with 7% aps rolled, have a total of 34% attack speed bonus from gear and paragon, 45% tnt:
1.4x 1.07x 1.34x 1.45 = 2.9106
If you wanted to know how much aps% you needed to reach a breakpoint just take the breakpoint value and work backwards from the calculation (ie. 2.84210/ weapon attack speed/ tnt bonus = aps% needed from gear and paragon)
It's all in the spreadsheet mate, being calculated as you just described
Weapon attack speed x weapon attack speed % bonus(if applicable) x total % aps bonus (from other sources but weapon) x tnt bonus = final sentry bonus.
So if you're using a bow with 7% aps rolled, have a total of 34% attack speed bonus from gear and paragon, 45% tnt:
1.4x 1.07x 1.34x 1.45 = 2.9106
If you wanted to know how much aps% you needed to reach a breakpoint just take the breakpoint value and work backwards from the calculation (ie. 2.84210/ weapon attack speed/ tnt bonus = aps% needed from gear and paragon)
It's all in the spreadsheet mate, being calculated as you just described
I made it public for everyone, so no idea why it doesn't work.
Edit: I fixed the link. For some reason the auto link generator on this forum removed the ":" after http. Did a work around and fixed the link.
You have to copy the sheets to your own google drive to edit the field with your own stats though.
People don't know how to Math. Sheet DPS *TnT. If your sheet DPS reads 2.1 and your TnT bonus is 45% just take 2.1 * 1.45 = sentry attack speed. Stop adding redundant steps and make this simple on yourselves.
People don't know how to Math. Sheet DPS *TnT. If your sheet DPS reads 2.1 and your TnT bonus is 45% just take 2.1 * 1.45 = sentry attack speed. Stop adding redundant steps and make this simple on yourselves.
In general I agree. However, two exceptions:
1) In-game sheet APS can fool you, as it's rounded and sometimes you might just miss the breakpoint by a small amount.
2) If you're relying on Gogok (or BBV and the WD is afk while you're calculating) you need to do the math, and it's not so simple for some people (not everyone is super comfortable in math). If in doubt I rather double check or triple check before wasting a high level GR keystone and the time of my team mates.
Also, spreadsheets help you to theorycraft different setups without swapping gear like crazy or enchanting it ("is it worth to re-roll my Unity to 7% IAS to hit the breakpoint or am I not gonna get there" might be something you want to answer on a spreadsheet before wasting all resources).
At this point I'm thinking of creating a list of all spreadsheets/websites as there are so many of them... and I like all of them, depending on what exactly I want to do and calculate (just breakpoint or DPS, entire gear or just weapon switching) I use a different one.
People don't know how to Math. Sheet DPS *TnT. If your sheet DPS reads 2.1 and your TnT bonus is 45% just take 2.1 * 1.45 = sentry attack speed. Stop adding redundant steps and make this simple on yourselves.
As Bagstone posted above, the steps aren't redundant and the need to make it more complex is needed to not get fucked over by rounding.
Here is a real example:
Bow with 1.40 APS and no IAS roll on it - 6.20% IAS from paragon and 30% total from gear netting 36.20% IAS total - TnT with 49% roll.
Lets calculate the sentry attack speed without "redundant steps and make it simple on ourself":
Sheet APS says: 1.91
TnT is: 1.49
Sentry APS: 1.91 x 1.49 = 2.8459
SUCCESS we're above the 2.84211 breakpoint!?
WRONG!
New lets do the calculation with those redundant steps:
Weapon APS: 1.40
IAS: 1.3620 (36.20%)
TnT: 1.49
Sentry APS: 1.40 x 1.3620 x 1.49 = 2.841132
Which is 0.000978 below the 2.84211 breakpoint
So making it simple on yourself can hurt you.
Regardless, the point of the spreadsheet was not to calculate the breakpoint, plenty of stuff around to do that. The point was to optimize IAS you have to be above and as close to the breakpoint as possible, since IAS between breakpoints does nothing for sentry DPS. Basically I wanted to know how much IAS I could strip down and still be at a certain breakpoint, and I wanted to share it with other people who might find it usefull.
Nice example malm. Funny how people fail big time by thinking they are smart by taking a shortcut. And before people say "nobody would put 6.2% from paragon", it becomes even worse with attackspeed on your weapon, as that's multiplicative in there as well giving even more rounding issues on sheet attackspeed.
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
As I couldn't find a tool to calculate how much attack speed I needed to hit the next breakpoint, or how much attack speed I had in excess of the current breakpoint, and could possibly drop from paragon points, I set out to make one myself.
I've added in some other tools I found useful as well.
So I just wanted to share it in case anyone else would find it useful:
Link to spreadsheet
It's pretty self explanatory, just edit the yellow fields out on the right hand side to match your paper doll stats.
But it doesn't tell me how much IAS I need for next BP or how much excess IAS I got in the current BP, which was the whole point I did my spreadsheet
I'm aware of that, the problem with using the paper doll APS is that it's rounded to 2 decimal points, so you might end up in a scenario where you think you're at a breakpoint, when in fact you aren't. That's why it's being calculated that way.
You have to copy it to your own google drive to edit the values.
Season 7 Hardcore Demon Huntard #14 @ GR78
Unhallowed Essence Multishot Guide
Weapon attack speed x weapon attack speed % bonus(if applicable) x total % aps bonus (from other sources but weapon) x tnt bonus = final sentry bonus.
So if you're using a bow with 7% aps rolled, have a total of 34% attack speed bonus from gear and paragon, 45% tnt:
1.4x 1.07x 1.34x 1.45 = 2.9106
If you wanted to know how much aps% you needed to reach a breakpoint just take the breakpoint value and work backwards from the calculation (ie. 2.84210/ weapon attack speed/ tnt bonus = aps% needed from gear and paragon)
It's all in the spreadsheet mate, being calculated as you just described
Edit: I fixed the link. For some reason the auto link generator on this forum removed the ":" after http. Did a work around and fixed the link.
You have to copy the sheets to your own google drive to edit the field with your own stats though.
1) In-game sheet APS can fool you, as it's rounded and sometimes you might just miss the breakpoint by a small amount.
2) If you're relying on Gogok (or BBV and the WD is afk while you're calculating) you need to do the math, and it's not so simple for some people (not everyone is super comfortable in math). If in doubt I rather double check or triple check before wasting a high level GR keystone and the time of my team mates.
Also, spreadsheets help you to theorycraft different setups without swapping gear like crazy or enchanting it ("is it worth to re-roll my Unity to 7% IAS to hit the breakpoint or am I not gonna get there" might be something you want to answer on a spreadsheet before wasting all resources).
At this point I'm thinking of creating a list of all spreadsheets/websites as there are so many of them... and I like all of them, depending on what exactly I want to do and calculate (just breakpoint or DPS, entire gear or just weapon switching) I use a different one.
Here is a real example:
Bow with 1.40 APS and no IAS roll on it - 6.20% IAS from paragon and 30% total from gear netting 36.20% IAS total - TnT with 49% roll.
Lets calculate the sentry attack speed without "redundant steps and make it simple on ourself":
Sheet APS says: 1.91
TnT is: 1.49
Sentry APS: 1.91 x 1.49 = 2.8459
SUCCESS we're above the 2.84211 breakpoint!?
WRONG!
New lets do the calculation with those redundant steps:
Weapon APS: 1.40
IAS: 1.3620 (36.20%)
TnT: 1.49
Sentry APS: 1.40 x 1.3620 x 1.49 = 2.841132
Which is 0.000978 below the 2.84211 breakpoint
So making it simple on yourself can hurt you.
Regardless, the point of the spreadsheet was not to calculate the breakpoint, plenty of stuff around to do that. The point was to optimize IAS you have to be above and as close to the breakpoint as possible, since IAS between breakpoints does nothing for sentry DPS. Basically I wanted to know how much IAS I could strip down and still be at a certain breakpoint, and I wanted to share it with other people who might find it usefull.
Nice example malm. Funny how people fail big time by thinking they are smart by taking a shortcut. And before people say "nobody would put 6.2% from paragon", it becomes even worse with attackspeed on your weapon, as that's multiplicative in there as well giving even more rounding issues on sheet attackspeed.