View Single Post
  #7  
Old 03-13-2006, 01:50 PM
dfscott dfscott is offline
Senior Member
 
Join Date: Apr 2004
Location: Speed $11\'s
Posts: 3,010
Default SnG Spreadsheet for Speed Junkies! (2.7f)

The link at the top of this thread now points to a new version of the SnG spreadsheet (version 2.7f). This version allows you to separate Party Speeds and Normal SNGs when you import them into the spreadsheet. This currently only works for Party. Here's an example of how you'd use it if you were playing 11s, both speeds and normals, and wanted to keep them separate:

1) Go to the SNG1 tab. Put 10 in the buy-in field and 1 in the fee field. (no change from previous versions). I'd suggest changing the text in B1 to something like "$11 Party (Normal)" but this is optional.

2) Go to the SNG2 tab. Do the exact same thing, but make the text "$11 Party (Speed)"

3) Click the "Import from PT" button (on either page -- doesn't matter which).

4) Click "Configure". Configure everything like you have in the past, but notice the new Drop-down under the Poker Sites checkbox for "Party and Affiliates" (it's disabled unless you have Party selected).

5) Select "Normal Only" in the Speed drop-down.

6) Click "Next" and do that exact same thing for this sheet, except select "Speed Only" in the Speed drop-down.


That's it -- when you import, it should put them in the corresponding sheets. BTW, the default option is "Both," so if you don't do anything, it will combine them the way it always has.

For those that are interested, the only way I've been able to come up with to tell the difference is by looking at the table name. If it starts with "Speed ", I assume it's a speed tourney. Anything else is considered a regular. If Party ever changes this, it will break (and we'll have to go back to the drawing board).

Feel free to PM with questions/bug reports.

[ QUOTE ]
df or Slim, I have a fix I would like to be implemented in the spreadsheet. I reported an issue to Slim several months ago and finally created a fix for it. Who should I PM?

[/ QUOTE ]

If it's a problem with the PokerTracker import functionality, I can handle that. I believe Slim is still addressing any issues with the spreadsheet formulas and/or graphs.
Reply With Quote