Perodua Myvi - Cleaning Blower Aircond

I took this picture in 2012 to clean up the aircond blower is in my Myvi car. I find ways to clean it in a special forum for consumers of Myvi www.myvi.com.my. It gives a lot of knowledge and useful tips on driving and car care. Few pictures of the process.

luggage space in front of the passenger seat is open

20th Championship Title for Manchester United

Manchester United is a world leading international clubs. It is a football club that many followers around the world. Including my self. I have long followed the development of this club since the 90s. Players who are still playing for the club from the start I support is Ryan Giggs. There's no denying that he is a highly disciplined to date in pursuing a career as a football player who is able to play until now. Now Manchester United have been called up for the Barclay's Premier League for the 20th time. Under the management of Sir Alex Ferguson, numerous trophies and awards achieved. Last year Manchester United missed the Barclay's Premier League title to Manchester City only on goal difference.

Rainbow Cake

2 weeks ago, my wife had tried for the first time to provide a rainbow cake. My wife, however, had never taken a course in making cakes or pastries. But the result of hard work, my wife finally succeeded in producing a delicious rainbow cake. I fully support my wife's efforts to learn how to make cakes, pastries and other dishes. Most of the recipes learned from cooking blogs, and from his acquaintance. 

in progress

Jelly Bean update for GT-I9100G

Already 2 weeks it feels like Samsung has released the Samsung Galaxy S2 firmware update Android Jellybean GTI9100G to India as informed in Sammobile website. Until now has not been seen in the firmware for the same model for the users of Samsung Galaxy S2 GT-I9100G in Malaysia. I'm sure many are still waiting for updates for their mobile phone. Many who want to try their own updates that have been done by Samsung. It seems that Malaysian users will have to wait even longer to switch to Jelly Bean 4.1.2 for their mobile phone.

You can browse Sammobile to know whether there are the latest updates for your samsung mobile phone.

Samsung Galaxy S2

Most Use Formula In Microsoft Excel

On every working days, its all based on my data stored in Microsoft Excel. Filters, Formulas, Conditional Formatting and Mail Merge. Few hundreds of rows and dozens of columns always on my eye sight. Few of my most used formula is IF function, Date and VLookup function. But as you all know, after you create a formula its all done for the rest with the whole data. But sometimes there's more formula to be created based on what you really want. Those are my most use formula in Microsoft Excel

With the IF function, i manage to determine if my data is TRUE or FALSE, If its TRUE, i want it to appear some other text or another formula about calculation or else to suit my needs. Sometimes its hard to create new formula. You have to know what the exact formula function to use. Most of the time, i search in Google to get the exact function for my data and also from a forum under website Chandoo.org. The forum also let you to discuss about errors or info about the formula and determine the best formula to you. Thanks to Chandoo.org. 

VLookup is another formula function i use to get a data from another sheet. Its a good function that can combine with another formula function. 

Anyway, thanks to Chandoo.org for all the information for what they have share with me.
Alhamdulillah. Thanks to Allah S.W.T.

PC Fair is Back Again

All people must already know about PC Fair created every year. Today 12 April to 14 April once again held at the Kuala Lumpur Convention Centre for all levels from within and outside the Klang Valley. Of course many people are keen to see the new technologies on the market and try some more gadjet-gadjet that draw attention to the present.

I am also has been from time has become a habit to visit this event to get some computer goods. If you want to do a price survey, can be done at the beginning of the opening of this event because at that time the area was not very crowded when compared to on Saturday and Sunday as the average visitor coming in every event held is very encouraging and also very crowded on the day. For over a sometimes very narrow area with visitors who want to get information and buy several items at reasonable prices.

If you are a madman on gadjet and new technologies, this event is an event that is suitable for you. Normally the price is relatively cheap and also comes with a complete package. The event will be peaks on Sunday where the average visitor will find something good in them at cheap prices. As usual in the past, the sellers will lower their prices for goods sales pitch is placed in the convention center.

