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 #75: Scrabble Word Finder

Steven_Pocoroba2
8 - Asteroid

My solution attached

danilang
19 - Altair
19 - Altair

Definitely a tough one!  A lot of thought went into building that little ScrabbleTiles.png

 

Spoiler
I went the macro route with an iterative macro (Combos) that generates all unique combinations of a certain length without replacement
Combos
This is then wrapped by a standard macro (ScrabbleTiles) that takes the output of the combos macro and maps the letters of the hand to these combos.
ScrabbleTiles
The main work flow manages the words, points and cleans up the hand before calling the standard macro and joining up for the results

Main


I've included the iterative macro separately since it doesn't seem to be have been added to the package

 

Dan

Gauthier_B
8 - Asteroid

Not a very elegant solution at all that I have decided to hide in a macro.

But hey, it's working and the process makes sense (at least to me :D)

 

Not sure the spoiler will help any.

One question remains... What is a qoph?

 

challenge 102 screen.PNG

Spoiler
Macro Challenge 102.PNG

 

Gauthier_B
8 - Asteroid

Not a very elegant solution at all that I have decided to hide in a macro.

But hey, it's working and the process makes sense (at least to me :D)

 

Not sure the spoiler will help any.

One question remains... What is a qoph?

 

challenge 102 screen.PNG

Spoiler
Macro Challenge 102.PNG

 

JoBen
11 - Bolide

Cheers! This one was a lot of fun!

Laurap1228
11 - Bolide

I learned a lot about Regex in this challenge!

CHarrison
8 - Asteroid
 
pasccout
8 - Asteroid

Here is my solution... it works...  Only issue... extremely slow... not sure what I did wrong with my macros...

 

I also tested with blanks with a limited data set and it looks good...

 

The filter was to work with a subset of records...

justynam
8 - Asteroid

This one was fun - my favorite so far :-) !

I have quick and simple solution, with just one small additional macro to calculate point for letters in hand

 

Spoiler
New Picture (9).jpg
kelly_gilbert
13 - Pulsar

I'm sure there is a more elegant way to solve this, but my RegEx skills are not up to the task!

 

Spoiler
Workflow:

challenge_75_workflow.png


Results:

challenge_75_results.PNG