Yep

125 * .12 = 15

125 - 15 = 110 (so 1.10)

@Landsoul:

Page: FURY
Type: REFERENCE (Not sure how to classify this).

To start: I downloaded the last iteration of the spreadsheet, however, when I run it, Excel indicates that parts of the spreadsheet are corrupted and asks to use the source to repair it. I proceed with the repair after a few more attempts to download the spreadsheet again to avoid having to repair it failed.

The error: When on the fury page, I was changing information manually as opposed to querying the armory. When i go to change the race from the default "Night Elf" to "Undead" the sockets on the gear listings go blank and the DPS counter at the top drops from 8000+ to 2000+. Not sure if this is related to the repair I stated earlier but I verified this behavior on two different connection and on two different systems.

@Hungrymoo:

The link I posted a bit back should have taken you to Goatsey's post where he addressed where to make the ARP conversion rate change on the spreadsheet. Sorry if it just took you to the front page. For reference, it's post #1606 in this thread and has been addressed again in a few posts above.

Potential fix - if you're wearing tier or other faction-specific gear, make sure you change it all over to the Horde equivalents. I believe this has already been covered at some point, unless the faction-specific nature of the gear happens to be irrelevant in this case.

Landsoul, I noticed that Nitroboosts in your spreadsheet only give 16 Crit Rating instead of the 24 Crit Rating they give on live?

Also does anyone know where I can go to modify this myself in the spreadsheet?

It's giving 24 on mine, you can check cell N204 to be sure.

Umm no...

1.25*0.88=1.1

The reason is because he is alliance and the draeni passive 1% hit aura.

I updated my copy of Excel to the latest service pack (SP2) and I stopped having that problem.

Landsoul, it appears you fixed the non-heroic version only. I got the heroic Gormok's last night and was wondering where it was in the sheet.

Keep up the great work!

He changed it because Blizzard had reg Carnivorous as Alliance, heroic Carnivorous as Horde, and vice versa with Gormok but with 3.2.2 they fixed the error. Now both Carnivorous are Alliance and both Gormok are Horde as it was supposed to be.

Page: lookup
Error Type: typo

The Diplomat (Heroic) now provides 23 stamina instead of 20.

Page: Fury
Type: Div#/0 Error

I just went and tried to use the fury part of the spreadsheet and Banner of Victory, DMC: Greatness and Berserking all come up with Div#/0 errors.

For furry BiS list: I have better results using Bracers of the Untold Massacre (Heroik), with Greaves of the 7th Legion(Heroik) and Bloodbath Belt (Heroik). Also Planestalker Band (Heroik) instead of Band of Violent Temperment (Heroik)!
All gems are ArP ones, exept 2 yellow slots with 10str+10crit and 10all stats in Head.
9855.265 DPS...

Check the front page for updates.

Finaly make my Sep macro to work first i use http://office.microsoft.com/en-gb/he...141151033.aspx then i change "." with "," in c102 and c104.

Just wanted to add that i still get better results with Waistguard of Deathly Dominion instead of Bloodbath girdle (~150 dps difference according to the sheet) and Talonstrike instead of Rhok'shallah for BiS gear.
And whoever infracted me last time i wrote this for handholding, this is no question, it is a suggestion for a more accurate BiS List.

Thanks for the quality updates, Landsoul. I noticed that the sword spec changes are not in the update notes. Were they not implemented for this version of the Arms sheet? I'm not expecting this change to make a big difference but it might be interesting for those of us who have had excellent luck acquiring swords and terrible luck getting maces and axes.

Sorry if this has been addressed; I searched for related problems but didn't find anything that helped me.
I am unable to run the spreadsheet on my desktop computer. I have Windows Vista 64b and 2007 fully updated Excel. I can open the spreadsheet; however, when I click on any buttons, like "Fetch Armory," my excel freezes up and becomes non responsive. I pretty much have to restart my computer to get it to go away because I can't even close it through task manager.

Anyway, I can run the spreadsheet just fine on my laptop, which has Windows XP and 2007 fully updated Excel. My only guess is that it has something to do with Vista 64? My Excel, as I stated earlier, is fully updated and I have all macros enabled. I'm just getting annoyed that I have to pull out my crappy school laptop any time I want to play around with the spreadsheet. Any advice would be greatly appreciated.

It looks like they're in there if you check the formulas, it's just not a noted change on the front page here.

I do know I can add this in myself but the Horde Polearm (and Alliance equivalent) Anguish/Foredragon Blade are missing from the spreadsheet.

I thought the new sorting feature, with DPSdiff, basically checked each possible item in a given slot and checked the DPS against the currently equipped item. And the DPS would be the same as the Arms page. In my case if I equip Belt of Singing Blade, DPS reads 6934.0468, then if I equip Belt of the Twilight Assassin it reads 6922.6192. However, in the Lookup sheet it shows Twighlight assasin is a 33.8 DPS _increase_?! Whats going on here? Am I completely misunderstanding what the "Click to run item comparison" does?

Page: Lookup
Error Type: Typo
Helmet of Wrath has 141 stam and 140 str when it should be 141str 140 stam. Nothing too big.

However every time I import my character into my spreadsheet the items Bloodbath Belt, Carnivorous Band, and Boneshatter Armplates all come up as the non-heroic version of them instead of the heroic.