Resto Spreadsheet - Page 2

Allinone · 04/18/09, 3:02 PM

Bug/Exploit.

In an attempt to push your spreadsheet, I recently stumbled across an 'error' of sorts in the HPS calculation. Depending on how your rewrite goes, this could actually be of little importance.

In your HPS calculations, it should limit the spam timer to the global cooldown.

Allow me to explain. I was attempting how well spells with haste, comparing Glyphed Healing Touch, Regrowth, and Nourish. By giving my spells enough haste to make the nourish cast timer = 1 second, i found it to do crazy things to Healing Touch (Glyphed). Long story short, Healing Touch scaled down to a cast timer of under .2s (not sure if this behaivor works the same way on live), and its HPS jumped up to 33,000 HPS. While I admit that this is a very special case (as glyphed HT is the only spell that is easily haste capped) but it would give more accurate comparisons between glyphed HT and the rest of our spells.

So in most cases the HPS calculation should be limited by the cast timer or the spell, unless the cast timer is less than the GCD.

Paininabox · 04/19/09, 3:27 AM

I too noticed that glyphed HT's were getting huge HPS numbers. It's true, however, that the spell, when glyphed, can be faster than the GCD. The glyph is deceptive in that it states a 50% decrease in cast time, which one would assume is multiplicative. In actuality, it's a flat -1.5s off the cast time. However, the formula is calculated in such a way as haste scales the cast time down as fast as if it were still at the 3 second cast, so that haste is better at reducing glyphed HT cast time than it is at the GCD. I realize that it's unrealistic and deceptive to portray glyphed HT as some uber heal like that, because you have to wait for the GCD even when it has only .6s cast or whatever. The fix I implemented is that when the cast time gets below 1 second, additional fields pop up for an average cast time, which is capped at one second (due to GCD). I use this to then calculate a much more reasonable HPS value.

Erdluf · 04/22/09, 2:30 PM

Please consider adding [Idol of the Raven Goddess]. It works now, and 44 SP (all heals) seems very competitive when compared to other pre-Uldar idols (for instance 125 SP, Lifebloom HoT only).

Cyrran · 04/26/09, 8:19 PM

Apparently this file isn't available anymore (error when trying to download from the linked site). Anyone have a copy around that they can host somewhere?

Paininabox · 04/26/09, 10:11 PM

It still works fine for me. Try again, maybe the site was down/having maintenance. Let me know if you still can't get it.

Cyrran · 04/27/09, 10:54 AM

Yeah, it's working again. Sorry for the false alarm.

iplaydfns · 05/25/09, 2:28 AM

Hello, is this still working? I'm clicking on the link and it comes up with the same screen. I tried saving the file, but it came up as a webpage. Any help would be appreciated. Thanks!

Paininabox · 05/25/09, 10:54 AM

Originally Posted by iplaydfns

Hello, is this still working? I'm clicking on the link and it comes up with the same screen. I tried saving the file, but it came up as a webpage. Any help would be appreciated. Thanks!

It works for me. Try going to the link and clicking the start download button; let me know if you still can't get it.

iplaydfns · 06/01/09, 5:23 PM

I got it...thank you! I was reading that download now part as an ad because some family guy survey was above it and some other add was below it. Thank you for your help!

Erdluf · 07/09/09, 11:00 AM

I don't know if you're still updating the spreadsheet, but I believe Idol of Awakening should be applied before Moonglow and ToL form.

From WoWHead IoA comments:

Originally Posted by thelovefool

idol subtraction takes place before percentage reductions. I don't care to write out the math, cause these numbers are pulled right from the game as of time of post.

With no talents- 629
with talents - 446
with talents & idol - 371

theWul · 07/14/09, 6:33 AM

I don't know what I'm doing wrong but neither Firefox nor IE7 wont show any "Start Download" something to me =(

Quaiche · 07/14/09, 3:17 PM

Has anyone looked at updating this to current game mechanics?

Daegans · 08/12/09, 6:57 AM

Hi, thank you for the spread sheet for starters.
This is the first time I have attempted to use one, and I have found gear missing from the spread sheet.
Perhaps I am doing something wrong?

A good example would be:

Illustration of the Dragon Soul - Item - World of Warcraft

It is late for me, so I will continue to research further on this matter at another time.
I look forward to any help you may give me.
Thank you.

Paininabox · 08/12/09, 10:46 PM

Yes, I'm aware that there is quite a bunch of missing gear, particularly the trinkets and 3.2 gear. In the meantime, though, you can use the extra row to punch in your gear stats.

Has anyone looked at updating this to current game mechanics?

Well, the only thing the sheet is not updated on is the gear database and the ET change to nourish, so it's not like it's completely broken. There's also those extra rows to help you out, too. I'd really like to get back into developing this, so we'll see.

Erdluf · 08/13/09, 8:18 AM

Originally Posted by Paininabox

Well, the only thing the sheet is not updated on is the gear database and the ET change to nourish, so it's not like it's completely broken. There's also those extra rows to help you out, too. I'd really like to get back into developing this, so we'll see.

I think it also needs updates for 3.2 replenishment and lifebloom-bloom.