Can someone check my numbers?

[rickr]

Building an excel spreadsheet to do a little what if calcs and wanted to make sure my calcs were right. Could someone glance over these and flag anything blatantly wrong?

Thanks in advance.

Rick


Entry Fee For Tournement $20.00
Rake Fee $2.00
Number of games played at a time 4
In The Money Percent 40
Number of tournements played 100
Percent of 1st 40
Percent of 2nd 30
Percent of 3rd 30
Rake Back Percent 25
Total Money Invested 2200
Hours Invested 31.25



Net Earnings (including rakeback) $600.00
Average earnings per tournement $6.00
Hourly Pay Rate $19.20
Return on Investment 127.73%

[willie]

those numbers are sick.

for the time being

-do a search for sng tracker , it's a sweet program that is beta testing. it's created by Hood from this forum. it's MUCH better than using a spreadsheet, download it and check it out.

ps- good luck keeping those numbers up- but that's one hell of a run.

[Rolen]

Heh, something tells me they were test numbers rather than imported

But if they were imported, he's wasting valuable poker playing time making spreadsheets /images/graemlins/grin.gif

..They look correct to me btw

[dfscott]

[ QUOTE ]
-do a search for sng tracker , it's a sweet program that is beta testing. it's created by Hood from this forum. it's MUCH better than using a spreadsheet, download it and check it out.

[/ QUOTE ]

Is it really that much better than AM's SnG spreadsheet with all the bells and whistles added? I looked at the screen shots, and I didn't see anything particularly revolutionary, but maybe I should give it a look.

[Slim Pickens]

Um, 600/2200 is not a 127% ROI. Your ROI is the same no matter how many tables you play. Your hourly rate is not.

Slim

[rickr]

$600 was the net profit after subtracting buy-in/rake. Total won would be 2800/2200 * 100, right? And yes these are test numbers. This is not for keeping track of my stats. I do that with PT. This is simply a what if type thing. You, know, if I have this ITM what will I make type thing.

Thanks,
Rick

[Slim Pickens]

ROI is typically given as net return on investment, so an ROI of 0% would be paying $2200 in buy-ins and having $2200 in gross winnings.

[rickr]

So should the calculation then be 600/2200 * 100 = 27%?

Thanks,
Rick

[Slim Pickens]

That's the correct calculation. You didn't really think we all thought a 40% gross ROI was fantastic, did you? /images/graemlins/tongue.gif