I wanted a way to generate an automatic but unique code or password without it being easily back-traceable and collision-proof. i.e. each time it is executed, it must generate a unique universal ID, aka UUID. Additionally, that code or password must be 8 characters long and must contain a combination of letters and numbers and […]
Category: STEM
How to create Overlapping Charts in Excel
Sometimes a seemingly simple visual can be difficult to convey with a built-in Excel chart. I present here such an example. For instance, I will describe how and why to create an Overlapping Column Chart, aka 100% Overlapping Column Chart in Excel. It can also be turned into an Overlapping Bar chart. Say, we have […]
How To Pick Rows Or Columns, And Combine Them With Other Functions For Powerful Uses. Part 2
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: DROP(). In another blog, I discuss […]
How to pick rows or columns, and combine them with other functions for powerful uses
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: TAKE(). In the next blog, […]
Euro 2024 Analyzed with Visuals
Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]
Saving output from Turtle as an image (Python)
Saving output from the turtle module in Python involves a few unique steps compared to other libraries. The turtle module primarily uses the Tkinter canvas to render graphics, and saving these drawings typically requires converting the canvas to a PostScript file using the postscript() method. This file can then be converted to more common image […]
Given 4 numbers and a resulting number, create the equation to solve
You’re given four numbers and a result. You are supposed to create an equation with those four numbers that yield that given/desired result. Easy enough. Yeah, right! That’s the kind of puzzles some newspapers are running to challenge the readers as in Epoch Times et al. This is commonly referred to as the 4Numbers game. […]
Customizing Windows desktop wallpaper automatically, on schedule (Python)
With a little programming know-how, you can write your own dynamic Windows wallpaper app that can change its color to whatever color you want, to a random color that your app chose for you for the day, or set to your photos, images on a rotating basis or randomly picked from a list from your […]
How to convert a standard date format <-> Excel date serial number
You may already know that all date type values in Excel are converted to a serial number in Excel. This is an effective way to store date because not only do the digits take less space, it can be calculated upon for all sorts of date maths such as finding difference in days, months, years, […]
Division, Floor Division (Python)
In Python, the single forward slash ‘/’ performs a floating-point division unless you’re using Python 2.x,in which case it performs an integer division with integer operands. The double forward slash //, on the other hand, forces a floor division operator which performs an integer division and returnsthe largest integer less than or equal to the […]