Could Google and Microsoft’s online advertising model change the pricing of all Web services

February 20, 2008

Perhaps this micropayment model is also the future of Web services or software as a service (Saas). Soon, companies like and Qualys could be offering their on-demand services with the same pay-as-you-go pricing as Google charges for sponsored links. “There’s a growing demand of the businesses and enterprise to be treated as a customer,” says Yisrael Dancziger, CEO and president of Digital Fuel, a company that makes software specifically for measuring SaaS utilization.

Reat at

Online Software: Buzz vs. Business

February 15, 2008

Online software is supposed to make business computing cheaper and easier. But cost and simplicity don’t matter if the software doesn’t do what a company needs it to do. That is currently one of the challenges facing corporate-technology leaders. Even the ones who favor online software often can’t find a product that meets their needs. And ultimately, that is what is most important for businesses.

Read at

The Truth About Software as a Service (SaaS)

February 14, 2008

“What if we created a utility for enterprise automation? Then you don’t have to create a data center! Then you don’t have to have a CIO!” That was CEO Marc Benioff in June 2003, selling the benefits of the then-new concept of software as a service (SaaS). Fast-forward four years, and and dozens of other companies are inundating business users and CIOs alike with pitches for all sorts of SaaS applications. Right now, SaaS seems to be everywhere.

Read at

Strategies For Growing A Great Services Business

November 21, 2007

By Julie Giera,

Of the top 35 global IT vendors, 22 are either services providers or product companies with a large services business like IBM. This shift to services has been accelerating over the past five years among technology vendors looking to drive recurring revenues, deeper customer relationships, and additional channels for their products. Building a great services business is tough for many technology vendors, because the things that contributed to their success as product companies are the very things that can be their downfall in services. Forrester has identified the top ten strategies technology vendors can employ to build a great IT services business.

  1. Stick to services that closely tie in to your products’ strengths.
  2. Organize for services separately from products.
  3. Hire experienced sales people.
  4. Limit the services portfolio.
  5. Automate the proposal process.
  6. Market your message through multiple channels.
  7. Limit risk in very large contracts.
  8. Develop the channel and deal with conflict early.
  9. Weigh a direct service model against a subcontracting arrangement.
  10. Know your value proposition: Wal-Mart or Tiffany’s?

Source:Forrester Research

Go SaaS, Young Man

November 16, 2007

Venture capitalist Mike Fitzgerald says he’s more inclined to invest in software startups that embrace the service model.

Fitzgerald, founder of Commonwealth Capital Ventures in Waltham, Mass., says SaaS is a win-win for the software company and customers. Sales cycles are shorter for SaaS startups because it’s easy for potential buyers to try the product. And if a customer starts with a limited rollout, a department head can pay out of discretionary budget, or even use a credit card, instead of sending a purchase order through normal channels.

On the customer side, capital expenditures for SaaS are significantly lower than a traditional premises deployment, and the product gets into users hands more quickly. Customers begin extracting value right away.

A service model also provides a predictable revenue stream for the software company, because payments come in every month. That means the company can make more accurate predictions about its quarterly numbers.

By contrast, premises software vendors face more uncertainty. Because they get a large portion of revenue from the initial license sale, the timing of a purchase can make or break a quarter.

“Oracle taught the enterprise software crowd to buy at the end of the quarter to get a better deal,” says Fitzgerald. “And if you miss an order, you blew a quarter and now on the Street you’re a bum.”

The downside is that SaaS vendors don’t get a large chunk of license money up front. The number of new accounts a SaaS vendor has to open is a multiple of a traditional software company.

“You need to get an accumulation of payments to be large enough to support your operation,” says Fitzgerald. “It forces a SaaS company to be more productive for every dollar of sales and marketing.”

And as with any venture, SaaS startups need to identify an underserved market. Translation? Fitzgerald has no plans to invest in a CRM startup.

That said, Fitzgerald is bullish on the service model. “SaaS is the future of the software business.”


Third Wave Of SAAS On the Way

November 16, 2007

By Jessica Davis

Software as a Service’s next wave of opportunity will come in the form of vertically-oriented industry hubs or exchanges that have the potential to turn traditional customer relationships upside down for ISVs and VARs.

That’s according to Colleen Smith, managing director of SAAS at Progress Software, a provider of tools and infrastructure that ISVs need to build applications.

Smith, a former industry analyst, joined Progress two years ago and has been part of the company’s effort to help transition its ISVs to also offer SAAS to customers by enabling them to add multitenant capabilities and the ability to integrate with other applications, among other capabilities.

The first wave of SAAS, then cast as being offered by ASPs (application service providers), consisted of providers offering standalone applications to customers in order to lower the customer’s total cost of ownership.

“We think that wave has come and ended,” Smith said. “It was the end of that wave that made the industry focus more on software as a service.” And that has been the second wave as companies went from offering a single-hosted application to integrated business suites such as those from and SAP.

But with the introduction of software concepts such as the ESB (Enterprise Service Bus), ISVs are creating applications that can be integrated with any number of applications or services from other companies, Smith said. That’s opened up a whole new realm of opportunities for ISVs to work together and with VARs and for companies to expand their capabilities.

“This is the trend that is going on now,” Smith said. “It still means that you have traditional channels or traditional go to market, but now there are more ways for ISVs to work together as long as they’ve integrated their business applications.”

For some companies that means expanding their offerings vertically, Smith said, making for some interesting business combinations that go beyond what the industry traditionally has seen. For example, legal and news content provider Lexis-Nexis recently acquired a Progress Software ISV, Visual Files. Now Lexis-Nexis is looking to offer not only content but also software services to their existing customers of news and legal information.

“We are seeing a move from horizontal business processes to more of a vertical play,” Smith said, as companies look to offer more services to their existing base of industry clients rather than diversify to other industries. “That’s just one of the acquisitions that has happened this year. Next year we will see the building out of hubs or exchanges.”

