How To Calculate Text Occurrence Without Seed Keyword List

1. Highlight Keyword/Search Query Range
2. Text to Column the range
3. Combine All Text Into 1 column.
4. Pivot Table it, Use Keywords For Rows & Use the Same Column for Values

Operation hour for immigration Malaysia

Normal operating hour for immigration Malaysia as follow except public holidays & Ramadan Month. 

Operation hour for passport application

Monday-Friday : 7:30 am – 5:30 pm

Immigration office at Wilayah Persekutuan Kuala Lumpur dan Wilayah Persekutuan Putrajaya, Wilayah Persekutuan Labuan, Selangor, Negeri Sembilan, Melaka, Johor, Pahang, Perak, Pulau Pinang, Perlis, Sabah, Sarawak.

Saturday-Sunday : 8:00 am – 1:00 pm

Only apply to selected Immigration office at  Negeri Sembilan (Seremban), Selangor (Shah Alam, Kelana Jaya, Kajang, Pelabuhan Klang), Johor (Johor Bahru, Pekan Rabu), Pulau Pinang (Seberang Jaya), Sarawak(Kuching, Miri), Sabah (Kota Kinabalu) Wilayah Persekutuan Putrajaya (Pejabat Passport Presint 15)

Sunday – Thursday : 7:30 am – 5:30 pm

Only apply to Immigration office at Kedah, Kelantan and Terengganu

Operation hour OTHER THAN passport application

Monday-Friday : 7:30 am – 5:30 pm

Immigration office at Wilayah Persekutuan, Kuala Lumpur and Labuan, Selangor, Negeri Sembilan, Melaka, Johor, Pahang, Perak, Pulau Pinang, Perlis, Sabah, Sarawak

Sunday – Thursday : 7:30 am – 5:30 pm

Only apply to Immigration office at Kedah, Kelantan and Terengganu

Operation hour for immigration Malaysia at UTC /马来西亚UTC移民局工作日开放时间

Initially the operating hours for passport counter under this UTC is from Monday to Sunday from 8:00am to 10:00pm except holidays & Ramadan month. However, there is an official announcement from immigration Malaysia website that all UTC no longer operate on Weekend on 31 July 2013. 

Monday-Friday : 8:00 am – 10:00pm

All passport counter at UTC Immigration office

Pusat Transformasi Bandar (UTC) Kuala Lumpur （Pudu)

Aras 2, Pudu Sentral， Jalan Tun Tan Cheng Lock

50550 Kuala Lumpur

Tel : 03-20262079/90/92

Pejabat Imigresen Mini UTC, Sentul

Aras 1, Pusat Transformasi Bandar

Jalan 2/48A, Sentul Perdana

Bandar Baru Sentul，51000 Kuala Lumpur

Tel : 03-404000143/614/148

Pusat Transformasi Bandar (UTC) Melaka

Aras 2, Wisma UTC，Jalan Hang Tuah

75300 Melaka

Tel : 06-3333 333

Pusat Transformasi Bandar (UTC) Perak

Level 3，Bangunan UTC Perak

Off Jalan Dato' Onn Jaafar

30300 Ipoh， Perak

Tel: 05-249 4960 (UTC Information Counter)

Pusat Transformasi Bandar (UTC) Kedah (Alor Setar)

Pejabat Imigresen UTC, Alor Setar

2-6 UTC, Bangunan UTC Kompleks MBAS, Jalan Kolam Air

05675 Alor Setar, Kedah Darul Aman

Tel: 04-7360051/52/53/54 Closing hour for immigration Malaysia for Friday prayers All Immigration Office service counters will be closed during Friday prayers began at 12.15 pm to 2.45 pm.

Pokemon Go Rarity Chart

For all you know, you might have unwittingly caught a super-rare Pokémon without realising it, too — and to help you with this, Reddit user RotomGuy has created this useful Pokémon Rarity Chart:

