[Rogue] DPS Spreadsheet - Page 2

Darmoc · 07/14/07, 1:07 AM

Loving the [Gem upgrade][All Upgrade] buttons.

Three things I'm wondering.

Could it be possible to give an option to enter your professions, and then detect that because your Mining and Herbing, that you can not create the BoP leatherworking items, and thus filters them out from the floating point?

Could it be added to enter what bosses you've downed, and have only the loot from those bosses displayed?

And last, is there anyway to extract the information from the armory and have it automatically plugged into the spreadsheet?

These are just some things i was wondering and thanks again for the hard work.

Sindhura · 07/14/07, 2:25 AM

Please clarify

My in game to hit rating is 263 (16.68%) as displayed on the character page, and according to the spreadsheet my to hit is 21.65% (unbuffed total 342 - includes 79 from talents). I assume that either a) precision has not been taken into consideration on the WOW sheet or b) the spreadsheet has included precision twice. Which is it?

Darmoc · 07/14/07, 2:27 AM

Originally Posted by Sindhura

Please clarify

My in game to hit rating is 263 (16.68%) as displayed on the character page, and according to the spreadsheet my to hit is 21.65% (unbuffed total 342 - includes 79 from talents). I assume that either a) precision has not been taken into consideration on the WOW sheet or b) the spreadsheet has included precision twice. Which is it?

The hit rating on your character sheet does not include predision. add 5 to what it says.

evl · 07/14/07, 4:16 AM

The upgrade feature is really neat but it would be even better if it was stated where all the items drop like in the gear spreadsheet enabling you to filter out items you have no chance of getting too like Hyjal/BT in a Kara guild.

Apsalar · 07/14/07, 5:27 AM

Latito, you are forgetting one thing. A single non-dagger weapon specced rogue will have 4 or 5 points in vile or imp poison. Now that probably isn't enough for a pure sword specc to overtake fist/swords, but it is most likely enough to level the playing field.

Ellos · 07/14/07, 5:30 AM

Originally Posted by Rhiktif

Are there any plans to add
- AEP Calculation
- Item compare over AEP
- SaveDPS and the Gear Upgrade
- Gear, Enchant, Gem Upgrade Search
- Equip, Talents, Buff export import
to OpenOffice?

Not in the moment, sorry. Add this would mean to make 2 Sheets. One for Excel and one for Open Office. Well, updating 1 Sheet is work enough (same reason why there isn't a sheet in another language).

Originally Posted by Dontmindme

Again, awesome job with the updates and improvements.
A couple things:
1) Exact formula for haste seems to be 20/3*82/52
2) Exact formula for dodge is 12*82/52

Hope they are right

Originally Posted by Dontmindme

And 2 questions:
1) Scratch that, 0.1% to hit/weapon skill for bosses makes the only sense with the 25.5% miss chance and 308 capping out hits.
2) Was it determined that crit actually does get 0.1% additional? I thought I saw some data that suggested that weapon skill didn't noticably increase crit at all beyond the expected 0.04 per skill?

It just makes me wonder if that blue post about 0.1% crit actually was meant to say 0.1% to hit. Hence all the confusion. Of course then there was that other blue post....

Well, if i get better information about that, I'll change this, but for now it's that what I know

Originally Posted by Darmoc

Loving the [Gem upgrade][All Upgrade] buttons.

Three things I'm wondering.

Could it be possible to give an option to enter your professions, and then detect that because your Mining and Herbing, that you can not create the BoP leatherworking items, and thus filters them out from the floating point?

Could it be added to enter what bosses you've downed, and have only the loot from those bosses displayed?

Maybe in a future Version, I'll think about it, but that would be a huge update and will cost much time.

Originally Posted by Darmoc

And last, is there anyway to extract the information from the armory and have it automatically plugged into the spreadsheet?

These are just some things i was wondering and thanks again for the hard work.

If already thought about it, but at the moment I don't know how I'll get the information via a macro form the web.

Tyrne · 07/14/07, 8:14 AM

While chain procs from sword spec might be nice when they occur, think of the probability of it occuring. I'm doubting that the change on PTR will have much effect on DPS for this reason - Not looked at sheet yet but assuming it will have little effect.

Edit: Seems it does have a large DPS loss when removing R12/R13 on other sheets

Arioche · 07/14/07, 9:20 AM