For example, Progress is currently working with EDS on building out a vertical industry travel hub.

“This trend will be great for the small ISV,” Smith said. That’s because, in this model, large business service providers are beginning to pick up applications from smaller ISVs, bundle them together and offer them to customers, making the large company the reseller for the smaller company.

To take advantage of this new opportunity, ISVs need to change their expectations. First, they must adjust their idea of what a deal pays because instead of getting a percentage of a $100,000 deal, they may instead get a portion of a $100 a month deal.

Second, channel partners must figure out who is going to own the customer, and, in some cases, they must give up that relationship.

The question between the ISV and the VAR is who will host and who will service the customer,” Smith said. “Somebody has to say, ‘I’m going to be the owner,’ and if ISVs don’t give up customer ownership, they may not be successful.”


Gartner: SAAS to Make Big Jump in Business Software by 2011

November 14, 2007

By John Hazard

More than a quarter of business applications bought and sold in 2011 will be delivered as software as a service, according to Gartner projections.

A report released Sept. 26 by the research firm said that adoption is well on its way, with SAAS accounting for roughly 5 percent of business software revenue in 2005, and more in some markets such as CRM—8 percent in 2005 and an expected 12 percent this year.


On Software as a Service (SaaS)

November 14, 2007

By Steve Keifer, Vice President, Global Marketing, and Mark Morley, Industry Marketing Director, GXS

Industry analysts, software vendors, technology press and even the investment community are all talking about Software as a Service or SaaS. But what is SaaS? And how is it different from traditional software approaches? More importantly, how is it relevant for your business? The concept behind Software as a Service (SaaS) is very simple. Instead of licensing a perpetual software license, SaaS users subscribe to an application for an ongoing monthly recurring service fee. The SaaS vendor hosts the application in its own data center providing all the maintenance, upgrades and support activities. This, of course, differs from the traditional software model in which a corporation customizes, manages and operates the software themselves.

SAS model
How do SaaS Environments Work?
Introducing SaaS 2.0


Two More Challenges To Microsoft Office: Glide And ThinkFree

October 31, 2007

By Ron Miller

When Microsoft completely redesigned Office 2007, rendering it completely unfamiliar to even the most experienced users, it opened a door for a number of alternatives — some of them online. And while Google and Zoho are the names that most people are familiar with when it comes to online office applications (check out ), there are other — perhaps better — services out there.

Two of these services are ThinkFree Online and Glide. Both offer basic office functionality, as well as automatic synching to allow for access to your content when you’re offline. Glide includes not only office productivity applications, but also links your mobile and desktop computing environments and provides document-level security and media file sharing.

Both programs can open Office legacy documents with basic formatting, but each had some trouble with more complex documents, especially with Word numbered lists (but then Word has had trouble with numbered lists for years, so it should come as no surprise that these programs have trouble translating it). Neither can deal with an Open Office formatted document. While you can create fully formatted documents, slide show and spreadsheets, neither product’s spreadsheet can deal with sophisticated options such as pivot tables (although Glide promises that its upcoming offline version of the spreadsheet will have pivot table and other advanced functionality).

So before you make the leap and fork over the big bucks for Microsoft Office 2007, take a look at these two very reasonable alternatives.

ThinkFree Online aims to be a pure Microsoft Office alternative, offering a word processor, spreadsheet, and presentation program. The company actually offers several version: the free Online edition, the Desktop edition ($50). a Server edition )$30 per user per year), and a Premium version (currently in beta), which adds online/offline file synching.

ThinkFree is the only Office alternative I’ve seen that actually uses the same .DOC, .PPT, and .XLS extensions as Microsoft (spokesperson Jonathan Crow says that his company actually reverse engineered the Microsoft Office file formats beginning in 1997). That means you can simply open your native Office documents (Office 2003 or earlier; ThinkFree is working on Office 2007 DocX compatibility for a future release.) seamlessly, at least in theory. In reality, it really depends on how complex your formatting is and how many of Microsoft’s more advanced features you have used.

If you keep it fairly basic, the documents open and display as they would in Office, but ThinkFree can’t play sound or animations in imported Powerpoint documents, pivot tables in imported Excel files, or complex formatting from Word documents. That’s because the ThinkFree Office program equivalents tend to stick to simpler functionality than Microsoft. If you are looking for every bell and whistle, this is probably not for you.

ThinkFree Premium, which adds syncing to the product, uses the concept of a Webtop (like a desktop on the Web) where you store all of your personal documents. Once you move a document from the desktop to the Webtop, whenever you change the document, either online or offline, ThinkFree automatically syncs the two versions. When uploading, you are limited to a maximum 10MB file size per file, which could be problematic for users who have larger documents. When uploading, by default, you have to browse for each document one at a time, but hidden away (if you look closely) is a feature that enables you to drag and drop multiple files or folders from your computer onto the Webtop, which is a lot easier than uploading a file at a time when moving multiple files.

If you have been an Office user (at least, prior to Office 2007), you should know your way around the ThinkFree office applications. ThinkFree uses the tried and true menu bar/toolbar metaphor which we have all grown familiar with over 20 years of GUI use.

One departure from Office is the choice of two editing modes: Quick Edit and Power Edit. As the names suggest, you can use Quick Edit to make minor changes to your document, but if you are writing a document from scratch or need access to more advanced formatting and editing functions, you need to use Power Edit. ThinkFree designed the QuickEditor with AJAX to make it load faster and be used for smaller editing jobs, while the Power Editor is programmed in Java for more advanced functionality, but in testing I found it hard to discern between the two.

ThinkFree offers a nifty blog posting feature, which is designed to work with major blog platforms such as Typepad, WordPress, and Blogger. You simply enter your user name and password and select how you want to display your ThinkFree content — as embedded text or as an icon the user clicks to open. When I tested this feature with my Typepad blog, it worked without a hitch.

