[Rogue] DPS Spreadsheet - Page 40

nilme · 09/08/07, 1:01 PM

Originally Posted by Ellos

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

Well as far as I know any "," and "." get "translated" into the proper version depending on what language you use. As I open the sheet everything(that I guess contained a lot of "xxx.xx") gets changed to "xxx,xx" which is the Spanish format for decimals.
Same for anything in there. For every IF( you type I see a SI(, as the excel script language is translated between versions, which is frankly annoying.

So having "," or "." should not be an issue as excel will change them into the proper version. Anyway, I never had any problem with the bugs people mention above. And again, my excel version is the Spanish one, that like yours, use "," for decimals.
Someone mentioned that the bug only appeared when you used export-import, maybe the export//import function is having some problems with the decimals format?(I don't see why as it only really imports gear, not values)

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

no it changed it only when you write =1,3 aber not when you write 1,3 without the = And it was without so it is text.

Kytrarewn · 09/08/07, 1:27 PM

Yeah, windfury isn't working for me still, which you already know. As a suggestion though, your feint modelling seems like it could easily be modeled in such a way that it would be more flexible.

"Feints per minute dropdown, 1-6", instead of assuming every C/D, since cycle changes and energy -> damage aren't perfectly linear.

So instead of "Costs 10 energy every 10 seconds", you'd have "costs 10 energy every 0,10,20,30,40,50,60 seconds".

Not that I have to really feint that much these days anyway.

Wodahs · 09/08/07, 3:10 PM

Allright, Im sure the weapon skill portion of the miss rate formula is wrong. If you refer to http://elitistjerks.com/469576-post500.html you get the following (dual wield adjusted for rogues0

350 weapon skill vs a lvl 73 has a 28% miss rate.
355 weapon skill vs a lvl 73 has a 25% miss rate.
365 weapon skill vs a lvl 73 has a 24% miss rate.
375 weapon skill vs a lvl 73 has a 23% miss rate.

I do not think the spreadsheet is modeling this correctly at the moment. For example, I have 366 weapon skill with daggers, 299 hit, and 5% precision hit talent at the moment.

That is hit capped I believe, according to the linked post:
23.96% hit + 4.1% from weapon skill.
3% from the first 5 weapon skill.
1.1% from the next 11 weapon skill.
28.06% total.
Im a few % away from hit cap on the spreadsheet. In fact, I need to hit 330ish on the sheet to cap my hit, which is incorrect.

jweick · 09/08/07, 6:16 PM

ok i have been getting some sparatice ###value errors as well, like when i uncheck certian raid buffs like but it is also not repeating it reliably, and if i save dps it will go away. i did notice when i opened it, it had some ###value errors all over in the buffed DPS section.

i am also noting one oddity, when i do a gem upgrade search it is telling me that swift windfire is the best meta i can get....... thats got to be wrong

also, still not working on Mac version of Excel

Saurox · 09/08/07, 7:04 PM

hey, when im equipping the gear I can't get anything other than daggers to show on the list.. how can I show like swords, maces, or fist weapons in the selections...

dinesh · 09/09/07, 1:45 AM

Originally Posted by Saurox

hey, when im equipping the gear I can't get anything other than daggers to show on the list.. how can I show like swords, maces, or fist weapons in the selections...

I'm not normally the sorta guy who does this, but try reading the thread for one of the 57 other times this was asked. the question is repeated about once every page or two. It's also explained in the instructions on the first page. And on the download page. And...

Cyn · 09/09/07, 2:03 AM

Definately must be something wrong with the new Ashtongue trinket model, using even very conservative crit numbers yields higher dps than using the model.

Additionally, what were the changes made to mutilate? Mutilate is coming out as better dps than combat swords for me now o.0

jweick · 09/09/07, 4:25 AM

discovered something interseting in the upgrade routine..........

if you are running the upgrade querry, and wanting to know what the best upgrade is and have any of the Teir gear as choices, unless you have 1 or more of the tier items equiped, it has no way of calculating the choices against a teir bonus.

ie... i un equiped my T4 and went with all kara/gruul= gear. after running the upgrade macro, none of the T4 came up as options. as soon as i swaped 1 item out for a T4 item, it would then look and compare items and show a massive bump in DPS if i equiped a second item (which would enable the set bonus).....

so basically the macro has no way atm of considering set bonuses when recomending gear (unless a set item is already equiped)

Ellos · 09/09/07, 5:41 AM

Originally Posted by jweick

discovered something interseting in the upgrade routine..........

if you are running the upgrade querry, and wanting to know what the best upgrade is and have any of the Teir gear as choices, unless you have 1 or more of the tier items equiped, it has no way of calculating the choices against a teir bonus.

ie... i un equiped my T4 and went with all kara/gruul= gear. after running the upgrade macro, none of the T4 came up as options. as soon as i swaped 1 item out for a T4 item, it would then look and compare items and show a massive bump in DPS if i equiped a second item (which would enable the set bonus).....

so basically the macro has no way atm of considering set bonuses when recomending gear (unless a set item is already equiped)

Yes the reason is, that it only compare one slot, so you got no chance to compare a complett set.
I could chance this but I think no one would use this because it takes a to long time. Every Slot would go throw it's items around 14 times. I would say it takes round 14 times longer to search for updates then (could be longer). If it needs now 1 Minute, than it needs 14 Minutes, to long everyone would think there is something wrong. (and of course I have to change than the display).
So I think it's better to let it be.

Ellos · 09/09/07, 5:46 AM

Originally Posted by Cyn

Definately must be something wrong with the new Ashtongue trinket model, using even very conservative crit numbers yields higher dps than using the model.

Additionally, what were the changes made to mutilate? Mutilate is coming out as better dps than combat swords for me now o.0

Yes there is a bug with the Ashtounge, I'll bring today Version .12 where this is fixt. If made an Typo so I get a value which is to low.

And yes there is a smal change for Mutilate, I'm changed how many Finisher were used. Now a cycle uses 100% of the time from a Slice and Dice. But the DPS change wasn't that huge, only 4-5 DPS I think. Hope I havn't made issues, Rupture was realy difficult.

Ellos · 09/09/07, 6:00 AM

Originally Posted by Wodahs

Allright, Im sure the weapon skill portion of the miss rate formula is wrong. If you refer to http://elitistjerks.com/469576-post500.html you get the following (dual wield adjusted for rogues0

350 weapon skill vs a lvl 73 has a 28% miss rate.
355 weapon skill vs a lvl 73 has a 25% miss rate.
365 weapon skill vs a lvl 73 has a 24% miss rate.
375 weapon skill vs a lvl 73 has a 23% miss rate.

I do not think the spreadsheet is modeling this correctly at the moment. For example, I have 366 weapon skill with daggers, 299 hit, and 5% precision hit talent at the moment.

That is hit capped I believe, according to the linked post:
23.96% hit + 4.1% from weapon skill.
3% from the first 5 weapon skill.
1.1% from the next 11 weapon skill.
28.06% total.
Im a few % away from hit cap on the spreadsheet. In fact, I need to hit 330ish on the sheet to cap my hit, which is incorrect.

Mmmh.. First, I think I'll have to change Formular for non boss mode

Just looked, when I set the Weaponskill to this Values I get those Missrates.. mmh. I'll look if I had to take as Hitchance Hit+Weaponskill.

Okay I looked now. When I get 299Hit +5% From Talents and 16 Weaponskill I'm at 0% Miss.

Looks right

Rerox · 09/09/07, 6:11 AM

There seems to be something wrong with the hit-calculation in 2.2.0.11.
I get a dps increase when I add pure "hitrating" gems even if i am at (or over) the hit-cap.

Ellos · 09/09/07, 6:18 AM

Mmh.. don't know, just tested it in the .12 version, I'm at hit cap now with testequip and there is no DPS increase. Maybe I fixed this bug without knowing

Ellos · 09/09/07, 6:31 AM

Allright 2.2.0.12. Hope it works as wished.

http://rogue.raidcal.com/

2.2.0.12	(ellos)
fixed	a small windfury bug for people with a non german PC :)
	Ashtongue Talisman of Lethality now works correctly for non Mutilate Builds
changed	Feint can be choosen from 0 to 6 Feints per minute
	Calculation for Hit/miss
add	Toggle for Metagem require