Guild Wars 2

This is a damage calculator i made months ago when i was more into build crafting. I updated it today and included more accurate calculations, especially for estimating your damage over multiple attacks. The calculation formulas i used are basically the ones on the gw2 wiki.

Screenshot: http://postimage.org/image/8nalgnzob/

I dont have any skill coefficients besides 100b listed on there already, but with my updated skill coefficient formula they are easy to obtain. It may look intimidating at first, but its really simple and easy to use. Just follow the instructions.

If you are interested in this, let me know if you find any calculation errors or if something doesnt make sense.

The file is a protected excel sheet, which is much safer to use, and you wont inadvertently mess something up which will throw off the calculations.

I couldnt make an attachment with the excel format on the forums, so i uploaded it to depositfiles. Also google docs couldnt properly convert the file and kittened it all up.

http://depositfiles.com/files/e5434f530

Warning, 60 second wait.

Edit: For those who dont have excel, OpenOffice by Apache (free) works with excel sheets. I tested it with this file and it appears to work, though the formatting is a bit different.
http://www.openoffice.org/

Edit 2: I think i forgot to define ESD. ESD is your estimated sustained damage, the damage you are expected to do over multiple hits given your crit chance. The higher your crit chance is, the closer your ESD damage will be to critical damage.

Can you sample targets to see if +10% flame legion sigils stack with +10% dmg vs. flame legion pot. Then test if +10% flame legion dmg sigils stack and if +10% flame legion dmg sigil and +5% flame legion dmg sigil stacks or not.

Phira.3970:

Can you sample targets to see if +10% flame legion sigils stack with +10% dmg vs. flame legion pot. Then test if +10% flame legion dmg sigils stack and if +10% flame legion dmg sigil and +5% flame legion dmg sigil stacks or not.

Sorry, I dont think so. The calculator can only do hypothetical tests, not experimental, so the only way to see if the sigils stack properly is to test it in game. This can be used to see if say 5% crit chance was better than 10% damage increase, or if +10% crit chance gave you more damage than +5% crit damage, and stuff like that.

It is mainly used for accurately and reliably crafting different builds and testing them against each other to see which is better for the situations.

What you can do though is use those sigils with a pvp steady weapon. Since the steady weapons always do the same amount of damage (no random number generator), it will be clear if the sigils dont stack because the damage wont change.

+5% dmg sigils doesn’t stack. I’ve confirmed multiple times on pvp steady weapons. However, +10% bleed duration sigils do stack. This means its all bananas. Maybe +10% dmg vs flame legions do stack.

Yeah the sigil stacking rules are a bit complicated, check here
and scroll down to the “notes” section for more info. wiki.guildwars2.com/wiki/Sigil

Also, condition durations only go in whole numbers and round down, so 3.1 seconds = 3 seconds, and 3.99999 seconds = 3 seconds.

I have but it doesn’t tell me anything about whether they stack with pots or not or if they work in PvE or not.

I’m nuts for CoF P1 farm where I hit for 20k eviscerate on my axe against slave driver with 15% vs flame legion (10% flame legion and +5% flame legion) and my hundred blade has hit for 47.5k on slave driver.

Sand Beagle.9867:

Yeah the sigil stacking rules are a bit complicated, check here
and scroll down to the “notes” section for more info. wiki.guildwars2.com/wiki/Sigil

Also, condition durations only go in whole numbers and round down, so 3.1 seconds = 3 seconds, and 3.99999 seconds = 3 seconds.

Is the whole rounding thing actually confirmed?

Such as having a precision to hit a whole number otherwise it rounds down and is wasted? I always just thought that it doesn’t show decimal but I wouldn’t think that it’d actually round it down.

Well done Beagle!

Lets fine it a bit and make it a little spiffy on the looks. If that goes well you may be able to partner with an established GW2 website and provide the statistics and calculations needed so they can build a page on it.

This would help a lot of people with theory crafting!

Defektive.7283:

Well done Beagle!

Lets fine it a bit and make it a little spiffy on the looks. If that goes well you may be able to partner with an established GW2 website and provide the statistics and calculations needed so they can build a page on it.

This would help a lot of people with theory crafting!

Yeah thanks Im sure someone with a bit of programming knowledge could package it up nicely. I;ll take a look at trying to get it on google docs though, but it doesnt seem to convert it very well.

Sand Beagle.9867:

Defektive.7283:

Well done Beagle!

Lets fine it a bit and make it a little spiffy on the looks. If that goes well you may be able to partner with an established GW2 website and provide the statistics and calculations needed so they can build a page on it.

This would help a lot of people with theory crafting!

Yeah thanks Im sure someone with a bit of programming knowledge could package it up nicely. I;ll take a look at trying to get it on google docs though, but it doesnt seem to convert it very well.

I can write an application (software development / project management is my profession) if you’d like. We develop desktop applications (mostly b2b) but I may be able to whip up either a small exe or web plugin that websites could use.

If that’s something your interested in I would recommend asking a gw2 website if they’d use it. If you get a confirmation I’d be happy to help.

Defektive.7283:

Sand Beagle.9867:

Defektive.7283:

Well done Beagle!

Lets fine it a bit and make it a little spiffy on the looks. If that goes well you may be able to partner with an established GW2 website and provide the statistics and calculations needed so they can build a page on it.

This would help a lot of people with theory crafting!

Yeah thanks Im sure someone with a bit of programming knowledge could package it up nicely. I;ll take a look at trying to get it on google docs though, but it doesnt seem to convert it very well.

I can write an application (software development / project management is my profession) if you’d like. We develop desktop applications (mostly b2b) but I may be able to whip up either a small exe or web plugin that websites could use.

If that’s something your interested in I would recommend asking a gw2 website if they’d use it. If you get a confirmation I’d be happy to help.

Cool, thanks. It’d have to get some real testing though to iron out any bugs or errors, because so far its just been me using it and i dont use it often. Plus i’m sure its missing a lot of features. I just made it originally to test warrior builds.