How To Watch Netflix USA Outside USA

Well, you have heard so much about Netflix, the largest video streaming company in the world. And yesterday, they announced the launch of Netflix in a few more countries including Malaysia. However, it can be expected that some contents in Netflix USA may not be available in Netflix Malaysia. Then there’s the question of censorship; again it can be expected that certain contents in Netflix Malaysia may be censored.

So before you subscribe to Netflix Malaysia, you may want to know how to subscribe to Netflix USA instead.  Read on…..

To register with  or subscribe to Netflix USA, you need to access it from USA. Or if not, you need to fool the Netflix USA server into thinking that you are accessing from USA. To do that, you use a VPN (virtual private network). You install the VPN software on your device (PC, notebook, iPad, smart phone) and connect with a server in USA that is part of this VPN. From there, your data traffic to any other server/website will appear to have originated from the VPN server in USA. That way, Netflix USA will accept your registration/subscription. (Rates about the same as Netflix Malaysia).

A very good VPN is the PureVPN, shown in the image above. Click on the image to go buy the VPN. There’s a New Year offer currently on…. a 2-year subscription is only USD2.08 / mth. It comes with free SmartDNS as well.

In addition, because you are running the VPN software on your device, you can access the Store (Playstore, Apple Store) to download the USA Netflix App.

Now that you able to access the Netflix USA movies/TV shows, you quickly lose the thrill if you have to continually watch shows on the small screen of your device. Why not stream it to your large screen TV? You can do that easily by using the Google Chromecast, a media-streaming device whose shape/size is like a retro thumb-drive. It fits into a HDMI port on your TV and it acts like a transceiver to receive your Netflix video streams and displays on the TV.

You can get the Google Chromecast now through the Lazada store ( see the advertisement on the top-left of this page). The price varies from RM170 to RM140 depending on the current promotion. Just click on the advertisement to access Lazada to buy the Chromecast.

That’s it! Enjoy!

Updated: 28-Jan-2016

I found that my Chromecast was unable to cast all movies and many TV shows from Netflix. In spite of trying all the fixes documented in the Internet ( update Chromecast, use VPN, use SmartDNS…) it remained problematic. That forced me to try the Roku Stick instead. Luckily a close friend has both the Roku box and stick and he loaned me his Roku Stick. I removed my Chromecast and stuck the Roku Stick in its place ( on an input  HDMI port of my AV Receiver ) and almost instantly, the Roku logo displayed on my TV and after a while the homepage with the Netflix, Hulu, HBO Go (and many others) options appeared. All the movies and all the TV shows that previously could not be cast by Chromecast magically work now.

Note: my ASUS router came with a link to SmartDNSProxy.com and I registered for a 14-day free trial. It works very well. My account homepage displays on the same page:
Account activation
DNS Setup
IP Activation
Region Summary

The IP Activation is very useful in that each time I log back into my ISP, the dynamic IP address changes. By clicking the IP Activation, it whitelists whatever is the IP at the moment.
So in one page, I can re-establish my SmartDNS setup and then my devices are all now “USA” devices.

-end of update-

Grand Strategy

Elsewhere someone asked me about corporate strategy. Here is my reply:

Maybe with age, I’ve become more cynical but it’s a fact that “the victor writes the history”. True, “sound” strategies have a better chance of success but history is also littered by lots of failures simply because of bad timing and/or the x-factor called “luck”. For example when Alibaba was launched, if suddenly there’s a world war, the world will never know of its “success”. That’s an extreme, but I’m sure you know of some factual “hard luck” stories of some really deserving guys who failed because of some inexplicable misfortune; not because of any flaw in their strategies.

Having said that, I first heard the “Be first, if not be better, otherwise be different” credo at a conference some 30 years ago maybe, presented by the CEO or Marketing Director of the local soft drinks plant here. At that time it sounded so profound to me that I adopted it as my credo too. It certainly sums up neatly what marketing is all about and may still be a good guide. But look where is the local soft drinks plant today?

