This is a seemingly useless but visually fun usage of visuals, combined with Excel functions and VBA I did to take a break from my typical gnarly Excel analytics work 🙂 How it works: 1. Fill in a formula to generate random numbers between 1 and 100 (inclusive) across the cell range. 2. Apply 2 […]
Author: tony R.
A simple dataset with many questions (and answers!)
I’ll start with a simple dataset and demonstrate how many critical questions can arise just from this. You can now imagine in a real-world situation, how many more complex questions can be asked and information gleaned! But if we can’t extract the key answers from this table, we won’t be able to tackle even the […]
Simple & brilliant way to extract multiple matches in one cell
 The scenario: You have a dataset with values in one column that’s unique (or semi-unique) and another column with its associated values as Key:Value pairs but that column has repeating values. Imagine a list of members whose names are in one column and their corresponding membership status next to it as below: What we […]
How many real days…net? (Excel)
This is one of the simple and yet powerful tips when working with Dates in Excel. To calculate the number of workdays between two dates BUT EXCLUDING weekends (depending on your locale settings), we can use NETWORKDAYS(). In US and most western countries, Saturdays and Sundays would be excluded from the calculation. Without changing your […]
Defending base against Hammerman’s 4th attack
This is a short game play recording of me defending against Hammerman’s 4th wave of attack and losing. The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is very refined, simple, yet […]
Defending base against Hammerman’s 3rd attack
This is a short game play recording of me defending against Hammerman’s 3rd wave of attack and winning. The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is very refined, simple, yet […]
Phone number formatting tips (Excel and Python)
For most people working with data for a significant amount of time, formatting raw data from different sources are both a reality and a pain. Today, I show different ways to format an un-formatted string that contains phone numbers using Python, and Excel. Our task is to format it (either for human-reporting, or consumption by […]
Searching online (Google) with Python
In this blog, I demonstrate how to run a Google query from a Python app extremely easily. The harder part is just the set up and knowing what to install. So, let’s start with the set up details: You’ll need to install the following packages IN ORDER: 1) beautifulsoup4 2) google NOTE: The package to […]
Most brilliant people to know in the computing world
Here’s a list of some legendary programmers/tech-minds of the computing industry to-date. More brilliant minds will surface I’m sure, but if you know these names, you covered most of the critical people. Of these great people, I’ve had the pleasure to meet in person Bill Gates and Sir Tim Berners-Lee during my tenure at Microsoft. […]
Beating Dr. T at his highest level
This is a game play recording of me beating Dr. T at his highest level 60 (available for my current level 56). The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is […]