NEW Spreadsheet: 2.4b w/ Daily Summary

[1C5]

Awesome, thanks!

[Slim Pickens]

It looks nice. Does anybody know how to cut-and-paste and a tab into my old sheet without it leaving the reference to the old sheet. I'd love to just move this into my current sheet without having to import or move all my data.

SlimP

[astarck]

Unfortunately I don't know if it can be done. When I was working on this page and a new spreadsheet came out I upgraded the new one and tried to simply copy the sheet over. It referenced all of the cells in my old sheet (C:/Program Files....etc). I tried using the "Paste Special" feature, then selecting formulas only, but it too copied the file path.

One idea might be to host it online and try to copy the page from there since filepaths might not be linked.

You would think Excel would have thought of this and created something to get around this. If there is, I don't know of it.

[New York Jet]

To use the spreadsheet with the new PostgreSQL version of PT, open the frmImport VBA code and make the following changes:

Replace
<font class="small">Code:</font><hr /><pre>szConnString = "DSN=" &amp; szSelectedDSN &amp; ";" &amp; _
"Uid=admin"</pre><hr />
With
<font class="small">Code:</font><hr /><pre>szConnString = "DSN=" &amp; szSelectedDSN &amp; ";" &amp; _
"Uid=UserName;PWD=Password"</pre><hr />
Replace UserName and Password with your PostgreSQL username and password.

[New York Jet]

Here is how to copy and paste the daily summary in to your existing spreadsheet in 10 steps.

1. Open both your existing spreadsheet and the daily summary version.
2. In your existing spreadsheet, add a new worksheet, name it Daily Summary.
3. Select Tools, Macros, Microsoft Script Editor.
4. Expand the tree and highlight Daily Summary under the new version, then click View Code.
5. Select All (Ctrl-A) and copy (Ctrl-C).
6. Expand the tree and highlight Daily Summary under your existing spreadsheet.
7. Select All (Ctrl-A) and paste (Ctrl-V).
8. Close the Microsoft Script Editor.
9. In the new version, Daily Summary sheet, highlight cells A1 through Y368 and click the Special Paste button.
Do step 10 very carefully
10. In the existing version, Daily Summary sheet, highlight cells A1 through Y368.

[astarck]

Thanks for posting. I figured it could be done, just didn't know how.

[fnord_too]

It only lists 10 of my PT databases, but not my S&amp;G database. I renamed my S&amp;G database to something in the top 10 alphabetically, but that did not work. Any suggestions?

[Hood]

[ QUOTE ]
Well that import function should be done for PS, too. But i know you didn't do that thing.
Before someone talks about SNG Tracker - I think it doesn't import PS too - I can't get the damn thing to work. I have the newest Visual Studio Installed with newest .NET Framework, but it still wants some other .NET Framework!

[/ QUOTE ]

As it says on the site, "The software runs on the .NET Framework v1.1"., not the "latest version" (I assume you installed the v2.0 beta release). You don't need visual studio. It doesn't import pokerstars HHs.

[Jurollo]

Didn't I add this to the AleoMagus spreadsheet last summer? The daily splits/weekly splits pages? Or did that get left off the latest and greatest Aleo sheet? It's been a while since I have rocked the SNG forum.
~Justin

[Slim Pickens]

astarck's new tab tells you how you've done today/this week/this month. Your daily/weekly/TOD splits are still in there though. I fixed 'em up good.

SlimP