WotLK DPS spreadsheet - Page 38

Cranch · 11/11/08, 5:18 PM

Agreed, Shandara, we don't need a large number of items displayed.

On the gear planner, I just have the LK 5 man and crafted selectors enabled, and there aren't even 10 items available in each slot (the SS fills in with unselected items.) The reason I suggested what I did is with these selectors enabled my gear doesn't show up on the list, so I can't tell if items on the list are actually an upgrade or not. My gear should either be sorted into the list always, or just displayed as a separate line -- either will work for me.

presidentofmalf · 11/11/08, 6:32 PM

Is it possible to get a spreadsheet that works without Excel? I have MS Works, and (obviously) it doesn't work. I don't want to have to buy a new program just to check it out. Maybe there's an online spreadsheet?

Cranch · 11/11/08, 7:11 PM

Originally Posted by presidentofmalf

Is it possible to get a spreadsheet that works without Excel? I have MS Works, and (obviously) it doesn't work. I don't want to have to buy a new program just to check it out. Maybe there's an online spreadsheet?

If you're still a student, the Student and Teacher Edition of Office 2003 is inexpensive (~$120) and has Excel. Get the 2003 version as you can just reinstall it as you upgrade your hardware.

Chasim · 11/11/08, 7:46 PM

EDIT: Below is my post... the problem was the Settings tab had a level 70 MoB versus a 73 Boss.

Using v.77a, I have 142 hit at level 70 but on the Overview tab after I hit Calc Attributes it shows I need -63 hit to cap? Is this a bug or am I missing a setting I need to change?

Thanks.

presidentofmalf · 11/11/08, 8:08 PM

Originally Posted by Cranch

If you're still a student, the Student and Teacher Edition of Office 2003 is inexpensive (~$120) and has Excel. Get the 2003 version as you can just reinstall it as you upgrade your hardware.

Thanks Cranch, but I was really trying to avoid paying $100 to look at my DPS

Your tip was appreciated though!

Kargos · 11/11/08, 9:59 PM

Originally Posted by presidentofmalf

Thanks Cranch, but I was really trying to avoid paying $100 to look at my DPS

Your tip was appreciated though!

What you can do is go to Microsoft's website and download a free 60 trial of office 2007 (professional, student/home,or excel) and use that for awhile ^_^.

samfisher · 11/11/08, 11:49 PM

Originally Posted by Shandara

I had left a hand-adjusted -50 hit rating on the gear tab which I didn't clear out before uploading it. It's most likely that.

I'm not sure what you mean, is there something I should adjust in my spreadsheet? I can't seem to find the value you hand-adjusted though on the gear tab =(

Glodd · 11/12/08, 12:44 AM

Is there any chance of seeing a fully functional version of this sheet that is compatible with Open Office before we really get into the swing of 25-man raiding at level 80?

Shandara · 11/12/08, 2:45 AM

Originally Posted by Cranch

Agreed, Shandara, we don't need a large number of items displayed.

On the gear planner, I just have the LK 5 man and crafted selectors enabled, and there aren't even 10 items available in each slot (the SS fills in with unselected items.) The reason I suggested what I did is with these selectors enabled my gear doesn't show up on the list, so I can't tell if items on the list are actually an upgrade or not. My gear should either be sorted into the list always, or just displayed as a separate line -- either will work for me.

What I will do is the following:
- Add a line showing your current equipped item.
- Modify the DPS displayed to show the delta instead of the absolute value.

Kargos · 11/12/08, 7:37 AM

Originally Posted by samfisher

I'm not sure what you mean, is there something I should adjust in my spreadsheet? I can't seem to find the value you hand-adjusted though on the gear tab =(

On the Gear tab there is a row of blue highlighted, specifically row 96, that allows for hand adjustments to stats.

Edit: Column 'L' is the hit column, hope this all helps. You should see it as a -50 in the blue in the midst of zeros.

Whitefyst · 11/12/08, 10:40 AM

Haste is now the socket bonus for some gear (Hollowed Mandible Legplates from heroic Azjol-Nerub as an example). As a low priority, could you please add it as an option on the Custom Gear tab.

Nakari · 11/12/08, 10:53 AM

I found some minor errors with gear / enchants:

- [Blade-Scarred Tunic] has 286 AP in the spreadsheet, but only has 148 in the game. It was bugged for a while in beta and had two +AP stats (which still show up in wowhead).
- the shoulder enchant [Fortitude of the Scourge] is misspelled (Fortitude of the Scourage), and probably shouldn't be there in the first place since it's a tanking enchant and no longer obtainable
- the Inscription specific superior shoulder enchant Master's Inscription of the Axe is missing

Also, the ability to add sockets to the hand, bracer (Blacksmithing only) and waist slot (through [Eternal Belt Buckle]) doesn't seem to be implemented.

Sarutobi · 11/12/08, 2:43 PM

There appears to be a bug with [Item not found!].

Maybe I missed something, but I can't see any reason as to why increasing the duration of a buff that's automatically refreshed by Chimaera Shot in a MM build would cause a 55 DPS increase.
(Unless the hunter in question wasn't hit capped, which is not the case.)

vvv EDIT: That would explain it.

Trinsian · 11/12/08, 3:05 PM

Originally Posted by Sarutobi

There appears to be a bug with [Item not found!].

Maybe I missed something, but I can't see any reason as to why increasing the duration of a buff that's automatically refreshed by Chimaera Shot in a MM build would cause a 55 DPS increase.
(Unless the hunter in question wasn't hit capped, which is not the case.)

Chimaera Shot does damage based on the total amount of damage that serpent sting would do for it's full duration. Increasing it's duration increases this total amount of damage, and thus increases the damage done by each Chimaera Shot.

Mathorli · 11/12/08, 9:51 PM

Is an Open Office version a possibility?