Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving Sudoku with EXCEL
It is possible to use Excel to solve Sudoku.
I used mainly Excel Functions and just a little VBA to make it work. I just press one key and the answer comes up. It works for most of the puzzles from gentle to tough(categorized by LA Times). For the diabolical puzzle, it needs some more steps. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200801/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving Sudoku with EXCEL
This solves them
http://www.mrexcel.com/solveanysudoku.zip Mike "LynnI via OfficeKB.com" wrote: It is possible to use Excel to solve Sudoku. I used mainly Excel Functions and just a little VBA to make it work. I just press one key and the answer comes up. It works for most of the puzzles from gentle to tough(categorized by LA Times). For the diabolical puzzle, it needs some more steps. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200801/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving Sudoku with EXCEL
I have this spreadsheet that will do it, but it doesn't "solve" it,
just guess-and-check strategy. The upside of that over some "solving" algorithms out there, is that eventually, it will come up with a solution, whereas a solving algorithm isn't always guaranteed to do so. This version also has a delay time setting - a (woman) friend of mine said "yeah that's cool, but I can't see what's happening it's too fast!" so you can set it to a couple of milliseconds delay between trying the next iteration. Without delay, for tough puzzles it will take between 2 and 5 minutes to figure out a solution. There is a samples sheet that has some puzzles I found online, just copy/paste those into the grid. The code is quite simple, you can see it (all in the sudoku worksheet). It's basically a single recursive function that does everything, everything else is supplementary such as to check where row/column/block each thing is located. http://www.44lbs.net/ilia/061208sudoku_solver.xls FYI, I have never solved a sudoku in my life. On Jan 24, 1:26 am, "LynnI via OfficeKB.com" <u40849@uwe wrote: It is possible to use Excel to solve Sudoku. I used mainly Excel Functions and just a little VBA to make it work. I just press one key and the answer comes up. It works for most of the puzzles from gentle to tough(categorized by LA Times). For the diabolical puzzle, it needs some more steps. -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200801/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving Sudoku with EXCEL
Hi,
Your program is nice. I used totally different approach to to it. I actually used EXCEL to solve the puzzle. I did it just as the way I did it with pencil and paper. So my method is much faster than yours. However, I need to develop some way to do the trial and error for some really hard puzzle that I could not solve with my methods. ilia wrote: I have this spreadsheet that will do it, but it doesn't "solve" it, just guess-and-check strategy. The upside of that over some "solving" algorithms out there, is that eventually, it will come up with a solution, whereas a solving algorithm isn't always guaranteed to do so. This version also has a delay time setting - a (woman) friend of mine said "yeah that's cool, but I can't see what's happening it's too fast!" so you can set it to a couple of milliseconds delay between trying the next iteration. Without delay, for tough puzzles it will take between 2 and 5 minutes to figure out a solution. There is a samples sheet that has some puzzles I found online, just copy/paste those into the grid. The code is quite simple, you can see it (all in the sudoku worksheet). It's basically a single recursive function that does everything, everything else is supplementary such as to check where row/column/block each thing is located. http://www.44lbs.net/ilia/061208sudoku_solver.xls FYI, I have never solved a sudoku in my life. It is possible to use Excel to solve Sudoku. I used mainly Excel Functions and just a little VBA to make it work. I just [quoted text clipped - 4 lines] -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200801/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200801/1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solving Sudoku with EXCEL
This is a very good program to fill the blanks. However, if there is an error
in the puzzle, the program got stuck and could not stop early enough. Mike H wrote: This solves them http://www.mrexcel.com/solveanysudoku.zip Mike It is possible to use Excel to solve Sudoku. I used mainly Excel Functions and just a little VBA to make it work. I just press one key and the answer comes up. It works for most of the puzzles from gentle to tough(categorized by LA Times). For the diabolical puzzle, it needs some more steps. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200801/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sudoku hints | Excel Worksheet Functions | |||
Sudoku | Excel Discussion (Misc queries) | |||
Sudoku | Excel Discussion (Misc queries) | |||
solving equations using Excel | Excel Discussion (Misc queries) | |||
i've got a simple excel problem that needs solving... | Excel Discussion (Misc queries) |