Drumroll please… Excel add-in features we are proposing

Just in time for the holidays (and the AGU Fall 2011 Meeting)- a list of the overarching requirements we are working on for the Excel add-in project!  After talking with about 150 scientists about their Excel use and their data management/archiving practices, we think we have narrowed down the giant list of potential Excel improvements to a manageable list for the project.

  1. Generate metadata. Over and over, scientists said they didn’t have good data documentation. Wouldn’t it be great it Excel helped you create it? We think so.  Data centers require a certain amount of metadata for you to archive your data with them; the process would be much easier if you had a way to generate the correct metadata format and structure for the archive you designate.
  2. Generate a data citation for the data file. Data citation is the fastest way to encourage good data stewardship since it gives scientists incentives to publish and share their data.  For more information on data citation, read my post on the subject.
  3. Check the spreadsheet for export compatibility.  Most scientists don’t use Excel alone. Instead, Excel is a stepping stone for other programs- it is used to organize the data and perform basic quality control, but the data are then promptly copied and pasted or exported to another program like R, MATLAB, ArcGIS, or SAS.  The spreadsheet format needed to import your data into other programs is similar to what’s needed to submit your data to an archive. That means if you eliminate problems that would cause statistical programs to choke (see my post on problematic features in Excel), your data are one step closer to being archived quickly and easily.
  4. Link to archive services. We want you to be able to archive your data with the click of a button.  You will need to have a relationship with the archive you plan to submit to, but hopefully that’s already established.  Don’t worry- you can specify your usage restrictions and access policies depending on the archive you choose.  This requirement is where DataONE comes in- we hope to make the connection between Excel and DataONE as seamless as possible.
coast guard rescue

This add-in is going to rescue you from bad data stewardship. Original photo from Flickr by alandberning

What do you think? Ideas? Concerns? More details will come but suggestions are always welcomed. Just shoot me an email.

Tagged , , , , , ,

3 thoughts on “Drumroll please… Excel add-in features we are proposing

  1. If you need to write high performance Excel add-ins the xll library makes it very simple. It also generates natively integrated documentation.

  2. […] Strasser, of the Digital Curation for Excel Project, has posted some ideas about new features that could be added to Excel to make it more useful for scientists. In brief, […]

  3. […] I gave you a sneak peak into these requirements back in December, but over the next few blog posts I will be giving you more details about each of the specific capabilities we would like to see from Excel.  This is the first of those posts. Check ou the new Requirements page for more details about the requirements below. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: