Spreadsheet Macros and Pivot Tables: Google Says No. EditGrid Says No. Zoho Just Does It.

Collaboration, Personal Productivity, SaaS April 28th, 2008

OK, OK, I admit, the title is a bit tongue-in-cheek… but real. Sophisticated Excel users have long complained that none of the online spreadsheets support Macros or Pivot Tables. The answer has so far been sorry, no can do…

Google hinted they would likely not do it, as reported by TechCrunch:

Will Google Spreadsheets ever have advanced features like pivot tables, macros or offline database integrations? (This was actually my question) Scott said they are constantly trying to find the balance between speed and utility. It will never be a heavy duty analytics program because that would be too heavy and bulky for the average user.

EditGrid’s David Lee also suggested Pivot Table are too difficult to do online. Well, maybe, but here they are both, in Zoho Sheet. Not that it comes a real surprise, in fact ever since the launch of Zoho DB pivot tables were just a matter of time, and Zoho has promised macros for some time, too.

I admit I probably don’t appreciate the importance of these two features, as I’ve said before, the level of my spreadsheet competency is probably stuck somewhere at Lotus 1-2-3. smile_wink. But even I used very limited Excel macros in the past, although typically be recording and editing afterward, rather than writing them in Visual Basic. Now Zoho Sheet can interpret VB directly, without using Microsoft’s back-end, and that means you can import your Excel spreadsheet, the macros no longer die. No other spreadsheet (other than Excel itself) supports VB macros.

Zoho launched a “marketplace” -sort of, being free - of VB macros at http://vbmacros.wiki.zoho.com/

As for pivot tables, they are an important analytical tool, but instead of reading me, why don’t you look at this demo video:

Tags: , , , , , ,

How to Make Outlook Cool. Actually, Kool.

Personal Productivity, SaaS April 20th, 2008

Outlook read backwards is Kooltuo. Wow, it would make a good startup namesmile_wink. No, I did not go crazy, but TechCrunch reports that Microsoft just signed a letter of intent to acquire Xobni. And Xobni = Inbox, backwards.

Not that it’s a surprise: I wish I could predict everything with such certainty. This is what wrote in February, when Bill Gates presented Xobni for Outlook as “the next generation of social networking” at the Microsoft Office Developers Conference:

What does it mean when Bill Gates presents your product, a super-cool Outlook plugin to his crowd of developers?

  1. Gates’s message: now go back and copy this fast. That would be the classic Microsoft style, as many software startups can attest to. It would also put the market introduction to somewhere … around 2015? Unlikely.
  2. Microsoft will acquire Xobni in no time. Sweet and fast deal. Congratulations to the Xobni team and investors!

So, yes, congratulations to the Xobni team! On a personal note, I regret I can’t try Xobni, as I long ago ditched Outlook along with a lot of desktop bloatware, and am in happier land now, using Web-based applications. I’m perfectly happy ( and productive) with the combination of Gmail and the Zoho apps, and if I ever leave Gmail, it will be for another web-mail, not back to the desktop. The air is fresher in the Cloud.smile_regular

Tags: , , , , , , , , , , ,

Benchmarking: No Longer the Hidden Business Model in SaaS

Business, SMB / SME, SaaS April 9th, 2008

The cat is out of the bag - was my first reaction when FreshBooks announced the launch of their new benchmarking service in October 2006.  Then, and later I called it the hidden business model in SaaS:

He basically announced the hidden value proposition enabled by SaaS: competitive benchmarking. All previous benchmarking efforts were hampered by the quality of source data, which, with all systems behind firewalls was at least questionable. SaaS providers will have access to the most authentic data ever, aggregation if which leads to the most reliable industry metrics and benchmarking.

With Google’s entry today, benchmarking is no longer the hidden business model: it has just gone mainstream.  Potentially great value added service, a new revenue source for the provider, which may even allow them to give the core service away for free.

Give away?  Do you think I’m smoking something?   Read Jeremiah Owyang who predicted that storage companies will (?) eventually pay for your data. smile_shades

 

Related post:  Dennis @ AccMan Pro,

Tags: , , ,

Google Gears goes Mobile - Zoho First to Take Advantage

