I am probabbly doing this wrong, but seems like the spreadsheet cant find european armory. I have enabled macros, but still get errors. Anyone know what I should do? Thx

*edit*
Nvm, got it :o

Changes in 2.502:
(...) -5/5 Sword spec now grants a 10% on-hit chance for an extra attack, 10 second ICD

That's from the first post. Is it just a typo? I believe I've seen 10 seconds sword spec proc ICD being used in arguments around these forums too, but don't quote me on that.

So I just downloaded the spreadsheet and was inputing all my gear. I got everything filled in and was looking over some stuff and realized that I hadn't changed the race. I switched it from Night Elf to Tauren and the calculated dps metric dropped almost 2000.

Is this because the gear that is listed is all alliance based, and I should just keep the race as alliance? Or is there a way to adjust the sheet to use horde items?

The sheet automatically uses horde items when you change races, it just doesn't update the items you have selected to their horde equivalent. Just click on the item and select it's horde equivalent.

^ this.

Sorry the front page update info is definately a typo, sorry about that.

Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.

Hello Kitty. Definitely.

To get you started:





...


In all seriousness, I'll try some stuff in the sheet to see what styles / types of textures work well with it. Question: when you say "...new functionality something.", what do you have in mind?

Wishlist-wise, I think the following would be nice for convenience:
- a button or option to swap your MH and OH weapons as fury. While upgrading my alt's gear I've been through several different pairs of weapons and even though it's usually pretty obvious, confirming which one to main hand is always a bit of pain for socketed weapons or weapons with different enchants.
- a cell that generates a Pawn import string for your current SEP values. This would only be useful to people who actually use Pawn, but for them it makes keeping up to date Pawn scales really convenient. The hunter spreadsheet at WotLK DPS spreadsheet for instance automatically generates such a string (on the overview tab, underneath the equivalent of the SEP table) and you can just copy to clipboard and paste it into Pawn's Import box ingame
- a bit of explanation, perhaps on the intro sheet, on how to interpret the information presented in the Execute table. Perhaps I'm alone in this, but I've never been able to figure out what the 3 intercept values there mean, and had trouble finding the DPR/DPGCD values to compare to for WW/BT/Slam at the rage points the table lists (I assume the values in the Execute table are all for Execute itself).

And this last isn't really a layout suggestion, but having the sheet disable your metagem when your current gems don't satisfy the requirements would be nice.

edit: and if you're really in the mood for a large change, support for saving different profiles would be handy - i.e. having named configurations of gear and talents you can switch between from a dropdown, without having to keep around multiple copies of the sheet.

Cleave and whirlwind make huge contributions in a fight like Anub. I think it would be interesting to see DPS if there are multiple targets, and how that impacts SEP.

Regarding BiS lists on the front page. When using 1 DV, I dunno if anyone else has found this by playing with the spreadsheet, I obtain higher dps from using the [Belt of Deathly Dominion] and [Greaves of the 7th Legion] rather than using [Bloodbath Belt] and [Icewalker Treads] as suggested in the 2nd option of gearing for fury.

I agree that having an automatically generated PAWN string in the spreadsheet would be pretty handy for anyone using the PAWN addon. If the spreadsheet had an "Optimize Gemming" button that calculated the optimal gemming for you character, and possibly even the best food to buff with, I’d be willing to bet a lot of people would be excited about this functionality. It could take into consideration if you where a Jewelcrafter, or had extra gem slots from being a Blacksmith. The same could be said for having a "Optimize Enchants", but I think most people should know which enchants they should be using at this point.

Expanding on what Anduryondon suggested: support the import / export of CSV files through macros.

This would accomplish a few things:

