Excel-VBA - Lösung eines Waben-Puzzles

Have Excel try to match all colors of facing tiles

The game

seven hexagonal tiles with six colours each must be arranged in a way such that the colors match on all joins between tiles.

Concept

The VBA-Modul uses brute force and tries all combinations of tile arrangements and rotation. Every arrangement is checked for being a solution. If so, it is added to a list of solutions found.

In order to avoid the same solution to show up six times with different rotations, the central tile is not rotated, just swapped.

demo video

The video besides shows the search for a solution for a pre-set game (definitionen of color sequences for all tiles). The solutions found are displayed graphically to show ho hexagonal arrangements may be handled in Excel.

Comments and Responses

×

Name is required!

Enter valid name

Valid email is required!

Enter valid email address

Comment is required!

Be the First to Comment
Top