This book reviews and explains different methods to generate and solve Sudoku puzzles with Excel VBA. The book is directed to Sudoku enthusiasts who have some knowledge of Microsoft Excel and basic VBA coding experience. It contains numerous macro examples to generate and solve Sudoku, rate the difficulty, and create UI components to play Sudoku in Excel. A workbook annex contains all the macros explained in the book and a few more.
Get it now for just $9.99
Delivery may take a few hours or land in your spam folder. Contact me if any issues: xlsgsdata@gmail.com
List of contents:
About
1. Introduction
1.1. Sudoku grid
1.2. Programing Sudoku in Excel
1.2.1. Referencing a worksheet
1.2.2. Referencing a range
1.2.3. Using loops
1.2.4. Worksheet functions
1.2.5. VBA functions
1.2.6. Variables
1.2.7. Arrays
2. Sudoku Grid Layout
2.1. Basic layout
2.2. Additional formatting
3. Generating Sudoku Puzzles
3.1. Incremental generation
3.2. Decremental generation
3.2.1. Adding numbers with a mathematical formula
3.2.2. Adding numbers to the grid randomly
3.2.3. Comparison of different methods to fill the grid
3.2.4. Remove numbers from the grid without a solver
3.2.5. Numbers that can not be removed
3.2.6. Remove numbers from the grid with a solver
4. Solving Sudoku Puzzles
4.1. Solving with simple logic
4.2. Solving with pencil marks
4.2.1. Grid of possibilities (pencil marks)
4.2.2. Solving naked singles
4.2.3. Finding hidden singles
4.2.4. Finding pairs, triples, and quads
4.2.5. Advanced techniques
4.3. Solving with brute force
4.4. Solving steps and process flow
5. Measuring the Difficulty of Sudoku Puzzles
5.1. Configuration of Sudoku puzzles
5.1.1. Distribution of given clues
5.1.2. Distribution of pencil marks
5.1.3. Relationship between clues and difficulty
5.2. Complexity of solving techniques
5.3. Rating difficulty with solving techniques
5.4. Rating difficulty with other methods
5.5. Excel macros to rate difficulty
6. Sudoku User Interface
6.1. User input
6.2. Highlight errors
6.3. Showing hints
6.4. Solving options
6.5. Timer
APPENDIX A: List of Macros
APPENDIX B: List of Puzzles and Solutions
List of Macros:
CreateLayout
AddIncrementalToRandomPositionInGrid
AddIncrementalToRandomPositionInBlock
AddAllNumbersToSheetWithFormula
ShuffleNumbersPreserveValidity
AddAllNumbersToSheetWithBruteForce
AddAllNumbersToSheetWithBacktracking
AddAllNumbersToArrayWithBruteForce
AddAllNumbersToArrayWithBacktracking
RemoveNumbersUniquePosition
RemoveRandomNumbersDualPosition
ListGroupsSwap2
ListGroupsSwap3
RemoveRandomNumbersInGrid
ReduceSingleCandidates
SolveSimpleLogic
GetCandidates
SolveSingleCandidates
FindHiddenSingles
FindNakedPairs
FindNakedTriples
FindNakedQuads
FindHiddenPairs
SolveXwing
GuessNumber
CompareSolutions
SolvePencilMarks
RateDifficulty
UpdateNumber
AddButtons
InputNumber
HighlightAllErrors
ShowHints
ClearHints
ResolveStepByStep
StartTimer
Other Information:
Presentation: eBook (digital copy)
Format: PDF + Excel macro-enabled workbook (.xlsm)
Size: 4,123 KB (PDF) + 162 KB (Excel workbook)
Created by (author): Excel Macro Mania
Created in (year): 2024
Number of pages: 155
Language: English
No comments:
Post a Comment