GOOGLE SHEET cell data linking

To make a link to ONE cell on another sheet (within the same spreadsheet file) in GOOGLE SHEET :

*  =SheetName!A1

*  ='Long Sheet Name'!A1


For a range (MORE THAN ONE) of cells :

=arrayformula('Long Sheet Name'!A1:C4)

For the whole columns :

=arrayformula('Long Sheet Name'!A4:C)

For the whole rows :

=arrayformula('Long Sheet Name'!A3:4)

Make sure that the target cells are empty when using =arrayformula, or it will give out error message.

==========

To make a link to a cell or a range of cell on ANOTHER file,  use =ImportRange function.

*  =ImportRange("file key";"Sheet Name!A1")

Blogging tool : Open Live Writer

I used Google Drive and Docs heavily.  I do blog occationally on blogger.com.  Both blogger.com and Google Docs are owned by the same company, but somehow, it is not possible to publish a Docs to blogger.com

Microsoft came to the rescue!!! :D

Their free product Live Writer can publish directly to blogger.com.  It was ported and called Open Live Writer (under .NET foundation).
Open Live Writer is like a mini and simplified word processor with the main feature of being able to publish to many major blog such as Wordpress and Blogger.com
This was my first test.

Place to find older version of iTunes (and other apps)

Maybe at some point in your life, you just want to downgrade your iTunes.  This is the place to go http://www.oldapps.com/itunes.php

Why do you want to downgrade your iTunes??  I don't know.... maybe you're trying to prison break???  :P

iPhone stucked and iTunes won't recognize it? It's DFU time! :D

Once in a while, when you're toying with your iPhone (for example trying to jailbreaking or trying to unlock a locked iPhone), your iPhone can get confused and it will just stuck like the image on the left.  Worse, your iTunes won't recognize your iPhone too.

What to do?

Do the DFU thing.

1.  Shutdown your iPhone by holding the power button until it shows "Slide to Power Off".  Slide to power off.

2.  Make sure that iTunes is running and the iPhone is connected thru USB to your computer.

3. This is important.  Press HOME and POWER button at THE SAME TIME for 10 SECONDS.  After that RELEASE the POWER BUTTON *BUT* KEEP PRESSING the HOME BUTTON.

4.  Keep pressing HOME button, until iTunes recognize your phone, and ask you whether you want to restore it.

A pretty good video guide can be found here :
http://www.idownloadblog.com/2010/12/01/how-to-put-iphone-in-dfu-mode/

or search YouTube.  There're tons of these videos.

How to softmod Wii so you can play "backup" games.

This site has pretty good instruction on how to do it : Complete Softmod Guide

Pic source : Life Hacker

How to downgrade iPhone 3G(S) from version 4.x.x to version 3.x.x.

Why do I want to do that? you may asked.
 1. If you don't know why, then why bother.
2. Because version 4 is way way to bloated for ya old iPhone. If ya aint gonna miss the extra feature, or if you don't know what's the different between 4 and 3, then why bother.

Article from Life Hacker

Installing VNC in Debian

To install VNC server in Debian :

apt-get install vnc4server

To install VNC viewer / client :

apt-get install xvnc4viewer

After installing the viewer, type
Xvnc4viewer [hostname]