---

Poker Video: Misc/Other by PygmyHero (Micro/Small Stakes)

Maleficus, can you cite any source for that? Or at least tell me where you heard it?

I'd love to incorporate something like that into the spreadsheet to boost it's accuracy, but I'm not willing to unless I'm fairly certain the information is good.

http://forumserver.twoplustwo.com/51/affiliates-rakeback/buying-ftp-store-how-effects-your-rake-196154/

For cell E12, rather than doing SUM/COUNT you should just use the average function.

Hi Derek, that was actually a clever was of saying first.

Damn, I got modowned. Apparently they didn't think so.

As to your question, I believe you are 100% correct. That actually would have been a cool stat for me to write in. Maybe I'll add it in the final video.

Oops, forgot FTP points and bonuses are deducted from rakeback. Obv that reduces the effective rakeback.

Malefiicus, thanks for that link.

So I've changed cell C6 to account for this:

=0.005-0.005*C5 (C5 being the cell where we enter our rakeback percentage)

I also changed the formatting to show four places after the decimal point.

For cell E12, rather than doing SUM/COUNT you should just use the average function.

Good point. However, I don't like using the AVERAGE function here because it will create a weighting error. So I prefer to keep that cell calculated based on the data above it.

Speaking of weighting errors, cell E17 could be improved in this regard as well.

=(C10*C17+D10*D17)/E10

And again you'd need to keep adding terms inside the parentheses as you enter more months of data.

Malefiicus (or anyone else), do you have similar information on how redeeming bonuses affects your MGR?

This is another thing I knowingly left of the sheet, but if there's good information out there on the correct deduction amount I will incorporate it in the final version.

http://forumserver.twoplustwo.com/51/affiliates-rakeback/raketherake-com-iron-man-bonus-321181/

Thanks again for the link Malefiicus. It says that the total amount of bonus is deducted from your MGR. Unfortunately that information does NOT mesh with my data.

I cleared the initial deposit bonus during October and November. Over that time HEM reported my MGR as $1,975.98. My rake tracker reported it as $1,543.92. The difference, $432.06 is almost exactly 27% of $600 (which would be $438 - this small difference could easily be caused by different methods of calculating MGR by HEM and the rake tracker). I don't really believe in coincidence, so I'm inclined to think that bonuses are deducted at 73% (1-27%).

Based on that I feel the Iron Man Medal Value in cell C7 should be changed to :

=0.2-0.2*(1-C5)*C5

If, on the other hand, you believe that 100% of the bonus is deducted from your MGR then you should enter:

=0.2-0.2*C5

Looks like you're right, I did some more scrounging and came upon this, and since your experience verifies the result you've definitely got it right there. Searching forums is like using a really shifty wikipedia.

http://forumserver.twoplustwo.com/28/internet-poker/full-tilt-bonus-any-hidden-strings-119629/

Random posters, but it does match your data so I can't see it being wrong.

Wow, impressive find. Obviously the thread itself is a bit a train wreck, but there are enough coincidences here (my data, random thread) that we very likely have the correct answer.

I don't know why FTP has such a (likely intentionally) confusing bonus and rewards structure, but I assume it's so they can advertise certain values ($600 bonus!) while actually giving you slightly less (mine was really worth $481.74).

Anyway, Malefiicus, I want to again say thanks. I really appreciate you helping me work on this stuff. This spreadsheet needed a lot of tweaking. I've had the Stars one for a year plus, over which time I've worked a lot of improvement into it, but I'm still pretty unfamiliar with FTP, having only played there for the last two months.

Thanks Melefiicus for finding those. I did some searching myself but 2+2 searches are horrible and the archived threads make things worse.

Pygmyhero, are you going to make an update with the adjustments? It'd be really nice if we were able to plug in our figures and compare effective rakeback between the two sites accurately, esp with FTP points and Iron Man medals figured in.

Pygmyhero, are you going to make an update with the adjustments? It'd be really nice if we were able to plug in our figures and compare effective rakeback between the two sites accurately, esp with FTP points and Iron Man medals figured in.

Almost certainly yes. I think there are enough changes to warrant it.

Almost certainly yes. I think there are enough changes to warrant it.

top man