Challenge #75: Scrabble Word Finder

[Steven_Pocoroba2]

My solution attached

[danilang]

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

Spoiler

I went the macro route with an iterative macro (Combos) that generates all unique combinations of a certain length without replacement

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.

The main work flow manages the words, points and cleans up the hand before calling the standard macro and joining up for the results

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

Dan

[Gauthier_B]

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?

Spoiler

[Gauthier_B]

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?

Spoiler

[JoBen]

Cheers! This one was a lot of fun!

[Laurap1228]

I learned a lot about Regex in this challenge!

[pasccout]

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]

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

[kelly_gilbert]

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

Spoiler

Workflow:




Results: