Damage Formula and Critical Counting Suggestion

I've been thinking of a good damage formula that makes sense and I came up with a few things. I've made the formula and comparisons between Aoi's Formula and Shikyo's damaging Formula. To change the random number in excel just edit an empty place and it should re-randomize.

Excel Download : http://www.mediafire.com/?yh2hosus5au39gb

== Formula 1 == (Base Attack Calculations)
(Our Attack-Enemy Defense)*0.1*If(Random(1,6)<=3,8,9) as an Attack Formula

Code:

(A1-A2)*0.1*IF(RANDBETWEEN(1,6)<=3,8,9)

to be used in Excel

== Formula 2 == (Critical Calculations)
If(Random(1,6)=1,RoundUp(Formula1*(Our Agility/133),0),Formula1) as a Critical Counter

Code:

IF(RANDBETWEEN(1,6)=1,ROUNDUP(U5*(F9/133),0),U5)

to be used in Excel

That excel is also the same excel that I use to measure whether I'll win versus someone or not :3

Quote :

*If(Random(1,6)<=3,8,9) as an Attack Formula

whats this part suppose to be?

Quote :

If(Random(1,6)=1

this is dice, then the later part is

damage x (agi/133) 0) damage) ? whats the 0? and 133 and why this way?

lucchini wrote:

Quote :

*If(Random(1,6)<=3,8,9) as an Attack Formula

whats this part suppose to be?

Quote :

If(Random(1,6)=1

this is dice, then the later part is

damage x (agi/133) 0) damage) ? whats the 0? and 133 and why this way?

The first formula randomizes a number from 1 - 6 or should you say randomize a dice, and If the result is 1 - 3 then your damage is (Your Attack - Enemy Defense)*0.8, If the result is 4 - 6 then (Your Attack - Enemy Defense)*0.9

The second formula is multiplying the base damage you got from the first formula with your agility divided by 133. In other words your critical damage is based on agility divided by 133 multiplied to the original damage.

Shiro, your formula sound very interesting.
A bit confusing but i think we could go for your formula.

Shikyo wrote:

Shiro, your formula sound very interesting.
A bit confusing but i think we could go for your formula.

Thanks, We could always use excel to count things :3

lol excel will keep things in order, and for that i thank you EXCEL!

Shikyo wrote:

lol excel will keep things in order, and for that i thank you EXCEL!

We'll excel is also the key for me when it comes to challenging Players or NPCs, I always use it to calculate whether I would win or lose and for how many turns will the battle last.