The Roguecraft Spreadsheet - Page 105

FWk · 04/01/09, 2:47 PM

@ Rerox, Oscarvil, Darkshine

I didn't touch any of the cycles or anything regarding envenom and eviscerate. I think the main reason you're getting errors is because I'm using OpenOffice Calc 3.0 and you're presumably using Excel. One solution that might work is just to copy over the affected cells from Vulajin's original spreadsheet like Darkshine did. I know I had to do something similar when I first got Vulajin's sheet (he works with Excel). I'm not familiar with what's actually happening but the bottom line is the two programs aren't fully compatible. If you're using OpenOffice 3.0 (OpenOffice 2.x is no longer compatible since 0.4.7!) and you still get errors, please send me a PM and I'll try to track it down. Everyone else, I'd suggest re-entering or copying over the cells that have errors. Unfortunately I don't have access to Excel for testing.

Originally Posted by Rerox

On a sidenote, epic wotlk-gems shouldn't be in the gem-list, since they are not present in the game yet, except the new "stormjewels". Enchanted Tear is still missing from the gems-list although it is higher dps for non JCs than blue gems. Ah yes and the gear list still shows only "incription of the axe" as "default" shoulder enchant, this should be changed too.

If you really want to upgrade the sheet to proper 3.1 usage for everyone (and not wait for Vul to do it anyways) you might want to pull into the default gear setup the standard BiS items (like DMC: Greatness etc.) and don't use any profession-specific enchants or gems. Its better usability or everyone if you have a common "everyone can have these" default gear than some profession specialties you have to remove first if oyu are not of the profession.

Those are good points. I added the gems, changed the inscription and used profession-agnostic gear choices.

Originally Posted by Wytryszek

Awesome work - thank you.
I see that changing the offhand poison type in the Combat version to IP nets +5% increased total DPS (about +320dps). That is still in the current gear, so not counting the new DP set bonus. But it sounds quite significant.

I fixed an error in DPS.P13 where Instant Poison on the OH was still using the mainhand PPM value. Changed DPS.P13 to
J33*S11*(1-P7)+IF(cpbuilder="Shiv";D33;0)*(1-S11)*(1-P7)
Replaced Q11 with S11. My mistake I never tested IP in the offhand. I went ahead and tested 18/51/2 WP/IP on the PTR is the result I got is consistent with the new simulated DPS.

I've uploaded a new version (v0.4) primarily to fix the IP error.

Mutilate: http://rapidshare.com/files/21625360...duar_0.4.7.xls

Combat: http://rapidshare.com/files/21716485...duar_0.4.7.xls

• Vulajin · 04/01/09, 5:04 PM

Finally completed version 0.5.0 of the spreadsheet! Download link can be found here:

Roguecraft Spreadsheet 0.5.0 LK

Changes in this version:

- Greatly reduced the complexity of the available options.
- Provided handy EP value readouts, finally!
- All items now link to their Wowhead info pages.
- All items now include additional information (handedness, rarity, etc.) to serve as a quick reference.
- Added a large number of additional items.
- Unfortunately, had to cut support for some options, like user-specified cycles and cooldown usage.

I think you'll all agree this version of the sheet constitutes a massive improvement over previous versions. As always, please report bugs and I'll release 0.5.1 to fix them ASAP.

chalon · 04/01/09, 5:09 PM

Well, given that Vulajin has basically said he'd never put in EP values, this is a welcome change.

EDIT: Argh timestamps

MentalPROblem · 04/01/09, 5:30 PM

Err.. the link leads to shadowpanther.net/armor-pve and not to the download whatsoever
1st April is over and you can only make jokes before 12.00 in the morning I heard
Also, you've suggested copying the affected cells from Vuljan's spreadsheet, but err.. they are exactly the same so after copying it doesn't help either, I'm still getting the #Value! error in both Mutilate and Combat spreadsheet
Also, when you posted your reports were you referring to 18/51/2 SHIV build and have you applied the shiv changes to it (the fact that it cannot crit etc.)? Is there any chance you could add a wowhead link to the exact talent build and say which weapons you were using? Could you add the 51/13/7 Eviscerate build with Webbed Death/Webbed Death IP/IP?

FWk · 04/01/09, 5:46 PM

Thanks for releasing 0.5.0 Vulajin!

The new features are great. Wowhead links really make finding gear that much easier. And with EP values provided I can always tell what pieces are superior and by how much!

I'm thrilled you added additional items like Strength jewelry. I've often wondered how my dps would fare if I repaid all those jerks who steal my leather in full.

I think I've found a bug though: there's now no way to switch between Combat and Mutilate. What gives?! Please fix this in 0.5.1.

