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.

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 #240: Every Vote Counts!

Lorenz0
6 - Meteoroid

A nice challenge! I solved it with an iterative macro and only basic tools, eager to look now at your more sophisticated solutions.

 

Spoiler
challenge_240.PNG

 

JP_SDAK
8 - Asteroid

I'm working towards my advanced certification and trying to get practice with iteration macros.  I have a programming background but can't quite seem to get the hang of how they exit. 

I got this one to work, but I think it's kind of clunky.  If anyone can explain a better way to iterate/exit I would appreciate it!   I updated this to use the CrewTest expect equals tool instead of Test tool.  I realized I had configured it wrong, so went for easier option.

 

Spoiler

 

Workflow:


JP_SDAK_0-1604528783516.png

 


Macro:
 
Capture.JPG

 

gmoores
6 - Meteoroid

Tiny iterative macro; cute challenge!

TonyA
Alteryx
Alteryx

This one took longer than it should because I misread the instructions and built a beautiful macro to solve an entirely different problem. Fortunately I was able to adapt it to the real problem -- a great example of how workflows are much easier to refactor than code or spreadsheet programs.

Spoiler
2020-11-04_17-35-59.png

2020-11-04_17-35-25.png

T_Willins
13 - Pulsar
13 - Pulsar

Fun Challenge.  Easier than the other iterative macro I had to build this week.

 

Spoiler
Iterative MacroIterative Macro

 

WorkflowWorkflow

 

mike_w
8 - Asteroid

this was some good practice for iterative Macros. Don't use it often so I keep forgetting details of the setup and configuration, but always happy for a refresher. 

Spoiler
mike_w_0-1604628955173.png


Iterative Macro: 

mike_w_1-1604629014902.png

 

 

collinalldata
7 - Meteor

That was really fun to figure out!

 

Workflow:

Spoiler
collinalldata_0-1604663064553.png

 

Macro:

Spoiler
collinalldata_1-1604663100465.png

 

ehughes
9 - Comet

My solution

Spoiler
Img 240.png

Img 240 - macro.png

NurulShi12
8 - Asteroid

I'd vote for the winning flavor as well 🙂

enwiegand
7 - Meteor

Wow I really struggled with this one. I did figure out how to do it manually, but I wanted to get the macro to work as I need some practice with macros. My macro didn't stop iterating when it got to the "true" condition - does anyone have tips on that?