Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 01/10/07, 12:26 AM   #496
pf
Don Flamenco
 
Dwarf Rogue
 
Garona
doh, forgot about snd switch.

Offline
Old 01/19/07, 10:26 PM   #497
pf
Don Flamenco
 
Dwarf Rogue
 
Garona
New lvl 70 version of the spreadsheet. Lots of new features and changes. Anyway, I am not sure how much longer I am going to keep updating this sheet. I am not planning on purchasing TBC in the near future and as such, my account will expire in ~3 months. I do plan on updating it fixing any small bugs left in the sheet that are found within the next week or so. If anyone is willing and able to pick this project up, I will gladly help them with any questions they have. Simply PM me on this forum and I will get in touch with you. I updated this all to lvl 70 stuff because I had come too far with working on the lvl 70 version when deciding to quit the game and move on. Anyway, enjoy the spreadsheet.

Version 2.2 - 1/19/2007
Added lots of TBC gear/weapons, and removed most previous gear/weapons.
Added some improved buff ranks since with 25 man raids, it will be more difficult to always have the best.
Added new consumables, removed a few old ones.
Added option to choose whether or not to take into account boss level defense value. (need to make +.1% crit dynamic)
Added ring enchants.
Added some more colors and rearranged things on the gear/buffs sheet to hopefully make it easier to enter things.
Added Mongoose Enchant. Seal Fate does not receive benefit from this enchant currently and its slightly undervalued for those builds. Also, mongoose causes next-stat data to be slightly off.
Added a haste rating stat and converted old hastes which fixed a few minor math bugs relating to non-snd/blade flurry hastes.
Added sockets and socket bonus functionality.
Updated gear/weapons to follow ratings system instead of straight % increases.
Updated stats to the new rating system
Updated ranks for the following: Mutilate, Sinister Strike, Backstab, Hemorrhage, Eviscerate, Rupture.
Updated buffs to lvl 70 ranks.
Updated Poisons and Windfury to lvl 70 ranks.
Changed how dual wield spec affects mutilate slightly to match in-game testing.
Combat Potency now somewhat modelled in next-stat +hit/skill/haste, not 100% correct, but uses a base DPE conversion.

Offline
Old 01/19/07, 10:48 PM   #498
Whorpe
Von Kaiser
 
Murloc Rogue
 
Mal'Ganis
Not having thing like Gurubashi Dwarf Destroyer and any Bloodfang makes it anti-climactic to see my dps increase while getting new TBC gear :D

Offline
Old 01/20/07, 4:51 PM   #499
Un
Von Kaiser
 
Undead Rogue
 
Eredar
Thanks Pf.

Although sad to hear you're moving on. These spreadsheet contributions have been an amazing help to sorry sods like myself who's math skills have atrophied to a grade school level, and previously used terribly crude and inaccurate hunch's for comparing gear.

Best of luck to you whatever you choose to go on to.

Offline
Old 01/22/07, 12:11 PM   #500
 Maestroquark
What Would You Have Me Do?
 
Maestroquark's Avatar
 
Ramala
Orc Rogue
 
No WoW Account
Originally Posted by Whorpe
Not having thing like Gurubashi Dwarf Destroyer and any Bloodfang makes it anti-climactic to see my dps increase while getting new TBC gear :D
It's pretty simple to add them back in. I'd recommend the bottom, though, as adding some stuff back in alphabetical order on Bracers/Gloves sheet was bugging out on me.

Quick-fix bug: selecting "None" on slots that can be socketed is bugged, and causes all values to become undefined. Putting in "0 0 0" or such for the "None" sockets fixes it.

Cally - EJBSG 27; Dee Baltar - EJBSG 22; Tory - EJBSG 20; Leoben - EJBSG 19; Helo - EJBSG 14; Starbuck - EJBSG 12

United States Offline
Old 01/22/07, 12:41 PM   #501
Baiko
Glass Joe
 
Human Rogue
 
Windrunner
Very sad to hear you're moving on Pf, for reasons already stated a few posts above me. :(

