Creating a Simple Results Tracking Spreadsheet

of 16

Creating a Simple Results Tracking Spreadsheet

To improve at poker, you must keep good records. How will you know if you are a winning player or not? How will you know if you are improving? All you need is some software that handles spreadsheets and a little basic knowledge of how to use it. This article will walk you through the basics of setting up a spreadsheet so that you can easily track your hours and win rate for all your poker play.

of 16

Step 1 - Open Excel or similar

You'll need Microsoft Excel or a similar program. There are many alternatives, including Open Office and Google Drive, both of which are free. I am using Excel on a Mac for this demonstration, but most of the commands will translate across all programs and operating systems.

Open your spreadsheet application and create a new workbook by selecting New Workbook from the File Menu.

of 16

Step 2 - Select header

Select the top row by clicking on the 1 in the left-hand row numbers

of 16

Step 3 - Format Header

Open the "Format Cells" menu. I've done this by right-clicking on one of the highlighted cells and choosing "Format Cells." It can also be achieved by clicking "Format" on the menu bar and selecting the "Cells" option.

of 16

Step 3b - Underline Header

Click on "Border" in the top row to get to the cell bordering options. Click the dark line in the right box, then the underline in the left box to underline the entire top row.

of 16

Step 3c - Header

The spreadsheet should look something like the picture above. Now we're going to add some text.

of 16

Step 4 - Titling

Double-click cell A1 and enter the text "Total Profit/Loss" as shown above. You may need more space to fit the words in. The right margin of column A can be pulled to the right by clicking and dragging between the A and the B in the top line.

of 16

Step 4b - More Titling

Add "Total Hours" to A3 and "Hourly Rate" to A5. Use the Format menu to underline their boxes.

of 16

Step 4c - Top Row Titles

In cells B1 through E1, enter "Date", "Game", "Hours", "Profit/Loss"

Now that we've got the text in, we've got one more piece of formatting to do before we add the formulas to make the spreadsheet work.

of 16

Step 5 - Format Numbers

Click on the E in the top row. This selects the entire row. Select the Format Menu.

of 16

Step 5b - Format to Currency

Select "Numbers" from the top row, then "Currency" from the category box. Now every entry in column E, our Profit/Loss column, will show as currency.

Single-click A2, the cell under "Total Profit/Loss" and format it as currency as well. Do the same for A6, the hourly rate cell.

of 16

Step 6 - The Formulas

Finally! The formulas.

Double click A2. Enter =sum(E:E) then hit return.

The equal sign alerts the program that we're entering a formula that it will need to compute. "Sum" tells the program to add together the contents of all the cells listed between the ensuing parentheses. "E:E" refers to the entire E column.

The total will show as zero as we don't have any sessions entered.

of 16

Step 6b - The Formulas

Do the same for A4, the Total Hours cell, except this time it is "D:D" between the parentheses.

of 16

Step 6c - The Formulas

The last step is to divide your profit or loss by your total hours to get an hourly rate. Once again we put in an equal sign to indicate a formula, then enter the very simple A2/A4 and hit return.

Since this formula is calculating two other formulas that have no data yet, it will show an odd message. Not to worry, as soon as we get some data entered, the message will be replaced by a result.

of 16

Step 7 - Data Entry

All that's left now is to enter some data. I've entered a date of 3/17/13, Limit Holdem for the game, set a session time of five hours and decided I won a hundred bucks. If you do the same, the totals in column A should fill in to reflect the data.

of 16

Step 8 - Conclusion

Enter more data and the totals in column A change. You now have a simple results tracker, and the tools to add to it if you need to.