Shandara, I didn't see it in the change logs, but did you add in the reduced cooldown for Spirit Strike? I know Spirit Beasts currently have a host of other problems (slower attack speed, not recieving the 10% bonus from being Ferocity) that I assume aren't modeled into the sheet, but I'd be interested to see how Spirit Beasts stack up should they end up fixing those bugs.
Also, thank you again for doing these updates so quickly and such.
I hope i can word this in such a way that I dont banned, but is anyone working on an open office conversion? The reason I ask is because I would like to contribute to the effort in some fashion. I dont have much in the way of coding chops but Id like to help in any way that I can.
Under the Gear Tab there is option to click, Load Gear From Armory How do I modify/change your spread sheet so it would load my own armory rather then yours?
Ah btw please tell me the dumb down or step by step guide, i am not very good at using Excel and thank you for taking the time to make this spread sheet, it is very helpful.
I hope i can word this in such a way that I dont banned, but is anyone working on an open office conversion? The reason I ask is because I would like to contribute to the effort in some fashion. I dont have much in the way of coding chops but Id like to help in any way that I can.
This has been answered a few times, but I'll try it again. I am not working on an Open Office version because I don't have the time nor the expertise with its scripting language. Several people have offered to convert the sheet, but after sending out unlocked sheets to them I never heard back.
@Xerex:
On the overview tab change my name and server/region to yours to import a different character.
@Rokh:
The sheet never had the bug where Longevity interfered with the 10 second DoT implemented, so with the upcoming change should already (have been) be in the sheet. The actual ability itself still has a 10 second cooldown no? I don't own a spirit beast myself so I haven't been able to test it on the PTR.
Small update uploaded to fix the tier7 25-man items 2-set bonus (V81a).
I'm pretty sure the change is that instead of taking 10 seconds for the DoT to burn, it's only 6 seconds for it to deal it's damage. So it should be dealing the full damage over 7 seconds now talented, although I suppose the sheet already models that, if it's letting Spirit Strike work with Longevity. Good show.
Yes, the sheet merely calculates the damage done over 10 seconds (the cooldown) and with Longevity that damage is taking over 7,8 or 9 seconds depending on how much points you took.
Overview lists me as being 0.58% over the hitcap, or 19 rating. This is after calculating attributes and sorting gear, but the gear planner is still suggesting items such as Grim Toll and other items that have +hit on them. I doubt there is any ilvl 213 item with hit on it that is better than another ilvl 213 item without hit on it, if you are hitcapped.
Anyone else having these issues? Or maybe have an advice on how to resolve it?
Overview lists me as being 0.58% over the hitcap, or 19 rating. This is after calculating attributes and sorting gear, but the gear planner is still suggesting items such as Grim Toll and other items that have +hit on them. I doubt there is any ilvl 213 item with hit on it that is better than another ilvl 213 item without hit on it, if you are hitcapped.
Anyone else having these issues? Or maybe have an advice on how to resolve it?
You have 3/3 Focused Aim and since your pet doesn't benefit from that any +hit on items over your own hit-cap will benefit your pet.
You have 3/3 Focused Aim and since your pet doesn't benefit from that any +hit on items over your own hit-cap will benefit your pet.
Would have agreed on that if I was BM - but since I'm MM it never occured to me that the extra hit for my pet would alter the ranking of items this much.
Roar of Recovery doesn't properly appear to be reducing Viper uptime (which because it grants extra mana would appear to be the case), this should result in a dps increase for the hunter where the duration of the fight allows them to run out of mana.
Wolverine bite still appears to lower dps of the pet (loses about 50 dps on the wind serpent). I am working on leveling one up to 80 and checking what sort of dps numbers I get with WS compared to a cat.
This has been answered a few times, but I'll try it again. I am not working on an Open Office version because I don't have the time nor the expertise with its scripting language. Several people have offered to convert the sheet, but after sending out unlocked sheets to them I never heard back.
Shandara,
I understood perfectly well why you werent working on an OO. I did remember reading somewhere that some people had offered to help so I was hoping they were indeed helping you and I could in some way assist with their efforts. Too bad they arent. Like I said, I dont have much in the way of coding chops but I do have some background in scripting and in Python so I might be able to handle a translation. But I just want to make sure you dont read my original post as yet another post harassing you about the lack of OO support. I understood fully, I was just hoping I could help the effort some. Thanks for all the hard work youve put in on this project.
Roar of Recovery doesn't properly appear to be reducing Viper uptime (which because it grants extra mana would appear to be the case), this should result in a dps increase for the hunter where the duration of the fight allows them to run out of mana.
Wolverine bite still appears to lower dps of the pet (loses about 50 dps on the wind serpent). I am working on leveling one up to 80 and checking what sort of dps numbers I get with WS compared to a cat.
Thanks.
Roar of Recovery isn't implemented (yet).
As for Wolverine Bite, others have reported it but I haven't looked into it yet. Is it on the pet GCD? If so then that's probably the reason it reduces DPS. Coupled with the fact that the calculations might be not correct.
Is it known what the new stats will be for Saronite Shiv and Savage Cobalt Slicer? The PTR notes just say that they will be "adjusted to properly reflect their intended power."
I'm looking at the math for how Aspect of the Viper uptime is calculated. It looks like the mana gain from a potion is averaged along the length of the boss fight (C46, Shot Rotation tab. It's possibly a holdover from when potions could be chain-chugged?)
I noticed this because Viper Uptime has such a huge affect on DPS output. I also wondered if this entire calculation is stable for different bossfight lengths. Ie, are multiples of "Time to OOM" particularly advantageous because they happen to use exactly the minimum amount of Viper? I wonder if there is a better way of calculating Viper Uptime; maybe eliminating this "Regen from Mana Potion" and drinking once when you drop below a certain mana threshold.
I'm looking at the math for how Aspect of the Viper uptime is calculated. It looks like the mana gain from a potion is averaged along the length of the boss fight (C46, Shot Rotation tab. It's possibly a holdover from when potions could be chain-chugged?)
I noticed this because Viper Uptime has such a huge affect on DPS output. I also wondered if this entire calculation is stable for different bossfight lengths. Ie, are multiples of "Time to OOM" particularly advantageous because they happen to use exactly the minimum amount of Viper? I wonder if there is a better way of calculating Viper Uptime; maybe eliminating this "Regen from Mana Potion" and drinking once when you drop below a certain mana threshold.
The longer a fight, the less effect a potion will have. (precisely because you can't chain-chug anymore). Thus I average the effect over the duration of the whole fight.
Any ability or item that restores mana is in effect a specific amount of Mana per Second you gain, measured over the length over the fight. Mana potions are special in that they can only be used once, hence the value diminishes on longer fights.
I am trying to use the spreadsheet (v81a) and I noticed something when I changed specs from MM to SV to BM.
when I was changing specs, I was also looking at the rotation tab, and even after hitting test rotation, it was not changing my rotation based on the shot available to me.
So if I was BM, it was showing chimera shot in my rotation, etc.
This seem rather peculiar to me, as I think it might be effecting the numeric returns I get. Am I supposed to change something somewhere else in order to get the rotation to change to the appropriate shots for the spec?
Took me a while to get it in the right order so I didn't get errors. I am sure this is something a lot of people who use the spreadsheet don't know about that aspect of the spreadsheet.
There needs to be an option to save rotation orders, just like spec, so it is easy to switch specs as well as rotations.
You could possibly have an auto fill option that put the shots available to the each spec as talents are selected to simplify this aspect of the spreadsheet.
As for Wolverine Bite, others have reported it but I haven't looked into it yet. Is it on the pet GCD? If so then that's probably the reason it reduces DPS. Coupled with the fact that the calculations might be not correct.
I can't confirm that it's on the pet GCD, but that wouldn't lower the dps if the calculations are correct. In my testing (with a chimera), Wolverine Bite does more damage than Bite/Claw/Smack and the cunning family specials. At worst it's replacing a lower damage attack with a higher damage one, which should still be a dps increase. Maybe the sheet isn't scaling it with PAP?
12/21/08, 11:28 PM
Similar Threads