Personal Productivity, SaaS, Startups March 3rd, 2008

Mobility is supposed to be about 24/7 connectivity, isn’t it?  I’m writing this on a a 7.2Mbps HSDPA mobile connection while visiting my parents in Hungary.   HSDPA is like 3G on steroids, and we’re not even close to universal 3G coverage in the US.  What’s more, forget data, I’d be happy with just universal voice coverage right here in the heart of Technology.  I get measly coverage (half a bar only right next to the window) in my house, but what’s a real shame, try talking on a T-mobile phone on the long walkway from Parking to the International Terminal at SFO: zero, nada, no signal at all.

Until that’s fixed, mobility isn’t about 24/7 connectivity, it’s about 24/7 access, online or offline.  Which is why it’s great to see Google Gears Mobile released today, initially for Internet Explorer Mobile on Windows Mobile 5 and 6.  Now you don’t lose vital information when your phone goes offline. 

The first two apps taking advantage of Gears Mobile are Buxfer a finance tracking application and Zoho Writer.

 

The current Zoho Mobile Offline version (wow, that’s a mouthfulsmile_tongue) is view only - if you recall, it did not take long for Zoho to add edit capabilities to the Gears-based offline version on the desktop, so we can likely expect the same here, too.

This video presents Zoho Writer Offline in use.   As a reminder, Zoho also works on the iPhone, at at izoho.com - offline support will come just as soon as Google Gears will support it.

 

Related posts: Google Mobile Blog, TechCrunchTechMoz, VentureBeat, Mashable, The Buxfer Post, Zoho Blogs.

Tags: , , , , , , ,

JotSpot Born Again as Google Sites, the Wiki-less Wiki.

Collaboration, Personal Productivity, SaaS February 28th, 2008

Three weeks ago I speculated that JotSpot, the user-friendly wiki swallowed by Google a year and a half ago would soon come out of hibernation, and Voila! here it is, rebranded as Google Sites. It is the first service only available as part of Google Apps (including the free version), although I had some difficulty accessing it. Under “Manage this Domain” I could add “Sites” as a new service, but it did not show up on my account as an accessible application. When I typed sites.google.com it wanted me to sign up for Google Apps even though I was already logged in to my account. Of course trying to do so resulted in the error message:

Google Apps for zoliblog.com has already been registered by your domain administrator. Please contact your admin directly to get access to Google Apps services.

Catch 22. But there’s a solution: just type the direct URL (sites.google.com/a/yourdomain.com as default, or customize it to your liking) and you can get into Sites. I’m sure Google will soon add it to the Apps menu. (Sidenote: my old JotSpot account is still alive at name.jot.com).

Google no longer calls this a wiki, which I think is a good move. I previously wrote:

Wikis have arrived when …you don’t even have to know what they are to use one. You don’t have to know you’re using a wiki, just happily type away, creating shareable content on the Web.

I was discussing Wetpaint, the user friendly, wiki-less wiki there, and I think it’s smart of Google to follow that pattern… more later, but first, under the hood it is still a wiki, so let’s examine some of the wiki basics.

The interface is familiar from good old JotSpot (as a sidenote, the old JotSpot accounts are still alive at name.jot.com). There’s a basic wysiwyg editor, the Edit button is large and visible, and so is the New Page button. Good old JotSpot had several more ways of creating new pages, which are gone - perhaps for the best:

  • WikiWords or CamelCase: in old JotSpot anything you typed with embedded capitalization became a link to a page. As a relatively early wiki-user I liked it, as the easiest way to LinkAsYouThink. But in the Web 2.0 age we keep on bastardizing grammar writing EveryThingLikeThis, so more and more WikiWords had to be “unlinked”… too much confusion, especially for the new generation of mainstream users.
  • Linking to a shell-page before it’s created. This was a useful feature, even if we eliminate camelcase, I could use the “Link” icon, and mark up text as a link to a new sub-page, to be filled with content later. Again, this supports flow-thinking, or LinkAsYouThink, which I regret is gone.
  • The “New Page” button. This is the only remaining option in Google Sites, and I think the fact that it offers to pick a parent page (enforced hierarchy) is an improvement. No more orphan pages, yet relatively flexible hierarchy.

