Sunday, September 15, 2024

## Identifying double-bookings, scheduling conflicts

You’ve created a week’s schedule for your restaurant staff by day and shift (AM or PM). Next, you want a way fool-proof method to check if anyone is double-booked on any given day, and if so, who. Surely you can manually double-check and triple-check to make sure the schedule is exactly as planned but there […]

## Venn Diagrams (Python)

Venn diagrams are versatile and useful for a variety of purposes. Some common uses are: Visualizing Relationships: They illustrate the logical relationships between different sets. For example, they can show how different groups overlap and share common elements, and which don’t.Comparing and Contrasting: They are great for comparing and contrasting different items, ideas, or groups. […]

## Penalty Shootout Data and Presentation

One of the most thrilling games in the Euro 2024 was one of the quarterfinals between France and Portugal that was tied at 0-0 after the regular + extra time resulting in a penalty shootout. France won 5-3 in pks. I wanted to create a couple of dynamic charts based on some basic data from […]

## Paris Summer Olympics 2024 Stats

As the world eagerly watched the Paris Olympics 2024 from start to conclusion, I was fascinated by the amazing feats of the athletes from around the world. In this post, I present analysis of the performance of some nations and their athletes. You’ll find a collection of statistics, charts, and visualizations that highlight some key […]

## How to create Overlapping Charts in Excel

Sometimes a seemingly simple visual can be difficult to convey with a built-in Excel chart. I present here such an example. For instance, I will describe how and why to create an Overlapping Column Chart, aka 100% Overlapping Column Chart in Excel. It can also be turned into an Overlapping Bar chart. Say, we have […]

## How To Pick Rows Or Columns, And Combine Them With Other Functions For Powerful Uses. Part 2

In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: DROP(). In another blog, I discuss […]

## How to pick rows or columns, and combine them with other functions for powerful uses

In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: TAKE(). In the next blog, […]

## Euro 2024 Analyzed with Visuals

Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]

## Division, Floor Division (Python)

In Python, the single forward slash ‘/’ performs a floating-point division unless you’re using Python 2.x,in which case it performs an integer division with integer operands. The double forward slash //, on the other hand, forces a floor division operator which performs an integer division and returnsthe largest integer less than or equal to the […]

## GENETIC QUIRKS OF THE WORLD 2024

Here are some interesting facts (oddities?) from around the world and their associated visuals in Excel. Data source: worlpopulationreview.com Data rounded to nearest single decimal digit when applicable.