Videos Poker Forums

First,
good vid

Excellent PygmyHero.

I learned a fair bit about using spreadsheets more efficiently. Also I agree with your bonus interpretation as in "only counts for free deposit bonuses and not the ones you have to buy with FPPs".

If people want to expand on it they can add a simple calculator in some spare space to calculate the fpp value of a purchase, by entering the $ value of a purchase and how many fpps it costs. If they want to go further they can add a $ exchange rate, which might be nice for those in non $ countries. For example enter a book price from amazon.co.uk in GBP, enter the exchange rate, enter the amount of FPPs it costs and voila it gives you the value of your FPPs.

By the way, at the moment the exchange rate has stolen our exchange rate bonus. The effect of the exchange rate is dramatic on the value of an FPP when exchanged for a gift token. At the time of writing a £50 amazon.co.uk gift token is only worth $0.014 USD (and thats rounded up!). Also, for euro folk, some books are amazingly more expensive at least here in the UK compared to USA. As a result the FPP value for a book like harrington on cash direct from the vip shop is the actual $0.016 rate at the time of writing.

This brings about a strange effect for us lot living in non USD countries. If you get a lot of USD to your GBP for instance, then FPPs become more attractive as the dollars are not worth as much as converting into GBP via a gift token. Where as when you get a sharp fall in the amount of USD you get for a GBP then your probably better off trying to get rakeback in $'s as you get more GBP for a dollar.

nice vid, but what I am missing is a value to limit the amount of $ you earn from a bonus.
atm the rakeback- and $/h-values with bonus are way too high

Just a little tip: you can double click on a cell that contains text to edit the text in-place instead of selecting the cell and edit on top of the excel window .

Hey guys, thanks for all the feedback. I will try to answer all questions in the thread but am at work for most of the day. So some of them may have to wait until I get home depending on how much time I can devote to this thread right now and if anything gets complex enough that I need to see my spreadsheet.

kondor, that's a great point. Stuff that is subject to change is very handy to build into the spreadsheet, and the exchange rate is a great example of that.

As is I just hard coded the $0.016 value into the cell. But it'd obviously be fine to just enter the dollar value of an item divided by the FPP cost. So the cell would read something like "=29.95/2000" (for a book).

But I really like your idea of incorporating the exchange rate on a separate line and then just pointing to it. So the FPP value cell would be something like "=50*cell where you entered exchange rate/5500" (using the GBP Amazon gift certificate as an example.

This brings about a strange effect for us lot living in non USD countries. If you get a lot of USD to your GBP for instance, then FPPs become more attractive as the dollars are not worth as much as converting into GBP via a gift token. Where as when you get a sharp fall in the amount of USD you get for a GBP then your probably better off trying to get rakeback in $'s as you get more GBP for a dollar.

I haven't done any math but I suspect this is not correct. That's because the cumulative benefits of playing a larger volume at any one site is likely to outweigh fluctuations in the exchange rate.

really nice video. One thing i was wondering about, im a 1-2 and 2-4nl 6 max player. Could you add inn or tell me how many hours a day or hands you have to play to get to the different levels?

dydde, I cannot do that as I don't have data on 1/2 and 2/4 NL. I have no idea what percentage of hands are raked at various FPP increments for those games.

However I will address how to project what VIP level you will hit in the third video and I think if you follow the methodology I lay out there you'll be able to do the same thing with your data (even though I'll show it for LHE).

In the meanwhile, you can solve the problem yourself if you want to. Just enter the raked hands information as I did (but with your data from the game you want). Then the equation you'll use to solve will be:

=VIP level / (hands earning 1 FPP + hands earning 2 FPP *2)

Where VIP level is the required number of VPP's to earn that level,
hands earning 1 FPP is the percentage of hands earning 1 FPP (but NOT more),
and hands earning 2 FPP is the percentage of hands earning 2 FPP's

Make sure you have the parentheses in there.

The output will be the number of hands you need to play to reach that VIP level. To convert that to hours just divide the answer by the hands per hour that the spreadsheet calculates.