Is anyone else having the issue when they change/update weapon values the DPS breaks with '#NAME'.
Not sure if it's been posted/resolved yet, I've scoured the calc page looking for a way to fix it, with no avail. It even happens on the stock download when you switch the weapons the main page breaks and DPS is unable to be calculated.
When I get #NAME errors it's because I've renamed an item
while having it equipped. Resolving is either an Undo or if you've already saved it, a re-download of the spreadsheet. Let me know if this is what broke your sheet!
Is there a macro that needs to run the 120s duration of a fight to calculate the DPS that I'm not seeing a button for? I used to run macro's for my rogue in wow and I had to run the test in order to see dps updates....what am I missing with this spreadsheet?
No, any changes made to stats or other mods such as passive talents and so forth automatically updates ~30k calculations. And remember that it doesn't need to be a 120 sec duration, or even time duration at all, you do have options for choosing target health instead.
The macros in this spreadsheet are mainly to quicken up a boring task of manually adding a bunch of values for comparisons. For example, you have an SEP macro which essentially tries adding the chosen number of stats (there's a note explaining this in the spreadsheet) for one stat at a time, save the result, and re-run the calculations with another added stat. There's also a defensive equivalent to determine the value of defensive stats, although it is currently hidden!
Thanks for the resource Super, once I get this kink worked out it's going to be a godsend.
-Serated
Thank you! Hope you get it working and let me know if you still have #NAME issues even if you don't rename equipment you currently have equipped.
Edit: I should add that it's perfectly fine to change the affix values of an item while having it equipped, the spreadsheet doesn't like it when you try to rename it though.