Hi 👋 I’m Eric,

Welcome to my blog

Resource Allocation Between Teams

Last week, I am been encountered into the problem of allocating resource between different teams. Here is a quick guideline: Understand implications between different teams, and priorities. Work with stakeholders, run through all the options with them, and see if people agree or not. Keep the decision transparent. Don’t be helpfully unhelpful. Always generously providing support will lead others blind on their actual problem. Reference Float: Resource Allocation: 6 Steps Every Project Manager Should Know

December 5, 2022 · 1 min · 75 words · Eric

Orangise Hackathon in Your Organisation

TL;DR Early preparation and repeat communications are the keystones for high team engagement. A 2-days Hackathon is a good balance between team engagement, project complexity and business outcome. Sponsorship from external vendor is not essential, but good to have. Clear schedule and timeline will help all participant around when to do what. A Hackathon theme is necessary to guide team participations, even just ‘Have Fun’ is a good one. Post Hackathon communication is as IMPORTANT as the Hackathon event itself, especially for these who didn’t participant this time....

December 2, 2022 · 7 min · 1441 words · Eric

General Social Rules

I read about some social rules on the internet, and thought this would be a good idea to collect some of these general ideas, and organise my thinkings in this area. According to Wikipedia, Social Rules, or Social Norms, are shared standards of acceptable behaviour by groups. Social norms can both be informal understanding that govern the behaviour of members of a society, as well as codified into rules and laws....

November 28, 2022 · 3 min · 604 words · Eric

Create Random Pairs in Excel & Google Sheets

This week, I got this task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve this. Here are the detailed steps to achieve a random pair of two. All the example data and formula can be found in this Google Sheet Random Pairs. Step 1 - Generate random numbers using RAND() Step 2 - Copy the random number values to a new column named Value Excel or Google Sheets will automatic re-generate a new series of random numbers with the RAND() function....

November 16, 2022 · 1 min · 212 words · Eric

Facilitate Productive Workshop

In the previous blog, we talk about some general best practice about a productive meeting. Normally a meeting can be organised based on following phrases. In this page, I am going to write down some practical tips for facilitating a productive workshop. Before meeting kick-off In the meeting Post meeting follow-up Before Kick-Off Preparation. Get to the meeting room if you have. Get yourself a cup of water if you need....

October 19, 2022 · 2 min · 308 words · Eric