Warrior DPS Calculation Spreadsheet - Page 99

BWarner · 08/18/09, 10:17 PM

Maybe you could create a new sheet, that would hook into the existing Lookup one?

Otherwise, I mean... '97 is now 12 years old. Warcraft is no longer actively supporting Windows2k, and Microsoft itself only provides barebones maintenance for Windows2k/ME and earlier. Maybe it's time to unsupport '97 Excel in favor of '03 and later?

proga · 08/18/09, 11:07 PM

Excel 2003 doesn't support more than 255 (IV) columns also. Only 2007+

landsoul · 08/19/09, 12:41 AM

Half of the downloads are excel '97 because that is what a lot of people have, and is easier to get/torrent etc. If I discontinued '97 support then id lose half the downloads, and if I did that I might as well charge for a key to use the program.

Fedelis · 08/19/09, 2:09 AM

Originally Posted by landsoul

Half of the downloads are excel '97 because that is what a lot of people have, and is easier to get/torrent etc. If I discontinued '97 support then id lose half the downloads, and if I did that I might as well charge for a key to use the program.

IMO people would just go download the new XL if you discontinued the old one. I sure would.

turbare · 08/19/09, 3:09 AM

Well, Excel 2003 is very accessible as well TBH, maybe give it a go, it'll do them good, they should upgrade from 97 anyway

Mansch · 08/19/09, 3:32 AM

Originally Posted by BWarner

Maybe you could create a new sheet, that would hook into the existing Lookup one?

Otherwise, I mean... '97 is now 12 years old. Warcraft is no longer actively supporting Windows2k, and Microsoft itself only provides barebones maintenance for Windows2k/ME and earlier. Maybe it's time to unsupport '97 Excel in favor of '03 and later?

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 · 08/19/09, 3:53 AM

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 · 08/19/09, 4:05 AM

Originally Posted by landsoul

Half of the downloads are excel '97 because that is what a lot of people have, and is easier to get/torrent etc. If I discontinued '97 support then id lose half the downloads, and if I did that I might as well charge for a key to use the program.

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 · 08/19/09, 4:41 AM

Originally Posted by 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.

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 · 08/19/09, 4:45 AM

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 · 08/19/09, 5:47 AM

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

proga · 08/19/09, 6:59 AM

Originally Posted by turbare

Well, Excel 2003 is very accessible as well TBH, maybe give it a go, it'll do them good, they should upgrade from 97 anyway

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 · 08/19/09, 7:46 AM

Originally Posted by Kalandrakas

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

... which isnt supported by speadsheet

Lantador · 08/19/09, 7:49 AM

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 · 08/19/09, 9:51 AM

Originally Posted by 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.

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.