« Data Validation: Drop down lists | Main | Creating a 2-D Lookup Table »
January 06, 2006
A Sudoku Solver!
I have been wanting to do this for the longest time - ever since I became aware of this puzzle last year. So for the past week, I've been busy putting together this spreadsheet that will assist you with solving a Sudoku puzzle.Anyway, three days and 900 formulae later, I present... ooo_sodoku.
This is not a push-button solver. Perhaps the next version will allow that. Basically, for each square in the solution grid, the solver will determine all the possible values - saving you a lot of the drudge work associated with these puzzles.
As you manually enter the values in the solution grid - top left, the main grid in the center will display one of three colors for each square. Light blue indicates that square already filled in solution grid. Green indicates only one possible value - which has yet to be entered in the solution grid, and brown indicates more than one solution
Your comments, encouragement and feedback are always welcome. As I said earlier, there are 900+ formulae here - so bugs are possible.
Download this utility here
Posted by Dave at January 6, 2006 06:37 PM
Comments
WOW!
This is awesome!
I love Sudoku!
Thanks a billioN!
Posted by: Chad Smith at January 6, 2006 07:57 PM
Very nice.
Thanks
Posted by: John at January 6, 2006 10:16 PM
You must be from the USA, only a yank would want/need help with Sudoku! Only jesting - don't set GWB on me please.
Great! Very useful gadget.
Posted by: Bill at January 7, 2006 09:21 AM
Actually, I'm Irish - but living in USA. :)
Posted by: Dave at January 7, 2006 12:04 PM
If only everyone who needs help with Sudoku would be able to make a tool like this... ;-)
Posted by: Michaël at January 7, 2006 02:02 PM
A wonderful effort in providing a ready made formulae in solving SU DOKU
A nerve racking puzzle
Many thanks
Vic Byrne from Australia
Posted by: vic byrne at February 3, 2006 05:22 PM
you are my hero............
Posted by: Anon at March 20, 2006 09:35 PM
Very nice blog!Respect you!Added to favorites!
Posted by: Alex at March 27, 2006 03:44 PM