 |
06/11/06, 6:01 AM
|
#26
|
|
Von Kaiser
Draenei Shaman
Stormreaver
|
|
Originally Posted by Deathwing
http://www.savefile.com/files.php?fid=1341886
That's a spreadsheet I put together. I'm not saying it's correct, but I think it does a better job than the one you linked because it incorporates more of the picture. In my spreadsheet, if the warrior is wielding Death's Sting/Pugio and Edgemaster's Gauntlets, and replaces the gloves with Gauntlets of Annihilation, he only loses 3 dps on level 63, while gaining ~150 hp.
I want this to be accurate, so definitely go over it and look for mistakes and let me know.
|
I made some modifications to your sheet. I added item list so u can get item stats just by using the name. I fixed/ add some stuff in 2h, like: Added polearm spec in 2h, Added MS to the dps in 2h, Modified impale in white dmg, Added sword spec in 2h, Added Deep wounds in 2h, Added Rage Spent per Sec, Added abilities per x sec,
Changed execute in 2h
Sheet
|
|
|
|
|
06/11/06, 3:28 PM
|
#27
|
|
Bald Bull
Orc Warrior
Black Dragonflight
|
Impale doesn't affect white damage. Also, I'd like to keep control of the releases of this spreadsheet. You're free to modify it, but please note that in the spreadsheet if you decide to release. I don't want many versions of my spreadsheet floating around out there.
Additionally, I don't agree with your modeling of Deep Wounds since it's very easy to overwrite itself.
|
|
|
|
|
06/11/06, 3:49 PM
|
#28
|
|
Piston Honda
|
Problem with Thunderfury is it's alot harder to model I think. Or at least need a proc model included that is good, which tend to not be the case. I'm pretty sure that TF should beat all the pre Naxx combo at least due to it's "hability" to use more from to hit then normal combos via the proc and potentially haste.
Also for that list, the order would change assuming different buffs level. For example slow weapons are better with less buffs since you get more out of WW/OP but with full buffs, especially with WF, the faster your 1-h the more dmg you will do, changing the order. So at least a list that account for full buffs would be usefull.
Also you have to do 2-h imo. My own calculations tell me that 2-h is pretty close to what dw fury can do, would be nice to dispell the myth also that DW fury is all there is for warriors atm.
|
|
|
|
|
06/11/06, 4:01 PM
|
#29
|
|
Bald Bull
Orc Warrior
Black Dragonflight
|
If windfury is available, 2H pulls about even with DW. Windfury is better for 2H because you can spam hamstring.
|
|
|
|
|
06/11/06, 6:38 PM
|
#30
|
|
Von Kaiser
Draenei Shaman
Stormreaver
|
There is no problem with overwriting deepwounds, it just had a minor mistake. If u consider the chance that deepwounds is up at anymoment its 1-Chance to not crit all your atacks in the past 12 secs, that is 1- ( 1- Chance to crit) ^ Number of Atacks in 12.
|
|
|
|
|
06/12/06, 12:37 PM
|
#31
|
|
Mostly Harmless
|
I like the data this provides, but would it be possible to have it just input data like the first spreadsheet? Being a user of CTProfiles, its kinda frustrating to have to look up each item and input its stats manually each time.
EDIT : This would also allow for diffrent races of warrior, given that's something CTProfiles already calculates.
Also while I'm guessing the answer is no is there accurate modeling for HoJ yet?
|
|
|
|
|
06/12/06, 12:47 PM
|
#32
|
|
Bald Bull
Orc Warrior
Black Dragonflight
|
|
Originally Posted by Shavnir
I like the data this provides, but would it be possible to have it just input data like the first spreadsheet? Being a user of CTProfiles, its kinda frustrating to have to look up each item and input its stats manually each time.
EDIT : This would also allow for diffrent races of warrior, given that's something CTProfiles already calculates.
Also while I'm guessing the answer is no is there accurate modeling for HoJ yet?
|
Are you referring to my spreadsheet?
Those are things I'll look to add. I want to make it similar to Chalon's spreadsheet(the UI), but I have no idea how to make pulldowns in excel. And I'm still a bit confused about the VLOOKUP function. I've searched all over Chalon's sheet, and I can't find where he stores his database for gear.
|
|
|
|
|
06/12/06, 12:52 PM
|
#33
|
|
Mostly Harmless
|
Yes I am referring to your spreadsheet. I want to give it a whril, but the extra time in inputting the gear is a bit intimidating, so to speak.
Honestly I really liked the UI in the first spreadsheet, because from a CTProfile page I could copy a few things over and be good to go. I think Chalon uses extra sheets (not sure the terminology, its how you seperated DW from 2H on your sheet) for the item database, but its a bit...sparse.
|
|
|
|
|
06/12/06, 1:27 PM
|
#34
|
|
Founder of the Chalonverse
Chalon
Night Elf Rogue
No WoW Account
|
|
I've searched all over Chalon's sheet, and I can't find where he stores his database for gear.
|
The sheets are hidden sheets. Go to Format>Sheet>Unhide and select the option for what item you want.
|
I think Chalon uses extra sheets (not sure the terminology, its how you seperated DW from 2H on your sheet) for the item database, but its a bit...sparse.
|
How exactly is it sparse? I've got every reasonable item a rogue could be using more or less. Let me know what else you think should be there :P.
|
|
|
|
|
06/12/06, 1:29 PM
|
#35
|
|
Mostly Harmless
|
I've been to AQ40 maybe twice so far :P Hell I still have blue shoulderpads off of Bloodlord in ZG :p
Its not a huge deal, but it kinda stinks to see maybe 3 or 4 of your items recognized by the spreadsheet.
|
|
|
|
|
06/12/06, 2:08 PM
|
#36
|
|
Glass Joe
|
|
Originally Posted by Deathwing
That's a spreadsheet I put together.
|
Your comments on the spreadsheet indicate that "The first column for total dps [edit: cell B62] is just White + BT + WW + Hamstring + Full bar execute."
The actual calculation for cell B62 is
B69 * (B48 + C52 + C57 + C59)
which translates to
Armor mitigation * (White + BT + Execute + Hamstring)
From my perspective, it makes more sense to include the whirlwind DPS in that calculation, unless I missed something along the way.
Otherwise, the spreadsheet looks quite nice. Just want to make sure that's a typo and not something I didn't understand. Thanks
|
|
|
|
|
06/12/06, 2:46 PM
|
#37
|
|
Bald Bull
Orc Warrior
Black Dragonflight
|
You're right, that's a mistake on my part. I'm leaning towards just throwing out that model all together because it only accounts for 1 full-bar execute. Which in no way models sustained DPS at all, only DPS on short trash mobs, and I'm sure no one here really cares about that. I'll make sure to change my notes to point out that the 80%/20% model is the one I think models sustained warrior DPS the best. THe 55/45 one is crap as well.
Chalon, how do you make those pulldowns?
|
|
|
|
|
06/12/06, 2:52 PM
|
#38
|
|
Founder of the Chalonverse
Chalon
Night Elf Rogue
No WoW Account
|
|
Originally Posted by Shavnir
I've been to AQ40 maybe twice so far :P Hell I still have blue shoulderpads off of Bloodlord in ZG :p
Its not a huge deal, but it kinda stinks to see maybe 3 or 4 of your items recognized by the spreadsheet.
|
Well can you list out what items you have that you think should be listed?
And Deathwing I explained in another thread how I did it. :P
http://forums.elitistjerks.com/viewtopic.php?id=7030
|
|
|
|
|
06/12/06, 3:05 PM
|
#39
|
|
Mostly Harmless
|
Its not that big a deal, a lot of people that use calculators are on a bit more of the cutting edge of gear. I see the value in listing items seperately, I'd just like a way to input all the stats at once (unbuffed AP, battle critrate, hit, skill, weapon damage range, speed) and see the totals. Plus taurens start with diffrent stats than gnomes :p
Also I'm not sure if the dropdowns work in OpenOffice, I had to type in the names manually.
|
|
|
|
|
06/12/06, 3:31 PM
|
#40
|
|
Piston Honda
|
Yeah for those sheets a "overwrite" gear section where you supply unbuff stats that matter like the previous poster said would be nice. Basically if there is something int aht column use that value if not take it from the gear total.
|
|
|
|
|
06/12/06, 3:44 PM
|
#41
|
|
Bald Bull
Orc Warrior
Black Dragonflight
|
|
Originally Posted by Shavnir
Its not that big a deal, a lot of people that use calculators are on a bit more of the cutting edge of gear. I see the value in listing items seperately, I'd just like a way to input all the stats at once (unbuffed AP, battle critrate, hit, skill, weapon damage range, speed) and see the totals. Plus taurens start with diffrent stats than gnomes :p
Also I'm not sure if the dropdowns work in OpenOffice, I had to type in the names manually.
|
That wouldn't work too well because of stat's interaction with BoK, and hopefully, vitality soon.
I'm leaning towards using Chalon's method of gear input because it's more convenient for most people instead of having to change stats around each time.
|
|
|
|
|
|