WotLK DPS spreadsheet - Page 44

• Intermission · 11/24/08, 11:56 PM

I hope I'm not stepping on the author's toes by saying this, but you can easily unprotect a workbook without the original password. Google.

Shandara · 11/25/08, 4:25 AM

Originally Posted by Intermission

I hope I'm not stepping on the author's toes by saying this, but you can easily unprotect a workbook without the original password. Google.

The password isn't there to frustrate users, but rather to prevent the inadvertent changes to cells that aren't supposed to be changed.

I'm very much surprised a few users have such big problems with the sheet, because I have not been able to find any cells that are locked when they were supposed to be editable. I very much think it's a problem with their setup, because I haven't had a flood of PMs regarding the issue.

Are all cells non-editable, or just a few specific ones?

Lerastes · 11/25/08, 4:45 AM

Originally Posted by Shandara

The password isn't there to frustrate users, but rather to prevent the inadvertent changes to cells that aren't supposed to be changed.

I'm very much surprised a few users have such big problems with the sheet, because I have not been able to find any cells that are locked when they were supposed to be editable. I very much think it's a problem with their setup, because I haven't had a flood of PMs regarding the issue.

Are all cells non-editable, or just a few specific ones?

I haven't tested every single cell but I cannot change anything in Overview, any of the Default Values in Settings, or any cell in Custom Gear.

Shandara · 11/25/08, 7:36 AM

Originally Posted by Lerastes

I haven't tested every single cell but I cannot change anything in Overview, any of the Default Values in Settings, or any cell in Custom Gear.

The default values in Settings can't be changed at least, use the yellow 'custom value' field next to it.

• Intermission · 11/25/08, 8:28 AM

I have no problems at all, however I believe he wanted to edit your internal gear list thingy to add some new items without using the built in custom gear tool -- I have no idea how these mammoth types of spreadsheets work.

The only reason why I unprotected mine was to change some font/size settings. And as you said, because it's unprotected I now have to be careful that I dont muck something up!

greenjello · 11/25/08, 10:22 AM

Big thanks to who are involved in the creation/maintenance of this spreadsheet.

Question about attack power vs. agility for BM hunters. Using Beast Tamer's Shoulderpads and 2 pc T7 bonus, my pet cat is responsible for well over 50% of my damage on most if not all boss fights. Given that AP now "scales" with Trueshot Aura in much the same way that Agility "scales" with Blessing of Kings, and seeing as how the only stat (aside from hit) that my pet benefits from is AP, would not AP be the superior gem/enchanting choice?

The spreadsheet SEEMS to suggest so: Using my gear and spec it displays AP as 0.943 per item budget and AGI as only 0.781. However, when going from all 20 AGI gems and AGI to gloves enchant to 40 AP gems and AP to gloves enchant; The result is nearly a 100 dps drop.

So I guess I have 2 questions: Firstly: why, if the spreadsheet's attribute budget calculator shows AP to be the superior stat, am I showing a loss in dps when gemming/enchanting for it? Secondly: which, then is in reality the superior stat for a BM hunter in entry level T7 raid gear, given that both Blessing of Kings and Trueshot Aura are typically present?

KergeKacsa · 11/25/08, 10:26 AM

On the Settings tab Gem Options cannot be changed, I think this is a bug.

Missing gear:
Grips of the Beast God
Jagged Ice Band

btw, great job

Ebonleaf · 11/25/08, 11:02 AM

I've got a few more items for the sheet and a correction...

I got the [Drake-Mounted Crossbow] last night, but the sheet doesn't recognize it.

And for addition..

[Plunderer's Helmet]

[Cloak of Holy Extermination]

[Azure Ringmail Leggings]

Thanks again Shandara for all your hard work.

Shandara · 11/25/08, 11:23 AM

I'm currently busy passing through Wowhead again and adding all epic/blue 71-80 items, so please hold reporting any missing ones until I finish and publish the next version.

EDIT:

Update:

- Custom rings with a socket will have the correct dropdown menu
- Corrected more spelling mistakes on items
- Socket bonuses now include Mp5 and Haste for all item categories, including custom gear
- Added nearly all level 71-80 epic/blue items

The extra blacksmith socket enchant is in the works, but I need to figure out how to pull that from Armory first before I add it.

legomyegolas · 11/25/08, 12:27 PM

Awesome. [Bjarngrim Family Signet] has a typo though (it's Bjarngrim, not Bjarngrin.) Also, the [Heartseeker Scope] doesn't seem to load right from armory.

ty so much for all the hard work!

Shandara · 11/25/08, 12:28 PM

Originally Posted by legomyegolas

Awesome. [Bjarngrim Family Signet] has a typo though (it's Bjarngrim, not Bjarngrin.) Also, the [Heartseeker Scope] doesn't seem to load right from armory.

ty so much for all the hard work!

I need to know the tooltip texts for some of these enchants/scopes so I can scrape them correctly.

legomyegolas · 11/25/08, 12:43 PM

Originally Posted by Shandara

I need to know the tooltip texts for some of these enchants/scopes so I can scrape them correctly.

For the heartseeker it's "+40 Ranged Critical Strike"

Cattiebrie · 11/25/08, 1:26 PM

Only perused the last couple pages to see if this had been reported recently, but the Belt Buckle "enchant" that adds a socket to a Belt item does not seem to be supported.

Edit: Also thought I'd report that I'm also unable to load my information from the Armory. I get: "Run-time error '91': Object variable or With block variable not set". Debugging highlights this line:

sName = Node.Attributes.getNamedItem("name").Text

Using Office '07.

Edit 2: [Figurine - Emerald Boar] is just listing as "Emerald Boar" under the Trinket list, and no gems are showing up in the drop-down gem list for it.

Decker · 11/25/08, 1:35 PM

Originally Posted by KergeKacsa

On the Settings tab Gem Options cannot be changed, I think this is a bug.

Missing gear:
Grips of the Beast God
Jagged Ice Band

btw, great job

Are you trying to change the protected cells? This is common. At the top ensure that "Use Defaults" is set to no, and then instead of trying to change the gems, you should be adjusting the adjacent cells (Light Yellow? Cells F15-F18).

That should fix the problem.

Dralmoo · 11/25/08, 1:39 PM

Couple of minor problems:

* Master's Inscription of the Axe (Inscription Shoulder enchant) isn't supported via armory. The tooltip shows up as "+104 Attack power and +15 Crit rating".

* Kill Shot is never used (although this might be user error).