MBA699GanttChartTemplate.xlsx

Project Planner

[Project Planner]
Vineetha P: This Project Planner uses periods for intervals. Start = 1 is period 1 and duration = 5 means project spans 5 periods starting from the start period. Data in row 5 shows an example of how to use this table. Select a period to highlight at right. A legend describing the charting follows. Period Highlight: 1 Plan Duration Actual Start % Complete Actual (beyond plan) % Complete (beyond plan)
ACTIVITY PLAN START PLAN DURATION ACTUAL START ACTUAL DURATION PERCENT COMPLETE PERIODS
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
[Example: Form Strategic Planning Team] 1 1 1 2 75%
[Activity 01] x x x x x%
[Activity 02] x x x x x%
[Activity 03] x x x x x%
[Activity 04] x x x x x%
[Activity 05] x x x x x%
[Activity 06] x x x x x%
[Activity 07] x x x x x%
[Activity 08] x x x x x%
[Activity 09] x x x x x%
[Activity 10] x x x x x%
[Activity 11] x x x x x%
[Activity 12] x x x x x%
[Activity 13] x x x x x%
[Activity 14] x x x x x%
[Activity 15] x x x x x%
[Activity 16] x x x x x%
[Activity 17] x x x x x%
[Activity 18] x x x x x%
[Activity 19] x x x x x%
[Activity 20] x x x x x%
[Activity 21] x x x x x%
[Activity 22] x x x x x%
[Activity 23] x x x x x%
[Activity 24] x x x x x%
[Activity 25] x x x x x%
[Activity 26] x x x x x%