国际象棋,不用VBA.xls

The Immortal Game Adolf Anderssen vs Kieseritsky 1851 Excel craft Daniel Ferry 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 fucntions 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 IFCC 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 to complete the formulaic parsing on a future version I plan to use the Windows Sockets API from VBA to enable live game play over the internet Current version uses no VBA Game Viewer currently supports games with queenside castling It does not support pawn promotion yet Workbook license Creative Commons Attribution 3 0 United States Chess piece images courtesy of Maurizio Monge Moves WhiteBlack 1e4e5 2f4exf4 3Bc4Qh4 4Kf1b5 5Bxb5Nf6 6Nf3Qh6 7d3Nh5 8Nh4Qg5 9Nf5c6 10g4Nf6 11Rg1cxb5 12h4Qg6 13h5Qg5 14Qf3Ng8 15Bxf4Qf6 16Nc3Bc5 17Nd5Qxb2 18Bd6Bxg1 19e5Qxa1 20Ke2Na6 21Nxg7 Kd8 22Qf6 Nxf6 23Be7 1 0 Chessboard Style Modern Chess Game Viewer requires IFCC 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 to complete the formulaic parsing on a future version I plan to use the Windows Sockets API from VBA to enable live game play Game Viewer currently supports games with queenside castling It does not support Chessboard Stacked Column chart type Y Axis Series 0Series 1Series 2Series 3Series 4 110101 200101 310101 400101 510101 600101 710101 800101 Series 1bSeries 3b 11 11 11 11 11 11 11 11 Pieces XY Scatter chart type Whitexy wb13 021 5 wb26 021 5 wk5 021 5 wn12 021 5 wn27 021 5 wq4 021 5 wr11 021 5 wr28 021 5 wp11 022 5 wp22 022 5 wp33 022 5 wp44 022 5 wp55 022 5 wp66 022 5 wp77 022 5 wp88 022 5 Series 5Series 6Series 7Series 8Series 9 01010 01010 01010 01010 01010 01010 01010 01010 Series 5bSeries 7bSeries 9b 111 111 111 111 111 111 111 111 Blackxy bb13 028 5 bb26 028 5 bk5 028 5 bn12 028 5 bn27 028 5 bq4 028 5 br11 028 5 br28 028 5 bp11 027 5 bp22 027 5 bp33 027 5 bp44 027 5 bp55 027 5 bp66 027 5 bp77 027 5 bp88 027 5 ndxMove 0 0 MovesSquarexy 1111wr1 WhiteBlack2121wn1 1525457553131wb1 2626455644141wq 3613448845151wk 4516127256161wb2 5342578667171wn2 6716384868181wr2 7424366851212wp1 8638486752222wp2 9846537363232wp3 10727485664242wp4 11817136255252wp5 12828475766262wp6 13848576757272wp7 14416366788282wp8 15316475661313 16213368352323 17334566223333 18644635714343 19545522115353 20615228166363 21657758487373 22636678668383 2346571414 242424 253434 264444 275454 286464 297474 308484 311515 322525 333535 344545 355555 366565 377575 388585 391616 402626 413636 424646 435656 446666 457676 468686 471717bp1 482727bp2 493737bp3 504747bp4 515757bp5 526767bp6 537777bp7 548787bp8 1818br1 2828bn1 3838bb1 4848bq 5858bk 6868bb2 7878bn2 8888br2 123456789 525762556148512734 545564643484612525 wr1wr1wr1wr1wr1wr1wr1wr1wr1 wn1wn1wn1wn1wn1wn1wn1wn1wn1 wb1wb1wb1wb1wb1wb1wb1wb1wb1 wqwqwqwqwqwqwqwqwq wkwkwkwkwkwk wb2wb2wb2wb2wkwkwk wn2wn2wn2wn2wn2wn2wn2wn2wn2 wr2wr2wr2wr2wr2wr2wr2wr2wr2 wp1wp1wp1wp1wp1wp1wp1wp1wp1 wp2wp2wp2wp2wp2wp2wp2wp2wp2 wp3wp3wp3wp3wp3wp3wp3wp3wp3 wp4wp4wp4wp4wp4wp4wp4wp4wp4 wp6wp6 wp7wp7wp7wp7wp7wp7wp7wp7wp7 wp8wp8wp8wp8wp8wp8wp8wp8wp8 wb2wb2wb2wb2 wp5wp5wp5wp5wp5wp5wp5wp5wp5 wp6bp5bp5bp5bp5bp5bp5 bqbqbqbq bp2wb2 bp5bp5 bp1bp1bp1bp1bp1bp1bp1bp1bp1 bp2bp2bp2bp2bp2bp2bp2 bp3bp3bp3bp3bp3bp3bp3bp3bp3 bp4bp4bp4bp4bp4bp4bp4bp4bp4 bp5 bp6bp6bp6bp6bp6bp6bp6bp6bp6 bp7bp7bp7bp7bp7bp7bp7bp7bp7 bp8bp8bp8bp8bp8bp8bp8bp8bp8 br1br1br1br1br1br1br1br1br1 bn1bn1bn1bn1bn1bn1bn1bn1bn1 bb1bb1bb1bb1bb1bb1bb1bb1bb1 bqbqbqbqbq bkbkbkbkbkbkbkbkbk bb2bb2bb2bb2bb2bb2bb2bb2bb2 bn2bn2bn2bn2bn2bn2bn2bn2bn2 br2br2br2br2br2br2br2br2br2 101112131415161718 787184426663868437 666386438584756536 wr1wr1wr1wr1wr1wr1wr1wr1wr1 wn1wn1wn1wn1wn1wn1wn1wn1wn1 wb1wb1wb1wb1wb1wb1wb1wb1wb1 wqwqwqwqwqwqwqwqwq wkwkwkwkwkwkwkwkwk wn2 wr2wr2wr2wr2wr2wr2wr2wr2wr2 wp1wp1wp1wp1wp1wp1wp1wp1wp1 wp2wp2wp2wp2wp2wp2wp2wp2wp2 wp3wp3wp3wp3wp3wp3wp3wp3wp3 wp4wp4wp4 wp7wp7wp7wp7wp7wp7wp7wp7wp7 wp8wp8wp8wp8wp8wp8wp8wp8wp8 wp4wp4wp4wp4wp4wp4 wn2wn2wn2wn2 wp5wp5wp5wp5wp5wp5wp5wp5wp5 bp5bp5bp5bp5bp5bp5bp5bp5bp5 bqbqwn2wn2 wb2wb2wb2wb2wb2wb2wb2wb2wb2 wn2wn2 bqbqbq bn2bn2bn2bn2bn2 bp3 bn2bn2bn2bn2 bqbqbqbq bp1bp1bp1bp1bp1bp1bp1bp1bp1 bp3bp3bp3bp3bp3bp3bp3bp3 bp4bp4bp4bp4bp4bp4bp4bp4bp4 bp6bp6bp6bp6bp6bp6bp6bp6bp6 bp7bp7bp7bp7bp7bp7bp7bp7bp7 bp8bp8bp8bp8bp8bp8bp8bp8bp8 br1br1br1br1br1br1br1br1br1 bn1bn1bn1bn1bn1bn1bn1bn1bn1 bb1bb1bb1bb1bb1bb1bb1bb1bb1 bkbkbkbkbkbkbkbkbk bb2bb2bb2bb2bb2bb2bb2bb2bb2 br2br2br2br2br2br2br2br2br2 192021222324252627 728581368275847641 746671258476857563 wr1wr1wr1wr1wr1wr1wr1wr1wr1 wn1wn1wn1wn1wn1wn1wn1wn1wn1 wb1wb1wb1wb1wb1wb1wb1wb1wb1 wqwqwqwqwqwqwqwq wkwkwkwkwkwkwkwkwk wr2wr2wr2wr2wr2wr2wr2 wr2wr2 wp1wp1wp1wp1wp1wp1wp1wp1wp1 wp2wp2wp2wp2wp2wp2wp2wp2wp2 wp3wp3wp3wp3wp3wp3wp3wp3wp3 wp8wp8wp8wp8 wp4wp4wp4wp4wp4wp4wp4wp4wp4 wq wp5wp5wp5wp5wp5wp5wp5wp5wp5 bp5bp5bp5bp5bp5bp5bp5bp5bp5 wp7wp7wp7wp7wp7wp7wp7wp7wp7 wp8wp8 wb2wb2wb2bp3bp3bp3bp3bp3bp3 wn2wn2wn2wn2wn2wn2wn2wn2wn2 bqbqbqbqbqbqbq bn2wp8wp8wp8 bp3bp3bp3 bn2bn2bn2bn2bn2bn2bn2bn2 bqbq bp1bp1bp1bp1bp1bp1bp1bp1bp1 bp4bp4bp4bp4bp4bp4bp4bp4bp4 bp6bp6bp6bp6bp6bp6bp6bp6bp6 bp7bp7bp7bp7bp7bp7bp7bp7bp7 bp8bp8bp8bp8bp8bp8bp8bp8bp8 br1br1br1br1br1br1br1br1br1 bn1bn1bn1bn1bn1bn1bn1bn1bn1 bb1bb1bb1bb1bb1bb1bb1bb1bb1 bkbkbkbkbkbkbkbkbk bb2bb2bb2bb2bb2bb2bb2bb2bb2 br2br2br2br2br2br2br2br2br2 282930313233343536 663175216833666435 786466333545224671 wr1wr1wr1wr1wr1wr1wr1wr1wr1 wn1wn1wn1 wb1 wkwkwkwkwkwkwkwkwk wr2wr2wr2wr2wr2wr2wr2wr2bb2 wp1wp1wp1wp1wp1wp1wp1wp1wp1 wp2wp2wp2wp2wp2wp2bqbqbq wp3wp3wp3wp3wp3wp3wp3wp3wp3 wn1wn1 wp4wp4wp4wp4wp4wp4wp4wp4wp4 wqwqwqwqwqwqwqwqwq wp5wp5wp5wp5wp5wp5wp5wp5wp5 bp5wb1wb1wb1wb1wb1wb1 wp7wp7wp7wp7wp7wp7wp7wp7wp7 bp3bp3bp3bp3bp3bp3bp3bp3bp3 bb2bb2bb2bb2 wn1wn1wn1wn1 wn2wn2wn2wn2wn2wn2wn2wn2wn2 bqbq wp8wp8wp8wp8wp8wp8wp8wp8wp8 wb1wb1 bqbqbqbq bp1bp1bp1bp1bp1bp1bp1bp1bp1 bp4bp4bp4bp4bp4bp4bp4bp4bp4 bp6bp6bp6bp6bp6bp6bp6bp6bp6 bp7bp7bp7bp7bp7bp7bp7bp7bp7 bp8bp8bp8bp8bp8bp8bp8bp8bp8 br1br1br1br1br1br1br1br1br1 bn1bn1bn1bn1bn1bn1bn1bn1bn1 bb1bb1bb1bb1bb1bb1bb1bb1bb1 bkbkbkbkbkbkbkbkbk bb2bb2bb2bb2 bn2bn2bn2bn2bn2bn2bn2bn2bn2 br2br2br2br2br2br2br2br2br2 373839404142434445 542261286558637846 551152167748666657 wr1bqbqbqbqbqbqbqbq wkwk bb2bb2bb2bb2bb2bb2bb2bb2bb2 wp1wp1wp1wp1wp1wp1wp1wp1wp1 bq wp3wp3wp3wp3wp3wp3wp3wp3wp3 wkwkwkwkwkwkwk wp4wp4wp4wp4wp4wp4wp4wp4wp4 wqwqwqwqwqwq wp7wp7wp7wp7wp7wp7wp7wp7wp7 bp3bp3bp3bp3bp3bp3bp3bp3bp3 wn1wn1wn1wn1wn1wn1wn1wn1wn1 wp5wp5wp5wp5wp5wp5wp5wp5wp5 wn2wn2wn2wn2 wp8wp8wp8wp8wp8wp8wp8wp8wp8 bn1bn1bn1bn1bn1bn1 wb1wb1wb1wb1wb1wb1wb1wb1 wqbn2bn2 bp1bp1bp1bp1bp1bp1bp1bp1bp1 bp4bp4bp4bp4bp4bp4bp4bp4bp4 wb1 bp6bp6bp6bp6bp6bp6bp6bp6bp6 bp7bp7bp7bp7wn2wn2wn2wn2wn2 bp8bp8bp8bp8bp8bp8bp8bp8bp8 br1br1br1br1br1br1br1br1br1 bn1bn1bn1 bb1bb1bb1bb1bb1bb1bb1bb1bb1 bkbkbkbk bkbkbkbkbk bn2bn2bn2bn2bn2bn2bn2 br2br2br2br2br2br2br2br2br2 464748495051525354 VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VALUE VAL