Big deal? Yes - big deal. We may say that R can do everything better than Excel, but the ubuiqity of Excel and the familiarity of everyone with the spreadsheet metaphor, means that targeting Excel brings basic cheminformatic analysis into the hands of non-cinfs like our colleagues, our bosses and our students.
So, what's this all about? Well, once a spreadsheet has been "chemistry-enabled" you can...
- click on a SMILES strings to see the structure
- click on a point in a graph and see the structure
- filter the data by substructure searching (for large datasets you can speed this up by calculating fingerprints first)
- cluster the data
- create R group tables
- calculate molecular properties
One interesting aspect is that the software has been cleverly designed for use in a corporate environment. First of all, no installation is required (i.e. admin access is not needed) and secondly, chemistry-enabled spreadsheets can be shared with users who haven't installed the chemistry add-in, so long as they have access to a shared network drive with the required files.
Just a note, to get it all working the first time, you may have to override some security settings in Excel. In Excel 2007, I had to go into the "Trust Center", and in "Macro Settings", enable "Trust access to the VBA project object model". [Update (18/05/11): Kevin says this is only necessary if creating the spreadsheet, not if using one that has already been created.]
Remember - it's an open source project, so get in there and give a hand if you have any ideas for additional features.