Position
Byte
1
0
Position <= 80
Position + 1
Create 81 rows per quiz
Calculate row & column, extract cell
Row = FLOOR([Position]/9)
Col = Mod([Position], 9)
Region = FLOOR([Row]/3) * 3 +...
Simple
Cell
=
0
[Cell] = "0"
quizzes
CellCandidate
Byte
1
1
CellCandidate <= 9
CellCandidate + 1
Make candidate values
Remove candidates based on same row
Remove candidates based on same column
Remove candidates based on same region
Warning
All
ByName
Concatenate Solution
Count solutions by position
Simple
Count
>
1
[Count] > 1
quizzes
000000190230000600000240000000000960000160070048070000001093425009008000006005800
Simple
solutions
Contains
0
Contains([solutions],"0")
partialsolutions
solutions
quizzes - Ascending
Position - Ascending
[quizzes] != [solutions]
Custom
Prevent infinite loops
[quizzes] != [solutions]
Warning
All
ByName
Count solutions by row
Simple
Count
>
1
[Count] > 1
Count solutions by column
Simple
Count
>
1
[Count] > 1
Simple
Count
>
1
[Count] > 1
Count solutions by region
Unique: quizzes, Position
Add unknown cells back in
Warning
All
ByName
Horizontal
Question
Macro Input (18)
Question
Macro Output (20)
Question
Macro Output (21)
challenge_200_iterative_macro
Tab
Questions
Tab (1)
MacroInput
Macro Input (18)
Macro Input (18)
MacroOutput
Macro Output (20)
Macro Output (20)
MacroOutput
Macro Output (20)
Macro Output (21)
Macro
quizzes
Error
AllSame