Sudoku in Excel: Intersection Methods

Programs which generate, solve, and analyze Sudoku puzzles

Sudoku in Excel: Intersection Methods

Postby swaatacba » Thu Feb 06, 2020 1:47 pm

Excel's two dimensional environment isn't naturally suited to analyzing Sudoku methods. The Intersection Methods seem particularly tricky. This blog article discusses how I approached the problem.

https://logiccomppeople.blogspot.com/2020/01/sudoku-in-excel-intersection-methods.html
swaatacba
 
Posts: 49
Joined: 09 February 2017

Re: Sudoku in Excel: Intersection Methods

Postby tarek » Thu Feb 06, 2020 2:21 pm

Hi swaatacba,

Well done for documenting your thoughts & how you handled this problem.

I programmed several sudoku/variant solvers in the past.

I can see how it can be tricky if you don't use any macros but if you are then I would find using the word tricky too strong.

This technique has been coded in several languages by several people so many times and you'll find it in virtually every solver. Some even include it to enhance performance of their brute force solvers under certain conditions.

tarek
User avatar
tarek
 
Posts: 3759
Joined: 05 January 2006

Re: Sudoku in Excel: Intersection Methods

Postby swaatacba » Thu Feb 06, 2020 5:43 pm

Hi Tarek

The idea of employing a spreadsheet is to expose the processes used in the Intersection Methods.

It would defeat the point of using the spreadsheet if I subsequently used VBA (or any other programming language) to get the answer behind the scenes.

Thank you for taking a look.

Stephen
swaatacba
 
Posts: 49
Joined: 09 February 2017


Return to Software