Today I tried EditGrid to implement a simple Gantt Chart. EditGrid is a free and very powerful on-line application, which you can use to create and manage your spreadsheets.
I found immediatly a clear interface, simple and more similar then Google Spreadsheets to Excel and, moreover, I found a more fast and better response then Google Spreadsheets during the use and a full and more complete control for cells' formatting (border, background, number format...).
Take a look at the spreadsheetMy Gantt chart is a simple list of activities with a start date and a finish date.
Activity's Start Date is calculated like the minimum value of all Start Dates of tasks that compose it.
=min(C6:C9)
Activity's Finish Date is calculated like the maximum value of all Finish Dates of tasks that compose it.
=max(D6:D9)
Task's Duration is calculated using datediff() function:
=datedif(C7,D7,"d")
Unfortunately what it lacks is conditional fromatting to apply to cells (present in Google Spreadsheets), so you have to rapresent the Gantt Chart manually.
In general, I think EditGrid has many points to its favor respect its more famous adversary in terms of usability and funcionalities and it can be a real alternative to Excel more than Google Spreadseets.
Related Posts
I am 
Sponsored Links
Share this post
Old Comments
Thanks so much for trying EditGrid.
Conditional Formating is in our pipeline, before it is available, you may try to see if using the rept() function can do something similar to what you want. See this example:
http://woork.blogspot.com/2007/12/gantt-chart-with-editgrid-online.html
David
EditGrid Team
Sorry I screw up the links when I'm doing copy and paste, here you are:
http://www.editgrid.com/tnc/use-case/Project_Management_Template
David