Skip to main content

If you have a large number of simple projects with the same or similar activities, I have found the best way to manage them is with an Excel spreadsheet.

The activities are listed along the top of the spreadsheet, with two columns per activity for start(start date and end datesdate).

The projects are listed along the left of the sheet, each with two rows, one (one for planned dates, one for actual dates).

The sheet is set up with conditional formatting so that completed tasks are green, late tasks are red and imminent tasks are yellow.

The advantage of this sheet is that the information density is far higher than a can't chart, yougantt chart's. You can see at a glance the condition of individual projects and the whole programme, and it is simple for people to read.

If you have a large number of simple projects with the same or similar activities, I have found the best way to manage them is with an Excel spreadsheet.

The activities are along the top of the spreadsheet, two columns per activity for start and end dates.

The projects are along the left of the sheet, two rows, one for planned dates, one for actual dates.

The sheet is set up with conditional formatting so that completed tasks are green, late tasks are red and imminent tasks are yellow.

The advantage of this sheet is that the information density is far higher than a can't chart, you can see at a glance the condition of individual projects and the whole programme, and it is simple for people to read.

If you have a large number of simple projects with the same or similar activities, I have found the best way to manage them is with an Excel spreadsheet.

The activities are listed along the top of the spreadsheet, with two columns per activity (start date and end date).

The projects are listed along the left of the sheet, each with two rows (one for planned dates, one for actual dates).

The sheet is set up with conditional formatting so that completed tasks are green, late tasks are red and imminent tasks are yellow.

The advantage of this sheet is that the information density is far higher than a gantt chart's. You can see at a glance the condition of individual projects and the whole programme, and it is simple for people to read.

Source Link
Imp
  • 21
  • 2

If you have a large number of simple projects with the same or similar activities, I have found the best way to manage them is with an Excel spreadsheet.

The activities are along the top of the spreadsheet, two columns per activity for start and end dates.

The projects are along the left of the sheet, two rows, one for planned dates, one for actual dates.

The sheet is set up with conditional formatting so that completed tasks are green, late tasks are red and imminent tasks are yellow.

The advantage of this sheet is that the information density is far higher than a can't chart, you can see at a glance the condition of individual projects and the whole programme, and it is simple for people to read.