Dontmindme

I think the Import from Armory bug is the main culprit. All cells "should" be seeded with a Glinting unless the import had an empty gem slot or an unmodeled gem. Either it had a gem to begin with, or on an import should have had all extra cells filled. Next version should resolve most of this issue, although personal saved builds might have some empty gem slots because of the past error.

It doesn't solve all the issues. For example, it doesn't address metagem requirements (although disabling them during the search has helped) and doesn't address the situations where you actually want a blue socket filled for the bonus.

 

Sneakerpimp

With 2.4.0.9 I am getting different values for unbuffed AP (I78) and buffed AP (I141), even with "disable buffs" enabled.

 

Dontmindme

Good catch. Unleashed Rage was still applying even with Buffs Disabled.
Change the end of I141 to (1+IF(Talents!O29="No",unlrage*0.1,0)) and its fixed.

 

Draiko

I was running the spreadsheet today, and I am getting told that Predatory Gloves are an upgrade over Netherblade Gloves, but that can't be right. Anyone have any idea why I'm getting this?

Thanks.

 

avina

There's something wrong with "Buffed DPS" page or "AEPcalculator" in 2_4_0_9.
For example:
Open RogueDPS_2_4_0_9,change MHweapon from Blade of Infamy to Vengeful Gladiator's Slicer.
Then check "Hit Table - Main Hand",you will find that Hit % = 34.58%.
In fact,MHhit=(1-B19-B20-B21-B22) = (1-0.0626-0.025-0.24-0.3267) = 34.57%.
What causes that difference?
Now save DPS.saved DPS = 1858.60;
Run AEPcalculator,"Hit Table - Main Hand" is right now,but total DPS become 1858.70.

These problems can't be found in old versions(before2_4_0_8).

 

Dontmindme

Avina---
That is not a problem but a feature. The spreadsheet uses estimates for uptime for proccable items (like DST, WSC, Mongoose, etc). To avoid circular references, these estimates are necessary. This is because the calculations need to know which cycle you are using in order to know how many instants and specials you have.

I've found a workaround for this "chicken and the egg" situation. In short, the AEP Macro. After your cycle has been determined by the spreadsheet, the AEP & Optimize Macro now takes your actual cycle, calculates exact expected uptime and now "copies" that formula over the original estimate. In fact it does this 10 times, just to make sure the formula has completely settled. This does result in a small difference. So whats happening to the hit percent is probably your crit % changed just a smidgen through the optimization.

In short, this is not a problem but an increase in spreadsheet accuracy.

---------

Draiko ---
I need a lot more to go on than that. Neither item has gem slots which is the usual culprit as people lose their meta-gem requirement. Is the Upgrade Macro showing this? Is this a change by hand? Which version of the spreadsheet are you using? PC or Mac? Open Office? Are you sure you are looking at the right items and didn't change anything else at the same time?

 

• Aldriana

Took a few minutes to look at the differences between this sheet and mine, as some people have been noticing differences of significance regarding certain weapons. I still haven't managed to get total agreement between the two sheets, but I've found 2 differences of substance that account for at least part of it:

1) As far as I can tell, the energy cost of Blade Flurry isn't being accounted for anywhere, giving any rogue with that talent, effectively, 25 extra energy every 120 seconds.

2) Windfury modeling has it proccing off specials (i.e., Sinister Strike) when I'm pretty sure it shouldn't be. It also might be noted that the Buffed DPS calculations for MH weapon procs are getting the Sinister Strike attack count off the unbuffed cycles sheet, which is probably not correct either.

 

Left

I can't address (2), but in response to (1): Yes, Blade Flurry is actually accounted for. The sheet uses an average energy per second number on the "Buffed DPS" sheet to compute how much energy is available each second. Here is the formula from cell M4 on the "Buffed DPS" sheet (as of my 2.4.0.6 working copy):

The red portion is where Blade Flurry is accounted for. Basically, if you have the talent, the amount of energy you get per second is reduced by 25 per 120 seconds. Cell M5 contains a similar formula, but under the effects of Slice and Dice.

Now, I don't understand all the other stuff that goes into those formulas, or why one takes into account more than the other, but I do know that Blade Flurry is at least in there.

 

Dontmindme

Blade Flurry is accounted for as Left has explained. In terms of the energy cells, M5 used to calculate the effect of combat potency gains on Blade Flurry's energy contribution. Since I rolled Blade Flurry into permanent haste, these calculations became unnecessary simplifying the formula for the energy expansion. As permanent haste enters the combat potency formula on the front end, there was no need for the formula in M5.

