Below is a 10-day weather report for Seattle in Excel using external data connections. The following is the live embedded sheet (however, online Excel does NOT support external data connections in the browser…yet). To get the data to refresh, just save the file locally or click Open in Desktop App button along the top of […]
Blog
Yeah, I use it for ‘research’!
That’s Lean!
Happy Friday (the 13th!). Have you ever wondered…?
If you’re anything like me, you’ve at least once wondered: How can I get Excel to show me all the Friday-13ths in any given year? Well, I have (don’t ask me why)…and here’s the solution. I found a couple of ideas on how to do this, but my method I believe, is the most straight-forward […]
About your birthday and more (Excel)
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 […]
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.