On your enchants_consummables tab there's a section for modeling Weapon Stones.

Am i reading correctly that the sheet is only modeling the haste (spellstone) and crit (firestone) components of these?

I'm destro (00/13/58) and the numbers here suggest that I should use the spellstone over the firestone. That gave me some concern because everything else I've ever read tells me to use the firestone.

Spellstone and Firestone are correctly modeled in the spreadsheet, however I don't know the accuracy of the overall destruction model. If anyone can see flaws with it, please post here.

Everything loaded fine when I tried. You might need to check some of your settings with Excel.

I think I'm having something of an error...

In the Main Sheet, the Next Stat section: both '+dps' and 'profitability' are returning values in the negative... Is that incorrect?? Because apparently, if I increase any stat, my dps will decrease, according to how I'm reading it

I had that problem when I switched the sheet to my secondary spec. It didn't switch glyphs so I still had Glyphs of Felguard/Quick Decay/Life Tap for a full destro spec. I corrected them manually and that fixed the Next Stat section.

- All the gem bonuses on the gear sheet don't change for me.. they remain as spellpower bonus unless I manually type in something else (however, the value of the bonus changes).

- Items that are shown as an upgrade on the Items sheet, when added to my Gear sheet, decreases my DPS.. for example it says Ring of Rapid Ascent (Heroic) is a 17.6 DPS upgrade from Memory of Malygos (Heroic) but when added to my Gear, my DPS decreases by 6 DPS. Perhaps the Items sheet is not counting the DPS from gems? Since Memory of Malgyos has a yellow socket and socketing a [Reckless Ametrine] is better than socketing a [Purified Dreadstone] in the blue socket of Ring of Rapid Ascent.

Edit: the following occurred a few times but somehow it works now.

- The hit % on the main page doesn't change when I take off hit gear or uncheck Heroic Presence, remaining at 17%, other stats seem to.

When I said "the following [...] works now" I meant the % hit (my third point), not the DPS calculation on upgrades (my second point), just wanted to clarify myself so you don't spend lots of time figuring the % hit problem.

Regarding the DPS calculation error:

Sorry, I don't know the behind-the-scenes of this spreadsheet well enough. I don't know what other information I can provide you apart from the numbers I am seeing. The gear I ran the spreadsheet with is the gear shown on my Armory page (except switch out non-heroic Ring of Rapid Ascent with the rings mentioned below) and the spec is my primary affliction one.

The Items worksheet shows:

[Ring of Rapid Ascent] (Heroic) = 365.6 DPS
[Memory of Malygos] (Heroic) = 358.2 DPS

The difference is +7.4 DPS.

The Gear_Buffs worksheet shows:

Equipping [Ring of Rapid Ascent] (Heroic) with [Purified Dreadstone] = 9470 DPS
Equipping [Memory of Malygos] (Heroic) with [Reckless Ametrine] = 9487 DPS

The difference is -17 DPS.

(In my previous post, I mentioned a difference of -6 DPS, that one was with BIS gear. This time I tried with my current gear to see if the result is negative again).

I don't think the DPS calculation has to do with recognizing gems as I suggested, I just tried changing the colours of the gems and the DPS of the items changed. Though it could be the DPS value of gems. When I switch a blue socket to a yellow socket, the DPS increase is less than the numbers on the Gems sheet says.

The Gems worksheet shows:

[Veiled Ametrine] = 37.97 DPS
[Purified Dreadstone] = 29.77 DPS

The difference is +8.2 DPS.

The Items worksheet shows:

[Ring of Rapid Ascent] (Heroic) with [Purified Dreadstone]= 365.6 DPS
[Ring of Rapid Ascent] (Heroic) with [Reckless Ametrine] = 368.7 DPS

The difference by manually changing the SOCKET from a blue socket to a yellow socket is +3.1 DPS.

Is it suppose to be that low? But again, I don't know the math functions and relationships in the spreadsheet.. so this is completely a guess and it could also be that I don't understand how the Items sheet and Gear sheet work together.

Build 0004 released to fix some bugs. Check the main post for details.

Yes, it occured as soon as I loaded character from armory. However, not occuring in new release - dps calculations returning normally.

Hmm... we seem to have two threads for the same sheet, maybe under two dev streams but common base. I'll quite what I put into the other one here in case either thread is killed. Offer stands ofc.

Having been the custodian of the development of this sheet I can attest to the difficulty of maintaining it over an extended period. My hope in picking it up was that a team would develop that could carry it forward enabling people to slack when life required without holding up the sheet. That didn't exactly happen but I still think it's the best way to keep a project like this moving.

Hoip, Item #50339 is not supported in the newest version.

Hey, I appreciate the work you've put into the spreadsheet! I just tried loading my data in, and it says here that Item #49191 is invalid, [Relentless Gladiator's Blade of Celerity] is the item if that helps any.

Thanks!

The gem socket bonuses aren't accounted for in an item's DPS value on the Items worksheet. Changing a bonus of 5 spellpower to 10 spellpower doesn't change the DPS value. Intended?

[Rigid Dragon's Eye] is suppose to be a yellow gem, not red as indicated on the spreadsheet.

EITHER: Spirit seems to be valued very high when I equip an item with spirit OR, Crit seems to be valued too low when I equip an item with crit. Perhaps it's the spirit on [Memory of Malygos] that's increasing its value and making it better or the crit on [Ring of Rapid Ascent] that's making it worse. This goes for every item with either spirit or crit. When I switch in an item with the equivalent stats except crit instead of spirit, my DPS goes down, which doesn't make sense because my "next stat" for +1 spirit is +1.05 DPS while +1 crit is +1.35 DPS.

So, when EQUIPPING an item: spirit items have higher DPS than crit; when VIEWING an item on the Item worksheet: crit items have higher DPS than spirit.

ItemID 50339 is not a implemented.

I also got the false positive from Norton. I was running the file in 2010 beta. Checked it against a few others and have found nothing. My question is why am I getting a false positive in this version and not the previous versions?

I'm going to guess it has something to do with the function or macro name for a model inside that sheet that didn't exist before. The message you see (and I use Symantec Endpoint Protection and get notifications on this sheet as well) is triggering off some match for a temp file containing "mumble mumble Cooldown something something".

ItemID 47517 not implemented. I believe this is the Blade of the Unbroken Covenant.

If your 2nd spec is empty, and you hit the load armory macro, on the first page, the macro stops loading your gear (it left 3 slots empty in my case). After i set my second set of talents everything worked great. thanks for all you hard work.

Item 51331 not implemented.

I think this was the new PVP neck. Might want to double check all the new PVP items while you're there?

Your trinket procs for Phylactery of the Nameless Lich seem a little wrong since the average spell damage you receive declines when you are casting more dots. What you had was:

918*(20/(90+(IF(used_immo,1/3,0)+IF(use_curse,IF(Main!$A$30="CoA",1/2,0),0)+IF(use_corr,6/ea_uptime, 0))/0.3))

But what I think it should closer resemble to in game mechanics would be:

918*(20/(90+(1/((IF(used_immo,1/3,0)+IF(use_curse,IF(Main!$A$30="CoA",1/2,0),0)+IF(use_corr,6/ea_uptime,0))*0.3))))

Thanks for your time

Item Id51335 missing
[Wrathful Gladiator's Pendant of Ascendancy]