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 […]
Blog
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: […]
A GUI World Weather App (Python)
This is another version (improved with GUI and better error handling) of a weather app in Python that shows weather and related information of any city in the world. This uses tkinter library for GUI and its grid system for precise layout. The Web Service We’ll use openweathermap.org’s web service, which is free. It requires […]
Air-quality GUI Application Using Webservices (Python)
This is a complete GUI application in Python to retrieve air quality information based on a zipcode (within USA). It utilizes the following concepts: Using tkinter library for GUI Calling a webservice Parsing JSON payload Formatting date and UI controls (input box, button, label, will dynamic updates) How to name your application title, attaching your […]
Twisted Magic Tales with Emojis – Fun, Free, Wonky!
I’ve written a story generator application that spews out stories differently every time it’s executed! I did this thinking of kids and family activities, while having nerdy fun on my end. This story generator creates a semi-random* story based on a skeleton storyline and changes the characters, objects, mood, locations, accessories and placeholders/keywords in the […]
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, […]
A complete weather app (Python)
Here, I show step-by-step a complete weather application built using Python. Along with the critical explanations, the full source code is also included. The app makes a RESTful API call to weather service, gets the results back in JSON, then it parses the information and presents it in locale-specific format. The information we will send […]
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 […]