Archive for the ‘Software’ Category

Google Docs or MS Word?

Monday, April 14th, 2008

Recently our business has been experimenting with using Google Docs, and we’ve been having some limited success. I’ve noticed there are a lot of articles on the web about Google Docs, and they all seem to either praise the system as a Microsoft Office killer, or imply it’s just a kindergarten toy. So far it seems to be neither. Here’s why.

First - What is it?

If you’re recently emerged from a long sub-rock siesta, maybe you still haven’t heard of Google Docs, Google’s new online suite of office web applications. If you use other Google services such as GMail, then you already have an account, and in fact when you receive an MS Word or Excel document through GMail, you have the option of opening it as a Google Document.Google Docs Example

The idea?

  • Instead of firing up MS Office every time someone emails you a spreadsheet or Word document, you can open the document directly from GMail.
  • Where did you leave that document? At home? In the laptop? At work? Instead, just store them online and access them from anywhere.

The Good

The first time I used MS Office for collaborative work, I was co-writing a book (Slackware Linux 4 Unleashed). The revision process involved me sending a new chapter to the editors, receiving their revision comments, and sending back my revision. Sometimes we had several layers of revisions contained in the same document. It was a lot better than the old marker-on-the-printout method, but still slow.

Google Docs is a big step up from that. As with other online collaborative systems, several people can update a document simultaneously, in real time.

Recently at Swing Dynamite we used Google Docs to collaborate on making a schedule for an event, and sharing registration and financial details about the event. Here are some of the things I loved about doing it this way:

  • Chat. The Google Talk chat system is built-in, and as soon as you’ve invited someone to collaborate on a document, they’re available in a chat window when they’re editing the document. When we were working on our event schedule, this was very useful, and it saved a lot of time. Instead of getting together physically to meet, we saved time by doing all the revisions and discussions online. In total we took about 30 minutes instead of several hours.
  • See changes in real time. You can actually see the other person make changes as they happen. This is handy–you can easily respond in the chat window and discuss what they’re doing: “are you sure those numbers are correct?” This was useful for building our event schedule, and also for going over some of the numbers.
  • Permanently share. What I mean here is that, instead of having to email your colleagues every time you make a revision, they always have access to the most recent version.
  • Customizable notifications. In my case, I wanted to know when any update was made, so I had the documents set to notify me by email whenever there was a change. However, if I was only interested in looking over the final version, I could have turned notifications off. What’s nice is that unlike email collaboration, where typically you get emailed every time a collaborator deems appropriate, you choose how often you get pinged.
  • Surprise: Spreadsheet formulas work. That was my initial fear: that the formulas wouldn’t work, rendering spreadsheets basically useless. But in the simple spreadsheets we were collaborating on, the formulas and even formatting worked perfectly.
  • Soon: Even work offline. Google is also slowly rolling out an offline capability, enabling you to use Google Docs even without an internet connection.

The Bad

The system still has a lot of limitations, however. Here’s where we hit a wall:

  • Word processing is very limited. More to the point, usually when we use a word processor, we’re not just writing a strictly text document–if we were, we’d probably just send an email. Usually there’s a lot of formatting involved. When I tried collaborating on a staff handbook, I found that the version I uploaded ended up looking nothing like the original when I viewed it as a Google Doc. All the text was there–but none of the formatting. So if you’re collaborating on a Word document, I suggest using Docs in the early stages of collaboration, as you work on the text itself. Afterwards, import it back into Word and finish it off with style.
  • Spreadsheets: Keep it simple. I found Docs to be much more useful for spreadsheets. I didn’t encounter major issues with formatting or formulas, although I’d advise not trying to work with spreadsheets that contain complex formulas. The big difficulty, though, was in the limited functionality. For example, you can sort a column–but only the entire column. You can’t just sort an area without affecting the rest of the sheet. So to collaborate you’d want to make the spreadsheets fairly simple, or realize that you need to do more complex updates offline and then upload them. It’s a little annoying, but then it’s really just a return to the old email revision process.
  • Lossy Saving. That’s lossy as in loss of information: remember that if you upload a document that’s too complex for Google Docs, you lose all of the extra formatting. So you can collaborate and make changes, but even when you download the revised file, you’ll have to re-format it.

Is it useful?

The proof is in the pudding: I’ve started to use Google Docs more frequently after my recent experiments were a success. The key is that I wouldn’t work on a document for public release through this method… yet. However, as a method for sharing information between members of a project, Google Docs is a very useful tool, especially if your collaborators already use GMail. I’d especially recommend it for internal documents, not for collaborating on something your clients will see unless you switch to something more sophisticated in the final stages.

Where are they going with this?

Is it going to last? Between the enthusiasts crying “MS Office Killer” and the pundits claiming Google Docs is too limited… they’re both right.

The one thing we know about technology is that it improves. Today Google Docs is a useful collaborative tool, but in no way sophisticated enough to replace MS Office. In any case, there’s already a major alternative to MS Office, and completely free: OpenOffice. And yet MS Office still thrives. There’s no reason to think that Google Docs will kill MS Office tomorrow.

