Guild Wars 2

Hey guys I’ve been working on a damage calculator over the past few months adding bits and pieces, I guessed here might be a good place to share it, as well as get it double checked for errors (I’m just one guy who barely knows any Excel).

It’s pretty straight forward to use, just punch in the numbers and it should spit out your damage for that particular skill. I recently added a very, very rough DPS calculator as well.

Feel free to share it around as much as you like and edit it to your liking.

Enjoy

https://www.dropbox.com/s/pnu8em25desf64y/Damage%20Calculator.xls?dl=0

Usually ppl test their rotation over a period of 30sec. Then you list all the skill you were able to do in that 30sec and make a coefficient/second for each weapons you used. Then you calculate the dps for each and add the amount of condition for get your total dps.

That’s the most reliable way to get your dps that I know of.

This is a good start. As Thaddeus said, people normally test their rotations over a set period of time (10s to simulate a quick fight, 30s for long fights) and calculate damage coefficients. There is some good discussion about dps calculations on DnT’s forums http://www.dtguilds.com/forum/m/6563292/viewforum/4280860 I’d recommend checking it out if you want to improve your spreadsheet. The more the merrier!