Archived

This topic is now archived and is closed to further replies.

landsoul

(Updated 2/20) Fury DPS Spreadsheet 3.0.1a

311 posts in this topic

Please download >here<

Use this thread to discuss only relevant ideas or issues. If you are reporting any kind of feedback please be extremely detailed about how to reproduce it. Also, please don't post about armory import not working when in fact armory is down or you are in the wrong spec or wearing the wrong gear.

<Changelog Link>

Current Version: 3.0.1a

Changes

  • Added the ability to add a custom set of stats (instead of the ones loaded with the character) when playing with the ability calculator.
  • 2pT12 causes a directly noticeable drop in Melee DPS (see bullet #3).
  • Adding Tricks of the Trade at certain timestamps causes a noticable drop in Melee DPS (see bullet #3).
  • There was an error in my programming logic of searching for appled CS debuffs as well as Enrage uptime for specific melee slices, which is causing buffs to be turned off or on at incorrect times. CS was applied too often, and Enrage not often enough. A solution to the problem resulted in a 10% drop of Melee DPS and 3% overall. Also, an unfortunate increase in calculation time resulted in the fix for correctness.
  • Executioner stacks building was referring to the wrong column (BL) when summing, instead of the sum column for execute (BN). This particularly affected Executing styles that Executed more frequently.
  • Blood Fury should indicate as 120s CD in the UI, not 144, and also needed its 2nd column, 4th and 5th row populated with a formula.
  • Bloodsurge and War Academy should contribute additively as a set, not multiplicatively with regards to the damage modifiers on Bloodsurge Slam.
  • 3.0.1a Fixed Dropdowns not working for reforging out of a stat.
  • 3.0.1aFixed Advanced Profile Executioner Rotation not using Execute if there was nothing else to do.

Bugs:

  • HS@20 is not being prioritized over RB as SMF with 4t13 IR up.

Known Issues / Being worked on:

I am always looking for anyone who is an expert at excel programming logic and efficiency as well as experts in the field of probability and stochastic processes to help/collaborate on this project. Please, do not offer to help if you do not have expertise in these areas. Thank you!

  • Faster calculation time by having one timeline for GCDs and Melee, versus splitting them up and actually having decision good logic for GCD use.
  • Arms - Cannot solve yet without a model for probability a CS debuff will be active based on Sudden Death and 4t13. With this, creation of an Entire Arms sheet would be easy and only take time.
  • True SEP check per item is not yet available.
  • Alternate characters in character name must use the correct format when pulling from battle.net. Go to your battle.net character page and copy the URL into a notepad. Use the spelling code that your name appears there with the import in the spreadsheet.
  • MSScriptcontrol.Scriptcontrol object not a proper COM in 64 bit version of Excel.
  • Latency, key spamming frequency, and Latency Tolerance effect on GCD placement
  • Shout and Berserker Rage are being used a bit too frequently due to the lack of an accurate long cooldown model as described by the first point.

SPREADSHEET COMMUNITY COMPENDIUM GIVEAWAY:

Anyone who finds+posts a legitimate bug or error that has not already been posted, or finds a solution to any existing legitimate problems will win a Landsoulcoaching.com account with unlocked lifetime Compendium access. Legitimate means something along the lines of a mis-reference, incorrect item stats that affect the accuracy of the DPS of the item. To get this, you must claim it via PM and a link to your bug post.

About Trinkets and getting accurate DPS

You must manually enter the correct timestamps the trinket becomes active corresponding to what an actual fight may be.. This is located in the same window as the trinket selection.

Share this post


Link to post
Share on other sites

So found the first bug in Items.

Ring of Rivalry Normal, and Heroic are currently Haste/Mastery - Should be Haste/Expertise

Reg/Heroic Values = 127/143

Share this post


Link to post
Share on other sites

*Same issue stated above.*

License to Slay has a spelling error - Listed as Liscence to Slay in spreadsheet. (Not sure if you care about spelling :P)

Share this post


Link to post
Share on other sites

The Fireheart Necklace that is purchasable from the Firelands vendor is not available in the spreadhseet. Thanks so much for putting this spreadsheet together.

Share this post


Link to post
Share on other sites
The Fireheart Necklace that is purchasable from the Firelands vendor is not available in the spreadhseet. Thanks so much for putting this spreadsheet together.

It is in the Spreadsheet, It's labeled "Flameheart Necklace"

Also : Spiderstompers have been renamed : [iTEM]71029[/iTEM]

Share this post


Link to post
Share on other sites

Stats are missing on Voodoo Hunting Bow

69 Hit

66 Expertise

Also, I get an error about unreadable data when I open the spreadsheet ('07 version). It seems to work fine; nothing to worry about?

Share this post


Link to post
Share on other sites

It seems to happen when you switch weapons to 2x Sulfuras (R or H)

Then Equip T12 2P; When you equip the second piece it locks up the spreadsheet, a few minutes later the DPS Metric Screams #NUM.

Doesn't Matter if Pants+Gloves or Pants+Chest - I haven't tired any of the other combos yet.

Anyone else? ('07 Version)

Share this post


Link to post
Share on other sites

[iTEM]60227[/iTEM] is not reforgable. Crit has been hard-reforged (call it what you will), hence you can't reforge into Hit/Expertise/Haste. Unless you reforge away from Mastery - but that wouldn't work either as reforging an item two times doesn't work.

Share this post


Link to post
Share on other sites
It seems to happen when you switch weapons to 2x Sulfuras (R or H)

Then Equip T12 2P; When you equip the second piece it locks up the spreadsheet, a few minutes later the DPS Metric Screams #NUM.

Doesn't Matter if Pants+Gloves or Pants+Chest - I haven't tired any of the other combos yet.

Anyone else? ('07 Version)

I experienced the same thing on multiple tries. I switched to TG, equipped 2x H Sulfuras, fine up until that point, as soon I equipped 2 piece plus I got the same error. I used the '07 file with Office 2007.

Share this post


Link to post
Share on other sites

Great work, I love the amount of customization available in it.

I also had the spreadsheet lock up happen to me when I was fumbling around with Sulfuras and 2/4 piece T12. SMF weapons work fine, but it appears that every 2 hander (Not only Rag) throws the #NUM error eventually.

Share this post


Link to post
Share on other sites

I was able to get the dual sulfuras to work but i had to wait a few min without clicking on anything for it to load right. Otherwise the dps metric would read #NUM

Share this post


Link to post
Share on other sites
It seems to happen when you switch weapons to 2x Sulfuras (R or H)

Then Equip T12 2P; When you equip the second piece it locks up the spreadsheet, a few minutes later the DPS Metric Screams #NUM.

Doesn't Matter if Pants+Gloves or Pants+Chest - I haven't tired any of the other combos yet.

Anyone else? ('07 Version)

I'm able to reproduce this, It takes the iterations all the way to the maximum amount (100), then quits and spits out #NUM! This happens with any Non-SMF and 2t12 combo. I'm taking a look into it.

Update: It seems to have a hard time reordering the melee timestamps, because of the T12 shout not figuring out where to go, which is a result of Raging Blow moving around too much, which is a result of Enrage Uptime not knowing what it is, which is a result of the melee timestamps moving around to much.

The root problem is the Enrage Uptime Forumla defaults to 1 if it's formula results in an error. This basically causes an infinite loop when T12 shouts activate and change the melee timestamp indexing. If go to the Fury Calculation tab, and find cell BA187, it should look like this:

=IF(ISERROR(1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203))),[SIZE="4"][b]1[/b][/SIZE],1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)))
Change that cell to this:
=IF(ISERROR(1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203))),[B][SIZE="4"]0.75[/SIZE][/B],1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)))

