Project Name

Company Name

Project Lead: John Doe

Today's Date: 3/5/2007 (vertical red line)

Viewing Weeks: 1/1/07 - 11/26/07 ###

###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###

Days Remaining
Duration (Days)

Days Complete
Working Days
% Complete

10/15/07
10/22/07
10/29/07

11/12/07
11/19/07
11/26/07
1/15/07
1/22/07
1/29/07

2/12/07
2/19/07
2/26/07

3/12/07
3/19/07
3/26/07

4/16/07
4/23/07
4/30/07

5/14/07
5/21/07
5/28/07

6/18/07
6/25/07

7/16/07
7/23/07
7/30/07

8/13/07
8/20/07
8/27/07

9/10/07
9/17/07
9/24/07
10/1/07
10/8/07
6/11/07

11/5/07
1/1/07
1/8/07

2/5/07

3/5/07

4/2/07
4/9/07

5/7/07

6/4/07

7/2/07
7/9/07

8/6/07

9/3/07
WBS Tasks Start End

1 Task Category 1 1/03/07 3/20/07 76 85% 55 65 11

1.1 Sub Task 1/03/07 1/21/07 18 100% 13 18 0
1.2 Sub Task 1/22/07 2/21/07 30 95% 23 29 2
1.3 Sub Task 1/22/07 2/10/07 19 95% 15 18 1
1.4 Sub Task 2/11/07 3/20/07 37 50% 27 19 19
2 Task Category 2 3/01/07 5/13/07 73 20% 52 15 58
2.1 Sub Task 3/01/07 3/18/07 17 50% 12 9 9
2.2 Sub Task 3/01/07 3/18/07 17 30% 12 5 12
2.3 Sub Task 3/19/07 4/27/07 39 0% 30 0 39
2.4 Sub Task 4/15/07 5/13/07 28 0% 20 0 28
3 Task Category 3 4/27/07 8/08/07 103 0% 74 0 103
3.1 Sub Task 4/27/07 5/14/07 17 0% 12 0 17
3.2 Sub Task 5/15/07 6/01/07 17 0% 14 0 17
3.3 Sub Task 6/02/07 7/09/07 37 0% 26 0 37
3.4 Sub Task 7/10/07 8/08/07 29 0% 22 0 29

HELP

The number of weeks shown in the gantt chart is limited by the maximum number of columns available in Excel.
Use the slider to adjust the range of dates shown in the gantt chart.

Q: How do I make Task 2 start the day after the end of Task 1?
Use the following formula for the start date of Task 2:
=EndDate+1
where EndDate is the reference to the cell containing the end date of task 1

Q: How do I add/insert tasks and subtasks?

Copy the entire ROW (or a group of rows) for the type of task(s) you want to add and then right-click on the row where you want to insert the new tasks, then select
Insert Copied Cells.
Note: When inserting a new subtask after the last subtask or before the first subtask, you will need to update the formulas for calculating the Level 1 %Complete
and Duration (see below) to include the new subtask, because the ranges won't automatically expand to include the additional row.

Q: How do I calculate the %Complete for a Level 1 task based upon the %Complete of all of the associated subtasks?
Example: If Task 1 is on row 11 and the subtasks are on rows 12-15, use the following formula:
=SUM(F12:F15)/COUNT(F12:F15)

Q: How do I calculate the Duration for a Level 1 task based upon the largest end date of a sub task?
Example: If the Level 1 task is on row 11 and the sub tasks are on rows 12-15, use the following formula
=MAX(D12:D15)-C11

Q: How can I include holidays in the calculation of the Working Days?

You can add a list of holidays to exclude in the NETWORKDAYS function. See Excel's help (F1) for more information.

Q: How do I change the print settings?

Select the entire range of cells that you want to print and then go to File > Print Area > Set Print Area. Then go to File > Page Setup or File > Print Preview and
adjust the Scaling and Page Orientation as desired.