Slim Pickens
06-10-2005, 04:36 PM
I promised myself I would quit working on this thing after the last version. Lying in the shards of that promise is this, the newest spreadsheet. I added some bankroll tracking stuff, places to include bonuses and rakeback (check out the new Extras tab), and the Poker Tracker autoimport macro is working like a charm.
version 2.4 (http://mowrmowr.com/poker/SUPER_SNG_w_UI_PT_v2.4a.zip)
If that link is broken, find it in the
root poker directory (http://mowrmowr.com/poker/)
I'm trying to write a small FAQ/user guide. Here's some text for new users.
Getting Started
I’m going to assume a basic familiarity with Excel. If you’ve never used Excel, go through a few of the tutorials in the Help menu first. About all you need to know how to do is click on cells and type stuff in them. The grey cells are where users enter data. The white cells do calculations and display results. Please do not change any white cells. The sheet is organized by tabs, those little colored deals along the bottom of the screen. Tabs may be renamed by double-clicking on the name. There are three kinds of tabs.
1) SNG tabs: This is where to enter tournament results.
2) STATS tabs: This is where the statistics from those results entered on the corresponding SNG tab are calculated and displayed
3) Other tabs: the blue tabs at the end
The SNG tabs:
Before you enter data, set up your worksheets
By default, two of the SNG tabs are set up and ready to go. They are named “11s” and “22s.” The other SNG tabs are named “SNG3,” “SNG4,” and “SNG5.” It is important to set the Base Buy-in and entry fee (Vigourish) in cells D5 and D6. The standard Party Poker payout structure is entered in cells G4 through G8, so if you play at a site with a different payout structure, you should change those cells. For sites with a different play structure, Poker Stars 9-player tournaments for example, cells D7 and D8 should be changed to the correct values for the particular format. The Base Buy-in and Vig on any SNG tab not in use should be set to zero.
Entering Data
Manual Entry
Tournaments can be entered manually in the SNG tabs. Starting with row 13, the critical information goes in columns C, E, F, and G. In column C, enter the date as mm/dd/yyyy or mm/dd. In column E, enter the tournament start time as hh:mm or hh:mm:ss. In column F, enter the finish place. In column G, enter the duration in minutes. Columns H though K may be used for notes. Columns L and M contain the site and tournament number, although it may be left blank without affecting any of the calculations. Many stats can be calculated from the finishes and nothing else, so column F is the only one that absolutely has to be filled in to get the sheet to do something worthwhile.
Automatic Entry from Poker Tracker
If you have Poker Tracker installed, tournaments can be imported automatically using the “Import from PT” Macro button. Use the dropdown menu to select the Poker Tracker database from which to import. If desired, enter a start date, end date, or both to filter tournaments.
Click Configure. You will need to set up five import pages for the five SNG tabs. Any sheets into which you do not want to import tournaments should have “Select this sheet for import” unchecked. Check the boxes corresponding to the site, tournament type, and table type you wish to import into that sheet. If no boxes in a section are checked, it's the same as if all of them are checked. Once it's set up, click on Start Import and watch the magic.
version 2.4 (http://mowrmowr.com/poker/SUPER_SNG_w_UI_PT_v2.4a.zip)
If that link is broken, find it in the
root poker directory (http://mowrmowr.com/poker/)
I'm trying to write a small FAQ/user guide. Here's some text for new users.
Getting Started
I’m going to assume a basic familiarity with Excel. If you’ve never used Excel, go through a few of the tutorials in the Help menu first. About all you need to know how to do is click on cells and type stuff in them. The grey cells are where users enter data. The white cells do calculations and display results. Please do not change any white cells. The sheet is organized by tabs, those little colored deals along the bottom of the screen. Tabs may be renamed by double-clicking on the name. There are three kinds of tabs.
1) SNG tabs: This is where to enter tournament results.
2) STATS tabs: This is where the statistics from those results entered on the corresponding SNG tab are calculated and displayed
3) Other tabs: the blue tabs at the end
The SNG tabs:
Before you enter data, set up your worksheets
By default, two of the SNG tabs are set up and ready to go. They are named “11s” and “22s.” The other SNG tabs are named “SNG3,” “SNG4,” and “SNG5.” It is important to set the Base Buy-in and entry fee (Vigourish) in cells D5 and D6. The standard Party Poker payout structure is entered in cells G4 through G8, so if you play at a site with a different payout structure, you should change those cells. For sites with a different play structure, Poker Stars 9-player tournaments for example, cells D7 and D8 should be changed to the correct values for the particular format. The Base Buy-in and Vig on any SNG tab not in use should be set to zero.
Entering Data
Manual Entry
Tournaments can be entered manually in the SNG tabs. Starting with row 13, the critical information goes in columns C, E, F, and G. In column C, enter the date as mm/dd/yyyy or mm/dd. In column E, enter the tournament start time as hh:mm or hh:mm:ss. In column F, enter the finish place. In column G, enter the duration in minutes. Columns H though K may be used for notes. Columns L and M contain the site and tournament number, although it may be left blank without affecting any of the calculations. Many stats can be calculated from the finishes and nothing else, so column F is the only one that absolutely has to be filled in to get the sheet to do something worthwhile.
Automatic Entry from Poker Tracker
If you have Poker Tracker installed, tournaments can be imported automatically using the “Import from PT” Macro button. Use the dropdown menu to select the Poker Tracker database from which to import. If desired, enter a start date, end date, or both to filter tournaments.
Click Configure. You will need to set up five import pages for the five SNG tabs. Any sheets into which you do not want to import tournaments should have “Select this sheet for import” unchecked. Check the boxes corresponding to the site, tournament type, and table type you wish to import into that sheet. If no boxes in a section are checked, it's the same as if all of them are checked. Once it's set up, click on Start Import and watch the magic.