国际象棋,不用VBA（精选）.xlsx

The Immortal Game - Adolf Anderssen vs Kieseritsky (1851)


Excel craft:
Daniel Ferry

@

Demonstrates:
Popcorn Chart Chess Game Viewer
Combination of XY (Scatter) and Stacked Column chart types
Marker Fill with picture files.
Conditional Chart Formatting for chessboard style
Dynamic Charting with No VBA
No IF() tions. Not even one.
REPT() and boolean logic as alternative to IF()
INDEX/MATCH
The most famous chess game of all time -

Notes
Project crafted on February 12, 2010.
Chess Game Viewer requires Numeric Notation for game input. The Algebraic Notation is
simply for display. Disambiguity of the Algebraic Notation by formula proved too demanding for
this simple demonstration project. It would be interesting plete the formulaic parsing on
a future version. I plan to use the Windows Sockets API from VBA to enable live game play
over the . Current version uses no VBA.
Game Viewer currently supports games with queenside castling. It does not support
pawn promotion, yet.

Workbook license:
mons, Attribution United States



Chess piece images courtesy of:
Maurizio Monge


















































Moves
White Black
1 e4 e5
2 f4 exf4
3 Bc4 Qh4+
4 Kf1 b5
5 Bxb5 Nf6
6 Nf3 Qh6
7 d3 Nh5
8 Nh4 Qg5
9 Nf5 c6
10 g4 Nf6
11 Rg1 cxb5
12 h4 Qg6
13 h5 Qg5
14 Qf3 Ng8
15 Bxf4 Qf6
16 Nc3 Bc5
17 Nd5 Qxb2
18 Bd6 Bxg1
19 e5 Qxa1+
20 Ke2 Na6
21 Nxg7+ Kd8
22 Qf6+ Nxf6
23 Be7# 1-0









Chessboard Style: Modern



















































































Ches