Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #200: Sudoku Solver

nini
8 - Asteroid

My solutions for Beginner and Intermediate:

Greg_Murray
12 - Quasar

Solution attached

danilang
19 - Altair
19 - Altair

Beginner and Intermediate.  Now if only I could solve them in my head, like Lord Vetinari.

200px-Lord_Vetinari.jpg

 

Spoiler
w.png

Dan

dombaikamilla
8 - Asteroid
Spoiler
Beginner and Intermediate Solutions200.PNG
Blake
12 - Quasar

All set on the advanced solution. I put my iterative macro/data cleansing in a standard macro to keep the canvas clean. Fun challenge! 

Spoiler
Top LevelTop Level


standard macro.png


Iterative macro gutsIterative macro guts


salima
5 - Atom

Beginner Level,

 

Spoiler
salima_0-1580228718656.png
carlosteixeira
15 - Aurora
15 - Aurora

Here my solution Beginner and Intermediate.

 

Beginner

Spoiler
carlosteixeira2005_0-1580231871709.png

Intermediate

 

Spoiler
carlosteixeira2005_1-1580231918117.png
Carlos A Teixeira
JORGE4900
8 - Asteroid

I completed the beginner solution yesterday; here is the intermediate one today. Fun challenge. The basic idea is to add 45 on all rows and columns; this would ensure that the numbers 1-9 are only being used once per box.

 

First generate the possible solutions by row or record ID; then find the unique number not already used on other solutions and plug it in.

 

By the way, I was blown away with the macros and R snippets solving the advanced one; I always enjoy looking at your workflows.

Spoiler
2020-01-28_11-30-30.jpg
JustinBabbitt
Alteryx
Alteryx

Beginner and Intermediate solutions attached

Spoiler
JustinBabbittEAG_0-1580243070128.png
Macro: 
JustinBabbittEAG_1-1580243134688.png
Justin Babbitt
sonyakasenkramer
8 - Asteroid

I built a solver for the advanced challenge, and used it for the intermediate. But more importantly: I built a working macro!! 

Spoiler
sonyakasenkramer_0-1580247623035.pngsonyakasenkramer_1-1580247637920.png