While ThinkFree needs to upgrade the size of documents you can upload, it provides a familiar environment and deals fairly well with legacy documents.

Glide gives you office applications in a comprehensive online operating environment that works seamlessly between your mobile and desktop versions.

Glide takes an entirely different approach from ThinkFree. Instead of aiming to be a one for one Microsoft Office alternative, you get an online operating environment where in addition to a word processor, presentation program, and spreadsheet (which is due to be released at the end of October). You also get e-mail, an online meeting tool, automatic file syncing, sophisticated file security, media file sharing, a blogging tool, and a simple Web site building tool. If you wish, you can also import your browser bookmarks and contact list.

What’s more, the mobile and the desktop versions synch automatically, so any changes you make — whether on your desktop or mobile device — update instantly on each platform. Glide is coming out with a business version at the end of October that will let you to work locally on your hard drive, as well. There are versions for Linux, Mac, and Windows. And while Glide is free with 2GB of storage, you can increase that to 10 GB ($4.75/month) or 12 GB ($49.95/year).

Glide’s home page offers you a selection of all the applications that it offers; tabs along the top give you access to your mailbox, address book, and other tools. Like Microsoft Office 2007, the Glide office applications have foregone the menu bar in favor a ribbon divided up by task; however, I found Glide’s design was cleaner and easier to use. In addition, to the ribbon with traditional Office functions, when you edit a document, three tabs along the left side of the window enable you to share your document, invite one or more people to a chat or e-mail the document. However, the overall screen design isn’t quite as crisp as it could be; Transmedia needs to find a smoother way to incorporate these tabs.

Glide clearly separates itself from both ThinkFree and Office 2007 with its security features, which far outdo just about any other tools on the market. With Glide you can not only make your document read-only, you can set it so the recipient can only read it one time (or however many times you decide). You can control if the user can download attachments or reply with attachments and so forth, giving you total control on a file by file basis and even on a recipient by recipient basis (in an e-mail with multiple recipients).

Business users will appreciate the seamless integration between the mobile and desktop versions. The mobile side has been designed to do tasks with finger taps, making it a great match for the iPhone, and any changes you make to your documents on the mobile side sync instantly with the desktop. You have to download a separate syncing tool to your desktop computer, which provides a way to move content such as documents or photos from your desktop into the Glide system and synch any changes you make to those items. You can set the sync tool to watch files or folders to update the corresponding online folders automatically.

It would be remiss to have a review of Glide without discussing how well it handles media files whether it’s video or audio, regardless of the format. You simply send a media file to a recipient and apply whatever rights you want (just as with a document); Glide ships the file with its own media player.

Glide needs to work on handling Office documents better, but overall it offers a great package with security that dwarfs offerings from Microsoft and other competitors. You are not only getting fairly sophisticated office applications, but also the ability to share files and interact with other users, regardless if they are part of the Glide system or not. Because you’re dealing with a Web interface, the capacity to move and share files between desktop and mobile environments is seamless — for example, if you make a change on a file using your desktop, it will be immediately reflected on your mobile device.

The interface could still use some tweaking, but overall, Transmedia has built a system that includes all of the tools you need to create and share documents and collaborate with your colleagues securely with access from wherever you are.

Source: Information Week

Google Vs. Zoho: Can Either Replace Microsoft Office?

October 30, 2007

By Serdar Yegulalp, Barbara Krasnoff

