Has anyone come up with an efficient was to approach or accomplis
Soduko solutions using excel? Hope this not considered frivolous
L. Howard Kittle - 13 Jun 2006 03:10 GMT
Probably considered frivolous in a few circles... <vbg>
I did my own version of a solver, (which does not do any deductive
reasoning... if that is a real word???), but merely takes out the numbers in
the rows or squares if there is a clue or a "decided" number of that row or
square. Then I go to work on the puzzle with my reasoning.
On the no brainers puzzles, my solver can go to a puzzle conclusion by just
clicking the "Auto - Sift" button as many times as it takes to run through
the puzzle and make all the necessary eliminations. The Evil ones I have to
do a bunch of work.
A former poster on the Soduko puzzle offered up his solver, (and he said it
was his first macro he had written) and it solved the four or five puzzles I
threw to it. I looked to see the code and it was not available, hidden or
whatever. Poked around on the sheet and gave up. But his solver waltzed
through the puzzles in a matter of several seconds.
I think I still have it if interested.
lhkittle@comcast.net
HTH
Regards,
Howard
> Has anyone come up with an efficient was to approach or accomplish
> Soduko solutions using excel? Hope this not considered frivolous!
Peo Sjoblom - 13 Jun 2006 03:16 GMT
Here are 2 workbooks you can download, one is using VBA and one is using
formulas with circular references
http://andypope.info/fun/sudoku.htm
http://office.microsoft.com/en-us/templates/TC100809721033.aspx

Signature
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
> Has anyone come up with an efficient was to approach or accomplish
> Soduko solutions using excel? Hope this not considered frivolous!
MartinW - 13 Jun 2006 08:32 GMT
Hi knowtrump,
Do a google search for Sudoku solver and you'll find hundreds of 'em.
Regards
Martin
Paul Lautman - 13 Jun 2006 09:00 GMT
> Has anyone come up with an efficient was to approach or accomplish
> Soduko solutions using excel? Hope this not considered frivolous!
Somewhere I have a javascript web page that solve's them all
Ed - 13 Jun 2006 14:58 GMT
I made my own Soduko solving program for two reasons: (a) it is making me
learn programming methods I wouldn't touch otherwise, and (b) my teenage
daughter can look at a Master's puzzle and see the complete solution, and
this was the only way I could maintain my male superiority! (Not
happening - I have a wife and two teenage daughters - I'm outvoted the
minute I walk in the door!)
Basically I fill in the known squares, fill in all the blank squares with
1-9, then run through the range and delete numbers until it's solved. For
the harder ones, you also have to look at conditions (such as pairs in the
same row of the same square) that give you clues to the rest of the puzzle.
Ed
> Has anyone come up with an efficient was to approach or accomplish
> Soduko solutions using excel? Hope this not considered frivolous!
Marcus Fox - 13 Jun 2006 16:09 GMT
> Has anyone come up with an efficient was to approach or accomplish
> Soduko solutions using excel? Hope this not considered frivolous!
I was looking for something similar, In Excel I have a grid sized 36 x 36,
and this grid is subdivided into 36 6 x 6 boxes. What I would like to do is
auto fill the grid randomly with the characters A-Z and 0-9. However, in
each row and in each column, each character will appear only once. In
addition, each character will appear only once in each 6 x 6 box. Sort of
like a giant Sudoku puzzle. Couldn't figure how to get it to work though.
Marcus
Michael Bednarek - 14 Jun 2006 13:45 GMT
>Has anyone come up with an efficient was to approach or accomplish
>Soduko solutions using excel? Hope this not considered frivolous!
Some time ago, I came across David Ireland's effort at
<http://www.di-mgt.com.au/sudoku.html> which had some success in solving
Sudoku puzzles, but Andy Pope's workbook seems better.

Signature
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"