Elitist Jerks - View Single Post

tunah · 06/21/07, 2:25 AM

So I'm not all talk, here's my current (possibly broken) version

HTML (read only)
XLS
ODF

The current version gives 1 hit rating as 1.40AP for my gear, a substantial improvement (and i think, more accurate, thanks guys!). It's still the worst DPS stat though (I don't have haste modeled).

Roughly speaking, you type in the yellow fields.
Sheets depend on sheets on their left generally (exceptions: damage section of attack depends on cycle, pawn section of stat value depends on gems).
Calculating value for each step is hacky atm since TABLE() isn't supported - you enter a 1 in the STR column, it increases your STR by 10, you type the DPS into the box. To get AEP values you have to do this for base (no modifiers), AP, and the stats of interest.

Now I find what I lied about modelling.

06/21/07, 2:25 AM	#28
tunah Von Kaiser Asplode Gnome Mage <Nocturnis> Eldre'Thalas	So I'm not all talk, here's my current (possibly broken) version HTML (read only) XLS ODF The current version gives 1 hit rating as 1.40AP for my gear, a substantial improvement (and i think, more accurate, thanks guys!). It's still the worst DPS stat though (I don't have haste modeled). Roughly speaking, you type in the yellow fields. Sheets depend on sheets on their left generally (exceptions: damage section of attack depends on cycle, pawn section of stat value depends on gems). Calculating value for each step is hacky atm since TABLE() isn't supported - you enter a 1 in the STR column, it increases your STR by 10, you type the DPS into the box. To get AEP values you have to do this for base (no modifiers), AP, and the stats of interest. Now I find what I lied about modelling. Last edited by tunah : 06/21/07 at 2:32 AM.