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
No comments:
Post a Comment