For those not too familiar with wiki terms, I discuss some of these concepts in more detail here: technically an article on SocialText 2.0, but I often make comparisons to JotSpot and Atlassian’s Confluence.

I’m glad to see Sites retained breadcrumbs for easier navigation, and they added sitemaps, a tree-style view of all your pages. This could be improved to allow for drag-and-drop style moving of the pages (changing the hierarchy), like Zoho Wiki does.

I’m surprised Sites still does not have inbound links: this is a critical feature for all wikis, whatever we call them. A wiki is all about associating pieces of information with each other, and the inbound link, also referred to as backlink shows you where the information on the current page is used elsewhere. The JotSpot tea half-recognized the importance of backlinks, as they were available as as a downloadable plugin on the Jot Development wiki, but never made it to the standard feature-set, and are apparently lost in the Google reincarnation, at least for now.

Attachment handling is as good as it was in the original JotSpot: it maintains previous versions, allows users to revert to earlier ones…etc. However, Google missed a huge chance here to by not offering to convert the attached documents to its own Google Docs style. This point takes us to the next level: stepping outside the boundaries of a standalone wiki and using it as a facility to pull together data created by other applications.

Last year I said after burying JotSpot for a year, Google can’t just release it as a wiki, instead:

…I hope that means they rethought everything and integrated JotSpot well into a number of offerings.

  • It could provide for much better document management than the current Docs &­ Spreadsheets UI.
  • It overlaps with Page Creator, also with the simplified version found in Google Groups - in fact Groups which is no longer just email lists but a rudimentary collaboration platform and JotSpot could very well be merged / integrated.
  • Finally JotSpot tried to provide primitive applications (spreadsheet, calendar..etc) all of which have a better Google counterpart, so one would hope they will be replaced, too.

Well, what’s the score on that prediction? Google Sites is a better replacement for Page Creator, Google ditched the JotSpot “apps”, replacing them with their own ones - so far 2 scores out of 3. As for document management.. well, I’d say half a score, or less. (Hey, that’s 2.5 out of 3smile_tongue)

You can somewhat integrate Google Docs (which includes documents, spreadsheets and presentations) by embedding them into any Google Sites page. You have to enter the specific URL though - why not just select from a list? Furthermore, your Google docs or spreadsheets have to be first made public and you have to use the public URL to embed them into Sites. Here’s my test site, showing first an error message, then the actual embedded spreadsheet, after I made it public.

The embedded docs appear properly in the saved page, but I can’t click on it, not even in Edit mode to get to the source. In fact in Edit mode all I see is a graphical placeholder for the embedded doc.

How about sharing / collaboration? As expected, your Sites can be:

  • private
  • public
  • shared with individual email id’s
  • shared with everyone within your domain

…and you can set view or edit options for all those levels. However, Google missed a big chance again. As a complete coincidence, it’s only yesterday that I raved about Zoho’s Group level sharing, half-announced in a fairly understated manner - hidden in a list of Zoho Writer enhancements. Well, Google already has a very good group facility: Google Groups, which started it’s life as a group discussion / forum system, but it gradually evolved into a decent collaboration platform. Once I have a “group” defined (i.e. the list of members), why doesn’t it become an entity I can share my wiki (sites) or docs with? When I invite users to share the wiki with, there’s an option to save the list as group, but I don’t know where it disappears, can not pull it up either within the wiki or gmail, or docs.

Finally there are gadgets, but if you read Dennis Howlett at ZDNet, gadgets might the feature you don’t want to touch with a ten-foot pole. smile_sad

Summary: Nice to have Jot back (even if we did not get GSpot.smile_embaressed ) Google now has a pretty good and easy web-page creator with some wiki features made user-friendly, and a half-hearted attempt at integrating the rest of the Apps empire using Sites. Perhaps they get it right in the next release.

Related posts: TechCrunch, eWeek, Ross Mayfield’s Weblog, Irregular Enterprise, Mashable!, InfoWorld, Between the Lines, Portals and KM, CNet, Webware, GigaOM, Web Worker Daily, Venture Chronicles, Insider Chatter, Learning and Technology, Solo Technology.