The sheet is looking solid as ever. The only bug I've found is when attempting to use 0/3 Ruthlessness with Mutilate (divsion by 0 somewhere in the cycle calculations), but it's easy enough to side-step for the time being.

Offline
Old 01/22/07, 9:14 PM   #502
Bleedo
Glass Joe
 
Murloc Rogue
 
Bonechewer
Sorry to see you go Pf. If anyone takes over the project they're welcome to the same disk space and bandwidth @ rogue.bleedo.net that Pf had. Contact me via private message here or on the www.vismaior.net forums if you're interested.

http://www.bleedo.net/Signatures/bleedo.php
http://www.bleedo.net
http://www.vismaior.org

Offline
Old 01/23/07, 5:17 AM   #503
Zoro
Piston Honda
 
Murloc Rogue
 
Aggramar (EU)
If no-one else steps into the breach I'd at least keep it up to date with entering new items as they appear as I'll be doing that anyway.
Don't have the free time I used to and unfamiliarity with all the background workings means I certainly couldn't do as good a job as pf of keeping it bug free and totally inclusive.

Edit: While I think about it I should report that most of the maces are missing the 0 0 0 in the socket field, causing the sheet to nix itself if you're mace spec :)

Offline
Old 01/23/07, 1:52 PM   #504
roq
Piston Honda
 
Troll Rogue
 
Uther
Pf i echo what everyone says above. Thanks for taking this over, there are alot of rogue out there that appriciate it.

I did notice a bug with the offhand weapons. Whenever i add an offand weapon, i can't get the sockets to take for some reason, causing all the values to go #na. I ended up copying a previous weapon to make sure i wasn't doing something wrong and it still didn't work.

Offline
Old 01/23/07, 4:25 PM   #505
pf
Don Flamenco
 
Dwarf Rogue
 
Garona
Originally Posted by Zoro
Edit: While I think about it I should report that most of the maces are missing the 0 0 0 in the socket field, causing the sheet to nix itself if you're mace spec :)
ty, little things like that slip by me all the time.

Originally Posted by roq
Pf i echo what everyone says above. Thanks for taking this over, there are alot of rogue out there that appriciate it.

I did notice a bug with the offhand weapons. Whenever i add an offand weapon, i can't get the sockets to take for some reason, causing all the values to go #na. I ended up copying a previous weapon to make sure i wasn't doing something wrong and it still didn't work.
An issue that I have already fixed for the next version. Look at cells Q8:W8 and change MHweaponstats to OHweaponstats. It should only be broken for offhand only weapons for fairly obvious reasons.

I've already completed a fairly long list of little minor things that are being fixed in the next version as well. Nothing major, just more polish and fixing some minor issues. I'm hoping the next version out in about a week or so will be polished and bug free enough for me to be completely satisfied with it. Hopefully, someone else can take the mostly bug-free sheet and have little to do other than add new gear until blizzard comes out with all new rogue mechanics which should be about a year down the road.

Offline
Old 01/25/07, 9:22 AM   #506
Araniah
Glass Joe
 
Blood Elf Paladin
 
Illidan
Thanks, Pf. I am also one of the many rogues using this spreadsheet. Came on here to find an answer to some of the problems in the new spreadsheet and found out you were leaving. Sad to see you go. This has helped me alot. As with the bugs, I can attest to not being able to add any new gear or jewels to it. But apparently you already know that, heh. Well, good luck on the know spead and wherever you go in life. Thanks again

Offline
Old 01/25/07, 9:41 AM   #507
Twylyt
Glass Joe
 
Night Elf Rogue
 
Bloodhoof
I'm also a big fan and user of this spreadsheet and appreciate the current and former developers of it.

I've isolated one error in the current version and traced it to references to "zgbuff" in the NextStat worksheet. "zgbuff" is no longer defined but references to it remain. By removing "*(1+0.15*zgbuff)" from the formulas containing that reference the problems with "#NAME?" errors showing up on that sheet are removed.

There was another minor error in the VLookup column references on the "Gear _ Buffs" page but it wasn't effecting anything because no trinkets have +weapon skill currently. The problem was with some of the cells in the block (J53:058) and the column references were wrong. I don't remember exactly which cells were wrong but making sure those are correct will fix the problem.

