+ Reply to Thread
Results 1 to 11 of 11

Sliding Number Puzzle

Hybrid View

  1. #1
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Sliding Number Puzzle

    Just to comment on your number 1:

    Years (and years) ago (in the 1980's) I wrote a program to generate sliding block puzzles on a 3 x 3, 4 x 4 or 5 x 5 grid (user-selectable - I used letters of the alphabet, so couldn't allow it to be bigger), and I just generated a number of random moves to begin with. This did create unwinnable situations. I got round it by generating random numbers in the range 1 to 4 where each number represented a direction (up/down, left/right) and effectively moved a tile into the "blank" from those directions.

    As for who designed it (your number 6), I remember playing with a plastic version when I was a kid in the 60's, so I think the game has a very long history.

    Hope this helps.

    Pete

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Sliding Number Puzzle

    Quote Originally Posted by Pete_UK View Post
    Years (and years) ago (in the 1980's) I wrote a program to generate sliding block puzzles on a 3 x 3, 4 x 4 or 5 x 5 grid (user-selectable - I used letters of the alphabet, so couldn't allow it to be bigger), and I just generated a number of random moves to begin with. This did create unwinnable situations. I got round it by generating random numbers in the range 1 to 4 where each number represented a direction (up/down, left/right) and effectively moved a tile into the "blank" from those directions.
    I had a vague idea that truly random shuffles (as opposed to doing a number of random but valid moves) could create unwinnable situations in sliding block puzzles. Thanks for confirming it.

    BTW slightly off-topic but have you made any sliding block puzzles in Excel? I'd be interested in seeing it if that's OK with you.


    Quote Originally Posted by Pete_UK View Post
    As for who designed it (your number 6), I remember playing with a plastic version when I was a kid in the 60's, so I think the game has a very long history.
    That's interesting. Someone has recently pointed out to me one made by Binary Arts and it's called Top Spin (TopSpin? Top-Spin?). I googled Top Spin and the pictures are the same as the one I saw. Is the same as the one you saw?
    Last edited by mc84excel; 10-30-2014 at 07:06 AM.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filling up a Number Puzzle
    By tariqhasan75 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2012, 05:52 AM
  2. Filling up a Number Puzzle
    By tariqhasan75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 05:06 AM
  3. number puzzle
    By mkron in forum Excel General
    Replies: 14
    Last Post: 01-28-2007, 12:13 AM
  4. Number Puzzle
    By PetaPan via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2006, 12:45 PM
  5. [SOLVED] Prime number puzzle
    By johnT in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2005, 09:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1