Create Random Pairs in Excel & Google Sheets

This week I got a task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve my goal. Here are the detailed steps to achieve a random pair of two, and it’s easy to adjust to your specific needs. All the example data and formula can be found in this Google Sheet: Random Pairs . Steps Step 1 - Generate random numbers using RAND() Firstly, we need to generate a random number against each name, we can use the RAND() function to achieve that....

November 16, 2022 · 2 min · 329 words · Eric

Notion Resources  [draft]

Reference [Notion Docs: Keyboard shortcuts: https://www.notion.so/help/keyboard-shortcuts]

April 9, 2021 · 1 min · 6 words · Eric

Configure Java Environment on macOS Big Sur

Starting from macOS Big Sur (ver. 11.2.3), macOS doesn’t include pre-installed Java any more, the best option is to install AdoptOpenJDK . You can download the OpenJDK pkg binary and install it manually like here , or install AdoptOpenJDK via brew in your favourite terminal: 1 brew install --cask adoptopenjdk Hope it helps. Reference wolfpaulus.com: Installing Java on macOS 11 Big Sur github.com/AdoptOpenJDK: AdoptOpenJDK - HomeBrew TAP

April 7, 2021 · 1 min · 67 words · Eric

Git - how to move a folder from one repo to another and keep its commits history

I was encountered into this situation that I need to transfer some existing code to another separated GitHub repository. Ideally it would be perfect to keep all historic git commit histories so that we can still be able to revert back if necessary. After digging into Google and Stack Overflow, luckily I found there are others who need to achieve similar things. Here is the solution I used to resolve this problem eventually....

March 15, 2020 · 2 min · 386 words · Eric

First 90 Days

Why Do We Fail in First 90 Days? From Employee perspective, there are several aspects that lead to a unsuccessful start Job vs expectation. Relationship with boss. Lack of training. While from Company side, they have a different view on that: Poor performance. Poor punctuality. not able to be on time. Absenteeism. Not even be able to show up. First 90 days into a new role is not just the paperwork and basic induction, like training and meeting and greets....

October 26, 2019 · 6 min · 1201 words · Eric