Wednesday, July 17, 2024

# Blog

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

## GENETIC QUIRKS OF THE WORLD 2024

Here are some interesting facts (oddities?) from around the world and their associated visuals in Excel. Data source: worlpopulationreview.com Data rounded to nearest single decimal digit when applicable.

## How to parse json data from a restaurant

In this blog post, I’ll show you a real-life example of a restaurant menu encoded as a JSON file and how you can parse in your app, and subsequently display it in your custom UI as desired. Suppose you have a menu of items with details encoded in JSON format that looks like this: This […]

## Generate Bar Codes, QR Codes in Excel: Quick & Easy Way

In this post, I’ll show you a quick, easy, and a free method that you can use today to generate QR codes, bar codes in UPC-A, UPC-E formats, and custom bar codes based on the product information you enter in Excel as text. How it works Two things are at play here that make it […]

## How to calculate streaks in Excel

Streaks refer to trends in the data. These can be linear, exponential, damped, seasonal, irregular/random, stationary, or cyclical. Streaks are important for several reasons: There isn’t any built-in function in Excel for calculating streaks, but there different ways we can make Excel do some of that heavy-lifting by using a combination of functions such as […]

## What’s Your Chart Signature? Graphing a name in Excel

Have you ever wondered: how does my name look like if plotted in Excel? Well, wonder no more. In this post, I’ll show you how to enter any name (or any string of characters) and plot it in dynamically to make your unique name come alive as a chart. To make it fully dynamic, I […]