I’ve been exploring whether it’s possible to create a birthday cake-style chart in Excel. After some adjustments, I’ve reached a point where I can confidently say it’s achievable! You may ask, why not simply download an image from the internet? Well, that’s less engaging, potentially unlawful, and above all, it lacks the customization and scalability […]
Tag: education
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]
Windows 11 Boot MicroAnimation and Wise Monkey using just text
Recently, an ex-colleague of mine brought to our attention the Microsoft font possibly used in creating the spinning dots in Windows 11 boot screen. The font is called “Segoe Boot Semilight” and is a true type font. So, I had to verify that this is true, and I wanted to try to create the animation […]
Creating Quizes and Surveys in Microsoft Forms
With the latest release of Microsoft Forms, creating a quiz, survey, or essentially any type of form for free using either work or personal account has never been easier. There are different ways to share the survey too such as emailing; and it’ll even help you write the invite or via Teams to anyone or […]
Finding min, max in a sequence and plotting the distances
Let’s say that we have a sequence of numbers in consisting of whole numbers, fractions, positive and negative numbers of varying length, that is, of no predefined length (e.g.2.25, 5.25, 6.75, 8.25, 9.75…). What we want to do is to sort the numbers in ascending order, and find the differences between 2 adjacent numbers and […]
Electoral Votes by State/Jurisdiction
With the presidential election sneaking up fast, I thought it’d be good to get the latest electoral numbers by all states and District of Columbia based on the most recent census. So, here’s a map chart I created based on the published data. TIP: Use your mouse wheel while holding down Ctrl key on your […]
Calculating Euclidean Distance in Python
Euclidean distance is the length of the line segment between two points in Euclidean space. It can be calculated from the Cartesian coordinates of the points using the Pythagorean theorem. It is a simple formula enough to be calculated by hand but powerful enough to be used in Machine Learning and Artificial Intelligence applications for […]
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 […]
UPDATED: Find out more about your birthday
Sometime ago, I shared my code on how to determined the day of the week of someone’s birthday based on the DOB. You can check the original post here: https://flyingsalmon.net/which-day-were-you-born/Today, however, I am extending it a little further and also showing additional information about the birthday. For example:The key news/historical events of that day!What generation […]