Forums

PGN

Sort:
LisaGreen
LisaGreen
Dec 27, 2014
0
#1

Okay... I admit it right up front... I like fiddling with Excel.

I personally think that PGN isn't the easiest text to read... especially with annotations and moves within that.

I've written some excel stuff to expand PGN so it's easier to read. Yes I know... there are programs for that!! But this produces easilly readable text very quickly that you can even print out if you like.

Anyroad... If anyone wants a copy let me know.

Here is a sample of the output of a game from the London Chess Classic. I hope the formatting is preserved!!!!

Lisa

Original PGN...

1.e4 e5 2.Nf3 Nc6 3.Bb5 a6 4.Ba4 Nf6 5.O-O Be7 6.Re1 b5 7.Bb3 O-O 8.d3 d6
9.c3 Na5 10.Bc2 c5 11.Nbd2 Nc6 12.Nf1 h6 13.Ne3 ( { Not the commonest: }
13.h3 ) ( { and } 13.Ng3 { are seen more often. } ) 13...Re8 14.a4 Be6
{ Black    
thought for around 20 minutes on this, so was seemingly out of prep. } 15.h3
Bf8 16.Nh2  
{ By now White too was thinking for prodigious amounts of time on
his moves. } 16...b4 ( { Uncharted territory. } 16...d5 17.axb5 axb5 18.Rxa8
Qxa8 19.exd5 Nxd5 20.Neg4 Nf4 21.Nf3
{ was Spraggett-Sargissian, Linares Open 2013,
and eventually drawn. } ) 17.Bb3 Rb8 18.Bc4 bxc3 19.bxc3 d5 $5
{ It has been a  
fairly sedate Ruy Lopez to here but now the gauntlet is thrown down. }
20.Bxa6    
{ Adams takes up the challenge. Instead he could have gone in for multiple
exchanges in the centre, and probably equality. } 20...Qa5 21.c4 ( 21.Bb5
Rxb5 $1 22.axb5 Qxa1 23.bxc6 Qxc3
{ should lead to a reasonable advantage for Black. } ) 21...Qxa6 22.exd5 Bxd5
23.cxd5 Nb4 $1  
{ [diag] The GMs in the VIP room
thought Adams might have missed the power of this. The threat to d3 is hard to
meet. } 24.Ra3 ( 24.Nhg4 Nxg4 25.Qxg4 Nxd3 26.Rf1 Rb4 27.Qe2 c4
{ looks    
quite good for Black. } ) 24...Nfxd5 25.Neg4 f6 26.Nf1 Rbd8 ( 
{ Houdini    
suggests this was the wrong rook. So does natural logic: it seems better to
keep the b8 rook firing down the b-file whilst moving the e8 rook which is
relatively underemployed on e8. Perhaps Fabiano was wary of depleting his
kingside defences altogether. } 26...Red8
{ is close to winning according to
Houdini. } ) 27.Ng3 { [diag] } 27...c4 $2 ( 

 

Excel output...

9 c3 Na5        
10 Bc2 c5        
11 Nbd2 Nc6        
12 Nf1 h6        
13 Ne3          
          { Not the commonest: }
          13. h3  
          { and }  
          13. Ng3  
          { are seen more often.}
13 .. Re8        
14 a4 Be6        
          { Black thought for around 20 minutes on this, so was seemingly out
          of prep.}  
15 h3 Bf8        
16 Nh2          
          { By now White too was thinking for prodigious amounts of time on
          his moves.}
16 .. b4        
          { Uncharted territory.}
          16. .. d5  
          17. axb5 axb5
          18. Rxa8 Qxa8
          19. exd5 Nxd5
          20. Neg4 Nf4
          21. Nf3  
          { was Spraggett-Sargissian, Linares Open 2013, and eventually drawn.}
17 Bb3 Rb8        
18 Bc4 bxc3        
19 bxc3 d5 £5      
          { It has been a fairly sedate Ruy Lopez to here but now the gauntlet
          is thrown down.}
20 Bxa6          
          { Adams takes up the challenge.Instead he could have gone in for
          multiple exchanges in the centre, and probably equality.}
20 .. Qa5        
21 c4          
          21. Bb5 Rxb5 $1
          22. axb5 Qxa1
          23. bxc6 Qxc3
          { should lead to a reasonable advantage for Black.}
21 .. Qxa6        
22 exd5 Bxd5        
23 cxd5 Nb4 £1      
Chicken_Monster
Chicken_Monster
Dec 27, 2014
0
#2

Nicely done.

LisaGreen
LisaGreen
Dec 28, 2014
0
#3

Thank you!!