No way in hell do I want to maintain this spreadsheet but I would be happy to serve as an editor and bug checker/fixer for the current or future developers. If you are interested in my editing assistance just contact me by PM.

Offline
Old 01/30/07, 12:04 AM   #508
pf
Don Flamenco
 
Dwarf Rogue
 
Garona
Random thought, improved weapon totems needs buffing. Anyway, sheet has a little bit of a different look to keep down some of the bloat. Also, if someone with the hourglass trinket wants to do some proc testing on it as the listed 10% procrate from thottbot seems quite overpowered.

http://rogue.bleedo.net/

Version 2.2.1 1/29/2007
Added Wastewalker 4-piece bonus as a 2% chance to proc per thottbot. This as other random procs that give temp stat buffs is not implemented on the next-stat sheet, so crit/hit/agi will be worth slightly more than listed when active.
Added modeling to trinkets with on-use effects. (hourglass seems way to high based on thottbot proc % however).
Added socket info for most maces so mace rogues don’t have a broken sheet.
Added a few weapon procs back into the sheet. This includes TF/MSA and should model some new ones. The Night Blade is modeled as -100 armor as I have no data on procrate.
Added a few new items. Also added white gems since a bit of early lvl 70 gear will include them.
Added a 20% uptime guess for chance on hit +haste weapons.
Added Blinkstrike assuming a 2% chance on hit. (baseless assumption)
Added a Talents page to move the talents away from gear page as it was getting quite bloated.
Added a split on the gear page to keep DPS always in sight as well as what each column represents.
Fixed a bad link to mainhand weapons for offhand stats causing offhand only weapons not to work properly.
Fixed Kiss of the Spider to follow haste rating instead of 20% haste.
Fixed bracer list as the first 2 were not included in drop-down list.
Fixed a div/0 error with 0/3 ruthlessness and mutilate.
Fixed selecting "none" as an item so that it no longer breaks the sheet.
Fixed offhand mutilate attacks to now proc offhand mongoose/crusader enchants.
Fixed variables for offhand deadly poison VII.
Fixed some issues dealing with perma-haste and next-stat sheet
Fixed Windfury formula up a little bit.
Fixed mongoose enchant when using sword spec.
Changed how stamina was rounded off to get closer to actual HP values. Probably slightly off, but should be better than before.
Changed base armor value to 85% since smaller raids will mean less CoR/FF uptime, also corrected an old lvl 60 armor formula left in.
Changed resist rate for non-boss fights to 95%.
Changed a few leftover forced Improved Backstab critrate to the new talent model.
Changed default yellow miss to 8.6% for bosses and 5% otherwise.
Changed windfury formula a little bit to more correctly reflect in game mechanics.
Changed base crit formula to be more accurate (you start with about -.3% crit)

Offline
Old 01/30/07, 4:37 AM   #509
Zoro
Piston Honda
 
Murloc Rogue
 
Aggramar (EU)
Just a thought...
Could you add Troll Beserk in?
At the moment I do it by hand every time. 10% haste every 3 mins makes a small but noticeable difference for us lucky few!

Offline
Old 01/30/07, 10:54 AM   #510
Odium
Glass Joe
 
Undead Rogue
 
Frostwolf (EU)
Hello, I like the sheet a lot.
I just got http://thottbot.com/?i=57479 . Is the proc included in the sheet yet? If not I can perhaps do some testing about the proc chance etc...

Cheers

Offline
 

Go Back   Elitist Jerks » Public Discussion » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rogue Gear Spreadsheet Aldriana Class Mechanics 2892 08/03/08 5:10 AM
Newbie qestion reg. rogue dps spreadsheet thesmellyone The Dung Heap 2 06/21/07 8:18 AM
[Rogue] Haste rating and the spreadsheet Cloak-SH Class Mechanics 11 05/30/07 3:37 PM
Rogue Combat Daggers DPS Spreadsheet chalon Public Discussion 656 02/17/07 8:44 PM
Rogue Spreadsheet tynan Public Discussion 2 12/06/06 5:30 AM