The Roguecraft Spreadsheet - Page 21

xvvx01 · 11/30/08, 6:52 PM

Originally Posted by turbare

Ok, i can't seem to find this, and it's not very clear to me, but if i use a 5 SnD 5 Rupture 5 Envenom rotation on bosses, which cycle should i select in the spreadsheet?
The thing that got me going was the fact that i got [Split Greathammer], and the spreadsheet shows it as a DPS decrease from [Fang of Truth], which i find hard to believe, even with the 1.6 speed and me being sword specced at this moment.

Going off the top of my head here but the terminology might not be exact.

You would specify a XsYrZe cycle. Set it to Envenom over Eviscerate and set the combo points for each finisher at 5.

Xerxes25 · 12/01/08, 2:08 AM

I didn't see a post about it anywhere, and you likely already know this, but the spreadsheet doesn't seem to account for human racials. I select my race as human, and I am using swords in both hands but my expertise is never accurate.

Is there a way to add this in myself so AEP and upgrades are calculated correctly?

• Vulajin · 12/01/08, 2:14 AM

The expertise for both dwarf and human racials is accommodated correctly by the spreadsheet, but it does not display in the headers on the four main settings sheets ("Talents & Settings," "Gear," "Buffs," "Cooldowns") because it is applied on a per-hand basis for each ability.

Originally Posted by Caffeine

I am a bit unsure about this, to me it seems that haste procs are not added properly. If I manually change a trinket without any on use effect or procs and set it to passive 74 crit rating and 92 haste rating (this is the average given for Meteorite Whetstone for my gear in DPS Calc 3) I get roughly 20 more DPS using this passive trinket than with Sphere of Red Dragon's Blood or the Meteorite Whetstone as it is implemented in the sheet.

Turns out you were correct and there will be a forthcoming update to fix the bug that was causing this.

• Vulajin · 12/01/08, 3:40 AM

Version 0.4.1 is available via the download link in the first post. Changes:

- Reordered calculation of armor effects on Killing Spree to be consistent with other calculations.
- Removed Drums of Battle and Drums of War.
- Added Enchant Gloves - Precision.
- Moved "Saved DPS" field to Gear sheet and added instructions.
- Fixed an error where haste procs were not properly feeding into the cooldown model.
- Fixed an error when selection "None" for your meta gem.

The error with respect to proc-based haste and the cooldown model is the most significant part of this update, and everyone who uses [Meteorite Whetstone] pretty much needs to download this. Most of the other changes are incidental.

• Neto- · 12/01/08, 4:30 AM

The Eternal Belt Buckle isn't automatically adding the extra socket - but it can be done manually for now: change the A72 cell to Any.

saedo · 12/01/08, 5:16 AM

Originally Posted by Neto-

The Eternal Belt Buckle isn't automatically adding the extra socket - but it can be done manually for now: change the A72 cell to Any.

The fix is to change it to the "Titanium Belt Buckle" to "Eternal Belt Buckle" in that cell.

Also as a note, that haste proc fix probably fixes [Signet of Edward the Odd] as well.

turbare · 12/01/08, 6:24 AM

Originally Posted by xvvx01

Going off the top of my head here but the terminology might not be exact.

You would specify a XsYrZe cycle. Set it to Envenom over Eviscerate and set the combo points for each finisher at 5.

Made the changes, and even with this spec Talent Calculator - World of Warcraft it shows the mace as being a downgrade by about 10-15 dps.
Do you guys find this appropriate? I know it's a mace (1.6 speed) vs a sword (1.5 speed) but still, it has ~35 more dps, plus the stats.

Scound · 12/01/08, 7:49 AM

Originally Posted by turbare

Made the changes, and even with this spec Talent Calculator - World of Warcraft it shows the mace as being a downgrade by about 10-15 dps.
Do you guys find this appropriate? I know it's a mace (1.6 speed) vs a sword (1.5 speed) but still, it has ~35 more dps, plus the stats.

If you want to compare the two Weapons do it without any kind of weaponspecialisation selected. You will see the Mace indeed being superior to the sword.

The sword in your case is that good, as its faster Speed not only triggers more Combat-Potency Procs (increasing cyclespeeds) but also more Swordspec-Procs per minute (which are executed with your Mainhand-Weapon, meaning the better the Mainhand the better a slower offhand).

koaschten · 12/01/08, 9:15 AM

Originally Posted by Scound

... but also more Swordspec-Procs per minute (which are executed with your Mainhand-Weapon, meaning the better the Mainhand the better a slower offhand).

I assume you wanted to say "faster offhand" because anything else wouldnt make sense. Just clarifying.

• Rerox · 12/01/08, 10:37 AM

While checking out some gear upgrades, I noticed that the dps-gain of the 2-pieces and 4-pieces Bonescythe setbonus seems to be quite low and lackluster.

While the 2-pcs-Bonus of T6 nets for about 100dps and the 4-pcs-Bonus of T6 still for about 45 dps,
the 2-pcs-T7-Bonus registers for only roughly 20dps and even the 4-pcs-T7-Bonus delivers just about 80 dps.