What may be today’s strategic trend will be tomorrow’s no-no. For example, “conglomerates” was a hot strategic move in the 50-60’s but was discredited in the 70’s. But conglomerates are still thriving in Malaysia even now. So are the conglomerates in Malaysia considered a good strategic corporate structure?  The answer is “timing”. Good yesterday, bad today… may be good tomorrow. Eg. Companies like Apple outsource their manufacturing to dedicated EMS (electronic manufacturing services) companies. But then one day the EMS finds itself at the mercy of its big customers. So it creates its own brand, engages in marketing its own products too and in time the cycle begins again.

“Timing” and the x-factor “Luck”. If the Force is not with you, no amount of smart strategies can help you. Maybe it’s a Karma thing after all.

Adding a drop-down list to a cell in Excel

Let’s say you have created a spreadsheet template that requires input from different users, eg. a sales pipeline for your sales team. In one cell, the input has to be in a very specific manner, eg. months, spelt correctly. Now if left to the different users, there may be typo errors and moreover it doesn’t make sense to have to type an input that’s restricted to some specific list.The answer is to create a drop-down list in that cell for the user to select. That way the spelling will be consistently accurate and not so tedious to type in manually.

dropdown list 1Step 1:
Create the list in the Excel sheet. In the example, I have created the list of rainbow colours, from A1 to A7, viz. red, orange, yellow, green, blue, indigo, violet.

 

 

 

Step 2:
Select the cell where you want the drop-down list as the input.
I’ve selected cell C1 in the example.

 

data validation 1Step 3:
With Cell C1 still selected, go to the Data menu above, click Data Validation, and again Data Validation from the drop-down menu.

 
 

Step 4:
In the box that opens up, choose Settings, Validation criteria, List.

 

data validation 2Step 5:
In the Source selection, click and a new box opens up for Data Validation.

 

dropdown list 2Step 6:
Highlight (select) the list from A1 to A7, enter. Close the Data Validation box, and click OK in the Settings box.
That’s it. Now there’s a little arrow in the cell C1 for your drop-down list of rainbow colours.

How to sort data in Excel

One of the most compelling reasons for having a database is the ability to quickly search or sort the data. But not many people are inclined or able to manage (let alone master) a say SQL Database or even a simple database like Microsoft’s Access (part of the Office Suite).

Well, never fear. If you have used Excel long enough and if you have been creating tables and lists of data in the spreadsheet, you would have felt the need to sort the data alphabetically or by value (largest to smallest, or vice versa). And you can do that easily in Excel!

For example, if you have a contact list that you have been updating as you go along, you would have a mess of a list over time with all the names in no particular order. Wouldn’t it be nice if you can sort that by alphabetical order?

Or how about a list of your travel expenditure when you spent a whole week in Europe and now you have lots of souvenirs that you bought as gifts. You want to sort them by value, from the most expensive to the cheapest, so that you know what to give to who.

OK, let’s see how to sort those two lists.

1. Contacts List

Say you want to sort the names by alphabetical order.

unsorted names

 

Highlight the cells whose data you want to sort, from B3:C13 (include the header “Name” and “Phone” but not the No. )

sort_contacts

Go to the Home top menu, Sort & Filter at the top extreme right. Click for drop down menu and select Custom Sort.

custom sort

In the Sort Table that opens up, Sort by Column “Name”, Sort on “Values” and Order “A to Z”.

sort

And here’s the sorted Contacts List by names in alphabetical order.

sorted names

2. Travel Shopping List

Similarly for the travel shopping list:

unsorted items

Highlight the cells for the Items and Prices that are to be sorted:

sort_items

Then go to the Home top menu and click on the Sort&Filter for the drop-down menu, select Custom Sort.

Sort by the Column Price, Value and Order from Largest to Smallest:

sorted prices

Now you know the value from the largest to the smallest, for you to decide the recipients of your gifts.

 

How to center text across multiple columns in Excel

This feature is most useful when you have text in a cell that you use as a label or title for a range. By centering the text across the range, it makes it easier to see that the label or title applies to the entire range.

center text across cells

To center text across multiple columns, do the following:
1. Select a range that consist the text and the cells across which you want to center this text.

2. On the Home tab, in the Alignment group (or Merge & Center), click the dialog box launcher:

3. In the Format Cells dialog box, on the Alignment tab, click the Horizontal list and then select Center Across Selection in it:
4. Click OK.

