ExitOnly's Spreadsheet help

jonnyd · #1 06-14-2006, 02:35 AM

im no good with Excel
can someone write up the code to convert Bodog TLB points in the spreadsheet?

btw exit, props.. that thing is a beauty.. and its pretty good luck too.. since ive started using it ive had my biggest cash ever (1750)..

also here's the bodog formula for TLB for anyone who isnt on or familiar with bodogs points but is proficient in excel

Points = 10 * (SQRT(N)/SQRT(R)) * (SQRT(SQRT(B))+0.2)

N = Number of players entered in the tournament.
R = Finish Rank of the player for the tournament.
B = Buy-in of the tournament. For tournaments that have a Point (PTS) buy-in, 1 Point is counted as $0.03.

MUCH APPRECIATED!

LLKOOLK1 · #2 06-14-2006, 02:50 AM

Linky to exits spreadsheet if anyone gets a minute?
-LL

jonnyd · #3 06-14-2006, 02:54 AM

http://www.our2centz.com/poker/MTT_S...heet_BLANK.xls

jonnyd · #4 06-14-2006, 07:25 PM

up up up up

tubasteve · #5 06-14-2006, 08:06 PM

Dude...you have the forumla in your OP. All you have to do is replace the variables with cells from the spreadsheet. I made it for you but it's something you could have easily done yourself.

http://www.wam.umd.edu/~swsnow/bodog...calculator.xls

jonnyd · #6 06-14-2006, 10:06 PM

hey man thanks.

i just suck at excel/am lazy