Excel 2007 Chess Game Viewer

It’s now half time for our NFL Drive Chart tutorial and so I thought I’d share another Popcorn Chart with you.

This one is a Chess Game Viewer and it’s a lot easier to construct:
the_immortal_game_excelhero.com.gif
The image above is a screen shot of the Excel 2007 Chess Game Viewer. The workbook is another implementation of the Popcorn Chart as series pop off the screen as chess pieces are captured.


If you’ve been reading my blog you know that I try to avoid IF() functions whenever possible. See I Heart IF for details. Previously I shared about using boolean expressions as one method to eliminate many IF() functions. The way this is usually done works well with numeric formula results. The Chess Game Viewer demonstrates a technique to do the same with formulas that result in text output. The key is the REPT function, which does not error out with zero repetitions.
The project demonstrates conditional chart formatting without VBA and using images as marker fill.
It showcases the advantage of using a state machine as input to the dynamic chart. This gives us the ability to view a game forward and backwards.
The Chess Game Viewer uses one compound chart comprised of a Stacked Column chart type for the chessboard and an XY (Scatter) chart type for the chess pieces.
The chart sheet is protected but there is no password. So to dig into the working details, just Unprotect the sheet.
You can find the controls to advance the game and to change the chessboard style at the bottom right corner of the chessboard.
I’d love to hear your feedback.
Here’s the Excel 2007 workbook.
— UPDATE —
Okay, I’ve been getting a lot of requests to provide a copy of the chess viewer that will work in previous versions of Excel. Today, I made one, but it looks terrible. Excel 2007’s graphics capability are far superior. At any rate, at least it works. Here it is…
Enhanced by Zemanta

54 thoughts on “Excel 2007 Chess Game Viewer”

  1. I haven’t had a chance to look at it yet, but you impressed John Walkenbach enough for him to post a link from his site, so be prepared for a big jump in traffic today :)
    Just a general comment; the Blog is really hard to navigate (unless it’s just me). For instance the Home tab doesn’t take you to the most recent post, and doesn’t even have a Blog tab. Some non pseudo-latin words on the About page would be nice too :)
    Best wishes anyway
    Doug

  2. @T-
    Yes it is possible and I’m working on it!
    You will be able to play a partner over the internet.
    Regards,
    Daniel Ferry
    excelhero.com/blog

  3. @Anil-
    Actually I make 100% of my living from freelance work.
    I’m always interested in new work.
    Thanks for the compliments on my work.
    I just sent you a PM.
    Regards,
    Daniel Ferry
    excelhero.com/blog
    daniel [dot] ferry at gmail [dot] com

  4. I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

  5. This is certainly among the more fascinating websites I have seen. It is so easy to get jaded, but there is absolutely some fantastic material on the internet, and I feel your site is one of them!

  6. Hi,
    This blog is an amazing demonstration of Excel as a platform. One of Excel’s best qualities is the independent development environment it provides. Thanks to your blog, we can see how powerful and flexible it can be.
    Your chess viewer is, again, quite impressive especially not using any VBA to implement it. My only concern is that somebody might get too excited and decide to present their own games. The good news is that the task isn’t impossible since your viewer is based on “ICCF numeric notation”. Such flexibility is probably good enough for the purpose of this exercise. The bad news is that what is shown is, in fact, a mere sequence of pictures and the viewer has no chess knowledge whatsoever. The problem is that chess community is more used to sharing games in PGN format. If somebody is interested in doing that he/she can visit How to publish a chess game on your blog

  7. @nick –
    You are right about the format that the viewer understands. I hope to get a chance (whenever I can find the time) to improve the viewer so that it does understand PGN. I would also like to make it so that it can be used to actually play a game over the net with a partner. Haven’t found the time yet :(
    Thanks for visiting and the link.
    Regards,
    Daniel Ferry
    excelhero.com

  8. Here i have got some good tips from here. This is also interesting to see that the gaming part is designed on Excel 2007. I will again visit this. Check out the classic automatic watch, god of watch!

  9. This blog is an amazing demonstration of Excel as a platform. One of Excel’s best qualities is the independent development environment it provides. Thanks to your blog, we can see how powerful and flexible it can be. Get the fat mechanical watch out there!

  10. I would also like to make it so that it can be used to actually play a game over the net with a partner. Haven’t found the time yet :( Thanks for visiting and the link to my 32 lcd tv site!

  11. This blog is an amazing demonstration of Excel as a platform. One of Excel’s best qualities is the independent development environment it provides. All I need now are fast ceramic watches for my use!

  12. Hi Daniel,
    some times ago I read your overwhelming Excel chess blog. It’s awesome to read what you are doing with Excel. I want to learn and build a Excel chess game for my one. May I use your chess pieces pictures?
    Regrads,
    Frank

  13. I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well.livejasmin

  14. Your article is really great and I truly enjoyed reading it. I will be waiting for some more great articles like this from you in the coming days. Thanks a lot. Regards
    Area Rugs

  15. Very impressive. I am a chess fan and aspiring to play competitive chess. This is a very valuable tool for me.

  16. I just finished my day at business for sale site and taking time reading some posts of yours. I play chess sometimes and the game is really great when the game has come to its end. Nice post.

  17. I work at job search site and I am totally find this game so boring. Maybe for a reason that I only game outdoor games. I like playing games that really boost my stamina and get sweat.

  18. Hi, I’m Sara from gold coast home builders and I think this game significantly improved in both memory and verbal reasoning. Chess improves academic performance as well, which happened not played by most young ones.

  19. Hi Daniel, this is Mark from a job site – how did you do this one? This is really awesome.

  20. Hi Daniel, thanks to your brilliant idea of ​​a chess viewer based on the numerical notation, I have prepared my own viewer that part of the algebraic notation displaying chess pieces into Excel cells. Please, follow me at Pedro Wave Blog Spot.

  21. Thanks for your sharing .Your thoughts are creative and they actually do help to me. It provides me with a lot of information. It is a nice post!
    Tool Steel

  22. billige lån
    Hi Daniel,
    some times ago I read your overwhelming Excel chess blog. It’s awesome to read what you are doing with Excel. I want to learn and build a Excel chess game for my one. May I use your chess pieces pictures?
    Regards,
    lån penge

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>