Movement Control Order Day 23

Hari ni hari Khamis minggu ke 3 Movement Control Order. Sedey pulak next week dah nak abis MCO. Esok government akan announce whether sambung atau tidak. I wish MCO disambung sebab aku kan memang malas nak pegi keje. I've been very good. Tak tengok TV pun, memang betul-betul follow Work From Home.

Hari ni aku masak nasi lemak untuk breakfast. Asalnya nak pre-cook se-tupperware cili boh jadi sambal supaya bila nak masak sambal senang. Pastu ada sotong dalam fridge jadi tu datang idea nak masak nasi lemak lauk sambal sotong.

 Aku tak tahu kenapa, memang dah tak semangat nak keje. Apa motivation orang pegi keje ye? Nak sara hidup la kot...gitu la aku agaknya. Ntah....aku rasa cam nak buat hal sendiri. Nak buat menda for myself...yoga, masak, tulis blog, tak nak pikir pressure kat opis.... masalahnya sume menda yang aku nak buat tak da pulak menghasilkan duit...nak hidup kena pakai duit cek oii!

Hari ni tak tahu kenapa...tak semangat langsung. Masak pun tak berapa nak masak.

Movement Control Order Day 19

Dah masuk hari ke 19. So far I'm enjoying this PKP thingy. Kerja tetap kerja, tapi best sebab tak payah mengadap boss. Aku enjoy memasak sebab bukan aku yang pegi kedai beli barang so takda la penat sangat. Pastu dapat masak menda yang dah lama tak masak dan menda yang tak pernah masak!

Peria
Suami beli peria, dia ingatkan tu petola! Berpeluh jugak pikir camna nak masak sebab peria pahit kan. Serious tak tahu cara nak masak. Tapi ghupanya quite simple, cuma kena rendam air garam sekurang-kurangnya 30 min. Boleh goreng rangup atau buat masak telur. Hari tu buat masak telur, boleh tahan! Ada separuh lagi yg mentah, nanti aku nak pairkan dengan Ayam Tandoori.

Agar-agar Santan
Dulu masa ada bibik, aku rajin juga buat agar-agar. Pastu lama dah tak buat sebab guna gula kan (aku pantang gula sebagai langkah mengawal berat badan). Then ada terjumpa agar-agar tali dalam dry cabinet. Ni mesti adik ipar aku beli (tapi tak buat-buat). Aku kuatkan semangat untuk buat sebab sayangkan agar-agar tu nanti dah expire. Kali ni aku buat Agar-agar Santan guna gula melaka. Sebelum ni aku buat yang kaler hijau (kononnya perisa Pandan). Ni sebab ada gula melaka yg adik ipar aku beli jugak tapi tak pakai-pakai, aku decide nak guna gula melaka tu. Same reason, takut terbuang. Alhamdulillah, menjadi dan tak manis sangat (aku takut manis sebab guna 1 ketul gula melaka kot1)

Nasi Daging
Ni pun sebab adik ipar aku beli set Nasi Dagang dulu tapi tak buat-buat. Sebenarnya dah expired tapi serius aku sayangkan beras dalam set tu. Beras mahal kot. Glad I made it because now I know Al Manar set boleh repeat beli. Senang jugak kerja and people will definitely be impressed. Yang penting, main ingredient that is tulang/daging lembu & beef stock dah buat siap-siap. Husband aku suka sangat terus suh adik ipar aku order lagi set Al Manar tu.

Deep inside, I wish the government will extend the MCO. There are so many things I would like to do and learning tajwid is one of the main ones but I still have not opened my notes yet!

Movement Control Order: Sewing

Today is Sunday. I've just completed my #PKPproject which is to make covers for my dining chairs that have been scratched by the cat. Yeay!

Saturday 04.04.2020
I started yesterday morning, after I cleaned my house and did a bit of yoga. I was thinking about what are the things that I have been wanting to do but always blame of not having the time to do it. Then' 'sewing' came to mind and that was how I had the idea to sew the covers. Luckily I've not thrown this one piece of a remnant that would suit the green chair.

