ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBK
1
[Project Name]Start Date:January 21, 2015
2
[Your Name]
3
TaskStart DateEnd DateDuration
(days)		Percent CompleteJan Feb Mar
4
Date:1/211/221/231/241/251/261/271/281/291/301/312/12/22/32/42/52/62/72/82/92/102/112/122/132/142/152/162/172/182/192/202/212/222/232/242/252/262/272/283/13/23/33/43/53/63/73/83/93/103/113/123/133/143/153/163/173/183/19
5
1: Task 12015-01-212015-01-2110.00%X
6
1.1: Subtask 12015-01-212015-01-2110.00%X
7
1.2: Subtask 22015-01-212015-01-2110.00%X
8
1.3: Subtask 32015-01-212015-01-2110.00%X
9
1.4: Subtask 42015-01-212015-01-2110.00%X
10
1.5: Subtask 52015-01-212015-01-2110.00%X
11
2: Task 22015-01-212015-01-2110.00%X
12
2.1: Subtask 12015-01-212015-01-2110.00%X
13
2.2: Subtask 22015-01-212015-01-2110.00%X
14
2.3: Subtask 32015-01-212015-01-2110.00%X
15
2.4: Subtask 42015-01-212015-01-2110.00%X
16
2.5: Subtask 52015-01-212015-01-2110.00%X
17
3: Task 32015-01-212015-01-2110.00%X
18
3.1: Subtask 12015-01-212015-01-2110.00%X
19
3.2: Subtask 22015-01-212015-01-2110.00%X
20
3.3: Subtask 32015-01-212015-01-2110.00%X
21
3.4: Subtask 42015-01-212015-01-2110.00%X
22
3.5: Subtask 52015-01-212015-01-2110.00%X
23
4: Redesign/Refine2015-03-092015-03-18100.00%XXXXXXXXXX
24
4.1: Redesign/Refine - Round 12015-03-092015-03-1130.00%XXX
25
4.2: Redesign/Refine - Round 22015-03-112015-03-1330.00%XXX
26
4.3: Redesign/Refine - Round 32015-03-162015-03-1830.00%XXX
27
28
29
30
31
Template Rows:
32
Highlight a row by clicking on row number at left, right-click and Copy, then highlight empty row, right-click and paste (formulas should stay intact). Insert a row above or below where you intend to paste before pasting.
33
1.0 Task Heading2011-01-202011-01-2010.00%
34
1.1 Subtask 12011-01-202011-01-2010.00%
35
1.2 Subtask 22011-01-202011-01-2010.00%
36
37
38
Help:Credits
39
- Go to File => Make a copy... to copy this file to your own Google Docs folder for editing.

- Modify only the GREEN cells and the Task and Subtask text. The other cells contain formulas which will fill in the other data and colorize the Gantt chart.

- In the TASK column, precede the task name with the WBS number (technical note: Google Spreadsheet only allows 5 columns to be frozen, so I included the WBS number in with the Task name for simplicity's sake).

- Double-clicking a field in the Start Date and End Date columns should expose a pop-out calendar for date selection (though it seems to be buggy from time to time).

- In the graph, incomplete percentages are shown in dark gray (main tasks are almost black), while completed percentages are show in color (yellow for main tasks and blue for subtasks.)

- Percentages on the charts are rounded down. If you have 50% completed on an item that is 5 days duration, 50% of 5 days is 2.5 days; the chart will round this down to 2 days so only 2 out of 5 cells will be shown as "done".

- The TASK headings rows contain formulas that calculate based on the range of Subtasks under that heading. If something is fishy with the Task heading calculations or the way the chart is displayed, ensure that the Task heading formulas include the proper range of subtask cells.

- This spreadsheet does NOT export well into other applications, though the PDF should be usuable.

- The date range changes automatically once the Start Date value is changed