The Aran Calculator V3.5

Well if you want to make it easy for yourself, make 3 new rows:
- Average non critical damage (easy: row3 + row4 /2)
- Average (only) extra added critical damage (based on the rate of criticals happening because of the non-fixed critical chance rate > see previous post)
- Combined normal + critical average damage

If you want you could hide these first two rows, but that would make things more complicated while you're working on it.

I can't help you with the average critical formula since you locked everything... xD

Well, that seems like 2 new rows:
-Average non-critical, yes, it would be =(Min+Max)/2
-Then this one would be (Min+Max)/2*(Critical_value-1)*Critical_chance.
-Third is already displayed in Exp damage per shot.

Seems do-able, not too complicated, and I can complete it in a day or two.

And, yes, that is why I lock everything =P