Spreadsheet Skunkworks! Excel VBA Chess Challenge #2 (+ Puppy Intro!)

videos

Can we create a chess computer in an Excel spreadsheet using Excel VBA?

*** PUPPY INTRO from 18.00 ***

Download the file used in this video here:
https://tinyurl.com/y8oqtfoy

Spreadsheet Skunkworks playlist here:
https://tinyurl.com/y8ufaodr

Welcome to the Spreadsheet Skunkworks! In this video series, Chris tests the boundaries of what is possible in Excel. You will not find the usual step-by-step tuition here; the focus is on experimentation and creativity. Expect plenty of coding challenges, and some nice surprises about what is possible in Excel…

We will seek to use Excel’s functions and Excel VBA to create the functions of a chess computer. We do not know to what extent this is possible but, ultimately, we would like to challenge somebody to a game on Chess.com using our spreadsheet-based system. Along the way, we aim to learn lots about Excel VBA and its capabilities.

Some key questions:
– How can we represent a chess board and chess pieces in Excel?
– Can we make Excel understand where the pieces can move?
– Can we ‘teach’ Excel some simple chess principles (capture the other pieces, move your pieces to good squares), and get Excel to recommend a move to make?

In the second video in the series, Chris improves code produced in the first. We explore how to implement a ‘remote referencing’ approach to creating the chess board which achieves efficiency improvements. We also build in a mechanism to allow the user to control the appearance of the squares, and look at some cool cell fill options. VBA techniques in the video include for / next loops, loop within a loop, integer and boolean variables, and copy / paste (special) coding. Finally, Chris introduces his new puppy, Kuda!

What do you think about the Spreadsheet Skunkworks series? Do you have any ideas for the Chris? Don’t forget to leave a comment.

Get in touch with Tiger using the platforms below!
For regular spreadsheet hints and tips and more on the #ExcelRevolution:
https://www.facebook.com/TigerSpreadsheetSolutions
https://twitter.com/TigSpreadsheets

Home

The post Spreadsheet Skunkworks! Excel VBA Chess Challenge #2 (+ Puppy Intro!) appeared first on Rimadyl Painkillers for dogs.

from Rimadyl Painkillers for dogs http://video.getridoffleasondogs.com/dogs/spreadsheet-skunkworks-excel-vba-chess-challenge-2-puppy-intro/
via IFTTT