Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #239: SEND + MORE = MONEY

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found heresendmore.png

 

For this week's challenge, we will use Designer to solve/prove a classic verbal arithmetic problem. In this case, each letter in the equation "SEND + MORE = MONEY" will have a unique value between 0 and 9. Your job is to find the solution that makes the equation true.

atcodedog05
22 - Nova
22 - Nova

Fun challenge reminds me of the deciphering challenge.

 

Spoiler
Keys
atcodedog05_0-1603717833304.png

Workflow: to find keys

atcodedog05_1-1603717869370.png
Finding:
atcodedog05_0-1603718765939.png

Output:

atcodedog05_2-1603717898084.png

 

Cheers and Happy Analyzing 🙂 

Aaron_Harter
11 - Bolide

Relationships are a lot like algebra...You look at your X and wonder Y.

Spoiler
239.1.PNG

 (edit 10/26 11:33 CT) video of solution overview:

Spoiler
Sashikumar
8 - Asteroid

Good one . 

Spoiler
ch239.PNG
dsmdavid
11 - Bolide

There are certainly smarter ways of tackling this than this brute-force approach...

Spoiler
dsmdavid_0-1603725105554.png

Used Python to generate the permutations as I find it easier than having a nested macro here.

But there are more potential solutions (or I am misunderstanding something)

Spoiler
Problem
2817 + 0368 = 03185
2819 + 0368 = 03187
3712 + 0467 = 04179
3719 + 0457 = 04176
3821 + 0468 = 04289
3829 + 0458 = 04287
5731 + 0647 = 06378
5732 + 0647 = 06379
5849 + 0638 = 06487
6415 + 0734 = 07149
6419 + 0724 = 07143
6524 + 0735 = 07259
6851 + 0738 = 07589
6853 + 0728 = 07581
7316 + 0823 = 08139
7429 + 0814 = 08243
7531 + 0825 = 08356
7534 + 0825 = 08359
7539 + 0815 = 08354
7643 + 0826 = 08469
7649 + 0816 = 08465
8324 + 0913 = 09237
8432 + 0914 = 09346
8542 + 0915 = 09457
9567 + 1085 = 10652

Edit: Ok, following the link in the description of the problem  

 the leading digit of a multi-digit number must not be zero

Oh well...

AkimasaKajitani
17 - Castor
17 - Castor

I used a brute-force approach to make the workflow. But it takes too long time. It is not useful workflow.

I added only two conditions that are immediately turning out.

 

Spoiler

Condition
1. "m" and "s" is not Zero
2. "m" equal One

It takes for 6 minutes 27 seconds.

 
file1.png

file3.png



 
file2.png

Maybe I'll be back to make efficient workflow.

RolandSchubert
16 - Nebula
16 - Nebula

Real fun. Used a kind of "smart brute force" reducing the number of possible solutions step by step.

 

Spoiler
239.png
JennyMartin
9 - Comet
Spoiler
AWC239.PNG

I am not proud of this brute force solution at all! Looking forward to seeing more elegant solutions. Video solution here: https://www.youtube.com/watch?v=D1MkKk31kDE&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=43&t=9s 

OllieClarke
15 - Aurora
15 - Aurora

Tricky challenge!

Spoiler
I spent a while trying to generate the permutations needed in Alteryx without appending 8 times, but in the end went with a python library that I remember @PhilipMannering using.
Challenge 239.PNG
patrick_digan
17 - Castor
17 - Castor

Great challenge. I successfully reinvented the wheel.

Spoiler
WorkflowWorkflow

 

Macro to create all combinations/reinvent wheelMacro to create all combinations/reinvent wheel