Royce Kin Chung To's Blog

Situtation: Have ever you find yourself using way too many columns to describe your data to the extend that all alphabets from A to Z had been given a name ? Worst still, the proliferation of column goes beyond double alphabets (52 columns and counting) where a Excel meltdown is coming…☢️☢️☢️ What’s Wrong With This? Very often, we use multiple ...

The post What’s Wrong With Using Too Many Columns In Excel? appeared first on Royce To.

Having been deep dived into data cleaning in Excel these days, I found that some cells were filled with zeros when it is much more appropriate to leave it blank. The following explains why there are difference between filling a cell with 0 and leaving it blank and why it is important. To those that that are impatient, here is ...

The post Should You Put Zero or Leave it Blank in Excel? appeared first on Royce To.

Cleaning data in Excel is something that I enjoyed very much these days (don’t judge). While I am pondering on writing something more in-depth about how to organise your data for management and analysis, it seems much easier to write about Excel errors first as a warm up. So, here goes: ###### Problem: This is not even an error. It ...

The post Demystifying Excel Errors and How to Fix Them appeared first on Royce To.

The Challenge Hong Kong, along with Vietnam, Singapore, Thailand and China, is an internationally recognized hub for wildlife trafficking and as such plays an important role in global networks that supply poached wildlife across Asia. Estimated at over 20 billion annually (UNEP 2016), wildlife trafficking is one of the worlds most nefarious challenges, ranking thefourthlargest illegal trade behind drugs, people ...

The post Keeping Wildlife in the Wild appeared first on Royce To.

Transportations in Hong Kong are usually double deckers. Here’s how you could enjoy. Bus No. 15 Central Pier – The Peak Forget about the Peak Tram, I recommend you to try bus No. 15 from Central to the Peak. Part of the fun is the road to the top is long and winding. Sitting in front of the upper deck, you will ...

The post The Double Deckers – Bus, Tram and Ferry appeared first on Royce To.

Bring these on your next camping trip Camping in the countryside of Hong Kong is one of the best outdoor activities during autumn and winter. Designated Campsites are reachable by public transport with short walking to sites. The following are camping items you will need for your next outdoor adventure! ONE – Rucksack #ospreypacks #kestrel48 and waterproof bags 35L and 20L A ...

The post Eight Things You Need for Camping in Hong Kong appeared first on Royce To.

大樹倒塌，其實只有一個理由。。。There are both short and long answers to why trees fall and how should we manage trees in the city to avoid failure to happen. This post is in Chinese and for English, please refer to http://royceto.com/why-trees-fall/. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer vel urna imperdiet, accumsan ante gravida, pulvinar leo. Suspendisse quis 簡答： 地心吸力！ 沒有地心吸力又何來塌樹呢？ 詳答： 樹木的生物學 樹木為一種生命體，隨著時間會發展成不同的生命階段 ...

The post 為什麼會塌樹？ appeared first on Royce To.

Gravity will be the short answer… The Long Answer Biology of Trees Trees are biological organisms, which means they will go through stages of life in establishing themselves, attaining maturity and after multiple years of reproduction, they die. This process can last for any number of years but usually within hundred in the case of trees in the city (and ...

The post Why Trees Fall? appeared first on Royce To.

Just came back from the final round of thesis presentation. It was a full day almost non-stop listening to students’ presentation on what they do and what to expect by the time they submit their reports few weeks from now. I like seminars like this that makes me feels like I am Ryu fighting his enemies in Street Fighter. So after ...

The post 5 Tips for Better Thesis Presentation appeared first on Royce To.

Just came back from another round of tutorial in thesis development. Have that eureka moment on how we could help student in developing their thesis, could look like this: Stage I – Let Their Minds Run Free –  I don’t intervene much at this early stage of development. It is after all, students’ thesis, not mine! More importantly, is to pay attention to students’ aspiration ...

The post Mentoring Student’s Thesis appeared first on Royce To.