Thus, when Enrage Uptime formula gets an error, it defaults to a value that matches more closely its expected value, so the entire calculation process doesn't endlessly loop when re-indexing the melee timestamps. See how this fix works for your spreadsheet.

Share this post


Link to post
Share on other sites

Thanks a lot Lansoul for working on this, I just have one question about the flurry and enrage calculations.

-Flurry and enrage uptime seem abnormally high, after imputting my gear ( buffed stats: 21.55% crit, 20%haste,8%hit the sheet says I should have 72% enrage uptime and 89% flurry uptime.

Is that normal?

Share this post


Link to post
Share on other sites
Thanks a lot Lansoul for working on this, I just have one question about the flurry and enrage calculations.

-Flurry and enrage uptime seem abnormally high, after imputting my gear ( buffed stats: 21.55% crit, 20%haste,8%hit the sheet says I should have 72% enrage uptime and 89% flurry uptime.

Is that normal?

If you have weapons synced set to "Yes" then you will have higher Flurry Uptime.

Share this post


Link to post
Share on other sites

Spreadsheet is showing 27.9 expertise rating as Goblin with the following;

Reg. Earthen Helm (reforged exp to crit)

Heroic Massacre Treads (Mastery to crit)

Reg. Alysrazor's Band (haste to crit)

Reg. Cloudburst Ring of the Landslide (not reforged)

Heroic Heart of rage (exp to crit)

Crossfire Carbine (not reforged)

Armory shows 26 expertise

In-game shows 6.5% and 788 expertise (26)

I don't think I overlooked any other modifiers. Can anyone re create this or is anyone else seeing an issue here?

Share this post


Link to post
Share on other sites

In my sheet (WarriorDPS3.0BETAExcel07.xlsm) i have


=IF(ISERROR(1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)));0;1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)))

