Guild Wars 2

I’ve been using a spreadsheet I put together to help crunch numbers for my Elementalist for quite a while now. My guildmates expressed interest in seeing it, so I took a bit of time to convert it to Google Sheets so you all can play around with it.

Check it out over on Google Sheets!
( This is the GW2Skills build I used for the preloaded stats. )

Enter the unbuffed stats as seen on your character sheet, and buff information into the stats area on the left (I use gw2skills for my numbers), and it will tell you your effective power, effective health, and various tuning statistics. You can also enter a second set of stats to get a comparison. The area on the right will estimate the various amounts of damage your attacks should do in various situations.

• White cells are to be edited, shaded cells are automatically calculated.
• A lot of cells have notes that explain what they do. Be sure to check them out.
• You can change which stats set is used for calculations by changing cell I1.
• There are additional tweaks to the damage calculators along the top row.
• No rotation modeling is implemented, but most situations can be simulated by tweaking the provided options.

In addition to being useful for Elementalists, the only thing really Elementalist-specific about this sheet is the “possible healing” calculations. If you ignore the health-related information, and enter attack information relevant to another class, it still works great.

Let me know what you think. If you spot any calculation errors, be sure to let me know about them!

I’m pretty new to this Google Docs thing, so once I get my Gnumeric Spidy plugin ported to whatever scripting system Google Sheets uses, I’ll be able to post a ton of nifty spreadsheets in the BLTC section.

One of the most useful things I’ve ever found on these forums, thanks!

Good way to factor healing power into effective HP too. After crunching some numbers I ended up switching a couple pieces of gear.

Sigh … Why don’t people who want to contribute to damage calculations just contact me?? It’s a shame to see work being done twice when we could improve on what has been done instead!

Darox.8069:

Sigh … Why don’t people who want to contribute to damage calculations just contact me?? It’s a shame to see work being done twice when we could improve on what has been done instead!

The man likes making spreadsheets.

Tei.1704:

The man likes making spreadsheets.

Spreadsheets!

Darox.8069:

Sigh … Why don’t people who want to contribute to damage calculations just contact me?? It’s a shame to see work being done twice when we could improve on what has been done instead!

Pretty sure he did improve on what’s been done before. It’s all about the presentation.

There’s plenty of math that’s been floating around on reddit as well but for one, I’m not aware of anyone doing EHP like that before, including healing power. And also combining an easy way to compare defensive and offensive stats at a glance.

It’s looking like some zealots is actually a reasonable alternative to berserker on my build.

If you’re using the Possible Healing and Effective HP values for anything, do be aware of the note on cell A31; the possible healing is basically how much health you would recover if you used every healing skill/attack available to D/D consecutively.

The healing calculations are probably the weakest and most rigid part of this spreadsheet, so make sure to check the cell comments to make sure the calculations will work for your situation.

(Edit: There was confusion about EHP and Zealot’s gear here, but I figured out where Zephyrus was going with it after I posted)

This sheet used to have a control for “% of damage taken is condition damage” way back when, which would increase the value of healing power/vitality, but I could never get really good test results to enter meaningful values for it. Maybe I should add that control back in?

Zephyrus.9680:

Darox.8069:

Sigh … Why don’t people who want to contribute to damage calculations just contact me?? It’s a shame to see work being done twice when we could improve on what has been done instead!

Pretty sure he did improve on what’s been done before. It’s all about the presentation.

There’s plenty of math that’s been floating around on reddit as well but for one, I’m not aware of anyone doing EHP like that before, including healing power. And also combining an easy way to compare defensive and offensive stats at a glance.

It’s looking like some zealots is actually a reasonable alternative to berserker on my build.

Heh well, I guess not everybody follows what’s going on in this forum …

ZDBioHazard.8246:

If you’re using the Possible Healing and Effective HP values for anything, do be aware of the note on cell A31; the possible healing is basically how much health you would recover if you used every healing skill/attack available to D/D consecutively.

The healing calculations are probably the weakest and most rigid part of this spreadsheet, so make sure to check the cell comments to make sure the calculations will work for your situation.

(Edit: There was confusion about EHP and Zealot’s gear here, but I figured out where Zephyrus was going with it after I posted)

This sheet used to have a control for “% of damage taken is condition damage” way back when, which would increase the value of healing power/vitality, but I could never get really good test results to enter meaningful values for it. Maybe I should add that control back in?

I realized that was how you were counting healing power. I was already considering zealots gear but didn’t have a good way to compare healing power with some of these other secondary stats like ferocity or precision my head.

Since I’ll typically use all healing skills more than once in a fight, and also since healing power combats condition damage while toughness does not, I value healing power with a higher weight than it’s “EHP” value. It might be good to have the ability to weight EHP considering condition damage or have a separate EHP value for condition damage exclusively which would probably just be HP +1 healing rotation.

I found some time to update this spreadsheet. The undated link is up in the main post. (And right there too. )

• Converted to “The New Google Sheets”, so some UI bugs are fixed (dropdowns, etc). This means the link has changed.
• Added Staff and Focus attacks.
• Added some preliminary information for the important skills on some conjured weapons.
• Instead of weapon damage, weapon is set per-attack. Right now it assumes Ascended quality.
• More might blasting rotations.

Let me know what you all think about the conjured weapon skills, I had a hard time finding information on them.