fbpx
Search
Close this search box.

All articles with 'games' Tag

Solve Sudoku Puzzles using Excel [because it is weekend]

Published on Oct 23, 2009 in VBA Macros
Solve Sudoku Puzzles using Excel [because it is weekend]

Sanjay, my colleague is an avid programmer and excel enthusiast. In his spare time he wrote a small VBA macro to solve Sudoku. Sudoku is a very famous number based puzzle with a 9×9 grid of cells. Each of the 9 rows, columns and 3×3 blocks should be filled in such a way that they have all the numbers from 1 to 9. Sudoku is a very effective way to keep your brain cells ticking. I am a huge sudoku fan and I solve sudoku whenever I have few minutes to kill. So naturally I jumped with joy when I saw Sanjay’s excel macro for solving sudoku. He is kind enough to let me share this with all of you.

Continue »

Excel Links of The Week – Malmo Edition

Published on Mar 23, 2009 in excel links

In this week’s excel links learn how to make bingo cards, make your random numbers unique and prepare your data for charting and much more…

Continue »

5 Awesome Info-graphics for your Inspiration [Dec 19]

Published on Dec 19, 2008 in Cool Infographics & Data Visualizations
5 Awesome Info-graphics for your Inspiration [Dec 19]

Every week PHD features 5 of the most beautiful and awesome visualizations seen on the web for your inspiration and amusement. These charts explore and present data in creative ways and provide new ideas. Browse past visualizations for inspiration and fun.

Continue »

Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Published on Oct 3, 2008 in Learn Excel, simulation
Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Ever since we moved to Seattle we have been watching TV game show – Deal or No Deal (for lack of better things to do in the hotel) The game provides an interesting look at human nature and risk taking abilities. People who wouldn’t risk their retirement savings or jobs would go to these game […]

Continue »

Simulating Dice throws – the correct way to do it in excel

Published on Aug 13, 2008 in Learn Excel, simulation

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if […]

Continue »

Bingo / Housie Ticket Generator in Excel

Published on Jul 16, 2008 in Analytics, Learn Excel
Bingo / Housie Ticket Generator in Excel

I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why whenever I get sometime I experiment with simulating games to know them better. So, out of curiosity I have created an excel sheet that can generate bingo / housie (housey) tickets – 24 of them at a time. To get new set of tickets you would hit F9 (recalculate).

Continue »