Professional Excel Templates
Spreadsheet programs make it possible for you to record and summarize your data much more efficiently than you could dream of doing by hand. We'll focus on Excel, the world-leading spreadsheet program, but if you can't afford, or don't want to buy, a copy of Microsoft Excel, you can turn to OpenOffice, an open source software alternative, which includes a mostly Excel-compatible spreadsheet program named Calc. To download OpenOffice, visit openoffice.org and find the build for your operating system. Windows, Linux, and FreeBSD are well supported, but the Macintosh implementation only works with Mac OS X and has some bugs. When you play poker seriously, you must be willing to examine every aspect of your game. Just as studying the strategies and tactics of poker improves your skill at the game's mechanics, studying your habits and tendencies will point out your strengths and help you identify correctable leaks in your game. We recommend tracking your results by the hour, rather than by...
In this eight-handed game, you know the identities of 10 cards that are no longer available for you to draw the three cards in your hand and the upcards of each of your opponents. Unless you have the lowest upcard and post the bring-in, you have a very good sense of whether you should put any money into the pot. You have to keep track of dead cards in your head when you play in a brick-and-mortar casino, but you can use a software program to keep track of them when you play online. For example, you could use the Excel worksheet shown in Figure 8.9 to track which cards are out.
One key point to note about data lists is the row at the top, which contains column headings that are centered in their cells and displayed in bold type. You need to format your column headings distinctively so your spreadsheet can distinguish the column headings from the data.
Concept, it is completely irrational to think anyone can do these calculations in the heat of the battle. But it is still useful to play with the spreadsheet and the math so you can have some idea of certain situations when you are at the table. In this case, you will notice that it takes the opponent's folding rate to be only 9 of the time for a semi-bluff to be a breakeven play when you have a 18 out of 44 chance of winning and an EV of 2.07 big bets when calling. Anything higher than a 9 folding rate makes the semi-bluff a positive expectancy play. Since most players will fold more than 9 of the time in a situation like this, you can keep in mind the strategy of the semi-bluff Turn raise when you have so many outs, and the opponent may only have second pair.
Before we get started, however, there's a caveat. SHAL isn't a method that you can use at the poker table. It's a technique for posing and solving problems at home, when you're out of the action. You'll need time, some facility with using a spreadsheet like Excel, and one of the programs that lets you input a couple of starting hands and gives you the probability that each hand triumphs in a showdown. (I like PokerWiz, but there are others.) If you're willing to put in the time and effort, and you enjoy noodling over numbers for an hour or two, you'll be able to figure out things that no one else knows. If that kind of work doesn't appeal to you, no harm done. Just skip this section and move on to the problems at the end of the chapter. If the thought of exploring the dark corners of poker and discovering hidden treasures is appealing, then let's get to work. All in all, I'm comfortable with our description of the playing styles of our four imaginary opponents. But to get a better...
If the site doesn't have a feature where you can record notes, another way is to simply record notes in a spreadsheet while you are playing. Simply sort the players you are playing to the top of the spreadsheet, and then toggle back and forth between the game and the spreadsheet.
There is also a helpful function that tells you how much bankroll you need, what your earning rate is within a certain probability, and how much you could win or lose in a 10-hour or 100-hour time period. You could just use a spreadsheet to do all of this yourself, but for a small price I find StatKing invaluable.
Stud that you don't need in Hold 'em is remembering which cards have been thrown away and are no longer available to improve anyone's hand. When you play online, you can use a spreadsheet or other tool to keep track of these dead cards, so the burden isn't quite as onerous. If you plan to play seven-card Stud in a brick-and-mortar casino, where you can't use such aids, you should play online using only your memory, at least part of the time.
Official Download Link Vertex42 The Excel Nexus
Free versions of Vertex42 The Excel Nexus can not be found anywhere on the net.