Guild Wars 2

I went ahead and made a spreadsheet for calculating theoretical alacrity and quickness up times for different traits and gear. It has enough information for me to easily make new formulas for different continuum split rotations and well combinations. I thought I’d share. If you see any typos feel free to mention them so I can fix them.

Chrono Buff Spreadsheet

This is fantastic!!

I would recommend a Sticky! Pretty much exactly what I’m looking for here.

Thanks, Syrval!

isn’t gravity well 90 second base recharge?

Lumpy.8760:

isn’t gravity well 90 second base recharge?

Yeah that’s a typo :P It’s fix’t now. Thanks for the catch!

Last time i did some duration stacking there was this stack cap of 9. I suspect this is still the case? If so, people or this spreadsheet need to keep that cap in mind. Also if this is the case, don’t use timewarp :p its a noob trap.

Is boon duration worth it? You only produce quickness (yes I know that one’s powerful)

Great initiative! However, the alacrity numbers are not quite correct. The numbers in the spreadsheet state that alacrity increases recharge rates by 50%, while it actually increases them by 66%.

This is also stated on the wiki, and I tested it myself to be sure. In HoTM, permanent alacrity due to three avengers caused my Gravity Well to recharge in approx. 54 seconds.
This is equal to (90/1.66) seconds.

So the chronomancer is even stronger than you thought. :P

Qixz.5640:

Last time i did some duration stacking there was this stack cap of 9. I suspect this is still the case? If so, people or this spreadsheet need to keep that cap in mind. Also if this is the case, don’t use timewarp :p its a noob trap.

You are correct according to the wiki page on effect stacking and I did completely forgot to note this. I didn’t seem to hit the stack cap that noticeably when I tried the Illusionary Inspiration spread in the mists (trying to verify the sanity of the numbers). However that was probably because by the time I triggered the signet trait, most or all of Timewarp’s short duration quickness stacks were gone (10s after the drop of Timewarp).

I’ll have to add that to the note to the bottom that the cap is 9, since its a bit beyond my excel skills to add a check for how many times we’ve stacked quickness. (unless someone has a suggestion how to do this, and I’m just being dumb) People will just have to keep it in mind when actually utilizing this stuff. It should also be kept in mind the rotations I made were largely for example purposes as well as my own curiosity. My personal copy of this spreadsheet is even more of a mess Xp

roelvanesch.2817:

Is boon duration worth it? You only produce quickness (yes I know that one’s powerful)

This was largely an exercise on compiling data for all the different kinds of combinations you get and boon duration was part of that. But if you want my opinion, since one of the combinations takes chaos and you can produce other boons through chaos it might be worthwhile if your pug group isn’t able to keep up might stacks on their own. But in such a case you’re probably better off using something temporary like food.

I should add the 325 concentration is what you can get from boon duration weapons and armors (specifically I was looking at Commander’s). If I remember right the max boon duration you can get from runes is 35% and you can get a max of 30% from consumables. Not that you would ever do all of that. But it’s a combination, so I wanted to support it in the spreadsheet.

Bean Muncher.5197:

Great initiative! However, the alacrity numbers are not quite correct. The numbers in the spreadsheet state that alacrity increases recharge rates by 50%, while it actually increases them by 66%.

This is also stated on the wiki, and I tested it myself to be sure. In HoTM, permanent alacrity due to three avengers caused my Gravity Well to recharge in approx. 54 seconds.
This is equal to (90/1.66) seconds.

So the chronomancer is even stronger than you thought. :P

You might be confusing the alacrity benefit box with the herald bonus box. It was written down as 66%. The problem was I was applying it wrong. I thought it was two thirds recharge which would have been (90*0.66). Welp, I’m really glad I posted this here. All these extra eyes to help sanity check for me.

Edit: BTW it’s fixed now, and thanks.

sticky please? Great work mate. !

roelvanesch.2817:

Is boon duration worth it? You only produce quickness (yes I know that one’s powerful)

I did some math on this:
lets compare commander vs marauders. and assume that with commanders u can get around 40% boon duration, and with marauders u can get to 190% crit dmg. both have around 50% crit chance ( i ballparked all these numbers but they probably aren’t far from the truth).

Normally we would crit half the time for 1.5x the dmg, with marauders we crit for 1,9 half the time we go from a 1.25x dps modifier to 1.45×. ferocity increases our dp by 16%

