![]() Yet my model is very inferior to expert puzzlers like clm. It also shows the power of the human brain: all brain cells work parallel, and if some thousands of braincells were connected the same way as in my model, our brain would solve the puzzle in a millisecond. People like to see this and show themselves astonished. Our human brain processes information much the same way. Blocks of cells containing equivalent formulae process a certain analysis of the puzzle, like revealing hidden pairs. Set up & solve large word problems in Microsoft Excel How To: Work with array formulas in Microsoft. So you can clearly see how information flows though the model. In this MS Excel tutorial from ExcelIsFun, the 242nd installment in their series of digital spreadsheet magic tricks, youll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation. You can have Excel drawing arrows to source cells or to target cells. I am working on a second version that will have actual games in it that you can randomly play. "I didn't know this was possible in Excel!" "Why don't we learn this at school!!" Here is a link to a spreadsheet that I created to solve Sudoku puzzles. I love to see the wide open eyes of graduated persons when I explain the inner working of my model. To experience this, the only way is to try it yourself! There are many sorts of challenges creating a working model solving puzzles fully automatically with the least amount of programming code. Why would anyone want or need a solver for any puzzles on this site? Maybe to learn how to have more success at solving (and then not need them anymore). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |