This LOP tool embedges a NEW function to synchronize the items from the LOP with the tasks in Outlook

This brings three benefits :

1. All actions assigned to one people are set at one place >> in his Outlook session

2. The assignees know easiliy what they have to do and for when , looking at their tasks in Outlook that are highlighted as well in the calendar.

3.It gives more visibilities on workload when multiple tasks start to be stacked at the same due date

This sheet allows to resume in one table the different milestones of your project , detailed at each level : System, Sub-assembly and components

Well known and identified milestones to all actors of a project contributes to its success, achieving cost , timing and quality.

In this sheet , you can add new columns (=new milestones) and/or rows (= new components or sub systems )

Only the cell "Scope" with red borders is protected against deletion so shall and can not be modified - This cell indexes origin of the table for the macro.

This sheet allows to set the main deliverables expected at each milestones of the project.

In this sheet you can add rows to add deliverables, kust make sure each deliverable stay in front of a merged cell corresponding to the component or sub-sytem

and make sure columns milestones are identical to the column milestones from the sheet "Milestones".

This constraint is mandatory to make the macro "add new deliverables in LOP" works properly

On top of the sheet "Deliverables" click on <<Add new deliverables in LOP>> to create all deliverables with corresponding due date in the LOP :

Status of the items set in the LOP is reported in the deliverables table keeping same coloring set-up :

Grey for items not started, yellow for items on going ,Orange for items due this week , red for items in late and green for completed items

As an additional remark, a double click on one deliverable in the deliverable table will bring you to the corresponding line item in the LOP sheet.