Oct 13 2021 10:42 AM - edited Oct 28 2021 10:31 AM
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.
Oct 13 2021 12:06 PM
Oct 13 2021 12:25 PM - edited Oct 13 2021 12:27 PM
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.
Oct 13 2021 12:46 PM
Oct 13 2021 01:05 PM
Oct 13 2021 01:22 PM
Oct 18 2021 03:26 AM - edited Oct 18 2021 03:43 AM
@Twifoo, this great chess games viewer has reminded me that 6 years ago I published a chess viewer that loads games from PGN files, that I share here in case it is of your interest.
I just updated it to link to your chess games viewer:
Excel Chess Board PGN Viewer - Visor PGN Tablero de Ajedrez Excel | Pedro Wave for Excel Guys
It is a joy that there are enthusiasts who bring together Excel and Chess.
Regards,
Pedro Wave
Oct 18 2021 04:11 AM
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.
Oct 18 2021 05:16 AM
Oct 18 2021 05:56 AM
Without detailed instructions, your Excel PGN Viewer can never be user-friendly. Such instructions must be directed towards the convenience of the User, not the Author thereof. I look forward to viewing those instructions in your upgraded version soon.