User Profile
tauqeeracma
Iron Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: An Excel-Based Game
Hi Aplhajohnny Thank you so much for your thoughtful words. I am glad you enjoyed it. This project has been fun to work on. It’s amazing how a tool like Excel, often associated with data and analysis, can also be leveraged for creative and engaging purposes. I firmly believe that the creative possibilities with Microsoft Excel are limitless. Your support means a great deal to me and is a powerful motivator to continue exploring and experimenting with fresh ideas. Your belief in my efforts inspires me to push boundaries and think creatively. As soon as I can free up some time from my other ongoing projects, I will focus on finalizing the computer-versus-player version. Once it's complete, I will make sure to share it here on this platform for everyone to try out. I see myself as a lifelong learner and enjoy following the insights of experts and respected members on this amazing platform. Meanwhile, feel free to explore my other two Excel projects—I’m confident you’ll find them enjoyable too! Thanks again for your support. Tauqeer Wordle with Excel Solver | Microsoft Community Hub An Excel-Based Spelling Bee Puzzle | Microsoft Community Hub Please note that the previously shared game model has a minor linking issue. Kindly use the revised file, ‘Four in a Row (Corrected)’, for seamless gameplay.Re: Wordle with Excel Solver
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 GameRe: Help on Power Query Merging
Hi Mei_Jiang_Wu With the help of Power Query(PQ), you can easily merge all of your five tables. Since you can only merge two tables at a time in PQ, you need at least four steps: 1. Using the Name column, merge Table 3 with Table 1 and give it a name as Course_1&3. 2. Using the Email column, merge Course_1&3 with Table 4 and name as Course_1&3&4. 3. Using the ID column, merge Table 5 with Table 2 and name as Course_2. 4. Using the Email column, merge Course_2 with Course_1&3&4 and name it All_Courses. Points to note: I assume that all of your tables have information for all students, so use Inner as Join kind. For simplicity purposes, use the "Merge Queries as New" option. Please let me know if it works for you. Thanks TauqeerRe: Seleccionar el valor mas antiguo en una tabla dinamica
Hola a7024782 Siempre que comprenda su requisito, puede usar la función MIN() para filtrar la cantidad más antigua. Consulte el archivo de muestra adjunto para obtener más información. Espero que te ayude. Por favor, dígame si le funciona. Gracias TauqeerRe: Change horizontal data to vertical (no transpose)
Hi zaomoni Power Query is the best option for such data transformations. You can use the Transpose feature in the power query to change the orientation of your data. Click on the POWER QUERY tab in your Excel file then click From Table/Range: It will open the power query window. Go to Transform Tab and click Transpose. I hope I will help you. Please let me know if it works for you. Thanks TauqeerRe: An Excel-Based Spelling Bee Puzzle
Hi dunkindonuts Many thanks for your comments and appreciation. That would be a brilliant idea to formulate the WereWords puzzle in Excel. I am sure of much learning potential in it. Thanks for sharing the relevant links to the game. I will add it to my agenda for future projects. Regards, TauqeerAn Excel-Based Spelling Bee Puzzle
Formulating scenarios and logic in Excel is always exciting and worth learning. I am pleased to share an Excel version of another famous word puzzle game. Spelling Bee is a word game published daily by the New York Times (NYT). This Excel-based Spelling Bee puzzle is built in a conventional Excel version that attempts to simulate the same users’ experience. This Excel model can be a good practicing tool for the admirers of the puzzle. They can do the unlimited practice that would be off-line too. The objective of designing this model is to explore learning opportunities and find alternate modeling approaches. In my future post, I will share the same model built in Office365 and analyze the improvement in efficiency and ease of making logic using dynamic arrays. Therefore, comments and feedback from the expert members of the community will be of great value. The model is designed in two parts. In the first part, a list of seven unique letter words is identified and for the sake of simplicity, this portion of transformational work is not included in the model. Over seven thousand unique combinations of 7 letters have been used that decreases the possibility of a repeated word in a new game. Players can start a new game by inputting a randomly generated number. Previously inputted words must also be deleted before proceeding with a new game. The puzzle challenges players to form words using a set of seven letters. The objective is to create as many words as possible. The puzzle has a straightforward scoring system. At a minimum, a word must have at least four letters. Four letters will get one point. Starting with five-letter words, players receive one point per letter. Players receive an extra seven points for making a Pangram. The pangram is when players use all seven given letters in one word. Vocabulary Used I have referred to the Collins Scrabble Word (CSW-19) to download valid words having a length of four or more letters. The CSW dictionary has over 278K words that I have filtered out to 57K because the model's performance becomes extremely slow with more words. Have also tried to remove the maximum offensive/obscure/hyphenated words. Solver Mode With slight changes, players can also use this model as a puzzle-solver for the NYT Spelling Bee quiz. But in that case, users may notice some differences in the solution published by the Spelling Bee (NYT) and the list of possible words generated by the model. The reason being the Spelling Bee (NYT) has its own separately curated word list that is not accessible. Thanks TauqeerRe: Power Query Connectors missing?
Hi, TomTomas You may use a workaround that will hopefully allow you to add the different data connectors. Go to File > Options > Customize Ribbon > Select 'All Commands' in the left table. Create a new Tab in the right table, and rename it as per your preferences. Then while selecting the new Tab, find the desired command (connectors) in the left table. Press Add>> button. Please let me know if it works for you. Thanks TauqeerRe: Fill with custom list.
Hi Silvia755 The quick workaround for your requirement is to keep your Names in a separate column and use another column to write the additional text. Finally, you may combine both columns using CONCATENATE() or TEXTJOIN() functions to get the desired result. See the sample file. Hope it will help. Thanks TauqeerRe: Fill with custom list.
HI Silvia755 Assume you have a list of names in column A You can define the custom list by following the below steps: File > Option > Advanced > General > Edit Custom List > NEW LIST > Link the range > Import > OK Once you have defined the list, open a new excel workbook, just write any name from the list and simply drag it. The fill function will auto-generate the custom list. Hope it will help. Thanks TauqeerRe: Conditional SUM
Hi Saad_Khalil In that case, I think the best option is to put the calculation option as "Manual" and uncheck the 'Recalculate workbook before saving' option as mentioned below: Update your table as you like, and change the values. The total of the table will remain the same. Whenever you want to refresh your table, simply press the F9 key. Please ensure that the option is set again as "Automatic" for other excel workbooks. Thanks TauqeerRe: Conditional SUM
Hi Saad_Khalil As per my understanding, you need a calculation in which you want to sum the values after each interval of an hour. To achieve the requirements, you can use the NOW() function. Based on the above, I have made the attached sample file. Let's assume you have defined the hour's intervals in column B and amounts in column C. To accomplish the desired results, you also need a starting time as a reference point that you will input in cell C4. You can either manually input the starting time or copy it from C1 and paste it as values into C4. =IF(NUMBERVALUE(TEXT(NOW(),"HH:MM:SS"))>(NUMBERVALUE($C$4)+NUMBERVALUE(TIME(B8,0,0))),(D7+C8),0) It is pertinent to note that since the NOW() function displays the current time, it, therefore, needs calculations to be refreshed. So please always press F9 before you take the results from column D. Hope it will help. Please check the attached sample file and let me know if it works for you. Thanks Tauqeer
