Mansch

All companies I work for or contract use '97 as a standard even though it's 12 years old, so letting go of that version would be a loss.
I manually added an extra tab which provides the drop locations of the loot, may be this could solve it. I generally am not extremely interested in the exact stats of the item (though relevant for the calculations), but how much it is an improvement and where it drops. So maybe an additional location tab is the solution.

To elaborate on the upgrade question, is it possible to construct a macro to find all upgrades by replacing all item in one slot for all slots?
It should work like this:
Input your current gear, run SEP.
Push macro
Current Helm is replaced by Helm A, dps difference with current Helm is stored with Helm A.
Rinse and repeat for all Helms
Rinse and repeat for all Slots

Two problems are the large amount of options and associated calculation time. And second the sockets and how to fill them (enchants are a non issue).

 

arc

Alternatively the lookup sheet could be broken into several sheets. Each item slot could reasonably have its own lookup sheet without too much additional effort. Left/right side of the character sheet would also be a clean division.

An issue like running out of columns seems a silly reason to break compatibility with 2k3/97, since as you said they're still very widely used. Many workplaces are really bad about upgrading older versions of things like Office, and for those people pirating 2k7 simply isn't an option.

 

Eliminate2

Hey, Landsoul, appreciate the great work. I was wondering if there is a release date for the new sheet? I know the last time you mentioned it, that it would been done by this past Monday. Obviously its delayed a bit. =P

I'm excited to see all the new changes.
Thanks Again.

 

Mode

If you're really desperate to, it's pretty easy to fix your own sheet.

Step 1: Go to cell z55, find '180', change that to 108. Congratulations, your sheet now adds one AP for every 108 armor.

Step 2: If you're a JC, you'll need to update the gems. First, remove all the epic gems from your current gear set. Go to column GD on the Lookup sheet, row ~110 and change all the gem bonuses from +27 to +34. Next, go to column GN and change all the JC gems from Pris to R or Y as appropriate. For the new +10 all stats gem, I recommend just changing the old +6 to to +10. To change the name of the gem, make sure you put a single quote before the +34 or Excel will bitch you out. If you're a skinner, uh, you'll just need to use the dummy value input to input the difference in crit between old skinning and new skinny. For enchantments, just use the same method as gems except they around rows ~260.

Step 3: The fun part: Adding new gear. Find an existing piece on the Lookup sheet that you'll never use (Sunwell gear is good for this) that has the same type of gem slots as the piece you want to add, e.g. If you want to add a piece that has two red sockets, find a piece that has two red sockets that you won't ever use. Replace all the stats on that old piece with the new piece, but do not under any circumstances touch the columns that contain R, B, or Y. You can safely change the gem socket bonus, but never touch the gems. They're not a user serviceable part.

 

Flukeworld

Sorry, to go a bit away of what you currently discussing. I have an idea that i want to propose, and as i see it, a lot of people have been asking for something like that, but seems not taken seriously. I will try to explain why this is important, and how it would help a lot of other people. (sorry for textwall)

Fist to start, that my main raid role is a tank, so i have a bit of a trouble finding out what gear to take for my fury ofspec.
My approach for planning tanking gear is to create list of items in xls with ranking, then export that list in meta format to my tiny addon that enhance item tooltip in game to show me clearly do i need that item or not. Why im doing this - first because currently ingame there are so many items i couldnt remember and second i have 15-20 seconds to react do i need that item while in raids.
But that list shouldnt be a list based on what caps i have to chase or what i have, this list should be sorted on default item value. After that, when i have the gear i always can use some tool to evaluate, should i wear that item now, or later when i reach desired stats, caps or whatever.
As i said - for me it took long time to realize how to value items, hot to equalize different type of stats and get to clear how does X stat weights, and with how much Y item is better than Z item. All that included using different tools, the tanking spreadsheet here, ranking sites and so on - in other words very time consuming.

So, 2 weeks im trying to do the same for my fury build, and I came to something that doesnt look so clear, but is something. I was thinking how much time it would save me, if spreadsheets like this one here can do that for me - sort items by BiS on top.

 

Kalandrakas

There's always Open Office, free to all...

 

proga

Excel 2003 has same limitations as Excel 97 regarding 255 columns on sheet. This problem was solved only in Excel 2007 that is not very popular still.

 

Speeder

... which isnt supported by speadsheet

peace MK

 

Lantador

Landsoul, can I ask what model you use to arrive at your BiS list on the first page?

The reason I'm asking is that I've done some editing/testing in the old (current) version of the spreadsheet, and it would seem (I'm in in no way saying that I'm right) that a 100% passive (including the 6% from T9 bonus) ArP setup utilizing items like banner of Victory is a huge DPS boost over str builds - I'm landing at close to 9300 DPS.

Other people on previous pages have arrived at the same numbers more or less - Hence I'm curious to know how you arrive at your BiS list.

 

Narcissus

You're comparing his BiS against your total build. The difference is - BiS is simply that. Best dps /stat usage for that slot. There are obviously other factors like hit and situation where an entire combination will be better than this "set" because it's not really a set at all.

 

ZorbaTHut

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.

 

Speeder

I guess OO doesnt suport VB script and macros arent compatible between those 2 products. Another thing considering popularity of Exel target audience for OO version is small and not worth effort.

peace MK

 

Zxahn

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.

 

ZorbaTHut

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.

 

Recab

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?

Protection Warrior since '05 !

 

Statix

So could any of us, including yourself.
He used to provide sheets for OO and it became such a chore to cater to a small number of people that he stopped... do you really want the sheets to take even longer to come out?

 

galindon

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)

 

galindon

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.

 

halton

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.

 

nomopofomo

Pardon me for being skeptical but why is your version 19 megabytes?

 

arc

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.

 

bo5r5osh

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.

 

galindon

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.

 

Grayson Carlyle

Did you make sure to update the SEP column on the gear lists to use 108 instead of 180? Most people seem to be missing this one.

 

galindon

Yap. Did that too.