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
Excel Maze
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Excel Maze
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 4StarLounger
- Posts: 495
- Joined: 13 Sep 2013, 07:56
Re: Excel Maze
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
"Science is the belief in the ignorance of the experts."
- Richard Feynman
-
- Administrator
- Posts: 78586
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel Maze
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:
There are 4 'paths' in this 'maze'.
Here is an example with the first argument set to 5 instead of 80:
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
Hans
-
- 4StarLounger
- Posts: 495
- Joined: 13 Sep 2013, 07:56
Re: Excel Maze
Ah, so not a traditional maze that I can print and pass out to people. Pity.
Thanks Hans.
Thanks Hans.
Regards, Ben
"Science is the belief in the ignorance of the experts."
- Richard Feynman
"Science is the belief in the ignorance of the experts."
- Richard Feynman
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Excel Maze
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).
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 4StarLounger
- Posts: 495
- Joined: 13 Sep 2013, 07:56
Re: Excel Maze
Rudi, on the example you posted that is not possible.
Thanks anyway.
Thanks anyway.
Regards, Ben
"Science is the belief in the ignorance of the experts."
- Richard Feynman
"Science is the belief in the ignorance of the experts."
- Richard Feynman