I'm pretty sure Landsoul could fix this if he really wanted to. It's not like OpenOffice has a bug that makes it impossible to calculate Warrior DPS.

Actually, if you add up the numbers for the posted sets they both hit the exp/hit caps and when fully ArP socketed both hit the ArP cap, and that is without baing a JC/BS.

But, as I said, he could fix this - OO has a scripting language, and he could do the scripting in OO.

Also, if he's mentioning torrents as being one of his major customer bases . . . well, OO is very very easy and free to get ahold of. The only cost to installing OO is a little bandwidth and disk space, so anyone who wanted to use an OO version of the spreadsheet could do so easily.

I don't know if he wants to, but it's pretty clearly possible.

It is also a lot of work. No offense but I don't think that you all are remembering that he does this for the Warrior community for free. Quit posting saying "omg landsoul hurry up and update" and "wahhhh i want OO support".

Here's an idea: If you want OO support or a quicker update to happen, why don't you offer some form of incentive (hint: there's a donation paypal address on the front page) instead of just annoying landsoul and everyone else who visits this thread?

I don't know if its been posted, but I have personally updated the sheet using alliance gear. This is just to get you by until Landsoul is done.

What I did.
1) T9 bonuses and checks are included.
2) Trinkets are included (even though I don't like the effective proc for the 10 man DPS trinket)
3) New gear for alliance side is included (heroic and regular, emblems). Not all Mail and leather items are included. Mainly the crit/Exp/ArP ones. I Bascially ignored all the hit/haste combos.
4) 180 to 108 AP for the talent.
5) Fixed all the macros to adjust to the added lines in the front page. (SEP button works)
6) Added gem columns for the 2 gear pieces that have new gem possibilities (Bracers and rings). These also work just like everything else, checks for
bonuses etc.
(*BUG* While the new bracer gem slots are included, I forgot to fix the "check both gem slots" to figure out if the bonus should apply. This affects only Bracers of Dark Determination. The rings however work with the 2nd gem slot. *FIXED*)

What I didn't do
1) Update the gems for JC.

Enjoy. Thank you Landsoul for all the hard work you put into this thing.

Excel'97 version
WarriorDPS2.407GAL.Excel97.xls

(why not the newer version? Well, because I don't have that version available for me to edit)

Oh, and the gear list is long because I just included the heroic versions with an (H) in the name to indicate the higher version. Lots of stuff is doubled up this way. Just easier this way.

Good stuff, Galindon. You might want to edit your prior post to note that this is the 97 (although that should be clear from the filename, I missed it) version. Those using 2007 will need to continue to wait or continue to update their own spreadsheets.

Landsoul's 2k3/97 version is also that size. I'd assume it has to do with image compression? I've also been curious why the original is so large.

As for how to differentiate between two items which share same name, different ids, one from herioc and the other from normal, here is the part of the XML file from the armory which you can use:

<itemSource areaId="4722" areaName="Trial of the Crusader (25)" creatureId="35216" creatureName="Lord Jaraxxus" difficulty="h" dropRate="3" value="sourceType.creatureDrop"/>
<itemSource areaId="4722" areaName="Trial of the Crusader (25)" creatureId="35216" creatureName="Lord Jaraxxus" difficulty="n" dropRate="3" value="sourceType.creatureDrop"/>

You can use the getAttributes method (or excel equivalent one) to fetch [difficulty], and compare it to "n" or "h".

link: http://www.wowarmory.com/item-tooltip.xml?i=ITEM_ID

Hope this helps.

Because excel sucks. I don't know why its that big to be honest. I did add a lot of gear. No virus, no key logger (unless my work computer is infected, which if it is I get to yell at some IT people and change my own stuff.)

Night Eternal : Home is my guild. Check the left for my toon. It's safe to the best of my own knowledge.

If you guys spot any gear bugs, or what have you point it out. Other than the fancy addons and improvements that Landsoul is teasing us with as well as the arms improvements and JC gems it should be ready to go. I can also spend some time adding the JC gems. Once you figure out how Landsoul programmed it, its actually quite easy but very tedious because of all the possible ways to get #N/A errors which suck.

Yap. Did that too.