Originally Posted by tunah

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.