Thank you for going through the Extra Attack block for me Aldriana. Sometimes its easier to find bugs in code you didn't write.
For those watching at home...
Buffed DPS cell C51 change uinstsec to instsec
Buffed DPS cell C53 change uinstsec to instsec
Buffed DPS cell C54 remove +instsec
And the rest of the block should calculate correctly.

In further news...
I've decided to occasionally upload my current working version (Excel only). This should have all fixes (and some upgrades) up to the date listed. Of course it could also have undiscovered bugs from new coding. The Excel version still works in Open Office last I knew (just need to deal with the Copy buttons). Mac is a little more problematic.

I believe it "may" be made to work with as few as the following steps:
1) Go to Tools-->Macro-->Visual Basic Editor. In the Visual Basic Editor, go to Tools-->References and uncheck Microsoft XML, v6.0 if it will let you.
2) Cut the Import from Wow Armory button on the Gear _ Buffs sheet

 

• Aldriana

Ah, good call on Blade Flurry. I was trying to figure out why the two sheets were giving different values for Instant Hits per second, and since Blade Flurry wasn't listed in the post-cycle calculations (which seems to me to be the sensible place for it) I assumed it wasn't there.

Hence, upon a little further investigation, the answer appears to be a difference in the way AR is modeled; this sheet is counting a significantly larger benefit for AR than mine. Now, I'm not an expert on this sheet, so I can't say for 100% certain what's happening, but based on Buffed Cycles cell V17 it looks to me like AR is being modeled as 5 extra Sinister Strikes and an Eviscerate... which costs 210 energy, versus the 150 that AR actually gives. It seems to me that the better model would probably be a 5 point eviscerate and as many extra SS (or BS, for dagger specs) as you have energy for. Regardless, this seems to be the energy difference between the two sheets; this sheet appears to utilize about an extra 60 energy every 300 seconds, which gives a proportionally larger number of instant attacks.

(Note that 60 energy every 300 seconds works out to 24 energy every 120 seconds, which is why I was initially suspicious of BF.)

 

dinesh

I'm not sure if it changed since March when it was implemented, but I believe DMM implemented it as a prorated portion of a 5e every 5 min.

http://elitistjerks.com/677109-post533.html
http://elitistjerks.com/677098-post532.html
http://elitistjerks.com/684358-post606.html

Perhaps he did switch it to be a full 5e at some point, and I just can't find it with search. I could swear there was some discussion about whether we could count on having a free finisher, CP procs, etc. in an AR build, but can't find any discussion like that now.

 

• Aldriana

Maybe that's what it's supposed to do, but that doesn't seem to be what it's actually doing. Consider the cell in question, Buffed Cycles cell V17. The term for AR is

+IF(arush,MAX(1,150/(instcost*5+evicost))*5/300,0)

So, instcost for SS is (just over) 40, and evicost is 35. So 150/(instcost*5+evicost) is 150/235, or about 2/3, which is thus less than one; hence, the whole thing evalutes to 5/300 if AR is up; thus, you're getting 5 extra SS every 300 seconds, which costs 200 energy, which is more than 150.

Alternately: with AR on and the default gear/buffs of the sheet, inst/sec is calculated as .3299; without AR, it's .3132, a difference of .0167. .0167 attacks per second for 300 seconds is... well, 5 extra attacks, just as we'd expect from the above analysis. So regardless of what it's *supposed* to be doing, what it's *actually* doing is giving too much energy.

So, as a first approximation, I might just drop the MAX out of that calculation and just make it +IF(arush,150/(instcost*5+evicost)*5/300,0), which would help; however, that's still miscalculating the cost of the eviscerate, as with Relentless Strikes eviscerate only costs 10 energy net. Also, for the swords case, since I think a lot of people do just queue up some energy and use that to get a full 5 point evis, it seems to me that a simple +IF(arush,(140/instcost)/300,0) might work as well as anything.

 

Dontmindme

Looking at it again, it also isn't taking into account Ruthlessless but easily corrected by changing 5 to $L$18. Assuming the formula gets worked out, the big problem is still what to do with Combat Daggers. Can't very easily charge the energy cycle for the difference as the difference is too much for any backstab cycle to queue. Suggestions?

Basically, Combat daggers is why I decided to prorate in the first place, so that I would be consistent on how the spreadsheet handled the different weapon specs.

 

Sinsei

DMM, there is a problem with the Save Gear macro. It's replacing the current gear build with your newly named gear build AND adding another same named gear guild to the list at the bottom. You end up with 2 same named gear builds.

