The Roguecraft Spreadsheet - Page 70

Ticia · 05/21/09, 12:46 PM

Originally Posted by tetracycloide

For auto attacks my instinct is that this is a wash, perhaps a slight DPS gain. The haste will reduce the % chance to poison but the overlapping effect with the envenom buff might result in a DPS gain after factoring in the increase in hits during the buff due to the nature of the buff being of limited duration. For instants it would strictly be a DPS loss because the small haste gain is not going to change the energy regen profile enough to add more instants and the % chance will be lower than it was without the haste. My instinct would be that tying a haste cooldown to envnom, given these two effects, would be a net loss but that's just an educated guess. Tying the cooldown to your instant would not be much better but tying it to rupture would probably eliminate the possibility of overlap with the envenom buff.

You are assuming that haste would decrease the chance per hit to proc poison, which as far as I know is not the case. The chance per hit to proc poison is determined by which poison you are using and your weapon's base speed, not it's hasted speed. So the increase in haste could only be a DPS gain, as you will be attacking more often and therefore have more chances to proc at the exact same percentage per hit.

How much of a DPS gain the synergy between envenom and Hyperspeed Accelerators is is another question, however, and I suspect it's not that significant.

tetracycloide · 05/21/09, 3:50 PM

That is totally right, I rechecked the mechanics and poisons do not work the way I discribed. At worst poping a haste buff with the envenom buff up is a DPS wash if no extra hits within the buff window result and at best, indeed in most cases, it is a DPS gain.

nordveien · 06/03/09, 4:07 AM

Originally Posted by Gogge

The problem is hotfixed by opening the sheet in excel, unhiding the cycles/cycles1/cycles2 sheets, editing the "broken" cells and then pressing enter. It's discussed a few pages back.

Mutilate excel: LC_v0.5.3_Mutilate_Ulduar_0.4.7_excel.xls
Combat excel: LC_v0.5.3_Combat_Ulduar_0.4.7_excel.xls

Dear thread author, would you mind linking updated for 3.1 spreadsheets in the 1st post?
So that it would help those who's searching for info to find it much quicker.

I spent about a week convinced that Vulajin's spreadsheet is no longer viable and wondering why it's not being updated for that long. Yeah, I know, I suck, but still... Very hard to find useful info among xxx-paged threads if it's somewhere in the middle.

turbare · 06/03/09, 5:11 AM

Well, these additional sheets aren't made by Vulajin, they are modified by other forum members, based on Vulajin's original one, until he has the time to make an official release.

nordveien · 06/03/09, 10:03 AM

Links to corresponding reply posts then?
Anything would do, really.

Vef · 06/05/09, 9:25 AM

This is the spreadsheet I'm currently using. I updated Furtim's version with that Gear_Upgrade-Macro and put all those 3.1 changes in. I haven't worked much with Excel so far, but the spreadsheet seems to be accurate. I removed gear with an ilvl lower than 213 and made an extra spreadsheet with daggers only for mutilate, so the upgrade macros work faster. I also removed the prismatic quality of JC gems and put colors in to reflect the JC changes in the next major content patch. If you want to change that you can easily unhide the Gem worksheet und change the colour to "Any".

Roguecraft-LK-0.4.7_macro_v2_3.1-muti
Roguecraft-LK-0.4.7_macro_v2_3.1-combat

Mindflayer · 06/07/09, 4:41 AM

Originally Posted by evolart

Why aren't any of you brilliant people working with Rawr guys to make a model for rogues? That program is very slick...just does not work for rogues.

I'm finally catching up on some of these threads...

I wouldn't call myself brilliant by any stretch of the imagination, but I've been working on updating the Rawr.Rogue module. An alpha version was even included in 2.2.6. Its still missing a bunch of things, but you can see the status here.

[edit]
I should mention that I'm not shooting for 100% DPS model accuracy out of the gate. I'm trying to get most things modeled, so we can test different specs, and get a good idea of gear upgrades. But if we can get to 100%, I won't be complaining.

[/edit]

thottstation · 06/10/09, 10:59 AM

I figured out for myself how to add gear not already in the spreadsheet (and edit gear that had wrong stats, probably due to human error), but I still don't know how to add the new Killing Spree glyph.

I'd appreciate some guidance, or even a link to one of the thousand posts in this thread that tells how (using Search came up dry), even if the answer is "can't be done, try someone else's spreadsheet".

