User Profile
Twifoo
Silver Contributor
Joined Feb 08, 2019
User Widgets
Recent Discussions
Excel Chess Games Viewer 2.1
Excel Chess Games Viewer 2.1 is a slightly upgraded version of my Excel Chess Games Viewer 2.0, which now includes an option to flip the chessboard, and 77 of the most famous chess games ever. Can you guess the brilliant move 29 for Black, in the game below? Happy International Chess Day!Excel Chess Games Viewer 2.0
As my contribution to the celebration of Spreadsheet Day on 17 October 2021, I will post Version 2.0 of my Excel Chess Games Viewer. I now completed testing all of the 73 most famous chess games of all time included therein. Inspired by fmwcopen and excelasesports, the upgraded version shall feature conditional formatting for MoveFrom and MoveTo, which are dynamically defined formulas that return the squares from which, and to which, each chesspiece moves. Can you guess the brilliant move 21 for White in The Evergreen Game, shown below: As I promised, here is my Excel Chess Games Viewer 2.0. I realized that the file from the link has been edited. To view the unedited version, I now upload it here.Re: Excel Chess Games Viewer 2.0
PedroWave I've seen your Chess PGN Viewer even before I attempted to create my versions. Nonetheless, I saw no detailed instructions on how to add and view Chess Games, and so I pursued mine. Anyway, I suggest that you upgrade your version by including such detailed instructions.Excel ChessGames Viewer
Two Excel mavens incited this tenacious pursuit. Thus, it behooves me to gratefully recognize them, as follows: 1. Diarmuid Early. In his blog post, he wrote that: “If the structure held the co-ordinates fixed and figured out what piece was in each square on any given turn (rather than holding the pieces fixed and figuring out their co-ordinates on each turn) then it would be possible to handle pawn promotion in a way that my setup can’t. The trade-off is that the formula for figuring out if a given piece could have moved to a given space becomes way more complicated if it needs to cover a case for every different piece, compared to the structure used where any given row will only ever contain one piece.” (Emphasis mine.) He was right. To handle pawn promotion to Queen and to identify the position of each piece after every move, I inserted the Rook and Moves sheets and defined various named ranges and complicated formulas. Please view Diarmuid’s blog post here: https://theexcelements.com/2017/08/10/data-visualization-challenge-chess-notation/ 2. Bill Szysz. His formula was regarded as the shortest possible solution to the Material Gains Challenge. I adapted such formula by defining PtLd as Pieces!$E$3 containing: =SUM(COUNTIF(C5:J12, {"B","W"}&{"P";"N";"B";"R";"Q"})* {-1,1}*{1;3;3;5;9}) Please view the explanation of XOR LX on the foregoing formula here: https://excelxor.com/2014/10/22/shortest-formula-challenge-1-results-and-discussion/ It is noteworthy that Kevin Lehrbass expressed his love for Excel and Chess in both of the foregoing links. In his amazement, he created a blog post on Bill’s formula here: https://www.myspreadsheetlab.com/video-00162-excel-formula-calculates-value-of-chess-pieces/ In my amazement too, I created the attached Excel ChessGames Viewer, which includes 73 of the Most Famous Games of All Time. Although you may not love Chess, as Kevin and I do, your scrutiny of the formulas therein shall surely enhance your inherent analytical ability, without which you shouldn’t have read this far. Happy International Chess Day! Excel Chess Games Viewer 2.0 can now be downloaded through the link I posted here.Re: Excel Chess Games Viewer 2.0
Curiosity is thirst for knowledge. A check that is a bad move would be: +?. Check (+) is the move. Bad move (?) is the comment on the move. A move always precedes any comment thereto, not otherwise. So, a Question Mark (?), in chess notation, can never precede a Plus Sign (+).Re: Excel Chess Games Viewer 2.0
By all means, you must know by heart the meanings of those characters in each move. Those characters were published by chess gurus (certainly excluding me for being unqualified to be deemed as such). After knowing those meanings, the only issue that remains is: from what square to what square did the last piece move? If you view any chess game from other platforms, you will certainly visualize those answers, but never in Excel, until I did!Re: Excel Chess Games Viewer 2.0
I appreciate your compliment but no conditional formatting is required for: 1, Check. Because the last character in the move would be "+"; 2. Double Check. Because the last two characters in the move would be "++"; and 3. Checkmate. Because the last character in the move would be "#". For additional information, these last characters in a move mean, as follows: 1. Question Mark (?). Bad move; 2. Double Question Mark (??). Blunder; 3. Question Mark followed by Exclamation Mark (?!). Dubious move; 4. Exclamation Mark (!). Good move; 5. Exclamation Mark followed by Question Mark (!?) Interesting move; and 6. Double Exclamation Mark (!!). Brilliant move.Re: Forumula Help
jonoross When you enter =A1 in C4, that formula means: return in C4 whatever value is stored in A1. So, if the value in A1 is 10, the formula in C4 also returns 10. If the value in A1 subsequently changes to 11, the result in C4 also changes to 11. If you want the value in C4 to remain 10 although the value in A1 changes to 11 or another value, do not enter a formula in C4, simply enter 10.
