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:
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.