Excel Maze

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Excel Maze

Post by Rudi »

Graeme McRae shares an Excel maze here, created by a UDF function.
Not sure how practical it is, but if you like mazes or if you have time to waste...try this.

Each time you want a new maze, just autofill A2 to the bottom.
I have not tested if they are actually solvable...and I guess the idea would be to enter the maze at one corner and work your way out on the opposite diagonal corner.

Enjoy :hairout: :groan:
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

BenCasey
4StarLounger
Posts: 495
Joined: 13 Sep 2013, 07:56

Re: Excel Maze

Post by BenCasey »

Rudi, does this have a start and end point? I cannot see one.
Regards, Ben

"Science is the belief in the ignorance of the experts."
- Richard Feynman

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Maze

Post by HansV »

The mazes generated by the workbook are just random sets of diagonal lines. They will usually contain several 'paths' from one point on the edge to another point on the edge, some very short, some longer, but not a maze in the traditional sense.

Here is an example with the first argument set to 5 instead of 80:
S297.png
There are 4 'paths' in this 'maze'.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

BenCasey
4StarLounger
Posts: 495
Joined: 13 Sep 2013, 07:56

Re: Excel Maze

Post by BenCasey »

Ah, so not a traditional maze that I can print and pass out to people. Pity.
Thanks Hans.
Regards, Ben

"Science is the belief in the ignorance of the experts."
- Richard Feynman

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Excel Maze

Post by Rudi »

Hi Ben,
As I mentioned in my opening post: "I guess the idea would be to enter the maze at one corner and work your way out on the opposite diagonal corner."
It will still pose a challenge if you specify a start and end point (having verified yourself beforehand that the path is possible).
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

BenCasey
4StarLounger
Posts: 495
Joined: 13 Sep 2013, 07:56

Re: Excel Maze

Post by BenCasey »

Rudi, on the example you posted that is not possible.
Thanks anyway.
Regards, Ben

"Science is the belief in the ignorance of the experts."
- Richard Feynman