Example:

The dropdown shows

Sample Tier 6
Sample Tier 5
Misc
Sample Tier 4
Sample Early-Kara

The sheet loads as downloaded with "Sample Tier 6"

I optimize my current gear with boomkin in raid and save it as "Current T6 w/boomkin"

The dropdown now shows

Current T6 w/boomkin
Sample Tier 5
Misc
Sample Tier 4
Sample Early-Kara
Current T6 w/boomkin

The first occurance of "Current T6 w/boomkin" is the real one, and the second "Current T6 w/boomkin" is the "Sample Tier 6" gear renamed as "Current T6 w/boomkin".

It's minor but the reason I'm pointing it out is because I spent 20 minutes putting my gear in and deleting one of the copies only to find out I deleted the copy with my actual saved gear =/

 

Phrenexia

I tried my best to read the rest of the posts, but I did not catch anyone addressing the topic of the set bonus for the new Fists of Fury set from trash in Mt. Hyjal. I recently picked them up and put them in the spreadsheet to see how they do. However, I cannot find anywhere that accounts for the set bonus (chance to deal 100-150 fire damage.) Is it really there, but hidden, or is there just not enough data on the procrate or whether it's affected by scorch/misery to put it in yet?

 

Sinsei

The proc isn't modeled yet because the proc rate isn't known I believe.

At 3 ppm I see it as worth 15 total dps even with full debuffs, maybe 20 at the very most.

 

Dontmindme

It's in the sheet, hidden under Proc/Other DPS. Its current being modeled as a 10% proc rate. There was a rather short combat log posted in one of the threads. That is the best estimate I have.

As to the Saved builds issue, that has been addressed. The fix is included in the "beta" version.

 

demibaka

Hi all, quick question:

I've been using the sheet for some time to calculate upgrades for myself and the jump from the last version to this one moves the Warp-Spring coil from being roughly equal to Hourglass of the Unraveller to about a 20dps increase for me. (I am mutilate) For comparison this is a bigger increase than DST is currently showing. Any idea what might have caused the change? Is this a reflection of greater accuracy or a bug on the new sheet?

Danke!

 

Garren

A quick interjection to AR modeling:

While it might be too much trouble to come up with a bunch of different plans for a talent of minor worth anyways, on a longer cycle would it not be best to use AR to just increase rupture uptime? For example, on a 5s/5r cycle, popping AR a few seconds before rupture ticks off would allow the extra energy to be used for a much higher (temporary) rupture uptime, without realistic chance risk of wasting energy. Or do the CP's wasted on severely cut SnD make up for the damage gained from using rupture instead of evis?

To that end, for daggers what about using AR to just pop a larger rupture, and maybe an extra BS or two dependent on cycle? Almost certainly this would be better than trying to cram a 3e cycle of dubious use into the normal rotation.

 

Dontmindme

First off, WSC and DST were modeled as approximations. These approximations were based on the most common Combat Swords spec. Now, they are accurately based off one's stats. Mutilate tending to be a more crit heavy spec really should be gaining more from WSC than other specs. Now the spreadsheet reflects that. The proc modeling is rather new, so I not going to rule out potential typos or bugs, but I certainly could see why WSC would be enhanced with a Mutilate spec.

 

demibaka

Oh ho, thanks for the reply! I wasn't trying to come across as rude or anything, I just genuinely had no idea which would really be better. <3 Now I have something to shoot for.

 

Orgulous

Hi Everyone,

I have downloaded 2.4.0.9.... I go to the Gear _ Buffs tab, click on Import from wow armory, put in my alt name, check all 5 import option boxes, click the button, enter my alt name, US server (I am in AU) copy my URL from the armory browser (open and I am logged in) and past it in... click start import....

I get a message "This Profile/file can't be loaded!"

I have checked/unchecked multiple options.... tried taking the http:// off the url... I have saved the file local (it is not read only).... can anyone help please?

Thanks heaps..

Org.

 

drumbum

You shouldn't be entering a URL at all. Just your character name, realm, and US/EU. I was able to successfully load using your character named Orgulous (the one listed in your profile).

 

Orgulous

Nice! thanks heaps... I thought I had to enter the full url... but server name is what it was after...

Thank to Drumbum for helping this dumbdumb

Org.

 

Zurgat

I have an odd situation with 2409, when i select an item in the gear_buff sheet a large "upgrade" button pops up over the item name.
Thus i'm unable to see the item name, and unable to select other items.


Sheet 2408 has a similar issue.


Sheet 2407 works fine.

-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.