I Could be wrong but isn't FI overwritten by AI do to the intellect portion?



You are correct, as a fellow mac user, I use vmware fusion and the latest version of excel (you can find a good version if you umm, know where to look wink wink because I'm sure you have a legit version of excel for mac, and it is just an unfortunate oversight that it doesn't work as well as it should). I can how ever, save my current worksheet and bring it over to the mac side, and use it, It just poops it self when I try and import from armory and such, and occasionally locks up. If you have a decent computer it's not a big strain, just a hassle.

From what I recall, it only overwrites the intellect portion but you still receive the spirit portion unless you have a higher spirit buff present. Even so, I believe the buff itself stays up because it's not a direct copy of another ability.

Aah ok, I haven't run with a Mage and a felpup in a raid in a long time, nor do I pay strict attention to most of my buffs do to the lack of difficulty in content these days.

Thanks - it was hidden by clicking on flametounge totem (had a drop down to select totem of wrath).

For the felhunter we do get the spirit bonus even with the better arcane Int out there from a mage (just no benifit from the int portion of the puppy's buff).

Maybe one day we will have a disc priest so I can use my imp instead... till then puppy power

The problem lies in the sorting algorithm: it mirrors all of the other sorting techniques, but for weapons it's necessary to sort columns A and X, which are normally ignored. Here's how you can fix it in your own spreadsheet.

Short version: create a new named range that includes columns A and X, and reference it in the VB sort function. Modifying the old named range does not work.

Long version (Excel 2002):
1. Select menu item Insert//Name//Define...
2. Select items_mh
3. Give it a new name, like items_mhsort
4. Change the range to =Items!$A$633:$Y$681
5. Click the Add button
6. Click OK
7. Right click the Sort Items button, select Assign Macro...
8. Select Sort_gems_dps
9. Click Edit (The visual basic editor will open)
10. In the Sort_items function, change "items_mh" to "items_mhsort" in this line:

Sheets("Items").Range("items_mh").Sort Key1:=Sheets("Items").Columns(SortCol), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

For some reason I can not get the spreadsheet to retrieve any information from the Armory at all.

I am using Excel 2003 SP2 and have tried with all the Wotlk versions of the spreadsheet.

Currently I download the spreadsheet from www.leullier.com, open it and enable the macro's, update the information on the Armory tab and when I click "Import gear from armory" on the Gear_Buffs tab I get the following Visual Basic error;

Run-time error '-2147012889 (80072ee7)'

The server name or address could not be resolved.

I can access the armory normally with no problem, and I get the error even if I select a random level 80 warlock from any server.

Obviously I am doing something incorrectly since no one else appears to be having this issue. If anyone knows what it is, any help would be greatly appreciated.

Whitetooth, your version of the spreadsheet has the following formula for the 2 piece T7 set.

'=COUNTIF(Gear_Buffs!Q7:Q71,"T7")>=4'

Would it be possible to sort the MH/OH DPS factoring in an OH?

I'm thinking this may need to be another button to keep things clean and would probably have to be driven from the currently 'equipped' item on the Gear_Buffs page but would certainly put things in context more I feel.

I'll try and get time to have a look at this myself but as I'm kinda swamped atm I thought I'd throw the idea/request out there in case anyone else wanted to do it.

I'm not quite sure what you're asking for, because I think the spreadsheet already does that.

When you fix the weapon sorting using the technique above (or by using version j from the post below), the weapons get sorted according to dps: the MH weapons using the OH you've specified on the Gear_Buffs sheet, and the 2H weapons as if you have no OH weapon.

New version J up at WoW Warlock DPS Spreadsheet

It seems some of the Normal Damage Calculations aren't correct, is says my Corruption would do a smacking 115365 dmg
and 896322 DPSC.

Several others might be off as well if I compare the values to this post.

(using 303j)



P.S. Thanks for making and updating this

Hello.

I know it's usually a bad idea to start on a forum like this but seeing that I couldn't find any help any place else, I will vent my problem here as it seems that this thread is the official discussion of Leulier's Spreadsheet and my question is linked to it.

The thing is that I can't make the spreasheet to download any sort of information regarding my character. I have entered the required information under Armory Info tab but nothing happens when I press the "Load Gear from Armory" and the "Load Talents from Armory" buttons. I have manually entered the talent points of my current spec but the situation turns tricky in terms of gear. Any idea what the problem is?

I use Open Office 3.0.0

Thanks in advance.

OpenOffice is not supported by the maintainer of the spreadsheet and it doesn't work with it at all. At least I never got it working or saw anyone posting here who did. According to other Posts it doesn't work with some Excel Versions for Macintosh.
The only way to get it to work without editing it a lot is using MS Excel for Windows it seems.

As I suspected. :/ Thank you for your swift answer.

That is correct. The damage is the damage that occurs on average per single cast. You likely have everlasting affliction, are using haunt, and have the everlasting affliction time set to the default of 200 seconds.

Nice find, thanks.

The T7 set bonus is not in the spread sheet. Will this affect the outcome when choosing the optimal gear?

I have noticed that the item Pendulum of Telluric Currents does not have the second equip effect registered. The effect Pendulum of Telluric Currents has a 15% proc rate.

Hope it helps and keep up the good work.

Still present in 3.0.3j

[edit]
For those that want to correct their version:
Insert -> Name -> Define:
Select "items_wand"
Change the "Refers to:" value to:
=Items!$B$560:$W$596

I did a quick glance through the recent pages of this thread and I havent seen anything addressing this, sorry if I missed something somewhere.

I set up the (version j) spreadsheet using a 0/41/30 talent build with Felguard as the pet choice. The sheet says that the FG will only put out about 500dps and that the imp is significantly better. I believe this is caused by the fact that there is no place to input melee oriented raid buffs. I know I have seen my FG do atleast 1000, even pushing 1200 on certain fights in a 25man raid. Is there some way for me to add in the melee totems and all the other buffs he receives so I can see a realistic output or is this just not implemented yet?

Another issue I had, I modeled a shadow mastery/shadow and flame build 31/0/40. I chose both hit talents and it did not credit me with the 3%, so when I looked at my weight stats, it still listed hit rating at 0.99, even though I was fully capped with 289 + 3% talents +3% S.priest selected. I next tried to just edit the equation on the "DPS" page by adding a +3 at the end and it blew up everything. I got all kinds of crazy results out of it and all the weight stats went into the negative 1000's. I switched it back to normal by removing the +3 and all was fine. I then went to the "gear_buffs" page and added +(26.23*3) to the hit calc on the top of the table and all worked fine. Again, is this something I dont have set right, or an error?

I am new to using the sheet so I don't doubt there must be things I have missed. I tried using the sheet back at 70 and found it far too cumbersome and complicated to spend my time on. This newest version "j" seems WAY easier to use so either you did some great improvements with the sheet to make it more user friendly, or I got smarter recently, either way I am loving it now so THANKS!

In regards to the FG, I have said this many times. I do not play a demo spec for raiding nor will I ever. As such, my desire to work on FG dps is next to nil and will not happen without input from the community. And by input I don't mean people telling me to do it. If you guys want it accurate, you guys are going to need to do the work. Tell me where the equations are wrong, etc. and I'll be happy to fix them. But I won't ever spend my time respeccing to demo simply so I can figure out FG dps accurately.

In regards to hit rating, the next version should address some of this problem. I personally wouldn't go trying to change the equations in the spreadsheet. How hit/miss is handled is not something that can be solved simply by changing 17s to 14s and you're likely to make the DPS page give less accurate values simply to try and get TNS and items correct.

Well, as I said, I am new to this sheet in general and I didnt see anything in the last 2 or 3 pages regarding anything about Demo, so thats why I asked. I was unaware of you distaste for Demo or I wouldnt have had to ask. As far as Demo goes, I am an officer in my guild and prior to WotLK release, I flat out automatically refused any warlock who even tried to apply to me as Demo spec. I even went so far as to attempt to have one removed from guild if they would show up to a raid as a PVP SL/SL or Felguard spec. My distaste for the entire tree (beyond DS atleast) was easily as strong as yours. However, no matter what I read on here or anywhere else, since WotLK, I have found Demo to be at the very least equivalent if not better than any other spec you can dream up. I tested quite a few specs over the last few weeks in 25 man raids and while I was able to squeeze a small amount more DPS from Affliction, no Destro build with more than 40 points can come close to Demo. I strongly urge you to consider checking it out, if for no other reason than to have a higher, more complete understanding of your class. It is far more simplistic than Affliction, but not so simple that it falls into the pre-TBC pathetic one button spam. For the small loss in DPS on some bosses compared to affliction, I will gladly trade it up for the less stressful Demo builds 0/41/30 and 0/31/40. Plus it affords me the opportunity to keep an eye on the raid and make sure people arent being retarded.

Either way, it is good to know Spell hit concerns are being addressed and that the Felguard problem wasnt my mistake and simply just omitted from the sheet. Thanks for the quick response and all the effort on the sheet!

I tried to find out why the discrepancies between my toon and spreadsheet intellect and as far as I can tell from playing on my character and the armory, the racial bonus for the gnome (expansive mind +5% INT) only scales the intellect part from gear and not the base intellect you have. I don't know if it's a Blizzard bug but it seems to be that way currently.

The spreadsheet currently does:
bonus = 0.05 * (base + gear)

when it should be :
bonus = base + 0.05 * gear

If anyone can confirm... i am new to this.