Sunday, March 03, 2024

## All About NFL’s Top Heach Coaches

I dug some information on some of the 32 head coaches in NFL today, and did some analayses. I was intrigued by their performance, compensation, their roots, their network and influence, correlations among various parameters like age, experience, wins, and salary. I also looked at how many teams they’ve coached in the past, and how […]

## Republican Candidates’ Primaries Spend 2024

The campaign trails are blazing for the upcoming elections and the Republican party still needs to narrow their final nominee down to one in the coming months. Niki Haley and Donald Trump are the only two remaining runners (written: Jan 25, 2024). Below are some charts I created to show how much they’ve spent on […]

## How to chart ranges in Excel

Let’s say you have some actual measurements of some parameter over time or a series, and you’re measuring it to see if it falls within the “safe” or “ideal” range. How can you create a visualization to show both the measurements and the safe/idea range values effectively? That’s what I’m going to answer in this […]

## How to create visualizations in Excel given nested scores

Here’s the scenario:We have two players named Eve and Inna in a game competition (say, Tennis). They play 5 matches against each other, and each match is composed of 3 games called Sets.We have data on scores of the players set by set for all 5 matches.So, the question is: How do we present this […]

## Word definitions, synonyms, antonyms via RAPIDAPI

This program gets all definitions of a user-entered word from WORDS API service called RAPIDAPI. Once connected, the response is in JSON and we display the meanings neatly on screen as well as optionally write (append) the word and its meanings(s) and part-of-speech to a csv file. Demonstrates: 1) how to get word definition using […]

## Extract sample subset with given criteria

How to load a subset of data from a full dataset with given percentages proportions by a column (“Group” in this example) plus how to import/export the Excel data file. Objective:We have n food items from 4 different groups: dairy, fruits, protein, vegetable in an XLSX sheet with a header and 3 columns: Name, Group, […]

## Movies Searchable Database Webapp is Back

It’s back and it’s better…now includes more updated, focused, and curated list of movie titles. Read more about it here (includes basic instructions + technical information on how it’s done start to finish). Or, you can simply go ahead and use the app by clicking here directly.

## Finding target values with constraints

In this post, I share an example of a very common challenge in business which is complex to solve just by hand, along with the easy solutions. The Scenario: Let’s start with the scenario. We have a bakery that bakes 4 items that sell at our pre-determined prices as shown below: Cost (each) Bun \$3.00 […]

## Finding a missing number in a sequence

Imagine having a list of thousands of numbers in a sequence that is supposed to be sequential (incrementing by one) and somewhere there’s a number missing. That number could be an ID or some required piece of information. Also, what if the sequence is not incrementing by one but by some other number (e.g. by […]

## Animating Charts in Excel and beyond

Some time ago I demonstrated how to create Time-lapse animations in Excel in my post here. Part of that procedure utilized a short-lived but cool feature called ‘PowerView’. Unfortunately, as of late 2021, Microsoft has removed support for PowerView in Excel (that made this time-lapse animation possible) and instead is encouraging users to use PowerBI […]