The gold standard for office productivity has become Microsoft Office — a suite of applications used by most of us in our day-to-day business and personal activities. While there have been a number of commercial (Corel WordPerfect Office) and free ( alternatives available, it’s the new online applications that have been causing the most talk — and, possibly, offering the most promise.

Until recently, the idea of online applications replacing locally-installed software was, to say the least, impractical. In fact, before a majority of computer users were on broadband connections, it would have been completely useless: if you’re only online a few hours a day you can’t confine your word processing and spreadsheet activity to those hours.

That has changed in the last few years. Most of us are online most of the time — certainly, we have continuous access to the Internet at work and at home. As a result, using an online word processor or calendar app sounds a lot less ridiculous than it did before. And there are some things current software applications do rather badly (such as sharing files for collaborative work) that online apps are a lot better at.

The idea of committing to a Web connection for your basic tasks is still a tricky one, though. While the Internet may be ubiquitous in homes and offices, getting online from your commuter train or while you wait for your kid to finish dance class is problematic at best. In addition, glitches in broadband service, especially in remote areas that depend on satellite service, are common enough that the likelihood of even temporary loss of access to a word processor or spreadsheet can make many of us a bit nervous. But if you’re willing to take the risk, two Web services have taken the lead in offering online applications that have the potential to, one day, knock Microsoft Office off its pedestal.

But can Google and/or Zoho really challenge something as entrenched in the marketplace as Microsoft Office? In the following pages, we compare each of these online contenders to the leader of the pack by matching them up to six of Microsoft Office’s applications: Word, Excel, Outlook, PowerPoint, OneNote, and Access. (Note: There is currently no database application such as Access in Google.) How do Google and Zoho rate? Is it time to switch, or are the two online services still second-raters when compared to Microsoft’s established frontrunners? Read on, and see what you think.

Introducing: Google

Google, which has joined Microsoft and Apple as a contender for “tech company most likely to take over the world,” has been slowly buying up interesting online applications and integrating them into its own line of advertising-supported products. It has accumulated a wide range of applications: word processing, e-mail, photo album, simple Web site developer, blogging application, and so on.

However, while there is a great deal of value in the variety, there is little to no attempt to organize them into a cohesive whole. The nearest that Google comes to this is in its Google Docs application, which combines a word processor, spreadsheet app, and presentation package. Calendar and Gmail, apps you’d normally expect to be part of a productivity suite, are totally separate. You can use Google’s home page, iGoogle, to organize some of these onto the same page, but it’s not quite as efficient a method as that used by, yes, Microsoft.

Introducing: Zoho

Zoho’s motto is “Work. Online” and its aim is to provide you with portable replacements for many of the programs you expect to find installed on a desktop PC. The analogy the folks at Zoho use is a desk phone vs. a mobile phone: the fact that you can take your cell phone nearly anywhere (as long as there’s service) gives it possibilities a regular phone doesn’t have.


Despite Zoho being new to the game, it’s been adding applications and features to its online office suite with persistent regularity; for example, it recently added e-mail to its feature set. Zoho even has some applications, such as its Creator database, that many hard drive-based packages do not.There’s no question about it: Zoho is obviously serious in its bid to offer people at least some of Office’s functionality without the price, and with the added bonus of being able to work anywhere that there’s a Web browser and an Internet connection.

Replacing Microsoft Word: Zoho Writer

Writer, Zoho’s word processor, has been designed to sport roughly the same level of functionality as “classic” Word (Word 97 through 2003). It offers the same clutch of frequently used features that also turn up in programs like AbiWord or The editing features are nowhere near what they ought to be compared to even low-end Word clones on the desktop, but Writer balances its shortcomings with some collaborative features that are interesting and potentially useful.

At first glance, Writer looks and behaves like it should: a word processor, emulated via a Web browser’s interface, with most of the controls behaving as you might expect. Copying and pasting text from existing Word documents preserves a lot of its formatting, but you’ll probably want to use the Import function to bring in existing .doc files. If you want to convert documents en masse, you can e-mail them to an address specially generated for your Zoho account and wait for them to show up in the My Docs panel on the left-hand side of the screen. Documents can also be imported from a URL, though when I imported an HTML document from my site some of the images inexplicably showed up broken.

While Writer works for casual use, I found that many things I would take for granted in a full word processor are simply not there. Page headers and footers, for instance, cannot be edited at all; documents have an automatic “Page x of y” footer inserted on each page. There’s no equation editor, either, so anyone doing scientific or technical work will be stymied (although I suspect they’d already have spent the money for a desktop suite instead of using a service like Zoho). Printing, likewise, is limited to the way the browser itself handles print jobs. When I tried to print a simple document, I got extraneous headers and footers supplied by the browser itself.

Writer seems to work best as a text editor rather than a full-featured word processor, since the formatting and construction of documents is limited by what’s possible in a Web browser. Sometimes this shows up in unexpected ways: One page I imported included some JavaScript that caused images to zoom to full size when clicked, and the scripting was still able to run while the page was in the editor. I worried about what possible effects retaining such functions might have on the program at large.

I also kept running into the rough edges of what is still essentially an alpha product. Image handling seems to be very spotty. I sometimes couldn’t edit the attributes of imported images, and the only real image-editing option possible with an inserted picture is to resize it. Your best bet is to make sure whatever images you’re working with are as finished as they can be before you upload them.

The collaborative features, though, are what make the program truly useful. A document can be published, which allows other people to submit comments on it, or you can share documents with specific people, essentially sending them an e-mail inviting them to work on it with you. Shared documents can be read-only or marked as read-write to allow others to make changes. It’s a lot cheaper than setting up a document server for Microsoft Office — but at the same time, you have to keep in mind the constraints of the program. I liked the export-to-PDF function — probably the best way to preserve document formatting — except when the export function inexplicably yielded up a blank file.

Replacing Microsoft Word: Google Docs

When Google bought the online word processor Writely in 2006, the app was already attracting attention. It’s been substantially tweaked since then, but it remains a very useful tool. You want to do some quick word processing for your blog? Perfect. You want to write a letter and share it with your family? Absolutely. You want to construct a formal report with headers, footnotes, and other interesting formatting? Time to go back to Word.

Google’s word processor is part of what was once known as Google Docs & Spreadsheets, and which is now called Google Docs (probably because it also includes Presentation, Google’s new slideshow application). All three applications are accessible through a single Google Docs interface that offers up a list of current documents that can be organized by name, date, or folder; topics at the side allow you to filter the list according to folder, type, or who you’re sharing with. You can either start a new document or upload HTML, Word, .RTF, .ODT, or .SXW (StarOffice) documents up to 500KB in size.

The working interface of Google Docs is a model of simplicity. A drop-down File menu offers basic save/print options; you can also export your document as an HTML, .RTF, Word, OpenOffice, .PDF, or text file, get a word count, or do a find and replace.

Three other tabs offer access to Edit, Inset, and Revisions features; as you click on each, you get the associated toolbar below. The Edit toolbar offers basic formatting functionality: cut/copy/paste; bold, italics, underline; font, size, color, highlighting; bulleted and numbered lists, flush left, right, and center. The Insert tab lets you place links, comments, tables, bookmarks, separators (for instance, page breaks) and special characters in the text. Revisions (which is available for spreadsheets and presentations as well) gives you the chance to revert to past versions of your document.

That is pretty much it. If you want page numbers, headers, or footers — sorry. Don’t even think about more complex print formats like columns or indexing. Google Docs is mainly for day-to-day tasks, especially if your text is eventually meant to be posted on the Web. In fact, the Share and Publish features, which are accessible via two tabs on the right side of the working area, are the major strengths of the Google applications.

Share lets you invite friends and colleagues as collaborators (with full editing capabilities) or viewers; you can give your collaborators permission to invite others. Another feature, the somewhat confusingly named “Invitations may be used by anyone,” actually allows you use mailing lists to invite groups of users (who must have a registered Google account in order to edit the document).

I’ve found the Share feature to be very useful when working on documents with other people — even in real time (a discreet message at the bottom of the window lets you know who is currently editing the document). You can also publish your document to a Google page (the URL is assigned by Google) or to your blog. Unfortunately, however, there is no way to undo any specific changes to the document. You can see who made which changes by checking the Revisions area, which color codes the changes.

On the whole, Google Docs is a good basic word processor, especially if you tend to live online. However, most of us will still need to keep Microsoft Word around for our professional word processing.

Replacing Microsoft Excel: Zoho Sheet

Sheet is one of the more polished and functional of the Zoho applications. It’s an almost note-perfect replacement for Excel or similar products — perhaps because a spreadsheet lends itself a little more easily to being replicated in a Web browser than, say, a word processor. And yet there are still some things that get in the way.

If you have existing spreadsheets you want to import, Sheet lets you do this by uploading files directly through a browser or pointing to a file somewhere on the Web. Excel 97/2003 documents, OpenDocument and OpenOffice 1.x spreadsheets, and plain old .CSV files are all supported, but as of yet there doesn’t appear to be a way to e-mail documents to be converted into Sheet (as with Writer). Sheet also makes a best-effort attempt to preserve the formatting of the imported documents, including hyperlinks.

The list of math functions available is pretty impressive — there’s dozens of them in the full list — and when you insert a function in a cell you can browse the function list by category (financial, statistical, engineering, etc.) to make it easier to find what you’re looking for. Better yet, there’s full contextual documentation for each function.

Some limitations of the program, however, really frustrated me. Inserting functions or formulas didn’t always work — I sometimes had to save the document, close it, and reopen it to get the computed formulas to show up. Another frustration: you can’t input a range of cells to be arbitrarily selected. This would make it possible to select a range of cells that is too big to fit on the screen, which right now is next to impossible.

What I also kept running into, again, were limits of either the program’s design or the fact that it was running as a browser document. You can select a range of cells by clicking and dragging (as is done in just about every other spreadsheet), but if you right-click, suddenly you’re only getting a contextual menu for the one cell you had the pointer over.

Once again, it’s the collaborative functions that make Sheet really useful. You can publish individual cells, ranges of cells, or share whole sheets or workbooks with specific users. The export-to-PDF function is also useful — in fact, that’s probably the best way to get consistent output from the Zoho suite for printing.

The biggest drawback to the program is something I saw consistently throughout Zoho: often you’re at the mercy of what a Web browser can do. With Sheet, though, I have confidence the programmers can find elegant ways to work around those limitations and make a good program even better.

Replacing Microsoft Excel: Google Spreadsheet

Spreadsheet is one of the three applications that makes up Google Docs. Like the word processor, it is a solid basic product with little of the sophistication of its MIcrosoft counterpart.

For those who use spreadsheets at their most basic, the Google application is very simple to work with. A tab titled Formulas gives immediate access to the most popular operations (Sum, Average, etc.); click on the “More” link, and you get a pop-out box that offers a wide selection of operations, organized by type (Math, Financial, Logical, etc.). Be careful where you click, though; once you have an operation open, any cell you click on becomes part of that operation, which is handy if you’re careful, but in my case, it resulted in quite a few extraneous entries.

Because Spreadsheet is definitely a work in progress, you may find yourself occasionally resorting to workarounds that later caused problems. For example, when Spreadsheet was new I needed a series of dates (such as such as 01/01/2007, 01/02/2007) in my A column. At the time the program didn’t have a feature to automatically create a range of incremental dates. I created a workaround that added +1 to each date, but when I deleted one of the dates, it created havoc with the rest of the series. (Google has since added that feature.)

The charting features, accessed from the Edit menu, work well, but your options for customizing the charts are definitely limited. You can create five types of charts — column, line, bar, pie, and scatter — and several sub-types of each. You can specify which data to include and label the two axes, but that’s about it. Even for simple charts, that’s not quite enough. For example, when I created a chart based on two columns of data, one of which were simple numbers and the other of which were dates, I couldn’t find any way to get the actual dates to show up as labels on the x-axis.

You can import .XLS, .ODS, .CSV, and .TXT files, and export in those formats as well as HTML and PDF. You can add worksheets; sort each column in increasing or decreasing order; freeze rows; and create charts. Many of the formatting, sharing, and revision features are the same as are provided in Google Docs. Like Docs, you can also view your spreadsheets on a mobile device, but the formatting on that device isn’t quite as consistent as it is with Docs.

Google Spreadsheets is very handy for those of us who only need to occasionally use spreadsheets for organizing data or doing simple calculations, and it offers enough operations to suit most uses. But for more complex calculations, or if you depend on charts to visualize your data, Excel is still the better deal.

Replacing Microsoft Outlook: Zoho Mail

Zoho Mail boasts the closest approximation to its Microsoft counterpart (Outlook) in the Zoho galaxy — not just because it handles mail, as the name implies, but also because it provides quite a few of Outlook’s other functions, like calendaring, task lists, contact management and so on. It’s closer to a mini-suite than just an application, actually, given how much is packed into it.

The interface is similar to Outlook’s own multi-paned display (including a customizable “swipe bar” on the left-hand side), so people making the switch from Outlook should not be thrown too badly at first. As with many of Zoho’s other offerings, the big plus is collaboration. Multiple Mail users can be aggregated into a Group, and interact closely by sharing information (documents, messages, etc.) and assigning duties and tasks. But I suspect the big test of how useful Mail will be for existing Office users will come after Zoho rolls out closer integration for Outlook.

When you use Mail, you “connect” a third-party POP3-accessible mailbox to your Zoho Mail account, Mail will then poll that account periodically, even when you’re not logged in. Mail also assumes by default, correctly, that e-mail from any account you’re hooking up should be left in the mailbox, since you might still be accessing it from another client. Also bear in mind that if you’re sending e-mail from Zoho, you need to have access to an outbound (SMTP) e-mail server that will accept authenticated connections from third-party clients.

Newly-created mail can be edited as either plain-text or HTML — I’m a staunch user of plain text e-mail, so I opted for that automatically. The address fields autosuggest entries from your contacts list, and you can add contacts from the From: field of any e-mail you open up, so it’s relatively easy to build up a contact list from scratch. If you want to import an existing contacts list, you can upload a VCF, LDIF or CSV file, but there’s no two-way integration. (Zoho is working on adding closer integration with Office to allow things like this in the future.) I also liked the universal search function, which lets you hunt for anything filed in Mail with a keyword.

If you’re an Outlook user, the calendar function is probably going to be one of the first things you try to migrate data to. Right now, Calendar only accepts imported data in ICS format (something you need a little third-party help to accomplish), but the list of functions in Calendar itself is impressive enough that you are not going to feel functionally deprived. Event reminders can be e-mailed to you or displayed as popup windows, and scheduled events can be related to items in the Tasks list if needed. There doesn’t appear to be a way to import lists of tasks, but the way tasks are set up is also closely reminiscent of Outlook, with priority, status, reminder notices, percentage of completion and the ability to assign tasks to other team members.

Other elements in the Mail mini-suite echo or incorporate elements of other Zoho applications. The Documents function, for instance, lets you upload and organize all manner of files. (Uploaded audio files can even be played back in the browser). Notes is a freeform, categorizable notepad much like Outlook’s own Notes function, and the Links section lets you organize libraries of URLs that are either entered manually or imported from an existing document. Also included are links to Writer, Sheet, and Show, all of which open instances of those programs within Mail itself.

Mail isn’t free — it’s one of the more advanced, for-pay components of the Zoho suite, and given how ambitious it is I’m not surprised they want to charge for its usage. But perhaps in the future we’ll see a stripped-down, no-cost version for those of us who don’t need the full gamut of features.

Replacing Microsoft Outlook: Gmail/Google Calendar

Google would have an excellent alternative to Microsoft Outlook, if its various personal information apps would only work together.

Google’s e-mail service, Gmail, is the most interesting, and different, of all its applications. Unlike Outlook (and most other e-mail applications) , Gmail doesn’t let you use folders to organize your messages, aside from basics like the Inbox and Sent Mail folders. Instead, you are asked to label them; you can then filter your inbox to show only the e-mails matching that label. It’s not difficult to use — you can create and assign as many labels as you need, and you can have them automatically assigned as each message comes in. (You can’t, however, choose to filter for two labels, or look at all your e-mails except a certain label.)

Gmail also offers a variety of filtering and forwarding options; if your Inbox is getting too unwieldy but you don’t want to delete any e-mails, you can archive those messages you don’t really need anymore. But of course, this is Google, so if you’re looking for a specific e-mail, even an archived one, the fastest way to find it is to simply search on a phrase. If it’s there, you’ll find it.

Gmail is nicely flexible when it comes to using the service as an extension of your other accounts. For example, if you’d prefer to use Gmail with Outlook or another e-mail application, you can download Gmail as POP mail. On the other end, you can use Gmail to send mail from your other e-mail addresses (so that you don’t have to confuse your correspondents with too many different e-mail addresses), and you can fetch mail from up to five other accounts.

One of my favorite aspects of Gmail is the way it threads conversations. While applications such as Outlook treat each e-mail is seen as an independent entity, Gmail sees messages as items in a thread (or, as Google puts it, a “conversation”), so that each appears onscreen as one in a series of overlapping cards. Thus, an e-mail back-and-forth can be immediately seen in context.

Google’s Calendar application is also excellent; unfortunately, it is not paired with Gmail in any effective way — you can’t use Gmail’s contact list to make an appointment in Google Calendar, for example. Calendar makes it simple to add events, invite others to scheduled events, and track your invitations. It also lets you include as many private and public “calendars” as you like: you can track separate work and home calendars, your spouse’s and kids’ schedules, and add publicly-available iCal calendars. There is a mobile version of the Google Calendar available for your smartphone (including the iPhone). However, there is as yet no way to access Calendar off-line.

For many of us, a Todo list is a must, but Google doesn’t offer any type of task tracking. There are, if you look around the Web, a number of third-party software apps that will work alongside Google Calendar and/or iGoogle (Google’s desktop home page) — I’m particularly fond of one called RememberTheMilk.

One of the biggest disappointments about Gmail is its contact listings. Granted, Gmail is about e-mail, not about keeping track of your contacts, but as long as you’re at it, why not offer that as well? Gmail does maintain a contact list that is populated from sent/received e-mails; each contact is associated with any messages that has been sent or received from that person, which is handy. You can also import contacts in CSV format and add images, address, etc. But it’s obvious that Contacts is not meant to be a serious tool for tracking your associates — if, for example, a colleague has sent you e-mail from more than one address, you’ll have two contact entries with no apparent way to merge them.

So while Google offers a number of really useful personal information apps — Gmail and Calendar are standouts — if you’re an Outlook user who wants to integrate your e-mail, scheduling, and contact information in any kind of efficient way, you may want to stick with Microsoft for now.

Replacing Microsoft PowerPoint: Zoho Show

Show emulates most of the really important core functionality of PowerPoint — in other words, all the things the vast majority of us use PowerPoint for in the first place. The most recent versions of PowerPoint have new design tools which Show does not have, but again, Show’s got the vast majority of what people need to get this work done. Most people will have no trouble creating polished-looking work with it.

Many of the tools and their behavior in Show will be familiar. New presentations can be created with your choice of several basic theme templates which can be customized to a fair degree. When you insert new slides, you also have your choice of slide templates — blank, title only, title with bullet points, and so on. Copying or reordering existing slides is as easy as right-clicking on them or dragging and dropping them in the thumbnail sidebar, and adding text, images or geometric shapes is about as intuitive as it can be.

When you click “Slide Show,” the presentation opens in a separate window (which can be maximized to fill the screen by hitting F11), and can be played back at your choice of speeds. Presentations can be shared out remotely, exported to HTML, or embedded in another Web page, but unfortunately there’s no way to export to PDF.

Show would be very limited if you couldn’t also import existing presentations. Both regular PowerPoint PPT / PPS files and OpenOffice ODP files can be uploaded and converted with good fidelity. Documents can also be imported as “read-only,” which converts all text to images.

Some of the more exotic things missing from Show would be difficult to replicate in a browser-based app — like dual-display support, so the presentation could be on one display and your notes on another. For what it attempts to do so far, though, Show is more than adequate for most people.

Replacing Microsoft PowerPoint: Google Presentation

Google Presentation is the latest addition to the Google Docs suite, and as such, it’s the least developed. It’s accessible through the Google Docs main screen; you simply click on the Google Doc’s drop-down New menu and choose Presentation.

At the beginning, you get a simple opening card offering a place to put a title and subtitle. After that, it’s very easy to insert a theme (at the time I was working with Presentation, I counted 15) and one of several layouts, including a blank page for the more creative among us.

Google Presentation is simple, both in execution and available features. You can insert text and change font, color, size, and highlight. You can add images and change their size (the aspect ration is automatically preserved). You can add links to URLs and email addresses. You can create numbered and bulleted lists, center text or place it flush left/right. You can take any document you’ve created in Docs (but not Spreadsheet) and save it as a presentation.

And that’s about it. If you’re planning to add fancy transitions to your presentation, you won’t find them here — in fact, there aren’t any transitions of any kind, and don’t even think about music or other multimedia.

However, you can make your presentation easily available online — in fact, when you start the presentation, there is automatically an area at the side for the audience and a button that let’s you “take control” of the presentation. You can chat by typing into a box at the bottom of the window. (Presumably, any discussion you’d have about the presentation would have to come from a phone conversation, or another source.)

Presentation, like some of Google’s other apps (for example, Google Creator) seems to be aimed at the most basic functionality that somebody would possibly need. Certainly, you could put together a reasonably good presentation in record time using Google Presentation, but if you wanted anything approaching professionalism, you would have to create your presentation in, say, PowerPoint (you can upload a PPT or PPS file). You could then use Google’s share and/or publish features to show it off.

Replacing Microsoft OneNote: Zoho Notebook

Notebook is like a binder for assembling material in many formats, both from other parts of Zoho and from the Web at large. You can pick up Sheet spreadsheets, Writer documents, Show presentations, RSS feeds, video, audio and plain old images and text, and scrapbook them together in various ways. Embedded video or audio plays back via a Flash application, much as it does on sites like MySpace or YouTube.

Notebook is a little like a cross between a desktop publisher and an HTML editor, although its function is not really to allow creation of standalone Web pages or sites. It’s more a way to compile disparate things in a sort of fixed presentation format. Those of you familiar with Microsoft’s OneNote will find all this strikingly familiar, although Notebook lacks many of OneNote’s more advanced features, like transcribing handwritten notes.

A Notebook document consists of pages — again, like a scrapbook — onto which you place elements. When you add an element you’re given several choices of actions you can perform: you can point to a URL somewhere, upload the element manually, type it in (if it’s text), or import it from elsewhere in your Zoho portfolio of documents. The element can be sized — this is the part that reminded me most of a desktop publishing app — pinned into place, or floated to the front or back. Notebook also supports version-tracking for individual objects, so you can revert changes if need be.

If you don’t want to upload audio or video, you can record either one directly into a Notebook document via a Flash application. You’ll need to allow Flash to access your microphone or camera to do that, so this might not work on a configuration where the machine has been locked down, but it’s still a splendid feature. Some formats aren’t supported directly but can be embedded anyway: a PDF file added to a page, for example, didn’t show up as a visible image, it did show up as an icon with a link to launch it in a separate window.

The published results are viewed in a special Notebook interface with page-flipping controls, not just as flat Web pages. Again, Zoho’s universal sharing functions come in handy here: you can share not only whole notebooks and individual pages, but individual objects, either with the world at large or with specific people. This makes Notebook a good way to share things that don’t fit into an easily-pigeonholed category, even if the implementation is still limited, again, by what a browser’s capable of.

Replacing Microsoft OneNote: Google Notebook

Google Notebook
Google Notebook is less a data catch-all than a way to track all the small interesting stuff that you find on the Web — like that quote you saw on Valleywag, for example, or the snazzy new mobile phones reported on, uh, InformationWeek.

Unlike Microsoft OneNote, which is fashioned to look like a scrapbook, Notebook works on a simpler level. The app attaches itself as a button to the lower right-hand corner of your browser; click on it, and you get a small pop-up window with the name of that particular Notebook on top (you can create as many as you wish).

To add new entries, you can click on the “Clip” or “New note” buttons in the Notebooks window; drag and drop a highlighted segment of a Web page into the window; or right click on a highlighted segment and click on the “Note This” menu item that Google adds to your browser’s right-click menu. However you do it, the result is that the highlighted text clip and/or image is saved to that notebook, together with the name of the page (which is automatically linked to its URL). There is a separate area for each item where you can add comments, or you can edit the entry itself.

Your Notebooks are listed to the side of your item window; the list can be visible or hidden. You can delete notes or move them to new Notebooks from the small browser window; if you want to do a search through all your items, you need to go to your Notebook’s home page — this is essentially a Google page that lets you do a typically efficient Google search.

You can also, of course, share your Notebooks, and this can be a powerful tool. When you want to share a Web reference with a friend or colleague, there is nothing easier than simply dropping the reference into a shared Notebook, where it is instantly available. There is one problem, though: Unless you actually tell your colleague that the reference is there, they may not notice the addition. It would be a great improvement if there was some way to notify the users of shared notebooks that a new entry had been made.

In short, while Google Notebook is not in the same league as Microsoft OneNote, which collects other data besides that found on the Web, it is an extremely useful applet for those of us who need to quickly collect and organize Web factoids as we surf.

Replacing Microsoft Access: Zoho Creator

Creator fills a sadly neglected niche: It’s a database application something like what FileMaker user to be and what Microsoft Access never really was to begin with. Also, unlike most other online applications, Creator is not at the mercy of your Web browser but a complement to it — it’s a great example of how to put together a powerful AJAX application that works well.

When you create a database in Creator, you can start entirely from scratch or use one of a set of prefab data collection forms: available templates include a bug tracker, DVD collection form, to-do list, and, whatever its usefulness to you, a blood donation form. Creator’s template designer is extremely powerful. You can drag and drop fields and field elements, or assign scriptable actions to individual fields when the user adds or changes data. The scripting engine for Creator, by the way, is amazingly powerful and well-designed. You need to understand JavaScript syntax to make the most of it, but the way it facilitates script creation and editing is downright artful. There are desktop applications that don’t have tools this good.

You can import data into Creator from an existing Excel or .CSV file or, as with Writer you can e-mail a plain-text data dump to a specially-generated e-mail address (Creator provides you with a template for the text format). You can also copy and paste data in tab-delimited format into an input field. (The latter might actually be easier, since you can simply declare the first row of the pasted data to be the field names, which is probably closer to the format most such data is already in).

When you set up views for entering or displaying data, Creator provides five basic models: a list view, a spreadsheet, a summary, a calendar and (newly introduced) a graphical chart. Pick the one that suits your data best: the calendar view is great for organizing appointments or other data ranges where the date is the most crucial element, while spreadsheet and list are best for seeing whole sheets of data at once. For the chart view, you need to pick which records are to be used to generate each axis or aspect of the chart you’re generating, but it takes very little time to select what you want, and the results look remarkably professional.

As with the other Zoho tools, the sharing functions make Creator particularly useful. Other users can be invited to add data or edit the database schema itself; or the data input forms can be made public to allow anyone to submit data as needed. Another sharing option of sorts, “Embed in Website,” generates HTML code to allow an input form to be embedded in a separate Web site via an iframe.

A slightly more upscale version of Creator, named DB and Reports, went online as I was evaluating Zoho. It’s still somewhat rough, but the emphasis here is more on creating charts, reports, pivot tables, and views from existing data. It also understands SQL queries from many broadly-used dialects of SQL (including MySQL, SQL Server, Oracle, PostgreSQL, and ANSI), and can import existing data from standard file formats like XLS and CSV. Most people will want to start with Creator and graduate to DB if they haven’t used this sort of thing before.

The Verdict: Zoho

Because Zoho is an online application, it’s limited by two things: connectivity and the capacities of a Web browser. That said, the makers of the Zoho suite have done a lot to ameliorate both of these things.

The first problem, connectivity, affects not only the availability of data, but also your ability to use the suite at all. To offset this, you can install desktop versions of some of the Zoho apps (Writer, Sheet, and Show, to name three) which can then access your documents on the Zoho server as needed. These local versions of the apps use the Desktopize toolkit to make the program(s) run locally, although if you want to use them entirely offline you also need to install the Google Gears browser extension. Another cross-compatibility feature is a plugin for Microsoft Office that allows Word and Excel to open and save documents directly to and from the Zoho repository.

The issue of browser capacity is more problematic, and involves a constant clash between the behaviors I would have expected out of a desktop application and the behaviors I’ve come to expect from a Web site. For instance, the “page loading” activity icon in Firefox would sometimes start up when I did something, which led me to believe that at any second the page would erase itself and refresh. False alarms like this caused me to stop working for seconds on end in anticipation of things that never materialized. Right-clicking doesn’t always give you predictable results, either. I’m used to the idea of right-clicking on something to get a context menu, but sometimes a right-click action gave me the browser’s right-click menu, and not the application in the browser.

Within the confines of what can be done comfortably in a browser, the Zoho applications are downright inspiring. As long as you don’t run afoul of those limitations, it’s possible to get real work done. But at least for now, there are still many things that will be the domain of a desktop application.

The Verdict: Google

Google has made some attempts to collect its varied range of applications into some kind of order, but on the whole, because only some of them are associated with others, you can only judge each app on its own.

In addition, judged against desktop applications such as those in Microsoft Office, Google’s aren’t quite ready to take over. For basic usage, Google’s word processor, spreadsheet and (to a lesser extent) presentation package are all fine. Gmail, because it works so differently than its peers, can be considered either an innovative and highly useful way to work with your e-mail, or too awkward, depending on the individual. (The fact that you can now use IMAP to sync Gmail across devices is a real plus.) And Google Calendar is an excellent way to keep up with (and share) your schedule. But on the whole, Google’s feature set is not nearly as extensive as Microsoft’s, and in some cases not even up to reasonable business standards (for example, Google Docs’ lack of any header or footer capabilities).

So, on the whole, Google’s applications are not ready to substitute for those provided by Microsoft Office. However, they do offer different benefits that, like Zoho’s, reflect the fact that they are Web-based: the ability to easily collaborate with other users and/or groups of users; the ability to access your documents no matter what computer you’re using; and the ability to quickly add interesting third-party applets. In addition, the mobile versions of Google’s apps are a real plus (although the fact that not all of Google’s applications sync to offline versions can be a problem).

While they may not be as sophisticated as those in most suites, these apps are not bad — and quickly getting better. If you’re a heavy user of online resources, it wouldn’t be a bad idea to make the acquaintance of at least some of Google’s applications — there’s a good chance that they will be ready for the big time fairly soon.