Grim13

I'll see if I can come up with a way to distinguish group buffs from raid buffs. If I do implement this, I will do it in a non-invasive way....something more subtle than adding an R or G. I'll put it on the to-do list.


Now, there is no way I'm gonna have a beta ready today, now that I've looked over what I am going to need to do to get beyond the alpha stage. I have a lot of work left to do, so it looks like next week. However, I do have a screen shot of the new front-end, and would appreciate some comments and/or suggestions.

 

DarkS

Awesome Look! Keep the good job Grim13

 

dr_AllCOM3

Yeah, that looks professional. A good layout is half the work.

 

enthrop

Was just hoping to get some help w/ the DPS spreadsheet..

I'm having issues where things aren't updating. If I change my gear around, I can force a refresh of the 'cycle' and 'execute' dps shown in cells A5/A7/A9 by hitting 'fix it'. That's really not an issue cause it's not too much work for me to hit the button. But the big DPS spanning cells E2-F3.. the only way I get that to refresh is to save & close the whole workbook, then re-open it. I'm not TOO concerned w/ that either because I can more or less rely on the 'cycle' dps when I'm comparing different gear.

The problem that I can't figure out a workaround for is when I change talents. For some reason, I'm semi-permenantly stuck on a 4xSlam, 2xMS, 1xWW for my "using." I wanted to compare this PVE Arms set with a PVE Fury set... I initially setup the PvE Arms set in Gear1, then loaded it in Gear2, changed the weapons & the talent spec that's being used. But the "using" won't change, and I think it's still calculating dps based on an arms approach.

I've looked at the equation, and the "USING" field points to the Warriors_Sim workbook's cell G2. I looked at that equation and it basically picks between N2 & Q2, depending on if an offhand weapon exists. I see my offhand weapon having a speed of 2.50, so it should be picking Q2, which is the DW option. But the cell isn't refreshing and just shows the 2H option. I went into the cell, simply hit "F2 (edit)" and "enter" again, hoping to force a refresh.. but it caused the cell to become 0.00 instead =( The Warrior_DPS sheet DID update, and also reads 0.00 now.

I'm wondering what's going on and how to fix this.. This is all on MS Office 2003 SP3 w/ low macro security settings.

 

Taruo

Grim would it be possible to include Despair in your next version. I manually add it in, in every version, but I have no idea how to emulate its proc "Impale" which scales nicely with one's gear and is capable of critting itself basis ones Crit%. Thanks in advance.

 

cryinfreeman

Grim, while looking at the spreadsheet, i found a mistake. When it comes to the hit rating, the calculation is wrong. I think it counts 3% extra hit. For example, with 78 hit rating, the spreadsheet indicates a hit chance of 7.95% without precision. With precision, it goes to 10.95%. Can anyone else confirm if it really adds this 3% extra hit or if i may do something wrong?

 

Whistles

You've got the Improved Faerie Fire (Boomkin) option ticked on somewhere.

 

cryinfreeman

Ah yeah, you're right. Dumb freeman

 

Grim13

Make sure "Automatically recalculate" or whatever is enabled in the options screen. Also, F9 works to force a refresh. See if that helps.

 

Mardraum

Is there a way to add "NO SLAM" DPS rotation to your spreadsheet? Alot of people are finding they get better results with this. It would be good to be able to compare gear and such with a spreadsheet that is valuing the correct rotation that you're using. And the option to switch between NO SLAM and SLAM rotations would be awesome for a gearset.

 

Grim13

I have already implemented something like this for PvP, but I suppose I could put it in for PvE as well. Not trying to tell anyone what to do, but I would think that if your lag is so bad as to make slam unusable then you'd be MUCH better off going fury I would think. Not using slam, at least for me, is in excess of 20% DPS. However, using unspecced slam is even worse, so if I add a slam-free cycle, it would be chosen by the sheet, so long as slam isn't specced. Since it isn't much work to make a new cycle, most of the time, I'll toss it into the next release.

Speaking of the new version, I apologize for my absence. I've had little time in which to work of the sheet these last few weeks. But, with a little luck, I'll be able to get things sorted out in the next couple days. Possibly even be ready for a release on Friday, but no promises. In fact, most likely it won't be ready by tomorrow, but the chance is there. I think I'll put out a rough beta regardless though. Would be nice to iron out any bugs sooner rather than later.

 

