New AM Spreadsheet version 2.3f

[dfscott]

The latest version of the AM spreadsheet is now available for download:
Zipped version (2.2MB)
Unzipped version (10.7MB)

This version has several bug fixes (thanks, Slim) and adds the following features:

* Times can now be converted to your local time zone.
* You can specific an "to date" as well as a "from date" when importing (this is useful for people with massive PT DBs that need to use several spreadsheets).

Please let me know if you find any bugs (the time zone stuff was pretty tricky, so I expect for some of you non-US folks to find some issues.)

The latest version of this spreadsheet can always be found at at http://www.mowrmowr.com/poker (Thanks to mowrmowr for hosting)

[Apathy]

great work, bump.

[byronkincaid]

i dunno whether to start recording my results again or not.....Bump anyway

[dfscott]

As an FYI, it looks like the import functionality will not work if you're using Open Office instead of MS Excel. The importing was all written in VBA, and VB scripts will not run in Open Office.

I got a few questions in the other thread about this, so I wanted to post it here before anyone wasted their time downloading just to be disappointed.

[vindikation]

One thing that I have noticed and tried to fix is that when I modify a tournament to be 9 players, I can get it to work out numerically, but the overall yearly graph does not work correctly. I tried hacking around to get it to work correctly, but I suck at Excel so I gave up. My numbers and calculations are correct, but for some reason it still posts my wins and losses with respect to a 10 person game instead of 9 on the Yearly Graph. NOTE: the graph on the individual page for this 9 person SnG is correct, it's only screwed up on the main Yearly Graph.

[Slim Pickens]

Yeah, sure enough... it does something wrong for tournaments with any number other than 10 players. It won't affect the individual stat pages, but the "Year" graph will be wrong. I'll fix this and post the link when it's ready.