Scrolling probability chart and excell questions

For 60%s, nCr*0.6^r*0.4^(n - r) for chances of r scrolls working out of n? O_o

I know how do do pass/fail probability like that, but don't know any awesome formulas for something like this: you can pass, fail, or explode. So I just make a chart based on the other cells in the chart.

 Spoiler

BOOM	+0	+1	+2
0.35	0.35	0.3
pass/fail formula above	(above)*(failure)	([above,left]*[success])+([above]*[failure])	(above,left)*(success)

...and so on. The ones on the side (+0 and +max) are technically the same formula as the middle, but there's no +-1 for the +0 column and no +(max+1) for the +max column.

B>probability skills.

I'm not positive that it works, but try opening the .xls in Notepad. Then you should be able to turn it into something resembling VBulletin table format using find+replace.


You could just use autofill. It does the offsets for you.

E.g. if your cell in B1 has a formula "=A1*2", and you autofill that to B2, B2 would now contain "=B1*2". I think that should suit your purposes.

The text document thing gives me a bunch of jibberish. Can't get it to work on .xlsx, .xlr, or .xls.

I'll try the offset thing tomorrow. It's pretty late.