Tags: , , , , , , , , , , , , ,

Zoho Expands Group Collaboration

Collaboration, Personal Productivity, SMB / SME, SaaS February 27th, 2008

Today’s Zoho Writer update is not what it looks like. Yes, I get the story about:

  • DocX Support
  • Thesaurus (in 10 languages)
  • Enhanced Endnotes/Footnotes
  • Enhanced Headers/Footers

..etc, but that’s not what I find exciting. DocX support? Personally, I don’t care, MS Office 2003 was the last version I bought, people much smarter than me call it a completely insane format … but hey, the Borg is the market leader, so why not support it… Layout improvements? I’m already in a paperless world, barely ever print, so I don’t really care about these features. But Microsoft Office was created at a time when the purpose of document creation was to eventually print it, and in our legacy world the challenger is measured against the standards of the incumbent, so, yes, I can accept these are important features for Writer. Besides, the academic / student community has been dying for endnotes / footnotes, so now they can have it. smile_shades

But the hidden bomb here isn’t just a Writer improvement: it’s a feature that shows Zoho’s hands regarding collaboration in the entire Zoho Business Suite. Yes, I am talking about Group Sharing. After all, one of the key drivers behind moving to web-based Office applications is to enable easier collaboration.

Most of the collaborative apps, including Zoho or mighty Google typically allow either public sharing, or inviting users individually, but until now there has been no way to share your documents with a predefined set of users, i.e. members of a group. A year and a half ago I praised Google Groups for stepping out of being just a group email mechanism, becoming a mini community/collaborative platform - but the definition of a “group”, i.e.it’s members does not exist outside the Groups application. Gmail does not recognize the Group as a valid address, and I certainly can’t share Google Docs or Spreadsheets with my Group. (And make no mistake it’s been the same with Zoho until now.)

With today’s update you can now create a Group in the ‘My Account‘ section of Zoho, and that Group is recognizable in any other Zoho Application, including Writer, Sheet, Show or even Zoho Mail. Eventually there will be multiple privacy / sharing levels within the Zoho Universe:

  • private
  • shared with individual email id’s
  • shared with Groups (defined once, recognized in all apps)
  • shared by Domain (i.e. share info within your business)

The last one will be a feature of Zoho Business, currently in private Beta, but the other two are available. Thesaurus in 10 languages, format and layout improvements are all nice, but the real news of the day is the improved cross-application collaboration.

Related posts: TechCrunch, Mashable, ReadWriteWeb, Wired, Digital Inspiration, Zoho Blogs.

Tags: , , , , , , , , , , ,

Google Reader Offline: Smart Yet Dumb

Blogging, Personal Productivity, SaaS February 26th, 2008

Yes, it’s great to be able to download my feed items and read it on the plane without Internet connection (since I am not flying Virgin). I even “starred” some entries I want to respond to.But why can’t I mark items “read”? It’s an “online only” action - that does not make sense. When I go back online, Google Reader will perform synchronization anyway; why could it not remember “read” status and sync it?

The above rant is half a year old. I typed it up and decided not to post it. Now I am finding myself offline for a few days again, and can’t believe Google still hasn’t fixed this shortcoming.

Why is it a big deal? If you have hundreds of items in your Reader, I seriously doubt you will use Expanded View and scroll through everything. I found the only way to stay productive with Reader is to use List View, scan titles (OK, a combination of titles and author), and when all done, click “Mark all as read”. I don’t want to reprocess the same items again and again.

The error message says I can do this once I am connected again. But it’s too late, by then my Reader list will be a mix of already seen and new items. In other words, I am scr***d.

What really baffles me though is that I haven’t found any references to this problem online. Am I the only one finding this a major productivity killer? smile_sad

Update (3/14): Now that ReadBurner, a cool tool to determine the most shared items in Google Reader became the news du jur, let me just point out that you can’t mark an item ’shared’ while offline, either. Not as frustrating as losing “read”status, just an annoyance. Google, please fix Reader!

Related posts: Unofficial ReadBurner, louisgray.com, Adam Ostrow, CenterNetworks and SheGeeks

Tags: , , , , ,

Google’s Darth Vader Phone