However, looking to the future, the entire reason OpenOffice exists as a completely free Office suite is that to a large degree, the Office application space is stagnant. Basically spreadsheets and word processing documents do what we need them to. Little vertical improvements aren’t really enough to charge money for. In fact, it really doesn’t make sense to me that anyone whole pay for MS Word anymore, when OpenOffice is available. So the lateral leap that Google has taken with Docs is essential. For now, Docs is just a limited (but very useful) online collaboration tool - not full-fledged Office suite. But as the technology improves, Docs may set the standard. Still, MS Office has a major asset if it can leverage the combination of its existing MS Office and .NET technologies combined with the Hotmail/Live system, behind their new Office Live Workspace edition.The question will be: who can do it the right way? So far Google’s been winning on that point.

In the meantime, my advice is to download OpenOffice and start using Google Docs for online collaboration.

Feedback, Iteration and Just Doing It

Tuesday, September 11th, 2007

One of the reasons that startups are often able to innovate in ways that larger companies can’t, is because they can cut a smaller feedback loop.  Large companies often take too long from noticing a problem to fixing it.  And part of the problem is that when five people are using your software and they notice a bug, you just fix it.  But when the latest version is used by millions of people, it’s more complicated.  Which missing features matter most?  Which bugs?  And what new problems will come from the bug fix?  The biggest problem, though, is that giants move slowly.

The key to improvement in anything–sports, public speaking–is feedback.  Feedback is even more important than knowing HOW to improve.  Why? Because if you know how to improve but have no feedback, you’ll never know how close you’re getting.  But with good feedback, you can simply try things at random until you start seeing an improvement.

That’s basically the biggest advantage a new company has, which is why great entrepreneurs always seem to be trying something new.  A large supermarket takes time to collect data on how customers react to a reorganization of the aisles, but the owner of a grocery store can just watch the customers coming in.  Where do they look?  What do they pick up?  What do they buy?  And who buys what?

Since small businesses can iterate so much more quickly, it makes sense to spend more time just doing it than thinking about it.  Your mistakes just don’t cost as much as they would cost the big boys.  And chances are that if you’re small, you’re probably able to maintain a better relationship with your customers, who are likely to forgive your mistake today because they can see it will be fixed tomorrow.

So just do it, get feedback, make changes, and do it again: iteration.

(Inspired by this post about iteration and software development.

Vista and Ubuntu: Somebody’s Grown Up

Thursday, July 26th, 2007

As I write this, I’m installing Linux.

The funny part about this is that I’m installing Linux on the same computer I’m working on. Using something called a “Live CD” I’m able to actually run Linux, complete with a web browser, while I install the system. This is insanely cool.

I’ve always had a love/hate relationship with installing operating systems. My geeky side enjoys the excitement of the upgrade, of trying something new. But the business side of me knows that upgrading or installing a new operating system always means a few weeks of lost productivity. Sure, months later everything might work better, but that first day of installing the operating system and new drivers, re-installing all the old programs, migrating data, re-configuring settings… it’s a lot of wasted time.

Having just installed Vista on a new computer, I had mixed feelings. The install was fairly easy, although I had to install some new drivers, and with Vista’s driver reputation, who knows if they work properly. The look and changes to the operating system seem decent, little things like the way that you navigate through folders, or additions like more sophisticated CD burning programs.

However I also found Vista to be surprisingly slow, and I encountered some small bugs that led to some bigger problems. This morning while doing some updates, the system crashed and wouldn’t start up again without recovery.

(Linux has finished installing now. No joke.)

Ubuntu-Logo

I figured that would be a good reason to try installing Linux for dual-booting. Already I’d tried out a new brand (ie. “distribution”) of Linux called Ubuntu. The cool thing is that you can use a Live CD to try out the system without even installing it. I found that even running from a CD, Ubuntu was faster than Vista.

I started using Linux back in ‘94 or so, and since then I’ve used both Windows and Linux on a regular basis. The big question I’ve been asking myself for years is, which one makes the better business case? And since the introduction of OS X, MacOS has been looking pretty good, too.

What we’re seeing is a huge convergence. It used to be that MacOS was a beautiful system for artists with a rickety back-end, Linux was the technologically superior system that only geeks could understand, and Windows was somewhere between the two, making it the best option for business.

But now it’s different. MacOS now runs a BSD system under the hood, putting it technologically on a par with Linux, and Windows has both improved its usability and shifted to using its server-oriented technology (eg. NT-based OSes) even for home users. Finally, we’ve seen many groups try to create Linux brands for the masses. And it seems that Ubuntu is succeeding mightily.

Currently, I’m still using Windows because of a few minor things: needing to verify web sites in Internet Explorer, which is possible but not easy under Linux; the slightly greater ease of use with movies and multimedia; and the comfort of knowing that all of those popular Windows programs will run.

Most of that is changing. Multimedia seems to work just fine with Ubuntu, and the system is at least as easy to use as Windows. Updating the system is extremely easy, and there are tons of programs included right off the bat. In fact, as for the programs, my preferences are mostly with the open source software in any case. It’s just a sensible business choice: the programs do everything I need them to do, are easy and quick to download, and cost nothing.

Of course, we’ll see what I think in two months, but so far Ubuntu may be the first time I’ve felt Linux was a definitively good choice for business, especially for entrepreneurs starting out, who don’t have a lot of investment in other software. People have been saying this for years, from the first appearance of Red Hat, but now Linux has really grown up.

Now it’s time to boot into my new Ubuntu system.