Greetings Humans
Welcome to my personal webpage where I try to document what I found useful during my day-to-day work in Universiti Teknologi Malaysia and what I randomly come across in the Internet. Feel free to leave any comment and get in touch with me. Hope you found something useful among my random rambling posts.
Enjoy!
Royal Rambles
Optical Character Recognition (OCR)
One of the frustrating thing when we are handling PDF document is that sometime we would not be able to select, copy and paste the content of that pdf. This is because the content of the pdf was not properly OCR-ed (Optical Character Recognition). Whenever we are...
Section navigation based on selection in Google Form
We often use Google Form to create a quick & efficient registration form of some sort. Google Form does not only provide easy navigation to the users (participants) but also provides various function to the administrators, particularly the ability to export every...
Trimming whitespaces in Excel
More often than not, whenever we extract data from our databases (MySQL, ORACLE, etc.), perhaps due to some missing pre or post processing, we are dealing with extra spacing in our data. My own way of double checking this is to resize the specific column to as wide as...
My minimal Python setup for data mining, processing & analysis
I was introduced to Python by a close friend back in 2006. He also recommended to learn it using the awesome book by Allen B. Downey, How to Think Like a Computer Scientist. Ever since that, I started using Python whenever I need to program something for data mining,...
Creating video montage with minimal technical know-how
I was tasked to create an opening montage for an event back in May 2018 and I have no idea where to begin, except from trying to coordinate with all other video experts around campus. Unfortunately, most of the people I contacted were occupied with some other task at...
My top 5 tips for a better spreadsheet
I spent a considerable amount of time dealing with spreadsheets, especially using Microsoft Excel, Libre Calc and Google Sheets. While perhaps everyone has their own way of designing and organizing their own spreadsheets, I personally think these are my top 10 best...
Google Form as metadata manager
Often we encountered problem with documentations and reports done by someone else and that someone else has been transferred to another unit or retired. Although we have some kind of storage system to store all those information and it is just a matter of passing that...
Improved Scopus author profile wizard
Apologies to all other fans out there but I personally think Gandalf is the greatest (fictional) wizard of all time. Pun aside, I stumbled upon an improved Scopus Author Profile tool few days back when I was assisting Dr Mastura with her Scopus profile. Apart from...
New information export support from Scopus
A quick visit to Scopus today and I found out that new information can now be exported; particularly the Scopus IDs (or Author IDs) of the list on publications! This feature is definitely useful for anyone, myself included, in dealing with unique identifier for...
Royalty free photos for your next project
Looking for royalty-free (free-to-use) photos for your slides, presentation or webpage? Try PEXELS. It did not get any better than this as you can simply search, browse and download any photos you want to use. Just make sure you pay attention to the Pexel License on...