Excel 2007 Chess Game Viewer

| 54 Comments | 0 TrackBacks

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
If you liked this article, please share it!



Your Ad Here

No TrackBacks

TrackBack URL: http://www.excelhero.com/cgi-bin/mt/mt-tb.cgi/10

54 Comments

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

Thanks again, as usual. Good stuff here.

It's not in my nature to regularly reply to posts but I've made an exception in this case. WoW

Amazing what's possible in Excel!

Would be even cooler if it could be used to play actual games -- is that doable?

@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

Your detailed examples are very nice and detailed on http://www.databison.com/index.php/multithreaded-vba-an-approach-to-processing-using-vbscript/

Daniel , can you do freelancing projects.If yes , please conform by email,then i will send u details by email .

Regards

Anil Verma

@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

You have some really good posts on here, however it took me a while to find this blog, why dont you promote this blog more often?

Love the site - I'll check in again soon to pick up some more tips.

Where did you get this theme. Is this Wordpress?

Smart information&fantastic site.

This is a kewl wonder how to create such a thing. Cool place to find.

Super !!! Merci beaucoup :)

Love the blog, found it in bing, how do I subscribe?

Need yo subscribe to this blog, great post. Found it on yahoo.

Thanks for taking the top out to write this nice post.

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!

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!

I'm so glad I randomly found your blog. It is so cool.

Did I already tell you that I love each and every subjects on your website ?

Hi, I just thought I would drop you a line and let you know your web site layout is really messed up on the Firefox browser. Seems to work fine in IE though. Anyhow keep up the great work.

Interesting post.

You definitely outdid yourself with this post. Color me impressed.

Great information guys, keep it up!!

Usefulinformation shared..Iam very happyto read this article..thanks for giving us nice info.Fantastic walk-through.

I just found this website a while ago when a buddy of mine recommended it to me. I have been a regular reader ever since.

Excellent blog you have there, thanks for sharing, iv bookmakred you!

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

@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

Nice to see you make postings on this issue, I should bookmark this web site. Just keep up the good work.

Nice job! What an amazing website. Sincerely.

Hi

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.

This is good mate! skeleton watch

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!

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!

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!

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!

Jailbreaking your PS3 for Free is finally here! Free instructions, http://jailbreakingmyps3.com

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

@Frank -

You can definitely use the chess pieces, but they are not mine.

A kind soul by the name of Maurizio Monge from Italy made them available to me. They are also now available at wikimedia commons for anyone:

http://commons.wikimedia.org/w/index.php?title=Special:Search&search=chess+fantasy

Good luck with your project!

Regards,
Daniel Ferry
excelhero.com

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

Excel 2007 Chess Game is wonderfull. Thank you.replica designer handbags

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

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

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.

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.

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.

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

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.

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

wow, pretty amazing to see the conditional chart formatting without VBA, but using images as marker fill.

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 comment

About this Entry

This page contains a single entry by Daniel Ferry published on February 13, 2010 8:24 AM.

NFL Drive Chart Tutorial - Part 1 was the previous entry in this blog.

Excel Optical Illusions is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.