Is that really the expected damage range for these bonuses?
If so that makes the replacement of 2-pcs-T6-bonus even harder.

Boojangles · 12/01/08, 10:58 AM

Edited out due to my idiocy.

ekval · 12/01/08, 11:52 AM

Originally Posted by Rerox

While checking out some gear upgrades, I noticed that the dps-gain of the 2-pieces and 4-pieces Bonescythe setbonus seems to be quite low and lackluster.

While the 2-pcs-Bonus of T6 nets for about 100dps and the 4-pcs-Bonus of T6 still for about 45 dps,
the 2-pcs-T7-Bonus registers for only roughly 20dps and even the 4-pcs-T7-Bonus delivers just about 80 dps.

Is that really the expected damage range for these bonuses?
If so that makes the replacement of 2-pcs-T6-bonus even harder.

This seems to be the case, and while T7 set bonuses aren't anything spectacular, you still can get rid of T6 parts at some point.

sp00n · 12/01/08, 1:14 PM

Originally Posted by Furtim

Added Rating Conversions and Pawn import strings for AEP, EP, and DPS

They are currently hard-coded to level 80, but why even bother with this if you're not 80 yet.

I updated the sheet to include your EP & DPS strings. Good idea.
However, the conversion to ratings was unnecessary, as the values already represented ratings, and not %. I updated the description to make that more clear.

I also fixed the stupid bug where 2 EP was worth only 1 point. Should be 2 of course. After all, these are values derived from AP...

No changes beside those, just did a quick check if it works with 0.4.1, which seems to be the case.

Roguecraft.AEP.v1.1

Tetmikem · 12/01/08, 1:50 PM

I don't have Excel on my computer, does anyone know any other way to get the spreadsheet to work without it? If not, then is using the AEP system my best way to compare upgrades?

sp00n · 12/01/08, 1:58 PM

OpenOffice

The sheet itself will work with it, the AEP calculation not.

mechler · 12/01/08, 2:34 PM

Enchant Bracers - Greater Assault - Spell - World of Warcraft
In the latest version of the spreadsheet this gives 38 Attack Power but the spell on Live gives 50 attack power.

Muck · 12/01/08, 2:41 PM

The 51 Talent is calling "Killing Spree" and not "Murder Spree".

kurosawa · 12/01/08, 3:32 PM

I may just be blind, but I cannot find Heroic Presence anywhere on the sheet. Is it automatically implemented?

◊ chalon · 12/01/08, 4:11 PM

Originally Posted by Vulajin

Version 0.4.1 is available via the download link in the first post. Changes:

- Reordered calculation of armor effects on Killing Spree to be consistent with other calculations.
- Removed Drums of Battle and Drums of War.
- Added Enchant Gloves - Precision.
- Moved "Saved DPS" field to Gear sheet and added instructions.
- Fixed an error where haste procs were not properly feeding into the cooldown model.
- Fixed an error when selection "None" for your meta gem.

The error with respect to proc-based haste and the cooldown model is the most significant part of this update, and everyone who uses [Meteorite Whetstone] pretty much needs to download this. Most of the other changes are incidental.

Handful of notes:
1. Titansteel Shanker is not listed in the MH weapons
2. Greater Assault (wrist enchant) is 50 AP now, not 38
3. The bonus socket on the belt at least doesn't seem to work anymore. You can select Eternal Belt Buckle but it doesn't seem to add in the gem value anywhere

Haven't seen any other issues than that so far.

saedo · 12/01/08, 4:19 PM

Originally Posted by chalon

3. The bonus socket on the belt at least doesn't seem to work anymore. You can select Eternal Belt Buckle but it doesn't seem to add in the gem value anywhere

This part is because the A72 is looking for a Titanium Belt Buckle, instead of Eternal Belt Buckle for some reason. Can change it to fix that part.

Echophantom · 12/01/08, 6:03 PM

Edited for stupidity, and apologies to chalon. Misread the name and thought someone was complaining about the sheet again.

◊ chalon · 12/01/08, 6:39 PM

Uh, I obviously know how to add it myself. But I mentioned it because I'd suspect it would be a common choice for a main hand weapon, and thus should be on the default list.

Also, the space isn't really limited because you can just add a row and change the named regions.

ekval · 12/01/08, 7:08 PM

Pardon me if this has been answered earlier but out of curiosity, why is the armor value 11990 in spreadsheet? Are the armor values flawed in thread like Wrath boss armor testing or where does 11990 come from? I know it's really simple to change it, just curious which number is correct one.

sdwwraith · 12/01/08, 7:25 PM

Just happened to notice - Target levels go 70, 71, 72 and Boss. Shouldn't those be 80, 81, 82 and Boss?

laod · 12/01/08, 8:15 PM

With the appropriate spec and the same enchant shouldn't [Librarian's Paper Cutter] typically be a better OH than [Fang of Truth]? Even taking the significantly better weapon stats, human racial and the boost from sword spec in to account, .2 spd and 10 dps seems huge. However, I'm seeing the fang as giving me about 40 more dps on the sheet. I generally trust the sheet. What am I forgetting or misunderstanding?

EDIT: swapping my poisons narrowed the gap to 13 dps.