Your formula (the critical % average formula) doesn't appear to be working, pchan.
What I did:
First, expanded it out so I could be sure I'm getting all the parentheses in there:
Code:
crit%=
(c+
(lambda1+1)*
(-c+a*c-a)/
(-1+a)+
1/
(-1+a)*
(-
(-c+a*c-lambda1-1+
(lambda1+1)*
a-a)*
a^(lambda1+1)/
(-1+a)+
a^(lambda1+1)*
(lambda1+1+c)
)-
1/
(-1+a)*
(-
(-c+a*c-1)*
a/
(-1+a)+
a*
(1+c)
)-
(-c+a*c-lambda1-1+
(lambda1+1)*
a-a)*
a^(lambda1+1)/
(-1+a)+
a^(lambda1+1)*
cap1+
(N-2-lambda1)*
(-
(-c+a*c-lambda1-1+
(lambda1+1)*
a-a)*
a^(lambda1+1)/
(-1+a)+
(-c+a*c-a)/
(-1+a)+
a^(lambda1+1)*
cap1)
)/N
Then, using a small chunk of the spreadsheet, entered/calculated values:
Code:
AG AH AI AJ
base max hits to cap
6 acc 95% 95% 0
7 crit 12% 62% 50
8 crit dmg 0% 50% 50
9 att 50
10 hits 144
Then did a search/replace on the formula you provided, substituting in the appropriate Excel cells:
Code:
=
(ah7+
(ai7+1)*
(-ah7+ah6*ah7-ah6)/
(-1+ah6)+
1/
(-1+ah6)*
(-
(-ah7+ah6*ah7-ai7-1+
(ai7+1)*
ah6-ah6)*
ah6^(ai7+1)/
(-1+ah6)+
ah6^(ai7+1)*
(ai7+1+ah7)
)-
1/
(-1+ah6)*
(-
(-ah7+ah6*ah7-1)*
ah6/
(-1+ah6)+
ah6*
(1+ah7)
)-
(-ah7+ah6*ah7-ai7-1+
(ai7+1)*
ah6-ah6)*
ah6^(ai7+1)/
(-1+ah6)+
ah6^(ai7+1)*
aj7+
(ai10-2-ai7)*
(-
(-ah7+ah6*ah7-ai7-1+
(ai7+1)*
ah6-ah6)*
ah6^(ai7+1)/
(-1+ah6)+
(-ah7+ah6*ah7-ah6)/
(-1+ah6)+
ah6^(ai7+1)*
aj7)
)/ai10
Then collapsed it all together again to copy into Excel:
Code:
=(ah7+(ai7+1)*(-ah7+ah6*ah7-ah6)/(-1+ah6)+1/(-1+ah6)*(-(-ah7+ah6*ah7-ai7-1+(ai7+1)*ah6-ah6)*ah6^(ai7+1)/(-1+ah6)+ah6^(ai7+1)*(ai7+1+ah7))-1/(-1+ah6)*(-(-ah7+ah6*ah7-1)*ah6/(-1+ah6)+ah6*(1+ah7))-(-ah7+ah6*ah7-ai7-1+(ai7+1)*ah6-ah6)*ah6^(ai7+1)/(-1+ah6)+ah6^(ai7+1)*aj7+(ai10-2-ai7)*(-(-ah7+ah6*ah7-ai7-1+(ai7+1)*ah6-ah6)*ah6^(ai7+1)/(-1+ah6)+(-ah7+ah6*ah7-ah6)/(-1+ah6)+ah6^(ai7+1)*aj7))/ai10
With the above values, the result was 45.53356941.