Mardraum

So what is the rotation the sheet uses? Does it follow the heroic strike over 60 rage and hamstring every global cooldown unless mortal strike or whirlwind is up? Does it take into account sword spec procs from hamstring?

 

ceasefire

I have a rather silly question. When Bloodlust/Haste potion are checked, does that mean 1 usage for a standard fight, or does that mean the buff is active for the entire calculation of DPS?

 

Llilyth

Does this spreadsheet take the proc of [Rod of the Sun King] into account (I'm told the proc is almost useless for warriors)? I ask because this spreadsheet shows higher DPS when equipping [Rod of the Sun King] compared to [Vanir's Right Fist of Brutality], for my setup. This seems strange to me looking at the stats of the weapons. Is it the +5 expertise bonus for being a human that puts the Rod over the Fist? Or is the spreadsheet giving the Rod a boost due to the proc?

Coincidentally, the Fury DPS Spreadsheet for 2.4 calculations put the Fist above the Rod.

 

Grim13

Yes, the proc from [Rod of the Sun King] is accounted for, as it the expertise bonus, assuming you are human. So, while the proc isn't exactly earth-shattering, it's still enough to make a difference.

In the case of potions, they are used as often as possible, every 2 minutes for most pots. Bloodlust, on the other hand, is assumed to be used once per fight.

Depends upon the spec and gear. Supported rotations are:

• 4x Slam, 2x MS, 1x WW
• 4x Slam, 2x BT, 1x WW
• MS > WW > HS
• BT > WW > HS
• 3x BT, 2x WW
• 5x BT, 3x WW
• 4x BT, 3x WW
• 5x MS, 3x WW
• WW > HS
• WW > Dev > HS

The spreadsheet calculates DPS for all rotations, taking talents and gear into account, then selects the rotation which results in the most DPS and reports the DPS output as well as more detailed information about the rotation to the user.

This isn't really something that can be done in a spreadsheet. Spreadsheets work with averages, so the sheet really doesn't know when you would be over 60 rage. It knows how much average rage is generated per second and what that amounts to over a period of time. It is for this reason that the execute model, for example, is overly complex and will never be precise in it's calculations. To do something like this you need a simulator. dr_AllCOM3 was working on one, but I'm afraid I've not kept up on his progress.

Even though none of the rotations include hamstring, the model is designed such that the addition of any new attack to the rotation is automatically accounted for in the calculation of procs and similar mechanics.



As to progress on the forthcoming re-release of the sheet, I've got a lot done, but there is still a lot to do. I think I'll be able to get a very rough beta version posted later today, and would appreciate any feedback. Particularly bugs and opinions on the re-vamped front-end. Should be ready within a few hours.

 

Mardraum

Thanks for your prompt answers. Can't wait to try out the new sheet.

 

Grim13

WarriorDPS_v400 beta1

OK, here's a "beta" of the new-ish sheet. For right now, I would suggest sticking to Gear1, as I am working on getting one sheet working correctly, then simply cloning it for the other 5 sets. If you see anything screwy, please let me know. Hopefully I can get this finished up pretty soon.

This version is a BETA. It is currently NOT fully functional. There are most certainly a lot of bugs. There are things that don't work. In other words, don't download this unless you are interested in helping me find bugs, suggesting improvements, etc. Please keep this in mind before you download.

There's probably a lot of stuff missing from the changelog, but whatever, I'm not a professional, so...

Changelog:

• New version system beginning at 4.0.0
• Corrected bug causing buffs to be referenced incorrectly
• Corrected issue dual-wielding in Gear3
• Prism of Inner Calm model looks to have been broken some time ago, so I have removed it's TPS model for now
• Tweaked Deep Wounds model
• Completely isolated cycle and execute DPS sheets
• If no offhand is selected, any enchant or temp. enchant still applied in the Gear sheet will not be counted as valid
• Re-did buff selection with check boxes instead of list boxes
• Rewrote Haste code from scratch, resulting in a slight change in DPS when haste is involved
• Added distance to cap table with both hard and soft caps for crit, hit, haste, ArPn, expertise and resillience
• Removed unused macros
• Added Imp Seal of the Crusader, Imp Sanctity Aura, Demonslaying elixir, Drums of Battle, Expose Weakness
• Reworked the new UI to reduce the upper portion's footprint

 

