February 21, 2011

new tab in Google Spreadsheet

Posted in office tagged , at 7:23 am by weiszguy

I have a couple Google Spreadsheets that I use to track annual items. Every year, I add a new tab, and I keep the old tabs around for reference.

I have these spreadsheets bookmarked in my browser so I can get to them quickly without going through the docs list on Google Docs. The bookmarks are great, but after I added a new tab for 2011, the spreadsheet would still open in the old 2010 tab.

I discovered that the spreadsheet would open on the old tab if I used the bookmark, but it would open on the new tab if I used the docs list. The difference had to be the text of the URL, right?

Bingo.

Here’s the text of the URL from my bookmark:

https://spreadsheets.google.com/ccc?key=0AujXCaDA7ic1ctobe0oxN2N3OU5tSWZjc25rbUprSEE&hl=en#gid=5

and here’s the text of the URL from my docs list:

https://spreadsheets.google.com/ccc?key=0AujXCaDA7ic1ctobe0oxN2N3OU5tSWZjc25rbUprSEE&hl=en#gid=6

The ‘gid’ number at the end of the URL is a tab number. In this case, the spreadsheet will open on tab number 6, instead of tab number 5. I can open any tab in the spreadsheet just by changing that last digit.

If you’re having a similar problem, the solution is to delete your bookmark, open the spreadsheet from the docs list, then add a new bookmark.

January 5, 2011

why you should use Google Docs

Posted in office, technology tagged , at 7:18 pm by weiszguy

Google Docs (http://docs.google.com) is an online office suite par excellence.  It has all the components you have come to expect from an installed office package (word processor, spreadsheet program, presentation program), plus a few others (forms and drawings).

Google Docs exists entirely online.  You don’t have software on your computer, you don’t have files on your computer.  All you need is access to the internet.

Benefits:

  • You save all your documents online.  You no longer need to worry about running out of space on your hard drive.  And you don’t have to worry about backing up your files, either.  Google’s systems are infinitely redundant.  If your hard drive crashes, you won’t lose anything.
  • You don’t have to try to remember which computer a certain file is on.  Your files are on the internet and you can reach them from any computer with internet access.
  • You don’t have to try to keep multiple copies of a file in sync.  For example, a certain file is on your home computer, so you bring a copy of the file to work so you can have it there, too.  Now you have multiple copies, and you have to think about keeping all your changes consistent across all your copies.
  • You don’t have to install any software.  You also don’t have to apply any patches or upgrades.  When Google makes changes to their applications, you see it automatically when you log in.
  • You don’t have to email documents to other people.  Attaching a document to an email usually isn’t all that hard, but it’s one less step nonetheless.  Plus, no more merging changes from other people with the master document on your computer.  If you want someone to see the document, you just invite them!
  • You can have multiple people working on a document at the same time.  You can see where each person is in the document, and you can see what they are changing.  Again, this also saves the step of merging changes from multiple copies.
  • If you absolutely need a local copy of a document, you can download it in any of several common office formats, and use your local software to edit it.

If you don’t like Google…
Some folks have an aversion to all things Google.  If this is you, Zoho (http://docs.zoho.com) is another great option for you.  Everything I’ve said about Google Docs also applies to Zoho.  Check it out.