When I try to do that I get an "Invalid Value" error, I'm using OpenOffice.

EDIT: Never mind, I got it to work.

It would be because I was not aware of that thread. Cheers, and the value will be changed next version.

I'm probably being dense, but I lose dps swapping from 32 attack power to 16 agility gems on the spreadsheet.

Open Office user.

Version 0.4.1.

edit: apologies for idiotic post thought I understood how they scaled but clearly didn't.

It's possible AP just scales better for you than agility does, in which case it actually would be a dps loss.

Simply make A72 read:

@Vulajin
any idea on the topic of 2pc-T6-bonus calculation that Antiarc mentioned in the Simple Questions Thread?
Rogue: Simple Questions/Simple Answers

Is there anyway to convert or toggle the Hit % (along with other %'s) to number values?

Not on the spreadsheet: Mark of Norgannon and Darkmoon Card: Greatness

I would greatly appreciate if these were modeled!

I've debated mentioning this because it's not really a big deal.

The default setting for talent spec for mutilate has one point in Vigour and two out of three in Ruthlessness. Given that this is not the ideal dps spec, you might want to change it. But like I said, it's not really a big deal.

That's the spec that vulajin uses. I believe the default gear is what he uses as well. It makes sense for it to mimic the person who maintains the spreadsheet, since it is less work for them that way.

The link to my new version of Vul's Spreadsheet is given below

Rogue_DPS_Cherubael_0.4.1.xls - FileFront.com

All credit goes to him for its creation. Mine differs only in these ways:

- You can Save/Load/Delete Gear Sets.
- I added a totals bar at the top of the gear page so you can see how much of each stat you have.
- I fixed an error on the gear page (A72) which does not correctly account for the belt enchant.
- Boss armor values are now correctly set to 13083

I am planning on updating mine as his updates and if people are interested I will continue to link through the latest version.

No one is adding trinkets that don't exist yet. Just because it had a certain internal cooldown on PTR or Beta doesn't mean it will be the same as live. It will probably be added shortly after the 8th.

More accurately, I haven't added [Darkmoon Card: Greatness] because I'm lazy. The default spec and gear are, in fact, my spec and gear, so yes, you are subject to any quirks in the way I spec. I had not even heard of [Mark of Norgannon], but that'll also go in next version along with [Bandit's Insignia]. As far as hit %'s go, I can only imagine that you need the number to judge your poison cap status, because otherwise the percentage tells you everything you need to know. I'll try to squeeze some poison hit cap info in there somehow.

I have question about EP evaluation - I want to use the spreadsheet to make Pawn scale (to roughly appraise item values).
So I assumed that it shall work ok when I save my current DPS in spreadsheet and then alter every each stat in one of gems in gear sheet and see the difference. I was adding 20 to the stat (to step over minor thresholds like in expertise and Agi/Str, and because gems come in +20 stat values), then I divided the difference by the ~7,09DPS (difference made by adding +20 AP). Only for expertise I pushed -20 instead of +20, because I’m almost at cap.

Basically I went to Gear!B18 till Gear!K18 cells, entered “20” in first cell, wrote down the difference, undid the change and moved to next cell. I know that this is not too accurate, but shall estimate EP scale pretty good, doesn’t it?
The problem is, that I got completely different values than in “Pocket Guide” article. I was evaluating combat fist/sword 7/51/13 with [Greed]/[Omen of Ruin] with my last Naxx-10 raid buffs, 1s5r rotation with glyphs of Rupture and of Slice. (Yes I know that Omen is a dagger and build is sword, but in fact there is no good +dps equivalents for evaluation). My gear is mostly T6-like slowly exchanged for quests/heroic rares and total DPS is 2169 with given buffs.

So my values were about:
1 Str = 1.1 AP, 1 Agi = 1.79 AP, 1 Hit = 1.27 (I’m between yellow and poison caps), 1 Crit = 1.18, 1 Exp = 1.06, 1 Haste = 1.01 AP, 1 ArP = 0.90 AP
I also evaluated some changes on weapons, maintaining constant either speed or dps:
1 MH DPS = 7.57 AP, 1 OH DPS = 2.91 AP, 2.7 MH speed on Greed (+0.1) = 16.1 AP, 1.6 OH speed on Omen (+0.1) = -55,0 AP. – But speed changes are too delicate matter as it may change rotation for keeping Slice on.

Those values varied depending on available (de)buffs, but still are quite different from “Pocket Guide” article. What bothers me, is AP value – assuming that it is always 2x other stats on gems or food, it clearly is best stat.

I don’t want to depreciate calculations in first article and I humbly assume that I’m doing something wrong if my values differ so much, but I’d really like to know what. First I guessed that I’m really too undergeared and that made the difference between my calculations and EJ’s. But then – I believe I’m quite average rogue at the moment, when not every guild got enough 80s to start 25ppl raids. May I ask you, what do you think of my idea of EP weight calculation? I'm not asking about hand-holding, only if it is correct way to calculate EPs.

I was just about to post on this. I've been adding in increments of 1 (or 2 for ap and simplicity) and am getting similar results. Most notably: 1 agi = .79 dps, 2 ap = .85 dps.

EDIT: I fail.

That's because the EP values are for starter gear, and very rough numbers, as Aldriana himself said. The spreadsheet is a much more accurate tool.

1 agi only gives you 1 ap.

Edit: Plus crit obviously.

You get 1 ap, not 2, plus whatever raid buff you're getting (Kings)

Question; how is sword spec modeled? Does it take into account the change they made to it? From my experience oh sword procs procs oh attacks. I'm fairly certain I've read the same thing somewhere around here as well.

Asking because I found myself getting a ~70 dps upgrade by having 5/5 CQC and 4/5 SS using [Monster - Hailstorm] in OH compared to using [The Hand of Nerub].

I see, thanks for clarifying that (yet again). D:

For the 8000th time in this very thread. Offhand attacks with a sword proc mainhand swings. Nobody has yet presented evidence to the contrary from any source that isn't Recount. Recount reports data from 'extra attack' procs incorrectly due to the ordering of events in the written combat log. It will frequently consider damage sources such as Sinister Strike, Rupture Ticks, Eviscerate, or Retribution Aura to be 'sword spec' damage. This is, quite obviously, not possible. If you have combat logs to the contrary, that's another matter, but otherwise, the current understanding, is, once again Landed attacks with a sword offhand with Sword Specialization will result in additional MAIN HAND swings, regardless of the weapon type in the main hand.

I am no good at this, how does one add this to the spreadsheet??

But remember (took me a while) that Kings give you 1AP every 10 Agi, not 0.1AP every 1Agi.