Now lets consider quickness uptime: lets assume we get around a 50% uptime without any boon duration (i’m assuming a rotation of 5 alac wells and 5 quick wells with chrono runes in 60 seconds, no ult. Its quite a tight rotation but should be doable?). So half the time we get 1.5 auto attacks in. base modifier is thus 1.25×. getting 40% boon duration gives us a 70% uptime and increases the modifier to 1.35. boon duration increases our dps by 8%

Now i’m sure i made some mistakes here and there but i think the general point would still stand. For solo play it isn’t worth it for only quickness. There is one big caveat to this: a lot of the quickness is also available for party members, and that which isn’t can be shared through a signet or a trait+well timed phantasm.

Personally i would restrain from actually building boon duration. u can get 30% from consumables, at some point Sigil of concentration (get 33% boon duration for 7 seconds after weapon swapping) is going to hit the TP (at least i assume so). Get a herald as a party member and TADAA u hit 100%.

syrval.1690:

You are correct according to the wiki page on effect stacking and I did completely forgot to note this. I didn’t seem to hit the stack cap that noticeably when I tried the Illusionary Inspiration spread in the mists (trying to verify the sanity of the numbers). However that was probably because by the time I triggered the signet trait, most or all of Timewarp’s short duration quickness stacks were gone (10s after the drop of Timewarp).

I’ll have to add that to the note to the bottom that the cap is 9, since its a bit beyond my excel skills to add a check for how many times we’ve stacked quickness. (unless someone has a suggestion how to do this, and I’m just being dumb) People will just have to keep it in mind when actually utilizing this stuff. It should also be kept in mind the rotations I made were largely for example purposes as well as my own curiosity. My personal copy of this spreadsheet is even more of a mess Xp

There are definitely rotations out there that waste quickness (double time warp at 100% boon duration = R.I.P. stack) what makes matters worse is that we (or at least i) don’t really know how this stack works in detail on quickness. Is it an actual stack or a queue? what happens if we share out our quickness? do we share the stack? or do we share a single item with the duration of our stack? etc. I’m personally not a big fan of this stack since it’s this obscure game mechanic that makes ur life difficult and causes some really weird game decisions (like why the kitten wouldn’t you wanna timewarp twice? or even once for that matter)

Qixz.5640:

syrval.1690:

You are correct according to the wiki page on effect stacking and I did completely forgot to note this. I didn’t seem to hit the stack cap that noticeably when I tried the Illusionary Inspiration spread in the mists (trying to verify the sanity of the numbers). However that was probably because by the time I triggered the signet trait, most or all of Timewarp’s short duration quickness stacks were gone (10s after the drop of Timewarp).

I’ll have to add that to the note to the bottom that the cap is 9, since its a bit beyond my excel skills to add a check for how many times we’ve stacked quickness. (unless someone has a suggestion how to do this, and I’m just being dumb) People will just have to keep it in mind when actually utilizing this stuff. It should also be kept in mind the rotations I made were largely for example purposes as well as my own curiosity. My personal copy of this spreadsheet is even more of a mess Xp

There are definitely rotations out there that waste quickness (double time warp at 100% boon duration = R.I.P. stack) what makes matters worse is that we (or at least i) don’t really know how this stack works in detail on quickness. Is it an actual stack or a queue? what happens if we share out our quickness? do we share the stack? or do we share a single item with the duration of our stack? etc. I’m personally not a big fan of this stack since it’s this obscure game mechanic that makes ur life difficult and causes some really weird game decisions (like why the kitten wouldn’t you wanna timewarp twice? or even once for that matter)

I never time warp twice, and only really use it with continium split to effectively halve the cooldown.

This is a great thing to have, but the cooldown adjustments under the Alacrity Generators heading are not correct. I made the same mistake when I started to calculate the reductions. You took the Alacrity duration, multiplied it by the benefit (1.66) and deducted that from the cd. This forgets that in, for example, traited Well of Recall, those 10 seconds of Alacrity are still passing. Thus, it takes 16.6 seconds (10 * 1.66) off the 40-second cooldown over the course of 10 real seconds. The total cooldown reduction is 6.6 seconds, to a new value of ~33s.

The actual benefit is the Alacrity duration times the hastened cooldown over and above each second. You can test it for yourself. I went to WvW (there is a clock) and cast Well of Recall under my feet. 34 seconds elapsed on the WvW clock (it of course only lists full seconds). I tested traited Calamity and it was the same (18s cd). (Of note, the Alacrity buff from Recall does seem to be 10 seconds, and not 10.5, as the base 7 plus 50% trait would suggest. If it were, the reduction would be 7.43s).

Again, a nice resource, just have to tweak the listed numbers a bit.