• 0

posted a message on ItemValue
Quote from LaoTseu »

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.

( 2.9-1.8 )*10 + 4.25*( 83+156 )/2 + 15 + 1.15*15 + .5*30 + 15 = 581.1

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

posted a message on ItemValue

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

posted a message on ItemValue
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.