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 […]
Author: tony R.
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 […]
Some of my Haikus
You can follow my page on Instagram for up-to-date and complete haiku list, but here is a small collection of my haikus. Hope you like them 🙂 Follow me or check out my Instagram page where I post my latest and greatest Haikus: https://www.instagram.com/kiruku11/
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 […]
Some of my music mixes
Here are some quick experimental music compositions created with digital DAW and virtual instruments for fun and relaxation. These are specifically made short to go along with imaginary movie, flix or event scenes…use your imagination 🙂 These are hosted in BandLab for now (some were previously posted in Soundation which is also a great site […]
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 […]