You are looking at the wrong list. Shadow Panther rate the Claw of the Netherwing Flight at 250 just like the result in the Off Hand list. It is rated 581 in the Main Hand list wich is the other formula.

Lao, with your formula: "(2.9-WEAPON_SPEED)*50+(WEAPON_MIN+WEAPON_MAX)/WEAPON_SPEED+AGI+.05*STA+.5*STR+1.15*CR_HIT+.85*CR_CRIT+.5*ATTACKPOWER+CR_HASTE+CR_WEAPON_DAGGER+.015*CR_DEFENSE+.01*CR_RESILIENCE+.01*CR_DODGE+.01*CR_RESILIENCE+.01*CR_PARRY+.01*ARMOR"

Applied to the Claw of the Netherwing Flight, ItemValues returns 250. The item is rated at a value of 581 on the spreadsheet.

Variables without values were removed to simplify the equation. Crunching this yields approximately 250.02

Even assuming the proper order of operations to yield the highest number, this is off by quite a lot. Any suggestions, or am I doing something wrong here?

I appreciate that, but I'm looking to reproduce perfectly the results on his spreadsheets, so I can have the game compute the results for me without having to check the charts all the time. I'm geting pretty close, the Chestguard of the Dark Stalker computes as 100.2 instead of the chart's 103, so I'll keep working on it.

Okay, something in this isn't reading right then. I'm certain I have the values correct, and when I crunch the numbers with a calculator, I get SP's 103.5.

But, when I use ItemValues, I get a 100.2 returned. I wrote the formula as follows:

(ARMOR*.01)+(STA)+(CR_CRIT*.085)+(ATTACKPOWER*.5) and get 100.2

If I substitute the numbers in making the equation read: (285*.01)+(31)+(32*.85)+(84*.5) I then get 103.5 returned by ItemValues, so it is doing the math correctly, something is getting screwed up along the way.

I've been going nuts trying to get the AEP DAEP, and MAEP formulas from ShadowPanther converted into ItemValues. I wanted something that could compute the numbers and output them exactly as an established source, so I could compare gear on the fly without having to reference the chart.

However, several values in the charts at SP do not have multipliers, or are multipliers that are hard to arrive at, such as the Defense Rating being rated as (1 Agi = 66.67 DefR).

If someone could suggest an alternate series of values for Rogues, I'd be incredibly happy.

Also, as was suggested earlier, adding values for sockets as representative of potential would be desireable, even if it was just a flat value.

0

Thanks. I'm an idiot. I failed to use copy correctly with the Main Hand formula selected, and was thus using the same formula twice.

0

Applied to the Claw of the Netherwing Flight, ItemValues returns 250. The item is rated at a value of 581 on the spreadsheet.

The calculation with variables filled in is:

"((2.9-1.8)*50)+((83+156)/1.8)+15+(1.15*15)+(.5*30)+15"

Variables without values were removed to simplify the equation. Crunching this yields approximately 250.02

Even assuming the proper order of operations to yield the highest number, this is off by quite a lot. Any suggestions, or am I doing something wrong here?

0

Okay, something in this isn't reading right then. I'm certain I have the values correct, and when I crunch the numbers with a calculator, I get SP's 103.5.

But, when I use ItemValues, I get a 100.2 returned. I wrote the formula as follows:

(ARMOR*.01)+(STA)+(CR_CRIT*.085)+(ATTACKPOWER*.5) and get 100.2

If I substitute the numbers in making the equation read: (285*.01)+(31)+(32*.85)+(84*.5) I then get 103.5 returned by ItemValues, so it is doing the math correctly, something is getting screwed up along the way.

0

However, several values in the charts at SP do not have multipliers, or are multipliers that are hard to arrive at, such as the Defense Rating being rated as (1 Agi = 66.67 DefR).

If someone could suggest an alternate series of values for Rogues, I'd be incredibly happy.

Also, as was suggested earlier, adding values for sockets as representative of potential would be desireable, even if it was just a flat value.