Macros, Pivot Tables & More in Zoho Sheet

Raju Vegesna  April 28, 2008 09: 44 am    Comments (0)

zsheetlogo.pngOur Zoho Sheet team just rolled out a milestone update to our spreadsheet application with a cluster of new features. There are more than 15 new features added to this update, but two key features really stand out for businesses - Macros & Pivot Tables.

This video gives you a quick introduction to these key features.




Macros:

Zoho Sheet now supports Visual Basic Macros - the ones you use in MS Excel. This is an important milestone for Zoho Sheet as it becomes the only Spreadsheet application that supports VB Macros apart from Microsoft Excel. We now understand Visual Basic and can execute Visual Basic code at the backend (no, we don’t run any MS stuff back there). This capability opens up new set of possibilities.

In the current version, Zoho Sheet lets you import your existing speadsheets with Excel macros or create new ones. We support a broad set of functions and we do plan to extend the list further. We also plan to add Record & Play for Macros going forward.

macros-ss.png


We are also launching a Wiki (http://vbmacros.wiki.zoho.com/) which is kind of a free marketplace for Macros. You can browse for sample Macros or share your Macros with others.

Pivot Tables & Charts:

As you may know, Zoho DB supports Pivot tables. This functionality is now extended to Zoho Sheet allowing you to create Pivot tables & Pivot charts on your structured data or from a range of spreadsheet data.

This unique integration between Zoho Sheet & Zoho DB brings in some new capabilities to Zoho Sheet. You can now import upto 100,000 rows of structured data to Zoho Sheet from a CSV file. Pivot tables and pivot charts can be created by simple drag and drop interface.

pivot-tble.png


Pivot Tables & Macros are just two of the key functionalities added in this update. Complete list is available here.

As you may have noticed, we are adding more depth to our existing applications apart from adding new apps. We believe in feature-rich business applications and you’ll see us improving and integrating our apps further.

As always, we can’t wait to hear your feedback on this new update.

Popularity: 48% [?]

It is all about Productivity

Sridhar  April 27, 2008 11: 27 am    Comments (2)

Mike Gunderloy at WebWorkerDaily has a great post on continuous innovation in online office suites. Both Google & Zoho are moving at a rapid clip. The root cause of this faster pace of innovation? Software development productivity.

We have experience in both the traditional and cloud model of software delivery, so can say with confidence that the cloud computing model enables a quantum leap in software development productivity. Such productivity gains for producers translates into faster innovation and better quality. And as I argued in my previous post, the reduced friction of lower switching costs in the cloud computing model will work to reduce prices as well.

Projecting this productivity advantage forward, I am confident in predicting that within a year or two, online suites will overtake desktop software in terms of features and functions. It won’t just be the Zoho or Google suites that would get there, perhaps even new companies that are as yet unknown (I am assuming Microsoft already has its cloud service coming out!). Conventional wisdom holds that online suites will forever be a lightweight alternative, but I believe that will be turned on its head.

Where do these productivity gains come from? I will address that in a separate post - there are numerous disparate sources that aggregate into a vast gain.

This is great news for consumers, even for the ones that don’t switch to the cloud, simply because of the pricing pressure it will bring. Like the open source competition which preceded and even enabled the cloud computing revolution, this competitive dynamic is fundamentally different from the one that Microsoft has faced before.

Popularity: 19% [?]

Cloud Computing, Switching Costs & Software Prices

Sridhar  April 26, 2008 10: 13 am    Comments (0)

Amazon is the most important software company in the world that does not think like a traditional software company, particularly of the “enterprise” or “business” software variety. I am talking about the Amazon Web Services platform. In any rational business, as scale goes up, per-unit costs go down. Competitive market dynamics ensure that prices go down. Sure enough, Amazon recently lowered prices of their services, as they gain scale, and lower their cost of operations. Compare that with what has happened in the business/enterprise software market.

In 1995, when I bought my first personal computer (a whopping 16 MB of RAM!) in San Diego, it cost me almost $3,000 and that was from a local white-box assembler who specialized in cheap. Windows 95 added about $50 to the cost. Microsoft Office came in around $250. Fast forward 13 years, and a perfectly serviceable PC can be had for $300-400. Vista probably will set me back about $80 assuming OEM pricing by the PC vendor. Microsoft Office will cost more than the PC itself, if I am a business user. Even a “generously” discounted student edition is about $120. As hardware costs plummet, software prices have actually gone up, so outfitting a PC with software now costs more than the hardware cost of the PC itself.

Contrary to what software sales and marketing types would have you believe, there is nothing rational about any of this. Throw away arguments like “Software is getting more complex, cost of development only goes up” and so on, because all of those things are true for hardware as well - a semiconductor chip is really hardwired-software. It is all too easy to blame sticky prices on “monopoly taxes” and while I believe there is some truth to the monopoly argument, there is something more fundamental going on. After all, Oracle is in a fairly competitive market, and still no one even expects Oracle to ever drop prices - perish the thought, that never happens. The clearest evidence of such an ingrained expectation is that no Internet company today would even consider Oracle for its database needs. On the flip side, Internet Explorer got itself into a near monopoly after the demise of Netscape, and yet, Firefox has stormed its way up to 20% market-share and climbing.

So the real explanation is elsewhere, and the Firefox example is illuminating: it is the friction of switching costs that keeps prices high. Switching from IE to Firefox is fairly easy - in fact, just last week, at the Web 2.0 Expo trade show floor, we discovered that the demo machines we had rented came only with IE, and the first thing we did was to download and install Firefox. That was almost an instinctive act, done without even much thinking. And a perfect illustration of almost zero switching costs.

That is also why cloud computing is so important to business and enterprise customers, even for those that don’t use cloud services. Switching from one web service to another is nowhere as complex as switching your operating system or even your desktop software. In any event, the vendor does most of the work. As one illustration, we frequently migrate Salesforce cusotmers to Zoho CRM, and the process is nearly fully automated, with human intervention mostly confined to perform quality assurance checks to ensure there are no glitches for the customer. As cloud services compete in a relatively low-friction market place and therefore prices fall along with unit costs, it is going to drive prices down even for conventional software.

Amazon is a perfect illustration of it. A lot of the code behind Zoho services was written before Amazon web services came on the scene, yet we have found that it is fairly easy to run our applications on the Amazon infrastructure - it took just a few days to test this out.

Lowered switching costs is going to dramatically alter the dynamics of the software industry. For all too long, vendors have hidden huge inefficiencies in their business model under the comforting cushion of high switching costs for customers. Not anymore. Watch for falling software prices ahead!

Popularity: 20% [?]

Baihui Distributes Zoho Apps in China

Raju Vegesna  April 24, 2008 10: 20 am    Comments (0)

We are happy to announce a new distribution partner in China - Baihui, a subsidiary of PC Stars - the largest Chinese online distributor with more than 2300 Resellers and over 1000 System Integrators.

With this partnership, Baihui hosts Zoho Applications in China for distribution in China (ofcourse, in Chinese language). These applications will be distributed under Baihui brand. To start with, Baihui will offer the following Zoho applications…

This list will expand going forward. All these applications are currently available @ www.baihui.com.

As with Zoho, Baihui plans to offer these applications free of charge for individuals. Zoho CRM does carry a price tag (99RMB/User/Month) beyond three free users.

baihui.png

While I don’t understand any of the stuff in the above screenshot, we are certainly excited to see our apps up there. Almost 50% of our existing users are outside US which is a good sign. We think partnerships like these will extend our reach further.

There are more exciting stuff coming from Zoho. We’ll keep you posted.

Popularity: 79% [?]

Zoho : Webware 100 2008 Winner!

Arvind  April 21, 2008 12: 24 pm    Comments (0)

webware100-2008-winner.jpgWe are happy to announce that Zoho is a winner of the 2008 Webware 100 award in the Productivity Category! The Web 2.0 user community cast nearly two million votes in an online voting poll which ultimately selected the winners.

Thanks to all of you who voted for Zoho! And congrats to all the other winners as well!

Popularity: 40% [?]

Zoho Projects Update : Task Dependency & more

Arvind  April 19, 2008 03: 58 am    Comments (0)

One of the most asked for functionalities in Zoho Projects is finally here. Dependency of tasks! And the current update brings in a few more useful features as well. The update in detail :

Task Dependency : You can now set dependency among tasks. A Task can now be made dependent on one or more tasks being completed.

Assigning a Task to Multiple Users : This is another much asked for feature from our customers. Zoho Projects now lets you split & assign a Task among multiple users.

Uniform Date format : Set a date format under ‘Settings’ -> ‘Company Settings’ -> ‘Date/Time Format’. And this format gets reflected throughout the rest of the Zoho Projects UI screens.

Clear Task date : It’s now easy to clear the start or end dates of a Task in case you have decided to reassign dates at a later point of time. Previously, you’d to delete the Task and add it again without dates.

Delete Forum category : This extends the forum post deletion function. Now, entire forum categories can be deleted.

Delete Project : An extension to ‘Clear Project’ that deletes the whole project. Be cautious while using forum & project deletion. The data can’t be retrieved.

Other than the above, a few bugs have been fixed too. Try Zoho Projects & do post your comments below.

Popularity: 43% [?]

Zoho a la carte

Sridhar  April 18, 2008 09: 50 am    Comments (0)

We get asked frequently about integration of some Zoho service or another with a third party service, often with that of a competitor. As one recent example, see this thread on Zoho CRM integration with GMail/GTalk. The question often is “Is Zoho all or nothing? If we like and use one Zoho service, would we be forced to use all of them as a bundle?”

The categorical answer is “No, Zoho is not an all or nothing proposition. We fully respect user choice and will fully support mixing and matching Zoho services with competing services.” We have intentionally architected the Zoho suite so that each service stands on its own, and can be mixed and matched with third party services. This “depth-first” architectural strategy, whereby each service is useful by itself (independent of integration with other Zoho services), enables a style of loose-coupled - RESTful, in the technical lingo - integration that makes it just as easy to integrate a Zoho service with a third party as it is with another Zoho service. We believe in customer choice, interoperability and data portability, and we do not want to lock-in any user. And we fully recognize the reality, particularly as a smaller vendor, but even true for very large vendors, that customers do not want to put all their eggs in one basket.

Specifically, to answer the specific question asked in our forums, Zoho CRM will interwork with the Google suite - including the all-important GMail, but with other Googe Apps components as well. But this extends beyond Zoho CRM - all of Zoho services will interwork with third party vendors wherever it makes sense, regardless of whether Zoho competes with that vendor in one aspect or another. As an example, if 37Signals would let us, we would be happy to integrate our Zoho Invoice or Zoho Wiki with their Basecamp project management offering, in spite of the fact that Basecamp competes directly with Zoho Projects.

It is that philosophy that guided us in our integration of the Zoho productivity applications with Salesforce AppExchange - an integration we nearly completed when they decided it wasn’t in their interest, something I actually disagree with; I believe it would actually make the Salesforce ecosystem stronger to let Zoho services in, but then again, perhaps it is in our best interest that they won’t let in Zoho! It is a different matter, of course, that it is their customers who lose.

Zoho a la carte is a fundamental guiding philosophy for us, not just a tactical competitive move. It brings numerous architectural benefits to us, enabling us to move faster in our own development.

Popularity: 36% [?]

Introducing Zoho ‘Affordable’ CRM - Enterprise Edition

Raju Vegesna  April 16, 2008 09: 00 am    Comments (0)

Zoho CRM which is part of our Business Applications set (Zoho Invoice, Zoho Projects, Zoho Meeting, Zoho People, Zoho DB, Zoho Creator etc) is now going one step further with the launch of Zoho CRM - Enterprise Edition.

This new release comes with a broad set of new capabilities making it easier for medium to large organizations to implement Zoho CRM. Some of the enhancements to the update include…

  • Introduction of Role-based Security Administration
  • Enhancements in product Customiation & Data Administration
  • Multi-language Support (11 Languages)
  • SSL Support for Professional & Enterprise Versions
  • Integration with Zoho Sheet
  • and lot more as mentioned here.

The key enhancement is the introduction of the Role-based Security Administration which makes it easier for managing the access permissions of users in an organization with multiple levels of hierarchy. In this Role-based Security module we introduced Roles, Profiles and Groups concept providing greater flexibility in access-control and customization.

The image below summarizes the new Role-based Security Administration section. Existing users: Please look at this document to understand how these changes compare to our previous version.




This video gives a quick introduction to this functionality. An online demo of the application is availble here.

Pricing:

As with other Zoho applications, Zoho CRM is very affordable. Here is the pricing information.

  1. Personal Edition - Free for 3 Users
  2. Professional Edition - $12/User/Month
  3. Enterprise Edition - $25/User/Month

Professional and Enterprise Editions are also free for the first 3 users. Detailed information on Pricing (along with feature separation between these three editions) is available here.

Zoho CRM Integration with Zoho Productivity Suite:

Zoho Sheet is now integrated into Zoho CRM which lets users edit Zoho CRM data on a spreadsheet using the ‘Zoho Sheet View’ option available in most of the modules. This provides an easy way of editing your form-based relational content in a spreadsheet view and saving the changes back to the CRM Database.

This is just a starting point and we plan to do an extended integration with our productivity suite once Zoho CRM is part of our Single Sign-on System (currently in the works).


Competition:

It is a well known fact that Zoho CRM competes with Salesforce. But the unknown fact is that the functionality of Zoho CRM is more broader for Personal and Professional Editions. Here is a quick comparison between these two applications. You’ll notice that ‘Affordable Apps’ doesn’t necessarily mean less-featured apps. All this functionality is available at fraction of the cost. To give you a quick example, for a 5 person organization, the savings with Zoho CRM are 3x and 8x (per year) with our Personal and Professional Editions respectively against the competition.

sfvszoho.png


More information on this update and the application is available on our new Zoho Wiki-based help. As always, we’d love to hear your feedback on this release.

Popularity: 52% [?]

Very Expensive + Affordable = Still Very Expensive

Sridhar  April 14, 2008 10: 51 am    Comments (2)

That was my response to the announcement that Salesforce.com is integrating their CRM system with Google Apps. I respect what Marc Benioff has done to evangelize the SaaS model in the enterprise, but I cannot bring myself to accept his business model, which is summarized by the spreadsheet below (data courtesy of Google Finance):





Salesforce spends nearly 8 times on sales/marketing as it spends on R&D. Sounds to me a text book definition of “business model bloat”. If you are a customer of Salesforce, it makes you feel really happy that the company spends 8x on selling to you as in writing the code, right?

Let me mention some history here that I believe is relevant (note: I am not under any NDA). Several months ago, Salesforce.com invited us to participate in their AppExchange ecosystem. They knew of our Zoho CRM competition (which is why it was mutually agreed than an NDA was inappropriate), but the AppExchanage folks thought it was still good for their ecosystem. We agreed that it would be good for both of us, so we worked on making Zoho work with AppExchange, with their help & support. We invested in R&D to make the integration work, and we were about a week from launch, when Marc Benioff decided to pull the plug. He invited me for discussions. He offered repeatedly to acquire Zoho outright, which we rejected. I told him there is absolutely no fit between our companies, particularly with his business model (as noted above) and our business model. I told him there is just no cultural fit between our companies and such an acquisition would be miserable for both parties. Finally, he offered to let us integrate Zoho into AppExchange, provided we pull the plug on Zoho CRM. We told him that kind of pre-condition is totally unacceptable, and it also completely negates his claims of openness of their platform. Needless to say, we never did agree on the issue, and we dropped the integration effort.

The reason I am recounting that history is to show just how little Benioff understands the value of open ecosystems. He is still playing a 1990s software game, with expensive software (sorry, software-as-a-service!) and a business model that is sure to make Larry Ellison flinch, which is saying something.

I want to contrast that with our Google Gears integration. Google is our principal competitor, yet neither their team nor ours had any issue at all integrating - it was obvious to us this is the right thing to do for customers. The Google Gears folks bent over backwards to make sure the playing field was level, and we got access to information and support to do the integration right. That is openness.

History shows that integration efforts like the Google/Salesforce one, where the business models are so radically different, don’t prove durable. Ultimately markets will be smart enough to figure out what is obvious to many already: the Salesforce business model is an evolutionary dead-end. The proof is the silent popularity of Zoho CRM, one of the most successful Zoho services to date.

Popularity: 50% [?]

Zoho In The News

Arvind  April 13, 2008 11: 24 pm    Comments (0)

Christian Harris at ZDNet reviewed Zoho Show 2.0 recently. From his review,

Zoho Show is a straightforward to use thanks to its pre-built themes, clipart and shapes, coupled with handy features like drag-and-drop. In fact, anyone familiar with using the web should be able to put together a decent-looking presentation in just a few minutes. And, of course, you can access your presentation from any computer, so long as it’s connected to the internet.

Version 2.0 of Zoho Show has a number of enhancements — most noticeably the new user interface, which has been completely redesigned. The UI is now less cluttered and more intuitive to navigate, and the floating toolbars are a real boon. Support for themes has been improved too, and the application now has over 50 default themes to get you started.

Zoho Show 2.0 integrates much better with Zoho Meeting, an online desktop sharing tool from the same stable. The major benefit here is that you can now quickly and easily switch between applications to share your desktop with the participants viewing your presentation. And Zoho Chat allows you to chat with your audience during remote presentations.

Chris gave 7.5 out of 10 for Zoho Show 2.0. Zoho Invoice which we released a couple of weeks ago has got a very good welcome from small & medium businesses. Peter Piazza writes about the release at CIO.com in an article titled, ‘Zoho Challenges Business App Industry Heavyweights‘ :

Web 2.0 company Zoho has announced the launch of the latest product in its suite of online freeware and payware applications. Zoho Invoice gives users the ability to create everything from estimates to invoices in multiple currencies.

Zoho Invoice is integrated with PayPal, so invoices can be generated and sent to customers, who can then make payments directly through PayPal. The company plans on adding more payment gateways. The application is free for sending up to five invoices per month; four monthly subscription versions range from $5 to $35 and allow from 25 to 1,500 invoices to be sent each month.

Mozilla’s Firefox 3.0 release is being anticipated much by all. And it was our pleasure seeing the Release Notes for Firefox 3 Beta 5 mention Zoho in it!

[Improved in Beta 5!]  Speed: improvements to our JavaScript engine as well as profile guided optimizations have resulted in continued improvements in performance. Compared to Firefox 2, web applications like Google Mail and Zoho Office run twice as fast in Firefox 3 Beta 5, and the popular SunSpider test from Apple shows improvements over previous releases.

Popularity: 58% [?]

Next Page »