Piken Square Dragon Hunters

Dragon Hunter's Den => General Chat => Topic started by: Ensho on May 13, 2016, 03:38:52 PM

Title: Awesome Excel sheet which uses blood magic to determine Ranger DPM :INPUT NEEDED
Post by: Ensho on May 13, 2016, 03:38:52 PM
Hi Everyone,

I had some really, really boring hours at work recently, and got around to fiddle around with build editors.
Immediately, I found that you can click around whatever you want, but you won't be able to determine a damage per minute (DPM) indication of your weapons used.

I am using a Celestial ranger of which I was eager to figure out which weapon set was most effective with my gear. Unfortunately, online calculators did not do the trick :(
Therefore, I had to throw some data in an excel file (which got a bit out of hand) to do it myself.

After an hour or two, I got my answer ( it's GS+Axe/torch or Sword/torch+SB for celestial by the way).

what can I use it for?
well: there are various questions about which builds are most DPS effective, or how much DPM you would lose if you go for stats like toughness. This document can calculate the individual DPM per weapon set. I did not use any complicated power things, the only thing you need to do is enter the damage your tooltip shows when you mouseover your own skills or mouseover a skill in online build editors.

A few of my GW2 friends have said they'd be interested in using this excel as well, so I spent a few more of my boss' precious work hours to make it user friendly.

You will find the excel in this topic. It would be much appreciated if  you guys would test this and leave any feedback. Please do not distribute this document without my permission.

I will take your left eye if you do. :P
SimplePortal 2.3.5 © 2008-2012, SimplePortal