There is an easy way to get the MRT train arrival time, particularly on the SMRT Train with Google Sheets.
Here are the steps you need to do:
Create Google Sheets account
Go to https://www.google.com/sheets/about and create the account.
Once your Google Sheets account is created, go to SG MRT Train Arrival Time Facebook page: https://www.facebook.com/sgmrtarrivaltime/ and get the updated link to its Google Sheets demo app.
At the time of writing is:
Click on that link, and you will be directed to the Google Sheets app
Google Sheets Demo App
Now you can select the MRT station code from the drop down list and click Run button. For this tutorial, I have selected “ Bedok (EW5)” station and clicked Run.
Here is the result from the ArrivalTime tab that I got.
If you notice carefully, I got the ‘Arrived’ status at platform B (second row — column G). You may not be able to get such details information from other existing apps.
What make us different with the existing apps/services?
The existing service or app in the market, only provide the timing information, like in the below screenshot. From us, we provide the information when the train has arrived.
Where to go beyond this ?
Google Sheets demo app is just a sample app that shows you how easy to get the train arrival information. You can easily implement the API with your favorite programming languages.
It is up to your imagination how do you want to process the information. You can build an alerting system with this information or doing some analytics.
I wrote a Python program to display the train arrival information on the mini LCD display with Raspberry Pi.
Here is the final app looks like. Hope you enjoy it!
Thank you and until next time :)