Forum Discussion

tauqeeracma's avatar
tauqeeracma
Steel Contributor
Mar 09, 2022

Wordle with Excel Solver

Amid the plenty of solutions and techniques that are coming for the newly viral word-puzzle game Wordle. I have also tried to make an excel-based solution for the puzzle. Because, being an excel enthusiast, I believe that Excel provides more flexibility and customization power than other analytical and problem-solving tools.

 

The primary aim of sharing the solution with the respected members of this excellent community is to have different logic and alternative solving approaches that would surely provide some learning opportunities. The element of interest for the members is to model an approach that would produce more close and accurate guesses.

 

For this solver, I have got inspiration from Mr. Robert Gascon, who occasionally demonstrates excellent features of traditional excel. Therefore the solver is a non-VBA / non-CSE model and does not require the 365 version of Excel. Thoughtful comments, especially from Mr. Robert Gascon Twifoo  and Mr. Sergei Baklan SergeiBaklan about alternate solving approaches will be valuable.

 

The solution of two real games along with the solution strategy is also attached for reference purposes.

 

Thanks

Tauqeer

11 Replies

  • John_lodu's avatar
    John_lodu
    Copper Contributor

    Hey tauqeeracma,

                        I just wanted to say how awesome your Wordle game using Excel Solver is! It's amazing how you turned something like Excel, which most people use for work stuff, into a fun and clever game. It really shows how creative and skilled you are, thinking of a unique way to mix problem-solving and gaming.

    Huge respect for your effort—it’s not every day you see someone come up with something like this! I’m sure it’s inspiring to a lot of people, and I can't wait to see what other cool projects you come up with next. I was playing this game on Wordle Unlimited.

    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor

      Hi John_lodu,

      Thank you so much for your kind words! I really appreciate it. I'm glad to hear you enjoyed the Excel Solver Wordle game—it's been a fun project to work on. It’s great to know that something as simple as Excel can be used in creative ways, and I'm happy that it resonated with you.

      Your encouragement means a lot, and it definitely motivates me to keep experimenting with new ideas.

      I always consider myself a learner and try to follow the other experts and respected members on this wonderful platform. In the meantime, feel free to check out my two other Excel projects—I’m sure you’ll enjoy them as well.

      Thanks again for your support!

      >>>> Spelling Bee Puzzle
      >>>> An Excel-Based Game

      • mtarler's avatar
        mtarler
        Silver Contributor

        tauqeeracma  First, very impressive and cool !!

        In the attached I did 2 small ideas:

        a) for the suggested word I decreased the point value for words with repeated letters to increase chance of suggested words not having repeated letters.  In example 1 it makes improvements.

        b) for input I created a new option for word input: a) type whole word and then B) type hint letters as capital for correct location and lower case for correct but in wrong location.  I just thought this might be an easier input idea.

         

        When I have time I might look at other parts too.  Should we look at how this project would look using dynamic array functions?

Resources