Kaan

Again thanks for the work. I've tested it and found out following:

Deep Wounds seems too strong. Activating / deactivating it, yields 80-90 DPS (only with 2H build though).

Adamantite Stone seems to only be enabled on offhand weapon damage (but increases mainhand weapon damage too).

Selecting Shard of Contempt brings up errors and isn't repairable until selecting another trinket.

Selecting Offhand Execute Weapon errors the spreadsheet and isn't repairable.

Some unimportant things:

Vengeful 1H Weapons have a wrong weapon damage. It's actually 187 minimum damage and 349 maximum damage (Sword 214-322).

Selecting ring enchants and 20 Strength/Agility scroll are missing. Improved Huntersmark can only be enabled with 5/5 points talented. Ferocious Inspiration (Beastmastery) and Expose Armor (Rogue) are missing.

Everything else seems to work fine for now. Looking forward for the final version.

 

Whistles

Socket bonuses are working correctly but it would be useful if they showed up on the sheet.

I'm not having errors using Shard of Contempt.

The "Click to jump to Execute Weapons" doesn't seem to work.

Enabling Execute Weapons throws a div/0 error which propagates through the rest of the sheet (disabling them or restarting the sheet with them disabled doesn't help). This might have something to do with there not being any weapons selected by default? Even after picking weapons for it nothing changed.

This is all in Excel 2003 SP2.

Overall it looks really good and I'm excited about having something to compare landsoul's sheet with.

 

Grim13

Thanks guys. This is the kind of stuff I'm looking for. As to Deep Wounds, I was kinda thinking the same thing, and am going to look into it and compare with some DPS logs and such.

 

Glory

I refer to the working Sheet.

Do Targetdebuffs, that dont really debuff the Target, but increase your stats ws your target scale with Talents?

Specially its interesting for Imp Huntersmark/Expose Weakness. Do they Scale with Unleased Rage/Imp Berserker Stance?
I think they dont. Correct me if I am Wrong. Like now its like they scale with Talents.



Set Flasks/Food Buffs into the Gear Sheet, because you can only Take 1Flask/Potion that increases DMG respectively 1 Foodbuff.

Missing Elixier : Demonslaying

Missing Druide With +20 Crit Idol
Missing Imp SoC
Missing Imp Expose Armor
Semi-Missing Expose Weakness

Drums of Battle/War

You only have 2 Options for most skills. Not skilled or fully skilled.

If you have once a nil value everything crashes, you have some tips to avoid this?

But over all nice work like your Spreadsheet much Grim13

 

Rallik

Referring to beta sheet, didn't check previous version:

Adamantite sharpening stones(all +wep damage effects i believe) were changed at some point so that their +dmg applied to all attacks. So a stone on the OH increases MH dmg by 12, OH dmg by 12(not reduced by OH dmg penalty), BT damage by 12, WW damage by 24(12 on both hits), execute by 12.. etc. That's before armor reduction of course. I tested by wielding 1-2 dmg weapons, sundering off all the armor of low level mobs, and testing HS/BT/execute/white hits to confirm. The beta sheet only adds 12 damage to the wep range of the OH, which is then reduced incorrectly by the OH penalty, and does not apply the bonus damage to any other attacks.

I assume that +dmg ring enchants would function the same way, but am unable to confirm as I'm not an enchanter. This massively improves the worth of +wep dmg effects and, most importantly, typically puts an adamantite stone ahead of an elemental stone.

 

Jalinda

I hava a problem with hit rating in the beta sheet. After selecting my gear, I have 146 hit rating. The spreadsheet says that that equals 12,26% rating. At first I thougth there was an error with skill tree, but when I chose dw fury, it goes up to 15,26% hit.

 

Liar

I don't have the new sheet but do you have any buffs enabled that might affect this? Having 3% more hit than you should sounds like Improved Fairie Fire to me.

Protection Warrior PvP video | Unexpected TankPoints error