Posts

Showing posts with the label Tutorial

Convert Single or Multiple CSV To Excel (Xlsx)

Image
There are a requirement needed to extract source text and currently translated text into a sheet and let third party to do translation. So this task is assigned to my team intern (Adrain) and under my guidance. So when I first received this task, I already think of a general automation way to extract the info via using python library (Beautiful soup). I have once using that library for my web scraping project so that I assume it will work on the xml tag file as well.  Therefore, what I proposed to my intern is to using that and extract the source text into a csv with delimiter, so that it will categorize it nicely when we use excel or other applications. I suggest he to break the source text by context name makes them into separate spreadsheet in a workbook. And today, my team lead tell me since using excel already what not also extract other languages make them together with different column? After some discussion I only reali...

Oral Hygiene 口腔卫生 #1

Image
还记得在大三期末,我发现我的牙齿很敏感。咬下东西的时候,有点酸酸的感觉。就拿了电话镜子照一照,才发现在我的左下和右下最深处的牙齿里有黑黑色的纹路。才急忙上 Google 查看,蛀牙相关的照片。惊觉发现真的是啊,感觉像蛀牙。 一向来除了在学校有的定期牙齿检查,基本上我家对牙齿和口腔卫生知识都不太认识。所以也很没什么到外面牙医那里去定期检查牙齿和洗牙等。所以因为蛀牙我得去看了。 那时候因为时间上的问题所以就去补牙,然后也没什么。渐渐的一年后我发现,怎样我自己在刷牙的时候也发现了很多蛀牙。都在牙缝,明明刷了牙,怎么还有蛀牙。问了牙医才发现很可能因为我没有用牙线的习惯导致蛀牙,而且还是很多颗。 下面要来分享一些我自己学到的一些牙齿知识。 PART I: 牙刷 通常建议选择的牙刷都是的都是: 软刷毛  可以更容易深入牙缝和牙龈沟,达到清洁牙齿功效。 但也不能太软,因为太软的话起不到更 好 的清洁牙齿功效 太硬的牙刷毛会 太会伤害到牙龈和牙齿。 相信你会问,怎样叫软? 方法一:买牙刷时可用手指轻轻压住刷毛,若有明显的刺激感说明刷毛太硬 方法二:买牙刷时可用用牙刷在前手臂内侧,来回刷,若有明显的刺激感说明刷毛太硬 小头 有很高的精准度,能清洁口腔每一个部位,但刷牙花费的时间长。 通常可以覆盖一至两颗牙齿。 适中的牙刷毛长度 太长的牙刷毛会导致难进入最深处的大牙,不方便清洗 建议都在 每三个月换一次牙刷,原因是: 刷毛上积累的细菌就会越多 弯曲磨合磨损,会影...

