Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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