Scrolling probability chart and excell questions

Has anyone made one of these? Like a bunch of charts that show you the probability of getting +y to your equip from x 60% scrolls. Something like this:

 30% scrolls

scroll #	BOOM	+0	+1	+2	+3	+4	+5	+6	+7
1	0.35	0.35	0.3
2	0.5775	0.1225	0.21	0.09
3	0.725375	0.042875	0.11025	0.0945	0.027
4	0.82149375	0.01500625	0.05145	0.06615	0.0378	0.0081
5	0.883970938	0.005252188	0.022509375	0.0385875	0.033075	0.014175	0.00243
6	0.924581109	0.001838266	0.009453938	0.020258438	0.0231525	0.01488375	0.005103	0.000729
7	0.950977721	0.000643393	0.003860358	0.009926634	0.014180906	0.012155063	0.006251175	0.00178605	0.0002187

If nobody has made one of these, I'd like to. And by the way:
1.) How do you convert something in excel into a vBullition quickly? I just add the | myself, but it kinda takes a while.
2.) Is there any way in excel to make something a function of other cells by placement from the current cell? As in, could I make a cell be "=((1UP,1LEFT)*.3)+((1UP)*.35)? That way, I could copy/paste this all down the chart and make it a bunch faster.