LHDN Income Tax & e-Filing Pin

  After graduation and we started our first permanent job. We definitely will open an account for KWSP (EPF). Then you will ask, how about LHDN income tax account? Do we need to open an account by ourselves? Here, I am going to record and share some of my experience regarding opening a LHDN account and e-Filing account. PART 1: Open Income Tax Account  (PS: I'm only share based on my experience): Mostly, our company will triggered and help us to open Income Tax account with LHDN. After that, I received a formal letter sent by LHDN to my house. In the letter, it stated our income tax number (nombor cukai pendapatan) (eg. SG XXXXXXXXXXX) Then we should inform our company about our income tax number. After having the income tax account, your company will do the monthly deduction which included INCOME TAX, EPF, SOCSO and EIS. How to know about the rate for monthly deduction? [Refer to  EXTRA INFO / USEFUL LINKS  Section] PART 2: Open e-Filing Account We need an e-Filing ...

PTPTN First Class Loan Waive Procedure

Image
❕ Update on 10 April:   📔 Hi All, you may read the latest updated details guide at my Medium Story Due to Covid-19, it changes our normal norm. My Bachelor Degree Graduation ceremony was postponed until further notice. However, my university Univerisity of Malaya (UM) still officially declared our graduation date as 🎓17 October 2020. The first things I thought of after knowing the graduation date was paying back my debt to PTPTN. Since I know that First Class Students still able to apply for PTPTN waive. Therefore, I made some research about that and compiled a list of steps for my junior future references.  The steps are as follows (Remember to read through all the parts before you start preparing your documents): PART I : GET THE LIST OF DOCUMENTS NEEDED Get ready your No. Pinjaman You may refer back to your PTPTN loan contract You may refer back by login to your Online account ...

PPT 里隐藏的宝石 / Hidden Gem In Microsoft Power Point

Image
相信大家对Power Point 都不陌生,Power point 是用来做Slide的。最近偶然听朋友(Yun Xin)说, power point 似乎可以拿来画画,画animation , 3D Object 等。自己跑去玩玩才发现好厉害,真的可以啊。 一下就是我的一些作品哈哈(初学者哈哈): 简单版本的寿司 帽子 球体 当我在画寿司的时候我发现,球体需要一点技巧才能画到。在这里我就整理了画球体的步骤,大家也试试看吧: 图画教学: 文字教学: 画一个圆圈 确保它的 Width 和 Height 是对等的 选自己喜欢的颜色(最后再选也可以) Right click, 选择 Format Shape 按那个 Polygon 图形 (Effects) 把 X Rotation angle 设置为 90° Top Bavel 选择 Round Bottom Bavel 也选择 Round 然后慢慢按增加键,直到图形碰到了格子边缘 把号码复制去其他Top bavel 和 Bottom Bavel 的 width 和 height 最后把 X Rotation angle 设置为 0 ° 球体就出现啦 今天就分享到这里啦 :)

显示代码片段 / Display Code Snippet In Blogger

Image
很多时候我们可以在网络教学里可以看到作者都会有显示代码片段, 比如以下: 这也是我很久之前就好奇如何办到的,所以我今天就来研究如何显示代码片段。 方式: 截图 Screenshot 这方式很简单,快速,可惜不太方便读者因为不能 highlight code Example of Code Snippet:  Edit HTML & CSS 自己加 CSS style sheet 和加 Html tag 好处:可以自己 customize 设计,颜色等 坏处:费时,不是一个很好的方法 所以以下是我下午自己做的成品例子: #include <SPI.h> #include <Ethernet.h> // the media access control (ethernet hardware) address for the shield: byte mac[] = { 0xDE , 0xAD , 0xBE , 0xEF , 0xFE , 0xED }; //the IP address for the shield: byte ip[] = { 192 , 168 , 66 , 100 }; EthernetServer server = EthernetServer( 111 ) ; void setup() { Ethernet . begin( mac , ip ) ; } void loop() { // if an incoming client connects, there will be bytes available to read: EthernetClient client = server. available() ; if (client == true ) { // r...

网上教学需懂的知识 / Online Teaching Starter Pack

在 Matriculation 的时期,还记得我的数学 lecturer 那时候用了 drawing pad 来教课,感觉整个流程也顺畅多了。在大学时期也有机会当了几次 demo 发现分享的过程很开心,互相可以学习到知识。所以就自从大学毕业以后,我有一个想法就是,想说未来哪天我也可以自己做一些 online  tutorial 教学哈哈。我是一个很爱拿笔讲解的人,所以就想起有 drawing tablet 是不是会方便很多啊? 昨天星期六,所以就上网做下research,写下一些东西,方便未来 refer 也不错嘛。 当一个人要 Teaching online with a tablet, 需要4个东西: Drawing Pad/Tablet Microphone Sketchbook / Whiteboard application  Screen Recording application 以下是我看过好几个Youtube 影片后总结出来重要的内容。 首先我们先看看第一个  Youtuber 的影片  介绍的牌子: Drawing Pad Low Budget Medium Budget High Budget Wacom Intuos Wacom Cintiq iPad Pro Microphones Low Budget Medium Budget High Budget Samson Go Blue Snowball Blue Yeti Whiteboard Applications Web Based (Free) Windows (Free) Mac (Free) ...