2011-01-25, 09:40 PM
That reminds me... could you confirm that you get 6%/orb with level 1-5 Advanced Combo? Data indicates that as a possibility but the skill description says 5%. So it should be 130% with 5 orbs instead of the 125% with just normal Combo.
I tackled the 10-orb charging problem like this:
Really it should stop after hitting 10 orbs, I did it this way so I could confirm each column adding to probability 1. Row 27 shows how unlikely it is to have less than 10 orbs after the 6th attack (1.3%).
On the right is the damage dealt with each orb - column M is the average damage of the attack starting from each number of orbs. N to S just evaluate the probabilities of charging each number of orbs.
for example,
F25 = E21*$N$21+E22*$N$20+E23*$N$19+E24*$N$18
E21~E24 are the number of orbs on the previous attack, $N$18~$N$21 are the probabilities of charging 4 3 2 1 orbs in the current attack.
M19 = 6.3*(1+MIN(10,A19)*A$29)+1.5*0.4*(0.2*(1+MIN(10,A19+1)*A$29)+0.8*(1+MIN(10,A19+2)*A$29))
This is just ridiculous. Anyway it basically makes sure no more than 10 orbs are ever counted, and takes into account the probabilities of FA going off with +1 or +2 orbs from the IS.
Oh, and as labeled, A29 is the % gained per orb.
I tackled the 10-orb charging problem like this:
Spoiler
On the left is the table of number orbs (down) vs. number attacks (across) - this is strictly counting the number of Intrepid Slash, so it can charge 1-4 orbs depending if FA triggers or not. Plus, attack "0" is the FA from the previous finisher.![[Image: tenorbcalc.png]](http://img98.imageshack.us/img98/3019/tenorbcalc.png)
Really it should stop after hitting 10 orbs, I did it this way so I could confirm each column adding to probability 1. Row 27 shows how unlikely it is to have less than 10 orbs after the 6th attack (1.3%).
On the right is the damage dealt with each orb - column M is the average damage of the attack starting from each number of orbs. N to S just evaluate the probabilities of charging each number of orbs.
for example,
F25 = E21*$N$21+E22*$N$20+E23*$N$19+E24*$N$18
E21~E24 are the number of orbs on the previous attack, $N$18~$N$21 are the probabilities of charging 4 3 2 1 orbs in the current attack.
M19 = 6.3*(1+MIN(10,A19)*A$29)+1.5*0.4*(0.2*(1+MIN(10,A19+1)*A$29)+0.8*(1+MIN(10,A19+2)*A$29))
This is just ridiculous. Anyway it basically makes sure no more than 10 orbs are ever counted, and takes into account the probabilities of FA going off with +1 or +2 orbs from the IS.
Oh, and as labeled, A29 is the % gained per orb.