centered text

How To Protect HDMI Inputs From Being Toasted By Lightning

So you have a super duper Home Theatre system complete with a jiffy HD Projector and a top-of-the-line AV Receiver linked by a 50-foot (15-metre) HDMI cable that snakes overhead in the ceiling. One end is connected to the HDMI input port of your overhead HD Projector while the other end is connected to the HDMI input port of your AV Receiver across the room.

What happens when there is a severe thunderstorm and there is one or more lightning strikes nearby? Does your system go on the blink? If yes, then you share the same bad experience as I have. The close proximity lightning strike has induced a large voltage spike  in your long HDMI cable that completely toasts your HDMI ports. If you’re “lucky” then maybe only either the Projector’s or the AV Receiver’s  HDMI port gets toasted. More likely, both will be zapped.

After that has happened to me 3 times in as many years, I decided to be proactive as I was getting embarrassed submitting my home insurance claim every year. Not to mention the inconvenience of the downtime pending repairs. I installed my solution early this year and having survived 2 severe thunderstorms since the installation, I am confident this is a viable solution. Read on.

hdmi-switchThe solution calls for two HDMI Switches. I searched for a simple 2-to-1 HDMI Switch but the simplest I found is this 3-to-1 HDMI Switch. I wanted a mechanical switch but finally settled for this electronic switch because it has a remote. This makes the switching convenient when the switch is mounted at the Projector, ceiling-high.

projector-hdmi-switchInstall one of the HDMI Switches to the HDMI Ouput of the AV Receiver. In my case, I connected Port 3 of the switch to the AV Receiver’s HDMI Output. The switch’s output port is then connected to the long HDMI cable. The other end of the AV-receiver-hdmi-switchHDMI Cable connects to Port 3 of the second HDMI Switch mounted at the overhead Projector. The output port of this switch connects to Projector’s HDMI Input port. That’s it. When the system is on, I use the remote to switch to Port 3 of both switches. When I have finished viewing, I switch to the un-used Port 1 of both switches, before shutting down the system.

The cost? Only RM80.00 (USD24.00) for each HDMI Switch.  I reckon that in the event of a really bad lightning strike, it’ll be a USD24 fuse. But so far, neither switch has failed.

Does this help you? Share your experiences here.

Rip, Compile and Burn Audio CD

Rip, Compile and Burn Audio CD

At some time, if you are a music buff, you may want to compile your own awesome playlist on an audio CD. And I don’t mean the MP3 compilations as you know MP3 is a lossy format. No sir, you want a compilation of the original lossless tracks, which means you have to rip or download or copy a track in either FLAC or WAV or WMA, which are lossless formats. Now, at this point if you start asking which of the three formats is the best to use, you’d be opening up an endless debate. But if you were to ask which one I use, I’d say all three but for the last-but-one stage I use WAV. Why WAV? And what about the final stage? Read on….

Disclaimer: What follows may not be the best or optimum way to rip, compile and burn an audio CD. However, it documents the methodology that I have finally settled on, after countless coasters made from useless CDs. Hopefully this will spare you the frustrations that I had endured up to now.

The free Tools I use:

1. Ashampoo Burning Studio

2. VLC Media Player

3. aTube Catcher

4. Audacity

5. iTunes

6. Windows Vista Acer Notebook with CD/DVD player/burner

1. To rip an audio track from a music CD, I use Ashampoo Burning Studio and rip it in the lossless WAV format.

2. To get lossless FLAC high quality audio tracks from the Internet, use Bit Torrent to search and download.

3. Use aTube Catcher to record streaming MP3 tracks and convert to WAV (yes, I know…the MP3 tracks are already lossy…but if no choice, then MP3 will do. Convert to WAV just to keep all the files in same format).

A great website to download MP3 songs is http:/grooveshark.com/

4. Two ways to convert FLAC to WAV.
Use VLC Media Player to convert the downloaded FLAC files to WAV.
Media->Convert/Save->Add (the Flac, MPEG4 files)->Convert/Save as Audio-CD (WAV).

