To me, Index and Match functions combined is so much better than VLookUp. But sometimes, that fact is better kept to myself rather than trying to convert others. Saves me a lot of headache.
Please, don’t get me started on XLOOKUP. Compatibility issues is a serious concern.
So, are you Team Index and Match or Team VLookUp?
We have our salaries paid through our Security Bank accounts. Since I keep funds in my accounts with other banks, I need to do fund transfers now and then. And Instapay for Security Bank would have really helped.
Today I discovered that Fund Transfer to Other banks via Instapay functionality is already added to the Security Bank mobile apps.
Apparently, this functionality is available only on Android and iOS apps, but not in the web using your favorite internet browser. Nevertheless, this is a welcome development, especially now that GCash disabled cash-in via bank cards starting July 6, 2020.
Currently, as the whole nation is still technically on lockdown, all fees for Instapay transfers for all banks, including Security Bank, are waived. When things go back to normal, this fee schedule indicates that fees range from ₱10 to ₱50 among the different Philippine banks. Security Bank in particular will charge ₱15 per transaction, which is I would say is not too steep. I would argue that would be a cost worth paying for the convenience of not waiting some 30 minutes should you need to visit a branch of your bank.
Update: Read: Security Bank InstaPay Temporarily Unavailable
I know I have my gripes against YNAB, but after several months of using a different system, I do appreciate how YNAB prepares you for the unexpected with its virtual envelope budgeting.
I guess I have to start saving up for YNAB subscription.
It seems like when users are getting more dependent on a service, these service providers are doing everything to milk its users. And they’re doing it in the most annoying way.
Take for example, Viber:
That’s for their desktop app. In the phone app, there appears to be a setting to turn off Birthday push notifications of your contacts. But not in the desktop app.
How in the world did Viber get a hold of contacts’ birthdays in the first place? Now it’s shoving it to our faces!
Too bad I only play NBA 2K.
If you keep annoying me with unsolicited and irrelevant SMS text messages, regardless of whether I opted for them earlier or not, this is where you belong:
Welcome to my SMS blacklist folder! Thanks to Pulse SMS for this functionality.
There used to be a plugin that seamlessly synchronized Plex library and watch history with Trakt.tv. Unfortunately, Plex discontinued the plugins feature, and thus leaving its loyal customers, even paying ones, in the dark. Yes, plugins still work, but I don’t think this particular plugin will still work in a fresh instance of Plex.
Of course, there’s the Plex scrobbler made by Trakt, which utilizes the Plex’s Webhooks, but that you need to have a Trakt VIP account to use this. Don’t get me wrong, Trakt is a great service, but I’m not paying $30 per year just for this scrobbler. They already have the vast users’ personal, movies and TV shows preferences and collections information, those should already pay for the experience. They just need to be creative in order to monetize them.
There are also python scripts, but documentations are so poor, it’s not worth learning python just for that.
There’s a webhook, but it seems to do one way sync only (Plex to Trakt).
So, my questions are why:
These are the questions that are painfully outstanding. Hopefully, in the near future, we’re not anymore dependent on Trakt.
Update: I have made PlexTraktSync work for my system. This required a little bit of work, installing Docker and running commands in the terminal, but I’m glad it’s working now. Read more about it here.
Have you encountered installing Microsoft Outlook in your fresh Windows 10 install, only to find it too resource hog for your use case, and thus installing Thunderbird, Mailbird, or any other email client that’s a lot less load to your computer’s meager resources?
Of course, you changed your system settings so that the default email app will be your new email client, just as below:
Apparently, this settings only affects clicks on MAILTO links. Continue reading How to truly change the default email client in Windows 10
I bought this Omni Model AEL-010 from Ace Hardware awhile back. It has been sitting in my living room for a while now. I can’t totally recall when exactly I bought this nor the Ace Hardware branch I purchased it from, not the actual price I paid it for. But it’s been a while — it could have been 6 months, it might even have been a year.
Now, in preparation for the for Typhoon Tisoy, I tried recharging this OMNI LED Emergency Light. Plugged it to the wall socket for like 8 hours. But when I unplugged and tested, it won’t turn on now.
It turns on fine while plugged, but not when I unplug. Thus, I searched around about this product. And this is the revelation about this good Omni Emergency Light: Continue reading How Omni Misleads and Defrauds Customers
As soon as the iPhone 11 series of iPhones hit the shelves in September, rumors about the next iPhones hit the rumor mill, like the new offerings don’t at all tickle the fancy of most people, the normal iPhone users and tech bloggers (and vloggers) alike. After all, except for the triple rear camera configuration, not much has changed in the design department from the previous iPhone.
MacRumors suggests there will still remain 3 varieties of the iPhone next year, and following this year’s naming convention, they’ll be called the iPhone 12, 12 Pro, and 12 Pro Max, shunning away from the S-intermediary name.
iMore is saying Apple might bring back the metal frame just like that in the iPhone 4. That metal frame is iconic. I used to own an iPhone 4, and I loved it. I would have kept using that phone if not for its outdated specs.
According to SBD, there is a good chance that the new iPhone generation brings in a 3D camera. I wonder if Apple will once again lead the innovation in the smartphone arena with this feature, if ever this comes to fruition.
Of course, we can’t ignore the obvious — 5G connectivity. Telcos might not be ready with the widespread connectivity given their current infrastructure, but Apple wouldn’t want to wait that long to keep in line.
For me, though, I liked the idea of a metal frame iPhone. Also, what kept the iPhone ahead of its competition in the past, in my opinion, is the idea of One iPhone to rule them all. I mean, if you get an iPhone, you get the iPhone. If you’re a little short in your budget, you get the older earlier versions.
Lastly, the price. It’s hard for me to stomach paying for a phone for more than $1,000. With how the market received the iPhone 11 series prices, as reflected in their sales figure, Apple should know better next time.