Soduko

K

knowtrump

Has anyone come up with an efficient was to approach or accomplis
Soduko solutions using excel? Hope this not considered frivolous
 
L

L. Howard Kittle

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.
[email protected]

HTH
Regards,
Howard
 
M

MartinW

Hi knowtrump,

Do a google search for Sudoku solver and you'll find hundreds of 'em.

Regards
Martin
 
P

Paul Lautman

knowtrump said:
Has anyone come up with an efficient was to approach or accomplish
Soduko solutions using excel? Hope this not considered frivolous!
Click to expand...

Somewhere I have a javascript web page that solve's them all
 
E

Ed

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
 
M

Marcus Fox

knowtrump said:
Has anyone come up with an efficient was to approach or accomplish
Soduko solutions using excel? Hope this not considered frivolous!
Click to expand...

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
 
Top