Search results
A few weeks ago I posted a screenshot of my Excel chess board that I use for some at-work correspondence games, and it seemed people liked it. Someone asked me to share, so I uploaded it as an Excel file to Google Docs. Feel free to share the link if others want a copy.
Oct 13, 2021 · 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.
- Review A Game
- How Do The Pieces Move?
- Continue Auditing
- Sheet ‘Games’
- Material Advantage
- The Author
- About Me
Let’s review a classic game! Below we see sheet ‘Board’. Select a game: in cell B4 I selected ‘Kasparov’s Brilliancy’. See the moves: click the “^” spinner button on the right. The next move is the brilliant move! Can you see it? Hold spin buttons to quickly cycle through moves or enter sequence number in the cell K6.
Everything starts with the game you select in cell B4. Cells B5 & B6 retrieve game details. In cell B9 we see this key formula: There are two LOOKUP functions in this formula. Let’s examine the inner LOOKUP. LOOKUP’s lookup_value is hard-coded to 2(I’ll explain later). 1/(CHOOSE(MoveChoice,WhiteMoves,BlackMoves)=B$8&$A9) is the lookup_vector(where ...
To get all the way back to the raw data (sheet ‘Games’) you’ll have to audit these named ranges found inside the double LOOKUP function: 1. MoveChoice 2. WhiteMoves 3. BlackMoves 4. WhiteLabels 5. BlackLabels Here are some auditing tips: 1. click inside formula bar to see referenced cells 2. unhide columns L & M (to see chess icons) 3. note spinner...
Starting in column B each column is a game with moves starting in row 8. This is modern chess notation. Each row contains a move from white and black. Column F’s game is called ‘Amazing Nakamura’. I played through the moves and IT IS amazing!
Cell B17 (sheet Board) displays chess piece material advantage. Note: a material advantage doesn’t necessarily mean a player is winning. Formula above uses named range PtLd (sheet Pieces) where the calculation happens. PtLdformula is: This calculates the value of the pieces. See this postfor a detailed explanation.
Robert H. Gascon is Certified Public Accountant from Quezon City, Philippines. See his Microsoft tech community profile. Robert is a valued contributor meaning that he answers a lot of questions posted by Excel users. Robert has an incredibly deep knowledge of Microsoft Excel. Robert has shared alternative solutions on my blog. I’ve learned a lot f...
My name is Kevin Lehrbass. I’m a Data Analyst. I live in Markham (Canada). In 2018 I visited New York City. In central park I found outdoor chess tables and an indoor chess club. I’ve played chess since I was 11. I was on the chess team in high school. Chess is fascinating and it’s great mental exercise. In the 90s I discovered Excel. I’ve been hoo...
Oct 23, 2018 · Comedy drama. It's bath night for Rosie and, as usual, that means chaos as she insists on having all the bubble bath. Emily decides that she needs to form a strategy. Show more.
- Edan Hayhurst
- September 1, 2025
- Jessica Hynes
- September 1, 2022
i am looking for a very very simple and light excel chess board, and surprisingly can not find anything online (i thought everything has been done and tried on the world wide web by now). i am envisioning an 8x8 grid with white and gray squares and movable pictures of pieces, that's all.
Aug 18, 2021 · How to make a chessboard in Excel. Posted on 18 August 2021 by John. I needed to make an image of a chessboard for the next blog post, and I’m not very good at image editing, so I make one using Excel. There are Unicode characters for chess pieces— white king is U+2654, etc.—and so you can make a chessboard out of (Unicode) text. ♔♕♖♗♘♙♚♛♜♝♞♟.
People also ask
Can I upload my Excel chess board to Google Docs?
What's new in Excel chess games viewer?
How do I audit a chess game?
1. One Day in the Life of Rosie Yates. It's a typical Saturday for nine-year-old Rosie, who has a severe learning disability. 30 mins. 2. Bubble Chess. 3. What Rosie Wants. A trip to Rosie's...
