Here’s a basic application in Excel I put together for fun that gives information about a birth date. For example, which day of the week was the person born? What’s the zodiac sign? The zodiac symbol for the person, and also a direct link to a web site to find his/her horoscope information (including daily […]
Blog
Let’s play with all the presidents (Excel)-Part2
This is Part 2 of the blog Let’s play with all the presidents (Excel)-Part1. Please read Part 1 there first to follow along. To find the zodiac sign of a president we need to map his month and day portion of his birthday to a table that map the month and day to a zodiac. […]
Let’s play with all the presidents (Excel)-Part1
Specifically, we’re going to start with the most basic data about US Presidents, and “play” with them to extract some more meaningful, interesting tidbits. Along the way, you’ll learn how to: Recognize, and deal with unprintable characters Shape raw (unruly string) data for analytics Find trends Make interactive charts and tables Use fuzzy logic and […]
Destroying Dr. T’s max base
A short clip recorded on my Android phone (no audio*) of a gameplay where I destroy Dr. T’s based at stage 6 (the max) and its level is 60. My level is 56. The battle time-limit is 4m and I finish this with 45 seconds left. The game is Boom Beach. Enjoy! For more topics […]
Another fun game and win vs AI (Chess)
Pay attention to the trade-offs: How the AI cornered me and I eventually tricked it to give up its Queen while it predicted it’d get a new one anyway…which I prevented. Also, the timing of my castling was vital in order to get the upper hand and do the checkmate.
800LB Gorilla (humor)
ADD vs ADHD (humor)
With apologies to myself 😉
A basic spin-slot game in…Excel??
With Excel’s toolbox of thousands of formulas and VBA support, it’s not out of question to be able to create games although it’s not designed for that purpose. However, not for the sake of playing, rather for experimentation and learning, I decided to present a simple form of a spin game. Game Rules Have 2 […]
Ranked, custom charts and animation (Excel)
In this blog, I share how to use simple data, and create some meaningful charts, even with animation and custom graphics. Along the way, I’ll demonstrate techniques to rank and spark some ideas on PowerPoint<->Excel interaction. Let’s start with the dataset. Following are the responses from a survey of 1,002 consumers from a couple of […]
Beating Level 5 AI (Chess)
In a “noisy” all-out attack by the AI, backed up into my own back line, I saw the opportunity with 1 move, but had to prepare for that final move by keeping the AI busy while fending off its checks. But I found it and it was soon over 🙂