Smart GIGA Pro Out! GOMO is the way to go!

In these new Giga packages of Smart, you’ll be allocated 3GB per day, and they expire, well, as often as, every day! Whether you like it or not, you’ll be forced to consume that much data in a day, otherwise you can bid them goodbye anyway.

In real life, however, we don’t stop, we GOMO! For P299, you’ll have 25GB of data that never expire. If you really are a heavy user, you’ll actually find this expensive, as this translates to ~P1,200 for 100GB, vs. Smart’s 114GB for ~P1,000. But really, don’t you bump into slack days when you’d wish you could hold on to some of your data?

We’re not even talking here yet about the much cheaper call and text rates should you opt to convert some of your GOMO data to text and/or call minutes.

So, unless Smart could find a way to compete to what GOMO offers, Globe will surely be the winner here.

How to Use Power Query to Pull Data from a CloudFlare Protected Website

I run Microsoft Excel’s Power Query daily in order to pull data from the BAP website for the USD/PHP rates for the day, which in turn I save in an Airtable database as a record for that day.

This week, however, it seems that BAP has implemented CloudFlare DDoS Protection, which helps it to combat DDoS attacks. Good for BAP, they can minimize what we’ve experienced downtimes in the past. Bad for me, now I’m getting 503 error in my query.

So how do we deal with this in Power Query? A quick Google search yields not much of a result. There’s one posted in June 2017 on Mr. Excel forum, 3 years and no one bothered with an answer.

Continue reading “How to Use Power Query to Pull Data from a CloudFlare Protected Website”

Can I use the GOMO Sim in a Pocket Wifi?

GOMO is so far the only cellular service that offer 25GB for ₱299 and that don’t expire. But is the sim only usable in a smartphone? Can I also stick it into a pocket wifi or a prepaid home wifi, to enjoy the unexpiring data?

I was looking for the answer around the web, but couldn’t find any. So I hit them up on Twitter, and here’s what I got:

So yes, you can use the GOMO Sim in a pocket wifi, Globe at Home Prepaid Wifi, or any unlocked/open-line wifi router device, only that you have to activate the sim first in a mobile phone (Android or iOS/iPhone) app.

Adobe just ruined its reputation to me

I was just trying to take Adobe Acrobat Reader DC for a spin, availed of the free trial, which by the way I found to be total crap — so no use to me! It was a 1.2GB piece of crap!

Then Adobe installed a 502MB worth of Adobe Creative Cloud Desktop for me, without even my consent!

Who the hell cares about Adobe Creative Cloud? It even added a stupid shortcut in the Navigation pane in Windows File Explorer (under Quick Access).

Adobe is a joke! I’m not paying them anything! They’re a scam, fraud, con artist, swindler — errr, wait let me check my dictionary for what more bad things to describe Adobe.

Everyone, stay away from this stupid company.

Sometimes it pays to keep Index and Match to yourself

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?

Instapay now available in Security Bank mobile app

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.

 

Security Bank transfer to other banks
Security Bank transfer to other banks via Instapay.

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