Humor, Technology February 16th, 2008

Probably a joke but there’s a mockup of what a Google - Alienware (owned by Dell) phone would look like. Personally, I find it ugly.  Perhaps if they bundle it with a light saber?

 

More on: CrunchGear, Engadget, Gizmodo, Gadgetell, Technology Questions, PalmAddicts and Mobility Site

Tags: , , , , ,

Google Takes a (404) Page from OpenDNS’s Book

Software February 12th, 2008

Big brouhaha this morning over the fact that Google’s Toolbar “hijacks” 404 error pages and displays their own promo instead. “Google is evil” - say some webmasters.

I don’t see it a big deal. 404 pages are not exactly masterfully designed pages anyway, in fact I’m not really supposed to see them at all.

By the way, it’s not such a new idea either: it’s the very foundation of OpenDNS’s business model.

Update: Google’s Matt Cutts explains how 404 works.

Tags: , , ,

Web Forms Gain Popularity

Collaboration, SaaS, Startups February 7th, 2008

Web forms are increasingly popular, as they provide an easy way to solicit user input, manage a database in the background, and display data in a controlled form. Typical uses are contact forms (this blog has one), surveys, signup-sheets.   Wufoo is perhaps the most popular standalone form builder, but as popular as they are, Google’s entry to the space will likely bring more visibility to Web form use cases. 

I set up a very rudimentary web form to demonstrate their use, but I am cheating: I took the data from Google Operating System and populated my database - sorry, Ionut, I don’t get anywhere close to your huge reader base.smile_wink   Please fill out the form below.

Although the form captures the time of entry, I am not displaying it below, to demonstrate that once can control the re-use of data after user entry.

You can manipulate the above data, filter it, sort it by clicking on the column headers, search the contents…etc. 

Oh… is this more than you’ve seen on the other Google forms?  And they’ve told you the lists were not embeddable?  Sorry .. I’m cheating: I’ve re-created Ionut’s  form in Zoho Creator. smile_tongue  (Disclaimer: I am an Advisor to Zoho - but I am making a point by doing this.)

 

Different people will always prefer different tools.  I don’t have any statistics, but I would assume the number of users for database-like tools (MS Access, Dabble DB, Zoho Creator & DB) is by an order of magnitude less than the number of spreadsheet users.  A lot of basic spreadsheet users don’t perform calculations, don’t use pivot tables - they just  create tables to track lists. (See my earlier rant on why JotSpot’s tracker is not a real spreadsheet).  For their sake it’s nice to be able to have simple form support inside a spreadsheet, which is what they can now get from Google.

Several reviewers of the new Google Forms were missing field verification, calculated numeric fields…etc. These features and more are supported in Zoho Creator, which in fact allows you to build mini-apps by dropping script elements, without actually coding.  Those who want more database manipulation can use Zoho DB. These are powerful applications, but which one to use when can be confusing to less technically inclined users (like yours truly).  Hence simple forms in a spreadsheet are a good idea.   But let me dream a little - here’s how I’d like to see web-based collaboration some day:

It won’t be about formats and applications - it will be about free-flowing thoughts and the data encapsulating them.  Of course there will be differences in application capabilities, but it’s entirely likely that what you can manipulate in your database application, I will access using a spreadsheet. Likewise, I may write something in a wiki, and you want to edit it in an online word processor.  It’s not a dream, we’re heading that way.  For example Zoho’s wiki and Writer apps share a basically similar editor, Zoho DB introduced pivot tables which will show up in Sheet in the near future.  I am impatient, would like to see this sharing happen faster, but have to accept the realities of how the leading Web companies work: individual products first, integration later.  But we’ll get there… to the vision of format-less web-collaboration.

Oh, and until then, Welcome Creator Mini Google Forms.smile_teeth

Related posts: Rev2.org, Download Squad, Digital Trends, Sunny Talks Tech, Webware.com, Compiler, Search Engine Roundtable, Googlified, Search Engine Journal, CenterNetworks, Google Operating System, TechCrunch, Google Blogoscoped, SEO and Tech Daily, Lifehacker, Gear Diary and Techmamas

Tags: , , , , , , , , , , , , , , , , , , ,