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

Excel_Pivot Tables

To improve my skills, I would like to write what I've learned about Pivot Table

1. We can add column to calculate what we want =  Pivot Table Tools - Analyze - Field, Items & Sets
2. We can change the font, create charts from pivot table
3. Slicers are visualizing what we have selected
4. Explore the 4th quadrant of pivot table. Boleh buat macam-macam sebenarnya
5. Use doughnut chart to visualize utilization of budget
6. Achievement is 1+% progress. Variance is the % progress

Mengelap lagi

Weekend haritu aku buat apa ek? Owh.... aku berjaya let go baju-baju lama kepada Life Line Clothing Malaysia. Hantar ke SMK Dato Abu Bakar Baginda dalam pukul 3.00 petang. Actually depa ada kat situ dari pukul 9.00 hingga 10.00 pm katanya. Aku rasa lega dan lapang dada, kepala dan rumah! Haha!Tu activity hari Sabtu...

Hari Ahad ingat nak pegi exercise tapi kena amik Irdina kat SGS pepagi. Dia volunteer jadi facilitator untuk Form 1 yang baru datang and started last Tuesday. Husband pun dah lama teringin nak makan mee Jawa kat Jalan Penghulu Cantik, dekat-dekat CentrePoint Seremban. Cantik lah planning tu....

So cancel exercise sebab hubby kata nak bertolak kul 8.00 pagi. Tukar plan, aku clean up tingkat atas sebab buat aritu tak abis lagi...Alhamdulillah, nampak kemas sikit. Aku kumpulkan frame-frame gambar, reorganize kotak-kotak buku husband aku, lap platform. Aku bangun kul 5.00 pagi tau mengemas, sampai kul 7.00 pagi. Pastu mandi bersiap nak ke Seremban. 

Around 10.30 aku pegi facial. Balik dari facial dalam kul 2.00 petang, aku solat Zohor dulu sebelum start kemas, vacum (final touch) atas dan bawah. Aku nak simpan carpet merah and bawak turun carpet bulat nak letak kat area buku-buku the boys. Aku bawak keluar lampu lip lap raya dan bagi area tu ceria sebab malap sangat. 2 jam jugak lah...pastu keluar makan kat D' Limau Nipis. Kalo after 4.00 pm, lauk2 sume dia bagi separuh harga. Kalau kuih-muih, dia bagi jek sebab dia kata dah petang... Alhamdulillah....aku mention kat husband, jom buat IF weekend. Makan after 4.00 kat D' Limau Nipis...boleh jimat! Kuang3x

So abis dah weekend.....

2020: Barang dapur & food

Sebab tahun ni special 2020, aku pun nak buat proper analysis on our household spending especially on barang dapur and food..

Dulu aku withdraw cash cukup-cukup saja supaya aku tak terlebih spend. Sekarang aku nak tukar strategy pulak. Withdraw sekali saja untuk sebulan sebab ATM Maybank dah limited. Yang dekat dengan rumah aku dah takda. Aku dah kira dah, I need around RM1k per month untuk beli macam ikan, ayam kat pasar biasa.

What I've learnt from past years to improve my speed and minimize chaos in the kitchen:

1. Ayam mentah sekor beli brand Ladangku RM18 per pack. Cleaned and chopped in small sizes, this reduces prep time
2. Chicken parts boleh beli kat supermarket. Contoh kalo nak beli quarter chicken or dada ayam
3. Dada ayam boleh masak salted egg, butter, goreng kunyit
4. Hanya beli kalo nak masak menu tu. Tak payah beli sebab 'nanti nak masak...' sebab high probability tak masak in the end. Rugi RM....
5. Frozen stuff such as frozen fried chicken, kuih, roti canai are good for emergency
6. Make simple breakfast, no need to cook up a storm
7. Spend on quality food ya, not quantity

Tempat aku shopping:

1. Jaya Grocer
2. Pasar Aceh Seksyen 4 atau depan rumah aku
3. Pasar Tani

Menu

Aku pun kena buat theme menu apa aku nak masak untuk 5 hari weekdays tu. Contoh:

• One pot/wok: Mee/Bihun goreng, hailam, sup
• Masakan Western
• Masakan Melayu
• Masakan Cina

Atau tema bahan:

• Ayam
• Seafood
• Ikan
• Pasta
• Nasi

Atau tema cara masak:

• Bakar
• Steam
• Masak biasa
• Goreng

Dan macam-macam lagi. Yang penting kena plan. Bila dah ada mental picture tu, senang sikit nak execute.