[Rogue] DPS Spreadsheet - Page 39

Kytrarewn · 09/08/07, 1:39 AM

Originally Posted by Jarlaxle

So with the haste and internal nerf of DST is it a nono now?
I have Abacus of Violent Odds and Hourglass
we still do gruul on offnights so not sure if DST is still worth it.
Dont do VR much anymore so i dont know if Ill see WSC
And Tsunami trinket doesn't drop for us

It'll still be better than either of your trinkets.

Ellos · 09/08/07, 5:57 AM

The Virus Warning is caused by the import/export function I think (well I don't get one)

I've changed this in 2.2.0.6 because of problems on some other OS (Mac for example) and the Macro is saving a new file in the same folder where the Spreadsheet is saved.

I hope I'm ready today or tomorrow with Version 2.2.0.11.

Ellos · 09/08/07, 8:20 AM

Uploaded a new Version http://rogue.raidcal.com/

Tell me the Bugs :P

2.2.0.11	(ellos)
changed	Ashtongue Talisman of Lethality, now based on the cycles & now includes SnD (ups :) )
	Changed Mongoose (Nextstat:O100) because of Windfury
	Merciless Gladiator's Left Ripper speed to 1.5
	Changed Evi static from 60 to (60+180)/2
	Mutilate cycle, hope it's near on reality now
	Changed the Header
	Boss-Base-Miss from 25.5% to 26% based on http://elitistjerks.com/469576-post500.html
	Instant-Miss from 8.6% to 9%
	Hit calculation for Boss-Mod based on http://elitistjerks.com/469576-post500.html
added	Metagem now only works, when you got the required Gems. Metagem is turning red when the it's not working
fixed	a bug that the last Chest in the list was missing
	a bug with the Nightblade buffed DPS
	added the Gems for Blackout Truncheon 
	
2.2.0.10	(mih)
removed	instant attacks in the formula for windfury
changed	Dragonspine Trophy internal cd -> uptime: 15sek/min
	Madness of the Betrayer (40% uptime)

Edit little typo in the Notes, but I don't upload a new Version for this little issue, in the Sheet it's calculated right.

sp00n · 09/08/07, 9:18 AM

Boss-Base-Miss from 25.5% to 26% based on [Rogue/Warrior] Weapon Skill Adjustment Discussion
Instant-Miss from 8.6% to 9%
Hit calculation for Boss-Mod based on [Rogue/Warrior] Weapon Skill Adjustment Discussion

I haven't downloaded the sheet, but the description is not correct.

If boss mode is NOT enabled it should be:
- 24% miss melee, 5% miss instants, 5% dodge.
- Each point of weapon skill reduces your chance to miss by 0.1% (only full weapon skill counts, fractions are dropped).

If boss mode IS enabled it should be:
- 28% miss melee, 9% miss instants, 6% (or 6.5%?) dodge.
- Each point of weapon skill reduces your chance to miss by 0.4%.
- Once you have reached 5 additional skill (through talents or rating), your miss rate is reduced by another 1% (thus having 25% miss rate with 355 skill) and each further point of weapon skill is worth 0.1% hit just like above.

For weapon skill and dodge, you could either leave it out, or insert a 0.1% reduction per point of weapon skill for melee attacks, and zero (or 0.04%) for instants.
We haven't figured out that formula yet, but in the data samples I have, melee dodge rate is lower than instant dodge rate when you have some additional weapon skill.

Ellos · 09/08/07, 9:41 AM

mmh.. Changed than Boss Miss to 28%

For Miss I picket out this Formular now, should work when I haven't missunderstood your discriptions.

If(Defense - ( 350 + Weaponskill )>10 ; BaseMiss +( Defense - ( 350 + WeaponSkill ) - 10)*0,4%; (BaseMiss - 2%(Bossmode Only) )+ (Defense - (350+Weaponskill))*0.1%) - hit

mmh.. no there is something wrong..

Batory · 09/08/07, 9:44 AM

I've noticed that Fool's Bane casues to turn all maths to #NA in latest spreadsheet.

I also have additional question about Sword Specialisation. Don't know if that question fits to this thread.
According to spreadsheet having MH sword and OH dagger without sword specialisation and with sword specialisation makes around 10 DPS difference with mine gear. From that I assume Sword Spec does proc from MH. I ask to doublecheck myself, because everywhere I read about sword spec, it always says that OH weapon triggers MH attack. I want to make sure if i understand Sword spec in correct way, or am I wrog in some point.

Any help appriciated.

Rosvall · 09/08/07, 9:57 AM

It can proc on whatever hand you use a sword in.

So if you have a sword in MH, OH can't proc, though MH can.

Ellos · 09/08/07, 10:02 AM

okay uploaded a version with lillte changes.

Testst Fool's bane, got no error

Wodahs · 09/08/07, 11:17 AM

I'm pretty positive the miss numbers are not right. When I was running 297 hit, with 16 weapon skill, I had a miss rate below 0.5% on extended fights. Now, per the spreadsheet I need somewhere around 331 hit rating, + precision, with 16 weapon skill to hit cap. I think thats contrary to most rogue logic being floated around.

Sneakerpimp · 09/08/07, 12:01 PM

2.2.0.11 still gives me the "#VALUE!" error described in post 502.

Ellos · 09/08/07, 12:10 PM

I got no problems with windfury.

had you changed the Equip/Talents? And when yes to what. I need more information to fix this problem.

Mikhael · 09/08/07, 12:17 PM

Yep, same Windfury bug as the other sheets. Cell B107 on Gear_Buffs is presently "1,3". It should be "=1+.15*C107".

This is thanks to Doink, post 511

Ellos · 09/08/07, 12:22 PM

Well this could be a error, but this should not the problem with the issue above.

As long as the field got 2 imp Windfury, the value is still 1.3

aaaah, I see the issue, in german the . is a , and thats the reason it works for me

Dread · 09/08/07, 12:25 PM

I am a little boggled by Ashtongue Talisman of Lethality, wielding no trinkets and equipping it it shows a -132,22dps loss just for equipping it instead of having an empty slot :P
I dont know exactly what with this change (Ashtongue Talisman of Lethality, now based on the cycles & now includes SnD) that made it like this, but i find it hard to belive that you're better off wearing no trinket at all

Ellos · 09/08/07, 12:30 PM

Originally Posted by Dread

I am a little boggled by Ashtongue Talisman of Lethality, wielding no trinkets and equipping it it shows a -132,22dps loss just for equipping it instead of having an empty slot :P
I dont know exactly what with this change (Ashtongue Talisman of Lethality, now based on the cycles & now includes SnD) that made it like this, but i find it hard to belive that you're better off wearing no trinket at all

before this version I had hardcoded it so a cyclechange wouldn't effectet this, In this version I changed it.. mmmh it shouldn't give such a value. could you upload your sheet with your Equip so that I can see this?

I would say the reason is in the nextstat but I'm not sure.

okay I don't need this, I see the bug.
Fixt this, had made a little issue, I will wait until tomorrow for more bugs and then upload a .12 with bugfixes