5. Or use Audacity to tidy up the files (cut off excessive silence front and back; and also to normalise the track to avoid clipping due to excessive amplitude). Open the FLAC files, edit and Export Audio as WAV.

6. Steps 4 and 5 convert the tracks to WAV as iTunes does not recognise FLAC. Transfer the final WAV tracks to iTunes’ Library as a Playlist.

7. Use iTunes (the icons at the lower left corner) to burn Playlist to CD as Audio CD.

8. Caution:

a. Check capacity of the blank CD and the total tracks size. iTunes does not check this and will give an error (the dreaded 4450 code) at the end!

b. Avoid the “Burn At Maximum Speed Possible”…..again iTunes only gives the error at the end, if your CD brand cannot handle the high speed. After iTunes has made me a bundle of coasters, I wised up and throttled the burn speed down to 8X, which worked for me.

c. If you want the track names to be displayed by your CD Player (if it has this feature), then be sure to check “Include CD Text” before burning.

Footnote:

Why not just use Ashampoo Burning Studio to rip tracks from CDs to WAV or WMA format and burn the compilation as WMA (or WAV)? Unfortunately not all CD player plays WAV/WMA formats. That’s why I use iTunes to burn an Audio CD for full compatibility in all CD players.

If your CD Player supports FLAC, WAV or WMA, and you don’t intend to play your CD anywhere else nor share with anybody else, then just use a Burn Software (eg. Ashampoo Burning Studio, Nero, etc..) to rip the tracks into WAV or WMA format and burn the CD with either one of the formats to cut down the complexity of all the foregoing convoluted steps.

Remove a WiFi Network From Your Computer

One day you may suddenly experience a jerky, intermittent streaming of your favourite FM station on your PC. What happened? After all you have the whole 10Mbps bandwidth to your greedy self in your home castle. Read on for a possible scenerio.

Now you recall…a week ago, your service provider failed and your kind neighbour offered you the temporary use of his WiFi, which you can access from your house. One week later, you may have forgotten and your PC still automatically latches on your neighbour’s WiFi because depending on where you are sitting in your house, your neighbour’s signal may be stronger than your own WiFi. Now recall further that he subscribes to a different service provider and he has a slower connection ( 4 Mbps? ) compared to your 10 Mbps. Ah, so that’s why you experience such poor audio streaming of your favourite FM station. So how to remove that slower WiFi Network?

1.  Go to your Windows Control Panel and click on Network and Sharing Centre.

2.  Click on “Manage Wireless Networks” on the left hand menu.

3.  Right-click on the wireless network that you want to remove.

4.  The pop-up context menu offers you the option to “Remove Network”. But hang on….maybe you should just click on “Properties” and remove the automatic connection. Then you still have the option to manually connect if you need to.

Time to have tea now.

 

 

 

How To Fix A Plastic Bolt Without A Washer

While this Tip shows a quick-fix to a problem with securing a toilet seat, the same method can be applied to similar problems with other plastic situations.

seatA toilet seat, usually with a hinged cover, is bolted to the toilet bowl for a flush system. The bolt is usually made of plastic with one end flared to secure the seat to the bowl. The problem is, very often the flared end of the plastic bolt slips right through the hole of the hinge’s base. You can get a metal washer but it would rust in no time. Anything else (stainless steel washer, plastic washer, etc) would be too much of an effort to find/buy, if at all available.

 

 

seat-3A view of the component parts. The seat, the hinge, the plastic bolt and nut.

 

 

 

seat-5aSee the bolt inserted in the hinge but is able to slip out of the hole.

 

 

 

seat-6aAll that’s required. A chisel-like tool ( a large screwdriver will do fine ) and a hammer ( or a rubber mallet, if you are a stickler about using the right tool ).

 

 

seat-7Use the screwdriver+hammer to make indentations in the plastic bolt’s flared end.

 

 

 

seat-8Compare the two bolts: one has the indentations completed.

 

 

 

seat-9Both completed. Just a minor tip here: in a paired situation ( two bolts, two lamps, two batteries…etc.) always repair both/change both together. If one has failed, most likely the other will fail soon too.

 

 

seat-10The bolts now stay well in place in the hinge. Re-bolt the seat to the toilet bowl and we’re done..