Preflop Practice Spreadsheet

[SukitTrebek]

Crossposted in Small Stakes

I've been reading on here for forever and decided to finally make a first post. I recently quit my job to play fulltime and probably wouldn't have done so had I not discovered 2p2.

So, in an effort to give something back, I wanted to make available a spreadsheet I made. When I first read SSH, I was having trouble memorizing all of the preflop hands and positions. I'm fairly proficient with Excel, so I sat down to build what amounted to electronic flashcards.

A couple hours later, it had evolved into this - a Preflop Practice Spreadsheet.




The spreadsheet will give you the hand, position, and whether you're facing a raise (and in LP whether other people have CC'd). It will also record the ones you miss, so you can review them later. I took out most of the obvious folds. (When I built the spreadsheet, I classified calling from the BB as "limping" rather than make another button.)

You'll need to have macros enabled to use it. To do this, go to Tools -- Options -- Security -- Macro Security. Set to Medium. You have to close and reopen Excel for the change to take effect. Then click enable macros on the prompt when you reopen it.

It is built on the tight rules in miller's book. The loose games specified may exist in a 1/2 live game, but they don't exist online (not even at 0.5/1.0).

I added a counter and would practice until I got 100 in a row, then 200, then 300. After practicing on this for a week, I was surprised at how quickly I was able to get everything down pat. I had planned to use it until I got 1,000 in a row, but I misclicked at 650 and said screw it.

So, if you're limping with QTo in MP, coldcalling with KJo, or just starting out, I think you'll find this spreadsheet will help.

I don't have anyway of hosting this. So, if anyone is able, please let me know and we'll get this available to download.


-Trebek

[SukitTrebek]

If anyone is interested, the spreadsheet is now available at:

http://www.pokerplayer.nl/upload/PreflopPractice.xls

Thanks to NoFobia for hosting it.

[adsvil]

Can you tell me what you mean by limp and cold call?

[00Snitch]

limp = entering the pot without raising
cold-call = entering the pot by calling someone elses raise (not re-raising).

you will hear "open-limp" alot too, that is, being the first one into the pot and not raising. i.e. being the first limper in a pot.

[Apron]

This is awesome...thanks for taking the time to make it, and then find a way to post it.

Do you have any way to make something like that for post-flop situations?

[SukitTrebek]

Had a friend ask about this spreadsheet and thought I'd give this thread a bump.

For anyone playing vpip >23 or pfr <7, you'll probably find this spreadsheet pretty helpful.

-Trebek

[bullys1974]

wowo thx.. this is really helpful [img]/images/graemlins/smile.gif[/img]

[makaveli001]

nice

[makaveli001]

If you are going strictly off of SSHE, then in the SB with with pocket pairs you should coldcall a raise with w/ 1 caller. Program just told me to fold 99 in this scenario.

Awesome program though!

[tennismonkey]

Great post, thanks!