Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 01/07/09, 5:28 AM   #166
rejdakon
Von Kaiser
 
Human Warrior
 
Der Rat von Dalaran (EU)
Originally Posted by landsoul View Post

I'm also thinking of using a different color scheme. Graphics are semi-important. Give me some Ideas.

some options:

BackgroundText and GridHighlights
Blackgrey/white/silverbold colors
TanBlack/greymaroons and reds
MaroonWhite/gold/tansreds
WhiteBlacksgrey/silver/colors
I think light on dark is usually better for long-time viewing. So either option 1 or option 3, though I really think that the color design is fine the way it is (option 1).


Originally Posted by Alamir View Post
I couldn't figure out if the spreadsheet took into consideration the two piece tier 7 set bonus in the SEP calculation. Because it affects Slam damage and that is based off crit, I thought it might bump up the SEP crit value a bit, but wasn't sure.
The sheet is based on 3.0.8 mechanics as far as they're currently known. Crit does therefore not influence Bloodsurge procs anymore.

Offline
Old 01/08/09, 1:38 PM   #167
ebs2002
Von Kaiser
 
Orc Warrior
 
Sisters of Elune
Noticed something missing: 40Expertise food as an option.

edit: put 14hit cuz i couldn't find it, but then I realized it just wasn't grouped where I thought it would be

Last edited by ebs2002 : 01/08/09 at 2:35 PM.

Offline
Old 01/08/09, 5:11 PM   #168
Graul
King Hippo
 
Graul's Avatar
 
Orc Warrior
 
Fenris
I've asked this before and maybe I just missed the answer, but doesn't the game round down when doing checks, i.e. 1.5% hit = 1% hit for checks? If that's the case then wouldn't it still be better to add one hit gem to make it 2%? It's not like you would be getting absolutely nothing at all from the hit gem, but if the game rounds down you are definitely not getting anything from that 0.5% hit. You could always add 16 str instead and still have wasted stat points floating around I guess.

Offline
Old 01/08/09, 5:53 PM   #169
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
The game's rounding behavior is quite odd. I've found sometimes doing static bloodsurge damage as either one number or the number -1 on multiple occasions. I don't see how a computer program could do this unless it was deliberate and that there was an algorithm that determined the randomness. Much like the random playlist in a music player, it's not truely random because it's determined by that algorithm.

I always believed that that it only truncates display values in the character sheet, but doesn't actually round them. Of course, it really is difficult to know.

To answer your question Graul, I don't think the game rounds down any chances at all. The game can handle many decimal places very well. In programming there are different kinds of stored variables that take up a certain amount of space. For certain kinds of variables, the size is static no matter the size of the value assigned to the variable. It wouldn't make sense to take additional steps to round a very accurate number and restore it. You can however, easily manipulate the display of these variables without changing the actual value that is assigned to the variable.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 01/08/09, 5:58 PM   #170
Graul
King Hippo
 
Graul's Avatar
 
Orc Warrior
 
Fenris
I never really thought too much about it until WoTLK and I guess there still isn't any need now then if the game does actually use decimals for checks and not just whole numbers. I suppose if it didn't use decimals then something like 6.5% for the dodge cap wouldn't really make any sense.

Offline
Old 01/09/09, 2:09 AM   #171
Grayson Carlyle
Take what ye can;
 
Grayson Carlyle's Avatar
 
Tauren Warrior
 
Turalyon
I have 295 hit rating, which translates to a total of 8.9966% chance to hit. The character sheet is rounding this up to 9.00, but I still get the occasional miss. 3 so far actually—since my gear was set up this way—in a half dozen attempts + kill of Sarth 3D, all of Naxx25 and all of Naxx10. I'm quite sure every one of those decimals is counting towards my 99.9966% chance to hit.

Canada Online
Old 01/09/09, 9:47 AM   #172
Avin
Von Kaiser
 
Worgen Priest
 
Lightbringer (EU)
Yes, they most likely do count, but with just under 9% hit and 3/3 Precision you should actually have just over 1% chance to miss specials as TG anyway, so it doesn't really show anything. (8% base miss + 5% from TG - 3% from Precision - 8.9966% from gear = 1.0034% to miss specials)

Offline
Old 01/09/09, 12:39 PM   #173
Grayson Carlyle
Take what ye can;
 
Grayson Carlyle's Avatar
 
Tauren Warrior
 
Turalyon

Last edited by Grayson Carlyle : 01/09/09 at 6:22 PM. Reason: I'm stupid

Canada Online
Old 01/09/09, 2:01 PM   #174
ebs2002
Von Kaiser
 
Orc Warrior
 
Sisters of Elune
You need 10% hit for TG. When the miss rate was 9%, you needed 11% hit. After the patch comes out, you only need 5%.

Offline
Old 01/13/09, 10:49 AM   #175
ebs2002
Von Kaiser
 
Orc Warrior
 
Sisters of Elune
I have a request; I've been working on this for myself, but it should be pretty easy to add to the baseline (it's a little bit of work for me to have to do it with each release of the sheet as it requires me to edit the Lookup Sort macro):

