The New Sudoku Players' Forum

[swaatacba]

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

[tarek]

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

[swaatacba]

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