MentalPROblem · 04/01/09, 5:50 PM

Is it just me seeing the link leading to shadowpanther.net? :P

wykedtron · 04/01/09, 5:57 PM

Originally Posted by Vulajin

Finally completed version 0.5.0 of the spreadsheet! Download link can be found here:

Roguecraft Spreadsheet 0.5.0 LK

Changes in this version:

- Greatly reduced the complexity of the available options.
- Provided handy EP value readouts, finally!
- All items now link to their Wowhead info pages.
- All items now include additional information (handedness, rarity, etc.) to serve as a quick reference.
- Added a large number of additional items.
- Unfortunately, had to cut support for some options, like user-specified cycles and cooldown usage.

I think you'll all agree this version of the sheet constitutes a massive improvement over previous versions. As always, please report bugs and I'll release 0.5.1 to fix them ASAP.

I'm calling april fools.

MentalPROblem · 04/01/09, 5:59 PM

Traditionally, in some countries, the jokes only last until noon, someone who plays a trick after noon is called an "April Fool".

Source: April Fools' Day - Wikipedia, the free encyclopedia

Darkshine · 04/01/09, 7:10 PM

Originally Posted by MentalPROblem

Err.. the link leads to shadowpanther.net/armor-pve and not to the download whatsoever
1st April is over and you can only make jokes before 12.00 in the morning I heard
Also, you've suggested copying the affected cells from Vuljan's spreadsheet, but err.. they are exactly the same so after copying it doesn't help either, I'm still getting the #Value! error in both Mutilate and Combat spreadsheet
Also, when you posted your reports were you referring to 18/51/2 SHIV build and have you applied the shiv changes to it (the fact that it cannot crit etc.)? Is there any chance you could add a wowhead link to the exact talent build and say which weapons you were using? Could you add the 51/13/7 Eviscerate build with Webbed Death/Webbed Death IP/IP?

Are you sure you copy and pasted to the right place? Line 41 doesn't actually matter since it's for ashtongue talisman stuff, but line 52 is only for one of the cycles (I think it's one of the combat ones, it was just the first place I noticed the error). I had to scroll down and copy+paste the cells into the table for the cycle that I was using (4e/4r CttC in my case).

Also, I didn't mention it before but thanks a lot to FWk for updating the spreadsheet!

Mavanas · 04/01/09, 9:40 PM

What's interesting is that using panther is not that far from using the actual spreadsheet in terms of finding best gear.

Rerox · 04/02/09, 10:46 AM

Originally Posted by MentalPROblem

Also, you've suggested copying the affected cells from Vuljan's spreadsheet, but err.. they are exactly the same so after copying it doesn't help either, I'm still getting the #Value! error in both Mutilate and Combat spreadsheet

I could get it to work when I pasted the cells from the original sheet over the cells that showed the #value error in the cycles tab.
Clicking into each "error" cell in the cycles tab abd confirming the formula by pressing enter works too, but copy&paste from the original sheet is faster.

Really seems like a OO/Excel problem, since there is nothing wrong with the formula in these cells, you just have to "reconfirm" every single Envenom/Evis-dps formula.

testor · 04/02/09, 11:50 AM

just wondering if anyone else is having trouble matching the spreadsheet for combat builds...

on patchwerk
mut build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4700, close enough
combat build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4200, big discrepancy

i have looked over the wws. rng isnt a factor, neither is time to kill. my cycles are tighter on combat than on mut.

something seems amiss....

Elassar · 04/02/09, 1:32 PM

Originally Posted by testor

just wondering if anyone else is having trouble matching the spreadsheet for combat builds...

on patchwerk
mut build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4700, close enough
combat build, weapons, buffs, spreadsheet shows 4900 dps, and i get 4200, big discrepancy

i have looked over the wws. rng isnt a factor, neither is time to kill. my cycles are tighter on combat than on mut.

something seems amiss....

A few questions that come to mind...
1. Were your raid buffs and target debuffs the same between for both combat and mutilate?
2. Are you specifying the time for your use of cooldowns as combat?
3. Are you sure the fight duration on the spreadsheet approximates the actual fight length? I'm guessing that is what "neither is time to kill" means, but it is worth mentioning.

saedo · 04/02/09, 2:17 PM

Originally Posted by testor

something seems amiss....

One more thing to ask, are you slime dipping? (even once in the beginning to get hp low?)

saedo · 04/02/09, 5:56 PM

Originally Posted by FWk

Over the last couple of weeks I've made changes to version 0.4.7 to update it for patch 3.1 and Ulduar.

One minor thing I just noticed, the Shoulderpads of the Monolith is missing the yellow socket in it.