This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Congrats @SeanAdams on your new shiny badge!
Climbing to the summit alone however could lead to a dangerous selfie situation. Hopefully your team will catch you soon.
Thank you Mark!
I'm eagerly awaiting your 350 solutions milestone - that's the true definition of a peak that will be difficult for anyone else to scale! @MarqueeCrew
Not too long now until Inspire EU!
Forgot to upload this last week, haven't done the bonus rounds yet. Prepped the letters beforehand (except the casing).
My approach. Since I wasn't able to jump on this quickly to win the first 75th badge, decided to take my time and work towards developing a Scrabble word app (which will let you include letters already on the board). Not there yet, but almost. Congratulations to everyone, with a special shout out to @SeanAdams, @NicoleJohnson, @LordNeilLord, and so many others who have contributed to our collective success in these challenges!!!!
Took a similar approach to many at the start, and then went a little macro-crazy. Started with cleaning up the word list to include words that are only 7 characters long (since the objective is a high scoring first word). Wrote the output to a yxdb for fastest processing.
Also cleaned up the letters/points/number tiles and wrote that output to a yxdb too.
Here's where I diverge. Then I designed a few macros:
This one generates all possible words from the letters in the hand:
This one generates point values per word:
This one generates possible words, taking into account one or two blank tiles:
And finally, my workflow that uses all of these macros:
Hopefully I packaged all of my macros with the workflow. When the app is finished, I'll post it too!
Think I found a reasonably elegant solution using only 16 tools that do all three cases.
Also went further and created an app where you input your own letters (0 or more including repeats) and the number of blanks (with the choice of whether or not blanks have value). See attachment.
Not being a RegEx expert I wanted to figure out if I could do this the old-fashioned way: raw inexperience. And I did. This is, to an Alteryx Ace, probably an example of terribly inefficient workflow development. But what the hey? It works and I understand every step.
This doesn't run in sub-1 second times, either, but 1.4 seconds ain't bad.
The most fun was writing the step-by-step, letter-by-letter checks for each word between 2-7 letters long in the "Finding matches based on word length" Tool Container.
Alteryx is quite simply the most fun I've had coding in a long time.
That is a beautiful solution. Now, all we have to do is set up a secret data transmission system that can allow us to participate in and win the Scrabble world championships! Of course, I'm kidding because we are not cheaters, but I bet there are plenty of unscrupulous people out there that would love to take the chance. Thanks for sharing this because I really enjoyed the quality of the solution, the awesome documentation, and layout.