Copacetic

Ace King, check it out!

Ideas Park : Excel to Web Applications

with 5 comments

One of the worlds most popular RAD environments is Excel. But Excel is a pain to share and god forbid you need a third party to enter data into your carefully crafted spreadsheets. Now imagine this problem compounded n times over when an organisation attempts to collate data via a shared spreadsheet. You get to play our favourite corporate games  such as,

  • Who has the master copy?
  • Where did all my changes go?
  • I updated that last week
  • We’ve changed the format this month

So we all love Excel, but we need better ways to control data entry and sharing.

So take your Excel spreadsheet and parse all the presentation material out it in order to generate a web page.  Now use an AJAX interface to hide intermediate workbooks, behinds the scenes tables etc. etc. Now ink in the data entry fields so they become highlighted. You now have a AJAX/HTML application version of your spreadsheet.

Now you load this into a runtime framework (probably encompassing the Excel DLL ‘cos who wants to rewrite all that code) and you wrap it in a proper web login environment along with profile and preference information and you store all computation and changes in a database so every version of the spreadsheet is kept when each set of values is changed by each user.

Finally you allow the designer to upload new versions of the spreadsheet and store that in a history as well. Finally you offer a sharing capability so a user can invite other users to access and use spreadsheet, safe in the knowledge that a single master and all changes are held centrally.

Now you can offer it as a hosted service, charging each user a few cents for each spreadsheet they access or charging the owner a most substantial fee on a monthly basis for hosting their application.

How hard can that be?

Advertisements

Written by Joe

October 16, 2006 at 11:46 pm

Posted in Uncategorized

5 Responses

Subscribe to comments with RSS.

  1. Have you seen this… ?

    http://wikicalc.org/products/wikicalc/index.html

    By Dan (the man) Bricklin himself no less.

    walter

    October 17, 2006 at 12:13 am

  2. Yes, but its not Excel.

    Joe

    October 17, 2006 at 12:33 am

  3. How about Vancouver’s http://www.dabbledb.com/?

    Darren

    October 17, 2006 at 5:05 am

  4. Hi Joe

    we use jotspot for our intranet – its got some good xls sharing capabilities…

    worth a look…

    talk soon
    fergus

    Fergus Burns

    October 26, 2006 at 12:42 pm

  5. Dabble looks good, I wonder if it would parse my financial plan (a multi-worksheet behemonth). Google Spreadsheets chokes and dies for sure.

    JotSpot I looked at back in the day, but the pricing seemed a little rich for a no revenue, no VC startup.

    Joe

    October 26, 2006 at 12:54 pm


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: