We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
17 - Castor

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
skumar_31
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
14 - Magnetar

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
15 - Aurora
15 - Aurora

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 

Find the challenge here:https://community.alteryx.com/t5/Weekly-Challenge/Challenge-239-SEND-MORE-MONEY/td-p/655912
OllieClarke
13 - Pulsar
13 - Pulsar

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
16 - Nebula
16 - Nebula

Great challenge. I successfully reinvented the wheel.

Spoiler
WorkflowWorkflow

 

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