Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Category: Coding
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]
Windows 11 Boot MicroAnimation and Wise Monkey using just text
Recently, an ex-colleague of mine brought to our attention the Microsoft font possibly used in creating the spinning dots in Windows 11 boot screen. The font is called “Segoe Boot Semilight” and is a true type font. So, I had to verify that this is true, and I wanted to try to create the animation […]
Calculating Euclidean Distance in Python
Euclidean distance is the length of the line segment between two points in Euclidean space. It can be calculated from the Cartesian coordinates of the points using the Pythagorean theorem. It is a simple formula enough to be calculated by hand but powerful enough to be used in Machine Learning and Artificial Intelligence applications for […]
UPDATED: Find out more about your birthday
Sometime ago, I shared my code on how to determined the day of the week of someone’s birthday based on the DOB. You can check the original post here: http://flyingsalmon.net/which-day-were-you-born/Today, however, I am extending it a little further and also showing additional information about the birthday. For example:The key news/historical events of that day!What generation […]
Word Connect Game
Recently, the game on New York Times has been getting a lot of attention and generating much excitement by the readers. While I don’t subscribe to the newspaper, my friends shared the game screens with me which prompted me to ponder if I could create my version of this in Python. So, after a few […]
Population, Procreation Simulation (Python)
In this post, I share my design and code for simulating some propagating organisms (you can think of them as humans, other creatures, cells, objects, whatever you like) with certain rules. And although I have a couple of other variations of this made in C/C++ in the past, I wanted to do it in Python […]
Impressive Voice->Text AI tool
I came across this newest entrant to voice to text AI generation tool called AudioNotes. It converts your ‘random’/unstructured voice notes and unstructured text notes into structured text summaries using AI. Essentially, it’s a note-taking app that analyzes the voice notes and can generate many variations depending on the need. I decided to give it […]
Word definitions, synonyms, antonyms via RAPIDAPI
This program gets all definitions of a user-entered word from WORDS API service called RAPIDAPI. Once connected, the response is in JSON and we display the meanings neatly on screen as well as optionally write (append) the word and its meanings(s) and part-of-speech to a csv file. Demonstrates: 1) how to get word definition using […]
Extract sample subset with given criteria
How to load a subset of data from a full dataset with given percentages proportions by a column (“Group” in this example) plus how to import/export the Excel data file. Objective:We have n food items from 4 different groups: dairy, fruits, protein, vegetable in an XLSX sheet with a header and 3 columns: Name, Group, […]