View previous topic :: View next topic |
Author |
Message |
| lars-petersson
| Joined: 17 Nov 2005 | Posts: 1 | : | Location: New York City | Items |
|
Posted: Fri Nov 18, 2005 1:11 am Post subject: I'm looking to solve Sudoku in Excel using Excel Solver or.. |
|
|
..alternatively the Excel Premium Solver.
So would need a spreadsheet set up accordingly with the restrictions, and the settings for the solver tool. Restrictions seem doable, but how to tell the solver to only use integer numbers, or integers from 1 to 9. This is what I so far failed to do.
Did anybody do it already? Is it available on the web somewhere?
Thanks,
Lars |
|
Back to top |
|
|
| Puzzled
| Joined: 18 Nov 2005 | Posts: 2 | : | | Items |
|
Posted: Fri Nov 18, 2005 9:36 pm Post subject: Re: I'm looking to solve Sudoku in Excel using Excel Solver |
|
|
lars-petersson wrote: | ..alternatively the Excel Premium Solver.
So would need a spreadsheet set up accordingly with the restrictions, and the settings for the solver tool. Restrictions seem doable, but how to tell the solver to only use integer numbers, or integers from 1 to 9. This is what I so far failed to do.
Did anybody do it already? Is it available on the web somewhere?
Thanks,
Lars | In the Solver you can select as a constraint that a cell be integer, <= 9 and >= 1. That means three constraints per cell. |
|
Back to top |
|
|
| LarryS
| Joined: 02 Jan 2006 | Posts: 1 | : | | Items |
|
Posted: Tue Jan 03, 2006 1:47 am Post subject: Sudoku Excel Solver |
|
|
I have developed an Excel-based Sudoku puzzle solver. I did it using formulas (logic) only. Macros are not used to solve the puzzle. Furthermore, formulas are constructed using a single formula in each section of the solver. This ensures accuracy.
Any way for me to attach this file for others to see? |
|
Back to top |
|
|
|