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

EmuAlert Wrote: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.

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

Russt Wrote: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.

KajitiSouls Wrote: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

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

Dusk Wrote: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]";