Infamous · 06/10/09, 12:27 PM

Originally Posted by Vef

This is the spreadsheet I'm currently using. I updated Furtim's version with that Gear_Upgrade-Macro and put all those 3.1 changes in. I haven't worked much with Excel so far, but the spreadsheet seems to be accurate. I removed gear with an ilvl lower than 213 and made an extra spreadsheet with daggers only for mutilate, so the upgrade macros work faster. I also removed the prismatic quality of JC gems and put colors in to reflect the JC changes in the next major content patch. If you want to change that you can easily unhide the Gem worksheet und change the colour to "Any".

Roguecraft-LK-0.4.7_macro_v2_3.1-muti
Roguecraft-LK-0.4.7_macro_v2_3.1-combat

Changing the major armor debuff to not present or false on that sheet yields no change in dps.

Vef · 06/10/09, 1:08 PM

fixed it

Roguecraft-LK-0.4.7_macro_v2_3.1-combat
Roguecraft-LK-0.4.7_macro_v2_3.1-muti

Corporations · 06/11/09, 5:26 AM

Can I add most gear, gems, etc. to the spreadsheet by unhiding the appropriate worksheet and adding a line for my unlisted Ulduar drop with the relevant stats? (I realize that some items like T8/8.5 with set bonuses require some extensive editing which I'm not prepared to do by myself.)

Originally Posted by Vef

fixed it

Roguecraft-LK-0.4.7_macro_v2_3.1-combat
Roguecraft-LK-0.4.7_macro_v2_3.1-muti

Has anyone else tried this spreadsheet safely? No offense, but I'm cautious about running macros from a random Internet stranger who's only posted twice. Thanks!

Originally Posted by nordveien

I spent about a week convinced that Vulajin's spreadsheet is no longer viable and wondering why it's not being updated for that long. Yeah, I know, I suck, but still... Very hard to find useful info among xxx-paged threads if it's somewhere in the middle.

To me this spreadsheet still seems very useful. Idk if you're saying you still think it's not viable or if you only thought that for a week. Can anyone else comment on the viability of Vulajin's Feb. 2009 spreadsheet, Roguecraft LK 0.4.7? Thanks!

calebdk · 06/11/09, 7:46 AM

Whats the difference between dps calc1 and 2 and cycle 1 and 2?

Varg · 06/11/09, 6:19 PM

Originally Posted by Corporations

Can anyone else comment on the viability of Vulajin's Feb. 2009 spreadsheet, Roguecraft LK 0.4.7? Thanks!

Vulajin's sheet is lacking both gear and updated game mechanics, so you either have to use some "stranger's" updated sheet or wait for an update. There's also aldriana's sheet, even if it's not as user friendly.

Onodrim · 06/12/09, 5:55 AM

Originally Posted by Varg

Vulajin's sheet is lacking both gear and updated game mechanics, so you either have to use some "stranger's" updated sheet or wait for an update. There's also aldriana's sheet, even if it's not as user friendly.

This is in no way meant as a downgrade of Vulajin's spreadsheet of which I've long been an ardent user. However, as you mention, the version currently available for download's been outdated for some time now; and while there's obviously the chance that your idea of user friendliness is invariably in tune with how Vulajin's constructed his version of a spreadsheet, I suspect there's a chance that you haven't taken a gander at the current version of Aldriana's sheet. If you seek simplicity and user friendliness, there you go.

Vef · 06/13/09, 10:06 AM

Originally Posted by Corporations

Can I add most gear, gems, etc. to the spreadsheet by unhiding the appropriate worksheet and adding a line for my unlisted Ulduar drop with the relevant stats?

You can do so. If the new entered items don't appear in the drop-down menu you should take a look into the name manager for example: headlist, headstats and look if the reference lists the new items.

Originally Posted by calebdk

Whats the difference between dps calc1 and 2 and cycle 1 and 2?

Those are iterative calculations for haste, energy and poison uptime. The final calculation are in Dps and Cylces.

I made some corrections with armorpen. in dps 1+2

Roguecraft-LK-0.4.7_macro_v2_3.1-combat
Roguecraft-LK-0.4.7_macro_v2_3.1-muti

StijnH · 06/18/09, 4:01 PM

Originally Posted by Vef

I made some corrections with armorpen. in dps 1+2

Roguecraft-LK-0.4.7_macro_v2_3.1-combat
Roguecraft-LK-0.4.7_macro_v2_3.1-muti

Could you consider a different host? I'm getting this message:

Your Free-Traffic is exceeded!

You have reached a maximum number of downloads or used up your Free-Traffic! You want to download more?
Get your uploaded Premium-Account now!
Your Premium-Account will be activated immediately after your order. (Or wait 56 minutes!)

Thank you for the extra work on the spreadsheet!

Vef · 06/18/09, 6:54 PM

- "Sword Spec" is now "Hack and Slash"
- added Comet's Trail

Roguecraft LK 0.4.7_macro_v2_3.2

Vef · 06/21/09, 5:37 PM

i looked into the formulas and corrected some things, like trinket uptime, heroism/bloodlust uptime was based on a 5 min cd and i made some improvements for 2pt8 bonus value. I also added gear you can get from tournament/heroics/emblems/crafters and 10er Naxx.

Roguecraft LK 0.4.7_macro_v2_3.2

Infamous · 06/22/09, 4:19 AM

Could you throw stormjewels into the gem list? Also I notice scrolls impact damage on the buffs tab, I remember them being unable to stack with horn of winter or shaman totems (STR AGI scrolls naturally) has this been changed or have I simply been raiding based on misinformation this expansion?

Infuria · 06/22/09, 2:28 PM

Originally Posted by Infamous

Could you throw stormjewels into the gem list? Also I notice scrolls impact damage on the buffs tab, I remember them being unable to stack with horn of winter or shaman totems (STR AGI scrolls naturally) has this been changed or have I simply been raiding based on misinformation this expansion?

It's really easy to input gear, gems, etc. All you need to do is go to: Format -> Sheet -> unhide (Gems) -- and insert a line with Delicate Stormjewel, 20 agility, red socket.

Vef, can't thank you enough for updating this sheet. It's a great companion to Aldriana's & a great tool.

I do have one question, however. What is going on with haste in your spreadsheet? It gives zero, or negative value to haste. For example, if I remove the 72 haste from my legs, I gain 2.94 dps. It is thereby giving me incorrect information on gear swapping. Another example: If I switch from Flamestalker boots to Footpads of Silence, the sheet tells me I will gain 65.00 dps. This can't be accurate.

...Can it?

Vef · 06/22/09, 9:55 PM

Thank you for your feedback.
The calcs in cooldowns 1+2 were messed up at the bottom, which caused wrong results if the combat duration wasn`t set to infinite. I fixed it.

Roguecraft LK 0.4.7_macro_v2_3.2

cheesepls · 06/24/09, 6:04 PM

Guys ill be upfront and honest and say ive never used a spreadsheet before in my life, but i seriously wanna improve my gear and dps.

Some of my current gear isnt available to select on the spreadsheet so obviously im trying to work out how to add it, is it just a case of typing the items name and stats into hidden sheet??? and where do i find the values for base score and rank?

Appreciate any help that you can offer

cheers

Vef · 06/24/09, 11:33 PM

Yes, you can just type the gear that is not listed into the correct sheet. But adding set items and trinkets is a little more complicated to explain.
In this spreadsheet there is no aep ratings and stuff. But you can click the Gear Upgrade Check macro and look which item you have gives you the most dmg bonus. After you put on this item you run the macro again and look which item gives the most now..and so on.
Alternative you can use sp00n's AEP values calculator for this spreadsheet. Roguesheet AEP Values

------------------------------

I uploaded an experimental 3.2 version. It includes the new implemented items and t9 bonuses. 2 piece t9 currently assumes a 10% proc chance.
Also i fixed something with rupture crits in 3.1 version.

Roguecraft 3.1+3.2+macro

StijnH · 06/25/09, 5:52 AM

A long-standing bug: the extra weapon socket for Blacksmiths did not make WotLK retail

A UI annoyance: Gear sheet, row 9 should have a row height of 13,5 to avoid overlapping C8 when editing C9

Joigahdenn · 06/25/09, 3:10 PM

Originally Posted by StijnH

A long-standing bug: the extra weapon socket for Blacksmiths did not make WotLK retail

That isn't a bug. Not everything that is written into patch notes at some point will necessarily be implemented in game. If you think about it from a balance perspective it makes sense, since and extra socket would increase the value of BS by roughly 50%.