Snooker scoreboard (2003 sp2)

Good morning

My son is an aspiring snooker player and plays at club level, I have noticed on the TV lately the scoreboards they are using and thought that it would be nice for my sons teams home games to have such a display on a large screen attached to a laptop.

I have no idea if this can be done in Excel and don't want to waste too much of anybodies energy as it is not work related. If you can give me some advice I have attached a workbook with an explanation of the basic workings. I have an idea that I should maybe assign each ball shape I have to a cell to make calculations but I am as always open to advice