This list lets you know which are the rare Pokémon you should be saving your Pokéballs for.

Here are the names of the Pokémon listed:
Everywhere
Rattata, Pidgey, Weedle, Caterpie, Drowzee

Virtually Everywhere
Eevee, Zubat, Venonat, Oddish, Magikarp

Very Common
Meowth, Spearow, Bellsprout, Paras, Krabby

Common
Clefairy, Nidoran♀, Nidoran♂, Ekans, Cubone, Goldeen, Poliwag, Shellder

Uncommon
Jigglypuff, Growlithe, Gastly, Geodude, Exeggcute, Slowpoke, Psyduck, Jynx, Onyx

Rare
Ponyta, Vulpix, Koffing, Sandshrew, Staryu, Tentacool, Horsea, Magmar, Tangela

Very Rare
Abra, Machop, Grimer, Rhyhorn, Voltorb, Lickitung, Scyther, Pinsir

Epic
Dratini, Magnemite, Electabuzz, Hitmonlee, Hitmonchan, Chansey

Mythical
Lapras, Snorlax, Porygon

Special
Bulbasaur, Charmander, Squirtle, Pikachu, Omanyte, Kabuto, Aerodactyl

Region exclusive
Farfetch’d, Mr. Mime, Tauros, Kangaskhan

Not currently available
Ditto, Moltres, Zapdos, Articuno, Mewtwo, Mew

All five legendary Pokémon and Ditto are listed as “Not currently available” — they have neither been found nor been caught yet. Currently, the number of Pokémon in the game stands at 145. When these six Pokémon are made available, they will complete the 151 monsters from the original game series.

This means that as far as prevailing wisdom goes, we might not be able to catch them all just yetIn the meantime, we can aspire to be like Nick Johnson.

On August 5, the 28-year-old from New York became the first Pokémon trainer confirmed to have caught all 145 Pokémon currently available in the game. According to this Mashable report, Johnson did an amazing feat of catching all 142 Pokémon available in the US in just two weeks, covering some 152km on foot and hatching 303 eggs.

Two companies, Marriott Rewards and Expedia, who were impressed by his dedication and effort, sponsored a round-the-world trip (!) for Johnson to catch Pokémon not found in North America.

Johnson became the world’s first Pokémon master when he completed his collection of 145 Pokémon in Sydney, capturing a rare Kangaskhan (exclusive to Australia and New Zealand).

For now, at least we know which are the rarest Pokémon that will bring us one step closer to being like Johnson the very best.

Pokemon Go Egg Hatch Chart

Part of the thrill of Pokémon Go is never knowing what might be lurking around the corner. Hanging around canals hoping a Lapras will rear its mythical head, doing a few more laps of the local Pokéstops in the hope of stumbling across a Scyther – the fun is endless.

But wandering around aimlessly will lead only to disappointment. And Rattatas. So many Rattatas. Of course, you catch them anyway because you really can't say no to that extra stardust, but you'll never master your local gym with a Raticate. To get your hands on the really rare Pokémon, you need to hatch eggs.

Thankfully some kind soul over at Serebeii.net has created a chart that tells players exactly how far they'll need to walk to hatch the rarest Pokémon:

http://imgur.com/gallery/pPDl1

Lowyat.NET’s Guide To Getting Started With Pokemon Go In Malaysia

Lowyat.NET’s Guide To Getting Started With Pokemon Go In Malaysia

By: FARHAN

Pokemon Go has finally hit our shores, and it is only a matter of time before the Pokepocalypsereaches critical mass. As is our civic duty, we are providing a simple guide for Malaysians starting their Pokemon journey; mostly because the game does a horrible job of explaining what to do.Keep moving around


Pokemon is a game of exploration and discovery. While it is possible to catch Pokemon without moving (if you drop Incense), there is significantly higher chance of catching something while on the move. The game spawns Pokemon roughly every 30 minutes, but decreases the time if the player is on the move. Pokemon also spawn in areas that resemble their natural habitat. This means water Pokemon near ponds and lakes, while housing areas will likely see plenty of Pidgeys and Rattata.



