Yes, it's an excel macro.
The program didn't work for me.
I can see what it should be doing. I can see the additional DBF worksheet that was created. But other than the headers, that new DBF tab is blank.
When the program asks for my handle, I was confused. My Chess.com handle? If so, why? The pgn file I pointed to was my file of over-the-board tournament games. My chess.com handle isn't in that file. So I figured it really just wanted my name, as it looks in my pgn file. So, I gave it my name (Collins, Edward Dennis) but again, no information apeared in the DBF tab.
I looked at the code and noticed a referense to chess.com. So I ran it again and this time I gave it my chess.com handle, just for fun, but again, nothing in the DBF file.
Both times, Sheet1, in the "A" column, correctly lists every game in my pgn file, so the pgn file is being loaded properly. (And yes, it's a standard, pgn text file.)
Ideally, you should add a tab called HELP that lists the program name, the version number, and a brief description of what the program should be doing, etc., ett., to help the user. Over the years I've seen hundreds of games and ulitities and programs... all with little or no documentation. The main reason being, the programmer was just too lazy to write something up. They had fun writing the program... but writing the docs was "work" to them. As much time as a programmer spends writing the source code, the programmer should now spend the same amount of time on cleaning up the interface and documenting the program.
PGN Converter
Hey Everyone,
Thanks for your input. I hard coded this to work for chess.com pgn files. I'll have to do some research and make this a more friendly, universal pgn converter.
The tool asks for your handle so that it can tell if you played the game as white or black.
Agreed about the documentation. I had just finished it and thought I would throw it up on the interwebs.
I'll get around to getting another version up soon.
PS - Thanks risk for pointing me to scid vs PC. It looks amazing.
-Adam
PSS - To download your chess.com PGN, go to:
http://www.chess.com/home/my_archive?show=live#
In the lower right corner, you'll find a "Download All My Games in One PGN" link.
Alright, version 1.1 is uploaded:
http://www.2shared.com/file/_fNmlYzI/PGN_to_DBF_Converter_v1_1.html
I just added a help tab. Next up, I'll make a few dashboards and make the macro more generic (i.e. make it run with PGN's that aren't from chess.com).
Thanks!
Hi Borg,
It's difficult to run statistical analyses on PGN files. It would even be difficult to get something as simple as a chart of your ELO over time.
But really, there's nothing ground breaking here. I was just bored and thought I would share what I made.
-Adam
Alright, I've created a universal PGN converter. This should work for any PGN files, not just chess.com files:
http://www.2shared.com/file/1rHSjNXX/PGN_to_DBF_Converter__universa.html
If you do want to convert your chess.com PGN file, I suggest the latest v1.X file as it has more functionality than the universal converter:
http://www.2shared.com/file/_fNmlYzI/PGN_to_DBF_Converter_v1_1.html
-Adam
- 1. e4 e5 2. Bc4 Nf6 3. Nc3 c6 4. Nf3 d6 5. h3 Nbd7 6. d4 Be7 7. O-O O-O 8. Re1
Re8 9. Ng5 Rf8 10. Bb3 h6 11. Bxf7+ Rxf7 12. Nf3 b5 13. Re2 Qa5 14. Re1 b4 15.
Nb1 Qb6 16. a4 a5 17. dxe5 Nxe5 18. Bd2 Bb7 19. b3 c5 20. Nxe5 dxe5 21. f3
Rff8 22. Be3 Ba6 23. Nd2 Rfd8 24. Qc1 Qd6 25. Nf1 Nh5 26. c4 Rac8 27. h4 Bxh4
28. Re2 Qg6 29. g4 Rf8 30. Rg2 Nf4 31. Bxf4 exf4 32. Nd2 Rcd8 33. Qc2 h5 34.
Rd1 Bb7 35. Qb1 Bg3 36. Nf1 Bh4 37. Nd2 Qh7 38. gxh5 Qxh5 39. Rh2 Qg6+ 40. Rg2
Qe6 41. Qc1 Rf6 42. Nf1 Rxd1 43. Qxd1 Rg6 44. Qd2 Rxg2+ 45. Qxg2 Bc8 46. Qd2
Qg6+ 47. Kh1 Kh7 48. Qb2 Qh5 49. Qg2 Bf2+ 50. Qh2 Qh3 51. Qxh3+ Bxh3 52. Nd2
g5 53. Kh2 g4 54. fxg4 Bxg4 55. Kg2 Be3 56. Nf3 Bxf3+ 57. Kxf3 Kg6 58. e5 Kf7
59. Kg4 Ke6 60. Kh4 Kxe5 61. Kh3 Ke4 62. Kh2 Kd3 63. Kg2 Kc3 64. Kf1 Kxb3 65.
Ke1 Kxa4 66. Kd1 Kb3 67. Ke1 Kxc4 68. Kd1 a4 69. Ke2 Kb3 70. Kd3 Kb2 71. Ke2
Kb1 72. Ke1 a3 73. Ke2 a2 74. Kf3 a1=R 75. Ke4 Kc1 76. Kf3 b3 77. Kg4 b2 78.
Kh4 b1=N 79. Kg4 Kd1 80. Kf5 c4 81. Ke5 c3 82. Ke4 c2 83. Kd5 c1=Q 84. Ke4 Ke2
85. Ke5 f3 86. Kf6 f2 87. Kf5 f1=B 88. Ke4 Nc3+ 89. Kf5 Ra5+ 90. Kg4 Ra4+ 91.
Kh5 Qa3 92. Kg6 Kf3 93. Kf5 Bd3+ 94. Kf6 Ne4+ 95. Kf7 Bc4+ 96. Ke8 Ng5 97. Kd8
Bb6+ 98. Kd7 Bb5+ 99. Kc8 Ra8+ 100. Kb7 Qa6# 0-1
Hey everyone!
I created a script that will convert your PGN files into a more friendly database format (dbf) for Excel. Now you're set to track your own performance and do your own analyses!
Download the chess.com specific converter here:
http://www.2shared.com/file/_fNmlYzI/PGN_to_DBF_Converter_v1_1.html
Download the universal converter here (this will work with PGN files that aren't from chess.com):
http://www.2shared.com/file/1rHSjNXX/PGN_to_DBF_Converter__universa.html