if i put

=IF(ISERROR(1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)));0,75;1-(1-BA185)^(BA186*(D241+E241+K207+P236+Q236+V235+W235+AI206+AC203)))

i have the same error !NUM! (for the same issue with 2 pieces T12)

The ',' instead of '.' is because of the localization, not an issue there.

Thank you

P.S. This happens only for TG

Share this post


Link to post
Share on other sites

When playing around with it I could not identify the SEP values. "Fury Calculation" rows 21-33 in column F look like a candidate but am I correct?

Share this post


Link to post
Share on other sites

The whole offhand-expertise-calculation doesn't work. In the 'Fury Calculation' tab in line 5 is a 8 in the calculations for 'DodgeOH' where there should be a 9. (It's (for a Bosslevel-mob)

=MAX('Shared Tables'!R22-HLOOKUP($R$31;RatingsMatrixFury;8;0)*0.0025;0)
. It should be
=MAX('Shared Tables'!R22-HLOOKUP($R$31;RatingsMatrixFury;9;0)*0.0025;0)
) (Sorry for my english, but mathematic/excel terms are something, I have to use at least rarely (especially) in english) /e I've just seen, that the calculation for the offhand-avoidance from Raging Blow and (SMF) Slam is equal to the Mainhand-avoidance, where it should be
HLOOKUP(N2;HitTableFury;3;0)+HLOOKUP(N2;HitTableFury;5;0)+HLOOKUP(N2;HitTableFury;6;0)

Share this post


Link to post
Share on other sites
The whole offhand-expertise-calculation doesn't work. In the 'Fury Calculation' tab in line 5: It should be
=MAX('Shared Tables'!R22-HLOOKUP($R$31;RatingsMatrixFury;9;0)*0.0025;0)
) I've just seen, that the calculation for the offhand-avoidance from Raging Blow and (SMF) Slam is equal to the Mainhand-avoidance, where it should be
HLOOKUP(N2;HitTableFury;3;0)+HLOOKUP(N2;HitTableFury;5;0)+HLOOKUP(N2;HitTableFury;6;0)

This is correct, thanks for finding this.

RB OH does not hit if MH does not from what I have tested.

Also, SEP values are underneath the ability distribution charts on the Fury page.

Share this post


Link to post
Share on other sites

Hello Landsoul and thank you for your work (sorry for my english in advance!)

I just want to ask if the arms spec hasn't been integrated yet or if my excel version has a problem. I can only choose "fury" in the option box on the Lookup page.

I'm well aware that this is still a beta version but I just want to be sure that I don't have some sort of bug with the sheet.

Thanks

Share this post


Link to post
Share on other sites
Hello Landsoul and thank you for your work (sorry for my english in advance!)

I just want to ask if the arms spec hasn't been integrated yet or if my excel version has a problem. I can only choose "fury" in the option box on the Lookup page.

I'm well aware that this is still a beta version but I just want to be sure that I don't have some sort of bug with the sheet.

Thanks

Arms is not implemented yet, Landsoul has said it on a few occasions.

I have another question, maybe I am doing something wrong but from my calculations Apparatus of Khaz'goroth should be better than License to Slay. 383STR and 2540/8 crit, vs 380 STR and 193 Hit and 128 Crit (if reforged). However when I put them in the spreadsheet they the Apparatus is almost 300 dps lower than LtS. I've got around 15% hit (as SMF) so there's no way hit could outperform crit. Interestingly enough even the heroic apparatus is 60 dps lower than LtS. Am I missing something?

Share this post


Link to post
Share on other sites
Arms is not implemented yet, Landsoul has said it on a few occasions.

I have another question, maybe I am doing something wrong but from my calculations Apparatus of Khaz'goroth should be better than License to Slay. 383STR and 2540/8 crit, vs 380 STR and 193 Hit and 128 Crit (if reforged). However when I put them in the spreadsheet they the Apparatus is almost 300 dps lower than LtS. I've got around 15% hit (as SMF) so there's no way hit could outperform crit. Interestingly enough even the heroic apparatus is 60 dps lower than LtS. Am I missing something?

Double check the "Custom Event Matrix" portion of the spreadsheet. I saw the same behavior and noticed that Apparatus was only being used once over the course of a fight. Filling in the next 2-3 uses put Apparatus well ahead of License to Slay.

Share this post


Link to post
Share on other sites

Hello! Was playing with putting my gear in the sheet and noticed that:

Dragon Bone Warhelm (normal) has 281 strength instead of 259 strength!

Thank You very much for this great piece of work

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.