This is built in Excel that shows how long it’ll take you to pay off a loan at a given interest, and also how much in total you’ll end up paying over the period until the loan is completely paid off. Additionally, you can simple visuals. To enter the required loan information as shown in […]
Tag: Excel
A Horse-race Simulation with a “Strip Plot”
Strip plots, or a dot plot horizontally spread out are very useful in certain cases. I’d use it to show spread or concentration of data points across multiple categories. For example, in order to visualize between brand A, and B, what are their product sales (or prices) and where they appear to focus. What the […]
Analyzing 10 Years of Patriots Performance: NFL
Love em or hate em, New England Patriots is a team to reckon with. They’ve implemented numerous creative and suspicious internal strategies that most other teams would love to copy or at least understand. Well, I cannot expose those details as they’re not available anywhere. What is available however is their scores and stats. So, […]
Re-creating Maslow’s Hierarchy of Needs in Excel
Intro Maslow’s hierarchy of needs is a theory in psychology proposed by Abraham Maslow in his 1943 paper “A Theory of Human Motivation” in Psychological Review. You can read more about it here. You have most likely have seen many depictions of his theory as a pyramid of “needs”. A typical one looks like this: […]
Parsing date-time string and formatting according to AM/PM (Excel)
Here’s a relatively quick way to parse a date-time string or any string (regardless of data type in your source) containing date and/or time. It doesn’t matter if the time format is in 12 or 24 hour format, this method works. The time portion of the data can be in HH:MM:SS or HH:MM or similar […]
A quick holidays & events calendar (Excel)
A no-frills demonstration (with actual, real data) of building and publishing a calendar of holidays/events in the United States. Covers 2020 through 2023 and includes major religious, political, and federal events and holidays as a quick reference. Below is the dynamic, real-time version: For interactive tables, visualizations, tips, demos and more, please explore this blog: […]
Generating, plotting trajectory and…gamification (Excel)
Reminiscing the old tank game, I wanted to re-create a low-weight, low-code option of that simulation. The game depended on a canon (projectile) shot at your selected speed and angle to hit an enemy tank. The foundational formula is used in missile launch, sports, and many (you guessed it) military applications. Here, using the same […]
Selected movies: searchable, sort-able for utility and fun
Today, I present a web application with a list of selected movies (about 3,000 titles) I extracted using developer APIs from IMDB and OMDB databases using my Python app. After extraction in the app, I reshape the data according to my needs and then export programmatically to XLSX format (for Excel). Which is then wrapped […]
What-if Models (COVID-19): Results
Here are the results of the four models that I had created to get results of What-If scenarios around COVID-19 (“corona”) virus using the data on hand as published officially as of 3/20/2020. Since we don’t have all the answers or even data for many variables, I hypothesized in such instances. For explanation of my […]
Why Pareto? Using 80/20 rule in the real-world.
The Pareto principle states that about 80% of the effects come from 20% of the causes in many real-world events. You can use this to, say, identify 80% of your best-selling categories, or conversely the worst performing categories/items. The uses are limitless, really. And they don’t have to be only about $$$. Graphically, it’s a […]