Do not miss the opportunity to visit this great event. Do not forget to bring extra money to spend on what you want. Happy weekend.

Way to check the electoral rolls in Malaysia

Malaysians can check the status via SPR website http://daftarj.spr.gov.my/. You can also check via mobile phone just by typing in a short message SPR SEMAK Identification Card. Examples of SPR SEMAK 999999887777 and send to 15888.

You will get to know the district and parliamentary voting later on May 5, 2013.

Carry out our responsibilities as citizens of Malaysia for the future of Malaysia.

Malaysia Election Day - Sunday, May 5, 2013

10-04-2013 - Election Commission today announced the date of nomination and polling dates for general elections 2013 the Malaysian government. The candidates nomination date is on 20 April 2013 and the date of polling is on May 5, 2013 corresponding to Sunday. The announcement was made by the Chairman of the EC, the EC Headquarters at 12.30 pm today.

Malaysia's 13 million people are eligible to vote in this election. A total of 222 parliamentary seats and 505 state seats contested.

Quoted from the Daily News.

Backup And Upgrade Jelly Bean 4.1.2 Firmware GT-N7000

Today, more and more firmware release for Samsung Galaxy Note GT-N7000. For whom that is own this model can upgrade to latest firmware, Jelly Bean 4.1.2. Please check using Samsung Kies if there is an update for your region or country. Here is the link GT-N7000 Latest Firmware for you to check about the update. The latest region/country that i manage to check at www.sammobile.com is Kenya, Ukraine, Kazakhstan, Taiwan and Hong Kong. Please backup before you do any upgrade to your phone.

List of GT-N7000 Official Firmwares

Upgrade from ICS 4.0.3 to Jelly Bean 4.1.2 Using Odin 3.07 For GT-I9100G

As you all know that i am using an android phone nowadays, i am keen to upgrade to the latest firmware. Before upgrading to the new one, my previous version was Ice Cream Sandwich 4.0.3. However Samsung has release new firmware that is Jelly Bean 4.1.2 for my phone in January 2013 started with France and in February for Germany, Open Austria and China. There is no latest update for other country and also to my Samsung Galaxy S2 GT-I9100G Malaysia. 

Tips About Microsoft Excel And Word Mail Merge Function.

TUTORIAL / TIPS ABOUT MICROSOFT EXCEL AND WORD MAIL MERGE FUNCTION.

     

     1-If you are using numbers or currency, you will get a lot of decimal or no decimals at all                   without notice. Even that in your data has already two decimal places.

     

     2- A few tricks for handling it by using a mail merge switch code.

     

     3- Below are few samples that I’ve list for all of us can manage it.

Basic Mail Merge Tutorial by Khyriel.

Below is an example to perform mail merge with Microsoft Word using the data stored in Microsoft Excel.

Firstly, you must have a data in Microsoft Excel to begin. Like the example below.

No	Name	D.O.B	Employee No.	Basic Pay
1	Ahmad Bin Ali	16.05.1990	V0051	1500.00
2	Sulaiman Bin Mahmud	12.02.1977	V0052	1600.00
3	Zakiah Binti Abdullah	05.08.1980	V0053	1300.00
4	Farrah Binti Kasim	29.07.1985	V0054	1200.00
5	Lisa Binti Abdul Razak	31.12.1995	V0055	900.00

Open blank Word document.

13th General Election for Malaysia?

PM will go on air live at 11.30 on the national channels, TV1 and TV3 private TV channel. This is related to a meeting with the King this morning around 9.00 am in the morning. Is it likely that PM would announce the dissolution of Parliament and the next date to vote for all Malaysians? Together we look forward to his announcement for the 13th General Election for Malaysia.

12.00 pm. And was officially dissolved parliament and within 2 weeks of the nomination of candidates by political parties contending to be determined. EC to hold hearings to determine the date of polling in 60 days.