1. Allow users to save character setups for archival purposes (through exporting a CSV file of the character)
2. Allow users to load character setups (through importing a CSV file)
3. Allow users to import non-spreadsheet generated character setups (eg. Rawr's)
4. Facilitate quicker and easier comparisons between various gear setups

Another option I'd love to see is allowing the user's choice of potion from the popular suspects (Speed, Wild Magic, Indesructible), with the additional option of pre-potting an Indestructible. Creating options in the existing dropdowns for the best Elixirs, as well as the +Armor Guardian Elixir, would be great for comparison purposes, as well.

I'm kind of an excel noob, so I was wondering if anyone could help me. Every time I enter my info to look up my gear, it looks up everything through my chest piece, and then gives me an error message;

Run-time error '1004':

Unable to get the VLookup property of the WorksheetFunction class.

Would this be a problem with my excel program? Or is it a macro error or something?

^this is the only thing the spreadsheet is really missing. Would be great if you could implement that landsoul.

Another thing would be some kind of more filtering in the lookup, e.g. 10man and 25man --> for those "dedicated to insanity 10man" or "herold of the titans 10man" set builders. right now theres no difference in 10man or 25man colours. could be easily solved with light tones for 10man and darker tones for 25.

keep it up! love you landsoul!

They've just released some incomplete loot lists for the 5-man ICC instances on mmo-champion and theirs a pretty interesting trinket dropping in there - Needle-Encrusted Scorpion - Items - Sigrie

What confuses me however is how Mjolnir is 6 ilv lower than it yet the only difference is 12 crit rating at a huge cost of 213 ArP on the proc. Assuming we model it in an ideal world with it proccing every 45 seconds thats an average loss of 47 ArP rounded down. I can only assume this is either a placeholder with an incorrect value or blizzard have messed about with ArP itemization believing that mjolnir was too great of an asset to ArP friendly classes.

Probably the latter, this trinket might be a good "transitional" trinket for icecrown tbh. Something for when your gear carries you past mjolnir soft cap, but not yet to the point of going for 100% passive ARP.

I put it into the sheet already.
I ran a little test to see which was better using runestone or scorpion and here's how it worked.

I equipped 2 DV's and used a mix of ICC and TOC gear and then got my armor pen 667 from the cap mixing gems.
I then equipped Runestone in place of 245 DV and got 2 rating from the cap.
I then re-equipped the 245 DV and got my armor pen 459 from the cap mixing gems.
I then equipped Scorpion in place of 245 DV and got 7 rating from the cap.

Runestone was significantly better. To visualize how it is better without doing math, think of it this way:

With runestone proc up, you have 200+ more STR than with Scorpion proc up.
With procs down, you have 200+ less ArP and 200+ more STR with Runestone than with Scorpion.

The increased passive armor pen at the cost of strength at that armor pen level to make the trinkets work, is not worth the strength loss when the proc is up.

A 33% loss in the linearly extracted ArP rating on the trinket from what you'd expect could be made up for with a 50% increase in uptime. I'd much rather see that anyway, so we don't have to try so hard to keep below the ArP soft cap with a proc as high as Mjolnir.

I think Runestone vs Scorpion is really no direct contest. If you are below arp soft cap from GEAR, then Runestone clearly wins. All i said is that, MAYBE ICC gear will leave us with 900+ PASSIVE arp before gemming (not hard to do with TOC gear, although not practical because of expertise lacking etc). Which means Mjolnir wont be an option anymore (as it will lose to 245 DV).

Only test to really matter i think is : Assuming increase in ICC gear to easily geyt us to higher ARP then toc, will it be better to have

400 STR + Scorpion

or

400 ArP + Deaths Verdict (245)

Again - if you are low enough on GEAR ArP so that mjolnir is fully utilized, then its clearly better. But it might not be the case in ICC.

I haven't looked into item budget for proc based items, however it could just be the scorpions ilv 219 and will drop on normal when it goes live (Anyone who can derive the procs budget please feel free to correct this) assuming the datamined values on mmo-champion are incorrect.

However I'm still adamant that its a placeholder, I find it extremely unlikely that Blizzard would mess about with proc budgets since all the other ArP gear in ICC has scaled properly with its ilv besides this trinket.

Also correct me if i'm wrong but does there even exist a proc trinket which breaks the 45 internal CD rule? as if their isnt I doupt they'd start here with this.

On other hand the 2h from 1st boss is strange. The complete lack of stats (almost) coupled with faster speed made me very reluctant about it. Im still reluctant to say it will replace TOGC weapons (well at least heroic JB), but the proc indeed is very powerful as it seems. It added 360 dps or so to our DK, a bit over 400 for me. Considering its a normal weapon, heroic one might be interesting.

The proc didnt seem to have any ICD, and do more healing then BT self heals too. I guess if nothing else double axe might be fun to solo some weird shit as fury (dual axe provides quite a lot of healing).

Yea I first assumed it was a 45 second internal CD making the DPS of it very sub-par compaired to Decimation & Heroic JB, however hearing that there is no CD sounds pretty interesting as to simulating it and working out the proc rate. The speed on the otherhand is still dissapointing however, you would of thought 3.6 would of been staple in the last raid of Wrath.

Weapon procs and weapon enchants rarely have ICDs; that's more of a trinket/talent thing.


--- EDIT: The following information is incorrect, because I used the spreadsheet improperly ---

As for the weapon speed, load up the spreadsheet and lower the speed of DBB/JB by .1 and see what actually happens for Fury.

The fact that it's 3.4 hurts Arms but helps Fury, and not by a lot in either case. It's the Rets and DKs who will be crying, as .1 DPS for them is several hundred SEP.