Guild Wars 2

i made a damage calculator in excel since i couldnt find one on the internet.
the only problem is that its slightly off, i think!
could someone test it and correct me please

just make sure you look up every coefficient for every skill that youre going to test as well as the armor of the opponent.

download it, enable editing and then enter the values
im not a expert on excel so the equations might look a bit long :P

EDIT: updated the link
https://www.dropbox.com/s/1iodwf45qwlx5nu/Gw2%20damage%20calculator.xlsx?dl=0

https://forum-en.gw2archive.eu/forum/game/dungeons/gw2esp-source-past-3-15-patch-available/first

need some help here please

You should upload it in Microsoft onedrive and embed it into a website like this. https://vmoddin.wordpress.com/poisonarrow/
It is visually pleasing and easy to understand for those that know this game.

@DarkyAnime
well i just made it yesterday but it feels like it’s slightly off already, not by much though

plus idk how to that, ill have to do some more digging on that, however i wont mind if someone just puts it on a big fan site though

Are you adding all of the damage multipliers multiplicatively? and Do you have enough space for all of the multipliers a class has access to? You may want to add a note that it doesn’t calculate condition damage contributions, I didn’t see space to add vuln in the multiplier section

@SlyDevil
i pretty much did it how it shows it on the wiki page, did you look at the equations.
ill add the vulnerability and critical chance average over time

hhmm something is wrong…im testing the basic and its not the same within in game vs the golems in pvp. unless the coefficient or weapon strength min-max is off
Damage = Weapon strength * Power * Skill coefficient / Armor
im using a thief and testing out cloak & dagger and backstab

i found out, that the pvp golems armor have been updated to
heavy, 2600
medium, 2400
light, 2200

i also found that multipliers dont multiple and just add up
Damage = (Weapon strength * Power * Skill coefficient / Armor)Critical DamageMultipliers(sum)

still not sure why cloak&dagger and backstab have a higher damage than my calculator though.
so far i have tested thief’s sword auto attacks with, with out crits, and without multipliers and those are working fine.

EDIT: I have also tested warriors Rush and Arcing Slice.
grateful greadtsword, scholar runes, sigil of force, assassins amulet, berserker trait 20%, stick and move, empowered 3%, empower allies and 8 stacks of might with above and below 50% for arcling slice but sometimes its a little too low or too high. so im not sure what weapon strength pvp is using because im wielding a ascended gs so if i sometimes put the stats of a exotic 995-1100 is within range and others if i put 1045-1155 is within range.

for rush i also tested it with the things above but with and without berserker 20% though and those numbers came within range of a ascended gs 1045-1155