In the past days I received some requests from my readers to deploy a simple Excel template to manage a project with a Gantt chart (in the right side of the sheet).
So I prepared this spreadsheet you can download and use in your job. The sheet contains only the following fields: WBS, Task Owner, Status, Start Date, Finish Date, Percentage of completion.
Download Excel Template
WBS structure is organized in two levels: activities and tasks. Each activity contains one or more task.
Each task has an owner and a status (I suggested:in progress, delay, completed, suspended, but you can change it like you prefer) and a percentage of completion.
Add a new task
To add a new task, copy a row with a task and paste it where you want. Remeber to update WBS number for the new task.
Add a new Activity
To add a new activity, copy a row with an activity and paste it where you want.
I hope you can find it useful. For infos or request please contact me :)
Related Post
Project Management: organize a project plan
Project Management: a project plan with Excel (template)
Gantt Chart using Google Spreadsheets and conditional formatting
Implement a Project Plan and manage activities with Google Spreadsheets
Jumat, 15 Februari 2008
