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.

I've done that for 5 60%s.

Chances of 5/5 working: 7.776%
Chances of 4/5 working: 25.92%
Chances of 3/5 working: 34.56%
Chances of 2/5 working: 23.04%
Chances of 1/5 working: 7.68%
Chances of 0/5 working: 1.024%

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

1.) How do you convert something in excel into a vBullition quickly? I just add the | myself, but it kinda takes a while.

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.

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.

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.

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.

I made such tables already using scrolls of only 1 type. It's in my LOLPALLY guide under the scrolls appendix xD. Chance of booming with only 70% scrolls is actually pretty high when you pile them on a 7 slot equip o.O

I made such tables already using scrolls of only 1 type. It's in my LOLPALLY guide under the scrolls appendix xD. Chance of booming with only 70% scrolls is actually pretty high when you pile them on a 7 slot equip o.O

common sense. with a 50% destruction rate and a 30% pure-fail rate, it sucks. ive not once lost an expensive item thanks to a 30% scroll, not once, even the ones i stupidly scrolled. but, 70%'s?
lost a clean maple shield, level 30 maple hat, my then 9 slot enig with a 30% passing on the first slot, countless weapons, the list goes on.

rule of thumb ive made is use 30/60, sell 70, junk 10/100. =/

When I convert Excel sheets to VBulletin tables, I save them as tab-delimited text files.

Then you can do this in any decent text editor:
[noparse]
- global find and replace [tab] with |
- add

to the top
- add

to the bottom
[/noparse]

But I usually just run this Perl script.

 Spoiler

Code:

#!usr/bin/perl
#Converts a tab-delimited text file to a BBcode table.

use warnings;
use strict;

my @params;
my $file;

die "Usage: perl $0 [input] >[output]" unless (@ARGV);
foreach (@ARGV) #find files matching parameters
{
    chomp;
    if (/^-(\w+)/) { push(@params, $1); }
    else { $file = $_; last; }
}

print "[table";
print ("=".join(";", @params)) if (@params);
print "]";

open(FILE, $file);
while (<FILE>)
{
    chomp;
    next unless /\w/;
    s/\t/|/g;
    print $_;
}
print "[/TABLE]";

[SIZE="1"][COLOR="DeepSkyBlue"]Noah made a guide about this here
what your looking for is in appendix-b
Clicky on PB :][/COLOR][/SIZE]

When I convert Excel sheets to VBulletin tables, I save them as tab-delimited text files.

Then you can do this in any decent text editor:
[noparse]
- global find and replace [tab] with |
- add

to the top
- add

to the bottom
[/noparse]

But I usually just run this Perl script.

 Spoiler

Code:

#!usr/bin/perl
#Converts a tab-delimited text file to a BBcode table.

use warnings;
use strict;

my @params;
my $file;

die "Usage: perl $0 [input] >[output]" unless (@ARGV);
foreach (@ARGV) #find files matching parameters
{
    chomp;
    if (/^-(\w+)/) { push(@params, $1); }
    else { $file = $_; last; }
}

print "[table";
print ("=".join(";", @params)) if (@params);
print "]";

open(FILE, $file);
while (<FILE>)
{
    chomp;
    next unless /\w/;
    s/\t/|/g;
    print $_;
}
print "[/TABLE]";

Perl looks weird @_@

And yeah, the tab delimited is what I meant. I just remember once opening some sort of Excel file in a text editor and finding meaningful-looking stuff in it, when I didn't have Excel or OpenOffice on said computer.

Well, I've been beaten to it, can't save .txt documents as tab delimited documents, and suck at using Perl. I've gotten answers, but apparently can't apply them.

/endthread