Sunday, March 03, 2024

## Projecting Neocaridina Shrimp Population

Two months ago I wrote an app for myself to keep track of my new hobby Neocaridina Shrimpkeeping. It was only 2 weeks before that I started the hobby before I recognized that a handy application to keep track of my shrimp’s water parameters, treatments and care with curated, accurate information would be very useful. […]

## 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 […]

## Early gambler’s prediction of Super Bowl winner for 2023 season

Here are the probabilities of each team winning the Super Bowl according to the betting odds from Caesars Sportsbook as of September 6, 2022: As you can see, the Buffalo Bills had the highest probability of winning the Super Bowl according to the betting odds, followed by the Tampa Bay Buccaneers and the Green Bay Packers, who […]

## Football is ON! Interesting NFL stats (2023 season)

Are you a fan of NFL (American Football)? Do you want to know the odds of your favorite team making the playoffs this season? Well, you are in luck, because we have some amazing stats for you. Based on the historical data from the past 23 seasons, here is what we found: But what about […]

## Impressive Voice->Text AI tool

I came across this newest entrant to voice to text AI generation tool called AudioNotes. It converts your ‘random’/unstructured voice notes and unstructured text notes into structured text summaries using AI. Essentially, it’s a note-taking app that analyzes the voice notes and can generate many variations depending on the need. I decided to give it […]

## 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, […]

## 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 […]