The Roguecraft Spreadsheet - Page 107

• Aldriana · 04/04/09, 6:30 PM

It's not a bug, and it doesn't mean IIV is or isn't better. The sheet does no consistency checking to make sure what you're asking it to model actually makes sense. So by switching from deadly to instant, you're basically telling it you're using double instant poison buy envenoming anyway - which is, of course, impossible, but the sheet doesn't know that. So it returns damage as though you were, in fact, using double instant poison with envenom. And, for obvious reasons, this does more damage - but since it's also impossible, that doesn't matter.

MentalPROblem · 04/05/09, 9:14 AM

I still can't manage Fwk's spreadsheet to work with Excel, I'm getting those #Value! errors, what I tried to do is to copy the formulas from Vuljan's original spreadsheet, I copied these exact cells:
In Cycles, Cycles 1 and Cycles 2 tabs: Evisc/Env DPS B52-Z52 cells, once I've changed those, the error is gone but there is another "line" with errors which is E.DPS AQ44-AQ72, when I change those cells to the formulas from the original spreadsheet the error does NOT go away : / anyone could help me out with this one?
I also wonder how come on the SimulationCraft thread according to their tests, 51/13/7 was outdps'ing 18/51/2 I mean I can understand the slight difference between their model of hat and Mavanas' spreadsheet model but mutilate vs eviscerate is a lot more easier to model, isn't it? Which one do you reckon is right?

Sprawl · 04/05/09, 9:06 PM

Change the cycle to Xs/Yr instead of a three part cycle. Not sure why, but it worked well enough.

mih · 04/06/09, 9:08 AM

Originally Posted by Sprawl

Change the cycle to Xs/Yr instead of a three part cycle. Not sure why, but it worked well enough.

every cycle without evi works

shuvool · 04/06/09, 1:33 PM

With the PTR for 3.1 wrapping up and most of the changes for rogues known, I've kind of been playing with the idea of updating the 2 spreadsheets that everyone uses (for personal use, I don't want to mess with anything anyone else might be in the process of doing). My main question is how to figure out PPM? Is it easier to just hand-write out the math for each weapon speed to convert to a percentage and then plug those variables in on each weapon kind of like the enchants, or is there a simpler way? If this is already being undertaken by someone else more proficient than me, I'll just drop it and wait.

sp00n · 04/06/09, 2:39 PM

That sounds very much like the bug encountered here, with the reason being possibly this.
I thought this was fixed by the way. Maybe I was mistaken.

Gogge · 04/06/09, 6:43 PM

Originally Posted by sp00n

That sounds very much like the bug encountered here, with the reason being possibly this.
I thought this was fixed by the way. Maybe I was mistaken.

For me it was some problem with the "CHOOSE(index;value;value;...) * (value)" part in the "Evis/Env DPS" rows on the cycle 1/2 sheets, it thought that one of those two was a different type, i.e one string and the other a number, or similar, and it broke. Just editing and pressing enter resolved the issue in that specific cell, and then copy/pasting it to the rest of the cells on that row was pretty quick work and seems to have solved it for me, I didn't explore it thoroughly but here's a version that I could use in excel 2007:

http://gogge.se/LC_v0.5_Combat_Ulduar_0.4.7_excel.xls
Savefile: LC_v0.5_Mutilate_Ulduar_0.4.7_excel.xls

Edit: Did the same changes to the fixed version of the sheet as posted by FWk below, fixed a typo in the "Xe (CttC)" cycletableref that referenced to cttce1[x] instead of cttce[x].

Edit2: Added the mutilate sheet.

Edit3: Savefile link for the mutilate sheet.

jest788 · 04/07/09, 10:35 AM

Originally Posted by Gogge

For me it was some problem with the "CHOOSE(index;value;value;...) * (value)" part in the "Evis/Env DPS" rows on the cycle 1/2 sheets, it thought that one of those two was a different type, i.e one string and the other a number, or similar, and it broke. Just editing and pressing enter resolved the issue in that specific cell, and then copy/pasting it to the rest of the cells on that row was pretty quick work and seems to have solved it for me, I didn't explore it thoroughly but here's a version that I could use in excel 2007:

http://gogge.se/Lovecuddles_Combat_U....4.7_excel.xls

Thanks for the spreadsheet update, I did have one question though. As combat without any poison Assassination talents, if I put Wound/Instant I get a HUGE DPS increase. I am talking WP/WP is like 6101 DPS but WP/IP it is like 6400 DPS. Would putting IP Off Hand really increase DPS that much?

FWk · 04/07/09, 3:49 PM

Originally Posted by jest788

Thanks for the spreadsheet update, I did have one question though. As combat without any poison Assassination talents, if I put Wound/Instant I get a HUGE DPS increase. I am talking WP/WP is like 6101 DPS but WP/IP it is like 6400 DPS. Would putting IP Off Hand really increase DPS that much?

I'd like to clarify that the version of the spreadsheet that Gogge adapted for Excel is the oldest version which isn't very accurate, has some bugs, and is missing some features. The instant poison in the OH bug was fixed here: The Roguecraft Spreadsheet

Edit: Gogge has now modified the newest version of the sheet and assuming it works out of the box with Excel, the result looks great.

Blizisyimhot · 04/08/09, 3:17 AM

Originally Posted by Gogge

For me it was some problem with the "CHOOSE(index;value;value;...) * (value)" part in the "Evis/Env DPS" rows on the cycle 1/2 sheets, it thought that one of those two was a different type, i.e one string and the other a number, or similar, and it broke. Just editing and pressing enter resolved the issue in that specific cell, and then copy/pasting it to the rest of the cells on that row was pretty quick work and seems to have solved it for me, I didn't explore it thoroughly but here's a version that I could use in excel 2007:

http://gogge.se/LC_v0.5_Combat_Ulduar_0.4.7_excel.xls

Edit: Did the same changes to the fixed version of the sheet as posted by FWk below, fixed a typo in the "Xe (CttC)" cycletableref that referenced to cttce1[x] instead of cttce[x].

Will you be doing the same changes for the mutilate version of the spreadsheet?

kylep · 04/08/09, 5:35 AM

I like this spreadsheet very much, but I don't see it changing the expertise percentage when I specify that I'm a human using swords. The expertise on the DPS tab changes, and the DPS itself changes, but not the percentage. Should it be changing?

Loot · 04/08/09, 6:17 AM

I think the display there was from gear only, excluding talents and racial. They are calculated tho.

Ixtlilton · 04/08/09, 3:47 PM

For what is it worth...the spreadsheets still list the Darkmoon Card: Death as having haste instead of crit.

ryal · 04/08/09, 11:28 PM

Unsure if this has been addressed already or not but under the "Buffs" tab for "melee haste" should be Improved Icy Talons, not Improved Icy Touch. Minor change nothing major. Again apologies if this has been addressed already.

fuzen · 04/09/09, 11:50 AM

I'd like to say that this spreadsheet is great but I'm fairly new to it and am having some issues. Firstly, I'm using the newest release .5 ulduar and it seems the values for eviscerate and my total dps portrays an error (#value). I'm not quite sure how to fix this problem, I think i've read in here that changing the cycle from Xs/Yr/Ze fixes something. Lastly, this is a very basic question: which dps reading (white, evis., rupture, poison, etc..) should I be looking at to determine my overall dps, I would assume total dps but currently that is not working correctly for me. Any help is greatly appreciated, cheers!