Moving around is also necessary to hatch eggs that drop from Pokestops. The game tracks how far you’ve moved since you put the egg in the incubator, which means that walking in circles in the same place doesn’t work. It also tracks your speed, just so you don’t try to cheat by driving around. That being said, nobody is sure of what the speed threshold is. It looks like cycling is perfectly acceptable at the moment, but not anything faster than that.Have a co-pilot


Despite cars allowing players to move around quickly to discover new Pokemon, playing Pokemon Go while driving is a terrible idea – for good reason. That is why it is an excellent idea to have a co-pilot in the car. The layout of Malaysian cities is admittedly not always conducive for pedestrian traffic – which leaves us resorting to recruiting friends for Pokemon drive-bys.Malls are the best place to find Pokemon


Niantic’s algorithms prioritise urban areas for Pokestops and Gyms, leaving other locations rather sparse. Unfortunately, this also goes for when the game spawns Pokemon. While it is tempting to visit parks and playgrounds to look for Pokemon, our local weather does not always make for ideal conditions. Instead, shopping malls are a good substitute for wandering around and catching those hard to find Pokemon. A mall with an attached park is probably the most efficient place to start hunting.Visit the same place at different times
Some Pokemon only come out at night, which makes sense considering that you’re not likely to see a ghost wandering around in broad daylight. In that case, it is a good idea to come back a spot later to see if things have changed.Some Pokemon are region specific


Not all Pokemon will be available in the wild. There are currently four Pokemon that are known to be region specific; which makes catching them all a bit harder. These are Tauros (North America), Mr Mime (Europe), Kangaskhan (Australia), and Farfetch’d (Japan, possibly Asia as a whole). While it might not be economically viable to literally travel the world to catch them all, these four will also hatch from eggs. Which means a lot of walking and hoping for the best.Transfer your Pokemon to get Candy

Pokemon Go doesn’t allow Pokemon to gain experience and evolve through fighting. Instead, Pokemon evolve when they are fed enough candy of their particular species. Getting this candy is as easy as catching the same Pokemon over and over again; and they transferring them to the professor. No, we don’t know what happens to the Pokemon after they are transferred. Just assume they are living on a nice farm somewhere.

Candy is also used to Power Up Pokemon. Each power up costs one Candy, but also incurs a cost in Stardust.Hoard your Stardust during the early game
Stardust is important for getting Pokemon ready for battling Gyms. Earning Stardust is easy enough, as you can accumulate quite a bit by simply catching Pokemon. Which means that it is important to catch all the Pokemon that cross your path. Also, because you want to turn them into Candy.Don’t be discouraged by overly difficult Pokemon Gyms


Notice how all the Gym are packed with Pokemon much stronger than anything you’ve found? Chances are that these are people who have been cheating their way into the game by disguising their GPS coordinates. In other words, they have been playing for much longer than you have. There is no reason to be discouraged though, as players are allowed to cooperate with other members of their team to take control of a Gym. Just train some Pokemon and team up with friends to take the fight to them.Talk to people


Pokemon Go is a social game. Sure, it’s alright if talking to people isn’t your thing. However, the game is made more interesting by running into people and simply having a chat. If you’re lucky, they will be able to tell you where all the good Pokemon are hiding.Be respectful at religious places
This is probably a rather sensitive subject, but it needs to be said. Niantic has marked mosques, shrines, temples, and churches as locations for Pokestops. There’s nothing wrong with visiting these places to replenish supplies, but please be mindful of where you are. The last thing we want is Pokemon Go players to offend someone and get the game banned.Join Team Valor


Players will be able to visit Gyms and choose a team to join at level five. There are supposedly three teams, but smart players know that Team Valor is the right choice. After all, they share the same colours as your favourite tech news portal.