Saturday, October 04, 2025
Coding Education STEM

Dynamic Listbox GUI demo using tkinter (Python)

I have been tinkering with the GUI library for Python called tkinter. There are some interesting features in it although I’m not thoroughly impressed by the API designs. It feels to me a little clunky and at times, work-in-progress or subject -to-change type of work. Nevertheless, I’m always curious and I had to explore. Specifically, […]

Read More
Coding STEM

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

Read More
Analytics Coding Education STEM

Tracking Actual vs. My Predictions 4/29/20

Back in March 2020, I did some predictive modeling using simple math and Excel where I presented 3 scenarios: Likely, Best-case, Worst-case. You can read the original blog here: What-If Models (COVID-19): Results Let’s take a look at today’s latest data from WHO and compare my Model 1: Likely Scenario numbers. We’ll compare the USA […]

Read More
Coding Education STEM

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

Read More
Analytics Break Coding Education STEM

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

Read More
Coding Education STEM

How many cats and dogs are there in your city? (method and cool charts)

In this seemingly simple couple of charts, I demonstrate a few nifty tricks that are fun and effective. First, we want to find out how many cats and dogs in a few selected cities (around me) and come with an educated estimate based on data. Then, we will use some cool, free add-in to create […]

Read More
Back To Top