And boy, for a once in a blue moon thing like sewing, things were not as smooth as I thought (I thought I could finish the project within a day). 1st, I had to re-thread the bobbin which later had caused varying tension on the thread (wow! those are seamtress lingo!) I had to take a break and watched Youtube to solve that and once solved, the needle broke! Luckily there were spare needles but with codes so not familiar to me. Again, I had to google for info on it and I decided to call it a day. I only managed to sew 2-3 pieces on the sides and I really hope I could finish the project!

Sunday 05.04.2020
Why did I ever commit to this project! That was my 1st thought when I woke up at 5.30 am. But as soon as I remembered watching Captain Marvel last night about being human with lots error but never give up, I quickly got up and determined to finish the project. And Yeay! I officially completed it at 12.00 noon. Alhamdulillah!

Lesson learned about sewing
The sewing machine is not at fault. It functions OK, it is just me that need to know how to go about if issues crop up...

1. When threading the bobbin, lock the needle.
2. The thread tension may be affected so adjust on the tension of top thread, as well as the tension of the bobbin thread (I need to hook the bobbin thread on the side).
3. Needle size depends on the cloth that I'm sewing. The thicker the fabric, the higher the number
4. To adjust the top thread if it's loose, go for lower numbers.
5. Always google. The information is very useful
6. Never give up and be patience. It will be worth in the end

Movement Control Order: Blessing in disguise

Malaysia is being hit with Covid 19 pandemic. Not only Malaysia but the whole world. Started from Wuhan, China I remembered Lutfi saying Coronavirus when we were in Perlis for Chinese New Year in January.

And today is the 5th day of Movement Control Order (MCO) I never knew this term until the government announced it on 16th Mar. I was excited at first because this would mean we would be working from home. Right after the announcement, my boss sent a Whatsapp message saying she wants to discuss about rotation during MCO tomorrow. Haiyaa!

I only got to calm down and plan how to go about this 'Work From Home' (FWH) thingy. The 1st 3 days, I actually didn't get much done. I was reading and googling on things that I've been wanting to do (such as learning how to do a survey report). I was on the edge worrying my boss would constantly contacting me asking about work. I just could not imagine how to juggle between doing what I want, attending to work as well as the kids. I noticed I was just sitting and only got up to eat, pee and pray. Not good for my weight management!

Luckily, I've been quite structured in my daily routine....I get up around 4.30 am to prepare breakfast and do ironing on alternate days. Then I'm off to send Kasyif to school and straight to work at 7.00 am. When I come home from work I usually prepare and cook dinner. So I figured out that I just need to continue doing that. Work is work, I still have to attend to it. So just continue the daily routine including the 9-5 work hours...except that you're doing the work at home...

I'm so thankful to Allah SWT for letting me to experience this WFH. I will write separately how I feel about this Work From Home arrangement.

In the meantime, let me continue my work face down in front of my broken TV.... I love WFH!

What I want to achieve in life?

Only at the age of 45, baru dapat ilham nak target apa dalam hidup. At this point of life, the target is different compared to when I was younger. Actually previously I didn't know what to achieve in life as in what I really want. Semua main ikut saja...tengok orang nak jadi akauntan, aku pun nak jadi la. Orang nak study oversea, aku pun nak jugak la. Orang ada boyfriend, aku nak jugak la etc. Masa zaman muda memang ikut orang saja.

Yesterday was not a good day for me. All this tension and demand from work really makes me want to quit my job. Aku dah accept rezeki aku so far takat ni. With bad experience at work semalam, aku memang rasa tak nak dah keje kat sini. Aku nak buat benda lain (tapi tak apply keje lain pulak ya). Aku cakap kat hubby and his response was 'kalau berenti nak buat apa?' Aku expect tak payah buat apa-apa la kan...haha! Tapi agak tak logic di situ. At least aku dah gauge expectation dia terhadap aku.

However, yesterday I watched an FB post about the origin of OYO Hotel and it really hit me. The owner is now a billionaire at the age of 26 and he resides in India. He came from a poor family and what he did was pure hard work. Macam Allah SWT kata something like this  'kamu akan dapat apa yang kamu usahakan'...

Then aku teringat, if we really want something, we have to be able to visualize it. In my case, i must be able to picture the life that I want. Sebelum ni cakap-cakap je...nak kaya, nak berenti keje, nak kereta, nak buat tu, nak buat ni, tapi aku tak really imagine dalam masa 24 jam aku tak keje tu, aku akan buat apa

So WHY I want to quit my job? Because I want to live the life that I want that is....

