zachvac
Legend
Silver Level
I'm looking to compile a list of average FPP/hand at each limit for NLHE full ring.
If you have a PT database with a sizeable amount of full ring games and don't mind doing a bit of work for the good of the CC community knowing how often to expect FPPs, read on.
If people want to request lower we can, but I'll do mine for nl10 and I'm looking for nl25, nl50, nl100, and nl200. If people have/want higher that will work. I have a little over 31k hands at nl10, so I'll do it for nl10, any additional hands to add in are welcome, but the higher limits are what are needed.
So here's the process if you're willing.
1. Find your PT database on your system. On a windows machine it's probably in program files/PT/ and is titled ptrack
2. Open it in Microsoft Access
2.5. Open the game_level table and note the game_level_id for the level you are analyzing
3. Select the table "Game", and go to the "external data" tab and export to microsoft excel. It will ask for a location, remember the location you export it to
4. Open the excel document, sort by "game_level_id"
5. Delete all the cells that are not the level you are currently analyzing, you found the game_level_id in step 2.5
6. Put this query somewhere at the bottom of the big block:
=COUNTIF(rake range,">=.4") + COUNTIF(rake range,">=3") + COUNTIF(rake range,">=5")
as well as this: COUNT(rake range)
The logic here is that if the rake is >= .4 it adds one, if it's >=3 it adds another one, so the cells with rake >=3 are counted twice, >=5 are counted three times. Obviously replace rake range with the range for your rake, for me it's L1:L31372
7. Post what limits you're using, and the results of each query. Here's mine:
nl10:
total FPPs: 1394
total hands: 31371
FPPs/hand: 0.0444 = 22.5 hands/FPP
Let me know if this is too confusing or you have any questions whatsoever.
If you have a PT database with a sizeable amount of full ring games and don't mind doing a bit of work for the good of the CC community knowing how often to expect FPPs, read on.
If people want to request lower we can, but I'll do mine for nl10 and I'm looking for nl25, nl50, nl100, and nl200. If people have/want higher that will work. I have a little over 31k hands at nl10, so I'll do it for nl10, any additional hands to add in are welcome, but the higher limits are what are needed.
So here's the process if you're willing.
1. Find your PT database on your system. On a windows machine it's probably in program files/PT/ and is titled ptrack
2. Open it in Microsoft Access
2.5. Open the game_level table and note the game_level_id for the level you are analyzing
3. Select the table "Game", and go to the "external data" tab and export to microsoft excel. It will ask for a location, remember the location you export it to
4. Open the excel document, sort by "game_level_id"
5. Delete all the cells that are not the level you are currently analyzing, you found the game_level_id in step 2.5
6. Put this query somewhere at the bottom of the big block:
=COUNTIF(rake range,">=.4") + COUNTIF(rake range,">=3") + COUNTIF(rake range,">=5")
as well as this: COUNT(rake range)
The logic here is that if the rake is >= .4 it adds one, if it's >=3 it adds another one, so the cells with rake >=3 are counted twice, >=5 are counted three times. Obviously replace rake range with the range for your rake, for me it's L1:L31372
7. Post what limits you're using, and the results of each query. Here's mine:
nl10:
total FPPs: 1394
total hands: 31371
FPPs/hand: 0.0444 = 22.5 hands/FPP
Let me know if this is too confusing or you have any questions whatsoever.