Printable Sudoku Puzzles Using Microsoft Excel

Does the world need yet another printable Sudoku puzzle software? Of course it does. I wanted to make one using my creaky spreadsheet programming skills. Along the way, I made a startling discovery…

Get Printable Spreadsheet Sudoku Now!

If you just want the spreadsheet, here’s what you have to do:

  • Go to Morphoboard.com
  • Register
  • Check your email to confirm your subscription
  • Get instant access, both online and via download

The Nitty Griddy

Okay, they’re gone. For the geeks remaining in the room, let me wow you with this revelation:

Sudoku puzzles are nothing more than collections of cryptograms!
This does not mean you can solve a Sudoku puzzle like a Cold War spy. Maybe.
But if you want to quickly create an absurdly large number of puzzles, you no longer have to create a tentative puzzle and exhaustively check it for accuracy. Just grab your code key and translate one Sudoku puzzle into another! I’ll demonstrate the technique with pictures.

Consider the first grid to be the solution to a particular Sudoku puzzle. Consider a substitution key where 1 becomes 4, 2 becomes 9, 3 stays 3, 4 becomes 5, 5 becomes 8, 6 stays 6, 7 becomes 1, 8 becomes 2 and 9 becomes 7. After translating the first grid, we arrive at the second grid!
Now that you know the “secret”, you can use your favorite program to generate new Sudoku Puzzles!

Here are some tricks I used for Printable Spreadsheet Sudoku:

  1. I randomly select one of 99 different solutions
  2. For the substitution key I use one of the rows in the solution!!
  3. I randomly shift and rotate the grid, ensuring that the puzzle remains intact
  4. Blank squares are randomly displayed – more blanks mean a tougher challenge

I limited the total number of possible combinations because I figured 48,000 puzzles are enough. By the time you finish them, you won’t even remember the first batch and you can play all over again! :)

Who’s Out There?

I wanted to see if anyone else had created Sudoku Puzzles based on substituting values. I discovered an interesting site:

This site has a Sudoku variation called Twin Corresponding Sudoku. Henry Kwok is the author.
This variation requires you to use cryptography in order to help solve both puzzles simultaneously. As an aside, I believe I have found the original creator of this variation. He has a lengthy post on a forum, discussing his invention:

With my friends and even some strangers, I have discussed the problem of my sudoku variants popping up here and there like mushrooms on some websites, in books and some international championships. Among them, the opinion of one person, who has a deep interest in Zen, is particularly interesting.

I almost fell off from my chair when he said that such happening shows that my sudoku variants are a great success and it should be viewed as a positive development. He said that my task is to make it “more positive” by thanking whoever is interested in my sudoku concepts and encouraging him to use more of my ideas, whether on websites or in books! He said that I cannot force others to advertise for me, but others cannot stop me from advertising myself . He said I can never stop others from using my ideas, and similarly others can never stop me from trying to get the maximum benefit out of the whole situation.

Now I am putting the advice of that “Zen master” into practice to see how successful it works.

First I have to thank http://www.sudokumasters.in for using my idea of “Twin Corresponding Sudoku” in its so-called “Substitution Twin Sudoku”.

… An article in http://www.notelay.com/articles/did_you_know/what_is_sudoku/ has this interesting comment about sudoku: “Because Sudoku is logic-based, other puzzles could be created that use the same concept and replace the numbers with other objects, such as colours, letters or shapes.”

I have used graphics, Chinese words and the alphabet for my Twin Corresponding Sudoku. Please refer to the following websites:

http://nrich.maths.org/public/viewer.php?obj_id=5518

http://www.ageofpuzzles.com/Collections/TwinSudokus/TwinSudokus.htm

http://www.chinasudoku.com/

I have to thank http://wsc2008.com for designing its so-called “Alphabet Substitution Twins”. Whatever name the “new” puzzle is called, it is still identical to my “Twin Corresponding Sudoku”.

Finally, I hope more people will use my sudoku ideas freely on their websites and in their books, but at the same time as the Chinese saying goes, “remember the source whenever you drink water”, so please don’t keep me totally out of your limelight.

- aman, on Phorum 5 (and elsewhere, evidently)

There ya go, Henry!

10 thoughts on “Printable Sudoku Puzzles Using Microsoft Excel

  1. Hi Mitch,

    Been browsing the net and i found your post. Actually it’s my first time to encounter this “Sudoku Puzzles”. As I read your post, I had this feeling to try it on my own too! ;)

    Thanks,

    • Hi Twitter Designs,

      Thanks for visiting my blog. I actually found that Google Docs is not the best way to store Sudoku.
      You might wish to download the spreadsheet to your PC.
      Have fun with it!

      Cheers,

      Mitch

    • Hi Ashok,

      I saw your comment a day ago and didn’t get around to commenting until today. Although I felt bad, when I logged in to my WordPress dashboard guess what I saw?
      Morpho Designs Printable Sudoku is at the top of page views!

      Thanks so much for sharing it with your Stumblicious self!

      Cheers,

      Mitch

  2. Hi Mitch. How’s your weekend?

    All subdomains of merschat.com have some connection to our (the Merschat) family. I’ve never been formally trained as a Programmer, but for some reason I enjoy it as a creative outlet and have picked up several languages over the years. So, whenever I set something up for a family member, I share it with the world. Sudoku puzzles were created for my mom who loves them. Although she has yet to solve my 36×36 monster. I recently had a baby, so that’s how the baby names section was born (he hee). My late grandmother liked word searches. And two of us practice tae kwon do. That’s the newest section.

    Steve Merschat

    • Hi Steve! Thanks for sharing your story. That’s very cool how the subdomains are family-related. I’ve never seen that before.
      I’ll be visiting soon to check out the Sudoku puzzles!

      Cheers,

      Mitch

    • Hi there MotorHomes. Thanks for visiting. I want to make the puzzles more symmetrical when hiding numbers. The random way of blanking them does not make it possible to determine how hard it is to solve. It’s not just a matter of the number of visible numbers. There has to be a limit to the amount of straight deduction you can use to solve a puzzle, because then it becomes a drudge. I don’t really understand of the x-wing stuff that serious solvers talk about.

      Cheers,

      Mitch

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


CommentLuv badge
This blog uses premium CommentLuv which allows you to put your keywords with your name if you have had 0 approved comments. Use your real name and then @ your keywords (maximum of 3)