It’s back and it’s better…now includes more updated, focused, and curated list of movie titles. Read more about it here (includes basic instructions + technical information on how it’s done start to finish). Or, you can simply go ahead and use the app directly by clicking here.
Category: STEM
Finding target values with constraints
In this post, I share an example of a very common challenge in business which is complex to solve just by hand, along with the easy solutions. The Scenario: Let’s start with the scenario. We have a bakery that bakes 4 items that sell at our pre-determined prices as shown below: Cost (each) Bun $3.00 […]
How to get exact color values and convert them
In this post, I’ll show you how to get exact RGB colors from an image and then freely convert them to Hex, and from Hex to RGB depending on your needs, whether it’s for CSS or for your application interface. Being a 12th man of the Seattle Seahawks, I’ll naturally start with the Seahawks logo. […]
Write your own program to use ChatGPT
With OPENAI’s ChatGPT being open to the public, it is now easy and possible to harness the incredible power of LLM like ChatGPT using any language of your choice. The good folks at OpenAI has good API documentations and handout free API keys to anyone who is interested. The free account allows you to use […]
How to become UNBEATABLE in word games
The app that makes you invincible in virtually all word games! With this app, you never have to toil away your time trying to unscramble a set of letters to form those words of specific lengths that’s just alluding you today! You just run it, enter the letters you have been handed (in a game of […]
Finding a missing number in a sequence
Imagine having a list of thousands of numbers in a sequence that is supposed to be sequential (incrementing by one) and somewhere there’s a number missing. That number could be an ID or some required piece of information. Also, what if the sequence is not incrementing by one but by some other number (e.g. by […]
Understanding Excel’s Handling of Dates
If you’ve ever dealt with time series data in spreadsheets, you must have noticed that Excel internally uses unique serial numbers for date values. In this Q-TIP (stands for Quick-Tip), I’ll show you the internal calculation of how it’s done…date to serial number, back from serial number to date using formulas instead of using the […]
Animating Charts in Excel and beyond
Some time ago I demonstrated how to create Time-lapse animations in Excel in my post here. Part of that procedure utilized a short-lived but cool feature called ‘PowerView’. Unfortunately, as of late 2021, Microsoft has removed support for PowerView in Excel (that made this time-lapse animation possible) and instead is encouraging users to use PowerBI […]
Splitting a continuous blob of text
There are times we copy a bunch of text from a web page or a trascript online where formatting is not copied and therefore everything copied comes in the clipboard as a large continuous text blob without line breaks. We often need to split a continous series of sentences into their individual lines for better […]
Creating iCalender files (Events)
In my previous blog, I shared how to read an existing event file in iCalendar format (commonly with ICS extension). Be sure to read that before continuing. Here, I’ll show you how to create one from scratch. Let’s support we want an event that is:starting on feb 09, 2023 at 1pm and ending at 2pm […]