An "Upgrade" column in the Lookup sheet, that will VLOOKUP whatever item you're currently wearing, and then list how much SEP difference there is between the two. This will help identify where the largest upgrades are without having to manually do the math.

Insert a new column at Lookup!T_, heading "Upgrade".
T2=M2-VLOOKUP('Set1'!$B$6,$D$2:$O$234,10,FALSE)
Fill down. Repeat for each slot.

Then, when you click sort, I can see that getting the Obsidian Greathelm is 50SEP upgrade, and Collar of Dissolution is 25SEP, etc.

The reason why I found it necessary to do this multiple times rather than just once is that SEP values can vary dramatically with upgrades. I did all the work manually yesterday, then got a few upgrades and it really changes my plan a lot.

---
Edit:
Just a note if you want to pursue this: you'll have to update the SEP macro as well in the weapon speed SEP calculations. Add +11 to the columns for main-hand, and +12 to the columns for off-hand. This is in addition to the LookupSort changes that would need to be made. If you want, I can send you the macros I'm using and/or the whole sheet (which includes the Upgrade column for every slot). Just PM me or reply here

Last edited by ebs2002 : 01/13/09 at 12:28 PM. Reason: Macro changes

Offline
Old 01/13/09, 8:39 PM   #176
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
A good idea, but there's not enough horizontal space to do this. In Excel 97 there's a limit to up to IV columns. I'm currently at column IP with this build. I'd have to replace total SEP with delta DPS or delta SEP if you wanted to do that. I just always thought it was easy to tell differences in numbers in an ordered list to see if it was a big upgrade or not.

Would you rather have Total SEP removed for a plus or minus value like this?

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 01/13/09, 10:52 PM   #177
ebs2002
Von Kaiser
 
Orc Warrior
 
Sisters of Elune
Blast Excel 97 and their lazy limits!

You're right, it's easy to tell if it's a big upgrade, but I'm an organizational freak when it comes to my gear planning. I have a spreadsheet with the top 3 upgrades for each slot, combined with how much of an upgrade they are, sorted by the size of the upgrade, so I know where to focus my efforts. We're not DKP, but with competition for plate I'll pass more freely if I have this sheet in front of me and know that it'll give me a better shot at suchandsuch item from the next boss.

I'd say that total SEP is more appropriate. I can just add them to each release, or write a macro I can run to update the sheet for each release or something.

Ooh, just a thought...could you maybe make it a dropdown box selection in the options? So you can switch between total SEP and delta SEP at a click? If that's not too tedious, that would be awesome. If it's a pain though, unless other people speak up on this subject I'd say it's not worth it for just me

Offline
Old 01/14/09, 2:13 AM   #178
Bigbazz
Von Kaiser
 
Bigbazz's Avatar
 
Tauren Warrior
 
Hellscream (EU)
First id like to say thanks for the sheet, been using the various versions of yours for a long time and it helped me loads.

Im not sure i feel qualified to make suggestions on the layout, but im going to give it a shot.

Back in your old models, designed for the "Pre 3.0" era, you had things spread out over many pages, which in my eyes made everything easy to keep track of. Now im not necessarily saying it should be exactly like that, not at all, however i did like that i had a seperate page where i could set buffs and another for the gear, where things looked more simplified and easy on the eye. Looking at a page full of numbers and boxes just seems quite daunting at first glance and im sure some people find themselves continuously scanning over the data to find what they are looking for amongst the mass of information. Keeping the simple and important information on 1 page (SEP/DPS values, gear choices and stats) with the more detailed information about buffs, proc rates and miss/hit/crit/dodge chances, along with all the rest of the "detailed" information on another would greatly increase the user friendlyness of the sheet in my opinion.

In a way, i think a sort of "declutter" by use of extra pages is what i'm suggesting. Now i may have restated what other people have said and for that i'm sorry. Otherwise it would be nice to have the gems in the way others have suggested to reduce time clicking through them (perhaps some kind of priority list that would show the last few gem choices as the first in sight when you click the pulldown menu, as im sure most people would only use a handful of gem types in their gear). That said, great work so far, and thanks alot.

Offline
Old 01/14/09, 12:58 PM   #179
Sore82
Von Kaiser
 
Night Elf Hunter
 
Sen'jin
Originally Posted by landsoul View Post
A good idea, but there's not enough horizontal space to do this. In Excel 97 there's a limit to up to IV columns. I'm currently at column IP with this build. I'd have to replace total SEP with delta DPS or delta SEP if you wanted to do that. I just always thought it was easy to tell differences in numbers in an ordered list to see if it was a big upgrade or not.

Would you rather have Total SEP removed for a plus or minus value like this?
I have enjoyed using the Delta DPS charts with the Hunter Spreadsheet. Its very easy to understand and, I think, much better overall. I would support this type of adjustment.

Offline
Old 01/15/09, 1:07 PM   #180
Conquistador
Von Kaiser
 
Night Elf Druid
 
Medivh
Just so you know in the 3.0.8 patch, [Belabored Legplates] are being adjusted. They were WAY overbudget for a 213 item. They are losing the 78 ArPen come patch day.

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Warriors

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 9:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 5:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 12:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 4:30 PM