The problem with profession specific, or even raid instance specific drops is that currently that information is not contained within the gear pages. This will require a large update to the table structure of the sheets. Which will then require an update to the references that change. I can do that but it will take awhile.

I use a differant spreadsheet based on ShadowPanther site info , where I can import/merge new updates from his site. In it I track which gear I actually have, or upgrades I have access too. Id ultimatly like to merge the 2 sheets, rather than duplicate efforts. My problem with his info is hes choosen to merge Socket bonus's into his gear statistics. So his stats arent accurate if you dont gem accordingly.

Some other minor issues I know of are there no is duplicate checking within upgrade routines for Ring/Trinkets. Or unique property checking for Gems.

x1tiger1x · 07/14/07, 11:29 AM

Originally Posted by Tyrne

While chain procs from sword spec might be nice when they occur, think of the probability of it occuring. I'm doubting that the change on PTR will have much effect on DPS for this reason - Not looked at sheet yet but assuming it will have little effect.

Not proccing WF (and sometimes chain proccing WF + SS) is where it will be noticeable.

Mikhael · 07/14/07, 11:41 AM

A couple bugs in 2.2.0.1 - The "Twinblade" label in the offhands is one line up from where it should be, and the gem/enchant search needs to have the 35 changed to a 36

Ellos · 07/14/07, 2:29 PM

Originally Posted by Arioche

The problem with profession specific, or even raid instance specific drops is that currently that information is not contained within the gear pages. This will require a large update to the table structure of the sheets. Which will then require an update to the references that change. I can do that but it will take awhile.

I use a differant spreadsheet based on ShadowPanther site info , where I can import/merge new updates from his site. In it I track which gear I actually have, or upgrades I have access too. Id ultimatly like to merge the 2 sheets, rather than duplicate efforts. My problem with his info is hes choosen to merge Socket bonus's into his gear statistics. So his stats arent accurate if you dont gem accordingly.

Some other minor issues I know of are there no is duplicate checking within upgrade routines for Ring/Trinkets. Or unique property checking for Gems.

Mih and I are currently working on it, we'll find a way, and maybe we will change it, that you only can choose that equip you have selected (this is the way we want it, so that the list won't be so huge anymore)

Ellos · 07/14/07, 2:30 PM

Originally Posted by Tyrne

While chain procs from sword spec might be nice when they occur, think of the probability of it occuring. I'm doubting that the change on PTR will have much effect on DPS for this reason - Not looked at sheet yet but assuming it will have little effect.

Edit: Seems it does have a large DPS loss when removing R12/R13 on other sheets

You can't delete this. In this cell is the real chance on extra hit, because you do not have 100% Hit

Reddll · 07/14/07, 7:30 PM

sorry for being noobish but..everytime i try to calculate anything i get scripting error..and i dont quite understand what you mean by running the macros..i run them but nothing happens? -.-

^^
| |
error i get

edit: stupid hoster..it says something like

"a scripting framework error has occured while running the basic script vnd.sun.star.script:standard.nextstat?language=basic&location=document"

"message: basic.providerimpl:getscript: no script!"

Ellos · 07/14/07, 7:56 PM

But some features only works in Microsoft Excel:

- AEP Calculation
- Item compare over AEP
- SaveDPS and the Gear Upgrade
- Gear, Enchant, Gem Upgrade Search
- Equip, Talents, Buff export import

Macros will only work in Microsoft Excel

The AEP Section does not work for Open Office

Maybe I should add some blinking Arrows?

Arioche · 07/14/07, 8:24 PM

Originally Posted by Ellos

Mih and I are currently working on it, we'll find a way, and maybe we will change it, that you only can choose that equip you have selected (this is the way we want it, so that the list won't be so huge anymore)

Its not ready yet, but heres some of the items Ive added in my test copy.

I ve added alot of structure to the tables, im just adding the functions now.
I added new colums in the gear sheets, to store information. Including a column for tracking Gear you have,Profession requiremnets,Instances,Pvp/Arena

Ive added:
Profession Filters
Pvp/Arena Filters
Minimum DPS upgrade Filter
Seperate gem/enchant all upgrade buttins

going to add:
Gem Filters
Instance Filters

I have not assigned Instance or Profession Information to all the gear yet. So that will be one of my biggest headaches. Have updated the weapon lists with prof/pvp info to test with.

Also fixed 2 small bugs. One being the " the gem/enchant search needs to have the 35 changed to a 36 " and a formulae change so it detects the meta gem as a Gem.