Pivot_creating doughnut chart

So aku dah tahu sikit-sikit pasa pivot table, now nak create chart from pivot table. Jumpa camna nak buat doughnut chart

Bila buat presentation, 1st thing kena tanya yourself nak analyze apa sebenarnya....
I would like to analyze the utilization of revenue, cost etc against budget and achievement against target

So, from Pivot Table tarik CM actual, 2020T. Contoh tunjuk camna nak tukar sum of Revenue jadi % from Total (i.e proportion revenue by specific region from Total Revenue). Just right click and boleh tukar value ikut suka. Tapi aku takleh buat camtu sebab yang tu reference dia based on 1 column saja i.e revenue. Aku punya nak compare dengan column lagi satu that is 2020T.

Presentation wise, selalu pivot tu tulis Row, Sum of bagai. Kalu nak tukar pegi Pivot Table Tools - Design - Report Layout - Tabular Form. Nanti kuar title 'P&L item' instead of Row.

How to create progress doughnut chart from pivot table
Kena create helper column (1-x%) sebab nanti doughnut chart tu ada 2 axis

1. Select 'create doughnut chart' tanpa highlight apa-apa values dulu
2. Then right click - Add value. Dalam series, taip 1 (no of occurence) x 20 kali
3. Kalo nak adjust doughnut jadi doughnut gebu atau kurus = Format Data series - Doughnut hole size
4. Tukar kaler yang bermacam-macam tu to solid fill, then biru (nanti sume seragam jadi kaler biru)

*dalam video, dia copy the chart sekarang untuk create lagi 2 chart yang sama

Create another doughnut dalam chart tu (nanti akan jadi secondary axis). Bila add value, masukkan data % daripada table, in my case achievement % against budget.

1. Chart 2 tu ada keliling kat luar chart 1, bila tukar ke secondary axis, nanti dia cover chart 1 (chart 1 tak nampak)
2. Now kena modify chart 2 (yg secondary axis tu) untuk reveal chart 1
3. Highlight data point (pecahan doughnut yang kita nak format), select No Fill
4. Select the other data point (balance budget), yang ni select fill kaler Putih. Then make it transparent

So doughnut chart dah siap
Nak bagi cantik nanti, masukkan label kat tengah doughnut tu. Jangan lupa masukkan slicer

Pivot Table_CY value

Aku nak buat chart utilization of CY budget vs YTD Actual. Dalam data table, ada value CY Target.  So aku tarik colum CY  Target dalam Pivot Table tapi bila buat, Pivot Table akan jumlahkan value CY budget. Aku bukan nak camtu, aku nak value saja. So aku cuba masukkan formula VLOOKUP dalam 'Field, Item & Sets' tapi x boleh guna formula VLOOKUP  kat situ.

So camna aku nak cari value instead of 'sum of'?

Aku cari contoh from YouTube dan jumpa solution! Yeay! Formula aku discover = Totalkan je la target bulanan! (Duh moment di situ...hahah!)...Aku kan ada CM, totalkan je la.

Learnt learnt:
Instead of guna formula dalam Data Table, kerja kira-kira tu Pivot Table boleh buat. Yang penting Data Table tu dalam bentuk DATA, bukan logic dan ada sume data yang perlu. Logic buat sheet lain. Akau cakap camni sebab aku siap buat column CY Target dalam Data Table. Tak perlu sebenarnya sebab boleh guna formula SUM(CM) kat dalam 'Field, Item & Sets'.

Aku perasan aku jenis yang kekadang complicate things. This is one example. I guess sebab aku dah biasa dengan yang aku biasa that is create formula. Excel semakin canggih sekarang. Kira-kira tu Excel boleh tolong buatkan, tak payah nak guna sangat dah formula-formula Excel yang complicated sangat. Kalo Accounting selalu pakai SUM, SUMIF, INDEX, MATCH. Even VLOOKUP pun dah macam obselete je sebab dah ada INDEX, MATCH.

UPDATE:
Bila aku test data tu, SUM(CM Target) pick 1 value saja, tak sumkan pun. Logicnya sebab aku amik 1 cell je kan. Instead of SUM, pickup cell from CY Budget je la...baru betul figures tu. So colum CY Target masih valid ya....

P/S: cantik date harini 02.02.2020