Imagine we are business owners who provide a range of services. We have a large set of customer data but we really want to target those customers who might be interested in your services. We want to extract only that subset of data based on our services. And since we provide multiple, diverse services the […]
Blog
Updated Story Download Page (FREE)
Here’s an updated online commerce page about Twisted Magic Tales with Emojis. Direct link to it This is a secure site from where you can download the ebook (with 7 stories, generated by Rob Deborot, the robot) for free as a PDF. When you click “I want this!” button, be sure to enter 0 (the […]
Simple and accurate credit payoff calculator
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 […]
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 […]