Hobbies Card Games & Gambling Creating a Simple Results Tracking Spreadsheet Share PINTEREST Email Print Card Games & Gambling Poker Gambling Strategies & Tips Casinos Sports Gambling Blackjack By Adam Stemple Adam Stemple has been playing poker professionally for 10 years. He has written books and created websites about the game, and coaches other players. our editorial process Adam Stemple Updated May 19, 2018 01 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. 02 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. 03 of 16 Step 2 - Select header Select the top row by clicking on the 1 in the left-hand row numbers 04 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. 05 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. 06 of 16 Step 3c - Header The spreadsheet should look something like the picture above. Now we're going to add some text. 07 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. 08 of 16 Step 4b - More Titling Add "Total Hours" to A3 and "Hourly Rate" to A5. Use the Format menu to underline their boxes. 09 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. 10 of 16 Step 5 - Format Numbers Click on the E in the top row. This selects the entire row. Select the Format Menu. 11 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. 12 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. 13 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. 14 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. 15 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. 16 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.