Android Apps

New phone - moving the apps I care about over to it. Here's my list - what's yours?

Installed
Pocket (Read It Later) - lets you add any webpage or link to a queue to be read later, even if you aren't connected. Great for a subway or plane ride, and the equivalent of letting you open infinite tabs in the browser.

NewsRob - offline RSS reader tied to Google Reader. I'm open to recommendations for something better, the management features for this are so-so and the reading is meh.

Yelp

Draw Some - I love Pictionary.

Dropbox - free 2gb of synced files.

Google Drive - Google Docs, Office documents, and free 5gb of synced files.

My Tracks - I track my biking with it.

Play Music - streams music you've uploaded to Google Music for free over the web. Good for really long podcasts that would eat up too much SD Card space. Useless in bad connectivity areas.

Pandora - try creating a station with the Gladiator Soundtrack as the seed.

Weather Underground - better weather app

Wifi Analyzer - lets you see all the wifi points in your building, what channels they're on. I once used this to find a friend's apartment when I was lost in their building, using their wifi name like a homing beacon.



Not Installed
I specifically don't install several apps:

Google+ - no one uses this, and it's over 30mb.

Facebook - the official Android Facebook app is terrible. It's slow, it has very few features, it breaks all the time, it doesn't support basic things like tagging friends - why would I use it? I know why it's terrible and the short version is the developers at Facebook are very proud of it, but no one should endure it.

QuickOffice/other Office apps - Google Docs (renamed Google Drive) can now edit Office style files, so there's no need for another app for this

Skype - this app sounds useful but in my experience it's just the thing I wish I hadn't accidentally opened.

How To Convert All Text To Lowercase In Google Spreadsheets

1. Select the column, right-click, and click Insert Column Right.
2. In the first cell of the new column enter formula =LOWER(A1) (or whatever the first cell is of the original column).
3. Copy the cell with the formula in it.
4. Select the column and paste - Google Spreadsheets is smart enough to adjust the row number for each pasted entry. You now have a column with lowercase in it - but it requires that column to the left to still be there.
5. Select the new column again and copy.
6. Right-click and click Paste Special > Values only.

This wipes out the formulas. You can now delete the original column. Yay hacks. Obviously this applies to anything you could do with a formula in spreadsheets.